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?

Re: [REVIEW] Thug Ways - Please review!! I don't really go for the green myself but I do really like your graphic layout. The whole layout of the site is nice and very complimentary to play, good flow and easy to follow. Also, with the layout set up as it is, I wasn't in the least annoyed at the plain background, cos the background is almost non existant anyway.( and yes I know, plain backgrounds are fine. Just happens to be a pet hate of mine) I always look for mods that are a little different, so maybe a bit more work on that... Overall, I like it!

Re: [REVIEW] Illegal-Intent - please review that is true, anyway, I gave you a +1 for your comments anyway. thanks.

Re: [REVIEW] Illegal-Intent - please review Thanks for the constructive comments. Background - takes a little adjusting to I guess after all the plain backgrounds that are so common, but I like the fact it is a bit different. Captcha once again off (not sure why it was back on, will have to figure that one out!) Shoutbox- yep, people either love em or hate em... Design...yeah well, everything is always a work in progress...I doubt design is a strong point of mine. But the bit I love best about your review...a little unique...that is exactly what I was aiming for so thanks for that comment above all others.

Re: [REVIEW] Illegal-Intent - please review :lol:

Re: [REVIEW] Illegal-Intent - please review Good thing your opinion doesn't bother me then zero. Those are the kind of comments I would expect from you. And just so you are informed, again, the reason I put you in fed is because you broke rule #1.

Re: [REVIEW] Illegal-Intent - please review captcha no longer a problem...any further feedback?

Re: [Mcodes V2]Auction Cron Fix[Needed] should $db->query("delete from auctions where time=0", $c); be $db->query("DELETE FROM 'auctions' WHERE 'time' <0", $c); or $db->query("DELETE FROM 'auctions' WHERE time ==0", $c); Keep in mind I am a total noob and I am probably way wrong!!!

Re: [mccode v2] Mine Shaft If by level restrictions not working you mean it goes over 100% and doesn't upgrade your level but just keeps going, maybe it needs an edit to the global_func.php. I added a mining function under my check_level function. Since this code is different to mine I'm sure the script will be different too, and since my last try at being helpful wasn't the best option, I will let Zero give you the right script to match his code. I'm sure Zero will add the updates soon. Of course it would be nothing new for me to be totally on the wrong track lol, I am a total noob/dumbass with all this code stuff and just beginning to learn it myself. Good luck.

Re: [mccode v2] Mine Shaft add at the top of the mining.php or whatever it is called... if($ir['mined'] > 20) { die("You can only mine 20 times a day"); }   and then also in the mining code wherever it has your queries for users table add mined=mined+1 so it adds 1 to mined each time they mine...e.g. a line like this: $query = sprintf('UPDATE `users` SET %s = %s + %u, brave = brave - %u WHERE userid = %u', $Mtype, $Mtype, $earn, $cost, $userid); would look like this: $query = sprintf('UPDATE `users` SET %s = %s + %u, brave = brave - %u, mined=mined+1 WHERE userid = %u', $Mtype, $Mtype, $earn, $cost, $userid);   and add to your users table... mined int 11 default 0   and add to your day_cron.php $db->query("UPDATE users SET mined=0");   and that is all that is needed...although I'm sure someone else will have a better way of doing it.

Re: [mccode v2] Mine Shaft I have no problem publicly admitting you have helped me. And I have appreciated it and thanked you for it to. And I don't doubt you have helped others. And who would have known a gentle jibe about a typo would have got you this fired up. I said it already, and I'll say it again, Sorry Zero.