Difference between revisions of "User:Ebrehe"
Line 1: | Line 1: | ||
+ | {{#cargo_query: | ||
+ | tables=Infobox_game,Tags,Multiplayer | ||
+ | |join on=Infobox_game._pageName=Tags._pageName,Infobox_game._pageName=Multiplayer._pageName | ||
+ | |where=Multiplayer.LAN='true' AND Lan.Online_players <= 1 | ||
+ | |fields=Infobox_game._pageName,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Released,Infobox_game.Available_on,Multiplayer.LAN,Multiplayer.Online | ||
+ | |format=template | ||
+ | |named args=yes | ||
+ | |limit=950 | ||
+ | |intro={{Multiplayer list/intro}} | ||
+ | |template=Multiplayer list/row | ||
+ | |outro=</table> | ||
+ | }} | ||
+ | |||
+ | |||
+ | |||
!lobiler | !lobiler | ||
==Native support== | ==Native support== | ||
Line 8: | Line 23: | ||
|format=template | |format=template | ||
|named args=yes | |named args=yes | ||
− | |limit= | + | |limit=50 |
|intro={{Multiplayer list/intro}} | |intro={{Multiplayer list/intro}} | ||
|template=Multiplayer list/row | |template=Multiplayer list/row | ||
Line 51: | Line 66: | ||
|format=template | |format=template | ||
|named args=yes | |named args=yes | ||
− | |limit= | + | |limit=8 |
|intro={{Game list/intro}} | |intro={{Game list/intro}} | ||
|template=Game list/row | |template=Game list/row |
Revision as of 15:00, 1 March 2024
Function: CargoSQLQuery::run Query: SELECT `cargo__Multiplayer`.`_pageID` AS `cargo_backlink_page_id_Multiplayer`,`cargo__Tags`.`_pageID` AS `cargo_backlink_page_id_Tags`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,`cargo__Infobox_game`.`_pageName` AS `_pageName`,`Developers__full` AS `Developers`,`Publishers__full` AS `Publishers`,`Released__full` AS `Released`,`Available_on__full` AS `Available on`,`cargo__Multiplayer`.`LAN` AS `LAN`,`cargo__Multiplayer`.`Online` AS `Online`,`cargo__Infobox_game`.`Released__precision` AS `Released__precision` FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Tags` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Tags`.`_pageName`)) LEFT OUTER JOIN `cargo__Multiplayer` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Multiplayer`.`_pageName`)) WHERE `cargo__Multiplayer`.`LAN`='true' AND Lan.Online_players <= 1 ORDER BY `cargo__Multiplayer`.`_pageID`,`cargo__Tags`.`_pageID`,`cargo__Infobox_game`.`_pageID`,`cargo__Infobox_game`.`_pageName`,`cargo__Infobox_game`.`Developers__full` LIMIT 100
!lobiler
Native support
No results Total number of games: 1,250
Hackable support
For instance ways to play online games on offline servers.
Total number of games: 125
Game | Series | Developer | Publisher | First release | Available on |
---|---|---|---|---|---|
Age of Empires | Age of Empires | Ensemble Studios | Microsoft, Ubisoft, MacSoft | October 15, 1997 | |
Age of Empires II: The Age of Kings | Age of Empires | Ensemble Studios | Microsoft, Ubisoft, MacSoft | October 10, 1999 | |
Age of Mythology | Age of Empires | Ensemble Studios | Microsoft Game Studios, Ubisoft, MacSoft | October 30, 2002 | |
Aliens versus Predator 2 | Aliens versus Predator | Monolith Productions, Third Law Interactive | Sierra Entertainment, Fox Interactive, MacPlay, Capcom | October 30, 2001 | |
Arma 2 | Arma | Bohemia Interactive | 505 Games, Got Game Entertainment, Akella | June 17, 2009 | |
Arma: Cold War Assault | Arma, Operation Flashpoint | Bohemia Interactive | Codemasters, Sold Out Software, Buka Entertainment | June 22, 2001 | |
Atomic Bomberman | Bomberman | Interplay Entertainment | Interplay Entertainment, Sold Out Software | July 31, 1997 | |
Battlefield 1942 | Battlefield | DICE | Electronic Arts | September 10, 2002 |