<feed xmlns='http://www.w3.org/2005/Atom'>
<title>markzz/aurweb.git/web/lib/aur.inc, branch maint</title>
<subtitle>aurweb working repository</subtitle>
<id>https://git.markzz.net/markzz/aurweb.git/atom/web/lib/aur.inc?h=maint</id>
<link rel='self' href='https://git.markzz.net/markzz/aurweb.git/atom/web/lib/aur.inc?h=maint'/>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/'/>
<updated>2011-06-22T13:15:04Z</updated>
<entry>
<title>rename *.inc files to *.inc.php and adjust imports and references</title>
<updated>2011-06-22T13:15:04Z</updated>
<author>
<name>elij</name>
<email>elij.mx@gmail.com</email>
</author>
<published>2011-05-29T21:33:37Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=888db089c515270fd5cd9a9bedd217110f43bc4c'/>
<id>urn:sha1:888db089c515270fd5cd9a9bedd217110f43bc4c</id>
<content type='text'>
Lukas: Add note to "UPGRADING".

Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>refactor apc code and move to aur.inc</title>
<updated>2011-06-22T13:02:21Z</updated>
<author>
<name>elij</name>
<email>elij.mx@gmail.com</email>
</author>
<published>2011-05-28T23:17:09Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=af5d05f4ad517489558afcbc2296999c724d2c1e'/>
<id>urn:sha1:af5d05f4ad517489558afcbc2296999c724d2c1e</id>
<content type='text'>
- move apc cache code to aur.inc (centralize)
- refactor the apc usage in stats.inc to utilize new code in aur.inc

Lukas: Small commenting style and spelling changes.

Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>test return value from db_query before assuming it is valid</title>
<updated>2011-05-17T08:43:42Z</updated>
<author>
<name>elij</name>
<email>elij.mx@gmail.com</email>
</author>
<published>2011-05-11T23:17:12Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=0898f1447a2d6bdc893f55f4718f867734841361'/>
<id>urn:sha1:0898f1447a2d6bdc893f55f4718f867734841361</id>
<content type='text'>
make the sql query form consistent in usage by cleaning up instances
where db_query's result was not inspected before attempting to fetch row
data from the handle

Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>add SQL_DEBUG variable and database logging</title>
<updated>2011-04-27T12:50:44Z</updated>
<author>
<name>elij</name>
<email>elij.mx@gmail.com</email>
</author>
<published>2011-04-26T18:52:11Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=c43558ba60ed027227010a9b93e37ee8b78be430'/>
<id>urn:sha1:c43558ba60ed027227010a9b93e37ee8b78be430</id>
<content type='text'>
add a hook to db_query to log all sql queries when SQL_DEBUG is set
Additionally, provide better logging for sql error situations (provide
backtrace as well as error message).

Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>SQL: treat all UID/ID values as numbers, not strings</title>
<updated>2011-04-27T12:50:27Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-04-26T04:23:01Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=3609cf140eaca30878d0a69fba0d837b4fec41a0'/>
<id>urn:sha1:3609cf140eaca30878d0a69fba0d837b4fec41a0</id>
<content type='text'>
Ensure we are not quoting these values in any of our SQL queries.

Thanks-to: elij &lt;elij.mx@gmail.com&gt;
Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Replace translation engine with php-gettext.</title>
<updated>2011-04-10T13:40:50Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-04-07T01:53:31Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=22a718ea89bb78e25532d5256dc212cd0bcba94e'/>
<id>urn:sha1:22a718ea89bb78e25532d5256dc212cd0bcba94e</id>
<content type='text'>
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>Set a default timezone</title>
<updated>2011-03-04T09:29:17Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-03-01T18:24:48Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=d4b1ca7cf19c1a6b902b3c7810047156328d8c72'/>
<id>urn:sha1:d4b1ca7cf19c1a6b902b3c7810047156328d8c72</id>
<content type='text'>
With our use of strtotime() in stats.inc, we are "required" to do so or at
least the emitted warning tells us it is a good idea.

Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Improve cookie handling</title>
<updated>2011-03-04T09:29:13Z</updated>
<author>
<name>Dan McGee</name>
<email>dan@archlinux.org</email>
</author>
<published>2011-03-01T15:24:34Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=984ce9529c926c884136780d017ae90f0b82b54b'/>
<id>urn:sha1:984ce9529c926c884136780d017ae90f0b82b54b</id>
<content type='text'>
* Remove comment that is mostly bogus- the domain is automatically set.
* When logging out, don't delete the language cookie.
* Make the language cookie persistent.
* Use the minimal time possible to expire cookies; no need to compute
  anything.

Signed-off-by: Dan McGee &lt;dan@archlinux.org&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Set the character set when connecting to mysql</title>
<updated>2011-02-27T18:46:30Z</updated>
<author>
<name>Florian Pritz</name>
<email>bluewind@server-speed.net</email>
</author>
<published>2011-02-25T15:20:35Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=85c0db0ccd0dd3e57418c55ba3a843dbaa26fec2'/>
<id>urn:sha1:85c0db0ccd0dd3e57418c55ba3a843dbaa26fec2</id>
<content type='text'>
We should not rely on the default server setting staying the same
forever.

Signed-off-by: Florian Pritz &lt;bluewind@server-speed.net&gt;
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
</feed>
