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

[masons]

Can someone integrate this so it shows up in ZOINTS profiles too?

[masons]

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 post.postid IN (0,5288,5244,5169,5161,5158,5154,5142,4651,4291,42 50) GROUP BY post.postid

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

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 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 05:53:15 AM
Script : http://www.novusordosaeculorum.com/s...34.html?p=5288
Referrer : http://www.novusordosaeculorum.com/
IP Address : 124.86.224.8
Username : Mike
Classname : vB_Database

[Phooey]

Originally Posted by KristerSwe

Hello all

Sharing my PSD here for you to play with. the psd file is sliced so if you make changes
you can easy "save optimized as" and they are splitted and named .....

Hope you guys liked them enjoy ...

Regards Krister

You rock.

[masons]

The above error disappears when I turn off the POSTBIT function in the admin area!

[Necrosaro420]

Will this run on vb 3.6.4? Also, I use Postbit, (not legacy) will this work? Thanks!

[toucan42]

Originally Posted by masons

The above error disappears when I turn off the POSTBIT function in the admin area!

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 post.postid IN (0,11332,11334,11336,11337,11338) GROUP BY post.postid

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

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 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 11:04:22 PM
Script : http://www.talkwhatever.com/showthread.php?p=11338
Referrer : http://www.talkwhatever.com/index.php
IP Address : 72.92.141.48
Username : admintw42
Classname : vb_database

For me this occurs when I turn ON postbit - assuming it is the double GROUP BY but not sure how to fix that in the product.

[toucan42]

On member.php there is a problem also where it shows the small awards showcase:

Awards Showcase
The Ladybug Award: For excellent posts

Congratulations!" border="0" />

Issue with quotes in the "Reason" field?

[mtha]

Originally Posted by masons

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 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7

Originally Posted by toucan42

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 post.postid IN (0,11332,11334,11336,11337,11338) GROUP BY post.postid

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

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 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 11:04:22 PM
Script : http://www.talkwhatever.com/showthread.php?p=11338
Referrer : http://www.talkwhatever.com/index.php
IP Address : 72.92.141.48
Username : admintw42
Classname : vb_database

For me this occurs when I turn ON postbit - assuming it is the double GROUP BY but not sure how to fix that in the product.

Do you have some other hack that replace the $postids value and add a GROUP BY post.postid ?


please check what's other hacsk using this hook location: showthread_query

[toucan42]

I'm not sure but by simply removing the GROUP BY in the product XML and replacing with a comma I was able to get it working.

[howard11]

Great Mod really chuffed about it Thanks