".$msg[sql_info_notices]."

".pmb_sql_value("select count(*) as nb from notices")."

" ; echo "

".$msg[sql_info_exemplaires]."

".pmb_sql_value("select count(*) as nb from exemplaires")."

" ; echo "

".$msg[sql_info_bulletins]."

".pmb_sql_value("select count(*) as nb from bulletins")."

" ; echo "

".$msg[sql_info_authors]."

".pmb_sql_value("select count(*) as nb from authors")."

" ; echo "

".$msg[sql_info_publishers]."

".pmb_sql_value("select count(*) as nb from publishers")."

" ; echo "

".$msg[sql_info_empr]."

".pmb_sql_value("select count(*) as nb from empr")."

" ; echo "

".$msg[sql_info_pret]."

".pmb_sql_value("select count(*) as nb from pret")."

" ; echo "

".$msg[sql_info_pret_archive]."

".pmb_sql_value("select count(*) as nb from pret_archive")."

" ; echo "

MySQL Database name, host and user

".DATA_BASE." on ".SQL_SERVER.", user=".USER_NAME."

MySQL Server Information

".mysql_get_server_info()."

" ; echo "

MySQL Client Information

".mysql_get_client_info()."

" ; echo "

MySQL Host Information

".mysql_get_host_info()."

" ; echo "

MySQL Protocol Information

".mysql_get_proto_info()."

" ; echo "

MySQL Stat. Information

".str_replace(' ','
',mysql_stat())."

"; echo "

MySQL Variables

" ; $result = mysql_query('SHOW VARIABLES', $dbh); $parity=0 ; while ($row = mysql_fetch_assoc($result)) { if ($parity % 2) $pair_impair = "even"; else $pair_impair = "odd"; $parity+=1; echo ""; } echo "

".$row['Variable_name']."

".$row['Value']."

" ; break; case '': default: print "

$msg[719]

$msg[720]

$msg[721]

$msg[722]

$msg[admin_info_mysql]

$msg[admin_info_php]

$msg[admin_info_table_index]

"; break; } if($action) { @set_time_limit($pmb_set_time_limit); $db = DATA_BASE; $tables = mysql_list_tables($db); $num_tables = @mysql_num_rows($tables); $i = 0; while($i < $num_tables) { $table[$i] = mysql_tablename($tables, $i); $i++; } echo ""; while(list($cle, $valeur) = each($table)) { $requete = $action." TABLE ".$valeur." "; $res = @mysql_query($requete, $dbh); $nbr_lignes = @mysql_num_rows($res); $nbr_champs = @mysql_num_fields($res); if($nbr_lignes) { if(!$cle) { for($i=0; $i < $nbr_champs; $i++) { printf("", mysql_field_name($res, $i)); } } for($i=0; $i < $nbr_lignes; $i++) { $row = mysql_fetch_row($res); echo ""; foreach($row as $dummykey=>$col) { if(!$col) $col=" "; print ""; } echo ""; } } } echo "

%s
$col

"; }