installation

<?php
$host = $_POST['dbhost'];
$dbuser = $_POST['dbuser'];
$dbpass = $_POST['dbpass'];
$dbname = $_POST['webdb'];
$authdb = $_POST['authdb'];
$chardb = $_POST['chardb'];
$worlddb = $_POST['worlddb'];
$soapUsername = $_POST['soapuser'];
$soapPassword = $_POST['soappass'];
$soapHost = $_POST['soaphost'];
$soapPort = $_POST['soapport'];
$title = $_POST['title'];
$realmlist = $_POST['realmlist'];
$table = "azer_config";
$itemtable = "azer_items";
$logtable = "azer_items_log";
$linktable = "azer_links";
$posttable = "azer_posts";
$slidertable = "azer_slider";

$myfile = fopen("../../config/db_conf.php", "w") or die("Unable to open file!");

$txt = "<?php\n";
fwrite($myfile, $txt);

$txt = "\$host = \"$host\";\n";
fwrite($myfile, $txt);

$txt = "\$dbuser = \"$dbuser\";\n";
fwrite($myfile, $txt);

$txt = "\$dbpass = \"$dbpass\";\n";
fwrite($myfile, $txt);

$txt = "\$dbname = \"$dbname\";\n";
fwrite($myfile, $txt);

$txt = "\$authdb = \"$authdb\";\n";
fwrite($myfile, $txt);

$txt = "\$chardb = \"$chardb\";\n";
fwrite($myfile, $txt);

$txt = "\$worlddb = \"$worlddb\";\n";
fwrite($myfile, $txt);

$txt = "\$soapUsername = \"$soapUsername\";\n";
fwrite($myfile, $txt);

$txt = "\$soapPassword = \"$soapPassword\";\n";
fwrite($myfile, $txt);

$txt = "\$soapHost = \"$soapHost\";\n";
fwrite($myfile, $txt);

$txt = "\$title = \"$title\";\n";
fwrite($myfile, $txt);

$txt = "\$realmlist = \"$realmlist\";\n";
fwrite($myfile, $txt);

$txt = "\$table = \"$table\";";
fwrite($myfile, $txt);

fclose($myfile);

$conn = new mysqli($host, $dbuser, $dbpass, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "CREATE TABLE IF NOT EXISTS `$itemtable` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_entry` int(10) unsigned DEFAULT '0',
  `points` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;";

if ($conn->query($sql) === TRUE) {
} else {
    echo "Error creating table: " . $conn->error;
}

$sql2 = "CREATE TABLE IF NOT EXISTS `$logtable` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(50) NOT NULL,
  `character` varchar(50) NOT NULL,
  `item` int(11) NOT NULL,
  `status` varchar(50) NOT NULL,
  `buy_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;";

if ($conn->query($sql2) === TRUE) {
} else {
    echo "Error creating table: " . $conn->error;
}

$sql3 = "CREATE TABLE IF NOT EXISTS `$linktable` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `link` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `login_req` smallint(5) unsigned NOT NULL DEFAULT '0',
  `type` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;";

if ($conn->query($sql3) === TRUE) {
} else {
    echo "Error creating table: " . $conn->error;
}

$sql4 = "CREATE TABLE IF NOT EXISTS `$posttable` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '0',
  `content` longtext NOT NULL,
  `author` varchar(50) NOT NULL DEFAULT '0',
  `avatar` varchar(50) NOT NULL DEFAULT '0',
  `rank` varchar(50) NOT NULL DEFAULT '0',
  `post_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;";

if ($conn->query($sql4) === TRUE) {
} else {
    echo "Error creating table: " . $conn->error;
}

$sql5 = "CREATE TABLE IF NOT EXISTS `$slidertable` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `href` varchar(50) DEFAULT '0',
  `imgdiv_open` longtext,
  `image` longtext,
  `imgdiv_close` longtext,
  `a_open` longtext,
  `title` longtext,
  `a_close` longtext,
  `contentdiv_open` longtext,
  `content` longtext,
  `contentdiv_close` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;";

if ($conn->query($sql5) === TRUE) {
} else {
    echo "Error creating table: " . $conn->error;
}

$sql6 = "INSERT INTO `$slidertable` (`id`, `href`, `imgdiv_open`, `image`, `imgdiv_close`, `a_open`, `title`, `a_close`, `contentdiv_open`, `content`, `contentdiv_close`) VALUES (1, '<a href=\"#\">', '<div class=\"slide\" id=\"slide-0\" style=\"background-image: url(\'images/', 'slide1.jpg', '\'); \"></div></a>', '<a href=\"javascript:;\" id=\"paging-0\" onclick=\"Slideshow.jump(0, this);\" class=\"current\"><div class=\"slide-panel-heading-1\">', 'Lost Army WoW', '</div>', '<div class=\"slide-panel-info-1\">', 'Experienced Staff', '</div></a>');";
if(mysqli_query($conn, $sql6)) {
}else{
}

$sql7 = "INSERT INTO `$slidertable` (`id`, `href`, `imgdiv_open`, `image`, `imgdiv_close`, `a_open`, `title`, `a_close`, `contentdiv_open`, `content`, `contentdiv_close`) VALUES (2, '<a href=\"#\">', '<div class=\"slide\" id=\"slide-1\" style=\"background-image: url(\'images/', 'slide2.jpg', '\'); display: none;\"></div></a>', '<a href=\"javascript:;\" id=\"paging-1\" onclick=\"Slideshow.jump(1, this);\"><div class=\"slide-panel-heading\">', 'Level 90 Realm', '</div>', '<div class=\"slide-panel-info\">', 'Instant Level 90', '</div></a>');";
if(mysqli_query($conn, $sql7)) {
}else{
}

$sql8 = "INSERT INTO `$slidertable` (`id`, `href`, `imgdiv_open`, `image`, `imgdiv_close`, `a_open`, `title`, `a_close`, `contentdiv_open`, `content`, `contentdiv_close`) VALUES (3, '<a href=\"#\">', '<div class=\"slide\" id=\"slide-2\" style=\"background-image: url(\'images/', 'slide3.jpg', '\'); display: none;\"></div></a>', '<a href=\"javascript:;\" id=\"paging-2\" onclick=\"Slideshow.jump(2, this);\"><div class=\"slide-panel-heading\">', 'Unique 3D Models', '</div>', '<div class=\"slide-panel-info\">', 'Here on Lost Army WoW we have Custom Wing Models', '</div></a>');";
if(mysqli_query($conn, $sql8)) {
}else{
}

$sql9 = "INSERT INTO `$slidertable` (`id`, `href`, `imgdiv_open`, `image`, `imgdiv_close`, `a_open`, `title`, `a_close`, `contentdiv_open`, `content`, `contentdiv_close`) VALUES (4, '<a href=\"#\">', '<div class=\"slide\" id=\"slide-3\" style=\"background-image: url(\'images/', 'slide4.jpg', '\'); display: none;\"></div></a>', '<a href=\"javascript:;\" id=\"paging-3\" onclick=\"Slideshow.jump(3, this);\"><div class=\"slide-panel-heading\">', 'Custom Fishing Event', '</div>', '<div class=\"slide-panel-info\">', 'Come ingame and try our fishing event !', '</div></a>');";
if(mysqli_query($conn, $sql9)) {
}else{
}

$sql10 = "INSERT INTO `$slidertable` (`id`, `href`, `imgdiv_open`, `image`, `imgdiv_close`, `a_open`, `title`, `a_close`, `contentdiv_open`, `content`, `contentdiv_close`) VALUES (5, '<a href=\"#\">', '<div class=\"slide\" id=\"slide-4\" style=\"background-image: url(\'images/', 'slide1.jpg', '\'); display: none;\"></div></a>', '<a href=\"javascript:;\" id=\"paging-4\" onclick=\"Slideshow.jump(4, this);\" class=\"last-slide\"><div class=\"slide-panel-heading\">', 'High Stats', '</div>', '<div class=\"slide-panel-info\">', 'Items with good stats and good haste', '</div></a>');";
if(mysqli_query($conn, $sql10)) {
}else{
}

$sql11 = "INSERT INTO `$linktable` (`id`, `link`, `name`, `login_req`, `type`) VALUES (1, '?p=home', 'Home', 1, 0);";
if(mysqli_query($conn, $sql11)) {
}else{
}

$sql12 = "INSERT INTO `$linktable` (`id`, `link`, `name`, `login_req`, `type`) VALUES (2, '?p=register', 'Register', 0, 0);";
if(mysqli_query($conn, $sql12)) {
}else{
}

$sql13 = "INSERT INTO `$linktable` (`id`, `link`, `name`, `login_req`, `type`) VALUES (3, '?p=connect', 'Connect', 1, 0);";
if(mysqli_query($conn, $sql13)) {
}else{
}

$sql14 = "INSERT INTO `$linktable` (`id`, `link`, `name`, `login_req`, `type`) VALUES (4, '?p=downloads', 'Downloads', 1, 0);";
if(mysqli_query($conn, $sql14)) {
}else{
}

$sql15 = "INSERT INTO `$linktable` (`id`, `link`, `name`, `login_req`, `type`) VALUES (5, 'forum', 'Forum', 1, 0);";
if(mysqli_query($conn, $sql15)) {
}else{
}

$sql15 = "INSERT INTO `$linktable` (`id`, `link`, `name`, `login_req`, `type`) VALUES (5, 'forum', 'Forum', 1, 0);";
if(mysqli_query($conn, $sql15)) {
}else{
}

$sql15 = "INSERT INTO `$posttable` (`id`, `title`, `content`, `author`, `avatar`, `rank`, `post_date`) VALUES (1, 'Welcome to TokDevCMS', 'Hello and Welcome to TokdevCMS. This website was designed by Baked and Coded by Tim Levinsson', 'TokDev', 'ava1.png', 'webdev', '2015-04-16 03:00:25');";
if(mysqli_query($conn, $sql15)) {
}else{
}

$sql16 = "ALTER TABLE $authdb.account ADD vp VARCHAR( 255 ) after recruiter;";

if ($conn->query($sql16) === TRUE) {
} else {
    echo "Error " . $conn->error;
}

$sql17 = "ALTER TABLE $authdb.account CHANGE COLUMN `vp` `vp` VARCHAR(255) NULL DEFAULT '0' AFTER `recruiter`;";

if ($conn->query($sql17) === TRUE) {
} else {
    echo "Error " . $conn->error;
}

$sql16 = "ALTER TABLE $authdb.account ADD dp VARCHAR( 255 ) after vp;";

if ($conn->query($sql16) === TRUE) {
} else {
    echo "Error " . $conn->error;
}

$sql17 = "ALTER TABLE $authdb.account CHANGE COLUMN `dp` `dp` VARCHAR(255) NULL DEFAULT '0' AFTER `vp`;";

if ($conn->query($sql17) === TRUE) {
} else {
    echo "Error " . $conn->error;
}

header('location: ../?p=finished');
?>