<feed xmlns='http://www.w3.org/2005/Atom'>
<title>markzz/aurweb.git/web/html/passreset.php, branch v1.9.0</title>
<subtitle>aurweb working repository</subtitle>
<id>https://git.markzz.net/markzz/aurweb.git/atom/web/html/passreset.php?h=v1.9.0</id>
<link rel='self' href='https://git.markzz.net/markzz/aurweb.git/atom/web/html/passreset.php?h=v1.9.0'/>
<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>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>Use HTTPs for links in password reset confirmation mails.</title>
<updated>2011-04-19T21:59:19Z</updated>
<author>
<name>Lukas Fleischer</name>
<email>archlinux@cryptocrack.de</email>
</author>
<published>2011-04-19T21:59:19Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=5ea9fc197dc286d4dee78df24f6422a92797cdd5'/>
<id>urn:sha1:5ea9fc197dc286d4dee78df24f6422a92797cdd5</id>
<content type='text'>
Signed-off-by: Lukas Fleischer &lt;archlinux@cryptocrack.de&gt;
</content>
</entry>
<entry>
<title>Modify some strings for translation.</title>
<updated>2010-10-08T03:07:01Z</updated>
<author>
<name>Loui Chang</name>
<email>louipc.ist@gmail.com</email>
</author>
<published>2010-10-08T03:07:01Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=d13f2af0799d5be163b8438c7f9594c20bb76208'/>
<id>urn:sha1:d13f2af0799d5be163b8438c7f9594c20bb76208</id>
<content type='text'>
Signed-off-by: Loui Chang &lt;louipc.ist@gmail.com&gt;
</content>
</entry>
<entry>
<title>Support for storing salted passwords</title>
<updated>2010-04-17T20:50:24Z</updated>
<author>
<name>Denis</name>
<email>d.v.kobozev@gmail.com</email>
</author>
<published>2010-04-05T13:41:30Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=290c436046327d9f04b7d12b5fda19f4dc14f574'/>
<id>urn:sha1:290c436046327d9f04b7d12b5fda19f4dc14f574</id>
<content type='text'>
To upgrade existing databases:

ALTER TABLE Users ADD Salt CHAR(32) NOT NULL DEFAULT '';

Signed-off-by: Loui Chang &lt;louipc.ist@gmail.com&gt;
</content>
</entry>
<entry>
<title>Implement 'Password Reset' facility (FS#3061)</title>
<updated>2009-11-13T21:49:55Z</updated>
<author>
<name>Evangelos Foutras</name>
<email>foutrelis@gmail.com</email>
</author>
<published>2009-11-12T15:21:59Z</published>
<link rel='alternate' type='text/html' href='https://git.markzz.net/markzz/aurweb.git/commit/?id=861cbf493591ec876f71ba200a844ed6177026f9'/>
<id>urn:sha1:861cbf493591ec876f71ba200a844ed6177026f9</id>
<content type='text'>
This works by adding a new field to the 'Users' table called 'ResetKey',
which is a 32 characters long, random string. When the user requests a
password reset, a new 'reset key' is generated and sent to the user's
e-mail address in the form of a link in the following format:

  http://aur.archlinux.org/passreset.php?resetkey=&lt;reset key&gt;

When the above link is followed, the user is presented with a form to
verify his/her e-mail address and specify the new desired password. If
the e-mail address matches the reset key in the database, the new
password is assigned to the account. If there is an error, a relevant
message is displayed and the user is prompted to re-enter the required
information. Upon successful completion of this procedure, the ResetKey
field in the database is blanked and the specific key cannot be reused.

One SQL query is needed to add the ResetKey field to the 'Users' table:

  ALTER TABLE `Users` ADD `ResetKey` CHAR(32) NOT NULL DEFAULT '';

Signed-off-by: Loui Chang &lt;louipc.ist@gmail.com&gt;
</content>
</entry>
</feed>
