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}"); }