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

[Sadie Frost]

I installed this with no problem on RC3, but installing on RC4 I get no awards showing anywhere and can't figure out why. I doublechecked all the code additions and I don't think I missed any.

Edit: for some reason the award template wasn't added - that fixed it

[blubber12]

Thanks that was the fix. Installed and working on rc2. Thanks again.

[Sadie Frost]

When I try to read and announcement, I get this error at the top of the page:

Warning: Invalid argument supplied for foreach() in /path/to/forums/includes/functions_showthread.php on line 792

which is "foreach($awards AS $useraward)"

Any ideas?

[agbates]

I think AnimeWebby is doing a great job..and thanks go to Lesane for his original idea. I am also going to wait until Gold before I install this, but one thing is for sure..I am going to install it! It's a great idea that really should have been included into VB.

[maurier]

I have run SQL-query using phpmyadmin getting error: my site vbRc4 help me please !

CREATE TABLE " . TABLE_PREFIX . "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 said:


You have an error in your SQL syntax near '" . TABLE_PREFIX . "award (
awardid smallint(5) unsigned NOT NULL auto_incre' at line 1

CREATE TABLE " . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
PRIMARY KEY (userid)
) TYPE=MyISAM;

MySQL said:


You have an error in your SQL syntax near '" . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
' at line 1

[InfiniteWebby]

@sadie: it looks like you may have missed out a step. you have to add

PHP Code:

global $awards; 


after

PHP Code:

global $vboptions, $stylevar, $vbphrase, $DB_site, $datastore, $_USEROPTIONS, $style, $show, $usergroupcache; 


in your /includes/functions_showthread.php file

@maruier: you are meant to replace " . TABLE_PREFIX . "with your table prefix before you run those queries.

[kcradio]

I am still getting this error:

SQL-query :

CREATE TABLE " . TABLE_PREFIX . "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 said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "award( awardid smallint( 5 ) unsigned NOT

Can anyone tell me what I am doing wrong on this?

[kcradio]

nevermind, if I look up a thread I can see the answer, sorry...

[InfiniteWebby]

if you are getting an error when you are trying to view announcements then.....

in /includes/functions_showthread.php
instead of finding

PHP Code:

    $show['messageicon'] = iif($post['iconpath'], true, false); 


find:

PHP Code:

            $show['reputationlink'] = iif($vboptions['reputationenable'] AND $bbuserinfo['userid'] AND $post['userid'] AND !($usergroupcache["$post[usergroupid]"]['genericoptions'] & ISBANNEDGROUP), true, false); 


then add above it:

PHP Code:

            // AWARDS IN POSTBIT
            foreach($awards AS $useraward)
            {
                $userawardid = "award$useraward[awardid]";
                if (!empty($post[$userawardid]))
                {
                    $userawardid_desc = $userawardid."_desc";
                    if ($post[$userawardid_desc] != '')
                    {
                        $useraward[description] = $post[$userawardid_desc];
                    }
                    eval('$awardsbit .= "' . fetch_template('award') . '";');
                }
            }
            // END AWARDS IN POSTBIT 


I will update all the files soon with all the current bug fixes plus instructions for versions less than RC 4. Sorry for the inconvinience

[Sadie Frost]

Works perfectly now - thanks!