/** * Get the current request with PageBrowser limit * * @return string SQL ressource */ public function getListPageBrowser() { $this->conf['records']['pagebrowsernbrecords'] = $this->conf['pageBrowserNbRecords']; $this->conf['records']['nbpages'] = ceil(intval($this->conf['records']['nbrecordsall']) / intval($this->conf['pageBrowserNbRecords'])); $this->conf['records']['offset'] = isset($this->piVars['page']) ? $this->piVars['page'] * $this->conf['pageBrowserNbRecords'] : 0; $this->conf['query']['LIMIT'] = $this->conf['records']['offset'] . ',' . $this->conf['pageBrowserNbRecords']; return tx_t3devapi_database::exec_SELECT_queryArray($this->conf['query'], $this->conf['debug']); }
public function checkPageExist($uid) { $query = array(); $query['SELECT'] = 'uid'; $query['FROM'] = 'pages'; $query['WHERE'] = 'uid=' . intval($uid) . ' AND deleted=0 AND hidden=0'; $res = tx_t3devapi_database::exec_SELECT_queryArray($query); $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res); $GLOBALS['TYPO3_DB']->sql_free_result($res); return empty($row); }