// Not Fix Create Account
[RicePacket(82, RiceServer.ServerType.Lobby)]
public static void CreateCharacter(RicePacket packet)
{
string characterName = packet.Reader.ReadUnicode();
string UIDCreate = packet.Reader.ReadUnicode();
DbConnection dbconn_c = Database.GetConnection();
DbCommand crechar = dbconn_c.CreateCommand();
crechar.CommandText = @"Insert into characters (UID, Name) values ('" + UIDCreate + "', '" + characterName + "')";
//Test
//crechar.CommandText = @"Insert into characters (UID, Name) values ('1', '" + characterName + "')";
crechar.ExecuteNonQuery();
Log.WriteLine("Create Character Success Name: {0}", characterName);
// TODO: Verify, Handle
[COLOR=#666666]var ack = new RicePacket(82);[/COLOR]
[COLOR=#666666]ack.Writer.WriteUnicodeStatic(characterName, 21);[/COLOR]
[COLOR=#666666]packet.Sender.Send(ack);[/COLOR]
}