The Ace Posted March 31, 2008 Posted March 31, 2008 I have successfully installed the Ruby Trader....so, I am trying to make my crimes give Rubys. I can enter the amount of rubys for succeeding at the crime, but whenever I push submit, it comes up with: QUERY ERROR: Unknown column 'crimeSUCCESSRUBY' in 'field list' Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSRUBY, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'test', '100', '((WILL*0.8)/2.5)+(LEVEL/4)', '1000000', 1000, 100, 0, '6', 'tetet', 'tetehh', 'khsjf', 'jhfsjf', 10, 'hfhf', 10) Does this mean I have to add the Success Rubys bit to my database? But, what would the query be!? :( EDIT: I have V2! :) Quote
AlabamaHit Posted April 1, 2008 Posted April 1, 2008 Re: New Crime.... Sounds like you didn't make that table. crimeSUCCESSRUBY You need to add that to your crimes table, in your database. Quote
The Ace Posted April 1, 2008 Author Posted April 1, 2008 Re: New Crime.... But would would I put into the query? EDIT: would it be something like this: ALTER TABLE `crimes` ADD `crimeSUCCESSRUBY` INT( 11 ) NOT NULL DEFAULT '0'; Quote
The Ace Posted April 1, 2008 Author Posted April 1, 2008 Re: New Crime.... That query worked...so I'm alright now....thanks AlabamaHit! :) Quote
AlabamaHit Posted April 1, 2008 Posted April 1, 2008 Re: New Crime.... No Problem, sorry I didn't get to respond to the query. but You got it :-D Quote
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.