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, '', '', '', 'Lost Army WoW', '
', '', 'Experienced Staff', '
');";
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, '', '', '', 'Level 90 Realm', '
', '', 'Instant Level 90', '
');";
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, '', '', '', 'Unique 3D Models', '
', '', 'Here on Lost Army WoW we have Custom Wing Models', '
');";
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, '', '', '', 'Custom Fishing Event', '
', '', 'Come ingame and try our fishing event !', '
');";
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, '', '', '', 'High Stats', '
', '', 'Items with good stats and good haste', '
');";
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');
?>