X-Git-Url: https://git.cweiske.de/stouyapi.git/blobdiff_plain/d8aa0c48c958b9ae357c10bab443e9c58edde9ef..b29b50fec73ea9c3e78a058e5c8948a0d0e5f053:/bin/import-game-data.php diff --git a/bin/import-game-data.php b/bin/import-game-data.php index b6c1917..5d454f4 100755 --- a/bin/import-game-data.php +++ b/bin/import-game-data.php @@ -18,6 +18,8 @@ if (!is_file($foldersFile)) { } //default configuration values +$GLOBALS['baseUrl'] = 'http://ouya.cweiske.de/'; +$GLOBALS['categorySubtitles'] = []; $GLOBALS['packagelists'] = []; $GLOBALS['urlRewrites'] = []; $cfgFile = __DIR__ . '/../config.php'; @@ -27,6 +29,11 @@ if (file_exists($cfgFile)) { $wwwDir = __DIR__ . '/../www/'; +$qrDir = $wwwDir . 'gen-qr/'; +if (!is_dir($qrDir)) { + mkdir($qrDir, 0775); +} + $baseDir = dirname($foldersFile); $gameFiles = []; foreach (file($foldersFile) as $line) { @@ -43,9 +50,18 @@ foreach (file($foldersFile) as $line) { } } +//store git repository version of last folder +$workdir = getcwd(); +chdir($folder); +$gitDate = `git log --max-count=1 --format="%h %cI"`; +chdir($workdir); +file_put_contents($wwwDir . '/game-data-version', $gitDate); + $games = []; $count = 0; $developers = []; + +//load game data. doing early to collect a developer's games foreach ($gameFiles as $gameFile) { $game = json_decode(file_get_contents($gameFile)); if ($game === null) { @@ -54,18 +70,18 @@ foreach ($gameFiles as $gameFile) { addMissingGameProperties($game); $games[$game->packageName] = $game; - writeJson( - 'api/v1/details-data/' . $game->packageName . '.json', - buildDetails($game) - ); - if (!isset($developers[$game->developer->uuid])) { $developers[$game->developer->uuid] = [ - 'info' => $game->developer, - 'products' => [], + 'info' => $game->developer, + 'products' => [], + 'gameNames' => [], ]; } + $developers[$game->developer->uuid]['gameNames'][] = $game->packageName; +} +//write json api files +foreach ($games as $game) { $products = $game->products ?? []; foreach ($products as $product) { writeJson( @@ -76,7 +92,14 @@ foreach ($gameFiles as $gameFile) { $developers[$game->developer->uuid]['products'][] = $product; } - /**/ + writeJson( + 'api/v1/details-data/' . $game->packageName . '.json', + buildDetails( + $game, + count($developers[$game->developer->uuid]['gameNames']) > 1 + ) + ); + writeJson( 'api/v1/games/' . $game->packageName . '/purchases', buildPurchases($game) @@ -116,6 +139,16 @@ foreach ($developers as $developer) { . '/current_gamer', buildDeveloperCurrentGamer() ); + + if (count($developer['gameNames']) > 1) { + writeJson( + 'api/v1/discover-data/dev--' . $developer['info']->uuid . '.json', + buildSpecialCategory( + 'Developer: ' . $developer['info']->name, + filterByPackageNames($games, $developer['gameNames']) + ) + ); + } } writeJson('api/v1/discover-data/discover.json', buildDiscover($games)); @@ -147,12 +180,12 @@ function buildDiscover(array $games) ]; addDiscoverRow( - $data, 'Last Updated', - filterLastUpdated($games, 10) + $data, 'New games', + filterLastAdded($games, 10) ); addDiscoverRow( - $data, 'Best rated', - filterBestRated($games, 10), + $data, 'Best rated games', + filterBestRatedGames($games, 10), true ); @@ -167,14 +200,20 @@ function buildDiscover(array $games) $data, 'Special', [ 'Best rated', + 'Best rated games', 'Most rated', 'Random', + 'Last updated', ] ); writeJson( 'api/v1/discover-data/' . categoryPath('Best rated') . '.json', buildSpecialCategory('Best rated', filterBestRated($games, 99)) ); + writeJson( + 'api/v1/discover-data/' . categoryPath('Best rated games') . '.json', + buildSpecialCategory('Best rated games', filterBestRatedGames($games, 99)) + ); writeJson( 'api/v1/discover-data/' . categoryPath('Most rated') . '.json', buildSpecialCategory('Most rated', filterMostDownloaded($games, 99)) @@ -186,6 +225,10 @@ function buildDiscover(array $games) filterRandom($games, 99) ) ); + writeJson( + 'api/v1/discover-data/' . categoryPath('Last updated') . '.json', + buildSpecialCategory('Last updated', filterLastUpdated($games, 99)) + ); $players = [ //1 => '1 player', @@ -197,7 +240,18 @@ function buildDiscover(array $games) foreach ($players as $num => $title) { writeJson( 'api/v1/discover-data/' . categoryPath($title) . '.json', - buildDiscoverCategory($title, filterByPlayers($games, $num)) + buildDiscoverCategory( + $title, + //I do not want emulators here, + // and neither Streaming apps + filterByGenre( + filterByGenre( + filterByPlayers($games, $num), + 'Emulator', true + ), + 'App', true + ) + ) ); } @@ -244,15 +298,21 @@ function buildDiscoverCategory($name, $games) 'rows' => [], 'tiles' => [], ]; - addDiscoverRow( - $data, 'Last Updated', - filterLastUpdated($games, 10) - ); - addDiscoverRow( - $data, 'Best rated', - filterBestRated($games, 10), - true - ); + if (isset($GLOBALS['categorySubtitles'][$name])) { + $data['stouyapi']['subtitle'] = $GLOBALS['categorySubtitles'][$name]; + } + + if (count($games) >= 20) { + addDiscoverRow( + $data, 'Last Updated', + filterLastUpdated($games, 10) + ); + addDiscoverRow( + $data, 'Best rated', + filterBestRated($games, 10), + true + ); + } $games = sortByTitle($games); $chunks = array_chunk($games, 4); @@ -277,6 +337,11 @@ function buildMakeCategory($name, $games) return $data; } +/** + * Category without the "Last updated" or "Best rated" top rows + * + * Used for "Best rated", "Most rated", "Random" + */ function buildSpecialCategory($name, $games) { $data = [ @@ -386,7 +451,7 @@ function buildAppDownload($game, $release) 'fileSize' => $release->size, 'version' => $release->uuid, 'contentRating' => $game->contentRating, - 'downloadLink' => rewriteUrl($release->url), + 'downloadLink' => $release->url, ] ]; } @@ -412,7 +477,7 @@ function buildProduct($product) /** * Build /app/v1/details?app=org.example.game */ -function buildDetails($game) +function buildDetails($game, $linkDeveloperPage = false) { $latestRelease = $game->latestRelease; @@ -467,11 +532,18 @@ function buildDetails($game) $iaUrl = dirname($game->latestRelease->url) . '/'; } + $description = $game->description; + if (isset($game->notes) && trim($game->notes)) { + $description = "Technical notes:\r\n" . $game->notes + . "\r\n----\r\n" + . $description; + } + // http://cweiske.de/ouya-store-api-docs.htm#get-https-devs-ouya-tv-api-v1-details - return [ + $data = [ 'type' => 'Game', 'title' => $game->title, - 'description' => $game->description, + 'description' => $description, 'gamerNumbers' => $game->players, 'genres' => $game->genres, @@ -531,6 +603,13 @@ function buildDetails($game) 'developer-url' => $game->developer->website ?? null, ] ]; + + if ($linkDeveloperPage) { + $data['developer']['url'] = 'ouya://launcher/discover/dev--' + . categoryPath($game->developer->uuid); + } + + return $data; } function buildDeveloperCurrentGamer() @@ -783,7 +862,9 @@ function addMissingGameProperties($game) $game->rating->count = 0; } + $game->firstRelease = null; $game->latestRelease = null; + $firstReleaseTimestamp = null; $latestReleaseTimestamp = 0; foreach ($game->releases as $release) { if (!isset($release->publicSize)) { @@ -798,6 +879,15 @@ function addMissingGameProperties($game) $game->latestRelease = $release; $latestReleaseTimestamp = $releaseTimestamp; } + if ($firstReleaseTimestamp === null + || $releaseTimestamp < $firstReleaseTimestamp + ) { + $game->firstRelease = $release; + $firstReleaseTimestamp = $releaseTimestamp; + } + } + if ($game->firstRelease === null) { + error('No first release for ' . $game->packageName); } if ($game->latestRelease === null) { error('No latest release for ' . $game->packageName); @@ -822,6 +912,34 @@ function addMissingGameProperties($game) if (!isset($game->developer->founder)) { $game->developer->founder = false; } + + if ($game->website) { + $qrfileName = preg_replace('#[^\\w\\d._-]#', '_', $game->website) . '.png'; + $qrfilePath = $GLOBALS['qrDir'] . $qrfileName; + if (!file_exists($qrfilePath)) { + $cmd = __DIR__ . '/create-qr.sh' + . ' ' . escapeshellarg($game->website) + . ' ' . escapeshellarg($qrfilePath); + passthru($cmd, $retval); + if ($retval != 0) { + exit(20); + } + } + $qrUrlPath = $GLOBALS['baseUrl'] . 'gen-qr/' . $qrfileName; + $game->media[] = (object) [ + 'type' => 'image', + 'url' => $qrUrlPath, + ]; + } + + //rewrite urls from Internet Archive to our servers + $game->discover = rewriteUrl($game->discover); + foreach ($game->media as $medium) { + $medium->url = rewriteUrl($medium->url); + } + foreach ($game->releases as $release) { + $release->url = rewriteUrl($release->url); + } } /**