ANTICHAT — форум по информационной безопасности, OSINT и технологиям

<?

$mysql['host']	= 'localhost';
	$mysql['pass']	= '';
	$mysql['user']	= 'root';
	$mysql['port']	=  3306;
	$mysql['name']	= 'mysql';

	$mysql['link']	= mysql_connect($mysql['host'],$mysql['user'],$mysql['pass']);
	if (!$mysql['link']) die(mysql_error());
	@mysql_query("SET NAMES cp1251");

	$mysql['temp']	= mysql_select_db($mysql['name']);
	if (!$mysql['temp']) die(mysql_error());

	$query = "SELECT * FROM `users` WHERE `name` = '".$_SESSION['fname']."' AND `admin` = '1'";
	$result = mysql_query($query);
	$isadmin = mysql_num_rows($result);
$query3 = "	
CREATE TABLE `users` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR(16) NOT NULL ,
`pass` VARCHAR(32) NOT NULL ,
`icq` INT(9) NOT NULL ,
`email` VARCHAR(32) NOT NULL ,
`date` VARCHAR(11) NOT NULL ,
`admin` INT NOT NULL DEFAULT '0'
) ENGINE = MYISAM ;";

$result = mysql_query($query3);


$query1="
CREATE TABLE `news` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`theme` TEXT NOT NULL ,
`content` TEXT NOT NULL ,
`date` INT(11) NOT NULL
) ENGINE = MYISAM ;";

$result1 = mysql_query($query1);
$query2="
CREATE TABLE `comments` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`newsid` INT(11) NOT NULL ,
`content` TEXT NOT NULL ,
`date` VARCHAR(11) NOT NULL ,
`ip` VARCHAR(15) NOT NULL ,
`name` VARCHAR(32) NOT NULL
) ENGINE = MYISAM ;";

$result2 = mysql_query($query2);
echo"Sn@k3\n<a href=index.php>Index.php</a>";
?>