PHP XDB::result_first方法代码示例

 public function count_by_wherec($condition)
 {
     if (is_array($condition)) {
         $where = " AND " . implode($condition, ' AND ');
     }
     return XDB::result_first("SELECT COUNT(*) FROM %t WHERE 1 %i", array($this->_table, $where));
 }

 public function count_by_fid($fids)
 {
     if (empty($fids)) {
         return 0;
     }
     return XDB::result_first('SELECT COUNT(*) FROM %t WHERE ' . XDB::field('fid', $fids), array($this->_table));
 }

 public function fetch_groupnum_by_founderuid($uid)
 {
     if (empty($uid)) {
         return false;
     }
     return XDB::result_first("SELECT COUNT(*) FROM " . XDB::table($this->_table) . " WHERE founderuid=%d", array($uid));
 }

 public function fetch_all_username_by_uid($uid)
 {
     $user = '';
     if ($uid) {
         $user = XDB::result_first('SELECT username FROM %t WHERE uid=%s', array($this->_table, $uid));
     }
     return $user;
 }

 public function fetch_count()
 {
     return XDB::result_first("SELECT count(*) FROM " . XDB::table('forum_grouplevel'));
 }

 public function check_variable($pluginid, $variable)
 {
     return XDB::result_first("SELECT COUNT(*) FROM %t WHERE pluginid=%d AND variable=%s", array($this->_table, $pluginid, $variable));
 }

 public function result_level_by_id($id)
 {
     return XDB::result_first("SELECT level FROM %t WHERE id=%d", array($this->_table, $id));
 }

 public function fetch_groupname_by_order($order)
 {
     return XDB::result_first("SELECT groupname FROM %t WHERE `order` = %d ", array($this->_table, $order));
 }

 public function fetch_all_for_grouplist($orderby = 'displayorder', $fieldarray = array(), $num = 1, $fids = array(), $sort = 0, $getcount = 0)
 {
     if ($fieldarray && is_array($fieldarray)) {
         $fieldadd = '';
         foreach ($fieldarray as $field) {
             $fieldadd .= $field . ', ';
         }
     } else {
         $fieldadd = 'ff.*, ';
     }
     $start = 0;
     if (is_array($num)) {
         list($start, $snum) = $num;
     } else {
         $snum = $num;
     }
     $orderbyarray = array('displayorder' => 'f.displayorder DESC', 'dateline' => 'ff.dateline DESC', 'lastupdate' => 'ff.lastupdate DESC', 'membernum' => 'ff.membernum DESC', 'thread' => 'f.threads DESC', 'activity' => 'f.commoncredits DESC');
     $useindex = $orderby == 'displayorder' ? 'USE INDEX(fup_type)' : '';
     $orderby = !empty($orderby) && $orderbyarray[$orderby] ? "ORDER BY " . $orderbyarray[$orderby] : '';
     $limitsql = $num ? "LIMIT {$start}, {$snum} " : '';
     $field = $sort ? 'fup' : 'fid';
     $fids = $fids && is_array($fids) ? 'f.' . $field . ' IN (' . dimplode($fids) . ')' : '';
     if (empty($fids)) {
         $levelsql = " AND f.level>'-1'";
     }
     $fieldsql = $fieldadd . ' f.fid, f.name, f.threads, f.posts, f.todayposts, f.level as flevel ';
     if ($getcount) {
         return XDB::result_first("SELECT count(*) FROM " . XDB::table($this->_table) . " f {$useindex} WHERE" . ($fids ? " {$fids} AND " : '') . " f.type='sub' AND f.status=3 {$levelsql}");
     }
     return XDB::fetch_all("SELECT {$fieldsql} FROM " . XDB::table($this->_table) . " f {$useindex} LEFT JOIN " . XDB::table("forum_forumfield") . " ff ON ff.fid=f.fid WHERE" . ($fids ? " {$fids} AND " : '') . " f.type='sub' AND f.status=3 {$levelsql} {$orderby} {$limitsql}");
 }

 public function get_total_filesize()
 {
     $attachsize = 0;
     for ($i = 0; $i < 10; $i++) {
         $attachsize += XDB::result_first("SELECT SUM(filesize) FROM " . XDB::table('forum_attachment_' . $i));
     }
     return $attachsize;
 }

 public function fetch_by_modename($modename, $bid)
 {
     return XDB::result_first("SELECT %i FROM %t WHERE bid='%i'", array($modename, $this->_table, $bid));
 }

 public function count_by_id_idtype($id, $idtype)
 {
     return XDB::result_first("SELECT COUNT(*) FROM %t WHERE id=%d AND idtype=%s", array($this->_table, $id, $idtype));
 }

 public function getid_by_keyword($keyword)
 {
     return XDB::result_first("SELECT id FROM %t WHERE keyword=%s", array($this->_table, $keyword));
 }

 public function fetch_max_tid()
 {
     return XDB::result_first("SELECT MAX(tid) as maxtid FROM " . XDB::table('forum_thread'));
 }

 public function count_by_tid_post($tableid, $tid)
 {
     return XDB::result_first('SELECT COUNT(*) FROM %t WHERE tid=%d AND invisible=0 AND first=0', array(self::get_tablename($tableid), $tid));
 }