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

[CypherSTL]

Originally Posted by racingsolution

Well by deleting the function function construct_depth_mark from awards.php it fixes the problem.

Most likely, now if you have multiple category sections, some of the category names will be doubling up.

[robdawg]

Is anyone else having a problem where the dropdown in the vBulletin Options Admin Section has a blank entry for this Awards Manager?

[gunboard]

Hi,

how i can delete the ascii 31 (_) between the award icons in postbit ?

[Speysider]

Originally Posted by robdawg

Is anyone else having a problem where the dropdown in the vBulletin Options Admin Section has a blank entry for this Awards Manager?

I'm having this problem as well.

[Xanlamin]

Have you tried to re-import the XML to overwrite to see if this solves this error, so far I have been unable to reproduce this problem.

[DarkArmada]

Stupid question, but what do the points actually do? I'm running vbExperience which manages my point system - is there a plugin available to add the points to vbE?

[Xanlamin]

You can assign a point value to the awards, once the user reaches a certain point structure they will receive the corresponding award.

[Cars2007]

Originally Posted by Xanlamin

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

We are still having the same issue with the latest version of the plugin. Any ideas?

Downloaded YaAS-3.8.3.1.zip from the link above.

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 = 4981) 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
Error Number  : 1140

[CypherSTL]

From looking at the database error, it would seem that it isn't using the new query.

Have you re-imported the XML?

It should be using this query:

SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
FROM ' . TABLE_PREFIX . 'award a, ' . TABLE_PREFIX . 'award_user au
WHERE (au.userid = '.$this->profile->userinfo['userid'].') AND (a.award_id=au.award_id) AND (a.award_active = "1")
GROUP BY au.userid

[gunboard]

Originally Posted by Xanlamin

Have you tried to re-import the XML to overwrite to see if this solves this error, so far I have been unable to reproduce this problem.

yes i have tried to reimport the Mod. Does not fix the problem. Sorry for my bad english