Search Log

[derekivey]

Search Log
Developer: derekivey (https://vborg.vbsupport.ru/member.php?u=81169)
Version: 1.0.0 Beta 1
vBulletin Version: 3.5.4
File Edits: 0
Template Edits: 0
New Phrases: 9
Uses Plugins: Yes!
Difficulty: Easy

Description: This hack logs every search query made on your forum. Useful to see what visitors are most interested in.

*** I Strongly Recommend That You Backup Before Installing/Upgrading This Hack! I am not responsible for any damage this hack may cause to your forum, so backup! ***

Planned features for a later release:

Anything that is suggested.Donations:
If you would like to make a donation, you may send it to me through PayPal.
https://vborg.vbsupport.ru/external/2013/04/2.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=derek%40nbsdesignz%2ecom&item_name=vBulletin%20Hack%20Donation&no_shipping=1&cn=Optional%20Message&tax=0&currency_code=USD&bn=PP%2dDonationsBF&charset=UTF%2d8)

I have added screen shots of this hack in action below.

Please click https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=114166) If you installed this hack.

Thanks!

[derekivey]

First Post Reserved For Future Use.

[Daniel]

Great idea.

/me will install and download soon enough.

[derekivey]

Thanks let me know if you have any problems with it.

Derek

[bobmonkey380]

lol, Yes there is a problem, I added everything yet, There is no search logs under stats.

[Boofo]

This could get quite big on a busy forum. Interesting idea, though. ;)

[DomP]

lol, Yes there is a problem, I added everything yet, There is no search logs under stats.


LoL, it's not there indeed :D

[Floris]

*nice*

[maroceve]

i don t see it either.

[derekivey]

I'll take a look when I get back from school.

Thanks,
Derek

[SaN-DeeP]

good idea derekivey, before installing the hack are we also able to log queries from guests ?

[Snake]

That's a great idea but will probably slow down the server load.

[derekivey]

good idea derekivey, before installing the hack are we also able to log queries from guests ?

Yes it logs all users including guests.

Also to all of you who think it will have much of an effect on the server load, I think it wouldn't. It just executes one query when every they do a search, the query just inserts a row into a table, so it shouldn't have much of an effect...

Derek

[derekivey]

I have fixed the bug with it not showing up in the Admin CP nav. The cpnav xml file was incorrectly named. Please upload the attached file instead to the includes/xml folder. The zip file has been updated too to include the new file.

Thanks,
Derek

[DomP]

Looks nice, will it be possible in the future to show stats for most used queries and such ?

[yinyang]

Looks nice, will it be possible in the future to show stats for most used queries and such ?

that would be very cool. sort of being able to sort not only via user name, but also via topic, etc. that would be very helpful and i think good for setting up advertising rates???

[derekivey]

Yup I am planning on adding that to the next beta release.

Derek

[DomP]

any news already ?

[derekivey]

It's not done yet. Sorry, I've been so busy with school work. I will try to work on it soon.

Derek

[DomP]

Cool, I really like the stats :)

[Nathan2006]

Thank you derekivey

This is really great! :D

Install;)

[Inferno Dragon]

Is there any sort option like sort the log by username? and clear log option?

[derekivey]

That hasn't been added yet. It will be in the next release. I can't give an ETA when the next release will be, but it will be soon.

Derek

[harry_5]

Hi, great hack!

One question: Very often I don´t find anything under "query". Can´t believe that so many people don´t fill in a word they are searching for. Maybe a bug?

[derekivey]

I'll have to take a look. I will get back to you on this.

Derek

[derekivey]

They most likely haven't entered anything into the search. It could be spiders or something doing it maybe. I am going to release a new version soon and have it not log the blank ones, to prevent it from wasting server resources and because that is useless logging blank queries lol.

[harry_5]

They most likely haven't entered anything into the search. It could be spiders or something doing it maybe. I am going to release a new version soon and have it not log the blank ones, to prevent it from wasting server resources and because that is useless logging blank queries lol.

Cool, thanks!

[derekivey]

No Problem :)

[Nathan2006]

Hi Derek,

After pruning users search results I receive the following:

Could not find phrase 'pruned_search_log_successfully'.

Thanks for any help :)

[derekivey]

Just ignore it for now. It looks like I forgot to add that phrase. I will have it fixed in the next version.

[Nathan2006]

Just ignore it for now. It looks like I forgot to add that phrase. I will have it fixed in the next version.

no problem

Thank you for your reply :)

[pdblizzard]

*pdb clicks install*
thank you for this mod!

[Paul M]

Question - which searches does this log, i.e. does it log everytime someone does a getnew search ?

[derekivey]

Nope it doesn't look like it logs the getnew ones. It just logs regular searches.

[Paul M]

Good, it would be very bad to log every getnew, I might take a look at this then. :)

[64North]

Thanks for creating his hack derek.
Will you be porting it to 3.6?

[derekivey]

Should work fine on 3.6, but I haven't tested it. I will see if it does once I get some time.

Derek

[64North]

I installed it on a 3.6 gold and it works fine, no problems installing and no errors when looking at the results either.

Thanks again, awesome hack! ;)

[derekivey]

No Problem :).

[SaN-DeeP]

is this 3.6 complaint ?

[derekivey]

It should work, but I haven't tested it on 3.6. Others say it works fine for them though, so I don't see why it wouldn't work.

Derek

[kafi]

Great I will install this as soon as it will have stats available. Stat is what make this so handy...

[Coach_Guru]

I don't understood where i must see for the log statistics.

Thanks

[derekivey]

Should be under Statistics & Logs in the AdminCP...

[suzkaw]

Just installed on v3.6.8 and had no issues.

[Darksky]

Does it log also non regular text, for example malicious code as sql query, or php or also ? In other words, it store also attempts to hack using the search form ?

[Darksky]

Nobody can answer me ? :(

[fishmaster]

HAs anyone tried this with the 3.7 version of Vbulletin?

[robertt]

HAs anyone tried this with the 3.7 version of Vbulletin?

Works with vBulletin 3.7.2 Patch Level 2

[BirdOPrey5]

Working fine for me in VB 3.8.6.

[BirdOPrey5]

This mod actually works on 4.x as well you just need to rename the database table because VB4 already has one called "searchlog" and there's some SQL queries that need to be updated to the new name...

I made these changes for you... The attached zip has a new product.xml file and a new searchlog.php file... replace the files in the original mod with these and follow the install instructions... absolutely no code was changed other than the database name (to searchlog2) so this is still completely the original coder's mod. You could make the same changes with a text editor and search and replace if you want. If the original coder wants this will be removed, but all credit still goes to him for this useful mod.