Difference between revisions of "Black Squirrel/Cargo"

From Sega Retro
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
<pre>{{#cargo_query:
 +
table=roms
 +
|fields=name,sha1,md5,crc32,size,date,source,comments
 +
|where=format="SMS" AND (prototype IS NULL OR prototype != "yes")
 +
|limit=10000
 +
|format=template
 +
|template=RomDumpListRow
 +
}}</pre>
 +
 +
==testing==
 
{{#cargo_query:
 
{{#cargo_query:
−
table=ratings_table
+
table=releases,missedreleases
−
|fields=page,console,average,totalReviews
+
|fields=releases.name="name1",releases.console="format1",releases.region="region1",missedreleases.name="name2",missedreleases.format="format2",missedreleases.region="region2",releases.date="release date",missedreleases.date="missed date"
−
|format=table
+
|where=releases.console="MD" and missedreleases.format="MD"
 +
|join on=releases.name=missedreleases.name
 +
|limit=10000
 
}}
 
}}
  
−
There's meant to be a "Create data table" option for template pages. I saw it briefly but don't know how to get it to show - maybe it takes a while?
+
TODO: determine whether a game was not released in a certain region
−
 
 
−
Appending "?action=recreatedata" is meant to do the same thing, but I ain't seeing nout
 
−
 
 
−
 
 
−
there's a maintenance script too but I'll leave it overnight to see if anything shows.
 
−
 
 
  
−
[[Special:CargoTables]] -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 17:06, 4 November 2017 (CDT)
+
which is too much of a faff at 10:45 in the evening
−
: You're supposed to declare a table before you store. It should only be declared once in the noincluded bit. - [[User:Hivebrain|Hivebrain]] ([[User talk:Hivebrain|talk]]) 17:11, 4 November 2017 (CDT)
 
−
::Turns out it also helps if you use the right commands :) -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 04:33, 5 November 2017 (CST)
 

Latest revision as of 17:42, 20 April 2022

{{#cargo_query:
table=roms
|fields=name,sha1,md5,crc32,size,date,source,comments
|where=format="SMS" AND (prototype IS NULL OR prototype != "yes")
|limit=10000
|format=template
|template=RomDumpListRow
}}

testing

"name1" "format1" "region1" "name2" "format2" "region2" "release date" "missed date"
Shinobi III: Return of the Ninja Master MD AS Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD AU Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD AU_[[Sega Gold Collection|Gold]][[Category:Sega Gold Collection games]] Shinobi III: Return of the Ninja Master MD JP 1994 1992-12
Shinobi III: Return of the Ninja Master MD BR Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD DE Shinobi III: Return of the Ninja Master MD JP 1993 1992-12
Shinobi III: Return of the Ninja Master MD EU Shinobi III: Return of the Ninja Master MD JP 1993 1992-12
Shinobi III: Return of the Ninja Master MD EU_[[Classic Mega Drive|Classic]][[Category:Classic Mega Drive games]] Shinobi III: Return of the Ninja Master MD JP 1994-08-19 1992-12
Shinobi III: Return of the Ninja Master MD JP Shinobi III: Return of the Ninja Master MD JP 1993-07-23 1992-12
Shinobi III: Return of the Ninja Master MD KR Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD SE_Rental Shinobi III: Return of the Ninja Master MD JP 199x 1992-12
Shinobi III: Return of the Ninja Master MD UK Shinobi III: Return of the Ninja Master MD JP 1993-11 1992-12
Shinobi III: Return of the Ninja Master MD US Shinobi III: Return of the Ninja Master MD JP 1993-09 1992-12

TODO: determine whether a game was not released in a certain region

which is too much of a faff at 10:45 in the evening

Retrieved from "https://segaretro.org/index.php?title=User:Black_Squirrel/Cargo&oldid=770924"