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

[Flow Fusion]

Is it anyway possible to allow mods to give out awards? Just to make my life easier?

Or a way to schedule a way to have "broken user profile" fixed?

[7aurelius]

installed with out a problem good ? flow

[rex_b]

I have a problem..

Everything seems to work fine except when I try to view my member's public profile. So put back my original member.php and still have errors. help!!

Invalid SQL: 
		SELECT 
		userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
		IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, level, avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline, " AS profilepic, customprofilepic.dateline AS profilepicdateline
		FROM vb3user AS user
		INNER JOIN vb3userfield AS userfield ON (user.userid = userfield.userid)
		INNER JOIN vb3usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
		LEFT JOIN vb3useraward AS useraward ON (useraward.userid = user.userid) LEFT JOIN  vb3reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid) LEFT JOIN vb3avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb3customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb3customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) 
		WHERE user.userid = 58

	
mysql error: 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 '" AS profilepic, customprofilepic.dateline AS profilepicdatelin

mysql error number: 1064

Date: Wednesday 08th of September 2004 03:56:16 PM
Script: http://www.***/forum/member.php?userid=58
Referer: http://www.***/forum/showthread.php?p=26959#post26959

[rex_b]

Well I narrowed down the problem to the functions.php file. I'm really not worried about this hack being shown in the member profile but rather just in the post bit..

So should I worry?

[apokphp]

that's exactly what I have AnimeWebby...still no dice. Would you mind taking a look at the file yourself to see if something else is conflicting with it?

[apokphp]

bump

need help on this please.

I have confirmed that it is NOT the user.php file. I have 2 sites. It works on 1, but not the other. So I took the user.php from the 1 that it did work on, and copied it to the site having troubles. Still, no change. It will not accept the change or selection of awards for a user.

[mfacer]

I've just tried to install this hack... I'm running 3.0.3 and followed the instructions to a tee..... I've reinstalled the original code twice now and continue to get the same error message....

Parse error: parse error in /home/recaf/domains/yu-gi-oh-online.co.uk/public_html/includes/functions.php on line 1890

Fatal error: Call to undefined function: is_browser() in /home/recaf/domains/yu-gi-oh-online.co.uk/public_html/global.php on line 59

any ideas where I've gone wrong?!! It's driving me mad!
I have no other hacks or anything installed - this has been coded from a fresh install....

[InfiniteWebby]

rex_b: I don't have any idea what has happened with your member profile page file... that is seriously messed up. If you want me to have a look contact me on any of my instant messenger services.

Apok: Try running this query in your admincp or phpmyadmin. If you still have troubles then contact me as above.

PHP Code:

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


Of course change " . TABLE_PREFIX . " to your vbulletin prefix

mfacer: I'll need to know what bit of code surrounds line 1890 and where this is happening. But there shouldn't be any code changes around that line to do with this hack.

[mfacer]

Originally Posted by AnimeWebby

mfacer: I'll need to know what bit of code surrounds line 1890 and where this is happening. But there shouldn't be any code changes around that line to do with this hack.

I pinned the problem down to Dreamweaver saving the file incorrectly. Maybe there are too many lines, I dont know - but when I made changes to the functions.php file then saved it to upload - I got errors. Even when I reverted the code back to its original state and saved in DW it came up with the same errors. I noticed this as it happened with another smaller hack I tried earlier.

I've used WordPad to edit functions.php and that worked perfectly. Off to try your hack now

[InfiniteWebby]

That's good to hear, keep me posted on the results