private void LoadItemData()
{
// Load in item name
MySqlDataReader ItemQuery = ExcuteSQLQuery("SELECT name FROM item_base WHERE id = '" + m_CurrentItem + "'");
// See if we found data
if (ItemQuery.HasRows)
{
ItemQuery.Read();
ItemName.Text = ItemQuery.GetString(0);
}
// remove all data
m_EffectIDNum.Clear();
// Set it all to 0
for (int y = 0; y < 5; y++)
{
m_BoxList[y].EffectBox.SelectedIndex = 0;
}
// Find all Effects on this item
DataTable dataTable = new DataTable();
MySqlConnection conn = new MySqlConnection(DB.GetLoginStr());
String query = "SELECT ItemEffectID, item_effect_base_id, Var1Data, Var2Data, Var3Data FROM item_effects WHERE ItemID = '" + m_CurrentItem + "'";
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(query, conn);
mySqlDataAdapter.Fill(dataTable);
int x = 0;
foreach (DataRow r in dataTable.Rows)
{
m_BoxList[x].EffectBox.Enabled = true;
m_EffectIDNum.Add((int)r["ItemEffectID"]);
int EffID = (int)r["item_effect_base_id"];
m_BoxList[x].EffectBox.SelectedIndex = FindEffectID(EffID);
m_BoxList[x].Var1.Text = r["Var1Data"].ToString();
m_BoxList[x].Var2.Text = r["Var2Data"].ToString();
m_BoxList[x].Var3.Text = r["Var3Data"].ToString();
x++;
// Make sure we dont go over the count #
if (x >= m_BoxList.Count)
{
break;
}
}
// Fill rest with 0's
for (; x < 5; x++)
{
m_BoxList[x].EffectBox.Enabled = true;
m_EffectIDNum.Add(0);
}
// Zero this out, if we cant find a container when we save
// we will create a new one
m_CurrentContainer = 0;
// Find containers for Activateable Only
DataTable ContainerDataTable = new DataTable();
MySqlConnection ContainConn = new MySqlConnection(DB.GetLoginStr());
String ContainerQuery = "SELECT EffectContainerID,RechargeTime,Unknown2,_Range,Unknown4, EnergyUse FROM Item_effect_container WHERE EquipEffect = '1' AND ItemID = '" + m_CurrentItem + "'";
MySqlDataAdapter ContainermySqlDataAdapter = new MySqlDataAdapter(ContainerQuery, ContainConn);
ContainermySqlDataAdapter.Fill(ContainerDataTable);
if (ContainerDataTable.Rows.Count > 0)
{
// Read in the data (will only have 1 row)
DataRow r = ContainerDataTable.Rows[0];
m_CurrentContainer = (int)r["EffectContainerID"];
Range.Text = r["_Range"].ToString();
CoolDown.Text = r["RechargeTime"].ToString();
EnergyUse.Text = r["EnergyUse"].ToString();
}
else
{
Range.Text = "0";
CoolDown.Text = "0";
EnergyUse.Text = "0";
}
// Enable effects to be changed
//EnableEffects(true);
}
