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

[SmasherMaster]

Oh great...database error...I can't seem to find out where this is coming from.

Database error in vBulletin 3.0.0:

Invalid SQL: 
		SELECT 
		userfield.*, // [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 10 ]
usertextfield.*, useraward.*, 
// [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 10 ] 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, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline
		FROM user AS user
		INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
		// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 11 ]
		INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
		LEFT JOIN useraward AS useraward ON (useraward.userid = user.userid) LEFT JOIN  reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) 
		WHERE user.userid = 55
	
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 '// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='Anim

mysql error number: 1064

Date: Friday 21st of May 2004 06:07:30 PM
Script: http://www.megareviews.com/forums/member.php?u=55
Referer: 
Username: Unregistered
IP Address: 65.54.164.101

someone help please

[y2krazy]

I really want to get this installed, preferrably via HTL, so what would I need to edit to get it working with 3.0.1 --- without having to go in and manually do what your(mtha) attachment says to do. I suppose I'll just have to wait until it's updated to work with 3.0.1.

-y2k-

[InfiniteWebby]

I just uploaded the new installers for both versions of the Awards/Medals/Cards hack. It should work fine with the arcade installed on any installation of vB3. If you encounter any troubles then send me a PM with the info stated in the first post.

Thanks alot.

Also if you love this hack then please join my forums and post at least once, we are desperate for activity ^_^. Oh yeah and click install.

[SmasherMaster]

Oh so the arcade was giving me hell is that it? GAH! I'll reinstall.

[BarHopper]

I'm having one problem. http://www.game-realms.net/vb/showth...id=3#post17580 Its doing the image twice. (the award image).

Why? And how can i resolve it?

[WebMasterAJ]

I receive the following errors:

The Header:

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

This is what appears where a thread is supposed to be:

Unable to add cookies, header already sent.
File: /home/fhco/public_html/boardvb2/includes/functions_showthread.php
Line: 724

I am on version 3.0.1

As the errors say, these errors happen as soon as I edit functions_showthread.php

Any ideas for this fix?

Thank you for your time and energy!

Sincerely,
Andrew Tatum

[ethics]

Getting the following errors when trying to enter the award admin panel:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT * FROM award AS award ORDER BY awardid ASC
mysql error: Unknown column 'awardid' in 'order clause'

mysql error number: 1054

Getting this in trying to get in to the member list:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT * FROM award AS award ORDER BY awardid ASC
mysql error: Unknown column 'awardid' in 'order clause'

mysql error number: 1054
=========

Not sure if the table creation was ok but didn't see any errors and see the tables as ok in the db admin.

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

[WebMasterAJ]

I can't wait for this hack to work on my boards... ALL of my members miss it!

BTW... SmasherMaster: It looks like we're having similar problems... are you able to view the awards in a member's profile?

[SmasherMaster]

I haven't added any awards yet, but I don't see any places that say "awards" in the member's profile.