- Aur-dev - lists.archlinux.org

[aur-dev] 2.0.0 string freeze
by Lukas Fleischer 28 Oct '12

28 Oct '12

Strings are frozen for one week [1]. 2.0.0 is expected to be released on next Sunday (04 Feb 2012). A lot of languages still need to be updated. These include: * German * French * Catalan * Greek * Spanish * Hungarian * Italian * Norwegian Bokmål * Polish * Portuguese (Portugal) * Romanian * Serbian * Turkish * Finnish * Russian * Chinese (China) All of these were ~100% complete before the new strings were pushed and need some additions for 2.0.0. Thanks in advance to all translation contributors! [1] https://www.transifex.com/projects/p/aur/r/2-0-0/

2 2

[aur-dev] [HEADS-UP] API changes in 2.0.0
by Lukas Fleischer 28 Oct '12

28 Oct '12

Just another reminder to all users of the RPC interface. As I mentioned before [1], 2.0.0 introduces a couple of API changes: * 0557f7705ab12c84e53a5f2dc352557b908af511 [2] * 168a51431bda11d2250a26e8acb8b05c0876092e [3] * e53b91fe52be262d94a45769814c1e87c796988b [4] * 47c5167acb0a4a2c809c03dc664fea1d130d0c8b [5] * 795971bc806776ad48de6f0135736cbaaefa5fcd [6] * 04a0fd47482f513c24645eb3f8b88b07303f9ec4 [7] * 53a31865f41db7315dc5c99e1b100f397ef80b1a [8] Please make sure to fix your RPC clients. AUR 2.0.0 will be released in one week. Also make sure you use the "URLPath" parameter included in RPC responses to locate source tarballs instead of hardcoding paths (no helpers should rely on the existence of a "/packages/" subdirectory -- this might be changed in the future)! [1] https://mailman.archlinux.org/pipermail/aur-dev/2012-October/002175.html [2] https://projects.archlinux.org/aur.git/commit/?id=43a69e71 [3] https://projects.archlinux.org/aur.git/commit/?id=0557f770 [4] https://projects.archlinux.org/aur.git/commit/?id=168a5143 [5] https://projects.archlinux.org/aur.git/commit/?id=e53b91fe [6] https://projects.archlinux.org/aur.git/commit/?id=47c5167a [7] https://projects.archlinux.org/aur.git/commit/?id=795971bc [8] https://projects.archlinux.org/aur.git/commit/?id=04a0fd47

1 1

[aur-dev] [PATCH] Implement word-wrap for package statistics
by Lukas Fleischer 28 Oct '12

28 Oct '12

Word-wrap labels in the package statistics box, just as we wrap package names in the "Recent Updates" box. Addresses FS#32160. Signed-off-by: Lukas Fleischer <archlinux(a)cryptocrack.de> --- web/html/css/aur.css | 4 ++++ web/template/stats/general_stats_table.php | 16 ++++++++-------- 2 files changed, 12 insertions(+), 8 deletions(-) diff --git a/web/html/css/aur.css b/web/html/css/aur.css index dada258..bae8e21 100644 --- a/web/html/css/aur.css +++ b/web/html/css/aur.css @@ -10,3 +10,7 @@ #pkg-updates td.pkg-new { padding: 0 .5em; } + +#pkg-stats td.stat-desc { + white-space: normal; +} diff --git a/web/template/stats/general_stats_table.php b/web/template/stats/general_stats_table.php index 6a92c3b..5b59832 100644 --- a/web/template/stats/general_stats_table.php +++ b/web/template/stats/general_stats_table.php @@ -2,35 +2,35 @@ <table> <tr> - <td><?= __("Packages"); ?></td> + <td class="stat-desc"><?= __("Packages"); ?></td> <td><?= $unsupported_count; ?></td> </tr> <tr> - <td><?= __("Orphan Packages"); ?></td> + <td class="stat-desc"><?= __("Orphan Packages"); ?></td> <td><?= $orphan_count; ?></td> </tr> <tr> - <td><?= __("Packages added in the past 7 days"); ?></td> + <td class="stat-desc"><?= __("Packages added in the past 7 days"); ?></td> <td><?= $add_count; ?></td> </tr> <tr> - <td><?= __("Packages updated in the past 7 days"); ?></td> + <td class="stat-desc"><?= __("Packages updated in the past 7 days"); ?></td> <td><?= $update_count; ?></td> </tr> <tr> - <td><?= __("Packages updated in the past year"); ?></td> + <td class="stat-desc"><?= __("Packages updated in the past year"); ?></td> <td><?= $update_year_count; ?></td> </tr> <tr> - <td><?= __("Packages never updated"); ?></td> + <td class="stat-desc"><?= __("Packages never updated"); ?></td> <td><?= $never_update_count; ?></td> </tr> <tr> - <td><?= __("Registered Users"); ?></td> + <td class="stat-desc"><?= __("Registered Users"); ?></td> <td><?= $user_count; ?></td> </tr> <tr> - <td><?= __("Trusted Users"); ?></td> + <td class="stat-desc"><?= __("Trusted Users"); ?></td> <td><?= $tu_count; ?></td> </tr> </table> -- 1.8.0

1 0

[aur-dev] [PATCH v2] aurjson.class.php: Limit number of RPC results
by canyonknight 22 Oct '12

22 Oct '12

With no limit to the number of results, memory_limit set to 32M can easily be exceeded for searches that have a large number of results. This results in an HTTP error 500 for those queries. Limit results to an amount set within config.inc.php to avoid exceeding memory_limit. Introduce new JSON error code for when the result limit is hit. Fixes FS#31849 Signed-off-by: canyonknight <canyonknight(a)gmail.com> --- web/lib/aurjson.class.php | 22 +++++++++++++++++----- web/lib/config.inc.php.proto | 4 ++++ 2 files changed, 21 insertions(+), 5 deletions(-) diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php index fbdc711..949c34f 100644 --- a/web/lib/aurjson.class.php +++ b/web/lib/aurjson.class.php @@ -117,6 +117,7 @@ class AurJSON { } private function process_query($type, $where_condition) { + global $MAX_RPC_RESULTS; $fields = implode(',', self::$fields); $query = "SELECT Users.Username as Maintainer, {$fields} " . "FROM Packages LEFT JOIN Users " . @@ -149,6 +150,10 @@ class AurJSON { } } + if ($resultcount === $MAX_RPC_RESULTS) { + return $this->json_error('Too many package results.'); + } + return $this->json_results($type, $resultcount, $search_data); } else { @@ -191,6 +196,7 @@ class AurJSON { * @return mixed Returns an array of package matches. **/ private function search($keyword_string) { + global $MAX_RPC_RESULTS; if (strlen($keyword_string) < 2) { return $this->json_error('Query arg too small'); } @@ -198,7 +204,8 @@ class AurJSON { $keyword_string = $this->dbh->quote("%" . addcslashes($keyword_string, '%_') . "%"); $where_condition = "(Name LIKE {$keyword_string} OR "; - $where_condition.= "Description LIKE {$keyword_string})"; + $where_condition.= "Description LIKE {$keyword_string}) "; + $where_condition.= "LIMIT {$MAX_RPC_RESULTS}"; return $this->process_query('search', $where_condition); } @@ -227,6 +234,7 @@ class AurJSON { * @return mixed Returns an array of results containing the package data **/ private function multiinfo($pqdata) { + global $MAX_RPC_RESULTS; $args = $this->parse_multiinfo_args($pqdata); $ids = $args['ids']; $names = $args['names']; @@ -238,17 +246,19 @@ class AurJSON { $where_condition = ""; if ($ids) { $ids_value = implode(',', $args['ids']); - $where_condition .= "ID IN ({$ids_value})"; + $where_condition .= "ID IN ({$ids_value}) "; } if ($ids && $names) { - $where_condition .= " OR "; + $where_condition .= "OR "; } if ($names) { // individual names were quoted in parse_multiinfo_args() $names_value = implode(',', $args['names']); - $where_condition .= "Name IN ({$names_value})"; + $where_condition .= "Name IN ({$names_value}) "; } + $where_condition .= "LIMIT {$MAX_RPC_RESULTS}"; + return $this->process_query('multiinfo', $where_condition); } @@ -258,9 +268,11 @@ class AurJSON { * @return mixed Returns an array of value data containing the package data **/ private function msearch($maintainer) { + global $MAX_RPC_RESULTS; $maintainer = $this->dbh->quote($maintainer); - $where_condition = "Users.Username = {$maintainer}"; + $where_condition = "Users.Username = {$maintainer} "; + $where_condition .= "LIMIT {$MAX_RPC_RESULTS}"; return $this->process_query('msearch', $where_condition); } diff --git a/web/lib/config.inc.php.proto b/web/lib/config.inc.php.proto index f132445..1fe7dbc 100644 --- a/web/lib/config.inc.php.proto +++ b/web/lib/config.inc.php.proto @@ -55,3 +55,7 @@ $AUR_LOCATION = "http://localhost"; # Use virtual URLs -- to enable this feature, you also need to tell your web # server to redirect all requests to "/index.php/$uri". $USE_VIRTUAL_URLS = true; + +# Maximum number of package results to return through an RPC connection. +# Avoid setting this too high and having a PHP too much memory error. +$MAX_RPC_RESULTS = 5000; -- 1.7.12.4

2 1

[aur-dev] [PATCH] Use HTTPS links everywhere for Arch sites
by Dan McGee 22 Oct '12

22 Oct '12

The main site, wiki, and BBS are using HTTPS exclusively, so link directly to the correct protocol rather than forcing a redirect. Signed-off-by: Dan McGee <dan(a)archlinux.org> --- HACKING | 2 +- README | 2 +- TRANSLATING | 2 +- UPGRADING | 2 +- support/schema/aur-schema.sql | 2 +- web/html/home.php | 10 +++++----- web/html/passreset.php | 2 +- web/template/header.php | 8 ++++---- web/template/pkg_details.php | 2 +- 9 files changed, 16 insertions(+), 16 deletions(-) diff --git a/HACKING b/HACKING index 4f0831c..291da1f 100644 --- a/HACKING +++ b/HACKING @@ -32,7 +32,7 @@ Submitting patches Submit uncompressed git-formatted patches to aur-dev(a)archlinux.org. You will need to register on the mailing list before submitting: -http://mailman.archlinux.org/mailman/listinfo/aur-dev +https://mailman.archlinux.org/mailman/listinfo/aur-dev Base your patches on the master branch as forward development is done there. When writing patches please keep unnecessary changes to a minimum. diff --git a/README b/README index 805e0ce..8f6892a 100644 --- a/README +++ b/README @@ -64,4 +64,4 @@ Contact: ======== Questions, comments, and patches related to the AUR can be sent to the AUR development mailing list: aur-dev(a)archlinux.org -Mailing list archives: http://mailman.archlinux.org/mailman/listinfo/aur-dev +Mailing list archives: https://mailman.archlinux.org/mailman/listinfo/aur-dev diff --git a/TRANSLATING b/TRANSLATING index d8f1bd4..8f729c8 100644 --- a/TRANSLATING +++ b/TRANSLATING @@ -2,7 +2,7 @@ AUR Translation ================ This document describes how to create and maintain AUR translations. It was -originally derived from http://wiki.archlinux.org/index.php/AUR_Translation +originally derived from https://wiki.archlinux.org/index.php/AUR_Translation Creating an AUR translation requires a Transifex (http://www.transifex.net/) account. You will need to register with a translation team on the AUR project diff --git a/UPGRADING b/UPGRADING index a0d4a95..dcf9169 100644 --- a/UPGRADING +++ b/UPGRADING @@ -170,7 +170,7 @@ ALTER TABLE PackageCategories MODIFY Category VARCHAR(32) NOT NULL; ALTER TABLE Packages MODIFY Name VARCHAR(64) NOT NULL, MODIFY Version VARCHAR(32) NOT NULL DEFAULT '', MODIFY Description VARCHAR(255) NOT NULL DEFAULT "An Arch Package", - MODIFY URL VARCHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", + MODIFY URL VARCHAR(255) NOT NULL DEFAULT "https://www.archlinux.org", MODIFY License VARCHAR(40) NOT NULL DEFAULT ''; ALTER TABLE PackageSources MODIFY Source VARCHAR(255) NOT NULL DEFAULT "/dev/null"; diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 726fd2f..d55cf1a 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -97,7 +97,7 @@ CREATE TABLE Packages ( Version VARCHAR(32) NOT NULL DEFAULT '', CategoryID TINYINT UNSIGNED NOT NULL DEFAULT 1, Description VARCHAR(255) NOT NULL DEFAULT "An Arch Package", - URL VARCHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", + URL VARCHAR(255) NOT NULL DEFAULT "https://www.archlinux.org", License VARCHAR(40) NOT NULL DEFAULT '', NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL, diff --git a/web/html/home.php b/web/html/home.php index 4d5b699..40ad5fe 100644 --- a/web/html/home.php +++ b/web/html/home.php @@ -22,9 +22,9 @@ $dbh = db_connect(); <?php echo __( 'Welcome to the AUR! Please read the %sAUR User Guidelines%s and %sAUR TU Guidelines%s for more information.', - '<a href="http://wiki.archlinux.org/index.php/AUR_User_Guidelines">', + '<a href="https://wiki.archlinux.org/index.php/AUR_User_Guidelines">', '</a>', - '<a href="http://wiki.archlinux.org/index.php/AUR_Trusted_User_Guidelines">', + '<a href="https://wiki.archlinux.org/index.php/AUR_Trusted_User_Guidelines">', '</a>' ); ?> @@ -34,7 +34,7 @@ $dbh = db_connect(); echo __( 'Contributed PKGBUILDs %smust%s conform to the %sArch Packaging Standards%s otherwise they will be deleted!', '<strong>', '</strong>', - '<a href="http://wiki.archlinux.org/index.php/Arch_Packaging_Standards">', + '<a href="https://wiki.archlinux.org/index.php/Arch_Packaging_Standards">', '</a>' ); ?> @@ -48,9 +48,9 @@ $dbh = db_connect(); <?php echo __( 'General discussion regarding the Arch User Repository (AUR) and Trusted User structure takes place on %saur-general%s. This list can be used for package orphan requests, merge requests, and deletion requests. For discussion relating to the development of the AUR, use the %saur-dev%s mailing list.', - '<a href="http://mailman.archlinux.org/mailman/listinfo/aur-general">', + '<a href="https://mailman.archlinux.org/mailman/listinfo/aur-general">', '</a>', - '<a href="http://mailman.archlinux.org/mailman/listinfo/aur-dev">', + '<a href="https://mailman.archlinux.org/mailman/listinfo/aur-dev">', '</a>' ); ?> diff --git a/web/html/passreset.php b/web/html/passreset.php index 42dfc86..064e3de 100644 --- a/web/html/passreset.php +++ b/web/html/passreset.php @@ -100,7 +100,7 @@ html_header(__("Password Reset")); } else { ?> <p><?= __('If you have forgotten the e-mail address you used to register, please send a message to the %saur-general%s mailing list.', - '<a href="http://mailman.archlinux.org/mailman/listinfo/aur-general">', + '<a href="https://mailman.archlinux.org/mailman/listinfo/aur-general">', '</a>'); ?></p> <form action="" method="post"> <p><?= __("Enter your e-mail address:"); ?> diff --git a/web/template/header.php b/web/template/header.php index 265d638..a60174b 100644 --- a/web/template/header.php +++ b/web/template/header.php @@ -13,16 +13,16 @@ </head> <body> <div id="archnavbar" class="anb-aur"> - <div id="archnavbarlogo"><h1><a href="http://www.archlinux.org" title="Return to the main page">Arch Linux</a></h1></div> + <div id="archnavbarlogo"><h1><a href="https://www.archlinux.org/" title="Return to the main page">Arch Linux</a></h1></div> <div id="archnavbarmenu"> <ul id="archnavbarlist"> - <li id="anb-home"><a href="http://www.archlinux.org/" title="Arch news, packages, projects and more">Home</a></li> - <li id="anb-packages"><a href="http://www.archlinux.org/packages/" title="Arch Package Database">Packages</a></li> + <li id="anb-home"><a href="https://www.archlinux.org/" title="Arch news, packages, projects and more">Home</a></li> + <li id="anb-packages"><a href="https://www.archlinux.org/packages/" title="Arch Package Database">Packages</a></li> <li id="anb-forums"><a href="https://bbs.archlinux.org/" title="Community forums">Forums</a></li> <li id="anb-wiki"><a href="https://wiki.archlinux.org/" title="Community documentation">Wiki</a></li> <li id="anb-bugs"><a href="https://bugs.archlinux.org/" title="Report and track bugs">Bugs</a></li> <li id="anb-aur"><a href="/" title="Arch Linux User Repository">AUR</a></li> - <li id="anb-download"><a href="http://www.archlinux.org/download/" title="Get Arch Linux">Download</a></li> + <li id="anb-download"><a href="https://www.archlinux.org/download/" title="Get Arch Linux">Download</a></li> </ul> </div> </div> diff --git a/web/template/pkg_details.php b/web/template/pkg_details.php index 74f9257..1c76557 100644 --- a/web/template/pkg_details.php +++ b/web/template/pkg_details.php @@ -192,7 +192,7 @@ if ($row["MaintainerUID"]): ?> <li><a href="<?= htmlspecialchars(get_pkg_uri($darr[0]), ENT_QUOTES); ?>" title="<?= __('View packages details for').' '.$darr[0].$darr[1]?>"><?= $darr[0].$darr[1]?></a></li> <?php else: ?> - <li><a href="http://www.archlinux.org/packages/?q=<?= urlencode($darr[0])?>" title="<?= __('View packages details for').' '.$darr[0].$darr[1] ?>"><?= $darr[0].$darr[1] ?></a></li> + <li><a href="https://www.archlinux.org/packages/?q=<?= urlencode($darr[0])?>" title="<?= __('View packages details for').' '.$darr[0].$darr[1] ?>"><?= $darr[0].$darr[1] ?></a></li> <?php endif; ?> <?php endwhile; ?> </ul> -- 1.7.12.4

2 1

[aur-dev] [PATCH] Link to the HTTPs login page in the header
by Lukas Fleischer 21 Oct '12

21 Oct '12

Change the login link so that it points directly to the HTTPs version of the login page if "$DISABLE_HTTP_LOGIN" is set and if HTTP is used. Signed-off-by: Lukas Fleischer <archlinux(a)cryptocrack.de> --- web/lib/aur.inc.php | 2 ++ web/template/header.php | 4 ++++ 2 files changed, 6 insertions(+) diff --git a/web/lib/aur.inc.php b/web/lib/aur.inc.php index 93ae23b..018d5c8 100644 --- a/web/lib/aur.inc.php +++ b/web/lib/aur.inc.php @@ -298,6 +298,8 @@ function db_connect() { * @return void */ function html_header($title="") { + global $AUR_LOCATION; + global $DISABLE_HTTP_LOGIN; global $LANG; global $SUPPORTED_LANGS; diff --git a/web/template/header.php b/web/template/header.php index c78f1e3..265d638 100644 --- a/web/template/header.php +++ b/web/template/header.php @@ -63,7 +63,11 @@ <li><a href="<?= get_uri('/logout/'); ?>"><?= __("Logout"); ?></a></li> <?php else: ?> <li><a href="<?= get_uri('/register/'); ?>"><?= __("Register"); ?></a></li> + <?php if ($DISABLE_HTTP_LOGIN && empty($_SERVER['HTTPS'])): ?> + <li><a href="<?= $AUR_LOCATION . get_uri('/login/'); ?>"><?= __("Login"); ?></a></li> + <?php else: ?> <li><a href="<?= get_uri('/login/'); ?>"><?= __("Login"); ?></a></li> + <?php endif; ?> <?php endif; ?> </ul> </div> -- 1.7.12.4

1 0

[aur-dev] [PATCH 1/6] pkg_details.php: Add missing XHTML close tags
by canyonknight 20 Oct '12

20 Oct '12

Signed-off-by: canyonknight <canyonknight(a)gmail.com> --- web/template/pkg_details.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/web/template/pkg_details.php b/web/template/pkg_details.php index b286664..74f9257 100644 --- a/web/template/pkg_details.php +++ b/web/template/pkg_details.php @@ -117,6 +117,7 @@ if ($SID && ($uid == $row["MaintainerUID"] || <a href="<?= get_uri('/packages/'); ?>?C=<?= $row['CategoryID'] ?>"><?= $row['Category'] ?></a> <?php endif; ?> </td> + </tr> <tr> <th><?= __('License') . ': ' ?></th> <td><?= htmlspecialchars($license) ?></td> @@ -138,6 +139,7 @@ if ($row["SubmitterUID"]): <?php else: ?> <td>None</td> <?php endif; ?> + </tr> <tr> <th><?= __('Maintainer') .': ' ?></th> <?php @@ -160,9 +162,9 @@ if ($row["MaintainerUID"]): <th><?= __('Votes') . ': ' ?></th> <?php if ($atype == "Developer" || $atype == "Trusted User"): ?> <?php if ($USE_VIRTUAL_URLS): ?> - <td><a href="<?= get_pkg_uri($row['Name']); ?>voters/"><?= $votes ?></a> + <td><a href="<?= get_pkg_uri($row['Name']); ?>voters/"><?= $votes ?></a></td> <?php else: ?> - <td><a href="<?= get_uri('/voters/'); ?>?ID=<?= $pkgid ?>"><?= $votes ?></a> + <td><a href="<?= get_uri('/voters/'); ?>?ID=<?= $pkgid ?>"><?= $votes ?></a></td> <?php endif; ?> <?php else: ?> <td><?= $votes ?></td> -- 1.7.12.3

2 6

[aur-dev] [PATCH] Display a 404 page if a virtual path doesn't exist
by Lukas Fleischer 20 Oct '12

20 Oct '12

Give user feedback instead of bailing out with an empty HTTP response body. Signed-off-by: Lukas Fleischer <archlinux(a)cryptocrack.de> --- web/html/404.php | 14 ++++++++++++++ web/html/index.php | 4 ++++ 2 files changed, 18 insertions(+) create mode 100644 web/html/404.php diff --git a/web/html/404.php b/web/html/404.php new file mode 100644 index 0000000..caaaf90 --- /dev/null +++ b/web/html/404.php @@ -0,0 +1,14 @@ +<?php + +set_include_path(get_include_path() . PATH_SEPARATOR . '../lib'); + +html_header( __("Page Not Found") ); +?> + +<div id="error-page" class="box 404"> + <h2>404 - Page Not Found</h2> + <p>Sorry, the page you've requested does not exist.</p> +</div> + +<?php +html_footer(AUR_VERSION); diff --git a/web/html/index.php b/web/html/index.php index 6ee23bc..422c0e5 100644 --- a/web/html/index.php +++ b/web/html/index.php @@ -102,5 +102,9 @@ if (isset($tokens[1]) && '/' . $tokens[1] == get_pkg_route()) { header("Content-Type: image/png"); include "./$path"; break; + default: + header("HTTP/1.0 404 Not Found"); + include "./404.php"; + break; } } -- 1.7.12.3

2 2

[aur-dev] [PATCH] aurjson.class.php: Limit number of RPC results
by canyonknight 18 Oct '12

18 Oct '12

With no limit to the number of results, memory_limit set to 32M can easily be exceeded for searches that have a large number of results. This results in an HTTP error 500 for those queries. Limit results to 5000 packages to avoid exceeding memory_limit. Introduce new JSON error code for when the result limit is hit. Fixes FS#31849 Signed-off-by: canyonknight <canyonknight(a)gmail.com> --- It doesn't have to be 5000. That's just a safe arbitrary number I came up with during testing. web/lib/aurjson.class.php | 18 +++++++++++++----- 1 file changed, 13 insertions(+), 5 deletions(-) diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php index fbdc711..5701697 100644 --- a/web/lib/aurjson.class.php +++ b/web/lib/aurjson.class.php @@ -149,6 +149,10 @@ class AurJSON { } } + if ($resultcount === 5000) { + return $this->json_error('Too many package results.'); + } + return $this->json_results($type, $resultcount, $search_data); } else { @@ -198,7 +202,8 @@ class AurJSON { $keyword_string = $this->dbh->quote("%" . addcslashes($keyword_string, '%_') . "%"); $where_condition = "(Name LIKE {$keyword_string} OR "; - $where_condition.= "Description LIKE {$keyword_string})"; + $where_condition.= "Description LIKE {$keyword_string}) "; + $where_condition.= "LIMIT 5000"; return $this->process_query('search', $where_condition); } @@ -238,17 +243,19 @@ class AurJSON { $where_condition = ""; if ($ids) { $ids_value = implode(',', $args['ids']); - $where_condition .= "ID IN ({$ids_value})"; + $where_condition .= "ID IN ({$ids_value}) "; } if ($ids && $names) { - $where_condition .= " OR "; + $where_condition .= "OR "; } if ($names) { // individual names were quoted in parse_multiinfo_args() $names_value = implode(',', $args['names']); - $where_condition .= "Name IN ({$names_value})"; + $where_condition .= "Name IN ({$names_value}) "; } + $where_condition .= "LIMIT 5000"; + return $this->process_query('multiinfo', $where_condition); } @@ -260,7 +267,8 @@ class AurJSON { private function msearch($maintainer) { $maintainer = $this->dbh->quote($maintainer); - $where_condition = "Users.Username = {$maintainer}"; + $where_condition = "Users.Username = {$maintainer} "; + $where_condition .= "LIMIT 5000"; return $this->process_query('msearch', $where_condition); } -- 1.7.12.3

2 1

[aur-dev] [PATCH] Sync CSS with archweb
by Lukas Fleischer 18 Oct '12

18 Oct '12

Signed-off-by: Lukas Fleischer <archlinux(a)cryptocrack.de> --- web/html/css/archweb.css | 50 +++++++++++++++++++++++++++++++++++++----------- 1 file changed, 39 insertions(+), 11 deletions(-) diff --git a/web/html/css/archweb.css b/web/html/css/archweb.css index cafae77..905a3ec 100644 --- a/web/html/css/archweb.css +++ b/web/html/css/archweb.css @@ -273,7 +273,7 @@ table.pretty2 { } /* additional styles for JS sorting */ - table.pretty2 th.header { + table.pretty2 th.tablesorter-header { padding-right: 20px; background-image: url(nosort.gif); background-repeat: no-repeat; @@ -281,11 +281,11 @@ table.pretty2 { cursor: pointer; } - table.pretty2 th.headerSortDown { + table.pretty2 th.tablesorter-headerSortDown { background-image: url(desc.gif); } - table.pretty2 th.headerSortUp { + table.pretty2 th.tablesorter-headerSortUp { background-image: url(asc.gif); } @@ -486,6 +486,31 @@ h3 span.arrow { border: 1px solid #09c; } + .pkgsearch-typeahead { + position: absolute; + top: 100%; + left: 0; + z-index: 1000; + display: none; + float: left; + padding: 0.15em 0.1em; + margin: 0; + min-width: 10em; + font-size: 0.812em; + text-align: left; + list-style: none; + background-color: #f6f9fc; + border: 1px solid #09c; + } + + .pkgsearch-typeahead li a { + color: #000; + } + + .pkgsearch-typeahead li.active a { + color: #07b; + } + /* home: recent pkg updates */ #pkg-updates h3 { margin: 0 0 0.3em; @@ -617,7 +642,7 @@ table.results { } /* additional styles for JS sorting */ - table.results th.header { + table.results th.tablesorter-header { padding-right: 20px; background-image: url(nosort.gif); background-repeat: no-repeat; @@ -625,12 +650,12 @@ table.results { cursor: pointer; } - table.results th.headerSortDown { + table.results th.tablesorter-headerSortDown { background-color: #e4eeff; background-image: url(desc.gif); } - table.results th.headerSortUp { + table.results th.tablesorter-headerSortUp { background-color: #e4eeff; background-image: url(asc.gif); } @@ -797,7 +822,10 @@ form#flag-pkg-form input[type=text] { #pkgdetails #metadata .virtual-dep, #pkgdetails #metadata .testing-dep, +#pkgdetails #metadata .staging-dep, #pkgdetails #metadata .opt-dep, +#pkgdetails #metadata .make-dep, +#pkgdetails #metadata .check-dep, #pkgdetails #metadata .dep-desc { font-style: italic; } @@ -811,12 +839,12 @@ form#flag-pkg-form input[type=text] { padding-top: 1em; } - #pkgdetails #pkgfiles li.d { - color: #666; - } +#pkgfilelist li.d { + color: #666; +} - #pkgdetails #pkgfiles li.f { - } +#pkgfilelist li.f { +} /* mirror stuff */ table td.country { -- 1.7.12.3

2 1