cvs: php-master-web /fetch cvsforwarding.php cvspasswd.php cvsusers.php cvswriters.php
| From: | Jim Winstead | 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;