📄 install.php
字号:
<?php
include("../includes/fun_post.php");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>星雨留言版</title>
<link href="../includes/main.css" rel="stylesheet" type="text/css">
</head>
<body>
<?
include("fun_data.php");
function writeVar($filename, $host, $db, $user, $password, $prefix, $url, $rootmail)
{
$buf = "<?php\n\$g_db_host = \"$host\";\n\$g_db_user = \"$user\";\n\$g_db_password = \"$password\";\n\$g_db_name = \"$db\";\n\$g_db_prefix = \"$prefix\";\n\$g_url = \"$url\";\n\$g_mail = \"$rootmail\";\n?>";
$fp = fopen($filename, "wb");
fwrite($fp, $buf);
}
function initDB($host, $db, $user, $password, $prefix, $aname, $apassword)
{
DB($host, $db, $user, $password);
$db = new DBReader;
$sql = "CREATE TABLE `".$prefix."user` (`u_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,`u_name` VARCHAR( 16 ) NOT NULL ,`u_password` VARCHAR( 32 ) NOT NULL ,`u_homepage` VARCHAR( 255 ) NOT NULL ,`u_mail` VARCHAR( 64 ) NOT NULL ,`u_title` VARCHAR( 64 ) NOT NULL ,`h_ID` INT UNSIGNED NOT NULL ,`s_ID` INT UNSIGNED NOT NULL ,`u_pagesize` INT UNSIGNED NOT NULL ,`u_IP` VARCHAR( 1 ) DEFAULT 'S' NOT NULL );";
$db->execute($sql);
$sql = "CREATE TABLE `".$prefix."words` (`w_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,`u_ID` INT UNSIGNED NOT NULL ,`w_title` VARCHAR( 64 ) NOT NULL ,`w_content` TEXT NOT NULL ,`w_IP` VARCHAR( 15 ) NOT NULL ,`w_mail` VARCHAR( 64 ) ,`w_QQ` VARCHAR( 32 ) ,`w_web` VARCHAR( 255 ) ,`w_head` TINYINT UNSIGNED NOT NULL ,`w_date` DATETIME NOT NULL , `w_name` VARCHAR( 32 ) NOT NULL , `w_re` TEXT);";
$db->execute($sql);
$sql = "CREATE TABLE `".$prefix."admin` (`a_ID` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,`a_name` VARCHAR( 32 ) NOT NULL ,`a_password` VARCHAR( 32 ) NOT NULL );";
$db->execute($sql);
$sql = "CREATE TABLE `".$prefix."style` (`s_ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,`s_name` VARCHAR( 32 ) NOT NULL ,`s_path` VARCHAR( 255 ) NOT NULL );";
$db->execute($sql);
$sql = "CREATE TABLE `".$prefix."head` (`h_ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,`h_name` VARCHAR( 32 ) NOT NULL ,`h_path` VARCHAR( 255 ) NOT NULL ,`h_count` TINYINT NOT NULL );";
$db->execute($sql);
$sql = "INSERT INTO `".$prefix."admin` ( `a_ID` , `a_name` , `a_password` ) VALUES ('', '".$aname."', MD5( '".$apassword."' ) );";
$db->execute($sql);
$sql = "INSERT INTO `msg_head` ( `h_ID` , `h_name` , `h_path` , `h_count` ) VALUES ('', '最终幻想', 'head/ff/', '28');";
$db->execute($sql);
$sql = "INSERT INTO `msg_head` ( `h_ID` , `h_name` , `h_path` , `h_count` ) VALUES ('', '精美手绘', 'head/draw/', '23');";
$db->execute($sql);
$sql = "INSERT INTO `msg_head` ( `h_ID` , `h_name` , `h_path` , `h_count` ) VALUES ('', '橙色笑脸', 'head/face/', '40');";
$db->execute($sql);
$sql = "INSERT INTO `msg_head` ( `h_ID` , `h_name` , `h_path` , `h_count` ) VALUES ('', '拳皇大全', 'head/kof/', '22');";
$db->execute($sql);
$sql = "INSERT INTO `msg_head` ( `h_ID` , `h_name` , `h_path` , `h_count` ) VALUES ('', '中国娃娃', 'head/wawa/', '24');";
$db->execute($sql);
$sql = "INSERT INTO `msg_style` ( `s_ID` , `s_name` , `s_path` ) VALUES ('', '黑色', 'style/black/');";
$db->execute($sql);
$sql = "INSERT INTO `msg_style` ( `s_ID` , `s_name` , `s_path` ) VALUES ('', '白色', 'style/white/');";
$db->execute($sql);
$sql = "INSERT INTO `msg_style` ( `s_ID` , `s_name` , `s_path` ) VALUES ('', '枣红', 'style/red/');";
$db->execute($sql);
$sql = "INSERT INTO `msg_style` ( `s_ID` , `s_name` , `s_path` ) VALUES ('', '紫色', 'style/violet/');";
$db->execute($sql);
$sql = "INSERT INTO `msg_style` ( `s_ID` , `s_name` , `s_path` ) VALUES ('', '绿色', 'style/green/');";
$db->execute($sql);
$sql = "INSERT INTO `msg_style` ( `s_ID` , `s_name` , `s_path` ) VALUES ('', '圣诞节', 'style/Xmas/');";
$db->execute($sql);
}
if(!(empty($_POST["host"])&&empty($_POST["db"])&&empty($_POST["user"])&&empty($_POST["prefix"])&&empty($_POST["adminname"])&&empty($_POST["adminpassword"])&&empty($_POST["mail"])&&empty($_POST["url"])))
{
$host = $_POST["host"];
$db = $_POST["db"];
$user = $_POST["user"];
$password = $_POST["password"];
$prefix = $_POST["prefix"];
$aname = $_POST["adminname"];
$apassword = $_POST["adminpassword"];
$url = $_POST["url"];
$rootmail = $_POST["mail"];
writeVar("inc_var.php", $host, $db, $user, $password, $prefix, $url, $rootmail);
initDB($host, $db, $user, $password, $prefix, $aname, $apassword);
?>
<table width="70%" border="0" align="center">
<tr>
<th>安装完毕</th>
</tr>
</table>
<?php
}
else
{
?>
<form action="install.php" method="post" name="install" id="install">
<table width="70%" border="0" align="center">
<tr>
<th colspan="2">数据库设定</th>
</tr>
<tr>
<td width="200" align="right">数据库服务器主机名称或IP地址:</td>
<td><input name="host" type="text" class="textbox" id="host"></td>
</tr>
<tr>
<td align="right">您的数据库名称:</td>
<td><input name="db" type="text" class="textbox" id="db"></td>
</tr>
<tr>
<td align="right">数据库用户帐号:</td>
<td><input name="user" type="text" class="textbox" id="user"></td>
</tr>
<tr>
<td align="right">数据库密码:</td>
<td><input name="password" type="password" class="textbox" id="password"></td>
</tr>
<tr>
<td align="right">数据库的表格字首(Prefix):</td>
<td><input name="prefix" type="text" class="textbox" id="prefix" value="msg_"></td>
</tr>
<tr>
<td align="right">管理员名:</td>
<td><input name="adminname" type="text" class="textbox" id="adminname" value="admin" maxlength="32"></td>
</tr>
<tr>
<td align="right">管理员密码:</td>
<td><input name="adminpassword" type="password" class="textbox" id="adminpassword"></td>
</tr>
<tr>
<td align="right">管理员邮件:</td>
<td><input name="mail" type="text" class="textbox" id="mail"> </td>
</tr>
<tr>
<td align="right" valign="top"> </td>
<td>使用邮件群发功能时,对方看到的回复地址</td>
</tr>
<tr>
<th colspan="2">站点设定</th>
</tr>
<tr>
<td align="right">留言板绝对路径:</td>
<td><input name="url" type="text" class="textbox" id="url" value="http://www.xxiyy.com/msg/" size="45"></td>
</tr>
<tr align="center">
<td colspan="2">注意不要将结尾的“<font color="#FF0000"><strong>/</strong></font>”号丢掉!如:“<font color="#0000FF"><strong>http://www.xxiyy.com/msg</strong></font><strong><font color="#FF0000">/</font></strong>”</td>
</tr>
<tr>
<td colspan="2" align="center"> <input type="submit" name="Submit" value="开始安装" class="button">
</td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -