Miscellaneous Hacks - Yet Another Awards System

A lot of you have been waiting for this forever to work 100% with 3.7 due to the new profile tabs...Well wait no longer, here is the new revises version of HacNho's YAAS (Yet Another Awards System).

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

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)

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)


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
- Cypher for helping with the tabs in 3.7
- liwo for re-writing plugins
- and all others for supports and ideas

And most of all to HacNho

This MOD is 100% Supported.

Authors of YaAS 3.7:
Xanlamin
CypherSTL

Current Release: v3.7.4

[Saint_ago]

Originally Posted by Scarface Claw

A little bug, my awards disappear from post bit after I edit a post, but display again once I click away.

I'm having the same here!

[Tanpapasmurf]

I remember reading that there was a update in the works for the past weekend?

Any news on this?

[gorentals]

Anyway to get this to display under the visitor messages on the main profile instead of a tab? This would be for version 3.7.3

Thanks

[kurv]

Okay, asking again

Quick question.... is there a way to create a link that when you click on the award, it takes you to the thread they received the award for..? I guess it would have to have a URL link box for each award given that it links to.

Is that possible... and what would this modification cost me

Thank you!! and thanks for the hard work - installed and donated!!

[Xanlamin]

Thanks kurv;

Where would you like the link placed? cause right now when you click on an award it should take you to there profile (soon to the awards tab itself), we may be able to figure a way to have it choose able to which it would take you to.

to gorentals: this would be possible yes as an option.

As to an update...we where not able to work on this as much as we would have liked to this past week...I really hate emergancies, expect some major updates coming the weekend of the 27th.

[gorentals]

Ok thanks Xanlamin....Love your mod btw.

Is this something I can do or in the coming update?

Thanks again

[Xanlamin]

Not sure, I am only familure with certain parts of the code, my brother Cypher knows more of the deeper code and how to do the options aspect.

[Tanpapasmurf]

Thanks for your hard work.

[dknelson]

I had this working for some time now but suddenly members can't request an award. If you click on "request award", the page refreshes and nothing happens.

Then if I try to ISSUE an award from the admin panel, I get the following error.

Database error in vBulletin 3.7.3:

Invalid SQL:

			SELECT userid, username
			FROM user
			WHERE username = 'Sleeperhawk's Mechanic';

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 Mechanic'' at line 3
Error Number  : 1064
Request Date  : Wednesday, September 17th 2008 @ 09:53:41 PM
Error Date    : Wednesday, September 17th 2008 @ 09:53:41 PM
Script        : http://www.mysite.org/forum/admincp/award.php?do=dogiveaward
Referrer      : http://www.mysite.org/forum/admincp/award.php?do=awardusers&award_id=1
IP Address    : 72.69.93.240
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.51a-community

[dknelson]

OK folks....I looked into this a bit deeper. The problem with the database error seems to be only when there is an apostrophe in the username. This user is Sleeperhawk's Mechanic. I can give awards to members with the apostrophe or to this one if I use the userID instead of the name. I can live with that but is there a fix for it?

As for not being able to request an award. That may be just because I, as admin, am trying to do so. Maybe it won't allow me to. Never tried before but was trying to test it in researching the above problem and noticed that it doesn't work if I click on "request award".