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

[RobbieZ]

Thank you good sir

[PirateTinman]

Is there any way to get this mod to be displayed to the left of the Join Date and Post, in the user information field?
----------------------------------------------------------------------- like right above threre ^
I would make the page look allot slimer instead of having it under all the information.
I am sure it is possible, but I have no idea on how to move it to that location, I guess I would need to replace some code, if anyone knows how to do this I would be very greatfull.

Thanks!

[Biker_GA]

Just move the code in your postbit template to the location where you want the award to appear.

[PirateTinman]

Thanks for the response, but I did not get allot closer, would you mind tell me what file I need to edit, one of the YAAS postbits or one of the one for my forum style, havent done allot of modifying, and what code am I supposed to move?

[HolyKiller]

Fine mod, but i get one Warning if i giving avard to some user.

Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in [path]/adminpanel/award.php on line 581

Award is given, PM sended, everything looks fine, but that messages... i don't know what is wrong.

Thanks

Holy

[Biker_GA]

Originally Posted by PirateTinman

Thanks for the response, but I did not get allot closer, would you mind tell me what file I need to edit, one of the YAAS postbits or one of the one for my forum style, havent done allot of modifying, and what code am I supposed to move?

I did state which template to edit. Postbit

Find the snippet of code that places the award into the template, and move it to the location where you want it to appear in the template.

[Biker_GA]

Originally Posted by HolyKiller

Fine mod, but i get one Warning if i giving avard to some user.

Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in [path]/adminpanel/award.php on line 581

Award is given, PM sended, everything looks fine, but that messages... i don't know what is wrong.

Thanks

Holy

You've made an error somewhere during the installation. Triple check your installation and edits.

[fourat]

hi
when i put Userid for Congratulation PM ... the PM sent to user but the sender is number of the id not the name !!
when i put the id no. 1 its name is "fourat" the pm's sender name shown in the private messeges is "1" .. not "fourat"
when members try to replay this messege the forum say:
The following errors occurred with your submission
The following users were not found: 1

how i fix this problem ?

[muslimmomscafe]

Hello,

I gave a user an award, and it says on the "Users that already received award" her username but it wont show in her postbit. Why is that? I have given awards to other members and theirs did show on the postbit.

thanks

[cermi]

Originally Posted by HolyKiller

Fine mod, but i get one Warning if i giving avard to some user.

Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in [path]/adminpanel/award.php on line 581

Award is given, PM sended, everything looks fine, but that messages... i don't know what is wrong.

Thanks

Holy

The problem is in the mod source. The author "hardcoded" usage of (now deprecated, but that's not the point) mysql_insert_id(). But vB can use both mysql and mysqli API. And when you switch vB to new mysqli API, the problem appears:

1. mysql_insert_id() is called without parameters, so it's supposed to take last opened mysql connection (opened from "old" mysql api)
2. but there is no mysql connection, all connetions were opened by mysqli api
3. "no worries!", says php, "we make new connections", so it tooks db credentials from php.ini and tries to make new connection
4. but credentials in php.ini are usually empty, therefore the connection fails and mysql_insert_id() fails with it

Solution? I don't want to be rude, but hardcoding 1 api when vB is capable of running of 2 different APIs isn't the cleanest way. The cleanest way would be to use vB's build-in class and call some *insert_id() wrapped (if exists) or to dig the mysql(i) link object from vB's classes and use it directly in consideration of selected mysql API in vB conf. Or perhaps something better There are always many solutions to those kinds of problems.

But it's nice mod, anyway