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

[daviblight]

i just an odd error...

Database error in vBulletin 3.6.5:

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,1331380,1331426,1331429,1331508,1331510,1331542 ,1331851,1334085,1334399,1334432,1334436,1334446,1 334460,1334503,1334505,1334614,1334806,1335043,133 8530,1338533,1338581,1338616,1338693,1342940,13429 68,1344396)

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

MySQL Error : Unknown column 'a.award_id' in 'on clause'
Error Number : 1054
Date : Monday, June 4th 2007 @ 09:42:07 AM
Script : http://www.conceptart.org/forums/showthread.php?t=98016
Referrer : http://www.conceptart.org/forums/forumdisplay.php?f=2
IP Address : 66.72.161.124
Username : davi
Classname : vb_database

[IR15H]

I installed and it all seemed to go well, however when I give someone a medal I get the following error;

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

It gives the award anyway, and appears in memberlist/posbit but when I try to view a member's profile it returns a white screen. I saw someone else mis edited the MEMBERINFO template, so I double checked mine and it was correct. I even reverted it to it's original state and tried clicking the profile anyway (assuming I'd see the user profile but no award stuff), but that still gave a white screen. When I remove the user's medal I can see their profile again. This is on 3.6.7. Help?

[santimariani]

This may seem like a dumb question, but...

How do I get to the Awards List page? I can't seem to find it anywhere.

Thanks!

EDIT: Found it. It's amazing what looking well for something will do.

[IR15H]

Well, it's been over 24 hours so I guess it's ok to bump...

Originally Posted by IR15H

I installed and it all seemed to go well, however when I give someone a medal I get the following error;

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

It gives the award anyway, and appears in memberlist/posbit but when I try to view a member's profile it returns a white screen. I saw someone else mis edited the MEMBERINFO template, so I double checked mine and it was correct. I even reverted it to it's original state and tried clicking the profile anyway (assuming I'd see the user profile but no award stuff), but that still gave a white screen. When I remove the user's medal I can see their profile again. This is on 3.6.7. Help?

[PoetJA-1975]

Thanx very much MTHA for this modification.
Planning on making it a Major Feature on JPiC
**INSTALLED**

Jacquii.

[masons]

Several things that could possible make a good add-on to this amazing mod.

Could you please make it possible for members to know about the different awards that are available in an area that they can readily access it should they desire to do so.

Can this area also have a recommend an award to someone area so that if someone wants to make a recommendation, they can.

Can we have a "Hall of Honor" to display those people who have won awards.

Can we also have something saying that we are prepared to make up a new award should there be a need recommended through PM to admins.

Let me know what you think!

[BigDog56]

Got it working, great mod, was looking for this one! Thank you very much!

[kennethsia]

works fully functional on 3.6.5 please guys follow all the steps, upload files. upload product. DO the styles edit first. then start messing with the awards. test it out before u start editing the settings. great great mod.

[wrang]

Witch database prefix do this mod upload
I want to delete it from my database

is this the thing or is it more?
vb3_award
vb3_award_cat
vb3_award_user

[powerful_rogue]

Any idea where to get the really small award icons? Ive searched high and low and can only find the large ones.