本文整理汇总了C#中PhoenixProject.Database.MySqlCommand.Delete方法的典型用法代码示例。如果您正苦于以下问题:C# MySqlCommand.Delete方法的具体用法?C# MySqlCommand.Delete怎么用?C# MySqlCommand.Delete使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类PhoenixProject.Database.MySqlCommand
的用法示例。
在下文中一共展示了MySqlCommand.Delete方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Claim
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);
}
示例2: Disband
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();
}
示例3: RemoveItem
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();
}
示例4: RemoveEnemy
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();
}
示例5: RemoveReincarnated
public static void RemoveReincarnated(Game.Entity entity)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
cmd.Delete("reincarnation", "uid", entity.UID).Execute();
}
示例6: DeleteArsenalItem
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();
}
示例7: DeleteArsenal
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();
}
示例8: DeleteSpell
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();
}
示例9: RemovePartner
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();
}
示例10: RemoveMentor
public static void RemoveMentor(uint apprenticeuid)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
cmd.Delete("apprentice", "apprenticeid", apprenticeuid).Execute();
}
示例11: RemoveFriend
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();
}
示例12: RemoveEnemy
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();
}
示例13: RemoveApprentice
public static void RemoveApprentice(Client.GameState client, uint apprenticeID)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
cmd.Delete("apprentice", "apprenticeid", apprenticeID).Execute();
}
示例14: RemoveAdding
public static void RemoveAdding(uint UID, uint addingid)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
cmd.Delete("itemadding", "uid", UID).And("addingid", addingid).Execute();
}
示例15: DeleteRelation
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");
}