PHPhulp.nl
35k+ leden Over PHPhulp Offerte opdracht Contact
t

bezig met een garage

Door thymen akker op 09-02-2009 22:47
2.157 views
hey allemaal ik ben bezig met een criminals script en ben bezig met garage her scripten maar ik kan mijn tabellen niet uit de dB lezen ik kom er gewoon niet meer uit

kunnen jullie mij helpen ?


garage.php

<?

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}'");


?>
<head> 
<title>The Sicilians</title>
<script language="JavaScript" src="overlib.js"></script>
<link rel="stylesheet" type="text/css" href="css.css">



</head>




<table width=100%>
   </table>
  <center><table>

<tr><td align="center" class="subTitle" width=5><b><center>Id</td>
<td   class="subTitle" width=35%><b>Voertuig</td>
<td   class="subTitle" width=30%><b>Schade</td>
<td   class="subTitle" width=150><b>Stad</td>
<td   class="subTitle" width=30%><b>Prijs</td>
<td   class="subTitle" width=30%><b>Actie</td>
</tr>



<?php

$gegevens = mysql_query("SELECT * FROM `auto` WHERE `owner`='$data->login'");
while($rij = mysql_fetch_object($gegevens)) { 
$auto = 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 = $auto[$rij->soort];
$id1	=	mysql_query("SELECT * FROM `[auto]`(soort,schade,owner,land) values('$geld','$schade','$data->login','$data->land')");


echo("<td width=\"250\" class=\"mainTxt\">$id1</td>");
echo("<td width=\"250\" class=\"mainTxt\"><a href=\"#\"onmouseover=\"return overlib('$soortauto');   \">$soortauto</td></td>");
echo("<td width=\"250\" class=\"mainTxt\">$schade%</td>");
echo("<td width=\"150\" class=\"mainTxt\">$landauto</td>");
echo("<td width=\"250\" class=\"mainTxt\">$geld</td>");
echo("<td width=\"250\" class=\"mainTxt\">actie2</td>");
echo("</tr>");
 
}

?> 
</table></center>
</body>
</html>

dB

--
-- Tabel structuur voor tabel `auto`
--

CREATE TABLE IF NOT EXISTS `auto` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `soort` int(3) NOT NULL DEFAULT '0',
  `schade` int(3) NOT NULL DEFAULT '0',
  `owner` varchar(255) NOT NULL DEFAULT '',
  `land` int(10) NOT NULL DEFAULT '1',
  `fast` varchar(20) NOT NULL DEFAULT '',
  `verkoop` varchar(255) NOT NULL DEFAULT '',
  `tekoop` varchar(255) NOT NULL DEFAULT '',
  `waarde` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10812 ;

--
-- Gegevens worden uitgevoerd voor tabel `auto`
--

INSERT INTO `auto` (`id`, `soort`, `schade`, `owner`, `land`, `fast`, `verkoop`, `tekoop`, `waarde`) VALUES
(10811, 27, 90, 'Admin', 6, '', 'garage.php?p=27', '', '0'),
(10810, 37, 83, 'Admin', 6, '', 'garage.php?p=37', '', '0'),
(10809, 16, 0, 'Admin', 6, '', 'garage.php?p=16', '', '0'),
(10808, 17, 8, 'Admin', 6, '', 'garage.php?p=17', '', '0'),
(10807, 18, 5, 'Admin', 6, '', 'garage.php?p=18', '', '0'),
(10806, 3, 46, 'Admin', 6, '', 'garage.php?p=3', '', '0'),
(10804, 11, 34, 'Admin', 5, '', 'garage.php?p=11', '', '0'),
(10803, 2, 13, 'Admin', 5, '', 'garage.php?p=2', '', '0'),
(10802, 33, 44, 'Admin', 5, '', 'garage.php?p=33', '', '0'),
(10801, 19, 61, 'Admin', 5, '', 'garage.php?p=19', '', '0'),
(10800, 33, 99, 'Admin', 5, '', 'garage.php?p=33', '', '0'),
(10799, 1, 0, 'Admin', 5, '', 'garage.php?p=1', '', '0'),
(10798, 30, 61, 'Admin', 5, '', 'garage.php?p=30', '', '0'),
(10796, 13, 70, 'Admin', 5, '', 'garage.php?p=13', '', '0'),
(10795, 26, 30, 'Admin', 5, '', 'garage.php?p=26', '', '0'),
(10794, 0, 90, 'Admin', 5, '', 'garage.php?p=0', '', '0'),
(10793, 26, 77, 'Admin', 5, '', 'garage.php?p=26', '', '0'),
(10792, 4, 21, 'Admin', 5, '', 'garage.php?p=4', '', '0'),
(10791, 22, 37, 'Admin', 5, '', 'garage.php?p=22', '', '0'),
(10790, 26, 1, 'Admin', 5, '', 'garage.php?p=26', '', '0'),
(10789, 36, 87, 'Admin', 5, '', 'garage.php?p=36', '', '0'),
(10788, 14, 1, 'Admin', 5, '', 'garage.php?p=14', '', '0'),
(10787, 27, 73, 'Admin', 5, '', 'garage.php?p=27', '', '0'),
(10786, 23, 48, 'Admin', 5, '', 'garage.php?p=23', '', '0'),
(10785, 16, 93, 'Admin', 5, '', 'garage.php?p=16', '', '0'),
(10784, 1, 0, 'Admin', 5, '', 'garage.php?p=1', '', '0'),
(10783, 15, 78, 'Admin', 5, '', 'garage.php?p=15', '', '0'),
(10782, 11, 1, 'Admin', 5, '', 'garage.php?p=11', '', '0'),
(10781, 26, 2, 'Admin', 5, '', 'garage.php?p=26', '', '0'),
(10780, 8, 26, 'Admin', 5, '', 'garage.php?p=8', '', '0'),
(10779, 28, 17, 'Admin', 5, '', 'garage.php?p=28', '', '0');

alvast bedankt,
groetjes Thymen
t
thymen akker
10-02-2009 01:26
ja layout met photoshop die vind ik zelf wel strak

ja de autos die in de garage zitten van $data->login
- SanThe -
10-02-2009 01:30
Dit heb jij niet zelf gemaakt neem ik aan.
Maar hoe dan ook, ik ga nu lekker pitten.
Zie je vast wel weer.
Slaap ze.
t
thymen akker
10-02-2009 01:30
lay-out zelf rest ( scripts) ben ik aan het veranderen ;)
ik ga ook slaapzucht xD
alsnog bedankt voor alles
t
thymen akker
10-02-2009 11:46
SanThe
zou je mij mischien nog 1 keer willen helpen?

ik heb nu dit:


<?php
ini_set('display_errors', 1); // 0 = uit, 1 = aan
error_reporting(E_ALL);

include("connect.php");
if(! check_login())
{
    header("Location: login.php");
    exit;
}
include("ban.php");
include("jail.php");
include("dood.php");
include("time.php");

$sql = "UPDATE users SET online = NOW() WHERE login = '" . $data->login . "'";
$res = mysql_query($sql);
if(!$res)
{
    // maak hier een errorafhandeling: query is mislukt
}
?>

<head> 
<title>The Sicilians</title>
<script language="JavaScript" src="overlib.js"></script>
<link rel="stylesheet" type="text/css" href="css.css">
</head>

<table width=100%>
</table><center>

<table>
    <tr>
        <td align="center" class="subTitle" width="5"><b><center>Id</td>
        <td class="subTitle" width="35%"><b>Voertuig</td>
        <td class="subTitle" width="30%"><b>Schade</td>
        <td class="subTitle" width="150"><b>Stad</td>
        <td class="subTitle" width="30%"><b>Prijs</td>
        <td class="subTitle" width="30%"><b>Actie</td>
    </tr>

<?php
$sql = "SELECT * FROM auto WHERE owner = '" . $data->login . "'";
$res = mysql_query($sql);
if(!$res)
{
    // maak hier een errorafhandeling: query is mislukt
}
$auto = 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");
$stad = array("","Groningen","Amsterdam","Rotterdam","Eindhoven","Maastricht","Nijmegen",""); 
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="" onmouseout="return overlib("")"; onclick="return overlib(\'<img src=images/cars/$geld9.gif border=0>\'); ">' . $soortauto . '</a></td>';
        echo '<td width="250" class="mainTxt">' . $rij->schade . '%</td>';
        echo '<td width="150" class="mainTxt">' . $stad[$rij->land] . '</td>';
        echo '<td width="250" class="mainTxt">' . $rij->waarde . '</td>';
        echo '<td width="250" class="mainTxt">actie2</td>';
    echo '</tr>';
}
?> 

</table></center>
</body>
</html>



er zit een java script je in met als je op een auto klikt dat er een tabelletje komt in dat tabelletje moet de auto(plaatje) komen te staan

ik had geprobeert met een str_replace(' ', '_', $auto);

maar ik krijg de plaatjes niet te zien

een "Harley Davidson " = in de dir images/cars/Harley_Davidson.gif

(sorry voor de lange post
Gr Thymen

*edit*

wat vond je eigenlijk van mijn Css?
en div`s van de lay-out

Reageren

Inloggen om te reageren