public static Interfaces.IConquerItem GetSingleItem(uint UID)
{
Interfaces.IConquerItem item = new Network.GamePackets.ConquerItem(true);
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("items").Where("UID", UID);
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
if (r.Read())
{
item.ID = r.ReadUInt32("ID");
item.UID = r.ReadUInt32("UID");
item.Durability = r.ReadUInt16("Durability");
item.MaximDurability = r.ReadUInt16("MaximDurability");
item.Position = r.ReadUInt16("Position");
item.SocketProgress = r.ReadUInt32("SocketProgress");
item.PlusProgress = r.ReadUInt32("PlusProgress");
item.SocketOne = (Game.Enums.Gem)r.ReadByte("SocketOne");
item.SocketTwo = (Game.Enums.Gem)r.ReadByte("SocketTwo");
item.Effect = (Game.Enums.ItemEffect)r.ReadByte("Effect");
item.Mode = Game.Enums.ItemMode.Default;
item.Plus = r.ReadByte("Plus");
item.Bless = r.ReadByte("Bless");
item.Bound = r.ReadBoolean("Bound");
item.Enchant = r.ReadByte("Enchant");
item.Lock = r.ReadByte("Locked");
item.UnlockEnd = DateTime.FromBinary(r.ReadInt64("UnlockEnd"));
item.Suspicious = r.ReadBoolean("Suspicious");
item.SuspiciousStart = DateTime.FromBinary(r.ReadInt64("SuspiciousStart"));
item.Color = (Game.Enums.Color)r.ReadByte("Color");
item.Warehouse = r.ReadUInt16("Warehouse");
if (item.Lock == 2)
if (DateTime.Now >= item.UnlockEnd)
item.Lock = 0;
}
r.Close();
//r.Close();
r.Dispose();
return item;
}
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 LoadSpells(Client.GameState client, MySql.Data.MySqlClient.MySqlConnection conn)
{
if (client.Entity == null)
return;
client.Spells = new System.SafeDictionary<ushort, Interfaces.ISkill>(100);
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("skills").Where("EntityID", client.Entity.UID);
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
while (r.Read())
{
Interfaces.ISkill spell = new Network.GamePackets.Spell(true);
spell.ID = r.ReadUInt16("ID");
spell.Level = r.ReadByte("Level");
spell.PreviousLevel = r.ReadByte("PreviousLevel");
spell.Experience = r.ReadUInt32("Experience");
spell.TempLevel = r.ReadByte("TempLevel");
spell.Available = true;
if (!client.Spells.ContainsKey(spell.ID))
client.Spells.Add(spell.ID, spell);
}
r.Close();
r.Dispose();
}
public static void LoadProficiencies(Client.GameState client)
{
if (client.Entity == null)
return;
client.Proficiencies = new System.SafeDictionary<ushort, Interfaces.IProf>(100);
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("profs").Where("EntityID", client.Entity.UID);
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
while (r.Read())
{
Interfaces.IProf proficiency = new Network.GamePackets.Proficiency(true);
proficiency.ID = r.ReadUInt16("ID");
proficiency.Level = r.ReadByte("Level");
proficiency.PreviousLevel = r.ReadByte("PreviousLevel");
proficiency.Experience = r.ReadUInt32("Experience");
proficiency.TempLevel = r.ReadByte("TempLevel");
proficiency.Available = true;
if (!client.Proficiencies.ContainsKey(proficiency.ID))
client.Proficiencies.Add(proficiency.ID, proficiency);
}
r.Close();
r.Dispose();
}
public static void NextClan()
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("clans");
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
while (r.Read())
{
uint uid = r.ReadUInt32("ClanID");
if (uid > 0)
{
if (uid > Program.nextClanid)
Program.nextClanid = uid;
}
}
r.Close();
//r.Close();
r.Dispose();
Program.nextClanid += 1;
Console.WriteLine("Last Clan ID: " + Program.nextClanid + "");
}
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.");
}
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 void LoadMonsters()
{
// Companions = new SafeDictionary<uint, Entity>(1000);
Database.MySqlCommand command = new PhoenixProject.Database.MySqlCommand(PhoenixProject.Database.MySqlCommandType.SELECT);
command.Select("monsterspawns").Where("mapid", ID);
PhoenixProject.Database.MySqlReader reader = new PhoenixProject.Database.MySqlReader(command);
int mycount = 0;
try
{
while (reader.Read())
{
uint monsterID = reader.ReadUInt32("npctype");
ushort CircleDiameter = reader.ReadUInt16("maxnpc");
ushort X = reader.ReadUInt16("bound_x");
ushort Y = reader.ReadUInt16("bound_y");
ushort XPlus = reader.ReadUInt16("bound_cx");
ushort YPlus = reader.ReadUInt16("bound_cy");
ushort Amount = reader.ReadUInt16("max_per_gen");
int respawn = reader.ReadInt32("rest_secs");
if (Database.MonsterInformation.MonsterInfos.ContainsKey(monsterID))
{
Database.MonsterInformation mt = Database.MonsterInformation.MonsterInfos[monsterID];
mt.RespawnTime = respawn + 5;
mt.BoundX = X;
mt.BoundY = Y;
mt.BoundCX = XPlus;
mt.BoundCY = YPlus;
bool more = true;
for (int count = 0; count < Amount; count++)
{
if (!more)
break;
Entity entity = new Entity(EntityFlag.Monster, false);
entity.MapObjType = MapObjectType.Monster;
entity.MonsterInfo = mt.Copy();
entity.MonsterInfo.Owner = entity;
entity.Name = mt.Name;
entity.MinAttack = mt.MinAttack;
entity.MaxAttack = entity.MagicAttack = mt.MaxAttack;
entity.Hitpoints = entity.MaxHitpoints = mt.Hitpoints;
entity.Body = mt.Mesh;
entity.Level = mt.Level;
entity.UID = EntityUIDCounter.Next;
entity.MapID = ID;
entity.SendUpdates = true;
entity.X = (ushort)(X + ServerBase.Kernel.Random.Next(0, XPlus));
entity.Y = (ushort)(Y + ServerBase.Kernel.Random.Next(0, YPlus));
for (int count2 = 0; count2 < 50; count2++)
{
if (!Floor[entity.X, entity.Y, MapObjectType.Monster, entity])
{
entity.X = (ushort)(X + ServerBase.Kernel.Random.Next(0, XPlus));
entity.Y = (ushort)(Y + ServerBase.Kernel.Random.Next(0, YPlus));
if (count2 == 50)
more = false;
}
else
break;
}
if (more)
{
if (Floor[entity.X, entity.Y, MapObjectType.Monster, entity])
{
mycount++;
AddEntity(entity);
}
}
}
}
}
}
catch (Exception e) { Program.SaveException(e); }
reader.Close();
reader.Dispose();
if (mycount != 0)
{
MyTimer = new System.Timers.Timer(interval);
MyTimer.AutoReset = true;
MyTimer.Elapsed += new System.Timers.ElapsedEventHandler(_timerCallBack);
MyTimer.Start();
// _timercallback = new TimerCallback(_timerCallBack);
// _timer = new Timer(_timercallback, this, 10000, 1000);
}
}
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 LoadHouse()
{
MySqlCommand command = new MySqlCommand(MySqlCommandType.SELECT);
command.Select("house");
PhoenixProject.Database.MySqlReader reader = new PhoenixProject.Database.MySqlReader(command);
while (reader.Read())
{
uint id;
uint BaseID;
uint HouseLevel;
//MapsTable.MapInformation info = new MapsTable.MapInformation();
id = reader.ReadUInt16("id");
BaseID = 3024;
// info.Status = reader.ReadUInt32("type");
// info.Weather = reader.ReadUInt32("weather");
id = reader.ReadUInt32("owner");
HouseLevel = reader.ReadUInt32("HouseLevel");
// info.Box = reader.ReadUInt32("Box");
// info.BoxX = reader.ReadUInt32("BoxX");
// info.BoxY = reader.ReadUInt32("BoxY");
bool Success = CreateDynamicMap2(id, (ushort)BaseID, id, HouseLevel);
}
reader.Close();
reader.Dispose();
Console.WriteLine("Houses Loaded informations loaded.");
}
public static void NextUit()
{
if (rates.lastitem == 0)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("items");
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
while (r.Read())
{
uint uid = r.ReadUInt32("UID");
if (uid > 0)
{
if (uid > PhoenixProject.Client.AuthState.nextID)
PhoenixProject.Client.AuthState.nextID = uid;
}
if (uid == 0)
{
PhoenixProject.Client.AuthState.nextID = 1;
}
}
r.Close();
r.Dispose();
PhoenixProject.Client.AuthState.nextID += 1;
new Database.MySqlCommand(Database.MySqlCommandType.UPDATE).Update("rates").Set("LastItem", PhoenixProject.Client.AuthState.nextID).Where("Coder", "kimo").Execute();
Console.WriteLine("Last Item UID: " + PhoenixProject.Client.AuthState.nextID + "");
}
else
{
PhoenixProject.Client.AuthState.nextID = rates.lastitem;
PhoenixProject.Client.AuthState.nextID += 1;
Console.WriteLine("Last Item UID: " + PhoenixProject.Client.AuthState.nextID + "");
}
}
public static void NextEntity()
{
if (rates.lastentity == 0)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("entities");
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
uint uidd = 0;
while (r.Read())
{
uint uid = r.ReadUInt32("UID");
if (uid > 0)
{
if (uid > Program.nextEntityID)
{
Program.nextEntityID = uid;
uidd = uid;
}
}
}
r.Close();
r.Dispose();
if (uidd != 0)
{
Database.rates.lastentity = Program.nextEntityID;
Program.nextEntityID += 1;
new Database.MySqlCommand(Database.MySqlCommandType.UPDATE).Update("rates").Set("LastEntity", Program.nextEntityID).Where("Coder", "kimo").Execute();
}
else
{
Program.nextEntityID = 1000000;
Database.rates.lastentity = Program.nextEntityID;
new Database.MySqlCommand(Database.MySqlCommandType.UPDATE).Update("rates").Set("LastEntity", Program.nextEntityID).Where("Coder", "kimo").Execute();
}
Console.WriteLine("Last Entity UID: " + Program.nextEntityID + "");
}
else
{
Program.nextEntityID = rates.lastentity;
Program.nextEntityID += 1;
Console.WriteLine("Last Entity UID: " + Program.nextEntityID + "");
}
}
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();
}
