function digest($uid, $digest, $start = 0, $limit = 0, $tableid = 0, $digestglue = '>=', $displayorder = 0, $glue = '>=')
{
$thread_obj = C::t('forum_thread');
$parameter = array($thread_obj->get_table_name($tableid), $digest, $displayorder);
$digestglue = helper_util::check_glue($digestglue);
$glue = helper_util::check_glue($glue);
if ($uid) {
$where = 'authorid=' . $uid . ' AND ';
}
$data = DB::fetch_all("SELECT * FROM %t WHERE " . $where . " digest{$digestglue}%d AND displayorder{$glue}%d" . DB::limit($start, $limit), $parameter, 'tid');
$data[count] = DB::result_first("SELECT count(*) FROM %t WHERE " . $where . " digest{$digestglue}%d AND displayorder{$glue}%d", $parameter, 'tid');
return $data;
}
public function fetch_all_by_available_icon($available = null, $haveicon = false, $glue = '=', $order = 'displayorder', $sort = 'ASC')
{
$parameter = array($this->_table);
if ($available !== null) {
$parameter[] = $available;
$glue = helper_util::check_glue($glue);
$wherearr[] = "available{$glue}%d";
}
if ($haveicon) {
$wherearr[] = "icon!=''";
}
$wheresql = !empty($wherearr) && is_array($wherearr) ? ' WHERE ' . implode(' AND ', $wherearr) : '';
$ordersql = !empty($order) ? ' ORDER BY ' . DB::order($order, $sort) : '';
return DB::fetch_all("SELECT * FROM %t {$wheresql} {$ordersql}", $parameter, $this->_pk);
}
public function count_by_fid_typeid_displayorder($fid, $typeid = null, $displayorder = null, $glue = '=')
{
$parameter = array($this->get_table_name(), $fid);
$wherearr = array();
$fid = dintval($fid, true);
$wherearr[] = is_array($fid) ? 'fid IN(%n)' : 'fid=%d';
if ($typeid) {
$parameter[] = $typeid;
$wherearr[] = "typeid=%d";
}
if ($displayorder !== null) {
$parameter[] = $displayorder;
$glue = helper_util::check_glue($glue);
$wherearr[] = "displayorder{$glue}%d";
}
$wheresql = !empty($wherearr) && is_array($wherearr) ? ' WHERE ' . implode(' AND ', $wherearr) : '';
return DB::result_first("SELECT COUNT(*) FROM %t {$wheresql}", $parameter);
}
public function fetch_all_by_flag($flag, $glue = '=', $sort = 'ASC')
{
$glue = helper_util::check_glue($glue);
return DB::fetch_all("SELECT * FROM %t WHERE flag{$glue}%d ORDER BY " . DB::order('displayorder', $sort), array($this->_table, $flag), $this->_pk);
}
public function fetch_all_by_dateline($dateline, $glue = '>=')
{
$glue = helper_util::check_glue($glue);
return DB::fetch_all("SELECT * FROM %t WHERE dateline{$glue}%d ORDER BY dateline", array($this->_table, $dateline), $this->_pk);
}
