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

[stickskills]

Originally Posted by mikelf453

When ever someone requests an award, this message comes up:



But the request still sends. Any idea how I can get rid of this message?

Getting this same exact message, and the request goes through as well. Would love to be able to fix that. Also, is there any way to display the total score from all awards a user has? Love to be able to incorporate this into our postbit.

[stickskills]

If we're manually trying to add this code into the postbit, do you have a quick mockup of the code?

[MarceloS]

Originally Posted by stickskills

If we're manually trying to add this code into the postbit, do you have a quick mockup of the code?

Same thing for me.

[Vick98]

Originally Posted by squidsk

On the previous page I had a couple of fixes that dealt with user profile pages that you could try.

Thank you very much for the reply and your codes fixed the extra tab issue but I still do not have a background image. Do you have any suggestion or ideas why this is occurring?

[nerowolfe]

Hi Cyp.

When I install your addon, I have this error im my vbull (4.1.2):

Database error in vBulletin 4.1.2:

Invalid SQL:
ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error   : Duplicate column name 'award_allowrecommend'
Error Number  : 1060
Request Date  : Sunday, April 10th 2011 @ 06:11:28 PM
Error Date    : Sunday, April 10th 2011 @ 06:11:29 PM
Script        : http://name site/forum/admincp/plugin.php?do=productimport
Referrer      : http://name site/forum/admincp/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Username      : user name of db
Classname     : vB_Database
MySQL Version : 5.0.32-Debian_7etch12-log

May you help me please?

Regards

[squidsk]

It means what it says it means, you're trying to add a column to the table that already exists.

[dnk.it]

Originally Posted by dnk.it

when this mod will be updated?

My footer is misplaced and I think the cause is a bad css formatting, please see attachment

vbulletin Version 4.1.1

I have solved this

just remove the <br /> code in memberinfo_block_myawards template

[Vick98]

I am still looking for a fix with the disappearance of the backgrounds. If anyone can help it would be greatly appreciated. Anyone without a medal has the custom background but once a member receives a medal/award the background disappears.

[Daisyboo]

Clutching at straws...I had the 3.x version installed which I removed prior to upgrading to 4.
I want to add it back but I'm currently getting SQL errors emailed to me. Can anyone give me some clues as to how I sort them out? I asked on vB.com but because its a mod they won't help.
Its being triggered by a google bot so I don't know why its happening.
The error is

Invalid SQL:

SELECT u.userid, u.username, au.award_id
FROM vb_award_user AS au
LEFT JOIN vb_user AS u ON (u.userid = au.userid)
WHERE au.award_id = 1
GROUP BY u.userid, u.username, au.award_id
ORDER BY u.userid;

MySQL Error : Table 'babydre_bumples2.vb_award_user' doesn't exist
Error Number : 1146

If I add the updated mod back will it affect the error or the error affect the install?

Thanks!

[TNERatedEdge]

Hi, for some reason one of my members cant revieve awards in there profile..

Any reason why?