$PlatformDistribution = $Pie->url(); $Cache->cache_value('platform_distribution', $PlatformDistribution, 3600 * 24 * 14); } if (!($BrowserDistribution = $Cache->get_value('browser_distribution'))) { include_once SERVER_ROOT . '/classes/charts.class.php'; $DB->query("\n\t\tSELECT Browser, COUNT(UserID) AS Users\n\t\tFROM users_sessions\n\t\tGROUP BY Browser\n\t\tORDER BY Users DESC"); $Browsers = $DB->to_array(); $Pie = new PIE_CHART(750, 400, array('Other' => 1, 'Percentage' => 1)); foreach ($Browsers as $Browser) { list($Label, $Users) = $Browser; $Pie->add($Label, $Users); } $Pie->transparent(); $Pie->color('008AB8'); $Pie->generate(); $BrowserDistribution = $Pie->url(); $Cache->cache_value('browser_distribution', $BrowserDistribution, 3600 * 24 * 14); } //Timeline generation if (!(list($Labels, $InFlow, $OutFlow, $Max) = $Cache->get_value('users_timeline'))) { $DB->query("\n\t\tSELECT DATE_FORMAT(JoinDate,'%b \\'%y') AS Month, COUNT(UserID)\n\t\tFROM users_info\n\t\tGROUP BY Month\n\t\tORDER BY JoinDate DESC\n\t\tLIMIT 1, 12"); $TimelineIn = array_reverse($DB->to_array()); $DB->query("\n\t\tSELECT DATE_FORMAT(BanDate,'%b \\'%y') AS Month, COUNT(UserID)\n\t\tFROM users_info\n\t\tGROUP BY Month\n\t\tORDER BY BanDate DESC\n\t\tLIMIT 1, 12"); $TimelineOut = array_reverse($DB->to_array()); foreach ($TimelineIn as $Month) { list($Label, $Amount) = $Month; if ($Amount > $Max) { $Max = $Amount; } } foreach ($TimelineOut as $Month) {
$Cache->cache_value('torrents_timeline', array($Labels, $InFlow, $OutFlow, $NetFlow, $Max), mktime(0, 0, 0, date('n') + 1, 2)); //Tested: fine for dec -> jan } include_once SERVER_ROOT . '/classes/charts.class.php'; $DB->query("\n\tSELECT tg.CategoryID, COUNT(t.ID) AS Torrents\n\tFROM torrents AS t\n\t\tJOIN torrents_group AS tg ON tg.ID = t.GroupID\n\tGROUP BY tg.CategoryID\n\tORDER BY Torrents DESC"); $Groups = $DB->to_array(); $Pie = new PIE_CHART(750, 400, array('Other' => 1, 'Percentage' => 1)); foreach ($Groups as $Group) { list($CategoryID, $Torrents) = $Group; $CategoryName = $Categories[$CategoryID - 1]; $Pie->add($CategoryName, $Torrents); } $Pie->transparent(); $Pie->color('FF33CC'); $Pie->generate(); $Categories = $Pie->url(); View::show_header(); ?> <div class="box pad center"> <h1>Uploads by month</h1> <img src="https://chart.googleapis.com/chart?cht=lc&chs=880x160&chco=000D99,99000D,00990D&chg=0,-1,1,1&chxt=y,x&chxs=0,h&chxl=1:|<?php echo implode('|', $Labels); ?> &chxr=0,0,<?php echo $Max; ?> &chd=t:<?php echo implode(',', $InFlow); ?> |<?php
} } $Pie->generate(); if (!empty($_GET['order_way']) && $_GET['order_way'] == 'asc') { $SortWay = SORT_ASC; } else { $SortWay = SORT_DESC; } array_multisort($Sort, $SortWay, $Tables); //End sorting show_header('Database Specifics'); ?> <h3>Breakdown</h3> <div class="box pad center"> <img src="<?php echo $Pie->url(); ?> " /> </div> <br /> <table> <tr class="colhead"> <td><a href="tools.php?action=database_specifics&order_by=name&order_way=<?php echo !empty($_GET['order_by']) && $_GET['order_by'] == 'name' && !empty($_GET['order_way']) && $_GET['order_way'] == 'desc' ? 'asc' : 'desc'; ?> ">Name</a></td> <td><a href="tools.php?action=database_specifics&order_by=engine&order_way=<?php echo !empty($_GET['order_by']) && $_GET['order_by'] == 'engine' && !empty($_GET['order_way']) && $_GET['order_way'] == 'desc' ? 'asc' : 'desc'; ?> ">Engine</a></td> <td><a href="tools.php?action=database_specifics&order_by=rows&order_way=<?php