[Capt PPRuNe]

Installed the hack but now getting serious problem. The following code added in showthread.php:

PHP Code:

thread.postuserid AS puserid,bans.active AS active, 


and

PHP Code:

LEFT JOIN thread ON thread.threadid=post.threadid
LEFT JOIN bans ON bans.userid = post.userid AND bans.threadid=post.threadid AND active=1 


is causing an SQL error whenever trying to read a thread.

This is the error:

PHP Code:

Database error in vBulletin 2.3.0:

Invalid SQL: 
SELECT
thread.postuserid AS puserid,bans.active AS active,post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter

FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid

LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,810719,812243,812549,812889,837671)
ORDER BY dateline 

mysql error: Unknown table 'thread' in field list

mysql error number: 1109

Date: Saturday 19th of April 2003 07:56:44 PM
Script: [url]http://www.pprune.org/forums/forums/showthread.php?s=&threadid=85068[/url] 


I have removed the code for the moment and users can read the forums. Now the 'Thread Ban this user' link is still there and it is possible to ban users using the link. What doesn't happen is the link changing to 'Unban' which means mods who don't have access to the CP can't unban a banned user.

Any suggestions would be helpful.

I did have a problem running the SQL Query. It was generating an error so I ran the query without line breaks and it ran successfully.
:disappointed: