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

[CypherSTL]

Originally Posted by n_only

and IF there are an infraction for any member , Awards Showcase change it's location

for more info. check out my attachment please

Alright, I enabled that option on my test board to view it. I will try to get that fixed in the RC2 release.

For now, you can set your display location to "userinfo_right_after_post" and it will still show inside the postbit, but a bit higher.

Thanks for the report.

[fishmaster]

All works 99.9% correctly on my install.

1st error: When changing award category descriptions to a new category name, database error occurred.

[albrens]

thanks a lot

[albrens]

Dear CypherSTL,

After install, I can't see Award System in AdminCP. I don't know why!

Regards,

[CypherSTL]

Originally Posted by fishmaster

All works 99.9% correctly on my install.

1st error: When changing award category descriptions to a new category name, database error occurred.

Can you paste the error?

Originally Posted by albrens

Dear CypherSTL,

After install, I can't see Award System in AdminCP. I don't know why!

Regards,

Make sure you've imported the XML. Post a screenshot too if that doesn't fix it.

[fishmaster]

Database error in vBulletin 4.0.1:

Invalid SQL:

UPDATE vb3_award
SET award_name = '**** Service Award',
award_desc = 'Provides Valuable Services To The ***.',
award_icon_url = 'http://****.com/awards/1.gif',
award_img_url = 'http://****.com/awards/1b.gif',
award_cat_id = '1',
award_displayorder = '1',
award_allowrequest = '1',
award_allowrecommend = '0',
award_active = '1',
award_pointvalue = '0'
WHERE award_id = 1;

MySQL Error : Unknown column 'award_allowrecommend' in 'field list'
Error Number : 1054
Request Date : Friday, January 15th 2010 @ 04:35:43 AM
Error Date : Friday, January 15th 2010 @ 04:35:43 AM
Script : http://www.****.com/forums/admincp/a...hp?do=doupdate
Referrer : http://www.****.com/forums/admincp/a...dit&award_id=1
IP Address : 75.90.***.254
Username : ********
Classname : vB_Database
MySQL Version : 4.1.22-standard



Note: Issuing awards, removing awards, awards totals, awards display, everything else is working fine.

[CypherSTL]

Originally Posted by fishmaster

Database error in vBulletin 4.0.1:
...

MySQL Error : Unknown column 'award_allowrecommend' in 'field list'
Error Number : 1054
Request Date : Friday, January 15th 2010 @ 04:35:43 AM
Error Date : Friday, January 15th 2010 @ 04:35:43 AM
Script : http://www.****.com/forums/admincp/a...hp?do=doupdate
Referrer : http://www.****.com/forums/admincp/a...dit&award_id=1
IP Address : 75.90.***.254
Username : ********
Classname : vB_Database
MySQL Version : 4.1.22-standard
...

Is this an upgraded version of YaAS (e.g. from 3.8), or a brand new fresh install?

[CypherSTL]

Alright. I have just finished writing the Award Automation for Postcount-Based awards, and seems to be functioning correctly during my testing. This will be in the RC2 release in a few days.

I still need to code the automation script for issuing awards based on usergroup membership, and length/days of being a forum member.

--
Also, just a reminder. For those of you using the Points system, and the future Automation System will need to run atleast MySQL 5.0+ due to some of the query functions.

[Verionia]

I seem to be having database issues with 4.01 - causing my site to be turtle slow...

[abdulbasitsaeed]

Just installed after the upgrade, and seems to be working fine.

Is it possible to (Please see screenshot below):

1. Top align the icon and image for a award?

2. Remove the box around Issue Time and Issue Reason?

3. Align the Description of the award under the Description heading? The actual description appears to start from the left of the Description heading.

Thanks!