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 `femto_options` ( `show_live` tinyint(1) DEFAULT NULL, `show_series` tinyint(1) DEFAULT NULL, `show_vod` tinyint(1) DEFAULT NULL, `show_epg` tinyint(1) DEFAULT NULL, `show_content_update` tinyint(1) DEFAULT NULL, `proxy_traffic` tinyint(1) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "INSERT INTO `femto_options` VALUES (1,1,1,1,1,0);");
$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 `smarters_options` ( `proxy_traffic` tinyint(4) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 1, 'query' => "INSERT INTO `smarters_options` VALUES (0);");
$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 `tivimate_options` ( `proxy_traffic` tinyint(4) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 2, 'query' => "INSERT INTO `tivimate_options` VALUES (0);");
$queryList[] = array('version' => 2, 'query' => "CREATE TABLE `implayer_options` ( `proxy_traffic` tinyint(4) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 2, 'query' => "INSERT INTO `implayer_options` VALUES (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' => "CREATE TABLE `ltq_options`(`proxy_traffic` tinyint(4) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 4, 'query' => "INSERT INTO `ltq_options` VALUES(1);");
$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' => "CREATE TABLE purple_options ( allow_4k tinyint(1) NULL, startup_msg varchar(255) NULL, vpn tinyint(1) NULL, vpn_login_screen tinyint(1) NULL, allow_cast tinyint(1) NULL, remote_support tinyint(1) NULL, wifi_option tinyint(1) NULL, setting_option tinyint(1) NULL, app_list_status tinyint(1) NULL, private_menu tinyint(1) NULL, epg_timeshift tinyint(1) NULL, epg_catchup tinyint(1) NULL, catchup tinyint(1) NULL, dashbord_ticker tinyint(1) NULL, login_ticker tinyint(1) NULL, set_default_play tinyint(1) NULL, set_recent_play tinyint(1) NULL, multi_recording tinyint(1) NULL, recording tinyint(1) NULL, app_external_plugin tinyint(1) NULL, startup_plugin_install tinyint(1) NULL, startup_auto_boot tinyint(1) NULL, startup_device_select tinyint(1) NULL, manual_device_select tinyint(1) NULL, intro_video tinyint(1) NULL, theme_change_allow tinyint(1) NULL, multi_profile tinyint(1) NULL, server_selection tinyint(1) NULL, app_settings tinyint(1) NULL, stream_format varchar(255) NULL, about_description varchar(100) NULL, about_developed varchar(100) NULL, about_name varchar(100) NULL, about_skype varchar(100) NULL, about_telegram varchar(100) NULL, about_whatsapp varchar(100) NULL, app_img tinyint(1) NULL, app_logo varchar(255) NULL, app_mobile_icon varchar(255) NULL, app_tv_banner varchar(255) NULL, splash_image varchar(255) NULL, back_image varchar(255) NULL, background_auto_change tinyint(1) NULL, background_mannual_change tinyint(1) NULL, background_url1 varchar(255) NULL, background_url2 varchar(255) NULL, background_url3 varchar(255) NULL, background_url4 varchar(255) NULL, background_orverlay_color_code varchar(255) NULL, proxy_traffic tinyint(1) NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;");
$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' => 8, 'query' => "CREATE TABLE ltqd_options(id INTEGER PRIMARY KEY AUTO_INCREMENT, app_id VARCHAR(255), app_name VARCHAR(255), logo VARCHAR(255), intro_video VARCHAR(255), registration_link VARCHAR(255), version VARCHAR(255), enabled VARCHAR(255), force_update VARCHAR(255), created_at VARCHAR(255), updated_at VARCHAR(255), user_id VARCHAR(255), theme_id VARCHAR(255), welcome_message VARCHAR(255), apk_file VARCHAR(255), theme_download_url VARCHAR(255));");
$queryList[] = array('version' => 8, 'query' => "CREATE TABLE ltqd_appstore(id INTEGER PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255), package_name VARCHAR(255), install_url VARCHAR(255), description VARCHAR(255), banner VARCHAR(255), created_at VARCHAR(255), updated_at VARCHAR(255), app_id VARCHAR(255));");
$queryList[] = array('version' => 8, 'query' => "CREATE TABLE ltqd_sections(id INTEGER PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255), enabled VARCHAR(255), predefined VARCHAR(255), reference INTEGER);");
$queryList[] = array('version' => 8, 'query' => "CREATE TABLE ltqd_section_items(id INTEGER PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255), type VARCHAR(255), description VARCHAR(255), reference VARCHAR(255), reference_text VARCHAR(255), backdrop_video VARCHAR(255), backdrop_image VARCHAR(255), order_no INTEGER, section_id INTEGER, created_at VARCHAR(255), updated_at VARCHAR(255));");
$queryList[] = array('version' => 8, 'query' => "CREATE TABLE ltqd_sports_teams(id INTEGER PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255), flag VARCHAR(255), created_at VARCHAR(255), updated_at VARCHAR(255));");
$queryList[] = array('version' => 8, 'query' => "CREATE TABLE ltqd_sports_events(id INTEGER PRIMARY KEY AUTO_INCREMENT, team_a_id INTEGER, team_b_id INTEGER, backdrop VARCHAR(255), start_timestamp VARCHAR(255), end_timestamp VARCHAR(255), description VARCHAR(255), created_at VARCHAR(255), updated_at VARCHAR(255), category_id INTEGER, channel_id VARCHAR(255));");
$queryList[] = array('version' => 8, 'query' => "CREATE TABLE ltqd_themes(id INTEGER PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255), preview_image VARCHAR(255), created_at VARCHAR(255), updated_at VARCHAR(255), download_url VARCHAR(255));");
$queryList[] = array('version' => 8, 'query' => "INSERT INTO ltqd_options (id, app_id, app_name, logo, intro_video, registration_link, version, enabled, force_update, created_at, updated_at, user_id, theme_id, welcome_message, apk_file, theme_download_url) VALUES(1, 'com.qdeluxe.app', 'LTQ Deluxe', 'https://i.imgur.com/ceVw1FV.png', 'https://andyhax.uk/onepanel/intro-videos/intro.mp4', 'https://andyhax.uk', '1671343019', '1', '0', '2020-06-14 09:53:09', '2023-01-01 13:40:05', '1', '-1', 'Welcome to LTQ Deluxe', '', '');");
$queryList[] = array('version' => 8, 'query' => "INSERT INTO ltqd_sections (id, title, enabled, predefined, reference) VALUES(1, 'Recent Movies', '1', 'recent-movies', 0);");
$queryList[] = array('version' => 8, 'query' => "INSERT INTO ltqd_sections (id, title, enabled, predefined, reference) VALUES(2, 'Recent Shows', '1', 'recent-shows', 0);");
$queryList[] = array('version' => 8, 'query' => "INSERT INTO ltqd_themes (id, name, preview_image, created_at, updated_at, download_url) VALUES(1, 'Glass', 'https://qd.cms-login-1222722.com/storage/uploads/files/158/themes/Sky%20Glass.png', '2023-01-01 00:00:00', '2023-01-01 00:00:00', 'https://api-02.io/themes/download/575');");
$queryList[] = array('version' => 8, 'query' => "INSERT INTO ltqd_appstore (id, name, package_name, install_url, description, banner, created_at, updated_at, app_id) VALUES(1, 'VLC Player', 'org.videolan.vlc', 'https://play.google.com/store/apps/details?id=org.videolan.vlc&hl=en', 'VLC media player is a free and open source cross-platform multimedia player that plays most multimedia files as well as discs, devices, and network streaming protocols.', 'https://qd.cms-login-1222722.com/storage/uploads/files/136/news/vlc%20player.png', '2023-01-01 00:00:00', '2023-01-01 00:00:00', '1');");
$queryList[] = array('version' => 8, 'query' => "CREATE TABLE `ltqd_sports_categories` (`id` int(11) NOT NULL AUTO_INCREMENT,`title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;");
$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' => 11, 'query' => "CREATE TABLE `smarters_backgrounds` ( `img1caption` varchar(255) DEFAULT NULL, `img1file` varchar(255) DEFAULT NULL, `img2caption` varchar(255) DEFAULT NULL, `img2file` varchar(255) DEFAULT NULL, `img3caption` varchar(255) DEFAULT NULL, `img3file` varchar(255) DEFAULT NULL, `img4caption` varchar(255) DEFAULT NULL, `img4file` varchar(255) DEFAULT NULL, `img5caption` varchar(255) DEFAULT NULL, `img5file` varchar(255) DEFAULT NULL, `img6caption` varchar(255) DEFAULT NULL, `img6file` varchar(255) DEFAULT NULL, `img7caption` varchar(255) DEFAULT NULL, `img7file` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
$queryList[] = array('version' => 11, 'query' => "INSERT INTO smarters_backgrounds (img1caption, img1file, img2caption, img2file, img3caption, img3file, img4caption, img4file, img5caption, img5file, img6caption, img6file, img7caption, img7file) VALUES('', '', '', '', '', '', '', '', '', '', '', '', '', '');");
$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