Code:
public static bool CreateEntity(Network.GamePackets.EnitityCreate eC, Client.GameState client, ref string message)
{
if (eC.Name.Length > 16)
eC.Name = eC.Name.Substring(0, 16);
if (eC.Name == "")
return false;
if (InvalidCharacters(eC.Name))
{
message = "Invalid characters inside the name.";
return false;
}
var rdr = new MySqlReader(new MySqlCommand(MySqlCommandType.SELECT).Select("entities").Where("name", eC.Name));
if (rdr.Read()) {
rdr.Close();
message = "The chosen name is already in use.";
return false;
}
rdr.Close();
client.Entity = new Game.Entity(Game.EntityFlag.Player, false);
client.Entity.Name = eC.Name;
DataHolder.GetStats(eC.Class, 1, client);
client.Entity.UID = Program.EntityUID.Next;
new MySqlCommand(MySqlCommandType.UPDATE).Update("configuration").Set("EntityID", client.Entity.UID).Where("Server", ServerBase.Constants.ServerName).Execute();
client.CalculateStatBonus();
client.CalculateHPBonus();
client.VIPDays = 0; <<---I added this but it did nothing anyway as I expected lol.
new MySqlCommand(MySqlCommandType.INSERT)
.Update("LotteryIn")
.Insert("UID", client.Entity.UID)
.Insert("Name", client.Entity.Name)
.Execute();
new MySqlCommand(MySqlCommandType.INSERT)
.Update("top2")
.Insert("UID", client.Entity.UID)
.Insert("TopTrojan2", 0)
.Insert("TopWarrior2", 0)
.Insert("TopPirate2", 0)
.Insert("TopMonk2", 0)
.Insert("TopNinja2", 0)
.Insert("TopWaterTaoist2", 0)
.Insert("TopArcher2", 0)
.Insert("TopFireTaoist2", 0)
.Insert("Name", client.Entity.Name)
.Execute();
new MySqlCommand(MySqlCommandType.INSERT)
.Update("top1")
.Insert("UID", client.Entity.UID)
.Insert("TopTrojan", 0)
.Insert("TopWarrior", 0)
.Insert("TopPirate", 0)
.Insert("TopMonk", 0)
.Insert("TopNinja", 0)
.Insert("TopWaterTaoist", 0)
.Insert("TopArcher", 0)
.Insert("TopFireTaoist", 0)
.Insert("Name", client.Entity.Name)
.Execute();
new MySqlCommand(MySqlCommandType.INSERT)
.Update("top3")
.Insert("UID", client.Entity.UID)
.Insert("TopGuildLeader", 0)
.Insert("TopDeputyLeader", 0)
.Insert("WeeklyPKChampion", 0)
.Insert("MonthlyPK", 0)
.Insert("Name", client.Entity.Name)
.Execute();
client.Entity.Hitpoints = client.Entity.MaxHitpoints;
client.Entity.Mana = (ushort)(client.Entity.Spirit * 5);
client.Entity.Class = eC.Class;
client.Entity.Body = eC.Body;
if (eC.Body == 1003 || eC.Body == 1004)
client.Entity.Face = (ushort)ServerBase.Kernel.Random.Next(1, 50);
else
client.Entity.Face = (ushort)ServerBase.Kernel.Random.Next(201, 250);
byte Color = (byte)ServerBase.Kernel.Random.Next(4, 8);
client.Entity.HairStyle = (ushort)(Color * 100 + 10 + (byte)ServerBase.Kernel.Random.Next(4, 9));
client.Account.EntityID = client.Entity.UID;
client.Account.Save();
//723753
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT);
cmd.Insert("entities").Insert("Name", eC.Name).Insert("Owner", client.Account.Username).Insert("Class", eC.Class).Insert("UID", client.Entity.UID)
.Insert("Hitpoints", client.Entity.Hitpoints).Insert("Mana", client.Entity.Mana).Insert("Body", client.Entity.Body)
.Insert("Face", client.Entity.Face).Insert("HairStyle", client.Entity.HairStyle).Insert("Strength", client.Entity.Strength)
.Insert("Agility", client.Entity.Agility).Insert("Vitality", client.Entity.Vitality).Insert("Spirit", client.Entity.Spirit);
cmd.Execute();
message = "ANSWER_OK";
return true;
}
