Create functions that output the following scoreboards (this will be used later)

[Cromanowski]

• Top 10 Weekly
• Top 10 Monthly
• Top 10 Lifetime
• Scoreboards should show no more than 10 results; if there are no results a proper message should be displayed (i.e., “No [time period] scores to display”)

[Cromanowski]

https://github.com/Cromanowski/IT202-007/pull/55

[Cromanowski]

function get_top_10($duration = "day") { $d = "day"; if (in_array($duration, ["day", "week", "month", "lifetime"])) { //variable is safe $d = $duration; } $db = getDB(); $query = "SELECT user_id,username, score, Scores.created from Scores join Users on Scores.user_id = Users.id"; if ($d !== "lifetime") { //be very careful passing in a variable directly to SQL, I ensure it's a specific value from the in_array() above $query .= " WHERE Scores.created >= DATE_SUB(NOW(), INTERVAL 1 $d)"; } //remember to prefix any ambiguous columns (Users and Scores both have created) $query .= " ORDER BY score Desc, Scores.created desc LIMIT 10"; //newest of the same score is ranked higher error_log($query); $stmt = $db->prepare($query); $results = []; try { $stmt->execute(); $r = $stmt->fetchAll(PDO::FETCH_ASSOC); if ($r) { $results = $r; } } catch (PDOException $e) { error_log("Error fetching scores for $d: " . var_export($e->errorInfo, true)); } return $results; }