cvs: php-master-web / forgot.php /entry cvs-account.php event.php user-note.php /fetch countries.php cvsforwarding.php cvspasswd.php cvsusers.php
events.php mirrors.php user-notes.php /include alert_lib.inc /manage event.php mirrors.php user-notes.php users.php

jimw Sun Apr 21 13:58:51 2002 EDT Modified files: /php-master-web forgot.php /php-master-web/entry cvs-account.php event.php user-note.php /php-master-web/fetch countries.php cvsforwarding.php cvspasswd.php cvsusers.php events.php mirrors.php user-notes.php /php-master-web/include alert_lib.inc /php-master-web/manage event.php mirrors.php user-notes.php users.php Log: go ahead and use persistent connections

Index: php-master-web/forgot.php diff -u php-master-web/forgot.php:1.1 php-master-web/forgot.php:1.2 --- php-master-web/forgot.php:1.1 Thu Mar 14 22:07:40 2002 +++ php-master-web/forgot.php Sun Apr 21 13:58:50 2002 @@ -13,7 +13,7 @@ head("forgotten password"); -mysql_connect("localhost","nobody","") +mysql_pconnect("localhost","nobody","") or die("unable to connect to database"); mysql_select_db("php3") or die("unable to select database"); Index: php-master-web/entry/cvs-account.php diff -u php-master-web/entry/cvs-account.php:1.5 php-master-web/entry/cvs-account.php:1.6 --- php-master-web/entry/cvs-account.php:1.5 Sun Jan 20 16:29:41 2002 +++ php-master-web/entry/cvs-account.php Sun Apr 21 13:58:50 2002 @@ -10,7 +10,7 @@ $username = strtolower($username); -@mysql_connect("localhost","nobody", "") +@mysql_pconnect("localhost","nobody", "") or die("failed to connect to database"); @mysql_select_db("php3") or die("failed to select database"); Index: php-master-web/entry/event.php diff -u php-master-web/entry/event.php:1.4 php-master-web/entry/event.php:1.5 --- php-master-web/entry/event.php:1.4 Mon Mar 4 18:35:08 2002 +++ php-master-web/entry/event.php Sun Apr 21 13:58:50 2002 @@ -20,7 +20,7 @@ if (empty($sdesc) || empty($email) || empty($country) || empty($category) || empty($type)) die("missing some parameters."); -@mysql_connect("localhost","nobody", "") +@mysql_pconnect("localhost","nobody", "") or die("failed to connect to database"); @mysql_select_db("php3") or die("failed to select database"); Index: php-master-web/entry/user-note.php diff -u php-master-web/entry/user-note.php:1.6 php-master-web/entry/user-note.php:1.7 --- php-master-web/entry/user-note.php:1.6 Wed Oct 3 21:11:34 2001 +++ php-master-web/entry/user-note.php Sun Apr 21 13:58:50 2002 @@ -8,7 +8,7 @@ if (!isset($user) || empty($note) || empty($sect)) die("missing some parameters."); -@mysql_connect("localhost","nobody", "") +@mysql_pconnect("localhost","nobody", "") or die("failed to connect to database"); @mysql_select_db("php3") or die("failed to select database"); Index: php-master-web/fetch/countries.php diff -u php-master-web/fetch/countries.php:1.2 php-master-web/fetch/countries.php:1.3 --- php-master-web/fetch/countries.php:1.2 Sun Mar 3 14:27:46 2002 +++ php-master-web/fetch/countries.php Sun Apr 21 13:58:50 2002 @@ -5,7 +5,7 @@ die("token not correct."); // Connect and generate the list from the DB -if (@mysql_connect("localhost","nobody","")) { +if (@mysql_pconnect("localhost","nobody","")) { if (@mysql_select_db("php3")) { $res = @mysql_query("SELECT * FROM country ORDER BY name"); if ($res) { Index: php-master-web/fetch/cvsforwarding.php diff -u php-master-web/fetch/cvsforwarding.php:1.8 php-master-web/fetch/cvsforwarding.php:1.9 --- php-master-web/fetch/cvsforwarding.php:1.8 Sat Apr 20 16:51:13 2002 +++ php-master-web/fetch/cvsforwarding.php Sun Apr 21 13:58:50 2002 @@ -5,7 +5,7 @@ die("token not correct."); // Connect and generate the list from the DB -if (@mysql_connect("localhost","nobody","")) { +if (@mysql_pconnect("localhost","nobody","")) { if (@mysql_select_db("php3")) { $res = @mysql_query("SELECT username,email FROM users WHERE email != '' AND cvsaccess"); if ($res) { Index: php-master-web/fetch/cvspasswd.php diff -u php-master-web/fetch/cvspasswd.php:1.5 php-master-web/fetch/cvspasswd.php:1.6 --- php-master-web/fetch/cvspasswd.php:1.5 Fri Oct 19 18:05:46 2001 +++ php-master-web/fetch/cvspasswd.php Sun Apr 21 13:58:50 2002 @@ -5,7 +5,7 @@ die("token not correct."); // Connect and generate the list from the DB -if (@mysql_connect("localhost","nobody","")) { +if (@mysql_pconnect("localhost","nobody","")) { if (@mysql_select_db("php3")) { $res = @mysql_query("SELECT username,passwd FROM users WHERE passwd != '' AND cvsaccess"); if ($res) { Index: php-master-web/fetch/cvsusers.php diff -u php-master-web/fetch/cvsusers.php:1.4 php-master-web/fetch/cvsusers.php:1.5 --- php-master-web/fetch/cvsusers.php:1.4 Fri Oct 19 18:05:46 2001 +++ php-master-web/fetch/cvsusers.php Sun Apr 21 13:58:50 2002 @@ -5,7 +5,7 @@ die("token not correct."); // Connect and generate the list from the DB -if (@mysql_connect("localhost","nobody","")) { +if (@mysql_pconnect("localhost","nobody","")) { if (@mysql_select_db("php3")) { $res = @mysql_query("SELECT username,name,email FROM users WHERE cvsaccess"); if ($res) { Index: php-master-web/fetch/events.php diff -u php-master-web/fetch/events.php:1.4 php-master-web/fetch/events.php:1.5 --- php-master-web/fetch/events.php:1.4 Tue Mar 5 20:13:59 2002 +++ php-master-web/fetch/events.php Sun Apr 21 13:58:50 2002 @@ -4,7 +4,7 @@ #if (!isset($token) || md5($token) != "19a3ec370affe2d899755f005e5cd90e") # die("token not correct."); -@mysql_connect('localhost','nobody','') or exit; +@mysql_pconnect('localhost','nobody','') or exit; @mysql_select_db('php3') or exit; $re = array(1=>'First',2=>'Second',3=>'Third',4=>'Fourth',-1=>'Last',-2=>'2nd Last',-3=>'3rd Last'); Index: php-master-web/fetch/mirrors.php diff -u php-master-web/fetch/mirrors.php:1.2 php-master-web/fetch/mirrors.php:1.3 --- php-master-web/fetch/mirrors.php:1.2 Thu Mar 7 19:57:07 2002 +++ php-master-web/fetch/mirrors.php Sun Apr 21 13:58:50 2002 @@ -5,7 +5,7 @@ die("token not correct."); // Connect and generate the list from the DB -if (@mysql_connect("localhost","nobody","")) { +if (@mysql_pconnect("localhost","nobody","")) { if (@mysql_select_db("php3")) { $res = @mysql_query("SELECT mirrors.*,country.name AS cname FROM mirrors LEFT JOIN country ON mirrors.cc = country.id ORDER BY country.name,hostname"); if ($res) { Index: php-master-web/fetch/user-notes.php diff -u php-master-web/fetch/user-notes.php:1.3 php-master-web/fetch/user-notes.php:1.4 --- php-master-web/fetch/user-notes.php:1.3 Tue Nov 20 20:31:50 2001 +++ php-master-web/fetch/user-notes.php Sun Apr 21 13:58:50 2002 @@ -4,7 +4,7 @@ if (!isset($token) || md5($token) != "19a3ec370affe2d899755f005e5cd90e") die("token not correct."); -@mysql_connect("localhost","nobody","") +@mysql_pconnect("localhost","nobody","") or exit; @mysql_select_db("php3") or exit; Index: php-master-web/include/alert_lib.inc diff -u php-master-web/include/alert_lib.inc:1.1 php-master-web/include/alert_lib.inc:1.2 --- php-master-web/include/alert_lib.inc:1.1 Wed Oct 3 21:11:34 2001 +++ php-master-web/include/alert_lib.inc Sun Apr 21 13:58:50 2002 @@ -1,6 +1,6 @@ <?php -$alink = mysql_connect("localhost","nobody","") or die("failed to connect to database"); +$alink = mysql_pconnect("localhost","nobody","") or die("failed to connect to database"); @mysql_select_db("php3", $alink) or die("failed to select database"); /*{{{ show_alert_form */ Index: php-master-web/manage/event.php diff -u php-master-web/manage/event.php:1.5 php-master-web/manage/event.php:1.6 --- php-master-web/manage/event.php:1.5 Tue Mar 5 19:51:48 2002 +++ php-master-web/manage/event.php Sun Apr 21 13:58:51 2002 @@ -22,7 +22,7 @@ head("event administration"); -@mysql_connect("localhost","nobody","") +@mysql_pconnect("localhost","nobody","") or die("unable to connect to database"); @mysql_select_db("php3"); Index: php-master-web/manage/mirrors.php diff -u php-master-web/manage/mirrors.php:1.7 php-master-web/manage/mirrors.php:1.8 --- php-master-web/manage/mirrors.php:1.7 Sun Mar 3 22:12:43 2002 +++ php-master-web/manage/mirrors.php Sun Apr 21 13:58:51 2002 @@ -38,7 +38,7 @@ head("mirror administration"); -mysql_connect("localhost","nobody","") +mysql_pconnect("localhost","nobody","") or die("unable to connect to database"); mysql_select_db("php3"); Index: php-master-web/manage/user-notes.php diff -u php-master-web/manage/user-notes.php:1.13 php-master-web/manage/user-notes.php:1.14 --- php-master-web/manage/user-notes.php:1.13 Tue Dec 18 12:04:23 2001 +++ php-master-web/manage/user-notes.php Sun Apr 21 13:58:51 2002 @@ -71,7 +71,7 @@ $action = $m[1]; $id = $m[2]; } -@mysql_connect("localhost","nobody","") +@mysql_pconnect("localhost","nobody","") or die("unable to connect to database"); @mysql_select_db("php3") or die("unable to select database"); Index: php-master-web/manage/users.php diff -u php-master-web/manage/users.php:1.21 php-master-web/manage/users.php:1.22 --- php-master-web/manage/users.php:1.21 Tue Feb 5 17:09:43 2002 +++ php-master-web/manage/users.php Sun Apr 21 13:58:51 2002 @@ -14,7 +14,7 @@ head("user administration"); -@mysql_connect("localhost","nobody","") +@mysql_pconnect("localhost","nobody","") or die("unable to connect to database"); @mysql_select_db("php3");