Post Award Hack

[Abe1]

Post Award Hack 2.1


Overview:
This hack will allow you to award individual posts. It will give you an option to add or remove the award. It will show a rosette on a post that has been awarded.

Features:

Shows a rosette on all awarded posts
Search for individuals awarded posts
Search for all awarded posts
Settings to allow what users or usergroups can give thanksInstallation information on hack:

Files edited: 0
Templates edited: 4
Files to upload: 1
Time to install: 5 minutes maxUpdates:

Version 2.1 (2/8/06):

GOLD Release of this hack for vBulletin version 3.5
Added user and usergroup permissions via the acp options
Rewrote the template edits

Please post your comments or suggestions for this hack. I read ALL posts.

MAKE SURE YOU CLICK INSTALL (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=92677)!
You will get an email when a new version is released.

This hack is created for your use free of charge. No payment is requested. However, if you would like to donate money for the work I put in to this hack, a donation would show your appreciation.
https://vborg.vbsupport.ru/external/2010/02/12.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=bigware%40gmail%2ecom&item_name=Donation%20for%20Post%20Award%20Hack&no_shipping=0&tax=0&currency_code=USD&bn=PP%2dDonationsBF&charset=UTF%2d8)

[ForYou]

Nice Award ,

is there away to give users Award , it's like this hack ,

Regards

[Azhrialilu]

Nice :D

[Darth Gill]

Where's the PHP file (award.php) and where is the SQL to update the database. Also I found a problem in the templates editing...

You have

in MEMBERINFO:
find:
--------------------------------------------------------------------
<if condition="$vboptions['profilelastpost']">
--------------------------------------------------------------------

replace with:
--------------------------------------------------------------------
<tr>
<td><a href="search.php?$session[sessionurl]do=findawards&amp;u=$userinfo[userid]">Find all awarded posts by $userinfo[username]</a></td>
</tr>
--------------------------------------------------------------------


It should be:
find:

<td><a href="search.php?$session[sessionurl]do=process&amp;showposts=0&amp;starteronly=1&amp;exactname=1&amp;s earchuser=$userinfo[urlusername]"><phrase 1="$userinfo[username]">$vbphrase[find_all_threads_started_by_x]</phrase></a></td>
</tr>



after it add:

<!-- HACK -->
<tr>
<td><a href="search.php?$session[sessionurl]do=findawards&amp;u=$userinfo[userid]">Find all awarded posts by $userinfo[username]</a></td>
</tr>
<!-- HACK -->

[Darth Gill]

Nevermind I see the sql in the xml.

[Abe1]

Where's the PHP file (award.php) and where is the SQL to update the database. Also I found a problem in the templates editing...

You have

in MEMBERINFO:
find:
--------------------------------------------------------------------
<if condition="$vboptions['profilelastpost']">
--------------------------------------------------------------------

replace with:
--------------------------------------------------------------------
<tr>
<td><a href="search.php?$session[sessionurl]do=findawards&amp;u=$userinfo[userid]">Find all awarded posts by $userinfo[username]</a></td>
</tr>
--------------------------------------------------------------------


It should be:
find:

<td><a href="search.php?$session[sessionurl]do=process&amp;showposts=0&amp;starteronly=1&amp;exactname=1&amp;s earchuser=$userinfo[urlusername]"><phrase 1="$userinfo[username]">$vbphrase[find_all_threads_started_by_x]</phrase></a></td>
</tr>



after it add:

<!-- HACK -->
<tr>
<td><a href="search.php?$session[sessionurl]do=findawards&amp;u=$userinfo[userid]">Find all awarded posts by $userinfo[username]</a></td>
</tr>
<!-- HACK -->

First, thanks for that template error. It should have said "add before" instead or "replace". I fixed it in the zip download.

Second, the award.php is no longer needed. All actions are in the plugings. Yhe SQL change is also done by the installer when you import the plugings. It's a pritty cool way how the installer and uninstaller work using the plug-in sytem.

[Darth Gill]

Why do some of the templates link to award.php then if it's handled by the plugin?

[Abe1]

Why do some of the templates link to award.php then if it's handled by the plugin?

I must have been sleeping when I made the installer. Anyways, I just fixed it over. award.php was not changed to showthread.php. The search features I had made already go to search.php.

[Darth Gill]

Oh, another bug, you have in the instructions to upload to images/buttons when it should be images/misc

[Abe1]

Oh, another bug, you have in the instructions to upload to images/buttons when it should be images/misc

Anything else? I'm glad I call this Beta.

I had copied the image location from my Post Thanks Hack that is why is said button and not misc.

Anyways, all showld be good now.

[Darth Gill]

Yes all is good now. I have the hack install perfectly! I love it, thank you very much. Here's an example of the icon I made: http://forums.5solas.org/showthread.php?p=34232#post34232

[ForYou]

Nice Award ,

is there away to give users Award , it's like this hack ,

Regards

Please i need to give some users Award not just post ,

is there away to let this hack work with tow way , Award for Post and award for user ,

Regards

[ForYou]

Hello ,

when i install the hack , i just see Remove Award , and there is no link to add Award ,

what is the problem ?

Regards

[Abe1]

Hello ,

when i install the hack , i just see Remove Award , and there is no link to add Award ,

what is the problem ?

Regards

Did you import the xml?

[Darth Gill]

Hey another thing you could add to the XML is the code to index the award column in the post table. Searching on my board was taking several seconds without the index. Added the index and searching was instantaneous.

[theArchitect]

Very cool. I loved this hack for 3 and will really install it once it goes gold.

[TrueDeath]

all was well except when i went to give an award i got
Invalid SQL:

UPDATE `post` SET `award` = '1' WHERE `postid` = '4967' LIMIT 1;

MySQL Error : Table 'usr_vbb.post' doesn't exist
Error Number : 1146
Date : Saturday, July 23rd 2005 @ 09:10:18 AM
Script : http://www.*removed*.co.uk/forum/showthread.php?do=award&postid=4967
Referrer :
IP Address : *removed*
Username : Matt
Classname : vb_database


edit:
i fixed this by adding my table prefix in the plugin.

[Abe1]

Updated and will work on rc1 and rc2.

[Gizmo5h1t3]

works a treat on RC2

[NuclioN]

Is it possible to make more award types to award with? :)

[VB-STYLE]

when i want to give an award i get

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

UPDATE `post` SET `award` = '1' WHERE `postid` = '202938' LIMIT 1;

MySQL Error : Unknown column 'award' in 'field list'
Error Number : 1054
Date : Tuesday, August 16th 2005 @ 05:08:25 PM
Script : http://XXXXXXXX showthread.php?do=award&postid=202938
Referrer :
IP Address : XXXXXXX
Username : XXXXX
Classname : vb_database

also when i want to Uninstall the hack i get

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
ALTER TABLE `post` DROP `award`;

MySQL Error : Can't DROP 'award'. Check that column/key exists
Error Number : 1091
Date : Tuesday, August 16th 2005 @ 05:25:00 PM
Script : http://XXXXXXXXXX/vb/admincp/plugin.php
Referrer : http://XXXXXXXXXX/vb/admincp/plugin.php?do=productdelete&productid=post_award&s=
IP Address : XXXXXXX
Username : XXXXXX
Classname : vb_database

[Abe1]

when i want to give an award i get



also when i want to Uninstall the hack i get

You mostlikey installed the wrong file. You must have imported the the Update xml.

[VB-STYLE]

I'm using FRESH INSTALLATIONS ONLY :)

and yesterday i install the hack so i don't need
the Update xml ..

[VB-STYLE]

MySQL Error : Unknown column 'award' in 'field list' :(

[Abe1]

MySQL Error : Unknown column 'award' in 'field list' :(

Did you import the xml into products or plugins?

[VB-STYLE]

into products

[Abe1]

into products

Sorry, I dont know the problem. Are you useing Prefexes?

[VB-STYLE]

what is Prefexes?

[Abe1]

what is Prefexes?

an add on to each table in you database

[VB-STYLE]

ok
do you think if i run Manual Query will work?
i mean to add award.

[Abe1]

ok
do you think if i run Manual Query will work?
i mean to add award.

It should.

ALTER TABLE `post` ADD `award` TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL

[VB-STYLE]

:)
it's working now aftar
i add the query manual.

thank you.

[chikkoo]

This is a very nice idea to encourage the posters.

I found the same type of errors. The UPDATE sql query is not having TABLE PREFIX. I added manually, then started working.

I would suggest adding more categories. Like I am using this for Best Poem of the Month. I also want to use it for Best Joke, Best Story, etc.

Or you can change colors and sizes to add more steps, like 1st Price 2nd Price 3rd Price and so on. This is just a suggestion. I don't know whether it is possible.

[Abe1]

This is a very nice idea to encourage the posters.

I found the same type of errors. The UPDATE sql query is not having TABLE PREFIX. I added manually, then started working.

I would suggest adding more categories. Like I am using this for Best Poem of the Month. I also want to use it for Best Joke, Best Story, etc.

Or you can change colors and sizes to add more steps, like 1st Price 2nd Price 3rd Price and so on. This is just a suggestion. I don't know whether it is possible.

Fixed now.

[Biker_GA]

Hello ,

when i install the hack , i just see Remove Award , and there is no link to add Award ,

what is the problem ?

Regards

I have the same issue. There's a Remove option, but no add option. (And yes, I imported the xml under Products.

[Abe1]

I have the same issue. There's a Remove option, but no add option. (And yes, I imported the xml under Products.

did you download the latest version that was just released?

[Biker_GA]

Yepper... And uploaded product-post_award_2_0b3.xml into products (new install). I just removed the plugin and reinstalled. Same thing. Can remove, but there's no add option.

[Abe1]

Yepper... And uploaded product-post_award_2_0b3.xml into products (new install). I just removed the plugin and reinstalled. Same thing. Can remove, but there's no add option.

I just tested a fresh installation an it worked fine. I need me info from you. What happend when you click remove?

[Biker_GA]

It removed the plugin. :)

[ForYou]

did you download the latest version that was just released?

Hello ,

There is the same problem just i see Add Award and remove ، But i can't add award and how can i remove the award without add ??? Look at the attach

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

Regards

[Abe1]

Hello ,

There is the same problem just i see Add Award and remove ، But i can't add award and how can i remove the award without add ??? Look at the attach

http://www.dardasha.net/imagehost/uploads/5b4cb6c7ec.png (http://www.dardasha.net/imagehost)

Regards

Are you sure the template changes were made to your current template?

[EasyTarget]

Thanks Abe, installed on 3.5.1 just fine. even working with another awards hack (for users not threads). I can award and remove with no problems so far.

maybe some nice features to add/consider would be ability to define award categories, upload post award images, maybe a forum which all awarded posts get copied to or a page that just list them all (besides the search function). if you add more award categories maybe a page like that could be sorted to show awards by their category.

also maybe an option to award a thread. this could add an award thread icon to the thread list/view page which would also be a nice distinction.

@For You, here's an award user hack that is very well done and integrated into the admincp:
https://vborg.vbsupport.ru/showthread.php?p=834641

a combination of these hacks would be very nice.

[wcbryant]

I've been having some users complain of random subscriptions (http://www.vbulletin.com/forum/showthread.php?t=165959) to threads around the site. Post Award and the Advanced Warning System are the only two hacks I have (as I sit here and think about it) that play with showthread.php, which is the file Steve at vb.org suggested would be the area of concern.

Can anyone think of any reason Post Awards, under any circumstances, might be causing such a problem in limited cases? Just trying to narrow down my field of search, and hopefully remedy the problem.

[Abe1]

I've been having some users complain of random subscriptions (http://www.vbulletin.com/forum/showthread.php?t=165959) to threads around the site. Post Award and the Advanced Warning System are the only two hacks I have (as I sit here and think about it) that play with showthread.php, which is the file Steve at vb.org suggested would be the area of concern.

Can anyone think of any reason Post Awards, under any circumstances, might be causing such a problem in limited cases? Just trying to narrow down my field of search, and hopefully remedy the problem.

Nope. Cant think of a way.

[Ramsesx]

Thanks a lot abe, your hacks are everytime an improvement for my forum.

[cyberhypnotic]

I have a moderator that was looking to give out an award for special and/or unique posts made by members. I wanted to give him something that ONLY he could use and not another moderator.

With the use of this hack, plus the creation of a moderator usergroup for him, which will look like the other moderator usergroups, he now will have his special stamp of approval for the forum.

Thanks a bunch!

[Zia]

helo Abe1

Its a very usefull hack..it help a lot to decide the best poster or the best thread author in a month...
we are on vb3.5.3
does it support vb3.5.3 ?

umm can u add an xtra option..like on cmps to show the top 5(or whatever) award receiver with links on top award received post or get the info from acp?

it will be nice..plz have a thought on it

Thnx

[Abe1]

helo Abe1

Its a very usefull hack..it help a lot to decide the best poster or the best thread author in a month...
we are on vb3.5.3
does it support vb3.5.3 ?

umm can u add an xtra option..like on cmps to show the top 5(or whatever) award receiver with links on top award received post or get the info from acp?

it will be nice..plz have a thought on it

Thnx

It should work on vb3.5.3. i hope to fully update in the coming days. I just finished working on a different hack called Moderator Stats.

[Mudvayne]

It should work on vb3.5.3. i hope to fully update in the coming days. I just finished working on a different hack called Moderator Stats.

Hope it works.. :D.. I 'll eagerly wait for ur full update.. & I wanna say as like Zia.. Is it possible to make a module which 'll show the stat in vba cmps?

[Abe1]

Hope it works.. :D.. I 'll eagerly wait for ur full update.. & I wanna say as like Zia.. Is it possible to make a module which 'll show the stat in vba cmps?

Should be possible.

[Zia]

Should be possible.

Helo Abe1

Thankx for ur nice co-operation..

we are waiting for this update version...

It would be really a grate edition to our board.. :D

[Abe1]

Version 2.1 (2/8/06):

GOLD Release of this hack for vBulletin version 3.5
Added user and usergroup permissions via the acp options
Rewrote the template edits

You should re-do all template edits if you are upgrading.

[Zia]

Version 2.1 (2/8/06):

GOLD Release of this hack for vBulletin version 3.5
Added user and usergroup permissions via the acp options
Rewrote the template edits

You should re-do all template edits if you are upgrading.

Thank U Sir....Thanku Very Much...

Is thera any cmps block to show

Who Got how many Award : klikable link to show in which/which thread [maybe lots of sql query]...any other way instead of lots sql query?



Thnx

[Abe1]

Thank U Sir....Thanku Very Much...

Is thera any cmps block to show

Who Got how many Award : klikable link to show in which/which thread [maybe lots of sql query]...any other way instead of lots sql query?



Thnx

There is no count by users for how many awards they got.

[Zia]

frankly i trying figure out a system for Best Poster of the month some ting like that
system...

in previous version...one post can get only one award.ANy way tht a post can get multiple award?
and a block Latest 5/10 award received post (ignoring user)....
what about it?

Thnx

[Abe1]

frankly i trying figure out a system for Best Poster of the month some ting like that
system...

in previous version...one post can get only one award.ANy way tht a post can get multiple award?
and a block Latest 5/10 award received post (ignoring user)....
what about it?

Thnx

Sorry, I dont think I'm going to be adding more features to this hack. I recommend my Post Thank You Hack for such a thing.

[Zia]

oh okay.....
just dont wanted to make the installed hacks list longer....

Many thnx

[chikkoo]

Nice Hack. Installed & working fine.

I have two suggestions:

1) I want the Post's Icon/Thread's Icon to show a mini Awarc Icon automatically, if a Post is given Award.

It would be easy to find the Awarded Threads from the Thread Display mode.

2) Add a short description velow the Award picture, i.e. "Best post of April 2006".

Can somebody suggest me how todo it?

[davelacey]

There's going to be a simple solution to this, but after clicking "add award", all I get is the word "award".

the relevant pointer to the images/misc directory is

<img src="$stylevar[imgdir_misc]/rosette.gif" alt="award">

The rosette.gif is in my images/misc directory.

Suggestions, anyone?
Thanks in advance.

[mtha]

Abe1,

Adding post award counter would be great.

Says if someone receive howmany post awards ...

Also, same problem with Post Thanks Hack, the search take too much time (with 1,060,392 posts)

search.php?$session[sessionurl]do=findallawards

Search took 166.78 seconds; generated 2 minute(s) ago.

[Abe1]

Abe1,

Adding post award counter would be great.

Says if someone receive howmany post awards ...



Also, same problem with Post Thanks Hack, the search take too much time (with 1,060,392 posts)

search.php?$session[sessionurl]do=findallawards

Search took 166.78 seconds; generated 2 minute(s) ago.
I'm going to see if I can do anything about that.

[doggy1]

Thank you for offering this hack. It looks great!

I was wondering though if there is a setting that will allow folks to NOT be able to reward their own posts. It appears they can and this may pose a problem with greedy folks. If it doesn't have this setting is there any chance of adding it? Thanks!

[Abe1]

Thank you for offering this hack. It looks great!

I was wondering though if there is a setting that will allow folks to NOT be able to reward their own posts. It appears they can and this may pose a problem with greedy folks. If it doesn't have this setting is there any chance of adding it? Thanks!
Only admins or mods can add awards. I dont think your mods would do this.

[doggy1]

Only admins or mods can add awards. I dont think your mods would do this.
Yes, I do not think they would, but I was thinking of having the registered members be able to use this as well. Perhaps supporting members of the site. If I did that, then maybe there would be ribbon abuse. LOL! Just wondering if there were any plans to prevent self awards. Thanks for the reply and the hack. :)

[Abe1]

Yes, I do not think they would, but I was thinking of having the registered members be able to use this as well. Perhaps supporting members of the site. If I did that, then maybe there would be ribbon abuse. LOL! Just wondering if there were any plans to prevent self awards. Thanks for the reply and the hack. :)
I'll see what I can do for next version.

[mtha]

Yes, I do not think they would, but I was thinking of having the registered members be able to use this as well. Perhaps supporting members of the site. If I did that, then maybe there would be ribbon abuse. LOL! Just wondering if there were any plans to prevent self awards. Thanks for the reply and the hack. :)

well, then you can create a group of member who can give awards, and change the permission, so that if groupid = xxx, the person can give award.

[RFViet]

cool

[Ramsesx]

I'll see what I can do for next version.
Will be there a next version? Thanks.

[Ronak]

Does this work with 3.6.x ??

[Abe1]

Does this work with 3.6.x ??
It should

[Ramsesx]

After updating to 3.6.4 everything is working fine except this error message if I click on /search.php?do=findallawards:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 657

[catastrope]

After updating to 3.6.4 everything is working fine except this error message if I click on /search.php?do=findallawards:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 657

even i'm facing the same problem:surprised:

wat do i do?
I badly want this feature...but hav to solve this warning...
pls guide me...

[Abe1]

even i'm facing the same problem:surprised:

wat do i do?
I badly want this feature...but hav to solve this warning...
pls guide me...
I dont support 3.6.x yet for this hack.

[cloyal]

Any chance some one could tell me if the search all awards was solved for 3.6.X? I've got members that really loved this hack and would like to use it again since I've upgraded to 3.6.7PL

[Abe1]

Any chance some one could tell me if the search all awards was solved for 3.6.X? I've got members that really loved this hack and would like to use it again since I've upgraded to 3.6.7PL
It does work on my forum.

[DieselMinded]

Anyone Running on 3.6.8 ?

[DieselMinded]

Running on 3.6.8 Thanks Installed

[Bree]

Intalled (again hehe)... Works great on 3.7 Beta 3 (*Blush* I gotta update hehe)
Thanks again! -Bree

[mystic10]

First Of All I Want To Thank The Aurthor For Making Such An Awesome And Unique Hack...it Was Definetly Needed...so Thanks

Request: Option To Put More Pics So We Can Select The Type Of Award We Want To Give For That Post....much Appreciated

Once Again Thanks..i Have 3.6.8pl2 And It Works Great

[YLP1]

Is there a version for 3.6.8 pl2?

[Abe1]

Is there a version for 3.6.8 pl2?
No. But this version should work i think.

[Bree]

Request: Option To Put More Pics So We Can Select The Type Of Award We Want To Give For That Post....much Appreciated

I second that =0) That is an awesome idea Mystic! Regardless tho, I love this Mod!

-Bree

[cafenetland]

works pretty nice.

thx

[DieselMinded]

Abe , Can i get the conditional for Post Bit to show

Total Awarded Posts :

and have the posts number link to there posts

Also Give them $1000 Casino Cash from The Casino Mod would be Great !!

Thanks for considering

DM

[DieselMinded]

Working on 3.7.0 Gold

[jazzyname]

so long ago... does this work with 3.8 or is there an updated for 3.8, or is there something simple like this to award posts out there ? Tyvm in adv.