cvs: php-master-web / users.sql /fetch svnpasswd.php /include svn-auth.inc

bjori Tue Dec 16 09:04:35 2008 UTC Added files: /php-master-web/fetch svnpasswd.php /php-master-web/include svn-auth.inc Modified files: /php-master-web users.sql Log: - Update the user table scheme - Add svn_gen_pass() function - Add script to generate the svn authentication file http://cvs.php.net/viewvc.cgi/php-master-web/users.sql?r1=1.5&r2=1.6&diff_format=u Index: php-master-web/users.sql diff -u php-master-web/users.sql:1.5 php-master-web/users.sql:1.6 --- php-master-web/users.sql:1.5 Thu Sep 28 18:04:02 2006 +++ php-master-web/users.sql Tue Dec 16 09:04:35 2008 @@ -25,6 +25,7 @@ CREATE TABLE users ( userid int(11) NOT NULL auto_increment, passwd varchar(16) NOT NULL default '', + svnpasswd varchar(32) NOT NULL default '', name varchar(255) NOT NULL default '', email varchar(255) NOT NULL default '', username varchar(16) default NULL, http://cvs.php.net/viewvc.cgi/php-master-web/fetch/svnpasswd.php?view=markup&rev=1.1 Index: php-master-web/fetch/svnpasswd.php +++ php-master-web/fetch/svnpasswd.php <?php // vim: et ts=2 sw=2 # token required, since this should only get accessed from cvs.php.net if (!isset($token) || md5($token) != "585ae1060f9b881490d1a1e3c7353e89") { die("token not correct."); } require dirname(__FILE__). "/../include/svn-auth.inc"; // Connect and generate the list from the DB if (@mysql_connect("localhost","nobody","")) { if (@mysql_select_db("phpmasterdb")) { $res = @mysql_query("SELECT username, svnpasswd FROM users WHERE svnpasswd != '' AND cvsaccess ORDER BY username"); if ($res) { while ($row = @mysql_fetch_array($res)) { printf("%s:%s:%s\n", $row["username"], REALM, $row["svnpasswd"]); } # the read-only svnread account printf("%s:%s:%s\n", "svnread", REALM, gen_svn_pass("svnread", "svnread")); } } } http://cvs.php.net/viewvc.cgi/php-master-web/include/svn-auth.inc?view=markup&rev=1.1 Index: php-master-web/include/svn-auth.inc +++ php-master-web/include/svn-auth.inc <?php define("REALM", "PHP Subversion Repository"); function gen_svn_pass($username, $password) { return md5(sprintf("%s:%s:%s", $username, REALM, $password)) }