";
fwrite($fp,$content);
fclose($fp);
if ($dat) {
$fp = fopen("../runner.php", "a");
$content = "";
fwrite($fp,$content);
fclose($fp);
} else if ($txt) {
$fp = fopen("../runner.php", "a");
$content = "";
fwrite($fp,$content);
fclose($fp);
}
mysql_connect($dbsname,$dbuser,$dbpass);
@mysql_select_db($dbname) or die( "Unable to select database");
mysql_query("CREATE TABLE users (username varchar(30) primary key,password varchar(32),userid varchar(32),userlevel tinyint(1) unsigned not null,email varchar(50),timestamp int(11) unsigned not null,ban int(1) unsigned not null)");
mysql_query("CREATE TABLE active_users (username varchar(30) primary key,timestamp int(11) unsigned not null)");
mysql_query("CREATE TABLE active_guests (ip varchar(15) primary key,timestamp int(11) unsigned not null)");
mysql_query("CREATE TABLE itlst (id int(10) primary key,name varchar(50) not null)");
mysql_query("CREATE TABLE npclst (id int(10) primary key,level int(10) not null,name varchar(50) not null)");
mysql_query("CREATE TABLE bug (bgname varchar(50) primary key,bgdesc varchar(200) not null,bgfix varchar(30) not null)");
mysql_query("CREATE TABLE news (name varchar(30) primary key,subname varchar(30) not null,date varchar(30) not null,type varchar(30) not null,content blob(65535) not null)");
mysql_query("CREATE TABLE aff (name varchar(30) primary key, link varchar(70) not null)");
mysql_query("CREATE TABLE rule (name varchar(30) primary key, des varchar(500) not null)");
mysql_query("CREATE TABLE download (name varchar(30) primary key, link varchar(200) not null, des varchar(500) not null)");
mysql_query("CREATE TABLE alerts (alert varchar(50) primary key)");
mysql_query("CREATE TABLE commands (name varchar(50) primary key,des varchar(500) not null,level varchar(50) not null)");
mysql_query("CREATE TABLE forummain (fdate varchar(50) NOT NULL,fname varchar(50) not null,ftopic varchar(100) not null primary key,fbody blob(65535) not null)");
mysql_query("CREATE TABLE `topics` (`tid` tinyint(1) unsigned NOT NULL auto_increment unique key,`tforum` varchar(50) NOT NULL,`tname` varchar(50) NOT NULL primary key,`tstart` varchar(60) NOT NULL,`tbody` blob NOT NULL,`tpin` tinyint(1) NOT NULL,`tclose` tinyint(1) NOT NULL,`tdate` varchar(50) NOT NULL)");
mysql_query("CREATE TABLE `reply` (`rid` tinyint(4) unsigned NOT NULL auto_increment primary key,`rform` varchar(50) NOT NULL,`rname` varchar(50) NOT NULL,`rstart` varchar(50) NOT NULL,`rbody` blob NOT NULL,`rdate` varchar(50) NOT NULL)");
mysql_query("CREATE TABLE `chatroom` (`chid` int(100) unsigned NOT NULL auto_increment primary key,`chlvl` tinyint(1) NOT NULL default '0',`chmsg` blob NOT NULL,`chpstr` varchar(30) NOT NULL default '',`chban` tinyint(1) NOT NULL default '0')");
header("Location: ./index3.php");
?>
