Major Additions - Yet Another Awards System

*** CREATE A BACKUP OF YOUR FORUM AND DATABASE BEFORE INSTALLING ***

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
+ Writes granting/removing awards to the log

In ModCP
- Issue awards to members, based on username or userid, with Issue Reason
- Remove awards from members
+ Writes granting/removing award to the log

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)

New Features/Additions since 3.8
- Points System
- Separate Award Request/Recommendation Forms
- CSS Customizable

Current Release Version 4.0.9

• Added - Handling of user merges
• Added - Handling of user deletes
• Added - Manage awards on per user basis
• Added - Extra info to the logs for mass removal and editing of issued awards
• Added - Ability to collapse categories on awards.php
• Added - Checksum file for checking for suspect file versions
• Added - Various missing phrases
• Fixed - Memberlist not showing awards when option is active
• Fixed - Navtab not being selected (vb version < 4.2)
• Fixed - Category title not being displayed on awards.php
• Fixed - Logging not working in modcp
• Fixed - A few other minor bugs

[squidsk]

Originally Posted by CAG CheechDogg

Good stuff squidsk...thanks for such a great mod my Man!

One quick question ! lol...would it be possible to add a feature, a one click feature to completely remove all the awards from a user with one click? Or list all the awards for one user and check a box for each award we want to remove in clusters?

Thanks in advance!

I'll take a look into adding it into a future release.

[CAG CheechDogg]

Originally Posted by squidsk

I'll take a look into adding it into a future release.

Muchas Gracias squidsk!

[Skyrider]

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT a.*, au.*
FROM award a, award_user au
WHERE (au.userid = 40476) AND (a.award_id=au.award_id) AND (a.award_active=1)
ORDER BY issue_time desc;

MySQL Error : MySQL server has gone away

Getting this often lately. Any idea what might be the cause? I know the "SQL gone away" is an obvious hint. But whenever I receive a SQL error in my e-mail, 80% of them is regarding the Yet Another Awards System.

[afmarko99]

Guys, is this mod compatible with 4.2.2?

[CoZmicShReddeR]

Originally Posted by afmarko99

Guys, is this mod compatible with 4.2.2?

Yes!

[afmarko99]

Thanks man

[Mobo]

I recently disabled and re-enabled this mod to track down some php display error messages. When I re-enabled it, the awards.php page is no longer displaying the names of the users that have each award (see attached screen shot).

Any thoughts on what might be causing that or how to fix it? From the Admin CP, each award still shows the users that have it.

[squidsk]

I'd check to make sure you have the correct version of the files installed. If you were using 4.0.7 version of awards.php you'd see that kind of behaviour.

[Mobo]

Thanks squidsk, that was it! Not sure how I only got a partial upload on that last update though.

[snipes01]

Originally Posted by Skyrider

Getting this often lately. Any idea what might be the cause? I know the "SQL gone away" is an obvious hint. But whenever I receive a SQL error in my e-mail, 80% of them is regarding the Yet Another Awards System.

I am also getting a database error with the latest version. I have disabled the plugin for now. I am only getting this error if I click on a users name to view their profile.

Anyway to fix this?