Statistics Modifications - Forum Search Stats 1.0

Hi all

Did you ever wondered what your users expect to find in your forums?
Did you ever wanted to know what are their needs?
Did you ever wanted to let them know what they can easily find?
If your answer is "Yes", then you must use this product ...

Features
1- Log user searches in your forums.
2- Show most searched keywords on the main forums page in away that demonstrates every keywords importance in your forums.

Version
Expected to work on all vBulletin 3.6 versions tell now.

Template Edits
1 template edit in FORUMHOME

Plugins
2 Plugins

Installation
1- Upload the directory "upload" contents to your forum root.
2- Import the attached product "[product] Forum Search Stats 1.0.xml" into your AdminCP.
3- Edit template "FORUMHOME":
BEFORE:

</table>
<br />
<!-- end what's going on box -->

ADD:

<if condition="$vbulletin->options['setting_searchstats_showuser']">
<tbody>
 <tr>
  <td class="thead" colspan="2">
   <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_events')"><img id="collapseimg_forumhome_events" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_events].gif" alt="" border="0" /></a>
$vbphrase[most_searched]
</td>
 </tr>
</tbody>
<tbody id="collapseobj_forumhome_events" style="$vbcollapse[collapseobj_forumhome_events]">
 <tr>
  <td class="alt2"><img src="images/misc/search_stats.gif" alt="$vbphrase[most_searched]" border="0" /></td>
  <td class="alt1" width="100%">$most_searched</td>
 </tr>
</tbody>
</if>

Finally, if you like the product Please show your support by clicking INSTALL..
you can also NOMINATE FOR MOD OF THE MONTH


IMPORTANT: after installation if you noticed that keyword font size is very large, wait and give it a try as font size is depending on num of search in ur forum, so wait and give it a try...

[dutchbb]

Originally Posted by mcyates

I've had to disable it as people where spamming the search box with urls to other sites, also a lot of people were swearing and basically just abusing the box.

In the forumhome template, paste this before the code: <if condition="$bbuserinfo[usergroupid] == 6">

and this after: </if>

So only admins can see it. It's good for finding keywords for your site, because if you know what users are searching for you can focus on those words to make articles, threads, tags, meta keywords, titles, etc.

[Neal-UK]

Originally Posted by mcyates

I've had to disable it as people where spamming the search box with urls to other sites, also a lot of people were swearing and basically just abusing the box.

Slightly off topic, but when I view your football forum as a guest, I get the fist page showing the image url in the poll pushing the forums out....

See attached:

[coderphp]

Originally Posted by dutchbb

In the forumhome template, paste this before the code: <if condition="$bbuserinfo[usergroupid] == 6">

and this after: </if>

right and you can also use:

<if condition="$vbulletin->userinfo['usergroupid'] == 6">
</if>

Originally Posted by dutchbb

So only admins can see it. It's good for finding keywords for your site, because if you know what users are searching for you can focus on those words to make articles, threads, tags, meta keywords, titles, etc.

Agree with you 100% as this is the main reason - for me - for programming this hack..

[Masiello]

Hi, Ive my forum in a root and not in a /forum dir, I have install this mod but after the product is active the database error appear in a forum index, it don't find the table, any fix?

[coderphp]

Originally Posted by Masiello

Hi, Ive my forum in a root and not in a /forum dir, I have install this mod but after the product is active the database error appear in a forum index, it don't find the table, any fix?

execute this query:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )

[ncweb]

Originally Posted by coderphp

ok now it is clear for me

do the following:
1- reinstall the product.
2- execute this new query:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )

Great mod, I also had to use this query with mysql 4.1.21-standard and dev box with 4.0.26. Is there something missing from installer?

/installed

[nikki712]

Originally Posted by TheBlackPoet

great hack!! since i have a dark theme... i changed the graphic to something appropiate... and made the search result text smaller... but other than that.... this is great!! really nice..

i personally cant think of anything this hack needs to be any better

Can you please tell me how you made the text smaller?

[Masiello]

Originally Posted by coderphp

execute this query:

CREATE TABLE `coder_searchstats` ( `id` int(10) unsigned NOT NULL auto_increment, `query` varchar(200) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )

Hello, the table that you have write already exist, this is the error with the product enabled:

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT MAX(`count`) AS m FROM vb_coder_searchstats;

MySQL Error : Table 'db.vb_coder_searchstats' doesn't exist
Error Number : 1146
Date : Thursday, February 22nd 2007 @ 08:34:40 PM
Script : http://www.mysite.com/index.php
Referrer : http://www.mysite.com/admincp/index.php?do=head
IP Address : xxx.xxx.xxx
Username : xxx
Classname : vb_database

I think have to create a table named vb_coder_searchstats and drop the table coder_searchstats.

[HMBeaty]

Originally Posted by nikki712

Can you please tell me how you made the text smaller?

Hi Nikki, the easiest way I could do it was this...

Go into your admincp > plugins & products > plugin manager

and edit Forum Search Stats 1.0 at hook location forumhome_complete

Then change:

PHP Code:

$rat = 5/$max; 


To:

PHP Code:

$rat = 2/$max; 


You can change 2 to whatever number you want. 2 is just what I have mine at

[dutchbb]

There seem to be something wrong... it shows a completely different list of keywords every F5, there is no ranking or words marked bigger because they are searched more? isn't that what statistics is about? Because this is pretty useless if you don't know what the top keywords are...