📄 install.php
字号:
";
$res2="friends_setpnt....................";
if(mysql_query($str21)&&mysql_query($str22))$res2 .= "创建成功！";
mysql_query("INSERT INTO `friends_setpnt` VALUES (1, 0, '登录网站', 'Login', '0.5');");
mysql_query("INSERT INTO `friends_setpnt` VALUES (2, 0, '更新资料', 'Modify', '1');");
mysql_query("INSERT INTO `friends_setpnt` VALUES (3, 0, '搜索会员', 'Search', '0.2');");
mysql_query("INSERT INTO `friends_setpnt` VALUES (4, 0, '购买资料', 'Contact', '-50');");
mysql_query("INSERT INTO `friends_setpnt` VALUES (5, 0, '上传照片', 'SavePhoto', '2');");
mysql_query("INSERT INTO `friends_setpnt` VALUES (6, 0, '浏览照片', 'ViewPic', '-50');");
mysql_query("INSERT INTO `friends_setpnt` VALUES (7, 0, '查看留言', 'ViewPm', '-30');");
$str31 = "DROP TABLE IF EXISTS `friends_user`;";
$str32 = "CREATE TABLE `friends_user` (
`id` int(10) NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`pass` varchar(40) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`joindate` date NOT NULL default '0000-00-00',
`ip` varchar(20) NOT NULL default '',
`realname` varchar(20) default NULL,
`sex` tinyint(2) NOT NULL default '0',
`birth` varchar(15) default NULL,
`place` tinyint(3) NOT NULL default '0',
`city` varchar(30) default NULL,
`address` varchar(80) default NULL,
`zipcode` varchar(10) default NULL,
`tel` varchar(15) default NULL,
`otherinfo` varchar(100) NOT NULL default '',
`edu` tinyint(3) NOT NULL default '0',
`job` tinyint(3) NOT NULL default '0',
`income` tinyint(3) NOT NULL default '0',
`grade` tinyint(3) NOT NULL default '1',
`height` tinyint(3) NOT NULL default '0',
`weight` tinyint(3) NOT NULL default '0',
`marriage` tinyint(3) NOT NULL default '0',
`relation` tinyint(3) NOT NULL default '0',
`skilledlang` varchar(255) NOT NULL default '0',
`studyinglang` varchar(255) NOT NULL default '0',
`interest` varchar(255) NOT NULL default '0',
`drink` tinyint(3) NOT NULL default '0',
`smoke` tinyint(3) NOT NULL default '0',
`aboutme` text NOT NULL,
`update` date NOT NULL default '0000-00-00',
`uptimes` int(5) NOT NULL default '1',
`click` int(11) NOT NULL default '0',
`money` float NOT NULL default '0',
`active` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
";
$res3="friends_user....................";
if(mysql_query($str31)&&mysql_query($str32))$res3 .= "创建成功！";
$str41 = "DROP TABLE IF EXISTS `friends_words`;";
$str42 = "CREATE TABLE `friends_words` (
`id` int(5) unsigned NOT NULL auto_increment,
`writer` varchar(40) NOT NULL default '',
`from` varchar(60) NOT NULL default '',
`category` int(3) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`words` text NOT NULL,
`date` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
";
$res4="friends_words....................";
if(mysql_query($str41)&&mysql_query($str42))$res4 .= "创建成功！";
$str51 = "DROP TABLE IF EXISTS `user_album`;";
$str52 = "CREATE TABLE `user_album` (
`ID` int(7) unsigned NOT NULL auto_increment,
`username` varchar(50) NOT NULL default '',
`approved` tinyint(1) NOT NULL default '0',
`time` varchar(20) NOT NULL default '2000-1-1',
`path` varchar(40) NOT NULL default 'pic/',
`fm` tinyint(1) NOT NULL default '0',
`click` int(10) NOT NULL default '0',
`name` varchar(60) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
";
$res5="user_album....................";
if(mysql_query($str51)&&mysql_query($str52))$res5 .= "创建成功！";
$str61 = "DROP TABLE IF EXISTS `user_charge`;";
$str62 = "CREATE TABLE `user_charge` (
`username` varchar(20) NOT NULL default '',
`item` varchar(100) NOT NULL default '',
`num` float NOT NULL default '0',
`account` enum('0','1','2') NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
KEY `username` (`username`)
) TYPE=MyISAM;
";
$res6="user_charge....................";
if(mysql_query($str61)&&mysql_query($str62))$res6 .= "创建成功！";
$str71 = "DROP TABLE IF EXISTS `user_pm`;";
$str72 = "CREATE TABLE `user_pm` (
`id` int(10) unsigned NOT NULL auto_increment,
`pfrom` varchar(20) NOT NULL default '',
`pto` varchar(20) NOT NULL default '',
`title` varchar(60) NOT NULL default '',
`msg` text NOT NULL,
`ptime` datetime NOT NULL default '0000-00-00 00:00:00',
`readed` enum('0','1') NOT NULL default '0',
`box` enum('1','2') NOT NULL default '1',
`free` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
";
$res7="user_pm....................";
if(mysql_query($str71)&&mysql_query($str72))$res7 .= "创建成功！";
?>
<form action="install.php" method="post">
<input type="hidden" name="step" value="5">
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#000000">
<tr>
<td class="m_title">第四步：创建数据表</td>
</tr>
<tr>
<td bgcolor="#E7ECF5"><table border="0" align="center">
<tr>
<td>
<?=$res1;?>
</td>
</tr>
<tr>
<td>
<?=$res2;?>
</td>
</tr>
<tr>
<td>
<?=$res3;?>
</td>
</tr>
<tr>
<td>
<?=$res4;?>
</td>
</tr>
<tr>
<td>
<?=$res5;?>
</td>
</tr>
<tr>
<td>
<?=$res6;?>
</td>
</tr>
<tr>
<td>
<?=$res7;?>
</td>
</tr>
</table></td>
</tr>
</table>
<br>
<center>
<input type="submit" name="submit" value="点击进入下一步安装">
</center>
</form>
<?php
@mysql_close($conn);
}
if($_POST["step"]==5)
{
?>
<script language="javascript">
function check()
{
var email_ok=true,i;
if(inputform.email.value==''){
alert("您没有填写 EMail！");
inputform.email.focus();
return false;
}
else{
email=inputform.email.value;
if((at=email.indexOf("@"))<0){
email_ok=false;
}
if((dot=email.lastIndexOf("."))<0){
email_ok=false;
}
if(at>dot||dot>=email.length-1){
email_ok=false;
}
if(!email_ok){
alert("填写 EMail 错误！");
inputform.email.focus();
return false;
}
}
if(inputform.pass.value!=inputform.pass1.value)
{
window.alert("两次输入的密码不相符！");
inputform.pass.focus();
return false;
}
return true;
}
</script>
<form action="install.php" method="post" name="inputform" onsubmit="return(check());">
<input type="hidden" name="step" value="6">
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#000000">
<tr>
<td class="m_title">第五步：创建管理员帐号 </td>
</tr>
<tr>
<td bgcolor="#E7ECF5"><table border="0" align="center">
<tr>
<td>用户名：</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>密 码：</td>
<td><input type="password" name="pass"></td>
</tr>
<tr>
<td>确 认：</td>
<td><input type="password" name="pass1"></td>
</tr>
<tr>
<td>邮 件：</td>
<td><input type="text" name="email"></td>
</tr>
</table></td>
</tr>
</table>
<br>
<center>
<input type="submit" name="submit" value="确认提交">
</center>
</form>
<?php
}
if($_POST["step"]==6)
{
require_once("function.php");
require_once("config.inc.php");
$db = mysql_connect(HOST,USERNAME,PASSWORD);
$select = mysql_select_db(DATABASE,$db);
$ip = ip();
$name = $_POST['username'];
$pass = md5($_POST['pass']);
$mail = $_POST['email'];
$date = date("Y-m-d");
mysql_query("delete from friends_user");
$str = "INSERT INTO friends_user VALUES (1, '$name', '$pass', '$mail', '$date', '$ip', '姓名', 1, '0000-00-00', 1, '北京市', '', '100000', '01012345678', '', 0, 16, 1, 0, 0, 0, 0, 0, '0', '0', '0', 0, 0, '自我介绍', '$date', 1, '0', '0','1')";
if(mysql_query($str))
{
$msg="<p>创建管理员帐号成功！</p>
<p><font color=red>为了安全起见，请立即删除install.php文件！</font></p>
<p><a href=\"index.php\">点击这里登录管理界面，修改个人详细信息及进行系统设置</a></p>";
upPoint($name,"Modify","");
}
@mysql_close($db);
?>
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#000000">
<tr>
<td class="m_title">安装完成！</td>
</tr>
<tr>
<td bgcolor="#E7ECF5">
<table border="0" align="center">
<tr>
<td>
<?=$msg;?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<?php
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -