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

[dssart]

Sounds like a great 1.0 release mtha, you're off to a terrific start. I'm going to wait to install until the release with the awards in the postbit also. Thanks for keeping this cool hack alive!

Also, if/when you do the postbit update..could you please include the update for us legacy postbit users?

Thaaankssss

[snowlion]

Very good hack , I like it

[mtha]

Here's the bad news.

The more function you want, the more editing you need to do, and there's one additional querry for each post showing in the thread.

well trying to minimize the queries. give me suggestion if you have any.

[mtha]

quick addon for postbit if you did install the hack, and want to TEST and give suggestions.

Additional modifications for NOW: DELETED -

This is for TESTING PURPOSE only.

........

deleted. New version is coming out.

[snowlion]

Originally Posted by mtha

quick addon for postbit if you did install the hack, and want to TEST and give suggestions.

Additional modifications for NOW:

Template to edit: 2 (postbit, postbit_legacy)
Files to edit: 3 (showthread.php, showpost.php, announcement.php)

I want to display in postbit templates , What should i do ?

[ChrisBaktis]

This is the Database error I get. Im running 3.0.7.

PHP Code:

Database error in vBulletin 3.0.7:

Invalid SQL: DROP TABLE IF EXISTS award;        
mysql error: You have an error in your SQL syntax near ';        ' at line 1

mysql error number: 1064

Date: Monday 28th of March 2005 10:43:21 PM
Script: http://rustysoaptraders.com/forums/admin/awards_install.php?step=doqueries
Referer: 


[dssart]

Mtha's first release of this hack was yesterday and it was more or less to test functionality. The first version didn't contain the option to display in the postbit and he posted a suggestion to get it to display but removed it because it looks like he is planning another update soon. We wait until he posts the update.

Originally Posted by snowlion

I want to display in postbit templates , What should i do ?

[mtha]

I am going to update a new version in says 30 minutes, on hold please!

PS. If you did install the TESTING Addon for postbit (POSTBIT_addon.txt) I posted before, please process to un-do that one. (just remove the changes in that instruction file). In the new release, I will not include how to un-do that one.

[mtha]

Version 1.0.1 released

New features:
- Display awards in postbit (showthread, showpost, announcement, private)



upgrade from 1.0.0 to 1.0.1:
https://vborg.vbsupport.ru/attachmen...chmentid=25204

[mtha]

Originally Posted by ChrisBaktis

This is the Database error I get. Im running 3.0.7.

PHP Code:

Database error in vBulletin 3.0.7:

Invalid SQL: DROP TABLE IF EXISTS award;        
mysql error: You have an error in your SQL syntax near ';        ' at line 1

mysql error number: 1064

Date: Monday 28th of March 2005 10:43:21 PM
Script: http://rustysoaptraders.com/forums/admin/awards_install.php?step=doqueries
Referer: 


Hmm, I dont see any error there. I install/uninstall several times without error.

Why dont you try to download the new version, uninstall the hack (just to make sure your database is clean), and install it again.

If the error still there, try to edit the awards_install.php, remove line 233 (where executing that drop table query) and see how it works out.

Good luck

Originally Posted by lasto

cant have an awards system without displaying them in postbit.

Now you have it

Looks an ok hack will it have an ability for members to request awards later on ?

Quick question: What is the point of "requesting" awards? It's just like I have a cake, and members are jumping on me "Hey, give me one, give me one"

To me, Awards is kind of You or your administrative team giving to those who get some significant constribution.

Anyway, if you can tell me why it should be included, I will re-consider.

Suggestions/requests on code optimization, functions, or displays are welcome!