1, 'query' => "CREATE TABLE `ads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `path` varchar(100) DEFAULT NULL, `active` tinyint(1) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "CREATE TABLE `dns` ( `id` int(11) NOT NULL AUTO_INCREMENT, `url` varchar(255) DEFAULT NULL, `active` tinyint(1) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `username` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `password_hash` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "CREATE TABLE `config` (`dbversion` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "INSERT INTO `config` VALUES (2);");
$queryList[] = array('version' => 1, 'query' => "ALTER TABLE config ADD panel_root varchar(255) NULL;");
$queryList[] = array('version' => 2, 'query' => "CREATE TABLE `ibo_settings` ( `welcome_header` varchar(255) DEFAULT NULL, `welcome_text` varchar(255) DEFAULT NULL, `theme1_name` varchar(100) DEFAULT NULL, `theme1_background` varchar(255) DEFAULT NULL, `theme2_name` varchar(100) DEFAULT NULL, `theme2_background` varchar(255) DEFAULT NULL, `theme3_name` varchar(100) DEFAULT NULL, `theme3_background` varchar(255) DEFAULT NULL, `theme4_name` varchar(100) DEFAULT NULL, `theme4_background` varchar(255) DEFAULT NULL, `theme5_name` varchar(100) DEFAULT NULL, `theme5_background` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 2, 'query' => "CREATE TABLE `ibo_users` ( `dns_id` int(11) NOT NULL, `mac_address` varchar(100) NOT NULL, `username` varchar(100) DEFAULT NULL, `password` varchar(100) DEFAULT NULL, PRIMARY KEY (`dns_id`,`mac_address`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 2, 'query' => "INSERT INTO ibo_settings (welcome_header, welcome_text, theme1_name, theme1_background, theme2_name, theme2_background, theme3_name, theme3_background, theme4_name, theme4_background, theme5_name) VALUES('', '', '', '', '', '', '', '', '', '', '');");
$queryList[] = array('version' => 3, 'query' => "CREATE TABLE `hax_sports_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `league_id` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ");
$queryList[] = array('version' => 3, 'query' => "CREATE TABLE `hax_sports_event_channels` ( `id` int(11) NOT NULL AUTO_INCREMENT, `event_id` int(11) NOT NULL, `channel_name` varchar(255) DEFAULT NULL, `channel_epg` varchar(255) DEFAULT NULL, `channel_logo` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ");
$queryList[] = array('version' => 3, 'query' => "CREATE TABLE `hax_sports_events` ( `id` int(11) NOT NULL AUTO_INCREMENT, `team_a_id` int(11) DEFAULT NULL, `team_b_id` int(11) DEFAULT NULL, `backdrop` varchar(255) DEFAULT NULL, `start_timestamp` varchar(255) DEFAULT NULL, `end_timestamp` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `created_at` varchar(255) DEFAULT NULL, `updated_at` varchar(255) DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `channel_id` varchar(255) DEFAULT NULL, `league_id` int(11) DEFAULT NULL, `update_hash` varchar(100) DEFAULT NULL, `event_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ");
$queryList[] = array('version' => 3, 'query' => "CREATE TABLE `hax_sports_teams` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `flag` varchar(255) DEFAULT NULL, `created_at` varchar(255) DEFAULT NULL, `updated_at` varchar(255) DEFAULT NULL, `league_id` int(11) DEFAULT NULL, `update_hash` varchar(100) DEFAULT NULL, `team_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad1_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad2_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad3_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad4_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad5_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad6_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad7_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad8_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad9_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad10_image varchar(255) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE ibo_settings ADD ad_duration int(11) NULL;");
$queryList[] = array('version' => 4, 'query' => "UPDATE ibo_settings SET ad_duration = 10");
$queryList[] = array('version' => 100000, 'query' => "UPDATE config SET dbversion = " . $expectedVersion . ";");
$randPass = randomPassword();
$hash = password_hash($randPass, PASSWORD_DEFAULT);
$queryList[] = array('version' => 1, 'query' => "INSERT INTO `users` (username, password_hash) VALUES ('admin', '" . $hash . "');");
if (!$isInstalled) {
$_SESSION['installmessage'] = "OnePanel has been installed. You can log in with the username admin and the password " . $randPass . "
Please make a note of this password now as it will disappear if the page is refreshed. You should change this once logged in";
} else {
$_SESSION['installmessage'] = "OnePanel has been updated";
}
//execute queries
foreach ($queryList as $query) {
if ($query['version'] > $insVersion) {
$mysqli->query($query['query']);
}
}
$query = $mysqli->prepare("UPDATE config SET panel_root = ?");
$query->bind_param("s", $_POST['onepanel_root']);
$query->execute();
header("Location: index.php");
exit;
}
function randomPassword()
{
$alphabet = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890';
$pass = array();
$alphaLength = strlen($alphabet) - 1;
for ($i = 0; $i < 10; $i++) {
$n = rand(0, $alphaLength);
$pass[] = $alphabet[$n];
}
return implode($pass);
}
$showButton = false;
if ($dbConnected) {
if (!$isInstalled) {
$headerText = "Install";
$message = "OnePanel is ready to install to database $dbname, click GO to build the database";
}
else
{
$headerText = "Upgrade";
$message = "OnePanel is ready to upgrade database $dbname, click GO to update the database. Your existing data will not be lost.";
}
$showButton = true;
} else {
$message = "OnePanel cannot connect to the database, please create an empty database and edit the includes/db.php file with the details, then refresh this page.";
}
?>
OnePanel IM