Code:
[DriftCityPacket(82, DriftCityServer.ServerType.Lobby)]
public static void CreateCharacter(DriftCityPacket packet)
{
string characterName = packet.Reader.ReadUnicode();
//int characterUID = packet.Reader.ReadInt32();//test no read db problem.
//int Avatar = packet.Reader.ReadInt32();//test no read db problem.
int characterUID = 1;//test
int avatar = 3;//test
DbConnection dbconn_c = Database.GetConnection();
DbCommand crechar = dbconn_c.CreateCommand();
crechar.CommandText = @"Insert into characters (UID, Name, Avatar) values ('" + characterUID + "', '" + characterName + "', '" + avatar + "')";
crechar.ExecuteNonQuery();
Log.WriteLine("Create Character Success Name: {0} UID: {1} Avatar: {2}", characterName, characterUID, avatar);
// TODO: Verify, Handle
var ack = new DriftCityPacket(82);
//var ack = new DriftCityPacket(83); //Create Character and go start game
ack.Writer.WriteUnicodeStatic(characterName, 21);
ack.Writer.Write(characterUID);
ack.Writer.Write(avatar);
packet.Sender.Send(ack);
//packet.Sender.Error("Create New Character Error.");
}
Credits: By SdfSdf
Reply With Quote
