Hi All!
I've sent to Olivier an XHTML1.0 validated version of this script
a few hours ago. With a bit of luck it will be on the CVS soon.
Dan, I can't reach your server!
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi Marc!
>what do I put there if I have more than one host?
??? You're using the same phpMyAdmin script on more than one
server ???
This setting is the uri to the phpMyAdmin script itself, not to the sql
host.
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi All!
Well the current left.php3 script is not really optimized: it always use
mysql_list_dbs (even if $cfgServers[n]['only_db'] is set in order to
ensure these db trully exists) and this query may requires a huge
amount of memory if you're an ISP for example.
I've actaully done some tests with the ISP I suscribed to... and this
query make fails left.php3 indeed.
So I've rewritten a bit this script but I would like some of you to test
it before I submit this new version.
Lines 21 to 52 have been replaced by:
--- new code starts here ---
if ($server > 0) {
$num_dbs = count($dblist);
// 1. $cfgServers[n]['only_db'] exists -> gets the valid databases list
if ($num_dbs) {
$true_dblist = array();
for ($i = 0; $i < $num_dbs; $i++) {
$dblink = @mysql_select_db($dblist[$i]);
if ($dblink) {
$true_dblist[] = $dblist[$i];
} // end if
} // end for
unset($dblist);
$dblist = $true_dblist;
unset($true_dblist);
$num_dbs = count($dblist);
} // end if
// 2. no $cfgServers[n]['only_db']
else {
$dbs = mysql_list_dbs() or mysql_die();
$num_dbs = @mysql_num_rows($dbs);
for ($i = 0; $i < $num_dbs; $i++) {
$dblist[] = mysql_dbname($dbs, $i);
} // end for
} // end else
} else {
$num_dbs = 0;
}
--- end of new code ---
Greetz,
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi Lance!
>Just adding another string "Drop table" and using it there would achieve
>the required result without affecting the other code at all ??
You must be an english/american user else you would know what is the
cost of each added string ;)
OK I've added $strDropTable.
Cheers,
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hi Lance!
>Call to undefined function: is_defined() in sql.php3 on line 15
My fault :o I've fixed it.
>BTW descending is missing its 'c' in the select query frame .
Also fixed. Thanks.
>At the bottom of the database frame shouldnt it say :-
>'Drop table xxxx' rather than just 'Drop xxxx' which may be
>confusing if you have both a database and a table of the same
>name ??
Well the same string is used here and in the first html table
generated by db_details.php3. Having more characters in this
string would lead to a non-friendly design in the second case.
But what do you think of:
'Drop db_name.table_name'
?
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
Hello,
Sorry sorry, I know we're supposed to be in "code freeze"
period, but I really needed this feature :) And it can't break
anything anyway, because it's a new script, hacked in a few
minutes tonight. (not sure if the html output is 100% correct:
not checked yet)
Link ("Databases Statistics") is displayed on main.php3 only
if the user may also access mysql.user (root). I hope you will
also find it useful!
Greetings,
Olivier
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
I have a problem when editing the result of a select query, when you post
the edit the db gets updated but phpmyadmin then comes back with an sql
error trying to redisplay the results - every time ...
Thought I'd post it here as I know you are close to release ...
Also a suggestion - in the right hand frame when you click on the db in
the lh frame, could not the table properties be collapsed under a link
that said 'properties' so you can expand it if you want, but all the other
options would be visible on the screen. There are a lot more options in
the new version ....
Also - any chance of the 'drop database' option being configurable to not
be available ... we run an isp and offer phpmyadmin - its a real pain when
users drop their databases without going through our interface ...
Regards
Lance
At the bottom of the database frame shouldnt it say :-
'Drop table xxxx' rather than just 'Drop xxxx' which may be confusing if
you have both a database and a table of the same name ??
Lance
Done in the CVS: MYSQL_MAJOR_VERSION and MYSQL_MINOR_VERSION constants have
been replaced
by MYSQL_INT_VERSION.
Jocelyn, please test it.
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif