22 Aug
2001
22 Aug
'01
1:21 p.m.
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