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

[Danisty]

Can anybody help me with this? Perhaps post the entire text that should be in the YAAS - Showthread_postbit_create plugin?

[sinisterpain]

Originally Posted by Danisty

Can anybody help me with this? Perhaps post the entire text that should be in the YAAS - Showthread_postbit_create plugin?

$post['userawards'] = '';
  $post['showuserawards'] = false;
  if ($vbulletin->options['aw_postbit'])
  {
      if (is_array($userawardscache[$post[userid]]))
      {
        $aw_i = 0;
        $post['num_awards'] = count($userawardscache[$post[userid]]);
        foreach($userawardscache[$post['userid']] AS $award_id => $award)
        {
          $aw_i++;
          if ($aw_i <= $vbulletin->options['aw_display_limit'])
          {
            eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
          }
        }
        $post['showuserawards'] = true;
      }
    }

[Elfo King]

Hi !
I have a problem with this:

IF on POSTBIT is enabled:

Database error in vBulletin 3.6.4:

Invalid SQL:

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
AND post.postid IN (0,1684)

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

MySQL Error : Colonna sconosciuta 'a.award_id' in 'on clause'
Error Number : 1054
Date : Sunday, April 8th 2007 @ 10:45:07 PM
Script : http://forum.uebb.it/showthread.php?t=371
Referrer :
IP Address : 66.249.72.209
Username : Non registrato
Classname : vb_database

If MEMBERLIST is enabled:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT a.*, au.*
FROM user AS user
INNER JOIN award_user AS au ON (au.userid=user.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputati onlevelid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)


WHERE 1=1
AND user.usergroupid IN (-1,37,38,72,71,9,6,70,52,79,74,51,16,19,64,82,29,69 ,30,56,77,42,28,68,7,15,14,73,84,12,65,80,81,59,60 ,5,26,49,83,50,2,31,78)
GROUP BY au.issue_id;

MySQL Error : Colonna sconosciuta 'a.award_id' in 'on clause'
Error Number : 1054
Date : Sunday, April 8th 2007 @ 11:38:03 PM
Script : http://forum.uebb.it/memberlist.php
Referrer :
IP Address : 62.123.244.184
Username : King™
Classname : vb_database

and...a big problem...if all disabled, in ALL MEMBER PROFILE:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT a.*, au.*
FROM award AS a
LEFT JOIN award_user AS au ON (a.award_id=au.award_id)
WHERE (au.userid = 1874)
ORDER BY au.issue_time DESC;

MySQL Error : Colonna sconosciuta 'a.award_id' in 'on clause'
Error Number : 1054
Date : Sunday, April 8th 2007 @ 10:43:57 PM
Script : http://www.uebb.it/forum/member.php?u=1874
Referrer :
IP Address : 74.6.68.235
Username : Non registrato
Classname : vb_database

Now i have disabled the product for full board function...
Pls...i need fast help to repair..

[Danisty]

Originally Posted by sinisterpain

$post['userawards'] = '';
  $post['showuserawards'] = false;
  if ($vbulletin->options['aw_postbit'])
  {
      if (is_array($userawardscache[$post[userid]]))
      {
        $aw_i = 0;
        $post['num_awards'] = count($userawardscache[$post[userid]]);
        foreach($userawardscache[$post['userid']] AS $award_id => $award)
        {
          $aw_i++;
          if ($aw_i <= $vbulletin->options['aw_display_limit'])
          {
            eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
          }
        }
        $post['showuserawards'] = true;
      }
    }

I'm still getting the following error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /member.php(825) : eval()'d code on line 60

[polo708]

alright, I feel stupid right now... to install this hack I download the zip file on teh first page and do what?... yes im serious, haha. This is my first hack install and im curious/nervous. Looks like a great program.

Im running: VBulletin 3.6.4

[MikeHolohan]

Can anyone tell me if it is possible to give an award to a usergroup rather that a single user... for example I have bronze supporter, silver supporter and gold supporter usergroups.

I created awards for each of these usergroups and wanted to assign an award to each usergroup, any ideas?

Mike.

[Kirkus]

Originally Posted by polo708

alright, I feel stupid right now... to install this hack I download the zip file on teh first page and do what?... yes im serious, haha. This is my first hack install and im curious/nervous. Looks like a great program.

Im running: VBulletin 3.6.4

First you need to "unzip" the file that you downloaded. Then, if you look inside the "Docs" folder you'll see installation instructions. Follow them step by step.

[home9000]

very nice product

I want to change Yes/No/Maybe options in poll to another words where I can found this words

[Danisty]

If I can't get some kind of feedback here I'm just going to uninstall this.

[djchris]

Am I right to say that for this mod, I allow members to vote, and then I see the results of the voters and award the winner?

If so, may I know, how do I view the results of the votes? I can't seem to find the results, and who voted..