bladewolf2010 Posted May 8, 2010 Share Posted May 8, 2010 My monorail won't show the citys i create :( any reAson why? Quote Link to comment Share on other sites More sharing options...
Jordan Palmer Posted May 8, 2010 Share Posted May 8, 2010 My monorail won't show the citys i create :( any reAson why? Contact MCCodes Support and they'll issue you with a repaired one. This was a known issue and has been actually repaired in the patched version so they say, However contact them Quote Link to comment Share on other sites More sharing options...
bladewolf2010 Posted May 8, 2010 Author Share Posted May 8, 2010 Don't I need proof of purchase yada yada yada? Quote Link to comment Share on other sites More sharing options...
Dominion Posted May 8, 2010 Share Posted May 8, 2010 o look a nice monorail :) [mccode v2] Monorail Recode Quote Link to comment Share on other sites More sharing options...
bladewolf2010 Posted May 8, 2010 Author Share Posted May 8, 2010 It still don't show cities i create:( Quote Link to comment Share on other sites More sharing options...
Dominion Posted May 8, 2010 Share Posted May 8, 2010 ok so did you fix staff citys? if not find Minimum Level: <input type='text' name=minlevel' /> Replace with Minimum Level: <input type='text' name='minlevel' /> if that does not work please explain better or post your files not working is not really a lot of info Quote Link to comment Share on other sites More sharing options...
bladewolf2010 Posted May 8, 2010 Author Share Posted May 8, 2010 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 :/ Quote Link to comment Share on other sites More sharing options...
Dominion Posted May 8, 2010 Share Posted May 8, 2010 when you add citys are you adding there min level higher then the level you are cos they don't show up untill you hit that level Quote Link to comment Share on other sites More sharing options...
bladewolf2010 Posted May 8, 2010 Author Share Posted May 8, 2010 Oh okAy thank you :) sorry to bother you Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.