vb.org Archive - vB3 15 Most Recent Searches Made By Our Members

Page 9 of 16

« First

Last »

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

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - vB3 15 Most Recent Searches Made By Our Members (https://vborg.vbsupport.ru/showthread.php?t=61424)

Imprezer

06-01-2004 12:11 AM

Great hack!
Works great!
Thanks!

- Alex

FWF	06-05-2004 06:34 PM

nice hack

Onkel_Tom

06-05-2004 11:18 PM

Hi Boofo, my old friend, very nice Hack !
clicked install

thank your ;)

cteselle

07-17-2004 05:51 AM

vb is also only showing the last hour of searches for me. This was on a fresh 3.0.3 install on my test board. So I did some investigating. I figured I would start at the scheduled tasks, so I took a look at the "Hourly Cleanup" entries. In the file ./includes/cron/cleanup.php I found:

PHP Code:


		
			
//searches expire after one hour

$DB_site->query("

    ### Remove stale searches ###

    DELETE FROM " . TABLE_PREFIX . "search

    WHERE dateline < " . (TIMENOW - 3600)

);

I have not tested this yet, but I don't know why it wouldn't work. You could change the 3600 to whatever you want to get the desired result. 86400 for 1 day, 604800 or 1 week, etc.

If I have problems I will report back.

Boofo

07-17-2004 08:19 AM

Quote:

Originally Posted by cteselle

PHP Code:


		
			
//searches expire after one hour
$DB_site->query("
    ### Remove stale searches ###
    DELETE FROM " . TABLE_PREFIX . "search
    WHERE dateline < " . (TIMENOW - 3600)
);

Mine have always only showed for 24 hours with vB3. Please keep me posted on what you find out with this. ;)

j_86	07-17-2004 10:17 AM

I am getting this error;

Code:

Database error in vBulletin 3.0.3:



Invalid SQL: SELECT search.searchid,search.orderedids,search.dateline,search.query,search.userid,user.username,user.userid,user.usergroupid FROM vb3_search,vb3_user WHERE query!='' AND user.userid = search.userid AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,15

mysql error: Unknown table 'search' in field list



mysql error number: 1109



Date: Saturday 17th of July 2004 12:16:03 PM

Script: http://forum.ugamer.net/search.php?

Referer: 

Username: S------

IP Address: -----------

Any ideas why?

My table prefix is vb3_

I'm running 3.0.3 :)

Boofo

07-17-2004 04:54 PM

JimpsEd,

Change to following queries. They will add the table prefix for you.

Change:

PHP Code:


		
			
$querycount=$DB_site->query_first("SELECT COUNT(*) AS orderedids FROM " . TABLE_PREFIX . "search LEFT JOIN " . TABLE_PREFIX . "user USING (userid) WHERE query!='' AND usergroupid NOT IN (5,6,7)");

to:

PHP Code:


		
			
$querycount=$DB_site->query_first("
SELECT COUNT(*) AS orderedids FROM " . TABLE_PREFIX . "search AS search
LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid)
WHERE query!=''
AND usergroupid NOT IN (5,6,7)
");

Change:

PHP Code:


		
			
$lastsearches=$DB_site->query("SELECT search.searchid,search.orderedids,search.dateline,search.query,search.userid,user.username,user.userid,user.usergroupid FROM " . TABLE_PREFIX . "search," . TABLE_PREFIX . "user WHERE query!='' AND user.userid = search.userid AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,15");

to:

PHP Code:


		
			
 $lastsearches=$DB_site->query("
SELECT search.searchid,search.orderedids,search.dateline,search.query,search.userid,user.username,user.userid,user.usergroupid
FROM " . TABLE_PREFIX . "search AS search," . TABLE_PREFIX . "user AS user
WHERE query!=''
AND user.userid = search.userid
AND usergroupid NOT IN (5,6,7)
ORDER BY searchid desc LIMIT 0,15
");

That should fix it for you. ;)

Make sure to click install. ;)

j_86	07-17-2004 11:29 PM

Thanks for the tips :)

But, unfortunatly nothing is showing at all - just nothing.

Even from a clean install of your mod with your changes (and yes, template stuff correct);

http://forum.ugamer.net/search.php?

:(

Not even an error message. ( I have also testing searching as regular user, and also turning off User Group *not** 7,6,5

Boofo

07-18-2004 09:18 AM

Quote:

Originally Posted by JimpsEd

You had to miss something somewhere. Re-check the hack and make sure you didn't miss anything. And also remember, the search listing will not show up until there is at least one successful search made.

j_86	07-18-2004 10:28 AM

Still definetly not working :surprised:

I cannot understand, i've resinstalled the hack, even installed it on a blank forum install.

Attatched is my Search.php and Template file if you can see anything wrong. The Search Template is a reverted one, with the hack added. The same goes for the search.php file, only with your above query modifications.

I have tried rebuilding search indexes etc.

All times are GMT. The time now is 09:44 AM.

Page 9 of 16

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01176 seconds Memory Usage 1,759KB 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 (1)bbcode_code_printable (6)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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: