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

[n00bl3t]

Originally Posted by Nocturnal222

When I was trying to upload the .xml I got the collowing error. Can anyone help me please?

Database error in vBulletin 4.1.4:

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   : Table 'zmu.award' doesn't exist
Error Number  : 1146
Request Date  : Thursday, June 30th 2011 @ 07:09:41 AM
Error Date    : Thursday, June 30th 2011 @ 07:09:42 AM
Script        : http://www.********.***/*****/admincp/plugin.php?do=productimport
Referrer      : http://www.********.***/*****/admincp/plugin.php?do=productadd
IP Address    : **.**.***.***
Username      : *******
Classname     : vB_Database
MySQL Version : 5.5.8

Any help is appreciated

Bumping this problem. I searched and still can't figure this out.

Mine is

MySQL Error : Duplicate column name 'award_allowrecommend'

I can't figure out where to find the column and delete it or something. Please help.

[discodoran]

having problems on vbulletin 4.1.5 when someone requests an award it say Users not Found: (then my admin team here) Any fixes for this yet or is it just me?

[TheLastSuperman]

Originally Posted by n00bl3t

Bumping this problem. I searched and still can't figure this out.

Mine is



I can't figure out where to find the column and delete it or something. Please help.

Try this: https://vborg.vbsupport.ru/showpost....1&postcount=32
*Mods are nearly identical so open the award system product .xml and modify.

Originally Posted by discodoran

having problems on vbulletin 4.1.5 when someone requests an award it say Users not Found: (then my admin team here) Any fixes for this yet or is it just me?

Hmm you do have the usergroup options set correctly right? If not that have you ever had a error similar to the above I just quoted?

[n00bl3t]

Doesn't work; tried it before and just tried it again. Still getting:

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'

[RollaJedi]

Just curious why automation of awards was never implemented. It was discussed a lot in the earlier pages of this thread.

[TheLastSuperman]

Originally Posted by n00bl3t

Doesn't work; tried it before and just tried it again. Still getting:

Uninstall the mod, upon re-install w/ your modified .xml it will work, you will lose all current awards though.

Originally Posted by RollaJedi

Just curious why automation of awards was never implemented. It was discussed a lot in the earlier pages of this thread.

It worked on the 3.6 versions, I believe there is a upload for that though - check the attachments up top in the mod info ^

[elzarie]

How can I add it the points count to custom place ?

[tidus78]

I'm losing some medals ... I tried to reload the images in the root of the forum, also renaming ,but does not work ...

[nacaruncr]

these don't have the extension .jpg, .png, .gif.... try to put an extension and reloading

[odie3]

Have it installed after upgrading from 3.6.x to 4.1.x! After re-installing I lost all my data from 3.6 but was able to export the entries from the old forums DB and insert them in to the new 4.1 DB (always good to keep your old data, never know what you might need).