Board Optimization - FUZZY SEO Booster - increase long tail search traffic AUTOMATICALLY!

New Version: 13th October 2010 - fixes the following:
1) searches that contain backslashes no longer give a database error
2) statistics pages cleanued up, improved pagination for big boards
3) random "ghost" keywords like "0h" now solved.

What does this plugin do?

It automatically increases your search engine traffic for long tail queries, by embedding the actual search terms that people use to find your site in an auto-updating tag cloud on every page.

This is one of the plugins used by SEOforums.org - the #1 SEO forum in google!

Full description, screenshots and more about this plugin is available here

I have also released a brand-free (gold) version here


Installation:


1. Download plugin archive and unzip it. You will find in the zip file, a product XML and

an "upload" folder.


2. Login to yor vBulletin admin control panel.


3. Open "Plugins & Products", and go to "Manage Products".

Click on "[Add/Import Product]".


4. Import the XML file that came with this download. Make sure you choose "allow

overwrite" = yes.

5. Upload all content from folder "upload" to you forum root direcory.


USAGE LICENSE AGREEMENT:
You are welcome to use this plugin free of charge on condition that the link in the footer remains. You can remove that by purchasing the brand free version over at my site (the link is at the top of this description).

~VB Staff Comment:

Please note that this modification adds a link to one of three of the developers sites to the footer of each page.

[washingtonboise]

Also hoping for 3.8.4

For good mods, we're gonna need a 'downgrade request' button that just keeps count.
I'm joining a swarm of people here.

[mikez006]

On the homepage the letter "f" is displaying in the search terms. Also when clicking "Browse Search terms" im seeing other one or two letter terms showing up. I see these in the list: 0, 1, 2, 3, 9, 1h, 0h, ph

I tried using the ban filter and added "f", but it still displayed.

[Jesh]

Doesn't like a lot of characters, any idea how to fix??

coin forums, waarde en fotos van ou munte, 1 dime valuta, coinforums, 硬币论坛, vispasaules izsoles monÄ“tu, seno monÄ“tu attÄ“li, מטבעות ×¤×œ×˜×™× ×”, numizmatične knjige, numizmaticke knjige, peso en gramos de moneda de dolar de 1795, forum sell platinum coins in europe, usa-mynt, forums munten, fotografia numismatica, numizmatika forumas, 0h, coin 1854-1889 de tres dollars oro, symboler pÃ¥ medaljer, numizmatika knjiga, how to grade coins forums, u.s. coin statistics, 1964 munte se waarde, korean numismatic, naklada kovanica hrvatski kovanica

[ps2wiz]

Originally Posted by lazerguy_82

Btw whenever a slash is in the query then there is a database error, as I get this email:
Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT * FROM seoqueries_terms WHERE term_value='some keyword\';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''some keyword\'' at line 1

Error Number : 1064
Request Date : Monday, April 5th 2010 @ 12:37:28 PM
Error Date : Monday, April 5th 2010 @ 12:37:29 PM

I get the same issue, please issue a fix!


Invalid SQL:
SELECT * FROM seoqueries_terms WHERE term_value='keyword\';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''keyword\'' at line 1
Error Number : 1064
Request Date : Monday, April 26th 2010 @ 03:37:56 PM
Error Date : Monday, April 26th 2010 @ 03:37:57 PM

[washingtonboise]

Bug: When viewing statistics, click on 'No of Searches' - the up/down arrow changes direction, but the list does not order itself by highest or lowest number of searches as would be expected.

[final kaoss]

I came up with an idea for this. What if it could create a user account with the same name as the keyword phrase used?

[algareem]

Originally Posted by haXan

Can you help me ?

Same problem , VB 3.8.4

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT * FROM seoqueries_terms WHERE term_value='xxxxx';

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Number : 1267

[final kaoss]

This is NOT for vbulletin 3.8.x theres your problem.

[algareem]

C'mon , Fix it

I dont think its a major problem . because everything works fine but it falls when it deal with complex phrases.

[trinyzap]

please make for vb 3.8.x