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...

[coderphp]

Originally Posted by rwilkins108

Works great, any chance of getting a way to remove 1 search term from the box, like the way Zoints Tags works (which looks similar) is that if you're an admin, there's an x next to each tag (or search term in this case) which will remove it. Also, it might be good to have a list of words that would be ignored, i've already got a swear word up on mine

Great work!
Thanks!!

these two features will be added to the new version in the next few days..

Originally Posted by Redlinemotorsports

I'm getting the following error on my forums after product upload....

Database error in vBulletin 3.6.4:

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

MySQL Error : Table 'Redline.vb_coder_searchstats' doesn't exist
Error Number : 1146
Date : Tuesday, February 20th 2007 @ 09:54:06 PM
Script : http://www.mysite.org/forum/index.php
Referrer : http://www.mysite.org/forum/admincp/index.php?do=head
IP Address : xx.xx.xx.xx
Username : xxxxxxx
Classname : vb_database




I tried the fix above but it didn't work for me

You got this error because of the ENGINE parameter not acceptable by your MySQL engine...
anyway this problem solved.... please reinstall the product

Originally Posted by Redlinemotorsports

Nevermind, I went in and manually edited the database. The problem is that your product is not creating the "TABLE_PREFIX" because its not in the product to include it. So you might want to fix that as well. Also, the "expand / collapse" doesn't work. It expands / collapses my "upcoming events"

EDIT: and that would be because you're USING the "upcoming events" module for it. As shown in your FORUMHOME template edit here:

onclick="return toggle_collapse('forumhome_events')

So you should fix that as well

yep i didnt notice that as i got it copied from the original module "upcoming events"
fixed please reinstall...

Originally Posted by Redlinemotorsports

[high]* Redlinemotorsports uninstalled until fixes are made[/high]

never mind .. problems fixed

thanx for ur feedback

[Neal-UK]

Any way just for admins only to see this?

[coderphp]

Originally Posted by Neal-UK

Any way just for admins only to see this?

sure it could be added to the new version..

but why?

as the main page stats is helpful for your website in search engines

[Neal-UK]

Just thought someone could see what's being searched on a site, and then create posts on their own relating to what members are searching for.

Just a thought....

[BigJimTheLug]

Can this be set so that only mods, admins, and supermods see the display?

I don't want members to see it.

[coderphp]

Originally Posted by MARKETPROFITS

Can this be set so that only mods, admins, and supermods see the display?

I don't want members to see it.

ok as this is requested again it will be added to the new version coming up in the upcoming few days

[dutchbb]

Wow very good idea! definitely going to use this, installed + nominated

ps: too bad for us it adds 2 queries on forumhome Can you make it add the 2 queries only for admins when you add the feature mentioned above?

Thanks!

[dutchbb]

PS: is it possible to release the photoshop file for the search incon, I like to change the matte color to match the background

PS2: (this is just a suggestion if you ever feel the need to further improve your mod) it would be nice to make the keyword links redirect to a more detailed statistics page that shows the users for the searched keywords, how many times it is searched for etc...

[coderphp]

Originally Posted by dutchbb

Wow very good idea! definitely going to use this, installed + nominated

ps: too bad for us it adds 2 queries on forumhome Can you make it add the 2 queries only for admins when you add the feature mentioned above?

Thanks!

yes it could.. maybe ill add that in the next version...

Originally Posted by dutchbb

PS: is it possible to release the photoshop file for the search incon, I like to change the matte color to match the background

PS2: (this is just a suggestion if you ever feel the need to further improve your mod) it would be nice to make the keyword links redirect to a more detailed statistics page that shows the users for the searched keywords, how many times it is searched for etc...

attached the search icon large sized in png format, and another 2 alternative icons
and about ur suggestion it would be nice if i had time to add that .. thanx for ur feedback keep on messaging me

[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.