$sql = "INSERT INTO users (id, active, role, banned, fname, lname, username, password, email, token, signed_ip, last_ip, signed_date, last_login, session_id)
                    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    $id = '';
    $active = 0;
    $role = 3;
    $banned = 0;
    $fname = $mysqli -> real_escape_string($fname);
    $lname = $mysqli -> real_escape_string($lname);
    $email = $mysqli -> real_escape_string($email);
    $username = $mysqli -> real_escape_string($username);
    $password = $mysqli -> real_escape_string(salt($password));
    $passwordconf = $mysqli -> real_escape_string(salt($passwordconf)); //salt incase it gets read or used in future
    $token = generate_token($email);
    $signed_ip = $_SERVER['REMOTE_ADDR'];
    $last_ip = '';
    $signed_date = date("m/d/y", time());
    $last_login = '';
    $session_id = '';

    $stmt = $mysqli -> prepare($sql);
    $stmt -> bind_param("iiiissssssiiiii", $id, $active, $role, $banned, $fname, $lname, $username, $password, $email, $token, $signed_ip, $last_ip, $signed_date, $last_login, $session_id);
    $stmt -> execute();

    printf("%d Row inserted.\n", $stmt->affected_rows);

    $stmt->close();
}