Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Last 10 Searches Details »
Last 10 Searches
Mod Version: 1.00, by AntiOnline (Member) AntiOnline is offline
Developer Last Online: Jun 2004 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (3 votes - 5.00 average) Installs: 156
Released: 07 Mar 2002 Last Update: Never Downloads: 9
Not Supported  

Greetings All:

Updated 3/11/2002: Hack now shows the date and time each search was made, plus the number of results. Also included is the security fix by firefly (thanks).

Updated 3/8/2002: It now also links those search words to the previous search results.

Here's just a little fun feature that I added for my users, and thought that I would share with everyone else. It works with versions 2.03 and up, requires no modifications to your database, and should take less than 2 minutes to install:

This hack displays the last 10 searches made by your users on your main site search page. It uses your censor options to make sure nothing naughty shows up (unless, that is, you want it to).

Demo at http://www.AntiOnline.com/search.php

Enjoy!

Yours In CyberSpace,
John Vranesevich
Founder, AntiOnline

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Forum Home Enhancements Most active user Last X (last day/last week/last month/ever) Fully controlled Omranic vBulletin 3.6 Add-ons 70 03 Nov 2011 17:05

  #121  
Old 23 Dec 2002, 09:06
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Originally posted by Squirre1
Hey FireFly, you might want to check me on this one...

I looked into this because I have not been able to see any searchs that I am performing


Are you searching with a regular user account?

.. Based on the below quote from the MySQL manual:

If the search was performed by a guest which has an account value of "0", it tries to do the NOT IN which it can not compare to anything because that account does not exist in the user table...

I think this should be a correct query, I have tested here and it is working with no issues:

SELECT searchid,postids,dateline,querystring FROM search LEFT JOIN user USING (userid) WHERE querystring!="" AND (usergroupid NOT IN (5,6,7) OR search.userid = "0") ORDER BY searchid desc LIMIT 0,10
I guess I'm not sure why you would need to add the OR search.userid = "0" part. I'm not very good at mySQL, though.

Also, as a note to some people, I had to upgrade my search.php in order the get the links created correctly so other users could access them. Otherwise, I got a user is not authorized message.

Enjoy this info folks.... !!
How did you upgrade? I am running 2.2.9 and it seems to work fine here.
Reply With Quote
  #122  
Old 23 Dec 2002, 12:18
Squirre1 Squirre1 is offline
 
Join Date: Jan 2002
When I say I had to upgrade... It was from the 2.2.6 Search.php to the 2.2.9 search.php... Also, the listings that did not get displayed were guest listing... Guests also have the option to search my forums and it was there searches that were not coming up in the last 10 searches list... BUT, registered users searches were...
Reply With Quote
  #123  
Old 25 Dec 2002, 00:37
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
I see what you mean now. Their searches don't show on the listing, but they are still able to search. I like it the way it is now, though. I also allow them to search, but not be listed in the last 15 (I set it to that). Gives them more of an incentive to register.
Reply With Quote
  #124  
Old 25 Dec 2002, 22:11
Da`Nacho Da`Nacho is offline
 
Join Date: Mar 2002
Originally posted by User_001
Nice hack, Thanks.

And i don't think you want to have Mods and admins searches shown...unless there is a way of checking user permissions in the search(if the user is an admin or mod then it shows All post by the admin or mod). IMO, a serious flaw in security.
Just so everyone knows, I think this was fixed in vBulletin 2.2.8 so that permissions are checked before sending the user the search results. I've checked on my forum and search results matching threads said user doesn't have access to no longer seem to show up. As a result I have removed the 'not in 5,6,7' part of the hack on my forums and things are working peachy.
Reply With Quote
  #125  
Old 02 Mar 2003, 10:58
mini2 mini2 is offline
 
Join Date: Nov 2001
Originally posted by Da`Nacho


Just so everyone knows, I think this was fixed in vBulletin 2.2.8 so that permissions are checked before sending the user the search results. I've checked on my forum and search results matching threads said user doesn't have access to no longer seem to show up. As a result I have removed the 'not in 5,6,7' part of the hack on my forums and things are working peachy.
Just installed this hack, very cool. I'm addicted to vB hacking now!

www.mini2.com/forum/search.php

Is the above (regarding the 'bug fix') correct, is it safe to remove the 'not in 5,6,7' section of the query?
Reply With Quote
  #126  
Old 10 Mar 2003, 08:24
Brother Brother is offline
 
Join Date: Sep 2002
Real name: Homood
I use it in my version 2.3.0 and it works
Reply With Quote
  #127  
Old 10 Mar 2003, 17:29
monstergamer's Avatar
monstergamer monstergamer is offline
 
Join Date: Feb 2003
Real name: Ryan
great hack
love it
clicks install
__________________
Video Game Forum

Last edited by monstergamer; 10 Mar 2003 at 17:32.
Reply With Quote
  #128  
Old 21 Mar 2003, 16:59
Sweet Cheeks's Avatar
Sweet Cheeks Sweet Cheeks is offline
 
Join Date: Mar 2002
06-20-02 at 05:31 AM Kathy said this in Post #91
This is a great help to me. Thanks!

I'm wondering about making it possible for admin to see the users on this page? (Or have a page just for admin to see the searches?)
Yes I'd love this too, did anyone ever figure out how to do this?
Reply With Quote
  #129  
Old 22 Mar 2003, 04:30
Snapperhaed Snapperhaed is offline
 
Join Date: Mar 2003
Nice hack! Thanks! Works fine on v2.3.3
Reply With Quote
  #130  
Old 24 Mar 2003, 16:01
Brooke Brooke is offline
 
Join Date: Mar 2003
Easily installed on 2.3 release 3. Thanks!!
Reply With Quote
  #131  
Old 31 Mar 2003, 12:50
Intex Intex is offline
 
Join Date: Apr 2002
Installed and works fine - just make sure you set the correct usergroup ID's dependent upon who you want to list search results for, whilst taking into consideration the security implications.

/me clicks install .
Reply With Quote
  #132  
Old 13 Apr 2003, 03:37
0ptima 0ptima is offline
 
Join Date: Feb 2002
I installed it on 2.3.0
Reply With Quote
  #133  
Old 14 Apr 2003, 14:56
neocorteqz's Avatar
neocorteqz neocorteqz is offline
 
Join Date: May 2002
Real name: George E Collins Jr
12-25-02 at 07:05 PM Da`Nacho said this in Post #124
Just so everyone knows, I think this was fixed in vBulletin 2.2.8 so that permissions are checked before sending the user the search results. I've checked on my forum and search results matching threads said user doesn't have access to no longer seem to show up. As a result I have removed the 'not in 5,6,7' part of the hack on my forums and things are working peachy.
Nice, thanks for letting us know that.

I'd also like to know if it's possible to list which user searched for what.. For admins only of course.
Reply With Quote
  #134  
Old 30 Apr 2003, 10:28
Doubledoom Doubledoom is offline
 
Join Date: Jan 2003
installed on 2.3.0 and removed the NOT IN part and permissions are working fine.

Thanks.
Reply With Quote
  #135  
Old 02 May 2003, 02:28
:Judge:'s Avatar
:Judge: :Judge: is offline
 
Join Date: Jan 2003
Real name: Judge
I had trouble at first tryin to edit www/search.php

I figured out that I needed to edit www/forums/search.php so it is workin now like a charm.

I don't know if I missed something here but this does not look like the last 10 searchs here, mine is pretty big.

The last 10 takes up alot of space on the page, anyway to slim it down some?

Might help if I add a link
http://www.planetquintessa.com/forums/search.php?
__________________
Cecil County, Maryland

Last edited by :Judge:; 02 May 2003 at 03:51.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 12:02.

Layout Options | Width: Wide Color: