public function fetch_by_id_idtype($id, $idtype, $uid = 0)
{
if ($uid) {
$uidsql = ' AND ' . XDB::field('uid', $uid);
}
return XDB::fetch_first("SELECT * FROM %t WHERE id=%d AND idtype=%s {$uidsql}", array($this->_table, $id, $idtype));
}
public function fetch_userinfo($uid, $fid)
{
if (empty($uid) || empty($fid)) {
return array();
}
return XDB::fetch_first("SELECT * FROM %t WHERE fid=%d AND uid=%d", array($this->_table, $fid, $uid));
}
public function fetch_by_username($username)
{
$user = array();
if ($username) {
$user = XDB::fetch_first('SELECT * FROM %t WHERE username=%s', array($this->_table, $username));
}
return $user;
}
public function check_moderator_for_uid($fid, $uid, $accessmasks = 0)
{
if (!intval($fid) || !intval($uid)) {
return false;
}
if ($accessmasks) {
$accessadd1 = ', a.allowview, a.allowpost, a.allowreply, a.allowgetattach, a.allowgetimage, a.allowpostattach';
$accessadd2 = "LEFT JOIN " . XDB::table('forum_access') . " a ON a." . XDB::field('uid', $uid) . " AND a." . XDB::field('fid', $fid);
}
return XDB::fetch_first("SELECT ff.postperm, m.uid AS istargetmod {$accessadd1}\n\t\t\t\tFROM " . XDB::table($this->_table) . " ff\n\t\t\t\t{$accessadd2}\n\t\t\t\tLEFT JOIN " . XDB::table('forum_moderator') . " m ON m.fid=%d AND m.uid=%d\n\t\t\t\tWHERE ff.fid=%d", array($fid, $uid, $fid));
}
public function fetch($id, $force_from_db = false)
{
$data = array();
if (!empty($id)) {
if ($force_from_db || ($data = $this->fetch_cache($id)) === false) {
$data = XDB::fetch_first('SELECT * FROM ' . XDB::table($this->_table) . ' WHERE ' . XDB::field($this->_pk, $id));
if (!empty($data)) {
$this->store_cache($id, $data);
}
}
}
return $data;
}
public function fetch_by_bid($bid)
{
return XDB::fetch_first("SELECT * FROM %t WHERE bid='%i'", array($this->_table, $bid));
}
public function get_by_cateidanduid($uid, $cateid)
{
return XDB::fetch_first("SELECT * FROM %t where uid=%d,cateid=%d", array($this->_table, $uid, $cateid));
}
public function get_by_id($helpid)
{
return XDB::fetch_first("SELECT * FROM %t WHERE flid=%d", array($this->_table, $helpid));
}
public function get_by_diystyleid($diystyleid)
{
return XDB::fetch_first("SELECT * FROM %t WHERE diystyleid=%d", array($this->_table, $diystyleid));
}
public function fetch_by_credits($credits = 0)
{
return XDB::fetch_first("SELECT * FROM %t WHERE creditshigher<=%d AND %d<creditslower LIMIT 1", array($this->_table, $credits, $credits));
}
public function show_table_by_tableid($tableid)
{
return XDB::fetch_first('SHOW CREATE TABLE %t', array(self::get_tablename($tableid)));
}
public function fetch_max_image($tableid, $idtype, $id)
{
return $this->_check_id($idtype, $id) ? XDB::fetch_first('SELECT * FROM %t WHERE %i AND isimage IN (1, -1) ORDER BY width DESC LIMIT 1', array($this->_get_table($tableid), XDB::field($idtype, $id))) : array();
}
public function fetch_mfandtag_by_groupid($groupid)
{
return XDB::fetch_first("SELECT ismf,istag FROM %t WHERE groupid=%d", array($this->_table, $groupid));
}
public function fetch_all()
{
return XDB::fetch_first("SELECT * FROM %t ", array($this->_table));
}
function get_forum_by_fid($fid, $field = '', $table = 'forum')
{
static $forumlist = array('forum' => array(), 'forumfield' => array());
$table = $table != 'forum' ? 'forumfield' : 'forum';
$return = array();
if (!array_key_exists($fid, $forumlist[$table])) {
$forumlist[$table][$fid] = XDB::fetch_first("SELECT * FROM " . XDB::table('forum_' . $table) . " WHERE fid=%d", array($fid));
if (!is_array($forumlist[$table][$fid])) {
$forumlist[$table][$fid] = array();
}
}
if (!empty($field)) {
$return = isset($forumlist[$table][$fid][$field]) ? $forumlist[$table][$fid][$field] : null;
} else {
$return = $forumlist[$table][$fid];
}
return $return;
}
public function fetch_by_tid_magicid($tid, $magicid = 0)
{
return XDB::fetch_first('SELECT * FROM %t WHERE tid=%d AND magicid=%d', array($this->_table, $tid, $magicid));
}
public function userget_by_albumid($albumid, $uid)
{
return XDB::fetch_first("SELECT * FROM %t\n\t\tWHERE albumid=%d AND uid=%d order by displayorder", array($this->_table, $albumid, $uid));
}
function gettablestatus($tableid = 0)
{
$table_info = XDB::fetch_first("SHOW TABLE STATUS LIKE '" . str_replace('_', '\\_', XDB::table($this->get_table_name($tableid))) . "'");
$table_info['Data_length'] = $table_info['Data_length'] / 1024 / 1024;
$nums = intval(log($table_info['Data_length']) / log(10));
$digits = 0;
if ($nums <= 3) {
$digits = 3 - $nums;
}
$table_info['Data_length'] = number_format($table_info['Data_length'], $digits) . ' MB';
$table_info['Index_length'] = $table_info['Index_length'] / 1024 / 1024;
$nums = intval(log($table_info['Index_length']) / log(10));
$digits = 0;
if ($nums <= 3) {
$digits = 3 - $nums;
}
$table_info['Index_length'] = number_format($table_info['Index_length'], $digits) . ' MB';
return $table_info;
}
public function getmsg_by_msgid($msgid)
{
return XDB::fetch_first("SELECT m.*,b.name as brandname FROM %t as m\n\t\tLEFT JOIN %t as b ON m.bid = b.bid\n\t\tWHERE msgid=%d", array($this->_table, $this->_jointable, $msgid));
}
public function getvotetotal_by_bid($bid)
{
$votedata = XDB::fetch_first("SELECT (star1 * 1 + star2 * 2 + star3 * 3 + star4 * 4 + star5 * 5) as total,(star1 + star2 + star3 + star4 + star5 ) as totalnum FROM %t where bid=%d", array($this->_table, $bid));
$total = array(0.0, 0, 0, 0);
if ($votedata) {
$total = $votedata['total'] / $votedata['totalnum'];
$total = sprintf("%1.1f", $total);
$vt = $total / 5 * 100;
$vt = sprintf("%1.0f", $vt);
return array($total, $votedata['total'], $votedata['totalnum'], $vt);
}
return $total;
}
public function userget_by_catid($catid, $uid)
{
return XDB::fetch_first("SELECT c.*,m.username,b.name as brandname FROM %t as c\n\t\tLEFT JOIN %t as m ON c.uid = m.uid\t\n\t\tLEFT JOIN %t as b ON b.bid = c.bid\t\t\n\t\tWHERE c.catid=%d and c.uid =%d order by c.displayorder", array($this->_table, $this->_membertable, $this->_joinbrandtable, $catid, $uid));
}
public function fetch_first_by_name($name, $upid)
{
return XDB::fetch_first("SELECT * FROM %t WHERE " . XDB::field('name', $name) . " and upid=%d", array($this->_table, $upid));
}
public function fetch_firstbyaid($aid)
{
return XDB::fetch_first("SELECT * FROM %t WHERE aid=%d ", array($this->_table, $aid));
}
public function usergetmaxalbumcategory_by_bid($bid, $uid)
{
return XDB::fetch_first("SELECT g.maxalbumcategory, g.maxalbum FROM %t as t \n\t\tLEFT JOIN %t as g on t.groupid=g.groupid \n\t\twhere t.bid=%d and t.uid=%d", array($this->_table, $this->_grouptable, $bid, $uid));
}
