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

[M.Iftikhar]

it is not working in 4.1.10...when i add new award it display database error and when i edit a award it also give database error.....please tell me what can i do....or please tell me an other addon that works..........thanks and reply me soon.

[Bisha]

Originally Posted by M.Iftikhar

it is not working in 4.1.10...when i add new award it display database error and when i edit a award it also give database error.....please tell me what can i do....or please tell me an other addon that works..........thanks and reply me soon.

Last Update: 16 May 2010 , and on 4.1.10, there are a tons of changes....

[M.Iftikhar]

Hello,vbulletin members and staff members please help me....i am using Yet Another Awards System...it work fine in vb4.1.5 after upgrading to vb 4.1.10 it did not work fine....all previous seeting work fine...but when i add new award or updat a award it gives error.... so i enabled to add new award....and also do not edit previously award setting..... when i add new award it gives the following error....

Database error in vBulletin 4.1.10:

Invalid SQL:

INSERT INTO award
(award_name, award_desc, award_icon_url, award_img_url, award_cat_id, award_displayorder, award_allowrequest, award_allowrecommend, award_pointvalue, award_active)
VALUES
('Special Proformas 2011',
'',
'http://******.com/images/medals/shairy.gif',
'http://********.com/images/medals/shairy.gif',
'27',
'1',
'0',
'0',
'0',
'1'
);

MySQL Error : Unknown column 'award_allowrecommend' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 1st 2012 @ 08:28:27 AM
Error Date : Wednesday, February 1st 2012 @ 08:28:29 AM
Script : http://www.******.com/admin/award.php?do=insert
Referrer : http://www.******.com/admin/award.ph...ward_cat_id=-1
IP Address : 1**.1**.2**.5
Username : Administrator
Classname : vB_Database
MySQL Version : 5.1.56

so please tell me how can i do....????

please provide me another award system link....that work reply me soon......thanks

[mIQe]

Why does this not work?

All of them have the setting: Enable Automation Task? YES
Also the Awards Systems Setting have: Automation: Enable Automation System set to YES
Members have been members for longer then 30 days.

This Mod is supposed to be supported. Then give me support and not some email address that doesn't include support.

Automation Task Name 		Issue reason 						Criteria Type	Criteria	Award ID

One Month Membership 		You have been a member for one month. 			daysasmember 	30 		24
Two Months Membership 		You have been a member for two months. 			daysasmember 	60 		25
Three Months Membership 	You have been a member for three months. 		daysasmember 	90 		26
Four Months Membership 		You have been a member for four months. 		daysasmember 	120 		27
Five Months Membership 		You have been a member for five months. 		daysasmember 	150 		28
Six Months Membership 		You have been a member for six months. 			daysasmember 	180 		29
Seven Months Membership 	You have been a member for seven months. 		daysasmember 	210 		30
Eight Months Membership 	You have been a member for eight months. 		daysasmember 	240 		31
Nine Months Membership 		You have been a member for nine months. 		daysasmember 	270 		32
Ten Months Membership 		You have been a member for ten months. 			daysasmember 	300 		33
Eleven Months Membership 	You have been a member for eleven months. 		daysasmember 	333 		34
Twelve Months Membership 	You have been a member for twelve months. 		daysasmember 	365 		35
One And A Half Year Membership 	You have been a member for one and a half years. 	daysasmember 	548 		36
Two Years Membership 		You have been a member for two years. 			daysasmember 	730 		37
Three Years Membership 		You have been a member for three years. 		daysasmember 	1095 		38

[killerford]

Will this work with the latest version of VB?

[squidsk]

Originally Posted by mIQe

Why does this not work?

All of them have the setting: Enable Automation Task? YES
Also the Awards Systems Setting have: Automation: Enable Automation System set to YES
Members have been members for longer then 30 days.

This Mod is supposed to be supported. Then give me support and not some email address that doesn't include support.

Automation Task Name 		Issue reason 						Criteria Type	Criteria	Award ID

One Month Membership 		You have been a member for one month. 			daysasmember 	30 		24
Two Months Membership 		You have been a member for two months. 			daysasmember 	60 		25
Three Months Membership 	You have been a member for three months. 		daysasmember 	90 		26
Four Months Membership 		You have been a member for four months. 		daysasmember 	120 		27
Five Months Membership 		You have been a member for five months. 		daysasmember 	150 		28
Six Months Membership 		You have been a member for six months. 			daysasmember 	180 		29
Seven Months Membership 	You have been a member for seven months. 		daysasmember 	210 		30
Eight Months Membership 	You have been a member for eight months. 		daysasmember 	240 		31
Nine Months Membership 		You have been a member for nine months. 		daysasmember 	270 		32
Ten Months Membership 		You have been a member for ten months. 			daysasmember 	300 		33
Eleven Months Membership 	You have been a member for eleven months. 		daysasmember 	333 		34
Twelve Months Membership 	You have been a member for twelve months. 		daysasmember 	365 		35
One And A Half Year Membership 	You have been a member for one and a half years. 	daysasmember 	548 		36
Two Years Membership 		You have been a member for two years. 			daysasmember 	730 		37
Three Years Membership 		You have been a member for three years. 		daysasmember 	1095 		38

I'm pretty sure the automation is not retroactive so if someone has already been a member of your site for X days they will not get the award just because you activate it. The query likely checks if they've been a member exactly X days and then gives an award.

[Bluefin221]

Originally Posted by killerford

Will this work with the latest version of VB?

Yes, although it doesn't function the way you want it to.

[mIQe]

Originally Posted by squidsk

I'm pretty sure the automation is not retroactive so if someone has already been a member of your site for X days they will not get the award just because you activate it. The query likely checks if they've been a member exactly X days and then gives an award.

Thanks for replying. Are you sure about it not being retroactive?
I surely have to check the registration date for a member not how long the award has been active.

Because if it isn't, then this mod stinks even more then their support does.

[squidsk]

Originally Posted by mIQe

Thanks for replying. Are you sure about it not being retroactive?
I surely have to check the registration date for a member not how long the award has been active.

Because if it isn't, then this mod stinks even more then their support does.

Pretty sure, because it would make the code and the queries more complex if it was applying awards retroactively. I'm guessing that the automation is run through a cron job which runs every X period of time. If you want it to run retroactively then you're running an extra query for every single user in the database for every single award that is being automatically awarded. The overhead for that would not be something I'd want on my site.

As for complaining about the support, you do realize that whatever support you're getting, and I believe that just means patches and stuff, you aren't paying a cent for, so complaining that you aren't getting enough for free is . . . uncalled for at best.

[mIQe]

Originally Posted by squidsk

Pretty sure, because it would make the code and the queries more complex if it was applying awards retroactively. I'm guessing that the automation is run through a cron job which runs every X period of time. If you want it to run retroactively then you're running an extra query for every single user in the database for every single award that is being automatically awarded. The overhead for that would not be something I'd want on my site.

As for complaining about the support, you do realize that whatever support you're getting, and I believe that just means patches and stuff, you aren't paying a cent for, so complaining that you aren't getting enough for free is . . . uncalled for at best.

Well I guess you and I read different things in to the term support. I read it as this: If a product is supported the customers can come with what ever problems they have with the product and get the help they need to fix the problem. It doesn't matter if it is free or not. What matters is that it is supported or not.

This product is supposed to be supported.

If it does mean what you say that it is just patches and such, then an other word then supported should be used. Such as In Active Development or some thing along those lines. Using supported is misleading in that case.

As for the award automation, it does not work, at all. I've tested with a 1 day membership award and it isn't awarded either. If it is some setting I've not done right or not, I have no idea as the documentation on how to use the product is not 100% on how to set it up. Nor have I gotten support here to sort it out.

As for rewarding automated awards retroactively, if it was a button you could click to start a process to check each member's amount of days as a member once, then it wouldn't be a huge amount of queries that runs all the time. Plus those that wouldn't like to use that function could choose not to. But since it's not working at all this is all just wishful thinking.