Major Additions - Yet Another Awards System 2.1.4

Yet Another Award System 2.1.4 ? by HacNho
Copyright (C) 2005 by HacNho, All rights reserved.

Hack Version: 2.1.4.070324
Compatible vB version: 3.6.x
Support: https://vborg.vbsupport.ru/showthread.php?t=142487

for vBulletin 3.5.x:
https://vborg.vbsupport.ru/showthread.php?t=94836
For vBulletin 3.0.x, please check the other version:
https://vborg.vbsupport.ru/showthread.php?t=78934

DESCRIPTION:
This is a Medals/Awards system. Admin can give members awards, and award icons will be displayed in member's profile, posts, as well as in a award list.

FEATURES:
In AdminCP
- Can Create/Edit/Delete/Reorder categories/sub-categories in ACP (with category name and description)
- Can Create/Edit/Delete awards in ACP (with Award Name, Description, Icon URL, Image URL)
- Can Move one (or all) award(s) from one category to another
- Can set some awards un-classified (not displayed for public)
- Can re-order awards in awards showcase
+ Issue awards to members, based on username or userid, with Issue Reason
+ Remove awards from members
- [1.2] Options to set number of awards displayed in postbit
- [1.2] Options to turn on/off showing award icon, images, award requests in awards list, awards icons in memberlist
- [2.1.3] Notify awarded user by PM/email
- [2.1.4] Option to turn on/off Award System in ModCP

In ModCP
+ Issue awards to members, based on username or userid, with Issue Reason
+ Remove awards from members

Front page
- Display awards list in with: Award Name, Description, Icon, Image, and Members who get each award.
- Display awards showcase in profile, with Award information, Issue time and reason
- Display award icons in postbit (showthread, showpost, announcement, private)
[1.2] Display limit awards in postbit, with total awards, and a link to awards showcase in member profiles.
[1.2] Award request, link to a form sending to email/PM/new thead or post (based on Dr Erwin Loh's Form hack)
[1.2] Display award on Memberlist page (by trulylowcarb)

CHANGES/MODIFICATION:
- Tables to add: 3 (award, award_user, award_cat)
- Files to add: 4 (/awards.php, /award_request.php, /admincp/award.php, /admincp/award_cat.php)
- Files to edit: 8 (/admincp/index.php, member.php, showthread.php, showpost.php, announcement.php, private.php, memberlist.php, /include/functions_online.php)
- Templates to edit: 5 (MEMBERINFO, postbit, postbit_legacy, memberlist, memberlist_resultsbit )

DIFFICULTY:
Easy
Time: about 5 minutes
Installer is included (1 product XML)


CREDIT:
Idea has been carried on by many people, here are some:
- Lesane for original Award hack for vB2, eventhough I've never use his hack
- AnimeWebby for Awards/ Medals/ Cards Hack [vB3], which I write new code based on his.
- Mac ycl6 for phpBB Medal System for phpBB forum
- Dr Erwin Loh for FORM TO THREAD/ FORUM/ PM/ EMAIL hack
- and all others for supports and ideas

[KristerSwe]

Hello. i will upload a PSD with many award medals i did for another portal

I will do it as soon i get home Cheers

[UncoderMom]

Thank you! Ive been waiting for this!!

[KristerSwe]

Hello all

Sharing my PSD here for you to play with. the psd file is sliced so if you make changes
you can easy "save optimized as" and they are splitted and named .....

Hope you guys liked them enjoy ...

Regards Krister

[Lionel]

@krister. That medals zip is corrupted, please reupload

[ZomgStuff]

Thanks!

[mtha]

Krister,

Can I provide your award file with the package?

ps. do you have a bigger version by any chance?

[weedheaven]

Originally Posted by mtha

Krister,

Can I provide your award file with the package?

That would be great, as i aint smart with psd's

[KristerSwe]

Originally Posted by mtha

Krister,

Can I provide your award file with the package?

ps. do you have a bigger version by any chance?

Yes feel free to include it to the package. and a little credit

Yes sure i can . i will upload the pics itself also. they are transparent
and should work on all skins. give me little time only

Thanks for like them ..

[KristerSwe]

Originally Posted by Lionel

@krister. That medals zip is corrupted, please reupload

Works great for me on 3 computers. i used Winrar 3.6 when i zipped them
can be found here. www.rarsoft.com

Sorry for the extra work

[Lionel]

I've just installed and I got this from showthread

PHP Code:

SELECT a.*, au.*, post.userid, post.postid 
FROM new_post AS post
INNER JOIN new_award_user AS au ON (au.userid=post.userid)
INNER JOIN new_award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,61944)

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

MySQL Error  : Unknown column 'au.award_id' in 'on clause'
Error Number : 1054