Traffiker

Last updated: 03/04/2020

Get map = 7; $x >= 0;){ $timeBefore = time() - (86400 * $x); $timeAfter = time() - (86400 * ($x + 1)); $query = $db->prepare("SELECT count(*) FROM levels WHERE uploadDate < :timeBefore AND uploadDate > :timeAfter AND userID != 388"); $query->execute([':timeBefore' => $timeBefore, ':timeAfter' => $timeAfter]); switch($x){ case 1: $identifier = $x . " day ago"; break; case 0: $identifier = "Last 24 hours"; break; default: $identifier = $x . " days ago"; break; } $chartdata[$identifier] = $query->fetchColumn(); $x--; } $levelsChart2 = array(); $months = ["January","February","March","April","May","June","July","August","September","October","November","December"]; $x = 0; foreach($months as &$month){ $x++; $nextMonthYear = date('Y'); if($x == 12){ $x = 0; $nextMonthYear++; } $nextMonth = $months[$x]; $timeBefore = strtotime("first day of $month ".date('Y')); $timeAfter = strtotime("first day of $nextMonth ".$nextMonthYear); $query = $db->prepare("SELECT count(*) FROM levels WHERE uploadDate > :timeBefore AND uploadDate < :timeAfter AND userID != 388"); $query->execute([':timeBefore' => $timeBefore, ':timeAfter' => $timeAfter]); $amount = $query->fetchColumn(); if($amount != 0){ $levelsChart2[$month] = $amount; } } $dl->printPage('

Welcome to the RoDashGDPS dashboard. Please choose a tool above.
DISCLAIMER: THIS AREA IS UNDER HEAVY DEVELOPEMENT, DON\'T EXPECT MUCH STUFF TO WORK
Legend: (N) = Not Working, (T) = Links to the legacy tool version

' . $dl->generateLineChart("levelsChart","Levels Uploaded",$chartdata) . $dl->generateLineChart("levelsChart2","Levels Uploaded",$levelsChart2), false); ?>