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

[y2krazy]

Ok. That fixed that problem, now I'm getting this weird error(see attachment). I haven't modded any of the templates for the Awards yet, so I'm not sure as to why this is happening.

[Roxie]

Excellent! The editing works...Your work is really appreciated.

[Roxie]

I promise I'm not trying to be a pain ... lol..but I'm getting this error when submitting the Request Award form. I also tried using the new request_award.php that you posted later in the thread.

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'1','Ro Award Request Form','Ro','1','1125870038','Award Request Form - Ro

------------------
Sender Information

UserID: 1
Username: Ro
Fullname: test

-----------------------------
Request Information:
Award ID: 29
Award Name: Cancer Zodiac
Award Description: 


Recipient username :  test  

-----------------------------------------------------
Please explain why the listed recipient should receive the award.

testing form
-----------------------------------------------------','1','1','0','0','1');

MySQL Error  : Table 'dizzam_daboard.post' doesn't exist
Error Number : 1146
Date         : Sunday, September 4th 2005 @ 05:40:38 PM
Script       : http://daboard.dizzam.com/request_award.php
Referrer     : http://daboard.dizzam.com/request_award.php?award_id=29
IP Address   : xx.xx.xxx.xx
Username     : Ro
Classname    : vb_database

*EDIT* Seems the request still went through, but for some reason I get that database error...hmmm.

Also, sometimes the awards in the postbit don't show. We have to refresh the page. (that's not really a problem..just a lil annoying...lol)...Thanks!

[y2krazy]

Regarding this post:

https://vborg.vbsupport.ru/showpost....7&postcount=61

I simply changed the following in the "awards_category" template:

PHP Code:

    <td class="tcat" colspan="$totalcols"> 


To this:

PHP Code:

    <td class="tcat" colspan="4"> 


Not sure what the previous code was used for, so this is just a temp-fix for the problem. Let me know when you get around to it...

[DeMiNe0]

Originally Posted by Roxie

I promise I'm not trying to be a pain ... lol..but I'm getting this error when submitting the Request Award form. I also tried using the new request_award.php that you posted later in the thread.

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'1','Ro Award Request Form','Ro','1','1125870038','Award Request Form - Ro

------------------
Sender Information

UserID: 1
Username: Ro
Fullname: test

-----------------------------
Request Information:
Award ID: 29
Award Name: Cancer Zodiac
Award Description: 


Recipient username :  test  

-----------------------------------------------------
Please explain why the listed recipient should receive the award.

testing form
-----------------------------------------------------','1','1','0','0','1');

MySQL Error  : Table 'dizzam_daboard.post' doesn't exist
Error Number : 1146
Date         : Sunday, September 4th 2005 @ 05:40:38 PM
Script       : http://daboard.dizzam.com/request_award.php
Referrer     : http://daboard.dizzam.com/request_award.php?award_id=29
IP Address   : xx.xx.xxx.xx
Username     : Ro
Classname    : vb_database

*EDIT* Seems the request still went through, but for some reason I get that database error...hmmm.

Also, sometimes the awards in the postbit don't show. We have to refresh the page. (that's not really a problem..just a lil annoying...lol)...Thanks!

i'm getting this same error.

[mtha]

Originally Posted by Roxie

I promise I'm not trying to be a pain ... lol..but I'm getting this error when submitting the Request Award form. I also tried using the new request_award.php that you posted later in the thread.

Database error in vBulletin 3.5.0 Release Candidate 2:

MySQL Error  : Table 'dizzam_daboard.post' doesn't exist
Error Number : 1146

*EDIT* Seems the request still went through, but for some reason I get that database error...hmmm.

Also, sometimes the awards in the postbit don't show. We have to refresh the page. (that's not really a problem..just a lil annoying...lol)...Thanks!

I could have uploaded the old file. replace request_award.php with the attached file

[mtha]

Originally Posted by y2krazy

Regarding this post:

https://vborg.vbsupport.ru/showpost....7&postcount=61

I simply changed the following in the "awards_category" template:

PHP Code:

    <td class="tcat" colspan="$totalcols"> 


To this:

PHP Code:

    <td class="tcat" colspan="4"> 


Not sure what the previous code was used for, so this is just a temp-fix for the problem. Let me know when you get around to it...

try the attached file with the old template (using $totalcols) and see how it turn out.

the totalcols will calculate the number of columns you have, depends on the options you have for award settings.

[Biker_GA]

Something that would make this a top notch modification. I've added the link for the nomination form to postbit_legacy. What I currently have users do is copy the URL of the post they'd like to nominate. To make this even better, I'd like to see the URL automatically added to the reason section when a user clicks the link in the postbit.

[y2krazy]

The new files are working properly. Thanks, mtha!

Also, I have edited the Award Request template quite a bit and thought I'd share it with everyone who wants it:

$stylevar[htmldoctype]
<html id="form" dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - $formtitle</title>
$headinclude
</head>
<body>
$header
$navbar

<form enctype="multipart/form-data" method="post" action="$phpfilename">
<input type="hidden" value="$userid" name="userid">
<input type="hidden" value="submit" name="action">
<input type="hidden" value="$award[award_id]" name="award_id">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
	<td class="tcat" colspan="3">
		Request for $award[award_name] (id: $award[award_id])
	</td>
</tr>
<tr>
	<td class="panelsurround" align="center">
	<div class="panel">
		<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
			<fieldset class="fieldset" style="margin:0px">
				<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
				<tr>
					<td>$formpurpose</td>
				</tr>
				</table>
			</fieldset>

			<br><div align="center"><img src="$award[award_img_url]"></div><br>

			<fieldset class="fieldset">
				<legend>Description</legend>
				<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
				<tr>
					<td>$award[award_desc]</td>
				</tr>
				</table>
			</fieldset>

		</div>
	</div>
	</td>
</tr>
</table>

<br>

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
	<td class="tcat" colspan="3">
		$formtitle
	</td>
</tr>
<tr>
	<td class="panelsurround" align="center">
	<div class="panel">
		<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
		
			<fieldset class="fieldset">
				<legend>Username</legend>
				<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
				<tr>
					<td><b>$bbuserinfo[username]</b></td>
				</tr>
				</table>
			</fieldset>
		
			<fieldset class="fieldset">
				<legend>$question1</legend>
				<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
				<tr>
					<td></td>
				</tr>
				<tr>
					<td><input type="text" class="bginput" size="30" name="answer1"></td>
				</tr>
				</table>
			</fieldset>

			<fieldset class="fieldset">
				<legend>$question2</legend>
				<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
				<tr>
					<td><input type="text" class="bginput" size="30" name="answer2"></td>
				</tr>
				</table>
			</fieldset>
		
			<fieldset class="fieldset">
				<legend>$longquestion1</legend>
				<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
				<tr>
					<td>$longexplain1</td>
				</tr>
				<tr>
					<td><textarea rows="5" cols="50" name="longanswer1"></textarea></td>
				</tr>
				</table>
			</fieldset>

		</div>
	</div>
	</td>
</tr>
<tr>
	<td class="panelsurround" align="center">
	<div style="margin-top:$stylevar[cellpadding]px">
		<input type="submit" name="submit" class="button" value="Submit Request" accesskey="s" />
		<input type="reset" name="reset" class="button" value="$vbphrase[reset_fields]" accesskey="r" />
	</div>
	</td>
</tr>

</table>
</td>
</tr>
</table>

</form>

$footer
</body>
</html>

NOTE: The attachment is in my unique style, but it was edited based on the UserCP templates, so it should look like that in any template. Let me know if this is any use to anyone.

EDIT: Where would I go to change the title of the thread, e-mail or PM that is created when a request is submitted?

EDIT 2: Nevemind the first EDIT as I figured out where in the file to change some things to make the title of the thread different.

[Roxie]

Originally Posted by mtha

I could have uploaded the old file. replace request_award.php with the attached file

Great! Database error is gone, but now it submits the form and refreshes to the form again. No thank you page. hmmm