array( "name" => "arch", "title" => "CPU architecture", "label" => "Arch", "table" => "architectures", "extra_condition" => "", "values" => array() ), "repo" => array( "name" => "repo", "title" => "respository", "label" => "Repository", "table" => "repositories", "extra_condition" => " WHERE `repositories`.`is_on_master_mirror`", "values" => array() ) ); foreach ( $multi_select_search_criteria as $criterium => $content ) { $result = mysql_run_query( "SELECT `name` FROM `" . $content["table"] . "`" . $content["extra_condition"] . " ORDER BY `name`" ); while ($row = $result -> fetch_assoc()) $multi_select_search_criteria[$criterium]["values"][] = $row["name"]; } $float_columns = array( "has_issues", "is_to_be_deleted" ); $filter = " WHERE 1"; foreach ($multi_select_search_criteria as $criterium) if (isset($_GET[$criterium["name"]])) { $filter .= " AND `" . $criterium["table"] . "`.`name` IN ("; foreach ($criterium["values"] as $value) if (strpos("&" . $_SERVER["QUERY_STRING"] . "&", "&" . $criterium["name"] . "=" . $value . "&") !== false) $filter .= "\"" . $value . "\","; $filter .= "\"\")"; } $single_select_search_criteria = array( "bugs" => array( "name" => "bugs", "label" => "Bugs", "title" => "bug-tracker status", "options" => array( "All" => "1", "Bugs" => "`binary_packages`.`has_issues`", "No Bugs" => "NOT `binary_packages`.`has_issues`" ) ), "del" => array( "name" => "del", "label" => "To Be Deleted", "title" => "to-be-deleted status", "options" => array( "All" => "1", "To Be Deleted" => "`binary_packages_in_repositories`.`is_to_be_deleted`", "Not To Be Deleted" => "NOT `binary_packages_in_repositories`.`is_to_be_deleted`" ) ), "uses_upstream" => array( "name" => "uses_upstream", "label" => "Upstream", "title" => "wether upstream source exists", "options" => array( "All" => "1", "Uses Upstream" => "`package_sources`.`uses_upstream`", "Does Not Use Upstream" => "NOT `package_sources`.`uses_upstream`" ) ), "uses_modification" => array( "name" => "uses_modification", "label" => "Modification", "title" => "wether modification exists", "options" => array( "All" => "1", "Uses Modification" => "`package_sources`.`uses_modification`", "Does Not Use Modification" => "NOT `package_sources`.`uses_modification`" ) ) ); foreach ($single_select_search_criteria as $criterium) if (isset($_GET[$criterium["name"]]) && isset($criterium["options"][$_GET[$criterium["name"]]])) $filter .= " AND " . $criterium["options"][$_GET[$criterium["name"]]]; if (isset($_GET["q"])) { $exact_filter = " AND `binary_packages`.`pkgname` = from_base64(\"".base64_encode($_GET["q"])."\")"; $fuzzy_filter = " AND `binary_packages`.`pkgname` LIKE from_base64(\"".base64_encode("%".$_GET["q"]."%")."\")"; } else { $exact_filter = " AND 0"; $fuzzy_filter = ""; } $query = " FROM `binary_packages`" . " JOIN `architectures` ON `architectures`.`id`=`binary_packages`.`architecture`" . " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" . " JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" . " AND `repositories`.`is_on_master_mirror`" . " JOIN `build_assignments` ON `build_assignments`.`id`=`binary_packages`.`build_assignment`" . " JOIN `package_sources` ON `package_sources`.`id`=`build_assignments`.`package_source`" . $filter . $exact_filter . " ORDER BY "; $query .= "`binary_packages`.`pkgname`,`repositories`.`stability`,`repositories`.`name`,`architectures`.`name`"; $result = mysql_run_query( "SELECT " . "`binary_packages`.`pkgname`," . "`repositories`.`name` AS `repo`," . "`architectures`.`name` AS `arch`," . "CONCAT(IF(`binary_packages`.`epoch`=\"0\",\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," . "`binary_packages`.`pkgver`,\"-\"," . "`binary_packages`.`pkgrel`,\".\"," . "`binary_packages`.`sub_pkgrel`) AS `version`," . "IF(`binary_packages`.`has_issues`,1,0) AS `has_issues`," . "`build_assignments`.`return_date` AS `build_date`," . "`binary_packages_in_repositories`.`last_moved` AS `move_date`," . "IF(`binary_packages_in_repositories`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`" . $query ); $exact_matches = array(); while ($row = $result -> fetch_assoc()) { foreach ($float_columns as $float_column) $row[$float_column] = floatval($row[$float_column]); $exact_matches[] = $row; } $sorts = array( "arch" => array( "title" => "architecture", "label" => "Arch", "mysql" => "`architectures`.`name`" ), "repo" => array( "title" => "repository", "label" => "Repo", "mysql" => "`repositories`.`name`" ), "pkgname" => array( "title" => "package name", "label" => "Name", "mysql" => "`binary_packages`.`pkgname`" ), "pkgver" => array( "title" => "package version", "label" => "Version", "mysql" => "CONCAT(`binary_packages`.`epoch`,\":\",`binary_packages`.`pkgver`,\"-\",`binary_packages`.`pkgrel`,\".\",`binary_packages`.`sub_pkgrel`)" ), "bugs" => array( "title" => "bug status", "label" => "Bugs", "mysql" => "NOT `binary_packages`.`has_issues`" ), "build_date" => array( "title" => "build date", "label" => "Build Date", "mysql" => "IFNULL(`build_assignments`.`return_date`,\"00-00-0000 00:00:00\")" ), "move_date" => array( "title" => "last update", "label" => "Last Updated", "mysql" => "IFNULL(`binary_packages_in_repositories`.`last_moved`,\"00-00-0000 00:00:00\")" ), "del" => array( "title" => "to be deleted", "label" => "Delete", "mysql" => "`binary_packages_in_repositories`.`is_to_be_deleted`" ) ); $query = " FROM `binary_packages`" . " JOIN `architectures` ON `architectures`.`id`=`binary_packages`.`architecture`" . " JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`" . " JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`" . " AND `repositories`.`is_on_master_mirror`" . " JOIN `build_assignments` ON `build_assignments`.`id`=`binary_packages`.`build_assignment`" . " JOIN `package_sources` ON `package_sources`.`id`=`build_assignments`.`package_source`" . $filter . $fuzzy_filter . " ORDER BY "; if (isset($_GET["sort"])) { if (isset($sorts[$_GET["sort"]]["mysql"])) $query .= $sorts[$_GET["sort"]]["mysql"] . ","; elseif (isset($sorts[substr($_GET["sort"],1)]["mysql"])) $query .= $sorts[substr($_GET["sort"],1)]["mysql"] . " DESC,"; } $query .= "`binary_packages`.`pkgname`,`repositories`.`stability`,`repositories`.`name`,`architectures`.`name`"; $result = mysql_run_query( "SELECT COUNT(1)" . $query ); $num_results = implode($result -> fetch_assoc()); $pages = max(ceil($num_results / 100), 1); if (isset($_GET["page"])) $page = max(min($_GET["page"]+0, $pages),1); else $page = 1; $result = mysql_run_query( "SELECT " . "`binary_packages`.`pkgname`," . "`repositories`.`name` AS `repo`," . "`architectures`.`name` AS `arch`," . "CONCAT(IF(`binary_packages`.`epoch`=\"0\",\"\",CONCAT(`binary_packages`.`epoch`,\":\"))," . "`binary_packages`.`pkgver`,\"-\"," . "`binary_packages`.`pkgrel`,\".\"," . "`binary_packages`.`sub_pkgrel`) AS `version`," . "IF(`binary_packages`.`has_issues`,1,0) AS `has_issues`," . "`build_assignments`.`return_date` AS `build_date`," . "`binary_packages_in_repositories`.`last_moved` AS `move_date`," . "IF(`binary_packages_in_repositories`.`is_to_be_deleted`,1,0) AS `is_to_be_deleted`" . $query . " LIMIT " . (($page-1)*100) . ", 100" ); $fuzzy_matches = array(); while ($row = $result -> fetch_assoc()) { foreach ($float_columns as $float_column) $row[$float_column] = floatval($row[$float_column]); $fuzzy_matches[] = $row; } function print_results($results) { $oddity="odd"; foreach ($results as $row) { print " \n"; print " \n"; print " " . $row["arch"] . "\n"; print " \n"; print " \n"; print " " . $row["repo"] . "\n"; print " \n"; print " \n"; print " " . $row["pkgname"] . "\n"; print " \n"; print " \n"; print " " . $row["version"] . "\n"; print " \n"; print " \n"; print " "; if ($row["has_issues"]) print "has open bug reports"; else print " "; print "\n"; print " \n"; print " \n"; print " "; if (isset($row["build_date"])) print $row["build_date"]; else print " "; print "\n"; print " \n"; print " \n"; print " "; if (isset($row["move_date"])) print $row["move_date"]; else print " "; print "\n"; print " \n"; print " \n"; print " "; if ($row["is_to_be_deleted"]) print "to be deleted"; else print " "; print "\n"; print " \n"; print " \n"; if ($oddity == "odd" ) $oddity = "even"; else $oddity = "odd"; } } function header_and_footer() { global $page, $pages, $num_results; print "
\n"; print "

\n"; print " " . $num_results . " matching package"; if ($num_results != 1) print "s"; print " found.\n"; if ($pages != 1) print " Page " . $page . " of " . $pages . ".\n"; print "

\n"; if ($pages != 1) { print "
\n"; print " \n"; print " "; if ($page > 1) { print ""; }; print "< Prev"; if ($page > 1) print ""; print "\n"; print " \n"; print " \n"; print " "; if ($page < $pages) { print ""; }; print "Next >"; if ($page < $pages) print ""; print "\n"; print " \n"; print "
\n"; }; print "
\n"; }; if (isset($_GET["exact"])) { export_as_requested( array( "All" => $exact_matches ) ); die(); }; if (isset($_GET["fuzzy"])) { export_as_requested( array( "All" => $fuzzy_matches ) ); die(); }; print_header("Package Search"); ?> \n"; } ?>
/>
\n"; print " \n"; print " \n"; } ?>
0) { ?>

exact match found.

$sort) { print " \n"; } ?>
\n"; print " ".$sort["label"]."\n"; print "
$sort) { print " \n"; } ?>
\n"; print " ".$sort["label"]."\n"; print "

Can't find what you are looking for? Try searching again using different criteria, or try searching the AUR to see if the package can be found there.

You are browsing the Arch Linux 32 package database. From here you can find detailed information about packages located in the 32 bit repositories.