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

[Tom_S]

Installed then Uninstalled. It crashed my board:

Database error in vBulletin 3.6.4:

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

MySQL Error : Table 'myboard.vb_coder_searchstats' doesn't exist Error Number : 1146

[Tom_S]

Okay...I read through all this thread and see that I have to manually fix this issue. It also says it would be updated and fixed in the next few days from the 21st but it isn't. I will wait until it is. doing it manually is no problem. just don't want to

Great mod though

[coderphp]

Originally Posted by Tom_S

Okay...I read through all this thread and see that I have to manually fix this issue. It also says it would be updated and fixed in the next few days from the 21st but it isn't. I will wait until it is. doing it manually is no problem. just don't want to

Great mod though

the new version isnot to be released now as im busy with my work...

u can query it manually though

[dutchbb]

Is there a way to just show the top 5 most searched on forumhome? Without changing the fontsize, just 1. keyword 2. keyword 3. etc...

I'm guessing it's

ORDER BY RAND()

rand = random? How to make it order by most searched?

[coffee]

Great job brother ..

Could you please add search terms from search engines like Google, Yahoo and MSN?

That can be done through reading visitor's browser header.

[coderphp]

Originally Posted by dutchbb

Is there a way to just show the top 5 most searched on forumhome? Without changing the fontsize, just 1. keyword 2. keyword 3. etc...

I'm guessing it's

ORDER BY RAND()

rand = random? How to make it order by most searched?

replace

ORDER BY RAND()

with

ORDER BY `count`

regards

[coderphp]

Originally Posted by coffee

Great job brother ..

Could you please add search terms from search engines like Google, Yahoo and MSN?

That can be done through reading visitor's browser header.

Ahlan mohammed

yes it could maybe soon ill add this feature

Regards

[dutchbb]

Originally Posted by coderphp

replace

ORDER BY RAND()

with

ORDER BY `count`

regards

I tried it without succes.

Can you please check my plugin code for errors:

if($vbulletin->options['setting_searchstats_showuser']){
$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 = 5/$max;
$get = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "coder_searchstats ORDER BY `count` LIMIT " . $vbulletin->options['setting_searchstats_showusernum']);
while($put = $db->fetch_array($get))
{
$r = round($rat*$put['count']);
$most_searched .= "<span dir=\"rtl\"><a href=\"search.php?q=". $put['query'] ."\"><font size=\"".$r."\">" . strip_tags($put['query']) . "</font></a></span>&nbsp;&nbsp;";
}
}
else
{
$most_searched .= "None";
}
}

Thank you

[coderphp]

Originally Posted by dutchbb

I tried it without succes.

Can you please check my plugin code for errors:



Thank you

the code looks good

can u please copy the error u got?

[dutchbb]

it didn't order on count. But I installed it again and now it seems to order ok

But I still get this problem with the blank keyword: