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;
}