--- branches/pear-db/admin/include/accessClass.php 2004/03/05 13:54:58 49 +++ branches/pear-db/admin/include/accessClass.php 2004/03/05 22:38:33 50 @@ -17,10 +17,8 @@ // Database variables -var $db_ac = "libdata"; -var $db_ac_srv = "localhost"; -var $db_ac_usr = "libdata"; -var $db_ac_pwd = "libdatapw"; +#var $access_dsn = 'mysql://libdata:libdatapw@localhost/libdata'; +var $access_dsn = 'pgsql://dpavlin@/libdata'; /********************************************************** Constructor Method: accessClass @@ -33,11 +31,14 @@ function accessClass($sessionClass) { // Set the database connection variables - $this->con_ac = @mysql_connect ( $this->db_ac_srv, $this->db_ac_usr, $this->db_ac_pwd ) - or die ( "ERROR: Could not connect to database server!" ); - $this->result_ac = mysql_select_db ( $this->db_ac, $this->con_ac ) - or die ( "ERROR: Could not connect to database!" ); - + global $dsn_options; + $this->con_ac =& DB::connect($this->access_dsn, $dsn_options); + if (DB::isError($db)) { + # XXX remove this! + print $db->getDebugInfo(); + + die($db->getMessage()); + } // Initialize for security purposes $valid = 0; @@ -63,8 +64,8 @@ FROM staff s, access a WHERE s.access_id = a.access_id AND s.staff_account = '" . $staff_account . "'"; - $rs = mysql_query($sql, $this->con_ac); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $this->con_ac); + $row = xx_fetch_array ($rs); $access_level = $row["access_level"]; $access = $row["access"]; $first_name = $row["first_name"];