wats correct

[HITMAN 17]

currentmission int 11 default 0

wats the sql for that

[gurpreet]

Re: wats correct

AAAAAAGHHHHH FFS its not sql!!!! its query. And if you bought the mod, i think its Isomerizer's mod, he would have provided you with queries. If it is the same missions mod..

[HITMAN 17]

Re: wats correct

5) You will need to add a field into the user database as follows:

currentmission int 11 default 0

wats the query to add it to database then

[gurpreet]

Re: wats correct

Finally query :) Your learning lol. I think its:

 

ALTER TABLE `users` add currentmission int 11 default 0

 

Try that

[HITMAN 17]

Re: wats correct

works a treat thnx

[gurpreet]

Re: wats correct

do you have to have the ;? or is that just extra?

[Halo]

Re: wats correct

lol, i think its just when you are in phpMyAdmin you don't need to but when you are importing files it helps if you do

[Halo]

Re: wats correct

Wouldn't it be:

 

ALTER TABLE `users` ADD `currentmission` INT(11) NOT NULL DEFAULT '0';

[Spudinski]

Re: wats correct

 

do you have to have the ;? or is that just extra?

"In normal cases the mySQL client interprets the ; character as the end of a SQL statement." - technikhil

The ";" is called a delimiter in MySQL, mostly used when sending more than one query at the same time to the server.

[Delete !]

Re: wats correct

Agreed =]