⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 install.php

📁 php编写的关于同学录系统如泰国人一天给予
💻 PHP
📖 第 1 页 / 共 2 页
字号:
<?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 + -