Yet Another Awards System [1.2.1]

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

Hack Version: 1.2.1.050818
Compatible vB version: 3.0.8. It should work with all vB 3.0.x versions.
Support: https://vborg.vbsupport.ru/showthread.php?t=78934


For vBulletin 3.5.0, please check the other version:
https://vborg.vbsupport.ru/showthread.php?t=94836


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 ACP
- 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

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 add: 9 ('AWARDS', 'awards_awardbit','awards_awardusers_bit','awards_ bit','awards_userawards_bit','awards_category','aw ards_categorybit', 'awards_request_form', 'awards_request_formanswers')
- Templates to edit: 5 (MEMBERINFO, postbit, postbit_legacy, memberlist, memberlist_resultsbit )
- Phrases to add: 49

DIFFICULTY:
Easy-medium
Time: about 5-10 minutes
Installer is included

HISTORY:
For detail, please click here
2005.08.18: Version 1.2.1
2005.04.14: Version 1.2.02005.04.03: Version 1.1
2005.03.29: Version 1.0.1b
2005.03.28: Version 1.0.1
2005.03.28: Initial release

FUTURE PLAN:
- Allow comments on user's award (by Arial)
- PM/Email user when he/she get an award.
- Allow voting on user's award (by Arial)

ADD ONs


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


IMPORTANT:
- BACKUP modified files and templates before making changes.
- Backup database is recommended.
- This hack is NOT compatible with AnimeWebby's Awards/Medals/CardsHack [vB3], you need to UNINSTALL his hack, before installing this one.

INSTALLATION:
Read HERE: https://vborg.vbsupport.ru/showthrea...316#post632316

UNINSTALL:
Read HERE: https://vborg.vbsupport.ru/showthrea...316#post632316

MANUAL:
Included in zip file

SCREENSHOT:
https://vborg.vbsupport.ru/showpost.php?p=632316

DEMO:
http://www.global-army.com/forum/awards.php
http://www.global-army.com/forum/sho...=9253#post9253
http://www.global-army.com/forum/member.php?u=22#award
There's some custom modification on this site, but you have the idea.

DONATIONS:
YAAS is free, but a donation of any amount is much appreciated.


SERVICE:
Installation service is available upon request

[TTG]

Very useful hack

All went well with the install .. added new awards to test the hack and when award was issued received this database error :-

Database error in vBulletin 3.0.6:

Invalid SQL: 
			SELECT user.username,userfield.field10,userfield.field11,userfield.field12,userfield.field13,userfield.field14
		FROM user, userfield
		WHERE (user.userid=1) and (userfield.userid=1)
		
mysql error: Unknown column 'userfield.field10' in 'field list'

mysql error number: 1054

Date: Monday 28th of March 2005 05:13:22 PM
Script: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=awardusers&award_id=1
Referer: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=manage
Username: The Tech Guy
IP Address: 82.44.23.235

I ran the sql updates included in the install file and tried several different user ID's !?

[GamerzWorld]

I want to wait before i uninstall current one to see a demo. Looking good tho

[mtha]

Originally Posted by TTG

Very useful hack

All went well with the install .. added new awards to test the hack and when award was issued received this database error :-

Database error in vBulletin 3.0.6:

Invalid SQL: 
			SELECT user.username,userfield.field10,userfield.field11,userfield.field12,userfield.field13,userfield.field14
		FROM user, userfield
		WHERE (user.userid=1) and (userfield.userid=1)
		
mysql error: Unknown column 'userfield.field10' in 'field list'

mysql error number: 1054

Date: Monday 28th of March 2005 05:13:22 PM
Script: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=awardusers&award_id=1
Referer: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=manage
Username: The Tech Guy
IP Address: 82.44.23.235

I ran the sql updates included in the install file and tried several different user ID's !?

Please download and replace the award.php in your admincp folder with the award.php file attached in the first post.

It was 4am at that time, I forgot to take out those fields

[Blackbeard]

Does anyone know where there are award icons on the net that can be used with this

[mtha]

Originally Posted by Blackbeard

Does anyone know where there are award icons on the net that can be used with this

There are few icons in the zip file. The Icons (c) belong to phpBB Medal hack and some other place online

[TTG]

Originally Posted by mtha

Please download and replace the award.php in your admincp folder with the award.php file attached in the first post.

It was 4am at that time, I forgot to take out those fields

That solved the problems .. thanks for the quick update.

All running with no problems on 3.0.6

[TTG]

Originally Posted by lsmba

I'm not sure what is meant by..."cannot be display awards in postbits"

What effect does this have on the functionality of the hack? Can someone enlighten the less tech-savvy...

Thanks all,

lsmba

Awards when rewarded at the moment can only be viewed in members profile. Next upgrade will hopefully allow rewards to be shown in postbit display for rewarded members.

[yinyang]

omg, this would be the best!

i can't wait for the post-bit code and will definitely install then.

[Jon@Refresh]

Do you know what the difference between this and AnimeWebby's hack is?

[mtha]

Originally Posted by lsmba

I'm not sure what is meant by..."cannot be display awards in postbits"

What effect does this have on the functionality of the hack? Can someone enlighten the less tech-savvy...

Just that I want to release the first version ASAP, so I just thru something out for people to discuss.
It is not "cannot", it's just not yet implemented. I am working on postbits, update will be available soon.

Do you know what the difference between this and AnimeWebby's hack is?

Yes I do





- Database structure is different
- Award managements is different (read description in first post)
- Support is different (I am currently supporting the hack)
- and ... you can add to the list