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, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "CREATE TABLE `dns_sessions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dns_id` int(11) DEFAULT NULL, `date_added` datetime DEFAULT NULL, `last_used` datetime DEFAULT NULL, `username` varchar(100) 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 `intro` ( `path` varchar(255) DEFAULT NULL, `active` tinyint(1) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "INSERT INTO `intro` VALUES ('intro.mp4',1);");
$queryList[] = array('version' => 1, 'query' => "CREATE TABLE `notifications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `notification_text` text, `active` tinyint(1) DEFAULT NULL, `notification_title` varchar(255) DEFAULT NULL, `date_added` datetime 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 `vpn` (`id` int(11) NOT NULL AUTO_INCREMENT, `location` varchar(100) DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `active` tinyint(1) DEFAULT NULL, `auth_type` varchar(100) DEFAULT NULL, `username` varchar(100) DEFAULT NULL, `password` varchar(100) DEFAULT NULL, `date_added` datetime DEFAULT NULL, `auth_embedded` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "CREATE TABLE `xciptv_options` ( `app_name` varchar(100) DEFAULT NULL, `app_build` varchar(100) DEFAULT NULL, `app_identifier` varchar(100) DEFAULT NULL, `login_type` varchar(100) DEFAULT NULL, `login_accounts_button` tinyint(1) DEFAULT NULL, `log_settings_button` tinyint(1) DEFAULT NULL, `announcements` tinyint(1) DEFAULT NULL, `messages` tinyint(1) DEFAULT NULL, `update_user_info` tinyint(1) DEFAULT NULL, `developer_name` varchar(100) DEFAULT NULL, `developer_contact` varchar(100) DEFAULT NULL, `signup_url` varchar(255) DEFAULT NULL, `login_logo` tinyint(1) DEFAULT NULL, `app_logs` tinyint(1) DEFAULT NULL, `category_count` tinyint(1) DEFAULT NULL, `user_agent` varchar(255) DEFAULT NULL, `load_last_channel` tinyint(1) DEFAULT NULL, `show_live` tinyint(1) DEFAULT NULL, `show_epg` tinyint(1) DEFAULT NULL, `show_vod` tinyint(1) DEFAULT NULL, `show_series` tinyint(1) DEFAULT NULL, `show_catchup` tinyint(1) DEFAULT NULL, `show_radio` tinyint(1) DEFAULT NULL, `show_multi` tinyint(1) DEFAULT NULL, `show_favorite` tinyint(1) DEFAULT NULL, `show_account` tinyint(1) DEFAULT NULL, `show_reminders` tinyint(1) DEFAULT NULL, `show_record` tinyint(1) DEFAULT NULL, `show_vpn` tinyint(1) DEFAULT NULL, `show_message` tinyint(1) DEFAULT NULL, `show_update` tinyint(1) DEFAULT NULL, `show_expiry` tinyint(1) DEFAULT NULL, `exo_buffer` varchar(100) DEFAULT NULL, `exo_zoom` varchar(100) DEFAULT NULL, `exo_hw` tinyint(1) DEFAULT NULL, `exo_subtitles` tinyint(1) DEFAULT NULL, `exo_volume` varchar(100) DEFAULT NULL, `vlc_buffer` varchar(100) DEFAULT NULL, `vlc_zoom` varchar(100) DEFAULT NULL, `vlc_hw` tinyint(1) DEFAULT NULL, `vlc_subtitles` tinyint(1) DEFAULT NULL, `vlc_volume` varchar(100) DEFAULT NULL, `player_live` varchar(100) DEFAULT NULL, `player_epg` varchar(100) DEFAULT NULL, `player_vod` varchar(100) DEFAULT NULL, `player_series` varchar(100) DEFAULT NULL, `proxy_traffic` tinyint(1) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "INSERT INTO `xciptv_options` VALUES ('XCIPTV','803','521064','login',1,1,1,1,1,'AndyHax','AndyHax','',1,1,1,'XCIPTV',1,1,1,1,1,0,0,1,1,1,0,1,1,1,1,1,'40000','3',1,0,'100','3000','3',1,0,'100','EXO','EXO','EXO','EXO',0);");
$queryList[] = array('version' => 2, 'query' => "CREATE TABLE `config` (`dbversion` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 2, 'query' => "INSERT INTO `config` VALUES (2);");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE xciptv_options ADD theme varchar(100) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE xciptv_options ADD licv4_method int NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE xciptv_options ADD licv3_key varchar(100) NULL;");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE xciptv_options ADD licv3_iv varchar(100) NULL;");
$queryList[] = array('version' => 4, 'query' => "UPDATE xciptv_options SET theme = 'd', licv4_method = 1, licv3_key = 'mysecretkeywsdef', licv3_iv = 'myuniqueivparamu';");
$queryList[] = array('version' => 4, 'query' => "ALTER TABLE config ADD panel_root varchar(255) NULL;");
$queryList[] = array('version' => 5, 'query' => "CREATE TABLE `messages` (`id` int(11) NOT NULL AUTO_INCREMENT,`text` text,`active` tinyint(1) DEFAULT NULL,`user` varchar(255) DEFAULT NULL,`date_added` datetime DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 6, 'query' => "CREATE TABLE `sports_options` (api_key varchar(100) NULL,header_name varchar(100) NULL,border_colour varchar(100) NULL,background_colour varchar(100) NULL,text_colour varchar(100) NULL)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;");
$queryList[] = array('version' => 6, 'query' => "INSERT INTO sports_options (api_key, header_name, border_colour, background_colour, text_colour) VALUES('1', '', '#000000', '#000000', '#FFFFFF');");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_catchup2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_catchup3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_catchup4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_catchup5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_live2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_live3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_live4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_live5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_epg2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_epg3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_epg4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_epg5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_vod2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_vod3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_vod4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_vod5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_series2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_series3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_series4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_series5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_catchup2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_catchup3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_catchup4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_catchup5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_radio2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_radio3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_radio4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_radio5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_multi2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_multi3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_multi4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_multi5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_favorite2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_favorite3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_favorite4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_favorite5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_account2 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_account3 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_account4 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 6, 'query' => "ALTER TABLE xciptv_options ADD show_account5 tinyint(1) DEFAULT 1;");
$queryList[] = array('version' => 7, 'query' => "INSERT INTO purple_options (allow_4k, startup_msg, vpn, vpn_login_screen, allow_cast, remote_support, wifi_option, setting_option, app_list_status, private_menu, epg_timeshift, epg_catchup, catchup, dashbord_ticker, login_ticker, set_default_play, set_recent_play, multi_recording, recording, app_external_plugin, startup_plugin_install, startup_auto_boot, startup_device_select, manual_device_select, intro_video, theme_change_allow, multi_profile, server_selection, app_settings, stream_format, about_description, about_developed, about_name, about_skype, about_telegram, about_whatsapp, app_img, app_logo, app_mobile_icon, app_tv_banner, splash_image, back_image, background_auto_change, background_mannual_change, background_url1, background_url2, background_url3, background_url4,background_orverlay_color_code, proxy_traffic) VALUES(1, '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '', '', '', '', '', '', '', 1, '', '', '', '', '', 1, 1, '', '', '', '','',0);");
$queryList[] = array('version' => 9, 'query' => "ALTER TABLE vpn ADD country varchar(255) NULL;");
$queryList[] = array('version' => 9, 'query' => "ALTER TABLE xciptv_options ADD support_email varchar(255) NULL;");
$queryList[] = array('version' => 9, 'query' => "ALTER TABLE xciptv_options ADD support_phone varchar(255) NULL;");
$queryList[] = array('version' => 10, 'query' => "ALTER TABLE xciptv_options ADD app_language varchar(100) NULL;");
$queryList[] = array('version' => 10, 'query' => "UPDATE xciptv_options SET app_language = 'en';");
$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) {
$message = "OnePanel is ready to install to database $dbname, click GO to build the database";
$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