$time_end = $date->format("U");
$day_end = $date->format("Y-m-d");
$date->modify("-30 days");
$date->setTime(0, 0, 0);
$time_start = $date->format("U");
$stats = array();
while (true) {
$day = $date->format("Y-m-d");
$stats[$day] = 0;
$date->modify("+1 day");
if ($day == $day_end) {
break;
}
}
// hent statistikk
$result = \Kofradia\DB::get()->query("\n\tSELECT DATE(FROM_UNIXTIME(poker_time_start)) AS day, SUM(CONVERT(poker_prize - poker_cash, SIGNED) * IF((poker_winner = 1 AND poker_starter_up_id = up_id) OR (poker_winner = 2 AND poker_challenger_up_id = up_id), 1, -1)) sum_result\n\tFROM poker, users_players\n\tWHERE poker_time_start >= {$time_start} AND poker_time_start <= {$time_end} AND up_u_id = {$u_id} AND (up_id = poker_starter_up_id OR up_id = poker_challenger_up_id) AND poker_state = 4\n\tGROUP BY DATE(FROM_UNIXTIME(poker_time_start))");
while ($row = $result->fetch()) {
$stats[$row['day']] = (double) $row['sum_result'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Pokerstatistikk for {$up_name} siste 30 dager"));
$bar = new OFC_Charts_Area();
$bar->text("Resultat av poker");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# kr");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(2)->rotate(330)->labels(array_keys($stats));
$ofc->axis_y()->set_numbers(min(0, min($stats)), max($stats));
$ofc->dark_colors();
echo $ofc;
$stats_die[$day] = 0;
$time->modify("+1 day");
if ($day == $today) {
break;
}
}
$result = \Kofradia\DB::get()->query("SELECT DATE(FROM_UNIXTIME(up_created_time)) day, COUNT(up_id) count FROM users_players WHERE up_created_time >= {$expire} GROUP BY DATE(FROM_UNIXTIME(up_created_time))");
while ($row = $result->fetch()) {
$stats_new[$row['day']] = (int) $row['count'];
}
$result = \Kofradia\DB::get()->query("SELECT DATE(FROM_UNIXTIME(up_deactivated_time)) day, COUNT(up_id) count FROM users_players WHERE up_deactivated_time >= {$expire} GROUP BY DATE(FROM_UNIXTIME(up_deactivated_time))");
while ($row = $result->fetch()) {
$stats_die[$row['day']] = (int) $row['count'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Antall spillere"));
$ofc->tooltip()->title("font-size: 13px;font-weight:bold");
$bar = new OFC_Charts_Line();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# nye brukere");
$bar->text("Antall nye spillere");
$bar->values(array_values($stats_new));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Line();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# døde brukere");
$bar->text("Antall døde spillere");
$bar->values(array_values($stats_die));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(2)->rotate(330)->labels(array_keys($stats_new));
$ofc->axis_y()->set_numbers(0, max(max($stats_new), max($stats_die)));
$date->setTime(0, 0, 0);
$time_from = $date->format("U");
$date->modify("+1 month -1 sec");
$time_to = $date->format("U");
// sett opp timestatistikk
$days = $date->format("t");
$month = $date->format(date::FORMAT_MONTH);
$stats = array();
$stats_redir = array();
$x = array();
for ($i = 1; $i <= $days; $i++) {
$stats[$i] = 0;
$x[] = "{$i}. " . $month;
}
// hent dagstatistikk
$result = \Kofradia\DB::get()->query("SELECT DAY(FROM_UNIXTIME(uhi_secs_hour)) AS day, SUM(uhi_points) sum_points FROM users_hits, users_players WHERE up_u_id = {$u_id} AND up_id = uhi_up_id AND uhi_secs_hour >= {$time_from} AND uhi_secs_hour <= {$time_to} GROUP BY DAY(FROM_UNIXTIME(uhi_secs_hour))");
while ($row = $result->fetch()) {
$stats[$row['day']] = (int) $row['sum_points'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Rankpoeng for {$up_name} - " . $date->format(date::FORMAT_MONTH) . " " . $date->format("Y")));
$bar = new OFC_Charts_Area();
$bar->text("Antall rankpoeng");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# poeng");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(2)->rotate(330)->labels($x);
$ofc->axis_y()->set_numbers(min($stats), max($stats));
$ofc->dark_colors();
echo $ofc;
for ($i = 1; $i <= 12; $i++) {
$stats1[$i] = 0;
$stats2[$i] = 0;
$x[] = $_lang['months'][$i];
}
// hent statistikk
$result = \Kofradia\DB::get()->query("SELECT MONTH(FROM_UNIXTIME(ft_time)) AS month, COUNT(ft_id) num FROM forum_topics JOIN users_players ON ft_up_id = up_id WHERE up_u_id = {$u_id} AND ft_time >= {$time_from} AND ft_time <= {$time_to} GROUP BY MONTH(FROM_UNIXTIME(ft_time))");
while ($row = $result->fetch()) {
$stats1[$row['month']] = (int) $row['num'];
}
$result = \Kofradia\DB::get()->query("SELECT MONTH(FROM_UNIXTIME(fr_time)) AS month, COUNT(fr_id) num FROM forum_replies JOIN users_players ON fr_up_id = up_id WHERE up_u_id = {$u_id} AND fr_time >= {$time_from} AND fr_time <= {$time_to} GROUP BY MONTH(FROM_UNIXTIME(fr_time))");
while ($row = $result->fetch()) {
$stats2[$row['month']] = (int) $row['num'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Aktivitet i forumet for {$up_name} - " . $date->format("Y")));
$bar = new OFC_Charts_Area();
$bar->text("Antall forumsvar");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# svar");
$bar->values(array_values($stats2));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Area();
$bar->text("Antall forumtråder");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# tråder");
$bar->values(array_values($stats1));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(1)->rotate(330)->labels($x);
$ofc->axis_y()->set_numbers(0, max(max($stats1), max($stats2)));
$ofc->dark_colors();
$stats = array();
$stats_redir = array();
$x = array();
for ($i = 1; $i <= $days; $i++) {
$stats[$i] = 0;
$stats_redir[$i] = 0;
$x[] = "{$i}. " . $month;
}
// hent dagstatistikk
$result = \Kofradia\DB::get()->query("SELECT DAY(FROM_UNIXTIME(uhi_secs_hour)) AS day, SUM(uhi_hits) sum_hits, SUM(uhi_hits_redirect) sum_hits_redirect FROM users_hits, users_players WHERE up_u_id = {$u_id} AND up_id = uhi_up_id AND uhi_secs_hour >= {$time_from} AND uhi_secs_hour <= {$time_to} GROUP BY DAY(FROM_UNIXTIME(uhi_secs_hour))");
while ($row = $result->fetch()) {
$stats[$row['day']] = (int) $row['sum_hits'];
$stats_redir[$row['day']] = (int) $row['sum_hits_redirect'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Sidevisninger for {$up_name} - " . $date->format(date::FORMAT_MONTH) . " " . $date->format("Y")));
$bar = new OFC_Charts_Area();
$bar->text("Antall visninger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# visninger");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Area();
$bar->text("Antall videresendinger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# videresendinger");
$bar->values(array_values($stats_redir));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(2)->rotate(330)->labels($x);
$ofc->axis_y()->set_numbers(0, max(max($stats), max($stats_redir)));
$ofc->dark_colors();
$time = $_base->date->get();
$time->modify("-50 days");
$time->setTime(0, 0, 0);
$expire = $time->format("U");
$stats = array();
$today = $_base->date->get()->format("Y-m-d");
while (true) {
$day = $time->format("Y-m-d");
$stats[$day] = 0;
$time->modify("+1 day");
if ($day == $today) {
break;
}
}
$result = \Kofradia\DB::get()->query("SELECT DATE(FROM_UNIXTIME(uhi_secs_hour)) day, SUM(uhi_points)/COUNT(DISTINCT uhi_up_id) avg_points FROM users_hits WHERE uhi_secs_hour >= {$expire} GROUP BY DATE(FROM_UNIXTIME(uhi_secs_hour))");
while ($row = $result->fetch()) {
$stats[$row['day']] = (int) $row['avg_points'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Gjennomsnittlig rankaktivitet per bruker"));
$ofc->tooltip()->title("font-size: 13px;font-weight:bold");
$bar = new OFC_Charts_Area();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# rankpoeng");
$bar->text("Gjennomsnittlig antall rankpoeng per bruker");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->rotate(330)->labels(array_keys($stats))->steps(3);
$ofc->axis_y()->set_numbers(min(0, min($stats)), max($stats));
$ofc->dark_colors();
$ofc->dump();
for ($i = 1; $i <= $days; $i++) {
$stats1[$i] = 0;
$stats2[$i] = 0;
$x[] = "{$i}. " . $month;
}
// hent statistikk
$result = \Kofradia\DB::get()->query("SELECT DAY(FROM_UNIXTIME(ft_time)) AS day, COUNT(ft_id) num FROM forum_topics JOIN users_players ON ft_up_id = up_id WHERE up_u_id = {$u_id} AND ft_time >= {$time_from} AND ft_time <= {$time_to} GROUP BY DAY(FROM_UNIXTIME(ft_time))");
while ($row = $result->fetch()) {
$stats1[$row['day']] = (int) $row['num'];
}
$result = \Kofradia\DB::get()->query("SELECT DAY(FROM_UNIXTIME(fr_time)) AS day, COUNT(fr_id) num FROM forum_replies JOIN users_players ON fr_up_id = up_id WHERE up_u_id = {$u_id} AND fr_time >= {$time_from} AND fr_time <= {$time_to} GROUP BY DAY(FROM_UNIXTIME(fr_time))");
while ($row = $result->fetch()) {
$stats2[$row['day']] = (int) $row['num'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Aktivitet i forumet for {$up_name} - " . $date->format(date::FORMAT_MONTH) . " " . $date->format("Y")));
$bar = new OFC_Charts_Area();
$bar->text("Antall forumsvar");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# svar");
$bar->values(array_values($stats2));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Area();
$bar->text("Antall forumtråder");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# tråder");
$bar->values(array_values($stats1));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(2)->rotate(330)->labels($x);
$ofc->axis_y()->set_numbers(0, max(max($stats1), max($stats2)));
$ofc->dark_colors();
for ($i = $time_from; $i <= $time_to; $i += 3600) {
$time = $_base->date->get($i);
$stats[$time->format("H")] = 0;
$stats_redir[$time->format("H")] = 0;
$h = $time->format("H");
$x[] = $h . ":00 - " . ($h + 1) . ":00";
}
// hent timestatistikk
$result = \Kofradia\DB::get()->query("SELECT uhi_secs_hour, uhi_hits, uhi_hits_redirect FROM users_hits, users_players WHERE up_u_id = {$u_id} AND up_id = uhi_up_id AND uhi_secs_hour >= {$time_from} AND uhi_secs_hour <= {$time_to}");
while ($row = $result->fetch()) {
$time = $_base->date->get($row['uhi_secs_hour']);
$stats[$time->format("H")] = (int) $row['uhi_hits'];
$stats_redir[$time->format("H")] = (int) $row['uhi_hits_redirect'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Sidevisninger for {$up_name} - " . $date->format(date::FORMAT_WEEKDAY) . " " . $date->format(date::FORMAT_NOTIME)));
$bar = new OFC_Charts_Area();
$bar->text("Antall visninger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# visninger");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Area();
$bar->text("Antall videresendinger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# videresendinger");
$bar->values(array_values($stats_redir));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(2)->rotate(330)->labels($x);
$ofc->axis_y()->set_numbers(0, max(max($stats), max($stats_redir)));
$ofc->dark_colors();
$stats_redir = array();
$x_label = array();
for ($i = 0; $i <= 23; $i++) {
$stats[$i] = 0;
$stats_redir[$i] = 0;
$x_label[] = "{$i}:00 - " . ($i + 1) . ":00";
}
// hent timestatistikk
$result = \Kofradia\DB::get()->query("SELECT HOUR(FROM_UNIXTIME(uhi_secs_hour)) AS hour, SUM(uhi_hits) AS sum_hits, SUM(uhi_hits_redirect) AS sum_hits_redirect FROM users_hits, users_players WHERE up_u_id = {$u_id} AND uhi_up_id = up_id GROUP BY HOUR(FROM_UNIXTIME(uhi_secs_hour))");
while ($row = $result->fetch()) {
$stats[$row['hour']] = (int) $row['sum_hits'];
$stats_redir[$row['hour']] = (int) $row['sum_hits_redirect'];
}
$ofc = new OFC();
$c = new OFC_Colours();
$ofc->title(new OFC_Title("Gjennomsnittlig antall visninger for {$up_name}"));
$ofc->tooltip()->title("font-size: 13px;font-weight:bold");
$bar = new OFC_Charts_Area();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# visninger");
$bar->text("Antall visninger");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Area();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# videresendinger");
$bar->text("Antall videresendinger");
$bar->values(array_values($stats_redir));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->rotate(330)->labels($x_label)->steps(2);
$ofc->axis_y()->set_numbers(0, max(max($stats), max($stats_redir)));
// hent dagstatistikk
$result = \Kofradia\DB::get()->query("SELECT WEEKDAY(FROM_UNIXTIME(uhi_secs_hour)) AS date, SUM(uhi_hits) sum_hits, SUM(uhi_hits_redirect) sum_hits_redirect FROM users_hits, users_players WHERE up_u_id = {$u_id} AND up_id = uhi_up_id GROUP BY WEEKDAY(FROM_UNIXTIME(uhi_secs_hour)) ORDER BY date");
while ($row = $result->fetch()) {
$stats[$row['date'] + 1] = (int) $row['sum_hits'];
$stats_redir[$row['date'] + 1] = (int) $row['sum_hits_redirect'];
}
$x = array();
global $_lang;
foreach ($stats as $date => $dummy) {
if ($date == 7) {
$date = 0;
}
$x[] = $_lang['weekdays'][$date];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Sidevisninger for {$up_name}"));
$bar = new OFC_Charts_Bar();
$bar->text("Antall visninger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# visninger");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Bar();
$bar->text("Antall videresendinger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# videresendinger");
$bar->values(array_values($stats_redir));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(ceil(count($x) / 20))->rotate(330)->labels($x);
$ofc->axis_y()->set_numbers(0, max(max($stats), max($stats_redir)));
$ofc->dark_colors();
$stats_redir[$day] = 0;
$time->modify("+1 day");
if ($day == $today) {
break;
}
}
$time->modify("-1 sec");
$time_to = $time->format("U");
// hent dagstatistikk
$result = \Kofradia\DB::get()->query("SELECT DATE(FROM_UNIXTIME(uhi_secs_hour)) AS date, SUM(uhi_hits) sum_hits, SUM(uhi_hits_redirect) sum_hits_redirect FROM users_hits, users_players WHERE up_u_id = {$u_id} AND up_id = uhi_up_id AND uhi_secs_hour >= {$time_from} AND uhi_secs_hour <= {$time_to} GROUP BY DATE(FROM_UNIXTIME(uhi_secs_hour))");
while ($row = $result->fetch()) {
$stats[$row['date']] = (int) $row['sum_hits'];
$stats_redir[$row['date']] = (int) $row['sum_hits_redirect'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Sidevisninger for {$up_name} siste periode"));
$bar = new OFC_Charts_Area();
$bar->text("Antall visninger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# visninger");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Area();
$bar->text("Antall videresendinger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# videresendinger");
$bar->values(array_values($stats_redir));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$ofc->axis_x()->steps(2)->label()->steps(4)->rotate(330)->labels(array_keys($stats));
$ofc->axis_y()->set_numbers(0, max(max($stats), max($stats_redir)));
$ofc->dark_colors();
$time = $_base->date->get();
$time->modify("-50 days");
$time->setTime(0, 0, 0);
$expire = $time->format("U");
$stats = array();
$today = $_base->date->get()->format("Y-m-d");
while (true) {
$day = $time->format("Y-m-d");
$stats[$day] = 0;
$time->modify("+1 day");
if ($day == $today) {
break;
}
}
$result = \Kofradia\DB::get()->query("SELECT DATE(FROM_UNIXTIME(uhi_secs_hour)) day, SUM(uhi_points) sum_points FROM users_hits WHERE uhi_secs_hour >= {$expire} GROUP BY DATE(FROM_UNIXTIME(uhi_secs_hour))");
while ($row = $result->fetch()) {
$stats[$row['day']] = (int) $row['sum_points'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Rankaktivitet"));
$ofc->tooltip()->title("font-size: 13px;font-weight:bold");
$bar = new OFC_Charts_Area();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# rankpoeng");
$bar->text("Antall rankpoeng");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->rotate(330)->labels(array_keys($stats))->steps(3);
$ofc->axis_y()->set_numbers(min(0, min($stats)), max($stats));
$ofc->dark_colors();
$ofc->dump();
<?php
require "graphs_base.php";
ajax::require_user();
global $_base;
// hent stats
$result = \Kofradia\DB::get()->query("SELECT name, extra, value, time FROM sitestats");
$sitestats = array();
$max = 0;
while ($row = $result->fetch()) {
$sitestats[$row['name']][$row['extra']] = (int) $row['value'];
$max = max($max, $row['value']);
}
$ofc = new OFC();
$c = new OFC_Colours();
$ofc->title(new OFC_Title("Rekord for antall pålogget"));
$ofc->tooltip()->title("font-size: 13px;font-weight:bold");
$info = array("max_online_900" => "15 minutter", "max_online_300" => "5 minutter", "max_online_60" => "1 minutt", "max_online_30" => "30 sekunder");
foreach ($info as $key => $title) {
$bar = new OFC_Charts_Area();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("Rekord for #x_label#:<br>#val# i løpet av {$title}");
$bar->text($title);
$bar->values(array_values($sitestats[$key]));
$bar->colour($c->pick());
$ofc->add_element($bar);
}
$x_label = array();
foreach (array_keys($sitestats['max_online_60']) as $val) {
$x_label[] = "{$val}:00 - " . ($val + 1) . ":00";
}
$ofc->axis_x()->label()->rotate(340)->labels($x_label)->steps(2);
$days = array();
$days_max = 0;
$users = array();
while ($row = $result->fetch()) {
$users[$row['up_name']][$row['day']] = (int) $row['num_actions'];
$days[$row['day']] = (isset($days[$row['day']]) ? (int) $days[$row['day']] : 0) + (int) $row['num_actions'];
$days_max = max($days_max, $row['num_actions']);
}
// sorter statistikk
$stats = array();
foreach ($days as $day => $total) {
foreach ($users as $user => $user_days) {
$stats[$user][$day] = isset($user_days[$day]) ? $user_days[$day] : 0;
}
}
$ofc = new OFC();
$c = new OFC_Colours();
$ofc->title(new OFC_Title("Aktivitet i crewloggen"));
$ofc->tooltip()->title("font-size: 13px;font-weight:bold");
foreach ($stats as $user => $days) {
$bar = new OFC_Charts_Line();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("Antall registreringer #x_label# for {$user}: #val#");
$bar->text($user);
$bar->values(array_values($days));
$bar->colour($c->pick());
$ofc->add_element($bar);
}
$ofc->axis_x()->label()->rotate(340)->labels(array_keys($days))->steps(5);
$ofc->axis_y()->set_numbers(0, min(20, $days_max));
$ofc->dark_colors();
$ofc->dump();
while (true) {
$day = $time->format("Y-m-d");
$stats_normal[$day] = 0;
$stats_redirect[$day] = 0;
$time->modify("+1 day");
if ($day == $today) {
break;
}
}
$result = \Kofradia\DB::get()->query("SELECT DATE(FROM_UNIXTIME(uhi_secs_hour)) day, SUM(uhi_hits) sum_hits, SUM(uhi_hits_redirect) sum_hits_redirect FROM users_hits WHERE uhi_secs_hour >= {$expire} GROUP BY DATE(FROM_UNIXTIME(uhi_secs_hour))");
while ($row = $result->fetch()) {
$stats_normal[$row['day']] = (int) $row['sum_hits'];
$stats_redirect[$row['day']] = (int) $row['sum_hits_redirect'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Antall sidevisninger"));
$ofc->tooltip()->title("font-size: 13px;font-weight:bold");
$bar = new OFC_Charts_Area();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# visninger");
$bar->text("Antall visninger");
$bar->values(array_values($stats_normal));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Area();
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# videresendinger");
$bar->text("Antall videresendinger");
$bar->values(array_values($stats_redirect));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->rotate(330)->labels(array_keys($stats_normal))->steps(3);
$ofc->axis_y()->set_numbers(0, max(max($stats_normal), max($stats_redirect)));
for ($i = $time_from; $i < $time_to; $i += 3600) {
$time = $_base->date->get($i);
$stats[$time->format("dH")] = 0;
$stats_redir[$time->format("dH")] = 0;
$h = $time->format("H");
$x[] = $h . ":00 - " . ($h + 1) . ":00";
}
// hent timestatistikk
$result = \Kofradia\DB::get()->query("SELECT uhi_secs_hour, uhi_hits, uhi_hits_redirect FROM users_hits, users_players WHERE up_u_id = {$u_id} AND up_id = uhi_up_id AND uhi_secs_hour >= {$time_from} AND uhi_secs_hour < {$time_to}");
while ($row = $result->fetch()) {
$time = $_base->date->get($row['uhi_secs_hour']);
$stats[$time->format("dH")] = (int) $row['uhi_hits'];
$stats_redir[$time->format("dH")] = (int) $row['uhi_hits_redirect'];
}
$ofc = new OFC();
$ofc->title(new OFC_Title("Sidevisninger for {$up_name} siste 24 timer"));
$bar = new OFC_Charts_Area();
$bar->text("Antall visninger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# visninger");
$bar->values(array_values($stats));
$bar->colour(OFC_Colours::$colours[0]);
$ofc->add_element($bar);
$bar = new OFC_Charts_Area();
$bar->text("Antall videresendinger");
$bar->dot_style()->type("solid-dot")->dot_size(3)->halo_size(2)->tip("#x_label#<br>#val# videresendinger");
$bar->values(array_values($stats_redir));
$bar->colour(OFC_Colours::$colours[1]);
$ofc->add_element($bar);
$ofc->axis_x()->label()->steps(2)->rotate(330)->labels($x);
$ofc->axis_y()->set_numbers(0, max(max($stats), max($x)));
$ofc->dark_colors();
