<?php


/*echo "<h1>Down for maintenance!</h1>";
exit;*/

$con = mysql_connect("mysql","rpg","wiggleyourdickbutt");
if (!$con) {
    die('Could not connect: ' . mysql_error());
}

$r = mysql_select_db("mop_rpg", $con);


$tables = array();
$q = mysql_query("SHOW TABLES");
while($row = mysql_fetch_array($q)) {
    array_push($tables, $row[0]);
}

if(!$tables) {
    $queries = array("CREATE TABLE `mrpg_battles` (
  `id` text,
  `use` text,
  `enemy` text,
  `enemyhp` text,
  `other` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;",

    "CREATE TABLE `mrpg_confirm` (
  `id` int(11) DEFAULT NULL,
  `q` text,
  `yesx` int(11) DEFAULT NULL,
  `yesy` int(11) DEFAULT NULL,
  `nox` int(11) DEFAULT NULL,
  `noy` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;",

    "CREATE TABLE `mrpg_message` (
  `id` int(11) DEFAULT NULL,
  `q` text,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;",

    "CREATE TABLE `mrpg_monsters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` text,
  `hp` int(11) DEFAULT NULL,
  `name` text,
  `diemsg` text,
  `expgive` int(11) DEFAULT NULL,
  `power` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;",

    "INSERT INTO `mrpg_monsters` VALUES (1,'rat.png',30,'Rat','rat died',10,0);",
    "INSERT INTO `mrpg_monsters` VALUES (2,'chef_1.png',30,'Chef','chef screamed \"profit has a tiny dick\" and died',20,2);",
    "INSERT INTO `mrpg_monsters` VALUES (3,'monster.png',30,'Monster','monster died',30,5);",

    "CREATE TABLE `mrpg_stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hp` int(11) DEFAULT NULL,
  `maxhp` int(11) DEFAULT NULL,
  `pp` int(11) DEFAULT NULL,
  `offense` int(11) DEFAULT NULL,
  `defense` int(11) DEFAULT NULL,
  `fight` int(11) DEFAULT NULL,
  `speed` int(11) DEFAULT NULL,
  `wisdom` int(11) DEFAULT NULL,
  `strength` int(11) DEFAULT NULL,
  `force` int(11) DEFAULT NULL,
  `poison` int(11) DEFAULT NULL,
  `other` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;",

    "CREATE TABLE `mrpg_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `password` text,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `dir` text,
  `inventory` text,
  `level` int(11) DEFAULT NULL,
  `lastact` text,
  `mode` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;");

    foreach($queries as $q) {
        mysql_query($q);
        print_r(mysql_error());
    }
}

//Get user IP
if($_SERVER['HTTP_X_FORWARDED_FOR']!="") {
    $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
    $ip=$_SERVER['REMOTE_ADDR'];
}

?>