|
|
![](\"$locquit1/IMLD/images/$builda\") |
$state1 |
";
}
if ($az2==2){
$checka2="checked";//deacon
$checkstatement="
|
|
|
$state2 |
";
}
if ($az2==3){
$checka3="checked" ;//ministry leader
$checkstatement="
|
|
|
$state3 |
";
}
if ($az2==4){
$checka4="checked" ;//parioners
$checkstatement="
|
|
|
$state4 |
";
}
$testy1=94;
$sql33 ="SELECT * FROM $table_name92 WHERE information_id = '$testy1' ";
$result33 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
$row22 =mysqli_fetch_array($result33,MYSQLI_ASSOC);
$display_blocka= $row22['description'];
$display_blocka=stripslashes($display_blocka);
$welcome=htmlspecialchars_decode($display_blocka);
$testy1=188;
$sql33 ="SELECT * FROM $table_name92 WHERE information_id = '$testy1' ";
$result33 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
$row22 =mysqli_fetch_array($result33,MYSQLI_ASSOC);
$display_blocka= $row22['description'];
$display_blocka=stripslashes($display_blocka);
$welcome12=htmlspecialchars_decode($display_blocka);
$welcome12=strip_tags($welcome12);
$testy1=190;
$sql33 ="SELECT * FROM $table_name92 WHERE information_id = '$testy1' ";
$result33 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
$row22 =mysqli_fetch_array($result33,MYSQLI_ASSOC);
$display_blocka= $row22['description'];
$display_blocka=stripslashes($display_blocka);
$welcome12a=htmlspecialchars_decode($display_blocka);
$testy1=189;
$sql33 ="SELECT * FROM $table_name92 WHERE information_id = '$testy1' ";
$result33 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
$row22 =mysqli_fetch_array($result33,MYSQLI_ASSOC);
$display_blocka= $row22['description'];
$display_blocka=stripslashes($display_blocka);
$welcome13=htmlspecialchars_decode($display_blocka);
$testy1=191;
$sql33 ="SELECT * FROM $table_name92 WHERE information_id = '$testy1' ";
$result33 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
$row22 =mysqli_fetch_array($result33,MYSQLI_ASSOC);
$display_blocka= $row22['description'];
$display_blocka=stripslashes($display_blocka);
$problem13=htmlspecialchars_decode($display_blocka);
$logscript="
|
| |
|
|
$problem13";
//class=required to make it red.
$display_title= "Create An Account";
$display_title11= "Create An Account";
if ($jedID2==0){
$display_block="
$welcome
";
///
}
if ($jedID2==5){
$blink='';
$firstname=addslashes($_POST['first']);
$lastname=addslashes($_POST['last']);
$phone=addslashes($_POST['cell']);
$phone = preg_replace("/[^0-9.]/", '', $phone);
$email=addslashes($_POST['email']);
$code98=addslashes($_POST['code98']);
if ($code98==$test98){
$Wemail1=$email;
$choice1=$_POST['choice1'];
$newsletter=$_POST['newsletter'];
$assigned_store[14]= 19;
$assigned_store[15]= 19 ;//20
$assigned_store[28]= 19;//21
$assigned_store[29]= 19;//22
$customer_group_id=$choice1;
$status=1;
if ( isset($_SERVER['HTTP_CLIENT_IP']) && ! empty($_SERVER['HTTP_CLIENT_IP'])) {
$ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif ( isset($_SERVER['HTTP_X_FORWARDED_FOR']) && ! empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
$ip = (isset($_SERVER['REMOTE_ADDR'])) ? $_SERVER['REMOTE_ADDR'] : '0.0.0.0';
}
$ip = filter_var($ip, FILTER_VALIDATE_IP);
$ip = ($ip === false) ? '0.0.0.0' : $ip;
if ( $firstname !=$blink AND $lastname !=$blink AND $email !=$blink AND $phone !=$blink){
$Pass=md5($phone);
$sq112abT="SELECT * FROM $table_name36 Where email='$email'";
$result33btT = @mysqli_query($connection,$sq112abT) or die(mysqli_error($connection));
$num335 = mysqli_num_rows($result33btT);
if ($num335<1){
$sql2 = "INSERT INTO $table_name36 (store_id, firstname, lastname, email, telephone, fax, password ,newsletter,customer_group_id, ip,status,approved,date_added, salesrep_id )
VALUES ('$assigned_store[$choice1]','$firstname', '$lastname','$email','$phone', '$fax', '$Pass','$newsletter','$customer_group_id','$ip', '$status', '1', '$Rtoday','$salesrep_id' )";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
// $sq112abT="SELECT * FROM $table_name36 Where customer_group_id='$customer_group_id' AND email='$email' AND date_added='$Rtoday'";
// echo " $sq112abT
";
// $result112abT = @mysqli_query($connection,$sq112abT) or die(mysqli_error($connection));
//while ($row112abT = mysqli_fetch_array($result112abT)) {
// $idA= $row112abT['customer_id'];
$rest = substr($locquit1, 8); // returns "cde"
$rest2 = substr($locquit1, 12); // returns "cde"
$msg .= "E-MAIL SENT From: admin@$rest2 \r\n";
$msg .= "Full Name: $firstname $lastname \r\n";
$msg .= "\r\n";
$msg .= "$welcome12 \r\n";
$msg .= "\r\n";
$msg .= "\r\n";
$msg .= "Username: $email \r\n";
$msg .= "\r\n";
$msg .= "Password: $phone \r\n";
$to2 ="glink@galliumgroup.com";
$to2 = "admin@$rest2";
$subject = "Your Account Has Been Created";
$mailheaders = "From: Bronner Network \n";
$mailheaders .= "Reply-To: $to2\n";
mail($Wemail1, $subject, $msg, $mailheaders);
$logscript="
|
| |
|
|
$problem13";
$display_block="$welcome12a
$logscript";
}else{
$display_block ="$welcome13
$logscript
";
// $sql2 = "UPDATE $table_name36 SET store_id='$assigned_store', firstname='$firstname', lastname='$lastname', telephone='$phone', fax='$fax', password='$Pass' , newsletter='$newsletter', ip='$ip', status='$status',approved='approved',date_added='$Rtoday', salesrep_id='$salesrep_id' Where customer_group_id='$customer_group_id' AND email='$email' ";
//$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
} }
}else{ //from the big catch check the numbers
$display_block ="
The code you entered is incorrect. Please use the GO BACK button at the top and try again.
$logscript
";
}
}
?>
<? echo "$display_title"; ?> <? echo "$survey_num"; ?> jedID2=<? echo "$jedID2"; ?>id2=<? echo "$id2"; ?>map_id1=<? echo "$map_id1-$num3334[22]"; ?>
![](\"$locquit1/IMLD/images/CAP_Logo.jpg\"){kind=logo}
