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

[InfiniteWebby]

@Barhopper: Did you have this hack installed previously if so you may have the same piece of code twice in your /includes/functions_showthread.php if not check that you dont have $post['userawards'] in your postbit_legacy twice. If you want send me your /includes/functions_showthread.php and your postbit_legacy via a pm and I'll see what I can do.

@WebMasterAJ: Check your pm

@ethics: I need to see some sort of mysql dump of your awards table but I have no idea what could be wrong with it, what installer did you use? and what vb version did you use?

@SmasherMaster: You are having the same problems as WebmasterAJ I will forward the pm i sent him to you.

[ethics]

@ethics: I need to see some sort of mysql dump of your awards table but
I have no idea what could be wrong with it, what installer did you use?
and what vb version did you use?

Vb 3.0.1 and used the manual installer (not HTL).

[tHe Rk]

Originally Posted by SmasherMaster

getting this error wehn i try to view a thread:

Warning: Invalid argument supplied for foreach() in /home/smasher1/public_html/forums/includes/functions_showthread.php on line 799

and in my thread, all posts say n/a

help?

I got the same thing! HELP HELP HELP!

As follows:

Warning: Invalid argument supplied for foreach() in /home/therk/public_html/forum/includes/functions_showthread.php on line 731

[InfiniteWebby]

<span class="highlight">Sorry about this guys but isn't it always the small things that ++++ up a script? Anyway I updated the first post with instructions on how to fix the foreach() errors as well as instructions which alot of you missed on how to fix the N/A post count.</span>

[tHe Rk]

Originally Posted by AnimeWebby

Sorry about this guys but isn't it always the small things that ++++ up a script? Anyway I updated the first post with instructions on how to fix the foreach() errors as well as instructions which alot of you missed on how to fix the N/A post count.

Thanks Anime! Will go check out the first post for the fix!

[tHe Rk]

Originally Posted by AnimeWebby

Awards/ Medals/ Cards Hack [vB3]
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; 


Worked like a charm! Thanks a million!

[SmasherMaster]

Wonderful, that worked. Thanks alot, animewebby!

[tHe Rk]

I had to reinstall my forums, and I have mutliple other hacks already in use and I get this error when I try to use the installer: (This is before I get to any template edits or anything like that, and ideas?)

Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT user.userid
FROM user AS user
LEFT JOIN useraward AS useraward USING(userid)
WHERE useraward.userid IS NULL

mysql error: Table 'therk_xgplanet.useraward' doesn't exist

mysql error number: 1146

Date: Thursday 27th of May 2004 05:21:00 PM

[Mystictrunks03]

i got that same error like this

Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT user.userid
FROM user AS user
LEFT JOIN useraward AS useraward USING(userid)
WHERE useraward.userid IS NULL

mysql error: Table 'dbgtx2_vbulletin.useraward' doesn't exist

mysql error number: 1146

Date: Thursday 27th of May 2004 06:54:33 PM
Script: http://www.dbgtx2.com/vb/admincp/awa...step=doqueries
Referer:

[InfiniteWebby]

those imply that you already have the file edits installed, ill look into it in a min and get back to you.