recent searches (DDL)

[crook]

hey,
any one mind sharing his/her recent searches script? (DDL)
mine is kinda bugged, or i can't get it to work ;/

thanks,
crook.

 

[Ak47]

I wont mind a copy either :P.

 

[JmZ]

cant find mine (the one which almost everyone uses :P )

if i do ill put it on warezcoders.com
someone will most likely post it anyway

edit:
added it, see warezcoders.com

 

[crook]

wow thanks jmz
but i dont have a table for recents

or somthing that looks like

id | INT | 3 | auto_increment, primary key
query | VARCHAR | 100 | index
searches* | INT | 3 | none

Only the table ''id'' but none of my tables contain ''query'' or ''searches''
Got the tables: downloads, iplogg, linker & que

 

[JmZ]

yeah you have to make it then
just create a new table called "recents" and input the fields as listed in the text file (in phpmyadmin).

"searches" is an optional field also, only add that and its PHP if you want to track top searches.

 

[crook]

wow awesome jmz, it works! thanks.

 

[JmZ]

no problem, happy to see it works