--
-- Host: localhost    Database: verlihub
-- ------------------------------------------------------


--
-- Table structure for table `SetupList`
--

CREATE TABLE `SetupList` (
  `file` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `var` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `val` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`file`,`var`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `SetupList`
--

INSERT INTO `SetupList` VALUES ('config','adv_conn_accept_num','100'),('config','adv_conn_accept_try','10'),('config','adv_conn_choose_timeout','10'),('config','adv_max_message_size','10240'),('config','adv_max_outbuf_size','1048576'),('config','adv_max_outfill_size','786432'),('config','adv_max_unblock_size','524288'),('config','adv_max_upload_kbps','131072,000000'),('config','adv_min_frequency','0,300000'),('config','adv_no_conn_delay','50'),('config','adv_no_read_delay','5'),('config','adv_no_read_try','100'),('config','adv_step_delay','50'),('config','adv_timer_conn_period','4'),('config','adv_timer_serv_period','1'),('config','allow_same_user','1'),('config','always_ask_password','0'),('config','autoreg_class','1'),('config','autounreg_class','1'),('config','ban_bypass_class','10'),('config','ban_extra_message',NULL),('config','bc_reply',NULL),('config','botinfo_report','0'),('config','cc_zone1',NULL),('config','cc_zone2',NULL),('config','cc_zone3',NULL),('config','chat_default_on','1'),('config','chatonly_bypass_class','3'),('config','classdif_download','10'),('config','classdif_kick','0'),('config','classdif_mcto','10'),('config','classdif_pm','10'),('config','classdif_reg','2'),('config','clone_det_tban_time','1800'),('config','clone_detect_count','0'),('config','clone_detect_report','1'),('config','cmd_start_op','+!/'),('config','cmd_start_user','+!/'),('config','default_password_encryption','1'),('config','delayed_chat','0'),('config','delayed_login','0'),('config','delayed_myinfo','1'),('config','delayed_ping','60'),('config','delayed_search','1'),('config','desc_insert_mode','0'),('config','desc_insert_vars',NULL),('config','dest_drop_chat','0'),('config','dest_regme_chat','0'),('config','dest_report_chat','0'),('config','detect_ctmtohub','1'),('config','disable_extjson','1'),('config','disable_me_cmd','0'),('config','disable_regme_cmd','0'),('config','disable_report_cmd','0'),('config','disable_usr_cmds','0'),('config','disable_zlib','1'),('config','dns_lookup','0'),('config','drop_invalid_key','0'),('config','extended_welcome_message','1'),('config','extra_listen_ports',''),('config','filter_lan_requests','0'),('config','hide_all_kicks','0'),('config','hide_msg_badctm','1'),('config','host_header','0'),('config','hub_category','Õîñòèíã https://firstbyte.ru/?from=5031  ñ çàùèòîé îò DDOS è îïòèìàëüíûìè öåíàìè'),('config','hub_desc','Ïîñëå âõîäà íà õàáå, ââåäèòå êîìàíäó /fav ÷òî áû äîáàâèòü õàá â èçáðàííûå. Ñïàñèáî =)'),('config','hub_encoding','CP1251'),('config','hub_failover_hosts',NULL),('config','hub_host','in.piter-hub.net.ru'),('config','hub_icon_url',NULL),('config','hub_logo_url',NULL),('config','hub_name','#Piter-Hub'),('config','hub_owner',NULL),('config','hub_security','PiterBot'),('config','hub_security_desc','Áîò óïðàâëÿþùèì õàáîì'),('config','hub_topic',NULL),('config','hub_version','1.2.0.7'),('config','hub_version_special',NULL),('config','hubfull_message',NULL),('config','hublist_host','hublist.te-home.net'),('config','hublist_port','2501'),('config','hublist_send_listhost','1'),('config','hublist_send_minshare','1'),('config','int_chat_ms','1000'),('config','int_flood_all_chat_limit','10'),('config','int_flood_all_chat_period','15'),('config','int_flood_all_mcto_limit','10'),('config','int_flood_all_mcto_period','15'),('config','int_flood_all_rctm_limit','200'),('config','int_flood_all_rctm_period','10'),('config','int_flood_all_search_limit','400'),('config','int_flood_all_search_period','5'),('config','int_flood_all_to_limit','10'),('config','int_flood_all_to_period','15'),('config','int_flood_chat_limit','5'),('config','int_flood_chat_period','10'),('config','int_flood_ctm_limit','300'),('config','int_flood_ctm_period','10'),('config','int_flood_extjson_limit','20'),('config','int_flood_extjson_period','60'),('config','int_flood_getinfo_limit','200'),('config','int_flood_getinfo_period','10'),('config','int_flood_in_limit','20'),('config','int_flood_in_period','60'),('config','int_flood_mcto_limit','5'),('config','int_flood_mcto_period','10'),('config','int_flood_myinfo_limit','20'),('config','int_flood_myinfo_period','60'),('config','int_flood_nicklist_limit','3'),('config','int_flood_nicklist_period','60'),('config','int_flood_ping_limit','5'),('config','int_flood_ping_period','60'),('config','int_flood_rctm_limit','300'),('config','int_flood_rctm_period','10'),('config','int_flood_search_limit','30'),('config','int_flood_search_period','60'),('config','int_flood_sr_limit','500'),('config','int_flood_sr_period','30'),('config','int_flood_to_limit','5'),('config','int_flood_to_period','10'),('config','int_flood_unknown_limit','10'),('config','int_flood_unknown_period','30'),('config','int_login','10'),('config','int_myinfo','60'),('config','int_nicklist','60'),('config','int_search','32'),('config','int_search_op','1'),('config','int_search_pas','48'),('config','int_search_reg','16'),('config','int_search_reg_pas','48'),('config','int_search_vip','8'),('config','ip_zone4_max',NULL),('config','ip_zone4_min',NULL),('config','ip_zone5_max',NULL),('config','ip_zone5_min',NULL),('config','ip_zone6_max',NULL),('config','ip_zone6_min',NULL),('config','listen_ip','0.0.0.0'),('config','listen_port','9000'),('config','log_level','0'),('config','mainchat_class','0'),('config','max_chat_lines','5'),('config','max_chat_msg','2048'),('config','max_class_check_clone','-1'),('config','max_class_int_login','2'),('config','max_class_proto_flood','2'),('config','max_class_same_user','0'),('config','max_class_self_repass','1'),('config','max_extra_admins','200'),('config','max_extra_cheefs','100'),('config','max_extra_ops','100'),('config','max_extra_pings','10'),('config','max_extra_regs','25'),('config','max_extra_vips','50'),('config','max_flood_counter_mcto','5'),('config','max_flood_counter_pm','5'),('config','max_len_extjson','1024'),('config','max_len_in','512'),('config','max_len_lock','256'),('config','max_len_myhuburl','128'),('config','max_len_myinfo','512'),('config','max_len_mynick','128'),('config','max_len_search','256'),('config','max_len_supports','512'),('config','max_len_version','64'),('config','max_mcto_msg','1024'),('config','max_message_size','10240'),('config','max_nick','64'),('config','max_outbuf_size','2097152'),('config','max_outfill_size','1310720'),('config','max_passive_sr','25'),('config','max_pm_msg','2048'),('config','max_share','0'),('config','max_share_ops','0'),('config','max_share_reg','0'),('config','max_share_vip','0'),('config','max_unblock_size','1835008'),('config','max_upload_kbps','2000000.000000'),('config','max_users','8000'),('config','max_users_from_ip','9'),('config','max_users_passive','-1'),('config','max_users0','6000'),('config','max_users1','1000'),('config','max_users2','1000'),('config','max_users3','1000'),('config','max_users4','1000'),('config','max_users5','1000'),('config','max_users6','1000'),('config','min_class_bc','4'),('config','min_class_bc_guests','4'),('config','min_class_bc_regs','4'),('config','min_class_bc_vips','4'),('config','min_class_redir','4'),('config','min_class_register','4'),('config','min_class_use_hub','0'),('config','min_class_use_hub_passive','0'),('config','min_frequency','0.300000'),('config','min_nick','3'),('config','min_search_chars','4'),('config','min_share','0'),('config','min_share_factor_passive','1.000000'),('config','min_share_ops','0'),('config','min_share_reg','0'),('config','min_share_use_hub','0'),('config','min_share_use_hub_reg','0'),('config','min_share_use_hub_vip','0'),('config','min_share_vip','0'),('config','mmdb_cache','1'),('config','mmdb_cache_mins','60'),('config','mmdb_conv_depth','2'),('config','mmdb_names_lang','ru'),('config','msg_replace_ban',NULL),('config','msg_welcome_admin',NULL),('config','msg_welcome_cheef',NULL),('config','msg_welcome_guest',NULL),('config','msg_welcome_master',NULL),('config','msg_welcome_op',NULL),('config','msg_welcome_reg',NULL),('config','msg_welcome_vip',NULL),('config','nick_chars','abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789()[]{}_-\r\n+=.ÀÁÂÃÄÅ¨ÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäå¸æçèéêëìíîïðñòóôõö÷øùúûüýþÿ,™®@=#^~/\\\'©*'),('config','nick_prefix',NULL),('config','nick_prefix_autoreg',NULL),('config','nick_prefix_cc','0'),('config','nick_prefix_nocase','0'),('config','nicklist_on_login','1'),('config','notify_gag_chats','1'),('config','notify_kicks_to_all','1'),('config','nullchars_report','1'),('config','opchat_class','3'),('config','opchat_desc','×àò äëÿ îïåðàòîðîâ'),('config','opchat_name','OpChat'),('config','oplist_class','3'),('config','optimize_userlist','0'),('config','password_min_len','6'),('config','plugin_mod_class','5'),('config','private_class','0'),('config','proto_flood_chat_action','3'),('config','proto_flood_ctm_action','3'),('config','proto_flood_extjson_action','3'),('config','proto_flood_getinfo_action','3'),('config','proto_flood_in_action','3'),('config','proto_flood_mcto_action','3'),('config','proto_flood_myinfo_action','3'),('config','proto_flood_nicklist_action','3'),('config','proto_flood_ping_action','3'),('config','proto_flood_rctm_action','3'),('config','proto_flood_report','1'),('config','proto_flood_report_locked','1'),('config','proto_flood_report_time','600'),('config','proto_flood_search_action','3'),('config','proto_flood_sr_action','3'),('config','proto_flood_tban_time','1800'),('config','proto_flood_to_action','3'),('config','proto_flood_unknown_action','3'),('config','pwd_tmpban','20'),('config','report_dns_lookup','0'),('config','report_pass_reset','1'),('config','report_user_country','1'),('config','same_flood_ban_time','900'),('config','search_number','1'),('config','send_crash_report','1'),('config','send_pass_request','0'),('config','send_user_info','0'),('config','send_user_ip','1'),('config','show_desc_len','-1'),('config','show_email','1'),('config','show_speed','1'),('config','show_tags','2'),('config','step_delay','50'),('config','tag_allow_none','1'),('config','tag_allow_passive','1'),('config','tag_allow_sock5','1'),('config','tag_allow_unknown','1'),('config','tag_max_hs_ratio','0.000000'),('config','tag_max_hubs','0'),('config','tag_max_version','-1.000000'),('config','tag_min_class_ignore','3'),('config','tag_min_hs_ratio','0.000000'),('config','tag_min_hubs','0'),('config','tag_min_hubs_op','0'),('config','tag_min_hubs_reg','0'),('config','tag_min_hubs_usr','0'),('config','tag_min_version','-1.000000'),('config','tag_sum_hubs','3'),('config','tban_kick','10800'),('config','tban_max','2592000'),('config','timeout_flush','30.000000'),('config','timeout_key','10,000000'),('config','timeout_login','600.000000'),('config','timeout_myinfo','40.000000'),('config','timeout_nick','30.000000'),('config','timeout_setpass','300.000000'),('config','timer_conn_period','4'),('config','timer_hublist_period','10800'),('config','timer_reloadcfg_period','300'),('config','timer_serv_period','1'),('config','tls_proxy_ip',''),('config','topic_mod_class','3'),('config','ul_portion','50'),('config','unknown_cmd_chat','0'),('config','use_hub_msg_time','0'),('config','use_penlist_cache','1'),('config','use_reglist_cache','0'),('config','use_search_filter','1'),('config','user_ip_class','3'),('config','wrongauthip_report','1'),('config','wrongip_message','1'),('config','wrongpass_message',NULL),('config','wrongpassword_report','1'),('config','zlib_compress_level','-1'),('config','zlib_min_len','100'),('pi_floodprot','bantime_on_flood','10800'),('pi_floodprot','max_conn_per_ip','55'),('pi_floodprot','max_users_per_ip','50'),('pi_isp','allow_all_connections','1'),('pi_isp','case_sensitive_nick_pattern','0'),('pi_isp','max_check_conn_class','2'),('pi_isp','max_check_isp_class','2'),('pi_isp','max_check_nick_class','0'),('pi_isp','max_insert_desc_class','2'),('pi_isp','msg_no_isp','You are not allowed to enter this hub. Your ISP is not allowed.'),('pi_isp','msg_share_less','Please share less!!'),('pi_isp','msg_share_more','Please share more!!'),('pi_isp','unit_max_share_bytes','1073741824'),('pi_isp','unit_min_share_bytes','1073741824'),('pi_lua','err_class','3'),('pi_lua','log_level','1'),('pi_python','log_level','1');

--
-- Table structure for table `banlist`
--

CREATE TABLE `banlist` (
  `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nick` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ban_type` tinyint(4) DEFAULT '0',
  `host` text COLLATE utf8_unicode_ci,
  `range_fr` bigint(32) DEFAULT NULL,
  `range_to` bigint(32) DEFAULT NULL,
  `date_start` int(11) DEFAULT '0',
  `date_limit` int(11) DEFAULT NULL,
  `last_hit` int(11) DEFAULT NULL,
  `nick_op` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reason` text COLLATE utf8_unicode_ci,
  `share_size` varchar(18) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note_op` text COLLATE utf8_unicode_ci,
  `note_usr` text COLLATE utf8_unicode_ci,
  UNIQUE KEY `ip` (`ip`,`nick`),
  KEY `nick_index` (`nick`),
  KEY `date_index` (`date_limit`),
  KEY `range_index` (`range_fr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `banlist`
--


--
-- Table structure for table `client_list`
--

CREATE TABLE `client_list` (
  `name` varchar(125) COLLATE utf8_unicode_ci NOT NULL,
  `tag_id` varchar(125) COLLATE utf8_unicode_ci NOT NULL,
  `min_version` decimal(8,5) NOT NULL DEFAULT '-1.00000',
  `max_version` decimal(8,5) NOT NULL DEFAULT '-1.00000',
  `ban` tinyint(1) NOT NULL DEFAULT '0',
  `enable` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `client_list`
--

INSERT INTO `client_list` VALUES ('AirDC++','AirDC++',-1.00000,-1.00000,0,1),('ApexDC++','ApexDC++',-1.00000,-1.00000,0,1),('DC Pro','DC:PRO',-1.00000,-1.00000,0,1),('DC++','++',-1.00000,-1.00000,0,1),('DDD++','DDD++',-1.00000,-1.00000,0,1),('DiCe++','DiCe++',-1.00000,-1.00000,0,1),('EiskaltDC++','EiskaltDC++',-1.00000,-1.00000,0,1),('FlylinkDC++','FlylinkDC++',-1.00000,-1.00000,0,1),('GreylinkDC++','GreylinkDC++',-1.00000,-1.00000,0,1),('GreylinkDC++ Mod','gl++',-1.00000,-1.00000,0,1),('IceDC++','IceDC++',-1.00000,-1.00000,0,1),('iDC++','iDC',-1.00000,-1.00000,0,1),('MLDonkey','MLDC',-1.00000,-1.00000,0,1),('NMDC','DC',-1.00000,-1.00000,0,1),('OperaDC','oDC',-1.00000,-1.00000,0,1),('OperaDC-2','o',-1.00000,-1.00000,0,1),('P2P','P2P',-1.00000,-1.00000,0,1),('Peers','Peers',-1.00000,-1.00000,0,1),('PeerWebDC++','PWDC++',-1.00000,-1.00000,0,1),('PeLinkDC++','pl++',-1.00000,-1.00000,0,1),('Pulse++K','Pulse++K',-1.00000,-1.00000,0,1),('RSX++','RSX++',-1.00000,-1.00000,0,1),('SharaDC','SharaDC',-1.00000,-1.00000,0,1),('Shareaza','Shareaza',-1.00000,-1.00000,0,1),('StrongDC++','StrgDC++',-1.00000,-1.00000,0,1),('StrongDC++ SQLite','SSQLite++',-1.00000,-1.00000,0,1),('Valknut','DCGUI',-1.00000,-1.00000,0,1),('zDC++','zDC++',-1.00000,-1.00000,0,1),('Zion++','Z++',-1.00000,-1.00000,0,1);

--
-- Table structure for table `conn_types`
--

CREATE TABLE `conn_types` (
  `identifier` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(64) COLLATE utf8_unicode_ci DEFAULT 'no description',
  `tag_min_slots` int(4) DEFAULT '0',
  `tag_max_slots` int(4) DEFAULT '0',
  `tag_min_limit` double DEFAULT '-1',
  `tag_min_ls_ratio` double DEFAULT '-1',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `conn_types`
--

INSERT INTO `conn_types` VALUES ('0.005','New style',0,0,-1,-1),('0.01','New style',0,0,-1,-1),('0.02','New style',0,0,-1,-1),('0.05','New style',0,0,-1,-1),('0.1','New style',0,0,-1,-1),('0.2','New style',0,0,-1,-1),('0.5','New style',0,0,-1,-1),('1','New style',0,0,-1,-1),('10','New style',0,0,-1,-1),('100','New style',0,0,-1,-1),('1000','New style',0,0,-1,-1),('2','New style',0,0,-1,-1),('20','New style',0,0,-1,-1),('28.8Kbps','Old style',0,0,-1,-1),('33.6Kbps','Old style',0,0,-1,-1),('5','New style',0,0,-1,-1),('50','New style',0,0,-1,-1),('56Kbps','Old style',0,0,-1,-1),('Cable','Old style',0,0,-1,-1),('default','Default settings for missing connection types',0,0,-1,-1),('DSL','Old style',0,0,-1,-1),('ISDN','Old style',0,0,-1,-1),('LAN(T1)','Old style',0,0,-1,-1),('LAN(T3)','Old style',0,0,-1,-1),('Microwave','Old style',0,0,-1,-1),('Modem','Old style',0,0,-1,-1),('Satellite','Old style',0,0,-1,-1),('Wireless','Old style',0,0,-1,-1);

--
-- Table structure for table `custom_redirects`
--

CREATE TABLE `custom_redirects` (
  `address` varchar(125) COLLATE utf8_unicode_ci NOT NULL,
  `flag` smallint(5) NOT NULL,
  `enable` tinyint(1) DEFAULT '1',
  `start` tinyint(2) NOT NULL,
  `stop` tinyint(2) NOT NULL,
  PRIMARY KEY (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `custom_redirects`
--

INSERT INTO `custom_redirects` VALUES ('dc.dcmagnet.ru',0,1,0,0),('dc.megalive.su',0,1,0,0),('hub.verlihub.net:7777',0,0,0,0);

--
-- Table structure for table `file_trigger`
--

CREATE TABLE `file_trigger` (
  `command` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `send_as` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `def` text COLLATE utf8_unicode_ci,
  `descr` text COLLATE utf8_unicode_ci,
  `min_class` int(2) DEFAULT NULL,
  `max_class` int(2) DEFAULT '10',
  `flags` int(2) DEFAULT '0',
  `seconds` int(15) DEFAULT '0',
  PRIMARY KEY (`command`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `file_trigger`
--

INSERT INTO `file_trigger` VALUES ('+faq',NULL,'%[CFG]/faq','Frequently asked quenstions',0,10,2,0),('+help_admin',NULL,'%[CFG]/help_admin','Help text',5,10,8,0),('+help_cheef',NULL,'%[CFG]/help_cheef','Help text',4,10,8,0),('+help_master',NULL,'%[CFG]/help_master','Help text',10,10,8,0),('+help_op',NULL,'%[CFG]/help_op','Help text',3,10,8,0),('+help_reg',NULL,'%[CFG]/help_reg','Help text',1,10,8,0),('+help_usr',NULL,'%[CFG]/help_usr','Help text',0,10,8,0),('+help_vip',NULL,'%[CFG]/help_vip','Help text',2,10,8,0),('+motd','Verlihub','Ýòîò õàá ðàáîòàåò ïîä óïðàâëåíèåì Verlihub %[VERSION] (Âðåìÿ ðàáîòû: %[UPTIME] / Ïîëüçîâàòåëè îíëàéí: %[USERS] /  Øàðà: %[TOTAL_SHARE])|<MOTD> \r\n\r\nÄîáðî ïîæàëîâàòü, %[NICK]@%[IP].%[CC] íà %[HUBNAME]!\r\n\r\n======================================================================================================\r\n\r\n\r\n8888888                                                                    88   88                   88888              \r\n88      88                                                                    88   88                 8                      \r\n88      88   88    88   8888    8888      88888               8888        888     88888              \r\n88      88   88  888     88    88    88    88    88               88        8    88   88     88           \r\n88      88   88  888     88    888888    88    88               88          8888   88     88           \r\n88      88   888  88     88    88            88    88   888    8888      88  88   88     88           \r\n88      88   888  88     88    88    88    88    88           88    88    88  88   88     88   \r\n88      88   88    88     88     8888       88888             88    88      8888     8888         \r\n                                                          88                                               \r\n                                                          88                                               \r\n\r\n\r\n\r\n======================================================================================================\r\n','Message of the day',0,10,52,NULL),('+motd_admin',NULL,'%[CFG]/motd_admin','Message of the day',5,10,4,0),('+motd_cheef',NULL,'%[CFG]/motd_cheef','Message of the day',4,10,4,0),('+motd_master',NULL,'%[CFG]/motd_master','Message of the day',10,10,4,0),('+motd_op',NULL,'%[CFG]/motd_op','Message of the day',3,10,4,0),('+motd_reg',NULL,'%[CFG]/motd_reg','Message of the day',1,10,4,0),('+motd_vip',NULL,'%[CFG]/motd_vip','Message of the day',2,10,4,0),('+rules',NULL,'%[CFG]/rules','Hub rules',0,10,2,0);

--
-- Table structure for table `files_list`
--

CREATE TABLE `files_list` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `adder` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N/A',
  `date` varchar(35) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `files_list`
--


--
-- Table structure for table `files_top`
--

CREATE TABLE `files_top` (
  `nick` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `f1` mediumint(8) unsigned DEFAULT NULL,
  `r1` tinyint(1) NOT NULL,
  `f2` mediumint(8) unsigned DEFAULT NULL,
  `r2` tinyint(1) NOT NULL,
  `f3` mediumint(8) unsigned DEFAULT NULL,
  `r3` tinyint(1) NOT NULL,
  `f4` mediumint(8) unsigned DEFAULT NULL,
  `r4` tinyint(1) NOT NULL,
  `f5` mediumint(8) unsigned DEFAULT NULL,
  `r5` tinyint(1) NOT NULL,
  `f6` mediumint(8) unsigned DEFAULT NULL,
  `r6` tinyint(1) NOT NULL,
  `f7` mediumint(8) unsigned DEFAULT NULL,
  `r7` tinyint(1) NOT NULL,
  `f8` mediumint(8) unsigned DEFAULT NULL,
  `r8` tinyint(1) NOT NULL,
  `f9` mediumint(8) unsigned DEFAULT NULL,
  `r9` tinyint(1) NOT NULL,
  `f0` mediumint(8) unsigned DEFAULT NULL,
  `r0` tinyint(1) NOT NULL,
  PRIMARY KEY (`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `files_top`
--


--
-- Table structure for table `files_type`
--

CREATE TABLE `files_type` (
  `id` tinyint(1) NOT NULL AUTO_INCREMENT,
  `type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `count` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `files_type`
--

INSERT INTO `files_type` VALUES (1,'movies',0),(2,'music',0),(3,'docs',0),(4,'games',0),(5,'anime',0),(6,'manga',0),(7,'progs',0),(8,'pics',0);

--
-- Table structure for table `kicklist`
--

CREATE TABLE `kicklist` (
  `nick` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(11) NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `host` text COLLATE utf8_unicode_ci,
  `share_size` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reason` text COLLATE utf8_unicode_ci,
  `op` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `is_drop` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`nick`,`time`),
  KEY `op_index` (`op`),
  KEY `ip_index` (`ip`),
  KEY `drop_index` (`is_drop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `kicklist`
--


--
-- Table structure for table `lua_ledo_acre`
--

CREATE TABLE `lua_ledo_acre` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cc` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_acre`
--


--
-- Table structure for table `lua_ledo_anti`
--

CREATE TABLE `lua_ledo_anti` (
  `antispam` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `priority` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `action` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `flags` tinyint(1) unsigned NOT NULL DEFAULT '3',
  PRIMARY KEY (`antispam`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_anti`
--

INSERT INTO `lua_ledo_anti` VALUES ('%S+://',206,6,4,3),('dchub://',0,6,4,3),('adcs://',0,6,4,3),('adc://',0,6,4,3),(':notes:',0,6,4,3),('[A-Za-z0-9]+%.info',3,6,4,3),('[A-Za-z0-9]+%.ru',11,6,4,3),('[A-Za-z0-9]+%.ro',0,6,2,3),('qwerty',0,6,4,3),('[A-Za-z0-9]+%.ua',2,6,4,3),('[A-Za-z0-9]+%.lv',0,6,4,3),('[A-Za-z0-9]+%.host',0,6,4,3),('[A-Za-z0-9]+%.tk',0,6,4,3),('[A-Za-z0-9]+%.com',2,6,4,3),('[A-Za-z0-9]+%.net',3,6,4,3),('[A-Za-z0-9]+%.us',0,6,4,3),('[A-Za-z0-9]+%.biz',0,6,4,3),('[A-Za-z0-9]+%.su',2,6,4,3),('[A-Za-z0-9]+%.org',0,6,4,3),('h.?t.?t.?p.?:.?/.?/',46,6,4,3),('%d+%.%d+%.%d+%.%d+',8,6,4,3),('âîñïðîèçâîäèò â êîëîíî÷êàõ: :notes:',619,6,4,3),('listen:',9,6,4,3),('÷åãî òàê ìàëî ðàñøàðèë?  0 Áàéò âñåãî òî!',0,6,4,3),('0 Áàéò âñåãî òî!',0,6,4,3),('[A-Za-z0-9]+%.nz',0,3,4,3),('www%..+',1,6,4,3),('https://dchublist.biz/forum/fly-server',0,8,2,3),(' h%p*t%p*t%p*p%p*:%p*/%p*/',0,6,4,3),('d%p*c%p*h%p*u%p*b%p*:%p*/%p*/',0,3,4,3),('%d+%s*[%.,]%s*%d+%s*[%.,]%s*%d+%s*[%.,]%s*%d+',4,6,2,3),('h%s*t%s*t%s*p%s*:%s*/%s*/',0,6,4,3),('êîíöìåäãåñòàïîïñèõîíêîó÷ð',43,6,4,3),('óáèéñòâ',1,6,4,3),('https://%S+',0,6,4,3),('adrenalin',0,3,4,3),('nmdcs://',0,3,4,3),('nmdc://',0,3,4,3),('7 9  . 1 3 7  . 2 5  . 1 5 6   :  6  6  6',0,3,4,3),('dchub://dchub.in.ua',0,3,4,3);

--
-- Table structure for table `lua_ledo_antiex`
--

CREATE TABLE `lua_ledo_antiex` (
  `exception` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`exception`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_antiex`
--

INSERT INTO `lua_ledo_antiex` VALUES ('iz.ru',0),('github.com',2),('coub.com',1),('lenta.ru',1),('ya.ru',0),('yandex.ru',2),('mail.ru',1),('hotmail.com',0),('gmail.com',0),('userapi.com',0),('speedtest.net',0),('dropbox.com',0),('twitter.com',0),('lifehacker.ru',0),('vimeo.com',0),('pixs.com',0),('wikipedia.org',1),('bash.im',0),('radikal.ru',0),('rutube.ru',0),('kinozal.tv',0),('spyhub.pp.ua',0),('filesharing.pp.ua',0),('planetdc.ru',0),('elitedc.ru',4),('livejournal.com',0),('%.gif',0),('%.png',1),('%S*%.jpg%S*%s*',0),('%.jpeg',0),('pikabu.ru',0),('youtube.com',17),('youtu.be',35),('rutor.org',0),('instagram.com',0),('facebook.com',1),('google.com.ua',0),('google.ru',0),('google.com',0),('goo.gl',0),('ok.ru',0),('vk.com',5),('mycdn.com',0),('imgur',0),('prntscr.com',1),('^%sotona$',0),('megalive.pp.ua',1),('yandex.net',0),('yandex.ua',0),('%S*userapi%.%S+',0),('%S*userapi%.com%S*%s*',0),('%S*%.jpg',5),('www.elitedc.ru',0),('elitedc.pp.ua',0),('vesti.ru',1),('lostfilm.tv',0);

--
-- Table structure for table `lua_ledo_auth`
--

CREATE TABLE `lua_ledo_auth` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `badip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0.0.0',
  `good` bigint(20) unsigned NOT NULL DEFAULT '0',
  `bad` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_auth`
--


--
-- Table structure for table `lua_ledo_ccgag`
--

CREATE TABLE `lua_ledo_ccgag` (
  `item` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `why` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_ccgag`
--


--
-- Table structure for table `lua_ledo_ccstat`
--

CREATE TABLE `lua_ledo_ccstat` (
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cc` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_ccstat`
--


--
-- Table structure for table `lua_ledo_chat`
--

CREATE TABLE `lua_ledo_chat` (
  `room` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `minclass` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `maxclass` tinyint(2) unsigned NOT NULL DEFAULT '10',
  `cc` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
  PRIMARY KEY (`room`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_chat`
--

INSERT INTO `lua_ledo_chat` VALUES ('VipChat','×àò äëÿ VIP-ïîëüçîâàòåëåé',2,10,'*');

--
-- Table structure for table `lua_ledo_chatrepl`
--

CREATE TABLE `lua_ledo_chatrepl` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `replace` text COLLATE utf8_unicode_ci NOT NULL,
  `maxclass` tinyint(2) unsigned NOT NULL DEFAULT '10',
  `flags` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_chatrepl`
--

INSERT INTO `lua_ledo_chatrepl` VALUES (1,'âîñïðîèçâîäèò â êîëîíî÷êàõ :notes:','                                           ',1,2,0),(2,'âîñïðîèçâîäèò â êîëîíî÷êàõ :notes:','çàáàíüòå ìåíÿ))))',2,1,0),(3,'[%- ]([%- ]+)',' ',10,1,0);

--
-- Table structure for table `lua_ledo_chran`
--

CREATE TABLE `lua_ledo_chran` (
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rank` bigint(20) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_chran`
--


--
-- Table structure for table `lua_ledo_citygag`
--

CREATE TABLE `lua_ledo_citygag` (
  `item` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `why` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_citygag`
--


--
-- Table structure for table `lua_ledo_clog`
--

CREATE TABLE `lua_ledo_clog` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `time` bigint(20) unsigned NOT NULL,
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `class` tinyint(2) unsigned NOT NULL,
  `command` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4186 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_clog`
--

INSERT INTO `lua_ledo_clog` VALUES (4175,1581194028,'CyberGhost404',10,'!oldclean stats'),(4176,1581194039,'CyberGhost404',10,'!oldclean stats 7 0'),(4185,1581194510,'CyberGhost404',10,'!modtrigger +motd -d \"Ýòîò õàá ðàáîòàåò ïîä óïðàâëåíèåì Verlihub %[VERSION] (Âðåìÿ ðàáîòû: %[UPTIME] / Ïîëüçîâàòåëè îíëàéí: %[USERS] /  Øàðà: %[TOTAL_SHARE])&#124;<MOTD> \r\n\r\nÄîáðî ïîæàëîâàòü, %[NICK]@%[IP].%[CC] íà %[HUBNAME]!\r\n\r\n======================================================================================================\r\n\r\n\r\n8888888                                                                    88   88                   88888              \r\n88      88                                                                    88   88                 8                      \r\n88      88   88    88   8888    8888      88888               8888        888     88888              \r\n88      88   88  888     88    88    88    88    88               88        8    88   88     88           \r\n88      88   88  888     88    888888    88    88               88          8888   88     88           \r\n88      88   888  88     88    88            88    88   888    8888      88  88   88     88           \r\n88      88   888  88     88    88    88    88    88           88    88    88  88   88     88   \r\n88      88   88    88     88     8888       88888             88    88      8888     8888         \r\n                                                          88                                               \r\n                                                          88                                               \r\n\r\n\r\n\r\n======================================================================================================\r\n\" -n Verlihub -f 52 -c 0 -C 10  '),(4184,1581194474,'CyberGhost404',10,'!reload'),(4183,1581194470,'CyberGhost404',10,'+regpasswd HomePC <ïàðîëü>'),(4182,1581194448,'CyberGhost404',10,'!rn HomePC 10'),(4181,1581194441,'CyberGhost404',10,'+histclean all'),(4180,1581194431,'CyberGhost404',10,'+histclean chat'),(4179,1581194410,'CyberGhost404',10,'!reload'),(4178,1581194062,'CyberGhost404',10,'!oldclean iplog 0'),(4177,1581194054,'CyberGhost404',10,'!oldclean iplog 7 0'),(4174,1581194018,'CyberGhost404',10,'!oldclean clog 0');

--
-- Table structure for table `lua_ledo_cmd`
--

CREATE TABLE `lua_ledo_cmd` (
  `command` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `class` tinyint(2) unsigned NOT NULL DEFAULT '11',
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`command`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_cmd`
--


--
-- Table structure for table `lua_ledo_cmdex`
--

CREATE TABLE `lua_ledo_cmdex` (
  `exception` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`exception`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_cmdex`
--

INSERT INTO `lua_ledo_cmdex` VALUES ('^[%+%!%/]drop .+$',7),('^[%+%!%/]rpass .+$',0),('^[%+%!%/]rpasswd .+$',0),('^[%+%!%/]regpass .+$',0),('^[%+%!%/]regpasswd .+$',44),('^[%+%!%/]msgsend .+$',3),('^[%+%!%/]report .+$',0),('^[%+%!%/]passwd .*$',23),('^[%+%!%/]regme',0);

--
-- Table structure for table `lua_ledo_conf`
--

CREATE TABLE `lua_ledo_conf` (
  `variable` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`variable`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_conf`
--

INSERT INTO `lua_ledo_conf` VALUES ('midescmessage','Îáíàðóæåíî çàïðåùåííîå îïèñàíèå: / Forbidden description detected: *'),('avsearchint','30'),('antibelowclass','3'),('sefiblockdel','1'),('mincommandclass','4'),('antispamdebug','0'),('minusrcommandclass','0'),('miclonekicktime',''),('enableantispam','1'),('avrandrequest','1'),('miemailmessage','Forbidden email detected: *'),('histdeflines','100'),('newsdeflines','25'),('useripinchat','0'),('regmeuptime','0'),('useripsupport','1'),('miccmessage','Forbidden country code detected: *'),('classnotisay','5'),('classnotianti','3'),('regnewpubmsgadmin',''),('michdns','0'),('langfileprefix','ru'),('searrankclass','11'),('classnotilowupreg','3'),('antikreason','Îáíàðóæåíà ïîïûòêà ðåêëàìû / Forbidden spam detected_ban_3h'),('michchat','1'),('translitmode','0'),('tolowcharcase','0'),('unkkickreason','Unknown protocol command detected from your client: *'),('usermenuname','.:: Ìåíþ õàáà'),('srvtimediff','0'),('showuseruptime','1'),('scanbelowclass','3'),('classnotikick','3'),('instrcmenu','1'),('searfiltmsg','Your search request is forbidden and therefore discarded: *'),('instusermenu','1'),('chathistbotmsg','1'),('userrecmsg','Íîâûé ðåêîðä ïî êîëè÷åñòâóþ þçåðîâ <shortdate>: <old> -> <new>'),('custlistclass','0'),('statscollint','0'),('enablecmdlog','1'),('funrandomchat','0'),('chatmodeclass','3'),('misameipmessage','Connection from same IP detected: *'),('clearclass','3'),('ctmblockmsg','You aren\'t allowed to connect to other users.'),('mivermessage','Îáíàðóæåíà çàïðåùåííàÿ âåðñèÿ NMDC: / Forbidden NMDC version detected: *'),('ctmminclass','0'),('histautonewlinedel','1'),('rolltopicspace','5'),('pmminclass','0'),('classnoticonfig','10'),('codetext','*** ×àò çàáëîêèðîâàí, ââåäèòå ïðîâåðî÷íûé êîä: <code> // Block chat, enter the access code: <code>'),('regnewpubmsgcheef',''),('codecharlist','1234567890'),('codelength','4'),('dateformat','%d/%m'),('opkeyself','11'),('regnewpubmsgreg','Ïîïðèâåòñòâóåì íîâîãî çàðåãèñòðèðîâàííîãî ïîëüçîâàòåëÿ  — <nick> :-)  '),('thirdacttime','1d'),('classnotiwelcome','3'),('codemaxclass','0'),('chatcodeflag','0'),('sefireason','Forbidden search request detected: *'),('chatcodeon','0'),('timebotint','1'),('chatuptime','0'),('classnotirepl','3'),('ulogautoclean','14'),('enableuserlog','1'),('avfilecount','30'),('michemail','0'),('useblacklist','0'),('classnotisefi','3'),('enablehardban','1'),('classnotimich','3'),('protofloodctmact','0'),('protofloodctmint','10'),('classnotigagip','3'),('protofloodctmcnt','0'),('enableipwatch','1'),('chatfloodaction','1'),('wordranmin','5'),('chatfloodcount','5'),('chatfloodoneint','120'),('histshowipclass','2'),('chatfloodonecount','10'),('ccroomautocls','3'),('classnotiipwatch','5'),('ccroommancls','3'),('timeformat','%H:%M'),('chatantiflood','0'),('showtopicowner','1'),('rolltopicint','0'),('classnotiex','3'),('classnotiunk','3'),('classnotiflood','3'),('michshare','0'),('classnotiav','3'),('chatfloodallcount','10'),('longdateformat','%Y-%m-%d'),('avfilediff','256'),('ledobotmail','support@elitedc.ru'),('codecharsep',''),('timebotnick','%H:%M[%d/%m/%y]'),('classnotiban','3'),('classnotiauth','3'),('ledobotsize','-1'),('michfakediv','0'),('chatfloodcmdgag','0'),('chathistlimit','0'),('chatrunning','1'),('custnickclass','3'),('extrafeednick','# Feed'),('antimessage','Âàøå ñîîáùåíèå íå áûëî îòïðàâëåíî èç-çà îáíàðóæåíèÿ ñïàìà. Åñëè âû íå ñîãëàñíû ñ ýòèì ðåøåíèåì, îáðàòèòåñü ê òåõïîääåðæêå ïî E-mail: support@elitedc.ru èëè ñàéò: https://www.elitedc.ru/contacts.html  / Your message wasn\'t sent due to spam detection. Contact technical support by E-mail: support@elitedc.ru  or website: https://www.elitedc.ru/contacts.html '),('trigrunning','0'),('useextrafeed','0'),('ledobotnick','PiterBot'),('addledobot','1'),('addspecialver','0'),('autoupdcheck','24'),('regkickaction','1'),('michclone','0'),('regmechatcnt','0'),('sayclass','5'),('ophistautolines','0'),('michip','0'),('histautolines','20'),('michdesc','1'),('histbotmsg','1'),('ctmmsginterval','300'),('sharerankclass','11'),('searchuptime','0'),('savecchistory','0'),('ccroomstyle','# <cc>'),('respskiplast','0'),('ccstatsclass','11'),('sefifeednick','# Search'),('enablesearfilt','0'),('avsendtodb','1'),('sixthactaddr','hub.verlihub.net:7777'),('commandstopm','1'),('chatfloodint','5'),('michcc','0'),('classnotipeakuc','0'),('avsearservport','4112'),('enablevipkick','1'),('oprankclass','11'),('shareranmin','500'),('chatrankclass','11'),('newsautolines','15'),('classnotiblist','3'),('replrunning','0'),('avkicktext','Virus spreaders are not welcome here _ban_30d'),('miipmessage','Forbidden IP address detected: *'),('newsclass','3'),('opkeyshare','0'),('classnoticust','0'),('resprunning','1'),('votekickclass','0'),('mifakemessage','Fake share detected: *'),('checkcmdspam','1'),('roomusernotify','1'),('respdelay','3'),('michnick','1'),('sharerecmsg','Íîâûé ðåêîðä ïî êîëè÷åñòâó øàðû <shortdate>: <old> -> <new>'),('remrunning','1'),('avuserfree','180'),('regnewpubenable','1'),('classnotiledoact','10'),('classnoticom','10'),('authmessage','Your IP doesn\'t match the authorization IP set for your nick.'),('authrunning','1'),('chatfloodallint','10'),('ccroomrunning','0'),('mchistclass','0'),('fasttimebot','0'),('classnotilowupsear','3'),('welcomeclass','3'),('relmodclass','3'),('reluseclass','0'),('wordrankclass','11'),('repldebug','0'),('votekickcount','3'),('unktbantime','3h'),('savecustnicks','1'),('custmaxlen','64'),('avsearservaddr',''),('classnotibotpm','3'),('searuptimeact','0'),('histautolinemax','256'),('chatuptimeact','0'),('regnewpubmsgmaster',''),('classnotilowupchat','3'),('miconnmessage','Forbidden connection type detected: *'),('offmsgclass','0'),('avdetaction','0'),('ranklimit','25'),('classnotibadctm','11'),('michsameip','0'),('classnotireg','4'),('opkeyclass','11'),('unkbeforelogin','0'),('kickunkusers','0'),('classnotiprotoflood','3'),('mitbantime','3h'),('miclonemessage','Clone of yourself detected: *'),('micallall','1'),('replprotect','1'),('histlimit','1000'),('misupmessage','Forbidden client supports detected: *'),('allowspamtoops','1'),('addsefifeed','0'),('michfakenum','0'),('midnsmessage','Forbidden DNS detected: *'),('chathistipclass','11'),('mitagmessage','Forbidden tag detected: *'),('minickmessage','Îáíàðóæåí çàïðåùåííûé íèê / Forbidden nick detected: *'),('michatmessage','Çàïðåùåíî îáíàðóæåíèå çàïðåùåííîãî ÷àòà / Forbidden chat nick detected: *'),('regnewpubmsgvip',''),('michver','1'),('classnotipeakts','0'),('michsup','0'),('michconn','1'),('michtag','0'),('regnewpubmsgop',''),('misharemessage','Forbidden share size detected: *'),('avfeedverb','2'),('classnotiredir','4'),('classnotioff','3'),('shrtuptimefmt','%s:%s:%s:%s:%s'),('logallmyinfos','0'),('ipconantiflint','0'),('avdbloadint','0'),('classnotihardban','3'),('micheck','1'),('seventhacttime',''),('wordranmax','25'),('ninthactrepmsg','Sorry. I won\'t be spamming this hub again.'),('cmdinstalled','1'),('cmdexinstalled','1'),('defmyinfnick','1'),('allow_shell','0'),('allow_sql','0'),('sefiblockmsg','1'),('autosendhelp','1'),('norepltoops','0'),('classnotichatcode','3'),('ctmuptime','0'),('ctmuptimeact','0'),('ctmuptimemsg','5'),('searuptimemsg','5'),('classnotilowupctm','3'),('chranprizeclass','11'),('chranprizecount','1000'),('chranprizetext',' Ïðèâåòñòâóåì íàøåãî ïîáåäèòåëÿ ÷àòà ñ ðàíãîì <rank>: <nick>'),('avdetblockmsg','5'),('relautolines','0'),('votekickclean','60'),('lastcleanulog','1581192506'),('limcleanulog','14'),('voteplustext','\r\n\r\n 			*** Âíèìàíèå! ***\r\n\r\n	Íà÷àòî ãîëîñîâàíèå çà êèê ñ íèêîì:  <user> è êëàññîì: <class>\r\n	Êîëè÷åñòâî ãîëîñîâ: <count> èç <total>!\r\n	Ïðîãîëîñîâàòü ìîæíî èç ìåíþ (Ãîëîñîâàíèå çà êèê\\) èëè êîìàíäîé +votekick <íèê> [ +votekick <user> ]'),('voteminustext',' \r\n\r\n 			*** Âíèìàíèå! ***\r\n\r\n	Íà÷àòî ãîëîñîâàíèå çà àíòèêèê þçåðà:  <user> è êëàññîì:  <class>\r\n	Êîëè÷åñòâî ãîëîñîâ: <count> èç <total>!\r\n	Ïðîãîëîñîâàòü ìîæíî èç ìåíþ (Ãîëîñîâàíèå çà àíòèêèê\\) èëè êîìàíäîé +votekick <íèê> - [ +votekick <user> - ]'),('votecleartext','\r\n 			*** Âíèìàíèå! ***\r\n\r\n	Ãîëîñîâàíèå çà êèê ñ íèêîì:  <user> è êëàññîì: <class> çàâåðøåíî!\r\n	Êîëè÷åñòâî ãîëîñîâ: <count> èç <total>!'),('votetimetext',' \r\n 			*** Âíèìàíèå! ***\r\n\r\n	Òàéì-àóò áûë äîñòèãíóò çà ãîëîñîâàíèå çà êèê ñ íèêîì:  <user> è êëàññîì: <class> çàâåðøåíî!\r\n	Êîëè÷åñòâî ãîëîñîâ: <count> èç <total>!'),('chatintelon','1'),('chatintelemail','support@megalive.pp.ua'),('chatintelact','1'),('chatintelmatch','100'),('chatintelqueue','100'),('chatintelquote','500'),('chatintelmaxreq','1'),('classnotichin','3'),('seardupfilt','0'),('seardupsecs','10'),('date_ccstats','1565952516'),('badpassbanmult','0'),('lastcleanclog','1581194018'),('limcleanclog','0'),('lastcleaniplog','1565524356'),('limcleaniplog','7'),('lastcleanstats','1565524385'),('limcleanstats','7'),('lastcleanban','1565524441'),('limcleanban','7'),('lastcleansrran','1565952484'),('limcleansrran','0'),('lastcleanwdran','1565952507'),('limcleanwdran','0');

--
-- Table structure for table `lua_ledo_crhist`
--

CREATE TABLE `lua_ledo_crhist` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `room` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `realnick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` bigint(20) unsigned NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_crhist`
--


--
-- Table structure for table `lua_ledo_cust`
--

CREATE TABLE `lua_ledo_cust` (
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_cust`
--


--
-- Table structure for table `lua_ledo_hban`
--

CREATE TABLE `lua_ledo_hban` (
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reason` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_hban`
--

INSERT INTO `lua_ledo_hban` VALUES ('95.83.188.0-95.83.188.255','îñëèíà');

--
-- Table structure for table `lua_ledo_hubs`
--

CREATE TABLE `lua_ledo_hubs` (
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`address`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_hubs`
--

INSERT INTO `lua_ledo_hubs` VALUES ('dchub://dc.megalive.su:411','M.E.G.A.L.I.V.E - G.r.o.u.p','RU',0),('dchub://dc.dcmagnet.ru:411','#DCMagnet.ru','RU',0);

--
-- Table structure for table `lua_ledo_ipgag`
--

CREATE TABLE `lua_ledo_ipgag` (
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_ipgag`
--

INSERT INTO `lua_ledo_ipgag` VALUES ('178.234.0.0-178.234.255.255',0),('178.234.160.0-178.234.175.255',0),('95.179.120.0-95.179.127.255',0),('188.162.133.0-188.162.159.255',0),('82.147.0.0-82.147.255.255',0),('85.113.0.0-85.113.255.255',0),('89.249.0.0-89.249.255.255',0),('95.83.0.0-95.83.255.255',0),('128.74.52.0-128.74.52.127',0);

--
-- Table structure for table `lua_ledo_ipwa`
--

CREATE TABLE `lua_ledo_ipwa` (
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reason` text COLLATE utf8_unicode_ci NOT NULL,
  `result` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_ipwa`
--


--
-- Table structure for table `lua_ledo_ledocmd`
--

CREATE TABLE `lua_ledo_ledocmd` (
  `original` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `new` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`original`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_ledocmd`
--

INSERT INTO `lua_ledo_ledocmd` VALUES ('relfind','relfind'),('authlist','authlist'),('repldel','repldel'),('sefiadd','sefiadd'),('myinflist','myinflist'),('antiexadd','antiexadd'),('newsdel','newsdel'),('hban','hban'),('wmdel','wmdel'),('antiexlist','antiexlist'),('ipwatadd','ipwatadd'),('chathist','history'),('cmndexlist','cmndexlist'),('cmnddel','cmnddel'),('mode','mode'),('votekick','votekick'),('sefiexdel','sefiexdel'),('ledover','ledover'),('sefibldel','sefibldel'),('protlist','protlist'),('wordranks','wordranks'),('triglist','triglist'),('gagiplist','gagiplist'),('trigdel','trigdel'),('calculate','calculate'),('authmod','authmod'),('chatleave','leave'),('acrelist','acrelist'),('votekicklist','votekicklist'),('ledoshell','ledoshell'),('ledohelp','ledohelp'),('respexdel','respexdel'),('antiadd','antiadd'),('myhistory','myhistory'),('rcmenuadd','rcmenuadd'),('citylive','citylive'),('myinfdel','myinfdel'),('wmforce','wmforce'),('nopmdel','nopmdel'),('sefidel','sefidel'),('rcmenuoff','rcmenuoff'),('chatdel','chatdel'),('wmlist','wmlist'),('rcmenuord','rcmenuord'),('userinfo','userinfo'),('sefilist','sefilist'),('clear','clear'),('gagccadd','gagccadd'),('repladd','repladd'),('chatusers','users'),('regname','regname'),('rcmenulist','rcmenulist'),('ophistory','ophistory'),('readlog','readlog'),('gagipadd','gagipadd'),('replexdel','replexdel'),('acredel','acredel'),('remadd','remadd'),('hubnews','hubnews'),('trigadd','trigadd'),('chatranks','chatranks'),('antilist','antilist'),('reldel','reldel'),('offmsg','offmsg'),('cmndlist','cmndlist'),('sefiexlist','sefiexlist'),('searranks','searranks'),('offlist','offlist'),('chathelp','help'),('chatenter','enter'),('replexlist','replexlist'),('ledosql','ledosql'),('ledokoluninstallisconfirmed','ledokoluninstallisconfirmed'),('ledoset','ledoset'),('ledoconf','ledoconf'),('respadd','respadd'),('ledostats','ledostats'),('offdel','offdel'),('ranexdel','ranexdel'),('ipwatlist','ipwatlist'),('hubadd','hubadd'),('authdel','authdel'),('showtopic','showtopic'),('gagcclist','gagcclist'),('say','say'),('gagccdel','gagccdel'),('protadd','protadd'),('gagipdel','gagipdel'),('votekickdel','votekickdel'),('dropip','dropip'),('reglist','reglist'),('seen','seen'),('cmndshow','cmndshow'),('ulog','ulog'),('ipinfo','ipinfo'),('wmshow','wmshow'),('ranexadd','ranexadd'),('nopmlist','nopmlist'),('avstats','avstats'),('wmset','wmset'),('mysharerank','mysharerank'),('chatlist','chatlist'),('chatadd','chatadd'),('custdel','custdel'),('history','history'),('rename','rename'),('sefiexadd','sefiexadd'),('hunban','hunban'),('remdel','remdel'),('custlist','custlist'),('realnick','realnick'),('nick','nick'),('myoprank','myoprank'),('ranclean','ranclean'),('randel','randel'),('authadd','authadd'),('resplist','resplist'),('ranexlist','ranexlist'),('cmndadd','cmndadd'),('showhubs','showhubs'),('nopmadd','nopmadd'),('cchist','cchist'),('antiexdel','antiexdel'),('respdel','respdel'),('reladd','reladd'),('antidel','antidel'),('replexadd','replexadd'),('repllist','repllist'),('cmndreset','cmndreset'),('shareranks','shareranks'),('oldclean','oldclean'),('acreadd','acreadd'),('mychatrank','mychatrank'),('hubdel','hubdel'),('cmndexdel','cmndexdel'),('cmndexadd','cmndexadd'),('cmndset','cmndset'),('cclive','cclive'),('regstats','regstats'),('regfind','regfind'),('respexlist','respexlist'),('avdetforce','avdetforce'),('clog','clog'),('histclean','histclean'),('histdel','histdel'),('rellist','rellist'),('sefibllist','sefibllist'),('ipwatdel','ipwatdel'),('newsadd','newsadd'),('hbans','hbans'),('lretoplain','lretoplain'),('rcmenudel','rcmenudel'),('remshow','remshow'),('respexadd','respexadd'),('remlist','remlist'),('avdbfind','avdbfind'),('opranks','opranks'),('offclean','offclean'),('protdel','protdel'),('myinfadd','myinfadd'),('whois','whois'),('histfind','histfind'),('histline','histline'),('clogfind','clogfind'),('cloneinfo','cloneinfo'),('clonemove','clonemove'),('ledocofi','ledocofi'),('gagcitydel','gagcitydel'),('gagcitylist','gagcitylist'),('gagcityadd','gagcityadd');

--
-- Table structure for table `lua_ledo_mchist`
--

CREATE TABLE `lua_ledo_mchist` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `realnick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` bigint(20) unsigned NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_mchist`
--


--
-- Table structure for table `lua_ledo_mcresp`
--

CREATE TABLE `lua_ledo_mcresp` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reply` text COLLATE utf8_unicode_ci NOT NULL,
  `maxclass` tinyint(2) unsigned NOT NULL DEFAULT '10',
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_mcresp`
--


--
-- Table structure for table `lua_ledo_micc`
--

CREATE TABLE `lua_ledo_micc` (
  `cc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`cc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_micc`
--


--
-- Table structure for table `lua_ledo_michat`
--

CREATE TABLE `lua_ledo_michat` (
  `chat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`chat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_michat`
--

INSERT INTO `lua_ledo_michat` VALUES ('âîñïðîèçâîäèò â êîëîíî÷êàõ: :notes:',NULL,0,NULL),('ÒàäæèêèñòîíÔîðåâà',NULL,0,NULL),('ÌèëàøêèíÒàäæèêñêèéÆåíèõ',NULL,0,NULL),('âîñïðîèçâîäèò â êîëîíî÷êàõ',NULL,0,NULL),('æåíèõ',NULL,0,NULL),('Óçáåêñêèéæåíèõ',NULL,0,NULL);

--
-- Table structure for table `lua_ledo_miconn`
--

CREATE TABLE `lua_ledo_miconn` (
  `connection` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`connection`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_miconn`
--


--
-- Table structure for table `lua_ledo_midesc`
--

CREATE TABLE `lua_ledo_midesc` (
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_midesc`
--


--
-- Table structure for table `lua_ledo_midns`
--

CREATE TABLE `lua_ledo_midns` (
  `dns` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`dns`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_midns`
--


--
-- Table structure for table `lua_ledo_miemail`
--

CREATE TABLE `lua_ledo_miemail` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_miemail`
--


--
-- Table structure for table `lua_ledo_miex`
--

CREATE TABLE `lua_ledo_miex` (
  `exception` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`exception`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_miex`
--


--
-- Table structure for table `lua_ledo_miip`
--

CREATE TABLE `lua_ledo_miip` (
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_miip`
--


--
-- Table structure for table `lua_ledo_minick`
--

CREATE TABLE `lua_ledo_minick` (
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_minick`
--

INSERT INTO `lua_ledo_minick` VALUES ('Admin',NULL,0,NULL),('Administrator',NULL,0,NULL),('root',NULL,101,NULL),('Àäìèí',NULL,0,NULL),('Àäìèíèñòðàòîð',NULL,0,NULL),('DCBEELINEKZ',NULL,0,NULL),('ÒàäæèêèñòîíÔîðåâà',NULL,0,NULL),('ÌèëàøêèíÒàäæèêñêèéÆåíèõ',NULL,0,NULL),('dchub://%S+',NULL,0,NULL),('Óçáåêñêèéæåíèõ',NULL,0,NULL),('æåíèõ',NULL,5,NULL),('ìèëàøêèí',NULL,4,NULL),('ÄæàìøóòÒàøêåíòñêèé',NULL,0,NULL),('òàøêåíòñêèé',NULL,1,NULL),('Ìèëàøêà',NULL,0,NULL);

--
-- Table structure for table `lua_ledo_mishare`
--

CREATE TABLE `lua_ledo_mishare` (
  `share` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`share`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_mishare`
--


--
-- Table structure for table `lua_ledo_misup`
--

CREATE TABLE `lua_ledo_misup` (
  `supports` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`supports`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_misup`
--


--
-- Table structure for table `lua_ledo_mitag`
--

CREATE TABLE `lua_ledo_mitag` (
  `tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`tag`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_mitag`
--


--
-- Table structure for table `lua_ledo_miver`
--

CREATE TABLE `lua_ledo_miver` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_miver`
--

INSERT INTO `lua_ledo_miver` VALUES ('1%.0091',NULL,108,NULL);

--
-- Table structure for table `lua_ledo_news`
--

CREATE TABLE `lua_ledo_news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` bigint(20) unsigned NOT NULL,
  `by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `item` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_news`
--


--
-- Table structure for table `lua_ledo_off`
--

CREATE TABLE `lua_ledo_off` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` bigint(20) unsigned NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_off`
--


--
-- Table structure for table `lua_ledo_ophist`
--

CREATE TABLE `lua_ledo_ophist` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` bigint(20) unsigned NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `class` tinyint(2) unsigned NOT NULL DEFAULT '10',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_ophist`
--

INSERT INTO `lua_ledo_ophist` VALUES (1,'PiterBot',1581194441,'Ïîëüçîâàòåëü CyberGhost404 10-ãî êëàññà óäàëèë 1000 ñîîáùåíèé èç èñòîðèè ñîîáùåíèé îïåðàòîðîâ.',10),(2,'PiterBot',1581194448,'Ïîëüçîâàòåëü CyberGhost404 10-ãî êëàññà çàðåãèñòðèðîâàë íîâîãî ïîëüçîâàòåëÿ 10-ãî êëàññà: HomePC',4),(3,'PiterBot',1581194474,'Ïîëüçîâàòåëü CyberGhost404 ñ IP àäðåñîì 185.189.15.8.RU è êëàññîì 10 èñïîëüçîâàë ñëåäóþùóþ êîìàíäó: !reload',10),(4,'PiterBot',1581194510,'Ïîëüçîâàòåëü CyberGhost404 ñ IP àäðåñîì 185.189.15.8.RU è êëàññîì 10 èñïîëüçîâàë ñëåäóþùóþ êîìàíäó: !modtrigger +motd -d \"Ýòîò õàá ðàáîòàåò ïîä óïðàâëåíèåì Verlihub %[VERSION] (Âðåìÿ ðàáîòû: %[UPTIME] / Ïîëüçîâàòåëè îíëàéí: %[USERS] /  Øàðà: %[TOTAL_SHARE])&#124;<MOTD> \r\n\r\nÄîáðî ïîæàëîâàòü, %[NICK]@%[IP].%[CC] íà %[HUBNAME]!\r\n\r\n======================================================================================================\r\n\r\n\r\n8888888                                                                    88   88                   88888              \r\n88      88                                                                    88   88                 8                      \r\n88      88   88    88   8888    8888      88888               8888        888     88888              \r\n88      88   88  888     88    88    88    88    88               88        8    88   88     88           \r\n88      88   88  888     88    888888    88    88               88          8888   88     88           \r\n88      88   888  88     88    88            88    88   888    8888      88  88   88     88           \r\n88      88   888  88     88    88    88    88    88           88    88    88  88   88     88   \r\n88      88   88    88     88     8888       88888             88    88      8888     8888         \r\n                                                          88                                               \r\n                                                          88                                               \r\n\r\n\r\n\r\n======================================================================================================\r\n\" -n Verlihub -f 52 -c 0 -C 10  ',10);

--
-- Table structure for table `lua_ledo_opran`
--

CREATE TABLE `lua_ledo_opran` (
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rank` bigint(20) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_opran`
--


--
-- Table structure for table `lua_ledo_prot`
--

CREATE TABLE `lua_ledo_prot` (
  `protected` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`protected`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_prot`
--

INSERT INTO `lua_ledo_prot` VALUES ('^%ëåñíàÿ.ðàçáîéíèöà$',667),('^ëåñíàÿ%.ðàçáîéíèöà$ ',0),('^sotona$',808),('^%[lv]leonkrevs$',26364),('^%[saratov]mythbusters$',114114),('^%[ua]alex404$',8),('^ðsih$',3016),('^185%.189%.15%.8$',413),('^37%.1%.217%.131$',163),('^êèðà$',162),('^51%.68%.143%.127$',930),('^54%.38%.54%.177$',549),('^185%.189%.14%.116$',719),('^51%.254%.38%.234$',0),('^rhino$',637),('^145%.239%.133%.57$',19);

--
-- Table structure for table `lua_ledo_ranex`
--

CREATE TABLE `lua_ledo_ranex` (
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_ranex`
--


--
-- Table structure for table `lua_ledo_rcmenu`
--

CREATE TABLE `lua_ledo_rcmenu` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `command` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `cont` tinyint(2) unsigned NOT NULL DEFAULT '3',
  `order` smallint(5) unsigned NOT NULL DEFAULT '0',
  `minclass` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `maxclass` tinyint(2) unsigned NOT NULL DEFAULT '10',
  `off` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_rcmenu`
--

INSERT INTO `lua_ledo_rcmenu` VALUES (22,'.:: Ìåíþ õàáà\\.:: Ðåãèñòðàöèÿ\\Çàðåãèñòðèðîâàòü íèê','+regme %[line:Ââåäèòå ïàðîëü(íå ìåíåå 6 ñèìâîëîâ)]',1,3,1,0,0,0),(2,'.:: Ìåíþ õàáà\\.:: Ïðàâèëà õàáà','+rules',1,3,1,0,10,0),(3,'.:: Ìåíþ õàáà\\.:: Îáùèå âîïðîñû(FAQ)','+faq',1,3,1,0,10,0),(4,'.:: Ìåíþ àäìèíà\\Ðàññûëêà ñîîáùåíèé\\Ðàçîñëàòü âñåì','!bc %[line:Ââåäèòå ñîîáùåíèå]',1,3,1,4,10,0),(5,'.:: Ìåíþ àäìèíà\\Ðàññûëêà ñîîáùåíèé\\Ðàçîñëàòü Guests','!guests %[line:Ââåäèòå ñîîáùåíèå]',1,3,1,4,10,0),(6,'.:: Ìåíþ àäìèíà\\Ðàññûëêà ñîîáùåíèé\\Ðàçîñëàòü Reg','!regs %[line:Ââåäèòå ñîîáùåíèå]',1,3,1,4,10,0),(7,'.:: Ìåíþ àäìèíà\\Ðàññûëêà ñîîáùåíèé\\Ðàçîñëàòü â ÷àò(Ëþáîé íèê)','!say %[line:Ââåäèòå íèê áîòà] %[line:Ââåäèòå ñîîáùåíèå]',1,3,1,4,10,0),(21,'.:: Ìåíþ àäìèíà\\Ðàññûëêà ñîîáùåíèé\\Ðàçîñëàòü â ÷àò îò [MegaLive]System','!say [MegaLive]System %[line:Ââåäèòå ñîîáùåíèå]',1,3,1,4,10,0),(9,'.:: Ìåíþ àäìèíà\\Ðåãèñòðàöèÿ\\Çàðåãèñòðèðîâàòü íîâîãî þçåðà','!rn %[line:Ââåäèòå íèê] %[line:Ââåäèòå êëàññ]',1,3,1,4,10,0),(10,'.:: Ìåíþ àäìèíà\\Ðåãèñòðàöèÿ\\Ñîçäàòü ïàðîëü äëÿ þçåðà','!regpasswd %[line:Ââåäèòå íèê] %[line:Ââåäèòå ïàðîëü]',1,3,1,4,10,0),(11,'.:: Ìåíþ àäìèíà\\Ðåãèñòðàöèÿ\\Èçìåíèòü êëàññ þçåðó','!regclass %[line:Ââåäèòå íèê] %[line:Ââåäèòå êëàññ]',1,3,1,4,10,0),(12,'.:: Ìåíþ àäìèíà\\Ðåãèñòðàöèÿ\\Óäàëèòü þçåðà','!regdel %[line:Ââåäèòå íèê]',1,3,1,4,10,0),(13,'.:: Ìåíþ àäìèíà\\Ðåãèñòðàöèÿ\\Èíôîðìàöèÿ î ðåãèñòðàöèè','!reginfo %[line:Ââåäèòå íèê]',1,3,1,4,10,0),(14,'.:: Ìåíþ àäìèíà\\Ðåãèñòðàöèÿ\\Ñïèñîê þçåðîâ ïî êëàññàì','!reglist %[line:Ââåäèòå êëàññ]',1,3,1,4,10,0),(23,'.:: Ìåíþ õàáà\\.:: Ðåãèñòðàöèÿ\\Èçìåíèòü ïàðîëü','+passwd %[line:Ââåäèòå íîâûé ïàðîëü(íå ìåíåå 6 ñèìâîëîâ)]',1,3,1,1,10,0),(24,'.:: Ìåíþ õàáà\\.:: Ðåãèñòðàöèÿ\\Óäàëèòü ðåãèñòðàöèþ','+unregme',1,3,1,1,10,0),(25,'.:: Ìåíþ õàáà\\.:: Æàëîáà íà íèê','+report %[line:Ââåäèòå íèê:] %[line:Ââåäèòå æàëîáó]',1,3,1,0,2,0),(26,'.:: Ìåíþ àäìèíà\\CyberSecurity\\Áàíû\\Ñïèñîê çàáàíåíûõ','!bl myall',1,3,1,10,10,0),(27,'.:: Ìåíþ àäìèíà\\CyberSecurity\\Áàíû\\Çàáàíèòü þçåðà','!bl myadd %[line:Ââåäèòå IP] %[line:Ââåäèòå Íèê þçåðà]',1,3,1,10,10,0),(28,'.:: Ìåíþ àäìèíà\\CyberSecurity\\Áàíû\\Ðàçáàíèòü þçåðà','!bl mydel %[line:Ââåäèòå ID]',1,3,1,10,10,0),(29,'.:: Ìåíþ àäìèíà\\CyberSecurity\\Èñêëþ÷åíèÿ\\Ñïèñîê èñêëþ÷åíèé','!bl exall',1,3,1,10,10,0),(30,'.:: Ìåíþ àäìèíà\\CyberSecurity\\Èñêëþ÷åíèÿ\\Äîáàâèòü èñêëþ÷åíèå','!bl exadd %[line:Ââåäèòå IP] %[line:Ââåäèòå Îïèñàíèå/Íèê]',1,3,1,10,10,0),(31,'.:: Ìåíþ àäìèíà\\CyberSecurity\\Èñêëþ÷åíèÿ\\Óäàëèòü èç èñêëþ÷åíèé','!bl exdel %[line:Ââåäèòå ID]',1,3,1,10,10,0),(39,'Êèêíóòü þçåðà','!kick %[nick] %[line:Ââåäèòå ïðè÷èíà] _ban_%[line:Ââåäèòå âðåìÿ(1m;1d,1w)]',1,3,1,2,2,0),(52,'.:: Ìåíþ àäìèíà\\CyberSecurity\\Èñêëþ÷åíèÿ\\Äîáàâèòü èñêëþ÷åíèå IP èëè íèê','!protadd %[line:Ââåäèòå IP èëè Nick â ôîðìàòå: ^37%.1%.217%.131&#36; èëè +protadd ^cyberghost404&#36; ]',1,3,1,5,10,0),(48,'.:: Ìåíþ õàáà\\.:: Ãîëîñîâàíèå çà êèê\\Ãîëîñîâàòü çà êèê','+votekick %[nick] +',1,3,1,0,10,0),(49,'.:: Ìåíþ õàáà\\.:: Ãîëîñîâàíèå çà êèê\\Ãîëîñîâàòü çà àíòèêèê','+votekick %[nick] -',1,3,1,0,10,0);

--
-- Table structure for table `lua_ledo_rel`
--

CREATE TABLE `lua_ledo_rel` (
  `release` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tth` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`release`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_rel`
--


--
-- Table structure for table `lua_ledo_rem`
--

CREATE TABLE `lua_ledo_rem` (
  `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `minclass` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `maxclass` tinyint(2) unsigned NOT NULL DEFAULT '10',
  `dest` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `interval` smallint(5) unsigned NOT NULL DEFAULT '10080',
  `timer` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_rem`
--


--
-- Table structure for table `lua_ledo_replex`
--

CREATE TABLE `lua_ledo_replex` (
  `exception` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`exception`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_replex`
--


--
-- Table structure for table `lua_ledo_respex`
--

CREATE TABLE `lua_ledo_respex` (
  `exception` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`exception`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_respex`
--


--
-- Table structure for table `lua_ledo_sefi`
--

CREATE TABLE `lua_ledo_sefi` (
  `filter` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  `priority` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `action` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`filter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_sefi`
--


--
-- Table structure for table `lua_ledo_sefiex`
--

CREATE TABLE `lua_ledo_sefiex` (
  `exception` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `occurred` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`exception`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_sefiex`
--


--
-- Table structure for table `lua_ledo_shran`
--

CREATE TABLE `lua_ledo_shran` (
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rank` bigint(20) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_shran`
--


--
-- Table structure for table `lua_ledo_srran`
--

CREATE TABLE `lua_ledo_srran` (
  `search` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rank` bigint(20) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`search`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_srran`
--


--
-- Table structure for table `lua_ledo_stat`
--

CREATE TABLE `lua_ledo_stat` (
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_stat`
--

INSERT INTO `lua_ledo_stat` VALUES ('ver_ledo',1581193434,'2.9.7');

--
-- Table structure for table `lua_ledo_trig`
--

CREATE TABLE `lua_ledo_trig` (
  `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `minclass` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `maxclass` tinyint(2) unsigned NOT NULL DEFAULT '10',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_trig`
--


--
-- Table structure for table `lua_ledo_ulog`
--

CREATE TABLE `lua_ledo_ulog` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `time` bigint(20) unsigned NOT NULL,
  `out` bigint(20) unsigned NOT NULL DEFAULT '0',
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `cc` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `conn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `share` bigint(20) unsigned NOT NULL DEFAULT '0',
  `nmdc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sups` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3063862 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_ulog`
--

INSERT INTO `lua_ledo_ulog` VALUES (3063861,1581194415,1,'CyberGhost404','185.189.15.8','RU','[5]#EliteDC.ru','<EiskaltDC++ V:2.21,M:A,H:0/1/0,S:8>','1000','admin@elitedc.ru',10737506548,'1,0091','UserCommand NoGetINFO NoHello UserIP2 TTHSearch ZPipe0 GetZBlock '),(3063860,1581193616,1581194413,'CyberGhost404','185.189.15.8','RU','[5]#EliteDC.ru','<EiskaltDC++ V:2.21,M:A,H:0/1/0,S:8>','1000','admin@elitedc.ru',10737506548,'1,0091','UserCommand NoGetINFO NoHello UserIP2 TTHSearch ZPipe0 GetZBlock '),(3063859,1581193435,1581193616,'CyberGhost404','185.189.15.8','RU','[5]#EliteDC.ru','<EiskaltDC++ V:2.21,M:A,H:0/1/0,S:8>','1000','admin@elitedc.ru',10737506548,'1,0091','UserCommand NoGetINFO NoHello UserIP2 TTHSearch ZPipe0 GetZBlock '),(3063858,1581193355,1,'CyberGhost404','185.189.15.8','RU','[5]#EliteDC.ru','<EiskaltDC++ V:2.21,M:A,H:0/1/0,S:8>','1000','admin@elitedc.ru',10737506548,'1,0091','UserCommand NoGetINFO NoHello UserIP2 TTHSearch ZPipe0 GetZBlock '),(3063857,1581193322,1581193354,'CyberGhost404','185.189.15.8','RU','[5]#EliteDC.ru','<EiskaltDC++ V:2.21,M:A,H:0/1/0,S:8>','1000','admin@elitedc.ru',10737506548,'1,0091','UserCommand NoGetINFO NoHello UserIP2 TTHSearch ZPipe0 GetZBlock '),(3063856,1581193315,1581193322,'CyberGhost404','185.189.15.8','RU','[5]#EliteDC.ru','<EiskaltDC++ V:2.21,M:A,H:0/1/0,S:8>','1000','admin@elitedc.ru',10737506548,'1,0091','UserCommand NoGetINFO NoHello UserIP2 TTHSearch ZPipe0 GetZBlock '),(3063855,1581193180,1581193180,'TankafettPinger','109.248.59.59','RU','Tankafett Hublist Pinger','<++ V:0.868,M:A,H:1/1/2,S:9>','1000','webmaster@tankafett.biz',135867502249,'1,0091','NoHello NoGetINFO UserIP2 BotINFO BotList'),(3063853,1581192876,1581192986,'darkfires','66.199.231.2','US','unix 4 ever!','<ncdc V:518b-d,M:A,H:15/3/0,S:40>','1000 KiB/s',NULL,59849490921,'1,0091','NoGetINFO NoHello UserIP2'),(3063854,1581192890,1581193314,'CyberGhost404','185.189.15.8','RU','[5]#EliteDC.ru','<EiskaltDC++ V:2.21,M:A,H:0/1/0,S:8>','1000','admin@elitedc.ru',10737506548,'1,0091','UserCommand NoGetINFO NoHello UserIP2 TTHSearch ZPipe0 GetZBlock ');

--
-- Table structure for table `lua_ledo_wdran`
--

CREATE TABLE `lua_ledo_wdran` (
  `word` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rank` bigint(20) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_wdran`
--


--
-- Table structure for table `lua_ledo_wm`
--

CREATE TABLE `lua_ledo_wm` (
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `in` text COLLATE utf8_unicode_ci,
  `out` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_ledo_wm`
--


--
-- Table structure for table `lua_towns_stat`
--

CREATE TABLE `lua_towns_stat` (
  `nick` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `score` bigint(20) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lua_towns_stat`
--

INSERT INTO `lua_towns_stat` VALUES ('CyberGhost404',5),('doc2204',1);

--
-- Table structure for table `pi_iplog`
--

CREATE TABLE `pi_iplog` (
  `date` int(11) DEFAULT NULL,
  `action` smallint(6) DEFAULT '0',
  `ip` bigint(20) DEFAULT NULL,
  `nick` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` int(11) DEFAULT NULL,
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `ind_ip` (`ip`),
  KEY `ind_nick` (`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pi_iplog`
--


--
-- Table structure for table `pi_isp`
--

CREATE TABLE `pi_isp` (
  `ipmin` bigint(20) NOT NULL DEFAULT '0',
  `ipmax` bigint(20) NOT NULL DEFAULT '0',
  `cc` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `descprefix` varchar(16) COLLATE utf8_unicode_ci DEFAULT '[???]',
  `nickpattern` varchar(64) COLLATE utf8_unicode_ci DEFAULT '\\[---\\]',
  `errmsg` varchar(128) COLLATE utf8_unicode_ci DEFAULT 'Your nick must be like this patern %[pattern]',
  `conntype` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `connmsg` varchar(128) COLLATE utf8_unicode_ci DEFAULT 'Your connection type does not match %[pattern]',
  `minshare` int(11) DEFAULT '-1',
  `minsharereg` int(11) DEFAULT '-1',
  `minsharevip` int(11) DEFAULT '-1',
  `minshareop` int(11) DEFAULT '-1',
  `maxshare` int(11) DEFAULT '-1',
  `maxsharereg` int(11) DEFAULT '-1',
  `maxsharevip` int(11) DEFAULT '-1',
  `maxshareop` int(11) DEFAULT '-1',
  PRIMARY KEY (`ipmin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pi_isp`
--


--
-- Table structure for table `pi_messages`
--

CREATE TABLE `pi_messages` (
  `sender` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `date_sent` int(11) NOT NULL,
  `sender_ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `receiver` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `date_expires` int(11) DEFAULT '0',
  `subject` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`sender`,`date_sent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pi_messages`
--


--
-- Table structure for table `pi_plug`
--

CREATE TABLE `pi_plug` (
  `nick` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `path` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `dest` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `detail` text COLLATE utf8_unicode_ci,
  `autoload` tinyint(1) DEFAULT '1',
  `reload` tinyint(1) DEFAULT '0',
  `unload` tinyint(1) DEFAULT '0',
  `error` text COLLATE utf8_unicode_ci,
  `lastload` int(11) DEFAULT NULL,
  PRIMARY KEY (`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pi_plug`
--

INSERT INTO `pi_plug` VALUES ('chat','/usr/local/lib/libchatroom_pi.so',NULL,'Multiple chatrooms to separate chat topics.',0,0,0,NULL,NULL),('flood','/usr/local/lib/libfloodprot_pi.so',NULL,'Advanced flood protection.',0,0,0,'Ïëàãèí çàãðóæåí.',1532290005),('forbid','/usr/local/lib/libforbid_pi.so',NULL,'Filter chat from forbidden words.',0,0,0,NULL,NULL),('isp','/usr/local/lib/libisp_pi.so',NULL,'Hub restrictions by ISP.',0,0,0,'Ïëàãèí çàãðóæåí.',1532290000),('log','/usr/local/lib/libiplog_pi.so',NULL,'IP and nick logger with history.',0,0,0,'Ïëàãèí çàãðóæåí.',1532289996),('lua','/usr/local/lib/liblua_pi.so',NULL,'Support for lua scripts',1,0,0,'Ïëàãèí çàãðóæåí.',1581193434),('msg','/usr/local/lib/libmessenger_pi.so',NULL,'Offline messenger system.',0,0,0,'Ïëàãèí çàãðóæåí.',1532290073),('perl','/usr/local/lib/libperl_pi.so',NULL,'Support for Perl scripts.',0,0,0,'Ïëàãèí çàãðóæåí.',1532290033),('python','/usr/local/lib/libpython_pi.so',NULL,'Support for Python scripts.',1,0,0,'Ïëàãèí çàãðóæåí.',1581193434),('replacer','/usr/local/lib/libreplacer_pi.so',NULL,'Replace some words by other.',0,0,0,NULL,NULL),('stats','/usr/local/lib/libstats_pi.so',NULL,'Hub statistics, trace diverse values in the database.',0,0,0,NULL,NULL);

--
-- Table structure for table `pi_stats`
--

CREATE TABLE `pi_stats` (
  `realtime` int(11) NOT NULL,
  `uptime` int(11) DEFAULT NULL,
  `users_total` int(11) DEFAULT '0',
  `users_zone0` int(11) DEFAULT '0',
  `users_zone1` int(11) DEFAULT '0',
  `users_zone2` int(11) DEFAULT '0',
  `users_zone3` int(11) DEFAULT '0',
  `users_zone4` int(11) DEFAULT '0',
  `users_zone5` int(11) DEFAULT '0',
  `users_zone6` int(11) DEFAULT '0',
  `upload_total` double DEFAULT '0',
  `upload_zone0` double DEFAULT '0',
  `upload_zone1` double DEFAULT '0',
  `upload_zone2` double DEFAULT '0',
  `upload_zone3` double DEFAULT '0',
  `upload_zone4` double DEFAULT '0',
  `upload_zone5` double DEFAULT '0',
  `upload_zone6` double DEFAULT '0',
  `share_total_gb` int(11) DEFAULT '0',
  `freq_search_active` double DEFAULT '0',
  `freq_search_passive` double DEFAULT '0',
  `freq_user_login` double DEFAULT '0',
  `freq_user_logout` double DEFAULT '0',
  PRIMARY KEY (`realtime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pi_stats`
--


--
-- Table structure for table `py_bl_asn`
--

CREATE TABLE `py_bl_asn` (
  `asn` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `off` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`asn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `py_bl_asn`
--


--
-- Table structure for table `py_bl_conf`
--

CREATE TABLE `py_bl_conf` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `py_bl_conf`
--

INSERT INTO `py_bl_conf` VALUES ('time_feed','60'),('nick_feed',''),('action_mylist','1'),('time_down','5'),('prox_timer','30'),('prox_match','80'),('except_mylist','1'),('prox_lookup','0'),('class_skip','3'),('class_feed','5'),('action_proxy','2'),('prox_email','support@elitedc.ru'),('prox_start','5'),('prox_nofail','1'),('except_proxy','1'),('prox_maxreq','1'),('class_conf','10'),('prox_debug','1'),('prox_queue','100'),('prox_quote','490'),('action_extry','0'),('code_block','A1 AD AE AF AG AL AO AR AX AZ BB BD BF BI BJ BH BN BO BR BS BW BZ CD CG CI CL CM CN CO CR CU CW CY DO DZ EC EG ET FJ FO GA GH GM GN GT GU HK HN HT ID IE IM IQ IR IS JM JO JP KE KG KH KN KR KW KY LA LB LI LK LR LS LU LY MA MC ME MM MN MO MP MQ MS MT MU MV MW MX MY MZ NA NC NG NE NI NP OM PA PE PF PG PH PK PR PS PT PY QA RE RW SA SD SG SC SO SR SS SV SZ TG TD TH TL TM TN TR TT TW TZ UG UY VA VE VG VI VN XK YE ZA ZM ZW UK HU ML SK CZ ES'),('nick_bot','[MegaLive]Umbrella'),('notify_update','1'),('code_except',''),('find_maxres','1000'),('action_asnlist','1'),('prox_getasn','1'),('extry_getasn','1'),('except_asnlist','1'),('nick_skip','Sotona'),('asn_except',''),('lang_pref','ru'),('asn_block',''),('asn_nofeed','');

--
-- Table structure for table `py_bl_exli`
--

CREATE TABLE `py_bl_exli` (
  `loaddr` int(10) unsigned NOT NULL,
  `hiaddr` int(10) unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `off` tinyint(1) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `addr_index` (`loaddr`,`hiaddr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `py_bl_exli`
--

INSERT INTO `py_bl_exli` VALUES (872294122,872294122,'HMnHublist',0),(872316614,872316614,'DCHublist.ru Pinger\r',0),(3110207179,3110207179,'Team Elite Pinger\r',0),(3580788501,3580788501,'Master',0),(3259225423,3259225423,'Sotona',0),(1486073504,1486073504,'Dimasikkk',0),(3116175112,3116175112,'MyVPN',0),(3573933319,3573933319,'DChublist.biz',0),(3110207117,3110207117,'FavoriteHublist',0),(1486067840,1486067903,'Dimasik',0),(772283732,772283732,'Tankafett.biz',0),(1578618951,1578618951,'MIXER',0),(528699392,528701439,'ëåñíàÿ ôåÿ',0),(1599354880,1599356927,'Rostelecom',0),(1844984635,1844984635,'Tankafett Hublist',0),(1198771936,1198771936,'DChubList.ORG',0),(1596947018,1596947018,'Master',0),(2303329817,2303329817,'Team Elite Pinger',0),(3116174964,3116174964,'MyVPN',0),(620878211,620878211,'Master',0);

--
-- Table structure for table `py_bl_lang`
--

CREATE TABLE `py_bl_lang` (
  `id` bigint(20) unsigned NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `py_bl_lang`
--

INSERT INTO `py_bl_lang` VALUES (0,'Blacklist %s startup'),(1,'Exception'),(2,'Failed with HTTP error'),(3,'Failed with URL error'),(4,'Failed with unknown error'),(5,'Failed to compile pattern'),(6,'File is not compressed with GZIP'),(7,'Failed to read data'),(8,'%s items loaded'),(9,'Unknown list type'),(10,'Failed to open file'),(11,'My list'),(12,'Value too low'),(13,'Value too high'),(14,'Value is not a number'),(15,'Value too short'),(16,'Value too long'),(17,'Item not found'),(18,'Blacklisted connection exception from %s.%s: %s'),(19,'Blocking blacklisted connection from %s.%s: %s'),(20,'You don\'t have access to this command.'),(21,'Blacklist statistics'),(22,'Version: %s'),(23,'Loaded lists: %s'),(24,'Blacklisted items: %s'),(25,'Excepted items: %s'),(26,'Blocked connections: %s'),(27,'Excepted connections: %s'),(28,'Total connections: %s'),(29,'Missing command parameters: %s'),(30,'Results for IP: %s'),(31,'No results for IP: %s'),(32,'Results for title: %s'),(33,'No results for title: %s'),(34,'Blacklist list is empty.'),(35,'Blacklist list'),(36,'ID: %s'),(37,'List: %s'),(38,'Type: %s'),(39,'Title: %s'),(40,'Update: %s'),(41,'On load'),(42,'%s minute'),(43,'%s minutes'),(44,'Disabled: %s'),(45,'No'),(46,'Yes'),(47,'Type must be one of: %s'),(48,'Update must be in range: %s - %s'),(49,'Item already in list'),(50,'Item added to list'),(51,'Status: %s'),(52,'Item deleted from list'),(53,'List out of item with ID: %s'),(54,'Item now disabled'),(55,'Item now enabled'),(56,'Exception list is empty.'),(57,'Exception list'),(58,'Lower IP: %s.%s'),(59,'Higher IP: %s.%s'),(60,'Lower IP not valid: %s'),(61,'Higher IP not valid: %s'),(62,'Configuration list'),(63,'Name: %s'),(64,'Range: %s - %s'),(65,'Value: %s'),(66,'Item configuration'),(67,'Old value: %s'),(68,'New value: %s'),(69,'Waiting feed list is empty.'),(70,'Waiting feed list'),(71,'IP: %s.%s'),(72,'Expires: %s'),(73,'Blacklist usage'),(74,'Script statistics'),(75,'Search in loaded lists'),(76,'Show all lists'),(77,'Load new list'),(78,'Disable or enable list'),(79,'Delete existing list'),(80,'Show exception list'),(81,'New exception item'),(82,'Delete an exception'),(83,'Show current configuration'),(84,'Set configuration item'),(85,'Show waiting feed list'),(86,'value'),(87,'item'),(88,'id'),(89,'addr'),(90,'range'),(91,'title'),(92,'list'),(93,'type'),(94,'update'),(95,'None'),(96,'Set translation string'),(97,'Show current translation'),(98,'Translation list'),(99,'Updated translation with ID: %s'),(100,'Parameter count mismatch in translation with ID: %s'),(101,'File is not compressed with ZIP'),(102,'Force load of existing list'),(103,'Item is disabled: %s'),(104,'Item load result'),(105,'Failed to load JSON'),(106,'Failed to parse JSON'),(107,'Failed to get status'),(108,'Unexpected status: %s'),(109,'Failed to get result'),(110,'Failed to open URL'),(111,'Waiting feed list out of item: %s.%s'),(112,'Error status: %s'),(113,'Unknown'),(114,'Waiting feed list item deleted: %s.%s'),(115,'Bad command parameters: %s'),(116,'Public proxy lookup'),(117,'Waiting feed list has been cleared.'),(118,'Not enough matches for %s.%s: %s of %s'),(119,'Public proxy detected: %s.%s'),(120,'Failed proxy detection for %s.%s: %s'),(121,'Delete blacklisted item'),(122,'List out of item with range: %s - %s'),(123,'Data directory: %s'),(124,'Failed to create directory'),(125,'Failed to execute command'),(126,'Public proxy'),(127,'Show waiting proxy lookups'),(128,'Waiting proxy lookup list is empty.'),(129,'Waiting proxy lookups'),(130,'Time: %s'),(131,'Users: %s'),(132,'Feature is disabled.'),(133,'Total: %s'),(134,'Queued'),(135,'Waiting'),(136,'Failed to get version'),(137,'%s version: %s'),(138,'%s of %s'),(139,'Done'),(140,'My list is empty.'),(141,'Reload all lists'),(142,'My item'),(143,'Reload results'),(144,'Show my list'),(145,'New my item'),(146,'Delete my item'),(147,'My items: %s'),(148,'Excepted country: %s=%s'),(149,'Blocked country: %s=%s'),(150,'User nick to receive all feed messages'),(151,'Space separated country codes to block'),(152,'Space separated country codes to except'),(153,'Minimal class to receive feed messages'),(154,'Minimal class to access script commands'),(155,'Minimal class to skip public proxy lookup'),(156,'Minutes to delay same IP notifications'),(157,'Download operation timeout in seconds'),(158,'Enable blacklist list update notification'),(159,'Maximum number of blacklist search results'),(160,'Enable proxy lookup on user login or chat'),(161,'Email address required for proxy lookup'),(162,'Minimal number of public proxy matches'),(163,'Minutes to wait after hub is started'),(164,'Seconds to process proxy lookup queue'),(165,'Maximum number of proxy lookups to enqueue'),(166,'Maximum number of proxy lookups to send'),(167,'Explanation: %s'),(168,'Disable proxy lookup failure notifications'),(169,'Level of proxy lookup debug information'),(170,'User agent: %s'),(171,'Delete from waiting feed list'),(172,'Set list block action'),(173,'Item now set to block'),(174,'Item now set to notify'),(175,'Action: %s'),(176,'Block'),(177,'Notify'),(178,'Blocking blacklisted login from %s with IP %s.%s: %s'),(179,'Notifying blacklisted connection from %s.%s: %s'),(180,'Notifying blacklisted login from %s with IP %s.%s: %s'),(181,'Block action on public proxy detections'),(182,'Block action on my list item detections'),(183,'Notified connections: %s'),(184,'Blacklisted login exception from %s with IP %s.%s: %s'),(185,'Bot nick to register and send notifications'),(186,'Search in exceptions'),(187,'Except: %s'),(188,'Item exception now disabled'),(189,'Item exception now enabled'),(190,'Set list exception usage'),(191,'Exception usage on public proxy detections'),(192,'Exception usage on my list item detections'),(193,'Run exception lookup on notification actions'),(194,'Exception list out of IP %s.%s: %s'),(195,'Blocking blacklisted chat from %s with IP %s.%s: %s'),(196,'Chat: %s'),(197,'Notifying blacklisted chat from %s with IP %s.%s: %s'),(198,'Blacklisted chat exception from %s with IP %s.%s: %s'),(199,'Checking logged in user from IP %s.%s: %s'),(200,'Checking chat user from IP %s.%s: %s'),(201,'Local or private IP specified: %s.%s'),(202,'Maximum number of proxy lookups per day'),(203,'Resetting proxy lookup quote limit: %s'),(204,'Proxy lookup quote limit reached on logged in user from IP %s.%s: %s'),(205,'Proxy lookup quote limit reached on chat user from IP %s.%s: %s'),(206,'Proxy lookup quote'),(207,'Enable GeoIP ASN information on proxy detection'),(208,'Enable GeoIP ASN information on exception lookup'),(209,'Information not found'),(210,'Function not supported'),(211,'ASN: %s'),(212,'Disable or enable item'),(213,'Enabled'),(214,'Disabled'),(215,'Block action on ASN list item detections'),(216,'Exception usage on ASN list item detections'),(217,'ASN list'),(218,'ASN items: %s'),(219,'Show ASN list'),(220,'asn'),(221,'New ASN item'),(222,'Delete ASN item'),(223,'ASN list is empty.');

--
-- Table structure for table `py_bl_list`
--

CREATE TABLE `py_bl_list` (
  `list` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `update` smallint(4) unsigned NOT NULL DEFAULT '0',
  `off` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `action` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `except` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`list`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `py_bl_list`
--

INSERT INTO `py_bl_list` VALUES ('http://lists.blocklist.de/lists/all.txt','single','Tor exit',60,0,1,1),('http://list.iblocklist.com/?list=xoebmbyexwuiogmbyprb&fileformat=p2p&archiveformat=gz','gzip-p2p','Bluetack - Proxy',60,0,1,1),('http://te-home.net/blacklist.php?do=load&list=SOCKS','p2p','TE - SOCKS',60,0,1,1),('http://te-home.net/blacklist.php?do=load&list=Proxy','p2p','TE - Proxy',60,0,1,1),('http://te-home.net/blacklist.php?do=load&list=AP2P','p2p','TE - AP2P',60,0,1,1),('http://stopforumspam.com/downloads/listed_ip_7.gz','gzip-single','Stop Forum Spam',1440,0,1,1),('http://ledo.feardc.net/mirror/torexit.list','single','Tor exit',60,0,1,1),('http://ledo.feardc.net/mirror/torserver.list','single','Tor server',60,0,1,1);

--
-- Table structure for table `py_bl_myli`
--

CREATE TABLE `py_bl_myli` (
  `loaddr` int(10) unsigned NOT NULL,
  `hiaddr` int(10) unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `off` tinyint(1) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `addr_index` (`loaddr`,`hiaddr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `py_bl_myli`
--

INSERT INTO `py_bl_myli` VALUES (2965466784,2965466784,'malta09',0),(1558144830,1558144830,'VPN/Proxy',0),(3562248512,3562248512,'BLOCK VPN',0),(3584294912,3584360447,'vpn',0),(2997050974,2997050974,'Proxy',0),(2966695936,2966697983,'Ðåçàê',0),(3106737561,3106737561,'VPN(West)',0),(1535549312,1535549312,'Proxy',0),(1049959424,1049959935,'West',0),(2990966187,2990966187,'Proxy',0),(1397034766,1397034766,'Proxy',0),(2916404720,2916404720,'Public Proxy',0),(550623384,550623384,'Proxy',0),(2916404224,2916405247,'Public Proxy',0),(2536767488,2536833023,'sku',0),(1540947968,1541013503,'Torento',0);

--
-- Table structure for table `temp_rights`
--

CREATE TABLE `temp_rights` (
  `nick` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `op` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `since` int(11) DEFAULT NULL,
  `st_chat` int(11) DEFAULT '1',
  `st_search` int(11) DEFAULT '1',
  `st_ctm` int(11) DEFAULT '1',
  `st_pm` int(11) DEFAULT '1',
  `st_kick` int(11) DEFAULT '1',
  `st_share0` int(11) DEFAULT '1',
  `st_reg` int(11) DEFAULT '1',
  `st_opchat` int(11) DEFAULT '1',
  PRIMARY KEY (`nick`),
  KEY `creation_index` (`since`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `temp_rights`
--


--
-- Table structure for table `unbanlist`
--

CREATE TABLE `unbanlist` (
  `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nick` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ban_type` tinyint(4) DEFAULT '0',
  `host` text COLLATE utf8_unicode_ci,
  `range_fr` bigint(32) DEFAULT NULL,
  `range_to` bigint(32) DEFAULT NULL,
  `date_start` int(11) DEFAULT '0',
  `date_limit` int(11) DEFAULT NULL,
  `last_hit` int(11) DEFAULT NULL,
  `nick_op` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reason` text COLLATE utf8_unicode_ci,
  `share_size` varchar(18) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_unban` int(11) DEFAULT NULL,
  `unban_op` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `unban_reason` text COLLATE utf8_unicode_ci,
  `note_op` text COLLATE utf8_unicode_ci,
  `note_usr` text COLLATE utf8_unicode_ci,
  UNIQUE KEY `ip` (`ip`,`nick`,`date_unban`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unbanlist`
--


--
-- Table structure for table `users_list`
--

CREATE TABLE `users_list` (
  `nick` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users_list`
--



