TheBigChief Posted March 4, 2009 Posted March 4, 2009 I found a nice mod on the web and I'm not too sure who created it but its good. On one of the files I get this error: QUERY ERROR: Unknown column 'cars_owned' in 'field list' Query was UPDATE users SET money=money-3000,cars_owned=cars_owned+1 where userid=1 Here is the code, can anyone help? You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. the sql was You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
POG1 Posted March 4, 2009 Posted March 4, 2009 Re: [v2] Car Mods add cars_owned to the user table Quote
DeaTH_RideR Posted March 4, 2009 Posted March 4, 2009 Re: [v2] Car Mods it seems your missing the users field so here they are (finally i catch something that i can help with) You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
POG1 Posted March 4, 2009 Posted March 4, 2009 Re: [v2] Car Mods you could separate each of them names with a comma and turn like 20 queries into 1 Quote
Karlos Posted March 4, 2009 Posted March 4, 2009 Re: [v2] Car Mods Or modify the script and make them into a new table.. Quote
John99 Posted March 4, 2009 Posted March 4, 2009 Re: [v2] Car Mods you could separate each of them names with a comma and turn like 20 queries into 1 You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Should work or this? i aint sure.. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Correct me if i am wrong.. Quote
Haunted Dawg Posted March 4, 2009 Posted March 4, 2009 Re: [v2] Car Mods He mean's one field 19 comma's (,). By this, 1,8,1,45,7,2,6,2,76,2,7,1,8,1,7,2 Then $numbers = explode(',',$user['field']); $field_1 = $numbers[0]; Quote
rscott4581 Posted March 5, 2009 Posted March 5, 2009 Re: [v2] Car Mods This is great, and that did work on the SQL, but now it can't find Garage.php.. I am assuming there is more to this mod than posted? Quote
POG1 Posted March 5, 2009 Posted March 5, 2009 Re: [v2] Car Mods He mean's one field 19 comma's (,). By this, 1,8,1,45,7,2,6,2,76,2,7,1,8,1,7,2 Then $numbers = explode(',',$user['field']); $field_1 = $numbers[0]; Yeah. Then a for loop to stuck it back together probly. or you could try this; http://dev.mysql.com/doc/refman/5.0/en/ ... _concat-ws Quote
champs08 Posted March 5, 2009 Posted March 5, 2009 Re: [v2] Car Mods does anyone have a full working car mod that they can share with us :-D Quote
Robert Posted March 5, 2009 Posted March 5, 2009 Re: [v2] Car Mods what's wrong? can't search the forum?.. :-( anyways.. http://criminalexistence.com/ceforums/i ... ic=24555.0 Quote
blade727 Posted March 9, 2009 Posted March 9, 2009 Re: [v2] Car Mods Lol their aint even a car mod on that thread. Quote
John99 Posted March 9, 2009 Posted March 9, 2009 Re: [v2] Car Mods I dont think any of uses dont even know how to use the search form. I typed: Car mod: Click Here! Wasnt hard eh? 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.