Nope. I still get an error...
Code:
Database error in vBulletin 2.2.9:
Invalid SQL:
SELECT
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
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
,signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline
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 avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN signature ON signature.signatureid=user.signatureid
LEFT JOIN customsignature ON customsignature.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,394,395,429)
ORDER BY dateline
mysql error: You have an error in your SQL syntax near 'LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.use' at line 8
mysql error number: 1064
Date: Friday 17th of January 2003 07:16:14 PM
Script: http://www.eo-gaming.com/forum/forum...hp?threadid=78
Referer: http://www.eo-gaming.com/forum/forum....php?forumid=4