summaryrefslogtreecommitdiffstats
AgeCommit message (Collapse)AuthorFilesLines
2009-06-18Specify explicit joins for package searchDan McGee1-6/+6
Refactor the query to use explicit LEFT JOINs, which appears to be handled by MySQL in a saner fashion than the previous implicit join syntax. This is part two in a slight fixup for observed slow queries in the production environment. With the new indexes and this fixup, a particular iteration of this query will examine only 13346 rows instead of 272060. Signed-off-by: Dan McGee <dan@archlinux.org> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-06-18Add multicolumn indexes on votes and notifications tablesDan McGee1-1/+2
To put a long story short, when we do joins on these tables in our pkg_search_page() function, we always join on both the user ID and package ID columns. By creating multicolumn indices, we can always get the exact row we are looking for in the table. The benefits of adding a unique index should also speak for themselves, as we previously did not have this on either of these tables. This is part one of a two-part series to address the fact that this query was often showing up in our slow query logs. Signed-off-by: Dan McGee <dan@archlinux.org> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-13Add Ukranian translation to default config.Loui Chang1-0/+1
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-13Don't hit the database twice per comment on packageDan McGee3-6/+19
It's performance improvement day today. For non-superusers, we were hitting the database twice per comment on a package- once to get the UID, and once to check the owner of the comment. The best part is we already knew the owner of the comment, and we only need to get our own UID once. For viewing a package like yaourt, this cuts a single pageview from over 700 queries to around 18, which is still not great but a pretty big improvement. Signed-off-by: Dan McGee <dan@archlinux.org> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-13translator.inc: Eliminate notices for untranslated strings.Loui Chang1-8/+9
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-13Move cn.po to zh_CN.po.Loui Chang3-1/+6
Update AUTHORS, and config.inc.proto Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-12Add more Chinese translations.Supern Lee1-0/+110
Signed-off-by: Supern Lee <supern.lee@gmail.com> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-12Add Chinese translations.Supern Lee1-0/+154
Signed-off-by: Supern Lee <supern.lee@gmail.com> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-12Remove author information from scripts.Loui Chang2-5/+0
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-06Bump version to 1.5.6.2Loui Chang1-1/+1
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-06Update AUTHORS - dp and dusty.Loui Chang1-4/+5
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-01Tweak the bash parsing for package submission.Loui Chang1-10/+17
Better detection of the build function. Better detection of variables. Support for variables with underscores. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-12Fixed some errors/omissions in setup docsMark Taylor1-4/+8
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Add LocationID to returned fields in json interface.Loui Chang1-1/+1
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Fix search output if no results are found.Loui Chang2-5/+4
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Redirect to REQUEST_URI after logging in.Loui Chang1-2/+3
This closes FS#13017 Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Go to details page when a search returns one result.Loui Chang1-3/+9
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Remove obsolete LAUNCH.txtLoui Chang1-16/+0
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03pkgfuncs.inc: Fix indentation.Loui Chang1-140/+146
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Update cleanup script to remove non-unsupported files.Loui Chang2-1/+16
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-02Fix user stats table links.Loui Chang1-6/+14
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-02added links at My Statistic valuesAndrea Scarpino1-3/+3
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-20Fix the comment poop bug.Loui Chang2-7/+10
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-20tupkgs: Print date and time when a client connects.Loui Chang1-0/+1
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-18Revamp markup and styles for comments.Loui Chang2-24/+30
Make post date consistent with other dates. Look Ma, no tables! Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-18Remove unused CSS styles.Loui Chang1-69/+1
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-18XHTML Validation fixes.Loui Chang2-2/+2
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-18Add 'Out of Date' detail in search formAndrea Scarpino2-0/+12
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-18Add more HACKING guidelines.Loui Chang1-4/+8
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-16Correct comment removal in pkgsubmit.phpGergely Imreh1-4/+7
This only neutralises bash parameter substitution, but doesn't perform the proper replacement. Closes FS#13122. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-15Fix: FS#13189, infinite variable replacement cycleGergely Imreh1-1/+5
Lines such as foo=$foo in the PKGBUILD would end up in a infinite replacement cycle when uploaded, thus the upload times out. In these kind of lines, $foo is replaced not by "$foo" again, but deleted (missing value for foo). Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-15rpc: delay getting DB connection until absolutely necessaryDan McGee1-3/+4
Signed-off-by: Dan McGee <dan@archlinux.org> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-13Add Angel Velasquez to AUTHORS.Loui Chang1-0/+1
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-13Change layout of tu_details.Loui Chang3-15/+21
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-13List TUs that voted on a proposal.Angel 'angvp' Velasquez2-1/+27
This patch lists who voted on a proposal after the proposal is closed. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-13Add notes about php tags in HACKING.Loui Chang1-0/+4
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-13Fix Sources listing in package details.Loui Chang1-9/+8
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-09xhtml validation fix.Loui Chang1-1/+1
2009-02-06Clean up some markup and styles in page navigation.Loui Chang2-9/+19
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-03Change pagination styleCallan Barrett2-16/+29
Looks different now, next and previous on their own sides and elips for both Signed-off-by: Callan Barrett <wizzomafizzo@gmail.com> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-01Bump version to 1.5.6Loui Chang1-1/+1
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-29Update Italian translation and some improvementsGiovanni Scafora1-0/+8
Signed-off-by: Giovanni Scafora <giovanni@archlinux.org> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-29Add some more requirements to HACKING.Loui Chang1-1/+8
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-28Add support for filename::url syntax for sources.Loui Chang1-1/+3
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-28Update AUTHORS.Loui Chang1-1/+5
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-28FS#2649, FS#12645: subsititution of all variables and "eval"Gergely Imreh1-11/+26
All custom variables are handled during subsitution, as well as bash "eval" statements. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-25Add note about short open tags in web/README.Loui Chang1-0/+4
Since .htaccess was removed some people might have issues. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-25Remove huge margins from main content.Loui Chang1-8/+0
This helps improve the use of space. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-25Move package comment form into a new template.Loui Chang4-80/+78
Feature the form on the package details page. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-25Updated Turkish translation.Samed Beyribey1-1/+87
Signed-off-by: Loui Chang <louipc.ist@gmail.com>