"; echo "Last Name: $lastname
"; echo "Gender: $gender
"; echo "Email: $email
"; echo "Username: $username
"; echo "Password: $password
"; echo "Referral: $referral
"; echo "referral_other: $referral
"; echo "Address: $address1 $address2 $address3
"; echo "City: $city
"; echo "State: $state
"; echo "Postcode: $postcode
"; echo "Country: $country
"; echo "Home No.: $home_no
"; echo "Home Fax: $home_fax
"; echo "Subsctipion Details: $sub_details
"; echo "Payment Type: $payment_type
"; echo "Card Number: $card_num
"; echo "Expiry Date: $exp_date
"; echo "Card Holder: $holder_name
"; echo "Auto Renew?: $auto_renew
"; **/ if($firstname != NULL && $firstname != "") { $fnameOk = TRUE; } if($lastname != NULL && $lastname != "") { $lnameOk = TRUE; } if($dobd != NULL && $dobd !="" && dobm != NULL && dobm !="" && $doby != NULL && $doby !="") { if(validate_date($dobd,$dobm,$doby)) $dobOk = TRUE; } if(check_email_address($email)) { $emailOk = TRUE; } if($username != NULL && $username != "") { if($_POST['status'] != "" && $_POST['status'] != NULL) { $username = TRUE; } else { include('/home/sgx/options/sgx/dbconna.ltc'); $sql = "SELECT username FROM subscriptions WHERE username='$username'"; $rs = mysql_query($sql); dbcon_checker(); if(mysql_num_rows($rs) > 0) $usernameOk = FALSE; else $usernameOk = TRUE; mysql_close(); } } if($password != NULL && $password1 !=NULL && $password != "" && $password1 != "" && strlen($password) >= 6) { if($password == $password1) { $passwordOk = TRUE; } } if($referral != NULL && $referral != "" && $referral != "na") { $referralOk = TRUE; } if($sub != NULL && $sub != "") { $subOk = TRUE; } if($address1 != NULL && $address1 != "") { $addressOk = TRUE; } if($city != NULL && $city != "") { $cityOk = TRUE; } if($state != NULL && $state != "") { $stateOk = TRUE; } if($postcode != NULL && $postcode != "") { $postcodeOk = TRUE; } if($home_no != NULL && $home_no != "") { $telephoneOk = TRUE; } if($fnameOk && $lnameOk && $dobOk && $emailOk && $usernameOk && $passwordOk && $referralOk && $subOk && $addressOk && $cityOk && $stateOk && $postcodeOk && $telephoneOk) { include('/home/sgx/options/sgx/dbconnalvin.ltc'); dbcon_checker(); $reg_date = gmdate("Y-m-d", time() + (28800)); $address = trim("$address1" . " $address2" . " $address3"); if($gender == "male") $gender = 'M'; elseif($gender == "female") $gender = 'F'; $dob = $doby . '-' . $dobm . '-' . $dobd; $expiry_date = "0000-00-00"; $sql = "INSERT INTO subscriptions VALUES(NULL,'$username','$password','$firstname','$lastname','$gender','$dob','$email','$address','$city','$state','$postcode','$country','$mob_no','$home_no','$home_fax','$reg_date','$expiry_date','$referral','NULL','NORMAL','NULL','Y')"; // $sql = sprintf(" INSERT INTO subscriptions // VALUES(NULL,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','NULL','NORMAL','NULL','Y')", // ($username), // ($password), // ($firstname), // ($lastname), // ($gender), // ($dob), // ($email), // ($address), // ($city), // ($state), // ($postcode), // ($country), // ($mob_no), // ($home_no), // ($home_fax), // ($reg_date), // ($expiry_date), // ($referral) // ); echo $sql;die(); mysql_query($sql); include('/home/finpres/options/klse/dbconnalvin.ltc'); mysql_close(); $redirect = ""; echo $redirect; echo ""; } $errorMsg = ""; $errorMsg = $errorMsg . "
"; $errorMsg = $errorMsg . "" . "
Registration Failed!
"; $errorMsg = $errorMsg . "
"; $errorMsg = $errorMsg . ""; //$errorMsg = $errorMsg . ""; $errorMsg = $errorMsg . " "; $errorMsg = $errorMsg . "
 
"; if(!$fnameOk) $errorMsg = $errorMsg . "First Name Missing.
"; if(!$lnameOk) $errorMsg = $errorMsg . "Last Name Missing.
"; if(!$dobOk) $errorMsg = $errorMsg . "DOB Missing or Not A Valid Date.
"; if(!$emailOk) $errorMsg = $errorMsg . "Email Missing or Not A Valid Email Address.
"; if(!$usernameOk) $errorMsg = $errorMsg . "Username Missing or Username Already Taken.
"; if(!$passwordOk) $errorMsg = $errorMsg . "Password Missing or Password Not Matched.
"; if(!$referralOk) $errorMsg = $errorMsg . "No Referral Selected.
"; if(!$subOk) $errorMsg = $errorMsg . "Please Select Your Subscription Details.
"; if(!$addressOk) $errorMsg = $errorMsg . "Address Missing.
"; if(!$cityOk) $errorMsg = $errorMsg . "City Name Missing.
"; if(!$stateOk) $errorMsg = $errorMsg . "State Name Missing.
"; if(!$postcodeOk) $errorMsg = $errorMsg . "Postal Code Missing.
"; if(!$telephoneOk) $errorMsg = $errorMsg . "Home Telephone Number Missing.
"; $errorMsg = $errorMsg . "
 
 
"; } function genderSelector($value) { if(isset($_POST['gender']) && isset($_POST['Submit3'])) { if($_POST['gender'] == $value) { echo "SELECTED"; } } } function referralSelector($value) { if(isset($_POST['referral']) && isset($_POST['Submit3'])) { if($_POST['referral'] == $value) { echo "SELECTED"; } } } function subSelector($value) { if(isset($_POST['sub']) && isset($_POST['Submit3'])) { if($_POST['sub'] == $value) { echo "CHECKED"; } } } function countrySelectror($value) { if(isset($_POST['country']) && isset($_POST['Submit3'])) { if($_POST['country'] == $value) { echo "SELECTED"; } } else if ($value == 'SINGAPORE') echo "SELECTED"; } function check_email_address($email) { // First, we check that there's one @ symbol, and that the lengths are right if (!ereg("^[^@]{1,64}@[^@]{1,255}$", $email)) { // Email invalid because wrong number of characters in one section, or wrong number of @ symbols. return false; } // Split it into sections to make life easier $email_array = explode("@", $email); $local_array = explode(".", $email_array[0]); for ($i = 0; $i < sizeof($local_array); $i++) { if (!ereg("^(([A-Za-z0-9!#$%&'*+/=?^_`{|}~-][A-Za-z0-9!#$%&'*+/=?^_`{|}~\.-]{0,63})|(\"[^(\\|\")]{0,62}\"))$", $local_array[$i])) { return false; } } if (!ereg("^\[?[0-9\.]+\]?$", $email_array[1])) { // Check if domain is IP. If not, it should be valid domain name $domain_array = explode(".", $email_array[1]); if (sizeof($domain_array) < 2) { return false; // Not enough parts to domain } for ($i = 0; $i < sizeof($domain_array); $i++) { if (!ereg("^(([A-Za-z0-9][A-Za-z0-9-]{0,61}[A-Za-z0-9])|([A-Za-z0-9]+))$", $domain_array[$i])) { return false; } } } return true; } function validate_date($day,$month,$year) { if(strlen($day) == 1) $day = '0'. $day; if(strlen($month) == 1) $month = '0' . $month; $strdate = $day . '/' . $month . '/' . $year; if((strlen($strdate)<10)OR(strlen($strdate)>10)){ //echo("Enter the date in 'dd/mm/yyyy' format"); return false; } else{ //The entered value is checked for proper Date format if((substr_count($strdate,"/"))<>2){ //echo("Enter the date in 'dd/mm/yyyy' format"); return false; } else{ $pos=strpos($strdate,"/"); $date=substr($strdate,0,($pos)); $result=ereg("^[0-9]+$",$date,$trashed); if(!($result)){ //echo "Enter a Valid Date"; return false; } else{ if(($date<=0)OR($date>31)){ //echo "Enter a Valid Date"; return false; } } $month=substr($strdate,($pos+1),($pos)); if(($month<=0)OR($month>12)){ //echo "Enter a Valid Month"; return false; } else{ $result=ereg("^[0-9]+$",$month,$trashed); if(!($result)){ //echo "Enter a Valid Month"; return false; } } $year=substr($strdate,($pos+4),strlen($strdate)); $result=ereg("^[0-9]+$",$year,$trashed); if(!($result)){ //echo "Enter a Valid year"; return false; } else{ if(($year<1900)OR($year>2200)){ //echo "Enter a year between 1900-2200"; return false; } } } } return true; } ?>
Registration Form

"; } ?>


Welcome to EquitiesTracker.com.
Please fill in your particulars to enjoy full access of the site.
Personal Details
*First Name:
*Last Name:
*Gender:
*Date of Birth:
/ / dd/mm/yyyy
*Email:
*User Name:

Min. 6 chars long & Case-Sensitive
*Password:

Min. 6 chars long & Case-Sensitive
*Confirm Password:
*Referred By:
 
*Required


  Contact Details
*Address:
*City:
*State:
*Postcode:
*Country:
Mobile No.:
*Telephone No.:
Facsimile No.:

Subscription Details
>12 Months (SGD$360) >6 Months (SGD$188) >3 Months (SGD$99)




The personal information that you enter will allow us to update you on new EquitiesTracker.com services and news, and to inform you of other products/services that may interest you.