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();
}
