$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();