getCol($sql); $arr_default_arch = $arr_display_arch = array('alpha', 'amd64', 'arm', 'hppa', 'ia64', 'm68k', 'mips', 'ppc', 'ppc64', 's390', 'sh', 'sparc', 'x86'); $arr = array(); if($_COOKIE['arch']) { foreach($_COOKIE['arch'] as $name => $value) { if($name && in_array($name, $arr_arch, true) && $value) $arr[] = $name; } } if(count($arr)) { sort($arr); $arr_display_arch = $arr; } $offset = 0; $amount = 10; $request_uri = $_SERVER['REQUEST_URI']; function headerMessage($str) { $str = "
$str
\n"; return $str; } function recentPackages($amount, $offset = 0, $arch = "") { $db =& MDB2::singleton(); if($arch) { // $sql ="SELECT DISTINCT pr.package FROM package_recent pr INNER JOIN ebuild e ON e.package = pr.package INNER JOIN ebuild_arch ea ON ea.ebuild = e.id AND ea.arch != 2 INNER JOIN arch a ON ea.arch = a.id AND a.name = ".$db->quote($arch)." ORDER BY max_ebuild_mtime DESC, package LIMIT $amount OFFSET $offset"; $sql = "SELECT package FROM package_recent_arch pra INNER JOIN arch a ON pra.arch = a.id AND a.name = ".$db->quote($arch)." WHERE pra.status = 0 ORDER BY pra.max_ebuild_mtime DESC, pra.package LIMIT $amount OFFSET $offset"; } else { $sql = "SELECT package FROM package_recent WHERE status = 0 ORDER BY max_ebuild_mtime DESC, package LIMIT $amount OFFSET $offset"; } // Note to sanity: I already found one instance (readline version bump to 6.1 ebuild) where the recent changes // said "version bump" but the most recent ebuild was 5.2_p14. Everything was working fine, because the 5.2 ebuild's // mtime really was *newer*. So, just because the recent changes doesn't match up to the display, don't panic. // This tracks what was the *last modified* ebuild *PLUS* an hour before that, to get (ostensibly) all the changes // since the last run. $sql = "SELECT e.package, e.id AS ebuild FROM ebuild e INNER JOIN package_recent pr ON e.package = pr.package AND e.cache_mtime > (pr.max_ebuild_mtime - 3600) WHERE pr.status = 0 AND e.status = 0 AND e.package IN ($sql) ORDER BY pr.max_ebuild_mtime DESC, e.package, e.ev DESC, e.lvl DESC, e.p IS NULL, e.p DESC, e.rc IS NULL, e.rc DESC, e.pre IS NULL, e.pre DESC, e.beta IS NULL, e.beta DESC, e.alpha IS NULL, e.alpha DESC, e.pr IS NULL, e.pr DESC;"; // echo $sql; $arr = $db->getAll($sql); return $arr; } function keywordsRow($arr, $view = 'category') { global $arr_arch; global $arr_display_arch; global $base_uri; global $base_url; global $lingua; $request_uri = $_SERVER['REQUEST_URI']; if(substr($request_uri, -1) == '/') $request_uri = substr($request_uri, 0, strlen($request_uri) - 1); $e = new DBEbuild(current($arr)); $p = new DBPackage($e->package); $c = new PackageChangelog($p->changelog); $recent_changes = htmlspecialchars($p->recent_changes); $recent_changes = preg_replace('/((bug\n?)( {1,2}\D?)|#)(\d{5,})/i', "$1$4", $recent_changes); $recent_date = $c->recent_date; $category_name = $e->category_name; $package_name = $e->package_name; $cp = "$category_name/$package_name"; $description = htmlspecialchars($p->description); $iarr_months = array( 'January' => gettext('January'), 'February' => gettext('February'), 'March' => gettext('March'), 'April' => gettext('April'), 'May' => gettext('May'), 'June' => gettext('June'), 'July' => gettext('July'), 'August' => gettext('August'), 'September' => gettext('September'), 'October' => gettext('October'), 'November' => gettext('November'), 'December' => gettext('December'), ); // Portage mtimes on directories are generally unreliable // directories get their mtime updated for no reasons that I can see. $max = max($e->cache_mtime, $e->changelog_mtime, $e->metadata_mtime, $e->portage_mtime); if($lingua == "es") $mdate = date('d', $max)." de ".gettext(strtolower(date('F', $max)))." ".date(', Y, H:i', $max); elseif($lingua == "de" || $lingua == "cs") $mdate = date('d.')." ".gettext(date('F', $max))." ".date('Y, H:i', $max); else $mdate = date('F d, Y, H:i', $max); $homepage = ( $e->homepage ? $e->homepage : "http://www.gentoo.org/" ); $url_category = urlencode($category_name); $url_package = urlencode($package_name); $url_pf = urlencode($e->pf); $gentoo_changelog = "http://sources.gentoo.org/viewcvs.py/*checkout*/gentoo-x86/$url_category/$url_package/ChangeLog"; $gentoo_cvs = "http://sources.gentoo.org/viewcvs.py/gentoo-x86/$url_category/$url_package/?hideattic=0"; $gentoo_bugs = "https://bugs.gentoo.org/buglist.cgi?query_format=&short_desc_type=allwords&short_desc=$url_package&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED"; $gentoo_wiki = "http://en.gentoo-wiki.com/w/index.php?title=Special%3ASearch&search=".urlencode(str_replace("-", " ", $package_name)); $gentoo_forums = "http://forums.gentoo.org/search.php?search_terms=all&show_results=topics&search_keywords=$url_package&mode=results"; $bugs = $base_uri."$url_category/$url_package/bugs"; $changelog = $base_uri."$url_category/$url_package/changelog"; $ml = "http://www.mail-archive.com/search?q=$url_package&l=gentoo-user%40lists.gentoo.org"; if($lingua == "cs") $ml = "http://search.gmane.org/?query=$url_package&group=gmane.linux.gentoo.user.czech-slovak"; elseif($lingua == "de") $ml = "http://search.gmane.org/?query=$url_package&group=gmane.linux.gentoo.user.german"; elseif($lingua == "fr") $ml = "http://search.gmane.org/?query=$url_package&group=gmane.linux.gentoo.user.french"; elseif($lingua == "hu") $ml = "http://search.gmane.org/?query=$url_package&group=gmane.linux.gentoo.user.hungarian"; elseif($lingua == "id") $ml = "http://search.gmane.org/?query=$url_package&group=gmane.linux.gentoo.user.indonesia"; elseif($lingua == "ru") $ml = "http://search.gmane.org/?query=$url_package&group=gmane.linux.gentoo.user.russian"; if($view == 'ebuild') { $dependencies = $base_uri."$url_category/$url_pf/dependencies"; $downloads = $base_uri."$url_category/$url_pf/downloads"; $license = $base_uri."$url_category/$url_pf/license"; $source = $base_uri."$url_category/$url_pf/source"; $useflags = $base_uri."$url_category/$url_pf/useflags"; } else { $dependencies = $base_uri."$url_category/$url_package/dependencies"; $downloads = $base_uri."$url_category/$url_package/downloads"; $license = $base_uri."$url_category/$url_package/license"; $useflags = $base_uri."$url_category/$url_package/useflags"; } // License // $arr_licenses = $e->licenses; // // $url_licenses = array(); // // if(count($arr_licenses)) { // foreach($arr_licenses as $name) { // $str = nl2br(wordwrap(str_replace('-', ' ', $name), 25)); // $url_licenses[$str] = $base_uri."licenses/".urlencode($name); // } // } $x = 0; /** New **/ // $html .= "\n"; $html .= "
\n"; $html .= "\t
\n"; $html .= "\t\t
\n"; $html .= "\t\t\t
$package_name
\n"; // FIXME CSS bug // if($view == 'category') // $str = " "; // else $str = $mdate; $html .= "\t\t\t\t
$str
\n"; if($view == 'ebuild' || $view == 'new' || $view == 'category' || $view == 'search') $html .= "\t\t\t\t

$description

\n"; $html .= "\t\t\t\t\t\n"; $html .= "\t\t\t\t\t\t\n"; $html .= "\t\t\t\t\t\t\t\n"; foreach($arr_display_arch as $name) { $class = "nowrap"; if($name == end($arr_display_arch)) $class = "$class last_cell"; // FIXME CSS in style tag $html .= "\t\t\t\n"; } $html .= "\t\t\t\t\t\t\n"; $istr_bugs = gettext("Bugs"); $istr_category = gettext("Category"); $istr_changelog = gettext("ChangeLog"); $istr_cvs = gettext("CVS"); $istr_dependencies = gettext("Dependencies"); $istr_forums = gettext("Forums"); $istr_homepage = gettext("Homepage"); $istr_license = gettext("License"); $istr_mailing_lists = gettext("Mailing Lists"); $istr_metadata = gettext("Metadata"); $istr_package_description = gettext("PACKAGE DESCRIPTION"); $istr_planet = gettext("Planet"); $istr_recent_changes = gettext("Recent Changes"); $istr_source = gettext("Source"); $istr_use_flags = gettext("Use Flags"); $istr_wiki = gettext("Wiki"); foreach($arr as $ebuild) { if($x > 0) $e = new DBEbuild($ebuild); $x++; $arr_keywords = $e->keywords; $pf =& $e->pf; $pv =& $e->pv; $pvr =& $e->pvr; $url_pf = urlencode($pf); $url = $base_uri.$url_category."/".$url_package."/$pf"; if($view == 'ebuild') $gentoo_cvs = "http://sources.gentoo.org/viewcvs.py/*checkout*/gentoo-x86/$url_category/$url_package/$url_pf.ebuild"; $html .= "\t\t\t\t\t\t\n"; $html .= "\t\t\t\t\t\t\t\n"; foreach($arr_display_arch as $arch) { $case = $arr_keywords[$arch]; if($arch == 'sparc fbsd') $arch = 'sparc-fbsd'; elseif($arch == 'x86 fbsd') $arch = 'x86-fbsd'; switch($case) { case null: $class = 'not_keyword'; $keyword = '–'; break; case 0: $class = 'stable'; $keyword = '+'; break; case 1: $class = 'testing'; $keyword = '~'; break; // FIXME case 2: case 3: $class = 'not_avail'; $keyword = 'x'; break; default: $class = 'not_keyword'; $keyword = '-'; break; } if($e->masked && ($case == 0 || $case == 1)) { $class = 'm_stable'; $keyword = 'm'; } if($arch == end($arr_display_arch)) $class .= " last_cell"; $html .= "\n"; } $html .= "\t\t\t\t\t\t\n"; } $html .= "\t\t\t\t\t
$name
$pvr$keyword
\n"; // if($view == 'ebuild' || $view == 'new' || $view == 'category') // $html .= "\t\t\t\t

Description: $description

\n"; if($recent_changes && ($view == 'new' || $view == 'package')) $html .= "\t\t\t\t

$istr_recent_changes:   $recent_changes

\n"; $html .= "\t\t\t
\n"; if($view == 'new' || $view == 'category' || $view == 'search') { $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t\t\n"; $html .= "\t\t\t\t
\n"; } if($view == 'package' || $view == 'ebuild') { $html .= "\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t\t

$istr_package_description:

\n"; $html .= "\t\t\t\t\t

$description

\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t\t

$istr_category:

\n"; $html .= "\t\t\t\t\t

$category_name

\n"; $html .= "\t\t\t\t
\n"; // $html .= "\t\t\t\t
\n"; // $html .= "\t\t\t\t
\n"; // $html .= "\t\t\t\t\t
    \n"; // $html .= "\t\t\t\t\t

    $istr_license:

    \n"; // foreach($url_licenses as $name => $url) // $html .= "\t\t\t\t\t\t
  • $name
    • \n"; // $html .= "\t\t\t\t\t
\n"; // $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t\t\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t\t\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t\t
    \n"; // $html .= "\t\t\t\t\t\t
  • Downloads
    • \n"; $html .= "\t\t\t\t\t\t
  • License
    • \n"; $html .= "\t\t\t\t\t\t
  • View CVS
    • \n"; if($view == 'ebuild') $html .= "\t\t\t\t\t\t
  • Source Code
    • \n"; $html .= "\t\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t\t
\n"; $html .= "\t\t\t
\n"; } $html .= "\t\t
\n"; return $html; } function getRowClass($i = 0) { $i = intval($i); if(($i % 2) == 0) return 'odd'; else return 'even'; } ?>