"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "install/data/seopanel.sql" between
seopanel.v.4.7.0.zip and seopanel.v.4.8.0.zip

About: Seo Panel is a seo control panel for managing search engine optimization of your websites.

seopanel.sql  (seopanel.v.4.7.0):seopanel.sql  (seopanel.v.4.8.0)
skipping to change at line 977 skipping to change at line 977
(33, 'Crawl relative links in a page', 'SP_RELATIVE_LINK_CRAWL', '1', 'siteaudit or', 'bool', 1), (33, 'Crawl relative links in a page', 'SP_RELATIVE_LINK_CRAWL', '1', 'siteaudit or', 'bool', 1),
(34, 'Enable HTTP Proxy Tunnel', 'CURLOPT_HTTPPROXYTUNNEL_VAL', '1', 'proxy', 'b ool', 1), (34, 'Enable HTTP Proxy Tunnel', 'CURLOPT_HTTPPROXYTUNNEL_VAL', '1', 'proxy', 'b ool', 1),
(35, 'Deactivate Proxy When Crawling Failed', 'PROXY_DEACTIVATE_CRAWL', '0', 'pr oxy', 'bool', 1), (35, 'Deactivate Proxy When Crawling Failed', 'PROXY_DEACTIVATE_CRAWL', '0', 'pr oxy', 'bool', 1),
(36, 'Check With Another Proxy When Crawling Failed', 'CHECK_WITH_ANOTHER_PROXY_ IF_FAILED', '0', 'proxy', 'bool', 1), (36, 'Check With Another Proxy When Crawling Failed', 'CHECK_WITH_ANOTHER_PROXY_ IF_FAILED', '0', 'proxy', 'bool', 1),
(37, 'SMTP Mail Port', 'SP_SMTP_PORT', '25', 'system', 'small', 1), (37, 'SMTP Mail Port', 'SP_SMTP_PORT', '25', 'system', 'small', 1),
(38, 'Time Zone', 'SP_TIME_ZONE', 'Europe/London', 'system', 'medium', 1), (38, 'Time Zone', 'SP_TIME_ZONE', 'Europe/London', 'system', 'medium', 1),
(39, 'Maximum number of proxies used in single execution', 'CHECK_MAX_PROXY_COUN T_IF_FAILED', '3', 'proxy', 'small', 1), (39, 'Maximum number of proxies used in single execution', 'CHECK_MAX_PROXY_COUN T_IF_FAILED', '3', 'proxy', 'small', 1),
(40, 'API Secret', 'API_SECRET', '', 'api', 'medium', 1), (40, 'API Secret', 'API_SECRET', '', 'api', 'medium', 1),
(41, 'Company Name', 'SP_COMPANY_NAME', 'Seo Panel', 'system', 'medium', 1), (41, 'Company Name', 'SP_COMPANY_NAME', 'Seo Panel', 'system', 'medium', 1),
(42, 'Currency', 'SP_PAYMENT_CURRENCY', 'USD', 'system', 'medium', 1), (42, 'Currency', 'SP_PAYMENT_CURRENCY', 'USD', 'system', 'medium', 1),
(43, 'Seo Panel version', 'SP_VERSION_NUMBER', '4.7.0', 'system', 'medium', 0), (43, 'Seo Panel version', 'SP_VERSION_NUMBER', '4.8.0', 'system', 'medium', 0),
(44, 'Moz API Link', 'SP_MOZ_API_LINK', 'http://lsapi.seomoz.com/linkscape', 'mo z', 'medium', 0), (44, 'Moz API Link', 'SP_MOZ_API_LINK', 'http://lsapi.seomoz.com/linkscape', 'mo z', 'medium', 0),
(45, 'Moz API Link', 'SP_MOZ_API_ACCESS_ID', '', 'moz', 'large', 1), (45, 'Moz API Link', 'SP_MOZ_API_ACCESS_ID', '', 'moz', 'large', 1),
(46, 'Moz API Link', 'SP_MOZ_API_SECRET', '', 'moz', 'large', 1), (46, 'Moz API Link', 'SP_MOZ_API_SECRET', '', 'moz', 'large', 1),
(47, 'Page authority check level first', 'SA_PA_CHECK_LEVEL_FIRST', '40', 'sitea uditor', 'small', 0), (47, 'Page authority check level first', 'SA_PA_CHECK_LEVEL_FIRST', '40', 'sitea uditor', 'small', 0),
(48, 'Page authority check level second', 'SA_PA_CHECK_LEVEL_SECOND', '75', 'sit eauditor', 'small', 0), (48, 'Page authority check level second', 'SA_PA_CHECK_LEVEL_SECOND', '75', 'sit eauditor', 'small', 0),
(49, 'Google API Key', 'SP_GOOGLE_API_KEY', '', 'google', 'large', 1), (49, 'Google API Key', 'SP_GOOGLE_API_KEY', '', 'google', 'large', 1),
(50, 'Number of websites needs to be checked in each cron execution', 'SP_NUMBER _WEBSITES_CRON', '1', 'report', 'small', 0), (50, 'Number of websites needs to be checked in each cron execution', 'SP_NUMBER _WEBSITES_CRON', '1', 'report', 'small', 0),
(51, 'Send custom header with curl request', 'SP_SEND_CUSTOM_HEADER_IN_CURL', '1 ', 'report', 'bool', 1), (51, 'Send custom header with curl request', 'SP_SEND_CUSTOM_HEADER_IN_CURL', '1 ', 'report', 'bool', 1),
(52, 'Google API Client Id', 'SP_GOOGLE_API_CLIENT_ID', '', 'google', 'large', 1 ), (52, 'Google API Client Id', 'SP_GOOGLE_API_CLIENT_ID', '', 'google', 'large', 1 ),
(53, 'Google API Client Secret', 'SP_GOOGLE_API_CLIENT_SECRET', '', 'google', 'l arge', 1), (53, 'Google API Client Secret', 'SP_GOOGLE_API_CLIENT_SECRET', '', 'google', 'l arge', 1),
skipping to change at line 1398 skipping to change at line 1398
-- --
-- Seo Panel 4.7.0 changes -- Seo Panel 4.7.0 changes
-- --
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set _type`, `display`) VALUES INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set _type`, `display`) VALUES
('Enable reCAPTCHA', 'SP_ENABLE_RECAPTCHA', '0', 'google', 'bool', 1), ('Enable reCAPTCHA', 'SP_ENABLE_RECAPTCHA', '0', 'google', 'bool', 1),
('reCAPTCHA Site Key', 'SP_RECAPTCHA_SITE_KEY', '', 'google', 'large', 1), ('reCAPTCHA Site Key', 'SP_RECAPTCHA_SITE_KEY', '', 'google', 'large', 1),
('reCAPTCHA Secret Key', 'SP_RECAPTCHA_SECRET_KEY', '', 'google', 'large', 1); ('reCAPTCHA Secret Key', 'SP_RECAPTCHA_SECRET_KEY', '', 'google', 'large', 1);
--
-- Seo Panel 4.8.0 changes
--
UPDATE `searchengines` SET `regex` = '<div.*?class=\"?g.*?>.*?<div.*?class=\"r.*
?\">.*?<a href=\"(.*?)\".*?>.*?<h3.*?>(.*?)<\\/h3>'
WHERE `url` LIKE '%google%';
INSERT INTO `settings` (`set_label`, `set_name`, `set_val`, `set_category`, `set
_type`, `display`) VALUES
('Country', 'SP_DEFAULT_COUNTRY', 'US', 'system', 'small', 1),
('Enable DataForSEO', 'SP_ENABLE_DFS', '0', 'dataforseo', 'bool', 1),
('DataForSEO API Login', 'SP_DFS_API_LOGIN', '', 'dataforseo', 'large', 1),
('DataForSEO API Password', 'SP_DFS_API_PASSWORD', '', 'dataforseo', 'large', 1)
,
('DataForSEO Balance', 'SP_DFS_BALANCE', '0', 'dataforseo', 'small', 1),
('Enable for Backlink and Saturation Checker', 'SP_ENABLE_DFS_BACK_SATU', '0', '
dataforseo', 'bool', 1),
('Enable Sandbox', 'SP_ENABLE_DFS_SANDBOX', '0', 'dataforseo', 'bool', 1);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 End of changes. 2 change blocks. 
1 lines changed or deleted 21 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)