$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();
