5
static function getAll($release) {
8
$types = array('desktop', 'tablet', 'mobile', 'television', 'gaming');
10
$db = Factory::Database();
12
foreach($types AS $type) {
13
$result = $db->query("
15
v.platform, IFNULL(v.version,'') AS version, v.nickname, v.details, v.visible, IFNULL(p.related,p.platform) AS id, f.score
18
LEFT JOIN data_versions AS v ON (p.platform = v.platform)
19
LEFT JOIN scores AS s ON (v.platform = s.platform AND (v.version = s.version OR (v.version IS NULL AND s.version IS NULL)))
20
LEFT JOIN fingerprints AS f ON (f.fingerprint = s.fingerprint)
22
FIND_IN_SET('" . $type . "',v.type) AND
23
s.release = '" . $release . "' AND
26
v.platform, v.status='experimental', v.status='upcoming', ISNULL(v.releasedate), v.releasedate, v.version
29
while ($row = $result->fetch_object()) {
30
$row->uid = $type . '-' . $row->platform . '-' . $row->version;
32
$row->visible = $row->visible == '1';
b'\\ No newline at end of file'