[DEVELOPMENT] CloudCMS - Habbo CMS für Retros

public function CreateUser($reguser, $regpw, $repw, $regmail){
            if(!empty($reguser) && !empty($regpw) && !empty($repw) && !empty($regmail)){
                $check = Connection::getConnection()->query("SELECT * FROM users WHERE username = '". Connection::getConnection()->real_escape_string($reguser) . "' OR mail = '". Connection::getConnection()->real_escape_string($regmail) . "'");

                if($check->num_rows > 0){
                    return 'data-exist-error';
                } elseif($regpw != $repw) {
                    return 'repw-error'; 
                } elseif(strlen($reguser) < 3) {
                    return 'reguser-error';
                } elseif(strlen($regpw) < 5) {
                    return 'regpw-error';
                } else {
                    $createuser = Connection::getConnection()->query("INSERT INTO users SET username = '". Connection::getConnection()->real_escape_string($reguser) . "', password = '". md5(Connection::getConnection()->real_escape_string($regpw)) . "', mail = '". Connection::getConnection()->real_escape_string($regmail) . "'");
                }
            }
        }

public function getEvent(){

            $row = Connection::getConnection()->query("SELECT * FROM eventlist ORDER BY id DESC LIMIT 1");

            if($row->num_rows > 0){
                $event = $row->fetch_object();
                return $event;
            } else {
                return 'event-not-found';
            }
        }