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

[tomrep]

when will it be released for 4.1.12

[marccap]

It works on 4.1.12 - check it out on my site

[Dave234]

Do I need to upload both of the folders?

[BWG22]

I uninstalled the plug-in, and tried to reinstall and got this....

MySQL Error : Duplicate column name 'award_allowrecommend'

How to fix please?

[Dave234]

There is an error in my upload. I tried uploading both folders via ftp.

As soon as I tried uploading the "product-yet_another_award_system" from the "YaAS-4.0.2-PL1" folder, it gave me a database error.

In my AdminCP, Plugin Manager, Edit Product screen, these are what appear under the "Install Code":

Version 1.0.0:

$db->reporterror = 0;
// NEW INSTALL CODE
if ($installed_version == null) {

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "award_user ADD award_cgroup VARCHAR( 15 )");
echo "<font size=\"1\">Alter table - award_user - criteria group</font><br />";

}



Version 1.0.2:
// CREATE AWARD AUTOMATION TABLE
$db->reporterror = 0;

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "award_automation (
award_automation_id int(10) unsigned NOT NULL auto_increment,
auto_active int(1) NOT NULL,
auto_name varchar(32) NOT NULL,
auto_issuereason varchar(255) NOT NULL,
auto_type varchar(32) NOT NULL,
auto_criteria int(10) NOT NULL,
auto_awardid int(10) NOT NULL,
PRIMARY KEY (award_automation_id)
)
");
echo "<font size=\"1\">Added Table - Award Automation</font><br />";

[squidsk]

Originally Posted by Dave234

Do I need to upload both of the folders?

No just the contents of the upload folder, if you uploaded the contents correctly and installed the xml correctly it should work.

Originally Posted by BWG22

I uninstalled the plug-in, and tried to reinstall and got this....

MySQL Error : Duplicate column name 'award_allowrecommend'

How to fix please?

What version did you uninstall? If you started with a 4.0.2PL1 version, the only error you should get when uninstalling and reinstalling is related to some missing uninstall code for the award_requests table.

That being said, if you run the following sql commands from admincp it should remove any leftover stuff.


show tables
drop table *award*


The first command will list all your tables, then you'll need to use the second command as many times as needed, by replacing the *award* with the name of an award table that was left around by mistake.

[squidsk]

Originally Posted by Dave234

There is an error in my upload. I tried uploading both folders via ftp.

As soon as I tried uploading the "product-yet_another_award_system" from the "YaAS-4.0.2-PL1" folder, it gave me a database error.

In my AdminCP, Plugin Manager, Edit Product screen, these are what appear under the "Install Code":

Version 1.0.0:

$db->reporterror = 0;
// NEW INSTALL CODE
if ($installed_version == null) {

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "award_user ADD award_cgroup VARCHAR( 15 )");
echo "<font size=\"1\">Alter table - award_user - criteria group</font><br />";

}



Version 1.0.2:
// CREATE AWARD AUTOMATION TABLE
$db->reporterror = 0;

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "award_automation (
award_automation_id int(10) unsigned NOT NULL auto_increment,
auto_active int(1) NOT NULL,
auto_name varchar(32) NOT NULL,
auto_issuereason varchar(255) NOT NULL,
auto_type varchar(32) NOT NULL,
auto_criteria int(10) NOT NULL,
auto_awardid int(10) NOT NULL,
PRIMARY KEY (award_automation_id)
)
");
echo "<font size=\"1\">Added Table - Award Automation</font><br />";

What is the database error you are getting?

[Dave234]

Alter table - award
Alter table - usergroup

Tables Altered Successfully

Alter table - 2.1.3
Alter table - 2.1.4





Database error



The Social Hulk Espa?ol database has encountered a problem.




--------------------------------------------------------------------------------




Please try the following: •Load the page again by clicking the Refresh button in your web browser.
•Open the www.socialhulk.com home page, then try to open another page.
•Click the Back button to try another link.



The www.socialhulk.com forum technical staff have been notified of the error, though you may contact them if the problem persists.




We apologise for any inconvenience.

[Dave234]

Database error in vBulletin 4.1.11:

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 : Tuesday, May 22nd 2012 @ 04:58:59 PM
Error Date : Tuesday, May 22nd 2012 @ 04:58:59 PM
Script : http://www.socialhulk.com/spanish/ad...=productimport
Referrer : http://www.socialhulk.com/spanish/ad...?do=productadd
IP Address : (hidden because confidential?)
Username : El Luchador Rubio
Classname : vB_Database
MySQL Version : 5.1.63-community-log

[Dave234]

Does this make any sense?