<?php
require "inc.php";
$db=mysql_connect($dbhost, $dbuser, $dbpass);
//$sql="CREATE DATABASE IF NOT EXISTS $dbname";
//$a=mysql_query($sql);
mysql_select_db($dbname,$db);
$sql="
CREATE TABLE `forum` (
`pid` int(11) NOT NULL auto_increment,
`post` text,
`topic` varchar(50) default NULL,
`usid` int(11) default NULL,
`date` date default NULL,
`time` varchar(20) default NULL,
`ip` varchar(30) default NULL,
`views` int(11) default NULL,
`ispoll` int(11) default NULL,
`poll_var1` varchar(20) default NULL,
`poll_var2` varchar(20) default NULL,
`poll_var3` varchar(20) default NULL,
`poll_res1` int(11) default NULL,
`poll_res2` int(11) default NULL,
`poll_res3` int(11) default NULL,
PRIMARY KEY (`pid`)
);
";
$a=mysql_query($sql);
$sql="
CREATE TABLE `replies` (
`rid` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL,
`messg` text,
`usid` int(11) default NULL,
`date` date default NULL,
`time` varchar(20) default NULL,
`ip` varchar(30) default NULL,
PRIMARY KEY (`rid`)
);
";
$a=mysql_query($sql);
$sql="
CREATE TABLE `users` (
`usid` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`pass` varchar(32) NOT NULL,
`avatar` varchar(20) NOT NULL,
`posts` int(11) NOT NULL,
PRIMARY KEY (`usid`)
);
";
$a=mysql_query($sql);
$sql="
CREATE TABLE `poll` (
`poll_id` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL,
`usid` int(11) NOT NULL,
PRIMARY KEY (`poll_id`)
);
";
$a=mysql_query($sql);
$pass=md5('pass');
$sql="INSERT INTO `users` VALUES (1, 'admin', 'admin@localhost', '$pass', 'av1.gif', 0);";
$a=mysql_query($sql);
setcookie("usid",1);
setcookie("pass",$pass);
Header("Location: profile.php");
?>