title = " - Register"; //captach module $_SESSION["security_code"] = ""; include_once($page->Modules["captcha.mod.incl.php"]); include_once("webadmin/_nemo.email.cls.php"); $captcha = $strOutput; //Events //print_rr($_POST); die; // var_dump($_POST['Action']); if(isset($_POST['Action'])){ // print_r($_POST); // die; $url = "https://www.google.com/recaptcha/api/siteverify"; $data = [ 'secret'=> '6LezXNkZAAAAANHYxGKxW7BAv4ycocFxt-Nklrqe', 'response' =>$_POST['g-recaptcha-response'] ]; $options = array( 'http' => array( 'header' => "Content-type: application/x-www-form-urlencoded\r\n", 'method' => 'POST', 'content' => http_build_query($data) ) ); $context = stream_context_create($options); $response = file_get_contents($url, false, $context); $res = json_decode($response, true); // var_dump($res); if($res['success'] == true) { // Perform you logic here for ex:- save you data to database echo ' Success! Your inquiry successfully submitted. '; } else { echo ' Error! You are not a human. '; } } if($Action == "Submit") { //20110603 - reg post checks - pj //20120716 - added registration $post insert $xdb->doQuery("INSERT INTO `sysRegistration` (`IP`,`POST`) VALUES ('".$_SERVER['REMOTE_ADDR']."', \"". qs(serialize($_POST)) ."\")"); //die; if(!isset($_POST['radPackage'])){ header('Location: message.php?MID=2'); } if(stripos($_POST[strEmail], "googlemail.com")){ tblSpamInsert($_POST[strName], $_POST[strEmail]); } $row = $xdb->getRowSQL("SELECT * FROM sysSpam WHERE strEmail = ". $xdb->qs($_POST[strEmail]));//strIP = '".$_SERVER['REMOTE_ADDR']."' OR if($row) header('Location: message.php?MID=3'); //save client //INI //$Debug = 1; $cdb = new NemoDatabase("tblClient", 0, null, $Debug); //print_rr($cdb->Fields); if($_POST[txtAddressPostal] == "") $_POST[txtAddressPostal] = $_POST[txtAddressPysical]; $row = $cdb->getRowSQL("SELECT MAX(strMembershipNumber) as strMembershipNumber FROM tblClient WHERE strMembershipNumber > 0 AND strMembershipNumber < 9999999");//20110203 - added membership number $cdb->Fields[strMembershipNumber] = $row->strMembershipNumber + 1; $cdb->Fields[strClient] = $_POST[strName]; $cdb->Fields[strID] = $_POST[strID]; $cdb->Fields[strEmail] = $_POST[strEmail]; $cdb->Fields[strPhone] = $_POST[strPhone]; $cdb->Fields[strCell] = $_POST[strCell]; $cdb->Fields[strWork] = $_POST[strWork]; $cdb->Fields[txtAddressHome] = $_POST[txtAddressHome]; $cdb->Fields[txtAddressPostal] = $_POST[txtAddressPostal]; $cdb->Fields[strPostalCode] = $_POST[strPostalCode]; $cdb->Fields[refAreaID] = $_POST[refAreaID]; $cdb->Fields[strAccountHoldersName] = $_POST[strAccountHoldersName]; $cdb->Fields[strAccountNumber] = $_POST[strAccountNumber]; $cdb->Fields[strAccountType] = $_POST[strAccountType]; $cdb->Fields[strBankName] = $_POST[strBankName]; $cdb->Fields[strBranchCode] = $_POST[strBranchCode]; $cdb->Fields[strSurvey] = $_POST[strSurvey]; $cdb->Fields[blnActive] = 1; $cdb->Fields[dtRegistered] = date("Y-m-d"); $cdb->Fields[strFirstUser] = $cdb->Fields[strLastUser] = "Registration"; $cdb->Fields[dtFirstEdit] = date("Y-m-d H:i:s"); $result = $cdb->Save(); if($result->Error == 0) { if($_POST['PackageID'] > 0) { //get new ClientID $newClientID = $result->ID; $vdb = new NemoDatabase("tblVehicle", 0, null, $Debug); $vdb->Fields[refClientID] = $newClientID; $vdb->Fields[strVehicle] = $_POST['strVehicle']; $vdb->Fields[strRegistration] = $_POST['strRegistration']; $vdb->Fields[strColour] = $_POST['strColour']; $vdb->Fields[blnDefault] = 1; $vdb->Fields[dateLastUsedOn] = ""; $vdb->Save(); $row = $xdb->getRowSQL("SELECT * FROM tblPackage WHERE PackageID = '".$_POST['PackageID']."'"); $strPackage = $row->strPackage; $cpdb = new NemoDatabase("tblClientPackage", null, null, $Debug); $cpdb->Fields[refClientID] = $newClientID; $cpdb->Fields[refPackageID] = $_POST['PackageID']; $cpdb->Fields[dblPrice] = $row->dblPriceInc; $cpdb->Fields[dblMinCharge] = $row->dblMinCharge; $cpdb->Fields[dblFreeKM] = $row->dblFreeKM; $cpdb->Fields[dblMinimumTrip] = $row->dblMinimumTrip; $cpdb->Fields[dblChargePerKM] = $row->dblChargePerKM; $cpdb->Fields[dblAmount] = $row->dblPriceInc * 1; $cpdb->Fields[intQuantity] = 1; $cpdb->Fields[blnActive] = 1; $cpdb->Fields[strFirstUser] = $cpdb->Fields[strLastUser] = "Registration"; $cpdb->Fields[dtFirstEdit] = date("Y-m-d H:i:s"); $cpdb->Save(); $quantity = 0; if($_POST['chkFamilyDiscount'] == "on") {//20110707 - FM changes: only register a FM if FM -pj $row = $xdb->getRowSQL("SELECT * FROM tblPackage WHERE blnFamilyDiscountPackage = '1'"); $quantity = $_POST['intQuantity']; $cpdb = new NemoDatabase("tblClientPackage", 0, null, 0); $cpdb->Fields[refClientID] = $newClientID; $cpdb->Fields[refPackageID] = $row->PackageID; $cpdb->Fields[dblPrice] = $row->dblPriceInc; $cpdb->Fields[dblAmount] = $row->dblPriceInc * $quantity; $cpdb->Fields[intQuantity] = $quantity; $cpdb->Fields[blnActive] = 1; $cpdb->Fields[strFirstUser] = $cpdb->Fields[strLastUser] = "Registration"; $cpdb->Fields[dtFirstEdit] = date("Y-m-d H:i:s"); $cpdb->Save(); } } //Send the Email $nemoEmail = new NemoEmail($_POST[strEmail] , "Welcome new 1 For the Road Subscriber" , 0); $nemoEmail->addHeader("FROM", $page->SystemSettings["SMTP Send As"]); $nemoEmail->addHeader("BCC", $page->SystemSettings["SMTP BCC"]); $nemoEmail->Bcc = $page->SystemSettings["SMTP BCC"]; $nemoEmail->From = $page->SystemSettings["SMTP Send As"]; $nemoEmail->arrBody[1] = "Attention: ".$_POST[strName].",

You have successfully registered with 1 For The Road.

Your service will be activated shortly and you will be contacted.

You have registered with the following details:
Name: ".$_POST[strName]."
Email: ".$_POST[strEmail]."
Cell: ".$_POST[strCell]."
Phone: ".$_POST[strPhone]."
Package: ".$strPackage."
# Family members: ".$quantity."

Thanks
The 1 For the Road Team"; $nemoEmail->Save($arrFields); $nemoEmail->Send(); //goto message page header('Location: message.php?MID=1'); exit(); } else { header('Location: message.php?MID=2'); } }//eoSave //begin form //INI $required = "*";//"

"; $intMonths = 1; $widthA = "5%"; $widthB = "40%"; $widthC = "55%"; $rst = $xdb->doQuery("SELECT *, `blnOption:FamilyDiscount` as blnFamilyDiscount FROM tblPackage WHERE `blnOption:SellOnline` = 1 ORDER BY strDisplayOrder, strPackage"); //make page dynamic: phase 2 while($row = $xdb->fetch()) { //print_rr($row); if($row->PackageID != 5){ if($row->dblPriceInc != 0) { $intPriceInc = number_format($row->dblPriceInc/$intMonths,2); $strPriceOutput = "R".number_format($row->dblPriceInc/$intMonths,2); } else { $intPriceInc = 0; $strPriceOutput = "n/a"; } $jsOnclick = "blnShowF.value = Math.abs($row->blnFamilyDiscount -1); jsShowElement(\"divF\", blnShowF); jsResetDiscount(); jsReTotal(); /*jsShowPackageInfo($row->PackageID);*/"; //value='$row->PackageID' $familyDiscount = "blnOption:FamilyDiscount"; $tblPackages .= " PackageID ? "checked" : "")." type=radio name='radPackage' id='radPackage[$row->PackageID]' onclick='$jsOnclick' value = '$row->PackageID'> $row->strPackageHTML ". $strPriceOutput ." "; if($_REQUEST['PID'] == $row->PackageID) { $pickmeautoload = "blnShowF.value = Math.abs($row->blnFamilyDiscount -1); jsShowElement(\"divF\", blnShowF); jsReTotal(); "; } } } $tblPackages = " $tblPackages

Purchase a Package
Select	Package	Monthly Debit-Order Amount

"; $row = $xdb->getRowSQL("SELECT * FROM tblPackage WHERE blnFamilyDiscountPackage = 1"); if($row->dblPriceInc != 0) { $strPackagePriceInc = number_format($row->dblPriceInc/$intMonths,2); } else { $strPackagePriceInc = "n/a"; } $tblOptionFamilyDiscount = "

Add Family Discount	Quantity	Monthly Debit-Order Amount
		R". $strPackagePriceInc ."

"; $widthA = "40%"; $widthB = "60%"; $ddlArea = $xdb->ListOptions("SELECT 0 as ControlValue, '- Select -' AS ControlText UNION ALL SELECT AreaID as ControlValue, strArea AS ControlText FROM tblArea WHERE refProvince = strArea ORDER BY ControlText", null); //Security question calculation $r1 = rand(4,10); $r2 = rand(2,6); $arrOp = array("+","-","*"); $op = $arrOp[rand(0,2)]; $strQuestion = "$r1 $op $r2"; $strAnswer = ""; eval("\$strAnswer = $r1 $op $r2; "); // //CONTENT //20160623 - added package name, promotion code fieldsets - neils $page->Content = js(" var blnShowF = Object(); blnShowF.value=1; $js function jsResetDiscount() { if( $('input[name=chkFamilyDiscount]:checkbox:checked').length > 0) { $('input[name=chkFamilyDiscount]').removeAttr('checked'); } $('#intQuantity').val(1); } function jsReTotal() { /*ini*/ var packageID = $('input[name=radPackage]:checked').attr('id'); var packageID = packageID.slice(11, -1); $('#PackageID').val(packageID); var blnPackageOptionFamilyDiscount = $('#blnFamilyDiscount_'+packageID+'').val(); var intPackagePrice = $('#intPriceInc_'+packageID+'').val(); var intFamilyDiscountTotal = 0.0; var totalAmount = 0.0; if(intPackagePrice == 'n/a') { intPackagePrice = 0; } /*Processing*/ if( $('input[name=chkFamilyDiscount]:checkbox:checked').length > 0) { if(blnPackageOptionFamilyDiscount == 1) { var packageID = $('input[name=chkFamilyDiscount]').attr('id'); var packageID = packageID.slice(18, -1); var intDiscountPrice = $('#strPackagePriceInc_'+packageID).val(); if($('#intQuantity').val() > 0) { intFamilyDiscountTotal = parseInt($('#intQuantity').val()) * parseFloat(intDiscountPrice); } } } else { $('#intQuantity').val(1); } totalAmount = parseFloat(intPackagePrice) + parseFloat(intFamilyDiscountTotal); vatAmount = totalAmount * 0.14; /*display*/ $('#dblDtAmount').val(totalAmount); } ". getJSRemoveAlpha()); $page->Content .="

Subscribe & Become a Member

Packages

For more a more detailed description of each package, see the Packages page.

$tblPackages $BR

Check Out
Package Name:
Monthly Debit-Order Amount:	R

$BR

Member Details

Name and Surname: $required
South African ID Number: $required (or Passport)
Email Address: $required
Home Phone Number:
Cell Phone Number: $required
Work Phone Number:
Home Address: $required
Postal Address: (if not the same as above)
Postal Code: $required
Province: $required
How did you hear about us:

Vehicle Details

Make & Model: $required
Registration Number: $required
Colour: $required

Banking Details

Bank Name: $required
Branch Code: $required
Account Type: $required
Account Holders Name: $required
Account Number: $required

Security

Please answer the simple security question below:
What is $strQuestion ? $required
	I have read and accept the Terms & Conditions.

$BR

". js(" $('input[id=reloadCaptcha]').click(function() { var d = new Date(); $('img[id*=captchaImage]').attr('src' , \"modules/captcha.mod.incl.php?Captcha=render&date=\"+d.getTime()+\"\"); validateCaptcha(); return false; }); grecaptcha.ready(function() { grecaptcha.execute('6LezXNkZAAAAAPEjFN098uSM9x1Wq4CoDTxNxbSL', {action: 'submit'}).then(function(token) { // Add your logic to submit to your backend server here. console.log(token); document.getElementById('g-recaptcha-response').value=token; }); }); function jsValidate() { var msg = ''; if(!$('input[name=\"radPackage\"]:checked').val()) { msg += 'Select a Package\\n'; } /* Member Details */ if( $('#strName').val() == '' ) { msg += 'Name and Surname\\n'; } if( $('#strID').val() == '' ) { msg += 'ID Number\\n'; } var emailRegEx = /^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$/i; if( document.form.strEmail.value.search(emailRegEx) == -1) { msg += 'Email Address not in correct format\\n'; } if( $('#strCell').val() == '' ) { msg += 'Cell Phone Number\\n'; } if( $('#txtAddressHome').val() == '' ) { msg += 'Home Address\\n'; } if( $('#strPostalCode').val() == '' ) { msg += 'Postal Code\\n'; } if( $('#refAreaID').val() == '0') { msg += 'Province \\n'; } /* Vehical Details */ if( $('#strVehicle').val() == '' ) { msg += 'Make & Model\\n'; } if( $('#strRegistration').val() == '' ) { msg += 'Registration Number\\n'; } if( $('#strColour').val() == '' ) { msg += 'Colour\\n'; } /* Banking Details */ if( $('#strBankName').val() == '' ) { msg += 'Bank Name\\n'; } if( $('#strBranchCode').val() == '' ) { msg += 'Branch Code\\n'; } if( $('#strAccountType').val() == '' ) { msg += 'Account Type\\n'; } if( $('#strAccountHoldersName').val() == '' ) { msg += 'Account Holders Name\\n'; } if( $('#strAccountNumber').val() == '' ) { msg += 'Account Number\\n'; } /* misc */ /* if($('#strSecurityCode').val().toLowerCase() != captcha.toLowerCase()) { msg += '- Security Code does not match\\n'; } */ /* Security */ if($('#strSecurityCode').val() == '') { msg += '- Security Code\\n'; } if($('#strSecurityCode').val() != '') { if($('#strSecurityCode').val()*117 != $('#intAnswer').val()) { msg += '- Your security code does not match what you typed in\\n'; } } /* Terms and Conditions */ if(document.getElementById('chkTC').checked == false) { msg += 'Terms and Conditions\\n'; } if(msg != '') { alert('Please select the following:\\n\\n'+msg); return false; } else { var Action = document.createElement('input'); Action.setAttribute('type','hidden') Action.setAttribute('value','Submit') Action.setAttribute('name','Action') try{ document.form.appendChild(Action); }catch(e){alert(e);} document.form.submit(); return true; } } $pickmeautoload ") ; $page->Display(); ?>