Yet Another Awards System [1.2.1]

[mtha]

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

https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=78934)


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 (https://vborg.vbsupport.ru/showthread.php?p=632316#post632316)
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] (https://vborg.vbsupport.ru/showthread.php?t=61108), which I write new code based on his.
- Mac ycl6 for phpBB Medal System (http://www.phpbb.com/phpBB/viewtopic.php?t=148362) 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/showthread.php?p=632316#post632316

UNINSTALL:
Read HERE: https://vborg.vbsupport.ru/showthread.php?p=632316#post632316

MANUAL:
Included in zip file

SCREENSHOT:
https://vborg.vbsupport.ru/showpost.php?p=632316 (https://vborg.vbsupport.ru/showpost.php?p=632316&postcount=2)

DEMO:
http://www.global-army.com/forum/awards.php
http://www.global-army.com/forum/showthread.php?p=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 (https://www.paypal.com/xclick/business=mtha%40ou.edu&no_shipping=1&cn=vBulletin.org+Username&tax=0&currency_code=USD&item_name=YetAnotherAwardsSystem%20Donation)

SERVICE:
Installation service is available upon request

[mtha]

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/admincp/awards_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/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=78934).

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 (http://www.yourdomain.com/forumsdir/admindir/awards_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.

[deathemperor]

- 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.

[dssart]

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.

[Arial]

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?

[lasto]

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 ?

[ChrisBaktis]

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

[Polo]

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

[H2k_Coder]

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

[Arial]

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

[TTG]

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 :-

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT user.username,userfield.field10,userfield.field11, userfield.field12,userfield.field13,userfield.fiel d14
FROM user, userfield
WHERE (user.userid=1) and (userfield.userid=1)

mysql error: Unknown column 'userfield.field10' in 'field list'

mysql error number: 1054

Date: Monday 28th of March 2005 05:13:22 PM
Script: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=awardusers&award_id=1
Referer: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=manage
Username: The Tech Guy
IP Address: 82.44.23.235

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

[GamerzWorld]

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

[mtha]

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 :-

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT user.username,userfield.field10,userfield.field11, userfield.field12,userfield.field13,userfield.fiel d14
FROM user, userfield
WHERE (user.userid=1) and (userfield.userid=1)

mysql error: Unknown column 'userfield.field10' in 'field list'

mysql error number: 1054

Date: Monday 28th of March 2005 05:13:22 PM
Script: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=awardusers&award_id=1
Referer: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=manage
Username: The Tech Guy
IP Address: 82.44.23.235

I ran the sql updates included in the install file and tried several different user ID's !?
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

[Blackbeard]

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

[mtha]

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

[TTG]

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

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

All running with no problems on 3.0.6

[TTG]

I'm not sure what is meant by..."cannot be display awards in postbits"

What effect does this have on the functionality of the hack? Can someone enlighten the less tech-savvy... :)

Thanks all,

lsmba

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.

[yinyang]

omg, this would be the best!

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

[Jon@Refresh]

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

[mtha]

I'm not sure what is meant by..."cannot be display awards in postbits"

What effect does this have on the functionality of the hack? Can someone enlighten the less tech-savvy... :)


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.


Do you know what the difference between this and AnimeWebby's hack is?
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

[dssart]

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

[snowlion]

Very good hack , I like it

[mtha]

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.

[mtha]

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.

[snowlion]

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

Additional modifications for NOW:

Template to edit: 2 (postbit, postbit_legacy)
Files to edit: 3 (showthread.php, showpost.php, announcement.php)




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

[ChrisBaktis]

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

Database error in vBulletin 3.0.7:

Invalid SQL: DROP TABLE IF EXISTS award;
mysql error: You have an error in your SQL syntax near '; ' at line 1

mysql error number: 1064

Date: Monday 28th of March 2005 10:43:21 PM
Script: http://rustysoaptraders.com/forums/admin/awards_install.php?step=doqueries
Referer:

[dssart]

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 want to display in postbit templates , What should i do ?

[mtha]

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.

[mtha]

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/attachment.php?attachmentid=25204

[mtha]

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

Database error in vBulletin 3.0.7:

Invalid SQL: DROP TABLE IF EXISTS award;
mysql error: You have an error in your SQL syntax near '; ' at line 1

mysql error number: 1064

Date: Monday 28th of March 2005 10:43:21 PM
Script: http://rustysoaptraders.com/forums/admin/awards_install.php?step=doqueries
Referer:

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


cant have an awards system without displaying them in postbit.
Now you have it

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

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!

[Arial]

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.

[TTG]

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

[mtha]

allowing members to comment on awards given etc.


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

thanks for the upgrade mtha .. installed with no problems

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

Can I borrow your site as a demo? :>

[mtha]

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

[Creed]

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 :)

[ChrisBaktis]

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


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

Database error in vBulletin 3.0.7:

Invalid 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;

mysql error: You have an error in your SQL syntax near ';
' at line 10

mysql error number: 1064

Not sure why im the only one getting this error.

[mtha]

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

Database error in vBulletin 3.0.7:

Invalid 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;

mysql error: You have an error in your SQL syntax near ';
' at line 10

mysql error number: 1064

Not sure why im the only one getting this error.

Please try to execute the query in phpMyAdmin or in AdminCP


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;


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?

[ChrisBaktis]

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?

[mtha]

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)


DROP TABLE IF EXISTS `award`;


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;

DROP TABLE IF EXISTS `award_user`;
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;


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


You may also create the award_cat table, for future development:

REMOVED

[ChrisBaktis]

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!

[ChrisBaktis]

I noticed one problem - in the post bit there is a small '_' (which is a link) between award icons.

[mtha]

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!

Yes, you can give a award to one user as many times as you want to.


I noticed one problem - in the post bit there is a small '_' (which is a link) between award icons.

Hmm, I didnt use IE. FF displayed fine. Anyway, edit awards_bit template, and remove any line break there. Make sure your awards_bit template look like this:
<a href="member.php?$session[sessionurl]u=$award[userid]#award$award[issue_id]"><img src="$award[award_icon_url]" alt="$award[award_name]: $award[award_desc] - $vbphrase[award_reason]: $award[issue_reason]" border="0" /></a>

[ChrisBaktis]

Thanks for the response.

I changed the post bit code around a bit so it looks like it does in the profile (with 'Awards Showcase') looks and works great.

[mtha]

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

Open awards_install_files.html and do all the editing again!
Upload new awards.php and /admincp/award.php to your server

If you use BoardMod for automatic file change:
- uninstall the hack (files only)
- copy the new vb3_Yet_Another_Awards_System.mod into the Mod folder
- and reinstall it (files only).

[Harry72]

Hi,

i run querys in phpmyadmin but i get an error with INSERT Line

INSERT INTO `award_cat` VALUES (1, 'Default', 10);

ERROR: #1136 - Column count doesn't match value count at row 1


Thx for help !

Cheers :ermm:

[Harry72]

I run this INSERT Query with


INSERT INTO `award_cat` VALUES (1, 'Default', 10, 0);

Now, it works.

Cheers

[mtha]

Hi,

i run querys in phpmyadmin but i get an error with INSERT Line

INSERT INTO `award_cat` VALUES (1, 'Default', 10);

ERROR: #1136 - Column count doesn't match value count at row 1


Thx for help !

Cheers :ermm:

Seems that you read and run the queries in NOTE.txt? actually that is for my note, I am working on award_categories, so I didnt clean that part of code.


Okay...is the postbit issue resolved in the 1.01 version I see posted?

What is the "postbit issue"? you mean if the awards displayed in postbit? then yes, awards are displayed in postbit.

[mtha]

A new version is coming up with function of award category

You will be able to:
- Create/delete award categories and sub-categories
- Re-order categories in display
- Re-order awards in display
- Move award(s) from one category to another, or un-classified.

If you want to have a taste of it, look at the attachment.

Comments and suggestions are welcome!

[Harry72]

Seems that you read and run the queries in NOTE.txt? actually that is for my note, I am working on award_categories, so I didnt clean that part of code.


Yes, u are right ! :nervous:

Now my tables are right ! Thx. :ermm:

[Harry72]

A new version is coming up with function of award category

You will be able to:
- Create/delete award categories and sub-categories
- Re-order categories in display
- Re-order awards in display
- Move award(s) from one category to another, or un-classified.

If you want to have a taste of it, look at the attachment.

Comments and suggestions are welcome!

Looks very very nice. I want to have it. :nervous:

[Koutaru]

I'll install on my boards when the next version comes out :) since I really need the category feature. Looks pretty :3

[mtha]

and here are some more screenshots, I need to go now, so the next release will be sometime later tonight or tomorrow :)

keep the thread hot guys.

[Harry72]

Attachements

That`s great. I love it. :nervous:

[mahdiyat`]

YetAnotherAwardSystem1[1].0.1

thanks alot i installed it and working fine on vb 3.0.7

thanks

[dssart]

Looks great so far mtha..are there any other features you are considering adding for the next release? you've come a long way in a short amount of time..

[Polo]

congratulations is looks really good :)

[mtha]

Looks great so far mtha..are there any other features you are considering adding for the next release? you've come a long way in a short amount of time..


No, not for right now, you guys can suggest some

there're some other features like

- Allow members to comment awards given (Idea by Arial)
- Allow member to request awards (maybe)

but I will hold off for a while. If you guys can think of anything interesting, please add to the list.

[moley]

Not sure if i'm the only one getting this but my awards display fine in hybrid and threaded mode but in liner they dont show at all?

[mtha]

Not sure if i'm the only one getting this but my awards display fine in hybrid and threaded mode but in liner they dont show at all?
Download the zip file again
make sure you have the correct changes in showthread.php

or you can wait until the next release and do it :D

[fuse3k]

Thank you very much for this Award hack. This will come in handy.

I need a quick hand though; I received this SQL error in the Admin CP after I added an award:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT *
FROM forumsaward_user
WHERE award_user.award_id=1

mysql error: Unknown table 'award_user' in where clause

mysql error number: 1109

Date: Friday 01st of April 2005 11:25:56 PM
Script: http://forum.tampaimports.com/admincp/award.php?do=awardusers&award_id=1
Referer: http://forum.tampaimports.com/admincp/award.php
Username: Brian
IP Address: 65.xxx.xxx.xxx

I've checked the database. 'award_user' is there...any suggestions? TIA

[mtha]

Thank you very much for this Award hack. This will come in handy.

I need a quick hand though; I received this SQL error in the Admin CP after I added an award:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT *
FROM forumsaward_user
WHERE award_user.award_id=1

mysql error: Unknown table 'award_user' in where clause



It was the prefix problem.
Upload this file into your admincp.php and you will be fine.

[moley]

hehehe i missed one edit. thanks it fixed now.

Found an error. If you put anything like ' in the issue reason it gives you a database error
Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO award_user
(award_id, userid, issue_reason, issue_time)
VALUES ( '1', '2', 'He's', 1112474351)

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's', 1112474351)' at line

mysql error number: 1064

[mtha]

Found an error. If you put anything like ' in the issue reason it gives you a database error


Thanks moley, I missed adding slashed at one query :D

fixed in my code and releasing a new version in few hours


idea: send PM/email to member when he/she got award :D

[Koutaru]

Yes that's actually a great idea too :) Can't wait for the new release (I've been trying to check every day ;))

[mtha]

YAAS 1.1 is AVAILABLE, please check the first post for more information


Hack Version: 1.1.050402

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)

How to UPGRADE/INSTALL:
Read README.txt and follow instructions

[trulylowcarb]

i think I got it first! :D
Seems to be working first try too, (hacked up vb3.07 and cmps1.1 with Gallery)
Now I just need to figure out how to set up award icons and add images and all that...
THANK YOU! Your installer is sweee-eeeet. ^5 "HacNho", which really cracked me up.

[trulylowcarb]

Hmmmm. It IS 430 am here, ....Your hack install instruction is excellent but I haven't a clue how to use this wonderful mod now that it is in there (if it is in there correctly?)

Never mind, I was just being 430 stupid. {Hate that .. but if I hadn't embarrassed myself asking I probably wouldn't have found it, LOL}

[trulylowcarb]

I did find a legitimate oops for you though, an easy one I am sure. There seems to a duplicate column for Award Icon on the main awards page, as shown here.

[Harry72]

Yes, i found this too.

Go to awards_category template and than search for this:

<td class="thead" nowrap="nowrap">$vbphrase[award_icon]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_icon]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_name] /

and replace that with

<td class="thead" nowrap="nowrap">$vbphrase[award_icon]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_image]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_name] /

Cheers
Harry

[mtha]

I did find a legitimate oops for you though, an easy one I am sure. There seems to a duplicate column for Award Icon on the main awards page, as shown here.
:) oops, sorry, it was 4:30 my time too, I grap the wrong template, used it before adding phrases :D The installer was updated with the fix.

make the changes as Harry says, and you will be fine.

For those who see two "Award Icon" columns in the show awards page (/awards.php), please apply Harry's fix above.

If you have a fresh install, you can also run uninstall and re-install script. No file change.

Harry, would you click Install button please :) Thanks

[Harry72]

Ups, sorry - klicked it. :nervous:

[mtha]

Quick fix in showthead.php so that all awards icon will be displayed instead of one (if someone have the same award many times), and optimize the code in that part

Read the attached file or it it's hard to understand, download the zip file again, and open the awards_install_file.html, do the part for showthread.php

[mtha]

Hmmmm. It IS 430 am here, ....Your hack install instruction is excellent but I haven't a clue how to use this wonderful mod now that it is in there (if it is in there correctly?)

Never mind, I was just being 430 stupid. {Hate that .. but if I hadn't embarrassed myself asking I probably wouldn't have found it, LOL}

How to use:

- Find some good award icons and images (some example are given in medals.zip) and upload to your server (or anywhere online)
- Go to ACP/Award Manager, Add award, give it name/description, and URL (full path) to your award icon and image

Now you can go to Award Management, and click "Manage".
In there, you can give award to some user

[mtha]

Check out the YAAS Manual on the download link :D

[trulylowcarb]

I have been playing with it all day! Thanks so much. I just had to poke around, some and apparentlyI missed the manual completely. [blush]

Idea: Displaingy the medals on the member list? woudl be tres cool!

[mtha]

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 attached file./

[Arial]

Ok all installed as you know mtha
Example for people to see

http://www.global-army.com/forum/awards.php?

Please note we have made some minor changes to ours, including

a] Removing small icon (for postbit) from the main awards page
b] Adding 'more medal info' link under medals in postbit.

Donation made , thanks for your help and a great hack Mtha.

[mtha]

Idea: Displaingy the medals on the member list? woudl be tres cool!

Add-on: Display awards in memberlist

Note: right now, I will add this as a add-on. Add to main hack later.


(file expired. added to the hack)

[mtha]

Just for demonstration

limit number of awards show in postbit
added total awards and a link to profile

... seems like it's too quiet here. like not many people want to share awards hah :>

[Harry72]

Just for demonstration

limit number of awards show in postbit
added total awards and a link to profile


... seems like it's too quiet here. like not many people want to share awards hah :>


Good work. I like this hack very much.

Cheers
Harry :nervous:

[mtha]

More ... demo

award request form and result as a post in some forum.


Let me know if you like it or not. I will consider adding to a later release :)

[Nordinho]

More ... demo

award request form and result as a post in some forum.


Let me know if you like it or not. I will consider adding to a later release :)

looks excellent!!

[Harry72]

More ... demo

award request form and result as a post in some forum.


Let me know if you like it or not. I will consider adding to a later release :)

Yes - it looks very very nice. :nervous:

[Arial]

My personal preferece would be if other people could request awards for a member, rather than the member requesting an award for themselves.

[mtha]

My personal preferece would be if other people could request awards for a member, rather than the member requesting an award for themselves.

That's why you need to fill in "Recipient username"

What I am considering here is, what information I need to ask in the form

Right now, I just ask for (fullname - as reference), recipient username, and reason. should that be enough?

[dssart]

If you are really going to get into the "awards nomination" add-on, some points to consider:

1. Award nomination periods. Either by specifying an active nomination period or simply an "on and off" button to activate the nomination option. For example, assume you have a monthly award given out to the member with the most votes. I know as an admin I don't want to see these vote things in my mailbox every day for every month of the year. I would simply specify the dates I want the nominations to begin and the option to vote would become available. For a more inelegant solution, a simple "on and off" button would work.

2. Results tallying. All these nominations should be automatically tallied so I don't have to keep track of who gets so many votes and for which award (if awarding different awards during the same nomination period).

3. One nomination per member, per event. Fairly self-explanatory there. Similar to how the VBulletin polling system handles voting fraud by only allowing you to vote once.

[mtha]

I dont really "get into" the awards request/nomination much, but will consider doing it. yeah, "nomination" is a much better word than request :D, as of considering "award"


If you are really going to get into the "awards nomination" add-on, some points to consider:

1. Award nomination periods. Either by specifying an active nomination period or simply an "on and off" button to activate the nomination option. For example, assume you have a monthly award given out to the member with the most votes. I know as an admin I don't want to see these vote things in my mailbox every day for every month of the year. I would simply specify the dates I want the nominations to begin and the option to vote would become available. For a more inelegant solution, a simple "on and off" button would work.

I'll put a on-off button for this.

2. Results tallying. All these nominations should be automatically tallied so I don't have to keep track of who gets so many votes and for which award (if awarding different awards during the same nomination period).
Rightnow, I just had that request posting to a thread. for function, have to create a database. some information would be something like:
ID - award-ID - recipient - from - reason - time (and approved check for admin)
need also a seach on awards based on time,recipient

3. One nomination per member, per event. Fairly self-explanatory there. Similar to how the VBulletin polling system handles voting fraud by only allowing you to vote once.
hmm, means checking award_id and userid during that time ...

:squareeyed: alot of work here. ok, will get into detail when I work on it, for future release. Thanks dssart

*btw, did you install/click install? :D

[dssart]

Actually I was going to wait until the next release..or should I just go ahead and install it now?

[mtha]

Actually I was going to wait until the next release..or should I just go ahead and install it now?

up to you, maybe you should go ahead and install, since it's gonna take a while until the next one. I have some other work to do.

[Creed]

More ... demo

award request form and result as a post in some forum.


Let me know if you like it or not. I will consider adding to a later release :)

I like, (assuming our conversation is what spawned this) :)

[Lionel]

I can't display in memberlist. The instructions for memberlist are referring to private.php

Can't wait for awards request and limit in postbit.

[Bahrain VIP]

i just fixed it with some error in viewing the member profile .. when r u going to add it to the postbit ?

[Ski-Whiz]

I had minor troubles, but got it to install, after manually entering the cat table, and then adding the default category myself..

Other than that installed ok.. Now to check it out.. :D

So far I like this hack, and will click install upon deciding if I like it.. :D

Thanks!! I love your quick responses to people.. :D Way to stick behind your hacks!!

Good Job!

[mtha]

I can't display in memberlist. The instructions for memberlist are referring to private.php

sorry I post the wrong file. anyway, please wait for the next version coming up.

Can't wait for awards request and limit in postbit.

Limit in postbit will be available in the next release.
for award request, I am considering between my simple request of sending a request/nominate form, or dssart's suggestion. maybe I will make my form available for now, and work on the other options laterz/.

i just fixed it with some error in viewing the member profile .. when r u going to add it to the postbit ?
... what's error do you get? what do you mean by "add it to the postbit"?
the awards are displayed in postbit fine, isnt it?

Questions:

do you guys want to have an option to turn on/off displaying in postbit. memberlist

turn on/off displaying icon/image in awards list?

should I limit the number of awards displayed in memberlist, the same as the number of awards displayed in postbit?

[mtha]

award settings

[dssart]

A suggestion if you are playing with selectable options on how the postbit is displayed..I like how Arial's postbit has the small link displayed for anyone who wants more information about the award. New users will always ask either in the forum or via PM what these little graphics were. This way the entire awards program can be displayed to the newbie. I think Arial's hack on your hack would be a great addition to your..umm..hack.

[Arial]

Told you they would like that Mtha :-) LOL

[mtha]

A suggestion if you are playing with selectable options on how the postbit is displayed..I like how Arial's postbit has the small link displayed for anyone who wants more information about the award. New users will always ask either in the forum or via PM what these little graphics were. This way the entire awards program can be displayed to the newbie. I think Arial's hack on your hack would be a great addition to your..umm..hack.

you mean this?
https://vborg.vbsupport.ru/attachment.php?attachmentid=25419

what "options" should be there, for display?

@Arial, hehe, but I dont like the way I did it for you, so I will have something else better released soon, as in the demo, with total awards, and a link (more...) maybe :P

if you dont want the "more ...", just make it More Medal Info, heheh

[dssart]

you mean this?
https://vborg.vbsupport.ru/attachment.php?attachmentid=25419

I honestly didn't see that..sorry. I like how Arials is laid out though..nothing personal :) I guess changing the link text is easy enough, maybe not for those who aren't used to messing around with this sort of thing though.

what "options" should be there, for display?

Maybe a choice between two or three different "stock" YAAS layouts? similar to how VBulletin offers a choice between layouts. Layouts could be a combination of how awards are displayed ( small and numerous or large and not so numerous ) and how the link text is displayed ( top, bottom )..I'm just shooting out rough ideas..

@Arial, hehe, but I dont like the way I did it for you, so I will have something else better released soon, as in the demo, with total awards, and a link (more...) maybe :P?

Whatever you do, it will be cool. At least you are in the forum and listening to us. That alone deserves praise.

if you dont want the "more ...", just make it More Medal Info, heheh

Understood :)

[mtha]

Maybe a choice between two or three different "stock" YAAS layouts? similar to how VBulletin offers a choice between layouts. Layouts could be a combination of how awards are displayed ( small and numerous or large and not so numerous ) and how the link text is displayed ( top, bottom )..I'm just shooting out rough ideas..

You admins (who install the hack) should decide what and how to display awards, shouldnt you?
I dont see a point of switching between small+numerous and large+afew in a long run. you just need to decide from the beginning, and go with it. if you want to have it big, make your "icon" big, and limit the awards being displayed "few" (like what Arial has), and vice versa. one time deal.

[dssart]

Sure..no problem..you seemed to be interested in hearing suggestions, I offered suggestions. No big deal.

[mtha]

Sure..no problem..you seemed to be interested in hearing suggestions, I offered suggestions. No big deal.
:) we just discuss to get the best out of it. as long as you can make me think it's good, I will do it :) the more suggestions we have, the better product we're gonna get, you know.

[mtha]

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
- Modify awards_install.php


Please read the UPGRADE5.txt for more information


File changed in this version:

/admincp/index.php => add link to awards system settings
member.php
showthread.php => limit awards to display, and show link in postbit
showpost.php => limit awards to display, and show link in postbit
announcement.php => limit awards to display, and show link in postbit
private.php => limit awards to display, and show link in postbit
memberlist.php => NEW, show award in memberlist
/include/functions_online.php => NEW, show location in WhoisOnline

Templates changed in this version:

MEMBERINFO
postbit => show # of awards and link to profile
postbit_legacy => show # of awards and link to profile
memberlist => NEW, show award in memberlist
memberlist_resultsbit => NEW, show award in memberlist

[Lionel]

So basically there was no files change in this upgrade? I just upgraded and all the changes were already done. About templates? Where do we add that new link?

[mtha]

So basically there was no files change in this upgrade? I just upgraded and all the changes were already done. About templates? Where do we add that new link?


Basically, you need to make changes for some new functions to work.

File changed in this version:

/admincp/index.php => add link to awards system settings
member.php
showthread.php => limit awards to display, and show link in postbit
showpost.php => limit awards to display, and show link in postbit
announcement.php => limit awards to display, and show link in postbit
private.php => limit awards to display, and show link in postbit
memberlist.php => NEW, show award in Memberlist
/include/functions_online.php => NEW, show location in WhoisOnline

Templates changed in this version:

MEMBERINFO
postbit => show # of awards and link to profile
postbit_legacy => show # of awards and link to profile
memberlist => NEW, show award in memberlist
memberlist_resultsbit => NEW, show award in memberlist

[TTG]

After running the upgrade the additional column is now in the memberlist but not showing any awards even though the awards are showing in the member profile. Do the awards only show in the member list for new awards achieved after this upgrade.

[mtha]

nal column is now in the memberlist but not showing any awards even though the awards are showing in the member profile. Do the awards only show in the member list for new awards achieved after this upgrade.


Did you edit the memberlist.php file amd upload to your server?

[TTG]

Did you edit the memberlist.php file amd upload to your server?

$globaltemplates = array(
'awards_bit'
);

Yep :) .. still only showing the additional column.

[trulylowcarb]

Looking forward to installing the update, since I now need to incorporate a nomination and voting system for the Member of the Month awards I have created ... thanks again for this hack, I will be donating very soon! (Gotta get through tax day tomorrow, first.)

[fuse3k]

It was the prefix problem.
Upload this file into your admincp.php and you will be fine.

Worked perfectly. Thank you.

[Lionel]

Basically, you need to make changes for some new functions to work.

File changed in this version:

/admincp/index.php => add link to awards system settings
member.php
showthread.php => limit awards to display, and show link in postbit
showpost.php => limit awards to display, and show link in postbit
announcement.php => limit awards to display, and show link in postbit
private.php => limit awards to display, and show link in postbit
memberlist.php => NEW, show award in Memberlist
/include/functions_online.php => NEW, show location in WhoisOnline

Templates changed in this version:

MEMBERINFO
postbit => show # of awards and link to profile
postbit_legacy => show # of awards and link to profile
memberlist => NEW, show award in memberlist
memberlist_resultsbit => NEW, show award in memberlist

are you sure you put upgrade files. Those instructions included were alreay done.

[mtha]

$globaltemplates = array(
'awards_bit'
);

Yep :) .. still only showing the additional column.

agrr, my bad. I forgot to change the "Find in File /private.php" with the correct file name in two spots :(

do the next changes that was named private.php next to it too. and the one bellow that for functions_online.php

or you can download the instruction again.

sorry.,


Looking forward to installing the update, since I now need to incorporate a nomination and voting system for the Member of the Month awards I have created ... thanks again for this hack, I will be donating very soon!

what's your "voting system"? sounds like fun :D


(Gotta get through tax day tomorrow, first.)

agrrr, I forgot this too :(, have to do it today :(

[p h o e n i x x]

Mine will not show up in my postbit template. :-(
Help.

- PX

[mtha]

Mine will not show up in my postbit template. :-(
Help.

- PX

make sure you have the following:

Pre-requirement:
1. You have some awards in stock
2. The member you are looking at, has some award
3. You have the option Display in postbit = YES
4. Maximum Awards Displayed > 0

make sure you did the follwing changes:


<edit file>
showthread.php
</edit file>

<search for>
'pollresult',
</search for>

<replace>
'pollresult',
'awards_bit'
</replace>

<search for>
if (!($forumperms & CANGETATTACHMENT))
{
$vboptions['viewattachedimages'] = 0;
$vboptions['attachthumbs'] = 0;
}

$postcount = ($pagenumber - 1 ) * $perpage;
</search for>

<add before>
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
if ($vboptions['aw_postbit'])
{
// 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 $postids
GROUP BY au.issue_id
");
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']
</add before>

<search for>
while ($post = $DB_site->fetch_array($posts))
{
</search for>

<add after>
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
$post['userawards'] = '';
$post['showuserawards'] = false;
if ($vboptions['aw_postbit'])
{
if (is_array($userawardscache[$post[userid]]))
{
$aw_i = 0;
$post['num_awards'] = count($userawardscache[$post[userid]]);
foreach($userawardscache[$post['userid']] AS $award_id => $award)
{
$aw_i++;
if ($aw_i <= $vboptions['aw_display_limit'])
{
eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
}
}
$post['showuserawards'] = true;
}
}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']

</add after>

<search for>
// re-initialise the $postarray variable
$postarray = array();
while ($post = $DB_site->fetch_array($cacheposts))
{
</search for>

<replace>
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
if ($vboptions['aw_postbit'])
{
// 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
");
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']

// re-initialise the $postarray variable
$postarray = array();
while ($post = $DB_site->fetch_array($cacheposts))
{

// [START HACK='Yet Another Award System' AUTHOR='HacNho']
$post['userawards'] = '';
$post['showuserawards'] = false;
if ($vboptions['aw_postbit'])
{
if (is_array($userawardscache[$post[userid]]))
{
$aw_i = 0;
$post['num_awards'] = count($userawardscache[$post[userid]]);
foreach($userawardscache[$post['userid']] AS $award_id => $award)
{
$aw_i++;
if ($aw_i <= $vboptions['aw_display_limit'])
{
eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
}
}
$post['showuserawards'] = true;
}
}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']
</replace>


Make sure you did edit postbit (or postbit_legacy) template on the current using style.


<!-- show awards -->
<if condition="$post[showuserawards]">
<div>
$post[userawards]
<br>
$vbphrase[total_awards]: $post[num_awards] (<a href="member.php?$session[sessionurl]u=$post[userid]#award">$vbphrase[more_awards] ...</a>)
</div>
</if>
<!-- /show awards -->


That's all what you need to do to show awards in "showthread", edit other files for other pages.

Hope you can get something out of it. It's hard to help if you provide me NO information, except saying "It will not show up"

[TTG]

agrr, my bad. I forgot to change the "Find in File /private.php" with the correct file name in two spots :(

do the next changes that was named private.php next to it too. and the one bellow that for functions_online.php

or you can download the instruction again.

sorry.,
(

Thanks mtha ... that fixed the problem .. thought I was going code crazy

[mtha]

Thanks mtha ... that fixed the problem .. thought I was going code crazy


I still suggest you to install BoardMod and let it edit files automatically. it's quick, and it's easy. it also has option to show you to edit step by step too. I create the "file edit" mod in that program, before ... making the html instructions.

[RED_LINE]

nice hack

i have this error

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE
GROUP BY au.issue_id
ORDER BY au.issue_time

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY au.issue_id
ORDER BY a

mysql error number: 1064

Date: Friday 15th of April 2005 09:50:46 AM
Script: http://www.xxx.net/vb/showthread.php?p=388449
Referer: http://www.xxx.net/vb/
Username: RED_LINE
IP Address: 62.150.45.128

.....
how can i fixed this error?

Regards,

[mtha]

nice hack

i have this error

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE
GROUP BY au.issue_id
ORDER BY au.issue_time

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY au.issue_id
ORDER BY a

mysql error number: 1064

Date: Friday 15th of April 2005 09:50:46 AM
Script: http://www.xxx.net/vb/showthread.php?p=388449
Referer: http://www.xxx.net/vb/
Username: RED_LINE
IP Address: 62.150.45.128

.....
how can i fixed this error?

Regards,

is that when you showthread? are you sure you did change the file correctly?

I DONOT have anything in showthread.php that ORDER BY au.issue_time, Could you check the awards_install_file.html and make the correct changes to the file? if the errors still there, send me the showthread.php that you have.

here's what you need to change in showthread.php:




<edit file>
showthread.php
</edit file>

<search for>
'pollresult',
</search for>

<replace>
'pollresult',
'awards_bit'
</replace>

<search for>
if (!($forumperms & CANGETATTACHMENT))
{
$vboptions['viewattachedimages'] = 0;
$vboptions['attachthumbs'] = 0;
}

$postcount = ($pagenumber - 1 ) * $perpage;
</search for>

<add before>
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
if ($vboptions['aw_postbit'])
{
// 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 $postids
GROUP BY au.issue_id
");
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']
</add before>

<search for>
while ($post = $DB_site->fetch_array($posts))
{
</search for>

<add after>
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
$post['userawards'] = '';
$post['showuserawards'] = false;
if ($vboptions['aw_postbit'])
{
if (is_array($userawardscache[$post[userid]]))
{
$aw_i = 0;
$post['num_awards'] = count($userawardscache[$post[userid]]);
foreach($userawardscache[$post['userid']] AS $award_id => $award)
{
$aw_i++;
if ($aw_i <= $vboptions['aw_display_limit'])
{
eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
}
}
$post['showuserawards'] = true;
}
}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']

</add after>

<search for>
// re-initialise the $postarray variable
$postarray = array();
while ($post = $DB_site->fetch_array($cacheposts))
{
</search for>

<replace>
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
if ($vboptions['aw_postbit'])
{
// 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
");
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']

// re-initialise the $postarray variable
$postarray = array();
while ($post = $DB_site->fetch_array($cacheposts))
{

// [START HACK='Yet Another Award System' AUTHOR='HacNho']
$post['userawards'] = '';
$post['showuserawards'] = false;
if ($vboptions['aw_postbit'])
{
if (is_array($userawardscache[$post[userid]]))
{
$aw_i = 0;
$post['num_awards'] = count($userawardscache[$post[userid]]);
foreach($userawardscache[$post['userid']] AS $award_id => $award)
{
$aw_i++;
if ($aw_i <= $vboptions['aw_display_limit'])
{
eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
}
}
$post['showuserawards'] = true;
}
}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']
</replace>

[RED_LINE]

hello

yes im sure about change the file correctly

the error somtimes apear not alaways :rolleyes:

can you check showthread.php plz

Regards,

[Marco van Herwaarden]

Red Line

Please remove that file immediate. It is against your license agreement and against our forum rules to post vB files.

[Dean C]

I've removed your file Red Line :)

[mtha]

hello

yes im sure about change the file correctly

the error somtimes apear not alaways :rolleyes:

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.



the error somtimes apear not alaways :rolleyes:

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]

thankyou MarcoH64

no porblem Dean :nervous:

:"> 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

// [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]

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]

i see that code you told me

(ORDER BY au.issue_time) at line 1304

// [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]

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]

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]

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.

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]

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]

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"

[dark dragun]

I think I need to create the award_cat table again, cause when I click on Award Category Manager I get a error

Could not find phrase 'no_award_categories_found'.

Also when clicking Award Manager, or Add New Award I get this error

(Fatal error: Cannot redeclare construct_depth_mark() (previously declared in D:\Inetpub\wwwroot\forums\admincp\award.php:91) in D:\Inetpub\wwwroot\forums\includes\adminfunctions. php on line 1235)

should i delete all 3 awards tables and run query manually for this part ?
if so whats the code ? I try useing whats in awards_install.php under updateds - Run Querys, and created the tables that way but as you can see some thing is wronge. I need a little help.

[mtha]

I think I need to create the award_cat table again, cause when I click on Award Category Manager I get a error

Could not find phrase 'no_award_categories_found'.

Also when clicking Award Manager, or Add New Award I get this error

(Fatal error: Cannot redeclare construct_depth_mark() (previously declared in D:\Inetpub\wwwroot\forums\admincp\award.php:91) in D:\Inetpub\wwwroot\forums\includes\adminfunctions. php on line 1235)

should i delete all 3 awards tables and run query manually for this part ?
if so whats the code ? I try useing whats in awards_install.php under updateds - Run Querys, and created the tables that way but as you can see some thing is wronge. I need a little help.

Seems like you were upgrading, and you might have to go through "step 1b" where it says
IF you upgrade from YAAS 1.0 and DID NOT have Award Category, click here to CREATE Category Table -->

if you dont have anything yet, you can just un-install and install it again. it's easier.

anyway, I update the award_cat.php to fix the category error.

You may need to create a category first, before adding award. in the installation, I have a default category, but you missed that by one step.

[dark dragun]

Installed

Thank you so much, wow support at 1:30 a.m. lmao so cool. I redownloaded the zips. I than removed all querys from awards_install.php and manually ran the querys, then ran my edited awards_install.php which skipped the query section and finished the rest step. Maybe you should leave it out had have people run it manually.
Once again thanks so much this hack is awsome !

[deathemperor]

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?
It's ok if you don't do the auto awards it's easier with cron jobs for this right ?

other parts are good, I think you should make it, I'm looking forward to it (wait for an update mail ^^).

[playstation]

I went to install this today and when i run the installer i am getting this error

Parse error: parse error, unexpected '}' in /backup/home/carzone/public_html/forum/admincp/awards_install.php on line 126

This is lines 126-128

126 }
127 }
128 echo "<font size=\"1\">Updated Setting - $varname </font><br />";

[mtha]

I went to install this today and when i run the installer i am getting this error

Parse error: parse error, unexpected '}' in /backup/home/carzone/public_html/forum/admincp/awards_install.php on line 126

This is lines 126-128

126 }
127 }
128 echo "<font size=\"1\">Updated Setting - $varname </font><br />";


strainge. I have enough } in there. do you have the latest awards_install.php? just to make sure, download the zip file again, and use the installer in there.

- whats is the process running when you get the error?
something like:


Updated Phrase - award_settings
Updated Phrase - request_award
Updated Phrase - total_awards
Updated Phrase - more_awards

Phrases Updated Successfully

Updated Phrase - settinggroup_awards
Updated Phrase - setting_aw_memberlist_title
Updated Phrase - setting_aw_memberlist_desc
Updated Setting - aw_memberlist

[MikeGK]

This hack looks amazing, but it would be more awesome if we could have a place where an award winner could fill in their name and home address to claim for prizes. We're talking about real awards. Maybe there's a button where they can click on to claim and after clicking on the claim button it will prompt to fill in personal info where the admin can then send real prizes to the winners. The claim button can be in the postbit or user profile. Thanz

[gigaenvy]

Upgrade to 1.2.0 and received this error as well


Parse error: parse error, unexpected '}' in /home/mmotri2/public_html/forums/admincp/awards_install.php on line 126


Edit: Fixed it myself knowing less than zilch about vbulletin or php syntax.

I added a trailing ';' at the end of 'WHERE varname' statement.


{
$DB_site->query("UPDATE " . TABLE_PREFIX . "setting SET grouptitle = '$settinggroup' " .
iif($value, ", value = '" . $value . "'") .
iif($defaultvalue, ", defaultvalue = '" . $defaultvalue . "'") .
iif($optioncode, ", optioncode = '" . $optioncode . "'") .
iif($displayorder, ", displayorder = '" . $displayorder . "'") .
" WHERE varname = '$varname'");
}

[dark dragun]

I got this hack installed and working, but I need help with one thing.
I have mine set up after someone request a award, a new thread is started stating the request with no replys, and a poll option. Also a pm is set to admins and mods. My problem is when you read the request in the thread or if its email or pm to you they all have this bold tag in them twice as you can see below. How can I remove these ?

Dark Dragun Award Request Form

--------------------------------------------------------------------------------


Award Request Form - Dark Dragun

------------------
Sender Information

UserID: 1
Username: Dark Dragun
Fullname: Dark Dragun

-----------------------------
Request Information:
Award ID: 3
Award Name : Distinguished Service Cross
Award Description : Awarded to AMA Special Forces who have distinguished themselfs by extraordinary heroism.[b]


Recipient username : [b] Dark Dragun

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

test
-----------------------------------------------------

Update: I dont know how to paste code here per rules, but I can tell you were my error was. It was in awards_request_formanswers template. Left out a slash in the last bold tag toward the bottom, I know did this late a night huh ? lol I love your hack thanks again.

[mtha]

Upgrade to 1.2.0 and received this error as well

Edit: Fixed it myself knowing less than zilch about vbulletin or php syntax.

I added a trailing ';' at the end of 'WHERE varname' statement.

Thanks gigaenvy, someone had an error with ";" and I removed the wrong ; by mistake :">

the file was updated.


Update: I dont know how to paste code here per rules, but I can tell you were my error was. It was in awards_request_formanswers template. Left out a slash in the last bold tag toward the bottom, I know did this late a night huh ? lol I love your hack thanks again.

fixed in installer too. :"> actually you nead a closing [/b] instead of [b] at the end of $award[award_desc]


This hack looks amazing, but it would be more awesome if we could have a place where an award winner could fill in their name and home address to claim for prizes. We're talking about real awards. Maybe there's a button where they can click on to claim and after clicking on the claim button it will prompt to fill in personal info where the admin can then send real prizes to the winners. The claim button can be in the postbit or user profile. Thanz

You can make another form for this. just like the "Award request form". Look over Dr Erwin Loh for FORM TO THREAD/ FORUM/ PM/ EMAIL hack for detail.

[My 351]

Excellent hack mtha, and great support for it from what I've seen. Glad to have it, thanks.

[mtha]

Excellent hack mtha, and great support for it from what I've seen. Glad to have it, thanks.
:) Thanks

[playstation]

Upgrade to 1.2.0 and received this error as well



Edit: Fixed it myself knowing less than zilch about vbulletin or php syntax.

I added a trailing ';' at the end of 'WHERE varname' statement.


{
$DB_site->query("UPDATE " . TABLE_PREFIX . "setting SET grouptitle = '$settinggroup' " .
iif($value, ", value = '" . $value . "'") .
iif($defaultvalue, ", defaultvalue = '" . $defaultvalue . "'") .
iif($optioncode, ", optioncode = '" . $optioncode . "'") .
iif($displayorder, ", displayorder = '" . $displayorder . "'") .
" WHERE varname = '$varname'");
}


That worked,thank you.

Hack is now installed and working great. :D

[SHANE-D-PAIN]

love it, ive installed it on Teen Forums (http://www.teenageforums.com)

[mtha]

love it, ive installed it on Teen Forums (http://www.teenageforums.com)
If you have image and icon exactly the same, you can just display one of them in the awards list.

[apokphp]

For some reason, there is a direct to a different forum: http://www.hn-ams.org/forum/ (my site is www.onlinedebate.net)

This happens when you click on the award graphic, user's name, or userid of the submitter, when it has been set to start a new thread automatically to show the results of the request form.

How to fix?

[mtha]

For some reason, there is a direct to a different forum:(my site is www.onlinedebate.net (http://www.onlinedebate.net))

This happens when you click on the award graphic, user's name, or userid of the submitter, when it has been set to start a new thread automatically to show the results of the request form.

How to fix?

oops
Please go to your ACP, edit this template awards_request_formanswers
and replace content with:


=================================

$formtitle - $bbuserinfo[username]

------------------
Sender Information
$vboption
UserID: /member.php?u=$bbuserinfo[userid]]$bbuserinfo[userid] ($vboptions[bburl)
Username: $bbuserinfo[username]
Fullname: $answer1

-----------------------------
[b]Request Information:
Award ID: /awards.php#award$award[award_id]]$award[award_id] ($vboptions[bburl)
$vbphrase[award_name]: $award[award_name]
$vbphrase[award_description]: $award[award_desc]
/awards.php#award$award[award_id]]$award[award_img_url] ($vboptions/forum/member.php?username=$answer2] $answer2 ($vboptions[bburl)

-----------------------------------------------------
$longquestion1

$longanswer1
-----------------------------------------------------

[trulylowcarb]

Preparing to upgrade from 1.1.0 to 1.2.0 (and it isn't even the middle the night, LOL, how strange) and I can't seem to find the "forum/admincp/awards_install.php?do=upgrade" file in the new zip package. Should I just run the regular install file that's included?

Thanks a heap for adding the member list feature. Your support is superb and I'm headed over to paypal to donate right NOW. :D

You asked about the voting system I would use - I don't have one yet, but I intend to ask my members to nominate other members for a Member of the Month award and then hold a poll to let the members pick the winner, who will receive 2 free months of supporter status (ad-free browsing, among other benefits I have set up for paying members). As I haven't used Erwin's form hack yet (but have looked at it and want to) maybe you've already got me covered there, I am not sure .... but that is definitely the easy part. You've made the rest real easy. Thanks again,
trulylowcarb

[mtha]

Preparing to upgrade from 1.1.0 to 1.2.0 (and it isn't even the middle the night, LOL, how strange) and I can't seem to find the "forum/admincp/awards_install.php?do=upgrade" file in the new zip package. Should I just run the regular install file that's included?

run that from browser, or you just run .../admincp/awards_install.php and select "upgrade"

Remember that, if you didnt have "award category" before, you need to go through step 1b (it will ask when you upgrade)
If you already have Award Categories, skip that step.

Thanks a heap for adding the member list feature. Your support is superb and I'm headed over to paypal to donate right NOW. :D


Thank you very much, I got it.

[PIKenPIK]

Medals were a big success on my PHPBB ....

So i really needs it for my VB ...

PIKenPIK clicks INSTALL ... More than ThanXXxx a Lot ;)

[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]

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]

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 :D

[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]

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]

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 :D

[anarchystar]

Install finished ... can't wait to try it out. Thanks for the help :D

[mtha]

future:
- 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)



which do you want to have in the hack first :) and anything else do you want to see for the next releasae?

[dssart]

Is there a way to allow only certain members of a group the ability to display an award? I want to offer the ability to display an award only to those who subscribe to my forum. Once their subscription ends, and if they are no longer part of a subscription group, I want the award to dissappear. Anything like this present in YAAS?

[mtha]

Is there a way to allow only certain members of a group the ability to display an award? I want to offer the ability to display an award only to those who subscribe to my forum. Once their subscription ends, and if they are no longer part of a subscription group, I want the award to dissappear. Anything like this present in YAAS?

no, nothing like that yet.

so you want to allow some group to "see" the award list, and other people awards, or awards of those who are in some group being seen/not seen by all others?

[dssart]

No, sorry I'm not being clear..

I have a section on my forum which is for paying users only. All memberships for this group are handled via the VBulleting subscription system. If the member doesn't renew their yearly subscription, they are removed from the group automatically.

All paid members will be given badges. I want the award to automatically expire if the member is no longer a subscriber. Similar to how VBulletin will drop a user from a subscribers only group when they fail to renew their membership.

[PIKenPIK]

future:
- 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)
which do you want to have in the hack first :) and anything else do you want to see for the next releasae?
PM/Email user when he/she get an award.
Is one of the functions I really miss. So this one should be the 2nd moderation in this excellent hack (works like a charm, and because of the many phrases it's very suitable for a different-language-board :up: )

What I really, really (5 times) miss:

I'm a busy admin and it becomes more than very handy, just like the medal-mod on my old phpbb, if another moderator (or more moderators/crewmembers) could give the medals to the members.
So is there an option i can assign moderator(s)/member(s) to control the medals?
Create medals & categories should still be done by the admin only.
Maybe it's possible to cut a peace of the admincp-code into modcp?

Looking forward to some great coding-work by you :D

[mtha]

PM/Email user when he/she get an award.
Is one of the functions I really miss. So this one should be the 2nd moderation in this excellent hack


Thanks, but my time is alitbit tight right now, the next version wont be here for a while.



I'm a busy admin and it becomes more than very handy, just like the medal-mod on my old phpbb, if another moderator (or more moderators/crewmembers) could give the medals to the members.
So is there an option i can assign moderator(s)/member(s) to control the medals?
Create medals & categories should still be done by the admin only.
Maybe it's possible to cut a peace of the admincp-code into modcp?
Looking forward to some great coding-work by you :D

I will think more about this. currently, I give access to some people to get into ACP, and do the award management plus basic admin functions.

[Mattius]

Ive set it up and it works fine apart from two things.

- When im editing categories or adding awards, it wants to keep forcing me to log in all the time...That could be a problem though with how i have the board setup.

- I have it set to send me pm's and within those PM's all the links are substituted for http://yourdomain.com...instead of my real domain. Obviously ive overlooked something but i cant find a referance to that hardcoded in any of the files.

[mtha]

Ive set it up and it works fine apart from two things.

- When im editing categories or adding awards, it wants to keep forcing me to log in all the time...That could be a problem though with how i have the board setup.
should be. there's nothing special in the category editing part.


- I have it set to send me pm's and within those PM's all the links are substituted for http://yourdomain.com...instead of my real domain. Obviously ive overlooked something but i cant find a referance to that hardcoded in any of the files.

it is in template awards_request_formanswers
I think I have mentioned in the installation, didnt I?

[Flow Fusion]

looks great will install.

[deb0]

I tried to fix this and screwed up my awards_request_formanswers template.

Can someone please post the original template?

Here is the problem I was trying to fix:

When postbit information that is submitted in forum x has invalid links "//yourdomain/forum/ etc... I did a replace all on these, and as a result, it fixed all the links but no longer shows the image of the award. Instead it shows the url - $award[award_img_url][/img][/url].

I would like the image to show up. Help!

[mtha]

I tried to fix this and screwed up my awards_request_formanswers template.

Can someone please post the original template?

Here is the problem I was trying to fix:

When postbit information that is submitted in forum x has invalid links "//yourdomain/forum/ etc... I did a replace all on these, and as a result, it fixed all the links but no longer shows the image of the award. Instead it shows the url - $award[award_img_url][/img][/url].

I would like the image to show up. Help!

Supposed that you didnt edit the master template. if so, you just need to run "reverse" to get to the original template.

otherwise, you can open the install file, look for
$awards_request_formanswers_content

[Logik]

I have this installed and it works out great. Good job.

[Mr. Brian]

Well, is it possible to set permission to allow my mod to give out awards to user aswell?

[Flow Fusion]

Well, is it possible to set permission to allow my mod to give out awards to user aswell?

Dito.

[deb0]

Dito.

Ditto x2.

[mtha]

Well, is it possible to set permission to allow my mod to give out awards to user aswell?

you can always set someone to access ACP, with basic functions, to manage the awards

I've been working too much with admincp, maybe a copy in modcp be better. Will consider it.
Thanks
:)

[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:


Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,pa getext,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 (http://www.clanforums.com/forum/member.php?u=4)
Username: CFN|LordSoth
Fullname: CFN|LordSoth

-----------------------------
Request Information:
Award ID: 3 (http://www.clanforums.com/forum/awards.php#award3)
Award Name: Donationaward
Award Description: Thanks for your donation
https://vborg.vbsupport.ru/ (http://www.clanforums.com/forum/awards.php#award3)

Recipient username : Toky (http://www.clanforums.com/forum/member.php?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:
UPDATE " . TABLE_PREFIX . "thread SET

[Jagged Tooth]

I'm just having a few problems with the layout. If you look Here (http://www.forums.runevengeance.com/memberlist.php?) the usrenames are no longer in the table. Also Here (http://www.forums.runevengeance.com/member.php?u=3) (along with all the other usernames) the Icon contains the image, image contains the description and description is empty. Everything else is fine though.

And just the usuals.
PHP: 4.3.10
mySQL: 4.1.11-standard
Vb: 3.0.7

Any ideas

--Jagged Tooth--

[donBLACK]

i did al the mods and the install but the awards still wont show in the postbit...even after i edited the templates

www.undergroundmic.com/forums

[deb0]

Excellent hack! My members are very happy with this. So much that many have requested the following:

A CMPS module that would display the last x members to receive and award. Can this be added to the next release?

[Polo]

Excellent hack! My members are very happy with this. So much that many have requested the following:

A CMPS module that would display the last x members to receive and award. Can this be added to the next release?
yeah.. that would be nice :)

[Jagged Tooth]

I just noticed that when I got to the Polls section in my AdminCP that there are polls for all the test award requests I made. Is there a way to vote in these polls and a way to delete them?

[lange]

thanks

[PIKenPIK]

I just noticed that when I got to the Polls section in my AdminCP that there are polls for all the test award requests I made. Is there a way to vote in these polls and a way to delete them?

edit the request_award.php

there you can manage the way where the request need to be posted ..
in your case: post in thread (with poll).

[paul41598]

I wish there was a way to award a member from a thread instead of the admincp. That'd be cool

[Mr. Brian]

I wish there was a way to award a member from a thread instead of the admincp. That'd be cool
Ya, thats was a nice ideal..

[lange]

Install

[King Kovifor]

If I get this installed can we make it so that it's text not an image?

[oman]

thanx

put can u Update it for 3.5.0

thanx

[Neal-UK]

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:


Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,pa getext,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
http://www.clanforums.com/forum/images/medals/contributoraward.gif

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:
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:

Database error in vBulletin 3.0.7:

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

------------------
Sender Information

UserID: 1 (http://www.socialoutkast.com/forum/member.php?u=1)
Username: biagrin
Fullname: biagrin

-----------------------------
Request Information:
Award ID: 1 (http://www.socialoutkast.com/forum/awards.php#award1)
Award Name: test
Award Description: testing awards
https://vborg.vbsupport.ru/external/2005/07/4.gif (http://www.socialoutkast.com/forum/awards.php#award1)

Recipient username : biagrin (http://www.socialoutkast.com/forum/member.php?username=biagrin)

-----------------------------------------------------
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: http://www.socialoutkast.com/forum/request_award.php
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]

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?

[FusionHosting]

Ok, well I ran the award_install.php again, tried to run it's install link but that had an error. So I ran the upgrade link which went through fine. Looks like it reset a number of the settings though. I'm concerned it may have wiped out some 3.08 template changes too?

My forums are still functional though.

[jluerken]

Ok, well I ran the award_install.php again, tried to run it's install link but that had an error. So I ran the upgrade link which went through fine. Looks like it reset a number of the settings though. I'm concerned it may have wiped out some 3.08 template changes too?

My forums are still functional though.

As far as I know its only adding own templates and not modifying any original one.
Good to hear that its working for you again :D

[Eagle Creek]

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

Is it 3.5 compatible?

Is it possible to also let my mods give the awards?

[MillerLight]

Hello,

Is there any services available that would install this particular hack on a vB Version: 3.0.8 release?

Miller_Light

[Marco van Herwaarden]

If you don't feel comfortable doing it yourself, you can always request someone do it for a small payment for you in the Service Request forum.

[Boguns]

I installed the awards system, did all the editing but it still only shows in the member profile. I cant get it to show in postbit....help?

[mtha]

:) Seems like people are having problems here. Sorry I was away for a while. Will get back to you guys.


I havent install vb3.5 yet, but I will upgrade it for 3.5 (dont have any deadline yet)


for those who got the error something like



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



find the line 1109 in the file that you are calling, replace

SELECT * FROM " . TABLE_PREFIX . "award_cat

by

SELECT * FROM " . TABLE_PREFIX . "award_cat AS award_cat

any place that are missing " . TABLE_PREFIX . ", please add the prefix in.

I will take a look at my files and correct it.

Thanks for using YAAS!

[mtha]

upgrade from 1.2.0 to 1.2.1:
for those who have PREFIX in the database tables, and get database error, please re-upload the new files in 1.2.1 version

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)

[mtha]

Excellent hack! My members are very happy with this. So much that many have requested the following:

A CMPS module that would display the last x members to receive and award. Can this be added to the next release?

I dont use CMS, but this could be done, I will think about this.

I wish there was a way to award a member from a thread instead of the admincp. That'd be cool
Awards should be given by admin. why should it be given in a thread?

If I get this installed can we make it so that it's text not an image?
There's a field called Award Name, you can edit the right templates to display Award Name instead of its images. Which templates need to be edited depends on where you want to display what. it's not an option by default.


Ok, well I ran the award_install.php again, tried to run it's install link but that had an error. So I ran the upgrade link which went through fine. Looks like it reset a number of the settings though. I'm concerned it may have wiped out some 3.08 template changes too?

My forums are still functional though.

vb3.0.8 upgrade was wipe out the original YAAS settings, so you just need to run the upgrade link again, it will add the YAAS templates back. No vB templates are changed during this process.

Check to make sure all the settings are still correct.


Again, if anyone get database error, due to table prefix, please upgrade to YAAS 1.2.1 by replacing (awards.php, request_award.php)

You may also need to re-edit the award_request.php for your custom settings.

[mtha]

Update: I am converting this hack to 3.5.0.

Award Mamager: done.
Display award list: done

display awards in postbit, memberlist ... : working

it may still require file editing, hope you wont mind doing it :D

[mtha]

The version for vBulletin 3.5.0 has been released here:

https://vborg.vbsupport.ru/showthread.php?t=94836

Have fun

[commTRU]

Thanks for the great awards system, installed flawlessly ^^;;

Well, when I say flawlessy, I spent a good 10 minutes trying to figure out how to award members. I thought the 'Manage' option was just to edit LOL I'm just very stupid, so thank you for the manual :D

*clicks install*

[mtha]

Thanks for the great awards system, installed flawlessly ^^;;

Well, when I say flawlessy, I spent a good 10 minutes trying to figure out how to award members. I thought the 'Manage' option was just to edit LOL I'm just very stupid, so thank you for the manual :D

*clicks install*

:) yeah, that's what the manual for.

[o0Hubba0o]

The version for vBulletin 3.5.0 has been released here:

https://vborg.vbsupport.ru/showthread.php?t=94836

Have fun
Great! Once 3.5 is gold and the arcade is going I'll be switching over for sure now! The awards system is great for my graphics forum!

[blackpheonix]

great hack had to make a small change to navbar template so users can view the awards page but well done.

/me installs

[elemoum]

I get this Parse Error...

Parse error: parse error, unexpected $ in /var/www/web3/cg-cars.com/html/forum/showthread.php on line 1791

but my showthread.php has only 1790 lines.

[mtha]

you may have some blank line on that file, remove any space at the end of that file and see you it come out.

[elemoum]

I havent got a blank line at the end. last thing is the php tag "?>" in line 1790. I have Version 3.0.9 of vbulletin. plz help me dude...same error in memberlist.php!!

[mtha]

dont see any error on your site.

check and see if you have wrong $ somewhere.

[Lottis]

*installed* Great hack. Works fine in 3.0.9

[Lottis]

great hack had to make a small change to navbar template so users can view the awards page but well done.

* blackpheonix installs
Could you share that?

[mtha]

just add this link <a href="awards.php">Awards</a> to the place that you want to display it.

in navbar, you may need a <td></td> outside.

[Lottis]

just add this link <a href="awards.php">Awards</a> to the place that you want to display it.

in navbar, you may need a <td></td> outside.
Thanx a lot. :)

[SouthernTn]

my award images are not showing up when I add the url..

[Lottis]

I got a problem. I dont get the emails about award request.

[Stargesicht]

first i will say sorry for my bad english.
This Mod works in my Forum perfekt.

Now i want to chance the settings so, a Supermoderator or an other Admin with not all permissions can manage the awards too.

[zzzxxzzz]

co xai duoc cho 3.0.9 khong vay

[tnguy3n]

co xai duoc cho 3.0.9 khong vay

i think he got a version for vb 3.0 too. check his profile for the link ;)

[Stargesicht]

I used 3.0.8.....

[mtha]

my award images are not showing up when I add the url..

which URL are you talking about?


I got a problem. I dont get the emails about award request.

you have to configure the award-request setting, in order to receive information as you want'



Now i want to chance the settings so, a Supermoderator or an other Admin with not all permissions can manage the awards too.

There's No setting to do this. You can try to upload the files in admincp to modcp, and see if your fellow can use it. I cant give further modification at this time.


co xai duoc cho 3.0.9 khong vay

Yes.
Compatible vB version: 3.0.8. It should work with all vB 3.0.x versions.

[almqdad]

hi

when I click member list i get this error

'usercp_nav_folderbit', 'awards_bit'


Unable to add cookies, header already sent.
File: /home/vrfihres/public_html/forum/memberlist.php
Line: 5

and if i disablemember list i get this error

'usercp_nav_folderbit', 'awards_bit'
Warning: Cannot modify header information - headers already sent by (output started at /home/vrfihres/public_html/forum/memberlist.php:5) in /includes/functions.php on line 2869

I want also to disable request form completely

also is thereaway to display award image instead of icon in member profile

some one help

[mtha]

hi

when I click member list i get this error

'usercp_nav_folderbit', 'awards_bit'


Unable to add cookies, header already sent.
File: /home/vrfihres/public_html/forum/memberlist.php
Line: 5

and if i disablemember list i get this error

'usercp_nav_folderbit', 'awards_bit'
Warning: Cannot modify header information - headers already sent by (output started at /home/vrfihres/public_html/forum/memberlist.php:5) in /includes/functions.php on line 2869


You must have done something wrong. Try to reverse the first edit on memberlist.php,
just use original

$globaltemplates = array(
);

Dont add the awardsbit template, and see how it work



I want also to disable request form completely


There's an option in setting to turn it off. you then can remove the request_award.php file too.


also is thereaway to display award image instead of icon in member profile

In member prodile, the award image is displayed at the bottom, together with award name and reason, isnt it?

[Mr.T]

Hello,

first thank you for this great hack. But I've one question.
The title of the automatic post shows the username of the person, who requests an award for another user. But I want that the title looks like:

XXX Award Request Form
_________________________________________

Award Request Form - XXX

------------------
Sender information

UserID: yyy
Username: zzz



I hope you understand, what I mean. I think, that the change must be in the awards_request_formanswers the first line
$formtitle - $bbuserinfo[username]

instead of $bbuserinfo[username] $answer2 but it doesn't work.

I hope you can help me and you understand my bad english.


T

[almqdad]

great hack installed on vb 3.08

[mtha]

Hello,

first thank you for this great hack. But I've one question.
The title of the automatic post shows the username of the person, who requests an award for another user. But I want that the title looks like:

XXX Award Request Form
_________________________________________

Award Request Form - XXX

------------------
Sender information

UserID: yyy
Username: zzz



I hope you understand, what I mean. I think, that the change must be in the awards_request_formanswers the first line
$formtitle - $bbuserinfo[username]

instead of $bbuserinfo[username] $answer2 but it doesn't work.

I hope you can help me and you understand my bad english.


T

you want to chaneg the post/thread title?

well, it's not that simple,

you need to look at request_award.php file, there's few places where

in the insert query, it insert this for title:

'".addslashes(htmlspecialchars($vbulletin->userinfo[username]))." $formtitle'

You need to change in there.

CAUTION: you need to know what you are doing, when you make the changes.

My time is limited now, so I cant do that coding for you. I dont use that form anyway.

[RetroDreams]

Hello,

first thank you for this great hack. But I've one question.
The title of the automatic post shows the username of the person, who requests an award for another user. But I want that the title looks like:

XXX Award Request Form
_________________________________________

Award Request Form - XXX

------------------
Sender information

UserID: yyy
Username: zzz



I hope you understand, what I mean. I think, that the change must be in the awards_request_formanswers the first line
$formtitle - $bbuserinfo[username]

instead of $bbuserinfo[username] $answer2 but it doesn't work.

I hope you can help me and you understand my bad english.


T

Did you ever get this functional?

If so, can you help me out... I think the author shouldn't have added this feature as it is unmanagable without how you request it.

[almqdad]

Great hack installed

[mtha]

Did you ever get this functional?

If so, can you help me out... I think the author shouldn't have added this feature as it is unmanagable without how you request it.

I didnt want to add it in either, just that some members want to have it, so I add Edwins' form hack there. if you want. Maybe you should just disable it, as I dont have time to give alot of support over that function.

(not right now)

maybe later on, I write a complete different one, for the purpose

[tekram]

I?ve installed in the Version 3.0.10 and when i get this error when i fille out the request award and clicking submit

Datenbankfehler in vBulletin 3.0.10:

Ungueltige SQL-Abfrage:
INSERT INTO post
threadid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, iconid, visible)
VALUES
(189, 'RJ_Tekram Award Request Form',
'RJ_Tekram', 1, 1136370355,
'Award Request Form - RJ_Tekram

------------------
Sender Information

UserID: 1 (http://vb-gamezone.de/member.php?u=1)
Username: RJ_Tekram
Fullname: RJ_Tekram

-----------------------------
Request Information:
Award ID: 2 (http://vb-gamezone.de/awards.php#award2)
Award Name : Test
Award Description : das ist ein test
/images/medals/medal-yellow.gif (http://vb-gamezone.de/awards.php#award2)

Recipient username : NOMOS (http://vb-gamezone.de/member.php?username=NOMOS)

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

right now
-----------------------------------------------------
', 1, 1,
0, 1)

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'threadid, title, username, userid, dateline, pagetext, allowsmi

mysql error number: 1064

Datum: 04.01.2006 11:25:55
Skript: http://www.vb-gamezone.de/request_award.php
Referer: http://www.vb-gamezone.de/request_award.php?award_id=2
Benutzername: RJ_Tekram
IP-Adresse: 87.122.84.131

Can someone help me please?

[cloyal]

I've installed this,just a small problem. There is nothing in the ACP that allows me to add change or do anything else with the catagories. Theres the award setting in the options but thats the only thing I've seen.

Any suggestions?

[mat.knott]

i get the same problem, am running 3.6.5 to try it out... maybe thats the problem?

[mat.knott]

dunno what i done but i have it now, its at the top not by advatars

[mtha]

i get the same problem, am running 3.6.5 to try it out... maybe thats the problem?


this version is for 3.0.x line,

For vBulletin 3.5.x or 3.6.x, please check the version here:
https://vborg.vbsupport.ru/showthread.php?t=94836