public function getBillboardPosts($target_board = 0, $posts = 5)
{
$crit = new B2DBCriteria();
$crit->addWhere(TBGBillboardPostsTable::SCOPE, TBGContext::getScope()->getID());
$crit->addWhere(TBGBillboardPostsTable::IS_DELETED, 0);
$crit->setLimit($posts);
$crit->addOrderBy(TBGBillboardPostsTable::DATE, 'desc');
if (is_array($target_board)) {
$crit->addWhere(TBGBillboardPostsTable::TARGET_BOARD, $target_board, B2DBCriteria::DB_IN);
} else {
$crit->addWhere(TBGBillboardPostsTable::TARGET_BOARD, $target_board);
}
$posts = array();
$res = B2DB::getTable('TBGBillboardPostsTable')->doSelect($crit);
while ($row = $res->getNextRow()) {
$posts[] = new PublishBillboardPost($row);
}
return $posts;
}
/**
* Perform an SQL update
*
* @param B2DBCriteria $crit
* @param integer $id
*
* @return B2DBResultset
*/
public function doUpdateById(B2DBCriteria $crit, $id)
{
try {
$crit->setFromTable($this);
$crit->addWhere($this->id_column, $id);
$crit->setLimit(1);
$crit->generateUpdateSQL();
$statement = B2DBStatement::getPreparedStatement($crit);
$resultset = $statement->performQuery('update');
} catch (Exception $e) {
if (B2DB::throwExceptionAsHTML()) {
B2DB::fatalError($e);
exit;
} else {
throw $e;
}
}
return $resultset;
}
