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

[adders]

@ A Dead Puppie - Thanks a million that worked, funny thing is though that request was set to yes for everyone already but this didn't work, setting both recommend to yes made both work.

Cheers

[masonox]

Hello, It all seems to be going well except

My forum is contained within a pagewrap as seen in the Normal screenshot

After hitting the award link, the award.php blows out all the forum formatting as seen in the Award screenshot. I have not been able to find a way to fix this. I had the same problem with the "roster" mod, until it was updated on the site then it just started to work correctly.

Any help to have it conform to my forums css would be appreciated. Thanks

[CharlieDelta]

Originally Posted by A Dead Puppie

Hey, everything is working, but when i go to change the default submission data, i get:

"No Phrases Matched Your Query"

and everything is installed correctly.

I am having the same problem. When I try to edit the PM content and subject I get this same error. Did I miss something on the upload or installation?

[CharlieDelta]

Originally Posted by LuucEarth

Using the recommend award system. When I hit submit I get


Message
There's some error when sending your award request. Please contact site's administrator for assistant.


It does however add the recommendation into the award requests page.

I am also getting this when I use the recommend or request. It gets added to the request page as well.

Scratch that. I realized I had not set up where to submit the post. Duhhh.

[CharlieDelta]

How do I change the background color of the text box for explanation of request or recommendation? I am using a dark style and you cannot see the text.

[MmS1]

after upgrading the hack to 4.0.6 from 3.8.5

i got this error when i add a new award


Database error in vBulletin 4.0.6:

Invalid SQL:

INSERT INTO award
(award_name, award_desc, award_icon_url, award_img_url, award_cat_id, award_displayorder, award_allowrequest, award_allowrecommend, award_pointvalue, award_active)
VALUES
('test',
'',
'photo',
'photo',
'-1',
'1',
'1',
'1',
'0',
'1'
);

MySQL Error : Unknown column 'award_allowrecommend' in 'field list'
Error Number : 1054
Request Date : Tuesday, September 7th 2010 @ 03:40:48 PM
Error Date : Tuesday, September 7th 2010 @ 03:40:48 PM
Script : http://www.site/admincp/award.php?do=insert
Referrer : http://www.site/admincp/award.php?do=add
IP Address : 44.92.00.00
Username : MmS
Classname : vB_Database
MySQL Version : 5.1.48

[CharlieDelta]

Originally Posted by CharlieDelta

How do I change the background color of the text box for explanation of request or recommendation? I am using a dark style and you cannot see the text.

Can anyone tell me?

[wickedstangs]

does this work with 4.0.6?

[CypherSTL]

Originally Posted by masonox

Hello, It all seems to be going well except

My forum is contained within a pagewrap as seen in the Normal screenshot

After hitting the award link, the award.php blows out all the forum formatting as seen in the Award screenshot. I have not been able to find a way to fix this. I had the same problem with the "roster" mod, until it was updated on the site then it just started to work correctly.

Any help to have it conform to my forums css would be appreciated. Thanks

Link to the site would be helpful.

Originally Posted by MmS1

after upgrading the hack to 4.0.6 from 3.8.5

i got this error when i add a new award


Database error in vBulletin 4.0.6:

Invalid SQL:

INSERT INTO award
(award_name, award_desc, award_icon_url, award_img_url, award_cat_id, award_displayorder, award_allowrequest, award_allowrecommend, award_pointvalue, award_active)
VALUES
('test',
'',
'photo',
'photo',
'-1',
'1',
'1',
'1',
'0',
'1'
&nbsp;

MySQL Error : Unknown column 'award_allowrecommend' in 'field list'
Error Number : 1054
Request Date : Tuesday, September 7th 2010 @ 03:40:48 PM
Error Date : Tuesday, September 7th 2010 @ 03:40:48 PM
Script : http://www.site/admincp/award.php?do=insert
Referrer : http://www.site/admincp/award.php?do=add
IP Address : 44.92.00.00
Username : MmS
Classname : vB_Database
MySQL Version : 5.1.48

Some of the tables weren't created during the upgrade.

Originally Posted by wickedstangs

does this work with 4.0.6?

It should, but I cannot confirm it at this point. I've been working on the Awards System, but a lot of my work is still on vB 4.0.4

[wickedstangs]

works like a champ on 4.0.6