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

[mk craig 42]

Okay, so I always attempt things myself before seeking help, I usually succeed, after various hours.. However I've been at this now for coming up to 4 hours now and I'm baffled.

Attached is a file of the tab "My Awards" - My aim is to remove the "Icons" section, and simply just have "Image" "Description" and "Actions"

Image would be the image
Description would be the name of the award and date issued and reason issued
& actions would be Recommend & Request link

Would be GREAT if someone could help me on this! Let me know if you need any of my templates, but here is my awards_userawards_bit template

PHP Code:

<tr>

<if condition="$vboptions[aw_showicon]">
    <td class="$bgclass" align="center">
        <img src="$award[award_icon_url]" border="0">
    </td>
</if>

<if condition="$vboptions[aw_showimage]">
    <td class="$bgclass" align="center">
        <a name="award$award[award_id]"></a>
        <img src="$award[award_img_url]" alt="$award[award_name]" border="0">
    </td>
</if>

<if condition="$vboptions[aw_showdesc]">
    <td class="$bgclass"><b><a href="awards.php?do=viewaward&award_id=$award[award_id]">$award[award_name]</a></b>
        <div class="smallfont">$award[award_desc]
        <hr>
        $vbphrase[award_name]: <b>$award[award_name]</b><br>
        $vbphrase[award_description]: <i><b>$award[award_desc]
        </div>
    </td>
</if>

<if condition="$vboptions[aw_actioncolumn]">
    <td class="$bgclass" align="center" nowrap>
<if condition="$vboptions[aw_requestaward]">
<if condition="$award[award_allowrequest]">
        <a href="request_award.php?$session[sessionurl]award_id=$award[award_id]">$vbphrase[request_award]</a>
</if>
</if>
<if condition="$vboptions[aw_recommendaward]">
<if condition="$award[award_allowrecommend]">
        <br /><a href="recommend_award.php?$session[sessionurl]award_id=$award[award_id]">$vbphrase[award_recommend_award]</a>
</if>
</if>

    </td>
</if>

</tr> 


and this one is the original that works, but not really how I want it

PHP Code:

<tr>
    <td class="$bgclass" align="center">
        <img src="$award[award_icon_url]" border="0">
    </td>

    <td class="$bgclass" align="center">
        <a href="awards.php?$session[sessionurl]#award$award[award_id]">
        <img src="$award[award_img_url]" border="0"></a>
    </td>

    <td class="$bgclass" valign="top">
        <a name="aw_issue$award[issue_id]"></a>
        $vbphrase[award_name]: <b>$award[award_name]</b><br>
        $vbphrase[award_description]: <i><b>$award[award_desc]</b></i>

        <fieldset class="fieldset">
            <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
            <tr>
                <td>
                    <i>$vbphrase[award_reason]: $award[issue_reason]</i><br>
                    <i>$vbphrase[award_time]: $award_issue_date $award_issue_time
                </td>
            </tr>
            </table>
        </fieldset>

    </td>
</tr> 


[Tree Guardian]

Is it possible or anyone would know how to implement statistics of awards given to members,
just which member has how many awards?

Thanks in advance.

[Hamma]

Is there a way to display x awards on a line then do a line break in postbit?

[HazeCork]

I still receive this issue:

There's some error when sending your award request. Please contact site's administrator for assistant.

And the usergroup settings are fine.

[Taleempoint]

thankx

[Fireballx]

hi. installed. but have a problem that award manager is not showing in the admincp sidebar. Its showing in the settings option and in modcp, but cant see it in admincp :P

[squidsk]

Did you upload all of the files from the upload folder into your forum root? It sounds like the xml file for cpnav (in the includes directory I believe) did not get uploaded.

[Fireballx]

Originally Posted by squidsk

Did you upload all of the files from the upload folder into your forum root? It sounds like the xml file for cpnav (in the includes directory I believe) did not get uploaded.

Yes, that was the problem. Thanks a lot

[Irishnotsane]

I've installed this many times on different forums, and I can't figure out why I get a DB error on this one.. I run 3.8.4 Patch 10 I believe. Some help would be great as I really need this modification! Thanks

Database error in vBulletin 3.8.4:

Invalid SQL:

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

MySQL Error   : Table 'forum.award' doesn't exist
Error Number  : 1146
Request Date  : Monday, June 11th 2012 @ 04:02:46 AM
Error Date    : Monday, June 11th 2012 @ 04:02:46 AM
Script        : http://forum.mysite.com/showthread.php?t=29
Referrer      : 
IP Address    : 173.245.53.65
Username      : Myusername
Classname     : vB_Database
MySQL Version : 5.5.20-log

[Lon]

Originally Posted by Irishnotsane

I've installed this many times on different forums, and I can't figure out why I get a DB error on this one.. I run 3.8.4 Patch 10 I believe. Some help would be great as I really need this modification! Thanks

Database error in vBulletin 3.8.4:

Invalid SQL:

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

MySQL Error   : Table 'forum.award' doesn't exist
Error Number  : 1146
Request Date  : Monday, June 11th 2012 @ 04:02:46 AM
Error Date    : Monday, June 11th 2012 @ 04:02:46 AM
Script        : http://forum.mysite.com/showthread.php?t=29
Referrer      : 
IP Address    : 173.245.53.65
Username      : Myusername
Classname     : vB_Database
MySQL Version : 5.5.20-log

It seems in the new PhPMyAdmin version/MySQL, changes were made that affected the way queries were ran and now isn't compatible with the newest version.

You either have to alter the query within the XML or create the tables and columns manually until a fix is made.