Tonka

Re: Please Help. No problem, glad to help

Re: Please Help. This should work for you   print <<<EOF <button onclick="addPTag(document.getElementById('text'),'B')">[b]B[/b]</button> <button onclick="addPTag(document.getElementById('text'),'I')">[i]I[/i]</button> <button onclick="addPTag(document.getElementById('text'),'U')"><u>U</u></button> EOF;

Re: View Surrenders all the other gangs work fine, it's just my gang, so it doesn't matter to much

Re: Battle Bot's Help botattack is what i made so the users can't attack the bot's unless they go through the battle tent, i'm going to change it later

Re: View Surrenders it didn't work, it's only happening to gang 1, which is my test gang

Re: Battle Bot's Help every time any of my users or i try to attack bot's 5-7 i keep getting QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid=1' at line 1 Query was UPDATE users SET attacking= WHERE userid=1

bots 5-7 keep giving me, QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid=1' at line 1 Query was UPDATE users SET attacking= WHERE userid=1   <?php $menuhide=1; $atkpage=1; include "globals.php"; print "<center>"; $_GET['ID'] == (int) $_GET['ID']; if(!$_GET['ID']) { print "WTF you doing, bro?"; $h->endpage(); exit; } else if($_GET['ID'] == $userid) { print "Only the crazy attack themselves."; $h->endpage(); exit; } else if($_GET['ID'] == 1) { print "ERROR: Tonka Can Not Be Attacked"; $h->endpage(); exit; } /*else if($_GET['ID'] == 2) { print "ERROR: CommandoRyu Can Not Be Attacked"; $h->endpage(); exit; }*/ else if ($ir['hp'] <= 1) { print "Only the crazy attack when their unconscious. [url='index.php']Back[/url]"; $h->endpage(); exit; } else if ($_SESSION['attacklost'] == 1) { print "Only the losers of all their EXP attack when they've already lost. [url='index.php']Back[/url]"; $_SESSION['attacklost']=0; $h->endpage(); exit; } //get player data $youdata=$ir; $q=$db->query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid={$_GET['ID']}"); $odata=$db->fetch_row($q); $myabbr=($ir['gender']=="Male") ? "his" : "her"; $oabbr=($r['gender']=="Male") ? "his" : "her"; if($ir['attacking'] && $ir['attacking'] != $_GET['ID']) { print "Trying to Cheat I See. [url='index.php']Back[/url]"; $_SESSION['attacklost']=0; $h->endpage(); exit; } if($odata['hp'] == 1) { print "This player is unconscious. [url='index.php']> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } else if($odata['protected']) { print "This users is protected by their bodyguard. You are unable to get past the bodyguard and attack {$r['username']}. [url='index.php']> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } else if($odata['hospital']) { print "This player is in hospital. [url='index.php']> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } else if($ir['hospital']) { print "While in hospital you can't attack. [url='hospital.php']> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } else if($odata['jail']) { print "This player is in jail. [url='index.php']> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } else if($ir['jail']) { print "While in jail you can't attack. [url='jail.php']> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } else if($ir['location'] != $odata['location']) { print "You can only attack someone in the same location! [url='index.php']> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } else if($odata['fedjail']) { print "This user is in fed jail and can not be attacked. [url='index.php']> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } if($_GET['wepid']) { if($_SESSION['attacking']==0 && $ir['attacking'] == 0) { if ($youdata['energy'] >= $youdata['maxenergy']/2) { $youdata['energy']-= floor($youdata['maxenergy']/2); $me=floor($youdata['maxenergy']/2); $db->query("UPDATE users SET energy=energy- {$me} WHERE userid=$userid"); $_SESSION['attacklog']=""; $_SESSION['attackdmg']=0; } else { print "You can only attack someone when you have 50% energy"; $h->endpage(); exit; } } $_SESSION['attacking']=1; $ir['attacking']=$odata['userid']; $db->query("UPDATE users SET attacking={$odata['userid']} WHERE userid=$userid"); $_GET['wepid'] = (int) $_GET['wepid']; $_GET['nextstep'] = (int) $_GET['nextstep']; //damage if($_GET['wepid'] != $ir['equip_primary'] && $_GET['wepid'] != $ir['equip_secondary']) { print "Stop trying to abuse a game bug. You can lose all your EXP for that. [url='index.php']> Home[/url]"; $db->query("UPDATE users SET exp=0 where userid=$userid",$c); die(""); } $qo=$db->query("SELECT i.* FROM items i WHERE i.itmid={$_GET['wepid']}"); $r1=$db->fetch_row($qo); $mydamage=(int) (($r1['weapon']*$youdata['strength']/($odata['guard']/1.5))*(rand(8000,12000)/10000)); $hitratio=max(10,min(60*$ir['agility']/$odata['agility'],95)); if(rand(1,100) <= $hitratio ) { $q3=$db->query("SELECT i.armor FROM items i WHERE itmid={$odata['equip_armor']} ORDER BY rand()"); if($db->num_rows($q3)) { $mydamage-=$db->fetch_single($q3); } if($mydamage < -100000) { $mydamage=abs($mydamage); } else if($mydamage < 1) { $mydamage=1; } $crit=rand(1,40); if($crit==17) { $mydamage*=rand(20,40)/10; } else if($crit==25 or $crit == 8) { $mydamage/=(rand(20,40)/10); } $mydamage=round($mydamage); $odata['hp']-=$mydamage; if($odata['hp']==1) { $odata['hp']=0;$mydamage+=1; } $db->query("UPDATE users SET hp=hp-$mydamage WHERE userid={$_GET['ID']}"); print "<font color=red>{$_GET['nextstep']}. Using your {$r1['itmname']} you hit {$odata['username']} doing $mydamage damage ({$odata['hp']})</font> \n"; $_SESSION['attackdmg']+=$mydamage; $_SESSION['attacklog'].="<font color=red>{$_GET['nextstep']}. Using {$myabbr} {$r1['itmname']} {$ir['username']} hit {$odata['username']} doing $mydamage damage ({$odata['hp']})</font> \n"; } else { print "<font color=red>{$_GET['nextstep']}. You tried to hit {$odata['username']} but missed ({$odata['hp']})</font> \n"; $_SESSION['attacklog'].="<font color=red>{$_GET['nextstep']}. {$ir['username']} tried to hit {$odata['username']} but missed ({$odata['hp']})</font> \n"; } if($odata['hp'] <= 0) { $odata['hp']=0; $_SESSION['attackwon']=$_GET['ID']; $db->query("UPDATE users SET hp=0 WHERE userid={$_GET['ID']}"); print " [b]What do you want to do with {$odata['username']} now?[/b] <form action='attackwon.php?ID={$_GET['ID']}' method='post'><input type='submit' value='Mug Them' style='background-color: #000000; color:#FFFFFF;' /></form> <form action='attackbeat.php?ID={$_GET['ID']}' method='post'><input type='submit' value='Hospitalize Them' style='background-color: #000000; color:#FFFFFF;' /></form> <form action='attacktake.php?ID={$_GET['ID']}' method='post'><input type='submit' value='Leave Them' style='background-color: #000000; color:#FFFFFF;' /></form>"; } else { //choose opp gun $eq=$db->query("SELECT i.* FROM items i WHERE i.itmid IN({$odata['equip_primary']}, {$odata['equip_secondary']})"); if(mysql_num_rows($eq) == 0) { $wep="Fists"; $dam=(int)((((int) ($odata['strength']/$ir['guard']/100)) +1)*(rand(8000,12000)/10000)); } else { $cnt=0; while($r=$db->fetch_row($eq)) { $enweps[]=$r; $cnt++; } $weptouse=rand(0,$cnt-1); $wep=$enweps[$weptouse]['itmname']; $dam=(int) (($enweps[$weptouse]['weapon']*$odata['strength']/($youdata['guard']/1.5))*(rand(8000,12000)/10000)); } $hitratio=max(10,min(60*$odata['agility']/$ir['agility'],95)); if(rand(1,100) <= $hitratio) { $q3=$db->query("SELECT i.armor FROM items i WHERE itmid={$ir['equip_armor']} ORDER BY rand()"); if($db->num_rows($q3)) { $dam-=$db->fetch_single($q3); } if($dam < -100000) { $dam=abs($dam); } else if($dam < 1) { $dam=1; } $crit=rand(1,40); if($crit==17) { $dam*=rand(20,40)/10; } else if($crit==25 or $crit == 8) { $dam/=(rand(20,40)/10); } $dam=round($dam); $youdata['hp']-=$dam; if ($youdata['hp']==1) { $dam+=1; $youdata['hp']=0; } $db->query("UPDATE users SET hp=hp-$dam WHERE userid=$userid"); $ns=$_GET['nextstep']+1; print "<font color=blue>{$ns}. Using $oabbr $wep {$odata['username']} hit you doing $dam damage ({$youdata['hp']})</font> \n"; $_SESSION['attacklog'].="<font color=blue>{$ns}. Using $oabbr $wep {$odata['username']} hit {$ir['username']} doing $dam damage ({$youdata['hp']})</font> \n"; } else { $ns=$_GET['nextstep']+1; print "<font color=blue>{$ns}. {$odata['username']} tried to hit you but missed ({$youdata['hp']})</font> \n"; $_SESSION['attacklog'].="<font color=blue>{$ns}. {$odata['username']} tried to hit {$ir['username']} but missed ({$youdata['hp']})</font> \n"; } if($youdata['hp'] <= 0) { $youdata['hp']=0; $_SESSION['attacklost']=1; $db->query("UPDATE users SET hp=0 WHERE userid=$userid"); print "<form action='attacklost.php?ID={$_GET['ID']}' method='post'><input type='submit' value='Continue' />"; } } } else if ($odata['hp'] < 5) { print "You can only attack those who have health"; $h->endpage(); exit; } else if ($ir['gang'] == $odata['gang'] && $ir['gang'] > 0) { print "You are in the same gang as {$odata['username']}! What are you smoking today dude!"; $h->endpage(); exit; } else if ($youdata['energy'] < $youdata['maxenergy']/2) { print "You can only attack someone when you have 50% energy"; $h->endpage(); exit; } else if ($youdata['location'] != $odata['location']) { print "You can only attack someone in the same location!"; $h->endpage(); exit; } else { } if($youdata['hp'] <= 0 || $odata['hp'] <= 0) { } else { $vars['hpperc']=round($youdata['hp']/$youdata['maxhp']*100); $vars['hpopp']=100-$vars['hpperc']; $vars2['hpperc']=round($odata['hp']/$odata['maxhp']*100); $vars2['hpopp']=100-$vars2['hpperc']; print "<center><table width='50%' align='center'> <tr><td align='center'>Your Health: {$ir['hp']}/{$ir['maxhp']} <img src=images/greenbar.png width={$vars['hpperc']} height=10><img src=images/redbar.png width={$vars['hpopp']} height=10></td></tr> <tr><td align='center'>Opponents Health: {$odata['hp']}/{$odata['maxhp']} <img src=images/greenbar.png width={$vars2['hpperc']} height=10><img src=images/redbar.png width={$vars2['hpopp']} height=10></td></tr></table>"; $mw=$db->query("SELECT i.* FROM items i WHERE i.itmid IN({$ir['equip_primary']}, {$ir['equip_secondary']})"); print " Attack with: "; if($db->num_rows($mw) > 0) { while($r=$db->fetch_row($mw)) { if(!$_GET['nextstep']) { $ns=1; } else { $ns=$_GET['nextstep']+2; } if($r['itmid']==$ir['equip_primary']) { print "[b]Primary Weapon:[/b] "; } if($r['itmid']==$ir['equip_secondary']) { print "[b]Secondary Weapon:[/b] "; } print "[url='botattack2.php?nextstep=$ns&ID={$_GET[']{$r['itmname']}[/url] "; } } else { print "You have nothing to fight with."; } print "</center>"; } $h->endpage(); ?>

Re: V2 Staff Applications! what's not updating? be more specific

Re: Education cron thx, it worked perfectly

Re: How do I?????[v2] there are 2 ways, you can rename your new image title.jpg and upload it to your server or you can open your header.php and find print <<<OUT [img=title.jpg]   you than need to change the title.jpg to whatever you want to call it

My education days keep going into negative days, i've tried to fix it but i'm not sure how to fix it   <?php include "REMOVED"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } define("MONO_ON", 1); require "REMOVED"; $db=new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c=$db->connection_id; $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0"); $q=$db->query("SELECT * FROM users WHERE cdays < 0 AND course > 0"); while($r=$db->fetch_row($q)) { $cd=$db->query("SELECT * FROM courses WHERE crID={$r['course']}"); $coud=$db->fetch_row($cd); $userid=$r['userid']; $db->query("INSERT INTO coursesdone VALUES({$r['userid']},{$r['course']})"); $upd=""; $ev=""; if($coud['crSTR'] > 0) { $upd.=",us.strength=us.strength+{$coud['crSTR']}"; $ev.=", {$coud['crSTR']} strength"; } if($coud['crGUARD'] > 0) { $upd.=",us.guard=us.guard+{$coud['crGUARD']}"; $ev.=", {$coud['crGUARD']} guard"; } if($coud['crLABOUR'] > 0) { $upd.=",us.labour=us.labour+{$coud['crLABOUR']}"; $ev.=", {$coud['crLABOUR']} labour"; } if($coud['crAGIL'] > 0) { $upd.=",us.agility=us.agility+{$coud['crAGIL']}"; $ev.=", {$coud['crAGIL']} agility"; } if($coud['crIQ'] > 0) { $upd.=",us.IQ=us.IQ+{$coud['crIQ']}"; $ev.=", {$coud['crIQ']} IQ"; } $ev=substr($ev,1); if ($upd) { $db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid SET us.userid=us.userid $upd WHERE u.userid=$userid"); } $db->query("INSERT INTO events VALUES('',$userid,unix_timestamp(),0,'Congratulations, you completed the {$coud['crNAME']} and gained $ev!')"); } $db->query("UPDATE users SET course=0 WHERE cdays=0"); $db->disconnect(); ?>

Re: [v2]Casino[v2] I have gone through and tested and debugged casino.php   <?php include 'globals.php'; print "<center>"; if($ir['jail'] or $ir['hospital']) { echo("This page cannot be accessed while in jail or hospital."); $h->endpage(); exit; } print "<h3>Casino</h3>"; switch($_GET['action']) { case 'getmore': deposit(); break; case 'get100': get100(); break; case 'get200': get200(); break; case 'get500': get500(); break; case 'getaccount': getaccount(); break; case 'pacman': pacman(); break; default : index(); break; } function index() { global $db, $ir,$c,$userid,$h; $tresder1=(int) rand(100,999); $tresder2=(int) rand(100,999); if($ir['credits'] <= 0) { print "[url='casino.php?action=getaccount']Get a credits Account Here![/url] for \$5,000"; } else { print "<table width='75%' cellspacing='1' class='table'> <tr><td align='center' background='bullet.gif'>[img=casino1.png]</td></tr> <tr> <th><font color=white>credits</font></th></tr> <tr><td align='center' background='bullet.gif'>[b]<font color=white>You currently have {$ir['credits']} credits.[/b] [url='casino.php?action=get100']<font color=gold>Get 100 credits for \$200[/url]</font> [url='casino.php?action=get200']<font color=gold>Get 200 credits for \$400[/url]</font> [url='casino.php?action=get500']<font color=gold>Get 500 credits for \$1,000[/url]</font> <font color=white> You can spend these on Casino games and will win more credits if you win the game!</td></tr> <tr><th><font color=white>Casino Games</font></th></tr> <tr><td background='bullet.gif'> <table> <tr><td width='50%' background='bullet.gif'>[url='lucky.php']<font color=white>Lucky Boxes[/url]</td> <td width='50%' background='bullet.gif'>[url='poker.php']<font color=white>Poker[/url]</td></tr> <tr><td width='50%' background='bullet.gif'>[url='slots.php?tresde=$tresder1']<font color=white>Slots Matchine[/url]</td> <td width='50%' background='bullet.gif'><a href='casino.php?action=pacman'><font color=white>Pac-Man</td></tr> <tr><td width='50%' background='bullet.gif'>[url='roulette.php?tresde=$tresder2']<font color=white>Roulette[/url]</td> <td width='50%' background='bullet.gif'>[url='carnival.php']<font color=white>Go to the Carnival[/url]</font></td></tr> </table></td></tr></table>"; } } function getaccount() { if($ir['credits'] == 0) { global $db, $ir,$c,$userid,$h; $db->query("UPDATE users SET money=money-5000,credits=credits+100 WHERE userid=$userid"); print "[b]Congratulations! You have just brought a credits account for \$5,000 [url='casino.php']Click here to start using your new Casino Account[/url]"; } else if($ir['money'] <= 4999 ) { print "You do not have enough money! [url='casino.php']Go back to the Casino![/url]"; } } function get100() { global $db,$ir,$c,$userid,$h; if($ir['money'] >= 200) { $db->query("UPDATE users SET money=money-200,credits=credits+100 WHERE userid=$userid"); print " You have just bought 100 credits for \$200! You now have [b]{$ir['credits']}[/b] credits."; } else if($ir['money'] <= 199) { print "You do not have enough money! [url='casino.php']Go back to the Casino![/url]"; } } function get200() { global $db,$ir,$c,$userid,$h; if($ir['money'] >= 400) { $db->query("UPDATE users SET money=money-400,credits=credits+200 WHERE userid=$userid"); print " You have just bought 200 credits for \$400! You now have [b]{$ir['credits']}[/b] credits."; } else if($ir['money'] <= 399) { print "You do not have enough money! [url='casino.php']Go back to the Casino![/url]"; } } function get500() { global $db,$ir,$c,$userid,$h; if($ir['money'] >= 1000) { global $db, $ir,$c,$userid,$h; $db->query("UPDATE users SET money=money-1000,credits=credits+500 WHERE userid=$userid"); print " You have just bought 500 credits for \$1,000! You now have [b]{$ir['credits']}[/b] credits."; } else if($ir['money'] <= 999) { print "You do not have enough money! [url='casino.php']Go back to the Casino![/url]"; } } function pacman() { print "[b] You paid 5 credits and get to play Pac-Man as many times as you like![/b] "; global $db, $ir,$c,$userid,$h; print"<OBJECT classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0' width='470' height='470'> <PARAM name=quality value=high> <PARAM name='SRC' value='http://www.zemnetmedia.com/games/pacman/pacmangame.swf'> <EMBED src='http://www.zemnetmedia.com/games/pacman/pacmangame.swf' width='470' height='470' quality=high pluginspage='http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash' type='application/x-shockwave-flash'> </EMBED></object> [b]These are the shortcut keys: <font color=red>M</font> - Turn music On/Off <font color=red>P</font> - Pause/ Unpause the game <font color=red>Q</font> - Quit the Game <font color=red>L</font> - Low quality on/ off"; } $h->endpage(); ?>

Re: How to Make you rmarried Stats Display in viewuser.php you need to use $r not $ir

Re: View Surrenders its displaying the drop down and that's it,

Re: View Surrenders the page works, it's just not displaying any surrenders and it's not exiting at the end of the function

My view surrenders is not working and i'm not sure why, everything looks fine to me   function gang_staff_viewsurrenders() { global $db,$ir,$c,$userid,$gangdata; if(!isset($_POST['subm'])) { print "<form action='yourgang.php?action=staff&act2=viewsurrenders' method='post'> Choose who to accept the surrender from. <input type='hidden' name='subm' value='submit' /> Gang: <select name='sur' type='dropdown' style='background-color: #000000; color:#FFFFFF;'>"; $wq=$db->query("SELECT s.*,w.* FROM surrenders s LEFT JOIN gangwars w ON s.surWAR=w.warID WHERE surTO={$ir['gang']}"); while($r=$db->fetch_row($wq)) { if($gangdata['gangID'] == $r['warDECLARER']) { $w="You";$f="warDECLARED"; } else { $w="Them";$f="warDECLARER"; } $ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]); $them=$db->fetch_row($ggq); print "<option value='{$r['surID']}'>War vs. {$them['gangNAME']} (Msg: {$r['surMSG']})</option>"; } print "</select> <input type='submit' value='Accept Surrender' style='background-color: #000000; color:#FFFFFF;' /></form>"; } 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); if($gangdata['gangID'] == $r['warDECLARER']) { $w="You";$f="warDECLARED"; } else { $w="Them";$f="warDECLARER"; } $db->query("DELETE FROM surrenders WHERE surID={$_POST['sur']}"); $db->query("DELETE FROM gangwars WHERE warID={$_POST['war']}"); $ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]); $them=$db->fetch_row($ggq); $event=str_replace("'","''","[url='gangs.php?action=view&ID={$ir[']{$gangdata['gangNAME']}[/url] have accepted the surrender from [url='gangs.php?action=view&ID={$them[']{$them['gangNAME']}[/url], the war is over!"); $db->query("INSERT INTO gangevents VALUES('',{$ir['gang']},unix_timestamp(),'$event') , ('',".$r[$f].",unix_timestamp(),'$event')"); print "You have accepted surrender, the war is over."; } }

Re: Captca code mccodeV2 post your macro1.php

Re: Mccodes V2 Layout help this should work for you   if($ir['jail']) { echo "[img=images/title.jpg] "; } else if($ir['hospital']) { echo "[img=images/title.jpg] "; } else { echo "[img=images/title.jpg] "; }

Re: if jail/if hosp this should work for you   if($ir['jail']) { echo "[img=images/title.jpg] "; } else if($ir['hospital']) { echo "[img=images/title.jpg] "; } else { echo "[img=images/title.jpg] "; }

Re: [mccode]streetsv1[mccode] this was mad by Vorlen/on_fire and can be found here http://www.mccodes.com/freebie_streets.php it's very easy to convert for v2 just read this post http://criminalexistence.com/ceforums/http://makewebgames.io/phpBB3/viewforum.php?f=2.0

Re: strang ' marks appearing thanks ragnar

Re: strang ' marks appearing i have the same problem, just edit them in your DB, unless someone else post's a fix

Re: Attacking bug here's what i use it might help you   else if($odata['fedjail']) { print "This user is in fed jail and can not be attacked. [url='index.php']> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; }

Re: [V1] Chests [V1] for the SQL's you need to add the delimiter, try theses ALTER TABLE `users` ADD `keys` INT( 11 ) NOT NULL DEFAULT '100'; ALTER TABLE `users` ADD `chestsincome` INT( 11 ) NOT NULL DEFAULT '0';

Re: Question just put this at the top of any page you don't want a user to access while they are in the hosp or jail   if($ir['jail'] or $ir['hospital']) { echo("This page cannot be accessed while in jail or hospital."); $h->endpage(); exit; }