public function checkChallenge($username)
{
$challengeInProgress = false;
$challengeDAO = new ChallengeDAO();
$challenge = $challengeDAO->getByUsername($username);
if (!is_null($challenge->getChallengeId())) {
$challengeInProgress = TRUE;
}
return $challengeInProgress;
}
public function getPointsByChallengeId($challengeId)
{
$sql = "SELECT pointID, challangeID, date, weight FROM weighpoints WHERE challangeID = :challengeId";
// $sql = "select pointID, challangeID, date, weight from weighpoints";
$dbh = new PDO(DBConfig::$DB_CONNSTRING, DBConfig::$DB_USERNAME, DBConfig::$DB_PASSWORD);
$stmt = $dbh->prepare($sql);
$stmt->execute(array(':challengeId' => $challengeId));
$resultList = $stmt->fetchAll(PDO::FETCH_ASSOC);
// $resultSet = $dbh->query($sql);
var_dump($resultList);
$lijst = array();
foreach ($resultList as $rij) {
$challengeDAO = new ChallengeDAO();
$challenge = $challengeDAO->getById($rij["challangeID"]);
$weighpoint = Weighpoint::create($rij["pointID"], $challenge, $rij["weight"], $rij["date"]);
var_dump($weighpoint);
array_push($lijst, $weighpoint);
}
$dbh = null;
return $lijst;
}
var_dump($fox);
// $userSvc = new UserService();
// $service = $userSvc->checkLogin("foxbarrelinc", "adminpwd");
// var_dump($service);
$par1 = $_SERVER['REMOTE_ADDR'];
var_dump($par1);
$par2 = gethostbyaddr($par1);
var_dump($par2);
var_dump(redirect_arrayName());
var_dump(redirect_par());
$_SESSION[redirect_arrayName()] = redirect_par();
var_dump($_SESSION[redirect_arrayName()]);
var_dump($_SERVER['HTTP_USER_AGENT']);
$hashValue = passwordEncrypt("fifafo", "schildp@d");
var_dump($hashValue);
$color = randomColor();
echo "<span style='color:" . $color . "'>" . $color . "</span>";
$cDAO = new ChallengeDAO();
$temp_var = $cDAO->getByUsername("foxbarrelinc");
var_dump($temp_var);
$challengeSvc = new ChallengeService();
$service = $challengeSvc->getChallegeby("foxbarrelinc");
var_dump($service);
$bool_temp = $challengeSvc->checkChallenge($service->getUser()->getUsername());
var_dump($bool_temp);
$wDAO = new WeighpointDAO();
$points = $wDAO->getPointsByChallengeId($service->getChallengeId());
?>
</body>
</html>
<?php
$challengeDAO = new ChallengeDAO();
$app->get('/challenges/?', authorize(), function () use($challengeDAO) {
header("Content-Type: application/json");
echo json_encode($challengeDAO->selectAll(), JSON_NUMERIC_CHECK);
exit;
});
$app->get('/challenges/:id/?', authorize(), function ($id) use($challengeDAO) {
header("Content-Type: application/json");
echo json_encode($challengeDAO->selectById($id), JSON_NUMERIC_CHECK);
exit;
});
$app->post('/challenges/?', authorize(), function () use($app, $challengeDAO) {
header("Content-Type: application/json");
$post = $app->request->post();
if (empty($post)) {
$post = (array) json_decode($app->request()->getBody());
}
echo json_encode($challengeDAO->insert($post), JSON_NUMERIC_CHECK);
exit;
});
$app->delete('/challenges/:id/?', authorize(), function () use($challengeDAO) {
header("Content-Type: application/json");
echo json_encode($challengeDAO->delete());
exit;
});
$app->put('/challenges/:id/?', authorize(), function () use($app, $challengeDAO) {
header("Content-Type: application/json");
$post = $app->request->post();
if (empty($post)) {
