[PATCH] Quote MySql 8.0 reserved keywords

2019-01-14 Thread Florian Pritz
Signed-off-by: Florian Pritz --- aurweb/git/update.py | 4 ++-- schema/aur-schema.sql | 4 ++-- upgrading/3.0.0.txt | 4 ++-- upgrading/3.1.0.txt | 2 +- web/lib/aurjson.class.php | 6 +++--- web/lib/pkgfuncs.inc.php | 2 +- 6 files changed, 11 insertions(+), 11 deletions

[PATCH] Hash IP for API rate limit

2018-04-22 Thread Florian Pritz
The hash uses the start of a fixed window as an HMAC key. Therefore the windows stored in the DB also use this so that there can only be one active window for each IP. Signed-off-by: Florian Pritz <bluew...@xinu.at> --- schema/aur-schema.sql | 2 +- upgrading/4.7.0.txt | 2 +

Mailing list posting style (was: Re: Extending the RPC to include "provides" info)

2018-03-08 Thread Florian Pritz
Hi everyone, On 08.03.2018 13:21, Actionless Loveless wrote: > [some nested quotes that are totally confusing and unnecessary] Please do NOT start new threads when replying and please reply under the quoted text. Also remove any quoted text that is not required to understand your reply. For

[PATCH] Add rate limit support to API

2017-12-07 Thread Florian Pritz
This allows us to prevent users from hammering the API every few seconds to check if any of their packages were updated. Real world users check as often as every 5 or 10 seconds. Signed-off-by: Florian Pritz <bluew...@xinu.at> --- Basic idea for a rate limiting solution. Currently the c

Re: aur-dev mailing list configuration changes regarding subject prefix and Reply-To header

2017-12-04 Thread Florian Pritz
Let's try that again, this time with the sender munging disabled. Sorry for the noise guys. Florian signature.asc Description: OpenPGP digital signature

aur-dev mailing list configuration changes regarding subject prefix and Reply-To header

2017-12-04 Thread Florian Pritz via aur-dev
Hi, The aur-dev mailing list will no longer change common headers in mails that are being distributed. This especially means that the subject will no longer contain the [aur-dev] prefix and the list will not rewrite the reply-to header. If you want to filter mails coming from this list, please

Re: [aur-dev] [PATCH] Store dependency descriptions in a separate column

2017-04-19 Thread Florian Pritz via aur-dev
ndencies() as well as pkg_required(). > > Suggested-by: Florian Pritz <bluew...@xinu.at> > Signed-off-by: Lukas Fleischer <lfleisc...@archlinux.org> The patch looks good, thanks! Florian signature.asc Description: OpenPGP digital signature

[aur-dev] [PATCH 1/2] schema: Remove invalid default values for TEXT columns

2017-04-15 Thread Florian Pritz via aur-dev
When running in strict mode, mysql throws an error upon encountering these definitions since they are not supported. References: https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html Signed-off-by: Florian Pritz <bluew...@xinu.at> --- schema/aur-schema.sql | 8 1 file c

[aur-dev] [PATCH 2/2] schema: Fix invalid NULL on primary key

2017-04-15 Thread Florian Pritz via aur-dev
nts. (Bug #13995622, Bug #66987, Bug #15967545, Bug #16545198) References: http://stackoverflow.com/a/22314073 Signed-off-by: Florian Pritz <bluew...@xinu.at> --- schema/aur-schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/schema/aur-schema.sql b/schema/aur-s

Re: [aur-dev] [aur-general] Perl-Moose dependency failure.

2016-06-10 Thread Florian Pritz via aur-dev
On 10.06.2016 21:59, John D Jones III via aur-general wrote: > On 06/10/16 13:45, Florian Pritz via aur-general wrote: >> On 10.06.2016 21:08, John D Jones III via aur-general wrote: >> Any reason you don't just call it perl-list-utils? That way it could be >> used to alway

Re: [aur-dev] [PATCH] Autofocus input fields at login and package-search

2015-05-27 Thread Florian Pritz
Please use the -v2 argument (also -v3, -v4, ...) to git format-patch or git send-email next time so the subject will look like this: [PATCH v2] Also I'd suggest using --in-reply-to with a message ID from your old thread so that threading works as expected and it's easier to view previous

Re: [aur-dev] aur-dev no longer uses port 2222 for SSH

2015-05-21 Thread Florian Pritz
On 21.05.2015 11:31, Lukas Fleischer wrote: If you are using the AUR 4.0.0 testing environment on aur-dev.archlinux.org, please note that we now use the default SSH port 22 instead of . This means that you can drop the : part from your Git remote URIs or remove the Port line from

Re: [aur-dev] list of AUR packages

2014-12-24 Thread Florian Pritz
On 24.12.2014 23:46, Xyne wrote: What is the current position on adding a query type to the JSON interface to return a full list of AUR packages? If creating a JSON list of that size is prohibitive, what about providing a simple, newline-delineated text file that is refreshed via a cronjob? I

Re: [aur-dev] [PATCH 2/6] Add a package request list

2014-07-01 Thread Florian Pritz
On 25.06.2014 11:44, Lukas Fleischer wrote: Introduce a new navigation point Requests that shows a list of pending package requests. This functionality is only available to Trusted Users. Signed-off-by: Lukas Fleischer archli...@cryptocrack.de --- web/html/pkgreq.php | 58

Re: [aur-dev] [PATCH 3/6] Allow for closing package requests

2014-07-01 Thread Florian Pritz
On 25.06.2014 11:44, Lukas Fleischer wrote: This allows Trusted Users to close package requests via the request list. Also, entries are now sorted such that open requests are shown before closed requests. Signed-off-by: Lukas Fleischer archli...@cryptocrack.de --- UPGRADING

Re: [aur-dev] [PATCH 1/6] Add support for filing package requests

2014-07-01 Thread Florian Pritz
On 25.06.2014 11:44, Lukas Fleischer wrote: Add a new entry to the package actions box that allows for filing deletion and orphan requests. When choosing that action, the user is redirected to a new page that allows for selecting a request type and entering a comment. When submitting the

Re: [aur-dev] [PATCH] Add support for TU ninja edits

2014-05-31 Thread Florian Pritz
On 31.05.2014 12:04, Lukas Fleischer wrote: Trusted Users now have the ability to overwrite packages without changing ownership. This allows for adding small fixes to PKGBUILDs without disowning the package. This sounds like it is bound to cause regressions. I keep my aur packages in a git

Re: [aur-dev] [PATCH] Add support for TU ninja edits

2014-05-31 Thread Florian Pritz
On 31.05.2014 15:24, Daniel Micay wrote: On 31/05/14 09:18 AM, Florian Pritz wrote: I keep my aur packages in a git repo and if updates come I do my work there. Ninja edits will only really be useful if the maintainer isn't responsive so chances are they won't even notice the edit. Next time

Re: [aur-dev] [PATCH] tu_details.php: Avoid division by zero

2013-08-26 Thread Florian Pritz
On 26.08.2013 17:56, Lukas Fleischer wrote: Do not divide by zero if the number of active TUs is unknown. Signed-off-by: Lukas Fleischer archli...@cryptocrack.de --- web/template/tu_details.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git

Re: [aur-dev] [PATCH 3/3] tu_details.php: Display vote result

2013-08-04 Thread Florian Pritz
On 04.08.2013 17:43, Lukas Fleischer wrote: This adds an field that indicates whether the vote was accepted or rejected, based on the rules specified in the TU Bylaws. Signed-off-by: Lukas Fleischer archli...@cryptocrack.de --- web/template/tu_details.php | 11 +++ 1 file changed,

Re: [aur-dev] How can I Upload a new vesion of the vidyo package to AUR?

2013-01-17 Thread Florian Pritz
This belong to aur-general, aur-dev is only for development of the AUR software itself. On 17.01.2013 20:52, Fernando Monticelli wrote: Hi all, Current vidyo (a CERN video conferencing tool) package in AUR doesn' t work for me. But I found a hack here

Re: [aur-dev] Update ikiwiki

2012-06-11 Thread Florian Pritz
that the package be orphaned so you can take over maintainership if the current maintainer doesn't respond for ~2-4 weeks. -- Florian Pritz signature.asc Description: OpenPGP digital signature

Re: [aur-dev] [PATCH] validate email and fully check existence of it

2012-03-20 Thread Florian Pritz
($smtp) { +fwrite($smtp, RSET\r\n); +fwrite($smtp, QUIT\r\n); +fclose($smtp); } # a new seed value for mt_srand() -- Florian Pritz signature.asc Description: OpenPGP digital signature

Re: [aur-dev] replace categories with tags (was: New user introduction and proposal)

2011-11-17 Thread Florian Pritz
searching. Something like the search on stackoverflow maybe. -- Florian Pritz signature.asc Description: OpenPGP digital signature

[aur-dev] [PATCH 1/5] README: fix pacman call

2011-06-22 Thread Florian Pritz
Signed-off-by: Florian Pritz bluew...@xinu.at --- web/README |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/web/README b/web/README index b8d1b72..0c081f2 100644 --- a/web/README +++ b/web/README @@ -1,7 +1,7 @@ Setup on Arch Linux: 1) Install

[aur-dev] [PATCH 2/5] use valid_email() from codeigniter's email helper

2011-06-22 Thread Florian Pritz
Signed-off-by: Florian Pritz bluew...@xinu.at --- web/lib/aur.inc.php |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/web/lib/aur.inc.php b/web/lib/aur.inc.php index 4c2cc55..3250133 100644 --- a/web/lib/aur.inc.php +++ b/web/lib/aur.inc.php @@ -78,7 +78,7 @@ function

[aur-dev] [PATCH 3/5] remove unneeded make_seed()

2011-06-22 Thread Florian Pritz
http://us.php.net/mt_srand Note: As of PHP 4.2.0, there is no need to seed the random number generator with srand() or mt_srand() as this is now done automatically. Signed-off-by: Florian Pritz bluew...@xinu.at --- web/lib/aur.inc.php | 12 +--- 1 files changed, 1 insertions(+), 11

Re: [aur-dev] vim-vimoutliner

2010-10-20 Thread Florian Pritz
the source from http://archive.ubuntu.com/ubuntu/pool/universe/v/vimoutliner/vimoutliner_0.3.4+pristine.orig.tar.gz Also, please post such requests to aur-general. -- Florian Pritz -- {flo,bluewi...@server-speed.net signature.asc Description: OpenPGP digital signature

Re: [aur-dev] [PATCH] PKGBUILD syntax highlight

2010-10-04 Thread Florian Pritz
On 03.10.2010 20:08, Lukas Fleischer wrote: I don't get the point of using urlencode() here tho. It changes / to %2F so /etc/passwd would result in a broken path. -- Florian Pritz -- {flo,bluewi...@server-speed.net signature.asc Description: OpenPGP digital signature