The Arcive of Official vBulletin Modifications Site.

Yet Another Awards System [1.2.1] · **Released**: 03-27-2005

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

Dean C · #**122** 04-15-2005, 08:13 PM

I've removed your file Red Line

mtha · #**123** 04-15-2005, 09:22 PM

Quote:

Originally Posted by RED_LINE

hello

yes im sure about change the file correctly

the error somtimes apear not alaways

can you check showthread.php plz

Regards,

:"> sorry Marco and DeanC, i fotgot that we cant distribute files.

RedLine, check and see if your showthread has anything like this:

ORDER BY au.issue_time

If you find any, paste that part of code (with the whole query) hereI dont have that line on my code, and your errror says that it got error at that location.

Quote:

the error somtimes apear not alaways

can you test and see when and where it apprear?

make sure that you do upload the right file to the right location.

RED_LINE · #**124** 04-16-2005, 06:40 AM

thankyou MarcoH64

no porblem Dean :nervous:

Quote:

Originally Posted by mtha

:"> sorry Marco and DeanC, i fotgot that we cant distribute files.

RedLine, check and see if your showthread has anything like this:

ORDER BY au.issue_time

If you find any, paste that part of code (with the whole query) hereI dont have that line on my code, and your errror says that it got error at that location.

can you test and see when and where it apprear?

make sure that you do upload the right file to the right location.

i see that code you told me

(ORDER BY au.issue_time) at line 1304

PHP Code:


			
// [START HACK='Yet Another Award System' AUTHOR='HacNho']

                // Obtain list of awards for current user

                        $alluserawards =  $DB_site->query("

                                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 post.postid IN (" . $cache_postids . ")

                                GROUP BY au.issue_id

                                ORDER BY au.issue_time

                        ");

                        while( $ua = $DB_site->fetch_array($alluserawards))

                        {

                                $userawardscache[$ua['userid']][$ua['issue_id']] = $ua;

                        }

                        $DB_site->free_result($alluserawards);

// [END HACK='Yet Another Award System' AUTHOR='HacNho']

thanx for help mtha :nervous:

deathemperor · #**125** 04-16-2005, 10:26 AM

Hi mtha,

I'm requesting for automatic awards like user has top post, user has the most reputation, user has the most post per day %, etc....

my site use UCS as the point system, and ppl is stealing money from the others -> reputation drops, I'd like to have an award like "Thief Master" with someone did most thief actions, and "The Worse Guy" if he has least reputation.

Below is the best example from Gamespot community, take a look and these links:

http://www.gamespot.com/user/profile.html?user=duxup
http://www.gamespot.com/user/emblem.html?id=mod
http://www.gamespot.com/user/emblem.html?id=badtaste

It is to make a superb awards system.

mtha · #**126** 04-16-2005, 06:33 PM

Quote:

Originally Posted by RED_LINE

i see that code you told me

(ORDER BY au.issue_time) at line 1304

PHP Code:


			
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
                // Obtain list of awards for current user
                        $alluserawards =  $DB_site->query("
                                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 post.postid IN (" . $cache_postids . ")
                                GROUP BY au.issue_id
                                ORDER BY au.issue_time
                        ");
                        while( $ua = $DB_site->fetch_array($alluserawards))
                        {
                                $userawardscache[$ua['userid']][$ua['issue_id']] = $ua;
                        }
                        $DB_site->free_result($alluserawards);
// [END HACK='Yet Another Award System' AUTHOR='HacNho']

thanx for help mtha :nervous:

What version of YAAS are you using? did you upgrade to the last version? Since your pasted code is different from the one in my instruction, I think you DID NOT make the correct changes to your files file.
PLEASE download the NEW zip file and follow instruction there for upgrade, and re-edit ALL files.

mtha · #**127** 04-16-2005, 06:46 PM

Quote:

Originally Posted by deathemperor

Hi mtha,

I'm requesting for automatic awards like user has top post, user has the most reputation, user has the most post per day %, etc....

my site use UCS as the point system, and ppl is stealing money from the others -> reputation drops, I'd like to have an award like "Thief Master" with someone did most thief actions, and "The Worse Guy" if he has least reputation.

Below is the best example from Gamespot community, take a look and these links:

http://www.gamespot.com/user/profile.html?user=duxup
http://www.gamespot.com/user/emblem.html?id=mod
http://www.gamespot.com/user/emblem.html?id=badtaste

It is to make a superb awards system.

The example looks really nice.
however, i think that your would lead to a seperate award system, or a branch of it.

I dont really like the idea of giving awards "automatically" very much, for right now, but that'd be a nice idea.
However, for this to work,you dont have award issue time and reason, you also dont have award history. just the current users has, says, top posts (or reputation) showing up, right? if tomorrow, someone else has higher score, the former one will lose his award?

datainternet · #**128** 04-17-2005, 01:24 PM

Hi,

At first: This is really really a great hack. Thanks dude

.

But I have two little Questions:

1. In the request_award.php - file there is an option called "REDIRECT OPTIONS:". There you can choose Option 0 to show a thank you message.

Now my question: Is it possibly to show this message AND redirect after some seconds to another page?

This would be very nice

.

2. I translated my hack to german speech and now I have 1 little problem:

In the request award page there are 2 different buttons in the bottom: "Submit" and "Reset". Where can i find this values to translate them?

When this two little problems are solved I really love this hack

.

MFG datainternet

mtha · #**129** 04-17-2005, 04:23 PM

Quote:

Originally Posted by datainternet

Hi,

1. In the request_award.php - file there is an option called "REDIRECT OPTIONS:". There you can choose Option 0 to show a thank you message.

Now my question: Is it possibly to show this message AND redirect after some seconds to another page?

for this, you can ask Erwin here:
https://vborg.vbsupport.ru/showthread.php?t=66082
I use his hack for the form, basically.

Quote:

In the request award page there are 2 different buttons in the bottom: "Submit" and "Reset". Where can i find this values to translate them?

sorry I had those things hard-coded.
you can edit awards_request_form template, and change
value="Submit" => value="$vbphrase[submit]"
value="Reset" => value="$vbphrase[reset]"

Ben5150 · #**130** 04-18-2005, 12:56 AM

has anybody got this error
Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE vb3_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
if so how to fix it

mtha · #**131** 04-18-2005, 04:08 AM

Quote:

Originally Posted by Ben5150

has anybody got this error
Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE vb3_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
if so how to fix it

hmm, have no idea yet. you can try to manually enter the database, or run "upgrade"

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04735 seconds Memory Usage 2,358KB 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 (2)bbcode_php (8)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!