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

[eXtremeTim]

Try repairing the table and see what happens.

[lasto]

tried it m8

no luck - was first think i thought of - ive even dropped the 2 tables and re-added em

could anything else be causing that error ??

i really stuck here at moment as i can view main page of my test board but i get the error when i got to view any post

Im on vb3 rc4 if that helps

I did have some trouble with showthread.php
what it told me to find i could`nt

==>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)

in mine i never had the announcement.userid on what i was meant to find - it simpley was`nt in my files so i just replaced what was there

[lasto]

ive put me old copy of showthread back and i can now read posts etc so obviously the problem lies in showthread so how can i edit that if what im meant to find simply aint there ??

someone must have this installed on v3 rc4 - cause it does look like a good hack as the admin part works for adding em and the awards.php page displays em fine but i just cant view me board cause i cant find what im meant to replace

[eXtremeTim]

I will look at this latter tonight like I said if I have time.

[lasto]

im a genuis LOL

it works fine and every one appears in postbit

all i did was this in showthread was replace every occurance of where

==>Find:

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

with this

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

u notice on the first line i did`nt add announcement - i replaced it with user (userid=user.userid) and it works fine

I aint sure what damage i may of doen to the rest of the board though by ommititing announcements out of it

[Flow Fusion]

I added what you said but i still don't get the images to load anywhere but that page I posted. What did you do to your post bit? I recall in the other one 2.0 it was something about showing the image URL

[Flow Fusion]

oh yeah did you get the images to show in the admincp?

[lasto]

lo flow

the images dont show in the admin cp just the name and then u tick what pic u want to show

as for postbit all i added was what was in the file - i had no problems there at all.

Its showthread thats the problem m8

find all occurances and swap em for the 2 lines i posted above as this is the only way mine worked and now i have no probs at all (opps touch wood i should`nt say that)

wot version are u on m8 ?

[Flow Fusion]

damn I might just start from scrach. I don't see the images at all in the post bit

[lasto]

Originally Posted by 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?

u dont need to start from scratch

just replace

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid) - (which is`nt even their mind you as announcement.userid aint there so search upto that bit and replace thelot )

and replace with

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

replace both in showthread as there is 2 occurances.


also images do appear in admin cp in awards manager - they dont appear when u bring an account up to give em to that user so hacks works fine