Welcome Guest ( Log In | Register )

 Forum Rules Joomla Scraper support
 
Reply to this topicStart new topic
> Example Sql And Example Synonyms Database, how to make your own Synonym Database for Joomla Scraper
Web Design Seo
post Aug 27 2012, 01:00 PM
Post #1


Web Design Seo
****

Group: Root Admin
Posts: 4,161
Joined: 29-April 09
From: Sofia
Member No.: 1



Here is published example of synonyms database to use in Joomla Scraper:

Код
CREATE TABLE IF NOT EXISTS `wpa_synonyms_test` (
  `keyword` varchar(44) NOT NULL,
  `synonyms` text NOT NULL,
  PRIMARY KEY  (`keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `wpa_synonyms_test` (`keyword`, `synonyms`) VALUES ('back', 'aback,backward,rearward,regressively,to the rear');


This synonyms database example will be installed with every new copy of Joomla Scraper. If you upgrade component from previous version, use published here sql query to create this databse table - just open phpmyadmin and run this query.

What do this example:
This test synonym database is from only one line. Keyword "back" in content will be replaced with one random synonym from this list: "aback,backward,rearward,regressively,to the rear". So, if you want to test it, you must import some content with keyword "back" inside.

After install of bigger synonyms databases in this way, you can use synonym replacement - you can add manual more lines likw this in this synonym database. You will see in Joomla Scraper admin something like this:



After configuration of current rss feed, some of words in imported from Joomla Scraper content will be replaced with their synonyms.

If you want, you can purchase from here english synonym database formatted to work with our Scraper component


--------------------
Правила на форума | Forum Rules | How to receive support. 3D Web Design: Уеб дизайн, Seo оптимизация, Web Site Extensions, Oscommerce Addons, Wordpress plugins and Joomla Extensions. Изработка на уеб сайтове и оптимизация на сайт за търсачки и Seo услуги.
Go to the top of the page
 
+Quote Post
Web Design Seo
post Dec 12 2012, 07:41 AM
Post #2


Web Design Seo
****

Group: Root Admin
Posts: 4,161
Joined: 29-April 09
From: Sofia
Member No.: 1



More examples:

Example database must look in this way:
Код
CREATE TABLE IF NOT EXISTS `wpa_synonyms_en` (
  `keyword` varchar(20) NOT NULL,
  `synonyms` text NOT NULL,
  PRIMARY KEY  (`keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpa_synonyms_en`
--

INSERT INTO `wpa_synonyms_en` (`keyword`, `synonyms`) VALUES
('aback', 'back,backward,rearward,regressively,to the rear'),
('abalienate', 'alienate,estrange'),
next line.........
next line.........



And last line in your sql query must be like this:
Код
('yoke', 'bond,chain,link,tie,ligature');


--------------------
Правила на форума | Forum Rules | How to receive support. 3D Web Design: Уеб дизайн, Seo оптимизация, Web Site Extensions, Oscommerce Addons, Wordpress plugins and Joomla Extensions. Изработка на уеб сайтове и оптимизация на сайт за търсачки и Seo услуги.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

Collapse

> Similar Topics

  Topic Replies Topic Starter Views Last Action
No New Posts Synonyms, Nothing Changes
Synonyms, entities and quotes
2 papero de paperi 8,054 11th October 2018 - 04:42 PM
Last post by: Web Design Seo
No New Posts Pinned: Android Tv Box
Андроид ТВ бокс устройства, какво е това
0 Web Design Seo 16,248 21st December 2015 - 09:52 AM
Last post by: Web Design Seo


 



RSS Lo-Fi Version Time is now: 22nd October 2019 - 09:19 AM
Clicky Web Analytics