Last 10 Searches

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

[Crazy Mofo]

nm

[Crazy Mofo]

actully how do you get it so theres no spaces between eace line?

e.g

https://vborg.vbsupport.ru/search.php?s=

[Twig Deez]

working fine for me. great hack!

[212rikanmofo]

this hack doesnt show up anything for me when i use

$lastsearches=$DB_site->query('SELECT searchid,postids,dateline,querystring FROM search LEFT JOIN user USING (userid) WHERE querystring!="" AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,10');

but it shows up when i use:

$lastsearches=$DB_site->query('SELECT searchid,querystring FROM search WHERE querystring!="" ORDER BY searchid desc LIMIT 0,10');

what gives??? and how come it doesnt display the user who ran the search like on here?

[212rikanmofo]

i found out why it wasn't displaying... it was filtering out the usergroup id's and unfortunately everyone doesnt have the same userids for there usergroups...

$lastsearches=$DB_site->query('SELECT searchid,postids,dateline,querystring FROM search LEFT JOIN user USING (userid) WHERE querystring!="" AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,10');

see where it says 5,6,7? i changed it to 1 and it shows up...

how do you findout what ID each of your usergroups are?

[inetd]

FireFly, please post version of hack in used this board.

[akaler]

That'd be cool if firefly did that! Except that, for me, I'd want to remove the bit of code that displays someone's name. If I left it in, I'd feel like one of those nasty kids who pulled down other kid's pants in school.

BTW... I continue to have some issues with this hack myself (as you can read above, i couldn't even get it going without taking out security modified queries, toying around, then placing the security modified queries back in) .

Even though usergroups 5, 6 and 7 are blocked exclusively, the hack still doesn't show searches by guests/not logged in folks (group 1), even though they can certainly perform searches.

And something else I just noticed is that people in group 3 -- awaiting email moderation -- their searches DO show up... but when I click on them in the last 10 list, nothing comes up! For one, it says "101 posts" next to the search, yet when I click on it and vB respond back saying "Sorry, no matches". (I've tried it logged on as both an admin and a normal registered user)

If I then do the *exact* same search again as as a normal user (group 2), then the search works, and it's entry on the last 10 list works, too... for everyone, in all groups. (as far as I can tell, anyway)

Kinda funky.

My usergroups are default.
Group 1 are Unregistered/not logged in.
Group 2 are normal Registered Users.
Group 3 are Users Awaiting Email Confirmation.
Group 4 are COPPA Users Awaiting Moderation.
Group 5 are Super Moderators.
Group 6 are Administrators.
Group 7 are Moderators.

Since my vB is so new, a lot of other things are default, too, and the code itself is relatively unhacked.

Any tips anyone?

212rikanmofo, in your vB control panel, on the left side of the screen, look for "User Groups". Under that, select "Modify". Hover your mouse over "Edit" link for each group, and in the url displayed on the status line of your browser.. at the very end, you'll something like &usergroup=7. That's the method I use to tell which usergroup is assigned to each number.

[TheComputerGuy]

Great hack, clicked installed.

www.gunandgame.com/forums/search.php

Thanks so much!

[Entourage]

cool one mate! tnx

[akaler]

Man, this seems to be working for sooo many people without problems. Makes those of us with 'issues' wonder 'what's wrong with meeeee????' like we're infected with the 'stupid' virus or something