Example Sql And Example Synonyms Database, how to make your own Synonym Database for Joomla Scraper Options

[Web Design Seo]

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

[Web Design Seo]

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');