public PlayerData.ItemInfo GenerateItemInfo(ItemSlot _Slot, SQLGemInfo _GemInfo)
{
int[] gemIDs = new int[4];
gemIDs[0] = _GemInfo.GemID1;
gemIDs[1] = _GemInfo.GemID2;
gemIDs[2] = _GemInfo.GemID3;
gemIDs[3] = _GemInfo.GemID4;
return(GenerateItemInfo(_Slot, gemIDs));
}
public bool GetPlayerGearGems(SQLPlayerData _PlayerData, out SQLPlayerGearGems _ResultGearGems)
{
var conn = OpenConnection();
try
{
const int ITEMSLOT_COLUMN = 0;
const int GEMID1_COLUMN = 1;
const int GEMID2_COLUMN = 2;
const int GEMID3_COLUMN = 3;
const int GEMID4_COLUMN = 4;
using (var cmd = new NpgsqlCommand("SELECT itemslot, gemid1, gemid2, gemid3, gemid4 FROM PlayerGearGemsTable WHERE gearid=:ID", conn))
{
{
var idParam = new NpgsqlParameter("ID", NpgsqlDbType.Integer);
idParam.Value = (int)_PlayerData.PlayerGearID;
cmd.Parameters.Add(idParam);
}
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows == true)
{
_ResultGearGems = SQLPlayerGearGems.CreateEmpty();
while (reader.Read() == true)
{
SQLGemInfo gemInfo = new SQLGemInfo();
ItemSlot itemSlot = (ItemSlot)reader.GetInt16(ITEMSLOT_COLUMN);
gemInfo.GemID1 = reader.GetInt32(GEMID1_COLUMN);
gemInfo.GemID2 = reader.GetInt32(GEMID2_COLUMN);
gemInfo.GemID3 = reader.GetInt32(GEMID3_COLUMN);
gemInfo.GemID4 = reader.GetInt32(GEMID4_COLUMN);
_ResultGearGems.Gems.Add(itemSlot, gemInfo);
}
return(true);
}
}
}
}
finally
{
CloseConnection();
}
_ResultGearGems = SQLPlayerGearGems.CreateEmpty();
return(false);
}
public int GenerateNewPlayerGearDataEntry(PlayerData.GearData _GearData, WowVersionEnum _WowVersion)
{
if (_GearData == null)
{
return(0);
}
Dictionary <ItemSlot, SQLIngameItemID> ingameItemIDs = new Dictionary <ItemSlot, SQLIngameItemID>();
foreach (ItemSlot slot in Enum.GetValues(typeof(ItemSlot)))
{
ingameItemIDs.Add(slot, new SQLIngameItemID(0));
}
foreach (var item in _GearData.Items)
{
SQLIngameItemID itemID = GenerateNewIngameItemEntry(new SQLIngameItemInfo(item.Value));
ingameItemIDs.AddOrSet(item.Key, itemID);
}
int gearDataEntryID = 0;
var conn = OpenConnection();
try
{
using (var cmd = new NpgsqlCommand("INSERT INTO playergeartable(id, head, neck, shoulder, shirt, chest, belt, legs, feet, wrist, gloves, finger_1, finger_2, trinket_1, trinket_2, back, main_hand, off_hand, ranged, tabard) VALUES (DEFAULT, :Head, :Neck, :Shoulder, :Shirt, :Chest, :Belt, :Legs, :Feet, :Wrist, :Gloves, :Finger_1, :Finger_2, :Trinket_1, :Trinket_2, :Back, :Main_Hand, :Off_Hand, :Ranged, :Tabard) RETURNING id", conn))
{
cmd.Parameters.Add(new NpgsqlParameter("Head", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Head];
cmd.Parameters.Add(new NpgsqlParameter("Neck", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Neck];
cmd.Parameters.Add(new NpgsqlParameter("Shoulder", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Shoulder];
cmd.Parameters.Add(new NpgsqlParameter("Shirt", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Shirt];
cmd.Parameters.Add(new NpgsqlParameter("Chest", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Chest];
cmd.Parameters.Add(new NpgsqlParameter("Belt", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Belt];
cmd.Parameters.Add(new NpgsqlParameter("Legs", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Legs];
cmd.Parameters.Add(new NpgsqlParameter("Feet", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Feet];
cmd.Parameters.Add(new NpgsqlParameter("Wrist", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Wrist];
cmd.Parameters.Add(new NpgsqlParameter("Gloves", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Gloves];
cmd.Parameters.Add(new NpgsqlParameter("Finger_1", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Finger_1];
cmd.Parameters.Add(new NpgsqlParameter("Finger_2", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Finger_2];
cmd.Parameters.Add(new NpgsqlParameter("Trinket_1", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Trinket_1];
cmd.Parameters.Add(new NpgsqlParameter("Trinket_2", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Trinket_2];
cmd.Parameters.Add(new NpgsqlParameter("Back", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Back];
cmd.Parameters.Add(new NpgsqlParameter("Main_Hand", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Main_Hand];
cmd.Parameters.Add(new NpgsqlParameter("Off_Hand", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Off_Hand];
cmd.Parameters.Add(new NpgsqlParameter("Ranged", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Ranged];
cmd.Parameters.Add(new NpgsqlParameter("Tabard", NpgsqlDbType.Integer)).Value = (int)ingameItemIDs[ItemSlot.Tabard];
using (var reader = cmd.ExecuteReader())
{
if (reader.Read() == true)
{
gearDataEntryID = reader.GetInt32(0);
}
}
}
if (gearDataEntryID != 0 && _WowVersion != WowVersionEnum.Vanilla)
{
//There may be gems we should add to the geardata!
Dictionary <ItemSlot, SQLGemInfo> gems = new Dictionary <ItemSlot, SQLGemInfo>();
foreach (var item in _GearData.Items)
{
if (item.Value.GemIDs != null)
{
SQLGemInfo gemInfo = new SQLGemInfo(item.Value.GemIDs);
if (gemInfo.IsNull() == false)
{
gems.Add(item.Key, gemInfo);
}
}
}
if (gems.Count > 0)
{
GenerateNewPlayerGearGemEntries(gearDataEntryID, gems);
}
}
}
finally
{
CloseConnection();
}
return(gearDataEntryID);
}