Major Additions - Yet Another Awards System 2.1.4

Yet Another Award System 2.1.4 ? by HacNho
Copyright (C) 2005 by HacNho, All rights reserved.

Hack Version: 2.1.4.070324
Compatible vB version: 3.6.x
Support: https://vborg.vbsupport.ru/showthread.php?t=142487

for vBulletin 3.5.x:
https://vborg.vbsupport.ru/showthread.php?t=94836
For vBulletin 3.0.x, please check the other version:
https://vborg.vbsupport.ru/showthread.php?t=78934

DESCRIPTION:
This is a Medals/Awards system. Admin 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)
- Can re-order awards in awards showcase
+ Issue awards to members, based on username or userid, with Issue Reason
+ Remove awards from members
- [1.2] Options to set number of awards displayed in postbit
- [1.2] Options to turn on/off showing award icon, images, award requests in awards list, awards icons in memberlist
- [2.1.3] Notify awarded user by PM/email
- [2.1.4] Option to turn on/off Award System in ModCP

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, with Award information, Issue time and reason
- Display award icons in postbit (showthread, showpost, announcement, private)
[1.2] Display limit awards in postbit, with total awards, and a link to awards showcase in member profiles.
[1.2] Award request, link to a form sending to email/PM/new thead or post (based on Dr Erwin Loh's Form hack)
[1.2] Display award on Memberlist page (by trulylowcarb)

CHANGES/MODIFICATION:
- Tables to add: 3 (award, award_user, award_cat)
- Files to add: 4 (/awards.php, /award_request.php, /admincp/award.php, /admincp/award_cat.php)
- Files to edit: 8 (/admincp/index.php, member.php, showthread.php, showpost.php, announcement.php, private.php, memberlist.php, /include/functions_online.php)
- Templates to edit: 5 (MEMBERINFO, postbit, postbit_legacy, memberlist, memberlist_resultsbit )

DIFFICULTY:
Easy
Time: about 5 minutes
Installer is included (1 product XML)


CREDIT:
Idea has been carried on by many people, here are some:
- Lesane for original Award hack for vB2, eventhough I've never use his hack
- AnimeWebby for Awards/ Medals/ Cards Hack [vB3], which I write new code based on his.
- Mac ycl6 for phpBB Medal System for phpBB forum
- Dr Erwin Loh for FORM TO THREAD/ FORUM/ PM/ EMAIL hack
- and all others for supports and ideas

[SVTCobraLTD]

Originally Posted by letsjoy

Please launch for 3.7+...we will be thank ful

One page back had this... https://vborg.vbsupport.ru/showthread.php?p=1594424

[saviola8x]

Mark as Installed.

[Jelmertjee]

I wasn't really satisfied with the postbit awards position so decided to add one manually myself, it looks like this:



How can you do it?

1. open the postbit template and add a new hook where you want the awards, in my case it was the <td> between the left and right of the userinfo, for me it looked like this:

<td width="100%">$template_hook[postbit_userinfo_center]</td>

Such a hook is just an identifier for all sorts of plugins so they can add stuff to templates automatically, now we need to tell our plugin to use this new hook.

2. in your admincp go into plugins, under awards open YAAS in Posbit

Now replace:

			{
				eval('$template_hook[\'postbit_userinfo_right\'] .= "' . fetch_template('awards_postbit_display') . '";');
			}

with:

			{
				eval('$template_hook[\'postbit_userinfo_center\'] .= "' . fetch_template('awards_postbit_display') . '";');
			}

I'm assuming you're using the default position in your award settings (admincp), we're basically changing it to the hook we've just made in the template, that's all.

I also added some custom css to better style this, first open the template awards_postbit_display, I've changed it like this, adding a div with a class around it to get some css control:

<!-- show awards -->
<if condition="$post[showuserawards]">
<div class="postbit_awards">
<fieldset><legend><a href="member.php?u=$post[userid]&tab=myawards" title="$vbphrase[more_awards]">$vbphrase[award_showcase]</a></legend>
<div>
$post[userawards]
<br>
<a href="member.php?u=$post[userid]&tab=myawards" title="$vbphrase[more_awards]">$vbphrase[total_awards]</a>: $post[num_awards]
</div>
</fieldset>
</div>
</if>
<!-- /show awards -->

Then add this bit of css to your custom css definitions:

.postbit_awards{float: left}

of course you can adjust this further to your liking, this makes it float to the left instead of the full width, you could also use float:right instead.

This looks a lot better and saves space, hope you like it.

[TheLastSuperman]

Originally Posted by Jelmertjee

I wasn't really satisfied with the postbit awards position so decided to add one manually myself, it looks like this:



How can you do it?

1. open the postbit template and add a new hook where you want the awards, in my case it was the <td> between the left and right of the userinfo, for me it looked like this:

<td width="100%">$template_hook[postbit_userinfo_center]</td>

Such a hook is just an identifier for all sorts of plugins so they can add stuff to templates automatically, now we need to tell our plugin to use this new hook.

2. in your admincp go into plugins, under awards open YAAS in Posbit

Now replace:

			{
				eval('$template_hook[\'postbit_userinfo_right\'] .= "' . fetch_template('awards_postbit_display') . '";');
			}

with:

			{
				eval('$template_hook[\'postbit_userinfo_center\'] .= "' . fetch_template('awards_postbit_display') . '";');
			}

I'm assuming you're using the default position in your award settings (admincp), we're basically changing it to the hook we've just made in the template, that's all.

I also added some custom css to better style this, first open the template awards_postbit_display, I've changed it like this, adding a div with a class around it to get some css control:

<!-- show awards -->
<if condition="$post[showuserawards]">
<div class="postbit_awards">
<fieldset><legend><a href="member.php?u=$post[userid]&tab=myawards" title="$vbphrase[more_awards]">$vbphrase[award_showcase]</a></legend>
<div>
$post[userawards]
<br>
<a href="member.php?u=$post[userid]&tab=myawards" title="$vbphrase[more_awards]">$vbphrase[total_awards]</a>: $post[num_awards]
</div>
</fieldset>
</div>
</if>
<!-- /show awards -->

Then add this bit of css to your custom css definitions:

.postbit_awards{float: left}

of course you can adjust this further to your liking, this makes it float to the left instead of the full width, you could also use float:right instead.

This looks a lot better and saves space, hope you like it.

AND... you know you can remove the border and text and display just the image right

See here for a similar code reference --> https://vborg.vbsupport.ru/showpost....57&postcount=3

So basically the Rank or in this mods case.. Awards would be displayed just as the images themselves and between your guns image and your name!

[TheLastSuperman]

Originally Posted by gamerfu

Make this suggestion for the YAAS 4.0. Very nice suggestion. I have this delima too.

Hmmmmm, nice suggestion.... I'll look into this for the Rank mod I support and get back to ya as I will add it into my Award Mod when I do!

[bluesoul]

Sorry for not perusing the entire thread but is there a simple way to remove either the icon or image column from being displayed? I don't really need both for what we're using it for.

EDIT: Got it, reading through the settings is pro.

[SVTCobraLTD]

On 3.6.11 I try and give an award but the keeps saying

Content Encoding Error         

The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.        

The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.

    * Please contact the website owners to inform them of this problem.

when trying to access "http://sitename.com/forums/admincp/award.php?do=dogiveaward".

Any ideas? I have given away more than 20 awards without any problems. It happens both in firefox and IE.

[home9000]

Originally Posted by Simetrical

This is a nice mod. Unfortunately, it crashed my site when this query was run repeatedly during a period of high load (23 times over, running between 78 and 208 seconds, as of just before I started killing them):

mysql> EXPLAIN SELECT a.*, au.*, post.userid, post.postid 
    ->                         FROM post AS post
    ->                         INNER JOIN award_user AS au ON (au.userid=post.userid)
    ->                         INNER JOIN award AS a ON (a.award_id=au.award_id)
    ->                         WHERE 1=1 
    -> 
    -> 
    ->                         GROUP BY au.issue_id
    ->                         ORDER BY au.issue_time DESC;
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
| id | select_type | table | type   | possible_keys | key     | key_len | ref                     | rows  | Extra                           |
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
|  1 | SIMPLE      | au    | ALL    | NULL          | NULL    | NULL    | NULL                    |   117 | Using temporary; Using filesort | 
|  1 | SIMPLE      | a     | eq_ref | PRIMARY       | PRIMARY | 2       | totalwar_vb.au.award_id |     1 | Using where                     | 
|  1 | SIMPLE      | post  | ref    | userid        | userid  | 4       | totalwar_vb.au.userid   | 25005 | Using where                     | 
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
3 rows in set (0.00 sec)

While I'm no MySQL expert, it seems that this attempts to copy the entirety of the post table to a temporary table, in my case about 1.5 million rows. I've tracked the query down to the showthread_query hook:

PHP Code:

        // Obtain list of awards for current user
        $alluserawards =  $db->query_read("
            SELECT a.*, au.*, post.userid, post.postid 
            FROM " . TABLE_PREFIX . "post AS post
            INNER JOIN " . TABLE_PREFIX . "award_user AS au ON (au.userid=post.userid)
            INNER JOIN " . TABLE_PREFIX . "award AS a ON (a.award_id=au.award_id)
            WHERE 1=1 
". iif((!empty($ids)), "AND post.postid IN (0" . $ids . ")") ."
". iif((!empty($cache_postids)), "AND post.postid IN (" . $cache_postids . ")") ."
            GROUP BY au.issue_id
            $awardsdisplayorder
        ");

        while( $ua = $db->fetch_array($alluserawards))
        {
            $userawardscache[$ua['userid']][$ua['issue_id']] = $ua;
        }
        $db->free_result($alluserawards); 


Apparently this fails to account for the possibility that $ids and $cache_postids are both empty. I have no idea why it would or would not be reasonable to account for that, because I don't know what either of those variables is, but at any rate, if they both are empty things are not very good. I've wrapped the whole thing in a conditional checking whether both are empty, just not setting anything if they both are. I'd appreciate any response.

I have the same problem any solution or workaround ?

[home9000]

Originally Posted by Simetrical

This is a nice mod. Unfortunately, it crashed my site when this query was run repeatedly during a period of high load (23 times over, running between 78 and 208 seconds, as of just before I started killing them):

mysql> EXPLAIN SELECT a.*, au.*, post.userid, post.postid 
    ->                         FROM post AS post
    ->                         INNER JOIN award_user AS au ON (au.userid=post.userid)
    ->                         INNER JOIN award AS a ON (a.award_id=au.award_id)
    ->                         WHERE 1=1 
    -> 
    -> 
    ->                         GROUP BY au.issue_id
    ->                         ORDER BY au.issue_time DESC;
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
| id | select_type | table | type   | possible_keys | key     | key_len | ref                     | rows  | Extra                           |
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
|  1 | SIMPLE      | au    | ALL    | NULL          | NULL    | NULL    | NULL                    |   117 | Using temporary; Using filesort | 
|  1 | SIMPLE      | a     | eq_ref | PRIMARY       | PRIMARY | 2       | totalwar_vb.au.award_id |     1 | Using where                     | 
|  1 | SIMPLE      | post  | ref    | userid        | userid  | 4       | totalwar_vb.au.userid   | 25005 | Using where                     | 
+----+-------------+-------+--------+---------------+---------+---------+-------------------------+-------+---------------------------------+
3 rows in set (0.00 sec)

While I'm no MySQL expert, it seems that this attempts to copy the entirety of the post table to a temporary table, in my case about 1.5 million rows. I've tracked the query down to the showthread_query hook:

PHP Code:

        // Obtain list of awards for current user
        $alluserawards =  $db->query_read("
            SELECT a.*, au.*, post.userid, post.postid 
            FROM " . TABLE_PREFIX . "post AS post
            INNER JOIN " . TABLE_PREFIX . "award_user AS au ON (au.userid=post.userid)
            INNER JOIN " . TABLE_PREFIX . "award AS a ON (a.award_id=au.award_id)
            WHERE 1=1 
". iif((!empty($ids)), "AND post.postid IN (0" . $ids . ")") ."
". iif((!empty($cache_postids)), "AND post.postid IN (" . $cache_postids . ")") ."
            GROUP BY au.issue_id
            $awardsdisplayorder
        ");

        while( $ua = $db->fetch_array($alluserawards))
        {
            $userawardscache[$ua['userid']][$ua['issue_id']] = $ua;
        }
        $db->free_result($alluserawards); 


Apparently this fails to account for the possibility that $ids and $cache_postids are both empty. I have no idea why it would or would not be reasonable to account for that, because I don't know what either of those variables is, but at any rate, if they both are empty things are not very good. I've wrapped the whole thing in a conditional checking whether both are empty, just not setting anything if they both are. I'd appreciate any response.

I have to remove this hack because this issue
It's make my site down 10 time per day

I am looking to another hack

Thank for you all

[Tarfandestan]

Hi.
Im using this hack for my forum.
but when I give an award to one of users, it doesn't show in his/her posts.
and when I give an award to one of moderators, its correctly add to his/her posts.
what's wrong?