石头的日志

<?php
require_once $_SERVER['DOCUMENT_ROOT'].'/config.ini.php';
require_once $INC.'/Smarty.Conf.php';//Smarty
require_once $CLASS.'/Mysql.class.php';//Adodb
$Mysql  = new Mysql;
$uni_show_width=30;
 $db = $Mysql->connect('ganji');
 //print_r($db->MetaDatabases());
 foreach($db->MetaDatabases() as $i=>$database)
 {
   if($database)
   {
    $dbb = $Mysql->connect($database);
    $sql = "SHOW TABLE STATUS from $database;";
    $res =$dbb->query($sql);
    print "Database -> $database: <br><br>";
    if($res)
    foreach($res as $line)
    {
       if(stristr($line['Name'],"_list")){
       print "tableName :{$line[Name]} is list <br>";
     $sql2 = "ALTER TABLE `$line[Name]` ADD `userid` VARCHAR( 100 ) NOT NULL;";
     $res2 = $dbb->query($sql2);
     }
       else{
       print "<font color=\"#FF0000\"> tableName :{$line[Name]}  </font><br>";}
    }
   }
}
?>