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) { MySqlDataReader 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; }