Просмотр архива Mobtops


<?
      DEFINE('TITLE' , 'Статистика рейтинга');  # фиксируем титул

      head();


      $allHost = $db->query("SELECT SUM(`allHost`) FROM `site` ");
      $allHost->execute();
      $totalallHost = $allHost->fetch(PDO::FETCH_NUM);
      $totalallHost = $totalallHost[0];


      $allHits = $db->query("SELECT SUM(`allHits`) FROM `site` ");
      $allHits->execute();
      $totalallHits = $allHits->fetch(PDO::FETCH_NUM);
      $totalallHits = $totalallHits[0];

      $allIn = $db->query("SELECT SUM(`allIn`) FROM `site` ");
      $allIn->execute();
      $totalallIn = $allIn->fetch(PDO::FETCH_NUM);
      $totalallIn = $totalallIn[0];

      $allOut = $db->query("SELECT SUM(`allOut`) FROM `site` ");
      $allOut->execute();
      $totalallOut = $allOut->fetch(PDO::FETCH_NUM);
      $totalallOut = $totalallOut[0];






      $onlineCount = $db -> query("SELECT `id` FROM `note_host` WHERE `time` >= '".round(time()-600)."' ");


      $siteActiveID = $db -> query("SELECT `id` FROM `site` WHERE `status` = '1' ");

      $siteDeactiveID = $db -> query("SELECT `id` FROM `site` WHERE `status` != '1' ");

      $siteID = $db -> query("SELECT `id` FROM `site`  ");



      $siteHostToday = $db -> query("SELECT SUM(`host`) FROM `site_statistic` WHERE `date` = '".date("Y-m-d",time())."'");
      $siteHostToday->execute();
      $siteHostTodayID = $siteHostToday->fetch(PDO::FETCH_NUM);
      $siteHostTodayID = $siteHostTodayID[0];

      $siteHitsToday = $db -> query("SELECT SUM(`hits`) FROM `site_statistic` WHERE `date` = '".date("Y-m-d",time())."'");
      $siteHitsToday->execute();
      $siteHitsTodayID = $siteHitsToday->fetch(PDO::FETCH_NUM);
      $siteHitsTodayID = $siteHitsTodayID[0];

      $siteInToday = $db -> query("SELECT SUM(`in`) FROM `site_statistic` WHERE `date` = '".date("Y-m-d",time())."'");
      $siteInToday->execute();
      $siteInTodayID = $siteInToday->fetch(PDO::FETCH_NUM);
      $siteInTodayID = $siteInTodayID[0];

      $siteOutToday = $db -> query("SELECT SUM(`out`) FROM `site_statistic` WHERE `date` = '".date("Y-m-d",time())."'");
      $siteOutToday->execute();
      $siteOutTodayID = $siteOutToday->fetch(PDO::FETCH_NUM);
      $siteOutTodayID = $siteOutTodayID[0];



      $siteHostYesterday = $db -> query("SELECT SUM(`host`) FROM `site_statistic` WHERE `date` = '".date("Y-m-d",(time()-86400))."'");
      $siteHostYesterday->execute();
      $siteHostYesterdayID = $siteHostYesterday->fetch(PDO::FETCH_NUM);
      $siteHostYesterdayID = $siteHostYesterdayID[0];

      $siteHitsYesterday = $db -> query("SELECT SUM(`hits`) FROM `site_statistic` WHERE `date` = '".date("Y-m-d",(time()-86400))."'");
      $siteHitsYesterday->execute();
      $siteHitsYesterdayID = $siteHitsYesterday->fetch(PDO::FETCH_NUM);
      $siteHitsYesterdayID = $siteHitsYesterdayID[0];

      $siteInYesterday = $db -> query("SELECT SUM(`in`) FROM `site_statistic` WHERE `date` = '".date("Y-m-d",(time()-86400))."'");
      $siteInYesterday->execute();
      $siteInYesterdayID = $siteInYesterday->fetch(PDO::FETCH_NUM);
      $siteInYesterdayID = $siteInYesterdayID[0];

      $siteOutYesterday = $db -> query("SELECT SUM(`out`) FROM `site_statistic` WHERE `date` = '".date("Y-m-d",(time()-86400))."'");
      $siteOutYesterday->execute();
      $siteOutYesterdayID = $siteOutYesterday->fetch(PDO::FETCH_NUM);
      $siteOutYesterdayID = $siteOutYesterdayID[0];








        echo '<div class="main">Онлайн на сайтах: '.number_format($onlineCount->rowCount()).'</div>';
        echo '<div class="main">
        Всего сайтов: '.number_format($siteID->rowCount()).'<br />
        Активных сайтов: '.number_format($siteActiveID->rowCount()).'<br />
        Неактивных сайтов: '.number_format($siteDeactiveID->rowCount()).'<br />
        </div><div class="main">
        Сегодня хостов: '.number_format($siteHostTodayID).'<br />
        Сегодня хитов: '.number_format($siteHitsTodayID).'<br />
        Сегодня пришло в топ: '.number_format($siteInTodayID).'<br />
        Сегодня ушло из топа: '.number_format($siteOutTodayID).'<br />
        </div><div class="main">
        Вчера хостов: '.number_format($siteHostYesterdayID).' <br />
        Вчера хитов: '.number_format($siteHitsYesterdayID).'<br />
        Вчера пришло в топ: '.number_format($siteInYesterdayID).'<br />
        Вчера ушло из топа: '.number_format($siteOutYesterdayID).'<br />
        </div><div class="main">
        Всего хостов: '.number_format($totalallHost).'<br />
        Всего хитов: '.number_format($totalallHits).'<br />
        Всего пришло в топ: '.number_format($totalallIn).' <br />
        Всего ушло из топа: '.number_format($totalallOut).' <br />
        </div>';

      foot();

?>