Post Award Hack

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 thanks

Installation information on hack:

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

Updates:

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

[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....=post_award&s=
IP Address : XXXXXXX
Username : XXXXXX
Classname : vb_database

[Abe1]

Originally Posted by VB-STYLE

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]

Originally Posted by VB-STYLE

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

Did you import the xml into products or plugins?

[VB-STYLE]

into products

[Abe1]

Originally Posted by VB-STYLE

into products

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

[VB-STYLE]

what is Prefexes?

[Abe1]

Originally Posted by VB-STYLE

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.