Recent Queries: From the Last 30 Days

This mod displays information about search queries from the last thirty days, starting from the day you install this mod. It does not include 'getnew' or 'getdaily' queries. The search ID link is active if you allow search sharing, the search was less than an hour ago, and the search has results. The IP address is resolvable like it is on the WOL page. The recent queries table created by this mod is in the same format as the vB search table, should you wish to make personal extensions to this mod. The number of results for the same query may vary, depending on how you set your vB permissions. See the screenshot.

[MorrisMcD]

Originally Posted by calorie

In the recent_queries.php file find:

require_once('./global.php');

And afterwards add the following:

if (!is_member_of($vbulletin->userinfo, 5, 6, 7))
{
	exit();
}

Where 5, 6, 7 represents these groups:

5 : Super Moderators
6 : Administrators
7 : Moderators

Thanks!

[htrshgytrs]

Originally Posted by Milad

This is nice, and may be used to show queries from last 30 days in clouds for forums that use fulltext search

I'd be keen to display the common searches in a cloud, how could this be done?

[htrshgytrs]

i used the cloud from here and altered the SQL to return common search terms in the cloud. Not pretty or too clever, but it works!

I changed this:

PHP Code:

$wordcloud_infos = $db->query_read("
    SELECT SUM(score) AS f1, t2.title AS f2
    FROM " . TABLE_PREFIX . "postindex AS t1, " . TABLE_PREFIX . "word AS t2
    WHERE t1.wordid = t2.wordid GROUP BY t1.wordid ORDER BY f1 DESC LIMIT 100
"); 


to this:

PHP Code:

$wordcloud_infos = $db->query_read("
SELECT  count(query) AS f1, query AS f2
        FROM " . TABLE_PREFIX . "rq_recent_queries AS t1
        WHERE t1.sortby = 'lastpost' AND t1.searchuser = '' GROUP BY f2 ORDER BY
 f1 DESC LIMIT 100
"); 


[athlon64bit]

Still working fine on version 3.6.9 just if anyone is wondering. I love this mod, being able to log search results or details should I say is very useful.
Thanks.

[Boofo]

I have guests allowed to search but when I do a search as a guest, it doesn't show up in the listing. I am using 3.7.0 RC1. Also, this doesn't record the search made in the drop down on the navbar. Shouldn't it pick that up to?

[athlon64bit]

Will this be made available for vb3.7? It is a brilliant mod. I hope so.