New City

RecklessCounty · July 14, 2007

can someone tell me why my code doesn't work?

<?php

/**
* @author ShannenName
* @copyright 2007
*/

session_start();
require "global_func.php";
if ($_SESSION['loggedin'] == 0)
{
   header("Location: login.php");
   exit;
}
$userid = $_SESSION['userid'];
require "header.php";
$h = new headers;
$h->startheaders();
include "mysql.php";
global $c;
$is = mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",
   $c) or die(mysql_error());
$ir = mysql_fetch_array($is);
check_level();
$fm = money_formatter($ir['money']);
$lv = date('F j, Y, g:i a', $ir['laston']);
$h->userdata($ir, $lv, $fm);
$h->menuarea();
if ($ir['user_level'] != 2)
{
   print "You sneak, get out of here!";
   $h->endpage();
   exit;
}
$posta = mysql_real_escape_string(print_r($_POST, 1), $c);
$geta = mysql_real_escape_string(print_r($_GET, 1), $c);
mysql_query("INSERT INTO adminlogs VALUES('', $userid, '$posta', '$geta', unix_timestamp() )",
   $c);
switch ($_GET['action'])
{
   case "delcity":
       delcity();
       break;
   case 'newcity':
       new_city();
       break;
   case 'newcitysub':
       new_city_sub();
       break;
   case 'editcity':
       edit_city();
       break;
   case 'editcitysub':
       edit_city_sub();
       break;
}
print "[[url='newcity.php?action=newcity']Create New city[/url]]

[[url='newcity.php?action=editcity']Edit City[/url]]
";
function new_city()
{
   global $ir, $c, $h, $userid;
   print "Create New City
This will create a new city.


City name: 

City desc: 

City min level 

";
}
function new_city_sub()
{
   global $ir, $c, $h, $userid;
   $_POST['cityminlevel'] = abs((int)$_POST['cityminlevel']);
   mysql_query("INSERT INTO cities (cityname, citydesc, cityminlevel) VALUES ('{$_POST['cityname']}', '{$_POST['citydesc']}', '{$_POST['cityminlevel']}');",
       $c);
   print "[url='admin.php']> Back[/url]";
}
function edit_city()
{
   global $ir, $c, $h, $userid, $cityid;
   print "Edit City
This will edit a city.


City Name EXACTLY as it appears: 

City desc: 

City min level 

";
}
function edit_city_sub()
{
global $ir,$c,$h,$userid;
mysql_query("UPDATE cities (cityname, citydesc, cityminlevel)VALUES ('{$_POST['cityname']}', '{$_POST['citydesc']}', '{$_POST['cityminlevel']}');", $c);
print "City edited...";
}
$h->endpage();
?>

RecklessCounty · July 15, 2007

Re: New City

Anyone? **bump**

Snatchy · July 16, 2007

Re: New City

<?php

/**
* @author ShannenName
* @copyright 2007
*/

session_start();
require "global_func.php";
if($_SESSION['loggedin']==0) { header("Location: login.php");exit; }
$userid=$_SESSION['userid'];
require "header.php";
$h = new headers;
$h->startheaders();
include "mysql.php";
global $c;
$is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error());
$ir=mysql_fetch_array($is);
check_level();
$fm=money_formatter($ir['money']);
$cm=money_formatter($ir['crystals'],'');
$bm=money_formatter($ir['l100bank']);
$lv=date('F j, Y, g:i a',$ir['laston']);
$h->userdata($ir,$lv,$fm,$cm);
$h->menuarea();
if ($ir['user_level'] != 2)
{
   print "You sneak, get out of here!";
   $h->endpage();
   exit;
}
$posta = mysql_real_escape_string(print_r($_POST, 1), $c);
$geta = mysql_real_escape_string(print_r($_GET, 1), $c);
mysql_query("INSERT INTO adminlogs VALUES('', $userid, '$posta', '$geta', unix_timestamp() )",
   $c);
switch ($_GET['action'])
{
   case "delcity":
       delcity();
       break;
   case 'newcity':
       new_city();
       break;
   case 'newcitysub':
       new_city_sub();
       break;
   case 'editcity':
       edit_city();
       break;
   case 'editcitysub':
       edit_city_sub();
       break;
}
print "</br >[[url='newcity01.php?action=newcity']Create New city[/url]]

[[url='newcity01.php?action=editcity']Edit City[/url]]

City List

<table>
<tr><td>";
$q=mysql_query("SELECT * FROM cities ",$c);
print"<table width=95% bgcolor=#ff9900 align=center border=1 cellspacing=0><tr style='background:#ff6633'><th>city id no.</th><th>Name</th><th>Description</th><th>Min Level</th><th> </th></tr>";
while($r=mysql_fetch_array($q))
{
print "<tr><td>{$r['cityid']}</td><td>{$r['cityname']}</td><td>{$r['citydesc']}</td><td>{$r['cityminlevel']}</td></tr>";
}
print "</table>";
function new_city()
{
   global $ir, $c, $h, $userid;
   print "<h3>Create New City</h3>
This will create a new city.

<form action='newcity01.php?action=newcitysub' method='post'>
City name: <input type='text' name='cityname' />

City desc: <input type='text' name='citydesc' />

City min level <input type='text' name='cityminlevel' />

<input type='submit' value='Create New city' /></form>";
}
function new_city_sub()
{
   global $ir, $c, $h, $userid;
   $_POST['cityminlevel'] = abs((int)$_POST['cityminlevel']);
   mysql_query("INSERT INTO cities (cityname, citydesc, cityminlevel) VALUES ('{$_POST['cityname']}', '{$_POST['citydesc']}', '{$_POST['cityminlevel']}');",
       $c);
   print "[url='admin.php']> Back[/url]";
}
function edit_city()
{
   global $ir, $c, $h, $userid, $cityid;
   print "<h3>Edit City</h3>
This will edit a city.

<form action='newcity01.php?action=editcitysub' method='post'>
City City id: <input type='text' name='cityid' />

City Name EXACTLY as it appears: <input type='text' name='cityname' />

City desc: <input type='text' name='citydesc' />

City min level <input type='text' name='cityminlevel' />

<input type='submit' value='Edit city' /></form>";
}
function edit_city_sub()
{
global $ir,$c,$h,$userid;
mysql_query("UPDATE cities SET cityid='{$_POST['cityid']}',cityname='{$_POST['cityname']}', citydesc='{$_POST['citydesc']}', cityminlevel='{$_POST['cityminlevel']}' WHERE cityid='{$_POST['cityid']}'",$c);
print "City edited...";
}
$h->endpage();
?>

Try that

Snatchy · July 16, 2007

Re: New City

<?php

/**
* @author ShannenName
* @copyright 2007
*/

session_start();
require "global_func.php";
if($_SESSION['loggedin']==0) { header("Location: login.php");exit; }
$userid=$_SESSION['userid'];
require "header.php";
$h = new headers;
$h->startheaders();
include "mysql.php";
global $c;
$is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error());
$ir=mysql_fetch_array($is);
check_level();
$fm=money_formatter($ir['money']);
$cm=money_formatter($ir['crystals'],'');
$bm=money_formatter($ir['l100bank']);
$lv=date('F j, Y, g:i a',$ir['laston']);
$h->userdata($ir,$lv,$fm,$cm);
$h->menuarea();
if ($ir['user_level'] != 2)
{
   print "You sneak, get out of here!";
   $h->endpage();
   exit;
}
$posta = mysql_real_escape_string(print_r($_POST, 1), $c);
$geta = mysql_real_escape_string(print_r($_GET, 1), $c);
mysql_query("INSERT INTO adminlogs VALUES('', $userid, '$posta', '$geta', unix_timestamp() )",
   $c);
switch ($_GET['action'])
{
/*    case "delcity":
       delcity();
       break;*/
   case 'newcity':
       new_city();
       break;
   case 'newcitysub':
       new_city_sub();
       break;
   case 'editcity':
       edit_city();
       break;
   case 'editcitysub':
       edit_city_sub();
       break;
	    case 'delcity':
       del_city();
       break;
	    case 'delcitysub':
       del_city_sub();
       break;
}
print "</br >[[url='newcity01.php?action=newcity']Create New city[/url]]


[[url='newcity01.php?action=editcity']Edit City[/url]]


[[url='newcity01.php?action=delcity']Delete City[/url]]

City List

<table>
<tr><td>";
$q=mysql_query("SELECT * FROM cities ",$c);
print"<table width=95% bgcolor=#ff9900 align=center border=1 cellspacing=0><tr style='background:#ff6633'><th>city id no.</th><th>Name</th><th>Description</th><th>Min Level</th></tr>";
while($r=mysql_fetch_array($q))
{
print "<tr><td>{$r['cityid']}</td><td>{$r['cityname']}</td><td>{$r['citydesc']}</td><td>{$r['cityminlevel']}</td></tr>";
}
print "</table>";
function new_city()
{
   global $ir, $c, $h, $userid;
   print "<h3>Create New City</h3>
This will create a new city.

<form action='newcity01.php?action=newcitysub' method='post'>
City name: <input type='text' name='cityname' />

City desc: <input type='text' name='citydesc' />

City min level <input type='text' name='cityminlevel' />

<input type='submit' value='Create New city' /></form>";
}
function new_city_sub()
{
   global $ir, $c, $h, $userid;
   $_POST['cityminlevel'] = abs((int)$_POST['cityminlevel']);
   mysql_query("INSERT INTO cities (cityname, citydesc, cityminlevel) VALUES ('{$_POST['cityname']}', '{$_POST['citydesc']}', '{$_POST['cityminlevel']}');",
       $c);
   print "[url='admin.php']> Back[/url]";
}
function edit_city()
{
   global $ir, $c, $h, $userid, $cityid;
   print "<h3>Edit City</h3>
This will edit a city.

<form action='newcity01.php?action=editcitysub' method='post'>
City City id: <input type='text' name='cityid' />

City Name EXACTLY as it appears: <input type='text' name='cityname' />

City desc: <input type='text' name='citydesc' />

City min level <input type='text' name='cityminlevel' />

<input type='submit' value='Edit city' /></form>";
}
function edit_city_sub()
{
global $ir,$c,$h,$userid;
mysql_query("UPDATE cities SET cityid='{$_POST['cityid']}',cityname='{$_POST['cityname']}', citydesc='{$_POST['citydesc']}', cityminlevel='{$_POST['cityminlevel']}' WHERE cityid='{$_POST['cityid']}'",$c);
print "City edited...";
}
function del_city()
{
   global $ir, $c, $h, $userid, $cityid;
   print "<h3>Delet City</h3>
This will delete a city.

<form action='newcity01.php?action=delcitysub' method='post'>
City id: <input type='text' name='cityid' />

<input type='submit' value='Delete city' /></form>";
}
function del_city_sub()
{
global $ir,$c,$h,$userid;
mysql_query("DELETE FROM cities WHERE cityid='{$_POST['cityid']}'",$c);
print "City deleted";
}
$h->endpage();
?>

Sign In

New City

Recommended Posts

RecklessCounty

RecklessCounty

Snatchy

Snatchy

Join the conversation

Browse

Activity

Hosting