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

[UK CHI3F]

Originally Posted by squidsk

I'd guess that the awards page isn't loading that additional css for some reason. I'll look into it.

Really appreciate it thanks

[squidsk]

Have you set the setting for Store CSS Stylesheets as Files? set to yes? If not you can try to edit the headerinclude template and near the end add additonal.css to the list of css files included.

[Glockie]

Hi,
firstly thanks for this great mod!

I am however, having some issues running it on 4.2.0
I don't have the 'Awards Tab' showing on the board only in the users profile page
And It's not showing anywhere the link to recommend an award

So, in short the recommend the award link (navbar) doesn't exist...

I hope someone can help here..
I look forward to hearing from you

Thanks

** EDIT Ignore the vbphrase issue, I've found it.. cheers!
I've also typed ****.example/award ( guess ) which works but the page is terribly messed up, so I'm assuming it's a CSS fault somewhere.. I can manually add the link on the nav, so that's not a problem. Thanks again

[Thunderbird8]

You can add it to the NavBar manually via the Navigation Manager (awards.php is the path). Or if you feel safe doing so, you can make the plugin edit that I mentioned a few posts earlier.

[FTG LIQUID CL]

I cant access the request and recommened awards.It tells me this..

Admin, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation

Any ideas.

[DiageoLiam]

Is there a fix for automation yet? Getting the following when trying to run the scheduled task. Am using the fix posted by another developer a few pages back.

Database error in vBulletin 4.2.0:

Invalid SQL:

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

MySQL Error : Unknown column 'award_cgroup' in 'field list'
Error Number : 1054
Request Date : Monday, June 25th 2012 @ 09:16:10 AM
Error Date : Monday, June 25th 2012 @ 09:16:10 AM
Script : XX/cronadmin.php?do=runcron&cronid=55
Referrer : XX/cronadmin.php?do=modify
IP Address : XX
Username : XX
Classname : vB_Database
MySQL Version : 5.5.23-55

[Kirk Fitzgerald]

Originally Posted by Crotan

Existing bug, sadly developer is AWOL, but the fix should still stand.

https://vborg.vbsupport.ru/showpost....&postcount=742

Exactly what I was trying to fix myself, many thanks for the information.

[squidsk]

Originally Posted by Kirk Fitzgerald

Exactly what I was trying to fix myself, many thanks for the information.

Use https://vborg.vbsupport.ru/showpost....postcount=1152 instead, it includes all the fixes from the link you used as well as many other fixes.

[squidsk]

Originally Posted by DiageoLiam

Is there a fix for automation yet? Getting the following when trying to run the scheduled task. Am using the fix posted by another developer a few pages back.

Database error in vBulletin 4.2.0:

Invalid SQL:

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

MySQL Error : Unknown column 'award_cgroup' in 'field list'
Error Number : 1054
Request Date : Monday, June 25th 2012 @ 09:16:10 AM
Error Date : Monday, June 25th 2012 @ 09:16:10 AM
Script : XX/cronadmin.php?do=runcron&cronid=55
Referrer : XX/cronadmin.php?do=modify
IP Address : XX
Username : XX
Classname : vB_Database
MySQL Version : 5.5.23-55

Looking at the xml for automation it looks like you didn't install the automation plugin properly, or there was an error with the installation. The reason I say this is the first thing that should be done by the install script is to add that column to the award_user table. You could try changing line 22 so that ADD award_cgroup instead says ADD COLUMN award_cgroup. If the automation plugin is showing up in your product list I'd uninstall it and re-install it. You'll also need to manually delete the award_automation table if you're doing a re-install since the table is not removed during an uninstall.

[FTG LIQUID CL]

i cant get the automation to work