Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

Difference between revisions of "List of games available on Discord"

From PCGamingWiki, the wiki about fixing PC games
(migrated to Cargo query)
Line 5: Line 5:
  
 
==Auto-populated list==
 
==Auto-populated list==
−
'''Total number of games: '''{{#ask: [[Category:Games]] [[Available from::Discord]] |format=count }}
+
'''Total number of games: '''{{#cargo_query:
 +
tables=Availability
 +
|fields=COUNT(*)
 +
|where=Available_from HOLDS LIKE 'Discord'
 +
|format=text
 +
}}
  
−
{{#ask: [[Category:Games]] [[Available from::Discord]]
+
{{#cargo_query:
−
|?Part of series=Series
+
tables=Infobox_game,Availability
−
|?Developed by
+
|join on=Infobox_game._pageName=Availability._pageName
−
|?Published by
+
|where=Availability.Available_from HOLDS LIKE 'Discord'
−
|?Release date|+limit=1
+
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Available_on
−
|?Available on
+
|format=template
−
|format=table
+
|named args=yes
−
|limit=500
+
|limit=200
−
|template=Feature/row
+
|intro={{Game list/intro}}
−
|introtemplate=Feature/intro
+
|template=Game list/row
−
|outrotemplate=Feature/outro
+
|outro=</table>
−
|sep=,&ensp;
 
−
|mainlabel=Game
 
−
|headers=plain
 
 
}}
 
}}
  

Revision as of 05:50, 26 September 2021

This is a list of games on PCGamingWiki marked as being available for purchase on Discord.

Key points

As a result of Discord's move towards self-publishing for developers, which saw the termination of their general-purpose storefront, this list will most likely never be accurate as a lot of games can only be found through the official Discord servers of the developers, or by googling site:discord.com/store/skus[1]

Auto-populated list

Total number of games:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Availability._pageID'; this is incompatible with sql_mode=only_full_group_by (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)

Function: CargoSQLQuery::run Query: SELECT `cargo__Availability`.`_pageID` AS `cargo_backlink_page_id_Availability`,COUNT(*) FROM `cargo__Availability` WHERE `cargo__Availability`.`_ID` IN (SELECT `_rowID` FROM `cargo__Availability__Available_from` WHERE `_value`LIKE 'Discord') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100

No results


References

  1. ↑ Verified by User:Dandelion Sprout on 2021-06-13