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