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.

[final kaoss]

For everyone who paid to remove the link, here is the fix
goto plugin manager and find the part listed below
Untick the footer advertisement

Product : SEOforums.org Fuzzy SEO Booster RC2
Add plugin content to page templates     process_templates_complete         [Edit] [Delete]
Footer advertisment     global_start         [Edit] [Delete]
Forum Seoqueries     forumdisplay_start         [Edit] [Delete]
Forum Seoqueries     forumhome_start         [Edit] [Delete]
Forum Seoqueries     init_startup         [Edit] [Delete]
Forum Seoqueries     showthread_start         [Edit] [Delete]
Test template hook     cache_templates         [Edit] [Delete]

[oddmud]

Originally Posted by extreme-gaming

I don't see any reason to uninstall it as a matter of fact if this plugin essentially made tags in posts instead of the spammy little boxes that are sometimes left behind, I would be way more satisfied with this.

Because I no longer want it? vBSEO is doing a fine job for my SEO work. It's just added text on the screen that's not necessary.

[GONUMBER6]

I got this message in my email this morning, what does it mean?

PHP Code:

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT * FROM seoqueries_terms WHERE term_value='english bulldog forums\';

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 ''english bulldog forums\'' at line 1
Error Number  : 1064
Request Date  : Friday, October 8th 2010 @ 12:50:52 AM
Error Date    : Friday, October 8th 2010 @ 12:50:52 AM
Script        : http://www.englishbulldognews.com/forums/forum.php
Referrer      : http://www.google.com/url?sa=t&source=web&cd=1&ved=0CBIQFjAA&url=http%3A%2F%2Fwww.englishbulldognews.com%2Fforums%2Fforum.php&rct=j&q=english%20bulldog%20forums%5C&ei=Rr-uTMPIGoKBlAe42pnlDw&usg=AFQjCNHlQX0vQOzwsFmI0p63ieVH74K39w&sig2=yVeReUYchoAPvKwdUFViLQ
IP Address    : 99.108.3.106
Username      : Unregistered
Classname     : vB_Database
MySQL Version : 


[MOGmartin]

Originally Posted by GONUMBER6

I got this message in my email this morning, what does it mean?

PHP Code:

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT * FROM seoqueries_terms WHERE term_value='english bulldog forums\';

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 ''english bulldog forums\'' at line 1
Error Number  : 1064
Request Date  : Friday, October 8th 2010 @ 12:50:52 AM
Error Date    : Friday, October 8th 2010 @ 12:50:52 AM
Script        : http://www.englishbulldognews.com/forums/forum.php
Referrer      : http://www.google.com/url?sa=t&source=web&cd=1&ved=0CBIQFjAA&url=http%3A%2F%2Fwww.englishbulldognews.com%2Fforums%2Fforum.php&rct=j&q=english%20bulldog%20forums%5C&ei=Rr-uTMPIGoKBlAe42pnlDw&usg=AFQjCNHlQX0vQOzwsFmI0p63ieVH74K39w&sig2=yVeReUYchoAPvKwdUFViLQ
IP Address    : 99.108.3.106
Username      : Unregistered
Classname     : vB_Database
MySQL Version : 


Its a bug, if the search term used to find your site contains a backslash, it doesnt work. Refreshing makes it all ok, but thats obviously not ideal.

Ive got a bug fix for this coming out on Monday or Tuesday (Ive been fixing some other stuff in my other plugins this week).

thanks


MOGmartin

[GONUMBER6]

Originally Posted by MOGmartin

Its a bug, if the search term used to find your site contains a backslash, it doesnt work. Refreshing makes it all ok, but thats obviously not ideal.

Ive got a bug fix for this coming out on Monday or Tuesday (Ive been fixing some other stuff in my other plugins this week).

thanks


MOGmartin

Awesome thank you. I am also having a pageination issue. If I go under 'search keywords' the page is stretched out very far due to having 97 pages of search terms. I got a huge boost once I installed the vBET software- is there anyway you can stop this from going on and on and on? let me know if you need a print screen if you don't understand what I am talking about. Thanks, I love this plug in!

[MOGmartin]

Originally Posted by GONUMBER6

Awesome thank you. I am also having a pageination issue. If I go under 'search keywords' the page is stretched out very far due to having 97 pages of search terms. I got a huge boost once I installed the vBET software- is there anyway you can stop this from going on and on and on? let me know if you need a print screen if you don't understand what I am talking about. Thanks, I love this plug in!

LOL - I hear ya, the new release is actually primarily aimed at that problem. I checked mine the other day on seoforums.org and had over 1500 pages... its about a mile long!!

glad you like the plugin mate,

Martin

[GONUMBER6]

Great, be looking forward to the upgrade!

Should I be banning the single digit number searches? Like "5"? or "2h?" I am assuming these are crawlers of some sort. But then I got to thinkin' (I do this a LOT) that maybe someone will not land if the put in "5 star bulldogs"? Because 5 is banned?

[MOGmartin]

Originally Posted by GONUMBER6

Great, be looking forward to the upgrade!

Should I be banning the single digit number searches? Like "5"? or "2h?" I am assuming these are crawlers of some sort. But then I got to thinkin' (I do this a LOT) that maybe someone will not land if the put in "5 star bulldogs"? Because 5 is banned?

The last new option in the next version is "minimum query length", which will be set by default to 3, so any searches with 3 or less characters would not be recorded.

its a roundabout way, but will solve that problem.

[MOGmartin]

new version now released and available for download, sorry about the time it took guys!

[MOGmartin]

Originally Posted by semprot

Thanks. Downloaded. Pagination is perfect !

glad to hear you like it!

also - if you have any of those random keywords, like 0h that have creeped in, just delete them using the keyword search or keyword delete tools, they wont come back now after installing the new version.