public function clear()
{
require_once libfile('function/forum');
$delaids = array();
$query = XDB::query("SELECT aid, attachment, thumb FROM %t WHERE %i", array($this->_table, XDB::field('dateline', TIMESTAMP - 86400)));
while ($attach = XDB::fetch($query)) {
dunlink($attach);
$delaids[] = $attach['aid'];
}
if ($delaids) {
XDB::query("DELETE FROM %t WHERE %i", array('forum_attachment', XDB::field('aid', $delaids)), false, true);
XDB::query("DELETE FROM %t WHERE %i", array($this->_table, XDB::field('dateline', TIMESTAMP - 86400)), false, true);
}
}
public function fetch_by_aid_uid($aid, $uid)
{
$query = XDB::query("SELECT * FROM %t WHERE aid=%d AND uid=%d", array($this->_table, $aid, $uid));
return XDB::fetch($query);
}
function fetch_table_struct($tablename, $result = 'FIELD')
{
if (empty($tablename)) {
return array();
}
$datas = array();
$query = XDB::query("DESCRIBE " . XDB::table($tablename));
while ($data = XDB::fetch($query)) {
$datas[$data['Field']] = $result == 'FIELD' ? $data['Field'] : $data;
}
return $datas;
}
public function groupuserlist($fid, $orderby = '', $num = 0, $start = 0, $addwhere = '', $fieldarray = array(), $onlinemember = array())
{
$fid = intval($fid);
if ($fieldarray && is_array($fieldarray)) {
$fieldadd = 'uid';
foreach ($fieldarray as $field) {
$fieldadd .= ' ,' . $field;
}
} else {
$fieldadd = '*';
}
$sqladd = $levelwhere = '';
if ($addwhere) {
if (is_array($addwhere)) {
foreach ($addwhere as $field => $value) {
if (is_array($value)) {
$levelwhere = "AND level>'0' ";
$sqladd .= "AND {$field} IN (" . dimplode($value) . ") ";
} else {
$sqladd .= is_numeric($field) ? "AND {$value} " : "AND {$field}='{$value}' ";
}
}
if (!empty($addwhere['level'])) {
$levelwhere = '';
}
} else {
$sqladd = $addwhere;
}
}
$orderbyarray = array('level_join' => 'level ASC, joindateline ASC', 'joindateline' => 'joindateline DESC', 'lastupdate' => 'lastupdate DESC', 'threads' => 'threads DESC', 'replies' => 'replies DESC');
$orderby = !empty($orderbyarray[$orderby]) ? "ORDER BY {$orderbyarray[$orderby]}" : '';
$limitsql = $num ? XDB::limit($start, $num) : '';
$groupuserlist = array();
$query = XDB::query("SELECT {$fieldadd} FROM " . XDB::table('forum_groupuser') . " WHERE fid=%d {$levelwhere} %i {$orderby} {$limitsql}", array($fid, $sqladd));
while ($groupuser = XDB::fetch($query)) {
$groupuserlist[$groupuser['uid']] = $groupuser;
$groupuserlist[$groupuser['uid']]['online'] = !empty($onlinemember) && is_array($onlinemember) && !empty($onlinemember[$groupuser['uid']]) ? 1 : 0;
}
return $groupuserlist;
}
public function fetch_all_field()
{
$data = false;
$query = XDB::query('SHOW FIELDS FROM ' . XDB::table($this->_table), '', 'SILENT');
if ($query) {
$data = array();
while ($value = XDB::fetch($query)) {
$data[$value['Field']] = $value;
}
}
return $data;
}
public function fetch_all_rank_thread($dateline, $notfid, $order = 'dateline', $start = 0, $limit = 0)
{
$parameter = array($this->get_table_name());
$data = $fids = $wherearr = array();
if ($dateline) {
$parameter[] = $dateline;
$wherearr[] = 'dateline>%d';
}
$wherearr[] = 'displayorder>=0';
if ($notfid) {
$parameter[] = $notfid;
$wherearr[] = 'fid NOT IN(%n)';
}
$wheresql = ' WHERE ' . implode(' AND ', $wherearr);
$ordersql = !empty($order) ? ' ORDER BY ' . XDB::order($order, 'DESC') : '';
$query = XDB::query("SELECT tid, fid, author, authorid, subject, dateline, views, replies, favtimes, sharetimes, heats FROM %t {$wheresql} {$ordersql} " . XDB::limit($start, $limit), $parameter);
while ($value = XDB::fetch($query)) {
$data[$value['tid']] = $value;
$fids[$value['fid']][$value['tid']] = $value['tid'];
}
if (!empty($fids)) {
foreach (C::t('forum_forum')->fetch_all_name_by_fid(array_keys($fids)) as $value) {
foreach ($fids[$value['fid']] as $tid) {
$data[$tid]['forum'] = $value['name'];
}
}
}
return $data;
}
public function show_table_columns($table)
{
$data = array();
$db =& XDB::object();
if ($db->version() > '4.1') {
$query = $db->query("SHOW FULL COLUMNS FROM " . XDB::table($table), 'SILENT');
} else {
$query = $db->query("SHOW COLUMNS FROM " . XDB::table($table), 'SILENT');
}
while ($field = @XDB::fetch($query)) {
$data[$field['Field']] = $field;
}
return $data;
}
