📄 install.php
字号:
<?PHP
error_reporting(E_ERROR | E_WARNING | E_PARSE);
@set_magic_quotes_runtime (0);
include ('db.php');
$mqgpc_status=get_magic_quotes_gpc();
if ($mqgpc_status==0) $_POST=addsd($_POST);
@extract($_POST, EXTR_SKIP);
@extract($_GET, EXTR_SKIP);
if (isset($password)) $password=md5($password);
$ts=time();
$ip=$_SERVER['REMOTE_ADDR'];
if (!$v) {
template("<div class='log'>Select Language</div><form action='install.php?v=setlang' method='post'><div class='mes'><div align='center'><select style=\"width: 50%;\" name='slang'><option value='zh-cn'>Simplified Chinese</option><option value='zh-tw'>Traditional Chinese</option></select></div><br/><div align='center'><input type='submit' value='OK' class='inbut'></div></form></div>");
}
if ($v=='setlang') {
setcookie('setuplang', $slang, time()+3600);
template("<div class='log'>Ready</div><form action='install.php?v=start' method='post'><div class='mes'><div align='center'>Installation is ready. Please click the button below to continue.</div><br/><div align='center'><input type='submit' value='Continue' class='inbut'></div></form></div>");
}
$language=$_COOKIE['setuplang'];
if (!$language) $language='zh-cn';
include("lang_{$language}.php");
if ($v=='start') {
//Checking PHP version
if (PHP_VERSION<"4.1.0") {
template("<div class='log'>{$lang[1]}</div><div class='mes'>{$lang[2]}</div>");
}
//Is <dir>data editable?
writetofile('../data/test.php', '');
if (!file_exists('../data/test.php')) {
template("<div class='log'>{$lang[1]}</div><div class='mes'>{$lang[70]}</div>");
} else {
@unlink('../data/test.php');
}
$copytxt=readfromfile("licence.txt");
template("<div class='log'>{$lang[3]}</div><div class='mes'><div align='center'><textarea style=\"width: 90%; height: 200px;\">{$copytxt}</textarea></div><br/><div align='center'><input type='button' value='{$lang[4]}' onclick='window.location=\"install.php?v=1\";' class='inbut'> <input type='button' value='{$lang[5]}' onclick='window.location=\"install.php?v=cancel\";' class='inbut'></div></div>");
}
if ($v=='cancel') {
template("<div class='log'>{$lang[6]}</div><div class='mes'>{$lang[7]}</div>");
}
if ($v=='1') {
template("<div class='log'>{$lang[8]}</div><div class='mes'><form action='install.php?v=2' method='post'>{$lang[9]}<br><input type='text' size='20' value='localhost' name='db_server'><br><br>{$lang[10]}<br><input type='text' size='20' value='' name='db_username'><br><br>{$lang[11]}<br><input type='password' size='20' value='' name='db_password'><br><br>{$lang[12]}<br><input type='text' size='20' value='' name='db_name'><br> {$lang[13]}<br><br>{$lang[14]}<br><input type='text' size='20' value='boblog_' name='db_prefix'><br> {$lang[15]}<br><br>{$lang[65]}<br><input type='radio' value='1' name='db_overwrite' onclick=\"alert('{$lang[68]}');\">{$lang[66]} <input type='radio' value='0' name='db_overwrite' checked>{$lang[67]}<br><br>{$lang[16]} <a href='javascript:showlayer(\"what1\");'>[{$lang[17]}]</a><br><input type='radio' value='0' name='db_410'>{$lang[18]} <input type='radio' value='1' name='db_410'>{$lang[19]} <div id='what1' style='display: none;'><br>{$lang[20]}</div><div align='center'><br><input type='submit' value='{$lang[21]}' class='inbut'> <input type='reset' value='{$lang[22]}' class='inbut'></div></form></div>");
}
if ($v=='2') {
$pp=db_connect($db_server, $db_username, $db_password, $db_name);
if (!$pp) {
template("<div class='log'>{$lang[1]}</div><div class='mes'>{$lang[23]}<br><br>{$errmsg}</div>");
}
$mysqlver=@mysql_get_server_info();
if ($mysqlver<'4') {
template("<div class='log'>{$lang[1]}</div><div class='mes'>{$lang[24]}</div>");
}
template("<div class='log'>{$lang[25]}</div><div class='mes'><form action='install.php?v=3' method='post' id='frm1'>{$lang[26]}<br><input type='text' size='20' value='' name='username'><br><br>{$lang[27]}<br><input type='password' size='20' value='' name='password'><br><br>{$lang[28]}<br><input type='text' size='40' name='blogname' value='Bo-Blog'><br><br>{$lang[29]}<br><input type='text' size='40' name='blogdesc' value=''><input type='hidden' name='db_server' value='{$db_server}'><input type='hidden' name='db_username' value='{$db_username}'><input type='hidden' name='db_password' value='{$db_password}'><input type='hidden' name='db_name' value='{$db_name}'><input type='hidden' value='{$db_410}' name='db_410'><input type='hidden' name='db_prefix' value='{$db_prefix}'><input type='hidden' name='db_overwrite' value='{$db_overwrite}'><br><br><div align='center'><input type='button' id='btn1' value='{$lang[21]}' onclick='submitit();' class='inbut'> <input type='reset' value='{$lang[22]}' class='inbut'></div></form></div>");
}
if ($v=='3') {
//Connect and Select Database
$pp=db_connect($db_server, $db_username, $db_password, $db_name);
if (!$pp) {
template("<div class='log'>{$lang[1]}</div><div class='mes'>{$lang[23]}<br><br>{$errmsg}</div>");
}
$mysqlver=@mysql_get_server_info();
if ($mysqlver<'4') {
template("<div class='log'>{$lang[1]}</div><div class='mes'>{$lang[24]}</div>");
}
//If the server is running MySQL with a version higher than 4.1, set the character as UTF-8
if ($db_410==1) {
db_query("SET NAMES 'utf8'");
$sqlcharset=" CHARSET=utf8";
}
if ($db_overwrite==1) {
db_query("DROP TABLE IF EXISTS `{$db_prefix}blogs`, `{$db_prefix}calendar`, `{$db_prefix}categories`, `{$db_prefix}counter`, `{$db_prefix}forbidden`, `{$db_prefix}history`, `{$db_prefix}linkgroup`, `{$db_prefix}links`, `{$db_prefix}maxrec`, `{$db_prefix}messages`, `{$db_prefix}replies`, `{$db_prefix}user`, `{$db_prefix}mods`, `{$db_prefix}tags`, `{$db_prefix}plugins`");
}
//Creating Tables
$setup_query="
CREATE TABLE `{$db_prefix}blogs` (
`blogid` int(10) NOT NULL default '0',
`title` text NULL,
`pubtime` int(11) NOT NULL default '0',
`authorid` int(8) NOT NULL default '0',
`replies` int(8) NOT NULL default '0',
`tbs` int(8) NOT NULL default '0',
`views` int(8) NOT NULL default '0',
`property` int(1) NOT NULL default '0',
`category` int(3) NOT NULL default '0',
`tags` text NULL,
`sticky` int(1) NOT NULL default '0',
`htmlstat` int(1) NOT NULL default '0',
`ubbstat` int(1) NOT NULL default '1',
`emotstat` int(1) NOT NULL default '1',
`content` MEDIUMTEXT NULL,
`editorid` int(8) NOT NULL default '0',
`edittime` int(11) NOT NULL default '0',
`weather` TINYTEXT NULL,
`mobile` int(1) NOT NULL default '0',
`pinged` text NULL,
`permitgp` text NULL,
`starred` INT( 5 ) NOT NULL DEFAULT '0',
`empty2` text NULL,
`empty3` text NULL,
`empty4` text NULL,
`empty5` text NULL,
`empty6` text NULL,
`empty7` text NULL,
`empty8` text NULL,
`empty9` text NULL,
`empty10` text NULL,
KEY `blogid` (`blogid`),
KEY `pubtime` (`pubtime`),
KEY `views` (`views`),
KEY `sticky` (`sticky`)
) TYPE=MyISAM{$sqlcharset}";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="INSERT INTO `{$db_prefix}blogs` VALUES ('0', '{$lang[30]}', '{$ts}', '1', '0', '0', '0', '0', '0', '', '0', '0', '1', '1', '{$lang[31]}', '0', '0', 'sunny', '0', '', '', '0', '', '', '', '', '', '', '', '', '')";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="
CREATE TABLE `{$db_prefix}calendar` (
`cyearmonth` TINYTEXT NULL ,
`cday` INT( 2 ) DEFAULT '1' NOT NULL ,
`cid` INT( 8 ) DEFAULT '0' NOT NULL ,
`cevent` TEXT NULL
) TYPE = MYISAM{$sqlcharset}";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="
CREATE TABLE `{$db_prefix}categories` (
`cateid` int(3) NOT NULL default '0',
`catename` text NULL,
`catedesc` text NULL,
`cateproperty` int(1) NOT NULL default '0',
`cateorder` int(20) NOT NULL default '0',
`catemode` int(1) NOT NULL default '0',
`cateicon` tinytext NULL,
`cateurl` text NULL,
`empty1` text NULL,
`empty2` text NULL,
`empty3` text NULL,
KEY `cateorder` (`cateorder`)
) TYPE=MyISAM{$sqlcharset}";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="INSERT INTO `{$db_prefix}categories` VALUES (0, '{$lang[32]}', '{$lang[33]}', 0, 0, 0, '', '', '', '', '')";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="
CREATE TABLE `{$db_prefix}counter` (
`total` int(20) NOT NULL default '0',
`max` int(20) NOT NULL default '0',
`today` int(20) NOT NULL default '0',
`entries` int(20) NOT NULL default '0',
`replies` int(20) NOT NULL default '0',
`tb` int(20) NOT NULL default '0',
`messages` int(20) NOT NULL default '0',
`users` int(20) NOT NULL default '0',
`empty1` int(20) NOT NULL default '0',
`empty2` int(20) NOT NULL default '0',
`empty3` int(20) NOT NULL default '0'
) TYPE=MyISAM{$sqlcharset}";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="INSERT INTO `{$db_prefix}counter` VALUES (0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0)";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="
CREATE TABLE `{$db_prefix}forbidden` (
`banword` text NULL,
`nosearch` text NULL,
`keep` text NULL,
`suspect` text NULL,
`banip` text NULL,
`empty1` text NULL,
`empty2` text NULL,
`empty3` text NULL
) TYPE=MyISAM{$sqlcharset}";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="INSERT INTO `{$db_prefix}forbidden` VALUES ('', '', '', '', '', '', '', '')";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="
CREATE TABLE `{$db_prefix}history` (
`hisday` int(8) NOT NULL default '0',
`visit` int(8) NOT NULL default '0'
) TYPE=MyISAM{$sqlcharset}";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="
CREATE TABLE `{$db_prefix}linkgroup` (
`linkgpid` int(3) NOT NULL default '0',
`linkgpname` text NULL,
`linkgppt` int(1) NOT NULL default '1',
`linkgporder` int(3) NOT NULL default '0',
`empty1` text NULL,
`empty2` text NULL,
KEY `linkgporder` (`linkgporder`)
) TYPE=MyISAM{$sqlcharset}";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="INSERT INTO `{$db_prefix}linkgroup` VALUES (0, '{$lang[34]}', 1, 0, '', '')";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="
CREATE TABLE `{$db_prefix}links` (
`linkid` int(4) NOT NULL default '0',
`linkname` text NULL,
`linkurl` text NULL,
`linklogo` text NULL,
`linkdesc` text NULL,
`linkgptoid` int(3) NOT NULL default '0',
`linkorder` int(4) NOT NULL default '0',
`isdisplay` int(1) NOT NULL default '1',
`empty1` text NULL,
`empty2` text NULL,
KEY `linkorder` (`linkorder`)
) TYPE=MyISAM{$sqlcharset}";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="INSERT INTO `{$db_prefix}links` VALUES (0, 'Bo-Blog', 'http://www.bo-blog.com', '', 'Bo-Blog Official Site', 0, 0, 1, '', ''), (1, 'BMForum', 'http://www.bmforum.com', '', 'BMForum - {$lang[71]}', 0, 0, 1, '', '')";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="
CREATE TABLE `{$db_prefix}maxrec` (
`maxblogid` int(8) NOT NULL default '0',
`maxuserid` int(8) NOT NULL default '0',
`maxcateid` int(8) NOT NULL default '0',
`maxgpid` int(8) NOT NULL default '0',
`maxrepid` int(8) NOT NULL default '0',
`maxmessagepid` int(8) NOT NULL default '0',
`maxtagid` int(8) NOT NULL default '0',
`maxlinkgpid` int(8) NOT NULL default '0',
`maxlinkid` int(8) NOT NULL default '0',
`empty1` int(8) NOT NULL default '0',
`empty2` int(8) NOT NULL default '0',
`empty3` int(8) NOT NULL default '0'
) TYPE=MyISAM{$sqlcharset}";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="INSERT INTO `{$db_prefix}maxrec` VALUES (0, 1, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0)";
$result=db_query($setup_query);
if (!$result) template("<div class='log'>{$lang[1]}</div><div class='mes'>{$errmsg}</div>");
$setup_query="
CREATE TABLE `{$db_prefix}messages` (
`repid` int(10) NOT NULL default '0',
`reproperty` int(1) NOT NULL default '0',
`reptime` int(11) NOT NULL default '0',
`replierid` int(8) NOT NULL default '0',
`replier` text NULL,
`repemail` text NULL,
`repurl` text NULL,
`repip` text NULL,
`repcontent` text NULL,
`html` int(1) NOT NULL default '0',
`ubb` int(1) NOT NULL default '1',
`emot` int(1) NOT NULL default '1',
`adminrepid` int(8) NOT NULL default '0',
`adminreplier` text NULL,
`adminreptime` int(11) NOT NULL default '0',
`adminrepcontent` text NULL,
`adminrepeditorid` int(8) NOT NULL default '0',
`adminrepeditor` text NULL,
`adminrepedittime` int(11) NOT NULL default '0',
`empty1` text NULL,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -