connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$data_index = 0;
function DrawSqlPieChart($div_id, $title, $conn, $sql, $key, $value) {
global $data_index;
$data_index = $data_index + 1;
echo "chart_data" . $data_index . " = google.visualization.arrayToDataTable([ ['Key', 'Value'],";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "[StrReplacments('" . $row[$key] . "'), " . $row[$value] . "],";
}
}
echo " ]);";
echo "chart" . $data_index . " = new google.visualization.PieChart(document.getElementById('" . $div_id . "'));";
echo "chart" . $data_index . ".draw(chart_data" . $data_index . ", {pieSliceText: 'label', title: '" . $title . "'});";
echo "google.visualization.events.addListener(chart" . $data_index . ", 'click', function (e) {pieClicked(e, chart_data" . $data_index . ") });";
}
function DrawSqlColumnChart($div_id, $title, $conn, $sql, $key, $value) {
global $data_index;
$data_index = $data_index + 1;
echo "chart_data" . $data_index . " = google.visualization.arrayToDataTable([['Key', 'Value', { role: 'style' } ],";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "[StrReplacments('" . $row[$key] . "'), " . $row[$value] . ", 'color: #e5e4e2'],";
}
}
echo " ]);";
echo "var view = new google.visualization.DataView(chart_data" . $data_index . ");";
echo 'view.setColumns([0, 1,{ calc: "stringify",sourceColumn: 1, type: "string", role: "annotation" },2]);';
echo "chart = new google.visualization.ColumnChart(document.getElementById('" . $div_id . "'));";
echo "chart.draw(view, {title: '" . $title . "', width: 1500, height: 500, bar: {groupWidth: '60%'}, legend: { position: 'none' }, vAxis: {minValue: 0}});";
echo "google.visualization.events.addListener(chart, 'click', function (e) {labelClicked(e, chart_data" . $data_index . ") });";
}
function SelectResult($sql, $conn, $key) {
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
return $row[$key];
}
}
}
function secondsToTime($seconds) {
if ($seconds == 0) {return 0;}
$dtF = new \DateTime('@0');
$dtT = new \DateTime("@$seconds");
return $dtF->diff($dtT)->format('%a days, %h hours, %i minutes and %s seconds');
}
?>
Statistics for player " . $SteamID . " - " . $name . "";
echo
'
';
echo "
Total Money Robbed From Stores: $" . SelectResult("SELECT Sum(RobbedAmount) AS Sum FROM RobberyStats WHERE SteamID = '" . $SteamID . "'", $conn, "Sum") . "
";
//change this to sql instead
$percent = SelectResult("SELECT (SELECT Count(*) AS Count FROM RobberyStats Where Success = true AND SteamID = '" . $SteamID . "') / (SELECT Count(*) AS Count FROM RobberyStats WHERE SteamID = '" . $SteamID . "') * 100 AS PERCENT", $conn, "PERCENT");
$kdr = SelectResult("SELECT (SELECT Count(*) FROM KillStats WHERE KillerID = '" . $SteamID . "') / (SELECT Count(*) FROM KillStats WHERE VictimID = '" . $SteamID . "') AS KDR", $conn, "KDR");
$arrestsMade = SelectResult("SELECT Count(*) AS Count FROM ArrestStats WHERE ArresterID = '" . $SteamID . "'", $conn, "Count");
$jailTime = SelectResult("SELECT Sum(JailTime) AS Sum FROM ArrestStats WHERE ArrestedID = '" . $SteamID . "'", $conn, "Sum");
$playTime = SelectResult("SELECT Sum(PlayTime) AS Sum FROM PlayTime WHERE SteamID = '" . $SteamID . "'", $conn, "Sum");
$warehouseEarnings = SelectResult("SELECT Sum(Value) AS Sum FROM ItemStats WHERE Item != 'Evidence' AND SteamID = '" . $SteamID . "'", $conn, "Sum");
$evidenceEarnings = SelectResult("SELECT Sum(Value) AS Sum FROM ItemStats WHERE Item = 'Evidence' AND SteamID = '" . $SteamID . "'", $conn, "Sum");
$bountyEarnings = SelectResult("SELECT Sum(Collected) AS Sum FROM BountyStats WHERE CollectorID = '" . $SteamID . "'", $conn, "Sum");
$lastSeen = SelectResult("SELECT EndTime FROM PlayTime WHERE SteamID = '" . $SteamID . "' ORDER BY EndTime DESC", $conn, "EndTime");
echo " Money Gained From Warehouses: $" . $warehouseEarnings . "
";
echo " Robbery Sucess Rate: " . round($percent, 2) . "%
";
echo "Time Spent In Jail: " . round($jailTime / 60, 1) . " Minutes
";
echo "";
echo " Money Gained From Killing/Arresting Robbers: $" . $bountyEarnings . "
";
echo " Money Gained From Evidence: $" . $evidenceEarnings . "
";
echo "";
echo " Arrests Made: " . $arrestsMade . "
";
echo " Kill/Death Ratio: " . round($kdr, 2) . "
";
echo "Play Time: " . secondsToTime($playTime) . "
";
echo "Last Seen: " . $lastSeen . "
";
echo "";
}
elseif (!empty($_GET["weapon"]))
{
$weapon = $_GET["weapon"];
echo "Statistics for weapon " . $weapon . "
";
echo
'
';
}
else
{
echo "";
echo
'
';
echo "
Total Money Robbed From Stores: $" . SelectResult("SELECT Sum(RobbedAmount) AS Sum FROM RobberyStats", $conn, "Sum") . "
";
echo " Total Money Generated From Warehouses: $" . SelectResult("Select Sum(Value) AS Sum FROM ItemStats WHERE Item != 'Evidence'", $conn, "Sum") . "
";
//change this to sql instead
$percent = SelectResult("SELECT (SELECT Count(*) AS Count FROM RobberyStats Where Success = true) / (SELECT Count(*) AS Count FROM RobberyStats) * 100 AS PERCENT", $conn, "PERCENT");
$arrestsMade = SelectResult("SELECT Count(*) AS Count FROM ArrestStats", $conn, "Count");
$jailTime = SelectResult("SELECT Sum(JailTime) AS Sum FROM ArrestStats", $conn, "Sum");
$playTime = SelectResult("SELECT Sum(PlayTime) AS Sum FROM PlayTime", $conn, "Sum");
echo " Robbery Sucess Rate: " . round($percent, 2) . "%
";
echo "Combined Play Time: " . secondsToTime($playTime) . "
";
echo "Arrests Made: " . $arrestsMade . "
";
echo "Combined Time Spent In Jail: " . round($jailTime / 60, 1) . " Minutes
";
echo "";
}
?>
close(); ?>