Statistics Modifications - Forum Search Stats V.2

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

The 1st version was here
https://vborg.vbsupport.ru/showthread.php?t=139829

What is new in Version 2

1. Most searched keywords in smaller text.
2. Most searched keywords leads to results page directly instead of search page.
3. Fixed random list bug.
4. Fixed blank keyword bug.
5. An option for choosing who can see search stats in homepage.
6. Censor words listed in Most searched stats according to Forum's censor list.
7. Solved "<span dir=rtl>" problem.
8. Solved TABLE_PREFIX problem.
9. Solved falsy search count when user clicks on links on "most searched keyword stats". ((Thanx to h2ojunkie))

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.

Screens





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 2.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'] AND in_array($vbulletin->userinfo['usergroupid'], $allowed_groups)">
<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

ALSO, many thanx for all who helped in testing and debugging the 1st version, the list is long so i couldnt name them here

[davide101]

That's the same site that got me!

Here's my forum_complete:

$allowed_groups = @explode(",", $vbulletin->options['setting_searchstats_showgroups']);
if($vbulletin->options['setting_searchstats_showuser'] AND in_array($vbulletin->userinfo['usergroupid'], $allowed_groups))
{
$censor_words = @explode(" ", $vbulletin->options['censorwords']);
$most_searched = "";
$m = $db->query_read("SELECT MAX(`count`) AS m FROM " . TABLE_PREFIX . "coder_searchstats");
$ma = $db->fetch_array($m);
$max = $ma['m'];
if($max)
{
$rat = 3/$max;
$get = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "coder_searchstats ORDER BY `count` DESC LIMIT " . $vbulletin->options['setting_searchstats_showusernum']);
while($put = $db->fetch_array($get))
{
$r = round($rat*$put['count']);
if(!in_array(strip_tags($put['query']), $censor_words)) $most_searched .= "<a href=\"search.php?do=process&searchstats=nocount&q=". $put['query'] ."\"><font size=\"".$r."\">" . strip_tags($put['query']) . "</font></a> &nbsp;&nbsp;";
}
}
else
{
$most_searched .= "None";
}
}

[davide101]

Looking at the code in 4x4 Mecca's screenshot, I think that htmlspecialchar() could fix the problem by replacing those brackets with &lt; and &gt;

[coderphp]

sorry !!!!!!
indeed the MOD is not safe
for all i removed the attachment & updated the thread.....

[vbl]

bad think, i really enjoyed this great MOD!

do you update the MOD soon?

[Scandal]

Great MOD!
I hope that you will fix it soon!

[Dr. Bantham]

I have removed the code from FORUMHOME and deleted the product. What file deletions should I make? Are there any other steps to removing this mod completely?

[yoyoyoyo]

I would love to see this fixed/updated

[lazytown]

Would be great if we can get this back! I marked it as one to install (but never downloaded it).

-vissa

[yoyoyoyo]

if this isn't going to be fixed can it at least be moved to the graveyard?

[city-love]

سؤال اخي محمد متى تنزل نسخه محميه من هذا الهاك

وشكرا لجهودك الكريمه
جزاك الله خير