Yet Another Awards System [1.2.1]
 

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.
https://vborg.vbsupport.ru/external/2010/02/12.gif

SERVICE:
Installation service is available upon request

for Screenshot an updates
MORE screenshot in the zip file attached to first post.


HISTORY:
2005.08.18 - Version 1.2.1
- fix some bug for database with PREFIX
- Update: upload/replace the files in the attachment (awards.php, request_award.php)
- Re-edit request_award.php with your settings (you may want to make a backup of your old request_award.php and copy the settings over)

2005.04.14 - Version 1.2.0
- [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
-[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)
- Modify awards_install.php

2005.04.04 - Version 1.1c
- Fix award_cat.php to delete infomation in award_user table when you delete category and awards in the category.
+ replace award_cat.php with the same file in the zip

2005.04.03 - Version 1.1b
- Fix in showthead.php so that all awards icon will be displayed instead of one (if someone have the same award many times)
- Optimize the code in that part
Instruction in UPGRADE4b.txt

2005.04.03 - Version 1.1
- Can Create/Edit/Remove/Reorder categories/sub-categories in ACP (with category name and description)
- Can Move one (or all) award from one category to another, or set it un-classified (not displayed in the list in public site)
- Can re-order awards (in ACP)
Instruction in UPGRADE 4.txt

2005.03.29 - Version 1.0.1c
- Optimize code.
Instruction in UPGRADE3.txt (optional)

2005.03.29 - Version 1.0.1b
+ Display awards in postbit for hybrid and threaded mode
+ Display award users for each awards in ACP/Award Manager
- Upgrade instruction: /docs/UPGRADE2.txt
- Replace /admincp/award.php with the one in zip file

2005.03.28: Version 1.0.1
+ Display awards in postbit (showthread, showpost, announcement, private)
- Upgrade Instruction: /docs/UPGRADE1.txt

2005.03.28: Initial release


INSTALLATION:

Step 1: Unzip the files to a directory on your computer.
Step 2: Upload the files to your forums directory.
Directory structure:
{ROOT}/awards.php
{ROOT}/admincp/awards_install.php
{ROOT}/admincp/award.php
Step 3: Run installation from your admincp folder and follow instruction:
http://www.yourdomain.com/forumsdir/...ds_install.php

The installer will add new phrases, and templates to your database, and tell you how to edit files and templates.
You can also read the instruction how to modify files and templates from
/docs/awards_install_file.html
/docs/awards_install_template.html
Note: AUTOMATIC file modification is also available. See /docs/BoardMod_Automatic_File_Editing.htm for instruction

Step 4: Enjoy your new hack, give me feedback, and click https://vborg.vbsupport.ru/.

UN-INSTALLATION:
Step 1: Unzip the files to a directory on your computer.
Step 2: Upload the awards_install.php files to your forums admincp directory.
Directory structure:
{ROOT}/admincp/awards_install.php
Step 3: Run un-installation from your admincp folder: http://www.yourdomain.com/forumsdir...rds_install.php
The un-installer will drop phrases, and templates from your database
Step 4: Remove the following files from server
{ROOT}/awards.php
{ROOT}/admincp/award.php
{ROOT}/admincp/awards_install.php
Step 5: Manually un-do all the modification to files and templates.
List of modifications in:
/docs/awards_install_file.html
/docs/awards_install_template.html
Step 6: Give me feedback on why you dont want to use this hack.

HOW TO USE:

- Find and upload award icons and images to your server. You can use the images in medals.zip as demo
- Go to your forum AdminCP/Awards

+ Click on Award Category Manager if you want to create new category, or re-order some
+ Click on Award Manager to manage awards (if you have any)
+ Click on Add New Award if you want to add a award. Fill in information for Award Name, Description, Image URLs (full path to your images) and chose category. (Note: If you chose Category as "No one", your award will be listed as un-classify, and not display in front page)
You need to ADD some awards before using it :)
+ Click on Manage for each award to Add/Remove award to/from some user (by their userid or username)

go to http://yourwebsite/awards.php to see results.

- Files to edit: 1 (member.php)

/me click installs ^^

waiting for "awards in postbit" but with me award in member.php is enough because I have a profile page that is BEST fit for this.

Congratulations on the release of YAAS 1.0 mtha! One question, am I correct in my understanding of deathemperors post that awards are not displayed in the postbit? If anyone has the hack installed, please post a link so we can see it in action.

Awards are not currently displayed in postbit according to mtha but will be in later version as I understand it.

The postbit is fairly important to us, what time scale do you think you have on it Mtha?

cant have an awards system without displaying them in postbit.

Looks an ok hack will it have an ability for members to request awards later on ?

Looks good but I would need awards in the postbit also - will wait to install when that is available.

Looks beautiful!! Thanks mtha for sharing with the community! I will definetly install this one... this one is must have in a community lol

again thanks!

/me clicks install

very nice just 2 day mymember reguest to install the awards system :)

As soon as postbit is released we will install and show the results on our site.

Very useful hack :)

All went well with the install .. added new awards to test the hack and when award was issued received this database error :-

I ran the sql updates included in the install file and tried several different user ID's !?

I want to wait before i uninstall current one to see a demo. Looking good tho

Please download and replace the award.php in your admincp folder with the award.php file attached in the first post.

It was 4am at that time, I forgot to take out those fields :D

Does anyone know where there are award icons on the net that can be used with this

There are few icons in the zip file. The Icons (c) belong to phpBB Medal hack and some other place online

That solved the problems .. thanks for the quick update.

All running with no problems on 3.0.6

Awards when rewarded at the moment can only be viewed in members profile. Next upgrade will hopefully allow rewards to be shown in postbit display for rewarded members.

omg, this would be the best!

i can't wait for the post-bit code and will definitely install then.

Do you know what the difference between this and AnimeWebby's hack is?

Just that I want to release the first version ASAP, so I just thru something out for people to discuss.
It is not "cannot", it's just not yet implemented. I am working on postbits, update will be available soon.

Yes I do :D





- Database structure is different
- Award managements is different (read description in first post)
- Support is different (I am currently supporting the hack)
- and ... you can add to the list

Sounds like a great 1.0 release mtha, you're off to a terrific start. I'm going to wait to install until the release with the awards in the postbit also. Thanks for keeping this cool hack alive!

Also, if/when you do the postbit update..could you please include the update for us legacy postbit users?

Thaaankssss

Very good hack , I like it

Here's the bad news.

The more function you want, the more editing you need to do, and there's one additional querry for each post showing in the thread.

well trying to minimize the queries. give me suggestion if you have any.

quick addon for postbit if you did install the hack, and want to TEST and give suggestions.

Additional modifications for NOW: DELETED -

This is for TESTING PURPOSE only.

........

deleted. New version is coming out.

I want to display in postbit templates , What should i do ?

This is the Database error I get. Im running 3.0.7.

Mtha's first release of this hack was yesterday and it was more or less to test functionality. The first version didn't contain the option to display in the postbit and he posted a suggestion to get it to display but removed it because it looks like he is planning another update soon. We wait until he posts the update.

I am going to update a new version in says 30 minutes, on hold please!

PS. If you did install the TESTING Addon for postbit (POSTBIT_addon.txt) I posted before, please process to un-do that one. (just remove the changes in that instruction file). In the new release, I will not include how to un-do that one.

Version 1.0.1 released

New features:
- Display awards in postbit (showthread, showpost, announcement, private)



upgrade from 1.0.0 to 1.0.1:
https://vborg.vbsupport.ru/attachmen...chmentid=25204

Hmm, I dont see any error there. I install/uninstall several times without error.

Why dont you try to download the new version, uninstall the hack (just to make sure your database is clean), and install it again.

If the error still there, try to edit the awards_install.php, remove line 233 (where executing that drop table query) and see how it works out.

Good luck


Now you have it

Quick question: What is the point of "requesting" awards? It's just like I have a cake, and members are jumping on me "Hey, give me one, give me one" :D

To me, Awards is kind of You or your administrative team giving to those who get some significant constribution.

Anyway, if you can tell me why it should be included, I will re-consider.

Suggestions/requests on code optimization, functions, or displays are welcome!

It's not a function we would want but I can see how some would require it as a function. I presumed this to mean that members can request an award for another member not for themselves.

Say for instance you have a large group of individuals say over a 100 or so and many of them are in different sub groups etc, only they know whether somebody is deserving of a medal not one potentially aloof admin. , so the system allows the admin to see 'votes' if you like , that a certain member has had for an award from other members then he can authorise it or decline it.

I guess that is the meaning, however I think its of secondary importance to issues like
allowing members to comment on awards given etc.

I will get this new version with posbit installed basically now and put up a link shortly.

thanks for the upgrade mtha .. installed with no problems :)

Interesting, I give this some thought, and added to the todo list for a later version.

Wow, it looks nice on your colourful site TTG. I mean your site looks great :D

Can I borrow your site as a demo? :>

2005.03.29 - Version .1.0.1b
+ Display awards in postbit for hybrid and threaded mode
+ Display award users for each awards in ACP/Award Manager
- Upgrade instruction: /docs/UPGRADE2.txt
- Replace /admincp/award.php with the one in zip file

Well, the only thing I could ask for which was included in my add-on to Animewebby's hack is teh ability to request awards :)

Tried and same error - I removed that line as you said and now get this error.

Not sure why im the only one getting this error.

Please try to execute the query in phpMyAdmin or in AdminCP

[sql]
CREATE TABLE 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;
[/sql]

there's a list of SQL queries in my "Notes.txt", could you try that manually, and see if you can do it.
BTW, do you have the right to CREATE TABLE in the database?

I got a message 'effected rows: 0'

I used the vbulletin admin cp to run it. would I have gotten an error or message if it didnt take?

It seems that you was able to create the database. Check database structure in phpMyAdmin to see if you have that table created?

Is there any different from the query you ran and the one in the installation file?

Or if you are the only one who get this error, I just have you to create the tables manually.

Execute the following queries: (if you run in AdminCP, you need to run each of them individually)

[sql]
DROP TABLE IF EXISTS `award`;
[/sql]
[sql]
CREATE TABLE `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;
[/sql]
[sql]DROP TABLE IF EXISTS `award_user`;[/sql]
[sql]CREATE TABLE `award_user` (
`issue_id` smallint(5) NOT NULL auto_increment,
`award_id` smallint(5) NOT NULL default '0',
`userid` int(10) NOT NULL default '0',
`issue_reason` varchar(255) NOT NULL default '',
`issue_time` int(10) NOT NULL default '0',
PRIMARY KEY (`issue_id`)
) TYPE=MyISAM;
[/sql]

and then go to the next step:
/admincp/awards_install.php?step=dofileedits


You may also create the award_cat table, for future development:
[sql]
REMOVED
[/sql]

Got it all working by doing it manually - I was going to ask if a single user can get the same award more then once...that would make this hack everything I needed - well you can - Thanks!