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.

[cobaku]

the mysql processes that are created by this mod seems to overload the server
could you optimize the plugin a bit.

[sportsbuddys]

Installed thank you. Still not sure exactly where the key words are showing up though... Excuse my noobness

[Cybeth]

Is it in the forum at all support? seoforum?

I have the gold by Paypal, but is not

1.3.2 RC2

no one responds to PN

[schlottkej]

How can we add this to the blogs or media section of the site?

[cobaku]

this line makes very heavy load on mysql
could anyone give me how to alter the table so
mysql may drop the load
is it something like this ?

PHP Code:

alter table tablename add index (cell1,cell2); 


if this is not solved this mod is completely useless for most of the people

PHP Code:

 $q = "
                        SELECT
                            st.*, sd.founded
                        FROM
                            ".$searchterms_data." sd
                        LEFT JOIN
                            ".$searchterms." st
                            ON
                            sd.stid = st.stid
                        WHERE
                            
                            sd.page_type = '".$type_id['type']."'
                            AND
                            sd.page_id = ".$type_id['id']."
                        ORDER BY
                            sd.founded DESC"; 


[hiker]

How often will the search phrases be added to the box? Will any maintenance/update counters benefit the rate at which they are added to the block?

[ps2wiz]

I paid for the Gold version of this mod 3 months ago and can not use it due to previously stated issues. Support is none existant, just check his official forum for more examples. Waste of my money.

[Cybeth]

Originally Posted by ps2wiz

I paid for the Gold version of this mod 3 months ago and can not use it due to previously stated issues. Support is none existant, just check his official forum for more examples. Waste of my money.

To me it's the same thing. The gold is not gold. There is no support in the official forum.

I'll report the PayPal

[cobaku]

the plugin itself is really wonderfull if you fix the issues yourself

[final kaoss]

share with us what you did to optimize it.