The Arcive of Official vBulletin Modifications Site.

Yet Another Awards System 3.5 v2.1.2 · **Released**: 08-21-2005

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

ChrisBaktis · #**202** 11-30-2005, 12:02 PM

I just changed from 3.0.7 to 3.5.1 and resintalled your hack - the awards that were present prior to the conversion still show up - but in the admincp area if I click on Manger or any of the items I get the following error:

Database error in vBulletin 3.5.1:

PHP Code:


			
Invalid SQL:



            SELECT aw_c.*, COUNT(aw.award_id) AS items

            FROM award_cat AS aw_c

            LEFT JOIN award AS aw USING(award_cat_id)

            GROUP BY award_cat_id

            ORDER BY award_cat_displayorder;



MySQL Error  : Unknown column 'award_cat_displayorder' in 'order clause'

Error Number : 1054

Date         : Wednesday, November 30th 2005 @ 09:01:03 AM

Script       : http://rustysoaptraders.com/forums/admincp/award_cat.php?do=modifycat

samu2 · #**203** 11-30-2005, 03:16 PM

could somebody please tell me the right code to put the link to awards in my navbar?

mtha · #**204** 12-01-2005, 01:57 PM

Quote:

Originally Posted by ChrisBaktis

I just changed from 3.0.7 to 3.5.1 and resintalled your hack - the awards that were present prior to the conversion still show up - but in the admincp area if I click on Manger or any of the items I get the following error:

Database error in vBulletin 3.5.1:

PHP Code:


			
Invalid SQL:

            SELECT aw_c.*, COUNT(aw.award_id) AS items
            FROM award_cat AS aw_c
            LEFT JOIN award AS aw USING(award_cat_id)
            GROUP BY award_cat_id
            ORDER BY award_cat_displayorder;

MySQL Error  : Unknown column 'award_cat_displayorder' in 'order clause'
Error Number : 1054
Date         : Wednesday, November 30th 2005 @ 09:01:03 AM
Script       : http://rustysoaptraders.com/forums/admincp/award_cat.php?do=modifycat

HMM, was you able to reorder award cat prior to your upgrade?
award_cat_displayorder was present in the database since after version 1.0

maybe you did not upgrade your award hack since 1.0 to the latest version for vB 3.0.7, or you missed one step to fix database?

anyway, check your database and see if you have table award_cat, and if there's a field called award_cat_displayorder in there.

or you may need to run the queries (add prefix if you need to):

this query will drop award_cat table. so becareful. if you already have the award cat table, want to keep it, you can look over the next query and see if there is anything wrong. with your current award_cat table.
[sql]DROP TABLE IF EXISTS award_cat
[/sql]

[sql] CREATE TABLE award_cat (
award_cat_id mediumint(8) unsigned NOT NULL auto_increment,
award_cat_title varchar(100) NOT NULL default '',
award_cat_desc varchar(250) NOT NULL default '',
award_cat_displayorder mediumint(8) unsigned NOT NULL default '0',
award_cat_parentid mediumint(8) NOT NULL default '-1',
PRIMARY KEY (award_cat_id),
KEY award_cat_order (award_cat_displayorder)
) TYPE=MyISAM[/sql]

[sql]
INSERT INTO " . TABLE_PREFIX . "award_cat
(award_cat_id, award_cat_title, award_cat_desc, award_cat_displayorder, award_cat_parentid)
VALUES (1, 'Default', 'Default category', 1, -1)[/sql]

mtha · #**205** 12-01-2005, 02:09 PM

Quote:

Originally Posted by samu2

could somebody please tell me the right code to put the link to awards in my navbar?

http://www.w3schools.com/html/html_links.asp

<a href="awards.php">$vbphrase[awards]</a>could work

ChrisBaktis · #**206** 12-01-2005, 03:01 PM

Quote:

Originally Posted by mtha

HMM, was you able to reorder award cat prior to your upgrade?
award_cat_displayorder was present in the database since after version 1.0

maybe you did not upgrade your award hack since 1.0 to the latest version for vB 3.0.7, or you missed one step to fix database?

anyway, check your database and see if you have table award_cat, and if there's a field called award_cat_displayorder in there.

or you may need to run the queries (add prefix if you need to):

this query will drop award_cat table. so becareful. if you already have the award cat table, want to keep it, you can look over the next query and see if there is anything wrong. with your current award_cat table.
[sql]DROP TABLE IF EXISTS award_cat
[/sql]

[sql] CREATE TABLE award_cat (
award_cat_id mediumint(8) unsigned NOT NULL auto_increment,
award_cat_title varchar(100) NOT NULL default '',
award_cat_desc varchar(250) NOT NULL default '',
award_cat_displayorder mediumint(8) unsigned NOT NULL default '0',
award_cat_parentid mediumint(8) NOT NULL default '-1',
PRIMARY KEY (award_cat_id),
KEY award_cat_order (award_cat_displayorder)
) TYPE=MyISAM[/sql]

[sql]
INSERT INTO " . TABLE_PREFIX . "award_cat
(award_cat_id, award_cat_title, award_cat_desc, award_cat_displayorder, award_cat_parentid)
VALUES (1, 'Default', 'Default category', 1, -1)[/sql]

Got this error on the third query:

PHP Code:


			
An error occurred while attempting to execute your query. The following information was returned. 

error number: 1064 

error desc: You have an error in your SQL syntax near '" . TABLE_PREFIX . "award_cat 

(award_cat_id, award_cat_title, ' at line 1

mtha · #**207** 12-03-2005, 09:49 PM

Quote:

Originally Posted by ChrisBaktis

Got this error on the third query:

PHP Code:


			
An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax near '" . TABLE_PREFIX . "award_cat 
(award_cat_id, award_cat_title, ' at line 1

remove the " . TABLE_PREFIX . " in that query.

ps. REMEMBER to correct prefix with yout vB tables if you use it.

ChrisBaktis · #**208** 12-04-2005, 03:12 AM

worked great - thanks.

gator777 · #**209** 12-06-2005, 08:01 PM

I noticed you changed the look with the postbit. It now has a box around it, and some additional text. I don't have a copy of the old "postbit" code you provided in an earlier version where it showed just the medals and a "more info..." link. Could I possibly have the old postbit code to make it more streamlined, because it gives to much height to the post header (postbit).

Thanks for this great program, and any help would be greatly appreciated.

nexus851 · #**210** 12-11-2005, 06:40 AM

after u request a reward, where do you go to moderate the request??? i dont see anything in the admin area for moderation....

Gaskell · #**211** 12-11-2005, 05:13 PM

It will be in ACP -> Award System -> Award Manager.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.13650 seconds Memory Usage 2,342KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!