Yeah I got it to work, but once I installed this it screwed a lot of things up. I went back to revert back to my old versions of the files, and accidentally deleted the ones that I had already hacked, so I just had the versions from before. I didn't feel like fixing it all at the time so I just renamed the ones that were left "member_aftericonhack.php" and so on. I'll have to wait till I feel like sitting down to a 2 hour hacking job again before I redo it lol. The other thing was that I found a few bugs. These could just be me, but here's what I got:
In announcement.php:
PHP Code:
Database error in vBulletin 2.2.9:
Invalid SQL:
SELECT
announcementid,startdate,enddate,announcement.title,pagetext,user.*,userfield.*
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
//start user icon hack
,iconavatar.iconavatarpath,NOT ISNULL(customiconavatar.iconavatardata) AS hascustomiconavatar,customiconavatar.dateline AS iconavatardateline
//end user icon hack
FROM announcement
LEFT JOIN user ON user.userid=announcement.userid
LEFT JOIN userfield ON userfield.userid=announcement.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid LEFT JOIN customavatar ON customavatar.userid=announcement.userid
//start user icon hack
LEFT JOIN iconavatar ON iconavatar.iconavatarid=user.iconavatarid LEFT JOIN customiconavatar ON customiconavatar.userid=announcement.userid
//end user icon hack
WHERE startdate<='1046592710' AND enddate>='1046592710' AND (announcement.forumid='20' OR announcement.forumid='19' OR announcement.forumid='-1') ORDER BY startdate DESC
mysql error: You have an error in your SQL syntax near '//start user icon hack
,iconavatar.iconavatarpath,NOT ISNULL(customiconavatar.i' at line 5
mysql error number: 1064
in showthread.php:
PHP Code:
Database error in vBulletin 2.2.9:
Invalid SQL:
SELECT
post.*,post.username AS postusername,post.userid AS userid,post.dateline AS dateline,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
//start user icon hack
//end user icon hack
,signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline
,signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline
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 avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
//start user icon hack
//end user icon hack
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,21309,21310,21312,21315,21317,21365,21367,21375,21377)
ORDER BY dateline
mysql error: You have an error in your SQL syntax near '//start user icon hack
//end user icon hack
,signature.signaturepath,NOT ISN' at line 6
mysql error number: 1064
and, in user.php:
PHP Code:
Database error in vBulletin Control Panel 2.2.9:
Invalid SQL: SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,
iconavatar.iconavatarpath,NOT ISNULL(customiconavatar.iconavatardata) AS hascustomiconavatar signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN iconavatar ON iconavatar.iconavatarid=user.iconavatarid
LEFT JOIN customiconavatar ON customiconavatar.userid=user.userid
LEFT JOIN signature ON signature.signatureid=user.signatureid
LEFT JOIN customsignature ON customsignature.userid=user.userid
WHERE user.userid=1
mysql error: You have an error in your SQL syntax near 'signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsi' at line 3
mysql error number: 1064
I think these might have been caused because I tried to use // tags to add the comments around each area of code I edited. I think I did it wrong and it messed up the line breaks or something.
Good times. lol
More Information