<?php
// Include the CRC Object class that needs to
// extended by all classes. This is the super
// class.
include_once('crc_constants.mod.php');
include_once('crc_object.cls.php');
include_once('crc_mysql.cls.php');
//******************************************
// Name: crc_object
//******************************************
//
// Desc: The primary CRC Object
// Developer: Shaffin Bhanji
// Email: hide@address.com
// Date: March 10th, 2003
// Version: 1.0.0
//
// Copyright
// =========
// This code is copyright, use in part or
// whole is prohibited without a written
// concent to the developer.
//******************************************
class crc_register extends crc_object {
var $m_uid;
var $m_pwd;
var $m_email;
var $m_rdn;
var $m_fname;
var $m_lname;
var $m_dob;
var $m_gender;
var $m_emp;
var $m_emptitle;
var $m_empcomp;
var $m_add1;
var $m_add2;
var $m_city;
var $m_prov;
var $m_country;
var $m_code;
var $m_phland;
var $m_phcell;
var $m_phfax;
var $m_roleid;
var $m_active;
var $m_sql;
var $m_data;
function crc_register($debug) {
//******************************************
// Initialization by constructor
//******************************************
$this->classname = 'crc_register';
$this->classdescription = 'Handle user registration.';
$this->classversion = '1.0.0';
$this->classdate = 'March 10th, 2003';
$this->classdevelopername = 'Shaffin Bhanji';
$this->classdeveloperemail = 'hide@address.com';
$this->_DEBUG = $debug;
if ($this->_DEBUG) {
echo "DEBUG {crc_register::constructor}: The class \"crc_register\" was successfuly created. <br>";
echo "DEBUG {crc_register::constructor}: Running in debug mode. <br>";
}
}
function fn_getroleid($db, $role) {
//******************************************
// Get the users role_id
//******************************************
if ($this->_DEBUG) {
echo "DEBUG {crc_register::fn_getroleid}: Retreiving the role id: " . $role . " for the profile. <br>";
}
if ($db->m_mysqlhandle != 0) {
$this->m_sql = 'select role_id from ' .
MYSQL_ROLES_TBL .
' where (role_name = "' . $role . '")';
$resource = $db->fn_runsql(MYSQL_DB, $this->m_sql);
if (mysql_num_rows($resource) > 0) {
$row = mysql_fetch_row($resource);
$this->m_roleid = $row[0];
} else {
$this->lasterrnum = ERR_PROFILE_NOROLE_NUM;
$this->lasterrmsg = ERR_PROFILE_NOROLE_DESC;
$this->m_roleid = 0;
if ($this->_DEBUG) {
echo 'ERROR {crc_register::fn_getroleid}: The sql command returned nothing. <br>';
echo 'ERROR {crc_register::fn_getroleid}: Error number: ' . $this->lasterrnum . '. <br>';
echo 'ERROR {crc_register::fn_getroleid}: Error description: ' . $this->lasterrmsg . '. <br>';
}
}
return $this->m_roleid;
} else {
return 0;
}
}
function fn_userexists($userid) {
//******************************************
// Check for a userid, if it already exisits
//******************************************
$result = false;
$db = new crc_mysql($this->_DEBUG);
$dbhandle = $db->fn_connect();
if ($dbhandle != 0) {
if ($this->_DEBUG) {
echo 'DEBUG {crc_register::fn_userexists}: Checking to see if the userid: ' . $userid . ' already exists!. <br>';
}
$this->m_sql = 'select * from ' . MYSQL_PROFILES_TBL . ' where (profile_uid = "' . $userid . '")';
$resource = $db->fn_runsql(MYSQL_DB, $this->m_sql);
if (mysql_num_rows($resource) > 0) {
$result = true;
} else {
$result = false;
}
$db->fn_freesql($resource);
return $result;
}
}
function fn_register($post) {
//******************************************
// Register a new user
//******************************************
$result = false;
$db = new crc_mysql($this->_DEBUG);
$dbhandle = $db->fn_connect();
if ($dbhandle != 0) {
if ($this->_DEBUG) {
echo 'DEBUG {crc_register::fn_register}: Reading $post variables. <br>';
}
$this->m_uid = strtolower($post['email']);
$this->m_pwd = strtolower($post['password']);
$this->m_email = strtolower($post['email']);
$this->m_rdn = strtolower($post['context']);
$this->m_gender = strtoupper($post['gender']{0});
$this->m_dob = $post['year'] . '-' . $post['month'] . '-' . $post['day'];
$this->m_fname = ucfirst($post['fname']);
$this->m_lname = ucfirst($post['lname']);
$this->m_add1 = strtoupper($post['add1']);
$this->m_add2 = strtoupper($post['add2']);
$this->m_city = ucfirst($post['city']);
$this->m_prov = strtoupper($post['province']);
$this->m_country = ucfirst($post['country']);
$this->m_code = str_replace(" ", "", strtoupper($post['pc']));
$this->m_phland = $post['lcode'] . $post['lprefix'] . $post['lpostfix'];
$this->m_roleid = $this->fn_getroleid($db, $post['profile']);
if ($this->_DEBUG) {
echo 'DEBUG {crc_register::fn_register}: Obtained role id: '. $this->m_roleid . ' <br>';
}
if ($this->fn_userexists($this->m_uid) == false) {
$this->m_sql = 'insert into ' . MYSQL_PROFILES_TBL . '(' .
'profile_uid, profile_pwd, profile_firstname, profile_lastname, ' .
'profile_email, profile_dob, profile_gender, profile_address_one, ' .
'profile_address_two, profile_city, profile_province_state, profile_postal_code, ' .
'profile_country, profile_phone_land, ' .
'profile_role_id, profile_rdn) ' .
'values("' . $this->m_uid . '","' . $this->m_pwd . '","' . $this->m_fname . '","' . $this->m_lname . '",' .
'"' . $this->m_email . '","' . $this->m_dob . '","' . $this->m_gender . '","' . $this->m_add1 . '",' .
'"' . $this->m_add2 . '","' . $this->m_city . '","' . $this->m_prov . '","' . $this->m_code . '",' .
'"' . $this->m_country . '","' . $this->m_phland . '",' . $this->m_roleid . ',"' . $this->m_rdn . '")';
//print('SQL: [' . $this->m_sql . ']');
$resource = $db->fn_runsql(MYSQL_DB, $this->m_sql);
if (mysql_affected_rows() > 0) {
$result = true;
} else {
$this->lasterrnum = ERR_REGISTER_ADD_NUM;
$this->lasterrmsg = ERR_REGISTER_ADD_DESC;
if ($this->_DEBUG) {
echo 'ERROR {crc_profile::fn_setprofile}: Could not register profile information. <br>';
echo 'ERROR {crc_profile::fn_setprofile}: Error number: ' . $this->lasterrnum . '. <br>';
echo 'ERROR {crc_profile::fn_setprofile}: Error description: ' . $this->lasterrmsg . '. <br>';
}
$result = false;
}
$db->fn_freesql($resource);
$db->fn_disconnect();
return $result;
} else {
$this->lasterrnum = ERR_REGISTER_USEREXISTS_NUM;
$this->lasterrmsg = ERR_REGISTER_USEREXISTS_DESC;
if ($this->_DEBUG) {
echo 'ERROR {crc_profile::fn_setprofile}: The email you have provided already exists! <br>';
echo 'ERROR {crc_profile::fn_setprofile}: Error number: ' . $this->lasterrnum . '. <br>';
echo 'ERROR {crc_profile::fn_setprofile}: Error description: ' . $this->lasterrmsg . '. <br>';
}
$result = false;
}
$db->fn_disconnect();
return $result;
} else {
$db->fn_disconnect();
return $result;
}
}
}
?>
<!--
?php
//This will test the fn_register function.
$register = new crc_register(True);
$data['context'] = 'ou=Don Mills,ou=Toronto,ou=Ontario,ou=Canada,o=CRC World';
$data['profile'] = 'Student';
$data['email'] = 'al';
$data['password'] = 'al';
$data['fname'] = 'al';
$data['lname'] = 'bhanji3';
$data['year'] = '1969';
$data['month'] = '03';
$data['day'] = '24';
$data['gender'] = 'Male';
$data['add1'] = '28 Elson Street';
$data['add2'] = '';
$data['city'] = 'Markham';
$data['province'] = 'ON';
$data['pc'] = 'L3S2J5';
$data['country'] = 'Canada';
$data['lcode'] = '416';
$data['lprefix'] = '524';
$data['lpostfix'] = '9520';
$register->fn_register($data);
?
-->