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

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

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

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

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

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

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

Can I borrow your site as a demo? :>

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

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

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

Not sure why im the only one getting this error.

Please try to execute the query in phpMyAdmin or in AdminCP

[sql]
CREATE TABLE award (
award_id smallint(5) unsigned NOT NULL auto_increment,
award_cat_id smallint(5) NOT NULL default '1',
award_name varchar(50) NOT NULL default '',
award_desc varchar(250) NOT NULL default '',
award_icon_url varchar(250) NOT NULL default '',
award_img_url varchar(225) NOT NULL default '',
award_displayorder smallint(5) NOT NULL default '0',
PRIMARY KEY (award_id)
) TYPE=MyISAM;
[/sql]

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

I got a message 'effected rows: 0'

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

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

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

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

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

[sql]
DROP TABLE IF EXISTS `award`;
[/sql]
[sql]
CREATE TABLE `award` (
`award_id` smallint(5) unsigned NOT NULL auto_increment,
`award_cat_id` smallint(5) NOT NULL default '1',
`award_name` varchar(50) NOT NULL default '',
`award_desc` varchar(250) NOT NULL default '',
`award_icon_url` varchar(250) NOT NULL default '',
`award_img_url` varchar(225) NOT NULL default '',
`award_displayorder` smallint(5) NOT NULL default '0',
PRIMARY KEY (`award_id`)
) TYPE=MyISAM;
[/sql]
[sql]DROP TABLE IF EXISTS `award_user`;[/sql]
[sql]CREATE TABLE `award_user` (
`issue_id` smallint(5) NOT NULL auto_increment,
`award_id` smallint(5) NOT NULL default '0',
`userid` int(10) NOT NULL default '0',
`issue_reason` varchar(255) NOT NULL default '',
`issue_time` int(10) NOT NULL default '0',
PRIMARY KEY (`issue_id`)
) TYPE=MyISAM;
[/sql]

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


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

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