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

[anarchystar]

I have been trying to install this hack on 3.0.7, I keep getting MySQL errors at step 3 when it runs the queries. It says I have an error near ';' on line 10, error 1064 as soon as the first query is run on my database. (MySQL vs. 3.23.58, PHP 4.3.8)
I tried 3 times, any suggestions?

[Polo]

Originally Posted by anarchystar

I have been trying to install this hack on 3.0.7, I keep getting MySQL errors at step 3 when it runs the queries. It says I have an error near ';' on line 10, error 1064 as soon as the first query is run on my database. (MySQL vs. 3.23.58, PHP 4.3.8)
I tried 3 times, any suggestions?

i would suggest, putting the exact error you are getting here so that the original coder can help you out...

[trulylowcarb]

Upgraded last night.
Wanted to note for you that in the file mods install file, shouldn't the last one actually be performed on functions_online.php?? It references the private.php file again, but the text that you want changed was not in my private.php file. It was in the functions file, however, and changing it there seems to have worked.

Thanks again!
Psssst - Voted for you for HOTM also.

[mtha]

Originally Posted by anarchystar

I have been trying to install this hack on 3.0.7, I keep getting MySQL errors at step 3 when it runs the queries. It says I have an error near ';' on line 10, error 1064 as soon as the first query is run on my database. (MySQL vs. 3.23.58, PHP 4.3.8)
I tried 3 times, any suggestions?

you may got the old installer file, or I put the wrong one in there by mistake? just to make sure, I uploaded the installer again in the zip file. You can download and install again. For safe, you can run uninstall before install, to remove any pre-added information. or run upgrade.

if you get same error, check the installer that you were running, make sure that there's no ; in lines 606, 618, 631

Upgraded last night.
Wanted to note for you that in the file mods install file, shouldn't the last one actually be performed on functions_online.php?? It references the private.php file again, but the text that you want changed was not in my private.php file. It was in the functions file, however, and changing it there seems to have worked.

did you get the latest file? I think I did change it to function_online. anyway, you got it working.

Psssst - Voted for you for HOTM also.

psssst, thanks

[anarchystar]

Hey I tried the install again, I still got the same error. I copied it this time so you could see exactly what it did:

Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE anarchystar_award (
			  award_id smallint(5) unsigned NOT NULL auto_increment,
			  award_cat_id smallint(5) NOT NULL default '1',
			  award_name varchar(50) NOT NULL default '',
			  award_desc varchar(250) NOT NULL default '',
			  award_icon_url varchar(250) NOT NULL default '',
			  award_img_url varchar(225) NOT NULL default '',
			  award_displayorder smallint(5) NOT NULL default '0',
			  PRIMARY KEY  (award_id)
			) TYPE=MyISAM;
		
mysql error: You have an error in your SQL syntax near ';
		' at line 10

mysql error number: 1064

Date: Monday 25th of April 2005 05:44:39 PM
Script: http://forums.anarchystar.com/admincp/awards_install.php?do=install&step=doqueries
Referer: http://forums.anarchystar.com/admincp/awards_install.php?do=install&step=dotemplates

[mtha]

Originally Posted by anarchystar

Hey I tried the install again, I still got the same error. I copied it this time so you could see exactly what it did:

Database error in vBulletin 3.0.7:
..
			  PRIMARY KEY  (award_id)
			) TYPE=MyISAM;
		
mysql error: You have an error in your SQL syntax near ';
		' at line 10

From this code here, can I say that you did not download the zip file again, and did not upload the new awards_install.php file to your server?

could you PLEASE download the zip file from the first post, unzip, and upload the awards_install.php to your admincp folder.

or I just upload one here. Please upload this file to your server.

[anarchystar]

actually I did, I went back after you posted, downloaded the new package and tried to install. Maybe I still had the old one though and screwed up, I will give it another shot :P .. thanks

[mtha]

Originally Posted by anarchystar

actually I did, I went back after you posted, downloaded the new package and tried to install. Maybe I still had the old one though and screwed up, I will give it another shot :P .. thanks

or maybe the old zip file was cached in your computer. sometime you need to clean cache, or download the php file I attached above.

[anarchystar]

it went a little better this time, the tables were added, but it hung up again here:

Database error in vBulletin 3.0.7:

Invalid SQL: 
			INSERT INTO anarchystar_award_cat 
				(award_cat_id, award_cat_title, award_cat_desc, award_cat_displayorder, award_cat_parentid) 
			VALUES (1, 'Default', 'Default category', 1, -1);
		
mysql error: You have an error in your SQL syntax near ';
		' at line 4

mysql error number: 1064

Date: Tuesday 26th of April 2005 04:38:51 AM
Script: http://forums.anarchystar.com/admincp/awards_install.php?do=install&step=doqueries
Referer: http://forums.anarchystar.com/admincp/awards_install.php?do=install&step=dotemplates

wha'cha think?

[anarchystar]

I opened up you install file, removed that ';' at the last step and it worked like a charm ... good stuff