zo dat heb je netjes gedaan alleen ik heb wat steden er in bijv. in de tabel 'land'
staat een nummer "6"
nummer 6 moet worden omgezet naar bijv. Maastricht
btw ik zal het orginele script wel even plaatsen
<?
include("connect.php");
if(! check_login()) {
header("Location: login.php");
exit;
}
include("ban.php");
include("jail.php");
include("dood.php");
include("time.php");
mysql_query("UPDATE `[users]` SET `online`=NOW() WHERE `login`='{$data->login}'");
if($data->familie != ''){ $lolz = '<input type=submit name=crush value="Crush geselecteerde.">'; }
?><head>
<title>Maffiagun.nl</title>
<!-- This source is a part of the Maffiagun web game. You may not use or otherwise copy or duplicate any part of the source, Javascripts or CSS files without explicit prior permission of: Maffiagun Game Copyright 2006-2007 -->
<link rel="stylesheet" type="text/css" href="css-v1.css">
</head>
<script language="javascript">
var checked = 0;
function checkAll() {
checked = !checked;
for(i=0; i<document.form1.elements.length; i++)
document.form1.elements[i].checked = checked;
}
</script>
<script>
function do_repair(carid,value,damage)
{
var del = confirm("Weet je zeker dat je deze auto wilt repareren? " + carid + " [Kosten: $" + (value/50)*damage+ "]?");
if (del == true){
var loc="garage.php?repair=" + carid;
window.location=loc;
}
}
function car_sell(carid,value,damage)
{
var del = confirm("Weet je zeker dat je deze auto wilt verkopen? " + carid + "?");
if (del == true){
var loc="garage.php?ver=" + carid;
window.location=loc;
}
}
</script>
<table width="100%" align="center">
<?
if(isset($_POST['shipp'])){
$autoo = mysql_query("SELECT * FROM `auto` WHERE `owner`='$data->login' AND `id`='{$_POST['carid']}'");
$auto = mysql_fetch_object($autoo);
$check = mysql_num_rows($autoo);
if($check == 0){
echo "<table width=500 align=center><tr><td class=subtitle>Autos Verschepen</td></tr>
<tr><td class=mainTxt><font color=red><center>Deze auto is niet van jou!</font></td></tr>";
}
elseif($data->cash < 10000){
echo "<table width=500 align=center><tr><td class=subtitle>Autos Verschepen</td></tr>
<tr><td class=mainTxt><font color=red><center>Je hebt niet genoeg geld hiervoor, Kosten $10.000</font></td></tr>";
}
else{
mysql_query("UPDATE `auto` SET `land`='{$_POST['shipto']}' WHERE `id`='{$_POST['carid']}'");
mysql_query("UPDATE `[users]` SET `cash`=`cash`-10000 WHERE `login`='{$data->login}'");
$lol = $_POST['shipto'];
$land1 = array("","Groningen","Amsterdam","Rotterdam","Eindhoven","Maastricht","Nijmegen","");
$land = $land1[$lol];
echo "<table width=500 align=center><tr><td class=subtitle>Autos Verschepen</td></tr>
<tr><td class=mainTxt><font color=red><center>Auto verscheept naar $land</font></td></tr>";
}
}
if(isset($_GET['scheep'])){
$autoo = mysql_query("SELECT * FROM `auto` WHERE `owner`='$data->login' AND `id`='{$_GET['scheep']}'");
$auto = mysql_fetch_object($autoo);
$check = mysql_num_rows($autoo);
if($check == 0){
echo "<tr><td class=mainTxt><font color=red><center>Deze auto is niet van jou!</font></td></tr>";
exit;
}
else{
echo "<table width=500 class=thinline cellspacing=0 cellpadding=2 align=center>
<tr><td colspan=1 align=center class=subtitle><b>Wagen verschepen</b></td></tr>
<tr><td height=1 colspan=1 bgcolor=black></td></tr>
<form method=post>
<tr><td class=maintxt><input type=Radio name=shipto value=1> Groningen prijs $10.000<br>
<input type=Radio name=shipto value=2> Amsterdam prijs $10.000<br>
<input type=Radio name=shipto value=3> Rotterdam prijs $10.000<br>
<input type=Radio name=shipto value=4> Eindhoven prijs $10.000<br>
<input type=Radio name=shipto value=5> Maastricht prijs $10.000<br>
<input type=Radio name=shipto value=6> Nijmegen prijs $10.000<br>
<input type=hidden name=carid value={$_GET['scheep']}><br>
<input type=submit name=shipp value=Verschepen!></tr></td></table>
</form>";
exit;
}
}
?>
<tr><td class="subTitle" colspan=7><b>Garage</b></td></tr>
<?php
mysql_query("UPDATE `[users]` SET `online`=NOW() WHERE `login`='{$data->login}'");
if(isset($_GET['ver'])){
$autoo = mysql_query("SELECT * FROM `auto` WHERE `owner`='$data->login' AND `id`='{$_GET['ver']}'");
$auto = mysql_fetch_object($autoo);
$geld2 = Array("T-Ford_Model","NRG 900F","Harley Davidson","BMW Wartburg Roadster","Crossley Super Silver","Morris Minor Tourer","Crossley 10hp Sports Roadster","Crossley 10hp Sports Tourer","Alvis TJ","Harley Davidson","Bugatti Type 13 Torpedo","Bugatti Type 38 Torpedo","Pierce-Arrow 7w Sedan","Nash Big Six Town Sedan","Buick Model 57","Nash Standard 8","Hudson-Essex Super Six","Packard 1100 Sedan","Packard 740 Roadster","740 Roadster 3.5 Litre CoupM-i","Horch 930V Phaeton","Lincoln KA","Reo Royale 8 Convertible","Crossley Kegresse Half-Track Truck","Bentley 4.5 Litre Barker 3 Position Drophead","Rolls Royce Phantom III","Crossley Streamline","Mercedes-Benz 320 Cabriolet","Cadillac V16 Series 452 C Fleetwood Towncar Cabriolet 1933","Alfa Romeo 6C 2500 Sport Touring Berlinetta","Bentley 3 Litre Vanden Plas Tourer","Bugatti Type 50 CoupM-i ProfileM-i","Bugatti Type 35","Duesenberg J Rollston Berline","Duesenberg SJ","Bugatti Type 32 Tank","Mercedes-Benz W25","Mercedes-Benz W125","Mercedes-Benz W25 Avus Streamliner");
$soortauto = $geld2[$auto ->soort];
$check = mysql_num_rows($autoo);
$ver = Array(1000,1200,1300,1500,2000,2250,2500,4000,4250,4500,5500,6000,10000,18000,24000,30000,35000,40000,45000,50000,55000,60000,61500,62000,70000,72000,75000,82000,84000,86000,88000,80000,90000,100000,120000,125000,150000,200000);
$verk = $ver[$auto->soort];
$geld3 = Array('41','80','120','160','200','240','280','320','360','400','440','480','520','560','600','640','680','720','760','800','840','880','920','960','1000','1040','1080','1120','1160','1200','1240','1280','1320','1360','1400','1440','1480','1520','1560','');
$geld2 = $geld3[$auto->soort];
$geld = $verk-$auto->schade*$geld2;
if($geld < 500){
$geld = 500;
}
$geld = round($geld);
$prijs = number_format($geld,0,",",".");
if($check == 0){
echo "<tr><td class=mainTxt colspan=7><font color=red><center>Deze auto is niet van jou!</font></td></tr>";
}
elseif($auto->schade == 0){
$lolol = Array(1000,1200,1300,1500,2000,2250,2500,4000,4250,4500,5500,6000,10000,18000,24000,30000,35000,40000,45000,50000,55000,60000,61500,62000,70000,72000,75000,82000,84000,86000,88000,80000,90000,100000,120000,125000,150000,200000);
$verkost = $lolol[$auto->soort];
$prijs = round($verkost);
$verkost = round($verkost);
$verkost = number_format($verkost,0,",",".");
mysql_query("DELETE FROM `auto` WHERE `id`='{$_GET['ver']})'");
mysql_query("UPDATE `[users]` SET `cash`=`cash`+$geld WHERE `login`='$data->login'");
echo "<tr><td class=mainTxt colspan=7><font color=red><center>Succes je hebt een $soortauto verkocht voor $$verkost!</font></td></tr>";
}
else{
mysql_query("DELETE FROM `auto` WHERE `id`='{$_GET['ver']})'");
mysql_query("UPDATE `[users]` SET `cash`=`cash`+$geld WHERE `login`='$data->login'");
echo "<tr><td class=mainTxt colspan=7><font color=red><center>Succes je hebt een $soortauto verkocht voor $$prijs!</font></td></tr>";
}
}
if(isset($_GET['repair'])){
$autoo = mysql_query("SELECT * FROM `auto` WHERE `owner`='$data->login' AND `id`='{$_GET['repair']}'");
$auto = mysql_fetch_object($autoo);
$check = mysql_num_rows($autoo);
$ver = Array(1000,1200,1300,1500,2000,2250,2500,4000,4250,4500,5500,6000,10000,18000,24000,30000,35000,40000,45000,50000,55000,60000,61500,62000,70000,72000,75000,82000,84000,86000,88000,80000,90000,100000,120000,125000,150000,200000);
$verk = $ver[$auto->soort];
$verkost = round($verk/50*$auto->schade);
$prijs = number_format($verkost,0,",",".");
$geld3 = Array('41','80','120','160','200','240','280','320','360','400','440','480','520','560','600','640','680','720','760','800','840','880','920','960','1000','1040','1080','1120','1160','1200','1240','1280','1320','1360','1400','1440','1480','1520','1560','');
$geld2 = $geld3[$auto->soort];
if($check == 0){
echo "<tr><td class=mainTxt colspan=7><font color=red><center>Deze auto is niet van jou!</font></td></tr>";
}
if($auto->schade == 0){
$lolol = Array(1000,1200,1300,1500,2000,2250,2500,4000,4250,4500,5500,6000,10000,18000,24000,30000,35000,40000,45000,50000,55000,60000,61500,62000,70000,72000,75000,82000,84000,86000,88000,80000,90000,100000,120000,125000,150000,200000);
$verkost = $lolol[$auto->soort];
$verkost = round($verkost);
$prijs = number_format($verkost,0,",",".");
}
elseif($data->cash < $verkost){
echo "<tr><td class=mainTxt colspan=7><font color=red><center>Je hebt niet genoeg geld hiervoor..!</font></td></tr>";
}
else{
mysql_query("UPDATE `auto` SET `schade`='0' WHERE `id`='{$_GET['repair']})'");
mysql_query("UPDATE `[users]` SET `cash`=`cash`-$verkost WHERE `login`='$data->login'");
echo "<tr><td class=mainTxt colspan=7><font color=red><center>Auto gerepereerd voor $$prijs!</font></td></tr>";
}
}
if(isset($_POST['ver'])){
$crush1 = mysql_query("SELECT * FROM `auto` WHERE `owner`='$data->login'") or die(mysql_error());
while($crush = mysql_fetch_object($crush1))
{
if($_POST[$crush->id] ==1 && $crush->land == $data->land)
{
if($crush->schade == 0){
$lolol = Array(1000,1200,1300,1500,2000,2250,2500,4000,4250,4500,5500,6000,10000,18000,24000,30000,35000,40000,45000,50000,55000,60000,61500,62000,70000,72000,75000,82000,84000,86000,88000,80000,90000,100000,120000,125000,150000,200000);
$verkost = $lolol[$crush->soort];
$prijs = round($verkost);
$geld = round($verkost);
mysql_query("DELETE FROM `auto` WHERE `id`='".$crush->id."'") or die(mysql_error());
}
else{
mysql_query("DELETE FROM `auto` WHERE `id`='".$crush->id."'") or die(mysql_error());
$ver = Array(1000,1200,1300,1500,2000,2250,2500,4000,4250,4500,5500,6000,10000,18000,24000,30000,35000,40000,45000,50000,55000,60000,61500,62000,70000,72000,75000,82000,84000,86000,88000,80000,90000,100000,120000,125000,150000,200000);
$verk = $ver[$crush->soort];
$geld3 = Array('41','80','120','160','200','240','280','320','360','400','440','480','520','560','600','640','680','720','760','800','840','880','920','960','1000','1040','1080','1120','1160','1200','1240','1280','1320','1360','1400','1440','1480','1520','1560','');
$geld2 = $geld3[$crush->soort];
$geld = $verk-$crush->schade*$geld2;
if($geld < 500){
$geld = 500;
}
}
$total = $total+$geld;
$cars = $cars+1;
}
}
mysql_query("UPDATE `[users]` SET `cash`=(cash+".$total.") WHERE `login`='".$data->login."'");
$verkost = number_format($total,0,",",".");
echo '<tr><td class="mainTxt" align="center" colspan=7>Je hebt '.$cars.' auto\'s verkocht voor $'.$verkost.'.</td></tr>';
}
if ( isset ( $_POST['crush'] ) )
{
$familyy = mysql_query("SELECT * FROM `[families]` WHERE `name`='".$data->familie."'") or die(mysql_error());
$family = mysql_fetch_object($familyy);
$crush = $family->crush;
if ($crush != 0){
if($family->maxautos > $family->autosnu)
{
$crush1 = mysql_query("SELECT * FROM `auto` WHERE `owner`='$data->login'") or die(mysql_error());
while($crush = mysql_fetch_object($crush1))
{
if($_POST[$crush->id] ==1 && $crush->land == $data->land)
{
$kogels += $family->maxkogels;
mysql_query("DELETE FROM `auto` WHERE `id`='".$crush->id."'") or die(mysql_error());
}
}
$auto = $kogels/$family->maxkogels;
mysql_query("UPDATE `[users]` SET `kogels`=(kogels+".$kogels.") WHERE `login`='".$data->login."'");
mysql_query("UPDATE `[families]` SET `autosnu`=(autosnu+".$auto.") WHERE `name`='".$data->familie."'");
echo '<tr><td class="mainTxt" align="center" colspan=7>Je hebt '.$auto.' autos omgezet naar '.$kogels.' kogels.</td></tr>';
}
else
{
echo '<tr><td class="mainTxt" align="center" colspan=7>De crusher zijn maximum is bereikt. De familie zal een nieuw crush-systeem moeten kopen.</td></tr>';
}
}else{
echo '<tr><td class="mainTxt" align="center" colspan=7>De familie heeft geen crusher gehuurd.</td></tr>';
}
}
$garage1 = mysql_query("SELECT * FROM `auto` WHERE `owner`='".$data->login."'");
if(mysql_num_rows($garage1) == 1)
{
// Your Car
}
else
{
// Not Your Car
}
print ' <form method="post" name="form1">';
print ' <tr> <td class="subTitle" align="center" width=50>Id</td> <td class="subTitle" align="center" width=250>Soort</td> <td class="subTitle" align="center" width=100>Stad</td> <td class="subTitle" align="center" width=150>Schade</td> <td class="subTitle" align="center" width=100>Prijs</td> <td class="subTitle" align="center" width=100>Actie</td> <td align="center" class="subTitle" width=50> </td></tr>';
$garage1 = mysql_query("SELECT * FROM `auto` WHERE `owner`='$data->login'");
$check = mysql_num_rows($garage1);
if($check == 0){
echo ' <tr> <td class="mainTxt" colspan=7><center><b>Je garage bevat nog geen auto\'s</B></td></tr>';
exit;
}
while($garage = mysql_fetch_object($garage1)){
$rep = Array(1000,1200,1300,1500,2000,2250,2500,4000,4250,4500,5500,6000,10000,18000,24000,30000,35000,40000,45000,50000,55000,60000,61500,62000,70000,72000,75000,82000,84000,86000,88000,80000,90000,100000,120000,125000,150000,200000);
$repk = $rep[$garage->soort];
$kost = $repk/50*$garage->schade;
$ver = Array(1000,1200,1300,1500,2000,2250,2500,4000,4250,4500,5500,6000,10000,18000,24000,30000,35000,40000,45000,50000,55000,60000,61500,62000,70000,72000,75000,82000,84000,86000,88000,80000,90000,100000,120000,125000,150000,200000);
$verk = $ver[$garage->soort];
$geld3 = Array('41','80','120','160','200','240','280','320','360','400','440','480','520','560','600','640','680','720','760','800','840','880','920','960','1000','1040','1080','1120','1160','1200','1240','1280','1320','1360','1400','1440','1480','1520','1560','');
$geld2 = $geld3[$garage ->soort];
$geld = $verk-$garage->schade*$geld2;
$verkost = number_format($geld,0,",",".");
if($garage->schade == 0){
$lolol = Array(1000,1200,1300,1500,2000,2250,2500,4000,4250,4500,5500,6000,10000,18000,24000,30000,35000,40000,45000,50000,55000,60000,61500,62000,70000,72000,75000,82000,84000,86000,88000,80000,90000,100000,120000,125000,150000,200000);
$verkost = $lolol[$garage ->soort];
$verkost = round($verkost);
$verkost = number_format($verkost,0,",",".");
}
if($data->land == $garage->land){
$img = "<a href=javascript:car_sell($garage->id,$verk,$garage->schade)><IMG SRC='/images/sell.gif' BORDER=\"0\"></a>";
}
if($geld < 500){
$verkost = 500;
}
if($data->land != $garage->land){
$img = "<IMG SRC='/images/nosell.gif' BORDER='0'>";
}
if($garage->schade != 0){
$rep = "<a href=javascript:do_repair($garage->id,$verk,$garage->schade)><IMG SRC='/images/repair.gif' BORDER='0'></a>";
}
if($garage->schade ==0){
$rep = "<IMG SRC='/images/nodam.gif' BORDER='0'>";
}
$geld2 = Array("T-Ford_Model","NRG 900F","Harley Davidson","BMW Wartburg Roadster","Crossley Super Silver","Morris Minor Tourer","Crossley 10hp Sports Roadster","Crossley 10hp Sports Tourer","Alvis TJ","Harley Davidson","Bugatti Type 13 Torpedo","Bugatti Type 38 Torpedo","Pierce-Arrow 7w Sedan","Nash Big Six Town Sedan","Buick Model 57","Nash Standard 8","Hudson-Essex Super Six","Packard 1100 Sedan","Packard 740 Roadster","740 Roadster 3.5 Litre CoupM-i","Horch 930V Phaeton","Lincoln KA","Reo Royale 8 Convertible","Crossley Kegresse Half-Track Truck","Bentley 4.5 Litre Barker 3 Position Drophead","Rolls Royce Phantom III","Crossley Streamline","Mercedes-Benz 320 Cabriolet","Cadillac V16 Series 452 C Fleetwood Towncar Cabriolet 1933","Alfa Romeo 6C 2500 Sport Touring Berlinetta","Bentley 3 Litre Vanden Plas Tourer","Bugatti Type 50 CoupM-i ProfileM-i","Bugatti Type 35","Duesenberg J Rollston Berline","Duesenberg SJ","Bugatti Type 32 Tank","Mercedes-Benz W25","Mercedes-Benz W125","Mercedes-Benz W25 Avus Streamliner");
$soortauto = $geld2[$garage ->soort];
if($geld < 1000){
$geld = 1000;
}
$land1 = array("","Groningen","Amsterdam","Rotterdam","Eindhoven","Maastricht","Nijmegen","");
$land = $land1[$garage->land];
echo ' <tr> <td class="mainTxt" width=50><center>'.$garage->id.'</center></td> <td class="mainTxt" width=250>'.$soortauto.'</td> <td class="mainTxt" width=100><center>'.$land.'</center></td> <td class="mainTxt"><center>'.$garage->schade.'%</center></td> <td class="mainTxt"><center>$'.$verkost.'</center><input type="hidden" name="'.$garage->id.'" value="'.$geld.'"></td><td width=100 class=maintxt><center>'.$img.' '.$rep.' <a href=garage.php?scheep='.$garage->id.'><IMG SRC="/images/ship.gif" BORDER="0"></a></td><td class="mainTxt" align="center" width=50><input type="checkbox" name="'.$garage->id.'" value="1"></td></tr>';
}
echo"<tr><td class=mainTxt colspan=7 align=center><a href=\"javascript: checkAll()\">Selecteer alle autos</a><br><Br><input type=submit name=ver value=\"Verkoop geselecteerde.\"> $lolz</td></tr>";
?>
</body>
</html>
<?PHP
// de site word sloom dus moeten we wel alles afsluiten..
mysql_close();
// zo dat was het dan weer voor vandaag..
?>
alvast voor zover heeeeel erg bedankt ;)
gr thymen
*edit*
zou je mischien ook willen uitleggen hoe dit:
$sql = "UPDATE users SET online = NOW() WHERE login = '" . $data->login . "'";
$res = mysql_query($sql);
if(!$res)
{
// maak hier een errorafhandeling: query is mislukt
}
-------------------------------------------
while($rij = mysql_fetch_object($res))
{
$soortauto = $auto[$rij->soort];
echo '<tr>';
echo '<td width="250" class="mainTxt">' . $rij->id . '</td>';
echo '<td width="250" class="mainTxt"><a href="#" onmouseover="return overlib(\'' . $soortauto . '\'); ">' . $soortauto . '</a></td>';
echo '<td width="250" class="mainTxt">' . $rij->schade . '</td>';
echo '<td width="150" class="mainTxt">' . $rij->land . '</td>';
echo '<td width="250" class="mainTxt">' . $rij->waarde . '</td>';
echo '<td width="250" class="mainTxt">actie2</td>';
echo '</tr>';
}
?>
werkt en wat het doet ( leer ik er ook nog van
