[Request] : Search Log hack !

[gcurrey]

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