public static SQLPlayerGearItems CreateEmpty()
{
SQLPlayerGearItems value = new SQLPlayerGearItems();
value.Items = new Dictionary <ItemSlot, SQLIngameItemID>();
return(value);
}
public bool GetPlayerGearItems(SQLPlayerData _PlayerData, out SQLPlayerGearItems _ResultGearItems)
{
var conn = OpenConnection();
try
{
const int HEAD_COLUMN = 0;
const int NECK_COLUMN = 1;
const int SHOULDER_COLUMN = 2;
const int SHIRT_COLUMN = 3;
const int CHEST_COLUMN = 4;
const int BELT_COLUMN = 5;
const int LEGS_COLUMN = 6;
const int FEET_COLUMN = 7;
const int WRIST_COLUMN = 8;
const int GLOVES_COLUMN = 9;
const int FINGER1_COLUMN = 10;
const int FINGER2_COLUMN = 11;
const int TRINKET1_COLUMN = 12;
const int TRINKET2_COLUMN = 13;
const int BACK_COLUMN = 14;
const int MAINHAND_COLUMN = 15;
const int OFFHAND_COLUMN = 16;
const int RANGED_COLUMN = 17;
const int TABARD_COLUMN = 18;
using (var cmd = new NpgsqlCommand("SELECT 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 FROM PlayerGearTable WHERE id=: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.Read() == true)
{
_ResultGearItems = SQLPlayerGearItems.CreateEmpty();
_ResultGearItems.Items.Add(ItemSlot.Head, new SQLIngameItemID(reader.GetInt32(HEAD_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Neck, new SQLIngameItemID(reader.GetInt32(NECK_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Shoulder, new SQLIngameItemID(reader.GetInt32(SHOULDER_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Shirt, new SQLIngameItemID(reader.GetInt32(SHIRT_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Chest, new SQLIngameItemID(reader.GetInt32(CHEST_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Belt, new SQLIngameItemID(reader.GetInt32(BELT_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Legs, new SQLIngameItemID(reader.GetInt32(LEGS_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Feet, new SQLIngameItemID(reader.GetInt32(FEET_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Wrist, new SQLIngameItemID(reader.GetInt32(WRIST_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Gloves, new SQLIngameItemID(reader.GetInt32(GLOVES_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Finger_1, new SQLIngameItemID(reader.GetInt32(FINGER1_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Finger_2, new SQLIngameItemID(reader.GetInt32(FINGER2_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Trinket_1, new SQLIngameItemID(reader.GetInt32(TRINKET1_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Trinket_2, new SQLIngameItemID(reader.GetInt32(TRINKET2_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Back, new SQLIngameItemID(reader.GetInt32(BACK_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Main_Hand, new SQLIngameItemID(reader.GetInt32(MAINHAND_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Off_Hand, new SQLIngameItemID(reader.GetInt32(OFFHAND_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Ranged, new SQLIngameItemID(reader.GetInt32(RANGED_COLUMN)));
_ResultGearItems.Items.Add(ItemSlot.Tabard, new SQLIngameItemID(reader.GetInt32(TABARD_COLUMN)));
_ResultGearItems.Items.RemoveAll((_V) => _V.Value.ID == 0);
return(true);
}
}
}
}
finally
{
CloseConnection();
}
_ResultGearItems = SQLPlayerGearItems.CreateEmpty();
return(false);
}
