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]

What's the rest of the error?

[marccap]

Originally Posted by squidsk

What's the rest of the error?

Here is the full error code when I run the schedule task but I've taken out my IP address

PHP Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

            SELECT userid, award_id, award_cgroup
            FROM award_user
            WHERE (userid=4) AND (award_id=4) AND (award_cgroup='postcount');

MySQL Error   : Unknown column 'award_cgroup' in 'field list'
Error Number  : 1054
Request Date  : Thursday, February 14th 2013 @ 08:18:52 AM
Error Date    : Thursday, February 14th 2013 @ 08:18:53 AM
Script        : http://www.platboyonline.com/admincp/cronadmin.php?do=runcron&cronid=32
Referrer      : http://www.platboyonline.com/admincp/cronadmin.php?do=modify
IP Address    : -----------
Username      : Marccap
Classname     : vB_Database
MySQL Version : 5.5.28 


[letsjoy]

Thanks squidsk for exploit fix

[richardevans123]

Is there a way to get the awards to show in the signature area?

Thanks

[squidsk]

Originally Posted by richardevans123

Is there a way to get the awards to show in the signature area?

Thanks

Yes in the awards settings where you choose where you want the awards to show, choose one of the signature options.

[marccap]

Originally Posted by marccap

Here is the full error code when I run the schedule task but I've taken out my IP address

PHP Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

            SELECT userid, award_id, award_cgroup
            FROM award_user
            WHERE (userid=4) AND (award_id=4) AND (award_cgroup='postcount');

MySQL Error   : Unknown column 'award_cgroup' in 'field list'
Error Number  : 1054
Request Date  : Thursday, February 14th 2013 @ 08:18:52 AM
Error Date    : Thursday, February 14th 2013 @ 08:18:53 AM
Script        : http://www.platboyonline.com/admincp/cronadmin.php?do=runcron&cronid=32
Referrer      : http://www.platboyonline.com/admincp/cronadmin.php?do=modify
IP Address    : -----------
Username      : Marccap
Classname     : vB_Database
MySQL Version : 5.5.28 


Any ideas on this yet?

[CharlieDelta]

Is it possible to make the poll votes public?

[CharlieDelta]

I just "granted" an award and it was issued to the sender and not the recipient.

Edit:
I just noticed that there was no pm sent as I was using the "Give award to user" in the acp to fix my above issue.

[squidsk]

Originally Posted by CharlieDelta

Is it possible to make the poll votes public?

If you mean to show who voted for which option, then no not currently aside from doing it manually.

Originally Posted by CharlieDelta

I just "granted" an award and it was issued to the sender and not the recipient.

Known issue, it will be fixed in the next release.

Edit:
I just noticed that there was no pm sent as I was using the "Give award to user" in the acp to fix my above issue.

I can't reproduce the problem as I get PMs if I issue an award from Award Manager -> Give Award to User in acp.

Originally Posted by marccap

Any ideas on this yet?

I'd guess it had an error on installation because if it had installed correctly that field would be in the table.

[CharlieDelta]

Thank you squidsk.