This project is mirrored from https://:*****@gitlab.archlinux.org/archlinux/aurweb.git.
Pull mirroring updated .
- 25 Jun, 2011 4 commits
-
-
Florian Pritz authored
Signed-off-by:
Florian Pritz <bluewind@xinu.at> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Florian Pritz authored
Signed-off-by:
Florian Pritz <bluewind@xinu.at> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Dan McGee authored
We were doing some silly things here with an "ORDER BY Name, CategoryID" clause, due to the fact that Name is unique, and thus any additional ordering after Name will have no effect. Of course, the dumb as a box of rocks MySQL query optimizer doesn't realize this, leading to full table scans every time of ~30000 packages instead of using index scans for the ordering and only retrieving the first 50 rows. The biggest change is noted in the default sort order as it cuts down the columns to one, but we can remove the redundant sort from other orderings as well, even though those will still not be able to use an index-driven query plan. Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Dan McGee authored
We do a lookup by DepName in the package details view, but I made the silly mistake of forgetting this index addition in the upgrade steps. Lukas: Fix numbering in "UPGRADING". Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
- 22 Jun, 2011 5 commits
-
-
Lukas Fleischer authored
The use of header() to redirect after previous output was a design flaw. Our only luck here was PHP's "output_buffering" config variable defaulting to 4096, which kind of hid the bug for a long time. Fixes FS#24580. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
Provie a mechanism to specify cache type from NONE, APC, or MEMCACHE based on a config variable. If MEMCACHE type is selected, a list of servers can be specified to provide multiserver support. Note that php-memcaced is required for MEMCACHE support. Lukas: Minor commenting style fixes. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
Lukas: Add note to "UPGRADING". Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
utilize the apc cache functionality in aur.inc to cache the rss feed output. the cache will cache on a per-protocol basis (http/https) so that urls are appropriate regardless of which url people hit. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
- move apc cache code to aur.inc (centralize) - refactor the apc usage in stats.inc to utilize new code in aur.inc Lukas: Small commenting style and spelling changes. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
- 29 May, 2011 4 commits
-
-
Lukas Fleischer authored
Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Lukas Fleischer authored
Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
- Undefined index: HTTPS in rss.php on line 8 - Undefined property: RSSCreator20::$cssStyleSheet in feedcreator.class.php on line 591 Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
- move request_method test to the top, and catch other request types (HEAD, PUT, etc) - change how html output is handled. instead of building a string, just output the html - set appropriate response header for incorrect request_method. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
- 17 May, 2011 4 commits
-
-
kachelaqa authored
after reading the discussion about the submitter field, i looked again at my previous patch and realized that it was not very good at all. hopefully this simplified version will be more acceptable. the justification for this patch is that many third-party tools will want to know how new a package is, or when it last changed. adding the submitted and modified timestamps will allow users to get all the relevant package data in a single query. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
Add etag and if-none-match conditional get support. This will allow 'smart client' to save network bandwidth, as they can save the etag hash value for queries and test it later. Still an http request because this patch specifically sets a cache lifetime of zero, and must-revalidate. The benefit here is bandwidth savings. Caching based on expires headers would likely be counter productive, as the api data can change rather quickly...but etag is a nice compromise, and could be quite beneficial for bandwidth recution in some scenarios. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
the query was being performed when $id was not set, resulting in an invalid sql query being performed. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
make the sql query form consistent in usage by cleaning up instances where db_query's result was not inspected before attempting to fetch row data from the handle Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
- 09 May, 2011 1 commit
-
-
Karlis Lauva authored
Lukas: Use tabs for indentation instead of spaces. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
- 27 Apr, 2011 6 commits
-
-
Lukas Fleischer authored
Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
add a hook to db_query to log all sql queries when SQL_DEBUG is set Additionally, provide better logging for sql error situations (provide backtrace as well as error message). Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
elij authored
fixes php notice level error: Undefined variable: whovoted in ../tu.php Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Dan McGee authored
Matches our normal code conventions. Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Dan McGee authored
Ensure we are not quoting these values in any of our SQL queries. Thanks-to: elij <elij.mx@gmail.com> Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Dan McGee authored
Increases compatibility with standard SQL dialect. Thanks-to: elij <elij.mx@gmail.com> Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
- 24 Apr, 2011 2 commits
-
-
Lukas Fleischer authored
Prevent race conditions that may occur when either the session or the user is deleted before we extract the actual user identifier. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Lukas Fleischer authored
uid_from_sid() is called once at the very beginning of the script, storing the actual user identifier in "$uid". No need to fire up another query. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
- 19 Apr, 2011 6 commits
-
-
Lukas Fleischer authored
Basically just sync with what archweb currently uses, prefixing all relative URLs with "http://www.archlinux.org". Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Lukas Fleischer authored
Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Lukas Fleischer authored
Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Lukas Fleischer authored
Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Lukas Fleischer authored
There may be characters in package dependencies that are reserved within URLs (e.g. "+"). Use urlencode() to ensure those are encoded correctly. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Dan McGee authored
This takes `git shortlog -sen | wc -l` length from 69 to 56 authors for me, fixing a lot of the author fields that have snuck in over time, and allows credit to be given where due for some contributors that couldn't pick a single email address in the past. Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
- 16 Apr, 2011 4 commits
-
-
tuxce authored
Include maintainer in info and search method. Lukas: Adjustments for "multiinfo" queries. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Dan McGee authored
The majority of "real world" info requests [1] come in hefty batches. We would be better served to handle these in one request rather than multiple by allowing AUR clients to send multiple arguments. This enables things like this to work: http://aur.test/rpc.php?type=multiinfo&arg[]=cups-xerox&arg[]=cups-mc2430dl&arg[]=10673 Note to RPC users: unfortunately due to the asinine design of PHP, you unfortunately have to use the 'arg[]' syntax if you want more than one query argument, or you will only get the package satisfying the last arg you pass. [1] Rough data from April 11, 2011, with a total hit count of 1,109,163: 12 /login.php 13 /rpc.php?type=sarch 15 /rpc.php?type=msearch 16 /pingserver.php 16 /rpc.php 22 /logout.php 163 /passreset.php 335 /account.php 530 /pkgsubmit.php 916 /rss2.php 3838 /index.php 6752 /rss.php 9699 / 42478 /rpc.php?type=search 184737 /packages.php 681725 /rpc.php?type=info That means a whopping 61.5% of our requests were for info over the RPC interface; package pages are a distant second at only 16.7%. Lukas: Introduce "multiinfo" query instead of extending "info" (for the sake of backward compatibility). Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Dan McGee authored
Do the implode as the same but separate step each time, and remove indentation where no other query has it. Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Dan McGee authored
* Mark things static in the class rather than use a constructor every single invocation of the service. * Don't call mysql_real_escape_string() before we even have a database connection, and don't do work in the database if we don't need to. * Formatting consistency fixups in a few places. * Add new process_query() helper function; use this instead of copy-pasted code in all of the RPC method calls. * Remove the escaping code meant to fix FS#15526, introduced in commit 4d1eb4dd . It broke more than it solved, only fixed the output in one of three RPC calls (and who knows what the web interface then also does), and proper encoding should be done at the database level rather than up here. Lukas: Add special case for "info" queries to process_query() (return a single result instead of an array of results here). Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
- 13 Apr, 2011 4 commits
-
-
Dan McGee authored
You need this enabled for the AUR, period. No need for this BS. Signed-off-by:
Dan McGee <dan@archlinux.org> Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Lukas Fleischer authored
PHP requires callback functions to be passed as strings. Fix this to supress PHP notices. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Lukas Fleischer authored
Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-
Lukas Fleischer authored
We do not require this column anymore. New package notifications are no longer supported. Signed-off-by:
Lukas Fleischer <archlinux@cryptocrack.de>
-