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

[WebMasterAJ]

I have encountered a problem that I don't see in this thread yet...

Anyway, I can successfully add an award to the database. However, when I go to give a user an award, it doesn't save the information. It says "User [username] saved" or whatever when you are editing their profile... but it actually doesn't do anything to that table. In addition, there are NO errors that are encountered.

If I go to the table itself (useraward) and enter data manually, it will show that a user has an award when you view their profile...

Does anyone have any ideas as to why this is happening?

Thank you for your time and energy!

Sincerely,
Andrew

[WebMasterAJ]

Also, it appears that the awards aren't appearing on the showthread page; however, they are showing in announcements and showpost... LOL.

I've done the modifications for showthread and functions_showthread over and over again... and I just don't understand. I made sure that awards_bit is added as a template as well.

If it helps, the arcade hack has been installed on my board... but I thought I read somewhere that it doesn't matter as the new Arcade version changed their variables...

Any thoughts?

Once again, thank you for your time and energy...

Sincerely,
Andrew Tatum

[WebMasterAJ]

UPDATE:

When I gave myself the award via phpMyAdmin and uploaded the files... it actually showed the award for me (FinHeavenAJ). However, for any other member that doesn't have an award... they show up as a guest.

See the attachment to see exactly what I'm talking about. Once again, the awards are showing on the announcements and showpost pages... but just don't want to cooperate when it comes down to the showthread. :disappointed:

[M.C.]

mtha, your version in post 134 works perfect for me I just take some of your code some of original and it works fine now (i hope... )

[Flow Fusion]

Ok something in this script does not work with 3.1. Soon as I add it it shows all new members as guest. Does anyone see what it is? showthread.php

// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 22 ]
$posts = $DB_site->query("
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
" . iif($forum['allowicons'], 'icon.title as icontitle, icon.iconpath,') . "
" . iif($vboptions['avatarenabled'], 'avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,') . "
" . iif($vboptions['reputationenable'], 'level,') . "
" . iif(!$deljoin, '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
" . iif(!can_moderate(), $datastore['hidprofilecache']) . "
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)
" . iif($forum['allowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = post.iconid)") . "
" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)") .
iif($vboptions['reputationenable'], " LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)") . "
" . iif(!$deljoin, "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')") . "
LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE $postids
ORDER BY dateline $postorder

[Flow Fusion]

Originally Posted by WebMasterAJ

Also, it appears that the awards aren't appearing on the showthread page; however, they are showing in announcements and showpost... LOL.

I've done the modifications for showthread and functions_showthread over and over again... and I just don't understand. I made sure that awards_bit is added as a template as well.

Sincerely,
Andrew Tatum

It's that part that is messed up that I just posted.

[WebMasterAJ]

Originally Posted by Flow Fusion

Ok something in this script does not work with 3.1. Soon as I add it it shows all new members as guest. Does anyone see what it is? showthread.php

It seems that we're in the same boat

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

[Fugler]

Hello, I tried installing this hack and it all seemed as if it was going to work. I'm using vB 3.0.0 and when i got to step 6 of the HTL i got the message saying "Theres been a slight problem with the database", does anyone know of a way to fix this? If I changed the file edits back would it get rid of the slight error, or is my forum doomed?

[Willgames]

well i think everthing is working fo me, the only problem is when i try to access the admincp/award.php it tells me that "Could not find phrase 'no_awards_defined'." and I know that I made it...am I doing somehting wrong?