CREATE TABLE `settings` (
`id` int(11) NOT NULL,
`bouquet_name` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`live_streaming_pass` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`email_verify_sub` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`email_verify_cont` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`email_forgot_sub` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`email_forgot_cont` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`mail_from` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`smtp_host` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`smtp_port` int(11) NOT NULL,
`min_password` int(11) NOT NULL DEFAULT '5',
`username_strlen` int(11) NOT NULL DEFAULT '15',
`username_alpha` int(11) NOT NULL DEFAULT '1',
`allow_multiple_accs` int(11) NOT NULL DEFAULT '0',
`allow_registrations` int(11) NOT NULL DEFAULT '0',
`server_name` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`smtp_username` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`smtp_password` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`email_new_pass_sub` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`logo_url` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`email_new_pass_cont` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`smtp_from_name` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`confirmation_email` int(11) NOT NULL,
`smtp_encryption` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`unique_id` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`copyrights_removed` tinyint(4) NOT NULL,
`copyrights_text` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
`default_timezone` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Europe/Athens',
`default_locale` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en_GB.utf8',
`allowed_stb_types` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a:6:{i:0;s:6:"mag245";i:1;s:6:"mag250";i:2;s:6:"mag255";i:3;s:6:"mag254";i:4;s:6:"mag260";i:5;s:6:"aurahd";} ',
`client_prebuffer` int(11) NOT NULL,
`split_clients` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`stream_max_analyze` int(11) NOT NULL DEFAULT '30',
`show_not_on_air_video` tinyint(4) NOT NULL,
`not_on_air_video_path` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`show_banned_video` tinyint(4) NOT NULL,
`banned_video_path` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`show_expired_video` tinyint(4) NOT NULL,
`expired_video_path` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`mag_container` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`probesize` int(11) NOT NULL DEFAULT '5000000',
`allowed_ips_admin` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
`block_svp` tinyint(4) NOT NULL DEFAULT '0',
`allow_countries` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`user_auto_kick_hours` int(11) NOT NULL DEFAULT '0',
`show_in_red_online` int(11) NOT NULL DEFAULT '0',
`disallow_empty_user_agents` tinyint(4) DEFAULT '0',
`show_all_category_mag` tinyint(4) NOT NULL DEFAULT '1',
`default_lang` mediumtext COLLATE utf8_unicode_ci,
`autobackup_status` int(11) NOT NULL DEFAULT '0',
`autobackup_pass` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`flood_limit` int(11) NOT NULL DEFAULT '0',
`flood_ips_exclude` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
`reshare_deny_addon` tinyint(4) NOT NULL DEFAULT '0',
`restart_http` tinyint(4) NOT NULL DEFAULT '0',
`css_layout` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`flood_seconds` int(11) NOT NULL DEFAULT '5',
`flood_max_attempts` int(11) NOT NULL DEFAULT '1',
`flood_apply_clients` int(11) NOT NULL DEFAULT '1',
`flood_apply_restreamers` int(11) NOT NULL DEFAULT '0',
`backup_source_all` int(11) NOT NULL DEFAULT '0',
`flood_get_block` int(11) NOT NULL DEFAULT '0',
`portal_block` int(11) NOT NULL DEFAULT '0',
`streaming_block` int(11) NOT NULL DEFAULT '0',
`stream_start_delay` int(11) NOT NULL DEFAULT '20000',
`hash_lb` tinyint(4) NOT NULL DEFAULT '1',
`vod_bitrate_plus` int(11) NOT NULL DEFAULT '60',
`read_buffer_size` int(11) NOT NULL DEFAULT '8192',
`tv_channel_default_aspect` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fit',
`playback_limit` int(11) NOT NULL DEFAULT '3',
`show_tv_channel_logo` tinyint(4) NOT NULL DEFAULT '1',
`show_channel_logo_in_preview` tinyint(4) NOT NULL DEFAULT '1',
`enable_connection_problem_indication` tinyint(4) NOT NULL DEFAULT '1',
`enable_pseudo_hls` tinyint(4) NOT NULL DEFAULT '1',
`vod_limit_at` int(11) NOT NULL DEFAULT '0',
`client_area_plugin` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'flow',
`persistent_connections` tinyint(4) NOT NULL DEFAULT '0',
`record_max_length` int(11) NOT NULL DEFAULT '180',
`total_records_length` int(11) NOT NULL DEFAULT '600',
`max_local_recordings` int(11) NOT NULL DEFAULT '10',
`allowed_stb_types_for_local_recording` text COLLATE utf8_unicode_ci NOT NULL,
`allowed_stb_types_rec` text COLLATE utf8_unicode_ci NOT NULL,
`show_captcha` int(11) NOT NULL DEFAULT '1',
`dynamic_timezone` tinyint(4) NOT NULL DEFAULT '1',
`stalker_theme` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'digital',
`rtmp_random` tinyint(4) NOT NULL DEFAULT '1',
`api_ips` text COLLATE utf8_unicode_ci NOT NULL,
`crypt_load_balancing` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`use_buffer` tinyint(4) NOT NULL DEFAULT '0',
`restreamer_prebuffer` tinyint(4) NOT NULL DEFAULT '0',
`audio_restart_loss` tinyint(4) NOT NULL DEFAULT '0',
`stalker_lock_images` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`channel_number_type` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'bouquet',
`stb_change_pass` tinyint(4) NOT NULL DEFAULT '0',
`enable_debug_stalker` tinyint(4) NOT NULL DEFAULT '0',
`online_capacity_interval` smallint(6) NOT NULL DEFAULT '10',
`always_enabled_subtitles` tinyint(4) NOT NULL DEFAULT '1',
`test_download_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`xc_support_allow` tinyint(4) NOT NULL DEFAULT '1',
`e2_arm7a` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`e2_mipsel` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`e2_mips32el` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`e2_sh4` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`e2_arm` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`api_pass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`message_of_day` text COLLATE utf8_unicode_ci NOT NULL,
`double_auth` tinyint(4) NOT NULL DEFAULT '0',
`mysql_remote_sec` tinyint(4) NOT NULL DEFAULT '0',
`enable_isp_lock` tinyint(4) NOT NULL DEFAULT '0',
`show_isps` tinyint(4) NOT NULL DEFAULT '1',
`userpanel_mainpage` longtext COLLATE utf8_unicode_ci NOT NULL,
`save_closed_connection` tinyint(4) NOT NULL DEFAULT '1',
`client_logs_save` tinyint(4) NOT NULL DEFAULT '1',
`get_real_ip_client` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`case_sensitive_line` tinyint(4) NOT NULL DEFAULT '1',
`county_override_1st` tinyint(4) NOT NULL DEFAULT '0',
`disallow_2nd_ip_con` tinyint(4) NOT NULL DEFAULT '0',
`firewall` tinyint(4) NOT NULL DEFAULT '0',
`new_sorting_bouquet` tinyint(4) NOT NULL DEFAULT '1',
`split_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'con',
`use_mdomain_in_lists` tinyint(4) NOT NULL DEFAULT '0',
`use_https` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`priority_backup` TINYINT NOT NULL DEFAULT '0',
`use_buffer_table` TINYINT NOT NULL DEFAULT '0',
`tmdb_api_key` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
`toggle_menu` TINYINT NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `settings` VALUES (1,'Example','fU1hMKib947EqNDKFDnM','Verify Registration @ {SERVER_NAME}','Hello,<p><br></p><p>Please Click at the following URL to activate your account {VERIFY_LINK}</p><p><br></p><p>{SERVER_NAME} Team</p><p>Thank you</p>','Forgot Password @ {SERVER_NAME}','Hello,<p><br></p><p>Someone requested new password @ {SERVER_NAME} . To verify this request please click at the following link: {FORGOT_LINK}<br></p><p><br></p><p>{SERVER_NAME} Team</p><p>Thank you</p>','[email protected]','',0,5,15,1,0,0,'My Streaming Server','','','Your New Password @ {SERVER_NAME}','https://cms.xtream-codes.com/images/logo.png','Hello,<p><br></p><p>Your New Password is: {NEW_PASSWORD}<br></p><p><br></p><p>{SERVER_NAME} Team</p><p>Thank you</p>','',0,'','HsnchQ8mdb',0,'','Europe/Athens','en_GB.utf8','[\"MAG200\",\"MAG351\",\"MAG352\",\"MAG245\",\"MAG245D\",\"MAG250\",\"MAG254\",\"MAG255\",\"MAG256\",\"MAG257\",\"MAG260\",\"MAG270\",\"MAG275\",\"AuraHD\",\"WR320\"]',20,'equal',5000000,0,'',0,'',0,'','ts',5000000,'',0,'[\"A1\",\"A2\",\"O1\",\"AF\",\"AX\",\"AL\",\"DZ\",\"AS\",\"AD\",\"AO\",\"AI\",\"AQ\",\"AG\",\"AR\",\"AM\",\"AW\",\"AU\",\"AT\",\"AZ\",\"BS\",\"BH\",\"BD\",\"BB\",\"BY\",\"BE\",\"BZ\",\"BJ\",\"BM\",\"BT\",\"BO\",\"BA\",\"BW\",\"BV\",\"BR\",\"IO\",\"BN\",\"BG\",\"BF\",\"BI\",\"KH\",\"CM\",\"CA\",\"CV\",\"KY\",\"CF\",\"TD\",\"CL\",\"CN\",\"CX\",\"CC\",\"CO\",\"KM\",\"CG\",\"CD\",\"CK\",\"CR\",\"CI\",\"HR\",\"CU\",\"CW\",\"CY\",\"CZ\",\"DK\",\"DJ\",\"DM\",\"DO\",\"EC\",\"EG\",\"SV\",\"GQ\",\"ER\",\"EE\",\"ET\",\"EU\",\"FK\",\"FO\",\"FJ\",\"FI\",\"FR\",\"GF\",\"PF\",\"TF\",\"MK\",\"GA\",\"GM\",\"GE\",\"DE\",\"GH\",\"GI\",\"GR\",\"GL\",\"GD\",\"GP\",\"GU\",\"GT\",\"GG\",\"GN\",\"GW\",\"GY\",\"HT\",\"HM\",\"VA\",\"HN\",\"HK\",\"HU\",\"IS\",\"IN\",\"ID\",\"IR\",\"IQ\",\"IE\",\"IM\",\"IL\",\"IT\",\"JM\",\"JP\",\"JE\",\"JO\",\"KZ\",\"KE\",\"KI\",\"KR\",\"KV\",\"KW\",\"KG\",\"LA\",\"LV\",\"LB\",\"LS\",\"LR\",\"LY\",\"LI\",\"LT\",\"LU\",\"MO\",\"MG\",\"MW\",\"MY\",\"MV\",\"ML\",\"MT\",\"MH\",\"MQ\",\"MR\",\"MU\",\"YT\",\"MX\",\"FM\",\"MD\",\"MC\",\"MN\",\"ME\",\"MS\",\"MA\",\"MZ\",\"MM\",\"NA\",\"NR\",\"NP\",\"NL\",\"AN\",\"NC\",\"NZ\",\"NI\",\"NE\",\"NG\",\"NU\",\"NF\",\"MP\",\"NO\",\"OM\",\"PK\",\"PW\",\"PS\",\"PA\",\"PG\",\"PY\",\"PE\",\"PH\",\"PN\",\"PL\",\"PT\",\"PR\",\"QA\",\"RE\",\"RO\",\"RU\",\"RW\",\"BL\",\"SH\",\"KN\",\"LC\",\"MF\",\"PM\",\"VC\",\"WS\",\"SM\",\"ST\",\"SA\",\"SN\",\"RS\",\"SC\",\"SL\",\"SG\",\"SK\",\"SI\",\"SB\",\"SO\",\"ZA\",\"GS\",\"ES\",\"LK\",\"SD\",\"SR\",\"SJ\",\"SZ\",\"SE\",\"SX\",\"CH\",\"SY\",\"TW\",\"TJ\",\"TZ\",\"TH\",\"TL\",\"TG\",\"TK\",\"TO\",\"TT\",\"TN\",\"TR\",\"TM\",\"TC\",\"TV\",\"UG\",\"UA\",\"AE\",\"GB\",\"US\",\"UM\",\"UY\",\"UZ\",\"VU\",\"VE\",\"VN\",\"VG\",\"VI\",\"WF\",\"EH\",\"YE\",\"ZM\",\"ZW\"]',0,3,0,1,'English',1,'pqrieWjEGtJuAevKAjDkwlKTAHBNCcotTeFfDTqKZlr6TxYvx8tWA84vVHt/qblRVJjVy4sEXhtq3Ogij/OFhHmqsrV9nPhWQByMALnPIEcK1ct50NwkwYDHF398dMTo|2Ihp9SQRQw4vP50RouyOxDq6E5OxDwunmGZ2FW8+0fc=',120,'',0,0,'light',1,3,0,0,0,0,0,0,0,1,6000,8192,'exp',3,1,1,1,1,0,'vlc',1,180,600,10,'[\"MAG255\",\"MAG256\",\"MAG257\"]','null',0,1,'emerald',1,'','3Fb1Bfi9f46qgnZBJHnp',0,0,0,'null','bouquet',0,0,10,1,'',0,'','','','','','','',1,0,0,1,'[]',1,1,'',1,0,0,0,1,'con',0,'',0,0,'',0);
