vB3.5 15 Most Recent Searches Made By Our Members

[Boofo]

vB3.5 15 Most Recent Searches Made By Our Members
Version 1.0.4
(By Boofo)

What does this product do?
This product will display the last 15 searches made by your members on your main site search page at the top. The search words are then linked to those search results. It uses your censor options to make sure nothing bad shows up. The searchee will also be visible, but only to Admins. The search box will only show up when searches have been made. Searches made in your private forums are not shown to members who do not have access to those forums. It is now fully permissions based.

Version Information:
Version 1.0.0 --Initial release
Version 1.0.1 --Fixed error for new sites when the search table was empty.
Version 1.0.2 --Product is now fully self-contained. No more need for a template edit. Also changed the product name.
Version 1.0.3 --Fixed search template from repeating itself on each subsequent search.
Version 1.0.4 --Fixed searchee name being blank on a guest search.

Upgrade Instructions:
1. You MUST un-install the old product before upgrading due to the product name being changed.
1. Go to the "search_forums" template and remove "$last15searches" (sans quotes).
2. Install the product.

Credits:
A big thank you goes out to EvilSL1 for co-authoring the vB3.0 version, on which this hack has been converted.

Installation overview:
----------------------------
Products to install: (1)

[yoyoyoyo]

Thanks once again, Bob!

[Boofo]

You're very welcome, sir. Enjoy! ;)

[amykhar]

Dumb question. This doesn't show people doing the getnew search does it? My members do that every 2 seconds, which would make it impossible to see real search terms.

[Boofo]

Dumb question. This doesn't show people doing the getnew search does it? My members do that every 2 seconds, which would make it impossible to see real search terms.

No, it only shows specific words/terms they are searching for. ;)

[VirtualMind]

working fine here

*installs*

[amykhar]

Then I'll give it a shot. Thanks Bob. (See, I spelled your name right! :D )

[Boofo]

Then I'll give it a shot. Thanks Bob. (See, I spelled your name right! :D )

Oh, sure, spell it right when I release something. ;)

And you're welcome. ;)

[chanzero]

Oh, sure, spell it right when I release something. ;)

And you're welcome. ;)

cool :) thanks boofo *installs*

[FleaBag]

Nice addition Boofo. The 3.0 version intermitantly stopped working on me once I got past around 3.05 or so I believe - hopefully this one will work out :)! About to install - thanks a lot. :)

[Paul M]

Does this work for both search methods (i.e. vb search, and mysql fulltext search) ?

[Marco van Herwaarden]

Does this work for both search methods (i.e. vb search, and mysql fulltext search) ?All this hack does, is list the last 15 rows in the search table, and then apply forumpermissions on those.

This hack itself does not do any searching, so binary or fulltext search is not in the question.

So i don't really get your question.

[Paul M]

All this hack does, is list the last 15 rows in the search table, and then apply forumpermissions on those.Ah Okay, so it will work whichever method you have set on the forum.


This hack itself does not do any searching, so binary or fulltext search is not in the question.Yes, surprisingly, I did know it doesn't do any searching .... :p

So i don't really get your question.Try harder then ;) - oh, hang on - you answered it above :)

[dieselpowered]

Great hack, however, for some reason I am getting an error on the search.php page??

Warning: Invalid argument supplied for foreach() in /search.php(292) : eval()'d code on line 73

Any thoughts?

[Neal-UK]

Great hack, however, for some reason I am getting an error on the search.php page??



Any thoughts?

me too

[Boofo]

Are you installing it as a product or a plug-in?

[dieselpowered]

Are you installing it as a product or a plug-in?

I am installing it as a product...just as indicated :)

Thanks Boofo :)

[Boofo]

I am installing it as a product...just as indicated :)

Thanks Boofo :)

What version of MySQL and PHP are you using?

[dieselpowered]

What version of MySQL and PHP are you using?

PHP version 4.3.11

MySQL version 4.0.25

Thanks for looking into it!

[TTG]

Same error !?

Warning: Invalid argument supplied for foreach() in /search.php(292) : eval()'d code on line 73

[dieselpowered]

To add something...I just ran a search and now that error is gone and displaying the search...that is kinda odd...wonder what the issue is?

[dieselpowered]

Same error !?

You will notice that if you do in fact do a search of your own, that error will go away. Seems that when no searches are listed that is when the error appears??

[Boofo]

You will notice that if you do in fact do a search of your own, that error will go away. Seems that when no searches are listed that is when the error appears??

Your search table was empty. You shouldn't have any problem with that error now. ;)

Don't forget the install button. ;)

[dieselpowered]

You're search table was empty. You shouldn't have any problem with that error now. ;)

Don't forget the install button. ;)

So that error had to do with the fact that the table was empty? I guess if you say so as I know nothing about coding??

**clicks install just for Boofo :) **

[Boofo]

So that error had to do with the fact that the table was empty? I guess if you say so as I know nothing about coding??

**clicks install just for Boofo :) **

Yes, that was it. I just had it confirmed for me by someone who knows more about arrays than I ever will. I just need to add a check to make sure there are entries in the search table is all. ;)

[Neal-UK]

working now thankyou

[merk]

You will notice that the error will reappear every hour unless people have been searching. (The cron system deletes the contents of the search table that are over an hour old every hour)

Im sure Boofo and Marco will solve the issue soon.

[yoyoyoyo]

You will notice that the error will reappear every hour unless people have been searching. (The cron system deletes the contents of the search table that are over an hour old every hour)

Im sure Boofo and Marco will solve the issue soon.
same thing here.. I would prefer not to have a cron job to delete them, and keep the last 15 searches, without a time restraint.

[Boofo]

same thing here.. I would prefer not to have a cron job to delete them, and keep the last 15 searches, without a time restraint.

That would require a total re-write of this product.

[Boofo]

You will notice that the error will reappear every hour unless people have been searching. (The cron system deletes the contents of the search table that are over an hour old every hour)

Im sure Boofo and Marco will solve the issue soon.

The error doesn't appear for me when the search table contents are deleted. ;)

[dieselpowered]

You will notice that the error will reappear every hour unless people have been searching. (The cron system deletes the contents of the search table that are over an hour old every hour)

Im sure Boofo and Marco will solve the issue soon.

You are correct sir...I am having that issue as well.

I do not mind the cron job deleting the searches, however, I would like to not see that error every hour.

[ThePimp]

Any way to get this on the Forumhome?

[Boofo]

You are correct sir...I am having that issue as well.

I do not mind the cron job deleting the searches, however, I would like to not see that error every hour.

It is being worked on as we speak. Sit tight.

[yoyoyoyo]

That would require a total re-write of this product.you're not too busy are you? j/k Just a suggestion, but if it is undoable then that is fine. I would like to see the prune cron be optional, but not if it means a total re-write.

[Boofo]

Well, between this hack and talking to lawyers and dealing with that stuff (personal), I am doing what I can as best I can at the present time.

As far as the prune cron job goes, this hack doesn't touch any of that. That is how vBulletin handles that part of it.

[dieselpowered]

It is being worked on as we speak. Sit tight.

I am sorry, I did not mean to come accross as though I was knocking your hack or knocking you :)

[Boofo]

I am sorry, I did not mean to come accross as though I was knocking your hack or knocking you :)

No problem. ;)

I will get back to you shortly with a fix. ;)

[dieselpowered]

No problem. ;)

I will get back to you shortly with a fix. ;)

Excellent, looking forward to it :)

[Talisman]

Oh, no...... not that dreaded 15-Most-Recent-Searches hack?

Do you have any idea how distracting it was here when I went to search for something and a good 8 of the 15 previous searches caught my attention ... ? By the time I checked out what results someone else got back on those, I couldn't remember what I went there to search for in the first place. LOL.

:cheeky:

[Kirk Y]

If the keyword(s) you're searching for don't return any results, they're not added to the list. Any way to add keywords that don't yield results to the list?

[Gizmo5h1t3]

Warning: Invalid argument supplied for foreach() in /search.php(292) : eval()'d code on line 73

im gettin the same error...nice to see the coders are aware of it, and are working on a fix...

[dieselpowered]

Warning: Invalid argument supplied for foreach() in /search.php(292) : eval()'d code on line 73

im gettin the same error...nice to see the coders are aware of it, and are working on a fix...

Appears to have something to do with the search table being empty. I am sure Boofo would hook us up with a fix shortly :)

[Neutral Singh]

too good Thanks !!

[Forumi Shqiptar]

needed this thanks

clicked install :)

[Boofo]

If anyone is still getting the error mentioned in the thread, contact me via pm and I will give you a fix to test. I don't get the error so I can't test it.

[Mike Gaidin]

Nice to see that this one made the jump to 3.5.0

[Boofo]

Hello, stranger. Glad to see you around. ;)

[Mike Gaidin]

I'm always around. Just not much to say anymore. :(

Keep up the good work Bob.

[Boofo]

I'm always around. Just not much to say anymore. :(

Keep up the good work Bob.

PM me when you have time and we'll catch up. Got a new site. ;)

[Boofo]

New version has been uploaded that fixes the error for new sites when the search table was empty. ;)

[yoyoyoyo]

works like a charm- thanks again!

[Boofo]

works like a charm- thanks again!

Were you getting the error, too?

[dieselpowered]

Were you getting the error, too?

Yes sir he was getting the error as well.

Appears the hack is running correctly on my site...crons have run and cleaned up the search table...No errors showing.

Well done my friend, I will followup is any other issues arise :)

[dieselpowered]

More information to add...

I would recommed those running RC2 go into the ACP and select 'scheduled tasks' Once in there, go to manage and attempt to run some of the tasks manually. If you receive an error, do not panic...

go into your admincp/cronadmin.php

Find

$db = null;

Replace With

unset($db);

Save and you should be good to go!!!

RC3 should have this fixed.

[Boofo]

More information to add...

I would recommed those running RC2 go into the ACP and select 'scheduled tasks' Once in there, go to manage and attempt to run some of the tasks manually. If you receive an error, do not panic...

go into your admincp/cronadmin.php

Find

$db = null;

Replace With

unset($db);

Save and you should be good to go!!!

RC3 should have this fixed.

I forgot all about that. That's why my cron was running. I changed that a while back when they first found it. I'm sorry I didn't think of that, Mike. Duh on me.

[dieselpowered]

Its no problem my friend...I am watching the logs to see if they are running at the correct time.

Have a great one!

FYI, Hourly Cleanup #1 just ran, searches are still being shown...I will report back after #2 runs :)

[dieselpowered]

Ok hourly cleanup #2 has not removed the searches, they are still showing.

I am curious if there is another cron that does this??

[dieselpowered]

I guess Hourly Cleanup #1 is supposed to remove the info in this table, however, it did not on the first run...However, on the second it did???

[Boofo]

The hack is working fine. I wouldn't worry about the cron removing the searches. The longer they are there, the better, right? ;)

[john_robot]

I have a question The searches only can see to admin or is there any way to activate it public too??

[dieselpowered]

Ummm actually guest can view the searches. :)

[Boofo]

Ummm actually guest can view the searches. :)

But only in those forums you allow guests to view. ;)

[dieselpowered]

But only in those forums you allow guests to view. ;)

What do you mean? Are you saying that results will only display if guests have the permissions to view the forums in which the search results found information?

LOL that was a mouthful...

So if guests cannot view any of the forums, they will be unable to view the last 15 searches?

[Boofo]

What do you mean? Are you saying that results will only display if guests have the permissions to view the forums in which the search results found information?

LOL that was a mouthful...

So if guests cannot view any of the forums, they will be unable to view the last 15 searches?

Exactly! ;)

Try searching for a word that is in a private forum and you will notice that it will not show up to anyone who doesn't have permission to view that forum. As I stated in the first post, this is now FULLY permissions based. ;)

[Marco van Herwaarden]

What do you mean? Are you saying that results will only display if guests have the permissions to view the forums in which the search results found information?
Even better then just that. If a search for a word has for example 5 resulting threads, of which 3 are in public forums, and 2 in privat. It will show to those that have no access to the privat forum, that there are only 3 results. :D

[Boofo]

In Marco's example, the Admin, who has access to all forums would see the results as: 5 Threads while the other user who does NOT have access to the private forums would see the results as: 3 Threads. ;)

I tried to do this on the vB 3.0 version but didn't have any luck at it then. Marco's expert coding allowed it to happen for this version now. ;)

[Marco van Herwaarden]

No luck involved in coding Boobo. :D

[Boofo]

No luck involved in coding Boobo. :D

I rely on luck when I code. I have to. I don't have the skills you do. ;)

[Alien]

On RC3, has anyone gotten repeated looping? Like when going to the search page you will see, for example 5 results and 5 tables repeating the same information.. Do a new search, and you will notice 6 seperate tables (with all the correct data) but it keeps creating brand new template tables per search term.. Anyone? :)

[Boofo]

All this hack does is read the last 15 rows from the search table. It is very possible to have what looks like duplicates, but are really not, if you search for the same item more than once. It did the same thing in RC 2 and it working as designed. ;)

And don't forget the install button. ;)

[Oblivion Knight]

I seem to remember that previously, admin searches were not displayed..

Is this not the case with this new version?

[Boofo]

I seem to remember that previously, admin searches were not displayed..

Is this not the case with this new version?

They are displayed only to those who have access to whatever forums the searches are in. It is fully permissions based now. ;)

[Alien]

They are displayed only to those who have access to whatever forums the searches are in. It is fully permissions based now. ;)

I should explain more accurately. :)

Each search that is submitted, yields a brand new instance of the new table code inserted into the search template.. Wierdest thing I ever saw.. I uninstalled and reinstalled several times (even on a fresh version) so I have no clue how it could be happening...

Say I go into search, and type "test" and JUST installed your hack for the first time. It will display flawlessly. Do it again for something like "funny", it will display TWO tables BOTH showing test and funny results. :)

[Boofo]

First of all, they are not tables, they are rows. And it is working exactly as it should. ALL it is doing is pulling the last 15 rows in the search table. Whatever is in those rows is what it will pull. Simple as that. ;)

[Boofo]

Show me a pic if I still don't understand.

[Brandon Sheley]

ty, * installs* worked just like it should. this will be a great tool for me to organize the forums for the members, depending on what they are searching for alot :)

[phlogiston]

Show me a pic if I still don't understand.The whole results table repeats. v1.0.2 of the product with vB 3.5 RC3

Looking at the search_intro plugin the code that looks for $navbar and adds the $last15searches variable to te template is within a foreach statement moving the last closing } up four lines may be all that's needed for a fix? :)

[Boofo]

ty, * installs* worked just like it should. this will be a great tool for me to organize the forums for the members, depending on what they are searching for alot :)

And it will you (Only Admins) to see who is doing the searches. ;)

[Boofo]

The whole results table repeats. v1.0.2 of the product with vB 3.5 RC3

Looking at the search_intro plugin the code that looks for $navbar and adds the $last15searches variable to te template is within a foreach statement moving the last closing } up four lines may be all that's needed for a fix? :)

Ok, I see what it is doing. I will have a fix shortly. ;)

[Boofo]

First post updated with fixed and working version. ;)

[Alien]

First post updated with fixed and working version. ;)

Kick ass, I'll try this now! Thanks so much for the fix, Boofo!

[Brinnie]

BEHOLD!

For it is none ofther than I, Brinnie, of whom shalt be thy one to install thine plugin, YARRRRRRRRRGH!

[Brinnie]

Okay, so you know that 'dead space' in the middle?
I was wondering if it was possible to show some more search criteria in that space:


1) One would be to show the username of who they tried to look up.

2) Not as important as the first one, but another idea would be to show if it was a title seach... If not, I guess it could just show nothing. Or better yet, under Results instead of sayin that it's "125 threads" it could say "125 thread titles found".


Moving right along...

ACP controlls with Yes/No boxes for each search criteria. For instance:
Can view time of search? Yes/No
Can view Searchee? Yes/No
Show the forums they searched? Yes/No

Or you could just bundle all of the extra search criteria into 1 and call it game for admins/staff. You know, n00bs and stuff dont need that much, but a sharp moderator could benefit from extra criteria.


And I don't really need all of this, I'm just a would-be inventor. ;)
But for the first one, it would be nice to know if someone is looking you up. :D

[Mathiau]

trying this baby out!!

[Cyricx]

Hmmm, hard to tell from the screenshots, but I'm guessing this is supposed to show on the search.php page?

I've installed the product on RC2 but I'm not seeing the box at all.

[Boofo]

Try making a search and when it shows after that, run right back here and ... please click the install button! ;)

[Cyricx]

LOL, hey.. it's friday...

/me clicks install!

[Boofo]

hehe

Thank you. ;)

[hardgainer]

Try making a search and when it shows after that, run right back here and ... please click the install button! ;)

It shows up searches that I make myself, but not what my members are searching for.

I know that they must be searching because when I do a Whos Online it shows a good bunch of them as Searching Forums.

Either that or they are just sitting staring at the search page :p

Anyone else have this problem?

[Boofo]

It shows up searches that I make myself, but not what my members are searching for.

I know that they must be searching because when I do a Whos Online it shows a good bunch of them as Searching Forums.

Either that or they are just sitting staring at the search page :p

Anyone else have this problem?

They might be searching for words that aren't there. Or not in forums they have access to. And remember, the search table gets emptied hourly.

[hardgainer]

They might be searching for words that aren't there. Or not in forums they have access to. And remember, the search table gets emptied hourly.

I wasn't aware that it doesn't display words that contain no results.

Thanks for the confirmation :)

I have seen it working a little better today and it seems fine

[poliveira]

Strange! It is not working for me.
I do not see any results...

Is there an ACP setting that I am missing?

www.apsion.com/forums (http://www.apsion.com/forums)

[Boofo]

Strange! It is not working for me.
I do not see any results...

Is there an ACP setting that I am missing?

www.apsion.com/forums (http://www.apsion.com/forums)

It's showing fine at the top of your Advanced search page.

[Allan]

Hey Boofo

Work with vB 3.5 Gold ?

[Boofo]

It should work fine with Gold. From what I have seen, many others here have upgraded and it seems to be working fine for them. ;)

[DefenceTalk]

It should work fine with Gold. From what I have seen, many others here have upgraded and it seems to be working fine for them. ;)

Works fine with Gold here as well! thank you!

[Boofo]

Hey Boofo

Work with vB 3.5 Gold ?

Don't forget the install button in case there are any updates you don't want to miss out on.

[dieselpowered]

If this is working fine with 3.5 Gold, maybe the vBulletin Version should be changed on this thread. Just a thought :)

Some people like me get that warm fuzzy feeling when they see it ;)

[Boofo]

If this is working fine with 3.5 Gold, maybe the vBulletin Version should be changed on this thread. Just a thought :)

Some people like me get that warm fuzzy feeling when they see it ;)

Done! ;)

[dieselpowered]

Thanks man, works like a champ!

[poliveira]

It's showing fine at the top of your Advanced search page.

I see it now! thanks.

Another question.
How difficult is it to move the "recent queries" results for use in vbAdvanced?

[Boofo]

I see it now! thanks.

Another question.
How difficult is it to move the "recent queries" results for use in vbAdvanced?

I have no idea as I don't use vbAdvanced. I'm sure you would probably have to duplicate the code for that and it really wouldn't be worth it as the search table empties every hour on the hour.

[rezovor]

Nice Hack
*installs*

[vibe]

great mod

[Julie]

Brilliant! :D Thanks!

*installs*

[TundraSoul]

Hi,

I just installed and a few minutes later started getting these errors:



Database error in vBulletin 3.5.0:
Invalid SQL:

SELECT threadid FROM thread

WHERE threadid IN (27799,45961,32517,44111,2044, there's a couple hundred of them.
AND forumid IN ();

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 Error Number : 1064

Date : Tuesday, October 11th 2005 @ 07:53:17 PM

Script : http://www.tundrasolutions.com/forums/search.php?s=&action=finduser&userid=677 (http://www.tundrasolutions.com/forums/search.php?s=&action=finduser&userid=677)

Referrer :

IP Address : 65.54.188.26
Username : Unregistered
Classname : vb_database

[TundraSoul]

Update: All the errors appear to be coming from unregistered user who can use the search.

[Boofo]

I just tried to search on your site and no matter what words I tried, I got the word cannot be found error. I got no db errors at all.

[TundraSoul]

I disabled the plug-in.. but I'll turn it back on so you can try it.

I just tried to search on your site and no matter what words I tried, I got the word cannot be found error. I got no db errors at all.

[Boofo]

You're the first that seems to have run into this problem. We will investigate it and report back in here.

[Boofo]

I just tried searching as a guest and got no db errors of any kind. It is working as designed. I did, however, update this hack as it was not showing Guest as the searchee name when a guest had searched.

@ TundraSoul - Try uploading a fresh search.php and enabling this product and see if maybe something else is going on with it. If you have guests set to not be able to view forums, turn the searching off as it will not do them any good anyways.

I cannot reproduce the problem you are having, sorry. ;)

[TundraSoul]

I did that last night. My settings were set to allow Guests to search forums but they're unable to read the content of any threads. So their search results ended up with nothing. If they tried Advanced Search, they would get a dB error that I shown in this thread.

As a fix, I disabled the Search ability for Guests, since they cannot see anything anyway.

I just tried searching as a guest and got no db errors of any kind. It is working as designed. I did, however, update this hack as it was not showing Guest as the searchee name when a guest had searched.

@ TundraSoul - Try uploading a fresh search.php and enabling this product and see if maybe something else is going on with it. If you have guests set to not be able to view forums, turn the searching off as it will not do them any good anyways.

I cannot reproduce the problem you are having, sorry. ;)

[bi11i]

I'm getting Invalid Attachment specified. If you followed a valid link, please notify the webmaster
on download...

[Boofo]

I did that last night. My settings were set to allow Guests to search forums but they're unable to read the content of any threads. So their search results ended up with nothing. If they tried Advanced Search, they would get a dB error that I shown in this thread.

As a fix, I disabled the Search ability for Guests, since they cannot see anything anyway.

Ok, now it makes more sense what is happening. Do you have a hack installed for not being able to view thread contents?

@bi11i - It is there now. ;)

[TundraSoul]

No hacks at all. In vB3.5 Gold, under Forum Viewing Permissions there's now an option to disallow a usergroup from viewing the thread content. So for instance you can let them see the thread listing, (Can View Others' Threads) but not actually read the posts (Can View Thread Content).

Ok, now it makes more sense what is happening. Do you have a hack installed for not being able to view thread contents?

@bi11i - It is there now. ;)

[Boofo]

No hacks at all. In vB3.5 Gold, under Forum Viewing Permissions there's now an option to disallow a usergroup from viewing the thread content. So for instance you can let them see the thread listing, (Can View Others' Threads) but not actually read the posts (Can View Thread Content).

Ok, I'll look into getting something in there for a check for this in case anyone else ever runs into it. I guess I never paid much attention to it as I don't allow guests to search and wouldn't think of allowing them if they can't view any threads anyway. ;)

You might want to click install if I come up with an update for this. ;)

[Unexplained.tv]

This plugin is not stable, has several issues- don't install this until it is fixed. You have been warned.

[dieselpowered]

This plugin is not stable, has several issues- don't install this until it is fixed. You have been warned.

What do you mean, I have used it without any issues :surprised:

[Boofo]

This plugin is not stable, has several issues- don't install this until it is fixed. You have been warned.

And what fix would that be? Do you have any idea what you are even talking about? It doesn't sound like it.

[Chris M]

This plugin is not stable, has several issues- don't install this until it is fixed. You have been warned.

I highly doubt you even have tried this plugin - Please use constructive criticism if at all :)

If you are having technical issues with this plugin, please respond to the thread with your errors - You may find that you have an interfering plugin/modification that renders this one defunct...

Chris

[ciocsy]

worked perfectly, thanks.

[akanevsky]

"Searchee" ain't a word :)

[Boofo]

"Searchee" ain't a word :)

It is to me.

[akanevsky]

It is to me.

It's not in vocabulary though... Just thought that it is a typo. But you can, obviously, leave it as is if that's done on purpose.

[Boofo]

It was done intentionally as I couldn't come up with a word that worked better. And thank you for allowing me to keep it in there. ;)

[akanevsky]

No problem :)

[havefun]

* havefun clicked install

working fine. THX :)

[thanh]

My Vbb 3.5.0 Gold does not work as advertising

[thanh]

It's not show any recently searches ? may be why?

[Boofo]

Someone may be searching for words that just aren't there. Try some more searches and it will show up at the top of the Advanced search page.

[folkish]

Clicks Install.

[Rabbitoh Warren]

Installed and working fine, thanks! However, recent searches by my members seem to get reset periodically? Can this be changed or...?

[Boofo]

Installed and working fine, thanks! However, recent searches by my members seem to get reset periodically? Can this be changed or...?

vB 3.5 clears the search table via cron job every hour, I think. All this hack does is read the search table. That would entail file edits and an additional table or column.

[Rabbitoh Warren]

vB 3.5 clears the search table via cron job every hour, I think. All this hack does is read the search table. That would entail file edits and an additional table or column.No need for that, let's keep it simple. :) You're right too ? search table gets cleared every hour...

So would there any harm in editing the cleanup.php file directly and changing it to every 12 hours?

[Boofo]

I like it getting cleaned every hour. It keeps the search table smaller and easier to search. ;)

[Oblivion Knight]

I like it getting cleaned every hour. It keeps the search table smaller and easier to search. ;)Hmm, well mine doesn't seem to be getting cleaned every hour.

I still have my test listed from over 4 hours ago, are you sure it's every hour? :)

[Boofo]

Hmm, well mine doesn't seem to be getting cleaned every hour.

I still have my test listed from over 4 hours ago, are you sure it's every hour? :)

The cron job is set to run every hour unless you have changed it.

[Oblivion Knight]

Hmm, I don't remember editing it..

Anyway, it's cleaning every hour on my v2 test board alright so that's all I'm bothered about.!

[87accordlxi]

Works great! Is there a quick way this can be edited so that only certain usergroups can see it? I understand only admins can see the names, but I want to specify which usergroups can see this at all.

[ayaam]

Hi ..

good job .

I want to traslate some words like for exmpale (theats) to my langage , Can I ?

http://ayaam.cc/vb/search.php


thanks alot

[Boofo]

Hi ..

good job .

I want to traslate some words like for exmpale (theats) to my langage , Can I ?

http://ayaam.cc/vb/search.php


thanks alot

Sure, just edit the phrases on your site for this. ;)

[bobs409]

Excellent! Thanks. :)

Clicked installed


Bob

[Mastar]

do I have to turn it on? Is there a setting in the admincp that I have to edit. Where would I see the searches?

[Boofo]

do I have to turn it on? Is there a setting in the admincp that I have to edit. Where would I see the searches?

You will see them at the top of the Advanced Search page. ;)

[Widebertha]

When trying to install Vbulletin 3.5 and the VBJournal upgrade, the upgrade installation of VJournal really messed up the bulletin board. Had to re-install the VBulletin message board. It is impossible to install VBJournal so it will work properly. Any suggestions would be much appreciated. If I had known that VBJournal would cause these problems I would have stayed with VBulletin Message board 3.1.

Widebertha

[Boofo]

When trying to install Vbulletin 3.5 and the VBJournal upgrade, the upgrade installation of VJournal really messed up the bulletin board. Had to re-install the VBulletin message board. It is impossible to install VBJournal so it will work properly. Any suggestions would be much appreciated. If I had known that VBJournal would cause these problems I would have stayed with VBulletin Message board 3.1.

Widebertha

Wrong thread?

[Widebertha]

I have asked this question before; where do I post questions about vbulletin journal?

Widebertha

[Boofo]

I have asked this question before; where do I post questions about vbulletin journal?

Widebertha

The vB Journal thread. The same place you downloaded the hack. ;)

[FleaBag]

Just installed the latest version and seems to be working better than before, it's picking up all my searches too [something it's avoided since 3.0.x]. Thanks! :)

[rob30UK]

Ok....

I've had enough head battering...

I've done several searches that ALL return results spread across many public access forums....

However, I hit advanced search page.... and nothing.

Is there a delay? is there an on / off switch? Does it ignore admin searches?

[sportsoutlaw]

Just installed this, and it seems to be working fine.

[rob30UK]

Just installed this, and it seems to be working fine.
..... not for me it isn't

I take it 3.5.1 is compatible?

why isn't this working?

[Boofo]

..... not for me it isn't

I take it 3.5.1 is compatible?

why isn't this working?

There's no way it cannot work. Try installing it again.

[rob30UK]

There's no way it cannot work. Try installing it again.

I have... and it isnt.

Here's my product screen

[engineco16]

It's not working for me either, installed it as a plugin as said too and nothing.

[Robert Basil]

Works just fine for me running 3.5.1

[vtx1800]

Installed. Works great.

[Rabbitoh Warren]

It's not working for me either, installed it as a plugin as said too and nothing.It works. But nothing will appear on the search page unless a search has been made in the last 60 minutes on your forum.

[Boofo]

For those of you saying it isn't working, like Rabbitoh Warren said above, any searches made over an hour, will NOT show up. vBulletin erases the search table hourly via a cron job. That has nothing to do with this product. The product works. ;)

[rob30UK]

For those of you saying it isn't working, like Rabbitoh Warren said above, any searches made over an hour, will NOT show up. vBulletin erases the search table hourly via a cron job. That has nothing to do with this product. The product works. ;)Boofo, can you please stop being so self righteous and single minded.

Frankly, you are insulting my intelligence if you think I have not read this thread front to back..... I know you need to perfom searches.... i know the cron clears the table every hour. People in this thread are saying it works and you are telling me it works, fine... I hear you... now hear me, ITS NOT WORKING FOR ME!!!!

Can I hear some recommendations for troubleshooting this? It's a nice plugin and it would be a shame if I cannot get it working.

[Oblivion Knight]

It's not working for me either, installed it as a plugin as said too and nothing.It's no longer a plugin, and is now a product.

Sorry if I'm pointing out the obvious, but it's something that could be causing it not to work.. ;)

[rob30UK]

It's no longer a plugin, and is now a product.

Sorry if I'm pointing out the obvious, but it's something that could be causing it not to work.. ;)

It wont install as a plug in anyway... mine is certainly installed as a product.

[Boofo]

What version are you running of this? And check the template edit to make sure the code for it is in there.

[rob30UK]

Ok... I'm running:-
MOD version 1.04
vB version: 3.5.1

Template has been inserted under the 'search templates' branch and called 'search_last15'

I can also confirm that (looking in plugins)
'Last 15 Searches Template Cache' is listed under Hook Location : cache_templates
'Last 15 searches' is listed under Hook Location : search_intro
..... they are also both ticked as active

I really am stumped.

[sportsoutlaw]

this plugin is giving me fits. I installed it a few days ago, then suddenly it quit appearing on the search page.

I removed the plugin, reinstalled it this morning. It worked, but would only show 2 searches (and there were more searches than that, it just kept showing the last 2), and now it has disappeared completely again.

Has anyone run into this situation and no an easy solution?

[sportsoutlaw]

For those of you saying it isn't working, like Rabbitoh Warren said above, any searches made over an hour, will NOT show up. vBulletin erases the search table hourly via a cron job. That has nothing to do with this product. The product works. ;)

ah crap, disregard my last post. I had no idea this was the case and it has been bugging me to no end as to why this wasnt working.

[rob30UK]

Well, I have a definite problem, but Boofo refuses to accept there is an issue.

[m.s]

nice hack.
installed and thanks :)

[Oblivion Knight]

It wont install as a plug in anyway...Only in RC3 and onwards.. Before then it would have installed as a "blank" plugin.

[Paul M]

Well, I have a definite problem, but Boofo refuses to accept there is an issue.Hmm, you don't think your rant might have harmed your chances of support then .......

Disable all your other products & plugins so that this is the only one running. It is possible for one to intefere with another.

[funinthesun]

*Installed* This wouldn't work for the first three attempts. Everytime I tried to import the product it kept saying create additional fields. I just kept trying to import though and it eventually worked. Have no idea what happened there :confused:

[Boofo]

*Installed* This wouldn't work for the first three attempts. Everytime I tried to import the product it kept saying create additional fields. I just kept trying to import though and it eventually worked. Have no idea what happened there :confused:

Strange. That is the first time I have heard of that happening with this. Must have been a fluke. Glad you got it installed ok. ;)

[GTAce]

Hmmm....why do my most recent searches disappear from the list after a short period of time?

[Boofo]

Hmmm....why do my most recent searches disappear from the list after a short period of time?

You might want to read the thread sometime. ;)

https://vborg.vbsupport.ru/showpost.php?p=821641&postcount=159

[GTAce]

Fair enough, sorry about that...didnt feel like reading 12 pages of material, that is why ;)

[rob30UK]

Boofo, what would it take for you to help me troubleshoot the problems I am having.... I am certainly not making it up and all your instructions have been followed to the letter. I'm no Noob to installing plugins and everything is set up correctly.... yet nothing is showing on the search page.

Check post #164 (https://vborg.vbsupport.ru/showpost.php?p=821844&postcount=164) for more detail Boofo.

I would be grateful if you (or someone) can help me as I feel this is an important MOD

[Boofo]

Fair enough, sorry about that...didnt feel like reading 12 pages of material, that is why ;)

You should have been here a few years ago. Reading the entire thread was a prerequisite for most hacks. And it was enforced quite often. 12 pages is nothing compared to over 100. ;)

[Boofo]

Boofo, what would it take for you to help me troubleshoot the problems I am having.... I am certainly not making it up and all your instructions have been followed to the letter. I'm no Noob to installing plugins and everything is set up correctly.... yet nothing is showing on the search page.

Check post #164 (https://vborg.vbsupport.ru/showpost.php?p=821844&postcount=164) for more detail Boofo.

I would be grateful if you (or someone) can help me as I feel this is an important MOD

First of all, I have no problem helping anyone with any hack here, mine or not. But I don't respond very well to posts like the one you made above. As a matter of fact, as you saw, I don't respond at all to most of them. Asking for help will get you a whole lot further than demanding help, every time. Might want to remember that for future reference. ;)

Ok, now to help you. When I said to check the template to make sure the template code was there, I meant to check the search_forums template. Look at the very end of the xml file and you will see what should be in there. If that is there, then the only thing I can do is to take a look at your setup and see what is going on. I would need to have you make a test account and give it admin access. PM me the details and I will take a look for you.

[cbr929rrerion]

Question,is there any way to make a link to most recent searches?

Oh.. and it worked for me first time, first install..

Thank you...

[Boofo]

Question,is there any way to make a link to most recent searches?

Oh.. and it worked for me first time, first install..

Thank you...

The searches are already linked if you click on them, or are you meaning something else? ;)

[funinthesun]

Hi Boofo

For some reason the search list isn't showing up searches for users. I know this because I viewed my who's online and someone was searching for posts by one of our members however it didn't show up in the search list. I tried doing it myself and it still doesn't show up? Any idea why or is this mod not for that? Thanks :)

[Boofo]

Hi Boofo

For some reason the search list isn't showing up searches for users. I know this because I viewed my who's online and someone was searching for posts by one of our members however it didn't show up in the search list. I tried doing it myself and it still doesn't show up? Any idea why or is this mod not for that? Thanks :)

The only way that would happen is if they were searching for a word in a forum that they did not have permissions for. If the word is in a non-permissions forum, then it will not show up on the list for them. However, you should be able to see the word if you have permission for that forum.

Annd searching for posts is a lot different than searching for words. ;)

[cbr929rrerion]

I actually thought about my question after I hit submit, I was wondering if there could be a link that takes you to the list of most recent searches but it already does how them on the search page, I just think if we had a seperate php page for most recent searches and have a link in navbar to where they can search, advanced search, and most recent searches....

[Boofo]

I actually thought about my question after I hit submit, I was wondering if there could be a link that takes you to the list of most recent searches but it already does how them on the search page, I just think if we had a seperate php page for most recent searches and have a link in navbar to where they can search, advanced search, and most recent searches....

That could be done but I don't want to add any more to this hack than is already there since I would never use it in that fashion. You're more than welcome to add to it if you want and I can link it in the first post. ;)

[funinthesun]

Hi Boofo

I'm not sure what's happened but since installing the arcade the searches aren't showing up? Any idea why?

Thanks :)

[Boofo]

Hi Boofo

I'm not sure what's happened but since installing the arcade the searches aren't showing up? Any idea why?

Thanks :)

The arcade shouldn't have anything to do with this hack. Try re-installing the hack and set "allow overwrite" to yes and see if that fixes it.

[funinthesun]

OK, I've re-installed the hack and allowed overwrite but still nothing is showing up?

[Boofo]

OK, I've re-installed the hack and allowed overwrite but still nothing is showing up?

The seraches get deleted every hour via a cron job. Any searches over that time will be gone.

If the hack was working before you installed the arcade, then I would say to look there first, although I don't know how anything from the Arcade could be causing this.

[klaush]

Got it!

Thanks!

[funinthesun]

Oh right, I didn't realise that the searches get deleted every hour as the searches were showing up in the search list for up to 2 days ago. I'll wait and see what happens :)

[funinthesun]

Ok, just did a search and checked and it's showing up now. Thanks :)

[Bernd Glasstett]

I installed it here:
http://www.comicforum.de/search.php
however as we are on a german board, I was translating the phrases I found. But there are still some missing and still in english. Is there any way to find and translate them? I searched for them in in the phrase-system but didn't find anything. If this was cleared somewhere in the previous 12 page, please excuse me, but the search didn't find anything. :)

[Rickie3]

*installs* cheers
Bob

[SmartGnome]

Smartgnome clicks *Install* and Tnx guys

:mad:

[Boofo]

I installed it here:
http://www.comicforum.de/search.php
however as we are on a german board, I was translating the phrases I found. But there are still some missing and still in english. Is there any way to find and translate them? I searched for them in in the phrase-system but didn't find anything. If this was cleared somewhere in the previous 12 page, please excuse me, but the search didn't find anything. :)

I would have to know which phrases or text you are referring to. ;)

[tamborinegal]

Thanks Bob, this is great!

I actually thought this was a part of vBulletin after seeing it on a vB forum that I often visited before I bought my own copy of vB. I was disappointed when I couldn't find it, but here it is...

Great stuff, thanks :)

Clancy

[Boofo]

Thanks Bob, this is great!

I actually thought this was a part of vBulletin after seeing it on a vB forum that I often visited before I bought my own copy of vB. I was disappointed when I couldn't find it, but here it is...

Great stuff, thanks :)

Clancy

Thank you for the kind words. ;)

Enjoy! ;)

[kafi]

This hack is nice, but would be possible to develop this to all search statistic?

I would like to see statistic of most wanted keywrods on my board. This would be usefull for me to know and maybe to stick some of moste wanted answers on my board, or to make list of them etc... I think this will be a good stuff to check also for newcomers and will make another step to make order on my forum and prevent from multiplequestioning...

[Argyle]

200th Install. Woot!
I modded it a wee bit so that only admins could see the entire table.

[pete_brady]

ok not related to this hack really, but since i installed it i'm noticing some rather odd searches & was hoping maybe someone else could shed some light...

174 threads http://video-poker-casino.newsua.org
197 threads http://top-online-casino.newsua.org
201 threads http://roulette-bet.newsua.org
194 threads http://internet-casino-gambling.newsua.org
196 threads http://casinolasvegas.com.newsua.org
187 threads http://casino-guide.newsua.org
150 threads http://casino-gaming.newsua.org
1 post http://32Red-casino.newsua.org
130 threads http://32Red-casino.newsua.org
150 threads http://vegas-lucky.amparks.net
31 posts http://spin-palace.amparks.net
164 threads http://spin-palace.amparks.net
2 posts http://online-slot.amparks.net
1 post http://online-slot.amparks.net

sample from apache logs:
209.190.x.x - - [07/Jan/2006:08:42:40 +0000] "GET /bbs/showthread.php?t=107 HTTP/1.1" 200 70459 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:40 +0000] "GET /bbs/index.php HTTP/1.1" 200 58670 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:41 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:41 +0000] "POST /bbs/login.php HTTP/1.1" 200 23071 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:41 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:41 +0000] "POST /bbs/postings.php HTTP/1.1" 200 22791 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:42 +0000] "POST /bbs/search.php HTTP/1.1" 301 5 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:42 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:43 +0000] "POST /bbs/search.php HTTP/1.1" 301 5 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:43 +0000] "POST /bbs/threadrate.php HTTP/1.1" 200 22799 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:43 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:44 +0000] "GET /bbs/forumdisplay.php?daysprune=&f=cp HTTP/1.1" 301 5 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:44 +0000] "GET /bbs/index.php HTTP/1.1" 200 58275 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:44 +0000] "GET /bbs/usercp.php HTTP/1.1" 200 25184 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:44 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:45 +0000] "POST /bbs/postings.php HTTP/1.1" 200 22791 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:45 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:45 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:45 +0000] "GET /bbs/index.php HTTP/1.1" 200 58676 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:46 +0000] "POST /bbs/search.php HTTP/1.1" 200 22859 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:46 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:46 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:47 +0000] "POST /bbs/threadrate.php HTTP/1.1" 200 22799 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:47 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"
209.190.x.x - - [07/Jan/2006:08:42:47 +0000] "GET /bbs/forumdisplay.php?daysprune=&f=cp HTTP/1.1" 301 5 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:48 +0000] "GET /bbs/usercp.php HTTP/1.1" 200 25184 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5"
209.190.x.x - - [07/Jan/2006:08:42:48 +0000] "POST /bbs/login.php HTTP/1.1" 200 20358 "-" "libwww-perl/5.803"


I've no idea what's going on, but i'm blocking the IP's involved as I find them.

Anyone know what's up? My guess is it's something to do with spoofing search engines, but can't figure out how.

I'm also a bit puzzled by the fact that searches for the exact same url return different amounts of results. None of the returned posts/threads include any mention of the url searched for, so i'm guessing it's just seeing the http://www part or something.

[Dave-ahfb]

I am showing nothing at all.

1) searches made within five minutes, still not showing. (not an issue with cron cleaning searches)

2) The only changes I see on search_forums are from adding google adsense.

3) product is enabled, as are (2) hooks

4) link: http://www.ahfb2000.com/webmaster_help_desk/search.php

I may well be wrong but it seems obvious to me that the xml failed to write to the search_forums template. Can somebody post the changes that should be made to this template.

[TheMusicMan]

Sorry to ask this dumb question... but i have installed this plug-in, yet I don't see anything on my forums.

Is there an area in AdminCP that controls who sees this that I have yet to spot...?? Sorry for being dull...

[funinthesun]

It only shows up searches that are done recently. Try doing a search your self then taking a look. The cron deletes the search list every hour.

[TheMusicMan]

Thanks for the quick response funinthesun.

However, I did a quick search for 'coding', and yet I still see nothing on the forumhome page...? is this where it will appear?

EDIT: Damn... I see it now on the Search.php pages... sorry...:(

Also... is there any way of controling who actually sees this search list? it would be nice if we were able to control via usergroups et al...

[Guest210212002]

/me clicks install

[Dave-ahfb]

I am showing nothing at all.

1) searches made within five minutes, still not showing. (not an issue with cron cleaning searches)

2) The only changes I see on search_forums are from adding google adsense.

3) product is enabled, as are (2) hooks

4) link: http://www.ahfb2000.com/webmaster_help_desk/search.php

I may well be wrong but it seems obvious to me that the xml failed to write to the search_forums template. Can somebody post the changes that should be made to this template.


anybody have an idea?

Dave

[Boofo]

anybody have an idea?

Dave

Guests won't see the searches. If you want to make a test account with Admin CP priviledges, I can take a look and see if everything is set up right.

[Dave-ahfb]

Guests won't see the searches. If you want to make a test account with Admin CP priviledges, I can take a look and see if everything is set up right.


pm sent

[Nathan2006]

Works great!

Thank you

Install

[Pickalo]

Someone asked this a while ago, but is there any way to get this outside of the search.php page? Such as on the forumhome or something? Great hack - thanks :)

[bashy]

Hi boofo

This iant showing any last searches for me
I have imprted the product and still no go for launch...

I have checked for $last15searches and cannot find it so it aint that
What was the name of the old product, just in case ihad that installed,
but i dont think so?

[EasyTarget]

have you made any searches since you intalled it?

[bashy]

only about 20 odd lol

[bashy]

Hi, this does work ok for me sorry.....
I was checking Post and title search, not the main advanced search..

Is there a way to get this to show atop of the search results?

[Julie]

Thanks for the updated code! :)

*updates*

[mikeinjersey]

Hello this is the first Plugin i installed on my forums. It seemed to install flawlessly. Nice mod.

I have a few questions.

#1 I have 3.5.4 installed...Should i uninstall this Plugin when upgrading to the next version of vBulletin? (whenever its released)

#2 Im also having the problem with only a few searches being shown an hour...when many more are actually being done. Could someone tell me which Cron's i should disable so that the cleanups dont erase the data?

thanks

[cudaxtreme]

its in /includes/cron/cleanup.php

//searches expire after one hour
$vbulletin->db->query_write("
DELETE FROM " . TABLE_PREFIX . "search
WHERE dateline < " . (TIMENOW - 2592000) . "
### Remove stale searches ###

change the timing in green

[cudaxtreme]

Somehow the search results is still available to guests, anybody have any idea what went wrong?

http://www.asiareefing.org/forums/search.php

[Boofo]

Somehow the search results is still available to guests, anybody have any idea what went wrong?

http://www.asiareefing.org/forums/search.php

Because you allow guests to search. ;)

[cudaxtreme]

hrmmm ... is there a way to allow guest to search yet not display the top seaches to them?

[Boofo]

hrmmm ... is there a way to allow guest to search yet not display the top seaches to them?

You could do a conditional in the template.

[cudaxtreme]

Thanks but I'm a total newbie to this,

Could you please advise how can I do this?

[cavorite]

Installed and working great :) , but I still see members with "Searching Forums" as a location on Who's Online, and no new searches are displayed. Is there any way to know what these people are doing? We have a few that show this status nearly all the time, and I'd like to know what they're looking for (or looking at).

[Boofo]

Installed and working great :) , but I still see members with "Searching Forums" as a location on Who's Online, and no new searches are displayed. Is there any way to know what these people are doing? We have a few that show this status nearly all the time, and I'd like to know what they're looking for (or looking at).

The search table gets emptied every hour by a cron job. ;)

Do the searches you make show up?

[cavorite]

The search table gets emptied every hour by a cron job. ;)

Do the searches you make show up?
Searches are showing up correctly for me and from other members. I've just edited the cleanup job to extend the time beyond an hour, in case that was having something to do with it. However, I'm looking at the Who's Online right now and seeing members with the "Searching Forums" location, and yet no new searches are showing up in the "Last 15" list. :confused:

[Boofo]

Searches are showing up correctly for me and from other members. I've just edited the cleanup job to extend the time beyond an hour, in case that was having something to do with it. However, I'm looking at the Who's Online right now and seeing members with the "Searching Forums" location, and yet no new searches are showing up in the "Last 15" list. :confused:

They could be sitting on the search page and not doing anything. That happens a lot. I used to get that all the time on my old forums.

Or if they did a search for a word that wasn't found. That would explain the list being empty.

[cavorite]

I understand. It's just that we've got a "situation" with another forum, and a high percentage of these people that are doing this searching thing are from that forum. Love to know what they're looking at...

(Just in case it is an attempt to load the server with search requests, I do have the time between searches at 90 seconds. Also, we're not seeing high load numbers...)

[Boofo]

I understand. It's just that we've got a "situation" with another forum, and a high percentage of these people that are doing this searching thing are from that forum. Love to know what they're looking at...

(Just in case it is an attempt to load the server with search requests, I do have the time between searches at 90 seconds. Also, we're not seeing high load numbers...)

It sounds like they're either not finding whatever it is they are looking for or they are sitting on thre search page waiting for the time to pass so they can search again. ;)

[CSS59]

how do i remove the usernames so members don't see who serched

[akanevsky]

Perhaps you should store the data for this hack in a separate table (or a datastore). That's because vbulletin's searches expire and get erased after a certain amount of time, and your hack seems to draw info from there.

If you choose to store things in a separate place, it should have fields: userid (left join usertable for username), keywords, dateline, resulttype, resultcount. It would be easier to store this in a datastore because then you can strip everything that's more than x number that you wanna show without any extra queries. Just a suggestion :)

[Boofo]

how do i remove the usernames so members don't see who serched

The staff is the only one who can see the user names. Regulars users never see them. Look at the 2 pics in the first post. ;)

[Boofo]

Perhaps you should store the data for this hack in a separate table (or a datastore). That's because vbulletin's searches expire and get erased after a certain amount of time, and your hack seems to draw info from there.

If you choose to store things in a separate place, it should have fields: userid (left join usertable for username), keywords, dateline, resulttype, resultcount. It would be easier to store this in a datastore because then you can strip everything that's more than x number that you wanna show without any extra queries. Just a suggestion :)

We thought about doing that even in the 3.0 version but decided it against it as I wanted to stay with how it had been done since the "Chen" days. On busier boards the list can stay pretty well filled up as there are usually more searches. The only thing it would be good for is smaller boards, I guess. ;)

[SnickersTK]

its in /includes/cron/cleanup.php

//searches expire after one hour
$vbulletin->db->query_write("
DELETE FROM " . TABLE_PREFIX . "search
WHERE dateline < " . (TIMENOW - 2592000) . "
### Remove stale searches ###

change the timing in green

thanks man

[TheBlackPoet]

no errors... i installed it and it works great.. the problem i had is that since it was only a xml, i didnt really read through the dirty details that i've read before on other hacks...
the problem was i didnt know where to go on my test server to verify this hack works...
when i slowed down to re read the instructions it was there... MAIN SEARCH PAGE... SO GO JOB!!

[Spiffware]

whats nice ill hit installed

[nerofix]

sorry for this question, i did install this product but i cant find where it appears o_O

[futuredood]

is their any way to get this to work in the memberinfo page so that it links people with the $post[fieldxx]? (this links people with the same interests)..

[Smitty]

Anyone have this on 3.6?

[Kihon Kata]

Also requesting this on 3.6 Anyone?

[zeropaid]

Just installed and nothing is showing up. I am running 3.5.4.

Do i need to make any changes to the templates?

[Smitty]

This does look interesting, but I also am wondering about 3.6 compatability.

[VPREATR]

Smitty,
Same here, I too am interested in using this on 3.6.2

Thanks!

[PoetJA-1975]

Thanx!

Jacquii.

[Domenico]

So does it work on 3.6.2 ?

[TheComputerGuy]

it works for 3.63

[yoyoyoyo]

how can I change it to display the last 25 instead of the last 15?

[Jacksplat]

nice tool, thank you.