verf.php

<?php

if (!file_exists('verifyPanel.php')) {
    $fail = false;
    if ($_POST['user'] != '') {
        $user = $_POST['user'];
    } else {
        echo 'Invalid User ';
        $fail = true;
    }

    if ($_POST['pass'] != '') {
        $pass = $_POST['pass'];
    } else {
        $pass = '';
    }

    if ($_POST['host'] != '') {
        $host = $_POST['host'];
    } else {
        echo 'Invalid Host ';
        $fail = true;
    }

    if ($_POST['name'] != '') {
        $name = $_POST['name'];
    } else {
        echo 'Invalid DB Name ';
        $fail = true;
    }

    if ($_POST['port'] != '') {
        $port = $_POST['port'];
    } else {
        $port = 3306;
    }

    if ($_POST['ServerIp'] != '') {
        $ServerIp = $_POST['ServerIp'];
        $ServerIp = $ServerIp;
    } else {

    }

    if ($_POST['DM_Dir'] != '') {
        $DM_Dir = $_POST['DM_Dir'];
        $DM_Dir =   $DM_Dir;
    } else {

    }



    if (!$fail) {
        $filename = 'verifyPanel.php';
        $ourFileName = $filename;

        $written = '<?php

include "functions.php";

function masterconnect(){

	global '.'$'.'dbcon;
	'.'$'."dbcon = mysqli_connect('$host', '$user', '$pass', '$name', '$port') or die ('Database connection failed');
}

function loginconnect(){

	global ".'$'.'dbconL;
	'.'$'."dbconL = mysqli_connect('$host', '$user', '$pass', '$name', '$port');
}


global ".'$'.'DBHost;
'.'$'."DBHost = '$host';
global ".'$'.'DBUser;
'.'$'."DBUser = '$user';
global ".'$'.'DBPass;
'.'$'."DBPass = '$pass';
global ".'$'.'DBName;
'.'$'."DBName = '$name';

global ".'$'.'ServerIp;
'.'$'."ServerIp = '$ServerIp';
global ".'$'.'DM_Dir;
'.'$'."DM_Dir = '$DM_Dir';


?>
";


        $dbconnect = mysqli_connect($host, $user, $pass, $name, $port) or die('Database connection failed');

		$sql = array();

        $sql[] = 'DROP TABLE IF EXISTS `users`;';
        $sql[] = 'DROP TABLE IF EXISTS `log`;';
        $sql[] = 'DROP TABLE IF EXISTS `notes`;';
        $sql[] = 'DROP TABLE IF EXISTS `reimbursement_log`;';
        $sql[] = 'DROP TABLE IF EXISTS `whitelist`;';
        $sql[] = 'DROP TABLE IF EXISTS `access`;';
        $sql[] = '
			CREATE TABLE IF NOT EXISTS `log` (
				`logid` int(11) NOT NULL AUTO_INCREMENT,
				`date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
				`user` varchar(64) DEFAULT NULL,
				`action` varchar(255) DEFAULT NULL,
				`level` int(11) NOT NULL,
				PRIMARY KEY (`logid`),
				UNIQUE KEY `logid` (`logid`),
				KEY `logid_2` (`logid`)
			) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
		';

        $sql[] = '
			CREATE TABLE IF NOT EXISTS `users` (
			    `ID` mediumint(9) NOT NULL AUTO_INCREMENT,
			    `username` varchar(60) NOT NULL,
			    `password` varchar(80) NOT NULL,
			    `permissions` text NOT NULL,
			    PRIMARY KEY (`ID`)
			) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;'
		;

        $sql[] = "
			CREATE TABLE IF NOT EXISTS `notes` (
			    `note_id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'auto incrementing note_id of each user, unique index',
			    `uid` VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci',
			    `staff_name` VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci',
			    `name` VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci',
			    `alias` VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci',
		            `note_text` VARCHAR(255) NOT NULL,
			    `warning` ENUM('1','2','3','4') NOT NULL,
			    `note_updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
			    PRIMARY KEY (`note_id`),
			    UNIQUE INDEX `note_id` (`note_id`)
			) COLLATE='latin1_swedish_ci' ENGINE=InnoDB AUTO_INCREMENT=6;"
		;

		$sql[] = "
			CREATE TABLE IF NOT EXISTS `reimbursement_log` (
				`reimbursement_id` INT(11) NOT NULL AUTO_INCREMENT,
				`playerid` VARCHAR(50) NOT NULL,
				`comp` INT(100) NOT NULL DEFAULT '0',
				`reason` VARCHAR(255) NOT NULL,
				`staff_name` VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci',
				`timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
				PRIMARY KEY (`reimbursement_id`),
				UNIQUE INDEX `reimbursement_id` (`reimbursement_id`)
			)
			COLLATE='latin1_swedish_ci'
			ENGINE=InnoDB
			AUTO_INCREMENT=1;"
		;

        $sql[] = '
	        CREATE TABLE IF NOT EXISTS `whitelist` (
	            `id` int(0) NOT NULL AUTO_INCREMENT,
	            `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	            `user` varchar(64) DEFAULT NULL,
	            `guid` varchar(64) DEFAULT NULL,
	            `uid` varchar(64) DEFAULT NULL,
	            PRIMARY KEY (`id`)
	        ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;'
		;

        $sql[] = '
	        CREATE TABLE `access` (
	            `accessID` int(11) NOT NULL AUTO_INCREMENT,
	            `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	            `address` varchar(64) DEFAULT NULL,
	            `failed` int(11) NOT NULL,
	            PRIMARY KEY (`accessID`),
	            UNIQUE KEY `accessID` (`accessID`),
	            KEY `accessID_1` (`accessID`)
	        ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;'
		;

		$sql[] = "INSERT INTO `users` (`username`, `password`, `permissions`) VALUES ('AdminPanel','60fe74406e7f353ed979f350f2fbb6a2e8690a5fa7d1b0c32983d1d8b3f95f67', '\"[[`notes`,1],[`cop`,1],[`medic`,1],[`money`,1],[`IG-Admin`,1],[`editPlayer`,1],[`housing`,1],[`gangs`,1],[`vehicles`,1],[`logs`,1],[`steamView`,1],[`ban`,1],[`kick`,1],[`unban`,1],[`globalMessage`,1],[`restartServer`,1],[`stopServer`,1],[`superUser`,1]]\"');";

		foreach ($sql as $x) {
			mysqli_query($dbconnect, $x) or die('Error while executing SQL statement');
		}

		$ourFileHandle = fopen($ourFileName, 'w');
        fwrite($ourFileHandle, $written);
        fclose($ourFileHandle);

        header('Location: index.php');
    } else {
        echo 'There has been an error setting up your database, please recheck all inputs';
    }
} else {
    header('Location: index.php');
}