Maar ik wil dan dat als je op de plaatje drukt van de stad (een plattegrond met de stad erin) dat hij dan naar reizen.php?p=pallettown (voorbeeld)
gaat en dan iets gaat aanpassen in de MySQL bij de leden van 't spel, maar volgens mij kan dat wel.. maar ik heb waarschijnlijk iets gecombineerd wat niet kan ofzo.. (zie einde van de script).
Mijn bedoeling was: Al drukken ze op een stad van de plattegrond, dan gaat het linken naar bijv. reizen.php?p=pallettown en dat gaat er iets aangepast worden in de MySQL (Ticket gaat eraf en dan de cijfer van de stad komt in de MySQL opgeslagen) en dan "ben je bij" Pallet Town. Hopelijk snappen jullie wat ik bedoel en check de PHP file, en misschien kunnen jullie zeggen wat er aangepast kan worden!
<?php /* ------------------------- */
$UPDATE_DB = 1;
include("_include-config.php");
if(! check_login()) {
header("Location: login.php");
exit;
}
mysql_query("UPDATE `[users]` SET `online`=NOW() WHERE `login`='{$data->login}'");
if($data->Ticket < 1){
print <<<ENDHTML
<html>
<head>
<title>[ð.. X-IST ..ð]</title>
<link rel="stylesheet" type="text/css" href="css-v1.css">
</head>
<body style="margin: 0px;">
<table align=center width=100%>
<tr><td class=subTitle><b>Sorry</b></td></tr>
<tr><td class="mainTxt">
<center><img src="images/airport.gif"></center>
</td></tr>
<tr><td class=mainTxt>U heeft geen Ticket, koop een ticket in de shop.
</table><br><br>
</body>
</html>
/* ------------------------- */ ?>
<html>
<head>
<title>[ð.. X-IST ..ð]</title>
<link rel="stylesheet" type="text/css" href="<?php echo ($_COOKIE['v'] == 2) ? "css-v1.css" : "css-v1.css"; ?>">
</head>
<body style="margin: 0px;">
<table width=100%>
<tr><td class="subTitle"><b>Station</b></td>
<tr><td class="mainTxt">
<center><img src="images/airport.gif"></center>
</td></tr>
<tr><td class="mainTxt">
Welkom op het station.<br>
U kunt naar 10 verschillende steden reizen.<br>
Elke reis die je maakt kost 1 ticket.<br>
Die kan je kopen in de shop voor $1000.<br><br>
<tr><td class="mainTxt"><center><b> Selecteer hier onder naar welke stad je heen wilt.</b></td></tr>
<tr><td class="mainTxt" align="center">
<br>
/* GESLICEDE PLATTEGROND */
<table width="521" height="349" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="18">
<img src="images/map_01.jpg" width="520" height="51" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="51" alt=""></td>
</tr>
<tr>
<td colspan="2">
<img src="images/map_02.jpg" width="83" height="50" alt=""></td>
<td colspan="4">
<a href="reizen.php?p=pewtercity">
<img src="images/pewtercity.jpg" width="67" height="50" border="0" alt=""></a></td>
<td colspan="5">
<img src="images/map_04.jpg" width="125" height="50" alt=""></td>
<td colspan="4">
<a href="reizen.php?p=ceruleancity">
<img src="images/ceruleancity.jpg" width="77" height="50" border="0" alt=""></a></td>
<td colspan="3">
<img src="images/map_06.jpg" width="168" height="50" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="50" alt=""></td>
</tr>
<tr>
<td colspan="7">
<img src="images/map_07.jpg" width="179" height="53" alt=""></td>
<td colspan="3">
<a href="reizen.php?p=celadoncity">
<img src="images/celadoncity.jpg" width="67" height="53" border="0" alt=""></a></td>
<td>
<img src="images/map_09.jpg" width="29" height="53" alt=""></td>
<td colspan="3">
<a href="reizen.php?p=saffroncity">
<img src="images/saffroncity.jpg" width="68" height="53" border="0" alt=""></a></td>
<td colspan="2">
<img src="images/map_11.jpg" width="43" height="53" alt=""></td>
<td>
<a href="reizen.php?p=lavendertown">
<img src="images/lavendertown.jpg" width="73" height="53" border="0" alt=""></a></td>
<td>
<img src="images/map_13.jpg" width="61" height="53" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="53" alt=""></td>
</tr>
<tr>
<td>
<img src="images/map_14.jpg" width="67" height="62" alt=""></td>
<td colspan="3">
<a href="reizen.php?p=viridiancity">
<img src="images/viridiancity.jpg" width="65" height="62" border="0" alt=""></a></td>
<td colspan="7">
<img src="images/map_16.jpg" width="143" height="62" alt=""></td>
<td colspan="4">
<a href="reizen.php?p=vermilioncity">
<img src="images/vermilioncity.jpg" width="77" height="62" border="0" alt=""></a></td>
<td colspan="3">
<img src="images/map_18.jpg" width="168" height="62" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="62" alt=""></td>
</tr>
<tr>
<td colspan="18">
<img src="images/map_19.jpg" width="520" height="31" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="31" alt=""></td>
</tr>
<tr>
<td colspan="2">
<img src="images/map_20.jpg" width="83" height="34" alt=""></td>
<td colspan="3">
<a href="reizen.php?p=palettown">
<img src="images/palettown.jpg" width="56" height="34" border="0" alt=""></a></td>
<td colspan="13">
<img src="images/map_22.jpg" width="381" height="34" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="34" alt=""></td>
</tr>
<tr>
<td colspan="9">
<img src="images/map_23.jpg" width="230" height="17" alt=""></td>
<td colspan="3" rowspan="2">
<a href="reizen.php?p=fuchsiacity">
<img src="images/fuchsiacity.jpg" width="64" height="42" border="0" alt=""></a></td>
<td rowspan="3">
<img src="images/map_25.jpg" width="46" height="56" alt=""></td>
<td colspan="5" rowspan="3">
<img src="images/map_26.jpg" width="180" height="56" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="17" alt=""></td>
</tr>
<tr>
<td colspan="3" rowspan="2">
<img src="images/map_27.jpg" width="98" height="39" alt=""></td>
<td colspan="5" rowspan="2">
<a href="reizen.php?p=cinnabarisland">
<img src="images/cinnabarisland.jpg" width="82" height="39" border="0" alt=""></a></td>
<td rowspan="2">
<img src="images/map_29.jpg" width="50" height="39" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="25" alt=""></td>
</tr>
<tr>
<td colspan="3">
<img src="images/map_30.jpg" width="64" height="14" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="14" alt=""></td>
</tr>
<tr>
<td colspan="18">
<img src="images/map_31.jpg" width="520" height="11" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="11" alt=""></td>
</tr>
<tr>
<td>
<img src="images/spacer.gif" width="67" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="16" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="15" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="34" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="7" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="11" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="29" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="1" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="50" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="16" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="29" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="19" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="46" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="3" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="9" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="34" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="73" height="1" alt=""></td>
<td>
<img src="images/spacer.gif" width="61" height="1" alt=""></td>
<td></td>
</tr>
</table>
/* GESLICEDE PLATTEGROND EINDE */
/* Hier kun je zien hoeveel mensen in elk stad zitten */
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=1 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Palet Town: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
<tr valign="top">
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=2 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Viridian City: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
<tr valign="top">
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=3 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Pewter City: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
<tr valign="top">
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=4 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Cerulean City: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
<tr valign="top">
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=5 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Saffron City: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=6 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Celadon City: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
<tr valign="top">
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=7 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Lavender Town: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
<tr valign="top">
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=8 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Vermilion City: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
<tr valign="top">
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=9 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Fuchsia City: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
<tr valign="top">
<?
$select = mysql_query("SELECT * FROM `[users]` WHERE Citynumb=10 AND id != '0'");
$aantal = mysql_num_rows($select);
?>
<td width="50%">Leden in Cinnabar Island: <b><? echo $aantal; ?></b></td>
<td width="50%"> </td>
</tr>
</td></tr>
</table>
/* HIER IS DE ZELF AANGEPASTE STUK */
<?
else if($_GET['p'] == "pallettown") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='1' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Pallet Town!</td></tr>\n";
}
?>
<?
else if($_GET['p'] == "viridiancity") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='2' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Viridian City!</td></tr>\n";
}
?>
<?
else if($_GET['p'] == "pewtercity") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='3' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Pewter City!</td></tr>\n";
}
?>
<?
else if($_GET['p'] == "ceruleancity") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='4' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Cerulean City!</td></tr>\n";
}
?>
<?
else if($_GET['p'] == "saffroncity") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='5' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Saffron City!</td></tr>\n";
}
?>
<?
else if($_GET['p'] == "celadoncity") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='6' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Celadon City!</td></tr>\n";
}
?>
<?
else if($_GET['p'] == "lavendertown") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='7' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Lavender Town!</td></tr>\n";
}
?>
<?
else if($_GET['p'] == "vermilioncity") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='8' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Vermilion City!</td></tr>\n";
}
?>
<?
else if($_GET['p'] == "fuchsiacity") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='9' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Fuchsia City!</td></tr>\n";
}
?>
<?
else if($_GET['p'] == "cinnabarisland") {
print " <tr><td class=\"subTitle\"><b>Station</b></td></tr>\n";
mysql_query("UPDATE `[users]` SET `Citynumb`='10' WHERE `login`='{$data->login}'");
mysql_query("UPDATE `[users]` SET `Ticket`=`Ticket`-1 WHERE `login`='{$member->login}'");
print " <tr><td class=\"mainTxt\">Je bent nu in Cinnabar Island!</td></tr>\n";
}
?>
</body>
</html>
</html>
<noscript><noscript><plaintext><plaintext>
<? mysql_close(); ?>
Alvast bedankt!
eXa
