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

[DigitalDark]

Oh! Another thing I forgotten... It would be possible to show only one image per medal?
Ex: I create a MEDAL "A". I give the Medal "A" 3 times to the same user. In postbit appears A A A. It would be possible to show A (3)?

[GrossKopf]

Originally Posted by CypherSTL

YaAS RC1 Released.

4.0.0 RC1 RELEASE: (01/13/2010 1:15AM CST)

* Fixed - Award Tab Display for vBulletin 4.0.1.

Just downloaded this version and the awards tab has disappeared from the user profiles:

http://flotgaming.net/forums/member.php?1-GrossKopf

[GrossKopf]

Originally Posted by GrossKopf

Just downloaded this version and the awards tab has disappeared from the user profiles:

http://flotgaming.net/forums/member.php?1-GrossKopf

I should probably mention that I haven't upgraded to vBulletin 4.0.1.

[Bouncer222]

Originally Posted by Sayid

hmm so what is the benefit of point system? I mean what does it calculate ? it depends on what ?

I like to see an auto award feature depends on posts number , reputation or points for example, and happy to see it upgraded

Yeah auto is a lot better I have to agree with him, especially on huge boards, here are some good features...

a) Auto for reaching a specific post count or maybe a couple of post counts with different medals.

b) User has been a member for X Years/Days/Months and gets a certain award and a new award for each increase of years.

c)Usergroup change/promotion-get award

And there could be more even great options.

[GrossKopf]

Originally Posted by GrossKopf

I should probably mention that I haven't upgraded to vBulletin 4.0.1.

Upgrading to 4.0.1 fixed it.

[CypherSTL]

If you guys want all the auto awards being issued for whatever reasons, my recommendation is that you start reading up on scheduled tasks and writing cron scripts. Their is simply way too many different combination of reasons why awards should be issued, to code something like this that would cover everyones bases.
----
I am willing to add a few "Automation Options"; but I cannot do special requests for everyones needs. My suggestion at that point, I will automate a few of the award scenarios, and for more "advanced" options I would recommend looking at the cron scripts for the 3 I will make and see if you can figure out from that. I will try to help, but I don't have all too much time to work on cron scripts for people. I hope everyone can understand that.

The only thing I can think of, it wouldn't be done within the next week mind you, but pick like 3 "most common" award scenarios and try to automate those. Those 3 would most likely be

• Post Counts
• Usergroups
• Membership Length

I will see what I can do on working with those 3. Just remember, it wont be anytime soon for those to be implemented. Give me a week or two atleast.

[mikeylikesitz]

got a database error on 4.0.1 upgraded from the 3.8 version of this

Database error in vBulletin 4.0.1:

Invalid SQL:

                        SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
                        FROM award a, award_user au
                        WHERE (au.userid = 2391) AND (a.award_id=au.award_id) AND (a.award_active=1)
                        GROUP BY au.userid;

MySQL Error   : Unknown column 'award_pointvalue' in 'field list'
Error Number  : 1054

[CypherSTL]

Originally Posted by mikeylikesitz

got a database error on 4.0.1 upgraded from the 3.8 version of this

MySQL Error   : Unknown column 'award_pointvalue' in 'field list'
Error Number  : 1054

Did you import the XML? The XML creates two new columns in the database.

[mikeylikesitz]

yes i did, i imported a second time after the error to make sure it didnt get corrupted

[CypherSTL]

When you imported the XML, did it give you any errors then?

Check your vBulletin Database in the awards table, and see if you have an "award_allowrecommend", and "award_pointvalue" column.