Yet Another Awards System 3.5 v2.1.2

[mtha]

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

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


Hack Version: 2.1.2.051128
Compatible vB version: 3.5.x
Support: https://vborg.vbsupport.ru/showthread.php?t=94836

For vBulletin 3.0.x, please check the other version:
https://vborg.vbsupport.ru/showthread.php?t=78934

DESCRIPTION:
This is a Medals/Awards system. Admin can give members awards, and award icons will be displayed in member's profile, posts, as well as in a award list.

FEATURES:
In ACP
- Can Create/Edit/Delete/Reorder categories/sub-categories in ACP (with category name and description)
- Can Create/Edit/Delete awards in ACP (with Award Name, Description, Icon URL, Image URL)
- Can Move one (or all) award(s) from one category to another
- Can set some awards un-classified (not displayed for public)
- Can re-order awards in awards showcase
+ Issue awards to members, based on username or userid, with Issue Reason
+ Remove awards from members
- [1.2] Options to set number of awards displayed in postbit
- [1.2] Options to turn on/off showing award icon, images, award requests in awards list, awards icons in memberlist
- [2.1.0] Options to re-order awards in postbit and member's profile
>Order by issued time (newest first)
>Order by issued time (oldest first)
>Order by Award Order (ASC)
>Order by Award Order (DESC)
- [2.1.0] Option to set award in-active. Inactive awards will not be listed in award list. However, it will still be displayed in user's profile, if member has the award.
- [2.1.0] Option to set "Request Award" option for each award. (Need "Show request award column" option ON to see the request link)
- [2.1.0] Set custom usergroup permission, to set which group can request award (access request award page)
- [2.1.0] Option to limit maximum number of users for each award displayed in awards list
- [2.1.0] Change award_request options, all options are set in AdminCP, template and phrase based. Totally cumsomizable
- [2.1.0] Option to send PM to use when he receives an award.

Front page
- Display awards list in with: Award Name, Description, Icon, Image, and Members who get each award.
- Display awards showcase in profile, with Award information, Issue time and reason
- Display award icons in postbit (showthread, showpost, announcement, private)
[1.2] Display limit awards in postbit, with total awards, and a link to awards showcase in member profiles.
[1.2] Award request, link to a form sending to email/PM/new thead or post (based on Dr Erwin Loh's Form hack)
[1.2] Display award on Memberlist page (by trulylowcarb)
[2.1.0] Display individual award with name of members who receive the award
[2.1.2] Collapse award categories and awards showcase

CHANGES/MODIFICATION:
(to do)
- Files to add: 6 (/awards.php, /award_request.php, /admincp/award.php, /admincp/award_cat.php, /includes/xml/postbbit_awards.xml, /includes/xml/cpnav_awards.xml)
- Templates to edit: 5 (MEMBERINFO, postbit, postbit_legacy, memberlist, memberlist_resultsbit)
(automatic)
- Tables to add: 3 (award, award_user, award_cat)
- Templates to add: 9 ('AWARDS', 'awards_awardbit','awards_awardusers_bit','awards_ bit','awards_userawards_bit','awards_category','aw ards_categorybit', 'awards_request_form', 'awards_request_formanswers')
- Phrases to add: xxx
DIFFICULTY:
Easy
Time: about 2 minutes
Installer is included (1 product XML)

HISTORY:
2005.11.28: 2.1.1 - Add check for errors before sending PMs
2005.11.27: 2.1.0 - Add functions, Change award request options
2005.11.12: 2.0.6 - remove $this->post['userid'] check in showthread
2005.11.02: 2.0.5 - fix error when display non-user's single post
2005.10.16: 2.0.4 - fix display award after quickreply
2005.10.11: 2.0.3 - fix Display award in PM and announcement, change award request template (thanks y2krazy) (https://vborg.vbsupport.ru/showpost.php?p=768359&postcount=69)
2005.10.07: Allow edit issued award
2005.09.05: Version 2.0.1 bug fix
2005.08.22: Version 2.0.0 for vBulletin 3.5.0
2005.08.18: Version 1.2.12005.04.14: Version 1.2.02005.04.03: Version 1.1
2005.03.29: Version 1.0.1b
2005.03.28: Version 1.0.1
2005.03.28: Initial release

FUTURE PLAN:
- Allow comments on user's award (by Arial)
- Allow voting on user's award (by Arial)
- Allow members to resort awards themselves <trackpad/TosaInu>

<done>
x. PM (/Email) user when he/she get an award. <2.1.0>
x. Allow awards to be resorted <trackpads> <2.1.0>
x. Allow admin to choose which awards have the 'request awards' link <trackpads> <2.1.0>
x. Allow/disallow certain awards for certain usergroups <trackpads> <2.1.0>


ADD ONs
How-to for importing from phpBB's Medal System Mod
https://vborg.vbsupport.ru/showpost.php?p=827421&postcount=171

CREDIT:
Idea has been carried on by many people, here are some:
- Lesane for original Award hack for vB2, eventhough I've never use his hack
- AnimeWebby for Awards/ Medals/ Cards Hack [vB3] (http://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 INSTALL.txt

UPGRADE:
Reimport XML product
Upload files if neccessary (keep the configuration)

upgrade 2.1.1: Reupload files + Reimport XML product
upgrade 2.1.2: Reupload files + Reimport XML product + reEdit templates (MEMBERINFO, postbit/postbit_legacy, memberlist_resultsbit)


UNINSTALL:
Click Uninstall in Product Manager, and undo the template changes

MANUAL:
Included in zip file

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

DEMO:
vB 3.5.x
<removed on owners request>

vB 3.0.x
http://www.global-army.com/forum/awards.php
http://www.global-army.com/forum/showthread.php?p=9253#post9253
http://www.global-army.com/forum/member.php?u=22#award

DONATIONS:
YAAS is free, but a donation of any amount is much appreciated.
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]

Hack Version: 2.0.0.050822
Compatible vB version: 3.5.0
Support: https://vborg.vbsupport.ru/showthread.php?t=94836


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}/award_request.php

{ROOT}/admincp/award.php
{ROOT}/admincp/award_cat.php

{ROOT}/includes/settings.request_award.php
{ROOT}/includes/xml/cpnav_awards.xml

{ROOT}/images/medals/*

Step 3: Import the YAAS Product into your plugin system
- Go to AdminCP/Plugin System/Manage Products/[Add/Import Product]
- Select the file: product-yet_another_award_system.xml
- Click Import

The installer will create new tables for awards, add new phrases, and templates to your database.


Step 4. Edit templates. Read instruction in /docs/awards_install_template.html

Step 5 (optional): If you use Award Request function, configure
{ROOT}/includes/settings.request_award.php and re-upload the file. Read the file for detail instruction.

Step 6: Enjoy your new hack, give me feedback, and click install.

[chikkoo]

eagerly awaiting for this..
love to know what is the difference.

[mtha]

Not anything different in functions, I just transport everything for the hack to work with vB 3.5.0.

[Biker_GA]

Question.... In your install.txt file you state:

Step 5: Configure {ROOT}/includes/settings.award.php and re-upload the file.

What needs to be configured?

[mtha]

If you use "Award Request" form, you can set configuration on how the form processed.

If you dont use the form, you dont need to worry about it :)

[wcbryant]

Will this extension recognize awards given from/through AnimeWebby's 3.0.x version of his hack? Meaning can I install yours when I move my site to 3.5.0, and have all the old awards still recognized by their database entries?

If not, is there a way to convert the old awards to your new system?

[Biker_GA]

Did all the file edits, installed the product and got this when clicking on a post:


Database error in vBulletin 3.5.0 Release Candidate 2:

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 post.postid IN (0,336683,336686,336689,336700)

GROUP BY au.issue_id;

MySQL Error : Unknown column 'a.award_id' in 'on clause'
Error Number : 1054
Date : Monday, August 22nd 2005 @ 12:10:33 PM
Script : http://www.*******.org/forum/showthread.php?p=336700
Referrer : http://www.*******.org/forum/search.php?searchid=338831
IP Address : **.**.**.**
Username : Biker
Classname : vb_database

[ForYou]

Hello ,

When I was Modify on the MEMBERINFO and need to Save , there is this Message

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

The following error occurred when attempting to evaluate this template:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/dardasha/public_html/montada/includes/adminfunctions_template.php(3510) : eval()'d code on line 349

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

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

Regards

[Biker_GA]

There are two /if statements at the end of that edit. Remove one of them.

[oman]

thanx dear mtha

for upgrade this hack

[Vizionz]

<!-- [START HACK='Yet Another Awards System hack' AUTHOR='HacNho'] -->
<if condition="$show['userawards']">
<fieldset class="fieldset">
<legend>$vbphrase[award_showcase]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td align="center">
$userawards
</td>
</tr>
</table>
</fieldset>
</if> * remove that --> </if>*
<!-- [END HACK='Yet Another Awards System hack' AUTHOR='HacNho'] -->

i get a parse error when i try adding that first template edit

note just read that post above


The admincp add award section and edit award section should have a drop down that reads from the medals directory and shows a preview of each medal

[ForYou]

Hello ,

When i need to request Award , there is error message

Warning: main(/home/SITENAME/public_html/montada./includes/settings.request_award.php): failed to open stream: No such file or directory in /request_award.php on line 23

Fatal error: main(): Failed opening required '/home/SITENAME/public_html/montada./includes/settings.request_award.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/SITENAME/public_html/montada/request_award.php on line 23

Regards

[ForYou]

Hello ,

I can't see the Issue time ,

How can i let Issue time appear ,

Regards

[ForYou]

Hello ,

When i put NO here ,

Display Icon in Awards List
Do you want to show award icon column in Awards list page

Look in the photo what happend ,

https://vborg.vbsupport.ru/ (http://www.dardasha.net/imagehost)

But the Correct in this photo ,

http://www.dardasha.net/imagehost/uploads/23398dc0bb.png (http://www.dardasha.net/imagehost)

Please Help

Regards

[mtha]

Will this extension recognize awards given from/through AnimeWebby's 3.0.x version of his hack? Meaning can I install yours when I move my site to 3.5.0, and have all the old awards still recognized by their database entries?

If not, is there a way to convert the old awards to your new system?


No, my database structure is different from his. There's no convertor yet available, but it can be done...

Did all the file edits, installed the product and got this when clicking on a post:

MySQL Error : Unknown column 'a.award_id' in 'on clause'
Error Number : 1054
Date : Monday, August 22nd 2005 @ 12:10:33 PM
Script : http://www.*******.org/forum/showthread.php?p=336700


Do you still get the error? check your database and see if you have the "award" table


There are two /if statements at the end of that edit. Remove one of them.

yeah, I was copying from vB compare, and it wasnt good. the new file was updated.

the first edit just had one </if> and the second one just has one </table> at the end.

Hello ,

When i need to request Award , there is error message

Warning: main(/home/SITENAME/public_html/montada./includes/settings.request_award.php): failed to open stream: No such file or directory in /request_award.php on line 23

Fatal error: main(): Failed opening required '/home/SITENAME/public_html/montada./includes/settings.request_award.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/SITENAME/public_html/montada/request_award.php on line 23

Regards
Did you have settings.request_award.php file uploaded to your includes folder? if not please do so. If you already have it up there, replace the request_award.php by the new one of the zip file

Hello ,

When i put NO here ,

Display Icon in Awards List
Do you want to show award icon column in Awards list page

Look in the photo what happend ,


Will look into that :) thanks

[ForYou]

Issue time

Hello ,

What about the Issue time , I can't see it

Regards

[mtha]

Hello ,

When i put NO here ,

Display Icon in Awards List
Do you want to show award icon column in Awards list page

Look in the photo what happend ,

http://www.dardasha.net/imagehost/uploads/486aeaffdb.png (http://www.dardasha.net/imagehost)



The bug is fixed and updated in the zip file

If you dont want to import the whole product again, you can import the attached plugin for TIME to show, and

replace the second part (above $footer) in MEMBERINFO template by


<!-- Award detail list -->
<if condition="$show['userawards']">
<a name="award">
<br>
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" colspan="3" align="center">$vbphrase[award_showcase]
</tr>
<tr>
<if condition="$vboptions[aw_showicon]">
<td class="thead" nowrap>$vbphrase[award_icon]
</if>
<if condition="$vboptions[aw_showimage]">
<td class="thead" nowrap>$vbphrase[award_image]
</if>
<td class="thead" width="100%">$vbphrase[award_description]
</tr>
$userawardslistbits
</table>
</if>
<!-- /Award detail list -->


Sorry for the errors, my first hack in 3.5.0 :)

[wcbryant]

No, my database structure is different from his. There's no convertor yet available, but it can be done...

I think that would be a huge bonus if it could be done. Several hundred different rewards have been given out on my site, so it wouldn't be practical to try and just rebuild everything manually, but I'd really like to use your hack once I move to 3.5.0.

I'll watch this thread closely, if anyone can put that together, I'll be first in line to put it to good use. :)

[mtha]

I think that would be a huge bonus if it could be done. Several hundred different rewards have been given out on my site, so it wouldn't be practical to try and just rebuild everything manually, but I'd really like to use your hack once I move to 3.5.0.

I'll watch this thread closely, if anyone can put that together, I'll be first in line to put it to good use. :)

I dont have his hack installed, so it'd be great if you can send me your tables that his hack created, i can look into it and write something for you, or I can work directly on your database.

[ForYou]

Hello Sir ,

I was Do what you say about the issue time , but there is problem now , whn i add the Award for any user it will be add 2 time , not for one Award it will be reapet to another one ,

I hope u understand me ,

and ther is another thing , I can see the issue time in user profile but i can't see it in AdminCp and the award mange ,

Regards

[ForYou]

Hello ,

Look at the duplicate Award down , but i was just add one Award ,

http://www.dardasha.net/imagehost/uploads/4c0702be2e.jpg

regards

[mtha]

Hello ,

Look at the duplicate Award down , but i was just add one Award ,

http://www.dardasha.net/imagehost/uploads/4c0702be2e.jpg

regards

Sorry, you need to delete the plugin called "YAAS - member_complete" before import.

The plugin system doesnt know if some plugin is duplicated :)

for the time in admincp, re-upload the award.php in adminCP folder.

[ForYou]

Hello Sir ,

You r Right :)

Evry thing is OK now ,

Regards

[Biker_GA]

**sigh** OK. No longer getting a DB error, however, there is nothing showing up in the postbit to add or remove an award. I did reapply all template changes.

[Biker_GA]

You also need to fix the description that appears in the Product page. It's nothing more than a URL back to this forum.

[Roxie]

I get the same error as Biker GA.

[mtha]

**sigh** OK. No longer getting a DB error, however, there is nothing showing up in the postbit to add or remove an award. I did reapply all template changes.

seems like it's working. i didnt see any problem yet.

... it looks like you didnt give any award to anyone, what should be displayed in postbit?

You need to assign awards to your members, in order to see them display in his postbit. it will only display awards on someone's postbit if and only if he/she has some.

How to add awards, please read over the manual, and add in your admincp.
/docs/YAAS_Manual.html#item4
IV. How to Use YAAS in Admin Control Panel

You also need to fix the description that appears in the Product page. It's nothing more than a URL back to this forum.

what should I fix in the description? I just put the URL, so anyone can come here and read for more information :)

[Roxie]

Biker GA ... what did you do to get rid of that database error?

[Biker_GA]

Roxie, I uninstalled, downloaded the new upgrade, and reloaded.

mtha - There is no way to assign an award. Nothing shows. Could there be a conflict with the "in reply to" plugin?

[mtha]

mtha - There is no way to assign an award. Nothing shows. Could there be a conflict with the "in reply to" plugin?

Are you sure you did the right thing?
Did you go to your forum AdminCP?
Did you get to Award System section in AdminCP? and then go to Award Manager
Did you get to [Manage] link in there, and to get to this:

https://vborg.vbsupport.ru/attachment.php?attachmentid=33725

If not so, try this link, on your domain

http://www.globalaffairs.org//forum/admincp/award.php?do=awardusers&award_id=1
and put your userid in there.


Tell me how far did you go, and what error did you get.

[Biker_GA]

:o Ahhhhhhhhhh. OK. I think I was confused about something else. The manager is there and works just fine.

[oman]

hi thanx again

[safiel]

I got SQL error as well

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

SELECT a.*, au.*
FROM award AS a
LEFT JOIN award_user AS au ON (a.award_id=au.award_id)
WHERE (au.userid = 192)
ORDER BY au.issue_time;

Most likely because you are using the same table name as AnimeWebby's hack for 3.0x. Might be good to rename your table or mention this might happen. :)

[mtha]

I got SQL error as well

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

SELECT a.*, au.*
FROM award AS a
LEFT JOIN award_user AS au ON (a.award_id=au.award_id)
WHERE (au.userid = 192)
ORDER BY au.issue_time;

Most likely because you are using the same table name as AnimeWebby's hack for 3.0x. Might be good to rename your table or mention this might happen. :)

I think I do mention that this hack does not compatible with Webby's award hack, and you cant use both at the same time.



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.

there's been a number of people using this hack already, and I wouldnt want to change and ask all of them to change, unless it's critical.

[Roxie]

AHA! That must be my issue. Now to figure out how to uninstall his. :D

[Roxie]

Got it working, however, I'm getting broken images in the postbit, profile and memberlist. The awards show fine on the award page and in the cp.

It would be great to be able to edit a users award! :D

[mtha]

Got it working, however, I'm getting broken images in the postbit, profile and memberlist. The awards show fine on the award page and in the cp.

It would be great to be able to edit a users award! :D

please use full image URL for award icon and image. if it doesnt work, please provide more information. I cannot give support with just knowind that it doesnt work, or it doesnt show something.

[Roxie]

I am using full image path. I don't know how to describe it better than "the image isn't showing." What information do you need? Everything else works just fine.

[Biker_GA]

Silly question of the day.. You did upload the images to the proper directory?

[Roxie]

Yes. The images show on the awards.php page, on part of the profile and in the control panel. Just now on memberslist and postbit. They are broken.

[Biker_GA]

Then I would suspect an error in your modifications to those templates.

[Biker_GA]

Getting the following when sending the request form (I have it set to be posted to the Admin forum).


Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

INSERT INTO thread(title, lastpost, forumid, open, replycount,
postusername, postuserid, lastposter, dateline, iconid, visible, attach)
VALUES
('Biker Award Request Form', 1125131466, 32,
1, 0, 'Biker', Array[userid],
'Biker', 1125131466, 0, 1,0);

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 '[userid],
'Biker', 1125131466, 0, 1,0)' at line 5
Error Number : 1064
Date : Saturday, August 27th 2005 @ 04:31:06 AM
Script : http://www.xxxxxxxx.org/forum/request_award.php
Referrer : http://www.xxxxxxxx.org/forum/request_award.php?award_id=1
IP Address : xx.xxx.xx.xxx
Username : Biker
Classname : vb_database

[mtha]

Getting the following when sending the request form (I have it set to be posted to the Admin forum).
I didnt get the error, but anyway,
replace this request_award.php file :) and see if its fixed

[mtha]

Yes. The images show on the awards.php page, on part of the profile and in the control panel. Just now on memberslist and postbit. They are broken.

give me access to those plase on your forum, i will take a look. username mtha

[Roxie]

give me access to those plase on your forum, i will take a look. username mtha

Done. Thanks.

[Biker_GA]

I didnt get the error, but anyway,
replace this request_award.php file :) and see if its fixed

Fixed the DB error. Thank you.

Having an issue in hand massaging the image link pointing back to the medal. Where is the URL called from?

Suggestion? Modify this so it goes into the postbit or postbit legacy so a user can go to the form directly from the post, with the URL of the post included.

[mtha]

Yes. The images show on the awards.php page, on part of the profile and in the control panel. Just now on memberslist and postbit. They are broken.

Since icons in postbit are "Award Icon", they are supposed to be small icons that fit to your postbit.

If you have Award Image also small, you can just add the url for award image to award icon field, then you are fine.


Fixed the DB error. Thank you.

Having an issue in hand massaging the image link pointing back to the medal. Where is the URL called from?

Suggestion? Modify this so it goes into the postbit or postbit legacy so a user can go to the form directly from the post, with the URL of the post included.

which hand massaging are you talking about? i dont get what you mean.

which form it should go to? and why?

the form to request for award is in award list

yourforumurl/awards.php

if you want, you can add this link to your menu

the link in postbit is linking to the userprofile, showing which awards someone's got.

[Biker_GA]

Here's what's showing. Instead of the actual image, it just shows part of the URL.

[mtha]

You just need to replace the relative path by full path to image URL in Award management, it will show.

[Biker_GA]

Thanks. I was tearing apart the templates looking for this. LOL

[Roxie]

Okay..I've noticed that all my awards show for "some" styles. There are 2 styles that they don't show in. I have reverted templates to match the default...and I still get broken images. Not sure why. I tried what you said above, with no luck.

[mtha]

Okay..I've noticed that all my awards show for "some" styles. There are 2 styles that they don't show in. I have reverted templates to match the default...and I still get broken images. Not sure why. I tried what you said above, with no luck.

since the picture is displayed on some styles, my best guess is you have some problem with some style.

I dont know how you setup your custom styles, so I cant tell you how to fix it.

if i have access to the templates, i might be able to see what happen,

you might want to check and see if all the additional templates for awards are displayed in the template that doesnt show.

[Roxie]

Finally figured it out! I had to revert the awards_bit template in a few of my styles. Don't know how that happened...but it worked. Thanks for your help!

[Roxie]

How hard would it be to add the ability to edit awards instead of having to delete them and start over? Thanks..

[mtha]

How hard would it be to add the ability to edit awards instead of having to delete them and start over? Thanks..

You ARE already able to edit awards, aint you? Read over the manual for how to edit awards.

If you meant "edit awards given to users", well I will think about that, for future dev. It wouldnt be too hard though, if you know what to do.

[wcbryant]

How possible would it be for other hacks (like the PayPal Donations system for 3.5 - https://vborg.vbsupport.ru/showthread.php?t=91567) to interact with this one?

Just imagining a scenario where users are awarded new medals, or upgraded in the event of an existing, immediately upon donating to the site in question. Or bloggers using an article system (like cinq's) automatically getting a contribution medal. vbQuiz leaders having something until someone else takes the high score. Season winners in my Pick'em extension getting something straight from the system, etc.

Don't know how realistic something like that is, though.

mtha, I was the one asking about a conversion tool to transfer data from AnimeWebby's 3.0.x version. I have my production site on 3.5.0rc2 now, so if you're still interested, willing and able to use me as a guinea pig to make that, I'm game.

[mtha]

It would be great to be able to edit a users award! :D

put the attached file in admincp, it should allow you to edit user's issued awards. some phrases might be missing, but it will be included in the next release. i will do some more checking on it before releasing :)


How possible would it be for other hacks (like the PayPal Donations system for 3.5 - https://vborg.vbsupport.ru/showthread.php?t=91567 (showthread.php?t=91567)) to interact with this one?

Just imagining a scenario where users are awarded new medals, or upgraded in the event of an existing, immediately upon donating to the site in question. Or bloggers using an article system (like cinq's) automatically getting a contribution medal. vbQuiz leaders having something until someone else takes the high score. Season winners in my Pick'em extension getting something straight from the system, etc.

Don't know how realistic something like that is, though.

I usually say, nothing is impossible. anything can be done, but it's just that I dont have interest on doing it/ I dont use any of those hacks, and it's more personal interest based than general bases.


mtha, I was the one asking about a conversion tool to transfer data from AnimeWebby's 3.0.x version. I have my production site on 3.5.0rc2 now, so if you're still interested, willing and able to use me as a guinea pig to make that, I'm game.
if you want, PM or email me your info, i may take a look

[y2krazy]

Any idea as to why the award is showing up twice in the MEMBERINFO template?

[mtha]

because you have duplicated YAAS plugin somehow. if you dont have anything yet, just uninstall, and install again. if you have many awards already, you need to look at the plugin list and find the duplicated one. look over the previous pages, there was someone getting the same error

[y2krazy]

Ok. That fixed that problem, now I'm getting this weird error(see attachment). I haven't modded any of the templates for the Awards yet, so I'm not sure as to why this is happening.

[Roxie]

Excellent! The editing works...Your work is really appreciated.

[Roxie]

I promise I'm not trying to be a pain ... lol..but I'm getting this error when submitting the Request Award form. I also tried using the new request_award.php that you posted later in the thread.

Database error in vBulletin 3.5.0 Release Candidate 2:

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

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

UserID: 1 (http://daboard.dizzam.com/member.php?u=1)
Username: Ro
Fullname: test

-----------------------------
Request Information:
Award ID: 29 (http://daboard.dizzam.com/awards.php#award29)
Award Name: Cancer Zodiac
Award Description:
https://vborg.vbsupport.ru/ (http://daboard.dizzam.com/awards.php#award29)

Recipient username : test (http://daboard.dizzam.com/member.php?username=test)

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

testing form
-----------------------------------------------------','1','1','0','0','1');

MySQL Error : Table 'dizzam_daboard.post' doesn't exist
Error Number : 1146
Date : Sunday, September 4th 2005 @ 05:40:38 PM
Script : http://daboard.dizzam.com/request_award.php
Referrer : http://daboard.dizzam.com/request_award.php?award_id=29
IP Address : xx.xx.xxx.xx
Username : Ro
Classname : vb_database

*EDIT* Seems the request still went through, but for some reason I get that database error...hmmm.

Also, sometimes the awards in the postbit don't show. We have to refresh the page. (that's not really a problem..just a lil annoying...lol)...Thanks! :)

[y2krazy]

Regarding this post:

https://vborg.vbsupport.ru/showpost.php?p=767567&postcount=61

I simply changed the following in the "awards_category" template:

<td class="tcat" colspan="$totalcols">

To this:

<td class="tcat" colspan="4">

Not sure what the previous code was used for, so this is just a temp-fix for the problem. Let me know when you get around to it... ;)

[DeMiNe0]

I promise I'm not trying to be a pain ... lol..but I'm getting this error when submitting the Request Award form. I also tried using the new request_award.php that you posted later in the thread.

Database error in vBulletin 3.5.0 Release Candidate 2:

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

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

UserID: 1 (http://daboard.dizzam.com/member.php?u=1)
Username: Ro
Fullname: test

-----------------------------
Request Information:
Award ID: 29 (http://daboard.dizzam.com/awards.php#award29)
Award Name: Cancer Zodiac
Award Description:
http://daboard.dizzam.com/awards/cancer.gif (http://daboard.dizzam.com/awards.php#award29)

Recipient username : test (http://daboard.dizzam.com/member.php?username=test)

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

testing form
-----------------------------------------------------','1','1','0','0','1');

MySQL Error : Table 'dizzam_daboard.post' doesn't exist
Error Number : 1146
Date : Sunday, September 4th 2005 @ 05:40:38 PM
Script : http://daboard.dizzam.com/request_award.php
Referrer : http://daboard.dizzam.com/request_award.php?award_id=29
IP Address : xx.xx.xxx.xx
Username : Ro
Classname : vb_database

*EDIT* Seems the request still went through, but for some reason I get that database error...hmmm.

Also, sometimes the awards in the postbit don't show. We have to refresh the page. (that's not really a problem..just a lil annoying...lol)...Thanks! :)

i'm getting this same error.

[mtha]

I promise I'm not trying to be a pain ... lol..but I'm getting this error when submitting the Request Award form. I also tried using the new request_award.php that you posted later in the thread.

Database error in vBulletin 3.5.0 Release Candidate 2:

MySQL Error : Table 'dizzam_daboard.post' doesn't exist
Error Number : 1146


*EDIT* Seems the request still went through, but for some reason I get that database error...hmmm.

Also, sometimes the awards in the postbit don't show. We have to refresh the page. (that's not really a problem..just a lil annoying...lol)...Thanks! :)

I could have uploaded the old file. replace request_award.php with the attached file

[mtha]

Regarding this post:

https://vborg.vbsupport.ru/showpost.php?p=767567&postcount=61

I simply changed the following in the "awards_category" template:

<td class="tcat" colspan="$totalcols">

To this:

<td class="tcat" colspan="4">

Not sure what the previous code was used for, so this is just a temp-fix for the problem. Let me know when you get around to it... ;)

try the attached file with the old template (using $totalcols) and see how it turn out.

the totalcols will calculate the number of columns you have, depends on the options you have for award settings.

[Biker_GA]

Something that would make this a top notch modification. I've added the link for the nomination form to postbit_legacy. What I currently have users do is copy the URL of the post they'd like to nominate. To make this even better, I'd like to see the URL automatically added to the reason section when a user clicks the link in the postbit. :)

[y2krazy]

The new files are working properly. Thanks, mtha! :)

Also, I have edited the Award Request template quite a bit and thought I'd share it with everyone who wants it:

$stylevar[htmldoctype]
<html id="form" dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - $formtitle</title>
$headinclude
</head>
<body>
$header
$navbar

<form enctype="multipart/form-data" method="post" action="$phpfilename">
<input type="hidden" value="$userid" name="userid">
<input type="hidden" value="submit" name="action">
<input type="hidden" value="$award[award_id]" name="award_id">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" colspan="3">
Request for $award[award_name] (id: $award[award_id])
</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div class="panel">
<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
<fieldset class="fieldset" style="margin:0px">
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td>$formpurpose</td>
</tr>
</table>
</fieldset>

<br><div align="center"><img src="$award[award_img_url]"></div><br>

<fieldset class="fieldset">
<legend>Description</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td>$award[award_desc]</td>
</tr>
</table>
</fieldset>

</div>
</div>
</td>
</tr>
</table>

<br>

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" colspan="3">
$formtitle
</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div class="panel">
<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">

<fieldset class="fieldset">
<legend>Username</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td><b>$bbuserinfo[username]</b></td>
</tr>
</table>
</fieldset>

<fieldset class="fieldset">
<legend>$question1</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td></td>
</tr>
<tr>
<td><input type="text" class="bginput" size="30" name="answer1"></td>
</tr>
</table>
</fieldset>

<fieldset class="fieldset">
<legend>$question2</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td><input type="text" class="bginput" size="30" name="answer2"></td>
</tr>
</table>
</fieldset>

<fieldset class="fieldset">
<legend>$longquestion1</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td>$longexplain1</td>
</tr>
<tr>
<td><textarea rows="5" cols="50" name="longanswer1"></textarea></td>
</tr>
</table>
</fieldset>

</div>
</div>
</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div style="margin-top:$stylevar[cellpadding]px">
<input type="submit" name="submit" class="button" value="Submit Request" accesskey="s" />
<input type="reset" name="reset" class="button" value="$vbphrase[reset_fields]" accesskey="r" />
</div>
</td>
</tr>

</table>
</td>
</tr>
</table>

</form>

$footer
</body>
</html>

NOTE: The attachment is in my unique style, but it was edited based on the UserCP templates, so it should look like that in any template. Let me know if this is any use to anyone. :)

EDIT: Where would I go to change the title of the thread, e-mail or PM that is created when a request is submitted?

EDIT 2: Nevemind the first EDIT as I figured out where in the file to change some things to make the title of the thread different.

[Roxie]

I could have uploaded the old file. replace request_award.php with the attached file

Great! Database error is gone, but now it submits the form and refreshes to the form again. No thank you page. hmmm

[y2krazy]

Great! Database error is gone, but now it submits the form and refreshes to the form again. No thank you page. hmmm
I tested mine and it works smoothly with the new files. Not quite sure what's going wrong over there... :(

[Roxie]

hmmm...let me check my settings...

[peterska2]

* peterska2 clicks install.

I had to delete a duplicate plugin though "YAAS Memberlist_Complete" coz it was putting the awards twice in the profile. Clean fresh install too so it's something in your XML there.

Looks good though. Now I just have to come up with some things to give awards for :D

[y2krazy]

The only change is that I edited the request form to make it look more streamlined with the forums. Screenshot is included.

Style Manager -> Choose the Style to Edit -> "awards_request_form"
Replace entire template with:

$stylevar[htmldoctype]
<html id="form" dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - $formtitle</title>
$headinclude
</head>
<body>
$header
$navbar

<form enctype="multipart/form-data" method="post" action="$phpfilename">
<input type="hidden" value="$userid" name="userid">
<input type="hidden" value="submit" name="action">
<input type="hidden" value="$award[award_id]" name="award_id">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" colspan="3">
Request for $award[award_name] (id: $award[award_id])
</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div class="panel">
<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
<fieldset class="fieldset" style="margin:0px">
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td>$formpurpose</td>
</tr>
</table>
</fieldset>

<br><div align="center"><img src="$award[award_img_url]"></div><br>

<fieldset class="fieldset">
<legend>Description</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td>$award[award_desc]</td>
</tr>
</table>
</fieldset>

</div>
</div>
</td>
</tr>
</table>

<br>

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" colspan="3">
$formtitle
</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div class="panel">
<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">

<fieldset class="fieldset">
<legend>Username</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td><b>$bbuserinfo[username]</b></td>
</tr>
</table>
</fieldset>

<fieldset class="fieldset">
<legend>$question1</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td></td>
</tr>
<tr>
<td><input type="text" class="bginput" size="30" name="answer1"></td>
</tr>
</table>
</fieldset>

<fieldset class="fieldset">
<legend>$question2</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td><input type="text" class="bginput" size="30" name="answer2"></td>
</tr>
</table>
</fieldset>

<fieldset class="fieldset">
<legend>$longquestion1</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td>$longexplain1</td>
</tr>
<tr>
<td><textarea rows="5" cols="50" name="longanswer1"></textarea></td>
</tr>
</table>
</fieldset>

</div>
</div>
</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div style="margin-top:$stylevar[cellpadding]px">
<input type="submit" name="submit" class="button" value="Submit Request" accesskey="s" />
<input type="reset" name="reset" class="button" value="$vbphrase[reset_fields]" accesskey="r" />
</div>
</td>
</tr>

</table>
</td>
</tr>
</table>

</form>

$footer
</body>
</html>

You can test the Awards out yourself at my site if you wish, too(see my sig for a link).

[Blaine0002]

OK, Great hack. BUT! When a user submits a request it automaticly goes to threadid 1. How do i change this?

[Roxie]

Blah..I'm still having the same issue. I have no clue. I tried having it redirect to the thread, the forum, the thank you page. Other than that, everything works good! :D

[Metropolitan]

Can somebody plz explain me how to add the awards-request function? I want the request function in my navbar, but i have no idea how to configure this.

I hope somebody can help me ;)

Thanks in advance

Metro

[Biker_GA]

Just create a link in your navbar.. And you have to link to awards.php, not awards-request.php. I added the link to the drop down menu in the postbit. :)


mtha -- Something to consider for a future version? The ability to restrict the use of the request function based on number of posts and length of membership. In other words, unless the individual requesting the award (either for themself or another person) has been a member for at least "x" days and has at least "x" posts, they can not use the form.

[blackpheonix]

i get a broken zip :(

[mtha]

I get no problem downloading and reading content of the zip file at all. try to download again.

[cclaerhout]

Here's the French translation for Yet Another Awards System 3.5 v2.0.0.
Just import the xml file as a product, and it will replace english phrases by french ones.

Edit : FR01 translation deleted.

[cclaerhout]

Here's the French FR02 translation for Yet Another Awards System 3.5 v2.0.0.

Just import the xml file as a product, and it will replace english phrases by french ones.

P.S : FR02 means second version

[cclaerhout]

Here's the French FR02 translation for Yet Another Awards System 3.5 v2.0.0.

Just import the xml file as a product, and it will replace english phrases by french ones.


P.S : FR02 means second version

Just to say that just one phrase remains hardcoded in the award.php line 453 :
print_table_header("Give award to user", 2, 0);

[cclaerhout]

Is there a way (ie : in postbit) to align awards from a same category in a line, then with a <br /> to align icons from another category in another line ?

Exemple sheme of the postbit :

Username (line 1)
Avatar ("line" 2)
awards from cat.1 (line 3)
awards from cat.2 (line 4 )

[Stunner Inc.]

Ok I'm either dumb or can't read....I put the medals where the instructions said ({ROOT}/images/medals/*)I get red X's on my site....I try putting them elsewhere and still get X's....HELP would be appreciated....

Do I have to move the Folder in the zip called Medals to the images folder or not?

[cclaerhout]

Ok I'm either dumb or can't read....I put the medals where the instructions said ({ROOT}/images/medals/*)I get red X's on my site....I try putting them elsewhere and still get X's....HELP would be appreciated....

Do I have to move the Folder in the zip called Medals to the images folder or not?

Are you sure about the path you have precised for each picture in admincp ?

[Cyricx]

Bug with table prefixes when viewing "awards.php?award_cat_id=x"

Got an sql error.

Fixed it by changing this


// check to see if we have already got the results from the database
$fcache = array();
$award_cats = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "award_cat
" . iif($display_award_cat_id, "WHERE award_cat.award_cat_id = $display_award_cat_id", '') . "
ORDER BY award_cat_displayorder
");



To this

// check to see if we have already got the results from the database
$fcache = array();
$award_cats = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "award_cat
" . iif($display_award_cat_id, "WHERE " . TABLE_PREFIX ."award_cat.award_cat_id = $display_award_cat_id", '') . "
ORDER BY award_cat_displayorder
");


You were missing a table_prefix after the where statement :)

Also, noticed that the "awards_bit" template isn't getting cached when viewing threads?

Causing alot of extra queries.

[Mastermaik]

Hi there,
is there any translation of this hack into german !?
would be very great !

[mtha]

Hi there,
is there any translation of this hack into german !?
would be very great !

There's one for vB 3.0.x

http://www.vbhacks-germany.com/forum/showthread.php?t=1285

[Mastermaik]

There's one for vB 3.0.x

http://www.vbhacks-germany.com/forum/showthread.php?t=1285

But thats not working in 3.5 i guess, or ?
A original version for 3.5. isn?t available !?
thx

[MarsNIIT]

please help me, error: http://forums.niitvn.info/awards.php?award_cat_id=1

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM abc_award_cat
WHERE award_cat.award_cat_id = 1
ORDER BY award_cat_displayorder;

MySQL Error : Unknown table 'award_cat' in where clause
Error Number : 1109
Date : Sunday, October 2nd 2005 @ 04:46:19 AM
Script : http://forums.niitvn.info/awards.php?award_cat_id=1
Referrer :
IP Address : 210.245.31.17
Username : MarsNIIT
Classname : vb_database

[TosaInu]

Hello,

Does it still work with 3.5.0 gold?

[WNxWakko]

When a medal is given out, on the users profile it shows it twice. Seems like its two different places because the first one is alt1 colors, then second row repeat with alt2 colors. How do I get rid of the dupe?

[mtha]

please help me, error: http://forums.niitvn.info/awards.php?award_cat_id=1

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM abc_award_cat
WHERE award_cat.award_cat_id = 1
ORDER BY award_cat_displayorder;

MySQL Error : Unknown table 'award_cat' in where clause
Error Number : 1109
Date : Sunday, October 2nd 2005 @ 04:46:19 AM
Script : http://forums.niitvn.info/awards.php?award_cat_id=1
Referrer :
IP Address : 210.245.31.17
Username : MarsNIIT
Classname : vb_database

you did not use the latest version of YAAS. Please download the newest version and upload the awards.php to your server



Does it still work with 3.5.0 gold?
yes.

When a medal is given out, on the users profile it shows it twice. Seems like its two different places because the first one is alt1 colors, then second row repeat with alt2 colors. How do I get rid of the dupe?

You got the old file too. check your plugin list, and find a duplicated plugin in there.

[gator777]

It installed like a charm, and works great. I really want to thank you for all your hard work by making such a great addon for VB. :up:

I have a couple of questions/requests.

Once a user is given a medal, for example, how do you go back at a later date and edit the "Issue Reason" for a user after that already been added?

Also, I'm confused about the permissions when using the Request for Award page. It says I am not authoized, so how does a user access this page, or where is the user permisison located?

Although still under construction, you can view my Awards page Here (http://www.the-armory.net/vb3/awards.php)

And here is a post with some of the awards in action Here (http://www.the-armory.net/vb3/showthread.php?t=9221)

Thanks again :)

[WNxWakko]

Is there a way you can make it so I can edit the reason without deleting and recreating the award?

[mtha]

I think I did add the function to edit it.

when you go to award manager/manage award, you will be able to edit/delete any given award.

let me check on the online version.

:) forgot to update the online version

replace this file in admincp

[WNxWakko]

oh thank you thank you! :) me is happy completly with this mod, it rocks.

[WNxWakko]

Um, me again :) Is there a way to maybe add a toggle switch in options so noone can be added for a medal more than once? I have a ton of members and it can be hard to organize sometimes.

[jluerken]

Hi mtha,

could you bring things like this
$formtitle = "Award Request Form";
in the phrase system?

Currently you can only use this hack on single language boards and I really want to use it :D

[WNxWakko]

Also I found a problem. For some reason the medals showing in postbit do not show up viewing PM's or when you use quick reply the medals dont show up until you refresh the page. Keep in mind the quick reply is using the ajax so the page doesnt reload from your reply.

[rb290]

ok I installed it and seems to be going good
thank you

[rb290]

if someone request an award where do I see the request ?

[rb290]

hmm, i just noticed that someone who requested an award it ended up in the intro forum where people introduce themselves, any idea on how to fix this and where its supposed to go ?

[mtha]

hmm, i just noticed that someone who requested an award it ended up in the intro forum where people introduce themselves, any idea on how to fix this and where its supposed to go ?

read the instruction on how to setup award request. it's in settings.request_award.php

[WhiteWolf]

Also I found a problem. For some reason the medals showing in postbit do not show up viewing PM's or when you use quick reply the medals dont show up until you refresh the page. Keep in mind the quick reply is using the ajax so the page doesnt reload from your reply.

Yeah, same here. We have noticed the same two things with our Forum, Awards not showing in PM's and just after quick reply (dealing with the AJAX update I'm sure... it's not pulling the awards when it refreshes to see the post)

[evenmonkeys]

Fixed it myself.

[WNxWakko]

Fixed it myself.


Fixed what exactly? and how did you fix what you fixed :)

[pfvc]

I had setup my own code where I had the awards I wanted to display side by side 5 across, then move to the next line and add another 5, etc, etc. using ghe custom fields and adding some code in the appropriate spots. However the YAAS system would be much better for my use.

Is there anyway of displaying awards side by side 5 across, then move to the next line and add another 5, etc, etc. or wrapping to the next line with the YAAS system and if so how?

Is there a way (ie : in postbit) to align awards from a same category in a line, then with a <br /> to align icons from another category in another line ?

Exemple sheme of the postbit :

Username (line 1)
Avatar ("line" 2)
awards from cat.1 (line 3)
awards from cat.2 (line 4 )

[rb290]

I wanna know how you put this awards system in the navbar so people will notice it and see what it is cause not many people know

[Flow Fusion]

How can I get the award to show in the postbit? Right now all I get is the links?

[mtha]

Um, me again https://vborg.vbsupport.ru/ Is there a way to maybe add a toggle switch in options so noone can be added for a medal more than once? I have a ton of members and it can be hard to organize sometimes.

you have ton of members to give awards? wow ...
i'd give a member the same awards as many time as it needs. if you dont want to give member award many time, just dont give him again.
it's posible to check award+userid when adding one, but I cant do it now.


For some reason the medals showing in postbit do not show up viewing PM's or when you use quick reply the medals dont show up until you refresh the page. Keep in mind the quick reply is using the ajax so the page doesnt reload from your reply.

well, there's some problem in private and announcement, will look into it.


Is there anyway of displaying awards side by side 5 across, then move to the next line and add another 5, etc, etc. or wrapping to the next line with the YAAS system and if so how?

I didnt test, but you can try. edit YAAS - Showthread_postbit_create plugin

replace


foreach($userawardscache[$post['userid']] AS $award_id => $award)
{
$aw_i++;
if ($aw_i <= $vbulletin->options['aw_display_limit'])
{
eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
}
}

with

foreach($userawardscache[$post['userid']] AS $award_id => $award)
{
$aw_i++;
if ($aw_i <= $vbulletin->options['aw_display_limit'])
{
eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
if (($aw_i%5) == '0') eval('$post[userawards] .= "<br>";');
}
}


</font></font>
How can I get the award to show in the postbit? Right now all I get is the links?

How can I understand what your error is? if you dont have award, no link is available at all.
read the manual on how to add/give award.

[rb290]

I wanna know how you put this awards in the navbar thatll link it to www.mysite.com/awards.php so people will notice it and see what it is cause not many people know without being informed

[mtha]

I wanna know how you put this awards in the navbar thatll link it to www.mysite.com/awards.php (http://www.mysite.com/awards.php) so people will notice it and see what it is cause not many people know without being informed

edit navbar,

add <a href="awards.php">Awards</a> to the place that you want people to see it.


you can customize the template to look the same with other links that you have in there

[mtha]

Version 2.0.3 is released with the fix to display awards in PM and announcement.

please reimport the XML product!

[StarGame]

Hi, i do not know if this has already been ask but when i installed your script on my forums I could not see or access the awards in my admin area, it did not appear under 'Users'
Can anyone help me?
Cheers

[mtha]

Hi, i do not know if this has already been ask but when i installed your script on my forums I could not see or access the awards in my admin area, it did not appear under 'Users'
Can anyone help me?
Cheers

did you upload the files, especially the /includes/xml/cpnav_awards.xml ?

did you refresh the admincp browsers?

if you have dual_admin nav. installed, it will be on the second panel.

[Flow Fusion]

OK I'm sorry but I don't see any way to request an award? Please explain....

[WNxWakko]

Installed 2.03. I still see the problem when a user uses quickreply their medal does not showup until they refresh the page.

[mtha]

OK I'm sorry but I don't see any way to request an award? Please explain....

- Read the manual
- Check the Award settings. Request is Off by default, you need to turn is ON and configure "award_request_settings" if you want to use.



Installed 2.03. I still see the problem when a user uses quickreply their medal does not showup until they refresh the page.

Didnt think of this ajax before. anyway, it's just you who dont see your medal, after you do quickreply, right? others still can see it fine, so it shouldnt be a big deal.

[Flow Fusion]

- Read the manual
- Check the Award settings. Request is Off by default, you need to turn is ON and configure "award_request_settings" if you want to use.


Help. I turned it on but I still don't see a link to request an award?

[pfvc]

I didn't have too much luck with your alterative code to display 5 awards, then if there is more, drop to the next line to display next 5 etc, etc... any suggestions or other alternatives?

The other thing that also came to mind was, my awards in the posts etc aren't tiny like the example you included, I can probably make them slightly smaller but any smaller would defeat the purpose of the size they display at. Because of this if like in my case I want to display 5 awards across etc, the above stuff i.e. Last Online, Join Date, Posts, and IM icons etc, all still sit above the awards but sit with the left most awards. Is it possible to keep that data where it belongs at the far right so they don't move with the awards... oh I probably have said my user stat bar that most people have on the left of each post is at the top of user posts on my forum.

Would be greatful for any assistance you can assist me with to get this working the way I'd like it to.



I didnt test, but you can try. edit YAAS - Showthread_postbit_create plugin...

[WhiteWolf]

Fixed it not showing after quick reply.
It appears that in newreply.php we find that the QuickReply is calling the same method as the post, except that the script name changes to the if check in the postbit_display_start fails and the code is not included.

To fix:
Replace in postbit_display_start:

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement'))


With:

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement') OR (THIS_SCRIPT == 'newreply'))

[secret1980]

clicked install :D thanks for the good mod :D

[Flow Fusion]

To fix:
Replace in postbit_display_start:

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement'))


With:

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement') OR (THIS_SCRIPT == 'newreply'))



Where is postbit_display_start?

[mtha]

You can either re-import the product xml (2.0.4) or edit the plugin YAAS - Showthread_postbit_create as mention above.

Thank WhiteWolf for the fix.

[klinsek]

This is a great mod. Nice job Mtha!

Trying it out on our test server and happy with its core functionality. No issues as of yet.

We use a "badge" system on our current site (vb 3) which is made up of hacks here and there. Basically a badge is shown in the users postbit if they belong to a certain group.

Id love to see a usergroup functionality added to this however. We have about 30k members and to add accolade badges manually is pretty much out of the question. Hehe. I want to just do "usergroup ID = this badge".

I like the ability to add to a single user though, as it may serve useful for more "special" awards. The awards page showing a nice legend of all the awards is great as well. Nice touch.

Anyways, is anyone else interested in a "issue award to usergroup" functionality within this mod? Not sure how hard or simple it will be, but I am going to ask my partner (the code guru) to give it a go.

Thanks
*install*

[Flow Fusion]

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement')


With:

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement') OR (THIS_SCRIPT == 'newreply')


This is the other script and it is edited cause it had an extra ) after announcement but...it still doesn't work.
From YAAS - postbit_display_start
// [START HACK='Yet Another Award System' AUTHOR='HacNho']

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement') OR (THIS_SCRIPT == 'newreply') OR (THIS_SCRIPT == 'newreply'))
{
global $db, $vbulletin;
{
if ($vbulletin->options['aw_postbit'])
{
if (THIS_SCRIPT == 'private') $this->post['userid'] =& $post['fromuserid'];
$post['userawards'] = '';
// Obtain list of awards for current user
$alluserawards = $db->query_read("
SELECT a.*, au.*
FROM " . TABLE_PREFIX . "award a, " . TABLE_PREFIX . "award_user au
WHERE (au.userid = ".$this->post['userid'].") AND (a.award_id=au.award_id)
ORDER BY au.issue_time
");

$post['showuserawards'] = false;
if ($post['num_awards'] = $db->num_rows($alluserawards))
{
$aw_i = 0;

while ($award = $db->fetch_array($alluserawards))
{
$aw_i++;
if ($aw_i <= $vbulletin->options['aw_display_limit'])
{
eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
}
}
$post['showuserawards'] = true;
$db->free_result($alluserawards);
}
}
}
}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']

[Kaelon]

Great hack - but found a bug on one of my threads (and not sure how to even debug or fix it):

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT a.*, au.*
FROM award a, award_user au
WHERE (au.userid = ) AND (a.award_id=au.award_id)
ORDER BY au.issue_time;

MySQL Error : You have an error in your SQL syntax near ') AND (a.award_id=au.award_id)
ORDER BY au.issue_time
' at line 4
Error Number : 1064
Date : Sunday, October 16th 2005 @ 11:25:07 AM
Script : http://www.xxxxxx.com/forums/showpost.php?p=6344
Referrer :
IP Address : xxx.x.xx.xxxx
Username : Kaelon
Classname : vb_database

Edit: I've debugged the problem. Apparently, the poster had his account deleted and the post is showing up as coming from an Unregistered user. Thoughts on how we can fix this?

[Kaelon]

Fixed it! Apparently, an error over in the postbit_display_start plugin.

CHANGE THIS:

if ($vbulletin->options['aw_postbit'])

TO THIS:

if (($vbulletin->options['aw_postbit']) AND ($this->post['userid']))

[WhiteWolf]

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement')

...
This is the other script and it is edited cause it had an extra ) after announcement but...it still doesn't work.
From YAAS - postbit_display_start
...

Didn't notice, typed it as I remembered it before I edited it (my mistake!)

Fixed it! Apparently, an error over in the postbit_display_start plugin.

CHANGE THIS:

if ($vbulletin->options['aw_postbit'])

TO THIS:

if (($vbulletin->options['aw_postbit']) AND ($this->post['userid']))

Instead of
if (($vbulletin->options['aw_postbit']) AND ($this->post['userid']))

To avoid a typecast from int to bool, it should be this (assuming you want it non-zero):


if (($vbulletin->options['aw_postbit']) AND ($this->post['userid'] !== 0))


Assuming data is bad.

[Flow Fusion]

But it still will remove the award if you hit the edit button and edit the thread. And can I get some help on the request award?

[WhiteWolf]

In order to display after edit, open the postbit_display_start "YAAS - postbit_display_start" plugin hook and change:

(Current file should say this... if it doesn't then you don't have the latest product file or have not been following the topic:)

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement') OR (THIS_SCRIPT == 'newreply'))


To contain OR (THIS_SCRIPT == 'editpost'), as such:

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement') OR (THIS_SCRIPT == 'newreply') OR (THIS_SCRIPT == 'editpost'))

[mtha]

In order to display after edit, open the postbit_display_start "YAAS - postbit_display_start" plugin hook
To contain OR (THIS_SCRIPT == 'editpost'), as such:

if ((THIS_SCRIPT == 'showpost') OR (THIS_SCRIPT == 'private') OR (THIS_SCRIPT == 'announcement') OR (THIS_SCRIPT == 'newreply') OR (THIS_SCRIPT == 'editpost'))


Thanks WhiteWolf :)

Using this would work too:


if (in_array(THIS_SCRIPT, array('showpost', 'private', 'announcement', 'newreply','editpost')))

[Flow Fusion]

Yup that fixed it. Thanks guys. Now about that request award thing?

[o0Hubba0o]

Yup that fixed it. Thanks guys. Now about that request award thing?
Edited, nvm me I was being silly heh, forgot to upload the files. :nervous:

[WhiteWolf]

Thanks WhiteWolf :)

Using this would work too:


if (in_array(THIS_SCRIPT, array('showpost', 'private', 'announcement', 'newreply','editpost')))

I'd be cautious about using in_array, it may be more (detrimental) than it's worth in terms of processing time on the template. (Roughly 50% over a chained OR statement)

[Flow Fusion]

OK I don't even see where to click to request an award from? Any help?

[mtha]

OK I don't even see where to click to request an award from? Any help?


All I can say is turn on the Show Request Award in AdminCP/ award options, and go to this page. there will be a column on the far right, to request award.

/forum/awards.php

[Flow Fusion]

Does anyone have it active?

[mtha]

Does anyone have it active?

1. Did you turn the option to request award ON? (see attachment)
http://giftedsouls.com/gs/admincp/options.php?do=options&dogroup=awards

2. Did you look at the right place for the request award link? (see attachment)
http://giftedsouls.com/gs/awards.php


remember, when you turn it on and use it, you HAVE to configure the request-award properties in order to use it properly.

[Flow Fusion]

I'm afraid my confusion is in this part.

//USERGROUPS ALLOWED
//You can add or remove usegroups that are ALLOWED to use this form by changing the numbers below in the array
////////////////////////////////////////////////////////////////////////////////////////////////////

if (!in_array($vbulletin->userinfo['usergroupid'], array(2,5,6,7,8.9.10.11.12,27,))) print_no_permission();

////////////////////////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////////////////////////
//NAME OF THIS PHP FILE AND TEMPLATES - DO THIS BIT IF YOU ARE MAKING MORE FORMS!
//You can easily make more forms by just copying this file, renaming it, and modifying the variable in
//this file. You can keep the same templates for different forms. For more customization, you can
//use different templates, by renaming and modifying the templates.
////////////////////////////////////////////////////////////////////////////////////////////////////

// Name of this file
$phpfilename = "request_award.php";

////////////////////////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////////////////////////
//CHOOSE WHETHER YOU WANT FORM TO BE POSTED IN A NEW THREAD, NEW POLL, REPLY TO EXISITING THREAD, PMed OR EMAILED
///////////////////////////////////////////////////////////////////////////////////////////////////

//ENABLE FORM TO BE POSTED - 1 = yes, 0 = no
$formforum = "1";

//FORUM TO POST NEW THREAD IN
$formforumid = "131";<---------------------------------------I added the arror

//ENABLE POLL TO BE CREATED - 1 = yes, 0 = no
$formpoll = "1";
$formoption1 = "Yes";
$formoption2 = "No";

////////////////////////////////////////////////////////////////////////////////////////////////////

//ENABLE FORM TO REPLY TO EXISTING THREAD
$formreply = "1";

//EXISTING THREAD ID FOR FORM TO REPLY IN
$formreplythreadid = "1";<---------------------------------------I added the arror


//FORUM ID WHERE THE EXISTING THREAD IS IN
$formreplyforumid = "2";

////////////////////////////////////////////////////////////////////////////////////////////////////

//ENABLE FORM TO BE PMED - 1 = yes, 0 = no
$formpm = "1";

[Flow Fusion]

I have it working I just don't see the link..

http://www.giftedsouls.com/gs/request_award.php?award_id=1

Name: test
PW: 999999

[Flow Fusion]

I got it now. Great hack. Thanks.

[Flow Fusion]

Any way to make it so more than one person can get a PM on the request?

[MissKalunji]

i get this error when i try to go here : http://www.dancehallareaz.com/forum/showpost.php?p=458&postcount=15



SELECT a.*, au.*
FROM award a, award_user au
WHERE (au.userid = ) AND (a.award_id=au.award_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 ') AND (a.award_id=au.award_id)
ORDER BY au.issue_time' at
Error Number : 1064
Date : Tuesday, October 25th 2005 @ 09:05:56 AM
Script : http://www.dancehallareaz.com/forum/showpost.php?p=458
Referrer :
IP Address : 24.37.191.104
Username : MissKalunji
Classname : vb_database

[mtha]

i get this error when i try to go here : http://www.dancehallareaz.com/forum/showpost.php?p=458&postcount=15

it's because you are looking at a guest's post.

I dont have access to my code now, but you can try this:

Go to your AdminCP, edit the plugin YAAS - postbit_display_start

LOOK FOR

if ($vbulletin->options['aw_postbit'])
{
if (THIS_SCRIPT == 'private') $this->post['userid'] =& $post['fromuserid'];

REPLACE BY


if (THIS_SCRIPT == 'private') $this->post['userid'] =& $post['fromuserid'];
if (($vbulletin->options['aw_postbit']) AND ($this->post['userid']))
{



ps. i didnt test it, let me know if it works :)

[MissKalunji]

it's because you are looking at a guest's post.

I dont have access to my code now, but you can try this:

Go to your AdminCP, edit the plugin YAAS - postbit_display_start

LOOK FOR

if ($vbulletin->options['aw_postbit'])
{
if (THIS_SCRIPT == 'private') $this->post['userid'] =& $post['fromuserid'];

REPLACE BY


if (THIS_SCRIPT == 'private') $this->post['userid'] =& $post['fromuserid'];
if (($vbulletin->options['aw_postbit']) AND ($this->post['userid']))
{



ps. i didnt test it, let me know if it works :)

worked i didnt know it was a guest post

thanks!!

[The Chief]

looks like a great extension I'll try it out on my vb 3.5, lets see if it works!

[RetroDreams]

If I'm posting a thread to the forum, what do I edit to change the title of that? It currently just throws a generic title in there and I'd like it to basically say "User Nomination for $nominatedusername"??

Also, same goes for the poll? How do I edit what the question of the poll should be?

[The Chief]

looking good, I have installed, hope it all works out :D

*clicks install*

[mtha]

it's because you are looking at a guest's post.

Go to your AdminCP, edit the plugin YAAS - postbit_display_start

LOOK FOR

if ($vbulletin->options['aw_postbit'])
{
if (THIS_SCRIPT == 'private') $this->post['userid'] =& $post['fromuserid'];

REPLACE BY


if (THIS_SCRIPT == 'private') $this->post['userid'] =& $post['fromuserid'];
if (($vbulletin->options['aw_postbit']) AND ($this->post['userid']))
{



ps. i didnt test it, let me know if it works :)

Version 2.0.5 has include this fix! please implement the change if you havent done so!

[jluerken]

How to update from 2.0.3 to 2.0.5 ?

[mtha]

Just re-import the product over the old one

[Omranic]

<a href="https://vborg.vbsupport.ru/showthread.php?t=100064" target="_blank">[plugin] Yet Another Awards System Template Grouping</a>

[RetroDreams]

If I'm posting a thread to the forum, what do I edit to change the title of that? It currently just throws a generic title in there and I'd like it to basically say "User Nomination for $nominatedusername"??

Also, same goes for the poll? How do I edit what the question of the poll should be?

Bump?

[mtha]

If I'm posting a thread to the forum, what do I edit to change the title of that? It currently just throws a generic title in there and I'd like it to basically say "User Nomination for $nominatedusername"??

Also, same goes for the poll? How do I edit what the question of the poll should be?

you can look over this one:
https://vborg.vbsupport.ru/showthread.php?p=813300#post813300

In the request award configuration, you can set

$formtitle = "User Nomination".

further customize, you can look over Dr Erwin Loh for FORM TO THREAD/ FORUM/ PM/ EMAIL hack, since I dont use the request form myself, and I cant customize further that way now.


there's also a new form hack for vb3.5.0, you can install that form hack, customize it, and chaneg the request form to link to the new form.

[AshokForums.com]

Tried installing this hack.. Everything worked perfectly.. Added few awards.. I awarded a award to a user.. And while viewing the thread i get this error..

If i disable the plugin.. There is no error.. Whats the problem any idea?

Please note that for testing purpose i have installed this hack on my local host.. :)

Fatal error: Using $this when not in object context in H:\localhost\xampp\xampp\htdocs\Vbulletin\showthre ad.php(923) : eval()'d code on line 2

[AshokForums.com]

Display in postbit
Do you want to show awards in member\'s postbit
Yes No

If i set this option to NO.. the error goes away.. Which means the award isnt displayed in the postbit area.. But i want it to be displayed.. Someone please help me...

What might be the problem?

Everything else is working just perfectly!

Thanks in advance

[mtha]

Tried installing this hack.. Everything worked perfectly.. Added few awards.. I awarded a award to a user.. And while viewing the thread i get this error..

If i disable the plugin.. There is no error.. Whats the problem any idea?

Please note that for testing purpose i have installed this hack on my local host.. :)

Fatal error: Using $this when not in object context in H:\localhost\xampp\xampp\htdocs\Vbulletin\showthre ad.php(923) : eval()'d code on line 2

well, dont remember why I added a $this->post['userid'] check in showthread hooks, so i just removed it.

anyway, you can download the new version, and import again.

[AshokForums.com]

Thanks... Its perfect now!

[Annie^.^]

Hi all!
I have a little problem. The script is great, but the only thing is the awards not showing in the posting under the user name.

[mtha]

Hi all!
I have a little problem. The script is great, but the only thing is the awards not showing in the posting under the user name.

did you edit the postbit (or postbit_legacy) template?

did you give user awards? (if not, it wont show up)

[Annie^.^]

Thank you for your reply. That solved the problem. Silly me :)

[dirtycrow]

any idea why the award showcase would be displayed in everyones profile except for the admins?

[FamilyCorner]

Clicked Install, awesome hack! Thank you very much, I really appreciate it. This is going to save me soooooooo many headaches!

[mtha]

any idea why the award showcase would be displayed in everyones profile except for the admins?

it should only be displayed in profile of those who HAVE awards, regardless he's admin or member

if admin doesnt have any award, then there's no showcase/

[dirtycrow]

it should only be displayed in profile of those who HAVE awards, regardless he's admin or member

if admin doesnt have any award, then there's no showcase/

the admin does have awards yet no showcase is viewable.

[mtha]

there's no reason for this, that I can think of right now

try: give more/remove awards to/from admin
give awards to other admins

check in MEMBER template, and see if the showcase is inside any condition that require usergroup not admin ...

[dirtycrow]

there's no reason for this, that I can think of right now

try: give more/remove awards to/from admin
give awards to other admins

check in MEMBER template, and see if the showcase is inside any condition that require usergroup not admin ...

tried and failed. can i shoot you an e-mail with a copy of my memberinfo template? perhaps you can spot something I'm missing.

[Arto]

I recently converted a phpBB forum to vBulletin and at the same time migrated members' medals from phpBB's Medal System Mod v2.1.0 by ycl6 (http://www.phpbb.com/phpBB/viewtopic.php?t=148362) to YAAS v2.0.5. As the SQL table schemas for both award mods are very similar, this was fairly painless and can be accomplished through executing a few simple SQL statements. What follows is a quick how-to which hopefully will be useful for others looking to avoid manually importing the medals :)

First off, it is presupposed that you've imported your phpBB forum's data to vB using Jelsoft's ImpEx, that the import session is still active (that is, the importuserid field needs to exist in vB's user table) and that you've installed YAAS. Additionally, the queries are written for a situation where phpBB and vB share the same database, phpBB with the table prefix phpbb_ and vB without a table prefix; adjust to your specific setup where necessary.

The SQL queries can be executed from vB's admin panel (if you have the permissions), phpMyAdmin or the MySQL command-line client. (Needless to say, if you don't know understand what the SQL statements do, or are unable to adapt them to your specific situation, don't execute them!)

To begin, the following SQL statement will convert all medals from phpBB to YAAS, preserving the same row identifiers (which means you may get clashes unless you first delete the included example award in YAAS):

INSERT INTO award SELECT medal_id AS award_id, -1 AS award_cat_id, medal_name AS award_name, medal_description AS award_desc, medal_image AS award_icon_url, medal_image AS award_img_url, 1 AS award_icon_url FROM phpbb_medal;

Note that the awards are imported as un-categorized; you will need to manually assign them to an award category in YAAS's admin panel before they'll show up in vB's front end.

Next, you need to copy all the medal/award images from phpBB's medals/ directory to the images/medals/ directory under your vB installation. The image paths also need to be corrected in the database, which can be done with the following two SQL statements (replace the URL http://www.yourforumsite.com/forum/ with your vB forum's base URL):

UPDATE award SET award_icon_url = CONCAT('http://www.yourforumsite.com/forum/images/', award_icon_url);
UPDATE award SET award_img_url = CONCAT('http://www.yourforumsite.com/forum/images/', award_img_url);

Finally, the following SQL statement will import all issued awards to YAAS, mapping from the phpBB user to the correct vB member through the aforementioned importuserid field:

INSERT INTO award_user SELECT m.issue_id, m.medal_id AS award_id, u.userid AS userid, m.issue_reason, m.issue_time FROM phpbb_medal_user m LEFT JOIN user u ON m.user_id = u.importuserid;

That's all, folks :) Though I migrated from the Medal System Mod v2.1.0, the instructions will likely work for newer versions as well (and could be enhanced to import award categories as well, which were introduced in the Medal System Mod v2.2.0).

[paulmjno]

I installed this, then disabled it almost immediately. It was causing MySQL errors throughout the whole board, and when I clicked the Award Manager options.

[Dollah]

installed thanx

[mtha]

tried and failed. can i shoot you an e-mail with a copy of my memberinfo template? perhaps you can spot something I'm missing.

you can email or PM me via my profile.

giving me your website would be good too, so I can take a look ...


I installed this, then disabled it almost immediately. It was causing MySQL errors throughout the whole board, and when I clicked the Award Manager options.

I'm not awared of anything like this should happen. if you could provide me more information, it'd be more helpful

(if there's bug in the hack, or you do anything wrong with it)

[FamilyCorner]

Just my 2 cents, I installed this without any problems at all and it's been running beautifully for a week now. In fact now I am taking votes on the next award we should create :)

Thanks again!

[TosaInu]

Sorry if this is already mentioned and me missing it:

-allow users to display the awards the like most in topicview, while the others show in profile.

Say only 3 awards are displayed, a user has 5 awards. Right now the 3 oldest awards are displayed in topicview. It's quite possible that the user is most proud about his new awards (recent, harder to get) and wants to display those.

Then you also have modest types who want to show only one or none in topicview :)

[trackpads]

mtha!

Great hack man! I am using it extensively on my site. As a mil guy there are a few additions if you could for the next release!

1. Allow awards to be resorted by weight, for example, allow us to choose higher ranking awards and those will be listed higher in a members postbit and profile.

2. Allow members to resort awards themselves?

3. Allow admin to choose which awards have the 'request awards' link and which ones do not. For example some awards cannot be request such as the member of the month etc etc.

4. Allow/disallow certain awards for certain usergroups

5. Allow members to comment on others' awards (congrats etc etc)

And thanks for all the work on this!!!!

[mtha]

Sorry if this is already mentioned and me missing it:

-allow users to display the awards the like most in topicview, while the others show in profile.

Say only 3 awards are displayed, a user has 5 awards. Right now the 3 oldest awards are displayed in topicview. It's quite possible that the user is most proud about his new awards (recent, harder to get) and wants to display those.

Then you also have modest types who want to show only one or none in topicview :)

dont understand what you are saying. but I am re-ordering the awards, so that newest awards are displayed first.

[mtha]

WORKING!


1. Allow awards to be resorted by weight, for example, allow us to choose higher ranking awards and those will be listed higher in a members postbit and profile.


Done, with options to sort
">Order by issued time (newest first)
">Order by issued time (oldest first)
">Order by Award Order (ASC)
">Order by Award Order (DESC)

2. Allow members to resort awards themselves?


you mean those who view member profile, can resort awards, or member who has award, can set display order setting?


3. Allow admin to choose which awards have the 'request awards' link and which ones do not. For example some awards cannot be request such as the member of the month etc etc.


this will require some changes in database, will look into it. I myself dont use (and dont like) the request award feature, if you want, I can add them in, but still, the feature will not be fully supported :)



4. Allow/disallow certain awards for certain usergroups

What do you mean by allow/disallow ...?

You admins are responsible for giving out awards, and you need to decide which award giving to which member (belong to which group). right?
I dont see the point of doing it, in adminCP


5. Allow members to comment on others' awards (congrats etc etc)


same as rating, ... good idea but I cant do it right now. maybe in the future :)

[akanevsky]

Nice hack! Installed.

[mtha]

Hack Version: 2.1.0.051127

- [2.1.0] Options to re-order awards in postbit and member's profile
>Order by issued time (newest first)
>Order by issued time (oldest first)
>Order by Award Order (ASC)
>Order by Award Order (DESC)
- [2.1.0] Option to set award in-active. Inactive awards will not be listed in award list. However, it will still be displayed in user's profile, if member has the award.
- [2.1.0] Option to set "Request Award" option for each award. (Need "Show request award column" option ON to see the request link)
- [2.1.0] Set custom usergroup permission, to set which group can request award (access request award page)
- [2.1.0] Option to limit maximum number of users for each award displayed in awards list
- [2.1.0] Change award_request options, all options are set in AdminCP, template and phrase based. Totally cumsomizable
- [2.1.0] Option to send PM to use when he receives an award.

[2.1.0] Display individual award with name of members who receive the award

UPGRADE:

- Upload all files in UPLOAD folder
- Delete /includes/setting.request_award.php
- Reconfig "Award System Settings" if you need to, especially if you use Award Request feature.
- Import/Overwrite YAAS Product

[trackpads]

Hack Version: 2.1.0.051127


- [2.1.0] Options to re-order awards in postbit and member's profile
>Order by issued time (newest first)
>Order by issued time (oldest first)
>Order by Award Order (ASC)
>Order by Award Order (DESC)
- [2.1.0] Option to set award in-active. Inactive awards will not be listed in award list. However, it will still be displayed in user's profile, if member has the award.
- [2.1.0] Option to set "Request Award" option for each award. (Need "Show request award column" option ON to see the request link)
- [2.1.0] Set custom usergroup permission, to set which group can request award (access request award page)
- [2.1.0] Option to limit maximum number of users for each award displayed in awards list
- [2.1.0] Change award_request options, all options are set in AdminCP, template and phrase based. Totally cumsomizable
- [2.1.0] Option to send PM to use when he receives an award.



[2.1.0] Display individual award with name of members who receive the award


UPGRADE:

- Upload all files in UPLOAD folder
- Delete /includes/setting.request_award.php
- Reconfig "Award System Settings" if you need to, especially if you use Award Request feature.
- Import/Overwrite YAAS Product

Excellent!!!!

[Oap JTRipper]

i get this error when setting the permissions to usergroups

[mtha]

i get this error when setting the permissions to usergroups

hmm, I dont get the error on my forums.

do you have error in other hack?

Try this:

Remove bitfield_awards.xml from your includes/xml folder, then go back to your usergroup permission, change some other setting, and see if you still get the error.

add the file back, rebuild bitfields, and try again with different group.




Can anyone confirm this error?

[trackpads]

hmm, I dont get the error on my forums.

do you have error in other hack?

Try this:

Remove bitfield_awards.xml from your includes/xml folder, then go back to your usergroup permission, change some other setting, and see if you still get the error.

add the file back, rebuild bitfields, and try again with different group.




Can anyone confirm this error?

I got it but had to rebuild the bitfields, I had removed a different hack and it was 'lingering'. Rebuild the bitfields and you will be fine.

-Jason

[EasyTarget]

great hack thank you.

I was wondering if for future versions you could make it so you could also choose to award a usergroup a medal so that each member in that group could receive it instead of having to do it one by one? or maybe even the ability to award a medal to a usergroup instead of a user.

also combining this hack with the post award hack:
https://vborg.vbsupport.ru/showthread.php?t=92677

where you could give an award to a specific post or thread.

thanks again.

[mtha]

Version 2.1.1 - Add some checkng for errors before sending PMs (in issue awards and request award)

If you had 2.1.0 installed, you just need to replace
request_award.php and admincp/award.php
with the new files.
AND reimport XML product.

[mtha]

I got it but had to rebuild the bitfields, I had removed a different hack and it was 'lingering'. Rebuild the bitfields and you will be fine.

-Jason

with vB 3.5.1, it rebuilds bitfield automatically. If you use vB 3.5.0, please rebuild bitfield.

great hack thank you.

I was wondering if for future versions you could make it so you could also choose to award a usergroup a medal so that each member in that group could receive it instead of having to do it one by one? or maybe even the ability to award a medal to a usergroup instead of a user.

thanks again.

Interesting idea. i will think about it.

[EasyTarget]

sorry edited my post above with:

"also combining this hack with the post award hack:
https://vborg.vbsupport.ru/showthread.php?t=92677

where you could give an award to a specific post or thread.

thanks again"

and just wanted to let you know you did a nice job on the readme as well.

[mtha]

sorry edited my post above with:

"also combining this hack with the post award hack:
https://vborg.vbsupport.ru/showthread.php?t=92677

where you could give an award to a specific post or thread.

thanks again"

and just wanted to let you know you did a nice job on the readme as well.

the scheme is different, so it'd be easier to leave them two seperate award hack, especially when someone else already release one.

[EasyTarget]

ok. they seem to work ok together anyways. I did post some suggestions in the other thread for the post award hack which would make it very distinct from what he's done so far. (to actually make it more like yours with the award categories and admincp integration and the versatility which your hack allows)

[TosaInu]

This update sounds very nice.

- [2.1.0] Option to set award in-active. Inactive awards will not be listed in award list. However, it will still be displayed in user's profile, if member has the award.

When each user can do this himself for his own awards, then that solves what I asked. In other words: allow each user to display his favourite awards in postbit.

I'll upgrade tonight.

Upgrade is so fast and easy: great release!

[Oap JTRipper]

cheers works fine now

[mtha]

Hack Version: 2.1.2.051128

[2.1.2] Collapse award categories and awards showcase
[2.1.2] Rearrange some templates

UPGRADE:

- Upload all files in UPLOAD folder
- Import/Overwrite YAAS Product
- Reedit templates (MEMBERINFO, postbit/postbit_legacy, memberlist_resultsbit) (not required but you should edit for collapse to function, or phrase cleanup)

[mtha]

This update sounds very nice.

When each user can do this himself for his own awards, then that solves what I asked. In other words: allow each user to display his favourite awards in postbit.

I'll upgrade tonight.

Upgrade is so fast and easy: great release!

dont like this idea for each user to de-activate award very much.

for user to set which award to show first, i will think about it.

[dark dragun]

Sorry I need a pointer or two on this. Its installed and working but the request arnt showing up in the specified thread, or forum. This is set through the Admincp.

In your instructions, you say setup settings.request_award.php to use this feature, but its not in the zip file that up for download.

My question is do i setup in admincp or use the file if i can find it?

If the admincp, then I can not get it to work right. it will send pm to user i pick, but thats it nothing else go 'es through. Any thoughts

[hydrostatic]

Small thing: in template awards_request_form,
<legend>$vphrase[award_description]</legend> needs to be <legend>$vbphrase[award_description]</legend>

[mtha]

Sorry I need a pointer or two on this. Its installed and working but the request arnt showing up in the specified thread, or forum. This is set through the Admincp.

In your instructions, you say setup settings.request_award.php to use this feature, but its not in the zip file that up for download.

My question is do i setup in admincp or use the file if i can find it?

If the admincp, then I can not get it to work right. it will send pm to user i pick, but thats it nothing else go 'es through. Any thoughts

i think i did remove the thing say edit settings...., i put edit in AdminCP instead, did I?

you dont need to look for that setting file, in the latest version.

my version work fine. check your settings and try again.

[dark dragun]

Its still in your first or 2nd post. I am setting thread id to 1. thats all i put in is 1
I tried it again and got pm, email nothing else. please come and try it at my site.
user name:tester
pass:tester
http://www.almightyassassins.com/Socom3/awards.php

[mtha]

Small thing: in template awards_request_form,
<legend>$vphrase[award_description]</legend> needs to be <legend>$vbphrase[award_description]</legend>

fixed, thanks

Its still in your first or 2nd post. I am setting thread id to 1. thats all i put in is 1
I tried it again and got pm, email nothing else. please come and try it at my site.
user name:tester
pass:tester
http://www.almightyassassins.com/Socom3/awards.php

The request is posted to the thread #1 here:
http://www.almightyassassins.com/Socom3/showthread.php?t=1
http://www.almightyassassins.com/Socom3/showthread.php?p=303#post303

and forum #4 here:
http://www.almightyassassins.com/Socom3/forumdisplay.php?f=4
http://www.almightyassassins.com/Socom3/showthread.php?t=93


It's working fine.

[ChrisBaktis]

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

Database error in vBulletin 3.5.1:

Invalid SQL:

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

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

[samu2]

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

[mtha]

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

Database error in vBulletin 3.5.1:

Invalid SQL:

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

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

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

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

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

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

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


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


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

[mtha]

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



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

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

[ChrisBaktis]

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

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

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

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

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


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


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

Got this error on the third query:

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

[mtha]

Got this error on the third query:

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


remove the " . TABLE_PREFIX . " in that query.

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

[ChrisBaktis]

worked great - thanks.

[gator777]

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

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

[nexus851]

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

[Gaskell]

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

[sifuhall]

Hello. I just installed and immediately recieved several hundred error emails (we have a very busy site) with the following error:


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 post.postid IN (0,214689,214697,214701,214703,214705,214711,21471 3,214715,214731,214742,214745,214747,214767,214768 ,214771)

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

MySQL Error : Unknown column 'a.award_id' in 'on clause'


I opened my awards table (it was created and appears there was no errors during the creating step of installation) and sure enough, there is no field named award_id in the awards table.

However there is a fieldnamed awardsid

Could this be a left over remnant from a hack long ago?

[MissKalunji]

Hello. I just installed and immediately recieved several hundred error emails (we have a very busy site) with the following error:


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 post.postid IN (0,214689,214697,214701,214703,214705,214711,21471 3,214715,214731,214742,214745,214747,214767,214768 ,214771)

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

MySQL Error : Unknown column 'a.award_id' in 'on clause'


I opened my awards table (it was created and appears there was no errors during the creating step of installation) and sure enough, there is no field named award_id in the awards table.

However there is a fieldnamed awardsid

Could this be a left over remnant from a hack long ago?


its because its a none register post......check in the previous post theres fix for it

[apfparadise]

I need some help. Brilliant hack, I used the 3.0 one by Inf.Webby and now I upgraded to 3.5 and this is a BIG must for me. It's installed and I love it, specially all the cool new stuff, BUT...

My awards are kind of big, and I would like a <br> between them so that they show one under the other. Which template is that done in? I have been trying for 2 hrs and can not figure it out. I am pretty sure it can be done, I did it in 3.0 somehow but who can remember, right? :)

Thank you in advance for the help.
Ed

[chimaira]

right ive added some custom award... but i dont like the placement... i want to place it here (look at pic) What template and where do i need to edit it.. to be put there.. i also dont like the box that much.. is there anyway to remove the box surrounding the award?
Hope someone can help me out here. andthanks :)

[tony76]

right ive added some custom award... but i dont like the placement... i want to place it here (look at pic) What template and where do i need to edit it.. to be put there.. i also dont like the box that much.. is there anyway to remove the box surrounding the award?
Hope someone can help me out here. andthanks :)

Good if someone can tell me how to remove the border of the box

[shush]

Can you help me at all please.

I have installed as directed. I am not sure what I have done wrong, but nothing shows up in my ACP for the awards editing.

I have not altered any templates as yet, do I need to do this first, I thought it would have shown in the ACP once I installed.

Any feedback appreciated.
I very much want to use your program and will be happy to support.

Oh here is part of the message that came up when I tried to install.

Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)

[ChuckH]

What is a good image size for the awards? - Nevermind

[ChuckH]

How do I change the column widths on Awards.php? The Award Description column is very narrow, while the users who have received award column is very long. I intend to only award to one user per award, so I would like to balance it out to allow a more in-depth description.

[Phlex]

I got a Problem with just one User
Only his award is shown in the profil , but not in posbit .
What's the problem ?

[mackers8923]

I got a Problem with just one User
Only his award is shown in the profil , but not in posbit .
What's the problem ?

Did you complete the postbit template edits?

[Spiffware]

kool thanks for this hack..

[Phlex]

Did you complete the postbit template edits?
yes of course ,but its really wierd , it just doesn't work with one single user

[shush]

Got it running now...No longer need help. Thanks anyway.

I have been wanting something like this for ages, we were placing trophies in members siggies till now.

Great work...I love it!!!

[RED_LINE]

hello

have problems with a modification, when i install the hack i have this error

Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode,
displayorder, advanced, volatile, product)
VALUES
(
'aw_display_limit',
'awards',
'4',
'4',
'free',
'',
30,
0,
1,
'award'
),
(
'award_pm_fromuserid',
'awards',
'0',
'0',
'number',
'',
100,
0,
1,
'award'
);

MySQL Error : Duplicate entry 'aw_display_limit' for key 1
Error Number : 1062
Date : Friday, December 30th 2005 @ 05:57:01 AM
Script : http://www.mysite.net/vb/adminCp/plugin.php
Referrer :
http://www.mysite.net/vb/adminCp/plugin.php?do=productadd
IP Address : 75.169.93.198
Username : RED_LINE
Classname : vb_database


how can i fix this error?

Best Regards,

[shush]

RED LINE, I had this same error when uploading, see above posts. the awards system still works anyway.

Only thing I have a little query on is this. When you go to plug in manger, any plugins I have are listed. But the awards one does not show as YAAS etc. etc.
It has this message instead.

Yet Another Award System 3.5 2.0.6
https://vborg.vbsupport.ru/showthread.php?t=94836

Waaaaah what have I done wrong?

[GlitterKill]

Hmm I have run into a strange error. When trying to assign an award to any member with a ' in their name it returns an error and the award is not given. For instance, the member name "rockin'male" return an error because of the apostrophe. All other usernames with apostrophes return errors as well when trying to give them awards.

Any ideas how to fix this?

Also here are urls to our implementation if you would like to use them in the examples.
http://forums.pimprig.com/awards.php
http://forums.pimprig.com/showpost.php?p=471624&postcount=3
http://forums.pimprig.com/member.php?action=getinfo&userid=1

Thanks for the great hack!

Edit//crap, I just realized I have those hidden for guests in the postbit. You can login with this account to see...
User: test
Pass: test

[mackers8923]

Hi

I have added this hack to my site and the members love it. I have one request though! In the attached image you'll see one of the various awards from my site.

My question is, how do I extend the amount of text that is allowed to be typed for the description of the award? Some are quite long and as you can see it is being cut short.

I would appreciate any help anyone can offer on this.

[Ghanem]

Hi,
thank you first for the gr8 hack..

I have a small problem with award requests email..
the email received by admin looks like:

- admin

------------------
Sender Information
.
.
.
while it should look like:
- admin

------------------
Sender Information
.
.
.

Version used: 2.1.2
VB version: 3.5.2

[Karsh]

Hi, i like this hack just one big big problem i want for you to fix for me.

You when an member posts an reply and so on, you see the name and Rep and other things, at the moment the awards are at the bottom how do i make them so it is under the Users name?

[Karsh]

Someone please help on this

[Karsh]

Anyone!?

[dubsyxxx]

how do i give someone the award??? anyone can help

[Nick King]

Karsh, Put the awards code beneath $post[musername]
</if>

dubsyxxx, goto your admincp -> Awards System -> Award Manager -> *pick the award to give* click Manage and fillin the userid (if you know it) OR (not AND, OOOORRR I've had many people fill in both and get it wrong and mess it up) username and the issue reason. If you want to notify the user via PM, check Yes and click save.

[Gaskell]

how do i give someone the award??? anyone can help

If an award has been requested (from the page like this (http://www.trackpads.com/forum/awards.php)), check the ACP for Award System. In that part there will be Award Manager. Next to the award you want to give someone, click Manage. Fill in the User ID or Username boxes and put in a reason if you want. Hit Save and its done :)

[Ghanem]

what about me :(
https://vborg.vbsupport.ru/showpost.php?p=870743&postcount=228

[2fast4ya]

Hello, awards are not showing up in member's posts... what have i done wrong?

[2fast4ya]

and yes ive done the postbit tempelate edits. ive double checked them as well to make sure i've done them correctly.

[2fast4ya]

okay, i looked at this again... it works in postbit_legacy, but not in postbit... but the tempelate edit is correct!

[dubsyxxx]

If an award has been requested (from the page like this (http://www.trackpads.com/forum/awards.php)), check the ACP for Award System. In that part there will be Award Manager. Next to the award you want to give someone, click Manage. Fill in the User ID or Username boxes and put in a reason if you want. Hit Save and its done :)
thanks a lot your the man

[Gaskell]

No problems - happy to help where I can :)

[cyberhypnotic]

Any way of allowing a Moderator to have access to the Award Manager? Or to the whole Awards navigation? Basically, adding it to the Moderators navigation menu in the ModCP?

I'm desperate to be able to allow a Mod award giving privileges, but not AdminCP access. Any help?

[rb290]

hey i need some help, i've had this hack installed for awhile and ive been doing vB upgrades and i keep doing the edits after every upgrade for this hack but now i dont know whats wrong when people request an award I dont get a pm anymore..know whats wrong ?

EDIT: nevermind, i found where to do it in the Award System Settings

[mtha]

Any way of allowing a Moderator to have access to the Award Manager? Or to the whole Awards navigation? Basically, adding it to the Moderators navigation menu in the ModCP?

I'm desperate to be able to allow a Mod award giving privileges, but not AdminCP access. Any help?

Sorry guys, my time is too limited now, so I currently cant give any support or upgrade to the hack. The hack is proved to be working properly, so if other members can give a hand on problems, it's be greatly appreciated.

I will try my best to give support when I have some spot on my schedule :)

[GlitterKill]

No problems - happy to help where I can :)

in the admincp when managing an award (giving a new one) how can the list of current members with the award be sorted alphabetically? Since I have multiple moderators and alot of award recipients there have been a few duplicate awards given. Sorting the list like this would make it easier to prevent that problem. :)

[Gaskell]

I have no idea on that I'm afraid. I am not a coder, so maybe someone else knows or can code a bit to do that :)

[mtha]

in the admincp when managing an award (giving a new one) how can the list of current members with the award be sorted alphabetically? Since I have multiple moderators and alot of award recipients there have been a few duplicate awards given. Sorting the list like this would make it easier to prevent that problem. :)

well, I dont have a sorting argument yet, but you can do something like this:

edit /admincp/award.php

Line 722-727:
LOOK FOR

$awardusers = $db->query_read("
SELECT au.*, u.username
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u USING (userid)
WHERE au.award_id=". $vbulletin->GPC['award_id'] ."
");



REPLACE WITH


$awardusers = $db->query_read("
SELECT au.*, u.username
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u USING (userid)
WHERE au.award_id=". $vbulletin->GPC['award_id'] ."
ORDER BY u.username
");

[Hellcat]

WOW!
That's not only exactely what I was looking for, this is even MORE!
I gave it a brief testrun on my private test install - GREAT THING!
I like the "Request Award" feature, my members will LOVE it!

* Hellcat hits INSTALL :)

[Roxie]

Is there away to arrange the order that the awards appear on the list (profile, postbit, memberslist)?

[Ghanem]

Hi,
thank you first for the gr8 hack..

I have a small problem with award requests email..
the email received by admin looks like:
https://vborg.vbsupport.ru/showpost.php?p=870743&postcount=228

Some one forgoten here :rolleyes:

[wallymg]

Hi,

I have installad the german version of this award system yesterday. (Version 2.0.4 / VB Version 3.5.3)

Everything works fine but from time to time I receive the following Database Error via Email:

Datenbankfehler in vBulletin 3.5.3:

Invalid SQL:

SELECT a.*, au.*
FROM award a, award_user au
WHERE (au.userid = ) AND (a.award_id=au.award_id)
ORDER BY au.issue_time;

MySQL-Fehler : You have an error in your SQL syntax near ') AND (a.award_id=au.award_id)
ORDER BY au.issue_time
' at line 4
Fehler-Nr. : 1064
Datum : Monday, February 6th 2006 @ 12:42:09 AM
Skript : http://www.arcadeinfo.de/announcement.php?f=36
Referrer :
IP-Adresse : 68.142.251.50
Benutzername : Unregistriert
Klassenname : vb_database


I cant find the error. Like I said the Board and the Scipt are working fine. Just this stupid email from time to time. Is there a way to slove the problem ?

Thanks in Advance
Walter