summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2009-06-18Advanced button i18nSergej Pupykin
Signed-off-by: Sergej Pupykin <sergej.pupykin@lx-ltd.ru> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-06-18russian updateSergej Pupykin
Signed-off-by: Sergej Pupykin <sergej.pupykin@lx-ltd.ru> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-06-18Specify explicit joins for package searchDan McGee
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 McGee
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 Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-13Don't hit the database twice per comment on packageDan McGee
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 Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-13Move cn.po to zh_CN.po.Loui Chang
Update AUTHORS, and config.inc.proto Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-12Add more Chinese translations.Supern Lee
Signed-off-by: Supern Lee <supern.lee@gmail.com> Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-12Add Chinese translations.Supern Lee
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 Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-06Bump version to 1.5.6.21.5.6.2Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-06Update AUTHORS - dp and dusty.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-04-01Tweak the bash parsing for package submission.Loui Chang
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 Taylor
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Add LocationID to returned fields in json interface.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Fix search output if no results are found.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Redirect to REQUEST_URI after logging in.Loui Chang
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 Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Remove obsolete LAUNCH.txtLoui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03pkgfuncs.inc: Fix indentation.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-03Update cleanup script to remove non-unsupported files.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-02Fix user stats table links.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-03-02added links at My Statistic valuesAndrea Scarpino
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-20Fix the comment poop bug.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-20tupkgs: Print date and time when a client connects.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-18Revamp markup and styles for comments.Loui Chang
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 Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-18XHTML Validation fixes.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-18Add 'Out of Date' detail in search formAndrea Scarpino
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-18Add more HACKING guidelines.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-16Correct comment removal in pkgsubmit.php1.5.6.1Gergely Imreh
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 Imreh
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 McGee
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 Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-13Change layout of tu_details.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-13List TUs that voted on a proposal.Angel 'angvp' Velasquez
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 Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-13Fix Sources listing in package details.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-09xhtml validation fix.Loui Chang
2009-02-06Clean up some markup and styles in page navigation.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-02-03Change pagination styleCallan Barrett
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.61.5.6Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-29Update Italian translation and some improvementsGiovanni Scafora
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 Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-28Add support for filename::url syntax for sources.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-28Update AUTHORS.Loui Chang
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
2009-01-28FS#2649, FS#12645: subsititution of all variables and "eval"Gergely Imreh
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 Chang
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 Chang
This helps improve the use of space. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
generated by cgit v1.2.3-54-g00ecf (git 2.45.2) at 2024-11-07 19:17:55 +0000