public static string sendValidation(string charactername, string mailSender)
{
string characterId = UserFunctions.getCharacterIdFromName(charactername);
try
{
string mailText = mailSender + " has requested this character to be linked to their discord account. If this was not done by you, please report this to staff immidately. If this was done by you, please enter the following text in discord: !validate ASFA";
using (conn = new SqlConnection())
{
conn.ConnectionString = "Server=" + ini.IniReadValue("mssql", "ipandport") + "; Database=heroes; User Id=" + ini.IniReadValue("mssql", "username") + "; password="******"mssql", "password");
string oString = "INSERT INTO QueuedItem (CID, ItemClassEx, IsCharacterBinded, Count, MailContent, MailTitle, Color1, Color2, Color3, ReducedDurability, MaxDurabilityBonus) " + "VALUES (@CID, @ItemClassEx, 0, @Count, @MailContent, @MailTitle,-1 ,-1 ,-1 ,0 ,0)";
SqlCommand oCmd = new SqlCommand(oString, conn);
oCmd.Parameters.AddWithValue("@CID", characterId);
oCmd.Parameters.AddWithValue("@ItemClassEx", "cooking_egg");
oCmd.Parameters.AddWithValue("@Count", 1);
oCmd.Parameters.AddWithValue("@MailContent", mailText);
oCmd.Parameters.AddWithValue("@MailTitle", "Iset Account Validation");
conn.Open();
oCmd.ExecuteNonQuery();
conn.Close();
return("The item has been sent to " + charactername + "! They will need to relog or run a quest to see the mail!");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static string forceRestoreItem(string character, string wepcode, string staff)
//!restoreweapon <charactername> <enhancement level> <weapon type> [quality] [prefix] [suffix] [fusion]
{
string charid = UserFunctions.getCharacterIdFromName(character);
string accountId = UserFunctions.getUserIdFromCharacterName(character);
string accountName = UserFunctions.getAccountNameFromID(accountId);
if (string.IsNullOrEmpty(charid))
{
return("Invalid character name!");
}
List <string> restoredItems = hasRestored(accountId);
int maxRestoredWeapons = 1;
int.TryParse(ini.IniReadValue("misc", "maxitemrestoresperaccount"), out maxRestoredWeapons);
if (restoredItems.Count() >= maxRestoredWeapons)
{
string retstr = "An item has allready been restored for " + character + "!";
return(retstr);
}
string wepToRestore = null;
try
{
if (string.IsNullOrEmpty(wepcode))
{
return("Invalid or missing weapon code!");
}
wepToRestore = wepcode;
if (!string.IsNullOrEmpty(wepToRestore))
{
SendMail(character, wepToRestore, 1, "Here is your weapon restore. Please be warned, the next destruction of this weapon will be permanant! You now have 0 weapon/item restores available.", "BloodRedDawn Item Restoration");
logRestore(staff, accountId, accountName, character, wepToRestore);
}
}
catch (Exception ex)
{
return(ex.Message);
}
Logging.LogItem(character + " has had an item restored by " + staff + ". Item code: " + wepToRestore, staff, "forcerestoreweapon - " + character, wepToRestore);
return("The weapon has been found and restored for " + character + "!");
}
public static string dyeItem(string charactername, string itemtoDye, string slot1, string slot2, string slot3)
{
string characterid = UserFunctions.getCharacterIdFromName(charactername);
if (string.IsNullOrEmpty(characterid))
{
return("Invalid Character Name!");
}
string itemID = findItemID(characterid, itemtoDye);
if (string.IsNullOrEmpty(itemID))
{
return("Invalid item name!");
}
int slt1 = 0;
int slt2 = 0;
int slt3 = 0;
if (!int.TryParse(slot1, out slt1))
{
return("Invalid Color given for slot 1!");
}
if (!int.TryParse(slot2, out slt2))
{
return("Invalid Color given for slot 2!");
}
if (!int.TryParse(slot3, out slt3))
{
return("Invalid Color given for slot 3!");
}
try
{
using (conn = new SqlConnection())
{
conn.ConnectionString = "Server=" + ini.IniReadValue("mssql", "ipandport") + "; Database=heroes; User Id=" + ini.IniReadValue("mssql", "username") + "; password="******"mssql", "password");
string oString = "UPDATE Equippable SET";
if (slt1 >= 0)
{
oString = oString + " Color1 = @fColor1";
}
if (slt2 >= 0)
{
if (slt1 >= 0)
{
oString = oString + ",";
}
oString = oString + " Color2 = @fColor2";
}
if (slt3 >= 0)
{
if (slt2 >= 0 || slt1 >= 0)
{
oString = oString + ",";
}
oString = oString + " Color3 = @fColor3";
}
oString = oString + " WHERE ID = @fName";
SqlCommand oCmd = new SqlCommand(oString, conn);
oCmd.Parameters.AddWithValue("@fName", itemID);
if (slt1 >= 0)
{
oCmd.Parameters.AddWithValue("@fColor1", slt1);
}
if (slt2 >= 0)
{
oCmd.Parameters.AddWithValue("@fColor2", slt2);
}
if (slt3 >= 0)
{
oCmd.Parameters.AddWithValue("@fColor3", slt3);
}
conn.Open();
oCmd.ExecuteNonQuery();
conn.Close();
}
}
catch (SqlException ex)
{
return(ex.Message);
}
return("The item colors have been changed! " + charactername + " will need to re-equip the item to see the changes.");
}
public static string SendMail(string charactername, string itemtospawn, int count, string mailcontent, string mailsender, string staffname = "Iset")
{
List <string> mailToList = null;
string retmsg = "The item has been sent to ";
if (charactername == "all")
{
mailToList = UserFunctions.playerList("id", "all");
if (mailToList.Count() <= 0)
{
return("error getting players!");
}
retmsg = retmsg + "all players (" + mailToList.Count().ToString() + ")";
}
else if (charactername == "allonline")
{
mailToList = UserFunctions.playerList("id", "online");
if (mailToList.Count() <= 0)
{
return("There are no players online!");
}
retmsg = retmsg + "all online players (" + mailToList.Count().ToString() + ")";
}
else
{
mailToList = new List <string>();
mailToList.Add(UserFunctions.getCharacterIdFromName(charactername));
retmsg = retmsg + charactername;
}
string itemCode = itemtospawn;
if (itemCode != "gold")
{
if (itemCode.Contains("COMBINATION:"))
{
if (!itemCode.Contains("ANTIBIND"))
{
itemCode = itemCode.Replace("]", ",") + "ANTIBIND:3]";
}
if (!itemCode.Contains("RESTORED"))
{
itemCode = itemCode.Replace("]", ",") + "RESTORED:1]";
}
}
else
{
itemCode = itemCode + "[ANTIBIND:3][RESTORED:1]";
}
}
try
{
foreach (string recipient in mailToList)
{
using (conn = new SqlConnection())
{
conn.ConnectionString = "Server=" + ini.IniReadValue("mssql", "ipandport") + "; Database=heroes; User Id=" + ini.IniReadValue("mssql", "username") + "; password="******"mssql", "password");
string oString = "INSERT INTO QueuedItem (CID, ItemClassEx, IsCharacterBinded, Count, MailContent, MailTitle, Color1, Color2, Color3, ReducedDurability, MaxDurabilityBonus) " + "VALUES (@CID, @ItemClassEx, 1, @Count, @MailContent, @MailTitle,-1 ,-1 ,-1 ,0 ,0)";
SqlCommand oCmd = new SqlCommand(oString, conn);
oCmd.Parameters.AddWithValue("@CID", recipient);
oCmd.Parameters.AddWithValue("@ItemClassEx", itemCode);
oCmd.Parameters.AddWithValue("@Count", count);
oCmd.Parameters.AddWithValue("@MailContent", mailcontent);
oCmd.Parameters.AddWithValue("@MailTitle", mailsender);
conn.Open();
oCmd.ExecuteNonQuery();
conn.Close();
}
logSpawn(staffname.Replace("()", ""), recipient, charactername, itemCode, count.ToString());
}
}
catch (Exception ex)
{
return(ex.Message);
}
retmsg = retmsg + "! They will need to relog or run a quest to see the mail!";
return(retmsg);
}
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);
}
public static string restoreItem(string character, string enhancement, string weapontype, string staff)
//!restoreweapon <charactername> <enhancement level> <weapon type> [quality] [prefix] [suffix] [fusion]
{
string charid = UserFunctions.getCharacterIdFromName(character);
string accountId = UserFunctions.getUserIdFromCharacterName(character);
string accountName = UserFunctions.getAccountNameFromID(accountId);
if (string.IsNullOrEmpty(charid))
{
return("Invalid character name!");
}
List <string> restoredItems = hasRestored(accountId);
int maxRestoredWeapons = 1;
int.TryParse(ini.IniReadValue("misc", "maxitemrestoresperaccount"), out maxRestoredWeapons);
if (restoredItems.Count() >= maxRestoredWeapons)
{
string retstr = "An item has allready been restored for " + character + "!";
return(retstr);
}
string wepToRestore = null;
try
{
using (conn = new SqlConnection())
{
conn.ConnectionString = "Server=" + ini.IniReadValue("mssql", "ipandport") + "; Database=heroesLog; User Id=" + ini.IniReadValue("mssql", "username") + "; password="******"mssql", "password");
string oString = "SELECT TOP 1 ItemClass FROM ItemLedger01 WHERE ItemClass LIKE @fWeaponType ESCAPE ' ' AND ItemClass LIKE @fEnhance AND CharacterID = @fName ORDER BY TIME ASC";
SqlCommand oCmd = new SqlCommand(oString, conn);
oCmd.Parameters.AddWithValue("@fName", charid);
oCmd.Parameters.AddWithValue("@fEnhance", "%ENHANCE:" + enhancement + "%");
oCmd.Parameters.AddWithValue("@fWeaponType", "%" + weapontype + "%");
conn.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
if (!string.IsNullOrEmpty(oReader["ItemClass"].ToString()))
{
wepToRestore = oReader["ItemClass"].ToString();
}
}
conn.Close();
}
}
if (string.IsNullOrEmpty(wepToRestore))
{
using (conn = new SqlConnection())
{
conn.ConnectionString = "Server=" + ini.IniReadValue("mssql", "ipandport") + "; Database=heroesLog; User Id=" + ini.IniReadValue("mssql", "username") + "; password="******"mssql", "password");
string oString = "SELECT TOP 1 ItemClass FROM ItemLedger02 WHERE ItemClass LIKE @fWeaponType ESCAPE ' ' AND ItemClass LIKE @fEnhance AND CharacterID = @fName ORDER BY TIME ASC";
SqlCommand oCmd = new SqlCommand(oString, conn);
oCmd.Parameters.AddWithValue("@fName", charid);
oCmd.Parameters.AddWithValue("@fEnhance", "%ENHANCE:" + enhancement + "%");
oCmd.Parameters.AddWithValue("@fWeaponType", "%" + weapontype + "%");
conn.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
if (!string.IsNullOrEmpty(oReader["ItemClass"].ToString()))
{
wepToRestore = oReader["ItemClass"].ToString();
}
}
conn.Close();
}
}
if (string.IsNullOrEmpty(wepToRestore))
{
return("Weapon not found!");
}
}
if (!string.IsNullOrEmpty(wepToRestore))
{
SendMail(character, wepToRestore, 1, "Here is your weapon restore. Please be warned, the next destruction of this weapon will be permanant! You now have 0 weapon/item restores available.", "BloodRedDawn Item Restoration");
logRestore(staff, accountId, accountName, character, wepToRestore);
}
}
catch (SqlException ex)
{
Logging.OldLogItem(ex.Message);
return(ex.Message);
}
Logging.LogItem(character + " has had an item restored by " + staff + ". Item code: " + wepToRestore, staff, "restoreweapon - " + character, wepToRestore);
return("The weapon has been found and restored for " + character + "!");
}
