[Request] : Search Log hack !
 

Hello,

Is there any hack which recods and displays as a search log in the AdminCP ??

This should redord :

1. The phrases searched
2. who searched
3. Number of thread results displayed by the search
4. Option for the admin within adminCP to delete logs
5. Download the search logs as tar/zip file.

Thanks if anyone can do this ?!

Cheers

similiar: https://vborg.vbsupport.ru/showthrea...ight=search%2A

Logician :

Thanks for the link,I have seen that hack, but what i want is in the admin CP not open to public, its just for my analysis as admin or owner of some community.

This can help me improving my boards.

I feel the same hack can be updated , added more features to achieve whats mentioned in my first post.

Just just 10 posts, i want all the searches to be logged....and then...there should be an option to delete the logs once the analysis is performed.

anyone interested to work on it ??

Thanks for your valuable time.

Cheers

here you go:

this is the file to upload:

FYI: Altough it's not Admin CP integrated, it can be displayed by Admins only!

Also it displays all existing keywords (upto 1000) in your search table so if you get few results, this is because that is all kept in your table..

Enjoy

Thanks Chief !

Logician :

Thank you for helping me with the code.

I'll install it in a couple of hours now. I'll get back here, if i bump into any problems or i'll PM if it works fine for me.

Cheers

Logician :

I installed the hacka nd its working perfectly fine.

Just that, i changed a bit of HTML...

Thanks very much for your valuable time.

Cheers

I tried this on 3.0.3 and got a database/table error. What needs to be changed on this mod to make it compatible with the latest database structure?

The error I get is:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT query("SELECT search.searchid,search.orderedids,search.dateline, search.query,search.userid,use r.username,user.userid,user.usergroupid FROM " . TABLE_PREFIX . "search," s LEFT JOIN user u ON u.userid=s.userid WHERE querystring!="" ORDER BY searchid desc LIMIT 1000
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 '("SELECT search.searchid,search.orderedids,search.dateline, sear

mysql error number: 1064

vb3 version: