$wieviele = "4";

echo '<div id="preisliste_logo"> </div>';
if(!isset($_GET['detail']))
{
    $select_all_furni = "SELECT id, name, cat, img, mimg FROM ".$prefix."pricelist_furni ORDER BY id DESC LIMIT ".$wieviele."";
    $select_all_furni = mysql_query($select_all_furni);

    if(mysql_num_rows($select_all_furni) != 0)
    {
        echo "<div width=\"100%\" style=\"align: center\">";
        while($furni = mysql_fetch_assoc($select_all_furni))
        {
            $get_price_query = "SELECT price FROM ".$prefix."pricelist_price WHERE furni_id = '".$furni['id']."' ORDER BY time DESC LIMIT 0, 1";
            $get_price_query = mysql_query($get_price_query);
            $price = mysql_fetch_assoc($get_price_query);
            $price = $price['price'];
            echo "\n";
            echo "<div class=\"furni_box\" style=\"background-image: url(".$furni['img'].");\" id=\"1467\" ontouchstart=\"showHiddenDiv('det_1467');\"><center><img onmouseover=\"Tip('".$furni['name']."')\" onmouseout=\"UnTip()\" style=\"width: auto; height: auto;\"  /><div id=\"det_1467\" class=\"furni_details\" ontouchstart=\"window.location.href='index.php?site=48&dfurni=1467';\">
<table cellpadding=\"2\" cellspacing=\"3\" width=\"100%\">
                <tr>
                 <td valign=\"top\" align=\"center\" width=\"36\" height=\"36\"><img src=\"".$furni['mimg']."\" /></td>
<td class=\"furni_details_name\"><b>".$furni['name']."</b><br><i>".$furni['cat']."</i></td>
                </tr>
<tr>
                 <td align=\"center\" valign=\"top\"><img src=\"uploads/buy_price.gif\"></td>
                 <td class=\"text_left_middle\">$furni[buyprice] Taler + 0 Pixel </td>
                </tr>
</table></div>
<div class=\"price_tag\">".$price."</div></center></div>";

        }
        echo '</div>';
    }
    else
    {
        echo "<center>Leider sind keine Möbel verfügbar!</center>";
    }
}
else
{
    $furni_id = (int) $_GET['detail'];
    $get_furni_info = "SELECT id, name, img, cat FROM ".$prefix."pricelist_furni WHERE id = '".$furni_id."'";
    $get_furni_info = mysql_query($get_furni_info);

    if(mysql_num_rows($get_furni_info) == 1)
    {
        $furni = mysql_fetch_assoc($get_furni_info);
        ?>
            <div style="background-color: #666; height: 200px; width: 200px; float:left">
              <center>
              <img style="height: 200px; width: 150px;" src="<?php echo $furni['img']; ?>" />
            </center></div>
            <div style="float: left;">

            Name des M&ouml;bels: <?php echo $furni['name']; ?><br /><br />
            Kategorie: <?php echo $furni['cat'] ?><br /><br /><?php

            $get_latest_price = "SELECT price, time FROM ".$prefix."pricelist_price WHERE furni_id = '".$furni['id']."' ORDER BY time DESC LIMIT 0 , 1";
            $get_latest_price = mysql_query($get_latest_price);

            $latest_price = mysql_fetch_assoc($get_latest_price);

            $update_day = date("d.m.Y", $latest_price['time']);
                $update_time = date("H:i", $latest_price['time']);

            ?>Aktueller Preis: <?php echo $latest_price['price']; ?> Taler (Letztes Update: <?php echo $update_day." : ".$update_time; ?>)<br  /><br />
            <span style="cursor:pointer; color:#00F; text-decoration: underline;" onclick="spoil('preishistorie');">Preishistorie</span><br /><br />
            <br /><br /><br />

            <div id="preishistorie" style="display:none;" align="center">
            <h2><center>Preishistorie</center></h2><?php

            $select_all_prices = "SELECT price, time FROM ".$prefix."pricelist_price WHERE furni_id = '".$furni['id']."' ORDER BY time DESC";
            $select_all_prices = mysql_query($select_all_prices);

            echo "<ul>";

            //Zeige Voting!

            $get_voting = "SELECT id
                FROM ".$prefix."pricelist_changes
                WHERE furni_id = '".$furni['id']."'
                AND visible = '1'";
            $get_voting = mysql_query($get_voting);


            if(mysql_num_rows($get_voting) == 1)
            {
                echo "<li><strong>Eine &Auml;nderung des Preises wird derzeit diskutiert!</strong></li>";

            }
            echo mysql_error();


            while($row = mysql_fetch_assoc($select_all_prices))
            {
                $this_update_day = date("d.m.Y", $row['time']);
                    $this_update_time = date("H:i", $row['time']);

                    echo "<li>".$this_update_day." : ".$this_update_time." - ".$row['price']." Taler</li>";

                }

                echo "</ul>";




            ?>

            </div>
            <h2><center>Diskussion</center></h2>

            <?php

            $ugb = new kommentar("preisliste_diskussion_".$_GET['id']);
                $ugb->draw();

            ?></div>

            <?php
    }
    else
    {
        echo "Nicht valides Möbelstück!";
    }
}

echo"<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />
<!-- Preisliste von jantede12 edited by SchokoBrunnen --> ";