stuff.php

   1 <?php
   2 // $Id$
   3
   4 require 'con.php';
   5
   6 $page->title = 'Stats and Stuff';
   7 $user->userheader();
   8
   9 $date = array(
  10         'today' => mktime(0, 0, 0),
  11         'week'  => mktime(0, 0, 0) - 86400*(gmdate('w')-1),
  12         'month' => mktime(0, 0, 0, gmdate('m'), 1),
  13         '24h'   => (time()-86400),
  14         '7d'    => (time()-86400*7),
  15         '30d'   => (time()-86400*30)
  16 );
  17
  18 /* this does stuff */
  19 function getrow($sql)
  20 {
  21         global $DB, $date;
  22         $return = '';
  23         foreach ($date as $num) {
  24                 $return .= '<td>'.$DB->query(sprintf($sql, $num))->fetch_object()->result.'</td> ';
  25         }
  26
  27         return $return;
  28 }
  29 ?>
  30
  31 <table id="board_stats" style="empty-cells: hide">
  32 <caption>Board Statistics</caption>
  33
  34 <colgroup title="Row headers">
  35         <col/>
  36 </colgroup>
  37 <colgroup title="Fuzzy statistics">
  38         <col/><col/><col/>
  39 </colgroup>
  40 <colgroup title="Raw statistics">
  41         <col/><col/><col/><col/>
  42 </colgroup>
  43
  44 <thead>
  45 <tr>
  46         <td/>
  47         <th>Today</th>
  48         <th>This week</th>
  49         <th>This month</th>
  50         <th>Last 24 hours</th>
  51         <th>Last 7 days</th>
  52         <th>Last 30 days</th>
  53         <th>Total</th>
  54 </tr>
  55 </thead>
  56
  57 <tbody>
  58
  59 <?php
  60 $a = 1;
  61
  62 echo
  63 '<tr class="content c',(++$a&1),'">
  64         <th scope="row">Posts</th>
  65         ',getrow('SELECT COUNT(*) AS `result` FROM `messages` WHERE `mtime` > %d'),'
  66         <td>',$DB->query('SELECT COUNT(*) AS `result` FROM `messages`')->fetch_object()->result,'</td>
  67 </tr>
  68
  69 <tr class="content c',(++$a&1),'">
  70         <th scope="row">Replies only</th>
  71         ',getrow('SELECT COUNT(*) AS `result` FROM `messages` WHERE `replyto` IS NOT NULL AND `mtime` > %d'),'
  72         <td>',$DB->query('SELECT COUNT(*) AS `result` FROM `messages`
  73                                         WHERE `replyto` IS NOT NULL')->fetch_object()->result,'</td>
  74 </tr>
  75
  76 <tr class="content c',(++$a&1),'">
  77         <th scope="row">Topics</th>
  78         ',getrow('SELECT COUNT(DISTINCT(`topicid`)) AS `result` FROM `messages` WHERE `mtime` > %d'),'
  79         <td>',$DB->query('SELECT COUNT(*) AS `result` FROM `topics`')->fetch_object()->result,'</td>
  80 </tr>
  81
  82 <tr class="content c',(++$a&1),'">
  83         <th scope="row">Total users</th>
  84         ',getrow('SELECT COUNT(*) AS `result` FROM `users` WHERE `register_date` > %d'),'
  85         <td>',$DB->query('SELECT COUNT(*) AS `result` FROM `users`')->fetch_object()->result,'</td>
  86 </tr>
  87
  88 <tr class="content c',(++$a&1),'">
  89         <th scope="row">Online users</th>
  90         ',getrow('SELECT COUNT(`userid`) AS `result` FROM `users`
  91                         WHERE `last_active_date` > `register_date` AND `last_active_date` > %d'),'
  92         <td>',$DB->query('SELECT COUNT(*) AS `result` FROM `users`
  93                         WHERE `last_active_date` > `register_date`')->fetch_object()->result,'</td>
  94 </tr>
  95
  96 <tr class="content c',(++$a&1),'">
  97         <th scope="row">Active users</th>
  98         ',getrow('SELECT COUNT(DISTINCT(`users`.`userid`)) AS `result` FROM `users`
  99                         NATURAL LEFT JOIN `messages` WHERE `messages`.`mtime` > %d'),'
 100         <td>',$DB->query('SELECT COUNT(DISTINCT(`users`.`userid`)) AS `result`
 101                                         FROM `users` NATURAL LEFT JOIN `messages`')->fetch_object()->result ?></td>
 102 </tr>
 103 </tbody>
 104
 105 </table>
 106
 107 <h2>Terms of Service</h2>
 108 <ul>
 109         <li>Don't be a fucking idiot.</li>
 110         <li>Don't invite them.</li>
 111         <li>This site is not affiliated with AOL. Don't behave like an AOLer here.</li>
 112 </ul>
 113
 114 <?php
 115 $page->pagefooter();
 116 ?>