bladewolf2010

the sql's dont work:( or am i doing it wrong? [mysql]#1064 - 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 '`helmet` int(11) NOT NULL default '0', `breastplate` int(11) NOT NULL default '' at line 3[/mysql] Thats the error with ALTER TABLE `items` ADD `boots` int(11) NOT NULL default '0', `helmet` int(11) NOT NULL default '0', `breastplate` int(11) NOT NULL default '0', `leggings` int(11) NOT NULL default '0', `gloves` int(11) NOT NULL default '0',   with [mysql]#1064 - 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 '`equip_boots` int(11) NOT NULL default '0', `equip_breastplate` int(11) NOT NUL' at line 3[/mysql] That's error with it ALTER TABLE `users` ADD `equip_helmet` int(11) NOT NULL default '0', `equip_boots` int(11) NOT NULL default '0', `equip_breastplate` int(11) NOT NULL default '0', `equip_leggings` int(11) NOT NULL default '0', `equip_gloves` int(11) NOT NULL default '0',

Whats your script?

<?php $atkpage=1; include "globals.php"; if ($_GET[buying]) { $_GET[buying]=mysql_safe($_GET[buying]); $_GET[iD]=mysql_safe($_GET[iD]); $qry="select * from userflags where attacking={$_GET[iD]}"; $busy=$db->query($qry); $bsy2=($db->fetch_row($busy)); if ($_GET[buying]!=$bsy2[time]) { die ("<font color=royalblue>Error in purchase, Are you using real money ??"); } if($ir[money]<=15000) { die ("<font color=royalblue>Insufficient money in your pocket to purchase fight"); } mysql_query("update users set money=money-15000 where userid=$userid"); mysql_query("update users set level=level-1 where userid=$bsy2[userid] and level>0"); mysql_query("delete from userflags where attacking={$_GET[iD]}"); Print " <font color=royalblue> You have paid \$15,000 and purchased rights to fight this user. The other attacker has lost a level for holding the fight open."; event_add($bsy2['userid'],"You have been deducted one level for holding a fight open until it has gone stale. Soemone purchased the fight"); $h->endpage(); exit; } $qry="select * from userflags where userid=$userid"; $att=$db->query($qry); $atta=0; if (mysql_num_rows($att)!=0) { $at2=($db->fetch_row($att)); Print "Unfinished attack on userid {$at2['attacking']}, Switching attack to this player. "; $_GET['ID']=$at2['attacking']; $atta=1; } else { $qry="select * from userflags where attacking={$_GET[iD]}"; $busy=$db->query($qry); if (mysql_num_rows($busy)!=0) { $bsy2=($db->fetch_row($busy)); Print " Player $_GET[iD] is busy "; $tim=(time()-901); if ($bsy2['time']<=$tim) { Print "<a href=attack.php?buying=$bsy2[time]&ID=$_GET[iD]>Buy the fight for \$15,000</a>"; } $h->endpage(); exit; } 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 ($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; $_GET['ID']=mysql_safe($_GET['ID']); $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=($ir['gender']=="Male") ? "his" : "her"; if($ir['attacking'] && $ir['attacking'] != $_GET['ID']) { print "Bad, bad, bad girl. [url='index.php']Back[/url]"; $_SESSION['attacklost']=0; $h->endpage(); exit; } if($ir['hp'] == 0 and $_SESSION['attacking']) { mysql_query("UPDATE users SET hospital=300,hospreason='Tried to run from {$odata['username']}' where userid=$userid", $c); print "<center>No Refreshing! [url='index.php']> Back [/url]</center>"; $h->endpage(); $_SESSION['attacking']=0; exit; } //if($odata['userpass'] == 'd41d8cd98f00b204e9800998ecf8427e') //{ // print "This is a bot, please attack using the Ally Way. // [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($odata['hp'] == 1) { print "<font color=royalblue>This player is unconscious. [url='index.php']><font color=royalblue> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } if($odata['fedjail'] == 1) { print "<font color=royalblue>This player is in fedjail and cannot be attacked. [url='index.php']> <font color=royalblue>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 "<font color=royalblue>This player is in hospital. [url='index.php']><font color=royalblue> Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } else if($odata['court']) { print "<font color=red>You cannot attack people that are in court!</font> [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 "<font color=royalblue>While in hospital you can't attack. [url='hospital.php']> <font color=royalblue>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 "<font color=royalblue>This player is in jail. [url='index.php']> <font color=royalblue>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 "<font color=royalblue>While in jail you can't attack. [url='jail.php']> <font color=royalblue>Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } else if($odata['travelling']) { print "<font color=royalblue>That player is travelling. [url='index.php']> <font color=royalblue>Back[/url]"; $h->endpage(); $_SESSION['attacking']=0; $ir['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; } print "<table width=100%><tr><td colspan=2 align=center>"; 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"); if ($_GET['nextstep'] && $atta==0) { $db->query("insert into userflags (userid,attacking,time) values ('$userid','$odata[userid]',unix_timestamp())"); } $_GET['wepid'] = (int) $_GET['wepid']; $_GET['nextstep'] = (int) $_GET['nextstep']; //damage if($_GET['wepid'] != $ir['equip_primary'] && $_GET['wepid'] != $ir['equip_secondary']) { print "<font color=royalblue>Stop trying to abuse a game bug. You can lose all your EXP for that. [url='index.php']> <font color=royalblue>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'><font color=royalblue><input type='submit' value='Mug Them' /></form> <form action='attackbeat.php?ID={$_GET['ID']}' method='post'><font color=royalblue><input type='submit' value='Hospitalize Them' /></form> <form action='attacktake.php?ID={$_GET['ID']}' method='post'><font color=royalblue><input type='submit' value='Leave Them' /></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=red>{$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 "<font color=royalblue>You can only attack those who have health </table>"; $h->endpage(); exit; } else if ($ir['gang'] == $odata['gang'] && $ir['gang'] > 0) { print "<font color=royalblue>You are in the same gang as {$odata['username']}! What are you smoking today dude! </table>"; $h->endpage(); exit; }else if ($ir['team'] == $odata['team'] && $ir['team']) { print "<font color=royalblue>You are in the same team as {$odata['username']}! What are you doing man!"; exit; } else if ($youdata['energy'] < $youdata['maxenergy']/2) { print "<font color=royalblue>You can only attack someone when you have 50% energy </table>"; $h->endpage(); exit; } else if ($youdata['location'] != $odata['location']) { print "<font color=royalblue>You can only attack someone in the same location! </table>"; $h->endpage(); exit; } else { } print "</td></tr>"; if($youdata['hp'] <= 0 || $odata['hp'] <= 0) { print "</table>"; } 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']; $mw=$db->query("SELECT i.* FROM items i WHERE i.itmid IN({$ir['equip_primary']}, {$ir['equip_secondary']})"); print "<tr><td colspan=2 align='center'>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='attack.php?nextstep=$ns&ID={$_GET[']{$r['itmname']}[/url] "; } } else { print "<font color=royalblue>You have nothing to fight with."; } print "</table>"; print "<table width='50%' align='center'><tr><td align=right><font color=royalblue>Your Health: </td><td><img src=greenbar.png width={$vars['hpperc']} height=10><img src=redbar.png width={$vars['hpopp']} height=10></td><tr><td align=right>Opponents Health: </td><td><img src=greenbar.png width={$vars2['hpperc']} height=10><img src=redbar.png width={$vars2['hpopp']} height=10></td></tr></table>"; } $h->endpage(); ?>

if ($ir['userid']!=1) { if ($ir['userid']!=2) { if ($ir['userid']!=14) { session_destroy(); die ("Shove Off! Only "names" May view this page! So get the hell out and QUIT your snooping!!!"); }}} $mc=$ir['new_mail']; if($ir['owner'] == 2)   If you wanna add another to it then add if ($ir['userid']!=14) {   and under session destroy add another }

Yeah me and KC are :)

Stealing my credit? you make the script i made it so onlt the owner,co-owner, and co-co-owner can access it

You mean I did >.< lol :)

http://www.justhost.com/web-hosting Been using these for 2years now no down time and cheaper :)

OK, here is one formula:   ((WILL*3.5)/3)+(LEVEL/3)   Now, this formula produces a HIGH chance of success. At will 100 and level 1, this comes out with: 117. This is a 117% chance of succeeding. Now, to make it harder, decrease the number the will is multiplied (3.5), increase the division number (3,3). A low success formula would be:   ((WILL*1.2)/10)+(LEVEL/8)   This produces 12.125% chance of succeeding. (Level and will the same as before). To make the crime easier, apply the same change, but vice versa. Therefore the multiplication is increase and division numbers decreased. Easy crime:   ((WILL*15)/2)+(LEVEL/2)   This produces a 750.5% chance of success. Hope this helps ya. :)

Oh okAy thank you :) sorry to bother you

staff_cities.php <?php include "sglobals.php"; if($ir['user_level'] > 2) { die("403"); } //This contains city stuffs switch($_GET['action']) { case "addcity": addcity(); break; case "editcity": editcity(); break; case "delcity": delcity(); break; default: print "Error: This script requires an action."; break; } function addcity() { global $db, $ir, $c, $h, $userid; $minlevel=abs((int) $_POST['minlevel']); $name=$_POST['name']; $desc=$_POST['desc']; if($minlevel and $desc and $name) { $q=$db->query("SELECT * FROM cities WHERE cityname='{$name}'"); if($db->num_rows($q)) { print "Sorry, you cannot have two cities with the same name."; $h->endpage(); exit; } $db->query("INSERT INTO cities VALUES('', '$name', '$desc', '$minlevel')"); print "City {$name} added to the game."; stafflog_add("Created City $name"); } else { print "<h3>Add City</h3><hr /> <form action='staff_cities.php?action=addcity' method='post'> Name: <input type='text' name='name' /> Description: <input type='text' name='desc' /> Minimum Level: <input type='text' name='minlevel' /> <input type='submit' value='Add City' /></form>"; } } function editcity() { global $db, $ir, $c, $h, $userid; switch($_POST['step']) { case "2": $minlevel=abs((int) $_POST['minlevel']); $name=$_POST['name']; $desc=$_POST['desc']; $q=$db->query("SELECT * FROM cities WHERE cityname='{$name}' AND cityid!={$_POST['id']}"); if($db->num_rows($q)) { print "Sorry, you cannot have two cities with the same name."; $h->endpage(); exit; } $name=$_POST['name']; $q=$db->query("SELECT * FROM cities WHERE cityid={$_POST['id']}"); $old=$db->fetch_row($q); $db->query("UPDATE cities SET cityminlevel=$minlevel, citydesc='$desc', cityname='$name' WHERE cityid={$_POST['id']}"); print "City $name was edited successfully."; stafflog_add("Edited city $name"); break; case "1": $q=$db->query("SELECT * FROM cities WHERE cityid={$_POST['city']}"); $old=$db->fetch_row($q); print "<h3>Editing a City</h3><hr /> <form action='staff_cities.php?action=editcity' method='post'> <input type='hidden' name='step' value='2' /> <input type='hidden' name='id' value='{$_POST['city']}' /> Name: <input type='text' name='name' value='{$old['cityname']}' /> Description: <input type='text' name='desc' value='{$old['citydesc']}' /> Minimum Level: <input type='text' name='minlevel' value='{$old['cityminlevel']}' /> <input type='submit' value='Edit City' /></form>"; break; default: print "<h3>Editing a City</h3><hr /> <form action='staff_cities.php?action=editcity' method='post'> <input type='hidden' name='step' value='1' /> City: ".location_dropdown($c, "city")." <input type='submit' value='Edit City' /></form>"; break; } } function delcity() { global $db,$ir,$c,$h,$userid; if($_POST['city']) { $q=$db->query("SELECT * FROM cities WHERE cityid={$_POST['city']}"); $old=$db->fetch_row($q); if($old['cityid']==1) { die("This city cannot be deleted."); } $db->query("UPDATE users SET location=1 WHERE location={$old['cityid']}"); $db->query("UPDATE shops SET shopLOCATION=1 WHERE shopLOCATION={$old['cityid']}"); $db->query("DELETE FROM cities WHERE cityid={$old['cityid']}"); print "City {$old['cityname']} deleted."; stafflog_add("Deleted city {$old['cityname']}"); } else { print "<h3>Delete City</h3><hr /> Deleting a city is permanent - be sure. Any users and shops that are currently in the city you delete will be moved to the default city (ID 1).<form action='staff_cities.php?action=delcity' method='post'> City: ".location_dropdown($c, "city")." <input type='submit' value='Delete City' /></form>"; } } function report_clear() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] > 3) { die("403"); } $_GET['ID'] = abs((int) $_GET['ID']); $_GET['ID']=mysql_safe($_GET['ID']); stafflog_add("Cleared player report ID {$_GET['ID']}"); $db->query("DELETE FROM preports WHERE prID={$_GET['ID']}"); print "Report cleared and deleted! [url='staff_users.php?action=reportsview']> Back[/url]"; } $h->endpage(); ?>   monorail.php <?php include "globals.php"; $ticketprice = 1000; // Set this to the price, you would like the players to pay, to travel between cities echo <<<EOFS1 <style type="text/css"> .success { color: green; } .fail { color: red; } table { text-align: center; } </style> EOFS1; $_GET['to'] = (!empty($_GET['to']) && ctype_digit($_GET['to']) && isset($_GET['to']) ? abs(@intval($_GET['to'])) : FALSE); if(!$_GET['to']) { echo" <h1> Welcome to the Monorail Station. </h1>"; echo "<h3> It costs \$$ticketprice for a ticket </h3>"; echo "<h3> Where would you like to travel today?</h3>"; $get_cities = sprintf("SELECT * FROM `cities` WHERE `cityid` != %d AND `cityminlevel` <= %d", $ir['location'], $ir['level']); $q = mysql_query($get_cities); if($q === FALSE) { echo "".mysql_error().""; } echo <<<EOF1 <table style="width:75%;border-spacing:1"> <tr> <th> Name </th> <th> Description </th> <th> Min Level </th> <th> </th> </tr> EOF1; while($r = $db->fetch_row($q)) { echo <<<EOF2 <tr> <td> {$r['cityname']} </td> <td> {$r['citydesc']} </td> <td> {$r['cityminlevel']} </td> <td> [url='monorail.php?to={$r[']Go[/url] </td> </tr> EOF2; } echo "</table>"; } else { if($ir['money'] < $ticketprice) { echo "<h3 class='fail'> You don't have enough money </h3>"; } else if($_GET['to'] != $_GET['to']) { echo "<h3 class='fail'> Invalid city ID </h3>"; } else { $select_cities = sprintf("SELECT * FROM `cities` WHERE `cityid` = %d AND `cityminlevel` <= %d", $_GET['to'], $ir['level']); $q = mysql_query($select_cities); if($q === FALSE) { echo "".mysql_error().""; } if(!$db->num_rows($q)) { echo "<h3 class='fail'> Error, this city either does not exist or you cannot go there </h3>"; } else { $update_query = sprintf("UPDATE `users` SET `money` = `money` - %d, `location` = %d WHERE `userid` = %u", $ticketprice, $_GET['to'], abs(@intval($userid))); $foo = mysql_query($update_query); if($foo === FALSE) { echo "".mysql_error().""; } $r = $db->fetch_row($q); printf("<h3 class='success'> Congratulations, you paid \$%d and travelled to %s on the monorail! </h3>", $ticketprice, $r['cityname']); } } } $h->endpage(); ?>   SQL [mysql]CREATE TABLE `cities` ( `cityid` int(11) NOT NULL auto_increment, `cityname` varchar(255) NOT NULL default '', `citydesc` longtext NOT NULL, `cityminlevel` int(11) NOT NULL default '0', PRIMARY KEY (`cityid`) ) ENGINE=MyISAM ; INSERT INTO `cities` VALUES('1', 'Default City', 'A standard city added to start you off', 1);[/mysql] Thats the files :/

It still don't show cities i create:(

Don't I need proof of purchase yada yada yada?

My monorail won't show the citys i create :( any reAson why?

Its crappy work on my part:( I need someone to run it and fix for me haha:(

cityadmin.php <?php include "globals.php"; print "<h3>Your City Admin Panel</h3> "; $q=mysql_query("SELECT * FROM `cities` WHERE `cityowner` = '$userid'"); if(mysql_num_rows($q)== 0) { print "You don't own any cities so you dont need to be here."; exit(); } $r=mysql_fetch_array($q); if(!$_GET['action']) { $popul=mysql_query("SELECT COUNT(*) AS pop FROM users WHERE location=$r[cityid]"); $populr=mysql_fetch_array($popul); print "<table width=90% border=1> <tr><th>City Population</th><td>".number_format($populr[pop])."</td></tr> <tr><th>City Running Length</th><td>$r[citydays] days</td></tr> <tr><th>City Friends</th><td>".number_format(mysql_num_rows(mysql_query("SELECT * FROM city_friends WHERE friend_GIVE=$r[cityid] OR friend_TAKE=$r[cityid] AND friend_ACCEPT=1")))."</td></tr> </table> [url='cityadmin.php?action=modify']Modify City[/url] [url='cityadmin.php?action=requests']View Friend Requests[/url] [url='cityadmin.php?action=friends']Manage Friends[/url] [url='cityadmin.php?action=viewban']View Banished Users[/url] [url='cityadmin.php?action=close']Close City[/url] "; } else if($_GET['action'] == "viewban") { if($_GET['unban']) { mysql_query("DELETE FROM `banished_users` WHERE `ban_CITY` = '$r[cityid]' AND `ban_USER` = '$_GET[unban]'"); if(mysql_affected_rows($c)> 0) { event_add($_GET['unban'],"You have been unbanished from $r[cityname] city by the city owner.",$c); } print "User Unbanished! [url='cityadmin.php']Back[/url] "; } else { print "[b]Viewing Banished Users[/b] <table width=80% border=1><tr><th>Username</th><th>Unban</th></tr>"; $banq=mysql_query("SELECT * FROM `banished_users` WHERE `ban_CITY` = '$r[cityid]'"); if(mysql_num_rows($banq)== 0) { print "<tr><td colspan=2>No users have been banished</td></tr>"; } while($banr=mysql_fetch_array($banq)) { $uqq=mysql_query("SELECT * FROM `users` WHERE `userid` = '$banr[ban_USER]'"); $urr=mysql_fetch_array($uqq); print "<tr><td>[url='viewuser.php?u=$banr[ban_USER]']$urr[username][/url]</td><td>[url='cityadmin.php?action=viewban&unban=$urr[userid]']Unban[/url]</td></tr>"; } print "</table>"; } } else if($_GET['action'] == "banish") { if($_GET['ID']) { $confirm_right_u=mysql_query("SELECT * FROM users WHERE userid=$_GET[iD]"); if(mysql_num_rowS($confirm_right_u)== 0) { die("There is no user existing with that ID!"); } $if_banishedq=mysql_query("SELECT * FROM `banished_users` WHERE `ban_CITY` = '$r[cityid] AND `ban_USER` = '$_GET[iD]'"); if(mysql_num_rows($if_banishedq)) { die("This user has already been banished!"); } mysql_query("INSERT INTO `banished_users` (`ban_ID`, `ban_CITY`, `ban_USER`) VALUES ('NULL', '$r[cityid]', '$_GET[iD]');"); print "You have successfully banished the user : $_GET[iD] [url='javascript:history.back();']Back[/url] "; } else { print "You forgot to collect the ID data!"; } } else if($_GET['action'] == "kick") { if($_GET['ID']) { $confirm_right_u=mysql_query("SELECT * FROM users WHERE userid=$_GET[iD]"); if(mysql_num_rowS($confirm_right_u)== 0) { die("There is no user existing with that ID!"); } $confirm_right_r=mysql_fetch_Array($confirm_right_u); if($confirm_right_r['location'] != $r['cityid']) { die("This user ain't even in your city dumbass!, Goto hell for trying to abuse GF's codes! [url='index.php']Home[/url] "); } $q=mysql_query("UPDATE users SET location=1 WHERE location=$r[cityid] AND userid=$_GET[iD]"); if(mysql_affected_rows($c) > 0) { event_add($_GET['ID'],"You was kicked out of the current city by the owner.",$c); } print "User kicked out! [url='javascript:history.back();']Back[/url] "; } else { print "You forgot to collect the ID data!"; } } else if($_GET['action'] == "close") { if($_GET['yes']) { mysql_query("DELETE FROM `cities` WHERE `cityid` = '$r[cityid]'"); mysql_query("UPDATE `users` SET `location` = '1' WHERE `location` = '$r[cityid]'"); $User=0; while($r=mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `location` = '$r[id]'"))) { event_add($r['userid'],"You have been kicked out of the city because it has closed down ",$c); $User++; } print "City has successfully closed! $User User's have been kicked out [url='index.php']Home[/url] "; } else { print "[b]Close City[/b] Are you 101% sure you want to close your city All your current visitors will be kicked out and sent back to primary city And you cannot undo this, This is permanent! [url='cityadmin.php?action=close&yes=1']Yes, Delete It Now![/url] [url='cityadmin.php']No, keep it[/url] "; } } else if($_GET['action'] == "friends") { if($_GET['delete']) { mysql_query("DELETE FROM `city_friends` WHERE `friend_ID` = '$_GET[delete]' AND (`friend_GIVE` = '$r[cityid]' OR `friend_TAKE` = '$r[cityid]')"); print "You have deleted your friend! [url='cityadmin.php']Back[/url] "; } else { $friq=mysql_query("SELECT * FROM `city_friends` WHERE `friend_TAKE` = '$r[cityid]' OR `friend_GIVE` = '$r[cityid]'"); print "[b]Manage Friends[/b] <table width=90% border=1><tr><th>Owner</th><th>City Name</th><th>Delete</th></tr>"; if(mysql_num_rows($friq) == 0) { print "<tr><td colspan=3>You have no current city friends</td></tr>"; } while($rq=mysql_fetch_array($friq)) { $q3=mysql_query("SELECT * FROM `cities` WHERE `cityid` = '$rq[friend_GIVE]'"); $rr2=mysql_fetch_array($q3); $getuname=mysql_query("SELECT * FROM `users` WHERE `userid` = '$rr2[owner]'"); $getusername=mysql_fetch_array($getuname); print "<tr><td>[url='viewuser.php?u=$getusername[userid]']$getusername[username][/url] [$getusername[username]]</td><td>$rr2[cityname]</td><td>[url='cityadmin.php?action=friends&delete=$rq[friend_ID]']Delete[/url]</td></tr>"; } print "</table>"; } } else if($_GET['action'] == "requests") { if($_GET['ID']) { $confq=mysql_query("SELECT * FROM `city_friends` WHERE `friend_ID` = '$_GET[iD]' AND (`friend_GIVE` = '$r[cityid]' OR `friend_TAKE` = '$r[cityid]')"); if(mysql_num_rows($confq) == 0) { print "I'm sorry you selected a invalid ID! [url='javascript:history.back();']Back[/url] "; exit(); } if($_GET['do'] == "accept") { mysql_query("UPDATE `city_friends` SET `friend_ACCEPT` = '1' WHERE `friend_ID` = '$_GET[iD]' AND (`friend_GIVE` = '$r[cityid]' OR `friend_TAKE` = '$r[cityid]')"); print "You have accepted the application! [url='javascript:history.back();']Back[/url] "; } else { mysql_query("DELETE FROM `city_friends` WHERE `friend_ID` = '$_GET[iD]'"); print "You have declined the application! [url='javascript:history.back();']Back[/url] "; } } else { $q2=mysql_query("SELECT * FROM `city_friends` WHERE `friend_TAKE` = '$r[cityid]' AND `friend_ACCEPT` = '1'"); print "[b]Friend Requests[/b] <table width=80% border=1><tr><th>From</th><th>City Name</th><th>Population</th><th>Reason</th><th>Action</th></tr>"; while($rr=mysql_fetch_array($q2)) { $q3=mysql_query("SELECT * FROM `cities` WHERE `cityid` = '$rr[friend_GIVE]'"); $rr2=mysql_fetch_array($q3); $getuname=mysql_query("SELECT * FROM `users` WHERE `userid` = '$rr2[cityowner]'"); $getusername=mysql_fetch_array($getuname); $usercntq=mysql_query("SELECT COUNT(*) AS countd FROM users WHERE location='$rr2[cityid]'"); $usercnt=mysql_fetch_array($usercntq); print "<tr><td>[url='viewuser.php?u=$getusername[userid]']$getusername[username][/url] [$getusername[username]]</td><td>$rr2[cityname]</td><td>".number_format($usercnt[countd]*5)."</td><td>$rr[friend_MSG]</td><td> [url='cityadmin.php?action=requests&ID=$rr[friend_ID]&do=accept']Accept[/url] [url='cityadmin.php?action=requests&ID=$rr[friend_ID]&do=decline']Decline[/url] </td></tr>"; } print "</table>"; } } else if($_GET['action'] == "modify") { if($_POST['cityname'] and $_POST['citydesc'] and $_POST['cityprice']) { if(!$_POST['cityminlevelon']) {$cityon=0; } else { $cityon=1; } if(!$_POST['citytax']) { $citytax=0; } else { $citytax=1; } mysql_query("UPDATE `cities` SET `cityname` = '$_POST[cityname]', `citydesc` = '$_POST[citydesc]', `cityminlevelon` = '$cityon', `cityminlevel` = '$_POST[cityminlevel]', `cityprice` = '$_POST[cityprice]', `citytax` = '$citytax', `citytaxprice` = '$_POST[citytaxprice]' WHERE `cityowner` = '$ir[userid]'"); print "You have successfully modified your city! [url='cityadmin.php']Back[/url] "; } else { print "[b]Modify Your City[/b] <form action='cityadmin.php?action=modify' method='post'> <table width=90% border=1> <tr><th>City Name</th><td><input type='text' name='cityname' value='$r[cityname]'></td></tr> <tr><th>City Description</th><td><textarea name='citydesc' cols=30 rows=8>$r[citydesc]</textarea></td></tr> <tr><th>Activate City Min Level Required</th><td><select name='cityminlevelon'> <option value='1'>Yes</option> <option value='0'"; if($r['cityminlevelon'] == 1) { print " selected"; } print ">No</option> </select></td></tr> <tr><th>City Min Level Required [size="1"]Only if above is Yes[/size]</th><td><input type='text' name='cityminlevel' value='$r[cityminlevel]'></td></tr> <tr><th>City Price [size="1"]Price to enter the city[/size]</th><td><input type='text' name='cityprice' value='$r[cityprice]'></td></tr> <tr><th>Activate City Tax</th><td><select name='citytax'> <option value='1'>Yes</option> <option value='0'"; if($r['citytax'] == 1) { print " selected"; } print ">No</option> </select></td></tr> <tr><th>City Tax [size="1"]Only if above is Yes[/size]</th><td><input type='text' name='citytaxprice' value='$r[citytaxprice]'></td></tr> <tr><td colspan=2><input type=submit value='Modify City'></td></tr> </table> </form>"; } } $h->endpage(); ?>   createcity.php <?php include "globals.php"; print "<h3>Create a City</h3> "; $back=" [url='javascript:history.back();']Back[/url] "; $q=mysql_query("SELECT * FROM `cities` WHERE `cityowner` = '$userid'"); if($ir['donatordays'] == 0) { print "You must be a donator to run a city "; print $back; } else if($ir['money'] < 2500000) { print "You do not have enough money to buy a city! You need \$2,500,000 before you can purchase one! "; print $back; } else if(mysql_num_rows($q)) { print "You already own a city, You cannot own two cities."; print $back; } else { //-- cityname,citydesc if($_POST['cityname'] and $_POST['citydesc']) { $cityname=str_replace(array("<",">"),array("",""), $_POST['cityname']); $citydesc=str_replace(array("<",">"),array("",""), $_POST['citydesc']); mysql_query("INSERT INTO `cities` (`cityid`, `cityname`, `citydesc`, `cityminlevelon`, `cityminlevel`, `cityowneron`, `cityowner`, `citymost`, `cityprice`, `citydays`, `citytax`, `citytaxprice`) VALUES ('NULL', '$cityname', '$citydesc', '0', '0', '1', '$userid', '0', '100', '0', '0', '0');"); print "You have successfully created your city [url='cityadmin.php']Your City Admin Panel[/url] "; } else { print "<form action='createcity.php' method='post'> <table width=90% border=1> <tr><th>City Name</th><td><input type='text' name='cityname' value=''></td></tr> <tr><th>City Description</th><td><textarea name='citydesc' cols=30 rows=8></textarea></td></tr> <tr><td colspan=2><input type='submit' value='Create City'></td></tr> </table> </form>"; } } $h->endpage(); ?>   cron_day.php <?php include "config.php"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } define("MONO_ON", 1); require "class/class_db_{$_CONFIG['driver']}.php"; $db=new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c=$db->connection_id; $db->query("UPDATE fedjail set fed_days=fed_days-1"); $q=$db->query("SELECT * FROM fedjail WHERE fed_days=0"); $ids=array(); while($r=$db->fetch_row($q)) { $ids[]=$r['fed_userid']; } if(count($ids) > 0) { $db->query("UPDATE users SET fedjail=0 WHERE userid IN(".implode(",", $ids).")"); } $db->query("DELETE FROM fedjail WHERE fed_days=0"); $db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0"); $db->query("UPDATE users SET daysold=daysold+1, boxes_opened=0"); $db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0"); $db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0"); $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0"); $db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0"); $db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>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->query("TRUNCATE TABLE votes;"); $cityl=$db->query("SELECT * FROM `cities` WHERE `cityowneron` = '1'"); while($r=$db->fetch_row($cityl)) { if($r['citytaxon'] == 1) { mysql_query("UPDATE users SET money=money-$r[citytax] WHERE location=$r[cityid] AND money>$r[citytaxprice]"); $qq=mysql_query("SELECT * FROM `users` WHERE `money` < $r[citytax] AND `location` = $r[cityid]"); while($rr=mysql_fetch_array($qq)) { event_add($r['cityowner'],"[url='viewuser.php?u=$rr[userid]']$rr[username][/url] has insufficient cash to pay for the tax today. [url='cityadmin.php?action=kick&ID=$rr[id]']Kick them out here[/url] ",$c); } $q=mysql_query("SELECT * FROM `users` WHERE `location` = '$r[cityid]'"); $pricepay=mysql_fetch_array($q)*$r['citytaxprice']; mysql_query("UPDATE users SET money=money+$pricepay WHERE userid=$r[cityowner]"); } $newcq=mysql_query("SELECT * FROM`cities`"); while($newr=mysql_fetch_array($newcq)) { $daf=mysql_query("SELECT * FROM `users` WHERE `location` = '$newr[cityid]"); if(mysql_num_rows($daf) > $newr['citymost']) { $rowstoupdate=mysql_num_rows($daf); mysql_query("UPDATE cities SET citymost=$rowstoupdate WHERE cityid=$r[cityid]"); } } mysql_query("UPDATE cities SET citydays=citydays+1"); } ?>   monorail.php <?php include "globals.php"; $_GET['to'] = abs((int) $_GET['to']); if(!$_GET['to']) { print "Welcome to the Monorail Station. It costs \$1000 for a ticket. Where would you like to travel today? "; $q=$db->query("SELECT * FROM cities WHERE cityid != {$ir['location']} AND cityminlevel <= {$ir['level']}"); print "[size="1"]If owner is N/A it has no owner, If tax is N/A it has no tax (the tax can change at anytime).[/size] <table width=75% cellspacing=1 class='table'><tr><th>Name</th><th>Description</th><th>Min Level</th><th>Cost</th><th>Tax</th><th>Owner</th><th> </th></tr>"; while($r=$db->fetch_row($q)) { print "<tr><td>{$r['cityname']}</td><td>{$r['citydesc']}</td><td>"; if($r['cityminlevelon'] == 1) { print $r['cityminlevel']; } else { print "N/A"; } print "</td><td><font color=green>\$".number_format($r['cityprice'])."</font></td><td>"; if($r['citytax'] == 1) { print "<font color=red>\$".number_format($r['citytaxprice'])."</font>"; } else { print "N/A"; } print "</td><td>"; if($r['cityowneron'] == 1) { $q=mysql_query("SELECT * FROM `users` WHERE `userid` = '$r[cityowner]'"); $rr=mysql_fetch_array($q); print "[url='viewuser.php?u=$rr[userid]']$rr[username][/url]"; } else { print "N/A"; } print "</td><td>[url='monorail.php?to={$r[']Go[/url] [url='viewmoreinfo.php?ID=$r[cityid]']View More Info[/url]</td></tr>"; } print "</table>"; } else { $q=$db->query("SELECT * FROM cities WHERE cityid = {$_GET['to']} AND cityminlevel <= {$ir['level']}"); $ban_q=mysql_query("SELECT * FROM `banished_users` WHERE `ban_CITY` = '$_GET[to]' AND `ban_USER` = '$ir[userid]'"); $qq=$db->query("SELECT * FROM cities WHERE cityid = {$_GET['to']} AND cityminlevel <= {$ir['level']}"); $rr=mysql_fetch_array($qq); if(!mysql_num_rows($q)) { print "Error, this city either does not exist or you cannot go there."; } else if( ((int) $_GET['to']) != $_GET['to']) { print "Invalid city ID"; } else if($ir['money'] < $rr['cityprice']) { print "You don't have enough money to travel to this city."; } else if(mysql_num_rows($ban_q)) { print "Error, You are banished from this city so go away."; $h->endpage(); exit; } else { $db->query("UPDATE users SET money=money-$rr[cityprice],location={$_GET['to']} WHERE userid=$userid"); $r=$db->fetch_row($q); print "Congratulations, you paid \$".number_format($r['cityprice'])." and travelled to {$r['cityname']} on the monorail!"; mysql_query("UPDATE users SET money=money+$r[cityprice] WHERE userid=$r[cityowner]"); } } $h->endpage(); ?>   viewmoreinfo.php <?php include "globals.php"; global $c,$ir,$db,$set,$_SESSION; $q=mysql_query("SELECT * FROM cities WHERE cityid=$_GET[iD]"); if(mysql_num_rows($q)== 0) { die("There is not a city with that ID, so stop trying to abuse!"); } $r=mysql_fetch_array($q); $popul=mysql_query("SELECT COUNT(*) AS pop FROM users WHERE location=$r[cityid]"); $populr=mysql_fetch_array($popul); print "<h3>City Information</h3> <table width=90% border=1> <tr><th>City Name</th><td>$r[cityname]</td></tr> <tr><th>City Most Members</th><td>$r[citymost]</td></tr> <tr><th>City Days Running</th><td>$r[citydays]</td></tr> <tr><th>City Friends</th><td>".number_format(mysql_num_rows(mysql_query("SELECT * FROM city_friends WHERE friend_GIVE=$r[cityid] OR friend_TAKE=$r[cityid] AND friend_ACCEPT=1")))."</td></tr> <tr><th>City Population</th><td>".number_format($populr[pop])."</td></tr> <tr><th>Citys Banished Users</th><td>".number_format(mysql_num_rows(mysql_query("SELECT * FROM banished_users WHERE ban_CITY=$r[cityid]")))."</td></tr> <tr><td colspan=2>[url='javascript:history.back();']Back[/url]</td></tr> </table>"; $h->endpage(); ?>   Insert SQL [mysql]DROP TABLE `cities` ; CREATE TABLE `cities` ( `cityid` int(11) NOT NULL auto_increment, `cityname` varchar(255) NOT NULL default '', `citydesc` longtext NOT NULL, `cityminlevelon` int(11) NOT NULL, `cityminlevel` int(11) NOT NULL default '0', `cityowneron` INT( 11 ) NOT NULL, `cityowner` INT( 11 ) NOT NULL, `citymost` INT( 11 ) NOT NULL, `cityprice` INT( 11 ) NOT NULL, `citydays` INT( 11 ) NOT NULL, `citytax` INT( 11 ) NOT NULL, `citytaxprice` INT( 11 ) NOT NULL, PRIMARY KEY (`cityid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; INSERT INTO `cities` (`cityid`, `cityname`, `citydesc`, `cityminlevelon`, `cityminlevel`, `cityowneron`, `cityowner`, `citymost`, `cityprice`, `citydays`, `citytax`, `citytaxprice`) VALUES ('1', 'Default City', 'The games default city', '1', '1', '0', '0', '0', '0', '0', '0', '0'); CREATE TABLE `city_friends` ( `friend_ID` INT( 11 ) NOT NULL auto_increment, `friend_GIVE` INT( 11 ) NOT NULL, `friend_TAKE` INT( 11 ) NOT NULL, `friend_ACCEPT` INT( 11 ) NOT NULL, `friend_MSG` LONGTEXT NOT NULL, PRIMARY KEY (`friend_ID`) ) TYPE=MYISAM ; CREATE TABLE `banished_users` ( `ban_ID` int(11) not null auto_increment, `ban_CITY` int(11) not null, `ban_USER` int(11) not null, primary key (`ban_ID`) ) TYPE=MYISAM ;[/mysql]   Add These Changes OPEN mainmenu.php AND FIND WHERE IT SYAS [url='search.php']Search[/url]"; ADD BELOW $qq=mysql_query("SELECT * FROM cities WHERE cityowner=$ir[userid]"); if(mysql_num_rows($qq) > 0) { print "[url='cityadmin.php']City Admin Panel[/url] "; } FIND WHERE IT SAYS [[url='sendcash.php?ID={$r[']Send Cash[/url]] "; ADD AFTER $qq=mysql_query("SELECT * FROM cities WHERE cityowner=$ir[userid]"); if(mysql_num_rows($qq) > 0) { print "[[url='cityadmin.php?action=banish&ID=$r[userid]']Banish[/url]] "; $r4=mysql_fetch_array($qq); if($r4['cityid'] == $r['location']) { print "[[url='cityadmin.php?action=kick&ID=$r[userid]']Kick Out City[/url]] "; } $qq2=mysql_query("SELECT * FROM cities WHERE cityowner=$r[userid]"); if(mysql_num_rows($qq) > 0) { $rr2=mysql_fetch_array($qq2); print "[[url='cityadmin.php?action=makeadd&ID=$r[cityid]']Request Alliance[/url]]"; } }   Theres a few bugs it won't allow admins to create citys if they bought them :/ the main menu part causes bigger error and stuff :( I know i'm a noob but if someone could help me fix thank you :)