| 155 |
- |
1 |
--
|
|
|
2 |
-- This section includes the database changes of Seo Panel version from 2.2.0 to 2.3.0
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
--
|
|
|
6 |
-- to update google urls for disable instant search option
|
|
|
7 |
--
|
|
|
8 |
Update `searchengines` set `cookie_send`='',`url`=concat(url,'&as_qdr=all') WHERE `domain` LIKE "%google%";
|
|
|
9 |
|
|
|
10 |
--
|
|
|
11 |
-- To add user agent field to system settings
|
|
|
12 |
--
|
|
|
13 |
INSERT INTO `settings` (
|
|
|
14 |
`id` ,
|
|
|
15 |
`set_label` ,
|
|
|
16 |
`set_name` ,
|
|
|
17 |
`set_val` ,
|
|
|
18 |
`set_type`
|
|
|
19 |
)
|
|
|
20 |
VALUES (
|
|
|
21 |
NULL , 'User agent', 'SP_USER_AGENT', 'Mozilla/5.0 (Windows; U; MSIE 9.0; WIndows NT 9.0; en-US))', 'large'
|
|
|
22 |
);
|
|
|
23 |
|
|
|
24 |
--
|
|
|
25 |
-- To fix the issues with google parsing
|
|
|
26 |
--
|
|
|
27 |
ALTER TABLE `searchengines` ADD `from_pattern` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `regex`;
|
|
|
28 |
ALTER TABLE `searchengines` ADD `to_pattern` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `from_pattern`;
|
|
|
29 |
update searchengines set from_pattern='<div id="ires">',to_pattern='<\\/ol>' where url LIKE '%google%';
|
|
|
30 |
|
|
|
31 |
--
|
|
|
32 |
-- To fix yahoo search engine url issue
|
|
|
33 |
--
|
|
|
34 |
update searchengines set regex='<li.*?<h3><a.*?\\*\\*(.*?)".*?>(.*?)<\\/a><\\/h3>.*?<div.*?>(.*?)<\\/div>.*?<\\/span>',url_index=1,title_index=2,description_index=3 where url LIKE '%yahoo%';
|
|
|
35 |
|
|
|
36 |
--
|
|
|
37 |
-- Changes for search engine like yandex
|
|
|
38 |
--
|
|
|
39 |
ALTER TABLE searchengines ADD `start_offset` INT( 8 ) NOT NULL DEFAULT '0' AFTER `start`;
|
|
|
40 |
UPDATE `searchengines` SET `start_offset` = `no_of_results_page`;
|