public static void AddNewArenaInfo(Data.ArenaInfo arena)
{
using (var sql = new SqlHandler(Program.Config.ReadString("GameConnectionString")))
{
using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.INSERT, false))
{
cmd.AddInsertValue("PlayerID", arena.DatabaseID);
cmd.AddInsertValue("PlayerName", arena.Name);
cmd.AddInsertValue("ArenaLevel", arena.Level);
cmd.AddInsertValue("ArenaClass", arena.Class);
cmd.AddInsertValue("Mesh", arena.Mesh);
cmd.AddInsertValue("HonorPoints", arena.DatabaseID);
cmd.AddInsertValue("ArenaPoints", arena.ArenaPoints);
cmd.AddInsertValue("TotalWins", arena.ArenaTotalWins);
cmd.AddInsertValue("TotalWinsToday", arena.ArenaWinsToday);
cmd.AddInsertValue("TotalLoss", arena.ArenaTotalLoss);
cmd.AddInsertValue("TotalLossToday", arena.ArenaLossToday);
cmd.AddInsertValue("TodayUpdate", DateTime.Now);
cmd.Finish("DB_ArenaQualifier");
}
sql.Execute();
}
SetRecordID(arena);
}
public static void SetRecordID(Data.ArenaInfo arena)
{
using (var sql = new SqlHandler(Program.Config.ReadString("GameConnectionString")))
{
using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.SELECT, true))
{
cmd.AddWhereValue("PlayerID", arena.DatabaseID);
cmd.Finish("DB_ArenaQualifier");
}
if (sql.Read())
{
arena.ArenaID = sql.ReadInt32("ArenaID");
}
}
}
public static void SaveArenaInfo(Data.ArenaInfo arena)
{
using (var sql = new SqlHandler(Program.Config.ReadString("GameConnectionString")))
{
using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.UPDATE, true))
{
cmd.AddWhereValue("PlayerID", arena.DatabaseID);
cmd.AddUpdateValue("PlayerName", arena.Name);
cmd.AddUpdateValue("ArenaLevel", arena.Level);
cmd.AddUpdateValue("ArenaClass", arena.Class);
cmd.AddUpdateValue("Mesh", arena.Mesh);
cmd.AddUpdateValue("HonorPoints", arena.DatabaseID);
cmd.AddUpdateValue("ArenaPoints", arena.ArenaPoints);
cmd.AddUpdateValue("TotalWins", arena.ArenaTotalWins);
cmd.AddUpdateValue("TotalWinsToday", arena.ArenaWinsToday);
cmd.AddUpdateValue("TotalLoss", arena.ArenaTotalLoss);
cmd.AddUpdateValue("TotalLossToday", arena.ArenaLossToday);
cmd.Finish("DB_ArenaQualifier");
}
sql.Execute();
}
}
private void AppendInfo(Data.ArenaInfo Info)
{
WriteUInt32((uint)Info.ArenaID, InfoOffset);
InfoOffset += 4;
WriteString(Info.Name, InfoOffset);
InfoOffset += 16;
WriteUInt32(Info.Mesh, InfoOffset);
InfoOffset += 4;
WriteUInt32(Info.Level, InfoOffset);
InfoOffset += 4;
WriteUInt32(Info.Class, InfoOffset);
InfoOffset += 4;
WriteUInt32((uint)I + 1, InfoOffset);
InfoOffset += 4;
WriteUInt32((uint)I + 1, InfoOffset);
InfoOffset += 4;
WriteUInt32(Info.ArenaTotal, InfoOffset);
InfoOffset += 4;
WriteUInt32((uint)I + 1, InfoOffset);
InfoOffset += 4;
WriteUInt32((uint)I + 1, InfoOffset);
InfoOffset += 4;
I++;
}
public GameClient()
{
IsAIBot = true;
this.socketClient = new ProjectX_V3_Lib.Network.SocketClient();
socketClient.Owner = this;
socketClient.Crypto = new ProjectX_V3_Lib.Cryptography.GameCrypto(Program.Config.ReadString("GameKey").GetBytes());
_screen = new ProjectX_V3_Game.Core.Screen(this);
_baseentity = new BaseEntity(this);
_maxhp = 0;
_maxmp = 0;
_inventory = new ProjectX_V3_Game.Data.Inventory(this);
_equipments = new ProjectX_V3_Game.Data.Equipments(this);
_trade = new ProjectX_V3_Game.Data.TradeData();
_spelldata = new ProjectX_V3_Game.Data.SpellData(this);
_subclasses = new SubClasses();
Warehouses = new ConcurrentDictionary<ushort, ProjectX_V3_Game.Data.Warehouse>();
foreach (ushort whID in whids)
{
if (!Warehouses.TryAdd(whID, new Data.Warehouse(this, whID)))
throw new Exception("Failed to add Warehouse...");
}
TournamentScore = new ProjectX_V3_Game.Tournaments.TournamentScore();
TournamentInfo = new ProjectX_V3_Game.Tournaments.TournamentInfo(this);
Arena = new ProjectX_V3_Game.Data.ArenaInfo(this);
Pets = new ConcurrentDictionary<int, BattlePet>();
Permission = Enums.PlayerPermission.Normal;
}
