public static void LoadRates()
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("gameupdates");
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
if (r.Read())
{
Body1 = r.ReadString("Body1");
Body2 = r.ReadString("Body2");
Body3 = r.ReadString("Body3");
Body4 = r.ReadString("Body4");
Body5 = r.ReadString("Body5");
Body6 = r.ReadString("Body6");
Header = r.ReadString("Header");
}
Console.WriteLine("System GameUpdates Loaded.");
r.Close();
r.Dispose();
}
public static void GetMembers()
{
foreach (KeyValuePair<uint, Game.Clans> G in PhoenixProject.ServerBase.Kernel.ServerClans)
{
Game.Clans clan = G.Value;
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("entities").Where("ClanId", clan.ClanId);
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
while (r.Read())
{
Game.ClanMembers member = new PhoenixProject.Game.ClanMembers();
member.Donation = r.ReadUInt32("ClanDonation");
//member.Rank = r.ReadByte("ClanRank");
member.UID = r.ReadUInt32("UID");
member.Name = r.ReadString("Name");
member.Class = r.ReadUInt16("Class");
member.Level = r.ReadByte("Level");
if (clan.ClanLider == member.Name)
{
member.Rank = 100;
}
else
{
member.Rank = 10;
}
if (!clan.Members.ContainsKey(member.UID))
clan.Members.Add(member.UID, member);
}
r.Close();
//r.Close();
r.Dispose();
//Console.WriteLine("1818");
}
}
public static void LoadRates()
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("helpdesk");
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
if (r.Read())
{
Register = r.ReadString("Register");
Vote = r.ReadString("Vote");
ChatBox = r.ReadString("ChatBox");
Purchase = r.ReadString("Purchase");
Facebook = r.ReadString("Facebook");
ChangePass = r.ReadString("ChangePass");
}
Console.WriteLine("HelpDesk Table Loaded.");
r.Close();
r.Dispose();
}
public static void LoadAllClans()
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("Clans");
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
while (r.Read())
{
Game.Clans clan = new PhoenixProject.Game.Clans();
clan.ClanLider = r.ReadString("Leader");
clan.ClanId = r.ReadUInt32("ClanID");
clan.ClanName = r.ReadString("Name");
clan.ClanBuletion = r.ReadString("Bulletin");
clan.ClanDonation = r.ReadUInt32("Fund");
clan.ClanLevel = r.ReadByte("Level");
if (!PhoenixProject.ServerBase.Kernel.ServerClans.ContainsKey(clan.ClanId))
PhoenixProject.ServerBase.Kernel.ServerClans.Add(clan.ClanId, clan);
}
r.Close();
//r.Close();
r.Dispose();
Console.WriteLine("Clans Loading " + PhoenixProject.ServerBase.Kernel.ServerClans.Count);
GetMembers();
// Console.WriteLine("1515");
foreach (Game.Clans c in ServerBase.Kernel.ServerClans.Values)
{
c.LoadAssociates();
}
}
public static void LoadRates()
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("rates").Where("Coder", "Kimo");
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
if (r.Read())
{
lastentity = r.ReadUInt32("LastEntity");
//Program.EntityUID = new ServerBase.Counter(r.ReadUInt32("LastEntity"));
lastitem = r.ReadUInt32("LastItem");
KoCount = r.ReadUInt32("KoCount");
plus13 = r.ReadUInt32("Plus13");
plus14 = r.ReadUInt32("Plus14");
plus15 = r.ReadUInt32("Plus15");
PartyDrop = r.ReadUInt32("PartyDrop");
CaptureFlag = r.ReadUInt32("CaptureFlag");
SkillTeam = r.ReadUInt32("SkillTeam");
DemonCave = r.ReadUInt32("DemonCave");
VoteUrl = r.ReadString("VoteUrl");
VotePrize = r.ReadUInt32("VotePrize");
Weather = r.ReadUInt32("Weather");
Night = r.ReadUInt32("Night");
SoulP6 = r.ReadUInt32("SoulP6");
Garment = r.ReadUInt32("Garment");
Steed = r.ReadUInt32("Steed");
Mount = r.ReadUInt32("Mount");
DamageTails = r.ReadUInt32("DamageTails");
DamageGarment = r.ReadUInt32("DamageGarment");
LevelUp = r.ReadUInt32("LevelUp");
TeratoDragon = r.ReadUInt32("TeratoDragon");
ThrillingSpook = r.ReadUInt32("ThrillingSpook");
SnowBanshe = r.ReadUInt32("SnowBanshe");
TreasureLow = r.ReadUInt32("TreasureLow");
TreasureMax = r.ReadUInt32("TreasureMax");
TreasureMin = r.ReadUInt32("TreasureMin");
GuildWar = r.ReadUInt32("GuildWar");
BotJail = r.ReadUInt32("BotJail");
RemoveBound = r.ReadUInt32("RemoveBound");
elitepk = r.ReadUInt32("elitepk");
SteedRace = r.ReadUInt32("SteedRace");
ChangeName = r.ReadUInt32("ChangeName");
MonthlyPk = r.ReadUInt32("MonthlyPk");
EliteGw = r.ReadUInt32("EliteGw");
TopSpouse = r.ReadUInt32("TopSpouse");
DailyPk = r.ReadUInt32("DailyPk");
LastMan = r.ReadUInt32("LastMan");
Riencration = r.ReadUInt32("Riencration");
king = r.ReadUInt32("kings");
prince = r.ReadUInt32("prince");
housepromete = r.ReadUInt32("HousePromete");
houseupgrade = r.ReadUInt32("HouseUpgrade");
itembox = r.ReadUInt32("ItemBox");
maxcps = r.ReadUInt32("MaxCps");
minicps = r.ReadUInt32("MiniCps");
CpsMethodNum = r.ReadUInt32("CpsMethodNum");
classpk = r.ReadUInt32("ClassPk");
weeklypk = r.ReadUInt32("WeeklyPk");
cpsmethod = r.ReadString("CpsMethod");
serversite = r.ReadString("ServerWebsite");
servername = r.ReadString("ServerName");
coder = r.ReadString("Coder");
PopUpURL = r.ReadString("LoginSite");
ServerBase.Constants.ServerName2 = r.ReadString("ServerName");
ServerBase.Constants.GameCryptographyKey = r.ReadString("CryptKey");
}
Console.WriteLine("Rates Loaded.");
r.Close();
r.Dispose();
}
public static void Load()
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("specialdrops");
PhoenixProject.Database.MySqlReader rdr = new PhoenixProject.Database.MySqlReader(cmd);
while (rdr.Read())
{
SpecialItemDrop sitem = new SpecialItemDrop();
sitem.ItemID = rdr.ReadInt32("itemid");
sitem.Rate = rdr.ReadInt32("rate");
sitem.Discriminant = rdr.ReadInt32("discriminant");
sitem.Map = rdr.ReadUInt64("map");
SpecialItemDropList.Add(sitem);
}
rdr.Close();
rdr.Dispose();
MySqlCommand command = new MySqlCommand(MySqlCommandType.SELECT);
command.Select("monsterinfos");
PhoenixProject.Database.MySqlReader reader = new PhoenixProject.Database.MySqlReader(command);
while (reader.Read())
{
MonsterInformation mf = new MonsterInformation();
mf.ID = reader.ReadUInt32("id");
mf.Name = reader.ReadString("name");
mf.Mesh = reader.ReadUInt16("lookface");
mf.Level = reader.ReadByte("level");
mf.Hitpoints = reader.ReadUInt32("life");
ServerBase.IniFile IniFile = new ServerBase.IniFile(ServerBase.Constants.MonstersPath);
if (IniFile.ReadString(mf.Name, "MaxLife") != "")
{
if (uint.Parse(IniFile.ReadString(mf.Name, "MaxLife")) != 0)
{
mf.Hitpoints = uint.Parse(IniFile.ReadString(mf.Name, "MaxLife"));
byte boss = byte.Parse(IniFile.ReadString(mf.Name, "Boss"));
if (boss == 0)
mf.Boss = false;
else mf.Boss = true;
}
}
mf.ViewRange = reader.ReadUInt16("view_range");
mf.AttackRange = reader.ReadUInt16("attack_range");
mf.AttackType = reader.ReadByte("attack_user");
mf.MinAttack = reader.ReadUInt32("attack_min");
mf.MaxAttack = reader.ReadUInt32("attack_max");
mf.SpellID = reader.ReadUInt16("magic_type");
mf.MoveSpeed = reader.ReadInt32("move_speed");
mf.RunSpeed = reader.ReadInt32("run_speed");
mf.OwnItemID = reader.ReadInt32("ownitem");
mf.HPPotionID = reader.ReadInt32("drop_hp");
mf.MPPotionID = reader.ReadInt32("drop_mp");
mf.OwnItemRate = reader.ReadInt32("ownitemrate");
mf.AttackSpeed = reader.ReadInt32("attack_speed");
mf.ExtraExperience = reader.ReadUInt32("extra_exp");
uint MoneyDropAmount = reader.ReadUInt16("level");
if (MoneyDropAmount != 0)
{
mf.MaxMoneyDropAmount = MoneyDropAmount * 25;
if (mf.MaxMoneyDropAmount != 0)
mf.MinMoneyDropAmount = 1;
}
if (mf.MoveSpeed <= 500)
mf.MoveSpeed += 500;
if (mf.AttackSpeed <= 500)
mf.AttackSpeed += 500;
MonsterInfos.Add(mf.ID, mf);
byte lvl = mf.Level;
if (mf.Name == "Slinger" ||
mf.Name == "GoldGhost" ||
mf.Name == "AgileRat" ||
mf.Name == "Bladeling" ||
mf.Name == "BlueBird" ||
mf.Name == "BlueFiend" ||
mf.Name == "MinotaurL120")
{
mf.LabirinthDrop = true;
lvl = 20;
}
if (!ItemDropCache.ContainsKey(lvl))
{
List<uint> itemdroplist = new List<uint>();
foreach (ConquerItemBaseInformation itemInfo in ConquerItemInformation.BaseInformations.Values)
{
if (itemInfo.ID >= 800000 && itemInfo.ID <= 824014)
continue;
ushort position = Network.PacketHandler.ItemPosition(itemInfo.ID);
if (Network.PacketHandler.IsArrow(itemInfo.ID) || itemInfo.Level == 0 || itemInfo.Level > 121)
continue;
if (position < 9 && position != 7)
{
if (itemInfo.Level == 100)
if (itemInfo.Name.Contains("Dress"))
continue;
if (itemInfo.Level > 121)
continue;
int diff = (int)lvl - (int)itemInfo.Level;
if (!(diff > 10 || diff < -10))
{
itemdroplist.Add(itemInfo.ID);
}
}
if (position == 10 || position == 11 && lvl >= 70)
itemdroplist.Add(itemInfo.ID);
}
ItemDropCache.Add(lvl, itemdroplist);
}
if (mf.Boss)
{
List<uint> itemdroplist = new List<uint>();
foreach (ConquerItemBaseInformation itemInfo in ConquerItemInformation.BaseInformations.Values)
{
if (itemInfo.ID >= 800000 && itemInfo.ID <= 824014)
{
if (itemInfo.PurificationLevel <= 3)
{
int diff = (int)mf.Level - (int)itemInfo.Level;
if (!(diff > 10 || diff < -10))
{
itemdroplist.Add(itemInfo.ID);
}
}
}
}
SoulItemCache.Add(lvl, itemdroplist);
}
}
reader.Close();
reader.Dispose();
Console.WriteLine("Monster information loaded.");
Console.WriteLine("Monster drops generated.");
}
public static void LoadRates()
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("systemmessage");
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
if (r.Read())
{
EliteGW2 = r.ReadString("EliteGW2");
ClassPk = r.ReadString("ClassPk");
GuildFlame = r.ReadString("GuildFlame");
DisEnd = r.ReadString("DisEnd");
DailyPk = r.ReadString("DailyPk");
CouplesPk = r.ReadString("CouplesPk");
SteedRace = r.ReadString("SteedRace");
Sys = r.ReadString("Sys");
Sys2 = r.ReadString("Sys2");
Sys3 = r.ReadString("Sys3");
Sys4 = r.ReadString("Sys4");
Sys5 = r.ReadString("Sys5");
Sys6 = r.ReadString("Sys6");
Sys7 = r.ReadString("Sys7");
Sys8 = r.ReadString("Sys8");
Sys9 = r.ReadString("Sys9");
}
Console.WriteLine("System Messages Loaded.");
r.Close();
r.Dispose();
}
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();
}
private void LoadNpcs()
{
Database.MySqlCommand command = new PhoenixProject.Database.MySqlCommand(PhoenixProject.Database.MySqlCommandType.SELECT);
command.Select("npcs").Where("mapid", ID);
PhoenixProject.Database.MySqlReader reader = new PhoenixProject.Database.MySqlReader(command);
while (reader.Read())
{
INpc npc = new Network.GamePackets.NpcSpawn();
npc.UID = reader.ReadUInt32("id");
npc.Mesh = reader.ReadUInt16("lookface");
npc.Type = (Enums.NpcType)reader.ReadByte("type");
npc.X = reader.ReadUInt16("cellx"); ;
npc.Y = reader.ReadUInt16("celly");
npc.MapID = ID;
//Network.GamePackets.PokerTable npc2 = new Network.GamePackets.PokerTable();
AddNpc(npc);
}
reader.Close();
reader.Dispose();
command = new PhoenixProject.Database.MySqlCommand(PhoenixProject.Database.MySqlCommandType.SELECT);
command.Select("sobnpcs").Where("mapid", ID);
reader = new PhoenixProject.Database.MySqlReader(command);
while (reader.Read())
{
Network.GamePackets.SobNpcSpawn npc = new Network.GamePackets.SobNpcSpawn();
npc.UID = reader.ReadUInt32("id");
npc.Mesh = reader.ReadUInt16("lookface");
if (ID == 1039)
npc.Mesh = (ushort)(npc.Mesh - npc.Mesh % 10 + 7);
npc.Type = (Enums.NpcType)reader.ReadByte("type");
npc.X = reader.ReadUInt16("cellx"); ;
npc.Y = reader.ReadUInt16("celly");
npc.MapID = reader.ReadUInt16("mapid");
npc.Sort = reader.ReadUInt16("sort");
npc.ShowName = true;
npc.Name = reader.ReadString("name");
npc.Hitpoints = reader.ReadUInt32("life");
npc.MaxHitpoints = reader.ReadUInt32("maxlife");
AddNpc(npc);
}
reader.Close();
reader.Dispose();
}
public FlowerRank(uint UID)
{
int PacketLength = 80;
uint charamount = 0;
uint place = 1;
string[] playernames = new string[100000];
uint[] playerflowers = new uint[1000000];
MemoryStream Stream = new MemoryStream();
BinaryWriter Writer = new BinaryWriter(Stream);
Database.MySqlCommand cmd = new Database.MySqlCommand(Database.MySqlCommandType.SELECT);
cmd.Select("flowers").Order("redroses DESC");
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
while (r.Read())
{
int redroses = r.ReadInt32("redroses");
if (redroses != 0)
{
uint charuid = r.ReadUInt32("id");
PacketLength += (r.ReadString("name").Length * 2) + 36;
playernames[charamount] = r.ReadString("name");
playerflowers[charamount] = r.ReadUInt32("redroses");
charamount++;
}
}
Buffer = new byte[80 +8];
WriteUInt16(80, 0, Buffer);
WriteUInt16(1151, 2, Buffer);
WriteUInt32(1, 4, Buffer);
WriteUInt32(UID, 8, Buffer);
WriteUInt32(0, 12, Buffer);
WriteUInt32(charamount, 16, Buffer);
int position = 24;
for(int x = 0; x < charamount; x++)
{
// WriteUInt32(1, position, Buffer);
// position+=4;
WriteUInt32(place, position, Buffer);
place++;
//WriteUInt32(place, position, Buffer);
position+=4;
WriteUInt32(playerflowers[1], position, Buffer);
position += 4;
WriteUInt32(playerflowers[1], position, Buffer);
position += 4;
WriteUInt32(UID, position, Buffer);
position += 4;
WriteUInt32(UID, position, Buffer);
position += 4;
WriteString(playernames[x], position, Buffer);
position += 16;
WriteUInt32(1, position, Buffer);
position += 4;
WriteString(playernames[x], position, Buffer);
position += 8;
position = position + 16;
}
WriteString("TQServer", position, Buffer);
}
public static void LoadPlayersVots()
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("VoteIp");
PhoenixProject.Database.MySqlReader d = new PhoenixProject.Database.MySqlReader(cmd);
while (d.Read())
{
PhoenixProject.Game.ConquerStructures.PlayersVot Vot = new PhoenixProject.Game.ConquerStructures.PlayersVot();
Vot.Uid = d.ReadUInt32("ID");
Vot.AdressIp = d.ReadString("IP");
if (!Kernel.VotePool.ContainsKey(Vot.AdressIp))
Kernel.VotePool.Add(Vot.AdressIp, Vot);
if (!Kernel.VotePoolUid.ContainsKey(Vot.Uid))
Kernel.VotePoolUid.Add(Vot.Uid, Vot);
}
d.Close();
d.Dispose();
}
