public async static Task <uint> TrySearchAppId(CommandArguments command)
{
uint appID = 0;
var name = command.Message;
Uri uri;
var query = new Dictionary <string, string>
{
{ "hitsPerPage", "1" },
{ "attributesToHighlight", "null" },
{ "attributesToSnippet", "null" },
{ "attributesToRetrieve", "[\"objectID\"]" },
{ "facetFilters", "[[\"appType:Game\",\"appType:Application\"]]" },
{ "advancedSyntax", "true" },
{ "query", name }
};
using (var content = new FormUrlEncodedContent(query))
{
uri = new UriBuilder("https://94he6yatei-dsn.algolia.net/1/indexes/steamdb/")
{
Query = await content.ReadAsStringAsync()
}.Uri;
}
using (var webClient = new HttpClient())
{
webClient.DefaultRequestHeaders.Add("Referer", "https://github.com/SteamDatabase/SteamDatabaseBackend");
webClient.DefaultRequestHeaders.Add("X-Algolia-Application-Id", "94HE6YATEI");
webClient.DefaultRequestHeaders.Add("X-Algolia-API-Key", "2414d3366df67739fe6e73dad3f51a43");
var data = await webClient.GetStringAsync(uri);
dynamic json = JsonConvert.DeserializeObject(data);
if (json.hits?.Count > 0)
{
appID = json.hits[0].objectID;
}
}
if (appID > 0)
{
return(appID);
}
if (!Utils.ConvertUserInputToSQLSearch(ref name))
{
command.Reply("Your request is invalid or too short.");
return(0);
}
using (var db = Database.Get())
{
appID = await db.ExecuteScalarAsync <uint>("SELECT `AppID` FROM `Apps` LEFT JOIN `AppsTypes` ON `Apps`.`AppType` = `AppsTypes`.`AppType` WHERE (`AppsTypes`.`Name` IN ('game', 'application', 'video', 'hardware') AND (`Apps`.`StoreName` LIKE @Name OR `Apps`.`Name` LIKE @Name)) OR (`AppsTypes`.`Name` = 'unknown' AND `Apps`.`LastKnownName` LIKE @Name) ORDER BY `LastUpdated` DESC LIMIT 1", new { Name = name });
}
return(appID);
}
public override void OnCommand(CommandArguments command)
{
if (command.Message.Length == 0)
{
CommandHandler.ReplyToCommand(command, "Usage:{0} app <appid or partial game name>", Colors.OLIVE);
return;
}
var count = PICSProductInfo.ProcessedApps.Count;
if (count > 100)
{
CommandHandler.ReplyToCommand(command, "There are currently {0} apps awaiting to be processed, try again later.", count);
return;
}
uint appID;
if (!uint.TryParse(command.Message, out appID))
{
string name = command.Message;
if (!Utils.ConvertUserInputToSQLSearch(ref name))
{
CommandHandler.ReplyToCommand(command, "Your request is invalid or too short.");
return;
}
using (var db = Database.GetConnection())
{
appID = db.ExecuteScalar <uint>("SELECT `AppID` FROM `Apps` WHERE `Apps`.`StoreName` LIKE @Name OR `Apps`.`Name` LIKE @Name OR `Apps`.`LastKnownName` LIKE @Name ORDER BY `LastUpdated` DESC LIMIT 1", new { Name = name });
}
if (appID == 0)
{
CommandHandler.ReplyToCommand(command, "Nothing was found matching your request.");
return;
}
}
var apps = new List <uint>();
apps.Add(appID);
JobManager.AddJob(
() => Steam.Instance.Apps.PICSGetAccessTokens(apps, Enumerable.Empty <uint>()),
new JobManager.IRCRequest
{
Target = appID,
Type = JobManager.IRCRequestType.TYPE_APP,
Command = command
}
);
}
public override void OnCommand(CommandArguments command)
{
if (command.Message.Length == 0)
{
CommandHandler.ReplyToCommand(command, "Usage:{0} players <appid or partial game name>", Colors.OLIVE);
CommandHandler.ReplyToCommand(command, true, "Use {0}^{1} and {2}${3} just like in regex to narrow down your match, e.g:{4} !players Portal$", Colors.BLUE, Colors.NORMAL, Colors.BLUE, Colors.NORMAL, Colors.OLIVE);
return;
}
uint appID;
if (!uint.TryParse(command.Message, out appID))
{
string name = command.Message;
if (!Utils.ConvertUserInputToSQLSearch(ref name))
{
CommandHandler.ReplyToCommand(command, "Your request is invalid or too short.");
return;
}
using (var db = Database.GetConnection())
{
appID = db.ExecuteScalar <uint>("SELECT `AppID` FROM `Apps` LEFT JOIN `AppsTypes` ON `Apps`.`AppType` = `AppsTypes`.`AppType` WHERE (`AppsTypes`.`Name` IN ('game', 'application') AND (`Apps`.`StoreName` LIKE @Name OR `Apps`.`Name` LIKE @Name)) OR (`AppsTypes`.`Name` = 'unknown' AND `Apps`.`LastKnownName` LIKE @Name) ORDER BY `LastUpdated` DESC LIMIT 1", new { Name = name });
}
if (appID == 0)
{
CommandHandler.ReplyToCommand(command, "Nothing was found matching your request.");
return;
}
}
JobManager.AddJob(
() => Steam.Instance.UserStats.GetNumberOfCurrentPlayers(appID),
new JobManager.IRCRequest
{
Target = appID,
Command = command
}
);
}
public override async Task OnCommand(CommandArguments command)
{
if (command.Message.Length == 0)
{
command.Reply("Usage:{0} app <appid or partial game name>", Colors.OLIVE);
return;
}
string name;
if (!uint.TryParse(command.Message, out var appID))
{
name = command.Message;
if (!Utils.ConvertUserInputToSQLSearch(ref name))
{
command.Reply("Your request is invalid or too short.");
return;
}
using (var db = Database.GetConnection())
{
appID = db.ExecuteScalar <uint>("SELECT `AppID` FROM `Apps` WHERE `Apps`.`StoreName` LIKE @Name OR `Apps`.`Name` LIKE @Name OR `Apps`.`LastKnownName` LIKE @Name ORDER BY `LastUpdated` DESC LIMIT 1", new { Name = name });
}
if (appID == 0)
{
command.Reply("Nothing was found matching your request.");
return;
}
}
var tokenCallback = await Steam.Instance.Apps.PICSGetAccessTokens(appID, null);
SteamApps.PICSRequest request;
if (tokenCallback.AppTokens.ContainsKey(appID))
{
request = Utils.NewPICSRequest(appID, tokenCallback.AppTokens[appID]);
}
else
{
request = Utils.NewPICSRequest(appID);
}
var job = await Steam.Instance.Apps.PICSGetProductInfo(new List <SteamApps.PICSRequest> {
request
}, Enumerable.Empty <SteamApps.PICSRequest>());
var callback = job.Results.FirstOrDefault(x => x.Apps.ContainsKey(appID));
if (callback == null)
{
command.Reply("Unknown AppID: {0}{1}{2}", Colors.BLUE, appID, LicenseList.OwnedApps.ContainsKey(appID) ? SteamDB.StringCheckmark : string.Empty);
return;
}
var info = callback.Apps[appID];
if (info.KeyValues["common"]["name"].Value != null)
{
name = Utils.RemoveControlCharacters(info.KeyValues["common"]["name"].AsString());
}
else
{
name = Steam.GetAppName(info.ID);
}
info.KeyValues.SaveToFile(Path.Combine(Application.Path, "app", string.Format("{0}.vdf", info.ID)), false);
command.Reply("{0}{1}{2} -{3} {4}{5} - Dump:{6} {7}{8}{9}{10}",
Colors.BLUE, name, Colors.NORMAL,
Colors.DARKBLUE, SteamDB.GetAppURL(info.ID), Colors.NORMAL,
Colors.DARKBLUE, SteamDB.GetRawAppURL(info.ID), Colors.NORMAL,
info.MissingToken ? SteamDB.StringNeedToken : string.Empty,
LicenseList.OwnedApps.ContainsKey(info.ID) ? SteamDB.StringCheckmark : string.Empty
);
if (command.IsUserAdmin && !LicenseList.OwnedApps.ContainsKey(info.ID))
{
JobManager.AddJob(() => Steam.Instance.Apps.RequestFreeLicense(info.ID));
}
}
public override async Task OnCommand(CommandArguments command)
{
if (command.Message.Length == 0)
{
command.Reply("Usage:{0} players <appid or partial game name>", Colors.OLIVE);
return;
}
uint appID;
string name;
if (!uint.TryParse(command.Message, out appID))
{
name = command.Message;
using (var webClient = new WebClient())
{
webClient.QueryString.Add("x-algolia-application-id", "94HE6YATEI");
webClient.QueryString.Add("x-algolia-api-key", "2414d3366df67739fe6e73dad3f51a43");
webClient.QueryString.Add("hitsPerPage", "1");
webClient.QueryString.Add("attributesToHighlight", "null");
webClient.QueryString.Add("attributesToSnippet", "null");
webClient.QueryString.Add("attributesToRetrieve", "[\"objectID\"]");
webClient.QueryString.Add("facetFilters", "[[\"appType:Game\",\"appType:Application\"]]");
webClient.QueryString.Add("advancedSyntax", "true");
webClient.QueryString.Add("query", name);
var data = await webClient.DownloadStringTaskAsync("https://94he6yatei-dsn.algolia.net/1/indexes/steamdb/");
dynamic json = JsonConvert.DeserializeObject(data);
if (json.hits != null && json.hits.Count > 0)
{
appID = json.hits[0].objectID;
}
}
if (appID == 0)
{
if (!Utils.ConvertUserInputToSQLSearch(ref name))
{
command.Reply("Your request is invalid or too short.");
return;
}
using (var db = Database.GetConnection())
{
appID = db.ExecuteScalar <uint>("SELECT `AppID` FROM `Apps` LEFT JOIN `AppsTypes` ON `Apps`.`AppType` = `AppsTypes`.`AppType` WHERE (`AppsTypes`.`Name` IN ('game', 'application', 'video', 'hardware') AND (`Apps`.`StoreName` LIKE @Name OR `Apps`.`Name` LIKE @Name)) OR (`AppsTypes`.`Name` = 'unknown' AND `Apps`.`LastKnownName` LIKE @Name) ORDER BY `LastUpdated` DESC LIMIT 1", new { Name = name });
}
}
if (appID == 0)
{
command.Reply("Nothing was found matching your request.");
return;
}
}
var callback = await Steam.Instance.UserStats.GetNumberOfCurrentPlayers(appID);
if (appID == 0)
{
appID = 753;
}
string appType, type = "playing";
name = Steam.GetAppName(appID, out appType);
if (callback.Result != EResult.OK)
{
command.Reply("Unable to request player count for {0}{1}{2}: {3}{4}", Colors.BLUE, name, Colors.NORMAL, Colors.RED, callback.Result);
return;
}
switch (appType)
{
case "Tool":
case "Config":
case "Application":
type = "using";
break;
case "Legacy Media":
case "Video":
type = "watching";
break;
case "Guide":
type = "reading";
break;
case "Hardware":
type = "bricking";
break;
}
command.Reply(
"People {0} {1}{2}{3} right now: {4}{5:N0}{6} -{7} {8}",
type,
Colors.BLUE, name, Colors.NORMAL,
Colors.OLIVE, callback.NumPlayers, Colors.NORMAL,
Colors.DARKBLUE, SteamDB.GetAppURL(appID, "graphs")
);
}
public override async Task OnCommand(CommandArguments command)
{
await Task.Yield();
if (command.Message.Length == 0)
{
command.Reply("Usage:{0} players <appid or partial game name>", Colors.OLIVE);
command.Notice("Use {0}^{1} and {2}${3} just like in regex to narrow down your match, e.g:{4} !players Portal$", Colors.BLUE, Colors.NORMAL, Colors.BLUE, Colors.NORMAL, Colors.OLIVE);
return;
}
uint appID;
string name;
if (!uint.TryParse(command.Message, out appID))
{
name = command.Message;
if (!Utils.ConvertUserInputToSQLSearch(ref name))
{
command.Reply("Your request is invalid or too short.");
return;
}
using (var db = Database.GetConnection())
{
appID = db.ExecuteScalar <uint>("SELECT `AppID` FROM `Apps` LEFT JOIN `AppsTypes` ON `Apps`.`AppType` = `AppsTypes`.`AppType` WHERE (`AppsTypes`.`Name` IN ('game', 'application', 'video', 'hardware') AND (`Apps`.`StoreName` LIKE @Name OR `Apps`.`Name` LIKE @Name)) OR (`AppsTypes`.`Name` = 'unknown' AND `Apps`.`LastKnownName` LIKE @Name) ORDER BY `LastUpdated` DESC LIMIT 1", new { Name = name });
}
if (appID == 0)
{
command.Reply("Nothing was found matching your request.");
return;
}
}
KeyValue result;
using (dynamic userStats = WebAPI.GetInterface("ISteamUserStats"))
{
userStats.Timeout = (int)TimeSpan.FromSeconds(5).TotalMilliseconds;
try
{
result = userStats.GetNumberOfCurrentPlayers(
appid: appID
);
}
catch (WebException e)
{
if (e.Status == WebExceptionStatus.Timeout)
{
throw new TaskCanceledException();
}
var response = (HttpWebResponse)e.Response;
command.Reply("Unable to request player count: {0}{1}", Colors.RED, response.StatusDescription);
return;
}
}
var eResult = (EResult)result["result"].AsInteger();
if (eResult != EResult.OK)
{
command.Reply("Unable to request player count: {0}{1}", Colors.RED, eResult);
return;
}
if (appID == 0)
{
appID = 753;
}
string appType, type = "playing";
name = Steam.GetAppName(appID, out appType);
switch (appType)
{
case "Tool":
case "Config":
case "Application":
type = "using";
break;
case "Legacy Media":
case "Video":
type = "watching";
break;
case "Guide":
type = "reading";
break;
case "Hardware":
type = "bricking";
break;
}
command.Reply(
"People {0} {1}{2}{3} right now: {4}{5:N0}{6} -{7} {8}",
type,
Colors.BLUE, name, Colors.NORMAL,
Colors.OLIVE, result["player_count"].AsInteger(), Colors.NORMAL,
Colors.DARKBLUE, SteamDB.GetAppURL(appID, "graphs")
);
}
public override async void OnCommand(CommandArguments command)
{
if (command.Message.Length == 0)
{
CommandHandler.ReplyToCommand(command, "Usage:{0} players <appid or partial game name>", Colors.OLIVE);
CommandHandler.ReplyToCommand(command, true, "Use {0}^{1} and {2}${3} just like in regex to narrow down your match, e.g:{4} !players Portal$", Colors.BLUE, Colors.NORMAL, Colors.BLUE, Colors.NORMAL, Colors.OLIVE);
return;
}
uint appID;
if (!uint.TryParse(command.Message, out appID))
{
string name = command.Message;
if (!Utils.ConvertUserInputToSQLSearch(ref name))
{
CommandHandler.ReplyToCommand(command, "Your request is invalid or too short.");
return;
}
using (var db = Database.GetConnection())
{
appID = db.ExecuteScalar <uint>("SELECT `AppID` FROM `Apps` LEFT JOIN `AppsTypes` ON `Apps`.`AppType` = `AppsTypes`.`AppType` WHERE (`AppsTypes`.`Name` IN ('game', 'application') AND (`Apps`.`StoreName` LIKE @Name OR `Apps`.`Name` LIKE @Name)) OR (`AppsTypes`.`Name` = 'unknown' AND `Apps`.`LastKnownName` LIKE @Name) ORDER BY `LastUpdated` DESC LIMIT 1", new { Name = name });
}
if (appID == 0)
{
CommandHandler.ReplyToCommand(command, "Nothing was found matching your request.");
return;
}
}
var callback = await Steam.Instance.UserStats.GetNumberOfCurrentPlayers(appID);
if (callback.Result != EResult.OK)
{
CommandHandler.ReplyToCommand(command, "Unable to request player count: {0}{1}", Colors.RED, callback.Result);
}
else if (appID == 0)
{
CommandHandler.ReplyToCommand(
command,
"{0}{1:N0}{2} people praising lord Gaben right now, influence:{3} {4}",
Colors.OLIVE, callback.NumPlayers, Colors.NORMAL,
Colors.DARKBLUE, SteamDB.GetAppURL(753, "graphs")
);
}
else
{
CommandHandler.ReplyToCommand(
command,
"People playing {0}{1}{2} right now: {3}{4:N0}{5} -{6} {7}",
Colors.BLUE, Steam.GetAppName(appID), Colors.NORMAL,
Colors.OLIVE, callback.NumPlayers, Colors.NORMAL,
Colors.DARKBLUE, SteamDB.GetAppURL(appID, "graphs")
);
}
}
public override async Task OnCommand(CommandArguments command)
{
if (command.Message.Length == 0)
{
command.Reply("Usage:{0} players <appid or partial game name>", Colors.OLIVE);
command.Notice("Use {0}^{1} and {2}${3} just like in regex to narrow down your match, e.g:{4} !players Portal$", Colors.BLUE, Colors.NORMAL, Colors.BLUE, Colors.NORMAL, Colors.OLIVE);
return;
}
uint appID;
string name;
if (!uint.TryParse(command.Message, out appID))
{
name = command.Message;
if (!Utils.ConvertUserInputToSQLSearch(ref name))
{
command.Reply("Your request is invalid or too short.");
return;
}
using (var db = Database.GetConnection())
{
appID = db.ExecuteScalar <uint>("SELECT `AppID` FROM `Apps` LEFT JOIN `AppsTypes` ON `Apps`.`AppType` = `AppsTypes`.`AppType` WHERE (`AppsTypes`.`Name` IN ('game', 'application', 'video', 'hardware') AND (`Apps`.`StoreName` LIKE @Name OR `Apps`.`Name` LIKE @Name)) OR (`AppsTypes`.`Name` = 'unknown' AND `Apps`.`LastKnownName` LIKE @Name) ORDER BY `LastUpdated` DESC LIMIT 1", new { Name = name });
}
if (appID == 0)
{
command.Reply("Nothing was found matching your request.");
return;
}
}
var callback = await Steam.Instance.UserStats.GetNumberOfCurrentPlayers(appID);
if (appID == 0)
{
appID = 753;
}
string appType, type = "playing";
name = Steam.GetAppName(appID, out appType);
if (callback.Result != EResult.OK)
{
command.Reply("Unable to request player count for {0}{1}{2}: {3}{4}", Colors.BLUE, name, Colors.NORMAL, Colors.RED, callback.Result);
return;
}
switch (appType)
{
case "Tool":
case "Config":
case "Application":
type = "using";
break;
case "Legacy Media":
case "Video":
type = "watching";
break;
case "Guide":
type = "reading";
break;
case "Hardware":
type = "bricking";
break;
}
command.Reply(
"People {0} {1}{2}{3} right now: {4}{5:N0}{6} -{7} {8}",
type,
Colors.BLUE, name, Colors.NORMAL,
Colors.OLIVE, callback.NumPlayers, Colors.NORMAL,
Colors.DARKBLUE, SteamDB.GetAppURL(appID, "graphs")
);
}
