set_time_limit(15);
$dbs = db_qa("show databases");
foreach($dbs as $db){
$db = $db['Database'];
if(!db_qrs("show tables like 'admintnxlogs'", 0, $db)) continue;
$echo = "
".$db."
";
$tot = db_qrs("select count(*) from admintnxlogs", 0, $db);
if(!$tot) continue;
$last = db_qrs("select max(start) from admintnxlogs", 0, $db);
$first = db_qrs("select min(start) from admintnxlogs", 0, $db);
$giorni = max((time()-strtotime($first))/86400, 1);
$per_day = $tot/$giorni;
$echo .= "EDITs:\t\t$tot
";
$echo .= "ULTIMO EDIT:\t\t".$last."
";
$echo .= "EDIT/GIORNO:\t\t".$per_day."
";
$echo .= "PERIODO (giorni):\t\t".$giorni."
";
$k = ceil($per_day*1000) ? ceil($per_day*1000) : 0;
while($return_most_used[$k]) $k++;//evito di perdere un altro utente
$return_most_used[$k] = $echo;
$k = $tot ? $tot : 0;
while($return_most[$k]) $k++;//evito di perdere un altro utente
$return_most[$k] = $echo;
$k = strtotime($last) ? strtotime($last) : 0;
while($return_recent[$k]) $k++;//evito di perdere un altro utente
$return_recent[$k] = $echo;
}
ksort($return_recent);
$return_recent = array_reverse($return_recent);
ksort($return_most);
$return_most = array_reverse($return_most);
ksort($return_most_used);
$return_most_used = array_reverse($return_most_used);
?>
Maggior uso giornaliero:
|
Numero di record:
|
Più recenti:
|