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

[JohnChapman]

MemberList question... I've just upgraded to vb 3.8.11, and YaAS 3.8.4. With the show awards in member list option turned on... the member list takes 2 seconds per row to fill the page and..the awards don't show. With it turned off, i get 30 rows back subsecond...

Any ideas?

[jskoh]

having this error

Deprecated: Assigning the return value of new by reference is deprecated in /home2/jskoh/public_html/domain.com/forums/admincp/award_version_info.php on line 17

and

Database error in vBulletin 3.8.10 Beta 1:

Invalid SQL:

SELECT a.*, au.*
FROM award a, award_user au
WHERE (au.userid = 14627) AND (a.award_id=au.award_id) AND (a.award_active=1)
ORDER BY issue_time desc;

MySQL Error : Table 'jskoh_domain.award' doesn't exist
Error Number : 1146
Request Date : Thursday, April 9th 2020 @ 08:57:39 AM
Error Date : Thursday, April 9th 2020 @ 08:57:39 AM
Script : http://domain.com/forums/showthread.php?t=3337
Referrer : http://domain.com/forums/
IP Address : 138.75.3.244
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.6.41-84.1

[drsolomon1990]

It is not working with vbulletin 3.8.7 ( Anyone can make one for version 3.8.7 ?