Version: 1.00, by Dark Jim
Developer Last Online: May 2007
Version: 2.3.x
Rating:
Released: 02-15-2003
Last Update: Never
Installs: 16
No support by the author.
For this hack you need the following other hacks: Store and User Icons. It makes custom user icons buyable in the store just like custom avatars. This works on vBulletin 2.3.0.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Expect an update on the user icon hack soon which should remove all those extra queries. Just need a little help with that otherwise I would have done it sooner.
Does this have any changes since the updated icon hack? I'm going to install it now so I guess I'll find out, but if you see this please let me know. Thanks.
By the sound of it did you run the the querys or install file. I personally have not installed or download this hack but I'm just wondering because if querys are making calls to non objects usally means there was querys you had to run or an install script that you had to run but didn't so there is nothing near thus the error.
Dunno, thought it would be easier to seperate it. And 006, you did get the icon hack to work right without this addon? And if you get any errors, please post them here.
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
User Icons and Store integration Details »»
About Developer
Visit Web Site
No support by the author.
02-19-2003, 11:25 PM
Just need a little help with that otherwise I would have done it sooner.
Good times. lol 
