Example #1
1
 public function defshow()
 {
     $this->pageinfo();
     include _APP_PATH . "libs/adodb/adodb-pager1.inc.php";
     $this->result["sites"]["contents"] = "active";
     if ($this->mPur->adminCheck("PW_BLOG", "1") == false) {
         sysMsg("非法授权页面,请与管理员联系");
     }
     $sql = "SELECT post_title,ID,post_date,post_modified,flag FROM wp_posts WHERE post_status='publish' ORDER BY post_modified DESC";
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : $size;
     $pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->pageLinks();
     $pages['frontlink'] = $pager->searchlinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $pagesize;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     $this->result["logs"] = $r["logs"];
     $this->result["pages"] = $r["pages"];
     $this->tplname = 'admin/blog';
     $this->mLog->adminLog("查看博文管理列表");
 }
Example #2
0
 public function getList($table, $where, $size = _PAGES)
 {
     $sql = "SELECT * FROM " . get_table($table);
     if ($where) {
         $sql .= " WHERE " . implode("AND", $where);
     }
     $sql .= "  ORDER BY id DESC";
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : $size;
     $pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->pageLinks();
     $pages['frontlink'] = $pager->searchlinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $pagesize;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     return $r;
 }
 public function PageLogout($row)
 {
     global $sDB, $sRequest, $sUser;
     parent::Page($row);
     $this->handleLogout();
     $this->redirect();
 }
 public function PageManageGroup($row)
 {
     global $sDB, $sRequest, $sQuery, $sUser, $sTemplate;
     parent::Page($row);
     if (!$this->group || !$this->group->groupId() || !$this->group->isAdmin($sUser->getUserId())) {
         header("Location: " . $sTemplate->getRoot());
         exit;
     }
     if ($sRequest->getInt("update_other_settings")) {
         $this->handleUpdateOtherSettings();
     }
     if ($sRequest->getInt("add_users")) {
         $this->handleAddUsers();
     }
     if ($sRequest->getInt("delete_user")) {
         $this->handleDeleteUser();
     }
     if ($sRequest->getInt("change_permissions")) {
         $this->handleChangePermissions();
     }
     if ($sRequest->getInt("delete_group")) {
         $this->handleDeleteGroup();
     }
     if ($sRequest->getInt("update_ownership")) {
         $this->handleChangeOwnership();
     }
 }
Example #5
0
 public function getList()
 {
     $sql = " SELECT t1. * , t2.admin AS username FROM templet t1,admins t2 WHERE t1.uid = t2.id ";
     if ($_GET["ttype"] == "0") {
         $sql .= " AND ttype=0";
     } elseif ($_GET["ttype"]) {
         $sql .= " AND ttype=" . $_GET["ttype"];
     }
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : _PAGES;
     $pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->pageLinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $pagesize;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     return $r;
 }
 public function PageNewCounterArgument($row)
 {
     global $sDB, $sRequest, $sUser;
     parent::Page($row);
     $questionTitle = $sRequest->getString("title");
     $this->question = false;
     $argumentTitle = $sRequest->getString("argument");
     $this->view = VIEW_NEW_COUNTER_ARGUMENT;
     $this->argument = false;
     $this->faction = $sRequest->getInt("faction");
     validateFaction($this->faction);
     $res = $sDB->exec("SELECT * FROM `questions` WHERE `url` = '" . mysql_real_escape_string($questionTitle) . "' LIMIT 1;");
     while ($row = mysql_fetch_object($res)) {
         $this->question = new Question($row->questionId, $row);
     }
     if (!$this->question) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_QUESTION"));
     }
     foreach ($this->question->arguments() as $k => $v) {
         if ($v->urlPlain() == $argumentTitle) {
             $this->argument = $v;
             break;
         }
     }
     if (!$this->argument) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_ARGUMENT"));
     }
     if ($sRequest->getInt("new_counter_argument")) {
         if ($this->handleNewCounterArgument()) {
             header("Location: " . $this->redirectUrl);
             exit;
         }
     }
 }
 public function PageNewArgument($row)
 {
     global $sDB, $sRequest, $sTemplate, $sUser, $sNotify;
     parent::Page($row);
     $questionTitle = $sRequest->getString("title");
     $this->question = false;
     $this->view = VIEW_NEW_ARGUMENT;
     $this->faction = $sRequest->getInt("faction");
     validateFaction($this->faction);
     $res = $sDB->exec("SELECT * FROM `questions` WHERE `url` = '" . mysql_real_escape_string($questionTitle) . "' LIMIT 1;");
     while ($row = mysql_fetch_object($res)) {
         $this->question = new Question($row->questionId, $row);
     }
     if (!$this->question) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_QUESTION"));
     }
     if ($sRequest->getInt("new_argument")) {
         $argumentId = $this->handleNewArgument();
         if ($argumentId) {
             $argument = new Argument($argumentId);
             $sNotify->notifyNewArgument($this->question, $argument);
             $sUser->follow($this->question->questionId());
             header("Location: " . $this->redirectUrl);
             exit;
         }
     }
 }
Example #8
0
 public function getList($size = _PAGES)
 {
     $sql = "SELECT * FROM " . get_table("asks");
     if ($_GET["title"]) {
         $sqlv[] = " (title LIKE '%" . $_GET["title"] . "%') ";
     }
     if ($sqlv) {
         $sql .= " WHERE " . implode("AND", $sqlv);
     }
     //$sql .="  ORDER BY $order";
     //echo $sql;
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : $size;
     $pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->pageLinks();
     $pages['frontlink'] = $pager->searchlinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $pagesize;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     return $r;
 }
 public function PageEditQuestion($row)
 {
     global $sDB, $sRequest, $sQuery, $sUser, $sTemplate, $sSession;
     parent::Page($row);
     $this->view = VIEW_NEW_QUESTION;
     $questionTitle = $sRequest->getString("title");
     $this->question = false;
     $res = $sDB->exec("SELECT * FROM `questions` WHERE `url` = '" . mysql_real_escape_string($questionTitle) . "' LIMIT 1;");
     while ($row = mysql_fetch_object($res)) {
         $this->question = new Question($row->questionId, $row);
     }
     if (!$this->question || $this->question->authorId() != $sUser->getUserId()) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_QUESTION"));
     }
     if (!$this->question->canEdit($sUser)) {
         $sSession->setVal('notification', $sTemplate->getString("QUESTION_EDIT_EXCEEDED"));
         $sSession->serialize();
         header("Location: " . $this->question->url());
         exit;
     }
     if ($sRequest->getInt("edit_question")) {
         if ($this->handleEditQuestion()) {
             header("Location: " . $this->redirectUrl);
             exit;
         }
     }
 }
 public function PageManageProfile($row)
 {
     global $sDB, $sRequest, $sQuery, $sUser;
     parent::Page($row);
     if ($sRequest->getInt("updateProfile")) {
         $this->updateProfile();
     }
 }
 public function PageSponsors($row)
 {
     global $sDB, $sRequest, $sQuery, $sTemplate, $sUser;
     parent::Page($row);
     $this->page = $sRequest->getInt("page");
     $this->numPages = -1;
     $this->sponsors = false;
 }
 function StoolballPage(SiteSettings $o_settings, $i_permission_required, $obsolete = false)
 {
     $this->i_constraint_type = StoolballPage::ConstrainNone();
     if (!SiteContext::IsDevelopment()) {
         $this->css_root = 'https://www.stoolball.org.uk';
         $this->resource_root = 'https://www.stoolball.org.uk';
     }
     parent::Page($o_settings, $i_permission_required);
 }
Example #13
0
 function SmartyPage()
 {
     parent::Page();
     $this->_smarty =& new Smarty();
     $this->_smarty->template_dir = APPLICATION_HOME . '/Templates';
     $this->_smarty->compile_dir = APPLICATION_HOME . '/Templates_c';
     $this->_smarty->use_sub_dirs = true;
     $this->setTempalte($this->getName() . '.tpl');
 }
Example #14
0
 function kibopage()
 {
     parent::Page();
     $this->forms = array();
     $this->box = array();
     $this->userdata = array();
     $this->backtracking = new kibo_backtracking($this->session);
     $this->version = TIC_VERSION;
     $this->template->assign('version', TIC_VERSION . " " . TIC_COPYRIGHT);
 }
Example #15
0
 function kibopage()
 {
     parent::Page();
     $this->forms = array();
     $this->box = array();
     $this->userdata = array();
     $this->backtracking = new kibo_backtracking($this->session);
     $this->version = "TIC 1.6b , Copyright by Huhn 2004,2005";
     $this->template->assign('version', $this->version);
 }
 public function PageNewSponsor($row)
 {
     global $sDB, $sRequest, $sQuery, $sTemplate, $sUser;
     parent::Page($row);
     if ($sRequest->getInt("new_sponsor")) {
         if ($this->handleNewSponsor()) {
             header("Location: " . $sTemplate->getRoot());
             exit;
         }
     }
 }
 public function PageProfile($row)
 {
     global $sDB, $sRequest, $sQuery, $sTemplate, $sUser;
     parent::Page($row);
     $this->userId = $sRequest->getInt("userId");
     $this->user = $sQuery->getUser("userId=" . $this->userId);
     if (!$this->user) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_PROFILE"));
     }
     $this->setShortUrl($this->user->shortUrl());
 }
Example #18
0
 public function PageNewQuestion($row)
 {
     global $sDB, $sRequest, $sQuery, $sUser;
     parent::Page($row);
     $this->view = VIEW_NEW_QUESTION;
     if ($sRequest->getInt("new_question")) {
         if ($this->handleNewQuestion()) {
             header("Location: " . $this->redirectUrl);
             exit;
         }
     }
 }
 public function PageNewGroup($row)
 {
     global $sDB, $sRequest, $sUser;
     parent::Page($row);
     $this->view = VIEW_NEW_GROUP;
     if ($sRequest->getInt("new_group")) {
         if ($this->handleNewGroup()) {
             header("Location: " . $this->redirectUrl);
             exit;
         }
     }
 }
Example #20
0
 public function getList($cateid, $size = _PAGES)
 {
     $sql = "SELECT * FROM " . get_table("cases");
     if ($_GET["title"]) {
         $sqlv[] = " (title LIKE '%" . $_GET["title"] . "%') ";
     }
     if ($_GET["keyword"]) {
         $sqlv[] = " (cprodname LIKE '%" . $_GET["keyword"] . "%' OR eprodname LIKE '%" . $_GET["keyword"] . "%' OR jprodname LIKE '%" . $_GET["keyword"] . "%') ";
     }
     if ($_GET["sku"]) {
         $sqlv[] = " sku LIKE '" . $_GET["sku"] . "%' ";
     }
     if ($_GET["quantity"]) {
         $sqlv[] = " quantity = '" . $_GET["quantity"] . "%' ";
     }
     if ($_GET["status"] || $_GET["status"] == '0') {
         $sqlv[] = " status = '" . $_GET["status"] . "' ";
     }
     if ($_GET["is_best"] || $_GET["is_best"] == '0') {
         $sqlv[] = " is_best = '" . $_GET["is_best"] . "' ";
     }
     if ($cateid) {
         if (is_array($cateid)) {
             $cateid = implode(",", $cateid);
         }
         $sqlv[] = " class_id IN ({$cateid})";
     }
     if ($sqlv) {
         $sql .= " WHERE " . implode("AND", $sqlv);
     }
     //$sql .="  ORDER BY $order";
     //echo $sql;
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : $size;
     $pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->pageLinks();
     $pages['frontlink'] = $pager->searchlinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $pagesize;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     return $r;
 }
Example #21
0
 public function PageSignup($row)
 {
     global $sDB, $sRequest, $sUser;
     parent::Page($row);
     $this->view = VIEW_SIGNUP;
     if ($sRequest->getInt("login")) {
         $this->handleLogin();
     } else {
         if ($sRequest->getInt("signup")) {
             $this->handleSignup();
         }
     }
     if ($sRequest->getInt("passRequest")) {
         $this->handlePassRequest();
     }
 }
 public function PageEditCounterArgument($row)
 {
     global $sDB, $sRequest, $sTemplate, $sUser, $sSession;
     parent::Page($row);
     $questionTitle = $sRequest->getString("title");
     $this->question = false;
     $this->argument = false;
     $this->counterArgument = false;
     $this->view = VIEW_EDIT_COUNTER_ARGUMENT;
     $argumentTitle = $sRequest->getString("argument");
     $counterArgumentTitle = $sRequest->getString("counterArgument");
     $res = $sDB->exec("SELECT * FROM `questions` WHERE `url` = '" . mysql_real_escape_string($questionTitle) . "' LIMIT 1;");
     while ($row = mysql_fetch_object($res)) {
         $this->question = new Question($row->questionId, $row);
     }
     if (!$this->question) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_QUESTION"));
     }
     foreach ($this->question->arguments() as $k => $v) {
         if ($v->urlPlain() == $argumentTitle) {
             $this->argument = $v;
         }
         foreach ($v->arguments() as $k1 => $v1) {
             if ($v1->urlPlain() == $counterArgumentTitle) {
                 $this->counterArgument = $v1;
                 break;
             }
         }
     }
     if (!$this->argument || !$this->counterArgument) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_ARGUMENT"));
     }
     if (!$this->counterArgument->canEdit($sUser)) {
         $sSession->setVal('notification', $sTemplate->getString("ARGUMENT_EDIT_EXCEEDED"));
         $sSession->serialize();
         header("Location: " . $this->question->url());
         exit;
     }
     if ($sRequest->getInt("edit_counter_argument")) {
         if ($this->handleEditCounterArgument()) {
             header("Location: " . $this->redirectUrl);
             exit;
         }
     }
 }
 public function PageQuestion($row)
 {
     global $sDB, $sRequest, $sStatistics, $sUser, $sTemplate;
     parent::Page($row);
     $questionTitle = $sRequest->getString("title");
     $this->question = false;
     $this->view = $sRequest->getInt("view");
     $res = $sDB->exec("SELECT * FROM `questions` WHERE `url` = '" . mysql_real_escape_string($questionTitle) . "' LIMIT 1;");
     while ($row = mysql_fetch_object($res)) {
         $this->question = new Question($row->questionId, $row);
     }
     if (!$this->question) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_QUESTION"));
     }
     if ($sRequest->getInt("vote_select")) {
         if ($this->question->group() && $this->question->group()->getPermission($sUser, ACTION_VOTE) == PERMISSION_DISALLOWED) {
         } else {
             $vote = $sRequest->getInt("vote");
             $questionId = $sRequest->getInt("questionId");
             $argumentId = $sRequest->getInt("argumentId");
             $sStatistics->vote($this->question, $argumentId, $vote);
             //header("Location: ".$this->question->url()."#argument_wrapper_".$questionId."_".$argumentId);
             header("Location: " . $this->question->url());
             exit;
         }
     }
     if ($this->view == VIEW_DETAILS) {
         $this->setShortUrl($this->question->shortUrlDetails());
     } else {
         $this->setShortUrl($this->question->shortUrl());
     }
     if ($sRequest->getInt("faction_select") && ($sUser->isLoggedIn() || $this->question->hasFlag(QUESTION_FLAG_PART_ALL))) {
         if ($this->question->group() && $this->question->group()->getPermission($sUser, ACTION_VOTE) == PERMISSION_DISALLOWED) {
         } else {
             $faction = $sRequest->getInt("faction");
             validateFaction($faction);
             $sUser->setFactionByQuestionId($this->question->questionId(), $faction);
             $sStatistics->updateQuestionStats($this->question->questionId());
             header("Location: " . $this->question->url());
             exit;
         }
     }
 }
Example #24
0
 public function getList()
 {
     $sql = " SELECT t1.*,t2.admin AS username FROM reports t1, admins t2 WHERE t1.uid =t2.id ORDER BY id DESC";
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pager->Page($key = '', $size = _PAGE_SIZE, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->searchlinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $size;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     return $r;
 }
 public function PageCounterArgumentFull($row)
 {
     global $sDB, $sRequest, $sStatistics, $sTemplate, $sUser;
     parent::Page($row);
     $questionTitle = $sRequest->getString("title");
     $this->question = false;
     $this->view = VIEW_ARGUMENT;
     $argumentTitle = $sRequest->getString("counterArgument");
     $this->argument = false;
     $res = $sDB->exec("SELECT * FROM `questions` WHERE `url` = '" . mysql_real_escape_string($questionTitle) . "' LIMIT 1;");
     while ($row = mysql_fetch_object($res)) {
         $this->question = new Question($row->questionId, $row);
     }
     if (!$this->question) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_ARGUMENT"));
     }
     foreach ($this->question->arguments() as $k => $v) {
         foreach ($v->arguments() as $k1 => $v1) {
             if ($v1->urlPlain() == $argumentTitle) {
                 $this->argument = $v1;
                 break;
             }
         }
         if ($this->argument) {
             break;
         }
     }
     if (!$this->argument) {
         $sTemplate->error($sTemplate->getString("ERROR_INVALID_ARGUMENT"));
     }
     if ($sRequest->getInt("vote_select")) {
         if ($this->question->group() && $this->question->group()->getPermission($sUser, ACTION_VOTE) == PERMISSION_DISALLOWED) {
         } else {
             $vote = $sRequest->getInt("vote");
             $questionId = $sRequest->getInt("questionId");
             $argumentId = $sRequest->getInt("argumentId");
             $sStatistics->vote($this->question, $argumentId, $vote);
             header("Location: " . $this->argument->url($this->question->url()));
             exit;
         }
     }
     $this->setShortUrl($this->argument->shortUrl());
 }
Example #26
0
 public function getList()
 {
     $sql = "SELECT * FROM " . get_table("admins");
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : _PAGES;
     $pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->pageLinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $pagesize;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     return $r;
 }
Example #27
0
 public function getListByUid($uid, $size = _PAGES)
 {
     $sql = "SELECT * FROM " . get_table("events") . " WHERE uid={$uid}  ORDER BY id DESC";
     //echo $sql;
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : $size;
     $pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->pageLinks();
     $pages['frontlink'] = $pager->searchlinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $pagesize;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     return $r;
 }
Example #28
0
 public function getList()
 {
     $sql = "SELECT * FROM " . get_table("logs");
     if (!empty($_GET["stime"])) {
         $w[] = "addtime >= '" . $_GET["stime"] . " 00:00:00'";
     }
     if (!empty($_GET["etime"])) {
         $w[] = "addtime <= '" . $_GET["etime"] . " 23:59:59'";
     }
     if (!empty($_GET["utype"])) {
         $w[] = "utype = '" . $_GET["utype"] . "'";
     }
     if (!empty($_GET["uname"])) {
         $w[] = "uname like '" . $_GET["uname"] . "'";
     }
     if ($w) {
         $sql .= " WHERE ";
         if (is_array($w)) {
             $sql .= implode(" AND ", $w);
         }
     }
     $sql .= " ORDER BY id DESC";
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : _PAGES;
     $pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->pageLinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $pagesize;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     return $r;
 }
 public function PageDefault($row)
 {
     global $sDB, $sRequest, $sStatistics, $sUser, $sTemplate;
     parent::Page($row);
     $this->page = $sRequest->getInt("page");
     $this->numPages = -1;
     $this->tags = array();
     $this->sort = SORT_TRENDING;
     if ($this->group && $this->group->groupId() && $this->group->getPermission($sUser, ACTION_VIEW_GROUP) == PERMISSION_DISALLOWED) {
         header("Location: " . $sTemplate->getRoot());
         exit;
     }
     if (in_array($sRequest->getInt("sort"), array(SORT_TRENDING, SORT_TOP, SORT_NEWEST))) {
         $this->sort = $sRequest->getInt("sort");
     }
     $tags = $sRequest->getStringPlain("tags");
     if ($tags != "") {
         $tags2 = explode(" ", $tags);
         foreach ($tags2 as $k => $v) {
             array_push($this->tags, $v);
         }
     }
     if ($sRequest->getInt("vote_select")) {
         $vote = $sRequest->getInt("vote");
         $questionId = $sRequest->getInt("questionId");
         $argumentId = $sRequest->getInt("argumentId");
         $sStatistics->vote(new Question($questionId), $argumentId, $vote);
         //header("Location: ".$sTemplate->getRoot()."#question_".$questionId);
         header("Location: " . $this->basePath() . ($this->getPage() != 0 ? $this->getPage() . "/" : ""));
         exit;
     }
     $this->questions = array();
     $res = $sDB->exec($this->buildQuery());
     while ($row = mysql_fetch_object($res)) {
         $q = new Question($row->questionId, $row);
         array_push($this->questions, $q);
     }
 }
Example #30
0
 public function getList($classid, $t, $lang, $size = 30)
 {
     if ($_GET["auditing"]) {
         $t = $_GET["auditing"];
     }
     $sql = "SELECT * FROM " . get_table("goods") . " ORDER BY id DESC";
     $pager = new Page();
     $get_page = is_numeric($_GET["page"]) ? $get_page : 1;
     $pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : _PAGES;
     $pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
     $pager->execute($this->mDb, $sql);
     $pages['link'] = $pager->pageLinks();
     $pages['fromto'] = $pager->fromto();
     $pages['total'] = $pager->getTotalpage();
     $pages['current'] = $pager->getCurrent();
     $pages['totalnum'] = $pager->getTotalnum();
     $pages['jump'] = $pager->jump();
     $pages['pagenum'] = $pagesize;
     $rs = $pager->getResult();
     $r["logs"] = $rs;
     $r["pages"] = $pages;
     return $r;
 }