Add-On Releases - Yet Another Awards System

vBulletin 4 version can be found here: https://vborg.vbsupport.ru/showthrea...highlight=YAAS

DESCRIPTION:
This is a Medals/Awards system. Admin/Mods 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)
+ Issue awards to members, based on username or userid, with Issue Reason
+ Recommend awards for members based on username, with Recommend Reason
+ Remove awards from members
+ Issue Point Values to awards (Recommended that you are running mySQL 5.0 or higher, will not work correctly with lower versions of mySQL)
+ Award automation

In ModCP
+ Issue awards to members, based on username or userid, with Issue Reason
+ Remove awards from members

Front page
- Display awards list in with: Award Name, Description, Icon, Image, and Members who get each award.
- Display awards showcase in profile within a TAB, with Award information, Issue time and reason
- Display award icons in postbit or under sig.

CHANGES/MODIFICATION:

3.8.4:

* Fixed - Issuing Awards to users with ' in usernames.
* Fixed - "Award System Settings" SettingGroup name.
* Fixed - Phrases for Award Request/Recommendation Settings.
* Fixed - All templates should be properly cached.
* Fixed - Inactive awards no longer display in postbit.

* Improved - Version Information in AdminCP.
* Improved - Award Name is added to Post/PM Title Recommendations/Requests.
* Improved - Postbit Display Location descriptions.
* Improved - Cleaner awards layout display.
* Improved - Award Submissions Post/PM layout.


3.8.3 Patch 1:

* Fixed - SQL Group By Syntax when Points are enabled



DIFFICULTY LEVEL:
Easy
Time: about 5 minutes
Installer is included (1 product XML)

Upload files and import xml.

When upgrading: re-upload ALL files and re-import XML

This MOD is 100% Supported.

Authors of YaAS 3.8:
Xanlamin
CypherSTL

Current Release: v3.8.4 Newest Release

[DarkArmada]

Originally Posted by Xanlamin

Did you allow overwrite?

Yes I did allow overwrite

[RobbieZ]

Im getting a database error when the Point system is activated. Any ideas?

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
FROM award a, award_user au
WHERE (au.userid = 19) 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
Request Date : Tuesday, February 2nd 2010 @ 07:41:55 PM
Error Date : Tuesday, February 2nd 2010 @ 07:41:56 PM
Script : http://www.*********.com/showthread.php?p=150996
Referrer : http://www.*********.com/index.php
IP Address : ********
Username : Admin
Classname : *********
MySQL Version : 5.0.67-community

[gamerfu]

Originally Posted by Xanlamin

Check your postbit template, in ours there are no underscores so they should not be appearing.

postbit_what?

I am not sure what I am looking for. None of my text are highlighted, they are all showing greyed out as if there was no changes made to the core postbit templates.

[Erica1977]

Question Whats The Total Points for how does that work thanks.

[Xanlamin]

Originally Posted by gamerfu

postbit_what?

I am not sure what I am looking for. None of my text are highlighted, they are all showing greyed out as if there was no changes made to the core postbit templates.

The mod itself will edit your postbit and postbitleg templates

Originally Posted by Erica1977

Question Whats The Total Points for how does that work thanks.

The points just assign a point value to the award, and in the users profile for the awards it will output a total points for all the awards the user has that has points assigned to them. It is not for anything special just something to make it more appealing.

[smartkidbk5]

Great addon with the points thing. I just downloaded the update. Any way to view a list of all users sorted by most points? Thanks.

[Xanlamin]

Not at this time.

[Farsisat]

hi.
thanks for this plugin.

the problem white this is for send requast awrad.when user send the request error was show : cannot find this user : 1. 1

help me plz.

[dknelson]

This is a great mod and we use it a lot. The only problem I have ever had with it is that if a username contains a symbol...example: John's Bride....the apostrophe causes an error. I've never said anything about it because the simple workaround is to use the member's number instead of the username but just decided to mention it.

[Xanlamin]

try upgrading to the latest release (3.8.4), this has been addressed already.