[Velocd]

I'm having a problem with the search part of the hack right now. I'm getting this error:


Database error in vBulletin 2.2.4:

Invalid SQL:
SELECT DISTINCT post.userid,
thread.threadid,thread.threadid AS postid,thread.title AS threadtitle,thread.iconid AS threadiconid,thread.replycount,
thread.views,thread.pollid,thread.open,thread.last post AS postdateline,thread.lastpost,thread.lastposter,
forum.forumid,forum.title AS forumtitle,forum.allowicons,attach,
thread.postusername AS usrname,
user.userid AS postuserid, post2.pagetext as pagetext,
threadicon.iconpath AS threadiconpath,threadicon.title AS threadicontitle
FROM
thread,forum
LEFT JOIN user ON user.username=thread.postusername
LEFT JOIN icon AS threadicon ON thread.iconid=threadicon.iconid
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '1') LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '1')
WHERE
thread.forumid=forum.forumid AND thread.threadid IN (0,14)
ORDER BY
thread.lastpost DESC,thread.lastpost DESC
mysql error: Not unique table/alias: 'post'

mysql error number: 1066

Date: Sunday 24th of March 2002 10:06:49 PM
Script: http://www.diffusion4.com/search.php...der=descending
Referer:


Any clue?