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

[Silvio]

ty mta for this great mod i'm using it from last version and is really gorgeous.

now i've upgraded to 3.6.x version and i enabled a setting i did not used on last version so i cant say if is the same issue.

issue : phrases not working (after install they doesnt exists and nor create them) at least from cp options
Enter the userID of the User you would like to appear as sender of the Congratulation PM and/or Email.
Leave it "0" to use userid of the one who issue award
To edit the PM Content, click here, to edit the Subject click here.



i guess the problem is here

To edit the PM Content, click <a href="phrase.php?do=edit&amp;e[3000][award_pm]">here</a>, to edit the Subject click <a href="phrase.php?do=edit&amp;e[4000][award_pm]">here</a>.]]></phrase>

how is possible to fix that?

pls accept apologises for my terrible english

take care
ciao

[es-league.com]

Think I have an error that I hope someone can help with...

I have noticed that only some of the award winning members
have medals displayed in their posts ?

Although the medals are clearly given in the admin cp
and showing as awarded on a particular date,
they even show up in each players user cp but not always
in the posts and threads...

seems a bit random , any ideas ?

[Taios]

Question:
How do i get the medals to be as big as the medals in this forum?
http://www.global-army.com/forum/sho...=9253#post9253

I mean like. When the user posts, they are much bigger. Atm, my forum only shows a minute of the actual thing.

EDIT : figured it out. Just need to do some edits now i guess to change the position fo where its shown

[katie hunter]

Hi I have a small question in the award how can i edit this part ? Name / Description

I want to stretch it more a little or add more words to it other then Name / Description

http://forum.nihonomaru.com/awards.php

Thanks

[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.

[letsjoy]

thanks alot

[kartik786]

thanks a lot.. im going to give it a try soon

[malluroses]

Thanks a lot yaar

[The Librarian]

I've got this mod working but I've got two items I need help fixing:

1) I need to re-arrange the order members are listed on the Awards page. They seem to be listed by MemberID # (order of registration) but I want them in Alphabetical order.

and

2) I got a database error when I tried to give an award to a member with an apostrophe in her name. I'm working on a fix but if someone has information on that it would be appreciated.

Oh, and btw, I corrected the English on the PM message. It should be "Congratulations" (with an "s") and "upon receiving" instead of "as you are receiving".

Thanks!

[The Librarian]

More about #2 above:

Originally Posted by The Librarian

2) I got a database error when I tried to give an award to a member with an apostrophe in her name. I'm working on a fix but if someone has information on that it would be appreciated.

Here's the deal... when I try to award another user (5peaches) I get "you have successfully given MA'AM the award"- so it's giving 5peaches award to MA'AM... and then if I try to give MA'AM an award I get this error message:

Invalid SQL:

SELECT userid, username
FROM vb_user
WHERE username = 'MA'AM';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AM'' at line 3
Error Number : 1064
Date : Thursday, July 19th 2007 @ 08:43:42 PM
Script : http://www.website.com/forum/admincp...do=dogiveaward
Referrer : http://www.website.com/forum/admincp...ers&award_id=9

I'm sure it's because of the appostrophe... does anybody have a fix for this, please?!