public static string GetSteamIDInfo(SteamBot.Bot bot, SteamKit2.SteamID steamId)
{
string output = "";
output += "| steamname: " + bot.SteamFriends.GetFriendPersonaName(steamId);
output += "\r\n| steamID32: " + steamId.ToString();
output += "\r\n| steamID64: http://steamcommunity.com/profiles/" + steamId.ConvertToUInt64();
output += "\r\n| steamrep: http://steamrep.com/profiles/" + steamId.ConvertToUInt64();
return output;
}
public static void setBotInventory(SteamKit2.SteamID botID, int defindex, int count)
{
try
{
MySqlCommand cmd = new MySqlCommand(String.Format("INSERT INTO bot_inventory (bot_id,defindex,count) VALUES ({0},{1},{2}) ON DUPLICATE KEY UPDATE count={2};", botID.ConvertToUInt64(), defindex, count), conn);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
log.Error("Error caching inventory: " + e.Message);
}
}
public static void wipeBotInventory(SteamKit2.SteamID botID)
{
try
{
MySqlCommand cmd = new MySqlCommand("DELETE FROM bot_inventory WHERE bot_id="+botID.ConvertToUInt64(), conn);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
log.Error("Error wiping cache inventory: " + e.Message);
}
}
public static int getUserRank(SteamKit2.SteamID id)
{
try
{
MySqlCommand cmd = new MySqlCommand("SELECT `rank_id` FROM users WHERE steam_id=" + id.ConvertToUInt64(), conn);
return (int)cmd.ExecuteScalar();
}
catch (Exception e)
{
log.Error("Error updating user rank: " + e.Message);
}
return -1;
}