public static string generateWeaponCode(Constructors.CharacterItem itm)
{
string retstr = "```";
retstr = retstr + "Item Class: " + itm.ItemClass + Environment.NewLine;
retstr = retstr + "Item Class: " + itm.ItemClass + Environment.NewLine;
retstr = retstr + "```";
return(null);
}
public static Constructors.CharacterItem getItemDetails(string charactername, string itemcode, string enhancement)
{
Constructors.CharacterItem item = new Constructors.CharacterItem();
string characterid = UserFunctions.getCharacterIdFromName(charactername);
if (String.IsNullOrEmpty(characterid))
{
return(null);
}
int enhancelevel = 0;
if (!int.TryParse(enhancement, out enhancelevel))
{
return(null);
}
if (enhancelevel < 0 || enhancelevel > 15)
{
return(null);
}
using (conn = new SqlConnection())
{
conn.ConnectionString = "Server=" + ini.IniReadValue("mssql", "ipandport") + "; Database=heroes; User Id=" + ini.IniReadValue("mssql", "username") + "; password="******"mssql", "password");
string oString = "SELECT TOP 1 * FROM Item WHERE OwnerID = @CID AND ItemClass LIKE @ItemClass";
SqlCommand oCmd = new SqlCommand(oString, conn);
oCmd.Parameters.AddWithValue("@CID", characterid);
oCmd.Parameters.AddWithValue("@ItemClass", "'%" + itemcode + "%'");
conn.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
if (!string.IsNullOrEmpty(oReader["ItemClass"].ToString()))
{
item.ItemClass = oReader["ItemClass"].ToString();
}
if (!string.IsNullOrEmpty(oReader["ID"].ToString()))
{
item.ItemID = oReader["ID"].ToString();
}
}
conn.Close();
}
}
using (conn = new SqlConnection())
{
conn.ConnectionString = "Server=" + ini.IniReadValue("mssql", "ipandport") + "; Database=heroes; User Id=" + ini.IniReadValue("mssql", "username") + "; password="******"mssql", "password");
string oString = "SELECT * FROM ItemAttribute WHERE ItemID = @ItemID";
SqlCommand oCmd = new SqlCommand(oString, conn);
oCmd.Parameters.AddWithValue("@ItemID", item.ItemID);
conn.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
switch (oReader["Attribute"].ToString())
{
case "ANTIBIND":
item.BindCount = oReader["Value"].ToString();
break;
case "COMBINATION":
item.Combination = oReader["Value"].ToString();
break;
case "ENHANCE":
item.Enhancement = oReader["Value"].ToString();
break;
case "LOOK":
item.Look = oReader["Value"].ToString();
break;
case "PREFIX":
item.Prefix = oReader["Value"].ToString();
break;
case "PS_0":
item.PS0 = new Tuple <string, string, string>(oReader["Value"].ToString(), oReader["Arg"].ToString(), oReader["Arg2"].ToString());
break;
case "PS_1":
item.PS1.Add(oReader["Value"].ToString(), oReader["Arg"].ToString());
break;
case "PS_2":
item.PS2.Add(oReader["Value"].ToString(), oReader["Arg"].ToString());
break;
case "PS_3":
item.PS3.Add(oReader["Value"].ToString(), oReader["Arg"].ToString());
break;
case "PS_4":
item.PS4.Add(oReader["Value"].ToString(), oReader["Arg"].ToString());
break;
case "SUFFIX":
item.Suffix = oReader["Value"].ToString();
break;
case "QUALITY":
item.Quality.Add(oReader["Value"].ToString(), oReader["Arg"].ToString());
break;
case "RESTORED":
if (oReader["Value"].ToString() == "1")
{
item.Restored = true;
}
else
{
item.Restored = false;
}
break;
case "SPIRIT_INJECTION":
item.Infusion.Add(oReader["Value"].ToString(), oReader["Arg"].ToString());
break;
}
}
conn.Close();
}
}
return(item);
}
