function LoadFromDB() { $s = new BM_query(); $s->AddField("message"); $s->AddField("addedDate"); $s->AddTable("oneliner"); $s->attach(array("oneliner"=>"who"),array("users as user"=>"id")); //$s->AddOrder("oneliner.addedDate desc, oneliner.id desc"); $s->AddOrder("oneliner.id desc"); $s->SetLimit(POUET_CACHE_MAX); $this->data = $s->perform(); $this->data = array_reverse($this->data); }
function LoadFromDB() { $s = new BM_query(); $s->AddField("bbs_topics.id as id"); $s->AddField("bbs_topics.topic as topic"); $s->AddField("bbs_topics.count as count"); $s->AddField("bbs_topics.category as category"); $s->AddField("bbs_topics.lastpost as lastpost"); $s->AddField("bbs_topics.closed as closed"); $s->AddTable("bbs_topics"); $s->attach(array("bbs_topics"=>"userfirstpost"),array("users as firstuser"=>"id")); $s->attach(array("bbs_topics"=>"userlastpost"),array("users as lastuser"=>"id")); $s->AddOrder("lastpost desc"); $s->SetLimit(POUET_CACHE_MAX); $this->data = $s->perform(); }
function LoadFromDB() { $s = new SQLSelect(); $perPage = get_setting("bbsbbstopics"); $this->page = (int)max( 1, (int)$_GET["page"] ); $s = new BM_query(); $s->AddField("bbs_topics.id as id"); $s->AddField("bbs_topics.lastpost as lastpost"); $s->AddField("bbs_topics.firstpost as firstpost"); $s->AddField("bbs_topics.topic as topic"); $s->AddField("bbs_topics.count as count"); $s->AddField("bbs_topics.category as category"); $s->AddTable("bbs_topics"); $s->attach(array("bbs_topics"=>"userfirstpost"),array("users as firstuser"=>"id")); $s->attach(array("bbs_topics"=>"userlastpost"),array("users as lastuser"=>"id")); $dir = "DESC"; if ($_GET["reverse"]) $dir = "ASC"; switch($_GET["order"]) { case "firstpost": $s->AddOrder("bbs_topics.firstpost ".$dir); break; case "userfirstpost": $s->AddOrder("bbs_topics_firstuser.nickname ".$dir); break; case "userlastpost": $s->AddOrder("bbs_topics_lastuser.nickname ".$dir); break; case "topic": $s->AddOrder("bbs_topics.topic ".$dir); break; case "category": $s->AddOrder("bbs_topics.category ".$dir); break; case "count": $s->AddOrder("bbs_topics.count ".$dir); break; case "lastpost": default: $s->AddOrder("bbs_topics.lastpost ".$dir); break; } $s->AddOrder("bbs_topics.lastpost ".$dir); $s->SetLimit( $perPage, (int)(($this->page - 1) * $perPage) ); if ($_GET["category"]) $s->AddWhere(sprintf_esc("category='%s'",$_GET["category"])); //echo $s->GetQuery(); $this->topics = $s->performWithCalcRows( $this->count ); //PouetCollectPlatforms($this->prods); //$this->maxtopics = SQLLib::SelectRow("SELECT MAX(views) as m FROM prods")->m; }