| 155 |
- |
1 |
--
|
|
|
2 |
-- Seo Panel 3.13.0 changes
|
|
|
3 |
--
|
|
|
4 |
|
|
|
5 |
update `settings` set set_val='3.13.0' WHERE `set_name` LIKE 'SP_VERSION_NUMBER';
|
|
|
6 |
|
|
|
7 |
UPDATE `currency` SET `symbol` = '£' WHERE `currency`.`id` =25;
|
|
|
8 |
|
|
|
9 |
UPDATE `searchengines` SET `regex` = '<div.*?class="?g.*?><h3 class="r"><a href="(.*?)".*?>(.*?)<\\/a>.*?<\\/div><span.*?>(.*?)<\\/span>' WHERE `url` LIKE '%google%';
|
|
|
10 |
|
|
|
11 |
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set_type`, `display`) VALUES
|
|
|
12 |
('Send custom header with curl request', 'SP_SEND_CUSTOM_HEADER_IN_CURL', '1', 'report', 'bool', 1);
|
|
|
13 |
|
|
|
14 |
--
|
|
|
15 |
-- Quick web proxy plugin
|
|
|
16 |
--
|
|
|
17 |
|
|
|
18 |
INSERT INTO `seoplugins` (`label`, `name`, `author`, `description`, `version`, `website`, `status`, `installed`) VALUES
|
|
|
19 |
('Quick Web Proxy', 'QuickWebProxy', 'Seo Panel', 'It will help you to create a web proxy server using your hosting server or external proxy servers', '1.0.0', 'https://www.seopanel.in/plugin/l/94/quick-web-proxy/', 1, 1);
|
|
|
20 |
|
|
|
21 |
CREATE TABLE IF NOT EXISTS `qwp_settings` (
|
|
|
22 |
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
23 |
`set_label` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
|
|
|
24 |
`set_name` varchar(64) CHARACTER SET latin1 NOT NULL,
|
|
|
25 |
`set_val` text COLLATE utf8_unicode_ci NOT NULL,
|
|
|
26 |
`set_type` enum('small','bool','medium','large','text') CHARACTER SET latin1 DEFAULT 'small',
|
|
|
27 |
PRIMARY KEY (`id`),
|
|
|
28 |
UNIQUE KEY `set_name` (`set_name`)
|
|
|
29 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
|
|
|
30 |
|
|
|
31 |
--
|
|
|
32 |
-- Dumping data for table `qwp_settings`
|
|
|
33 |
--
|
|
|
34 |
|
|
|
35 |
INSERT INTO `qwp_settings` (`set_label`, `set_name`, `set_val`, `set_type`) VALUES
|
|
|
36 |
('Allow user to access the web proxy', 'QWP_ALLOW_USER_WEB_PROXY', '0', 'bool'),
|
|
|
37 |
('Allow web server to act as a proxy', 'QWP_ALLOW_WEB_SERVER_ACT_AS_PROXY', '1', 'bool')
|
|
|
38 |
ON DUPLICATE KEY UPDATE `set_type`=`set_type`;
|