User Icons and Store integration

[Dark Jim]

For this hack you need the following other hacks: Store (http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=293) and User Icons (http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=912). It makes custom user icons buyable in the store just like custom avatars. This works on vBulletin 2.3.0.

[Vivi Ornitier]

nice nice

[Dark Jim]

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.

[007]

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.

[Dark Jim]

Nope, this does not need updating. :)

[007]

K this screwed up a lot of things in member.php... are you sure this works? Weird. A bunch of calls for non objects all over the place.

[Serge]

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.

[Erwin]

Why not put this in with your User Icon hack? :) Why a separate thread?

[Dark Jim]

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.

[007]

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:Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT
announcementid,startdate,enddate,announcement.titl e,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: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,attach ment.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: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 :)

[007]

Has anybody else installed this and got it working? (The store integration I mean). I am hoping to reinstall the icon hack and the store integration icon hack soon. Just want to know if the store integration works yet, because if not, the icon hack takes about 2 hours to install and I don't want to do it until the integration works. :)

[sabret00the]

just installed this, will be able to tell you if it works soon ;)

[sabret00the]

works perfectly, i'm loving it

[007]

Cool, I must have just messed something up when I first did it. I'll do it again sometime this week hopefully. :)