Yet Another Awards System 3.5 v2.1.2

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

Hack Version: 2.1.2.051128
Compatible vB version: 3.5.x
Support: 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 ACP
- 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.0] Options to re-order awards in postbit and member's profile
>Order by issued time (newest first)
>Order by issued time (oldest first)
>Order by Award Order (ASC)
>Order by Award Order (DESC)
- [2.1.0] Option to set award in-active. Inactive awards will not be listed in award list. However, it will still be displayed in user's profile, if member has the award.
- [2.1.0] Option to set "Request Award" option for each award. (Need "Show request award column" option ON to see the request link)
- [2.1.0] Set custom usergroup permission, to set which group can request award (access request award page)
- [2.1.0] Option to limit maximum number of users for each award displayed in awards list
- [2.1.0] Change award_request options, all options are set in AdminCP, template and phrase based. Totally cumsomizable
- [2.1.0] Option to send PM to use when he receives an award.

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)
[2.1.0] Display individual award with name of members who receive the award
[2.1.2] Collapse award categories and awards showcase

CHANGES/MODIFICATION:
(to do)
- Files to add: 6 (/awards.php, /award_request.php, /admincp/award.php, /admincp/award_cat.php, /includes/xml/postbbit_awards.xml, /includes/xml/cpnav_awards.xml)
- Templates to edit: 5 (MEMBERINFO, postbit, postbit_legacy, memberlist, memberlist_resultsbit)
(automatic)
- Tables to add: 3 (award, award_user, award_cat)
- Templates to add: 9 ('AWARDS', 'awards_awardbit','awards_awardusers_bit','awards_ bit','awards_userawards_bit','awards_category','aw ards_categorybit', 'awards_request_form', 'awards_request_formanswers')
- Phrases to add: xxx
DIFFICULTY:
Easy
Time: about 2 minutes
Installer is included (1 product XML)

HISTORY:
2005.11.28: 2.1.1 - Add check for errors before sending PMs
2005.11.27: 2.1.0 - Add functions, Change award request options
2005.11.12: 2.0.6 - remove $this->post['userid'] check in showthread
2005.11.02: 2.0.5 - fix error when display non-user's single post
2005.10.16: 2.0.4 - fix display award after quickreply
2005.10.11: 2.0.3 - fix Display award in PM and announcement, change award request template (thanks y2krazy) (https://vborg.vbsupport.ru/showpost....9&postcount=69)
2005.10.07: Allow edit issued award
2005.09.05: Version 2.0.1 bug fix
2005.08.22: Version 2.0.0 for vBulletin 3.5.0
2005.08.18: Version 1.2.12005.04.14: Version 1.2.02005.04.03: Version 1.1
2005.03.29: Version 1.0.1b
2005.03.28: Version 1.0.1
2005.03.28: Initial release

FUTURE PLAN:
- Allow comments on user's award (by Arial)
- Allow voting on user's award (by Arial)
- Allow members to resort awards themselves <trackpad/TosaInu>

<done>
x. PM (/Email) user when he/she get an award. <2.1.0>
x. Allow awards to be resorted <trackpads> <2.1.0>
x. Allow admin to choose which awards have the 'request awards' link <trackpads> <2.1.0>
x. Allow/disallow certain awards for certain usergroups <trackpads> <2.1.0>


ADD ONs
How-to for importing from phpBB's Medal System Mod
https://vborg.vbsupport.ru/showpost....&postcount=171

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


IMPORTANT:
- BACKUP modified files and templates before making changes.
- Backup database is recommended.
- This hack is NOT compatible with AnimeWebby's Awards/Medals/CardsHack [vB3], you need to UNINSTALL his hack, before installing this one.

INSTALLATION:
Read INSTALL.txt

UPGRADE:
Reimport XML product
Upload files if neccessary (keep the configuration)

upgrade 2.1.1: Reupload files + Reimport XML product
upgrade 2.1.2: Reupload files + Reimport XML product + reEdit templates (MEMBERINFO, postbit/postbit_legacy, memberlist_resultsbit)


UNINSTALL:
Click Uninstall in Product Manager, and undo the template changes

MANUAL:
Included in zip file

SCREENSHOT:
https://vborg.vbsupport.ru/showpost....25&postcount=2

DEMO:
vB 3.5.x
<removed on owners request>

vB 3.0.x
http://www.global-army.com/forum/awards.php
http://www.global-army.com/forum/sho...=9253#post9253
http://www.global-army.com/forum/member.php?u=22#award

DONATIONS:
YAAS is free, but a donation of any amount is much appreciated.


SERVICE:
Installation service is available upon request

[carpzone]

Tnx MTornback I can use it.

Sombody nows how to fix my problem, i can't find it

[mtha]

Thanks, Gaskell for your help on support. good that you love the hack


for translation, edit phrase: award_pm on Email Subject Text
Congratulation! You have got a new award!

Originally Posted by MThornback

If anyone wants to add this to their ModCP, I made a simple plugin for it...don't forget to put award.php in your modcp folder if you use it...


My problem is...how do I let Mods do this without giving them supermod permissions...maybe I just need sleep and it'll come to me. Suggestions anyway?

you need to setup permission right. In my award.php, i have "canadminusers" check, you might want to modify it "somehow", to let other moderator to do the job. sorry that I dont have enough time to do it right now.

[mtha]

Originally Posted by carpzone

I got this error when reading posts after installing de xml

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid 
FROM vb_post AS post
INNER JOIN vb_award_user AS au ON (au.userid=post.userid)
INNER JOIN vb_award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,2789,2790,2799,2808,2820) 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 near 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC

Did all of the template changes, i installed YAAS 2.1.2 On VB 3.4.5

I hope sombody can help me with this error.
The error occures when sombody try's to klik a forumpost.

P.S. I readed al of the post in this tread, its defenitly no Guest post

Regards

Where/how did you get the error? do you have any other hack/mod that could interfere with this one?

why "GROUP BY post.postid got inserted into the query??

[MThornback]

Originally Posted by mtha

Thanks, Gaskell for your help on support. good that you love the hack


for translation, edit phrase: award_pm on Email Subject Text
Congratulation! You have got a new award!




you need to setup permission right. In my award.php, i have "canadminusers" check, you might want to modify it "somehow", to let other moderator to do the job. sorry that I dont have enough time to do it right now.

Maybe the best way is to add a condition for specific userids..its a stop gap...but i'll play with it....i'll share my results if they work as always.

[carpzone]

Where/how did you get the error? do you have any other hack/mod that could interfere with this one?

why "GROUP BY post.postid got inserted into the query??

Well i have some hacks installed
Thanks Mod
Arcade mod

Both for 3.5 offcorse

I get the error on every tread clicked, so on every tread in every forum :cross-eyed:
When i set the option of postbit display on off in the admin Cp. I having no errors.

But then nobody can't see the awards in the postbit offcorse

When i get the error after clicking a tread a get the default database error page. With description from my previeus post.

Must i remove somthing from the original code or somthing ?

This is my Query in postbit query from the hooks

// [START HACK='Yet Another Award System' AUTHOR='HacNho']
if ($vbulletin->options['aw_postbit'])
{
if ($vbulletin->options['aw_postbitawardorder'] == 1)
{
$awardsdisplayorder = "ORDER BY au.issue_time ASC";
}
else if ($vbulletin->options['aw_postbitawardorder'] == 2)
{
$awardsdisplayorder = "ORDER BY a.award_displayorder ASC";
}
else if ($vbulletin->options['aw_postbitawardorder'] == 3)
{
$awardsdisplayorder = "ORDER BY a.award_displayorder DESC";
}
else
{
$awardsdisplayorder = "ORDER BY au.issue_time DESC";
}

// 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 $postids
". iif((!empty($cache_postids)), "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);
}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']

[carpzone]

OK Problem fixed, a hooked file from Photoplog Lite (gallery) did the Job for the errors.

I d'ont now the reason but i just disabled the the hook an the YAAS works very fine now.

Awesome Mod
Thank u for this Addon

[buyinflatables]

I installed this and it sems great!!! The only problem I am having is the request reward link.

When I click on it I get page that says:

Username, you do nothave permissions to access this page etc...

And I get this as a user or admin?

Did I miss something?

Im using 3.5.4

Thank you

Tim

[MThornback]

Originally Posted by MThornback

Maybe the best way is to add a condition for specific userids..its a stop gap...but i'll play with it....i'll share my results if they work as always.

As promised...it will work in the ModCP...I decided not to add the per user condition....but if you want it...it should be something like:

if (!can_moderate('canmoderate') AND $vbulletin->GPC['userid']=='x,y,z')

x,y,z are userids...that bit is untested....but I think it should work....if it doesn't try putting () around the userid condition....

[Gaskell]

Originally Posted by buyinflatables

I installed this and it sems great!!! The only problem I am having is the request reward link.

When I click on it I get page that says:

Username, you do nothave permissions to access this page etc...

And I get this as a user or admin?

Did I miss something?

Im using 3.5.4

Thank you

Tim

Daft question - have you allowed your usergroups to request awards in Usergroup Manager?

[buyinflatables]

Thank you... Didnt realize that option was added there.

It works now.


Does anyone know where to get different award images. I saw only a few on here... but could have sworn I seen more elswhere... Just dont remember where.

Thanks again!!

Tim