php 文件安装三
失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}member (
id int(10) not null auto_increment,
username varchar(255) not null,
password varchar(255) not null,
name varchar(255) not null,
status int(5) not null default '0',
power int(5) not null default '0',
regdate int(15) not null default '0',
visit int(10) not null default '0',
visitdate int(15) not null default '0',
question varchar(255) default null,
answer varchar(255) default null,
email varchar(255) default null,
gender int(5) not null default '0',
bir_y int(4) not null default '0',
bir_m int(2) not null default '0',
bir_d int(2) not null default '0',
address varchar(255) default null,
location varchar(255) default null,
url varchar(255) default null,
work varchar(255) default null,
phone varchar(255) default null,
tel varchar(255) default null,
qq varchar(255) default null,
msn varchar(255) default null,
gtalk varchar(255) default null,
gid int(5) not null default '0',
rela varchar(255) default null,
photo varchar(255) default null,
pupload int(5) not null default '0',
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'member:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}online (
aid int(10) not null default '0',
datetime int(15) not null default '0',
online int(5) not null default '1',
ip char(15) default null,
unique key aid (aid)
) .(chksqlv()?'engine=memory default charset=gb2312':'type=heap');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'online:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}topic (
id int(10) not null auto_increment,
content text not null,
aid int(10) not null default '0',
datetime int(15) not null default '0',
sticky int(5) not null default '0',
sid int(10) not null default '0',
tid int(5) not null default '0',
mid int(5) not null default '0',
disp int(5) not null default '0',
`lock` int(5) not null default '0',
rid int(10) not null default '0',
lasttime int(15) not null default '0',
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'topic:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}vote (
id int(10) not null auto_increment,
aid int(10) not null default '0',
tid int(10) not null default '0',
vid int(10) not null default '0',
datetime int(15) not null default '0',
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'vote:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}photo (
id int(10) not null auto_increment,
url text not null,
title varchar(255) default null,
aid int(10) not null default '0',
cid int(10) not null default '0',
datetime int(15) not null default '0',
upload int(5) not null default '0',
disp int(5) not null default '0',
vid int(5) not null default '0',
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'photo:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}pcomment (
id int(10) not null auto_increment,
aid int(10) not null default '0',
pid int(10) not null default '0',
disp int(5) not null default '0',
datetime int(15) not null default '0',
content text not null,
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'pcomment:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}camp (
id int(10) not null auto_increment,
title varchar(255) not null,
aid int(10) not null default '0',
sticky int(5) not null default '0',
closed int(5) not null default '0',
disp int(5) not null default '0',
datetime int(15) not null default '0',
cdate varchar(255) default null,
cloc varchar(255) default null,
cpay varchar(255) default null,
content text,
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'camp:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}ccomment (
id int(10) not null auto_increment,
aid int(10) not null default '0',
cid int(10) not null default '0',
sid int(10) not null default '0',
disp int(5) not null default '0',
datetime int(15) not null default '0',
content text,
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'ccomment:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}cuser (
id int(10) not null auto_increment,
aid int(10) not null default '0',
cid int(10) not null default '0',
tid int(10) not null default '1',
datetime int(15) not null default '0',
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'cuser:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}message (
id int(10) not null auto_increment,
aid int(10) not null default '0',
tid int(10) not null default '0',
datetime int(15) not null default '0',
readed int(5) not null default '0',
content text not null,
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'message:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}adminop (
id int(10) not null auto_increment,
aid int(10) not null default '0',
sid int(10) not null default '0',
tid int(5) not null default '0',
datetime int(15) not null default '0',
content text not null,
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'adminop:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}link (
id int(10) not null auto_increment,
title varchar(255) not null,
url varchar(255) not null,
thread int(10) not null default '0',
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'link:成功':'f00;>失败').'';
unset($query);
unset($result); $query=create table {$dbprefix}skin (
id int(10) not null auto_increment,
path varchar(255) not null,
title varchar(255) default null,
sfile varchar(255) not null,
unique key id (id)
) .(chksqlv()?'engine=myisam default charset=gb2312':'type=myisam');
$result=mysql_query($query);
echo '
建立数据表 '.$dbprefix.'skin:成功':'f00;>失败').'';
unset($query);
unset($result); $title=htmlspecialchars(trim($_post['title']),ent_quotes);
$query=sprintf('insert into %s (title) values (%s)', $dbprefix.'main',
sqlstring($title, 'text'));
$result=mysql_query($query);
echo '
写入新数据 '.$dbprefix.'main:成功':'f00;>失败').'';
unset($query);
unset($result); $username=trim($_post['username']);
$password=enc_p(trim($_post['password']));
$name=htmlspecialchars(trim($_post['name']),ent_quotes);
$query=sprintf('insert into %s (username, password, name, power, regdate) values (%s, %s, %s, 9, %s)', $dbprefix.'member',
sqlstring($username, 'text'),
sqlstring($password, 'text'),
sqlstring($name, 'text'),
time());
$result=mysql_query($query);
echo '
写入新数据 '.$dbprefix.'member:成功':'f00;>失败').'';
unset($query);
unset($result); $query=sprintf('insert into %s (path, title, sfile) values (%s, %s, %s)', $dbprefix.'skin',
sqlstring('blue', 'text'),
sqlstring('蓝色梦想', 'text'),
sqlstring('styles.css', 'text'));
$result=mysql_query($query);
echo '
写入新数据 '.$dbprefix.'skin:成功':'f00;>失败').'';
unset($query);
unset($result);
echo '
';
writetext($l_file,time());
}else{
?>
第2步:配置信息
标 题:
管理员信息
用户名:
姓 名:
密 码:
确 认: