<?php

	if (isset($_POST['first']) && isset($_POST['last']) && isset($_POST['state']) && isset($_POST['interest']) && isset($_POST['bank']) && isset($_POST['acc_num']) && isset($_POST['acc_name']) && isset($_POST['phone']) && isset($_POST['email']) && isset($_POST['username']) && isset($_FILES['pic']['name'])) {
		$first = $mysqli->real_escape_string(ucwords($_POST['first']));
		$last = $mysqli->real_escape_string(ucwords($_POST['last']));
		$country = $mysqli->real_escape_string(ucwords("Nigeria"));
		$state = $mysqli->real_escape_string(ucwords($_POST['state']));
		$interest = $mysqli->real_escape_string(ucwords($_POST['interest']));
		$bank = $mysqli->real_escape_string(ucwords($_POST['bank']));
		$acc_num = $mysqli->real_escape_string($_POST['acc_num']);
		$acc_name = $mysqli->real_escape_string(ucwords($_POST['acc_name']));
		$phone = $mysqli->real_escape_string($_POST['phone']);
		$email = $mysqli->real_escape_string($_POST['email']);
		$username = $mysqli->real_escape_string($_POST['username']);
		$filename = $_FILES['pic']['name'];
		$tmp_name = $_FILES['pic']['tmp_name'];
		$new_file = md5($acc_num.$acc_name);

		$pass = "";

		function name(){
			$chars = "1234567890abcdefghijklmnopqrstuvwxyzABCDEGHIJKLMNOPQRSTUVWXYZ";
			global $pass, $mysqli;
			for ($i=0; $i < 5; $i++) {
				$pass .= $chars[rand(0, strlen($chars) - 1)];
			}
			$query = "SELECT * FROM mfh_acc_tb WHERE mfh_acc_pass = '$pass'";
			if ($check = $mysqli->query($query)) {
				if ($check->num_rows > 0) {
					name();
				}
			}
		}
		name();
		$pass;
		// check if username exsts
		$query = "SELECT * FROM mfh_acc_tb WHERE (mfh_acc_username = '$username' OR mfh_acc_email = '$email' OR mfh_acc_num = '$acc_num')";
		if ($check = $mysqli->query($query)) {
			if ($check->num_rows > 0) { ?>
				<div class="alert alert-danger">
					Username, Email or Account Number Already Registered
				</div>
			<?php }else {
				$query = "SELECT * FROM mfh_obsolete_tb WHERE (mfh_username = '$username' OR mfh_email = '$email' OR mfh_acc_num = '$acc_num')";
				if ($check = $mysqli->query($query)) {
					if ($check->num_rows > 0) { ?>
						<div class="alert alert-danger">
							Username, Email or Account Number Already Registered
						</div>
					<?php }else {
						$query = "SELECT * FROM mfh_sub_tb WHERE (mfh_sub_username = '$username')";
						if ($check = $mysqli->query($query)) {
							if ($check->num_rows > 0) { ?>
								<div class="alert alert-danger">
									Username Already Registered
								</div>
							<?php }else {
								if (move_uploaded_file($tmp_name, "assets/img/dp/".$new_file)){
									$query = "INSERT INTO mfh_acc_tb VALUES(null, '$first', '$last', '$country', '$state', '$interest', '$bank', '$acc_num', '$acc_name', '$phone', '$email', '$username', '$pass', '$new_file', 'one', 'donor', 0, 0, 5, NOW())";
									if ($create = $mysqli->query($query)) {
										$query = "INSERT INTO mfh_notif_tb VALUES(null, 'admin', '$username', 'reg', 'unread', 'unread', 'unead', NOW())";
										if ($insert = $mysqli->query($query)) {
											$message = "Your Unique ID For My Future Hope Is ".$pass;
											$headers = "From: contactmyfuturehope@yahoo.com" . "\r\n";
											// $query = "INSERT INTO mfh_notif_tb VALUES(null, '$pass', '$username', 'id', 'unread', 'unread', 'unead', NOW())";
											// if ($insert = $mysqli->query($query)) {
											$mail_to_send_to = $email;
											$your_feedbackmail = "contactmyfuturehope@yahoo.com";
							                $headers = "From: $your_feedbackmail" . "\r\n" . "Reply-To: $your_feedbackmail" . "\r\n" ;
							                $a = mail( $mail_to_send_to, "Your Unique ID - My Future Hope", $message, $headers );
											if ($a) {
												if (!isset($_SESSION)) {
													session_start();
												}
													$_SESSION['mfh_first'] = $first;
													$_SESSION['mfh_last'] = $last;
													$_SESSION['mfh_country'] = $country;
													$_SESSION['mfh_state'] = $state;
													$_SESSION['mfh_interest'] = $interest;
													$_SESSION['mfh_bank'] = $bank;
													$_SESSION['mfh_acc_num'] = $acc_num;
													$_SESSION['mfh_acc_name'] = $acc_name;
													$_SESSION['mfh_phone'] = $phone;
													$_SESSION['mfh_email'] = $email;
													$_SESSION['mfh_username'] = $username;
													$_SESSION['mfh_pass'] = $pass;
													$_SESSION['mfh_pass'] = $pass;
													$_SESSION['mfh_pic'] = $new_file;
													$_SESSION['mfh_level'] = "one";
													$_SESSION['mfh_status'] = "donor";
													$_SESSION['mfh_paired'] = 0;
													$_SESSION['mfh_done'] = 0;
													$_SESSION['mfh_limit'] = 5;
													$_SESSION['new'] = true;

													if (isset($_GET['ref'])) {
									                    $id = $_GET['ref'];
									                    if (!isset($mysqli)) {
									                        require 'assets/php/conn.php';
									                    }
									                    $query = "SELECT * FROM mfh_acc_tb WHERE mfh_acc_username = '$id'";
									                    if ($get = $mysqli->query($query)) {
									                        if ($get->num_rows > 0) {
									                            $query = "INSERT INTO mfh_ref_tb VALUES(null, '$id', '$username', NOW())";
									                            if ($insert = $mysqli->query($query)) {
									                            	$query = "INSERT INTO mfh_notif_tb VALUES(null, '$username', '$id', 'refer', 'unread', 'unread', 'unead', NOW())";
									                            	if($insert = $mysqli->$query($query)){

									                            	}
									                            }else {
									                            	echo $mysqli->error;
									                            }
									                        }else { ?>
									                            <div class="alert alert-danger">
									                                Fake Referral Link
									                            </div>
									                        <?php }
									                    }else {
									                        echo $mysqli->error;
									                    }
									                }

													if(@header("location: assets/php/pair.php")){

													}else { ?>
														<script type="text/javascript">
															location.assign("assets/php/pair.php");
														</script>
													<?php }
											}else {
												print("Message wasn't sent, please check that you have changed emails in the bottom");
											}
										}else {
											echo $mysqli->error;
										}
									}else {
										echo $mysqli->error;
									}

								}else { ?>
									<div class="alert alert-danger">
										Please Check Your File And Try Again
									</div>
								<?php }
							}
						}else {
							echo $mysqli->error;
						}
					}
				}else {
					echo $mysqli->error;
				}
			}
		}




	}else {

	}

 ?>