From a81b7c142b680d5d5526a6e4c1865dcad245600f Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 22 May 2019 13:07:33 +0200 Subject: feed.php -> feeds.php --- feed.php | 490 -------------------------------------------------------------- feeds.php | 490 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 490 insertions(+), 490 deletions(-) delete mode 100644 feed.php create mode 100644 feeds.php diff --git a/feed.php b/feed.php deleted file mode 100644 index 70320e9..0000000 --- a/feed.php +++ /dev/null @@ -1,490 +0,0 @@ - fetch_assoc()) - $archs[$row['name']] = $row['name'] . '/'; - - $print_archs = array_merge( - array( - '' => '', - 'All Arches' => 'all/' - ), - $archs - ); - - $result = mysql_run_query( - "SELECT DISTINCT `repositories`.`name` FROM `repositories` WHERE `repositories`.`is_on_master_mirror` ORDER BY `name`" - ); - $repos = array(); - while ($row = $result -> fetch_assoc()) - $repos[$row['name']] = $row['name'] . '/'; - - $print_repos = array_merge( - array( - 'All Repos' => '' - ), - $repos - ); - - $bugtracker_projects = array( - 0 => 'All Projects', - 1 => 'Arch Linux 32' - ); - - $bugtracker_operations = array( - 'Opened' => '', - 'Edited' => 'topic=edit&', - 'Closed' => 'topic=clo&' - ); - - function print_arches_header() { - global $print_archs; - foreach ($print_archs as $arch => $dummy) { - print " \n"; - print " " . $arch . "\n"; - print " \n"; - }; - } - - function print_feeds($prefix) { - global $print_archs; - global $print_repos; - foreach ($print_repos as $repo => $dummy) { - print " \n"; - print " \n"; - print " " . $repo . "\n"; - print " \n"; - foreach ($print_archs as $arch => $dummy) { - if ($arch == '') - continue; - print " \n"; - print " Feed\n"; - print " \n"; - } - print " \n"; - } - } - - function print_feeds_table($prefix) { - print " \n"; - print " \n"; - print " \n"; - print_arches_header(); - print " \n"; - print " \n"; - print " \n"; - print_feeds($prefix); - print " \n"; - print "
\n"; - } - - ?> -
-

- RSS Feeds -

-

- Several RSS feeds are available for consumption from the Arch32 website. - The majority of these are package-related and allow feeds to be customized for the updates you care about. -

-

- News Feed -

-

- Grab the - news item feed - to keep up-to-date with the latest news from the Arch Linux development staff. -

-

- Package Feeds -

-

- If you are interested in - all package updates, - then grab this feed. - -

- Recently added packages. (to be implemented) -

- -

- Recently removed packages. (to be implemented) -

- -

- Release Feed -

-

- Grab the - ISO release feed - if you want to help seed the ISO release torrents as they come out. -

-

- Development Feeds -

-

- Subscribe to any of the following to track bug tickets and feature requests from the - Arch Linux 32 Bugtracker: -

- - - - - $dummy) { - print " \n"; - } - - ?> - - - - $project) { - print " \n"; - print " \n"; - foreach ($bugtracker_operations as $label => $option) { - print " \n"; - } - print " \n"; - } - - ?> - -
- Project - \n"; - print " Recently " . $label . " Tasks\n"; - print "
\n"; - print " " . $project . "\n"; - print " \n"; - print " Feed\n"; - print "
-
- \1\s+(\S+)\s+\S+\s+([0-9]+)\s*\n,', - $listing, - $matches, - PREG_SET_ORDER - ); - $available_isos = array(); - foreach ($matches as $match) { - $available_isos[] = array( - 'file' => $match[1], - 'title' => $match[2] . '-' . $match[3], - 'build_date' => strtotime(str_replace('.', '-', $match[2])), - 'build_type' => $match[3], - 'release_date' => $match[4], - 'size' => $match[5] - ); - } - apcu_store('available_isos', $available_isos, 3600); - } - - header('Content-Type: application/rss+xml; charset=utf-8'); - print ""; - print ""; - print ""; - print ""; - print "Arch Linux 32: Releases"; - print ""; - print ""; - print "https://www.archlinux32.org/download/"; - print ""; - print ""; - print "Release ISOs"; - print ""; - print ""; - print ""; - print ""; - print "en-us"; - print ""; - print ""; - print date('Y-m-d', $available_isos[0]['build_date']); - print ""; - foreach ($available_isos as $available_iso) { - print ""; - print ""; - print $available_iso['title']; - print ""; - // TODO: link to iso description (do we want that?) - print ""; - print ""; - print ""; - print date('Y-m-d', $available_iso['release_date']); - print ""; - // TODO: guid - print ""; - // TODO: url=\"https://www.archlinux32.org/iso/2019.02.01/archlinux-2019.02.01-x86_64.iso.torrent\">"; - print ""; - print ""; - } - print ""; - print ""; - - die(); -} // releases - -if ($uri_parts[0] == 'packages') { - - array_splice( - $uri_parts, - 0, 1 - ); - -// TODO: implement "added" and "removed" - but how? -// $actions = array('' => '', 'added' => 'added', 'removed' => 'removed'); - $actions = array('' => ''); - $archs = array('all' => 'all'); - $result = mysql_run_query( - "SELECT DISTINCT `architectures`.`name` FROM `architectures`" . - mysql_join_architectures_repositories() . - " WHERE `repositories`.`is_on_master_mirror`" . - " ORDER BY `name`" - ); - while ($row = $result -> fetch_assoc()) - $archs[$row['name']] = $row['name']; - $repos = array('' => ''); - $result = mysql_run_query( - "SELECT DISTINCT `repositories`.`name` FROM `repositories` WHERE `repositories`.`is_on_master_mirror` ORDER BY `name`" - ); - while ($row = $result -> fetch_assoc()) - $repos[$row['name']] = $row['name']; - - if (count($uri_parts) > 0 && array_key_exists($uri_parts[0], $actions)) { - $action = $uri_parts[0]; - $action_filter = 'unimplemented'; - array_splice( - $uri_parts, - 0, 1 - ); - } - else { - $action = ''; - $action_filter = '`repositories`.`is_on_master_mirror`'; - } - - if (count($uri_parts) > 0) { - if (!array_key_exists($uri_parts[0], $archs)) - throw_http_error(501, "Not Implemented", implode('/',$uri_parts)); - $arch = $uri_parts[0]; - $arch_filter = ' AND `r_a`.`name`="' . $arch . '"'; - array_splice( - $uri_parts, - 0, 1 - ); - } - else { - $arch = ''; - $arch_filter = ''; - } - - if (count($uri_parts) > 0) { - if (!array_key_exists($uri_parts[0], $repos)) - throw_http_error(501, "Not Implemented", implode('/',$uri_parts)); - $repo = $uri_parts[0]; - $repo_filter = ' AND `repositories`.`name`="' . $repo . '"'; - array_splice( - $uri_parts, - 0, 1 - ); - } - else { - $repo = ''; - $repo_filter = ''; - } - - if (count($uri_parts) != 0) - throw_http_error(501, "Not Implemented", implode('/',$uri_parts)); - - $result = mysql_run_query( - "SELECT MAX(`build_assignments`.`return_date`) AS `max_build_date`" . - " FROM `build_assignments`" . - mysql_join_build_assignments_binary_packages() . - mysql_join_binary_packages_binary_packages_in_repositories() . - mysql_join_binary_packages_in_repositories_repositories() . - mysql_join_repositories_architectures("", "r_a") . - " WHERE " . $action_filter . $repo_filter . $arch_filter - ); - $max_build_date = $result -> fetch_assoc(); - $max_build_date = $max_build_date['max_build_date']; - - $result = mysql_run_query( - "SELECT `binary_packages`.`pkgname`," . - "`binary_packages`.`epoch`," . - "`binary_packages`.`pkgver`," . - "`binary_packages`.`pkgrel`," . - "`binary_packages`.`sub_pkgrel`," . - "`binary_packages`.`sub_pkgrel_omitted`," . - "`architectures`.`name` AS `architecture`," . - "`repositories`.`name` AS `repo`," . - "`r_a`.`name` AS `r_a`," . - "`binary_packages_in_repositories`.`last_moved`" . - " FROM `binary_packages`" . - mysql_join_binary_packages_binary_packages_in_repositories() . - mysql_join_binary_packages_in_repositories_repositories() . - mysql_join_repositories_architectures("", "r_a") . - mysql_join_binary_packages_architectures() . - " WHERE " . $action_filter . $repo_filter . $arch_filter . - " ORDER BY `binary_packages_in_repositories`.`last_moved` DESC" . - " LIMIT 50" - ); - $packages = array(); - while ($row = $result -> fetch_assoc()) - $packages[] = $row; - - header('Content-Type: application/rss+xml; charset=utf-8'); - - print ""; - print ""; - print ""; - print ""; - print "Arch Linux 32: "; - switch ($action) { - case '': - print "Recent package updates"; - break; - case 'added': - print "Recent added packages"; - break; - case 'removes': - print "Recent removed packages"; - break; - } - if ($arch != 'all') - print " (" . $arch; - if ($repo != '') - print " [" . $repo . "]"; - if ($arch != '') - print ")"; - print ""; - print ""; - print "https://www.archlinux32.org/packages/"; - print ""; - print ""; - switch ($action) { - case '': - print "Recently updated packages in the Arch Linux 32 package repositories"; - break; - case 'added': - print "Recently added packages to the Arch Linux 32 package repositories"; - break; - case 'removes': - print "Recently removed packages from the Arch Linux 32 package repositories"; - break; - } - if ($arch != 'all') - print " for the '" . $arch . "' architecture (including 'any' packages)"; - else - print " for all architectures"; - if ($repo != '') - print " in the [" . $repo . "] repository"; - print "."; - print ""; - print ""; - print ""; - print ""; - print "en-us"; - print ""; - print ""; - print $max_build_date; - print ""; - foreach ($packages as $package) { - print ""; - print ""; - print $package['pkgname']; - if ($package['epoch'] != 0) - print $package['epoch'] . ":"; - print $package['pkgver'] . "-" . $package['pkgrel']; - if (!$package['sub_pkgrel_omitted']) - print '.' . $package['sub_pkgrel']; - print ' ' . $package['architecture']; - print ""; - print ""; - print "https://www.archlinux32.org/packages/" . $package['repo'] . "/" . $package['r_a'] . "/" . $package['pkgname'] . "/"; - print ""; -// TODO: description - print ""; - print $package['last_moved']; - print ""; -// TODO: guid - print ""; - print $package['repo']; - print ""; - print ""; - print $package['r_a']; - print ""; - print ""; - } - print ""; - print ""; - - die(); - -} // packages - -throw_http_error(501, "Not Implemented"); diff --git a/feeds.php b/feeds.php new file mode 100644 index 0000000..70320e9 --- /dev/null +++ b/feeds.php @@ -0,0 +1,490 @@ + fetch_assoc()) + $archs[$row['name']] = $row['name'] . '/'; + + $print_archs = array_merge( + array( + '' => '', + 'All Arches' => 'all/' + ), + $archs + ); + + $result = mysql_run_query( + "SELECT DISTINCT `repositories`.`name` FROM `repositories` WHERE `repositories`.`is_on_master_mirror` ORDER BY `name`" + ); + $repos = array(); + while ($row = $result -> fetch_assoc()) + $repos[$row['name']] = $row['name'] . '/'; + + $print_repos = array_merge( + array( + 'All Repos' => '' + ), + $repos + ); + + $bugtracker_projects = array( + 0 => 'All Projects', + 1 => 'Arch Linux 32' + ); + + $bugtracker_operations = array( + 'Opened' => '', + 'Edited' => 'topic=edit&', + 'Closed' => 'topic=clo&' + ); + + function print_arches_header() { + global $print_archs; + foreach ($print_archs as $arch => $dummy) { + print " \n"; + print " " . $arch . "\n"; + print " \n"; + }; + } + + function print_feeds($prefix) { + global $print_archs; + global $print_repos; + foreach ($print_repos as $repo => $dummy) { + print " \n"; + print " \n"; + print " " . $repo . "\n"; + print " \n"; + foreach ($print_archs as $arch => $dummy) { + if ($arch == '') + continue; + print " \n"; + print " Feed\n"; + print " \n"; + } + print " \n"; + } + } + + function print_feeds_table($prefix) { + print " \n"; + print " \n"; + print " \n"; + print_arches_header(); + print " \n"; + print " \n"; + print " \n"; + print_feeds($prefix); + print " \n"; + print "
\n"; + } + + ?> +
+

+ RSS Feeds +

+

+ Several RSS feeds are available for consumption from the Arch32 website. + The majority of these are package-related and allow feeds to be customized for the updates you care about. +

+

+ News Feed +

+

+ Grab the + news item feed + to keep up-to-date with the latest news from the Arch Linux development staff. +

+

+ Package Feeds +

+

+ If you are interested in + all package updates, + then grab this feed. + +

+ Recently added packages. (to be implemented) +

+ +

+ Recently removed packages. (to be implemented) +

+ +

+ Release Feed +

+

+ Grab the + ISO release feed + if you want to help seed the ISO release torrents as they come out. +

+

+ Development Feeds +

+

+ Subscribe to any of the following to track bug tickets and feature requests from the + Arch Linux 32 Bugtracker: +

+ + + + + $dummy) { + print " \n"; + } + + ?> + + + + $project) { + print " \n"; + print " \n"; + foreach ($bugtracker_operations as $label => $option) { + print " \n"; + } + print " \n"; + } + + ?> + +
+ Project + \n"; + print " Recently " . $label . " Tasks\n"; + print "
\n"; + print " " . $project . "\n"; + print " \n"; + print " Feed\n"; + print "
+
+ \1\s+(\S+)\s+\S+\s+([0-9]+)\s*\n,', + $listing, + $matches, + PREG_SET_ORDER + ); + $available_isos = array(); + foreach ($matches as $match) { + $available_isos[] = array( + 'file' => $match[1], + 'title' => $match[2] . '-' . $match[3], + 'build_date' => strtotime(str_replace('.', '-', $match[2])), + 'build_type' => $match[3], + 'release_date' => $match[4], + 'size' => $match[5] + ); + } + apcu_store('available_isos', $available_isos, 3600); + } + + header('Content-Type: application/rss+xml; charset=utf-8'); + print ""; + print ""; + print ""; + print ""; + print "Arch Linux 32: Releases"; + print ""; + print ""; + print "https://www.archlinux32.org/download/"; + print ""; + print ""; + print "Release ISOs"; + print ""; + print ""; + print ""; + print ""; + print "en-us"; + print ""; + print ""; + print date('Y-m-d', $available_isos[0]['build_date']); + print ""; + foreach ($available_isos as $available_iso) { + print ""; + print ""; + print $available_iso['title']; + print ""; + // TODO: link to iso description (do we want that?) + print ""; + print ""; + print ""; + print date('Y-m-d', $available_iso['release_date']); + print ""; + // TODO: guid + print ""; + // TODO: url=\"https://www.archlinux32.org/iso/2019.02.01/archlinux-2019.02.01-x86_64.iso.torrent\">"; + print ""; + print ""; + } + print ""; + print ""; + + die(); +} // releases + +if ($uri_parts[0] == 'packages') { + + array_splice( + $uri_parts, + 0, 1 + ); + +// TODO: implement "added" and "removed" - but how? +// $actions = array('' => '', 'added' => 'added', 'removed' => 'removed'); + $actions = array('' => ''); + $archs = array('all' => 'all'); + $result = mysql_run_query( + "SELECT DISTINCT `architectures`.`name` FROM `architectures`" . + mysql_join_architectures_repositories() . + " WHERE `repositories`.`is_on_master_mirror`" . + " ORDER BY `name`" + ); + while ($row = $result -> fetch_assoc()) + $archs[$row['name']] = $row['name']; + $repos = array('' => ''); + $result = mysql_run_query( + "SELECT DISTINCT `repositories`.`name` FROM `repositories` WHERE `repositories`.`is_on_master_mirror` ORDER BY `name`" + ); + while ($row = $result -> fetch_assoc()) + $repos[$row['name']] = $row['name']; + + if (count($uri_parts) > 0 && array_key_exists($uri_parts[0], $actions)) { + $action = $uri_parts[0]; + $action_filter = 'unimplemented'; + array_splice( + $uri_parts, + 0, 1 + ); + } + else { + $action = ''; + $action_filter = '`repositories`.`is_on_master_mirror`'; + } + + if (count($uri_parts) > 0) { + if (!array_key_exists($uri_parts[0], $archs)) + throw_http_error(501, "Not Implemented", implode('/',$uri_parts)); + $arch = $uri_parts[0]; + $arch_filter = ' AND `r_a`.`name`="' . $arch . '"'; + array_splice( + $uri_parts, + 0, 1 + ); + } + else { + $arch = ''; + $arch_filter = ''; + } + + if (count($uri_parts) > 0) { + if (!array_key_exists($uri_parts[0], $repos)) + throw_http_error(501, "Not Implemented", implode('/',$uri_parts)); + $repo = $uri_parts[0]; + $repo_filter = ' AND `repositories`.`name`="' . $repo . '"'; + array_splice( + $uri_parts, + 0, 1 + ); + } + else { + $repo = ''; + $repo_filter = ''; + } + + if (count($uri_parts) != 0) + throw_http_error(501, "Not Implemented", implode('/',$uri_parts)); + + $result = mysql_run_query( + "SELECT MAX(`build_assignments`.`return_date`) AS `max_build_date`" . + " FROM `build_assignments`" . + mysql_join_build_assignments_binary_packages() . + mysql_join_binary_packages_binary_packages_in_repositories() . + mysql_join_binary_packages_in_repositories_repositories() . + mysql_join_repositories_architectures("", "r_a") . + " WHERE " . $action_filter . $repo_filter . $arch_filter + ); + $max_build_date = $result -> fetch_assoc(); + $max_build_date = $max_build_date['max_build_date']; + + $result = mysql_run_query( + "SELECT `binary_packages`.`pkgname`," . + "`binary_packages`.`epoch`," . + "`binary_packages`.`pkgver`," . + "`binary_packages`.`pkgrel`," . + "`binary_packages`.`sub_pkgrel`," . + "`binary_packages`.`sub_pkgrel_omitted`," . + "`architectures`.`name` AS `architecture`," . + "`repositories`.`name` AS `repo`," . + "`r_a`.`name` AS `r_a`," . + "`binary_packages_in_repositories`.`last_moved`" . + " FROM `binary_packages`" . + mysql_join_binary_packages_binary_packages_in_repositories() . + mysql_join_binary_packages_in_repositories_repositories() . + mysql_join_repositories_architectures("", "r_a") . + mysql_join_binary_packages_architectures() . + " WHERE " . $action_filter . $repo_filter . $arch_filter . + " ORDER BY `binary_packages_in_repositories`.`last_moved` DESC" . + " LIMIT 50" + ); + $packages = array(); + while ($row = $result -> fetch_assoc()) + $packages[] = $row; + + header('Content-Type: application/rss+xml; charset=utf-8'); + + print ""; + print ""; + print ""; + print ""; + print "Arch Linux 32: "; + switch ($action) { + case '': + print "Recent package updates"; + break; + case 'added': + print "Recent added packages"; + break; + case 'removes': + print "Recent removed packages"; + break; + } + if ($arch != 'all') + print " (" . $arch; + if ($repo != '') + print " [" . $repo . "]"; + if ($arch != '') + print ")"; + print ""; + print ""; + print "https://www.archlinux32.org/packages/"; + print ""; + print ""; + switch ($action) { + case '': + print "Recently updated packages in the Arch Linux 32 package repositories"; + break; + case 'added': + print "Recently added packages to the Arch Linux 32 package repositories"; + break; + case 'removes': + print "Recently removed packages from the Arch Linux 32 package repositories"; + break; + } + if ($arch != 'all') + print " for the '" . $arch . "' architecture (including 'any' packages)"; + else + print " for all architectures"; + if ($repo != '') + print " in the [" . $repo . "] repository"; + print "."; + print ""; + print ""; + print ""; + print ""; + print "en-us"; + print ""; + print ""; + print $max_build_date; + print ""; + foreach ($packages as $package) { + print ""; + print ""; + print $package['pkgname']; + if ($package['epoch'] != 0) + print $package['epoch'] . ":"; + print $package['pkgver'] . "-" . $package['pkgrel']; + if (!$package['sub_pkgrel_omitted']) + print '.' . $package['sub_pkgrel']; + print ' ' . $package['architecture']; + print ""; + print ""; + print "https://www.archlinux32.org/packages/" . $package['repo'] . "/" . $package['r_a'] . "/" . $package['pkgname'] . "/"; + print ""; +// TODO: description + print ""; + print $package['last_moved']; + print ""; +// TODO: guid + print ""; + print $package['repo']; + print ""; + print ""; + print $package['r_a']; + print ""; + print ""; + } + print ""; + print ""; + + die(); + +} // packages + +throw_http_error(501, "Not Implemented"); -- cgit v1.2.3