<?php
function reg_acc() {

        $userx = @mysql_query("SELECT username, id FROM ".$this->db.".account WHERE username = '".mysql_real_escape_string($_POST['reg_username'])."' LIMIT 1", $this->id);
        $user_row = @mysql_fetch_assoc($userx);

        $totalaccs_q = @mysql_query("SELECT COUNT(*) AS total FROM ".$this->db.".account WHERE registerip = '".$_SERVER['REMOTE_ADDR']."' LIMIT 3", $this->id);
        $totalaccs = @mysql_fetch_assoc($totalaccs_q);

        $output = "<center>";

        if(isset($_SESSION['username'])) {
            $output .= "You're already logged in!";
        }

        elseif(filter_var($_POST['reg_email'], FILTER_VALIDATE_EMAIL) == false) {
            $output .= "Invalid email!";
        }

        elseif(isset($user_row['id'])) {
            $output .= "User already exists!";
        }

        elseif($_POST['reg_antibot'] != $_POST['reg_ans']) {
            $output .= "Wrong anti-bot answear!";
        }

        elseif(empty($_POST['reg_shoutboxnick'])) {
            $output .= "You need to enter a shoutbox nickname!";
        }

        elseif($totalaccs['total'] >= 3) {
            $output .= "You may only register 3 accounts per IP!";
        }

        else {
            $username = mysql_real_escape_string($_POST['reg_username']);
            $pass = mysql_real_escape_string($_POST['reg_password']);
            $email = mysql_real_escape_string($_POST['reg_email']);
            $flags = mysql_real_escape_string($_POST['reg_flags']);
            $shoutboxnick = mysql_real_escape_string($_POST['reg_shoutboxnick']);

            $pw = sha1(strtoupper($username).':'.strtoupper($pass));
            mysql_query("INSERT INTO ".$this->db.".account(`username`, `sha_pass_hash`, `email`, `expansion`, `shoutboxnick`, `registerip`) VALUES('".$username."', '".$pw."', '".$email."', '".$flags."', '".$shoutboxnick."', '".$_SERVER['REMOTE_ADDR']."')", $this->id) or die(mysql_error());

            $output .= "<span style='color:green;'>Account was created successfully!</span>";
        }

        $output .= "</center>";

        return $output;
    }
?>