February 2011 - Aur-dev - lists.archlinux.org

[aur-dev] [PATCH] Update the german translation
by Wieland Hoffmann 06 Apr '11

06 Apr '11

The subject should be self-explanatory. Wieland

3 7

[aur-dev] [PATCH] Specify utf8 in database schema.
by Loui Chang 28 Feb '11

28 Feb '11

Signed-off-by: Loui Chang <louipc.ist(a)gmail.com> --- support/schema/aur-schema.sql | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index b713fc8..1649055 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -2,7 +2,7 @@ -- is also included such as AccountTypes, etc. -- DROP DATABASE AUR; -CREATE DATABASE AUR; +CREATE DATABASE AUR DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE AUR; -- Define the Account Types for the AUR. @@ -159,7 +159,7 @@ CREATE TABLE PackageComments ( ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, PackageID INTEGER UNSIGNED NOT NULL, UsersID INTEGER UNSIGNED NOT NULL, - Comments TEXT NOT NULl DEFAULT '', + Comments TEXT NOT NULL DEFAULT '', CommentTS BIGINT UNSIGNED NOT NULL DEFAULT 0, DelUsersID INTEGER UNSIGNED NULL DEFAULT NULL, PRIMARY KEY (ID), @@ -193,8 +193,8 @@ CREATE TABLE PackageBlacklist ( -- CREATE TABLE IF NOT EXISTS TU_VoteInfo ( ID int(10) unsigned NOT NULL auto_increment, - Agenda text collate latin1_general_ci NOT NULL, - User VARCHAR(32) collate latin1_general_ci NOT NULL, + Agenda text COLLATE utf8_general_ci NOT NULL, + User VARCHAR(32) COLLATE utf8_general_ci NOT NULL, Submitted bigint(20) unsigned NOT NULL, End bigint(20) unsigned NOT NULL, SubmitterID int(10) unsigned NOT NULL, -- 1.7.4.1

2 1

[aur-dev] Russian comments are '???'
by Joker-jar 26 Feb '11

26 Feb '11

Hi. Russian comments are like '???' now in the aur. Look: http://aur.archlinux.org/packages.php?ID=40365 I think, problem in database encoding

6 5

[aur-dev] AUR 1.8.0 released
by Lukas Fleischer 22 Feb '11

22 Feb '11

1.8.0 is finally out [1]! Please note that this release removes all the code for automatic tarball extraction. From now on, only PKGBUILDs and source tarballs will be accessible via the AUR web interface. 1.8.0 also introduces a package blacklist and a blacklist helper which can be used to avoid submission of packages from the official repos to the AUR. Other changes include: * Original submitters in package details. * Variable parser improvements. * "python2" shebang for all Python scripts. * "First" and "Last" links in search results. * Timestamps for out-of-date packages. * Clickable links in comments. * Auto redirection from confirmation screens. * RTL support. * Updated translations. * InnoDB compatibility for all tables. * Database cleanups. * Fixes for some XSS vulnerabilities. * Fixes for all bugs reported on the bug tracker [2] :) Check the Git log [3] for a complete list. The official Arch Linux AUR setup [4] will be upgraded soon! [1] http://projects.archlinux.org/aur.git/commit/?id=a7742012 [2] https://bugs.archlinux.org/index.php?project=2 [3] http://projects.archlinux.org/aur.git/log/?id=a7742012 [4] https://aur.archlinux.org/

4 3

Re: [aur-dev] aur-dev Digest, Vol 39, Issue 8
by Connor Behan 22 Feb '11

22 Feb '11

Why would you do this? I find it immensely useful to look at the patches AUR developers use so I can see what they do to packages out of curiosity. Now I will have to download the tarball to see the same thing even if it's a program I don't want to compile and use. Furthermore, I refer to several of my own patches with links to the AUR website. When I'm emailing someone saying "here is a patch you might like" I often provide a link to http://aur.archlinux.org/packages/medit-full/medit-full/bindings2.diff(which still works but for how long) instead of pasting it or attaching it. Just off the top of my head I can think of two websites and two bug reports I've made that I will have to change if these links stop working. Please reconsider. And if I've missed my chance to complain because this was voted on in the mailing lists then I'm sorry for missing it but I highly doubt that was the case. Please note that this release removes all the code for automatic tarball > extraction. From now on, only PKGBUILDs and source tarballs will be > accessible via the AUR web interface. >

2 1

Re: [aur-dev] AUR 1.8.0 released
by Connor Behan 22 Feb '11

22 Feb '11

Oops, wrong subject line in the last post.

1 0

[aur-dev] [PATCH] "logged before" -> "logged in before" in web/lib/pkgfuncs.inc
by Wieland Hoffmann 21 Feb '11

21 Feb '11

This fixes a small message telling people they had to be logged to edit package information into telling them they need to be logged _in_. --- web/lib/pkgfuncs.inc | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-)

2 1

[aur-dev] Adding the HE language.
by Netanel Shine 18 Feb '11

18 Feb '11

Hey there, i was working on translating the AUR to my language, Hebrew. I am adding to this message the gzipped patched file. btw. i know his name lame, but i think he will work just fine. THanks! -- Netanel Shine

6 40

[aur-dev] Package blacklist for the AUR
by Lukas Fleischer 10 Feb '11

10 Feb '11

Hi! I recently started working on a package blacklist for the official AUR which can e.g. be used to prevent people from uploading packages in the official repos to [unsupported] (cf. FS#12902 [1]). Patches can be found in the "pkg-blacklist" branch of my working tree [2]. They currently include some code that adds a "PackageBlacklist" table and a hacky helper utility that can be used to update that table by sync'ing it with some binary repos. Constructive criticism and suggestions welcome! [1] https://bugs.archlinux.org/task/12902 [2] http://git.cryptocrack.de/aur.git/log/?h=pkg-blacklist

5 9

[aur-dev] aur live-search
by elij 10 Feb '11

10 Feb '11

I was messing around and created a live-search-like query interface (which utilizes the aur-rpc). forum post: https://bbs.archlinux.org/viewtopic.php?id=112878 example site: http://aurlivesearch.awesometrousers.net/ code: https://github.com/cactus/aurlivesearch

2 2