function m_insertUser()
{
$_SESSION['referer'] = $this->libFunc->ifSet($_SESSION, 'referer', "");
$comFunc = new c_commonFunctions();
$comFunc->obDb = $this->obDb;
$timestamp = time();
$status = $this->libFunc->ifSet($this->request, "status", "");
if (!isset($this->request['bill_state_id']) || empty($this->request['bill_state_id'])) {
$this->request['bill_state_id'] = "";
} else {
$this->request['bill_state'] = "";
}
$this->obDb->query = "select iCustmerid_PK FROM " . CUSTOMERS . " WHERE vEmail = '" . $this->request['txtemail'] . "'";
$qryResult = $this->obDb->fetchQuery();
$rCount = $this->obDb->record_count;
if ($rCount == 1) {
if ($this->request['customertype'] == "trade") {
$this->obDb->query = "UPDATE " . CUSTOMERS . " SET vFirstName='" . $this->libFunc->m_addToDB($this->request['first_name']) . "',vLastName='" . $this->libFunc->m_addToDB($this->request['last_name']) . "',vPassword=PASSWORD('" . $this->libFunc->m_addToDB($this->request['txtpassword']) . "') ,vAddress1='" . $this->libFunc->m_addToDB($this->request['address1']) . "',vAddress2='" . $this->libFunc->m_addToDB($this->request['address2']) . "',vCity='" . $this->libFunc->m_addToDB($this->request['city']) . "',vState='" . $this->libFunc->m_addToDB($this->request['bill_state_id']) . "',vStateName='" . $this->libFunc->m_addToDB($this->request['bill_state']) . "',vCountry='" . $this->libFunc->m_addToDB($this->request['bill_country_id']) . "',vZip='" . $this->libFunc->m_addToDB($this->request['zip']) . "',vCompany='" . $this->libFunc->m_addToDB($this->request['company']) . "',vRetail='" . $this->libFunc->m_addToDB($this->request['customertype']) . "',vPhone='" . $this->libFunc->m_addToDB($this->request['phone']) . "',vHomePage='" . $this->libFunc->m_addToDB($this->request['homepage']) . "',iMailList='" . $this->request['mail_list'] . "',tmSignupDate='{$timestamp}',iRegistered='1' WHERE vEmail='" . $this->request['txtemail'] . "'";
$this->obDb->updateQuery();
$subObjId = $this->obDb->last_insert_id;
$comFunc->m_sendDetails_trade($this->request['txtemail'], $this->request['txtpassword']);
} else {
$this->obDb->query = "UPDATE " . CUSTOMERS . " SET vFirstName='" . $this->libFunc->m_addToDB($this->request['first_name']) . "',vLastName='" . $this->libFunc->m_addToDB($this->request['last_name']) . "',vPassword=PASSWORD('" . $this->libFunc->m_addToDB($this->request['txtpassword']) . "') ,vAddress1='" . $this->libFunc->m_addToDB($this->request['address1']) . "',vAddress2='" . $this->libFunc->m_addToDB($this->request['address2']) . "',vCity='" . $this->libFunc->m_addToDB($this->request['city']) . "',vState='" . $this->libFunc->m_addToDB($this->request['bill_state_id']) . "',vStateName='" . $this->libFunc->m_addToDB($this->request['bill_state']) . "',vCountry='" . $this->libFunc->m_addToDB($this->request['bill_country_id']) . "',vZip='" . $this->libFunc->m_addToDB($this->request['zip']) . "',vCompany='" . $this->libFunc->m_addToDB($this->request['company']) . "',vRetail='" . $this->libFunc->m_addToDB($this->request['customertype']) . "',vPhone='" . $this->libFunc->m_addToDB($this->request['phone']) . "',vHomePage='" . $this->libFunc->m_addToDB($this->request['homepage']) . "',iMailList='" . $this->request['mail_list'] . "',tmSignupDate='{$timestamp}',iRegistered='1' WHERE vEmail='" . $this->request['txtemail'] . "'";
$this->obDb->updateQuery();
$subObjId = $this->obDb->last_insert_id;
$comFunc->m_sendDetails($this->request['txtemail'], $this->request['txtpassword']);
$_SESSION['userid'] = $subObjId;
$_SESSION['username'] = $this->request['first_name'];
}
} else {
#INSERTING CUSTOMER
if ($this->request['customertype'] == "trade") {
$this->obDb->query = "INSERT INTO " . CUSTOMERS . "\n\t\t\t\t\t(iCustmerid_PK,vFirstName,vLastName,\n\t\t\t\t\t vEmail ,vPassword ,vAddress1,vAddress2,vCity,\n\t\t\t\t\tvState,vStateName,vCountry,vZip,vCompany,vRetail,vPhone ,\n\t\t\t\t\t vHomePage ,iMailList,tmSignupDate,iStatus,iRegistered) \n\t\t\t\t\tvalues('',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['first_name']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['last_name']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['txtemail']) . "',\n\t\t\t\t\tPASSWORD('" . $this->libFunc->m_addToDB($this->request['txtpassword']) . "'),\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['address1']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['address2']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['city']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['bill_state_id']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['bill_state']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['bill_country_id']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['zip']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['company']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['customertype']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['phone']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['homepage']) . "',\n\t\t\t\t\t'" . $this->request['mail_list'] . "',\t\n\t\t\t\t\t'{$timestamp}','1','1')";
$this->obDb->updateQuery();
$subObjId = $this->obDb->last_insert_id;
$comFunc->m_sendDetails_trade($this->request['txtemail'], $this->request['txtpassword']);
} else {
$this->obDb->query = "INSERT INTO " . CUSTOMERS . "\n\t\t\t\t\t(iCustmerid_PK,vFirstName,vLastName,\n\t\t\t\t\tvEmail ,vPassword ,vAddress1,vAddress2,vCity,\n\t\t\t\t\tvState,vStateName,vCountry,vZip,vCompany,vRetail,vPhone ,\n\t\t\t\t\t vHomePage ,iMailList,tmSignupDate,iRegistered) \n\t\t\t\t\tvalues('',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['first_name']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['last_name']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['txtemail']) . "',\n\t\t\t\t\tPASSWORD('" . $this->libFunc->m_addToDB($this->request['txtpassword']) . "'),\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['address1']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['address2']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['city']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['bill_state_id']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['bill_state']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['bill_country_id']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['zip']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['company']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['customertype']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['phone']) . "',\n\t\t\t\t\t'" . $this->libFunc->m_addToDB($this->request['homepage']) . "',\n\t\t\t\t\t'" . $this->request['mail_list'] . "',\t\n\t\t\t\t\t'{$timestamp}','1')";
$this->obDb->updateQuery();
$subObjId = $this->obDb->last_insert_id;
$comFunc->m_sendDetails($this->request['txtemail'], $this->request['txtpassword']);
$_SESSION['userid'] = $subObjId;
$_SESSION['username'] = $this->request['first_name'];
}
}
if (!empty($_SESSION['referer'])) {
if ($this->request['customertype'] == "trade") {
$retUrl = $this->libFunc->m_safeUrl(SITE_URL . "user/index.php?action=user.loginForm&tc=s");
$this->libFunc->m_mosRedirect($retUrl);
} else {
$this->libFunc->m_mosRedirect($_SESSION['referer']);
}
} else {
$retUrl = $this->libFunc->m_safeUrl(SITE_URL . "user/index.php?action=user.home");
$this->libFunc->m_mosRedirect($retUrl);
}
exit;
}
function m_insertUser()
{
$comFunc = new c_commonFunctions();
$comFunc->obDb = $this->obDb;
$timestamp = time();
$this->request['status'] = $this->libFunc->ifSet($this->request, "status", "");
$this->request['bill_state_id'] = $this->libFunc->ifSet($this->request, "bill_state_id", "");
$this->request['bill_state'] = $this->libFunc->ifSet($this->request, "bill_state", "");
$this->request['customertype'] = $this->libFunc->ifSet($this->request, "vRetail", "");
#INSERTING CUSTOMER
$this->obDb->query = "INSERT INTO " . CUSTOMERS . "\n\t\t(iCustmerid_PK,vFirstName,vLastName,\n\t\t vEmail ,vPassword ,vAddress1,vAddress2,vCity,\n\t\t vState,vStateName,vCountry,vRetail,vZip,vCompany ,vPhone ,\n\t\t\t vHomePage ,iMailList,fMemberPoints,iStatus,tmSignupDate,iRegistered) \n\t\t\tvalues('',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['first_name']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['last_name']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['txtemail']) . "',\n\t\t\tPASSWORD('" . $this->libFunc->m_addToDB($this->request['password']) . "'),\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['address1']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['address2']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['city']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['bill_state_id']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['bill_state']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['bill_country_id']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['customertype']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['zip']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['company']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['phone']) . "',\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['homepage']) . "',\n\t\t\t'" . $this->request['mail_list'] . "',\t\n\t\t\t'" . $this->libFunc->m_addToDB($this->request['member_points']) . "',\n\t\t\t'" . $this->request['status'] . "',\n\t\t\t'{$timestamp}','1')";
$this->obDb->updateQuery();
$subObjId = $this->obDb->last_insert_id;
$comFunc->m_sendDetails($this->request['txtemail']);
$this->libFunc->m_mosRedirect(SITE_URL . "user/adminindex.php?action=user.details&id={$subObjId}");
}
