429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
|
$db = DB::getInstance();
return $db->get('SELECT *,
strftime(\'%s\', date_creation) AS date_creation,
strftime(\'%s\', date_modification) AS date_modification
FROM wiki_pages
WHERE '.$this->_getLectureClause().'
ORDER BY date_modification DESC;');
}
public function countRecentModifications()
{
$db = DB::getInstance();
return $db->firstColumn('SELECT COUNT(*) FROM wiki_pages WHERE '.$this->_getLectureClause().';');
}
|
|
>
|
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
|
$db = DB::getInstance();
return $db->get('SELECT *,
strftime(\'%s\', date_creation) AS date_creation,
strftime(\'%s\', date_modification) AS date_modification
FROM wiki_pages
WHERE '.$this->_getLectureClause().'
ORDER BY date_modification DESC
LIMIT ?,?;', $begin, self::ITEMS_PER_PAGE);
}
public function countRecentModifications()
{
$db = DB::getInstance();
return $db->firstColumn('SELECT COUNT(*) FROM wiki_pages WHERE '.$this->_getLectureClause().';');
}
|