[HTL] & [TXT] Awards/Medals/Cards Hack [vB3]

Awards/ Medals/ Cards Hack [vB3]
By: AnimeWebby
Idea by: Lesane
Updated: 28nd May 2004 - Installer not table prefix friendly.

What this hack does:
This hack allows you to add awards, medals or cards to your vbulletin and assign these to members who you think deserve them.
These graphics will then show up in their member profile and/or their postbits depending on where you choose to add this hack.

New in v2
- Extra page showing all awards available as well as all the users who have earned an award.
- Support for full urls and relative ones for award icons.
- Support for awards on showpost and announcement

Other Stuff:
Although I give credit to Lesane for the idea this hack is totally recoded to be less server intensive and also uses a whole lot less queries. Therefor I do not consider this a 'port'.

Installation:
Download the appropriate .Zip file and follow the instructions in the readme file.

Upgrading:
So far there are no ways to upgrade this hack, if you have an old copy installed then you need to uninstall and reinstall from scratch.

Coming Soon:
- Awards added to the search and memberlists.
- Added functions to the addition of awards as well as cron functions to assign awards automatically to those members with 'X' posts, registered 'X' days etc...
- Option to show award name rather than graphic.
- Option to turn awards OFF & ON in postbit and memberinfo
- Request award on awards page (at Cyricx' request)
(not necessarily in that order)

Make sure you backup your files and database first! This hack has been tested on vB RC1 and RC4 only!

Please click the install button

If you experience any errors, problems or the hack doesn't seem to be functioning correctly then send me a pm with the following info:
- HTL or Standalone installer.
- Version of vB you are running.
- File where error is encountered.
- Exact error or description of error.

Views so far:
[NORMAL]AwardsMedalsCardsv2.1.zip (12.7 KB, 69 views)
[HTL]AwardsMedalsCardsv2.1.zip (12.8 KB, 57 views)
[TXT]AwardsMedalsCardsv2.zip (8.5 KB, 278 views)
[HTL]AwardsMedalsCardsv2.zip (10.2 KB, 203 views)

If you installed this hack before 23rd May and are getting foreach errors in your showthread then follow the step below:

In /includes/functions_showthread.php find:

PHP Code:

    // sorts through all the stuff to return the postbit template 


below that add:

PHP Code:

    // user awards
    global $userawards; 


If in your showthread.php member post counts show N/A, they have no profile link or their user title is guest you MUST run 'Fix broken user profiles' in the update counters part of the admincp. This is found under the nav bar 'Import & Maintenance' > 'Update Counters' > 'Fix broken user profiles'. This will add the awards for all the users currently in your database and prevent showing incorrent member info.

[dniMTheory]

AHhh, yes, thanks for the help. I got it working, arcade hack also. Someone needs to update the first post with the changes for gold if it hasnt been done already.

But was does "request award" mean or supposed to do on the awards page?

[Sean S]

Database error in vBulletin 3.0.0:

Invalid SQL: 
		SELECT
			post.*, post.username AS postusername, post.ipaddress AS ip,
			user.*, userfield.*, usertextfield.*, useraward.*,
			icon.title as icontitle, icon.iconpath,
			avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
			
			NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason,
			post_parsed.pagetext_html, post_parsed.hasimages,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
			
		FROM post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
		LEFT JOIN useraward AS useraward ON(useraward.userid = user.userid)
		LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
		WHERE post.postid IN (0,21677,21698,21811)
		ORDER BY dateline 
	
mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109

does anyone know why I get that error message? yes I have done everything and read all the directions. I even went over instructions 3 times but still something gives error. I can see the forum home, but everytime i try to view each thread or something else, I get that error. Also the admin panel seems to work fine, but the rest is just messed up.

[dniMTheory]

Use these instructions, instead of the ones in the first post

https://vborg.vbsupport.ru/showpost....&postcount=134

[Flow Fusion]

ANyone have an idea why I get this error message in my email every so often?

IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline
,level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted,
post_parsed.pagetext_html, post_parsed.hasimages

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN useraward AS useraward ON(useraward.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid = 856

mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109

Date: Thursday 15th of April 2004 12:11:04 PM
Script: http://giftedsouls.com/gs/showpost.p...56&postcount=2
Referer:

[BarHopper]

My 7th attept has failed. I really wnat this, i think i'm gonna pay for someone to install it for me. But as a last resort, i;ve attatched my mof#dified files, could someone have a look to whether i've doen anything wrong? I used HTL, but i got Parse errors and database errors all over the place.

The /nw in teh attacthment, is the backup files.

[dniMTheory]

last I checcked, the first post wasnt updated for gold...atleast it wasnt when I downloaded it.

When you get to the file and template edits use the mods from this post
https://vborg.vbsupport.ru/showpost....&postcount=134

[BarHopper]

Right, i'll have another go if i get time. I think my problems were in member.php, announcement.php and showpost.php. I think thats all.

[JamesFrost]

Originally Posted by AnimeWebby

I am extremely sorry that I haven't been able to support this hack lately, I got a new computer about a week ago and am only know gettig it setup just as it is. Thanks to FlowFusion and mtha for all your help.

I will be re-doing the instructions and work out any bugs when I get my localhost vBulletin Gold version setup so please be patient.

Once again SORRY

AnimeWebby - Any update on the new install / instructions? Anyone running this on vb3.01?

[trinitym]

Originally Posted by JamesFrost

Anyone running this on vb3.01?

I'm currently upgrading/revamping [on a non-livesite location] and after two nights of caffiene and much hunting through this thread, I have this working on 3.0.1. The awards appear in the postbits and profiles where they should and I had no issues adding, editing and deleting awards, nor adding/removing them from users.

The only issues I seem to be having is it's saying it can't find some of the phrases [only through the admincp], like "deleted_award_successfully" AND when I went to go ahead and add them manually [I did this HTL style], it said the phrases already did exist.

Not too big a deal because the functionality seems to be working fine, though it does grate against my weird OCD-perfectionist-ness.

<edit>God, I'm so rude. I forgot to say: An otherwise excellent hack, this will be extremely useful to me. *clicks install*</edit>

[JamesFrost]

Originally Posted by trinitym

I'm currently upgrading/revamping [on a non-livesite location] and after two nights of caffiene and much hunting through this thread, I have this working on 3.0.1. The awards appear in the postbits and profiles where they should and I had no issues adding, editing and deleting awards, nor adding/removing them from users.

The only issues I seem to be having is it's saying it can't find some of the phrases [only through the admincp], like "deleted_award_successfully" AND when I went to go ahead and add them manually [I did this HTL style], it said the phrases already did exist.

Not too big a deal because the functionality seems to be working fine, though it does grate against my weird OCD-perfectionist-ness.

<edit>God, I'm so rude. I forgot to say: An otherwise excellent hack, this will be extremely useful to me. *clicks install*</edit>

I've followed the alternative instructions in this thread and I don't get any awards displaying under 3.01 (I had them working on 3 RC4). I can setup the awards in AdminCP and I have made the correct changes to the templates.

I have fixed broken user profiles again and tried removing and re-adding awards.

No error message, just no awards.

If anyone could shed any light, I'd be most grateful (I know I've not given a lot to go on here!)