cvs: php-master-web /fetch cvsforwarding.php cvspasswd.php cvsusers.php cvswriters.php

From: Date: Wed, 17 Oct 2001 23:22:25 +0000
Subject: cvs: php-master-web /fetch cvsforwarding.php cvspasswd.php cvsusers.php cvswriters.php
Groups: php.mirrors 
Request: Send a blank email to php-mirrors+get-7055@lists.php.net to get a copy of this message
jimw Wed Oct 17 19:22:25 2001 EDT Modified files: /php-master-web/fetch cvsforwarding.php cvspasswd.php cvsusers.php cvswriters.php Log: splitting cvs-specific stuff to distinct table. Index: php-master-web/fetch/cvsforwarding.php diff -u php-master-web/fetch/cvsforwarding.php:1.3 php-master-web/fetch/cvsforwarding.php:1.4 --- php-master-web/fetch/cvsforwarding.php:1.3 Tue Oct 16 23:06:44 2001 +++ php-master-web/fetch/cvsforwarding.php Wed Oct 17 19:22:25 2001 @@ -7,7 +7,7 @@ // Connect and generate the list from the DB if (@mysql_connect("localhost","nobody","")) { if (@mysql_select_db("php3")) { - $res = @mysql_query("SELECT cvsuser,email FROM users WHERE cvsuser IS NOT NULL AND email != ''"); + $res = @mysql_query("SELECT users_cvs.cvsuser,email FROM users LEFT JOIN users_cvs USING (userid) WHERE email != '' AND users_cvs.approved"); if ($res) { while ($row = @mysql_fetch_array($res)) { echo "$row[cvsuser]: $row[email];\n"; Index: php-master-web/fetch/cvspasswd.php diff -u php-master-web/fetch/cvspasswd.php:1.1 php-master-web/fetch/cvspasswd.php:1.2 --- php-master-web/fetch/cvspasswd.php:1.1 Tue Oct 16 19:50:26 2001 +++ php-master-web/fetch/cvspasswd.php Wed Oct 17 19:22:25 2001 @@ -7,7 +7,7 @@ // Connect and generate the list from the DB if (@mysql_connect("localhost","nobody","")) { if (@mysql_select_db("php3")) { - $res = @mysql_query("SELECT cvsuser,passwd FROM users WHERE cvsuser IS NOT NULL AND passwd != ''"); + $res = @mysql_query("SELECT users_cvs.cvsuser,passwd FROM users LEFT JOIN users_cvs USING (userid) WHERE passwd != '' AND users_cvs.approved"); if ($res) { while ($row = @mysql_fetch_array($res)) { echo "$row[cvsuser]:$row[passwd]:cvs\n"; Index: php-master-web/fetch/cvsusers.php diff -u php-master-web/fetch/cvsusers.php:1.1 php-master-web/fetch/cvsusers.php:1.2 --- php-master-web/fetch/cvsusers.php:1.1 Tue Oct 16 21:54:19 2001 +++ php-master-web/fetch/cvsusers.php Wed Oct 17 19:22:25 2001 @@ -7,7 +7,7 @@ // Connect and generate the list from the DB if (@mysql_connect("localhost","nobody","")) { if (@mysql_select_db("php3")) { - $res = @mysql_query("SELECT cvsuser,name,email FROM users WHERE cvsuser IS NOT NULL AND passwd != ''"); + $res = @mysql_query("SELECT users_cvs.cvsuser,name,email FROM users LEFT JOIN users_cvs USING (userid) WHERE email != '' AND users_cvs.approved"); if ($res) { while ($row = @mysql_fetch_array($res)) { echo "$row[cvsuser]:$row[name]:$row[email]\n"; Index: php-master-web/fetch/cvswriters.php diff -u php-master-web/fetch/cvswriters.php:1.1 php-master-web/fetch/cvswriters.php:1.2 --- php-master-web/fetch/cvswriters.php:1.1 Tue Oct 16 21:00:30 2001 +++ php-master-web/fetch/cvswriters.php Wed Oct 17 19:22:25 2001 @@ -7,7 +7,7 @@ // Connect and generate the list from the DB if (@mysql_connect("localhost","nobody","")) { if (@mysql_select_db("php3")) { - $res = @mysql_query("SELECT cvsuser FROM users WHERE cvsuser IS NOT NULL AND passwd != ''"); + $res = @mysql_query("SELECT cvsuser FROM users_cvs WHERE approved"); if ($res) { while ($row = @mysql_fetch_array($res)) { if ($row[cvsuser] == 'cvsread') continue;

« previous php.mirrors (#7055) next »