Ejemplo n.º 1
0
    if ($db->forum_group > $acl->group) {
        throw new Exception("Access denied");
    }
    echo "<span style='float:left; font-weight: normal;'><h2>" . $db->forum_name . "</h2></span>";
    $this->setTitle($db->forum_name);
    $db = new DB("forum_topics");
    $db->setColPrefix("topic_");
    $db->join("left", "{PREFIX}forum_posts", "post_topic", "topic_id");
    $db->setSort("topic_sticky DESC, post_added DESC");
    $db->select("topic_forum = '" . $db->escape($id) . "' GROUP BY post_topic");
    $perpage = 40;
    $pager = new Pager();
    $pager->perpage = $perpage;
    $pager->count = $db->numRows();
    $pager->href = array("forums", "view-forum", $arg);
    $pager->build();
    echo $pager->pager_top;
    ?>
    <br />
    <a href="<?php 
    echo page("forums", "create-topic", "", "", "", "forum=" . $id);
    ?>
" style="float:right;"><span class="btn"><?php 
    echo _t("Create new topic");
    ?>
</span></a>
    <br /><br />
    <table width="100%" cellpadding="5" cellspacing="0" class="forum">
        <thead>
            <tr>
                <td width="46px" class=""></td>
Ejemplo n.º 2
0
 function search($page = 1, $searchQuery = null, $sort = "id")
 {
     $m = $this->model;
     $temp = new $m();
     $searchQueryParsed = Options::parse($searchQuery);
     $where = array();
     $queryData = new stdClass();
     foreach ($searchQueryParsed as $key => $value) {
         if (APP_USE_LANGUAGE) {
             if ($value != "" && $value != null) {
                 if (isset($m->{$key})) {
                     $where[] = $temp->__table__ . ".{$key} LIKE \"%{$value}%\"";
                 } else {
                     $where[] = $temp->__table__ . ".{$key}_{$this->application->language} LIKE \"%{$value}%\"";
                 }
             }
         } else {
             if ($value != "" && $value != null) {
                 $where[] = $temp->__table__ . ".{$key} LIKE \"%{$value}%\"";
             }
         }
         $queryData->{$key} = $value;
     }
     $query = array();
     //if($this->order!=null) $query["order"] = $this->order;
     if ($sort != null) {
         $query["order"] = "{$temp->__table__}.{$sort}";
     }
     $query["group"] = $temp->__table__ . ".id";
     $query["limit"] = ($page - 1) * $this->perPage . "," . $this->perPage;
     $query["founds"] = true;
     if (count($where) > 0) {
         $query["where"] = implode(" AND ", $where);
     }
     /*
     if($condition!=null){
     	$query["where"] = $condition;
     }
     */
     $this->data["objects"] = Collection::load($this->model, $query, $total);
     $order = new stdClass();
     foreach ($this->orderFields as $key) {
         $order->{$key} = $key;
         $sym = $key . "symbol";
         $order->{$sym} = "[asc]";
         if ($key == $sort) {
             $order->{$key} .= " desc";
             $order->{$sym} = "[desc]";
         }
     }
     $this->data["order"] = $order;
     import("data.Pager");
     $page = max($page, 1);
     unset($this->data["objects"]["founds"]);
     $pager = new Pager($total, $this->perPage);
     $pager->to = "{$this->controller}/search/{page}/{$searchQuery}";
     $this->data["pager"] = $pager->build($page);
     $this->data["querydata"] = $queryData;
     $this->data["uri"] = linkForm("/{$this->controller}/search/{$page}/{$searchQuery}");
     $this->setView("{$this->folder}/{$this->subView}", $this->data);
 }