| 155 |
- |
1 |
--
|
|
|
2 |
-- Seo Panel 3.5.0 changes
|
|
|
3 |
--
|
|
|
4 |
UPDATE `searchengines` SET `regex` = '<li.*?<h3><a.*?RU=(.*?)\\/.*?>(.*?)<\\/a><\\/h3>.*?<div.*?>(.*?)<\\/div>' WHERE url like '%yahoo%';
|
|
|
5 |
|
|
|
6 |
UPDATE `searchengines` SET `max_results` = '50' WHERE url like '%bing.com%';
|
|
|
7 |
|
|
|
8 |
--
|
|
|
9 |
-- Table structure for table `crawl_log`
|
|
|
10 |
--
|
|
|
11 |
|
|
|
12 |
CREATE TABLE IF NOT EXISTS `crawl_log` (
|
|
|
13 |
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
14 |
`crawl_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'other',
|
|
|
15 |
`ref_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
16 |
`subject` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
17 |
`crawl_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
18 |
`crawl_referer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
19 |
`crawl_cookie` text COLLATE utf8_unicode_ci NOT NULL,
|
|
|
20 |
`crawl_post_fields` text COLLATE utf8_unicode_ci NOT NULL,
|
|
|
21 |
`crawl_useragent` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
22 |
`crawl_status` tinyint(4) NOT NULL DEFAULT '1',
|
|
|
23 |
`proxy_id` int(11) unsigned NOT NULL,
|
|
|
24 |
`log_message` text COLLATE utf8_unicode_ci NOT NULL,
|
|
|
25 |
`crawl_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
26 |
PRIMARY KEY (`id`),
|
|
|
27 |
KEY `crawl_status` (`crawl_status`),
|
|
|
28 |
KEY `crawl_type` (`crawl_type`),
|
|
|
29 |
KEY `ref_id` (`ref_id`),
|
|
|
30 |
KEY `proxy_id` (`proxy_id`)
|
|
|
31 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
|
|
|
32 |
|
|
|
33 |
CREATE TABLE IF NOT EXISTS `timezone` (
|
|
|
34 |
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
35 |
`timezone_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
36 |
`timezone_label` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
37 |
PRIMARY KEY (`id`)
|
|
|
38 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=91 ;
|
|
|
39 |
|
|
|
40 |
INSERT INTO `timezone` (`id`, `timezone_name`, `timezone_label`) VALUES
|
|
|
41 |
(1, 'Pacific/Midway', '(GMT-11:00) Midway Island, Samoa'),
|
|
|
42 |
(2, 'America/Adak', '(GMT-10:00) Hawaii-Aleutian'),
|
|
|
43 |
(3, 'Etc/GMT+10', '(GMT-10:00) Hawaii'),
|
|
|
44 |
(4, 'Pacific/Marquesas', '(GMT-09:30) Marquesas Islands'),
|
|
|
45 |
(5, 'Pacific/Gambier', '(GMT-09:00) Gambier Islands'),
|
|
|
46 |
(6, 'America/Anchorage', '(GMT-09:00) Alaska'),
|
|
|
47 |
(7, 'America/Ensenada', '(GMT-08:00) Tijuana, Baja California'),
|
|
|
48 |
(8, 'Etc/GMT+8', '(GMT-08:00) Pitcairn Islands'),
|
|
|
49 |
(9, 'America/Los_Angeles', '(GMT-08:00) Pacific Time (US & Canada)'),
|
|
|
50 |
(10, 'America/Denver', '(GMT-07:00) Mountain Time (US & Canada)'),
|
|
|
51 |
(11, 'America/Chihuahua', '(GMT-07:00) Chihuahua, La Paz, Mazatlan'),
|
|
|
52 |
(12, 'America/Dawson_Creek', '(GMT-07:00) Arizona'),
|
|
|
53 |
(13, 'America/Belize', '(GMT-06:00) Saskatchewan, Central America'),
|
|
|
54 |
(14, 'America/Cancun', '(GMT-06:00) Guadalajara, Mexico City, Monterrey'),
|
|
|
55 |
(15, 'Chile/EasterIsland', '(GMT-06:00) Easter Island'),
|
|
|
56 |
(16, 'America/Chicago', '(GMT-06:00) Central Time (US & Canada)'),
|
|
|
57 |
(17, 'America/New_York', '(GMT-05:00) Eastern Time (US & Canada)'),
|
|
|
58 |
(18, 'America/Havana', '(GMT-05:00) Cuba'),
|
|
|
59 |
(19, 'America/Bogota', '(GMT-05:00) Bogota, Lima, Quito, Rio Branco'),
|
|
|
60 |
(20, 'America/Caracas', '(GMT-04:30) Caracas'),
|
|
|
61 |
(21, 'America/Santiago', '(GMT-04:00) Santiago'),
|
|
|
62 |
(22, 'America/La_Paz', '(GMT-04:00) La Paz'),
|
|
|
63 |
(23, 'Atlantic/Stanley', '(GMT-04:00) Faukland Islands'),
|
|
|
64 |
(24, 'America/Campo_Grande', '(GMT-04:00) Brazil'),
|
|
|
65 |
(25, 'America/Goose_Bay', '(GMT-04:00) Atlantic Time (Goose Bay)'),
|
|
|
66 |
(26, 'America/Glace_Bay', '(GMT-04:00) Atlantic Time (Canada)'),
|
|
|
67 |
(27, 'America/St_Johns', '(GMT-03:30) Newfoundland'),
|
|
|
68 |
(28, 'America/Araguaina', '(GMT-03:00) UTC-3'),
|
|
|
69 |
(29, 'America/Montevideo', '(GMT-03:00) Montevideo'),
|
|
|
70 |
(30, 'America/Miquelon', '(GMT-03:00) Miquelon, St. Pierre'),
|
|
|
71 |
(31, 'America/Godthab', '(GMT-03:00) Greenland'),
|
|
|
72 |
(32, 'America/Argentina/Buenos_Aires', '(GMT-03:00) Buenos Aires'),
|
|
|
73 |
(33, 'America/Sao_Paulo', '(GMT-03:00) Brasilia'),
|
|
|
74 |
(34, 'America/Noronha', '(GMT-02:00) Mid-Atlantic'),
|
|
|
75 |
(35, 'Atlantic/Cape_Verde', '(GMT-01:00) Cape Verde Is.'),
|
|
|
76 |
(36, 'Atlantic/Azores', '(GMT-01:00) Azores'),
|
|
|
77 |
(37, 'Europe/Belfast', '(GMT) Greenwich Mean Time : Belfast'),
|
|
|
78 |
(38, 'Europe/Dublin', '(GMT) Greenwich Mean Time : Dublin'),
|
|
|
79 |
(39, 'Europe/Lisbon', '(GMT) Greenwich Mean Time : Lisbon'),
|
|
|
80 |
(40, 'Europe/London', '(GMT) Greenwich Mean Time : London'),
|
|
|
81 |
(41, 'Africa/Abidjan', '(GMT) Monrovia, Reykjavik'),
|
|
|
82 |
(42, 'Europe/Berlin', '(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna'),
|
|
|
83 |
(43, 'Europe/Belgrade', '(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague'),
|
|
|
84 |
(44, 'Europe/Brussels', '(GMT+01:00) Brussels, Copenhagen, Madrid, Paris'),
|
|
|
85 |
(45, 'Africa/Algiers', '(GMT+01:00) West Central Africa'),
|
|
|
86 |
(46, 'Africa/Windhoek', '(GMT+01:00) Windhoek'),
|
|
|
87 |
(47, 'Asia/Beirut', '(GMT+02:00) Beirut'),
|
|
|
88 |
(48, 'Africa/Cairo', '(GMT+02:00) Cairo'),
|
|
|
89 |
(49, 'Asia/Gaza', '(GMT+02:00) Gaza'),
|
|
|
90 |
(50, 'Africa/Blantyre', '(GMT+02:00) Harare, Pretoria'),
|
|
|
91 |
(51, 'Asia/Jerusalem', '(GMT+02:00) Jerusalem'),
|
|
|
92 |
(52, 'Europe/Minsk', '(GMT+02:00) Minsk'),
|
|
|
93 |
(53, 'Asia/Damascus', '(GMT+02:00) Syria'),
|
|
|
94 |
(54, 'Europe/Moscow', '(GMT+03:00) Moscow, St. Petersburg, Volgograd'),
|
|
|
95 |
(55, 'Africa/Addis_Ababa', '(GMT+03:00) Nairobi'),
|
|
|
96 |
(56, 'Asia/Tehran', '(GMT+03:30) Tehran'),
|
|
|
97 |
(57, 'Asia/Dubai', '(GMT+04:00) Abu Dhabi, Muscat'),
|
|
|
98 |
(58, 'Asia/Yerevan', '(GMT+04:00) Yerevan'),
|
|
|
99 |
(59, 'Asia/Kabul', '(GMT+04:30) Kabul'),
|
|
|
100 |
(60, 'Asia/Yekaterinburg', '(GMT+05:00) Ekaterinburg'),
|
|
|
101 |
(61, 'Asia/Tashkent', '(GMT+05:00) Tashkent'),
|
|
|
102 |
(62, 'Asia/Kolkata', '(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi'),
|
|
|
103 |
(63, 'Asia/Katmandu', '(GMT+05:45) Kathmandu'),
|
|
|
104 |
(64, 'Asia/Dhaka', '(GMT+06:00) Astana, Dhaka'),
|
|
|
105 |
(65, 'Asia/Novosibirsk', '(GMT+06:00) Novosibirsk'),
|
|
|
106 |
(66, 'Asia/Rangoon', '(GMT+06:30) Yangon (Rangoon)'),
|
|
|
107 |
(67, 'Asia/Bangkok', '(GMT+07:00) Bangkok, Hanoi, Jakarta'),
|
|
|
108 |
(68, 'Asia/Krasnoyarsk', '(GMT+07:00) Krasnoyarsk'),
|
|
|
109 |
(69, 'Asia/Hong_Kong', '(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi'),
|
|
|
110 |
(70, 'Asia/Irkutsk', '(GMT+08:00) Irkutsk, Ulaan Bataar'),
|
|
|
111 |
(71, 'Australia/Perth', '(GMT+08:00) Perth'),
|
|
|
112 |
(72, 'Australia/Eucla', '(GMT+08:45) Eucla'),
|
|
|
113 |
(73, 'Asia/Tokyo', '(GMT+09:00) Osaka, Sapporo, Tokyo'),
|
|
|
114 |
(74, 'Asia/Seoul', '(GMT+09:00) Seoul'),
|
|
|
115 |
(75, 'Asia/Yakutsk', '(GMT+09:00) Yakutsk'),
|
|
|
116 |
(76, 'Australia/Adelaide', '(GMT+09:30) Adelaide'),
|
|
|
117 |
(77, 'Australia/Darwin', '(GMT+09:30) Darwin'),
|
|
|
118 |
(78, 'Australia/Brisbane', '(GMT+10:00) Brisbane'),
|
|
|
119 |
(79, 'Australia/Hobart', '(GMT+10:00) Hobart'),
|
|
|
120 |
(80, 'Asia/Vladivostok', '(GMT+10:00) Vladivostok'),
|
|
|
121 |
(81, 'Australia/Lord_Howe', '(GMT+10:30) Lord Howe Island'),
|
|
|
122 |
(82, 'Etc/GMT-11', '(GMT+11:00) Solomon Is., New Caledonia'),
|
|
|
123 |
(83, 'Asia/Magadan', '(GMT+11:00) Magadan'),
|
|
|
124 |
(84, 'Pacific/Norfolk', '(GMT+11:30) Norfolk Island'),
|
|
|
125 |
(85, 'Asia/Anadyr', '(GMT+12:00) Anadyr, Kamchatka'),
|
|
|
126 |
(86, 'Pacific/Auckland', '(GMT+12:00) Auckland, Wellington'),
|
|
|
127 |
(87, 'Etc/GMT-12', '(GMT+12:00) Fiji, Kamchatka, Marshall Is.'),
|
|
|
128 |
(88, 'Pacific/Chatham', '(GMT+12:45) Chatham Islands'),
|
|
|
129 |
(89, 'Pacific/Tongatapu', '(GMT+13:00) Nuku''alofa'),
|
|
|
130 |
(90, 'Pacific/Kiritimati', '(GMT+14:00) Kiritimati');
|
|
|
131 |
|
|
|
132 |
INSERT INTO `settings`(`set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`) VALUES
|
|
|
133 |
('Time Zone', 'SP_TIME_ZONE', '', 'system', 'medium', '1');
|