MsgNewRole.cs
using COServer.Database;
client.Send(new MsgServer.MsgMessage("ANSWER_OK", MsgMessage.MsgColor.red, MsgMessage.ChatMode.PopUP).GetArray(stream));
using (var cmd = new MySqlCommand(MySqlCommandType.INSERT)) { cmd.Insert("entities").Insert("UID", client.Player.UID).Insert("Name", client.Player.Name).Insert ("ServerName", Program.ServerConfig.ServerName).Insert("Online", 1).Insert("ServerNum", 1).Execute(); }
MsgLoginClient.cs
MyConsole.WriteLine("Client " + client.Player.Name + " was login on [" + client.Socket.RemoteIp + "] EntityID ["+client.Player.UID+"]");
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE)) { cmd.Update("entities").Set("Online", 1).Set("ServerNum", 1).Where("UID", client.Player.UID).And("ServerName", Program.ServerConfig.ServerName).And("Name", client.Player.Name).Execute(); }
MyConsole.WriteLine("Client " + client.Player.Name + " was loggin out.");
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE)) { cmd.Update("entities").Set("Online", 0).Where("UID", client.Player.UID).And("ServerName", Program.ServerConfig.ServerName).And("Name", client.Player.Name).Execute(); }
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE)) { cmd.Update("entities").Set("Name", Name).Where("UID", user.Player.UID).And("ServerName", Program.ServerConfig.ServerName).Execute(); }