function RegisterUser($username, $password, $name, $parentEmail, $avatarSetup, $avatarImage)
{
include_once '../config/Config.php';
$conn = new DatabaseConnect();
$mysqli = $conn->connect($db_host, $db_username, $db_password, $mysql_db);
//check valid email address if entered
if (!filter_var($parentEmail, FILTER_VALIDATE_EMAIL) && $parentEmail != null) {
echo "Please try your parent's email address again";
die;
}
$md5_password = md5($password);
$hash = md5(rand(1, 10000));
$add = new Child_Functions();
//Function which either adds or creates new family entry
$add->childFamilyAdd($parentEmail, $username);
//NEED TO INSERT ID NOT USERNAME
$queryEmReg = "SELECT '" . $username . "' FROM Child_Account WHERE email ='" . $email . "'";
$emailCheck = $mysqli->query($queryEmReg);
if (!mysqli_num_rows($emailCheck) < 1) {
echo 'Username already in use';
echo $queryEmReg;
} else {
$sql = "INSERT INTO Child_Account (Username,Password,Name,ParentsEmail,hash)\n\t\t\t\t\tVALUES (?,?,?,?,?)";
//avatarSetup,avatarImage,
$mail = new Child_Functions();
//prepared query statements
if ($stmt = $mysqli->prepare($sql)) {
$stmt->bind_param("sssss", $username, $md5_password, $name, $parentEmail, $hash);
$stmt->execute();
$stmt->bind_result($result);
if ($stmt->affected_rows > 0) {
echo 'Email sent';
$mail->VerificationParent($parentEmail, $name, $hash);
} else {
echo 'Error - could not register';
}
$stmt->close();
} else {
echo 'Failed register child database query';
echo $stmt->errno;
}
}
$connect->close();
}
}
$deleteCompleted = "DELETE FROM Child_Tasks \n\t\t\t\tWHERE completed = 1 AND expiry = '" . $expired . "'";
$deleteFailed = "DELETE FROM Child_Tasks\n\t\t\t\tWHERE completed = 0 AND expiry = '" . $expired . "'";
//have to insert into table which and then delete
$query = "SELECT id FROM Child_Tasks WHERE Confirmed = 1";
$updateQuery = "DELETE FROM Child_Tasks WHERE Confirmed = 1";
if ($upd = $mysqli->prepare($updateQuery)) {
$upd->bind_param('s', $taskID);
$upd->execute();
$upd->bind_result($login);
$upd->fetch();
echo '';
} else {
echo 'Could not delete task';
}
$mysqli->close();
}
}
$obj = new Child_Functions();
//$obj->GetCharms('alex')
//$obj->GetKash('alex')
//$obj->GetStarz('alex')
//$obj->SpendCharms('alex',1,'lost')
//$obj->SpendStarz('alex',1,'lost')
//$obj->AddRemoveKash('alex',-1,'lost')
//$obj->AddNewTask("Alex", '2', '12','*****@*****.**');
//$obj->EditTask(24, 12);
//$obj->CompleteTask(26);
//$obj->DeleteTask(24);
//$obj->EditChildTimeLimits('Ronny123','hi there');
$obj->taskServer();
