AlabamaHit

Re: Help Needed with Monorail Try this...   $cityprice = $r['cityprice']; $cityowner = $r['cityowner']; mysql_query("UPDATE users SET money = money + $cityprice WHERE userid = $cityowner"); That should work right..

Re: Help Needed with Loan Officer All i see wrong on very quick look over is at the top... You don't need that session_start(); Take is out maybe its trying to run 2 sessions causing it????? Just a thought....

Re: The Point of Crime XP? agreed. mccodes is not a good way to learn...Its a way to get an Idea..but not learn...If you learn from it you will learn the Wrong way to do it...Im not bashing anyone I'm glad for everyone wanting to learn :-D

Re: The Point of Crime XP? but did you put a game up on free host and try to play it? or have players play it? I understand best way to learn is hands on..i agree with that.

Re: The Point of Crime XP? What is the reason for the crimes....... And YOU OWN a game...... Look kid stop downloading codes and placing on free server. Dont deney it No one will dump $75+ into codes and have NO clue what the hell they just bought.

Re: MCC V1 Jail Problem The combination is to show the Gang they user is in and the User...that code you made wont do it...

Re: Programs I use BlueFish...(Linux). Honestly don't know if they have a windows version. You could check it out. Its a good program I think...they have some fill ins for you but not many which i like i hate for example how DW wants to fill in for you...

Re: How Do I Delete The Inactive Yup...you woudl have to remove from for example users, userstats, delete the gang, (if you have mods...remove them from there examle honors.) and so on and on...and if they are in fed..you have to remove them from there.....

Re: View Surrenders CHeck your database see if the surrender is still there...Maybe it didnt send or got deleted somehow.... Let us know i will keep trying to help :P

Re: I need help with PHP No problem glad to help.

Re: [MCCv2] Crons Not Working they probarly stopped the curl feature on your hosting package.

Re: I need help with PHP Take the ' out of the querys......   mysql_query("UPDATE users SET level=level+1,brave=brave+2,maxbrave=maxbrave+2, hp={975*$ir['level']} ,maxhp={975*$ir['level']} WHERE userid=$userid") or die(mysql_error()); mysql_query("UPDATE users SET upgrade=upgrade-1 WHERE userid=$userid") or die(mysql_error());   Personallly I would change it to something like...   $hp = 975 * $ir['level']; $maxhp = 975 * $ir['level']; mysql_query("UPDATE users SET level=level+1, brave=brave+2, maxbrave=maxbrave+2, hp=$hp, maxhp=$maxhp WHERE userid=$userid") or die(mysql_error()); The other query is fine.

Re: war surrender Use the Search feature This is in the forums already more than once im sure or it.

Re: house tax If its NOT going into the minus you must have a WHERE clause in the query that prevents it.... So (Just an example) I would guess you have this $db->query("UPDATE users SET money=money-$tax WHERE money > 0"); For this to take them in the negative just take the WHERE out... Example... $tax = 5000; $db->query("UPDATE user SET money=money-$tax"); That would go on ALL users....Im sure your error is in the WHERE cluase of the query running.

Re: Help Needed [MC Codes 2] Thats half of it if you ahve the $jobquery=1; At the top You just need to put this $ir['jNAME'] where ever you want there job name to show.

Re: How to Make you rmarried Stats Display in viewuser.php     That code he gave will work Perfect for v1 You put it where ever you want it.........(Like where you want it to show up at.) and What Tonka said i Second that....use a $r not $ir

Re: View Surrenders try this im not sure but seems like you changed alot in there..   else { $_POST['sur'] = abs((int) $_POST['sur']); $q=$db->query("SELECT surWAR FROM surrenders WHERE surID={$_POST['sur']}"); $_POST['war'] = $db->fetch_single($q); $wq=$db->query("SELECT * FROM gangwars where warID={$_POST['war']}"); $r=$db->fetch_row($wq);   to   else { $_POST['sur'] = abs((int) $_POST['sur']); $q=$db->query("SELECT surWAR FROM surrenders WHERE surID={$_POST['sur']}"); list($_POST['war']) = $db->fetch_row($q); $wq=$db->query("SELECT * FROM gangwars where warID={$_POST['war']}"); $r=$db->fetch_row($wq);

Re: Battle Bot's Help mabye this line... "{$r['itmname']} ";   never heard of botattack....

Re: crimes Sounds like the query is in there 2 times to do it...or they are refreshing the page.....post the query that takes there brave and i will help.

Re: Stalemate bans members I agree...but that will fix it lol..... Looks like for some reason you put in the code to update the users attacking to 252 (guessing thats the round of stalemate)....But it should be updated to 0. So they don't lose exp.

Re: Energy problem lol, I'm confussed now......You don't know how you did it? You don't ahve to say I understand you want to protect your code I was just giving an idea of how to do it if you where to have done it that way... From what I understand your way will not work... A players energy is not a % its a number when there level goes up the number goes up...I think at level one there energy in the database is 12 so for yours to work it would have to be 18 but I dont know but figure as they level it would give you errors..

Re: Battle Bot's Help Don't know if its just me but I don't fully understand...Could you explain little better?

Re: Education cron No problem glad it helped :wink:

Re: Cron alternative? Very well said...I was trying give them an easy way out lol

Re: Education cron Theres a couple ways to do this with just the quick look over I did... One is this.... in your page find   $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0");   change it to this   $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0 AND cdays > 0");   or instead of changing to that you can add this below that line i said find..   $db->query("UPDATE users SET cdays=0 WHERE cdays < 0");   Either way should fix that for you. Good luck hope this helps.