Avalon.Managers.Database.Database.CharacterCreate C# (CSharp) Method

        public static SMSG_CHARACTER_CREATE CharacterCreate(String Name, int Class, int AID )
        {
            Regex pattern = new Regex("^[A-Za-z0-9]{0,16}$");
            SMSG_CHARACTER_CREATE packet;

            if (pattern.Match(Name).Success)
            {
                SqlDataReader sql = Database.Query("SELECT * FROM character WHERE name = '" + Name + "'");
                if (sql.HasRows)
                {
                    Database.Query("INSERT INTO character (aid, name, class) VALUES (" + AID + ", '" + Name + "', " + Class + ")");
                    packet = new SMSG_CHARACTER_CREATE(Name, Class, (int)SMSG_CHARACTER_CREATE.CreateState.CHAR_CREATE_OK);
                }
                else
                {
                    packet = new SMSG_CHARACTER_CREATE(Name, Class, (int)SMSG_CHARACTER_CREATE.CreateState.CHAR_CREATE_EXIST);
                }
            }
            else
            {
                packet = new SMSG_CHARACTER_CREATE(Name, Class, (int)SMSG_CHARACTER_CREATE.CreateState.CHAR_CREATE_INCORRECT);
            }

            return packet;
        }