(CentenaryCMS) News Prefix/Umlaute Problem

Romi090312

Hey Retrotowner

Habe ein kleiner Problem und hoffe, dass einer von euch mir da eine Lösung für hat.

Wenn ich beim CentenaryCMS eine News schreibe und darin ö ä ü etc. verwende werden diese nicht richtig angezeigt sondern irgendwie so: (ae)

Weiss jemand, wie man das beheben kann, dass ich auch diese Umlaute benutzen kann?

Danke im Voraus!

NoOne.

Code

<meta charset="utf-8" />

Füg das in deiner .php einfach ganz oben ein, dann sollte es klappen. (Falls das nicht helfen sollte, füg das auch ins Housekeeping ein.)

Romi090312

Zitat von NoOne.
Code
...

Habe es, wie du gesagt hast, bei beiden Dateien ganz oben eingefügt.

Das sind die ersten Zeilen des Codes der News.php (Homepage):

Code

...

Und das von der News.php (Housekeeping):

Code

...

Allerdings hat dies nichts geändert.

FOREX

Ich hatte das selbe Problem, du musst das im Ordner suchen da sollten mehrere Zeilen auftauchen mit den Umlauten, ich weiss auch nicht was sich der Coded dabei gedacht hat. Lösche dann diese Zeilen und füge wie NoOne sagte den Charset Code in die php Datei ein.

Sollte danach klappen.

**F4ncy**

meinst du diesen Code?

PHP

<?php


/*
 *   ___         _                           ___ __  __ ___ 
 *  / __|___ _ _| |_ ___ _ _  __ _ _ _ _  _ / __|  \/  / __|
 * | (__/ -_) ' \  _/ -_) ' \/ _` | '_| || | (__| |\/| \__ \
 *  \___\___|_||_\__\___|_||_\__,_|_|  \_, |\___|_|  |_|___/
 *                                     |__/                 
 * *************************                       
 * Content: CentenaryCMS
 * Autor  : Revue
 * Contact: me@revue-projects.at
 */


function getServerCount($string) {
    global $mysqli;


    switch ($string) {
        case 'users':
            $string = 'users_online';
            break;


        case 'rooms':
            $string = 'rooms_loaded';
            break;


        case 'stamp':
            $string = 'stamp';
            break;


        case 'server_started':
            $string = 'server_started';
            break;


        default:
            $string = '';
            break;
    }


    $sql = $mysqli->query("SELECT * FROM server_status");
    $row = $sql->fetch_object();


    return $row->$string;
}


function getServerstats($string) {
    global $mysqli;


    $sql = $mysqli->query("SELECT * FROM system_stats");
    $row = $sql->fetch_object();


    return $row->$string;
}


function pagetitle($title) {
    global $user;


    $title = protect($title);


    $title = str_replace("%username%", $user->username, $title);


    return $title;
}


function sendmail($empfaenger, $betreff, $text) {
    $empfaenger = $empfaenger;
    $betreff = $betreff;


    $header = 'MIME-Version: 1.0' . "\r\n";
    $header .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    $header .= 'From: Habbo Hotel <info@habbo.tl>' . "\r\n";


    mail($empfaenger, $betreff, $text, $header);
}


function MitarbeiterTable($user_id, $string) {
    global $mysqli;


    $user_id = protect($user_id);
    $string = protect($string);


    $sql = $mysqli->query("SELECT * FROM hp_mitarbeiter WHERE user_id = '" . $user_id . "' ");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();


        return $row->$string;
    } else {
        return '0';
    }
}


function getSettings($string) {
    global $mysqli;


    $string = protect($string);


    $sql = $mysqli->query("SELECT * FROM hp_settings LIMIT 1");


    $row = $sql->fetch_object();


    return $row->$string;
}


function umlaute($text, $noprotect = false) {
    if ($noprotect == false) {
        $text = protect($text);
    }


    $text = str_replace("Ă¤", "ä", $text);
    $text = str_replace("Ăź", "ü", $text);
    $text = str_replace("ü", "ü", $text);
    $text = str_replace("Ăś", "ö", $text);


    $text = str_replace("?Â", "ß", $text);
    return $text;
}


function umlautenew($string) {
    $string = $string;


    $string = str_replace("ü", "{ue}", $string);
    $string = str_replace("Ü", "{UE}", $string);
    $string = str_replace("ä", "{ae}", $string);
    $string = str_replace("Ä", "{AE}", $string);
    $string = str_replace("ö", "{oe}", $string);
    $string = str_replace("Ö", "{OE}", $string);
    $string = str_replace("ß", "{ss}", $string);
    $string = str_replace("&", "{uu}", $string);
    $string = str_replace("'", "{ho}", $string);
    $string = str_replace('"', "{hh}", $string);
    $string = str_replace("¶", "{u1}", $string);
    $string = str_replace("¢", "{u2}", $string);
    $string = str_replace("*", "{u3}", $string);
    $string = str_replace("≠", "{u4}", $string);
    $string = str_replace("¿", "{u5}", $string);
    $string = str_replace("‚", "{u6}", $string);
    $string = str_replace("‘", "[u7}", $string);
    $string = str_replace("€", "{u8}", $string);
    $string = str_replace("$", "{u9}", $string);




    return $string;
}


function Umlautefix($text, $noprotect = false) {
    if ($noprotect == false) {
        $text = protect($text);
    }


    $text = htmlentities($text);
    return $text;
}


function shitumlaute($string) {
    $string = str_replace("ä", "&auml;", $string);
    $string = str_replace("&Atilde;&frac14;", "ü", $string);


    return $string;
}


function protect($string, $output = false) {
    $string = str_replace("'", "", $string);
    $string = strip_tags($string);


    if ($output == false) {
        $string = Umlautefix($string, 'no-proect');
    }


    return utf8_encode($string);
}


function pwhash($string) {
    $string = protect($string);
    $verschlusselung = 'XX8402u7NF.TL.85929!FASDJ4FU!A\\//adgkl4hsfkasdfhas,l54jk';


    $pw = md5(md5(md5($string) . $verschlusselung));
    return $pw;
}


function getRanks($string, $what) {
    global $mysqli, $user;
    $sql = $mysqli->query("SELECT * FROM ranks WHERE id = '" . $string . "' ");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        return $row->$what;
    }
}


function getSiteManager($id, $string) {
    global $mysqli;


    $id = protect($id);
    $string = protect($string);


    $sql = $mysqli->query("SELECT * FROM hp_pages WHERE id = '" . $id . "' ");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();


        return $row->$string;
    }
}


function getNaviManager($id, $string) {
    global $mysqli;


    $id = protect($id);
    $string = protect($string);




    $sql = $mysqli->query("SELECT * FROM hp_navi WHERE id = '" . $id . "' ");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();


        return $row->$string;
    }
}


function getRoom($id, $string) {
    global $mysqli;


    $id = protect($id);
    $string = protect($string);


    $sql = $mysqli->query("SELECT * FROM rooms WHERE id = '" . $id . "' LIMIT 1");


    $row = $sql->fetch_object();


    return $row->$string;
}


function getRoomModel($roomid) {
    global $mysqli;


    $id = protect($roomid);
    $sql = $mysqli->query("SELECT * FROM rooms WHERE id = '" . $id . "' LIMIT 1");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();


        $search = $mysqli->query("SELECT * FROM room_models WHERE id = '" . $row->model_name . "' ");
        if ($search->num_rows > 0) {
            $srow = $search->fetch_object();


            return $srow->heightmap;
        } else {
            return 'NO Model Found';
        }
    } else {
        return 'No Room Found';
        exit;
    }
}


function Habbohash($textt, $type) {
    switch ($type) {
        case('ver'):
            $text = str_replace("A", "9/", $textt);
            $text = str_replace("B", "8/", $text);
            $text = str_replace("C", "7/", $text);
            $text = str_replace("D", "6/", $text);
            $text = str_replace("E", "5/", $text);
            $text = str_replace("F", "4/", $text);
            $text = str_replace("G", "3/", $text);
            $text = str_replace("H", "2/", $text);
            $text = str_replace("I", "1/", $text);
            $text = str_replace("J", "0/", $text);
            $text = str_replace("K", "+/", $text);
            $text = str_replace("L", "*/", $text);
            $text = str_replace("M", "ďż˝/", $text);
            $text = str_replace("N", "%/", $text);
            $text = str_replace("O", "&/", $text);
            $text = str_replace("P", "~/", $text);
            $text = str_replace("Q", "(/", $text);
            $text = str_replace("R", ")/", $text);
            $text = str_replace("S", ":/", $text);
            $text = str_replace("T", "_/", $text);
            $text = str_replace("U", "ďż˝/", $text);
            $text = str_replace("V", "#/", $text);
            $text = str_replace("W", "ďż˝/", $text);
            $text = str_replace("X", "ďż˝/", $text);
            $text = str_replace("Y", "ďż˝/", $text);
            $text = str_replace("Z", "|/", $text);
            $text = str_replace("a", "9>", $text);
            $text = str_replace("b", "8>", $text);
            $text = str_replace("c", "7>", $text);
            $text = str_replace("d", "6>", $text);
            $text = str_replace("e", "5>", $text);
            $text = str_replace("f", "4>", $text);
            $text = str_replace("g", "3>", $text);
            $text = str_replace("h", "2>", $text);
            $text = str_replace("i", "1>", $text);
            $text = str_replace("j", "0>", $text);
            $text = str_replace("k", "+>", $text);
            $text = str_replace("l", "*>", $text);
            $text = str_replace("m", "ďż˝>", $text);
            $text = str_replace("n", "%>", $text);
            $text = str_replace("o", "&>", $text);
            $text = str_replace("p", "~>", $text);
            $text = str_replace("q", "(>", $text);
            $text = str_replace("r", ")>", $text);
            $text = str_replace("s", ":>", $text);
            $text = str_replace("t", "_>", $text);
            $text = str_replace("u", "ďż˝>", $text);
            $text = str_replace("v", "#>", $text);
            $text = str_replace("w", "ďż˝>", $text);
            $text = str_replace("x", "ďż˝>", $text);
            $text = str_replace("y", "ďż˝>", $text);
            $text = str_replace("z", "|>", $text);
            $text = str_replace("@", "ďż˝<", $text);
            $text = str_replace(" ", "ďż˝<", $text);
            return base64_encode(base64_encode($text));
            break;


        case('ent'):
            $textt = base64_decode(base64_decode($textt));
            $text = str_replace("9/", "A", $textt);
            $text = str_replace("8/", "B", $text);
            $text = str_replace("7/", "C", $text);
            $text = str_replace("6/", "D", $text);
            $text = str_replace("5/", "E", $text);
            $text = str_replace("4/", "F", $text);
            $text = str_replace("3/", "G", $text);
            $text = str_replace("2/", "H", $text);
            $text = str_replace("1/", "I", $text);
            $text = str_replace("0/", "J", $text);
            $text = str_replace("+/", "K", $text);
            $text = str_replace("*/", "L", $text);
            $text = str_replace("ďż˝/", "M", $text);
            $text = str_replace("%/", "N", $text);
            $text = str_replace("&/", "O", $text);
            $text = str_replace("~/", "P", $text);
            $text = str_replace("(/", "Q", $text);
            $text = str_replace(")/", "R", $text);
            $text = str_replace(":/", "S", $text);
            $text = str_replace("_/", "T", $text);
            $text = str_replace("ďż˝/", "U", $text);
            $text = str_replace("#/", "V", $text);
            $text = str_replace("ďż˝/", "W", $text);
            $text = str_replace("ďż˝/", "X", $text);
            $text = str_replace("ďż˝/", "Y", $text);
            $text = str_replace("|/", "Z", $text);
            $text = str_replace("9>", "a", $text);
            $text = str_replace("8>", "b", $text);
            $text = str_replace("7>", "c", $text);
            $text = str_replace("6>", "d", $text);
            $text = str_replace("5>", "e", $text);
            $text = str_replace("4>", "f", $text);
            $text = str_replace("3>", "g", $text);
            $text = str_replace("2>", "h", $text);
            $text = str_replace("1>", "i", $text);
            $text = str_replace("0>", "j", $text);
            $text = str_replace("+>", "k", $text);
            $text = str_replace("*>", "l", $text);
            $text = str_replace("ďż˝>", "m", $text);
            $text = str_replace("%>", "n", $text);
            $text = str_replace("&>", "o", $text);
            $text = str_replace("~>", "p", $text);
            $text = str_replace("(>", "q", $text);
            $text = str_replace(")>", "r", $text);
            $text = str_replace(":>", "s", $text);
            $text = str_replace("_>", "t", $text);
            $text = str_replace("ďż˝>", "u", $text);
            $text = str_replace("#>", "v", $text);
            $text = str_replace("ďż˝>", "w", $text);
            $text = str_replace("ďż˝>", "x", $text);
            $text = str_replace("ďż˝>", "y", $text);
            $text = str_replace("|>", "z", $text);
            $text = str_replace("ďż˝<", "@", $text);
            $text = str_replace("ďż˝<", " ", $text);
            return $text;
            break;
    }
}


function mottosymbole($text) {
    $text = protect($text);
    $text = str_replace("|", "&#x2665;", $text);
    $text = str_replace("<3", "&#x2665;", $text);
    return $text;
}


function getDays($id) {
    $full_day = $id;
    if ($full_day == "1") {
        $date = "Montag";
    }
    if ($full_day == "2") {
        $date = "Dienstag";
    }
    if ($full_day == "3") {
        $date = "Mittwoch";
    }
    if ($full_day == "4") {
        $date = "Donnerstag";
    }
    if ($full_day == "5") {
        $date = "Freitag";
    }
    if ($full_day == "6") {
        $date = "Samstag";
    }
    if ($full_day == "0") {
        $date = "Sonntag";
    }


    return $date;
}


function getMonth($id) {
    $full_m = $id;


    if ($full_m == "1") {
        $datex = "Januar";
    }
    if ($full_m == "2") {
        $datex = "Februar";
    }
    if ($full_m == "3") {
        $datex = "März";
    }
    if ($full_m == "4") {
        $datex = "April";
    }
    if ($full_m == "5") {
        $datex = "Mai";
    }
    if ($full_m == "6") {
        $datex = "Juni";
    }
    if ($full_m == "7") {
        $datex = "Juli";
    }
    if ($full_m == "8") {
        $datex = "August";
    }
    if ($full_m == "9") {
        $datex = "September";
    }
    if ($full_m == "10") {
        $datex = "Oktober";
    }
    if ($full_m == "11") {
        $datex = "November";
    }
    if ($full_m == "12") {
        $datex = "Dezember";
    }


    return $datex;
}


function dateformatierung($time) {
    $time = protect($time);


    switch (date('d.m.Y', $time)) {


        case date('d.m.Y', strtotime("+1 day")):
            return 'Morgen </b>um<b> ' . date('H:i', $time);
            break;


        case(date('d.m.Y')):
            return 'Heute </b>um<b> ' . date('H:i', $time);
            break;


        case(date('d.m.Y', time() - 86400)):
            return 'Gestern </b>um<b> ' . date('H:i', $time);
            break;


        case(date('d.m.Y', time() - (86400 * 2))):
            return 'Vorgestern </b>um<b> ' . date('H:i', $time);
            break;


        default:
            return date('d.m.Y', $time) . '</b> um <b>' . date('H:i', $time);
            break;
    }
}


function getTime($time) {
    $time = protect($time);


    if ($time / 60 >= '1') {
        if (($time / 60) / 60 >= '1') {
            if ((($time / 60) / 60) / 24 >= '1') {
                if (((($time / 60) / 60) / 24) / 30 >= '1') {
                    if ((((($time / 60) / 60) / 24) / 30) / 12 >= '1') {


                        if ((((($time / 60) / 60) / 24) / 30) / 12 == '1') {
                            $beschreibung = 'Jahr';
                        } else {
                            $beschreibung = 'Jahren';
                        }


                        $time = round((((($time / 60) / 60) / 24) / 30) / 12);
                    } else {
                        if ((((($time / 60) / 60) / 24) / 30) == '1') {


                            $beschreibung = 'Monat';
                        } else {
                            $beschreibung = 'Monaten';
                        }


                        $time = round(((($time / 60) / 60) / 24) / 30);
                    }
                } else {


                    if (round((($time / 60) / 60) / 24) == '1') {
                        $beschreibung = 'Tag';
                    } else {
                        $beschreibung = 'Tagen';
                    }


                    $time = round((($time / 60) / 60) / 24);
                }
            } else {
                if (round(($time / 60) / 60) == '1') {
                    $beschreibung = 'Stunde';
                } else {
                    $beschreibung = 'Stunden';
                }


                $time = round(($time / 60) / 60);
            }
        } else {
            if (round($time / 60) == '1') {
                $beschreibung = 'Minute';
            } else {
                $beschreibung = 'Minuten';
            }


            $time = round($time / 60);
        }
    } else {
        if (round($time) == '1') {
            $beschreibung = 'Sekunden';
        } else {
            $beschreibung = 'Sekunden';
        }


        $time = round($time);
    }


    return $time . ' ' . $beschreibung;
}


function copyroom($roomid, $captionnew, $onwernew) {
    global $mysqli;
    $roomid = protect($roomid);
    $captionnew = protect($captionnew);
    $ownernew = protect($onwernew);


    $getroom = $mysqli->query("SELECT * FROM rooms WHERE id = '" . $roomid . "' ");
    if ($getroom->num_rows > 0) {
        $room = $getroom->fetch_object();
        $mysqli->query("INSERT INTO rooms (roomtype, caption, owner, description, category, state, users_now, users_max, model_name, password, allow_hidewall, wallthick, floorthick, wallpaper, floor, landscape)
	VALUES ('" . $room->roomtype . "', '" . $captionnew . "', '" . $onwernew . "', '" . $room->description . "', '" . $room->category . "', '" . $room->state . "', '0', '" . $room->users_max . "', '" . $room->model_name . "', '" . $room->password . "', '" . $room->allow_hidewall . "', '" . $room->wallthick . "', '" . $room->floorthick . "', '" . $room->wallpaper . "', '" . $room->floor . "', '" . $room->landscape . "') ");
        $newroom_sql = $mysqli->query("SELECT * FROM rooms WHERE caption = '" . $captionnew . "' AND owner = '" . $onwernew . "' ORDER BY id DESC LIMIT 1");
        if ($newroom_sql->num_rows > 0) {
            $newroom = $newroom_sql->fetch_object();
            $sql_get = $mysqli->query("SELECT * FROM items WHERE room_id = '" . $room->id . "'");
            if ($sql_get->num_rows > 0) {
                while ($row = $sql_get->fetch_object()) {
                    $sql = $mysqli->query("SELECT * FROM room_items_moodlight WHERE item_id = '" . $row->id . "' ");
                    if ($sql->num_rows < 1) {
                        $mysqli->query("INSERT INTO items (user_id, room_id, base_item, x, y, z, rot, wall_pos, copied_itemid, ltd_id, ltd_cnt, guild_data) VALUES
				('" . $row->user_id . "', '" . $newroom->id . "', '" . $row->base_item . "', '" . $row->x . "', '" . $row->y . "', '" . $row->z . "', '" . $row->rot . "', '" . $row->wall_pos . "', '" . $row->copied_itemid . "', '" . $row->ltd_id . "', '" . $row->ltd_cnt . "', '" . $row->guild_data . "') ");
                        MUS('update_catalogid');
                        $getitem_sql = $mysqli->query("SELECT * FROM items WHERE room_id = '" . $newroom->id . "' AND base_item = '" . $row->base_item . "' ORDER BY id DESC LIMIT 1");
                        $getitem = $getitem_sql->fetch_object();


                        $checkextra = $mysqli->query("SELECT * FROM items_extra_data WHERE item_id = '" . $row->id . "' ");
                        if ($checkextra->num_rows > 0) {
                            $extrada = $checkextra->fetch_object();
                            $mysqli->query("INSERT INTO items_extra_data (item_id, extra_data) VALUES ('" . $getitem->id . "', '" . $extrada->extra_data . "')");
                            MUS('update_catalogid');
                        }
                    } else {

                    }
                }
            }
            MUS('update_catalogid');
            MUS('unloadroom', $newroom->id);
            echo $newroom->id;
        } else {
            exit;
        }
    } else {
        exit;
    }
}


function isfriend($id1, $id2) {
    global $mysqli;
    $id1 = protect($id1);
    $id2 = protect($id2);


    $search = $mysqli->query("SELECT * FROM messenger_friendships WHERE user_one_id = '" . $id1 . "' AND user_two_id = '" . $id2 . "' LIMIT 1");
    if ($search->num_rows > 0) {
        return '1';
    } else {
        return '0';
    }
}


function getForumKategorie($id) {
    global $mysqli;


    $id = protect($id);


    $sql = $mysqli->query("SELECT * FROM hp_forum WHERE id = '" . $id . "' ");
    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        return $row->name;
    }
}


function getServerName($ip, $what) {
    $ip = protect($ip);


    switch ($ip) {
        case 'Server1':
        case '37.59.96.238':
            $x->name = 'Server <b>2</b>';
            $x->ip = '37.59.96.238';
            break;




        case 'Server2':
        case '46.105.17.53':
            $x->name = 'Server <b>2</b>';
            $x->ip = '92.222.146.46';
            break;


        case 'Server3':
        case 'c':
            $x->name = 'Server 3';
            $x->ip = '92.222.2.142';
            break;


        case 'Server4':
        case 'd':
            $x->name = 'Server 4';
            break;




        case '127.0.0.1':
            $x->name = 'Server Local';
            $x->ip = '127.0.0.1';
            break;


        default:
            header("location: http://Habbo.tl");
            exit;
            break;
    }


    return $x->$what;
}


function getServerStatus($ip, $port) {
    $starttime = microtime(true);
    $file = fsockopen($ip, $port, $errno, $errstr, 10);
    $stoptime = microtime(true);
    $status = 1;


    if (!$file)
        $status = '0';  // Site is down
    else {
        fclose($file);
        $status = ($stoptime - $starttime) * 1000;
        $status = '1';
    }
    return $status;
}


include('./classes/SecurityManager.php');


function fixOutgoingUmlaute($string) {
    $string = str_replace("{ue}", "ü", $string);
    $string = str_replace("{UE}", "Ü", $string);
    $string = str_replace("{ae}", "ä", $string);
    $string = str_replace("{AE}", "Ä", $string);
    $string = str_replace("{oe}", "ö", $string);
    $string = str_replace("{OE}", "Ö", $string);
    $string = str_replace("{ss}", "ß", $string);
    $string = str_replace("{uu}", "&", $string);
    $string = str_replace("{ho}", "'", $string);
    $string = str_replace("{hh}", '"', $string);
    $string = str_replace("{u1}", "¶", $string);
    $string = str_replace("{u2}", "¢", $string);
    $string = str_replace("{u3}", "*", $string);
    $string = str_replace("{u4}", "≠", $string);
    $string = str_replace("{u5}", "¿", $string);

    $string = str_replace("{u6}", "‚", $string);
    $string = str_replace("[u7}", "‘", $string);
    $string = str_replace("{u8}", "€", $string);
    $string = str_replace("{u9}", "$", $string);
    return $string;
}


function GetXlerInfo($userid, $string)
{
    global $mysqli;
    $userid = protect($userid);
    $string = protect($string);
    $check = $mysqli->query("SELECT * FROM hp_xler WHERE user_id = '".$userid."' ");
    if($check->num_rows > 0)
    {
        $row = $check->fetch_object();

        return $row->$string;
    } else {
        return '0';
    }
}
?>

Alles anzeigen

FOREX

Zitat von PrenK

meinst du diesen Code?

PHP

<?php


/*
 *   ___         _                           ___ __  __ ___ 
 *  / __|___ _ _| |_ ___ _ _  __ _ _ _ _  _ / __|  \/  / __|
 * | (__/ -_) ' \  _/ -_) ' \/ _` | '_| || | (__| |\/| \__ \
 *  \___\___|_||_\__\___|_||_\__,_|_|  \_, |\___|_|  |_|___/
 *                                     |__/                 
 * *************************                       
 * Content: CentenaryCMS
 * Autor  : Revue
 * Contact: me@revue-projects.at
 */


function getServerCount($string) {
    global $mysqli;


    switch ($string) {
        case 'users':
            $string = 'users_online';
            break;


        case 'rooms':
            $string = 'rooms_loaded';
            break;


        case 'stamp':
            $string = 'stamp';
            break;


        case 'server_started':
            $string = 'server_started';
            break;


        default:
            $string = '';
            break;
    }


    $sql = $mysqli->query("SELECT * FROM server_status");
    $row = $sql->fetch_object();


    return $row->$string;
}


function getServerstats($string) {
    global $mysqli;


    $sql = $mysqli->query("SELECT * FROM system_stats");
    $row = $sql->fetch_object();


    return $row->$string;
}


function pagetitle($title) {
    global $user;


    $title = protect($title);


    $title = str_replace("%username%", $user->username, $title);


    return $title;
}


function sendmail($empfaenger, $betreff, $text) {
    $empfaenger = $empfaenger;
    $betreff = $betreff;


    $header = 'MIME-Version: 1.0' . "\r\n";
    $header .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    $header .= 'From: Habbo Hotel <info@habbo.tl>' . "\r\n";


    mail($empfaenger, $betreff, $text, $header);
}


function MitarbeiterTable($user_id, $string) {
    global $mysqli;


    $user_id = protect($user_id);
    $string = protect($string);


    $sql = $mysqli->query("SELECT * FROM hp_mitarbeiter WHERE user_id = '" . $user_id . "' ");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();


        return $row->$string;
    } else {
        return '0';
    }
}


function getSettings($string) {
    global $mysqli;


    $string = protect($string);


    $sql = $mysqli->query("SELECT * FROM hp_settings LIMIT 1");


    $row = $sql->fetch_object();


    return $row->$string;
}


function umlaute($text, $noprotect = false) {
    if ($noprotect == false) {
        $text = protect($text);
    }


    $text = str_replace("Ă¤", "ä", $text);
    $text = str_replace("Ăź", "ü", $text);
    $text = str_replace("ü", "ü", $text);
    $text = str_replace("Ăś", "ö", $text);


    $text = str_replace("?Â", "ß", $text);
    return $text;
}


function umlautenew($string) {
    $string = $string;


    $string = str_replace("ü", "{ue}", $string);
    $string = str_replace("Ü", "{UE}", $string);
    $string = str_replace("ä", "{ae}", $string);
    $string = str_replace("Ä", "{AE}", $string);
    $string = str_replace("ö", "{oe}", $string);
    $string = str_replace("Ö", "{OE}", $string);
    $string = str_replace("ß", "{ss}", $string);
    $string = str_replace("&", "{uu}", $string);
    $string = str_replace("'", "{ho}", $string);
    $string = str_replace('"', "{hh}", $string);
    $string = str_replace("¶", "{u1}", $string);
    $string = str_replace("¢", "{u2}", $string);
    $string = str_replace("*", "{u3}", $string);
    $string = str_replace("≠", "{u4}", $string);
    $string = str_replace("¿", "{u5}", $string);
    $string = str_replace("‚", "{u6}", $string);
    $string = str_replace("‘", "[u7}", $string);
    $string = str_replace("€", "{u8}", $string);
    $string = str_replace("$", "{u9}", $string);




    return $string;
}


function Umlautefix($text, $noprotect = false) {
    if ($noprotect == false) {
        $text = protect($text);
    }


    $text = htmlentities($text);
    return $text;
}


function shitumlaute($string) {
    $string = str_replace("ä", "&auml;", $string);
    $string = str_replace("&Atilde;&frac14;", "ü", $string);


    return $string;
}


function protect($string, $output = false) {
    $string = str_replace("'", "", $string);
    $string = strip_tags($string);


    if ($output == false) {
        $string = Umlautefix($string, 'no-proect');
    }


    return utf8_encode($string);
}


function pwhash($string) {
    $string = protect($string);
    $verschlusselung = 'XX8402u7NF.TL.85929!FASDJ4FU!A\\//adgkl4hsfkasdfhas,l54jk';


    $pw = md5(md5(md5($string) . $verschlusselung));
    return $pw;
}


function getRanks($string, $what) {
    global $mysqli, $user;
    $sql = $mysqli->query("SELECT * FROM ranks WHERE id = '" . $string . "' ");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        return $row->$what;
    }
}


function getSiteManager($id, $string) {
    global $mysqli;


    $id = protect($id);
    $string = protect($string);


    $sql = $mysqli->query("SELECT * FROM hp_pages WHERE id = '" . $id . "' ");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();


        return $row->$string;
    }
}


function getNaviManager($id, $string) {
    global $mysqli;


    $id = protect($id);
    $string = protect($string);




    $sql = $mysqli->query("SELECT * FROM hp_navi WHERE id = '" . $id . "' ");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();


        return $row->$string;
    }
}


function getRoom($id, $string) {
    global $mysqli;


    $id = protect($id);
    $string = protect($string);


    $sql = $mysqli->query("SELECT * FROM rooms WHERE id = '" . $id . "' LIMIT 1");


    $row = $sql->fetch_object();


    return $row->$string;
}


function getRoomModel($roomid) {
    global $mysqli;


    $id = protect($roomid);
    $sql = $mysqli->query("SELECT * FROM rooms WHERE id = '" . $id . "' LIMIT 1");


    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();


        $search = $mysqli->query("SELECT * FROM room_models WHERE id = '" . $row->model_name . "' ");
        if ($search->num_rows > 0) {
            $srow = $search->fetch_object();


            return $srow->heightmap;
        } else {
            return 'NO Model Found';
        }
    } else {
        return 'No Room Found';
        exit;
    }
}


function Habbohash($textt, $type) {
    switch ($type) {
        case('ver'):
            $text = str_replace("A", "9/", $textt);
            $text = str_replace("B", "8/", $text);
            $text = str_replace("C", "7/", $text);
            $text = str_replace("D", "6/", $text);
            $text = str_replace("E", "5/", $text);
            $text = str_replace("F", "4/", $text);
            $text = str_replace("G", "3/", $text);
            $text = str_replace("H", "2/", $text);
            $text = str_replace("I", "1/", $text);
            $text = str_replace("J", "0/", $text);
            $text = str_replace("K", "+/", $text);
            $text = str_replace("L", "*/", $text);
            $text = str_replace("M", "ďż˝/", $text);
            $text = str_replace("N", "%/", $text);
            $text = str_replace("O", "&/", $text);
            $text = str_replace("P", "~/", $text);
            $text = str_replace("Q", "(/", $text);
            $text = str_replace("R", ")/", $text);
            $text = str_replace("S", ":/", $text);
            $text = str_replace("T", "_/", $text);
            $text = str_replace("U", "ďż˝/", $text);
            $text = str_replace("V", "#/", $text);
            $text = str_replace("W", "ďż˝/", $text);
            $text = str_replace("X", "ďż˝/", $text);
            $text = str_replace("Y", "ďż˝/", $text);
            $text = str_replace("Z", "|/", $text);
            $text = str_replace("a", "9>", $text);
            $text = str_replace("b", "8>", $text);
            $text = str_replace("c", "7>", $text);
            $text = str_replace("d", "6>", $text);
            $text = str_replace("e", "5>", $text);
            $text = str_replace("f", "4>", $text);
            $text = str_replace("g", "3>", $text);
            $text = str_replace("h", "2>", $text);
            $text = str_replace("i", "1>", $text);
            $text = str_replace("j", "0>", $text);
            $text = str_replace("k", "+>", $text);
            $text = str_replace("l", "*>", $text);
            $text = str_replace("m", "ďż˝>", $text);
            $text = str_replace("n", "%>", $text);
            $text = str_replace("o", "&>", $text);
            $text = str_replace("p", "~>", $text);
            $text = str_replace("q", "(>", $text);
            $text = str_replace("r", ")>", $text);
            $text = str_replace("s", ":>", $text);
            $text = str_replace("t", "_>", $text);
            $text = str_replace("u", "ďż˝>", $text);
            $text = str_replace("v", "#>", $text);
            $text = str_replace("w", "ďż˝>", $text);
            $text = str_replace("x", "ďż˝>", $text);
            $text = str_replace("y", "ďż˝>", $text);
            $text = str_replace("z", "|>", $text);
            $text = str_replace("@", "ďż˝<", $text);
            $text = str_replace(" ", "ďż˝<", $text);
            return base64_encode(base64_encode($text));
            break;


        case('ent'):
            $textt = base64_decode(base64_decode($textt));
            $text = str_replace("9/", "A", $textt);
            $text = str_replace("8/", "B", $text);
            $text = str_replace("7/", "C", $text);
            $text = str_replace("6/", "D", $text);
            $text = str_replace("5/", "E", $text);
            $text = str_replace("4/", "F", $text);
            $text = str_replace("3/", "G", $text);
            $text = str_replace("2/", "H", $text);
            $text = str_replace("1/", "I", $text);
            $text = str_replace("0/", "J", $text);
            $text = str_replace("+/", "K", $text);
            $text = str_replace("*/", "L", $text);
            $text = str_replace("ďż˝/", "M", $text);
            $text = str_replace("%/", "N", $text);
            $text = str_replace("&/", "O", $text);
            $text = str_replace("~/", "P", $text);
            $text = str_replace("(/", "Q", $text);
            $text = str_replace(")/", "R", $text);
            $text = str_replace(":/", "S", $text);
            $text = str_replace("_/", "T", $text);
            $text = str_replace("ďż˝/", "U", $text);
            $text = str_replace("#/", "V", $text);
            $text = str_replace("ďż˝/", "W", $text);
            $text = str_replace("ďż˝/", "X", $text);
            $text = str_replace("ďż˝/", "Y", $text);
            $text = str_replace("|/", "Z", $text);
            $text = str_replace("9>", "a", $text);
            $text = str_replace("8>", "b", $text);
            $text = str_replace("7>", "c", $text);
            $text = str_replace("6>", "d", $text);
            $text = str_replace("5>", "e", $text);
            $text = str_replace("4>", "f", $text);
            $text = str_replace("3>", "g", $text);
            $text = str_replace("2>", "h", $text);
            $text = str_replace("1>", "i", $text);
            $text = str_replace("0>", "j", $text);
            $text = str_replace("+>", "k", $text);
            $text = str_replace("*>", "l", $text);
            $text = str_replace("ďż˝>", "m", $text);
            $text = str_replace("%>", "n", $text);
            $text = str_replace("&>", "o", $text);
            $text = str_replace("~>", "p", $text);
            $text = str_replace("(>", "q", $text);
            $text = str_replace(")>", "r", $text);
            $text = str_replace(":>", "s", $text);
            $text = str_replace("_>", "t", $text);
            $text = str_replace("ďż˝>", "u", $text);
            $text = str_replace("#>", "v", $text);
            $text = str_replace("ďż˝>", "w", $text);
            $text = str_replace("ďż˝>", "x", $text);
            $text = str_replace("ďż˝>", "y", $text);
            $text = str_replace("|>", "z", $text);
            $text = str_replace("ďż˝<", "@", $text);
            $text = str_replace("ďż˝<", " ", $text);
            return $text;
            break;
    }
}


function mottosymbole($text) {
    $text = protect($text);
    $text = str_replace("|", "&#x2665;", $text);
    $text = str_replace("<3", "&#x2665;", $text);
    return $text;
}


function getDays($id) {
    $full_day = $id;
    if ($full_day == "1") {
        $date = "Montag";
    }
    if ($full_day == "2") {
        $date = "Dienstag";
    }
    if ($full_day == "3") {
        $date = "Mittwoch";
    }
    if ($full_day == "4") {
        $date = "Donnerstag";
    }
    if ($full_day == "5") {
        $date = "Freitag";
    }
    if ($full_day == "6") {
        $date = "Samstag";
    }
    if ($full_day == "0") {
        $date = "Sonntag";
    }


    return $date;
}


function getMonth($id) {
    $full_m = $id;


    if ($full_m == "1") {
        $datex = "Januar";
    }
    if ($full_m == "2") {
        $datex = "Februar";
    }
    if ($full_m == "3") {
        $datex = "März";
    }
    if ($full_m == "4") {
        $datex = "April";
    }
    if ($full_m == "5") {
        $datex = "Mai";
    }
    if ($full_m == "6") {
        $datex = "Juni";
    }
    if ($full_m == "7") {
        $datex = "Juli";
    }
    if ($full_m == "8") {
        $datex = "August";
    }
    if ($full_m == "9") {
        $datex = "September";
    }
    if ($full_m == "10") {
        $datex = "Oktober";
    }
    if ($full_m == "11") {
        $datex = "November";
    }
    if ($full_m == "12") {
        $datex = "Dezember";
    }


    return $datex;
}


function dateformatierung($time) {
    $time = protect($time);


    switch (date('d.m.Y', $time)) {


        case date('d.m.Y', strtotime("+1 day")):
            return 'Morgen </b>um<b> ' . date('H:i', $time);
            break;


        case(date('d.m.Y')):
            return 'Heute </b>um<b> ' . date('H:i', $time);
            break;


        case(date('d.m.Y', time() - 86400)):
            return 'Gestern </b>um<b> ' . date('H:i', $time);
            break;


        case(date('d.m.Y', time() - (86400 * 2))):
            return 'Vorgestern </b>um<b> ' . date('H:i', $time);
            break;


        default:
            return date('d.m.Y', $time) . '</b> um <b>' . date('H:i', $time);
            break;
    }
}


function getTime($time) {
    $time = protect($time);


    if ($time / 60 >= '1') {
        if (($time / 60) / 60 >= '1') {
            if ((($time / 60) / 60) / 24 >= '1') {
                if (((($time / 60) / 60) / 24) / 30 >= '1') {
                    if ((((($time / 60) / 60) / 24) / 30) / 12 >= '1') {


                        if ((((($time / 60) / 60) / 24) / 30) / 12 == '1') {
                            $beschreibung = 'Jahr';
                        } else {
                            $beschreibung = 'Jahren';
                        }


                        $time = round((((($time / 60) / 60) / 24) / 30) / 12);
                    } else {
                        if ((((($time / 60) / 60) / 24) / 30) == '1') {


                            $beschreibung = 'Monat';
                        } else {
                            $beschreibung = 'Monaten';
                        }


                        $time = round(((($time / 60) / 60) / 24) / 30);
                    }
                } else {


                    if (round((($time / 60) / 60) / 24) == '1') {
                        $beschreibung = 'Tag';
                    } else {
                        $beschreibung = 'Tagen';
                    }


                    $time = round((($time / 60) / 60) / 24);
                }
            } else {
                if (round(($time / 60) / 60) == '1') {
                    $beschreibung = 'Stunde';
                } else {
                    $beschreibung = 'Stunden';
                }


                $time = round(($time / 60) / 60);
            }
        } else {
            if (round($time / 60) == '1') {
                $beschreibung = 'Minute';
            } else {
                $beschreibung = 'Minuten';
            }


            $time = round($time / 60);
        }
    } else {
        if (round($time) == '1') {
            $beschreibung = 'Sekunden';
        } else {
            $beschreibung = 'Sekunden';
        }


        $time = round($time);
    }


    return $time . ' ' . $beschreibung;
}


function copyroom($roomid, $captionnew, $onwernew) {
    global $mysqli;
    $roomid = protect($roomid);
    $captionnew = protect($captionnew);
    $ownernew = protect($onwernew);


    $getroom = $mysqli->query("SELECT * FROM rooms WHERE id = '" . $roomid . "' ");
    if ($getroom->num_rows > 0) {
        $room = $getroom->fetch_object();
        $mysqli->query("INSERT INTO rooms (roomtype, caption, owner, description, category, state, users_now, users_max, model_name, password, allow_hidewall, wallthick, floorthick, wallpaper, floor, landscape)
	VALUES ('" . $room->roomtype . "', '" . $captionnew . "', '" . $onwernew . "', '" . $room->description . "', '" . $room->category . "', '" . $room->state . "', '0', '" . $room->users_max . "', '" . $room->model_name . "', '" . $room->password . "', '" . $room->allow_hidewall . "', '" . $room->wallthick . "', '" . $room->floorthick . "', '" . $room->wallpaper . "', '" . $room->floor . "', '" . $room->landscape . "') ");
        $newroom_sql = $mysqli->query("SELECT * FROM rooms WHERE caption = '" . $captionnew . "' AND owner = '" . $onwernew . "' ORDER BY id DESC LIMIT 1");
        if ($newroom_sql->num_rows > 0) {
            $newroom = $newroom_sql->fetch_object();
            $sql_get = $mysqli->query("SELECT * FROM items WHERE room_id = '" . $room->id . "'");
            if ($sql_get->num_rows > 0) {
                while ($row = $sql_get->fetch_object()) {
                    $sql = $mysqli->query("SELECT * FROM room_items_moodlight WHERE item_id = '" . $row->id . "' ");
                    if ($sql->num_rows < 1) {
                        $mysqli->query("INSERT INTO items (user_id, room_id, base_item, x, y, z, rot, wall_pos, copied_itemid, ltd_id, ltd_cnt, guild_data) VALUES
				('" . $row->user_id . "', '" . $newroom->id . "', '" . $row->base_item . "', '" . $row->x . "', '" . $row->y . "', '" . $row->z . "', '" . $row->rot . "', '" . $row->wall_pos . "', '" . $row->copied_itemid . "', '" . $row->ltd_id . "', '" . $row->ltd_cnt . "', '" . $row->guild_data . "') ");
                        MUS('update_catalogid');
                        $getitem_sql = $mysqli->query("SELECT * FROM items WHERE room_id = '" . $newroom->id . "' AND base_item = '" . $row->base_item . "' ORDER BY id DESC LIMIT 1");
                        $getitem = $getitem_sql->fetch_object();


                        $checkextra = $mysqli->query("SELECT * FROM items_extra_data WHERE item_id = '" . $row->id . "' ");
                        if ($checkextra->num_rows > 0) {
                            $extrada = $checkextra->fetch_object();
                            $mysqli->query("INSERT INTO items_extra_data (item_id, extra_data) VALUES ('" . $getitem->id . "', '" . $extrada->extra_data . "')");
                            MUS('update_catalogid');
                        }
                    } else {
                    }
                }
            }
            MUS('update_catalogid');
            MUS('unloadroom', $newroom->id);
            echo $newroom->id;
        } else {
            exit;
        }
    } else {
        exit;
    }
}


function isfriend($id1, $id2) {
    global $mysqli;
    $id1 = protect($id1);
    $id2 = protect($id2);


    $search = $mysqli->query("SELECT * FROM messenger_friendships WHERE user_one_id = '" . $id1 . "' AND user_two_id = '" . $id2 . "' LIMIT 1");
    if ($search->num_rows > 0) {
        return '1';
    } else {
        return '0';
    }
}


function getForumKategorie($id) {
    global $mysqli;


    $id = protect($id);


    $sql = $mysqli->query("SELECT * FROM hp_forum WHERE id = '" . $id . "' ");
    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        return $row->name;
    }
}


function getServerName($ip, $what) {
    $ip = protect($ip);


    switch ($ip) {
        case 'Server1':
        case '37.59.96.238':
            $x->name = 'Server <b>2</b>';
            $x->ip = '37.59.96.238';
            break;




        case 'Server2':
        case '46.105.17.53':
            $x->name = 'Server <b>2</b>';
            $x->ip = '92.222.146.46';
            break;


        case 'Server3':
        case 'c':
            $x->name = 'Server 3';
            $x->ip = '92.222.2.142';
            break;


        case 'Server4':
        case 'd':
            $x->name = 'Server 4';
            break;




        case '127.0.0.1':
            $x->name = 'Server Local';
            $x->ip = '127.0.0.1';
            break;


        default:
            header("location: http://Habbo.tl");
            exit;
            break;
    }


    return $x->$what;
}


function getServerStatus($ip, $port) {
    $starttime = microtime(true);
    $file = fsockopen($ip, $port, $errno, $errstr, 10);
    $stoptime = microtime(true);
    $status = 1;


    if (!$file)
        $status = '0';  // Site is down
    else {
        fclose($file);
        $status = ($stoptime - $starttime) * 1000;
        $status = '1';
    }
    return $status;
}


include('./classes/SecurityManager.php');


function fixOutgoingUmlaute($string) {
    $string = str_replace("{ue}", "ü", $string);
    $string = str_replace("{UE}", "Ü", $string);
    $string = str_replace("{ae}", "ä", $string);
    $string = str_replace("{AE}", "Ä", $string);
    $string = str_replace("{oe}", "ö", $string);
    $string = str_replace("{OE}", "Ö", $string);
    $string = str_replace("{ss}", "ß", $string);
    $string = str_replace("{uu}", "&", $string);
    $string = str_replace("{ho}", "'", $string);
    $string = str_replace("{hh}", '"', $string);
    $string = str_replace("{u1}", "¶", $string);
    $string = str_replace("{u2}", "¢", $string);
    $string = str_replace("{u3}", "*", $string);
    $string = str_replace("{u4}", "≠", $string);
    $string = str_replace("{u5}", "¿", $string);
    $string = str_replace("{u6}", "‚", $string);
    $string = str_replace("[u7}", "‘", $string);
    $string = str_replace("{u8}", "€", $string);
    $string = str_replace("{u9}", "$", $string);
    return $string;
}


function GetXlerInfo($userid, $string)
{
    global $mysqli;
    $userid = protect($userid);
    $string = protect($string);
    $check = $mysqli->query("SELECT * FROM hp_xler WHERE user_id = '".$userid."' ");
    if($check->num_rows > 0)
    {
        $row = $check->fetch_object();
        return $row->$string;
    } else {
        return '0';
    }
}
?>

Alles anzeigen

Genau, aber nur die Umlaute löschen.

Romi090312

Zitat von FOREX

Genau, aber nur die Umlaute löschen.

Sry stehe gerade bisschen auf der Leitung.
Wärst du so nett und würdest das Zeug rauslöschen was du meintest und dann das nochmals hier korrekt hochladen so wie es sein muss damit die Umlaute funktionieren ?

Wäre unnormal nett von dir

Ismail

PHP

<?php
/*
 *   ___         _                           ___ __  __ ___ 
 *  / __|___ _ _| |_ ___ _ _  __ _ _ _ _  _ / __|  \/  / __|
 * | (__/ -_) ' \  _/ -_) ' \/ _` | '_| || | (__| |\/| \__ \
 *  \___\___|_||_\__\___|_||_\__,_|_|  \_, |\___|_|  |_|___/
 *                                     |__/                 
 * *************************                       
 * Content: CentenaryCMS
 * Autor  : Revue
 * Contact: me@revue-projects.at
 */
function getServerCount($string) {
    global $mysqli;
    switch ($string) {
        case 'users':
            $string = 'users_online';
            break;
        case 'rooms':
            $string = 'rooms_loaded';
            break;
        case 'stamp':
            $string = 'stamp';
            break;
        case 'server_started':
            $string = 'server_started';
            break;
        default:
            $string = '';
            break;
    }
    $sql = $mysqli->query("SELECT * FROM server_status");
    $row = $sql->fetch_object();
    return $row->$string;
}
function getServerstats($string) {
    global $mysqli;
    $sql = $mysqli->query("SELECT * FROM system_stats");
    $row = $sql->fetch_object();
    return $row->$string;
}
function pagetitle($title) {
    global $user;
    $title = protect($title);
    $title = str_replace("%username%", $user->username, $title);
    return $title;
}
function sendmail($empfaenger, $betreff, $text) {
    $empfaenger = $empfaenger;
    $betreff = $betreff;
    $header = 'MIME-Version: 1.0' . "\r\n";
    $header .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    $header .= 'From: Habbo Hotel <info@habbo.tl>' . "\r\n";
    mail($empfaenger, $betreff, $text, $header);
}
function MitarbeiterTable($user_id, $string) {
    global $mysqli;
    $user_id = protect($user_id);
    $string = protect($string);
    $sql = $mysqli->query("SELECT * FROM hp_mitarbeiter WHERE user_id = '" . $user_id . "' ");
    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        return $row->$string;
    } else {
        return '0';
    }
}
function getSettings($string) {
    global $mysqli;
    $string = protect($string);
    $sql = $mysqli->query("SELECT * FROM hp_settings LIMIT 1");
    $row = $sql->fetch_object();
    return $row->$string;
}
function umlaute($text, $noprotect = false) {
    if ($noprotect == false) {
        $text = protect($text);
}
    $text = htmlentities($text);
    return $text;
}
function shitumlaute($string) {


    }
    return utf8_encode($string);
}
function pwhash($string) {
    $string = protect($string);
    $verschlusselung = 'XX8402u7NF.TL.85929!FASDJ4FU!A\\//adgkl4hsfkasdfhas,l54jk';
    $pw = md5(md5(md5($string) . $verschlusselung));
    return $pw;
}
function getRanks($string, $what) {
    global $mysqli, $user;
    $sql = $mysqli->query("SELECT * FROM ranks WHERE id = '" . $string . "' ");
    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        return $row->$what;
    }
}
function getSiteManager($id, $string) {
    global $mysqli;
    $id = protect($id);
    $string = protect($string);
    $sql = $mysqli->query("SELECT * FROM hp_pages WHERE id = '" . $id . "' ");
    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        return $row->$string;
    }
}
function getNaviManager($id, $string) {
    global $mysqli;
    $id = protect($id);
    $string = protect($string);
    $sql = $mysqli->query("SELECT * FROM hp_navi WHERE id = '" . $id . "' ");
    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        return $row->$string;
    }
}
function getRoom($id, $string) {
    global $mysqli;
    $id = protect($id);
    $string = protect($string);
    $sql = $mysqli->query("SELECT * FROM rooms WHERE id = '" . $id . "' LIMIT 1");
    $row = $sql->fetch_object();
    return $row->$string;
}
function getRoomModel($roomid) {
    global $mysqli;
    $id = protect($roomid);
    $sql = $mysqli->query("SELECT * FROM rooms WHERE id = '" . $id . "' LIMIT 1");
    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        $search = $mysqli->query("SELECT * FROM room_models WHERE id = '" . $row->model_name . "' ");
        if ($search->num_rows > 0) {
            $srow = $search->fetch_object();
            return $srow->heightmap;
        } else {
            return 'NO Model Found';
        }
    } else {
        return 'No Room Found';
        exit;
    }


}
function mottosymbole($text) {
    $text = protect($text);
    $text = str_replace("|", "&#x2665;", $text);
    $text = str_replace("<3", "&#x2665;", $text);
    return $text;
}
function getDays($id) {
    $full_day = $id;
    if ($full_day == "1") {
        $date = "Montag";
    }
    if ($full_day == "2") {
        $date = "Dienstag";
    }
    if ($full_day == "3") {
        $date = "Mittwoch";
    }
    if ($full_day == "4") {
        $date = "Donnerstag";
    }
    if ($full_day == "5") {
        $date = "Freitag";
    }
    if ($full_day == "6") {
        $date = "Samstag";
    }
    if ($full_day == "0") {
        $date = "Sonntag";
    }
    return $date;
}
function getMonth($id) {
    $full_m = $id;
    if ($full_m == "1") {
        $datex = "Januar";
    }
    if ($full_m == "2") {
        $datex = "Februar";
    }
    if ($full_m == "3") {
        $datex = "März";
    }
    if ($full_m == "4") {
        $datex = "April";
    }
    if ($full_m == "5") {
        $datex = "Mai";
    }
    if ($full_m == "6") {
        $datex = "Juni";
    }
    if ($full_m == "7") {
        $datex = "Juli";
    }
    if ($full_m == "8") {
        $datex = "August";
    }
    if ($full_m == "9") {
        $datex = "September";
    }
    if ($full_m == "10") {
        $datex = "Oktober";
    }
    if ($full_m == "11") {
        $datex = "November";
    }
    if ($full_m == "12") {
        $datex = "Dezember";
    }
    return $datex;
}
function dateformatierung($time) {
    $time = protect($time);
    switch (date('d.m.Y', $time)) {
        case date('d.m.Y', strtotime("+1 day")):
            return 'Morgen </b>um<b> ' . date('H:i', $time);
            break;
        case(date('d.m.Y')):
            return 'Heute </b>um<b> ' . date('H:i', $time);
            break;
        case(date('d.m.Y', time() - 86400)):
            return 'Gestern </b>um<b> ' . date('H:i', $time);
            break;
        case(date('d.m.Y', time() - (86400 * 2))):
            return 'Vorgestern </b>um<b> ' . date('H:i', $time);
            break;
        default:
            return date('d.m.Y', $time) . '</b> um <b>' . date('H:i', $time);
            break;
    }
}
function getTime($time) {
    $time = protect($time);
    if ($time / 60 >= '1') {
        if (($time / 60) / 60 >= '1') {
            if ((($time / 60) / 60) / 24 >= '1') {
                if (((($time / 60) / 60) / 24) / 30 >= '1') {
                    if ((((($time / 60) / 60) / 24) / 30) / 12 >= '1') {
                        if ((((($time / 60) / 60) / 24) / 30) / 12 == '1') {
                            $beschreibung = 'Jahr';
                        } else {
                            $beschreibung = 'Jahren';
                        }
                        $time = round((((($time / 60) / 60) / 24) / 30) / 12);
                    } else {
                        if ((((($time / 60) / 60) / 24) / 30) == '1') {
                            $beschreibung = 'Monat';
                        } else {
                            $beschreibung = 'Monaten';
                        }
                        $time = round(((($time / 60) / 60) / 24) / 30);
                    }
                } else {
                    if (round((($time / 60) / 60) / 24) == '1') {
                        $beschreibung = 'Tag';
                    } else {
                        $beschreibung = 'Tagen';
                    }
                    $time = round((($time / 60) / 60) / 24);
                }
            } else {
                if (round(($time / 60) / 60) == '1') {
                    $beschreibung = 'Stunde';
                } else {
                    $beschreibung = 'Stunden';
                }
                $time = round(($time / 60) / 60);
            }
        } else {
            if (round($time / 60) == '1') {
                $beschreibung = 'Minute';
            } else {
                $beschreibung = 'Minuten';
            }
            $time = round($time / 60);
        }
    } else {
        if (round($time) == '1') {
            $beschreibung = 'Sekunden';
        } else {
            $beschreibung = 'Sekunden';
        }
        $time = round($time);
    }
    return $time . ' ' . $beschreibung;
}
function copyroom($roomid, $captionnew, $onwernew) {
    global $mysqli;
    $roomid = protect($roomid);
    $captionnew = protect($captionnew);
    $ownernew = protect($onwernew);
    $getroom = $mysqli->query("SELECT * FROM rooms WHERE id = '" . $roomid . "' ");
    if ($getroom->num_rows > 0) {
        $room = $getroom->fetch_object();
        $mysqli->query("INSERT INTO rooms (roomtype, caption, owner, description, category, state, users_now, users_max, model_name, password, allow_hidewall, wallthick, floorthick, wallpaper, floor, landscape)
	VALUES ('" . $room->roomtype . "', '" . $captionnew . "', '" . $onwernew . "', '" . $room->description . "', '" . $room->category . "', '" . $room->state . "', '0', '" . $room->users_max . "', '" . $room->model_name . "', '" . $room->password . "', '" . $room->allow_hidewall . "', '" . $room->wallthick . "', '" . $room->floorthick . "', '" . $room->wallpaper . "', '" . $room->floor . "', '" . $room->landscape . "') ");
        $newroom_sql = $mysqli->query("SELECT * FROM rooms WHERE caption = '" . $captionnew . "' AND owner = '" . $onwernew . "' ORDER BY id DESC LIMIT 1");
        if ($newroom_sql->num_rows > 0) {
            $newroom = $newroom_sql->fetch_object();
            $sql_get = $mysqli->query("SELECT * FROM items WHERE room_id = '" . $room->id . "'");
            if ($sql_get->num_rows > 0) {
                while ($row = $sql_get->fetch_object()) {
                    $sql = $mysqli->query("SELECT * FROM room_items_moodlight WHERE item_id = '" . $row->id . "' ");
                    if ($sql->num_rows < 1) {
                        $mysqli->query("INSERT INTO items (user_id, room_id, base_item, x, y, z, rot, wall_pos, copied_itemid, ltd_id, ltd_cnt, guild_data) VALUES
				('" . $row->user_id . "', '" . $newroom->id . "', '" . $row->base_item . "', '" . $row->x . "', '" . $row->y . "', '" . $row->z . "', '" . $row->rot . "', '" . $row->wall_pos . "', '" . $row->copied_itemid . "', '" . $row->ltd_id . "', '" . $row->ltd_cnt . "', '" . $row->guild_data . "') ");
                        MUS('update_catalogid');
                        $getitem_sql = $mysqli->query("SELECT * FROM items WHERE room_id = '" . $newroom->id . "' AND base_item = '" . $row->base_item . "' ORDER BY id DESC LIMIT 1");
                        $getitem = $getitem_sql->fetch_object();
                        $checkextra = $mysqli->query("SELECT * FROM items_extra_data WHERE item_id = '" . $row->id . "' ");
                        if ($checkextra->num_rows > 0) {
                            $extrada = $checkextra->fetch_object();
                            $mysqli->query("INSERT INTO items_extra_data (item_id, extra_data) VALUES ('" . $getitem->id . "', '" . $extrada->extra_data . "')");
                            MUS('update_catalogid');
                        }
                    } else {
                    }
                }
            }
            MUS('update_catalogid');
            MUS('unloadroom', $newroom->id);
            echo $newroom->id;
        } else {
            exit;
        }
    } else {
        exit;
    }
}
function isfriend($id1, $id2) {
    global $mysqli;
    $id1 = protect($id1);
    $id2 = protect($id2);
    $search = $mysqli->query("SELECT * FROM messenger_friendships WHERE user_one_id = '" . $id1 . "' AND user_two_id = '" . $id2 . "' LIMIT 1");
    if ($search->num_rows > 0) {
        return '1';
    } else {
        return '0';
    }
}
function getForumKategorie($id) {
    global $mysqli;
    $id = protect($id);
    $sql = $mysqli->query("SELECT * FROM hp_forum WHERE id = '" . $id . "' ");
    if ($sql->num_rows > 0) {
        $row = $sql->fetch_object();
        return $row->name;
    }
}
function getServerName($ip, $what) {
    $ip = protect($ip);
    switch ($ip) {
        case 'Server1':
        case '37.59.96.238':
            $x->name = 'Server <b>2</b>';
            $x->ip = '37.59.96.238';
            break;
        case 'Server2':
        case '46.105.17.53':
            $x->name = 'Server <b>2</b>';
            $x->ip = '92.222.146.46';
            break;
        case 'Server3':
        case 'c':
            $x->name = 'Server 3';
            $x->ip = '92.222.2.142';
            break;
        case 'Server4':
        case 'd':
            $x->name = 'Server 4';
            break;
        case '127.0.0.1':
            $x->name = 'Server Local';
            $x->ip = '127.0.0.1';
            break;
        default:
            header("location: http://Habbo.tl");
            exit;
            break;
    }
    return $x->$what;
}
function getServerStatus($ip, $port) {
    $starttime = microtime(true);
    $file = fsockopen($ip, $port, $errno, $errstr, 10);
    $stoptime = microtime(true);
    $status = 1;
    if (!$file)
        $status = '0';  // Site is down
    else {
        fclose($file);
        $status = ($stoptime - $starttime) * 1000;
        $status = '1';


}
function GetXlerInfo($userid, $string)
{
    global $mysqli;
    $userid = protect($userid);
    $string = protect($string);
    $check = $mysqli->query("SELECT * FROM hp_xler WHERE user_id = '".$userid."' ");
    if($check->num_rows > 0)
    {
        $row = $check->fetch_object();
        return $row->$string;
    } else {
        return '0';
    }
}
?>

Alles anzeigen

Habe es im schnell durchlauf gemacht kann sein das es unsauber und nicht vollständig ist.

**koksal baba**

Ich rate jedem dazu ab dieses "etwas" zunutzen. Der Anblick dieses Code's ist einfach lachhaft und zugleich lächerlich.

Zitat

function GetXlerInfo($userid, $string)
{
global $mysqli;
$userid = protect($userid);
$string = protect($string);
$check = $mysqli->query("SELECT * FROM hp_xler WHERE user_id = '".$userid."' ");
if($check->num_rows > 0)
{
$row = $check->fetch_object();
return $row->$string;
} else {
return '0';
}
}

Alles anzeigen

Alleine das man Globale Variable bennutzt..... Na ja.
Und diese Funktion macht einfach keinen Sinn. Der "experten"-Rank wird einem User gegeben (Spalte rank... glaub rank 3 oder so) und statt das zu fetchen macht man natürlich (weil man professionell ist) eine extra Tabelle mit den jeweiligen Usern die diesen Rank besitzen.

Ahja, alleine das man überall SELECT * genutzt hat spricht für alles.
Die wenigen von euch wissen was ich meine @Rockstar*

**^SMAeterox**

Auf Wunsch
#Closed

(CentenaryCMS) News Prefix/Umlaute Problem

Jetzt mitmachen!

Tags

Benutzer online in diesem Thema