public static void Claim(uint kimo, Client.GameState owner) { MySqlCommand command = new MySqlCommand(MySqlCommandType.DELETE); command.Delete("claimitems", "ItemUID", kimo).And("GainerUID", owner.Entity.UID).Execute(); //ClaimItem.Delete(item.Item.UID); }
public static void Disband(Game.ConquerStructures.Society.Guild guild) { MySqlCommand command = new MySqlCommand(MySqlCommandType.UPDATE); command.Update("entities").Set("GuildID", 0).Where("GuildID", guild.ID).Execute(); ServerBase.Kernel.Guilds.Remove(guild.ID); command = new MySqlCommand(MySqlCommandType.DELETE); command.Delete("guilds", "ID", guild.ID).Execute(); }
public static void RemoveItem(Client.GameState client) { MySqlCommand command = new MySqlCommand(MySqlCommandType.DELETE); command.Delete("prizenpc", "Owner", client.Entity.UID).And("type", "2").Execute(); PrizeNpcInformations.Remove(client.Entity.UID); MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("prizenpc").Where("Owner", client.Entity.UID); PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd); if (r.Read()) { PrizeNpcInfo info = new PrizeNpcInfo(); info.Owner = r.ReadUInt32("Owner"); info.type = r.ReadUInt32("type"); info.amount = r.ReadUInt32("amount"); info.itemid = r.ReadUInt32("itemid"); PrizeNpcInformations.Add(info.Owner, info); } //Console.WriteLine("PrizeNpc Loaded."); r.Close(); r.Dispose(); }
public static void RemoveEnemy(Game.ConquerStructures.Society.Guild guild, uint enemy) { MySqlCommand command = new MySqlCommand(MySqlCommandType.DELETE); command.Delete("guildenemy", "GuildID", guild.ID).And("EnemyID", enemy).Execute(); }
public static void RemoveReincarnated(Game.Entity entity) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("reincarnation", "uid", entity.UID).Execute(); }
public static void DeleteArsenalItem(uint uid, uint i_uid, Arsenal_ID aid) { MySqlCommand Command = new MySqlCommand(MySqlCommandType.DELETE); Command.Delete("pt_arsenal_inscribed", "uid", uid).And("iten_id", i_uid).Execute(); }
public static void DeleteArsenal(uint s_id, Arsenal_ID id) { MySqlCommand Command = new MySqlCommand(MySqlCommandType.DELETE); Command.Delete("pt_arsenal", "syn_id", s_id).And("arsenal_id", (byte)id).Execute(); }
public static void DeleteSpell(Client.GameState client, ushort ID) { MySqlCommand command = new MySqlCommand(MySqlCommandType.DELETE); command.Delete("skills", "ID", ID).And("EntityID", client.Entity.UID).Execute(); }
public static void RemovePartner(Client.GameState client, uint partnerID) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("partners", "partnerid", partnerID).And("entityid", client.Entity.UID).Execute(); cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("partners", "entityid", partnerID).And("partnerid", client.Entity.UID).Execute(); }
public static void RemoveMentor(uint apprenticeuid) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("apprentice", "apprenticeid", apprenticeuid).Execute(); }
public static void RemoveFriend(Client.GameState client, uint friendID) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("friends", "friendid", friendID).And("entityid", client.Entity.UID).Execute(); cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("friends", "entityid", friendID).And("friendid", client.Entity.UID).Execute(); }
public static void RemoveEnemy(Client.GameState client, uint enemyID) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("enemy", "enemyid", enemyID).And("entityid", client.Entity.UID).Execute(); }
public static void RemoveApprentice(Client.GameState client, uint apprenticeID) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("apprentice", "apprenticeid", apprenticeID).Execute(); }
public static void RemoveAdding(uint UID, uint addingid) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("itemadding", "uid", UID).And("addingid", addingid).Execute(); }
public void DeleteRelation(UInt32 Relative, Network.GamePackets.ClanRelations.RelationTypes type) { MySqlCommand Command = new MySqlCommand(MySqlCommandType.DELETE); Command.Delete("clanrelation", "clanid", this.ClanId).And("AssociatedId", Relative).And("type", Convert.ToByte(type)).Execute(); //Console.WriteLine("2222"); }
public static void DeleteTabelInstances() { foreach (Elite_client client in Top8.Values) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("elitepk", "UID", client.UID).Execute(); } }
public static void DeleteClan(uint ID) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("Clans", "ClanID", ID).Execute(); // Console.WriteLine("6666"); }
public static void DeleteItem(uint UID) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE); cmd.Delete("items", "UID", UID).Execute(); }