function delete_action($id) { $connection = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USER, DB_PWD); $action = fetch_action($id); $statement = $connection->prepare("select count(*) from actions where active=1 and achievement_id!=0 and name=?"); $statement->bindValue(1, $action->name, PDO::PARAM_STR); $statement->execute(); if ((int) $statement->fetchColumn() == 1) { $statement = $connection->prepare("update actions set active=0 where achievement_id=0 and name=?"); $statement = $connection->bindValue(1, $action->name, PDO::PARAM_STR); $statement->execute(); } $statement = $connection->prepare("update actions set active=0 where id=?"); $statement->bindValue(1, $id, PDO::PARAM_INT); $statement->execute(); }
function should_it_have_been_worked_on($id) { $action = fetch_action($id); $days_since_last_work = days_since_last_worked($id); if (!$days_since_last_work) { return false; //deal with when it has no previous work history } if ($action->work == 2 && $days_since_last_work > 0) { return true; } else { if ($action->work == 3 && $days_since_last_work > 6) { return true; } else { if ($action->work == 4 && $days_since_last_work > 28) { return true; } } } return false; }
<?php require_once "../php/config.php"; require_once "../php/work.php"; require_once "../php/actions.php"; require_once "../php/achievements.php"; $connection = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USER, DB_PWD); $today = 0; $last_time = 0; if (!has_work_been_checked()) { check_work(); } $statement = $connection->query("select * from work where action_id!=0 and active=1 order by created desc"); $statement->execute(); while ($work = $statement->fetchObject()) { $action = fetch_action($work->action_id); $achievement = fetch_achievement($action->achievement_id); if ($today != date("m/d/y", strtotime($work->created))) { echo "<h2>" . date("m/d/y l", strtotime($work->created)) . "</h2>"; $today = date("m/d/y", strtotime($work->created)); } if ($last_time != date("H:i", strtotime($work->created))) { echo "<div style='margin-top:24px'>" . date("H:i", strtotime($work->created)) . "</div>"; $last_time = date("H:i", strtotime($work->created)); } echo "<div style='margin-top:8px'>"; if (!strtotime($work->updated) && $work->worked) { echo " <input style='margin-right:8px;' type='button' value='X' onclick=\"cancelWork({$action->id});\" />"; } echo $work->worked ? "Finished " : "<span style='color:red;'>Incompleted </span> "; echo strtolower(convert_work_num_to_caption($work->work)) . " work on \"{$action->name}\"";