/************************FORM VEGE*************************/
if(isset($_GET["mysql"])){
$farmnevx = $_POST['farmnev'];
$allatnevx = $_POST['allatnev'];
$adminnevx = $_POST['adminnev'];
$adminpassx = md5($_POST['adminpass']);
$hatterx = $_POST['hatter'];
$fiux = $_POST['fiu'];
$lanyx = $_POST['lany'];
$betux = $_POST['betu'];
$linkx = $_POST['link'];
$etel1x = $_POST['etel1'];
$etel2x = $_POST['etel2'];
$etel3x = $_POST['etel3'];
$etel4x = $_POST['etel4'];
$ital1x = $_POST['ital1'];
$ital2x = $_POST['ital2'];
$ital3x = $_POST['ital3'];
$ital4x = $_POST['ital4'];
$gomb1x = $_POST['gomb1'];
$gomb2x = $_POST['gomb2'];
$gomb3x = $_POST['gomb3'];
$gomb4x = $_POST['gomb4'];
$gomb5x = $_POST['gomb5'];
$gomb6x = $_POST['gomb6'];
$gomb7x = $_POST['gomb7'];
$gomb8x = $_POST['gomb8'];
$tanul1x = $_POST['tanul1'];
$tanul2x = $_POST['tanul2'];
$tanul3x = $_POST['tanul3'];
$tanul4x = $_POST['tanul4'];
$tanul5x = $_POST['tanul5'];
$tanul6x = $_POST['tanul6'];
$penz1 = $_POST['penz1'];
$penz2 = $_POST['penz2'];
$suli = $_POST['sulileir'];
$csapat1 = $_POST['csapat1'];
$csapat2 = $_POST['csapat2'];
$hatterszin = $_POST['hatterszin'];
/*************CREATE TABLES**************/
$admin = mysql_query("CREATE TABLE `admin` (
`id` int(11),
`admin` varchar(30) NOT NULL,
`pass` varchar(255) NOT NULL,
PRIMARY KEY (`id`))");
$csapat = mysql_query("CREATE TABLE `csapat` (
`csnev` text NOT NULL
)");
$csapattagok = mysql_query("CREATE TABLE `csapattagok` (
`tag` text NOT NULL,
`csapat` text NOT NULL
)");
$data = mysql_query("CREATE TABLE `data` (
`farmnev` text NOT NULL,
`allatnev` text NOT NULL,
`etel1` text NOT NULL,
`etel2` text NOT NULL,
`etel3` text NOT NULL,
`etel4` text NOT NULL,
`ital1` text NOT NULL,
`ital2` text NOT NULL,
`ital3` text NOT NULL,
`ital4` text NOT NULL,
`hatter` text NOT NULL,
`fiukep` text NOT NULL,
`lanykep` text NOT NULL,
`napok` text NOT NULL,
`gomb1` text NOT NULL,
`gomb2` text NOT NULL,
`gomb3` text NOT NULL,
`gomb4` text NOT NULL,
`gomb5` text NOT NULL,
`gomb6` text NOT NULL,
`gomb7` text NOT NULL,
`gomb9` text NOT NULL,
`betu` text NOT NULL,
`link` text NOT NULL,
`tanul1` text NOT NULL,
`tanul2` text NOT NULL,
`tanul3` text NOT NULL,
`tanul4` text NOT NULL,
`tanul5` text NOT NULL,
`tanul6` text NOT NULL,
`date` text NOT NULL,
`gold` text NOT NULL,
`goldnev` text NOT NULL,
`sulileir` text NOT NULL,
`csapatnev` text NOT NULL,
`csapatoknev` text NOT NULL,
`hatterszin` text NOT NULL
)");
$hirek = mysql_query("CREATE TABLE `hirek` (
`id` int(11) NOT NULL auto_increment,
`hir` text NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `hir` (`hir`)
)");
$nickek = mysql_query("CREATE TABLE `nickek` (
`id` int(11) NOT NULL auto_increment,
`nev` varchar(20) NOT NULL default '',
`jelszo` varchar(255) NOT NULL default '',
`mail` varchar(40) NOT NULL default '',
`rang` text NOT NULL,
`kor` text NOT NULL,
`nem` text NOT NULL,
`etel` text NOT NULL,
`ital` text NOT NULL,
`kedv` text NOT NULL,
`penz` text NOT NULL,
`csapat` text NOT NULL,
`csapatom` text NOT NULL,
`tanul1` text NOT NULL,
`egyeb` text NOT NULL,
`tanul2` text NOT NULL,
`tanul3` text NOT NULL,
`tanul4` text NOT NULL,
`tanul5` text NOT NULL,
`tanul6` text NOT NULL,
PRIMARY KEY (`id`)
)");
$pm = mysql_query("CREATE TABLE `pm` (
`id` int(11) NOT NULL auto_increment,
`cimzett` text NOT NULL,
`felado` text NOT NULL,
`datum` text NOT NULL,
`uzi` text NOT NULL,
PRIMARY KEY (`id`)
)");
$idobeir = date('Y'.'M'.'d');
$admink = mysql_query("INSERT INTO `admin` VALUES (1, '$adminnevx', '$adminpassx')");
$datak = mysql_query("INSERT INTO data (farmnev, allatnev, etel1, etel2, etel3, etel4, ital1, ital2, ital3, ital4, hatter, fiukep, lanykep, napok, gomb1, gomb2, gomb3, gomb4, gomb5, gomb6, gomb7, gomb9, betu, link, tanul1, tanul2, tanul3, tanul4, tanul5, tanul6, date, gold, goldnev, sulileir, csapatnev, csapatoknev, hatterszin) VALUES ('$farmnevx', '$allatnevx', '$etel1x', '$etel2x', '$etel3x', '$etel4x', '$ital1x', '$ital2x', '$ital3x','$ital4x' , '$hatterx', '$fiux', '$lanyx', '1', '$gomb1x', '$gomb2x', '$gomb3x', '$gomb4x', '$gomb5x', '$gomb6x', '$gomb7x', '$gomb8x', '$betux', '$linkx', '$tanul1x', '$tanul2x', '$tanul3x', '$tanul4x', '$tanul5x', '$tanul6x', '$idobeir', '$penz1', '$penz2', '$suli', '$csapat1', '$csapat2', '$hatterszin')");
$hirekk = mysql_query("INSERT INTO `hirek` VALUES (1, 'Ez itt egy teszt hír.')");
print"
Sikeres telepítés! Töröld az 'install.php'-t a tárhelyedről!