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.

[BSMedia]

Database error in vBulletin 4.0.1:

Invalid SQL:

						SELECT
							st.*, sd.founded
						FROM
							vb4_seoqueries_data sd
						LEFT JOIN
							vb4_seoqueries_terms st
							ON
							sd.stid = st.stid
						WHERE
							sd.page_type = 'index'
							AND
							sd.page_id = 0
						ORDER BY
							sd.founded DESC
						LIMIT;

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 '' at line 15
Error Number  : 1064
Request Date  : Tuesday, January 26th 2010 @ 11:12:32 AM
Error Date    : Tuesday, January 26th 2010 @ 11:12:32 AM
Script        : http://apertureforums.com/forum.php
Referrer      : http://apertureforums.com/admincp/index.php?do=head
IP Address    : 
Username      : David
Classname     : vB_Database
MySQL Version : 5.1.41

[bilgicc]

Same error.

Warning: Invalid argument supplied for foreach() in [path]/includes/class_bootstrap.php(399) : eval()'d code on line 112

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:4501) in [path]/includes/functions.php on line 4601

[iask]

Warning: Invalid argument supplied for foreach() in [path]/includes/class_bootstrap.php(399) : eval()'d code on line 178

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:4501) in [path]/includes/functions.php on line 3742

[LouisB]

^ Getting the same errors.

[MOGmartin]

NEW VERSION NOW UPLOADED

PLEASE READ THE INSTALLATION / UPGRADE INSTRUCTIONS, AS THERE ARE NOW FILES TO UPLOAD AS WELL....

PLEASE POST ANY BUG REPORTS FOR ME TO CHECK THROUGH!!!

thanks!

MOGmartin

[gbechtel]

New ver with the uploads seems to be working great!

[MOGmartin]

EXCELLENT!!!

let me know any other feedback people, I will be online again in an hour or so...

[Ju4nCh0]

Great job!!!!

Thanks a lot!!!

[BSMedia]

My Error seems to be fixed.

A couple of suggestions.

Create another new template called fseokeywords.css or whatever, and move all your inline styles out of the middle of pages and make a call to include it at the end of the headinclude template.

[ahmedbehiry]

would the new version solve the encoding issue as well?