Require_once ('inc. php ');
If (! File_exists ($ l_file )){
Echo getstop (2 );
If ($ _ SERVER ['request _ method'] = 'post' & $ _ POST ['title']! = ''& $ _ POST ['username']! = ''& $ _ POST ['name']! = ''& $ _ POST ['Password']! = ''){
Require_once ($ c_file );
Echo'
';
$ Query = "create table {$ dbprefix} main (
Id int (10) not null auto_increment,
Title varchar (255) not null,
School varchar (255) default NULL,
Classname varchar (255) default NULL,
Open int (5) not null default '0 ',
Openreg int (5) not null default '0 ',
Gid varchar (255) default '1 | 2 | 3 ',
Content text,
Email int (5) not null default '0 ',
Pagesize int (10) not null default '20 ',
Upload int (5) not null default '0 ',
Maxsize int (10) not null default '0 ',
Filetype varchar (255) default 'jpg ',
Thum int (5) not null default '0 ',
Slink int (5) not null default '0 ',
Veri int (5) not null default '0 ',
Icp varchar (255) default NULL,
Skin int (10) not null default '0 ',
Timefix varchar (255) not null default '0 ',
Ip varchar (255) default NULL,
Unique key id (id)
) ". (Chksqlv ()? 'Engine = MyISAM default charset = gb2312 ': 'Type = myisam ');
$ Result = mysql_query ($ query );
Echo'
- Create a data table '. $ dbprefix. 'main: successful': 'f00; "> failed ').'
';
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,
Workvarchar (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'
- Create a data table '. $ dbprefix. 'Member: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'Online: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'topic: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'vote: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'photo: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'pcomment: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'camp: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'ccomment: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'cuser: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'message: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'adminop: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'link: successful': 'f00; "> failed ').'
';
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'
- Create a data table '. $ dbprefix. 'skin: successful': 'f00; "> failed ').'
';
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'
- Write New Data '. $ dbprefix. 'main: successful': 'f00; "> failed ').'
';
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, 9, % s )', $ dbprefix. 'member ',
SQLString ($ username, 'text '),
SQLString ($ password, 'text '),
SQLString ($ name, 'text '),
Time ());
$ Result = mysql_query ($ query );
Echo'
- Write New Data '. $ dbprefix. 'Member: successful': 'f00; "> failed ').'
';
Unset ($ query );
Unset ($ result );
$ Query = sprintf ('insert into % s (path, title, sfile) values (% s, % s, % s) ', $ dbprefix. 'skin ',
SQLString ('blue', 'text '),
SQLString ('Blue dream', 'text '),
SQLString('styles.css ', 'text '));
$ Result = mysql_query ($ query );
Echo'
- Write New Data '. $ dbprefix. 'skin: successful': 'f00; "> failed ').'
';
Unset ($ query );
Unset ($ result );
Echo'