Difference between revisions of "List of DRM-free games on GamersGate"
m (|headers=plain) |
(migrated to Cargo query) |
||
Line 9: | Line 9: | ||
{{ii}} This list was last refreshed on '''{{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}}'''. [{{fullurl:{{FULLPAGENAMEE}}|action=purge}} Purge] the page to refresh it. | {{ii}} This list was last refreshed on '''{{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}}'''. [{{fullurl:{{FULLPAGENAMEE}}|action=purge}} Purge] the page to refresh it. | ||
− | '''Total number of DRM-free games:''' {{# | + | '''Total number of DRM-free games:''' {{#cargo_query: |
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.GamersGate_DRM HOLDS LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} out of {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'GamersGate' | ||
+ | |format=text | ||
+ | }} games in total. | ||
− | {{# | + | {{#cargo_query: |
− | + | tables=Infobox_game,Availability | |
− | + | |join on=Infobox_game._pageName=Availability._pageName | |
− | + | |where=Availability.GamersGate_DRM HOLDS LIKE 'DRM-free' | |
− | + | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Infobox_game.Available_on,Availability.GamersGate_DRM=DRM | |
− | + | |format=template | |
− | + | |named args=yes | |
− | + | |limit=200 | |
− | + | |intro={{Game list/intro with DRM}} | |
− | + | |template=Game list/row with DRM | |
− | + | |outro=</table></div> | |
}} | }} | ||
Line 27: | Line 37: | ||
{{ii}} This list was last refreshed on '''{{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}}'''. [{{fullurl:{{FULLPAGENAMEE}}|action=purge}} Purge] the page to refresh it. | {{ii}} This list was last refreshed on '''{{CURRENTMONTHNAME}} {{CURRENTDAY}}, {{CURRENTYEAR}}'''. [{{fullurl:{{FULLPAGENAMEE}}|action=purge}} Purge] the page to refresh it. | ||
− | '''Total number of unverified or DRM protected games:''' {{# | + | '''Total number of unverified or DRM protected games:''' {{#cargo_query: |
− | + | tables=Availability | |
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'DRM-free' | ||
+ | |format=text | ||
+ | }} out of {{#cargo_query: | ||
+ | tables=Availability | ||
+ | |fields=COUNT(*) | ||
+ | |where=Availability.Available_from HOLDS LIKE 'GamersGate' | ||
+ | |format=text | ||
+ | }} games in total. | ||
− | {{# | + | {{#cargo_query: |
− | + | tables=Infobox_game,Availability | |
− | + | |join on=Infobox_game._pageName=Availability._pageName | |
− | + | |where=Availability.Available_from HOLDS LIKE 'GamersGate' AND Availability.GamersGate_DRM HOLDS NOT LIKE 'DRM-free' | |
− | + | |fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Infobox_game.Available_on,Availability.GamersGate_DRM=DRM | |
− | + | |format=template | |
− | + | |named args=yes | |
− | + | |limit=200 | |
− | + | |intro={{Game list/intro with DRM}} | |
− | + | |template=Game list/row with DRM | |
− | + | |outro=</table></div> | |
}} | }} | ||
[[Category:Lists]][[Category:Lists of DRM-free games]] | [[Category:Lists]][[Category:Lists of DRM-free games]] |
Revision as of 06:08, 3 October 2021
See List of DRM-free games for more platforms.
This is a list of games on PCGamingWiki marked as being released (as of June 18, 2024) and available for purchase on GamersGate that are flagged as DRM-free.
DRM-free
- This list was last refreshed on June 18, 2024. Purge the page to refresh it.
Total number of DRM-free games:
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__GamersGate_DRM` WHERE `_value`LIKE 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100
out of
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 'GamersGate') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100
games in total.
Unverified or DRM protected
- This list was last refreshed on June 18, 2024. Purge the page to refresh it.
Total number of unverified or DRM protected games:
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 'GamersGate') AND `cargo__Availability`.`_ID` NOT IN (SELECT `_rowID` FROM `cargo__Availability__GamersGate_DRM` WHERE `_value`LIKE 'DRM-free') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100
out of
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 'GamersGate') ORDER BY `cargo__Availability`.`_pageID`,COUNT(*) LIMIT 100
games in total.