Thank you!!

trying to run the sql files and I am getting this error:

SQL-query :

CREATE award(

awardid smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
description varchar( 250 ) NOT NULL default '',
icon_url varchar( 250 ) NOT NULL default '',
PRIMARY KEY ( awardid )
) TYPE = MYISAM

MySQL said:

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 'award (
awardid smallint(5) unsigned NOT NULL auto_increment,

What am I doing wrong?

add a ; at the end

Only thing I can think of that would rock even more for this, would be to make some of the awards user requestable, and then the admin could approve.

Great job, I may use this. :)

Ummm....then it wouldn't be an award would it :) "I request the member of the month award please..." LOL!

This might be a dumb question but once we give the user an award, it is permamnet right? For example I want to give people awards for things they do/volunteer to do on the site. And then give that award to others also, like military awards etc.

Thanks again,

-Jason

anyone got this in action so we can see it ??

I REALLY want this but I am hoping for Gold soon so I dont have to re-hack it. It looks great!

-Jason

LOL nps trackpads - im just waiting for someone to test it and be the guinea pig.
I cant add hacks unless im 100 % sure as cant back up databse cause i have probs telenetting in :(

Your right, it would then be a Medal ;)

Hehe reason I ask that is I run a forums for an Online Game. And there are certain achievments you can attain that I could have awards displayed for the members that have done them.

But I'd hate to have to go through and check every member, would rather have them request it, then I'd verify, and set it, if they had done it.

Hmmm, that make sense? :P

Well I've been trying to install and am receiving a variety of errors on RC2...the biggest one, and it took me a while to figure out...The query for insert in phrases...14009 is listed twice...so I had to change it to 14005 in order for the query to run correctly. Have also been having problems with various functions..I will not list them now..Going to try a clean install and see if it sorts itself out first. If the same errors appear, I"ll post them