<feed xmlns='http://www.w3.org/2005/Atom'>
<title>markzz/aurweb.git/web/template, branch 1.8.2</title>
<subtitle>aurweb working repository</subtitle>
<id>https://git.markzz.net/markzz/aurweb.git/atom/web/template?h=1.8.2</id>
<link rel='self' href='https://git.markzz.net/markzz/aurweb.git/atom/web/template?h=1.8.2'/>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/'/>
<updated>2011-04-06T17:29:35Z</updated>
<entry>
<title>Make "Exact name" search option translatable.</title>
<updated>2011-04-06T17:29:35Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-04-06T17:29:35Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=a5213daaecac88b3df7c04ae460260f2fe9f9174'/>
<id>urn:sha1:a5213daaecac88b3df7c04ae460260f2fe9f9174</id>
<content type='text'>
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Add option to search for exact name matches only (fixes FS#23556).</title>
<updated>2011-04-06T17:21:19Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-04-06T17:21:12Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=1c55e6b40c015f3c3b15681aa181ef2dfbd8b106'/>
<id>urn:sha1:1c55e6b40c015f3c3b15681aa181ef2dfbd8b106</id>
<content type='text'>
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Add more stats to the front page table</title>
<updated>2011-04-03T20:59:33Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-03-31T01:48:11Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=2005a2889cebc817ad4bae6134aac109165fe595'/>
<id>urn:sha1:2005a2889cebc817ad4bae6134aac109165fe595</id>
<content type='text'>
Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Add indentation to stats table</title>
<updated>2011-04-03T20:59:32Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-03-31T01:48:10Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=79ce38d271bee57a792aeb8f52e9e96b6899a756'/>
<id>urn:sha1:79ce38d271bee57a792aeb8f52e9e96b6899a756</id>
<content type='text'>
Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
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>Fix XSS vulnerability in "web/template/header.php".</title>
<updated>2011-03-30T15:07:27Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-03-30T15:07:27Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=0a625ae8ff737f471ee4e29853ba57db20352b1a'/>
<id>urn:sha1:0a625ae8ff737f471ee4e29853ba57db20352b1a</id>
<content type='text'>
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Fix XSS vulnerabilities in package comment templates.</title>
<updated>2011-03-30T08:49:51Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-03-30T08:49:51Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=3aa2240b7dc281b37716a29025b08baf1318d059'/>
<id>urn:sha1:3aa2240b7dc281b37716a29025b08baf1318d059</id>
<content type='text'>
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Bump up default per-page value to 50</title>
<updated>2011-03-24T14:32:08Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-03-23T03:03:56Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=b6a34d013bd81c336312c09f55c417da1163b3f1'/>
<id>urn:sha1:b6a34d013bd81c336312c09f55c417da1163b3f1</id>
<content type='text'>
25 is woefully small for the number of packages many searches can
return, and with 28000+ packages in AUR, it makes sense to show a lot
more per page by default.

The new choices of (50, 100, 250) happen to match those from the main
site.

Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Fix main site package search URL</title>
<updated>2011-03-15T14:46:10Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-03-15T14:24:56Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=044393c44b64e822445a4193214d8aec17ef7a48'/>
<id>urn:sha1:044393c44b64e822445a4193214d8aec17ef7a48</id>
<content type='text'>
I've been wanting to kill this one for a long time.

Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
</feed>
