Yet Another Awards System [1.2.1]

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

Hack Version: 1.2.1.050818
Compatible vB version: 3.0.8. It should work with all vB 3.0.x versions.
Support: https://vborg.vbsupport.ru/showthread.php?t=78934


For vBulletin 3.5.0, please check the other version:
https://vborg.vbsupport.ru/showthread.php?t=94836


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

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 add: 9 ('AWARDS', 'awards_awardbit','awards_awardusers_bit','awards_ bit','awards_userawards_bit','awards_category','aw ards_categorybit', 'awards_request_form', 'awards_request_formanswers')
- Templates to edit: 5 (MEMBERINFO, postbit, postbit_legacy, memberlist, memberlist_resultsbit )
- Phrases to add: 49

DIFFICULTY:
Easy-medium
Time: about 5-10 minutes
Installer is included

HISTORY:
For detail, please click here
2005.08.18: Version 1.2.1
2005.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)
- PM/Email user when he/she get an award.
- Allow voting on user's award (by Arial)

ADD ONs


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 HERE: https://vborg.vbsupport.ru/showthrea...316#post632316

UNINSTALL:
Read HERE: https://vborg.vbsupport.ru/showthrea...316#post632316

MANUAL:
Included in zip file

SCREENSHOT:
https://vborg.vbsupport.ru/showpost.php?p=632316

DEMO:
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
There's some custom modification on this site, but you have the idea.

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


SERVICE:
Installation service is available upon request

[Neal-UK]

Originally Posted by jluerken

Hi author,

I found a bug in the request award section.

I am using table prefixes in my installation and request_award is not taking care about this.

Everytime a user requests an award I get this db error:

PHP Code:

Database error in vBulletin 3.0.7:
 
Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'88856','CFN|LordSoth Award Request Form','CFN|LordSoth','4','1117187527','Award Request Form - CFN|LordSoth
 
------------------
Sender Information
 
UserID: 4
Username: CFN|LordSoth
Fullname: CFN|LordSoth
 
-----------------------------
Request Information:
Award ID: 3
Award Name: Donationaward
Award Description: Thanks for your donation
[img]http://www.clanforums.com/forum/images/medals/contributoraward.gif[/img]
 
Recipient username : Toky 
 
-----------------------------------------------------
Please explain why the listed recipient should receive the award.
 
Sponsoring
-----------------------------------------------------
','1','1','0','0','1')
mysql error: Table 'usr_web1_3.post' doesn't exist
 
mysql error number: 1146 


The table name is not usr_web1_3.post, its usr_web1_3.vb3_post where vb3_ is the prefix


The error is in request_award.php around line 40
And line 41 has the same error. It should be:

PHP Code:

UPDATE " . TABLE_PREFIX . "thread SET 


I've just had to edit this template in about 8 places to put my db prefix in as i have FORUM before the name.

Is this the mod I only need to do or will other things need to be adjusted to get it working 100%? Don't want new errors on a newly re-installed forum and db.

[biagrin]

im getting the following error:

PHP Code:

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'22280','biagrin Award Request Form','biagrin','1','1121608524','[b]Award Request Form - biagrin[/b]

------------------
[color=blue][b]Sender Information[/b][/color]

UserID: [url=http://www.socialoutkast.com/forum/member.php?u=1]1[/url]
Username: biagrin
Fullname: biagrin

-----------------------------
[color=red][b]Request Information:[/b][/color]
Award ID: [b][url=http://www.socialoutkast.com/forum/awards.php#award1]1[/url][/b]
Award Name: [b]test[/b]
Award Description: [b]testing awards[/b]
[url=http://www.socialoutkast.com/forum/awards.php#award1][img]https://vborg.vbsupport.ru/external/2005/07/4.gif[/img][/url]

Recipient username : [b][url=http://www.socialoutkast.com/forum/member.php?username=biagrin] biagrin [/url] [/b]

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

test
-----------------------------------------------------
','1','1','0','0','1')
mysql error: Table 'socitvkx_general.post' doesn't exist

mysql error number: 1146

Date: Sunday 17th of July 2005 02:55:24 PM
Script: [url]http://www.socialoutkast.com/forum/request_award.php[/url]
Referer: biagrin
Username: biagrin
IP Address: **.**.**.** 


have i done something wrong somewhere?

any help would be appreciated

[SmartGnome]

I have clicked install :banana:

Thanks for sharing

[disquiet]

I got the same error that jluerken and biagrin are getting, but by deslecting the option to write to a thread in the config page, I got rid of that... So I kinda worked my way around that one...

Plus I'm getting an error when I click on the link to the categories while viewing the Awards page itself... I'm getting this error...

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM vb3_award_cat
		WHERE award_cat.award_cat_id = 1
			ORDER BY award_cat_displayorder
		
mysql error: Unknown table 'award_cat' in where clause

mysql error number: 1109

In reading this thread, I've seen that this is a problem with the prefixes in my db, but I don't know how to rectify the situation. I have the latest dl from the first post, so no other prefix fixes have worked... Any help would be appreciated...

*EDIT*
I guess you can ignore the above problems... I am still having them, but I have fiddled with the templates and managed to hide the error causing links...now unless I add the code back into the templates, no one will get the errors...

Once again, thanks for the hack...too bad for all the bugs that I had though...but still great..

*Me clicks install*
*/EDIT*

[biagrin]

exact same problem here mate

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT * FROM socitvkx_award_cat
		WHERE award_cat.award_cat_id = 1
			ORDER BY award_cat_displayorder
		
mysql error: Unknown table 'award_cat' in where clause

mysql error number: 1109

Date: Wednesday 20th of July 2005 03:10:03 AM
Script: http://www.socialoutkast.com/forum/awards.php?award_cat_id=1
Referer: 
Username: biagrin
IP Address: ***********

i manged to fix the previous problem and now i cant remember what i done. ill have a look and get back to you

[oman]

Hi

can u upgrade this hack for 3.5.0 plz

thanx

[FusionHosting]

Anyone have this working in 3.08? I tried the upgrade and now it seems the award hack is broken, also had a user say they couldn't post in a private forum.

[jluerken]

Originally Posted by FusionHosting

Anyone have this working in 3.08? I tried the upgrade and now it seems the award hack is broken, also had a user say they couldn't post in a private forum.

I'm running it with 3.0.8. Simply check if all file changes are still correct and then run award_install.php again to setup the templates again.

This should fix your problem

[Bernd]

Where can i change the css styles for the additional table displayed in memberlist.php?
The "awards" table is currently grey and would like to adjust it to fit my template.

[cuphongle]

yea i got it workiong on 3.0.8,
but i dont know how to change the award_request...
can someone help me a little?