[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.

[miker_316]

Ah yes, I wasn't thinking clearly enough and forget the condition. The correct way to do it is to replace it with...

<if condition="$post['userawards']">Earned Awards:<br /><div>$post[userawards]</div></if>

I tested it out and this way works like you want. My apologies. I also edited my original reply so as not to confuse anyone.

[WoodiE]

miker 316 - You're awesome man, worked perfectly!

-Michael

[dssart]

I'm also ready to install this onto 3.01, anyone have any problems with 3.01?

Another dumb question...when VBulletin issues updates and I install them, what do I do to prevent the new updates from overwriting my installation of this hack? Do I need to backup the templates or something else?

Thanks AnimeWebby..you've really put alot of work into this and I appreciate it. If you have a PayPal account please PM me your email and I will send you a donation once I get this up and running.

[wcbryant]

I installed this some time ago, I have a site where the community drives 90% of the content, so I wanted something to acknowledge the people who contribute materially either with content, or by our semi-annual fundraisers.

Recently, I decided to also use this as a system to flag people who are on XBoxLive or PS2Online, to make it easy for them to set up games. I have a college football focused site, but with EA Sport's NCAA 2005 title being online for both consoles, there's a significant enough level of interest from the users that I'm going to support it on the site level.

My question is this... Has anyone figured out a way, could an add-on be developed, or might a future version include a way to generate user lists for specific medals?

I'd love to have the little Xbox logo/'award' link to a page that lists everyone with that award. Ditto for the PS2 logo. As is, I have it set up to display people's gamertags on the mouseover, but a centralized 'roster' of people with the specific award/logo would be even more helpful.

[turbidblue]

I tryed to install this via the hack tracking log, got to step three and this error occured...

********************

Invalid SQL: CREATE TABLE award (
awardid smallint(5) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
description varchar(250) NOT NULL default '',
icon_url varchar(250) NOT NULL default '',
PRIMARY KEY (awardid)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 7

mysql error number: 1064

****************

I am using vB 3.0.1

Any help?

Thanks

[Wolffman]

I'm using vB 3.0.1. When I ran the uninstall script, I got this error:

Invalid SQL: 
         SELECT 
         userfield.*, usertextfield.*, useraward.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
         IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
              language.phrasegroup_holiday AS phrasegroup_holiday,
              language.phrasegroup_global AS phrasegroup_global,
              language.options AS lang_options,
              language.languagecode AS lang_code,
              language.charset AS lang_charset,
              language.locale AS lang_locale,
              language.imagesoverride AS lang_imagesoverride,
              language.dateoverride AS lang_dateoverride,
              language.timeoverride AS lang_timeoverride,
              language.registereddateoverride AS lang_registereddateoverride,
              language.calformat1override AS lang_calformat1override,
              language.calformat2override AS lang_calformat2override,
              language.logdateoverride AS lang_logdateoverride,
              language.decimalsep AS lang_decimalsep,
              language.thousandsep AS lang_thousandsep
         FROM user AS user
         INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
         INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
         LEFT JOIN useraward AS useraward ON (useraward.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
         WHERE user.userid = 14
    
mysql error: Table 'afceyri_forums.useraward' doesn't exist

mysql error number: 1146

This is VERY urgent because my forums are down because of it. Any help is very greatly appreciated.

[Cheeko]

hmm.. i just installed this hack, seems ok except for some reason the awards arent showing up on the post bit...

[Polo]

Is this hack compatible with vb3.0.1?

[Oldfart]

This hack works fine on vb301 you just have to make sure you follow the instructions very carefully. Especially the file and template edits. I've installed it 3 or 4 times on different boards so far.

[Polo]

oh ok, i will install it then. Thank you.