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

[racingsolution]

Cool Thanks for supporting your mod.. My members really enjoy it

[xorex]

Thanks

[Charles_1]

I am using YAAS for long time already and becouse I have vBulletin v3.8.3 and the idea of points for awards is great, I just installed YAAS v3.8.3 (downloaded 30 minutes ago). But now I have these database errors caused by users with some awards from earlier:

Database error in vBulletin 3.8.3:

Invalid SQL:

						SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
						FROM award a, award_user au
						WHERE (au.userid = 46060) AND (a.award_id=au.award_id);

MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Forum is running fine but when is loaded some thread or post with user with some award, the database error appear. I have to disable YAAS for now. Any suggestion to solve this problem please?

[CypherSTL]

Originally Posted by Charles_1

I am using YAAS for long time already and becouse I have vBulletin v3.8.3 and the idea of points for awards is great, I just installed YAAS v3.8.3 (downloaded 30 minutes ago). But now I have these database errors caused by users with some awards from earlier:

Database error in vBulletin 3.8.3:

Invalid SQL:

                        SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
                        FROM award a, award_user au
                        WHERE (au.userid = 46060) AND (a.award_id=au.award_id);

MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Forum is running fine but when is loaded some thread or post with user with some award, the database error appear. I have to disable YAAS for now. Any suggestion to solve this problem please?

Running into this problem on the 4.0 release as well. All I can recommend until I can get a fix, is to Disable the point system.

[CypherSTL]

Just curious Charles, what version of MySQL are you running?

[Charles_1]

Originally Posted by CypherSTL

Just curious Charles, what version of MySQL are you running?

MySQL Version 4.1.20

[NachoTPAO]

Awesome mod, could you make it possible that some awards are automatically given upon meeting some value such as having registered 2 years ago or having 1000 posts or being promoted to moderator and so? It would be very useful for medium-big forums like mine (15.000 members,800k Posts) so that the mod team doesnt have to give them manually. Bye!

[racingsolution]

Originally Posted by NachoTPAO

Awesome mod, could you make it possible that some awards are automatically given upon meeting some value such as having registered 2 years ago or having 1000 posts or being promoted to moderator and so? It would be very useful for medium-big forums like mine (15.000 members,800k Posts) so that the mod team doesnt have to give them manually. Bye!

Hm I like this.. it could be incorporated into a cron job to update members daily

[gunboard]

Hi,

sinse i have updated i have "_" between the award icons in postbit. else there is a blank line in
the admincp > setup menu.

[Xanlamin]

mySQL grouping erros resolved. Download newest zip and reimport the xml.