private void updateEquipment()
{
EquipmentTemplate result = equipment.FirstOrDefault(a => a.Entry == activeCreature.EquipmentTemplateId);
if (result != null)
{
activeEquipment = result;
txtEquipLeft.Text = activeEquipment.EquipEntry1;
txtEquipRight.Text = activeEquipment.EquipEntry2;
txtEquipRange.Text = activeEquipment.EquipEntry3;
}
else
{
txtEquipLeft.Text = "";
txtEquipRight.Text = "";
txtEquipRange.Text = "";
}
}
public List <EquipmentTemplate> GetEquipment()
{
string query = @"SELECT
A.Entry,
CONCAT(item1.name, ' (', A.EquipEntry1, ')') AS EquipEntry1,
CONCAT(item2.name, ' (', A.EquipEntry2, ')') AS EquipEntry2,
CONCAT(item3.name, ' (', A.EquipEntry3, ')') AS EquipEntry3
FROM creature_equip_template A
LEFT OUTER JOIN item_template item1 ON A.EquipEntry1 = item1.entry
LEFT OUTER JOIN item_template item2 ON A.EquipEntry2 = item2.entry
LEFT OUTER JOIN item_template item3 ON A.EquipEntry3 = item3.entry";
List <EquipmentTemplate> equipment = new List <EquipmentTemplate>();
if (OpenConnection())
{
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
EquipmentTemplate e = new EquipmentTemplate()
{
Entry = dataReader["Entry"].ToString(),
EquipEntry1 = dataReader["EquipEntry1"].ToString(),
EquipEntry2 = dataReader["EquipEntry2"].ToString(),
EquipEntry3 = dataReader["EquipEntry3"].ToString(),
};
equipment.Add(e);
}
dataReader.Close();
CloseConnection();
}
return(equipment);
}