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

Originally Posted by AnimeWebby

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

Ok I PMed you and I went back to the way my board was till you can get back to me.

[CHeeKY]

AnimeWebby just wanted to say thanks for all the support so far, ya doing well kid hang in there

I have a couple of things, working of a vb3rc2, have installed the hack and all seems ok apart from:

1. When I add a hack or modify I get a message telling me that the phrase "Saved named x saved succesfully" could not be found, I checked and its there for sure.

2. When I goto a user and click Yes to a medal and put a reason, I then click save, and it doesnt save, I go back to the user and its set to NO and viewing the users profile shows nothing. So basically its not saving the action. Any ideas?

Regards

[InfiniteWebby]

Originally Posted by CHeeKY

AnimeWebby just wanted to say thanks for all the support so far, ya doing well kid hang in there

I have a couple of things, working of a vb3rc2, have installed the hack and all seems ok apart from:

1. When I add a hack or modify I get a message telling me that the phrase "Saved named x saved succesfully" could not be found, I checked and its there for sure.

2. When I goto a user and click Yes to a medal and put a reason, I then click save, and it doesnt save, I go back to the user and its set to NO and viewing the users profile shows nothing. So basically its not saving the action. Any ideas?

Regards

1. do you mean when you try to add an award? if so make sure the phrase is in the control panel stop messages.

2. If you are using the htl version of the hack it might have something to do with the comments it places before and after any file edits. So just check out admincp/user.php and if you have any comments in between mysql then remove them. If not just make sure you applied all the changes to that file.

[CHeeKY]

Thanks m8, now I get a different error.

Database error in vBulletin 3.0.0 Release Candidate 2:

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,
level,
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 reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
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,2175,2213,2226,2710,2753,2824,2826,2827,2829,2832)
ORDER BY dateline 

mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109

It stems from the install code of showpost.php and showthread.php

in my vb RC2 showthread.php I have

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)

on your install script I have

>Find:

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

==>Replace With:

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

I dont have reference to the annoucement.userid...

Hope you can help

[CHeeKY]

ok update

I took out the annoucements and fixed the user.php and its all working great
Top marks for the hack m8

[Flow Fusion]

Ok in some of the files it says thing like edit "poll results" and add "poll result add award" or something. But I was wondering do you edit ALL of the poll results etc. Or just the first ones?

[Flow Fusion]

geez it's seems when I upload the "showthread.php" everything goes to hell. I don't know which one to edit. From the

In /showthread.php
-------------------------------

==>Find:

'pollresult'

==>Replace With:

'pollresult',
'awards_bit'

==>Find:

usertextfield.*,

==>Replace With:

usertextfield.*, useraward.*,

==>Find:

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

==>Replace With:

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

Their is 2 of each these. And on the LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

in my file it has
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

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

See how it has AS as oppose to ON?

Please help?

[Flow Fusion]

Any one?

[lasto]

not installed this m8 but if there is 2 here is what i would do

i would try it on the first one then save file (always backup orginal files first) and if it dont work then try it on the second one.

Its gotta be one of the two

[Flow Fusion]

Originally Posted by lasto

not installed this m8 but if there is 2 here is what i would do

i would try it on the first one then save file (always backup orginal files first) and if it dont work then try it on the second one.

Its gotta be one of the two

Hey funk it why not? LOL