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

[mtha]

Originally Posted by fuse3k

Thank you very much for this Award hack. This will come in handy.

I need a quick hand though; I received this SQL error in the Admin CP after I added an award:

Database error in vBulletin 3.0.7:

Invalid SQL: 
			SELECT * 
			FROM forumsaward_user
			WHERE award_user.award_id=1
		
mysql error: Unknown table 'award_user' in where clause

It was the prefix problem.
Upload this file into your admincp.php and you will be fine.

[moley]

hehehe i missed one edit. thanks it fixed now.

Found an error. If you put anything like ' in the issue reason it gives you a database error

 Database error in vBulletin 3.0.7:
 
 Invalid SQL: 
 		INSERT INTO award_user
 		(award_id, userid, issue_reason, issue_time) 
 				VALUES ( '1', '2', 'He's', 1112474351)
 	
 mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's', 1112474351)' at line 
 
 mysql error number: 1064

[mtha]

Originally Posted by moley

Found an error. If you put anything like ' in the issue reason it gives you a database error

Thanks moley, I missed adding slashed at one query

fixed in my code and releasing a new version in few hours


idea: send PM/email to member when he/she got award

[Koutaru]

Yes that's actually a great idea too Can't wait for the new release (I've been trying to check every day )

[mtha]

YAAS 1.1 is AVAILABLE, please check the first post for more information


Hack Version: 1.1.050402

2005.04.03 - Version 1.1
- Can Create/Edit/Remove/Reorder categories/sub-categories in ACP (with category name and description)
- Can Move one (or all) award from one category to another, or set it un-classified (not displayed in the list in public site)
- Can re-order awards (in ACP)

How to UPGRADE/INSTALL:
Read README.txt and follow instructions

[trulylowcarb]

i think I got it first!
Seems to be working first try too, (hacked up vb3.07 and cmps1.1 with Gallery)
Now I just need to figure out how to set up award icons and add images and all that...
THANK YOU! Your installer is sweee-eeeet. ^5 "HacNho", which really cracked me up.

[trulylowcarb]

Hmmmm. It IS 430 am here, ....Your hack install instruction is excellent but I haven't a clue how to use this wonderful mod now that it is in there (if it is in there correctly?)

Never mind, I was just being 430 stupid. {Hate that .. but if I hadn't embarrassed myself asking I probably wouldn't have found it, LOL}

[trulylowcarb]

I did find a legitimate oops for you though, an easy one I am sure. There seems to a duplicate column for Award Icon on the main awards page, as shown here.

[Harry72]

Yes, i found this too.

Go to awards_category template and than search for this:

<td class="thead" nowrap="nowrap">$vbphrase[award_icon]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_icon]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_name] /

and replace that with

<td class="thead" nowrap="nowrap">$vbphrase[award_icon]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_image]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_name] /

Cheers
Harry

[mtha]

Originally Posted by trulylowcarb

I did find a legitimate oops for you though, an easy one I am sure. There seems to a duplicate column for Award Icon on the main awards page, as shown here.

oops, sorry, it was 4:30 my time too, I grap the wrong template, used it before adding phrases The installer was updated with the fix.

make the changes as Harry says, and you will be fine.

For those who see two "Award Icon" columns in the show awards page (/awards.php), please apply Harry's fix above.

If you have a fresh install, you can also run uninstall and re-install script. No file change.

Harry, would you click Install button please Thanks