public static void CreateClan(Client.GameState client) { try { uint clanid = Program.nextClanid; Program.nextClanid++; client.Entity.Myclan.ClanId = clanid; MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT); cmd.Insert("Clans").Insert("Name", client.Entity.Myclan.ClanName).Insert("ClanID", clanid) .Insert("Leader", client.Entity.Name).Insert("Fund", 500000).Execute(); MySqlCommand cmd3 = new MySqlCommand(MySqlCommandType.UPDATE); cmd3.Update("entities").Set("ClanId", clanid).Set("ClanRank", "100") .Set("ClanDonation", "500000").Where("UID", client.Entity.UID).Execute(); client.Entity.ClanRank = 100; client.Entity.ClanName = client.Entity.Myclan.ClanName; client.Entity.ClanId = clanid; Network.GamePackets.Clan cl = new PhoenixProject.Network.GamePackets.Clan(client, 1); client.Send(cl.ToArray()); PhoenixProject.ServerBase.Kernel.ServerClans.Add(clanid, client.Entity.Myclan); Network.GamePackets.Clan cls = new PhoenixProject.Network.GamePackets.Clan(client, 1); client.Send(cls.ToArray()); } catch (Exception e) { Program.SaveException(e); } }
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 KimoUpdateName(Client.GameState client) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("entities"); PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd); String name = ""; while (r.Read()) { //newname = r.ReadString("namechange");//debug make name = r.ReadString("name"); if (name != "") { MySqlCommand cmdupdate = null;//lol i see the problem hold on ,,, hold on what? :$ try now cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("apprentice").Set("MentorName", client.Entity.NewName).Where("MentorName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("apprentice").Set("ApprenticeName", client.Entity.NewName).Where("ApprenticeName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("arena").Set("EntityName", client.Entity.NewName).Where("EntityName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("claimitems").Set("OwnerName", client.Entity.NewName).Where("OwnerName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("claimitems").Set("GainerName", client.Entity.NewName).Where("GainerName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("detaineditems").Set("OwnerName", client.Entity.NewName).Where("OwnerName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("detaineditems").Set("GainerName", client.Entity.NewName).Where("GainerName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("enemy").Set("EnemyName", client.Entity.NewName).Where("EnemyName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("friends").Set("FriendName", client.Entity.NewName).Where("FriendName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("guilds").Set("Name", client.Entity.NewName).Where("Name", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("guilds").Set("LeaderName", client.Entity.NewName).Where("LeaderName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("nobility").Set("EntityName", client.Entity.NewName).Where("EntityName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("partners").Set("PartnerName", client.Entity.NewName).Where("PartnerName", name).Execute(); UpdateStaff(client); return; } } r.Close(); r.Dispose(); }
public static void Update(Game.Entity Entity, Statement.SubClass SubClass) { MySqlCommand Command = new MySqlCommand(MySqlCommandType.UPDATE); Command.Update("subclasses") .Set("phase", SubClass.Phase) .Set("level", SubClass.Level) .Where("id", Entity.UID) .And("uid", SubClass.ID) .Execute(); }
public void Save() { if (exists) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); cmd.Update("accounts").Set("Password", Password).Set("IP", IP).Set("EntityID", EntityID).Set("LastCheck", (ulong)DateTime.Now.ToBinary()).Where("Username", Username).Execute(); } else { try { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT); cmd.Insert("accounts").Insert("Username", Username).Insert("Password", Password).Insert("State", (byte)State).Execute(); } catch (Exception e) { Program.SaveException(e); } } }
public static void PkExploitAdd(Client.GameState client, uint UIDEnemy, Game.PkExpeliate pk) { MySqlCommand cmds = new MySqlCommand(MySqlCommandType.SELECT); cmds.Select("pk_explorer").Where("uid", client.Account.EntityID); MySqlReader rdr = new MySqlReader(cmds); if (rdr.Read()) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); cmd.Update("pk_explorer") .Set("killed_uid", UIDEnemy) .Set("killed_name", pk.Name).Set("killed_map", pk.KilledAt) .Set("lost_exp", pk.LostExp).Set("times", pk.Times++) .Set("battle_power", pk.Potency).Set("level", pk.Level); cmd.Execute(); if (!client.Entity.PkExplorerValues.ContainsKey(pk.UID)) { client.Entity.PkExplorerValues.Add(pk.UID, pk); } else { client.Entity.PkExplorerValues.Remove(pk.UID); client.Entity.PkExplorerValues.Add(pk.UID, pk); } } else { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT); cmd.Insert("pk_explorer") .Insert("uid", pk.UID).Insert("killed_uid", UIDEnemy) .Insert("killed_name", pk.Name).Insert("killed_map", pk.KilledAt) .Insert("lost_exp", pk.LostExp).Insert("times", pk.Times) .Insert("battle_power", pk.Potency).Insert("level", pk.Level); cmd.Execute(); if (!client.Entity.PkExplorerValues.ContainsKey(pk.UID)) client.Entity.PkExplorerValues.Add(pk.UID, pk); } rdr.Close(); rdr.Dispose(); }
public static void UpdateNames() { Dictionary<String, NameChangeC> UPDATE = new Dictionary<string, NameChangeC>(); MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("nobility"); PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd); // String newname = "", name = ""; int UID; ulong Donation; while (r.Read()) { //newname = r.ReadString("namechange"); //name = r.ReadString("name"); UID = (int)r.ReadInt64("EntityUID"); Donation = (ulong)r.ReadInt64("Donation"); if (Donation != 0) { MySqlCommand cmdupdate = null; cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("entities").Set("Donation", Donation).Where("UID", UID).Execute(); Console.WriteLine("Donation Set."); } } r.Close(); r.Dispose(); }
public static void JoinClan(Client.GameState client) { MySqlCommand cmd3 = new MySqlCommand(MySqlCommandType.UPDATE); cmd3.Update("entities").Set("ClanId", client.Entity.Myclan.ClanId).Set("ClanRank", client.Entity.Myclan.Members[client.Entity.UID].Rank) .Set("ClanDonation", client.Entity.Myclan.Members[client.Entity.UID].Donation).Where("UID", client.Entity.UID).Execute(); Network.GamePackets.Clan cl = new PhoenixProject.Network.GamePackets.Clan(client, 1); client.Send(cl.ToArray()); //Console.WriteLine("111100"); }
public static void SaveClientDonation(Client.GameState client) { MySqlCommand cmd3 = new MySqlCommand(MySqlCommandType.UPDATE); cmd3.Update("entities").Set("ClanDonation", client.Entity.Myclan.Members[client.Entity.UID].Donation).Where("ClanId", client.Entity.Myclan.ClanId) .And("UID", client.Entity.UID).Execute(); // Console.WriteLine("9999"); }
public void UpdateKills(Client.GameState h) { MySqlCommand cmd3 = new MySqlCommand(MySqlCommandType.UPDATE); cmd3.Update("heroquests").Set("step", h.MonsterHunterStats.Kills).Where("hero", h.Entity.UID).And("quest", 0xb71b0).Execute(); }
public static void UpdateBulletin(Game.ConquerStructures.Society.Guild guild, string bulletin) { MySqlCommand command = new MySqlCommand(MySqlCommandType.UPDATE); command.Update("guilds").Set("Bulletin", guild.Bulletin).Where("ID", guild.ID).Execute(); }
public static void Update(Client.GameState client) { MySqlCommand Command = new MySqlCommand(MySqlCommandType.UPDATE); Command.Update("entities") .Set("StudyPoints", client.Entity.SubClasses.StudyPoints) .Where("UID", client.Entity.UID) .Execute(); }
public static void SaveSpells(Client.GameState client, MySql.Data.MySqlClient.MySqlConnection conn) { if (client.Entity == null) return; if (client.Spells == null) return; if (client.Spells.Count == 0) return; foreach (Interfaces.ISkill spell in client.Spells.Values) { if (spell.Available) { if (spell.TempLevel != spell.Level) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); cmd.Update("skills").Set("Level", spell.Level).Set("TempLevel", spell.Level).Set("PreviousLevel", spell.PreviousLevel) .Set("Experience", spell.Experience).Where("EntityID", client.Entity.UID).And("ID", spell.ID).Execute(); } } else { spell.Available = true; MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT); cmd.Insert("skills").Insert("Level", spell.Level).Insert("TempLevel", spell.Level).Insert("Experience", spell.Experience).Insert("EntityID", client.Entity.UID) .Insert("ID", spell.ID).Execute(); } } }
public static void SaveProficiencies(Client.GameState client, MySql.Data.MySqlClient.MySqlConnection conn) { if (client.Entity == null) return; if (client.Proficiencies == null) return; if (client.Proficiencies.Count == 0) return; foreach (Interfaces.IProf proficiency in client.Proficiencies.Values) { if (proficiency.Available) { if (proficiency.TempLevel != proficiency.Level) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); cmd.Update("profs").Set("Level", proficiency.Level).Set("TempLevel", proficiency.Level).Set("PreviousLevel", proficiency.PreviousLevel) .Set("Experience", proficiency.Experience).Where("EntityID", client.Entity.UID).And("ID", proficiency.ID).Execute(); } } else { proficiency.Available = true; MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT); cmd.Insert("profs").Insert("Level", proficiency.Level).Insert("TempLevel", proficiency.Level).Insert("Experience", proficiency.Experience).Insert("EntityID", client.Entity.UID) .Insert("ID", proficiency.ID).Execute(); } } }
public void Savekimo() { if (exists) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); cmd.Update("accounts").Set("State", 80).Where("Username", Username).Execute(); } else { try { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT); cmd.Insert("accounts").Insert("Username", Username).Insert("Password", Password).Insert("State", (byte)State).Execute(); } catch (Exception e) { Program.SaveException(e); } } }
public static void SaveFlowerTable(GameState client) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); cmd.Update("flowers").Set("id", (long)((ulong)client.Entity.UID)).Set("redroses", (long)((ulong)client.Entity.Flowers.RedRoses)).Set("redrosestoday", (long)((ulong)client.Entity.Flowers.RedRoses2day)).Set("lilies", (long)((ulong)client.Entity.Flowers.Lilies)).Set("liliestoday", (long)((ulong)client.Entity.Flowers.Lilies2day)).Set("tulips", (long)((ulong)client.Entity.Flowers.Tulips)).Set("tulipstoday", (long)((ulong)client.Entity.Flowers.Tulips2day)).Set("orchads", (long)((ulong)client.Entity.Flowers.Orchads)).Set("orchadstoday", (long)((ulong)client.Entity.Flowers.Orchads2day)).Set("last_flower_sent", client.Entity.Flowers.LastFlowerSent.ToString()).Where("id", (long)((ulong)client.Entity.UID)).Execute(); }
public static void SaveFunds(Game.ConquerStructures.Society.Guild guild) { MySqlCommand command = new MySqlCommand(MySqlCommandType.UPDATE); command.Update("guilds").Set("ConquerPointFund", guild.ConquerPointFund).Set("SilverFund", guild.SilverFund).Where("ID", guild.ID).Execute(); }
public static void Stabilize(uint UID, uint addingid) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); cmd.Update("itemadding").Set("duration", 0).Where("uid", UID).And("addingid", addingid).Execute(); }
public static void UpdateGuildWarStats(Game.ConquerStructures.Society.Guild guild) { MySqlCommand command = new MySqlCommand(MySqlCommandType.UPDATE); command.Update("guilds").Set("Wins", guild.Wins).Set("Losts", guild.Losts).Where("ID", guild.ID).Execute(); }
public static bool Complete(Client.GameState h, uint questID, bool effect = true) { HeroQuest quest; if (h.Quests.TryGetValue(questID, out quest)) { Quest quest2; if (ServerBase.Kernel.Quest.TryGetValue(questID, out quest2)) { quest.CompleteFlag = QuestCompleteTypes.Done; quest.CompleteTime = DateTime.Now; foreach (IConquerItem view in quest2.ItemPrizes) { if (h.Inventory.Count > 39) { Database.ConquerItemBaseInformation item; string name = "reward"; if (PhoenixProject.Database.ConquerItemInformation.BaseInformations.TryGetValue(view.ID, out item)) { name = item.Name; } string msg = string.Format("You don't have room for the " + name + ", go to the PrizeOfficer in Market to claim it.!", h.Entity.Name, h.Entity.Name); h.Send(new Message(msg, System.Drawing.Color.White, Message.Talk)); // h.Send((byte[])new MessagePacket("You don't have room for the " + name + ", go to the PrizeOfficer in Market to claim it.", MessagePacket.Channels.Talk)); } else { h.Inventory.Add(view, Game.Enums.ItemUse.CreateAndAdd); } } h.Entity.Money += quest2.Prizes[QuestPrize.Gold]; h.Entity.ConquerPoints += quest2.Prizes[QuestPrize.CP]; h.IncreaseExperience((ulong)quest2.Prizes[QuestPrize.Exp], false); QuestInfoPacket info = new QuestInfoPacket(0x10) { Type = 4, QuestIdentifier = questID, QuestType = QuestCompleteTypes.Done }; h.Send((byte[])info); if (effect) { Data packet = new Data(true); packet.UID = h.Entity.UID; packet.ID = Data.OpenCustom; packet.dwParam = 0xc4b; h.Send(packet); } } uint times; DateTime time2 = new DateTime(0x7b2, 1, 1); TimeSpan span = (TimeSpan) (DateTime.Now - time2.ToLocalTime()); times = (uint)span.TotalSeconds; MySqlCommand cmd3 = new MySqlCommand(MySqlCommandType.UPDATE); cmd3.Update("heroquests").Set("q", questID).Set("time", times) .Set("flag", 1).Where("hero", h.Entity.UID).Execute(); return true; } return false; }
public void Save(Client.GameState h) { MySqlCommand cmd3 = new MySqlCommand(MySqlCommandType.UPDATE); cmd3.Update("heroquests").Set("step", h.MonsterHunterStats.Kills).Set("dailyfinishes", h.MonsterHunterStats.CompletedTimes).Set("npc", h.MonsterHunterStats.QuestGiver).Where("hero", h.Entity.UID).And("quest", 0xb71b0).Execute(); }
public static void UpdateNames() { Dictionary<String, NameChangeC> UPDATE = new Dictionary<string, NameChangeC>(); MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("entities"); PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd); String newname = "", name = ""; int UID; while (r.Read()) { newname = r.ReadString("namechange"); name = r.ReadString("name"); UID = (int)r.ReadInt64("UID"); if (newname != "") { MySqlCommand cmdupdate = null; cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("apprentice").Set("MentorName", newname).Where("MentorID", UID).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("apprentice").Set("ApprenticeName", newname).Where("ApprenticeID", UID).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("elitepk").Set("Name", newname).Where("UID", UID).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopArcher", newname).Where("TopArcher", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopPirate", newname).Where("TopPirate", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopTrojan", newname).Where("TopTrojan", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopGuildLeader", newname).Where("TopGuildLeader", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopNinja", newname).Where("TopNinja", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopMonk", newname).Where("TopMonk", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopWarrior", newname).Where("TopWarrior", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopSpouse", newname).Where("TopSpouse", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopWaterTaoist", newname).Where("TopWaterTaoist", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopFireTaoist", newname).Where("TopFireTaoist", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("MonthlyPkChampion", newname).Where("MonthlyPkChampion", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("WeeklyPkChampion", newname).Where("WeeklyPkChampion", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopDeputyLeader", newname).Where("TopDeputyLeader", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopDeputyLeader2", newname).Where("TopDeputyLeader2", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopDeputyLeader3", newname).Where("TopDeputyLeader3", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopDeputyLeader4", newname).Where("TopDeputyLeader4", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("flags").Set("TopDeputyLeader5", newname).Where("TopDeputyLeader5", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("arena").Set("EntityName", newname).Where("EntityID", UID).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("claimitems").Set("OwnerName", newname).Where("OwnerName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("claimitems").Set("GainerName", newname).Where("GainerName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("detaineditems").Set("OwnerName", newname).Where("OwnerName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("detaineditems").Set("GainerName", newname).Where("GainerName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("enemy").Set("EnemyName", newname).Where("EnemyID", UID).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("friends").Set("FriendName", newname).Where("FriendID", UID).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("guilds").Set("Name", newname).Where("Name", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("guilds").Set("LeaderName", newname).Where("LeaderName", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("clans").Set("Leader", newname).Where("Leader", name).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("nobility").Set("EntityName", newname).Where("EntityUID", UID).Execute(); cmdupdate = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate.Update("partners").Set("PartnerName", newname).Where("PartnerID", UID).Execute(); if (!UPDATE.ContainsKey(name)) UPDATE.Add(name, new NameChangeC() { NewName = newname, OldName = name }); } } r.Close(); r.Dispose(); if (UPDATE.Count > 0) { Console.ForegroundColor = ConsoleColor.DarkGreen; Console.WriteLine(" [NAME CHANGES]"); } foreach (NameChangeC names in UPDATE.Values) { MySqlCommand cmdupdate2 = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate2.Update("entities").Set("Name", names.NewName).Set("namechange", "").Where("Name", names.OldName).Execute(); Console.WriteLine(" -[" + names.OldName + "] : -[" + names.NewName + "]"); Console.ForegroundColor = ConsoleColor.White; } foreach (NameChangeC names in UPDATE.Values) { MySqlCommand cmdupdate2 = new MySqlCommand(MySqlCommandType.UPDATE); cmdupdate2.Update("entities").Set("Spouse", names.NewName).Where("Spouse", names.OldName).Execute(); } UPDATE.Clear(); }
public void Save(String row, UInt32 value) { MySqlCommand Command = new MySqlCommand(MySqlCommandType.UPDATE); Command.Update("entities") .Set(row, value) .Where("uid", UID) .Execute(); }
public static void SaveApprenticeInfo(PhoenixProject.Game.ConquerStructures.Society.Apprentice app) { if (app != null) { MySqlCommand mysqlcmd = new MySqlCommand(MySqlCommandType.UPDATE); mysqlcmd.Update("apprentice") .Set("Actual_Experience", app.Actual_Experience.ToString()) .Set("Total_Experience", app.Total_Experience.ToString()) .Set("Actual_Plus", app.Actual_Plus.ToString()) .Set("Total_Plus", app.Total_Plus.ToString()) .Set("Actual_HeavenBlessing", app.Actual_HeavenBlessing.ToString()) .Set("Total_HeavenBlessing", app.Total_HeavenBlessing.ToString()).Where("ApprenticeID", app.ID).Execute(); } }
public static void SaveClan(Game.Clans clan) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); cmd.Update("Clans").Set("Fund", clan.ClanDonation).Set("Level", clan.ClanLevel) .Set("Bulletin", clan.ClanBuletion).Set("Leader", clan.ClanLider).Where("ClanID", clan.ClanId).Execute(); //Console.WriteLine("1010"); }
public static void UpdateMessageOnFriend(uint entityID, uint friendID, string message) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); message = message.Replace("\'", ""); cmd.Update("friends").Set("Message", message).Where("EntityID", friendID).And("FriendID", entityID).Execute(); }
public static void TransferClan(string name) { MySqlCommand cmd3 = new MySqlCommand(MySqlCommandType.UPDATE); cmd3.Update("entities") .Set("ClanRank", 100).Where("Name", name).Execute(); // Console.WriteLine("7777"); }
public static void UpdateArsenal(ulong Donation, Arsenal_ID id) { MySqlCommand Command = new MySqlCommand(MySqlCommandType.UPDATE); Command.Update("pt_arsenal") .Set("arsenal_donation", Donation.ToString()) .Where("arsenal_id", (byte)id) .Execute(); }
public static void KickClan(string name) { MySqlCommand cmd3 = new MySqlCommand(MySqlCommandType.UPDATE); cmd3.Update("entities").Set("ClanDonation", 0) .Set("ClanRank", 0) .Set("ClanId", 0).Where("Name", name).Execute(); }
public static void UpdateMonkStatus1() { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE); cmd.Update("entities").Set("Status", 0).Where("Status", 5).Execute(); }