public function RareAuktion() {
        global $mysqli, $Mus;
        echo '<div class="box">';
        echo '<b>Rare Auktion</b>';
        if (Hotel::getSettings('wartungsarbeiten') == '1') {
            return 'RareAuktion ist deaktiviert, da Wartungsarbeiten sind!';
        } else {

            $auktion_sql = $mysqli->query("SELECT * FROM hp_auktion WHERE timestamp_end < '" . time() . "' AND status = '1'");
            while ($row = $auktion_sql->fetch_object()) {

                $rare_sql = $mysqli->query("SELECT * FROM hp_auktion_rares WHERE id = '" . $row->item_id . "' LIMIT 1");
                if ($rare_sql->num_rows > 0) {
                    $rare = $rare_sql->fetch_object();


                    switch ($rare->currency) {
                        case 'credits';
                            $auktiondesc = array("name" => 'Taler');
                            $wertc = "credits";
                            break;

                        case 'pixels':
                            $auktiondesc = array("name" => 'Pixel');
                            $wertc = "activity_points";
                            break;

                        case 'sterne':
                            $auktiondesc = array("name" => 'Sterne');
                            $wertc = "vip_points";
                            break;
                    }


                    $getallwinners = $mysqli->query("SELECT * FROM hp_auktion_offers WHERE auktion_id = '" . $row->id . "' ORDER by count DESC limit 20");
                    $i = 0;
                    $winnerfound = 0;

                    while ($winners = $getallwinners->fetch_object()) {
                        $i++;
                        if ($winnerfound == 0) {

                            $winner = new User($winners->user_id);

                            if ($winner->$wertc >= $winners->count) {
                                $winnerfound = 1;

                                Staff::hklogs('winner_credits_before', $winner->$wertc);

                                $mysqli->query("UPDATE users SET $wertc = $wertc-$winners->count WHERE id = '" . $winner->id . "' ");


                                $config->getarray[1] = 'cronjob';
                                Staff::hklogs('winner_give_credits', $winner->id);

                                $Mus->send('giveitem', $winner->id . ' ' . $rare->item_id . ' Das von dir gewonnene Rare der Auktion mit der Nummer ' . $row->id . '. Viel Spaß!');
                                Staff::hklogs('winner_send_rare', 'giveitem, ' . $winner->id . ' ' . $rare->item_id . ' [text]');
                                $winner->sendNotification('Rare Auktion', 'Herzlichen Glückwunsch! Du hast bei der Auktion mit der Nummer: ' . $row->id . ' gewonnen! Mehr Infos findest du auf der Home.', "", true, true, true);
                                Staff::hklogs('winner_send_message', $winner->id);


                                $Mus->send('updatepoints', $winner->id);
                                $Mus->send('updatepixels', $winner->id);
                                $Mus->send('updatecredits', $winner->id);
                                Staff::hklogs('winner_update_mus', $winner->id);


                                $mysqli->query("UPDATE hp_auktion_rares SET available = available-1 WHERE id = '" . $row->item_id . "' ");
                                Staff::hklogs('winner_updateauktionrarestable', $winner->id);
                                $mysqli->query("UPDATE hp_auktion SET status = '2', sell_id = '" . $winner->id . "' WHERE id = '" . $row->id . "' ");
                                Staff::hklogs('winner_updatehpauktiontableset2', $winner->id);
                                echo 'Gewinner: ' . $winners->user_id . '<br>';
                            } else {
                                if ($i == 1) {
                                    $tenprocent = ($winners->count / 100) * 10;

                                    $mysqli->query("UPDATE users SET $wertc = $wertc-$tenprocent WHERE id = '" . $winner->id . "' ");

                                    $winner->sendNotification('Rare Auktion', 'Da ist wohl etwas schief gelaufen! Du hattest nicht genug ' . $auktiondesc['name'] . ' für die Auktion. Mehr Infos findest du auf deiner Home!', "", true, true, true);

                                    echo 'User hatte zu wenig Money: ' . $winner->id . '<br>';
                                    $config->getarray[1] = 'cronjob';

                                    Staff::hklogs('winner_not_found_tolowmoney', $winner->id);
                                }
                            }
                        }
                    }
                }
            }

            $getlastrare_sql = $mysqli->query("SELECT * FROM hp_auktion WHERE timestamp_end > '" . time() . "' AND status = '1' ");
            $getlastrare = $getlastrare_sql->fetch_object();
            if ($getlastrare_sql->num_rows < 1) {

                $getrand = $mysqli->query("SELECT * FROM hp_auktion_rares WHERE available > 0 AND id NOT LIKE '" . $getlastrare->item_id . "' ORDER BY RAND() LIMIT 1");


                if ($getrand->num_rows > 0) {
                    $newid = $getrand->fetch_object();

                    $mysqli->query("INSERT INTO hp_auktion (item_id, timestamp_beginn, timestamp_end, status) VALUES ('" . $newid->id . "', '" . strtotime(date('d.m.Y H:i')) . "', '" . strtotime(date('d.m.Y', time() + 86400) . ' 20:00') . "', '1') ");
                    Staff::hklogs('winner_setnerareauktion', $winner->id);
                    echo 'Neues Rare wurde verteilt!<br>';
                } else {
                    $offline = 'true';
                }
            } else {
                echo 'Fehler! Konnte kein neues Rare-Auktion erstellt werden, da die aktuelle noch läuft!';
            }
        }
        echo '</div>';
    }