up.php

来自「make project on java」· PHP 代码 · 共 30 行

<?php 
include'include/begin.php';
$version = explode('.', mysql_get_server_info());
define('SQLVER', $version[0] . '.' . $version[1]);
$_sqllist = SQLVER < '4.1'?'TYPE=MyISAM':'ENGINE=MyISAM DEFAULT CHARSET=utf8';

 mysql_query("update {$db_prefix}config set value='1.0 RC1' where id='21'", $myconn);
 mysql_query("ALTER TABLE `{$db_prefix}members` DROP `webcount`", $myconn); 
 @mysql_query("ALTER TABLE `{$db_prefix}members` ADD `webid` TINYINT( 3 ) UNSIGNED NOT NULL AFTER `emote`", $myconn);
 @mysql_query("ALTER TABLE `{$db_prefix}members` CHANGE `newpm` `newpm` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'", $myconn);

$sql="DROP TABLE `".$db_prefix."online`";
mysql_query($sql, $myconn);

$sql="CREATE TABLE IF NOT EXISTS `".$db_prefix."online` (
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `userip` varchar(15) NOT NULL default '',  
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) $_sqllist;
";
mysql_query($sql, $myconn);
$sql="CREATE TABLE IF NOT EXISTS `".$db_prefix."online2` (
  `ip` varchar(7) NOT NULL,
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ip`)
) $_sqllist;
";
mysql_query($sql, $myconn);
echo '鏁版嵁搴撳崌绾ф垚鍔