<feed xmlns='http://www.w3.org/2005/Atom'>
<title>markzz/aurweb.git/web/html/pkgsubmit.php, branch 1.8.2</title>
<subtitle>aurweb working repository</subtitle>
<id>https://git.markzz.net/markzz/aurweb.git/atom/web/html/pkgsubmit.php?h=1.8.2</id>
<link rel='self' href='https://git.markzz.net/markzz/aurweb.git/atom/web/html/pkgsubmit.php?h=1.8.2'/>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/'/>
<updated>2011-04-05T09:31:12Z</updated>
<entry>
<title>Remove File_Find PEAR module from code base.</title>
<updated>2011-04-05T09:31:12Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-04-05T09:31:12Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=8b4b2d207e8b1ff1a9ad13ace726ac7ff1510a29'/>
<id>urn:sha1:8b4b2d207e8b1ff1a9ad13ace726ac7ff1510a29</id>
<content type='text'>
We removed the code depending on this a long time ago - drop it and add
some note to "UPGRADING".

Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Remove Dummy Package concept</title>
<updated>2011-04-03T20:59:32Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-03-31T01:48:09Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=7c91c592458b7532806ef75fe09146f82f085f3b'/>
<id>urn:sha1:7c91c592458b7532806ef75fe09146f82f085f3b</id>
<content type='text'>
Instead, we just store dependencies directly in the PackageDepends
table. Since we don't use this info anywhere besides the package details
page, there is little value in precalculating what is in the AUR vs.
what is not.

An upgrade path is provided via several SQL statements in the UPGRADING
document. There should be no user-visible change from this, but the DB
schema gets a bit more sane and we no longer have loads of junk packages
in our tables that are never shown to the end user. This should also
help the MySQL query planner in several cases as we no longer have to be
careful to exclude dummy packages on every query.

Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Always set ModifiedTS including new packages</title>
<updated>2011-04-03T20:59:31Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-03-31T01:48:08Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=1f252eba64acf18719bd514a7a4464ca18f4c1cb'/>
<id>urn:sha1:1f252eba64acf18719bd514a7a4464ca18f4c1cb</id>
<content type='text'>
Set it equal to the SubmittedTS field, which will be our indication the
package is new when we show the logo on the front page of the AUR.

This results in the ability to remove the use of the unindexable
GREATEST() function from the AUR code everywhere we had to use it before
to handle the 0 timestamp case.

Note that there is no race condition here in calling UNIX_TIMESTAMP()
twice- it always returns the time at the beginning of statment
execution:

    mysql&gt; select unix_timestamp(), sleep(2), unix_timestamp();
    +------------------+----------+------------------+
    | unix_timestamp() | sleep(2) | unix_timestamp() |
    +------------------+----------+------------------+
    |       1300851746 |        0 |       1300851746 |
    +------------------+----------+------------------+
    1 row in set (2.00 sec)

Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Submission process code refactor</title>
<updated>2011-04-03T20:59:31Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-03-31T01:48:07Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=1128489bd0e89694dd4d88ff69bab7c8d45d972a'/>
<id>urn:sha1:1128489bd0e89694dd4d88ff69bab7c8d45d972a</id>
<content type='text'>
We had a ton of duplicate code shared between the insert and update
cases. Do a refactor so we can pull this stuff out below the if/else
block and only need it there once, saving some headaches.

Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Be more restrictive with source tarball contents.</title>
<updated>2011-03-30T18:49:21Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-03-30T18:26:13Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=a427bd72a7e3d2c74fbe66317c88e44df4b7bc3a'/>
<id>urn:sha1:a427bd72a7e3d2c74fbe66317c88e44df4b7bc3a</id>
<content type='text'>
Reject tarballs containing more than one directory or files outside a
directory.

Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Fix PHP notice when submitting an empty file.</title>
<updated>2011-03-30T14:16:27Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-03-30T14:16:27Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=746c2b72b541865431d88af7a99df29c472a297c'/>
<id>urn:sha1:746c2b72b541865431d88af7a99df29c472a297c</id>
<content type='text'>
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Fix strict standards warnings in "web/html/pkgsubmit.php".</title>
<updated>2011-03-30T10:28:17Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-03-30T10:27:25Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=e4130fcca6a206e2947765630757482aaf0cdbc0'/>
<id>urn:sha1:e4130fcca6a206e2947765630757482aaf0cdbc0</id>
<content type='text'>
end() expects a reference but we pass a function return value here.
Using list() is a bit hacky as well as it expects a 0-based array
whereas unpack() returns a 1-based array - thus we use "list(, $foo)".

Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Check if submitted files are in GZIP format.</title>
<updated>2011-03-30T09:55:32Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-03-30T09:44:05Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=47faf88f14bd420163e29e3cd583e741e63ce929'/>
<id>urn:sha1:47faf88f14bd420163e29e3cd583e741e63ce929</id>
<content type='text'>
This is quite hacky but this way we can ensure users get comprehensible
error messages when trying to upload ".tar.xz" or ".tar.bz2" files.

Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as "NULL".</title>
<updated>2011-02-27T18:46:19Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-02-27T16:12:43Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=1e3fa38de5f940fef474fc3961c70b357b976308'/>
<id>urn:sha1:1e3fa38de5f940fef474fc3961c70b357b976308</id>
<content type='text'>
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Reject blacklisted packages on initial submission only.</title>
<updated>2011-02-25T10:18:02Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-02-25T10:17:42Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=2e1ce869ec2445f489d7e0d1890289d6f12761aa'/>
<id>urn:sha1:2e1ce869ec2445f489d7e0d1890289d6f12761aa</id>
<content type='text'>
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
</feed>
