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); }