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

[maytrix]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~
| Step 6: Finishing up!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~

==>You need to 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.

==>Don't forget to upload award.php to your admincp directory and awards.php to your root directory as well as any modified files to their appropriate directories.

[Flow Fusion]

Ok I did it same error message on the same line 679

Matter of fact I fixed everything...help meeeeeeee

lol

[Flow Fusion]

Parse error: parse error in /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php on line 679

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php:679) in /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions.php on line 2753

[Flow Fusion]

$url = str_replace('&', '&', $url); // prevent possible oddity
header("Location: $url");
unset($shutdownqueries['pmpopup']);

[Flow Fusion]

Unable to add cookies, header already sent.
File: /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions.php
Line: 3695

Now I'm getting this error message after I removed the spaces

[Flow Fusion]

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,

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

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN useraward AS useraward ON(useraward.userid = user.userid)
)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,3861,3863,3866,3870,3873,3895,3896,3910)
ORDER BY dateline

mysql error: You have an error in your SQL syntax near ')
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS a' at line 19

mysql error number: 1064

Date: Wednesday 10th of March 2004 10:57:54 AM
Script: http://flowfusion.biz/forum/showthread.php?t=748
Referer: http://flowfusion.biz/forum/forumdisplay.php?f=2


Back to where I started

[Alzeimer]

I can?t find

Find in File /showpost.php

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

where paste this?

// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 20 ] LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid) LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid) // [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 20 ]

Thanks

[Flow Fusion]

Parse error: parse error in /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php on line 680

Fatal error: Call to undefined function: construct_postbit() in /hsphere/local/home/mojoblac/flowfusion.biz/forum/private.php on line 1331

When I click on any private messages. This is the only hack I really want please someone help me. Or at lease tell me how to revert my board back to the way it was.

[Cyricx]

Anime:

If I remember correctly, it was $awardsbit and $award_bit ...

It was a headache having to go through the code trying to figure out what was not working...

Shaz

[InfiniteWebby]

@Flow Fusion: As far as I can tell you have a different version or applied the code changes in the wrong place. There shouldn't be any code changes on line 679 or around there in v2. Send me your functions_showthread.php via pm and I will have a look.

@Alzeimer: Sorry, should be find:

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid) 


@Cyricx: You said you had trouble finding templates to edit. The names you just gave me are varibales hence the $ sign and if you meant you needed to find awardsbit and award_bit then you needed to add them not edit them.