HITMAN 17 Posted November 12, 2007 Share Posted November 12, 2007 currentmission int 11 default 0 wats the sql for that Quote Link to comment Share on other sites More sharing options...
gurpreet Posted November 12, 2007 Share Posted November 12, 2007 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.. Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted November 12, 2007 Author Share Posted November 12, 2007 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 Quote Link to comment Share on other sites More sharing options...
gurpreet Posted November 12, 2007 Share Posted November 12, 2007 Re: wats correct Finally query :) Your learning lol. I think its: ALTER TABLE `users` add currentmission int 11 default 0 Try that Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted November 12, 2007 Author Share Posted November 12, 2007 Re: wats correct works a treat thnx Quote Link to comment Share on other sites More sharing options...
gurpreet Posted November 12, 2007 Share Posted November 12, 2007 Re: wats correct do you have to have the ;? or is that just extra? Quote Link to comment Share on other sites More sharing options...
Halo Posted April 19, 2008 Share Posted April 19, 2008 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 Quote Link to comment Share on other sites More sharing options...
Halo Posted May 1, 2008 Share Posted May 1, 2008 Re: wats correct Wouldn't it be: ALTER TABLE `users` ADD `currentmission` INT(11) NOT NULL DEFAULT '0'; Quote Link to comment Share on other sites More sharing options...
Spudinski Posted May 1, 2008 Share Posted May 1, 2008 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. Quote Link to comment Share on other sites More sharing options...
Delete ! Posted May 24, 2008 Share Posted May 24, 2008 Re: wats correct Agreed =] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.