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 ncweb

Thanks Mahmoud, any chance of posting your mysql version? I'm a newb when it comes to mysql errors but still curious to know. I appreciate you work on this mod, I love being able to see what terms users are searching for. Also, I downloaded 2days ago.. what changes were made on 2/23/2007 and should I uninstall/upgrade? Thank you.

MySQL version: 4.1.21

re-upload the file admincp/search_stats.php as the variable "$this" was renamed to "$thispage"

[dutchbb]

Originally Posted by coderphp

of course size is specified depending on the popularity of the keyword in ur forum

Ok but can it be ordered so that keywords with more searches are displayed instead of the ones that have only 1 search?

[coderphp]

Originally Posted by dutchbb

Ok but can it be ordered so that keywords with more searches are displayed instead of the ones that have only 1 search?

Indeed keywords with more search times is displayed...
if you have all keywords searched just one time, then that means that no keyword is searched twice till now...

you can try to click on any keyword on the footer and search for it.. it is supposed to be larger the next time u visit the homepage

[dutchbb]

But it shows keywords with only one search on forumhome while there are keywords with more than one search.

The statistics also still show the top keyword with a lot of searches but it is blank. So I think something is wrong on my board. Its not wrking like it should.

[coderphp]

Originally Posted by dutchbb

But it shows keywords with only one search on forumhome while there are keywords with more than one search.

The statistics also still show the top keyword with a lot of searches but it is blank. So I think something is wrong on my board. Its not wrking like it should.

ok there seems really something wrong... so u can re-install the hack & start testing it on ur own before people submit their searches

[VIP66]

Thank you

VIP

[unitedpunjab]

I modified the hack to process the search directly instead of taking to search page (I like it that way)
I am attaching the modified product file in case some one else want it that way,

Demo: http://www.unitedpunjab.co.uk/

[coderphp]

Originally Posted by unitedpunjab

I modified the hack to process the search directly instead of taking to search page (I like it that way)
I am attaching the modified product file in case some one else want it that way,

Demo: http://www.unitedpunjab.co.uk/

thank you

[FireFish]

Nice mod; the only thing I'd change is the large font / font size representing the searches.

It makes my front page look inconsistent, so I disabled showing this on the front page.

I use it just to monitor from the AdminCP.

It would be nice to simply have the top searches there in a normal page font & do something like a mouse over or number next to each term in parenthesis representing search popularity.

[coderphp]

Originally Posted by FireFish

Nice mod; the only thing I'd change is the large font / font size representing the searches.

It makes my front page look inconsistent, so I disabled showing this on the front page.

I use it just to monitor from the AdminCP.

It would be nice to simply have the top searches there in a normal page font & do something like a mouse over or number next to each term in parenthesis representing search popularity.

you can change the keywords font size this way:

Originally Posted by Redlinemotorsports

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