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

[BWG22]

Ok, the SQL command worked and it installed, but now it brings me back to the awards main page getting this message.

Fatal error: Cannot redeclare construct_depth_mark() in /public_html/forums/includes/adminfunctions.php on line 1915

[FTG LIQUID CL]

keep getting this message when i try to upload the xml product

Database error in vBulletin 4.1.12:

Invalid SQL:
ALTER TABLE vbaward 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 : Wednesday, May 23rd 2012 @ 06:25:31 PM
Error Date : Wednesday, May 23rd 2012 @ 06:25:32 PM
Script : http://fataltalentgaminglive.com/adm...=productimport
Referrer : http://fataltalentgaminglive.com/adm...?do=productadd
IP Address : 75.137.26.203
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.63-community-log

[squidsk]

Originally Posted by BWG22

Ok, the SQL command worked and it installed, but now it brings me back to the awards main page getting this message.

Fatal error: Cannot redeclare construct_depth_mark() in /public_html/forums/includes/adminfunctions.php on line 1915

What exactly were you doing that caused this error to occur? The only reference I can find to this function within the awards files is in a location that does not make use of the file includes/adminfunctions.php.

Originally Posted by FTG LIQUID CL

keep getting this message when i try to upload the xml product

Database error in vBulletin 4.1.12:

Invalid SQL:
ALTER TABLE vbaward 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 : Wednesday, May 23rd 2012 @ 06:25:31 PM
Error Date : Wednesday, May 23rd 2012 @ 06:25:32 PM
Script : http://fataltalentgaminglive.com/adm...=productimport
Referrer : http://fataltalentgaminglive.com/adm...?do=productadd
IP Address : 75.137.26.203
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.63-community-log

Are you upgrading or re-installing the plugin? If re-installing then follow my instructions on the last page about deleting tables that weren't properly uninstalled. If upgrading what version are you upgrading from?

[BWG22]

Originally Posted by squidsk

What exactly were you doing that caused this error to occur? The only reference I can find to this function within the awards files is in a location that does not make use of the file includes/adminfunctions.php.

Didn't do anything I wasn't supposed to. It was the error I had before when I upgraded my vB to 4.1.11. It just started giving me that error after the upgrade completed. Since then, I uninstalled it, dropped the tables, and re-installed and I still get the error.

[squidsk]

Originally Posted by BWG22

Didn't do anything I wasn't supposed to. It was the error I had before when I upgraded my vB to 4.1.11. It just started giving me that error after the upgrade completed. Since then, I uninstalled it, dropped the tables, and re-installed and I still get the error.

What other plugins are you running? I'm on a clean vb4.1.12PL1 and don't get that message, nor did I get it when the forum was on 4.1.10.

As I said the only place in the awards code that creates its own construct_depth_mark function is in the awards.php file, which does not require adminfunctions.php nor does in require a file which requires adminfunctions.php.

I was specifically asking what actions you'd taken (e.g. trying to view/change the awards settings) that causes that error.

[Dave234]

Mine is the same (please see my last post). Can you please assist?

[squidsk]

Did you read my response to FTG LIQUID CL?

[FTG LIQUID CL]

yes i will work on it

[FTG LIQUID CL]

its the first time i have installed this product,i have tried to re install the xml file but keep getting that message

[squidsk]

Follow my instructions on the previous page how to delete the previous install correctly. First uninstall the plugin if it shows up in the plugin list, then you'll need to drop the three tables (if all of them were created) before trying to re-install.