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

[rex_b]

Ugh someone plz make this available for the MODCP.. I've been trying but can't make it where the MODCP can save the changes..

[rex_b]

I know someone knows what to do! Step up, pweeaasseee?

[snake-boy]

Hi,

I have been looking for something like this FOREVER, please please assist me in getting it working.

Info requested:

- HTL or Standalone installer. - Standalone Installer
- Version of vB you are running. - V3.0.3
- File where error is encountered. - During install process (awards_install.php)
- Exact error or description of error. - See below:

PHP Code:

======================================
Database error in vBulletin 3.0.3:

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,
            level,
            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 reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
        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,10)
        ORDER BY dateline 
    
mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109

Date: Friday 19th of November 2004 10:50:38 AM
Script: http://<path_to_my_forums>/showthread.php?t=8
Referer: 
Username: <myusername>
IP Address: <my_ip_address>
=========================== 


I have checked to see that the table "announcement" actually exists. It does. I also tried to fix broken user profiles from admincp just in case, but no go. Everything "seems" ok until I hut a showthread.php

Please advise me how to fix this, I really (REALLY) want to install this hack.

I await your reply. Many thanks in advance to anyone who may advise?

-snake

[paulmjno]

Amazing hack! But... very tiring to install! lol. The first hack I've installed thus far with no problems.

[TosaInu]

Originally Posted by paulmjno

Amazing hack! But... very tiring to install! lol. The first hack I've installed thus far with no problems.

vb 3.03, works without a flaw. Nice hack AnimeWebby.

[tomcromp]

Well, it simply won't work for me.

I installed following all the steps, but I still get an error:

Unable to add cookies, header already sent.
File: /home2/tom/public_html/forum/includes/functions_showthread.php
Line: 704

It's really bothering me as this is my first hack install and it won't work.

[trackpads]

Great Hack!

2 Additions if you ever get time.

1. Can you leave the small postbit but have the Awards display a large version of the award? Or both? I would like ot have full metals in the Awards page but only the tiny ribbons on the postbit.

2. Any way yo make them scroll in the postbit? The latest IPBArcade hack does this and it would be a great addon for this hack.

Agian, excellent work and thanks!!!!!

[dssart]

Finally installed this hack..works great with 3.0.3..I'd like to see an update with some of the great suggestions posted here. I would definitely pay for the next one!

BTW, for all those having trouble with this script...make sure every bit of code is inserted correctly. I had a ");" in the wrong place and I couldn't view my members.php!

[Eagle Creek]

Originally Posted by dssart

Finally installed this hack..works great with 3.0.3..I'd like to see an update with some of the great suggestions posted here. I would definitely pay for the next one!

BTW, for all those having trouble with this script...make sure every bit of code is inserted correctly. I had a ");" in the wrong place and I couldn't view my members.php!

I wouldn't but still it is a great script!

[Edric]

Originally Posted by Flow Fusion

Ok this hack does not work in 3.1 unless you do this.

You need to use the 3.0 showthread.php, and the 3.0 includes/adminfunctions_showthread.php

It won't work on the 3.1 php files. I don't know why but that's the deal.

I have the shoutbox, who was online, awards, arcade, and store hack on my board.

And this is the only way I see getting this file to work.

I am using 3.0.1, where can I get the 3.0.0 files?

I keep on getting errors with the showthread files, obviously using the 3.0.1 files.