vB Google Search Cloud - SEO

[NeutralizeR]

Simple Search Cloud Script by Dan Fletcher (http://buymyscripts.net)
vBulletin Integration by NeutralizeR (http://www.MsXLabs.org)

vB Google Search Cloud

Simple Search Cloud
https://vborg.vbsupport.ru/

A search cloud is like a tag cloud (http://en.wikipedia.org/wiki/Tag_cloud), that you find on blogs- except instead of showing a cloud of tags, it shows a cloud of search terms used to access the site.

It shows different searches visitors have used to get to your website. The more people that searched for a particular term- the bigger that term will appear in the cloud.

This script is easy to install, particularly if you have a PHP based website (like a blog, a script, a forum, etc).

It will increase your page views (because it encourages customers to explore more), and is also great for SEO.

More about search clouds...

One of the best ways to get targeted traffic to your website is through the search engines. And how much traffic you get will be based on how high you appear in the search engine rankings. So it is important to spend some of your marketing time trying to improve your search engine rankings. There are many ways to do this, but the two main ways are changing the text on your website, and increasing the links to your website.

You also need to look at the actual links on your website- make sure you link to your important pages, and use good anchor text (which is the text that your link appears as, eg a link to bluewidgets.com might appear as "blue widgets", so "blue widgets is the anchor text"). A great way to optimize your internal links is to use a "search cloud". A search cloud appears on your website (often on the side), and is a large list of words. Each word is a link, and they are all different sizes. Each word is something that someone searched for when they came to your website. If a lot of people search for a certain word, then that word will appear bigger in the cloud.

Search clouds help with your search engine rankings, because they ensure that you have internal links with the anchor text that people are actually searching for. Often people will guess what anchor text they should use- but they often get it wrong. A search cloud solves this problem- because it?s based on live results based on what people actually searched for. Lets say that you get some traffic for the search phrase "blue widgets". If someone visits your site after searching for "blue widgets", then the search cloud will now show "blue widgets", with a link to the relevant page. Now you have extra links to "blue widgets", you are more likely to rank higher for that term.

There are other benefits to search clouds as well. They can help lead your customers to your more important pages. If someone searches for "red widget", and then sees that the biggest phrase in your search cloud is for "blue widgets", they instantly know that your site is popular for blue widgets, and may go and visit the page. Search clouds also encourage visitors to explore your, which will help increase the average page views per visitor. This can mean more income, whether it?s in the form of extra sales, or more revenue from advertising. You can usually add a search cloud quite easily to your website.


Dan Fletcher

vBulletin Integration

Shorthly, vB Google Search Cloud product will fully integrate Simple Search Cloud script with your forum.
The default script didn't work for me so i changed some variables and added a function to display the hits of each search term + make-up for vBulletin.

Installation Instructions

1-) Upload search_cloud.php to your forum root.
2-) Import the product-vbgooglesearchcloud.xml.
3-) Put $searchcloud in any template you want to display your search cloud. e.g. footer

Upgrade Instructions

- (This step is for v1.0.3 only - Uninstall vB Google Search Cloud product.)

- Overwrite search_cloud.php with the new one.
- Import product-vbgooglesearchcloud.xml.

Optional

Open search_cloud.php and change these lines if needed:
// Variables you can set (if you want), but the defaults are fine.

var $m_minFont = 75; // The minimum font size. No keywords will be smaller than this. This is a %
var $m_maxFont = 150; // The maximum font size. No keywords will be bigger than this. This is a %
var $m_averageFont = 100; // The font size of an average searhced for keyword. This is a %
var $m_maxEntries = 100; // Maximum number of entries displayed in the cloud
var $m_showCount = 0; // Whether counts are shown along with each entry

var $m_blackList = array(); // list of disallowed words. An example is commented out below...
//var $m_blackList = array("sex","boob","cheatz");Template
If you want to change something in the template > Search Templates > searchcloud


vBadvanced CMPS Integration

vBa CMPS > Add Module > Template Module

Module Title: Search Cloud
Template to Include: adv_portal_searchcloud
Template Content: <tr>
<td class="$bgclass" style="text-align:justify">
$vbsearchcloud
</td>
</tr>Use Module Wrapper Template: Yes

Open vBadvanced Main Options and add vbsearchcloud to Portal Output Global Variables box.

Versions
v1.0.0 - May 10 2008
-First release
v1.0.1 - May 10 2008
-Fixed uncached template bug
v1.0.2 - May 15 2008
-Fixed security issue
-Added option to disable/enable hit counts
-Added blacklist option to disallow specific words
v1.0.3 - May 15 2008
-Changed mySQL variables so you don't have to enter the db details
v1.0.4 - May 16 2008
-Fixed bug: hit counts don't work
v1.0.5 - May 19 2008
-Added PHP 4 compatibility
-Small template changes

Demo
http://www.msxlabs.org/forum/

[iogames]

Do I have to buy something?

[NeutralizeR]

Do I have to buy something?
No, it's free.

[Ryuk]

im a bit noob at SEO so, how does this helps improving site seo?

[NeutralizeR]

im a bit noob at SEO so, how does this helps improving site seo?
It will increase your page views (because it encourages customers to explore more), and is also great for SEO.Actually it'd be better to have search terms per forum/per thread. But this is a simple script. It does list the search phrases that your site found by, and so increases the keyword density for your top content. By default, having 50 search terms looks alright. You can set it to 100-200 if you will only display it on a seperate page like zoints tags. You can also use this script to log your google hits. Adding search term to the related thread as a tag or creating new threads with the title of the search term will help building more related content and improving SEO.

[arena]

Thanks ..


var $m_dbpath = " "; // Path to DB ? i dont understand

[NeutralizeR]

Thanks ..


var $m_dbpath = " "; // Path to DB ? i dont understand

Enter "localhost" there if you are running only one server, otherwise enter the IP of your database server.

[ABDALWAHID]

Thx! *installed*

i have problem with Turkish characters

ma�aralardakİ sarkit ve dİkİtler

�anlıurfa,nın efsanesi

[NeutralizeR]

I fixed this problem with iconv support.

Open search_cloud.php and find:
if ($a > 0.8)

Add above:
$datas[kw]=iconv("utf-8","iso-8859-9",$datas[kw]);

[ABDALWAHID]

Thank you murat, süpersinnnnnn...

[NeutralizeR]

Update

v1.0.1 - May 10 2008
Fixed uncached template bug

[Animparadise]

where i can limit its tags?
just show 10 or 20 most tags

[NeutralizeR]

where i can limit its tags?
just show 10 or 20 most tags
In search_cloud.php:

var $m_maxEntries = 100; // Maximum number of entries displayed in the cloud

[fatihebru]

thanks

[ABDALWAHID]

I will not pay off this, I mean for current keywords we have to empty table?

I have a question,
Can we even keywords more than 3 size and color with h1 h2 use with css?

And I'm really sorry for my english. I can not english that is a translation of google:)

[NeutralizeR]

I will not pay off this, I mean for current keywords we have to empty table?

I have a question,
Can we even keywords more than 3 size and color with h1 h2 use with css?

And I'm really sorry for my english. I can not english that is a translation of google:)
Currently, there is no function to delete the search terms.
You can edit search_cloud.php to change the font style-color.

<a href='$datas[url]' style='font-size:$fontSize%'>To change font-size:
var $m_minFont = 75; // The minimum font size. No keywords will be smaller than this. This is a %
var $m_maxFont = 150; // The maximum font size. No keyworkd will be bigger than this. This is a %
var $m_averageFont = 100; // The font size of an average searhced for keyword. This is a %

[ABDALWAHID]

I think for any size a different color

[slowphantom]

thx install

[Animparadise]

thx man , after alot of time i saw a real support :p
do i allow to integrate your hack with atakan tag cloud?

[unitedpunjab]

Possible to blacklist a tag ?

[NeutralizeR]

thx man , after alot of time i saw a real support :p
do i allow to integrate your hack with atakan tag cloud?

Sure.

Possible to blacklist a tag ?

Since the search terms are automatically generated by Google targetting your content, no.

[dtv100]

i just install it on my forum but no tags show yet .
how long takes to show tags?

[NeutralizeR]

i just install it on my forum but no tags show yet .
how long takes to show tags?
With the first hit from a Google Search Result.

[dtv100]

thank you for reply .
can this be use on 3.6.x ?

[NeutralizeR]

thank you for reply .
can this be use on 3.6.x ?
Yes.

[with you]

Thanks..

[dtv100]

now is working thanks I using 3.6.10 and 3.7 both version working good .

nominate for mod of the month
thanks.

[alhindasi]

it is not working whith arabic it show only English words please can you help me ,,,

[alhindasi]

it is showing like that see whit out arabic language it is working with English only

1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 2 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 2 - 1 - 1 - 1 - 2 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 - 1 -

[ABDALWAHID]

it is not working whith arabic it show only English words please can you help me ,,,


https://vborg.vbsupport.ru/showpost.php?p=1514679&postcount=9
Have you tried? Of course with the Arab character set.

[hdrmut]

Thanx


When I enable the product I get this error :

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host ' localhost ' (1) in [path]/search_cloud.php on line 118



i think my problem with : localhost !!

I will show you my fake data base info :

can YOU CHECK ?

//Variables you need to set...

var $m_databaseName = " yahoo_nano "; // Database where everything is stored
var $m_databaseUser = " yahoo_neen "; // Username to access database
var $m_databasePassword = " 123456 "; // Password to access database
var $m_dbpath = " localhost "; // Path to DB

// Varables you can set (if you want), but the defaults are fine.

I use space before and after yahoo_nano and password

[hdrmut]

it is showing like that see whit out arabic language it is working with English only

use this :

$datas[kw]=iconv("utf-8","windows-1256",$datas[kw]);


Its work :)



hdrmut.net (http://hdrmut.net)

[rizelim]

Thanks

[NeutralizeR]

Open your includes/config.php file and check $config['MasterServer']['servername'] = setting.
Enter the same info for var $m_dbpath =

[hdrmut]

Still This error :
only in forum home and forumdisplay



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33

[NeutralizeR]

Still This error :
only in forum home and forumdisplay



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/functions_forumlist.php(393) : eval()'d code on line 33
I see Warning: mysql_connect() [function.mysql-connect (http://www.hdrmut.net/vb/function.mysql-connect)]: Access denied for user ' hdrmut_mohammed'@'localhost' (using password: YES) in [path]/search_cloud.php on line 118 error in your site. It's a database connection issue. You should enter the correct database name, username, password and IP.

[Mesohu]

how i can change the width of this template($searchcloud) b'coz i'm using a fixed skin .

[alhindasi]

hdrmut thanxSs , it ok now

------------------------------------

[alhindasi]

i need to know how can i remove the number from the word like -1 -3 -6

i need to add only - with out number

[NeutralizeR]

i need to know how can i remove the number from the word like -1 -3 -6

i need to add only - with out number
Edit search_cloud.php.

Remove (two times):

<font style='font-size:70%'>$datas[hits]</font>

[hdrmut]

I see Warning: mysql_connect() [function.mysql-connect (http://www.hdrmut.net/vb/function.mysql-connect)]: Access denied for user ' hdrmut_mohammed'@'localhost' (using password: YES) in [path]/search_cloud.php on line 118 error in your site. It's a database connection issue. You should enter the correct database name, username, password and IP.


Iam sury

the problem same :)

[Mesohu]

how i can change the width of this template($searchcloud) b'coz i'm using a fixed skin .

???

[Magnumutz]

Nice hack and a VERY nice skin you got on your forum :)

[TruthElixirX]

I get this 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 '-dev.google_searches order by hits DESC limit 100' at line 1

[glennybee]

Nice hack, thanks.

Is it possible to integrate this into vBadvanced CMPS?

I have created a new adv_portal_search_cloud template with the following code:

<tr class="alt1"><td>$searchcloud</td></tr>

I've also included the search_cloud.php file in the Global Advanced settings page. I see the new module on my page but it's empty, whereas I have search criteria in the cloud on forum home.

Thanks :)

[NeutralizeR]

how i can change the width of this template($searchcloud) b'coz i'm using a fixed skin .

Edit "Search Templates > searchcloud".

I get this 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 '-dev.google_searches order by hits DESC limit 100' at line 1

This hack doesn't use table prefixes. The table name will always be "google_searches" for everybody. Check which table exists "-dev.google_searches" or "google_searches" and edit your search_cloud.php.

Nice hack, thanks.

Is it possible to integrate this into vBadvanced CMPS?

I have created a new adv_portal_search_cloud template with the following code:

<tr class="alt1"><td>$searchcloud</td></tr>I've also included the search_cloud.php file in the Global Advanced settings page. I see the new module on my page but it's empty, whereas I have search criteria in the cloud on forum home.

Thanks :)

I haven't tried adding it as a vbadvanced module yet but if you put $searchcloud to your footer template, it'll also work for vbadvanced pages. I'll check it soon...

[NeutralizeR]

glennybee, use $vbsearchcloud instead of $searchcloud.

[glennybee]

Thanks for the reply NeutralizeR but I don't really want it in the footer.

When you're in the vBa CMPS admincp settings > edit module, you have the option to preview the module. You can see that the module works and you see the search queries. But when you go to the actual portal page, the queries don't appear. I'll keep working on it.

P.S. I tried $vbsearchcloud and that was the same. :(

[vmacedonia]

How to clean up the database with the referral links?

I have made some changes to the PHP file like the number of displayed links, and now I need the info to be cleaned up and showed all over again.

[swissknife]

ich got a little problem: when the product is active, then this error appears:

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 '-united.google_searches order by hits DESC limit 100' at line 1


This hack doesn't use table prefixes. The table name will always be "google_searches" for everybody. Check which table exists "-dev.google_searches" or "google_searches" and edit your search_cloud.php.

but i dont use prefixes?!?!?

[Marco van Herwaarden]

Cleaned thread from all non-english posts.

vBulletin.org is an international community where the only language allowed is english.

[NeutralizeR]

Please upgrade to the latest version.

v1.0.2 - May 15 2008
-Fixed security issue
-Added option to disable/enable hit counts
-Added blacklist option to disallow specific words

[unitedpunjab]

got this error
' Table 'forum.searches' doesn't exist'

[NeutralizeR]

got this error
' Table 'forum.searches' doesn't exist'
Sorry, my mistake. Re-download the ZIP please.

[onnenkolikko]

I get:

Fatal error: Call to undefined method SearchCloud::getMysqlReadyString() in /home/content/o/n/n/onnenkolikko/html/search_cloud.php on line 130

Any idea whats wrong?

[alhindasi]

did you update to Version: 1.0.2 & tell me what is the Deffrent Version: 1.0.1 and Version: 1.0.2

[NeutralizeR]

I get:

Fatal error: Call to undefined method SearchCloud::getMysqlReadyString() in /home/content/o/n/n/onnenkolikko/html/search_cloud.php on line 130

Any idea whats wrong?
Open search_cloud.php.

Change:
_getMysqlReadyString($a)

to

getMysqlReadyString($a)

[alhindasi]

Dear i get error

' Table 'hindasi_vb' doesn't exist'

[NeutralizeR]

did you update to Version: 1.0.2 & tell me what is the Deffrent Version: 1.0.1 and Version: 1.0.2
I've already posted what's new and fixed. I'll work on %100 vb integration so you won't have to enter the db details again.

Dear i get error


' Table 'hindasi_vb' doesn't exist'

The only table is being used by this hack is "google_searches".

Sorry for the troubles.

[onnenkolikko]

Thanks NeutralizeR, working now :)

[swissknife]

I am sorry, i reinstalled it again and got the some 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 '-united.google_searches order by hits DESC limit 100' at line 1

i dont use prefixes...

[NeutralizeR]

I am sorry, i reinstalled it again and got the some error:



i dont use prefixes...
Open your search_cloud.php file and change all instances of google_searches with -united.google_searches.

I'm currently working on the new version which won't ask you the db details.

[swissknife]

There are two of them, right?

my database name is boards-united. i dont know, why the error is "for the right syntax to use near '-united.google_searches order by h"

ok, i changed it into boards-united.google_searches -> still error

second try changing it to -united.google_searches -> error again.

:(

[NeutralizeR]

There are two of them, right?

my database name is boards-united. i dont know, why the error is "for the right syntax to use near '-united.google_searches order by h"

ok, i changed it into boards-united.google_searches -> still error

second try changing it to -united.google_searches -> error again.

:(
Okay... please disable the product now and wait for the next version. I hope it'll work for you.

[swissknife]

never mind , thank you for your time and your help.

[gibby540]

I am getting this error:

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lampstan'@'localhost' (using password: NO) in [path]/search_cloud.php on line 105

[Mesohu]

I am getting this error:

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'lampstan'@'localhost' (using password: NO) in [path]/search_cloud.php on line 105


check your database info ...
if you have a password for your database you must enter it b'coz actually you have not entered it .

(using password: NO)

[gibby540]

check your database info ...
if you have a password for your database you must enter it b'coz actually you have not entered it .

(using password: NO)
Actually, I did enter it. I checked the settings like 10 times to make sure I had all the settings right (and double-checked it with the config.php file)

[tarzan22]

I get the cloud in search but not in the index, that may be?

Thank you and pardon my English

is a translation of Google

[NeutralizeR]

v1.0.3 - May 15 2008
-Changed mySQL variables so you don't have to enter the db details

Uninstall the previous version first.

[jacx]

goes to try it

working fine..thank u!

[swissknife]

GREAT! Thanks a lot! U did a great AND fast job!!!!!!!!!!!!!!

[T3G4Life]

could you make this for 3.6 PLEASE!!!

[NeutralizeR]

could you make this for 3.6 PLEASE!!!
It should work on 3.6.x with no problems.

[dtv100]

tested on 3.6.10 no problem.

thanks again for this addon .

[jhamaican]

I just made my website 2 days ago and installed this mod.

Will words start to show up after I get indexed in Google and people hit on my website through Google search?

[NeutralizeR]

I just made my website 2 days ago and installed this mod.

Will words start to show up after I get indexed in Google and people hit on my website through Google search?
Correct. Install the latest version.

[NeutralizeR]

v1.0.4 - May 16 2008
-Fixed bug: hit counts don't work

Just upload the new search_cloud.php and overwrite.

[tarzan22]

v1.0.3 - May 15 2008
-Changed mySQL variables so you don't have to enter the db details

Uninstall the previous version first.


I did not understand, the problem is that shown in the search but not in the index

Greetings and thanks

[Fırtına]

Thanks, İnstalled...

NutralizeR hocam v1.0.4 güncellemesi tümüyle düzeltilmiş. teşekkürler...

İyi çalışmalar...

[VeeDubZ]

I get this error with the latest version

Fatal error: Call to undefined function: stripos() in /home/repti5/public_html/search_cloud.php on line 48

[NeutralizeR]

I get this error with the latest version
What's your PHP version?

Check this:
http://forum.mambo-foundation.org/showthread.php?t=820

[VeeDubZ]

Php v4.4.7.....so changing all the stripos to strpos will solve the problem???
done that now i get

Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT * FROM vb_google_searches order by hits DESC limit 50;

MySQL Error : Table 'repti5_vb.vb_google_searches' doesn't exist
Error Number : 1146
Request Date : Friday, May 16th 2008 @ 11:01:38 AM
Error Date : Friday, May 16th 2008 @ 11:01:38 AM
Script : http://www.reptilicious.com/index.php
Referrer : http://www.reptilicious.com/index.php
IP Address : 90.195.31.245
Username : VeeDubZ
Classname : vb_database
MySQL Version : 5.0.45-community

[Magnumutz]

I'm getting the same error:
Fatal error: Call to undefined function: stripos() in /home/magnum/public_html/arcademania/search_cloud.php on line 48


On PHP 4.4.6... Will this mod not work for me?

[VeeDubZ]

ok ive updated the servers php to v5.2.5 and i still get the above database error

[NeutralizeR]

I'm getting the same error:
Fatal error: Call to undefined function: stripos() in /home/magnum/public_html/arcademania/search_cloud.php on line 48
On PHP 4.4.6... Will this mod not work for me?

Try what VeeDubZ did. I'll check further and change the function to PHP 4 compatible version if i can.

ok ive updated the servers php to v5.2.5 and i still get the above database error

Check your "google_searches" table's full name with phpmyadmin or from vbulletin's repair/optimize tables feature and type here.

[VeeDubZ]

right found the problem.....the table prefix is missing....on my database it should be like this"vb_google_searches"

you need to update the product to take the prefix into account

EDIT

just looked at the product file and it should have worked...sorted it now

[NeutralizeR]

right found the problem.....the table prefix is missing....on my database it should be like this"vb_google_searches"

you need to update the product to take the prefix into account
Weird... i re-installed the product and don't have this table prefix issue.

[NeutralizeR]

Nice hack, thanks.

Is it possible to integrate this into vBadvanced CMPS?

I have created a new adv_portal_search_cloud template with the following code:

<tr class="alt1"><td>$searchcloud</td></tr>

I've also included the search_cloud.php file in the Global Advanced settings page. I see the new module on my page but it's empty, whereas I have search criteria in the cloud on forum home.

Thanks :)
vBadvanced CMPS Integration

vBa CMPS > Add Module > Template Module

Module Title: Search Cloud
Template to Include: adv_portal_searchcloud
Template Content: <tr>
<td class="$bgclass" style="text-align:justify">
$vbsearchcloud
</td>
</tr>
Use Module Wrapper Template: Yes

Open vBadvanced Main Options and add vbsearchcloud to Portal Output Global Variables box.

[maidos]

on the search cloud it jsut give me the search name links that lead me to the main site, is this normal behaviour

[NeutralizeR]

on the search cloud it jsut give me the search name links that lead me to the main site, is this normal behaviour
What's the url to test?

[Support]

shows strange leters

im from egypt

my dp sets on :

latin1

i need that line :

$datas[kw]=iconv("utf-8","iso-8859-9",$datas[kw]);


but with right code

[NeutralizeR]

shows strange leters

im from egypt

my dp sets on :

latin1

i need that line :

$datas[kw]=iconv("utf-8","iso-8859-9",$datas[kw]);


but with right code
Try this one:

$datas[kw]=iconv("utf-8","windows-1256",$datas[kw]);

[Magnumutz]

I re-downloaded and re-installed the product but i get the same error... and i'm not using table prefixes.

[NeutralizeR]

I re-downloaded and re-installed the product but i get the same error... and i'm not using table prefixes.
Your problem is not related to table prefixes. You need to change all instances of stripos to strpos in search_cloud.php or upgrade to PHP 5.

[MetalORock]

very great thanks :)

[Magnumutz]

Your problem is not related to table prefixes. You need to change all instances of stripos to strpos in search_cloud.php or upgrade to PHP 5.
Yup, changing all the "stripos" to "strpos" worked. But what's the difference anyways?

[NeutralizeR]

Yup, changing all the "stripos" to "strpos" worked. But what's the difference anyways?
stripos is only a php5 function but strpos should be fine, too. I'll change it in the next version.

[matrex722]

Fatal error: Call to undefined function iconv() in /home/77elrrm31aber/public_html/vb/search_cloud.php on line 218

[Andreas]

Fix your PHP or tell your host to do so - iconv() is really necessary for a lot of things.

[matrex722]

that error gone when i remove this code :

$datas[kw]=iconv("utf-8","windows-1256",$datas[kw]);

[Andreas]

You will run into character set issues if you remove that.

[matrex722]

yea thats right

[Support]

thank u sir :)
it works ...

but is there any way to dont make words dont repet ?!

ex : vbulletin (http://www.vbulletin.org/) , vbulletin (http://www.vbulletin.org/) , vbulletin (http://www.vbulletin.org)

[arena]

Error

Fatal error: Call to undefined function: stripos() in /home/magnum/public_html/xxxx/search_cloud.php on line 48

[NeutralizeR]

Error

Fatal error: Call to undefined function: stripos() in /home/magnum/public_html/xxxx/search_cloud.php on line 48
Update to the latest version.

v1.0.5 - May 19 2008
-Added PHP 4 compatibility
-Small template changes

[arena]

Update to the latest version.

v1.0.5 - May 19 2008
-Added PHP 4 compatibility
-Small template changes
Thank you workink no problem v1.0.5

[rob30UK]

This works in footer template, I want it in FORUMHOME but it wont work there.... any ideas?

[NeutralizeR]

This works in footer template, I want it in FORUMHOME but it wont work there.... any ideas?
Are you sure? Just edit your FORUMHOME template and add $searchcloud.

What's not working?

[elmati]

Really coool!
INSTALLED!!

Thanks for this :)

[vmacedonia]

Why most searched text isn't made with bigger font size, all the text phrases are the same?

Is this line in the PHP file have anything to do with the problem?

$datas[kw]=iconv("utf-8","Windows-1251",$datas[kw]);

[NeutralizeR]

Why most searched text isn't made with bigger font size, all the text phrases are the same?

Is this line in the PHP file have anything to do with the problem?

$datas[kw]=iconv("utf-8","Windows-1251",$datas[kw]);
No.

Check your google_searches table. Check the hit counts there...

[vmacedonia]

I have added that code before the line:

if ($a > 0.8)

like in version 1.0.1.

Is this correct for the new version or the code must be on another place?

[NeutralizeR]

I have added that code before the line:

if ($a > 0.8)

like in version 1.0.1.

Is this correct for the new version or the code must be on another place?
It's correct.

[RobParker]

Installed fine, only problem I've having is if the word you search for is too long it messes up the width of my style. Is there a way to fix the width easily to force the text to shrink if it doesn't fit in the column?

[NeutralizeR]

Installed fine, only problem I've having is if the word you search for is too long it messes up the width of my style. Is there a way to fix the width easily to force the text to shrink if it doesn't fit in the column?
Try this in searchcloud template:
http://www.blooberry.com/indexdot/css/properties/text/wordwrap.htm

[Amenadiel]

I suggest a little fix.

I was receiving this weird SQL error on my mail (it's VB's way to alert me when something goes wrong)


Database error in vBulletin 3.7.0:

Invalid SQL:
INSERT into vb_google_searches VALUES ('pavilion tx1332 drivers xp \"megaupload.com/\"|\"badongo.com/file/\"|\"rapidshare.com/files\"|\"mediafire.com/?\"|\"gigasize.com/get.php\"|\"seriesyonkis.com/\"','http://www.chw.net/foro/showthread.php?t=150369\',1);

MySQL Error : Duplicate entry 'pavilion tx1332 drivers xp ' for key 1
Error Number : 1062
Request Date : Tuesday, May 27th 2008 @ 04:10:48 PM
Error Date : Tuesday, May 27th 2008 @ 04:10:48 PM
Script : http://www.chw.net/foro/aqui-tienen-los-driver-del-tx1330la-t150369.html
Referrer : http://www.google.es/custom?cx=005259712913702778262:h0v4n2t74pm&cof=GFNT%3A%23444444%3BGALT%3A%23444444%3BCX%3ADal eYa%252Ecom%3BVLC%3A%23663399%3BDIV%3A%23336699%3B FORID%3A0%3BT%3A%236600FF%3BALC%3A%23330000%3BLC%3 A%23330000%3BGIMP%3A%23444444%3BBGC%3A%23DFE5FC%3B AH%3Aleft&q=pavilion+tx1332+drivers+xp++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++"megaupload.com/"|"badongo.com/file/"|"rapidshare.com/files"|"mediafire.com/?"|"gigasize.com/get.php"|"seriesyonkis.com/"&btnG=B%C3%BAsqueda&cx=005259712913702778262%3Ah0v4n2t74pm
IP Address : 190.198.248.43
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :


After a bit of tinkering, I found out that the field kw on the vb_google_searches table is 255 chars long, so two strings of, let's say, 260 chars, whose 255 first chars are identical, would trigger a duplicate key error. ?Why? Because the search_cloud script will check for a 260 chars $search variable without finding coincidences.

Ok, perhaps I'm not explaining myself enough, but if you guys get this error, I solved it cropping the $search variable to 254 chars.

In search_cloud.php find
$this->_logHit(strtolower($search),$pageURL);

add BEFORE
$search=substr($search,0,254);

and that's it

[NeutralizeR]

I suggest a little fix.

I was receiving this weird SQL error on my mail (it's VB's way to alert me when something goes wrong)


Database error in vBulletin 3.7.0:

Invalid SQL:
INSERT into vb_google_searches VALUES ('pavilion tx1332 drivers xp \"megaupload.com/\"|\"badongo.com/file/\"|\"rapidshare.com/files\"|\"mediafire.com/?\"|\"gigasize.com/get.php\"|\"seriesyonkis.com/\"','http://www.chw.net/foro/showthread.php?t=150369\',1);

MySQL Error : Duplicate entry 'pavilion tx1332 drivers xp ' for key 1
Error Number : 1062
Request Date : Tuesday, May 27th 2008 @ 04:10:48 PM
Error Date : Tuesday, May 27th 2008 @ 04:10:48 PM
Script : http://www.chw.net/foro/aqui-tienen-los-driver-del-tx1330la-t150369.html
Referrer : http://www.google.es/custom?cx=005259712913702778262:h0v4n2t74pm&cof=GFNT%3A%23444444%3BGALT%3A%23444444%3BCX%3ADal eYa%252Ecom%3BVLC%3A%23663399%3BDIV%3A%23336699%3B FORID%3A0%3BT%3A%236600FF%3BALC%3A%23330000%3BLC%3 A%23330000%3BGIMP%3A%23444444%3BBGC%3A%23DFE5FC%3B AH%3Aleft&q=pavilion+tx1332+drivers+xp++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++"megaupload.com/"|"badongo.com/file/"|"rapidshare.com/files"|"mediafire.com/?"|"gigasize.com/get.php"|"seriesyonkis.com/"&btnG=B%C3%BAsqueda&cx=005259712913702778262%3Ah0v4n2t74pm
IP Address : 190.198.248.43
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :


After a bit of tinkering, I found out that the field kw on the vb_google_searches table is 255 chars long, so two strings of, let's say, 260 chars, whose 255 first chars are identical, would trigger a duplicate key error. ?Why? Because the search_cloud script will check for a 260 chars $search variable without finding coincidences.

Ok, perhaps I'm not explaining myself enough, but if you guys get this error, I solved it cropping the $search variable to 254 chars.

In search_cloud.php find
$this->_logHit(strtolower($search),$pageURL);

add BEFORE
$search=substr($search,0,254);

and that's it
Yes, i'd add that search limiting in the next version. Thanks.

[ade5675]

I don't know where all the errors and questions are coming from. This hack is great.

It works in 3.6.8
Thanks for this, NeutralizeR :up:

INSTALLED!!

[saotome]

installed, reserved. thanks

[David_R]

How is this addon really helpful ? this shall help our competitors to find the top keywords/phrases for our website instead ?

[imported_silkroad]

Installed this on vb 3.6.8 and it does not display any search terms.

For example, see the top of the footer here:

http://www.unix.com/forum_index.php

Any idea why?

[Megatr0n]

Is there any point in installing this if we have vBSEO?

[imported_silkroad]

on the search cloud it jsut give me the search name links that lead me to the main site, is this normal behaviour

Same problem here.

Our site has the same issues (see top of the footer):

http://www.unix.com/forum_index.php

[imported_silkroad]

Deinstalled on 3.6.8 .... did not work on our board.

[NeutralizeR]

How is this addon really helpful ? this shall help our competitors to find the top keywords/phrases for our website instead ?

The tag cloud will also help your competitors to find the top content for your website if we think that way.

Installed this on vb 3.6.8 and it does not display any search terms.

For example, see the top of the footer here:

http://www.unix.com/forum_index.php

Any idea why?

Not sure... Did you try searching your website with the different search terms @ Google?

Is there any point in installing this if we have vBSEO?

Nothing to do with vBSEO. This is just a Google Search Cloud.

[srssr]

Same problem here. Installed on 3.7 in the top of the footer and any terms I search do not show up.

http://www.dssgeeks.com/forums/

[NeutralizeR]

Same problem here. Installed on 3.7 in the top of the footer and any terms I search do not show up.

http://www.dssgeeks.com/forums/
Do you have any data in the google_searches table?

[srssr]

Do you have any data in the google_searches table?

This is what I got:

google_searches 50.1 KB 19.0 KB

So yes, there is some data in there.

[NeutralizeR]

This is what I got:

google_searches 50.1 KB 19.0 KB

So yes, there is some data in there.
Any records in the google_searches table, "kw" column? You can check it with phpmyadmin. Try adding $vbsearchcloud to your footer template.

[srssr]

Its working now. Footer had $searchcloud instead of $vbsearchcloud. Replaced it and it worked immediately.

Thanks a million for this hack and thanks for helping me out. :D

[zmickzalois3]

Hello, I have a big problem with this hack, it appears! But look at the skin I've just write a message inside=> ... powered by Simple Search Cloud

https://vborg.vbsupport.ru/

thank you all aid

[NeutralizeR]

Hello, I have a big problem with this hack, it appears! But look at the skin I've just write a message inside=> ... powered by Simple Search Cloud

https://vborg.vbsupport.ru/

thank you all aid
I really couldn't understand the problem from the screenshot. Try moving $searchcloud somewhere else in the template

[zmickzalois3]

bonsoir, I think it puts a little time a tagger, it must act with time .. I thank you now 2 tagg

[maxicep]

Thanks , great

But it adds a few queries to all pages :(

[tpearl5]

saving this for later :)

[Mr.samy]

I install it and works perfectly but

I receive and database error

about duplicate key for entry

[NeutralizeR]

I install it and works perfectly but

I receive and database error

about duplicate key for entry
Apply this edit:
https://vborg.vbsupport.ru/showpost.php?p=1533628&postcount=117

[Mr.samy]

thanks mr.NeutralizeR

but i already make this modification

see

if (strlen($search)>0)
{
$search=substr($search,0,254);
$this->_logHit(strtolower($search),$pageURL);
}
}
}


and i still receive the error message


Database error in vBulletin 3.7.1:

Invalid SQL:
INSERT into google_searches VALUES ('ma3hd','http://www.ma3hd.net/vb/showthread.php?t=9165\',1);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062


my board used UTF8 encoding

[NeutralizeR]

Hmm... alright. Revert the changes you made to search_cloud.php file.

Find:
$search = $this->getMysqlReadyString(trim($search));Add below:
if (strlen($search) > 100 || strlen($pageURL) > 100)
{
return;
}

[Mr.samy]

thanks mr.NeutralizeR

but i still rececive error

that :

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT into google_searches VALUES ('����? ���? cake mania 2 ����?','ma3hd.com',1);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Request Date : Friday, July 4th 2008 @ 12:37:03 PM
Error Date : Friday, July 4th 2008 @ 12:37:03 PM
Script :
Referrer :
IP Address : 41.233.34.57
Username : غير مسجل
Classname : vB_Database
MySQL Version :

[NeutralizeR]

thanks mr.NeutralizeR

but i still rececive error

that :

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT into google_searches VALUES ('����? ���? cake mania 2 ����?','ma3hd.com',1);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Request Date : Friday, July 4th 2008 @ 12:37:03 PM
Error Date : Friday, July 4th 2008 @ 12:37:03 PM
Script :
Referrer :
IP Address : 41.233.34.57
Username : غير مسجل
Classname : vB_Database
MySQL Version :

I'm not sure why it didn't fix the problem for you. Try applying the both modifications :)

[dethfire]

google says 100 links per page, won't this kills this link count for most sites?

[NeutralizeR]

google says 100 links per page, won't this kills this link count for most sites?
If you have this kind of concerns you may set it to 50 links.

Many big forums already have more than 200+ forums linked from their forumhome.

[needaltuna]

Thank you for an invaluable mod.

I've adjusted the width of the box to match that of my forum, but it is out of alignment with the navbar at the bottom of the main page by one pixel. What code do I need to use to correct this?

Thanks.

[NeutralizeR]

Thank you for an invaluable mod.

I've adjusted the width of the box to match that of my forum, but it is out of alignment with the navbar at the bottom of the main page by one pixel. What code do I need to use to correct this?

Thanks.
Edit "Search Templates > searchcloud" template.

[needaltuna]

I know I have to edit the template, but what I'm asking is what changes do I need to make to the code in the template to fix the misalignment?

[NeutralizeR]

the "width" of the <table>

[rasputin]

Why most searched text isn't made with bigger font size, all the text phrases are the same?

Is this line in the PHP file have anything to do with the problem?

$datas[kw]=iconv("utf-8","Windows-1251",$datas[kw]);

I have added that code before the line:

if ($a > 0.8)

like in version 1.0.1.

Is this correct for the new version or the code must be on another place?

It's correct.

I obtain this error
Fatal error: Call to undefined function: iconv() in /web/htdocs/www.gradinatasud.it/home/forum/search_cloud.php on line 218
when trying to set the western europe character set..

[NeutralizeR]

I obtain this error
Fatal error: Call to undefined function: iconv() in /web/htdocs/www.gradinatasud.it/home/forum/search_cloud.php on line 218
when trying to set the western europe character set..
You don't have iconv installed.

[needaltuna]

the "width" of the <table>

It's not a width issue, as the width is correct, it's an alignment issue. The box isn't centered properly, it's one pixel too far to the left.

[NeutralizeR]

It's not a width issue, as the width is correct, it's an alignment issue. The box isn't centered properly, it's one pixel too far to the left.
What's the URL?

[needaltuna]

What's the URL?

It's an adult forum, so I'll PM the url to you.

Thanks.

[NeutralizeR]

Change table's width to 810

[needaltuna]

Thank you. That fixed it.

[jmke]

excellent! Works on 3.6.x too :D

[ruindil]

Thanks.

I fixed this problem with iconv support.

Open search_cloud.php and find:
if ($a > 0.8)

Add above:
$datas[kw]=iconv("utf-8","iso-8859-9",$datas[kw]);
I have done,but the procedure gave the mistake.
error
Fatal error: Call to undefined function: iconv() in /home/xxx/public_html/forum/search_cloud.php on line 218

[Big Kahuna]

I followed the instructions to the T at www.mopowerstyle.com/forums and put $searchcloud in a Ultimate Column block (but also tried in in the footer Template) and still nothing. How long does this take?

[NeutralizeR]

Thanks.


I have done,but the procedure gave the mistake.
error
Fatal error: Call to undefined function: iconv() in /home/xxx/public_html/forum/search_cloud.php on line 218

You need iconv support.

I followed the instructions to the T at www.mopowerstyle.com/forums (http://www.mopowerstyle.com/forums) and put $searchcloud in a Ultimate Column block (but also tried in in the footer Template) and still nothing. How long does this take?

Try $vbsearchcloud

[ruindil]

You need iconv support.


I worked solving

$datas[kw]=iconv("utf-8","iso-8859-9",$datas[kw]);

change

$datas[kw]= mb_convert_encoding ($datas, "ISO-8859-9", "UTF-8"");

[needaltuna]

I know that this has been touched on before, but it'd be really handy if there was a way to remove unwanted words from the search cloud.

[maidos]

this mod is not visible on a certain forum skin while other is..

[bezibaerchen]

Installed and customized.

If there is any need of Demo, here are mine (one in CMPS and one in search template):

http://www.mobil-talk.de/cmps_index.php

http://www.mobil-talk.de/search.php

[ahmedeldeep]

I fixed this problem with iconv support.

Open search_cloud.php and find:
if ($a > 0.8)

Add above:
$datas[kw]=iconv("utf-8","iso-8859-9",$datas[kw]);
thank you very much
ie. for Arabic boards
aad
$datas[kw]=iconv("utf-8","windows-1256",$datas[kw]);

[needaltuna]

HOW TO DELETE UNWANTED TERMS FROM THE SEARCH CLOUD

I found a way to do it.

1. Log-in to PhpMyAdmin

2. Click on your forum's database.

3. Click on vbgoogle_searches in the left-hand column

4. Click on the BROWSE tab in the page that opens up.

5. Check the box of each search term you wish to delete and then click on the red X.

That's it.

[habilonline]

working nice.. Thanks.

[x-death]

thanks

[imported_silkroad]

This plugin is a performance killer on a site with many Google keywords searches. We get over 600,000 Google searches each month. This mod just kills our SQL database performance unless we constantly trim the tables.

Can the developer fix this?

Perhaps offering an option to trim the table after it grows to some number in the database?

Also, I think there may be other problems, but this one obviously ruined our site performance recently, including (we think maybe) causing a crash, many hours of debugging etc.

Did I miss a warning somewhere about sites with many keyword searches every day?

[NeutralizeR]

This plugin is a performance killer on a site with many Google keywords searches. We get over 600,000 Google searches each month. This mod just kills our SQL database performance unless we constantly trim the tables.

Can the developer fix this?

Perhaps offering an option to trim the table after it grows to some number in the database?

Also, I think there may be other problems, but this one obviously ruined our site performance recently, including (we think maybe) causing a crash, many hours of debugging etc.

Did I miss a warning somewhere about sites with many keyword searches every day?
I'm using a custom coded version of this mod on my site which has caching support. You're right, if you're getting too many hits from Google it'll kill your SQL database performance in time. You may delete the search terms with only 1 hit. Another thing you can do is wrapping the main plugin with if conditionals so it'll only be executed @ forumdisplay, showthread. Sorry, the core script is "Simple Search Cloud"...

[imported_silkroad]

Thanks.

We had to disable this plugin because we get more than 600,000 Google keywords searches a month and this plugin kills our database performance.

I hope you will add more options in the future so it can be used with "bigger boards" .

[CheeseFrog]

Any tips on best placement for an average vB forum? I placed it in the footer but it's a little too far down the page. Where could I place the $searchcloud if I wanted it right below or above the list of users who are currently browsing the forums?

What about vBadvanced? How would I implement it within a block? As BBcode or a template? I tried BBcode but it just displayed the "$searchcloud" string heh. Funny stuff.

Edit: Nevermind. I feel like a complete moron. Please, nobody look at me. I'm an idiot. Someone throw a tarp over me.

[needaltuna]

Words that I have disallowed keep reappearing in the search cloud, even though I have entered the words correctly in the php file. Why is this happening?

[NeutralizeR]

Words that I have disallowed keep reappearing in the search cloud, even though I have entered the words correctly in the php file. Why is this happening?
You need to enter those words using the correct text encoding.

[needaltuna]

This is how I've entered them. The text encoding looks correct to me.

("elitistic","warmever","ellekappa","fbberotic","1234","cheatz","chacho_world","gxianfranko")

[Cust0ms]

Hello,
How to disable specific words in Search Cloud?

[ABDALWAHID]

Hello Neutralizer,

I have a question?

Can this man to hack a CronJob create examples I empty every week google_searches table.

That's why I always want the latest word searches to see.

I'm sorry my english is very bad here but I think turkish write not allowed.

[lnxtr]

selam her 2 dosyayıda yükledim ama sayfamda cıkmadı nasıl cıkmasını saglıyabilirim?

[Krico]

I'm using a custom coded version of this mod on my site which has caching support. You're right, if you're getting too many hits from Google it'll kill your SQL database performance in time. You may delete the search terms with only 1 hit. Another thing you can do is wrapping the main plugin with if conditionals so it'll only be executed @ forumdisplay, showthread. Sorry, the core script is "Simple Search Cloud"...


So... is there any possibility that you will release your custom coded version that wouldn't kill the SQL database at many google keyword searches?

[NeutralizeR]

Sorry for not being able to give support for this add-on.

[trstudent]

thanks for the mod but i had a little problem about the turkish spells. If a word includes a turkish spell and if it is shown in the search cloud it shows different characters How can i fix it ?

[lnxtr]

i want to new version :)

[swissknife]

thanks for the mod but i had a little problem about the turkish spells. If a word includes a turkish spell and if it is shown in the search cloud it shows different characters How can i fix it ?

German too.

"recycling ordner löschen" instead of "recycling ordner l?schen"

?, ?,?,? and so on are making problems... :(

[ABDALWAHID]

German too.

"recycling ordner löschen" instead of "recycling ordner l?schen"

?, ?,?,? and so on are making problems... :(


https://vborg.vbsupport.ru/showpost.php?p=1514679&postcount=9

change with german meta...

[Goomzee]

plz check my forums footer http://www.mknexusonline.com/forums/index.php and i don;t know hwy attachment is working last few days

[intospain]

Have installed but nothing coming up as yet, maybe has to have a bit of search before it kicks in.

Will keep an eye on it, thanks for the mod by the way.

[ABDALWAHID]

Hello

is that possible search-cloud templates can be seen only when there is file

Eğer veritabanında hiç kelime yoksa templates altta gözükmese?

[Chadi]

How do I remove the all bold formatting? All the words are bold.

[ABDALWAHID]

How do I remove the all bold formatting? All the words are bold.

find



echo " <b><a href='$datas[url]' style='font-size:$fontSize%'>$datas[kw]</a></b> $countText \n";



replace with



echo " <a href='$datas[url]' style='font-size:$fontSize%'>$datas[kw]</a> $countText \n";

[Osm@N]

kullanmakta olduğumuz temaya nasıl uygulayabiliriz defult tema kullanmayanlar için biraz sorun olduğuna eminim.

[leitel]

sure would love to use this but nothing is being loaded to $vbsearchcloud variable. I looked at the google_searches table and although there is one record. kw and url fields are empty but it shows 27 hits.
Any ideas?
Thank you :)

[colochris]

I must say that this is a nice find. As I am no coder, this was very easy and I thank you

Chris

BowlingBoards.com

[Duslerforum.ORG]

Why at the end of the link something like a hash appears what do i have to do to get rid off it ?

my forums tag cloud
exampLe :

tag : siirli slayt kodlari

tag link :

http://www.xxxxxxx.com/slayt-siir-t38674.html?s =02bcf5cf088184eacf3d05e5da7d31f2&

exampLe 2 :

tag : bayram mesajları

tag link :

http://www.xxx.com/bayram-mesajlari-t27263.html?s =350921f5bc7fbd2c4dcf79f107e756a9&


why hash appears at the end ?

[NeutralizeR]

Why at the end of the link something like a hash appears what do i have to do to get rid off it ?

my forums tag cloud
exampLe :

tag : siirli slayt kodlari

tag link :

http://www.xxxxxxx.com/slayt-siir-t38674.html?s =02bcf5cf088184eacf3d05e5da7d31f2&

exampLe 2 :

tag : bayram mesajları

tag link :

http://www.xxx.com/bayram-mesajlari-t27263.html?s =350921f5bc7fbd2c4dcf79f107e756a9&


why hash appears at the end ?


It's not related to this hack.

[Duslerforum.ORG]

What is a solution ?

[momo2]

some letters are larger than other, why ?

[7amza]

GR8 ,,
it well worked in 3.8?

[atakanson]

Thank you for the mod..
I got two question..
First is about turkish characters..

Open search_cloud.php and find:

PHP Code:
if ($a > 0.8)

Add above:

PHP Code:
$datas[kw]=iconv("utf-8","iso-8859-9",$datas[kw]);

I did this but this time forum gives erorr...

The second question is i banned some words but they ara still in the forum..
How can i delete the words....
I opened tables but there is no table names as google tag etc

Thanks...

[atakanson]

SO any idea about this subject?
Insted of this ("utf-8","iso-8859-9", what can i write so that ther will be no error...



Thank you for the mod..
I got two question..
First is about turkish characters..

Open search_cloud.php and find:

PHP Code:
if ($a > 0.8)

Add above:

PHP Code:
$datas[kw]=iconv("utf-8","iso-8859-9",$datas[kw]);


I did this but this time forum gives erorr...


The second question is i banned some words but they ara still in the forum..
How can i delete the words....
I opened tables but there is no table names as google tag etc

Thanks...

[atakanson]

Ok i talked with my host and they added iconv support now it works...

[6piston]

hi neutralizer

how long does the cloud refreshes once?
my search tags has been there for weeks and hasn't added or removed any new or old tags?

http://www.zerotohundred.com/newforums/

Thanks!
Tom

[safakuygur]

very good thanks

[Goomzee]

i did this below setting but it's not working

Installation Instructions

1-) Upload search_cloud.php to your forum root. (without edit)
2-) Import the product-vbgooglesearchcloud.xml.
3-) Put $searchcloud in any template you want to display your search cloud. e.g. footer

I put i footer template

[webmastersitesi]

nice mod but i dont think it has real value for seo unless customly coded like you did for yourself. This mod has a little use but well done :) Turkish handmade anyway.

[Onurss]

Very nice, thanks :)

[Hackhell]

Hello,
The turkish language the personality problem i've lived... i'm told. but empty page appers to be.
Can i help you?

[RamisK]

Thanks

[pretke]

I'm getting the same error:

Warning: mysql_real_escape_string() [/function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) in [path]/search_cloud.php on line 89

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in [path]/search_cloud.php on line 89

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) in [path]/search_cloud.php on line 89

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in [path]/search_cloud.php on line 89
/

:confused:

[6oct]

for arabic language please add this
$datas[kw]=iconv("utf-8","windows-1256",$datas[kw]);

above the :
if ($a > 0.8)

[lnxtr]

bu sistemi geliştirip para ile satıyorlar bunu engellemek için bu sistemi sistemi siz yapsanız hiç fena olmaz

[lnxtr]

mevcut olan sayfaya gelenleri nasıl gösterebiliriz?
Örnegin bu konudayken altta bu konuya hangi kelimerlle geldigini görmeyi nasıl saglaarız?

[AshMagic]

How do I clear the results back down to 0?! Is there an easier way than uninstalling and reinstalling again?

[jmke]

@AshMagic go into Mysql and empty the table "google_searches"
---

heads-up for those using or plan to use this mod; at first we received a huge traffic increase when we installed the search cloud, insane increase like 400% or so... but 2 months later all those same pages were added to Google's secondary index and no longer appear in the main index, so in short: banned. referring traffic from google is now lower than before this mod was installed... so beware.

https://vborg.vbsupport.ru/

[Smitty]

I can't say I use this mod, but I do have a tag cloud page and link to it in several of my site pages and the forum pages. I have seen some search results change, some to pages linked to through the tags that were linked through the 'archive' for example, but my traffic continues to rise.

Maybe there's another factor at work in your case.

[PaLeRmO]

B?yle Bir Hata Alıyorum Arkadaşım ?

Warning: require_once(./search_cloud.php) [function.require-once]: failed to open stream: No such file or directory in /global.php(360) : eval()'d code on line 232

Fatal error: require_once() [function.require]: Failed opening required './search_cloud.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/*****/public_html/global.php(360) : eval()'d code on line 232

[Lithack]

I fixed this problem with iconv support.

Open search_cloud.php and find:
if ($a > 0.8)

Add above:
$datas[kw]=iconv("utf-8","iso-8859-9",$datas[kw]);

Health across

[vithorius]

HI! Great mod you have here! :up:

I have this question: Would it be possible to 'test' the hack without really installing it publically? I mean, I would like to know just how it would look like my board's Google Search Cloud BEFORE I have the Mod installed.

Is that possible? :confused: (some kind of preview relating just with my forum, if you know what I mean...) ;) :up:



Thank you so very much, and keep up the EXCELLENT work! :up: :up:

[veyissen]

Türkçe karakter kullanmak istiyorum. yani replace etmek istemiyorum. bunu nasıl yapabilirim?

[weexto]

The product works with VB 3.8.2?

[GreasySpoon]

but 2 months later all those same pages were added to Google's secondary index and no longer appear in the main index

You know why? Because on every page the same search cloud is shown :down:

[shockx]

I had to make this change for it to work on 3.8.2, probably needed on others as well:


function getMysqlReadyString($a)
{
global $vbulletin;

if(get_magic_quotes_gpc())
{
$tmp = stripslashes($a);
}
else
{
$tmp = $a;
}
return $vbulletin->db->escape_string($tmp);
}

[Zi55]

Any risks on this mod ?

[aapkae]

is this mod work with 3.8.3

[GTX2]

i'm always getting duplicate entry for key 1 error warnings, tried the fix above but not solved....

any hint?

[Sadikb]

I had to make this change for it to work on 3.8.2, probably needed on others as well:


function getMysqlReadyString($a)
{
global $vbulletin;

if(get_magic_quotes_gpc())
{
$tmp = stripslashes($a);
}
else
{
$tmp = $a;
}
return $vbulletin->db->escape_string($tmp);
}


Thank you so much. You made my day! :)

[appsfinder]

How do I clear the results back down to 0?! Is there an easier way than uninstalling and reinstalling again?


HI I used Navicat mysql open forum DB google_searches then deleted all in that table :note takes a bit of time! and only does 0-1000 so keep refreshing and deleting till empty :)

[hulkster]

it will be working with vb4 ??
thx

[final kaoss]

I doubt that happened because of the search cloud.

@AshMagic go into Mysql and empty the table "google_searches"
---

heads-up for those using or plan to use this mod; at first we received a huge traffic increase when we installed the search cloud, insane increase like 400% or so... but 2 months later all those same pages were added to Google's secondary index and no longer appear in the main index, so in short: banned. referring traffic from google is now lower than before this mod was installed... so beware.

https://vborg.vbsupport.ru/

[ZuFett]

is a update for vB4 possible? I get a error if i installed it (vB4.0.1)

[Cloud2]

inst

Warning: mysql_real_escape_string() [http://moja-domena.pl/function.mysql...scape-string]: Access denied for user 'apache'@'localhost' (using password: NO) in [path]/search_cloud.php on line 89

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in [path]/search_cloud.php on line 89

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'apache'@'localhost' (using password: NO) in [path]/search_cloud.php on line 89

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in [path]/search_cloud.php on line 89

[Seba123]

is a update for vB4 possible? I get a error if i installed it (vB4.0.1)

Here http://vbhelp.pl/vbulletin-google-search-cloud-search-engine-optimization-t5869-2.html#post31230

[Nasgoth]

Hello, I have a big problem with this hack, it appears! But look at the skin I've just write a message inside=> ... powered by Simple Search Cloud

http://img72.imageshack.us/img72/5268/screenshot001jk8.jpg

thank you all aid

I have the same problem. Tags has not :/ Only these two how on small picture (up)

ver 3.8.5 help me.

[ChaFF]

is it suitable for 4.0.6?

[swissknife]

For some reasons, it stopped working .

Has anyone an idea ?

( vB 3.8. - when i first installed it, it worked perfekt. - after an while it stopped and didnt showed any keywords. )

[swissknife]

For some reasons, it stopped working .

Has anyone an idea ?

( vB 3.8. - when i first installed it, it worked perfekt. - after an while it stopped and didnt showed any keywords. )

No idea ? :(

[alhindasi]

4.0.8 please

[AshMagic]

Please release for 4.1.0!! :)

[valdet]

heads-up for those using or plan to use this mod; at first we received a huge traffic increase when we installed the search cloud, insane increase like 400% or so... but 2 months later all those same pages were added to Google's secondary index and no longer appear in the main index, so in short: banned. referring traffic from google is now lower than before this mod was installed... so beware.

http://www.vbseo.com/attachments/f30/5150d1233759193-websiteowners-hell-googles-secondary-index-clipboard01.jpg

Can you confirm this plugin was the cause to lose all your search engine traffic.

Search engine referral keyword clouds are quite popular and I see no reason how this could have caused your site to get "de-indexed".

I am interested to install this plugin but I would like to hear feedback from other users.

Thanks.

[swissknife]

Hi!

Thank you valdet for your information. - But i cna't confirm this.

I am using a simular modifikation for vB 3.8. and it seems to work good...

[matrex722]

does this mod contain : " Search Cloud For This Thread "

like this site : http://www.travpl.com/forum/travel-italy-13/gucci-cafe-italy-327.html

[mnms]

Hi All,

I installed Google Search cloud in VB 4.1.6

I tried to publish it inside the footer template using the line below.

{vb:raw searchcloud}
$searchcloud

But nothing appears except the variable name : $searchcloud

Do you think I'm wrong ?
Do I forgot something or is this an issue with this VB version ?

[mnms]

Hi
I installed the mod in VB 4.1.6.
But the content of the variable $vbsearchcloud doesn't appear in my side bar
Does anybody know if I have to change something ?

(results are well inserted inside the Mysql table)

[mnms]

My issue is not solved but I discovered an issue in the product script seach_cloud.php.
I solved it by making change in seach_cloud.php.
Explanation :
In my case (french web site), Latin characters are used and google convert them into hexadecimal.
So the script gave me the error message "duplicate entry error" with the number 1062.
So I added a conversion function.
Let me know in MP if you need my script version.

[Dr.CustUmz]

i know this is old, but being on the 3x series still i am intrigued with this mod. i have installed this with no errors, applied the
global $vbulletin;
fix i saw in one of these posts, and have done a search on google for my website and followed it, yet i am not seeing any results in the search cloud box =(

i am running vb 388 and php 5.4.16, i checked my DB the table created ok. yet i am seeing no results, any one have this working? or know a easy fix?