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

[coderphp]

Originally Posted by HDT

I have customs usergroup "Bulldog Guard" with user group id:9

Then when I set "who can see most searched keywords?" to 5,6,9 there only usergroup id 5,6 who can view the most searched keywords stats in the mainpage.

All user who included usergroup 9 doesnt see it.

Please help.

there is no reason i know for such a problem
i tested with custom usergroups and it seems to be working fine...

[HDT]

Problem solved!Thanks

[coderphp]

Originally Posted by HDT

Problem solved!Thanks

anytime friend

[davide101]

<font color="DarkRed">WARNING</font>
Hi, this script is currently NOT safe. A bot searched a dozen times for a malicious phrase and got a javascript redirect to load when the top searches were displayed. Luckily it was just a redirect that can easily be removed. I would disable search logging or fix the software ASAP less someone with a lot more evil intentions starts poking around.

[coderphp]

Originally Posted by davide101

WARNING
Hi, this script is currently NOT safe. A bot searched a dozen times for a malicious phrase and got a javascript redirect to load when the top searches were displayed. Luckily it was just a redirect that can easily be removed. I would disable search logging or fix the software ASAP less someone with a lot more evil intentions starts poking around.

Hello
many thanx for ur interest, but I dont know how you consider this to be Not safe! as tags are removed on listing queries on forumhome,
notice this code snippet, taken from the product:

PHP Code:

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;"; 


notcie the function strip_tags (read more about it at php.net/strip_tags)
I see that this is enough to trim any malicious codes, as javascript tags are removed b4 listed on page

to unserstand what im saying please try to search for

<script, language="javascript">alert('hello');</script>

of course the alert will not appear, if it appears so almost u modified the Mod

thanx for ur interest again, and looking forward to hear from you

Regards
Mahmoud

[4x4 Mecca]

It is unsafe, I got hacked, and this link http://www.aktifmadde.com/hacked.html replaced my forumhome. I searched my tables, and found it in the coder_search table. See the attached images.

[coderphp]

Originally Posted by 4x4 Mecca

It is unsafe, I got hacked, and this link http://www.aktifmadde.com/hacked.html replaced my forumhome. I searched my tables, and found it in the coder_search table. See the attached images.

https://vborg.vbsupport.ru/showpost....2&postcount=45

[4x4 Mecca]

I read that post, but I don't get what you are saying... I did get hacked through this product... are you saying it's something I did wrong?

[coderphp]

Originally Posted by 4x4 Mecca

I read that post, but I don't get what you are saying... I did get hacked through this product... are you saying it's something I did wrong?

ok please put the code of ur plugin "forumhome_complete" 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";
}
}