Difference between revisions of "ProductionHistory"

From Sega Retro

(Created page with "I've got this sorting by the release date, however it's not sorting by the ''earliest'' release date of a game - it's the first added to the releases template. So basically i...")
 
 
(One intermediate revision by one other user not shown)
Line 7: Line 7:
  
 
It will take the first result (2005) and use that to help define an order. My SQL skills are not good enough to get this to sort a table before joining. -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 15:42, 27 August 2018 (CDT)
 
It will take the first result (2005) and use that to help define an order. My SQL skills are not good enough to get this to sort a table before joining. -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 15:42, 27 August 2018 (CDT)
 +
 +
 +
It seems that some data stored in the cargo table is not displayed. Why? --[[User:Akane|Akiyama Akane]] ([[User talk:Akane|talk]]) 21:52, 29 September 2018 (CDT)
 +
 +
For example,
 +
*[[AeroWings]]
 +
**[[Katsumi Yabuno]]
 +
**[[Naoshi Kunisawa]]
 +
**[[Seiji Aoki]]
 +
 +
==Bugs==
 +
{{TODO}}
 +
Some Sonic games are being added twice (e.g. [[Yuji Naka]]), except the second (or first?) time there isn't a format specified
 +
 +
https://segaretro.org/index.php?title=Special%3ACargoQuery&tables=credits&fields=_pageName%3DPage%2Crole%3Drole%2Cname%3Dname%2Cgame%3Dgame%2Cconsole%3Dconsole%2Cdate%3Ddate%2Cpdf%3Dpdf%2Cpdfpage%3Dpdfpage&where=game%3D%22Sonic+%26+Knuckles%22&join_on=&group_by=&having=&order_by%5B0%5D=&order_by_options%5B0%5D=ASC&limit=500&offset=0&format=
 +
 +
I'm going to guess it's a caching thing. I'd rather not rebuild the table so let's see if this is an issue next time I see this page -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 14:57, 27 April 2022 (EDT)

Latest revision as of 14:57, 27 April 2022

I've got this sorting by the release date, however it's not sorting by the earliest release date of a game - it's the first added to the releases template.

So basically if you define

  • JP: 2005
  • US: 2004

It will take the first result (2005) and use that to help define an order. My SQL skills are not good enough to get this to sort a table before joining. -Black Squirrel (talk) 15:42, 27 August 2018 (CDT)


It seems that some data stored in the cargo table is not displayed. Why? --Akiyama Akane (talk) 21:52, 29 September 2018 (CDT)

For example,

Bugs

Clock.svg
This task is unfinished
This is a wiki task that requires more thought or peer review. An important issue that needs to be solved, which will appear at the top of Sega Retro:Todo until this message is removed.

Some Sonic games are being added twice (e.g. Yuji Naka), except the second (or first?) time there isn't a format specified

https://segaretro.org/index.php?title=Special%3ACargoQuery&tables=credits&fields=_pageName%3DPage%2Crole%3Drole%2Cname%3Dname%2Cgame%3Dgame%2Cconsole%3Dconsole%2Cdate%3Ddate%2Cpdf%3Dpdf%2Cpdfpage%3Dpdfpage&where=game%3D%22Sonic+%26+Knuckles%22&join_on=&group_by=&having=&order_by%5B0%5D=&order_by_options%5B0%5D=ASC&limit=500&offset=0&format=

I'm going to guess it's a caching thing. I'd rather not rebuild the table so let's see if this is an issue next time I see this page -Black Squirrel (talk) 14:57, 27 April 2022 (EDT)