lib/Topiclist_Lite.php

   1 <?php
   2 /**
   3  * SO2 default topic list layout
   4  *
   5  * @author Ant P <p@cpi.merseine.nu>
   6  * @license file://../COPYING
   7  * @version 2.15
   8  */
   9
  10 require_once 'lib/iface.Topiclist.php';
  11
  12 class Topiclist_Lite implements Topiclist
  13 {
  14     protected $tpp;
  15     protected $page;
  16     protected $topicsum;
  17
  18     function __construct($tpp = 35, $page = 0)
  19     {
  20         $this->tpp = $tpp;
  21         $this->page = $page;
  22         $this->topicsum = SO2::$DB->query('SELECT COUNT(*) FROM topics WHERE boardid = @boardid')->fetchColumn(0);
  23     }
  24
  25     public function display()
  26     {
  27         // bleh
  28         $q = SO2::$DB->q(
  29                 'SELECT topics.topicid, topic_title, topics.userid, messageid, mtime, '.
  30                        '(SELECT COUNT(*) FROM messages WHERE messages.topicid = topics.topicid) AS posts '.
  31                 'FROM topics LEFT JOIN messages ON lastpost = messageid '.
  32                 'WHERE boardid = @boardid '.
  33                 'GROUP BY topicid '.
  34                 'ORDER BY mtime DESC '.
  35                 'LIMIT ?, ?', array($this->page*$this->tpp, $this->tpp), SO2_PDO::QOBJ);
  36         $topics = $q->fetchAll();
  37
  38         echo
  39         "<table>\n",
  40         '  <col/><col/><col class="num"/><col/>',"\n",
  41         "  <thead>\n",
  42         "    <tr>\n",
  43         '      <th scope="col">Topic</th>',"\n",
  44         '      <th scope="col">Creator</th>',"\n",
  45         '      <th scope="col">Posts</th>',"\n",
  46         '      <th scope="col">Last Post</th>',"\n",
  47         "    </tr>\n",
  48         "  </thead>\n",
  49         "  <tbody>\n";
  50
  51         $a = 1;
  52
  53         foreach ( $topics as $topic ) {
  54             printf(
  55                 '  <tr class="content c%d u%d">'."\n".
  56                 '    <td><a class="topic" href="messagelist?%d">%s</a></td>'."\n".
  57                 "    <td>%s</td>\n".
  58                 "    <td>%d</td>\n".
  59                 "    <td>%s</td>\n".
  60                 "  </tr>\n",
  61                     (++$a&1),
  62                     $topic['topicid'],
  63                     $topic['userid'],
  64                     $topic['topic_title'],
  65                     SO2::$Page->namelink($topic['userid']),
  66                     $topic['posts'],
  67                     SO2::$Page->fdate($topic['mtime'])
  68             );
  69         }
  70         echo "  </tbody>\n</table>\n";
  71     }
  72
  73     public function pagelist()
  74     {
  75         global $boardid; // This is a nasty hack
  76         $list = array();
  77
  78         if ( $this->topicsum < $this->tpp ) {
  79             return null;
  80         }
  81
  82         if ( 0 == $this->tpp ) {
  83             $this->tpp = 5;
  84             trigger_error(__METHOD__.': $tpp was 0, changing to 5 instead', E_USER_WARNING);
  85         }
  86
  87         for ( $i = 0; $i < $this->topicsum; $i += $this->tpp ) {
  88             if ( $i/$this->tpp == $this->page ) {
  89                 $list[] = '<dd class="curpage">['.($i/$this->tpp+1).']</dd>';
  90             } else {
  91                 $rel = ( $i/$this->tpp == $this->page+1
  92                        ? 'next'
  93                        : ( $i/$this->tpp == $this->page-1
  94                          ? 'prev'
  95                          : '' ) );
  96                 $list[] = sprintf('<dd%s><a href="topiclist?board=%d;page=%d;length=%d"%s>%d</a></dd>',
  97                                   ( $rel ? ' class="'.$rel.'"' : '' ),
  98                                   $boardid,
  99                                   ($i/$this->tpp),
 100                                   $this->tpp,
 101                                   ( $rel ? ' rel="'.$rel.'"' : '' ),
 102                                   ($i/$this->tpp+1)
 103                                  );
 104             }
 105         }
 106
 107         return "\n\t".implode("\n\t", $list)."\n";
 108     }
 109 }
 110 ?>