Uriah

Column count doesn't match value count means you are trying to put in a different amount of information than you have space for. i.e. look at your "items" data base in your phpmysql in your c panel and look at how many fields are there, eg, itmid, itemprice, itemname etc and if there are say 5 fields, you then look at the line of code where it says INSERT INTO items VALUES... and check how many sets of ' ' are in that line of code, eg, INSERT INTO items VALUES('',200,'gun',etc... this would mean the ('', would be the itmid, the '200', would be the itemprice, and the 'gun', would be the item name) so if the number of fields matches the number of values then there will be no error message. If you are getting the error message you got then the fields and values don't match up so either delete or add a field or value as needed to make them match. If you need more explanation come see me at my site or look me up on yahoo. My profile will give you any details you need. ;)

Well put...find me anyone who enjoys being told what to do... :whistling:

also shouldn't line 75 > Back"; be > Back";

Re: hacked game and banned If you are still stuck shout at me on yahoo phoenix198

Re: does anyone know how to sort this Could it be because higher up in the script when the player gets a job the data base isn't setting his points, only his pay?   $db->query("UPDATE users SET job={$_GET['interview']},jobrank={$r['jrID']} WHERE userid=$userid;");

Re: [MCCODES V2] Mobile text messaging If you were to put $db->query("UPDATE users SET tcredits=10 WHERE userid=$userid"); in your day cron, that would give each user 10 free per day. I would suggest adding it to your register.php instead so that each user gets 10 when they register and they have to purchase them after that. You could run it as a cron once to set all current users and then leave it to the register.php for all new members. Simply add the values to the line that starts out like this... $db->query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy,.... in the register file

Re: [V1] V1 Help Please +1 for standing up and being honest

Re: [McCodes V2] Streets Mod I could be wrong, (I frequently am) but wouldn't this mean players that are using their turns every hour would just keep getting an ongoing supply? Surely as they are issued a users turn count goes up and as they are used the count comes down so it would never reach 100!

Re: Calling it a Day :) You'll be missed, coders who spend more time coding than posting negative comments everywhere are precious commodities. All the best with whatever you do next.

Re: [mccode v2] Parse The Parcel - [Re-Programmed] still doesn't show

Re: [mccode] Mining mod maybe something like... function mine_1() { global $ir,$c,$userid,$db;$domain; if($ir['power'] < 10) { print "<center>You need 5 power to mine here your have {$ir['power']}</center>"; die ("</table><tr><td><image src='bottom1.png'></td></tr></table>"); } $chance = rand(1,2); $db->query("UPDATE users SET power=power-10 WHERE userid=$userid",$c); $rand_gems = rand(0,5); $rand_exp = rand(1,100); $rand_hosp = rand(5,15); if ($chance == 1) echo "<center>You begin mining in the level 1 mine and found $rand_gems crystal(s).</center> "; $db->query("UPDATE users SET crystals=crystals+'$rand_gems',mine_exp=mine_exp+'$rand_exp' WHERE userid=$userid",$c); if ($chance == 2) $hospreason = 'Fell into the mine.'; echo "<center>You tripped and fell in the mine, go to hospital for $rand_hosp minutes.</center> "; $db->query("UPDATE users SET crystals=crystals+'$rand_gems',mine_exp=mine_exp+'$rand_exp',hospital=hospital+'$rand_hosp' WHERE userid=$userid",$c); $db->query("UPDATE users SET hospreason='$hospreason' WHERE userid=$userid",$c); but doing it this way with only 2 chances will make it kind 50/50 so you may want to add other chances to give a better randomness to it... And I really have no idea what I am doing anyway so this could be all wrong!!!

Re: [mccode v2] Fishing Mod I went and tested both the fishing mods mentioned here, one by $$BULL$EYE$ and one by MDK666 ... they look like edited version of search the streets or whatever people are calling it, however I managed to go from level 1 to level 6 in the first one and level 1 to level 9 in the other...way too easy...

Re: [mccode v2] Farming and if you read through the code there are a heap more of { than of } go through and make sure every open { has a closure too } Then it no longer has an unexpected end...

Re: [mccode v2] Fishing Mod I have hunting and fishing options on my site if you wanna have a look, am happy to help if wanted. www.illegal-intent.com

Re: [mccode] [TGM] Crystal Market Logs [TGM]   Ummm...why not use the code posted for V2?