function validateRegistration($conn, $registration_form)
{
if (isNullOrEmpty($registration_form['gamertag']) || !checkGamertagAvailability($conn, $registration_form['gamertag']) || isNullOrEmpty($registration_form['first_name']) || isNullOrEmpty($registration_form['last_name']) || isNullOrEmpty($registration_form['last_name']) || isNullOrEmpty($registration_form['email']) || !filter_var($registration_form['email'], FILTER_VALIDATE_EMAIL) || !checkEmailAvailability($conn, $registration_form['email']) || isNullOrEmpty($registration_form['city']) || isNullOrEmpty($registration_form['state']) || isNullOrEmpty($registration_form['skill']) || !is_numeric($registration_form['skill']) || !is_numeric($registration_form['melee_setups']) || !is_numeric($registration_form['projectm_setups']) || !is_numeric($registration_form['tvs'])) {
return false;
}
return true;
}
function validateRegistration($conn, $registration_form)
{
if (isNullOrEmpty($registration_form['gamertag']) || strlen($registration_form['gamertag']) > 25 || !checkGamertagAvailability($conn, $registration_form['gamertag']) || isNullOrEmpty($registration_form['first_name']) || isNullOrEmpty($registration_form['last_name']) || isNullOrEmpty($registration_form['email']) || $registration_form['email'] != $registration_form['email_conf'] || isNullOrEmpty($registration_form['password']) || $registration_form['password'] != $registration_form['password_conf'] || !filter_var($registration_form['email'], FILTER_VALIDATE_EMAIL) || !checkEmailAvailability($conn, $registration_form['email']) || isNullOrEmpty($registration_form['city']) || isNullOrEmpty($registration_form['state'])) {
return false;
}
if (!is_null($registration_form['pm_doubles'])) {
if (!filter_var($registration_form['pm_teammate'], FILTER_VALIDATE_EMAIL)) {
return false;
}
}
if (!is_null($registration_form['melee_doubles'])) {
if (!filter_var($registration_form['melee_teammate'], FILTER_VALIDATE_EMAIL)) {
return false;
}
}
return true;
}
function dispatcher($type)
{
switch ($type) {
case 'LoginAttempt':
loginAttempt();
break;
case 'GetInitialCart':
getInitialCart();
break;
case 'AddItemToCart':
addItemToCart();
break;
case 'RemoveItemFromCart':
removeItemFromCart();
break;
case 'EmptyCart':
emptyCart();
break;
case 'RefreshCatalog':
refreshCatalog();
break;
case 'GetGuidedSellingValues':
getGuidedSellingValues();
break;
case 'ReadCatalog':
readCatalog();
break;
case 'GetSubscriptions':
getSubscriptions();
break;
case 'SetAmendSubId':
setAmendSubId();
break;
case 'GetAmendSubscription':
getAmendSubscription();
break;
case 'PreviewAddRatePlan':
previewAddRatePlan();
break;
case 'AddRatePlan':
addRatePlan();
break;
case 'PreviewRemoveRatePlan':
previewRemoveRatePlan();
break;
case 'RemoveRatePlan':
removeRatePlan();
break;
case 'PreviewUpdateRatePlan':
previewUpdateRatePlan();
break;
case 'UpdateRatePlan':
updateRatePlan();
break;
case 'GetUpgradeDowngradePlans':
getUpgradeDowngradePlans();
break;
case 'PreviewPlanUpgradeDowngrade':
previewPlanUpgradeDowngrade();
break;
case 'PlanUpgradeDowngrade':
planUpgradeDowngrade();
break;
case 'PreviewRenewSubscription':
previewRenewSubscription();
break;
case 'RenewSubscription':
renewSubscription();
break;
case 'CancelSubscription':
cancelSubscription();
break;
case 'GetAccountSummary':
getAccountSummary();
break;
case 'GetContactSummary':
getContactSummary();
break;
case 'GetPaymentMethodSummary':
getPaymentMethodSummary();
break;
case 'GetInvoiceSummary':
getInvoiceSummary();
break;
case 'GetBillingPreview':
getBillingPreview();
break;
case 'GetUsageSummary':
getUsageSummary();
break;
case 'GetCompleteSummary':
getCompleteSummary();
break;
case 'UpdateContact':
updateContact();
break;
case 'CheckEmailAvailability':
checkEmailAvailability();
break;
case 'UpdatePaymentMethod':
updatePaymentMethod();
break;
case 'RemovePaymentMethod':
removePaymentMethod();
break;
case 'GetNewIframeSrc':
getNewIframeSrc();
break;
case 'GetExistingIframeSrc':
getExistingIframeSrc();
break;
case 'SubscribeWithCurrentCart':
subscribeWithCurrentCart();
break;
case 'PreviewCurrentCart':
previewCurrentCart();
break;
case 'IsUserLoggedIn':
isUserLoggedIn();
break;
// begin new code for Partner - Ming
// begin new code for Partner - Ming
case 'GetHierarchy':
getHierarchy();
break;
case 'GoToAccountView':
goToAccountView();
break;
case 'GetAccountInfo':
getAccountInfo();
break;
case 'GetSubConfirmInfo':
getSubConfirmInfo();
break;
case 'IsPartnerLoggedIn':
isPartnerLoggedIn();
break;
// end new code for Partner - Ming
// HPM 2.0 begin
// end new code for Partner - Ming
// HPM 2.0 begin
case 'SubscribeHPM2':
subscribeHPM2();
break;
// HPM 2.0 end
// Start Promo
// HPM 2.0 end
// Start Promo
case 'PromoValidate':
promoValidate();
break;
// End Promo
// Start Set Account Data
// End Promo
// Start Set Account Data
case 'SetAccountInfo':
setAccountInfo();
break;
// End Set Account Data
// Start Get Address Data
// End Set Account Data
// Start Get Address Data
case 'GetAddressInfo':
getAddressInfo();
break;
// End Set Account Data
// Start Get Formatting Data
// End Set Account Data
// Start Get Formatting Data
case 'GetFormatting':
getFormatting();
break;
// End Set Formatting Data
// End Set Formatting Data
default:
addErrors(null, 'no action specified');
}
}
<?php
require 'db_connect.php';
// creates mysqli in $conn
function checkEmailAvailability($conn, $email)
{
if (is_null($email)) {
return false;
}
$query = "SELECT id FROM registrants WHERE email=?";
$stmt = $conn->prepare($query);
$stmt->bind_param("s", $email);
if ($stmt->execute()) {
if ($stmt->store_result()) {
if ($stmt->num_rows == 0) {
return true;
}
}
}
return false;
}
if (isset($_GET['jscheck'])) {
$email = $_POST['email'];
if (checkEmailAvailability($conn, $email)) {
echo "1";
} else {
echo "0";
}
}
<?php
$dbhost = 'west87432.db.7866128.hostedresource.com';
$dbname = 'west87432';
$dbuser = '******';
$dbpass = '******';
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
function checkEmailAvailability()
{
$response['status'] = false;
if (!isset($_GET['email']) || !filter_var($_GET['email'], FILTER_VALIDATE_EMAIL)) {
die(json_encode($response));
}
$query = 'SELECT `id` FROM `users` WHERE `email` = "' . mysql_real_escape_string($_GET['email']) . '"';
$result = mysql_query($query);
if (mysql_num_rows($result) < 1) {
$response['status'] = true;
}
die(json_encode($response));
}
function signUp()
{
}
if (isset($_GET['action']) && $_GET['action'] == 'checkEmailAvailability') {
checkEmailAvailability();
}
