$link = mysql_connect("p2", "jarde", "Nsp5lxYI") or die("Could not connect"); mysql_select_db("jarde") or die("Could not select database"); if($HTTP_GET_VARS["do"] == "create") { $query = "". "insert into mapobj". "(name, x1, y1, x2, y2, datecreate, datemodify)". "values (\"" . $HTTP_GET_VARS["name"] . "\",". $HTTP_GET_VARS["x1"] . ",". $HTTP_GET_VARS["y1"] . ",". $HTTP_GET_VARS["x2"] . ",". $HTTP_GET_VARS["y2"] . ",". time() . "," . time() . ")"; $result = mysql_query($query, $link); //mysql_free_result($result); sleep(2); mysql_close($link); header("Location: index.php"); exit(); } if($HTTP_GET_VARS["do"] == "save") { $query = "update mapobj set ". "name = \"". $HTTP_GET_VARS["name"] . "\",". "x1 = ". $HTTP_GET_VARS["x1"] . ",". "y1 = ". $HTTP_GET_VARS["y1"] . ",". "x2 = ". $HTTP_GET_VARS["x2"] . ",". "y2 = ". $HTTP_GET_VARS["y2"] . ",". "level = ". $HTTP_GET_VARS["level"] . ",". "datemodify = ". time() . " ". "where obj_id = " . $HTTP_GET_VARS["id"]; $result = mysql_query($query, $link); sleep(2); header("Location: index.php"); exit(); } ?>
if($HTTP_GET_VARS["do"] == "select") { $query = "". "select * from mapobj where obj_id = ". $HTTP_GET_VARS["id"]; $result = mysql_query($query, $link); $row = mysql_fetch_array($result, MYSQL_ASSOC); $mapsubmit = "save"; $mapid = $row["obj_id"]; $mapname = $row["name"]; $mapx1 = $row["x1"]; $mapy1 = $row["y1"]; $mapx2 = $row["x2"]; $mapy2 = $row["y2"]; $maplvl = $row["level"]; } else { $mapsubmit = "create"; $mapx1 = 0; $mapy1 = 0; $mapx2 = 0; $mapy2 = 0; $maplvl = 5; } echo ("\n"); ?> | $mapobjs = ""; $query = "". "select * from mapobj where parent_id = 0". " and linkto = 0"; $result = mysql_query($query, $link); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $mapobjs = $mapobjs . "\n"; } mysql_free_result($result); echo ("\n"); ?> |