public static void Delete(uint UID)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
cmd.Delete("guild_arsenalsdonation", "item_uid", UID).Execute();
cmd = new MySqlCommand(MySqlCommandType.UPDATE);
cmd.Update("items").Set("Inscribed", 0).Where("UID", UID).Execute();
}
public static void DeleteItem(uint UID)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
int res = cmd.Delete("items", "UID", UID).Execute();
MySqlCommand cmds = new MySqlCommand(MySqlCommandType.DELETE).Delete("items", "UID", UID);
cmds.Execute();
}
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 DeleteAll(Dictionary<uint, Game.ConquerStructures.Society.ArsenalSingle> Items)
{
foreach (ArsenalSingle AS in Items.Values)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
cmd.Delete("guild_arsenalsdonation", "item_uid", AS.UID).Execute();
cmd = new MySqlCommand(MySqlCommandType.UPDATE);
cmd.Update("items").Set("Inscribed", 0).Where("UID", AS.UID).Execute();
}
}
public static void DeleteSpell(Client.GameState client, ushort ID)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
cmd.Delete("skills", "ID", ID).And("EntityID", client.Entity.UID).Execute();
}
public static void DeleteClan(uint ID)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
cmd.Delete("Clans", "ClanID", ID).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 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 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 RemoveMentor(uint apprenticeuid)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
cmd.Delete("apprentice", "apprenticeid", apprenticeuid).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 DeleteTabelInstances()
{
foreach (Team_client client in Top8.Values)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
int res = cmd.Delete("elitepk", "UID", client.UID).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();
}