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

[CAG CheechDogg]

Originally Posted by squidsk

Sorry I missed this yesterday. I'm currently working on it and it should be in the next release. The next release will also include an option that should provide a performance boost, most noticeable for sites with lots of users with awards.

Nice! You Da' Man squidsk! Thanks in advance Bro really appreciate it!

[squidsk]

Originally Posted by netzwart

Hi,

first of all: Congratulation for this brilliant MOD!

I am running this MOD in its version 4.0.4 and found out, that the latest version is 4.0.6, such that I want/need to update the MOD. How do I update? Is it possible to simply exchange those parts which have changed? Do I have to run the whole installation procedure again?

Thanks for your help !!!

nw

You need to download the current version (4.0.6), from the top of the page and follow the instruction in the installation instructions file.

[Dogma21cw]

So this is happening, kind of out of the blue:


Any clues on a fix? Is is a vB thing? I tried uninstall/reinstall a fresh D/L of the plugin. But no dice. And is in all styles, and on every browser.

I also mean the double comma before the first name in the list.

[Skyrider]

The automation.. Is there a cron? When it is being done? I can't find a button to manually run it, and it's not doing it right away (waited 5min) after I added it. It's not showing up in the task manager either, though I have found it in the XML file:

<scheduling weekday="-1" day="-1" hour="1" minute="30" />

EDIT, found it.. but when I run it manually..

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO award_user (award_id, userid, issue_reason, issue_time, award_cgroup) VALUES ('2', '2004', 'You've been rewarded an award for being a Black Star Lounge Member!', 1382211619, 'usergroup');

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 've been rewarded an award for being a Black Star Lounge Member!', 1382211619, 'u' at line 1
Error Number : 1064
Request Date : Saturday, October 19th 2013 @ 09:40:19 PM
Error Date : Saturday, October 19th 2013 @ 09:40:19 PM
Script : http:/xxx/admincp/cronadmin.php?do=runcron&cronid=369
Referrer : http://xxx/admincp/cronadmin.php?do=modify
IP Address : xxx
Username : Skyrider
Classname : vB_Database_MySQLi
MySQL Version : 5.1.67

[squidsk]

Remove the apostrophe from the issue reason.

[CAG CheechDogg]

Originally Posted by squidsk

Remove the apostrophe from the issue reason.

It's not because of an apostrophe squidsk, I have that on my awards page as well, it happened to me after I either deleted an account or merged one ...

I then got an award in the awards list with no username ...

[squidsk]

Originally Posted by CAG CheechDogg

It's not because of an apostrophe squidsk, I have that on my awards page as well, it happened to me after I either deleted an account or merged one ...

I then got an award in the awards list with no username ...

I didn't see the other report of a bug, the apostrophe was in response to the error in the automation add-on. I will look into dealing with renaming/deleting accounts.

[squidsk]

Originally Posted by Dogma21cw

So this is happening, kind of out of the blue:


Any clues on a fix? Is is a vB thing? I tried uninstall/reinstall a fresh D/L of the plugin. But no dice. And is in all styles, and on every browser.

I also mean the double comma before the first name in the list.

As per above I'm looking into dealing with deleted/merged user accounts, the template name is a vbulletin setting I just can't remember which one, turn it off and the template name will stop being displayed for all templates.

[CAG CheechDogg]

Originally Posted by squidsk

As per above I'm looking into dealing with deleted/merged user accounts, the template name is a vbulletin setting I just can't remember which one, turn it off and the template name will stop being displayed for all templates.

To turn that off go to General settings and find "Add Template Name in HTML Comments", set that to "No"

[Skyrider]

Thanks for the reply, I shall refrain from using apostrophe. Though I do wish to report another bug / issue or miscalculation.

I've set a new automation on usergroup 6 (administrators). In total, 14 users are gaining the rewards, while there are only 6 people in the administration group. Te other 8 are moderators, super moderators and other custom groups members.

So why have they been given the award while they are not within Usergroup ID 6? They are not even in GroupID 6 as Additional users.