[SUCHE] Preisliste [SUCHE]

<?php

require_once('./data_classes/server-data.php_data_classes-core.php.php');

$pagename = "Preisliste";

$pageid = "36";

require_once('./templates/community_subheader.php');

require_once('./templates/community_header.php');

$page['id'] = "rares";

$page['name'] = "Rare Werte";

$page['bodyid'] = "home";

$page['cat'] = "credits";

require_once('./templates/community_header.php');

if(isset($_POST['catgo'])){

if($_POST['cats'] == '' OR empty($_POST['cats']))

{

echo '<meta http-equiv="refresh" content="0; URL=werte.php">';

} else {

echo '<meta http-equiv="refresh" content="0; URL=werte.php?cat='.$_POST['cats'].'">';

}

}

?>

<div id="container">

<div id="content" style="position: relative; left: 0px; top: 0px; width: 83%;" class="clearfix">

<div class="habblet-container ">

<div class="cbb clearfix notitle ">

<div id="credits-safety" class="box-content credits-info">

<div class="credit-info-text clearfix">

<h2 class="title">Rare Preisliste

</h2>

<div class="habblet box-content">

Hier ist eine Liste mit allen Rare Werten vom Hotel. Scroll mit der Maus
runter um die Rares und die Werte zu sehen!.<br><br>

<table width="100%" border="0">

<tr>

<td width="15%" style="text-align:center"><b>Bild</b></td>

<td width="35%" style="text-align:left"><b>Rare Name</b></td>

<td width="20%" style="text-align:center"><b>Wert</b></td>

</tr>

<br />

<?php

// Kategorien

// Kategorien auslesen

$kats = mysql_query("SELECT * FROM preisliste_cats ORDER BY id");

echo '<form action="" method="post"><select name="cats"
style="margin-right: 5px;"><option value="">Letzte
Änderungen</option>

';

while($row = mysql_fetch_array($kats))

{

echo '<option value="'.$row['id'].'">'.$row['cat_name'].'</option>';

}

echo '</select><input name="catgo" type="submit" class="catgo" value="Los" /></form>';

//$result = mysql_query("SELECT * FROM preisliste_furnis");

$result = mysql_query("SELECT * FROM preisliste_furnis WHERE category = '$_GET[cat]'");

while ($row = mysql_fetch_array($result)){

echo '<tr>

<td width="15%"
style="text-align:center;background-color:#f5f5f5;"><img alt=""
src="moebel/'.$row['image'].'"></td>

<td width="35%" style="text-align:left;background-color:#f5f5f5">'.$row['name'].'</td>

<td width="20%" style="text-align:center;background-color:#f5f5f5">'.$row['wert'].' Taler</td>

</tr>';

}

?>

</table>

</div>

</div>

</div>

<script type="text/javascript">if
(!$(document.body).hasClassName('process-template')) { Rounder.init();
}</script>

</div>

<div id="column2" class="column">

<div class="habblet-container ">

</div>

<script type="text/javascript">

HabboView.run();

</script>

<?php require_once('./templates/community_footer.php'); ?>

<br /><br />

DROP TABLE IF EXISTS `preisliste_cats`;

CREATE TABLE `preisliste_cats` (

`id` int(10) NOT NULL AUTO_INCREMENT,

`cat_name` varchar(20) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `preisliste_furnis`;

CREATE TABLE `preisliste_furnis` (

`id` int(10) NOT NULL AUTO_INCREMENT,

`name` varchar(25) NOT NULL,

`wert` int(25) NOT NULL,

`image` varchar(50) NOT NULL,

`category` int(50) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;