vb.org Archive - Recent Queries: From the Last 30 Days

Page 3 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Recent Queries: From the Last 30 Days (https://vborg.vbsupport.ru/showthread.php?t=137185)

MorrisMcD

01-25-2007 11:55 AM

Quote:

Originally Posted by calorie (Post 1166732)

In the recent_queries.php file find:

Code:

require_once('./global.php');

And afterwards add the following:

Code:

if (!is_member_of($vbulletin->userinfo, 5, 6, 7))

{

        exit();

}

Where 5, 6, 7 represents these groups:

Code:

5 : Super Moderators

6 : Administrators

7 : Moderators

Thanks!

htrshgytrs

01-31-2007 11:49 PM

Quote:

Originally Posted by Milad (Post 1165445)

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

02-01-2007 12:29 AM

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

04-01-2008 01:09 AM

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

Boofo

04-01-2008 01:52 AM

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

04-30-2008 02:14 AM

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

All times are GMT. The time now is 09:34 PM.

Page 3 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01017 seconds Memory Usage 1,728KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: