unset($sqldump); $supetablepredot = strpos($supe['tablepre'], '.'); $supe['dbname'] = $supetablepredot !== FALSE ? substr($supe['tablepre'], 0, $supetablepredot) : ''; foreach($sqlquery as $sql) { $sql = syntablestruct(trim($sql), $db->version() > '4.1', $dbcharset); if(substr($sql, 0, 11) == 'INSERT INTO') { $sqldbname = substr($sql, 12, 20); $dotpos = strpos($sqldbname, '.'); if($dotpos !== FALSE) { if(empty($supe['dbmode'])) { $sql = 'INSERT INTO `'.$supe['dbname'].'`.'.substr($sql, 13 + $dotpos); } else { supe_dbconnect(); } } } if($sql != '') { $db->query($sql, 'SILENT'); if(($sqlerror = $db->error()) && $db->errno() != 1062) { $db->halt('MySQL Query Error', $sql); } } } if($delunzip) { @unlink($datafile_server); }
function supe_circlepermission($gid, $permission = 'allowshare') { global $supe, $discuz_uid, $_DCOOKIE; supe_dbconnect(); $query = $supe['db']->query("SELECT ispublic, allowshare, password FROM {$supe[tablepre]}groups WHERE gid='{$gid}' AND flag=1"); $circle = $supe['db']->fetch_array($query); $incircle = $discuz_uid ? $supe['db']->result($supe['db']->query("SELECT COUNT(*) FROM {$supe[tablepre]}groupuid WHERE uid='{$discuz_uid}' AND gid='{$gid}' AND flag>0"), 0) : 0; return $permission == 'allowshare' ? $circle['allowshare'] && ($circle['ispublic'] == 1 || $circle['ispublic'] == 2 && $circle['password'] == $_DCOOKIE['gidpw' . $gid]) || $incircle : $incircle; }
[Discuz!] (C)2001-2007 Comsenz Inc. This is NOT a freeware, use is subject to license terms $Id: viewthread.php 10561 2007-09-05 08:24:49Z monkey $ */ define('CURSCRIPT', 'viewthread'); define('SQL_ADD_THREAD', ' t.dateline, t.special, t.lastpost AS lastthreadpost,'); require_once './include/common.inc.php'; require_once DISCUZ_ROOT . './include/forum.func.php'; $page = max($page, 1); if ($cachethreadlife && $forum['threadcaches'] && !$discuz_uid && $page == 1 && !$forum['special']) { viewthread_loadcache(); } require_once DISCUZ_ROOT . './include/discuzcode.func.php'; $discuz_action = 3; $supe['status'] && supe_dbconnect(); $query = $db->query("SELECT * FROM {$tablepre}threads t WHERE tid='{$tid}' AND displayorder>='0'"); if (!($thread = $db->fetch_array($query))) { $tid = $_GET['tid']; if ($supe['status'] && is_numeric($tid) && !empty($supe_fromsupesite) && md5("{$discuz_auth_key}-{$tid}") == $supe_fromsupesite) { $supe['db']->query("UPDATE {$supe[tablepre]}spaceitems SET tid='0' WHERE tid='{$tid}'", 'SILENT'); } showmessage('thread_nonexistence'); } $oldtopics = isset($_DCOOKIE['oldtopics']) ? $_DCOOKIE['oldtopics'] : 'D'; if (strpos($oldtopics, 'D' . $tid . 'D') === FALSE) { $oldtopics = 'D' . $tid . $oldtopics; if (strlen($oldtopics) > 3072) { $oldtopics = preg_replace("((D\\d+)+D).*\$", "\\1", substr($oldtopics, 0, 3072)); } dsetcookie('oldtopics', $oldtopics, 3600);
function getcachearray($cachename, $script = '') { global $db, $timestamp, $tablepre, $timeoffset, $maxbdays, $smcols, $smrows, $charset, $supe; $cols = '*'; $conditions = ''; switch ($cachename) { case 'settings': $table = 'settings'; $conditions = "WHERE variable NOT IN ('siteuniqueid', 'mastermobile', 'bbrules', 'bbrulestxt', 'closedreason', 'creditsnotify', 'backupdir', 'custombackup', 'jswizard', 'maxonlines', 'modreasons', 'newsletter', 'welcomemsg', 'welcomemsgtxt', 'postno', 'postnocustom', 'customauthorinfo') AND SUBSTRING(variable, 1, 9)<>'jswizard_'"; break; case 'custominfo': $table = 'settings'; $conditions = "WHERE variable IN ('extcredits', 'customauthorinfo', 'postno', 'postnocustom', 'maxavatarpixel')"; break; case 'jswizard': $table = 'settings'; $conditions = "WHERE variable LIKE 'jswizard_%'"; break; case 'usergroups': $table = 'usergroups'; $cols = 'groupid, type, grouptitle, creditshigher, creditslower, stars, color, groupavatar, readaccess, allowavatar, allowcusbbcode, allowuseblog'; $conditions = "ORDER BY creditslower"; break; case 'ranks': $table = 'ranks'; $cols = 'ranktitle, postshigher, stars, color'; $conditions = "ORDER BY postshigher DESC"; break; case 'announcements': $table = 'announcements'; $cols = 'id, subject, type, starttime, endtime, displayorder, groups, message'; $conditions = "WHERE starttime<='{$timestamp}' AND (endtime>='{$timestamp}' OR endtime='0') ORDER BY displayorder, starttime DESC, id DESC"; break; case 'announcements_forum': $table = 'announcements a'; $cols = 'a.id, a.author, m.uid AS authorid, a.subject, a.message, a.type, a.starttime, a.displayorder'; $conditions = "LEFT JOIN {$tablepre}members m ON m.username=a.author WHERE a.type!=2 AND a.groups = '' AND a.starttime<='{$timestamp}' ORDER BY a.displayorder, a.starttime DESC, a.id DESC LIMIT 1"; break; case 'pmlist': $table = 'announcements a'; $cols = 'id as pmid, subject, starttime, endtime, groups'; $conditions = "WHERE type=2 AND starttime<='{$timestamp}' AND (endtime>='{$timestamp}' OR endtime='0') ORDER BY displayorder, starttime DESC, id DESC"; break; case in_array($cachename, array('globalstick', 'floatthreads')): $table = 'forums'; $cols = 'fid, type, fup'; $conditions = "WHERE status>0 AND type IN ('forum', 'sub') ORDER BY type"; break; case 'forums': $table = 'forums f'; $cols = 'f.fid, f.type, f.name, f.fup, f.simple, ff.viewperm, ff.formulaperm, a.uid'; $conditions = "LEFT JOIN {$tablepre}forumfields ff ON ff.fid=f.fid LEFT JOIN {$tablepre}access a ON a.fid=f.fid AND a.allowview='1' WHERE f.status>0 ORDER BY f.type, f.displayorder"; break; case 'onlinelist': $table = 'onlinelist'; $conditions = "ORDER BY displayorder"; break; case 'forumlinks': $table = 'forumlinks'; $conditions = "ORDER BY displayorder"; break; case 'bbcodes': $table = 'bbcodes'; $conditions = "WHERE available='1'"; break; case 'bbcodes_display': $table = 'bbcodes'; $cols = 'tag, icon, explanation, params, prompt'; $conditions = "WHERE available='1' AND icon!=''"; break; case 'smilies': $table = 'smilies s'; $cols = 's.id, s.code, s.url, t.typeid'; $conditions = "LEFT JOIN {$tablepre}imagetypes t ON t.typeid=s.typeid WHERE s.type='smiley' AND s.code<>'' AND t.typeid IS NOT NULL ORDER BY LENGTH(s.code) DESC"; break; case 'smilies_display': $table = 'imagetypes'; $cols = 'typeid, directory'; $conditions = "WHERE type='smiley' ORDER BY displayorder"; break; case 'smileytypes': $table = 'imagetypes'; $cols = 'typeid, name, directory'; $conditions = "WHERE type='smiley' ORDER BY displayorder"; break; case 'icons': $table = 'smilies'; $cols = 'id, url'; $conditions = "WHERE type='icon' ORDER BY displayorder"; break; case 'fields_required': $table = 'profilefields'; $cols = 'fieldid, invisible, title, description, required, unchangeable, selective, choices'; $conditions = "WHERE available='1' AND required='1' ORDER BY displayorder"; break; case 'fields_optional': $table = 'profilefields'; $cols = 'fieldid, invisible, title, description, required, unchangeable, selective, choices'; $conditions = "WHERE available='1' AND required='0' ORDER BY displayorder"; break; case 'ipbanned': $db->query("DELETE FROM {$tablepre}banned WHERE expiration<'{$timestamp}'"); $table = 'banned'; $cols = 'ip1, ip2, ip3, ip4, expiration'; break; case 'google': $table = 'settings'; $cols = 'value'; $conditions = "WHERE variable = 'google'"; break; case 'censor': $table = 'words'; $cols = 'find, replacement'; break; case 'medals': $table = 'medals'; $cols = 'medalid, name, image'; $conditions = "WHERE available='1'"; break; case 'magics': $table = 'magics'; $cols = 'magicid, available, identifier, name, description, weight, price'; break; case 'birthdays_index': $table = 'members'; $cols = 'uid, username, email, bday'; $conditions = "WHERE RIGHT(bday, 5)='" . gmdate('m-d', $timestamp + $timeoffset * 3600) . "' ORDER BY bday LIMIT {$maxbdays}"; break; case 'birthdays': $table = 'members'; $cols = 'uid'; $conditions = "WHERE RIGHT(bday, 5)='" . gmdate('m-d', $timestamp + $timeoffset * 3600) . "' ORDER BY bday"; break; case 'modreasons': $table = 'settings'; $cols = 'value'; $conditions = "WHERE variable='modreasons'"; break; case 'faqs': $table = 'faqs'; $cols = 'id, identifier, keyword'; $conditions = "WHERE identifier!='' AND keyword!=''"; break; case substr($cachename, 0, 5) == 'tags_': global $viewthreadtags, $hottags; $taglimit = substr($cachename, 5) == 'viewthread' ? intval($viewthreadtags) : intval($hottags); $table = 'tags'; $cols = 'tagname, total'; $conditions = "WHERE closed=0 ORDER BY total DESC LIMIT {$taglimit}"; break; } $data = array(); if (!in_array($cachename, array('secqaa', 'supe_updateusers', 'supe_updateitems', 'supe_updatecircles')) && substr($cachename, 0, 5) != 'advs_') { if (empty($table) || empty($cols)) { return ''; } $query = $db->query("SELECT {$cols} FROM {$tablepre}{$table} {$conditions}"); } switch ($cachename) { case 'settings': while ($setting = $db->fetch_array($query)) { if ($setting['variable'] == 'extcredits') { if (is_array($setting['value'] = unserialize($setting['value']))) { foreach ($setting['value'] as $key => $value) { if ($value['available']) { unset($setting['value'][$key]['available']); } else { unset($setting['value'][$key]); } } } } elseif ($setting['variable'] == 'creditsformula') { if (!preg_match("/^([\\+\\-\\*\\/\\.\\d\\(\\)]|((extcredits[1-8]|digestposts|posts|pageviews|oltime)([\\+\\-\\*\\/\\(\\)]|\$)+))+\$/", $setting['value']) || !is_null(@eval(preg_replace("/(digestposts|posts|pageviews|oltime|extcredits[1-8])/", "\$\\1", $setting['value']) . ';'))) { $setting['value'] = '$member[\'extcredits1\']'; } else { $setting['value'] = preg_replace("/(digestposts|posts|pageviews|oltime|extcredits[1-8])/", "\$member['\\1']", $setting['value']); } } elseif ($setting['variable'] == 'maxsmilies') { $setting['value'] = $setting['value'] <= 0 ? -1 : $setting['value']; } elseif ($setting['variable'] == 'threadsticky') { $setting['value'] = explode(',', $setting['value']); } elseif ($setting['variable'] == 'attachdir') { $setting['value'] = preg_replace("/\\.asp|\\0/i", '0', $setting['value']); $setting['value'] = str_replace('\\', '/', substr($setting['value'], 0, 2) == './' ? DISCUZ_ROOT . $setting['value'] : $setting['value']); } elseif ($setting['variable'] == 'onlinehold') { $setting['value'] = $setting['value'] * 60; } elseif ($setting['variable'] == 'userdateformat') { if (empty($setting['value'])) { $setting['value'] = array(); } else { $setting['value'] = dhtmlspecialchars(explode("\n", $setting['value'])); $setting['value'] = array_map('trim', $setting['value']); } } elseif (in_array($setting['variable'], array('creditspolicy', 'ftp', 'secqaa', 'supe', 'ec_credit', 'google', 'qihoo', 'insenz', 'spacedata'))) { $setting['value'] = unserialize($setting['value']); } $GLOBALS[$setting['variable']] = $data[$setting['variable']] = $setting['value']; } $GLOBALS['version'] = $data['version'] = DISCUZ_KERNEL_VERSION; $GLOBALS['totalmembers'] = $data['totalmembers'] = $db->result_first("SELECT COUNT(*) FROM {$tablepre}members"); $GLOBALS['lastmember'] = $data['lastmember'] = $db->result_first("SELECT username FROM {$tablepre}members ORDER BY uid DESC LIMIT 1"); $data['cachethreadon'] = $db->result_first("SELECT COUNT(*) FROM {$tablepre}forums WHERE status>0 AND threadcaches>0") ? 1 : 0; $data['cronnextrun'] = $db->result_first("SELECT nextrun FROM {$tablepre}crons WHERE available>'0' AND nextrun>'0' ORDER BY nextrun LIMIT 1"); $data['ftp']['connid'] = 0; $data['indexname'] = empty($data['indexname']) ? 'index.php' : $data['indexname']; if (!$data['imagelib']) { unset($data['imageimpath']); } $data['seccodedata'] = $data['seccodedata'] ? unserialize($data['seccodedata']) : array(); if ($data['seccodedata']['type'] == 2) { if (extension_loaded('ming')) { unset($data['seccodedata']['background'], $data['seccodedata']['adulterate'], $data['seccodedata']['ttf'], $data['seccodedata']['angle'], $data['seccodedata']['color'], $data['seccodedata']['size'], $data['seccodedata']['animator']); } else { $data['seccodedata']['type'] = 0; } } $secqaacheck = sprintf('%03b', $data['secqaa']['status']); $data['secqaa']['status'] = array(1 => $secqaacheck[2], 2 => $secqaacheck[1], 3 => $secqaacheck[0]); if (!$data['secqaa']['status'][2] && !$data['secqaa']['status'][3]) { unset($data['secqaa']['minposts']); } if ($data['watermarktype'] == 2 && $data['watermarktext']) { $data['watermarktext'] = unserialize($data['watermarktext']); if ($data['watermarktext']['text'] && strtoupper($charset) != 'UTF-8') { require_once DISCUZ_ROOT . 'include/chinese.class.php'; $c = new Chinese($charset, 'utf8'); $data['watermarktext']['text'] = $c->Convert($data['watermarktext']['text']); } $data['watermarktext']['text'] = bin2hex($data['watermarktext']['text']); $data['watermarktext']['fontpath'] = 'images/fonts/' . $data['watermarktext']['fontpath']; $data['watermarktext']['color'] = preg_replace('/#?([0-9a-fA-F]{2})([0-9a-fA-F]{2})([0-9a-fA-F]{2})/e', "hexdec('\\1').','.hexdec('\\2').','.hexdec('\\3')", $data['watermarktext']['color']); $data['watermarktext']['shadowcolor'] = preg_replace('/#?([0-9a-fA-F]{2})([0-9a-fA-F]{2})([0-9a-fA-F]{2})/e', "hexdec('\\1').','.hexdec('\\2').','.hexdec('\\3')", $data['watermarktext']['shadowcolor']); } else { $data['watermarktext'] = array(); } $tradetypes = implodeids(unserialize($data['tradetypes'])); $data['tradetypes'] = array(); if ($tradetypes) { $query = $db->query("SELECT typeid, name FROM {$tablepre}threadtypes WHERE typeid in ({$tradetypes})"); while ($type = $db->fetch_array($query)) { $data['tradetypes'][$type['typeid']] = $type['name']; } } $data['jsmenustatus'] = sprintf('%b', $data['jsmenustatus']); for ($i = 1; $i <= strlen($data['jsmenustatus']); $i++) { if (substr($data['jsmenustatus'], -$i, 1)) { $data['jsmenu'][$i] = TRUE; } } unset($data['jsmenustatus']); $data['stylejumpstatus'] = $data['stylejump']; $data['stylejump'] = array(); $query = $db->query("SELECT styleid, name FROM {$tablepre}styles WHERE available='1'"); while ($style = $db->fetch_array($query)) { $data['stylejump'][$style['styleid']] = dhtmlspecialchars($style['name']); } $globaladvs = advertisement('all'); $data['globaladvs'] = $globaladvs['all'] ? $globaladvs['all'] : array(); $data['redirectadvs'] = $globaladvs['redirect'] ? $globaladvs['redirect'] : array(); $data['invitecredit'] = ''; if ($data['inviteconfig'] = unserialize($data['inviteconfig'])) { $data['invitecredit'] = $data['inviteconfig']['invitecredit']; } unset($data['inviteconfig']); $data['videoopen'] = $data['videotype'] = $data['vsiteid'] = $data['vpassword'] = $data['vkey'] = $data['vsiteurl'] = ''; if ($data['videoinfo'] = unserialize($data['videoinfo'])) { $data['videoopen'] = intval($data['videoinfo']['open']); $data['videotype'] = explode("\n", $data['videoinfo']['vtype']); $data['vsiteid'] = $data['videoinfo']['vsiteid']; $data['vpassword'] = $data['videoinfo']['vpassword']; $data['vkey'] = $data['videoinfo']['vkey']; $data['vsiteurl'] = $data['videoinfo']['url']; } unset($data['videoinfo']); $exchcredits = array(); $allowexchangein = $allowexchangeout = FALSE; foreach ((array) $data['extcredits'] as $id => $credit) { if (!empty($credit['ratio'])) { $exchcredits[$id] = $credit; $credit['allowexchangein'] && ($allowexchangein = TRUE); $credit['allowexchangeout'] && ($allowexchangeout = TRUE); } } $data['exchangestatus'] = $allowexchangein && $allowexchangeout; $data['transferstatus'] = isset($data['extcredits'][$data['creditstrans']]); foreach (array('supe_status', 'supe_tablepre', 'supe_siteurl', 'supe_sitename', 'supe_circlestatus') as $variable) { $data['supe'][substr($variable, 5)] = $data[$variable]; unset($data[$variable]); } if (!$data['supe']['status']) { $data['supe'] = array('status' => 0); } else { if (!$data['supe']['items']['status']) { $data['supe']['items'] = array('status' => 0); } if (!isset($data['supe']['attachurl']) && isset($supe['tablepre'])) { $supe['status'] = 1; supe_dbconnect(); $query = $supe['db']->query("SELECT * FROM {$supe[tablepre]}settings WHERE variable IN ('attachmentdir', 'attachmenturl')", 'SILENT'); $supe_settings = array(); while ($supe_setting = $supe['db']->fetch_array($query)) { $supe_settings[$supe_setting['variable']] = $supe_setting['value']; } if (substr($supe_settings['attachmentdir'], 0, 2) == './' && empty($supe_settings['attachmenturl'])) { $supe_settings['attachmenturl'] = $supe['siteurl'] . substr($supe_settings['attachmentdir'], 1); } $data['supe']['attachurl'] = $supe_settings['attachmenturl']; $db->query("UPDATE {$tablepre}settings SET value='" . addslashes(serialize($data['supe'])) . "' WHERE variable='supe'"); } if (!$data['supe']['dbmode']) { unset($data['supe']['dbhost'], $data['supe']['dbuser'], $data['supe']['dbpw'], $data['supe']['dbname']); } } if ($data['insenz']['status'] && $data['insenz']['authkey']) { $softadstatus = intval($data['insenz']['softadstatus']); $hardadstatus = is_array($data['insenz']['hardadstatus']) && $data['insenz']['jsurl'] ? implode(',', $data['insenz']['hardadstatus']) : ''; $relatedadstatus = intval($data['insenz']['relatedadstatus']); $insenz_cronnextrun = intval($db->result_first("SELECT nextrun FROM {$tablepre}campaigns ORDER BY nextrun LIMIT 1")); if (!$softadstatus && !$hardadstatus && !$relatedadstatus && !$data['insenz']['virtualforumstatus'] && !$insenz_cronnextrun) { $data['insenz']['status'] = $data['insenz']['cronnextrun'] = 0; $db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('insenz', '" . addslashes(serialize($data['insenz'])) . "')"); $data['insenz'] = array(); } else { $data['insenz'] = array('siteid' => $data['insenz']['siteid'], 'uid' => intval($data['insenz']['uid']), 'username' => addslashes($data['insenz']['username']), 'hardadstatus' => $hardadstatus, 'topicrelatedad' => $relatedadstatus && $data['insenz']['topicrelatedad'] ? $data['insenz']['topicrelatedad'] : '', 'traderelatedad' => $relatedadstatus && $data['insenz']['traderelatedad'] ? $data['insenz']['traderelatedad'] : '', 'relatedtrades' => $relatedadstatus && $data['insenz']['traderelatedad'] && $data['insenz']['relatedtrades'] ? $data['insenz']['relatedtrades'] : '', 'cronnextrun' => $insenz_cronnextrun, 'statsnextrun' => intval($data['insenz']['statsnextrun']), 'jsurl' => $data['insenz']['jsurl']); } } else { $data['insenz'] = array(); } if (!empty($data['google']['status'])) { $data['google'] = $data['google']['searchbox']; } else { $data['google'] = 0; } if ($data['qihoo']['status']) { $qihoo = $data['qihoo']; $data['qihoo']['links'] = $data['qihoo']['relate'] = array(); foreach (explode("\n", trim($qihoo['keywords'])) as $keyword) { if ($keyword = trim($keyword)) { $data['qihoo']['links']['keywords'][] = '<a href="search.php?srchtype=qihoo&srchtxt=' . rawurlencode($keyword) . '&searchsubmit=yes" target="_blank">' . dhtmlspecialchars(trim($keyword)) . '</a>'; } } foreach ((array) $qihoo['topics'] as $topic) { if ($topic['topic'] = trim($topic['topic'])) { $data['qihoo']['links']['topics'][] = '<a href="topic.php?topic=' . rawurlencode($topic['topic']) . '&keyword=' . rawurlencode($topic['keyword']) . '&stype=' . $topic['stype'] . '&length=' . $topic['length'] . '&relate=' . $topic['relate'] . '" target="_blank">' . dhtmlspecialchars(trim($topic['topic'])) . '</a>'; } } if (is_array($qihoo['relatedthreads'])) { if ($data['qihoo']['relate']['bbsnum'] = intval($qihoo['relatedthreads']['bbsnum'])) { $data['qihoo']['relate']['position'] = intval($qihoo['relatedthreads']['position']); $data['qihoo']['relate']['validity'] = intval($qihoo['relatedthreads']['validity']); if ($data['qihoo']['relate']['webnum'] = intval($qihoo['relatedthreads']['webnum'])) { $data['qihoo']['relate']['banurl'] = $qihoo['relatedthreads']['banurl'] ? '/(' . str_replace("\r\n", '|', $qihoo['relatedthreads']['banurl']) . ')/i' : ''; $data['qihoo']['relate']['type'] = implode('|', (array) $qihoo['relatedthreads']['type']); $data['qihoo']['relate']['order'] = intval($qihoo['relatedthreads']['order']); } } else { $data['qihoo']['relate'] = array(); } } unset($qihoo, $data['qihoo']['keywords'], $data['qihoo']['topics'], $data['qihoo']['relatedthreads']); } else { $data['qihoo'] = array(); } $data['plugins'] = $data['pluginlinks'] = array(); $query = $db->query("SELECT available, name, identifier, directory, datatables, modules FROM {$tablepre}plugins"); while ($plugin = $db->fetch_array($query)) { $plugin['modules'] = unserialize($plugin['modules']); if (is_array($plugin['modules'])) { foreach ($plugin['modules'] as $module) { if ($plugin['available'] && isset($module['name'])) { switch ($module['type']) { case 1: $data['plugins']['links'][] = array('displayorder' => $module['displayorder'], 'adminid' => $module['adminid'], 'url' => "<a href=\"{$module['url']}\">{$module['menu']}</a>"); break; case 2: $data['plugins']['links'][] = array('displayorder' => $module['displayorder'], 'adminid' => $module['adminid'], 'url' => "<a href=\"plugin.php?identifier={$plugin['identifier']}&module={$module['name']}\">{$module['menu']}</a>"); $data['pluginlinks'][$plugin['identifier']][$module['name']] = array('adminid' => $module['adminid'], 'directory' => $plugin['directory']); break; case 4: $data['plugins']['include'][] = array('displayorder' => $module['displayorder'], 'adminid' => $module['adminid'], 'script' => $plugin['directory'] . $module['name']); break; case 5: $data['plugins']['jsmenu'][] = array('displayorder' => $module['displayorder'], 'adminid' => $module['adminid'], 'url' => "<a href=\"{$module['url']}\">{$module['menu']}</a>"); break; case 6: $data['plugins']['jsmenu'][] = array('displayorder' => $module['displayorder'], 'adminid' => $module['adminid'], 'url' => "<a href=\"plugin.php?identifier={$plugin['identifier']}&module={$module['name']}\">{$module['menu']}</a>"); $data['pluginlinks'][$plugin['identifier']][$module['name']] = array('adminid' => $module['adminid'], 'directory' => $plugin['directory']); break; } } } } } if (is_array($data['plugins']['links'])) { usort($data['plugins']['links'], 'pluginmodulecmp'); foreach ($data['plugins']['links'] as $key => $module) { unset($data['plugins']['links'][$key]['displayorder']); } } if (is_array($data['plugins']['include'])) { usort($data['plugins']['include'], 'pluginmodulecmp'); foreach ($data['plugins']['include'] as $key => $module) { unset($data['plugins']['include'][$key]['displayorder']); } } if (is_array($data['plugins']['jsmenu'])) { usort($data['plugins']['jsmenu'], 'pluginmodulecmp'); foreach ($data['plugins']['jsmenu'] as $key => $module) { unset($data['plugins']['jsmenu'][$key]['displayorder']); } } $data['hooks'] = array(); $query = $db->query("SELECT ph.title, ph.code, p.identifier FROM {$tablepre}plugins p\r\n\t\t\t\tLEFT JOIN {$tablepre}pluginhooks ph ON ph.pluginid=p.pluginid AND ph.available='1'\r\n\t\t\t\tWHERE p.available='1' ORDER BY p.identifier"); while ($hook = $db->fetch_array($query)) { if ($hook['title'] && $hook['code']) { $data['hooks'][$hook['identifier'] . '_' . $hook['title']] = $hook['code']; } } break; case 'custominfo': while ($setting = $db->fetch_array($query)) { $data[$setting['variable']] = $setting['value']; } $data['customauthorinfo'] = unserialize($data['customauthorinfo']); $data['customauthorinfo'] = $data['customauthorinfo'][0]; $data['extcredits'] = unserialize($data['extcredits']); include language('templates'); $authorinfoitems = array('uid' => '$post[uid]', 'posts' => '$post[posts]', 'digest' => '<a href="digest.php?authorid=$post[authorid]">$post[digestposts]</a>', 'credits' => '$post[credits]', 'readperm' => '$post[readaccess]', 'gender' => '$post[gender]', 'location' => '$post[location]', 'oltime' => '$post[oltime] ' . $language['hours'], 'regtime' => '$post[regdate]', 'lastdate' => '$post[lastdate]'); if (!empty($data['extcredits'])) { foreach ($data['extcredits'] as $key => $value) { if ($value['available'] && $value['showinthread']) { $authorinfoitems['extcredits' . $key] = array($value['title'], '$post[extcredits' . $key . '] {$extcredits[' . $key . '][unit]}'); } } } $data['fieldsadd'] = ''; $data['profilefields'] = array(); $query = $db->query("SELECT * FROM {$tablepre}profilefields WHERE available='1' AND invisible='0' AND showinthread='1' ORDER BY displayorder"); while ($field = $db->fetch_array($query)) { $data['fieldsadd'] .= ', mf.field_' . $field['fieldid']; if ($field['selective']) { foreach (explode("\n", $field['choices']) as $item) { list($index, $choice) = explode('=', $item); $data['profilefields'][$field['fieldid']][trim($index)] = trim($choice); } $authorinfoitems['field_' . $field['fieldid']] = array($field['title'], '{$profilefields[' . $field['fieldid'] . '][$post[field_' . $field['fieldid'] . ']]}'); } else { $authorinfoitems['field_' . $field['fieldid']] = array($field['title'], '$post[field_' . $field['fieldid'] . ']'); } } $customauthorinfo = array(); if (is_array($data['customauthorinfo'])) { foreach ($data['customauthorinfo'] as $key => $value) { if (array_key_exists($key, $authorinfoitems)) { if (substr($key, 0, 10) == 'extcredits') { $v = addcslashes('<dt>' . $authorinfoitems[$key][0] . '</dt><dd>' . $authorinfoitems[$key][1] . ' </dd>', '"'); } elseif (substr($key, 0, 6) == 'field_') { $v = addcslashes('<dt>' . $authorinfoitems[$key][0] . '</dt><dd>' . $authorinfoitems[$key][1] . ' </dd>', '"'); } elseif ($key == 'gender') { $v = '".(' . $authorinfoitems['gender'] . ' == 1 ? "' . addcslashes('<dt>' . $language['authorinfoitems_' . $key] . '</dt><dd>' . $language['authorinfoitems_gender_male'] . ' </dd>', '"') . '" : (' . $authorinfoitems['gender'] . ' == 2 ? "' . addcslashes('<dt>' . $language['authorinfoitems_' . $key] . '</dt><dd>' . $language['authorinfoitems_gender_female'] . ' </dd>', '"') . '" : ""))."'; } elseif ($key == 'location') { $v = '".(' . $authorinfoitems[$key] . ' ? "' . addcslashes('<dt>' . $language['authorinfoitems_' . $key] . '</dt><dd>' . $authorinfoitems[$key] . ' </dd>', '"') . '" : "")."'; } else { $v = addcslashes('<dt>' . $language['authorinfoitems_' . $key] . '</dt><dd>' . $authorinfoitems[$key] . ' </dd>', '"'); } if (isset($value['left'])) { $customauthorinfo[1][] = $v; } if (isset($value['menu'])) { $customauthorinfo[2][] = $v; } if (isset($value['special'])) { $customauthorinfo[3][] = $v; } } } } $GLOBALS['postminheight'] = ($data['maxavatarpixel'] > 300 ? 300 : $data['maxavatarpixel']) + count($customauthorinfo[1]) * 20; $customauthorinfo[1] = @implode('', $customauthorinfo[1]); $customauthorinfo[2] = @implode('', $customauthorinfo[2]); $customauthorinfo[3] = @implode('', $customauthorinfo[3]); $data['customauthorinfo'] = $customauthorinfo; updatecache('styles'); $postnocustomnew[0] = $data['postno'] != '' ? preg_match("/^[-]+\$/", $data['postno']) ? '<sup>' . $data['postno'] . '</sup>' : $data['postno'] : '<sup>#</sup>'; $data['postnocustom'] = unserialize($data['postnocustom']); if (is_array($data['postnocustom'])) { foreach ($data['postnocustom'] as $key => $value) { $value = trim($value); $postnocustomnew[$key + 1] = preg_match("/^[-]+\$/", $value) ? '<sup>' . $value . '</sup>' : $value; } } unset($data['postno'], $data['postnocustom'], $data['extcredits'], $data['maxavatarpixel']); $data['postno'] = $postnocustomnew; break; case 'jswizard': while ($jswizard = $db->fetch_array($query)) { $key = substr($jswizard['variable'], 9); $data[$key] = unserialize($jswizard['value']); unset($data[$key]['type']); unset($data[$key]['parameter']); } break; case 'usergroups': global $userstatusby; while ($group = $db->fetch_array($query)) { $groupid = $group['groupid']; $group['grouptitle'] = $group['color'] ? '<font color="' . $group['color'] . '">' . $group['grouptitle'] . '</font>' : $group['grouptitle']; if ($userstatusby == 1) { $group['userstatusby'] = 1; } elseif ($userstatusby == 2) { if ($group['type'] != 'member') { $group['userstatusby'] = 1; } else { $group['userstatusby'] = 2; } } if ($group['type'] != 'member') { unset($group['creditshigher'], $group['creditslower']); } unset($group['groupid'], $group['color']); $data[$groupid] = $group; } break; case 'ranks': global $userstatusby; if ($userstatusby == 2) { while ($rank = $db->fetch_array($query)) { $rank['ranktitle'] = $rank['color'] ? '<font color="' . $rank['color'] . '">' . $rank['ranktitle'] . '</font>' : $rank['ranktitle']; unset($rank['color']); $data[] = $rank; } } break; case 'announcements': $data = array(); while ($datarow = $db->fetch_array($query)) { if ($datarow['type'] == 2) { $datarow['pmid'] = $datarow['id']; unset($datarow['id']); unset($datarow['message']); $datarow['subject'] = cutstr($datarow['subject'], 60); } $datarow['groups'] = empty($datarow['groups']) ? array() : explode(',', $datarow['groups']); $data[] = $datarow; } break; case 'announcements_forum': if ($data = $db->fetch_array($query)) { $data['authorid'] = intval($data['authorid']); if (empty($data['type'])) { unset($data['message']); } } else { $data = array(); } break; case 'pmlist': $data = array(); while ($datarow = $db->fetch_array($query)) { $datarow['subject'] = cutstr($datarow['subject'], 60); $datarow['groups'] = empty($datarow['groups']) ? array() : explode(',', $datarow['groups']); $data[] = $datarow; } break; case 'globalstick': $fuparray = $threadarray = array(); while ($forum = $db->fetch_array($query)) { switch ($forum['type']) { case 'forum': $fuparray[$forum['fid']] = $forum['fup']; break; case 'sub': $fuparray[$forum['fid']] = $fuparray[$forum['fup']]; break; } } $query = $db->query("SELECT tid, fid, displayorder FROM {$tablepre}threads WHERE displayorder IN (2, 3)"); while ($thread = $db->fetch_array($query)) { switch ($thread['displayorder']) { case 2: $threadarray[$fuparray[$thread['fid']]][] = $thread['tid']; break; case 3: $threadarray['global'][] = $thread['tid']; break; } } foreach (array_unique($fuparray) as $gid) { if (!empty($threadarray[$gid])) { $data['categories'][$gid] = array('tids' => implode(',', $threadarray[$gid]), 'count' => intval(@count($threadarray[$gid]))); } } $data['global'] = array('tids' => empty($threadarray['global']) ? 0 : implode(',', $threadarray['global']), 'count' => intval(@count($threadarray['global']))); break; case 'floatthreads': $fuparray = $threadarray = $forums = array(); while ($forum = $db->fetch_array($query)) { switch ($forum['type']) { case 'forum': $fuparray[$forum['fid']] = $forum['fup']; break; case 'sub': $fuparray[$forum['fid']] = $fuparray[$forum['fup']]; break; } } $query = $db->query("SELECT tid, fid, displayorder FROM {$tablepre}threads WHERE displayorder IN (4, 5)"); while ($thread = $db->fetch_array($query)) { switch ($thread['displayorder']) { case 4: $threadarray[$thread['fid']][] = $thread['tid']; break; case 5: $threadarray[$fuparray[$thread['fid']]][] = $thread['tid']; break; } $forums[] = $thread['fid']; } foreach (array_unique($fuparray) as $gid) { if (!empty($threadarray[$gid])) { $data['categories'][$gid] = implode(',', $threadarray[$gid]); } } foreach (array_unique($forums) as $fid) { if (!empty($threadarray[$fid])) { $data['forums'][$fid] = implode(',', $threadarray[$fid]); } } break; case 'censor': $banned = $mod = array(); $data = array('filter' => array(), 'banned' => '', 'mod' => ''); while ($censor = $db->fetch_array($query)) { $censor['find'] = preg_replace("/\\\\{(\\d+)\\\\}/", ".{0,\\1}", preg_quote($censor['find'], '/')); switch ($censor['replacement']) { case '{BANNED}': $banned[] = $censor['find']; break; case '{MOD}': $mod[] = $censor['find']; break; default: $data['filter']['find'][] = '/' . $censor['find'] . '/i'; $data['filter']['replace'][] = $censor['replacement']; break; } } if ($banned) { $data['banned'] = '/(' . implode('|', $banned) . ')/i'; } if ($mod) { $data['mod'] = '/(' . implode('|', $mod) . ')/i'; } break; case 'forums': while ($forum = $db->fetch_array($query)) { $forum['orderby'] = bindec(($forum['simple'] & 128 ? 1 : 0) . ($forum['simple'] & 64 ? 1 : 0)); $forum['ascdesc'] = $forum['simple'] & 32 ? 'ASC' : 'DESC'; if (!isset($forumlist[$forum['fid']])) { $forum['name'] = strip_tags($forum['name']); if ($forum['uid']) { $forum['users'] = "\t{$forum['uid']}\t"; } unset($forum['uid']); if ($forum['fup']) { $forumlist[$forum['fup']]['count']++; } $forumlist[$forum['fid']] = $forum; } elseif ($forum['uid']) { if (!$forumlist[$forum['fid']]['users']) { $forumlist[$forum['fid']]['users'] = "\t"; } $forumlist[$forum['fid']]['users'] .= "{$forum['uid']}\t"; } } $orderbyary = array('lastpost', 'dateline', 'replies', 'views'); if (!empty($forumlist)) { foreach ($forumlist as $fid1 => $forum1) { if ($forum1['type'] == 'group' && $forum1['count']) { $data[$fid1]['fid'] = $forum1['fid']; $data[$fid1]['type'] = $forum1['type']; $data[$fid1]['name'] = $forum1['name']; $data[$fid1]['fup'] = $forum1['fup']; $data[$fid1]['viewperm'] = $forum1['viewperm']; $data[$fid1]['orderby'] = $orderbyary[$forum1['orderby']]; $data[$fid1]['ascdesc'] = $forum1['ascdesc']; foreach ($forumlist as $fid2 => $forum2) { if ($forum2['fup'] == $fid1 && $forum2['type'] == 'forum') { $data[$fid2]['fid'] = $forum2['fid']; $data[$fid2]['type'] = $forum2['type']; $data[$fid2]['name'] = $forum2['name']; $data[$fid2]['fup'] = $forum2['fup']; $data[$fid2]['viewperm'] = $forum2['viewperm']; $data[$fid2]['orderby'] = $orderbyary[$forum2['orderby']]; $data[$fid2]['ascdesc'] = $forum2['ascdesc']; foreach ($forumlist as $fid3 => $forum3) { if ($forum3['fup'] == $fid2 && $forum3['type'] == 'sub') { $data[$fid3]['fid'] = $forum3['fid']; $data[$fid3]['type'] = $forum3['type']; $data[$fid3]['name'] = $forum3['name']; $data[$fid3]['fup'] = $forum3['fup']; $data[$fid3]['viewperm'] = $forum3['viewperm']; $data[$fid3]['orderby'] = $orderbyary[$forum3['orderby']]; $data[$fid3]['ascdesc'] = $forum3['ascdesc']; } } } } } } } break; case 'onlinelist': $data['legend'] = ''; while ($list = $db->fetch_array($query)) { $data[$list['groupid']] = $list['url']; $data['legend'] .= "<img src=\"images/common/{$list['url']}\" alt=\"\" /> {$list['title']} "; if ($list['groupid'] == 7) { $data['guest'] = $list['title']; } } break; case 'forumlinks': global $forumlinkstatus; if ($forumlinkstatus) { $tightlink_text = $tightlink_logo = ''; while ($flink = $db->fetch_array($query)) { if ($flink['description']) { $forumlink['content'] = "<h5><a href=\"{$flink['url']}\" target=\"_blank\">{$flink['name']}</a></h5><p>{$flink['description']}</p>"; if ($flink['logo']) { $forumlink['type'] = 1; $forumlink['logo'] = $flink['logo']; } else { $forumlink['type'] = 2; } $data[] = $forumlink; } else { if ($flink['logo']) { $tightlink_logo .= "<a href=\"{$flink['url']}\" target=\"_blank\"><img src=\"{$flink['logo']}\" border=\"0\" alt=\"{$flink['name']}\" /></a> "; } else { $tightlink_text .= "<a href=\"{$flink['url']}\" target=\"_blank\">[{$flink['name']}]</a> "; } } } if ($tightlink_logo || $tightlink_text) { $tightlink_logo .= $tightlink_logo ? '<br />' : ''; $data[] = array('type' => 3, 'content' => $tightlink_logo . $tightlink_text); } } else { $data = array(); } break; case 'bbcodes': $regexp = array(1 => "/\\[{bbtag}]([^\"]+?)\\[\\/{bbtag}\\]/is", 2 => "/\\[{bbtag}=(['\"]?)([^\"]+?)(['\"]?)\\]([^\"]+?)\\[\\/{bbtag}\\]/is", 3 => "/\\[{bbtag}=(['\"]?)([^\"]+?)(['\"]?),(['\"]?)([^\"]+?)(['\"]?)\\]([^\"]+?)\\[\\/{bbtag}\\]/is"); while ($bbcode = $db->fetch_array($query)) { $search = str_replace('{bbtag}', $bbcode['tag'], $regexp[$bbcode['params']]); $bbcode['replacement'] = preg_replace("/([\r\n])/", '', $bbcode['replacement']); switch ($bbcode['params']) { case 2: $bbcode['replacement'] = str_replace('{1}', '\\2', $bbcode['replacement']); $bbcode['replacement'] = str_replace('{2}', '\\4', $bbcode['replacement']); break; case 3: $bbcode['replacement'] = str_replace('{1}', '\\2', $bbcode['replacement']); $bbcode['replacement'] = str_replace('{2}', '\\5', $bbcode['replacement']); $bbcode['replacement'] = str_replace('{3}', '\\7', $bbcode['replacement']); break; default: $bbcode['replacement'] = str_replace('{1}', '\\1', $bbcode['replacement']); break; } if (preg_match("/\\{(RANDOM|MD5)\\}/", $bbcode['replacement'])) { $search = str_replace('is', 'ies', $search); $replace = '\'' . str_replace('{RANDOM}', '_\'.random(6).\'', str_replace('{MD5}', '_\'.md5(\'\\1\').\'', $bbcode['replacement'])) . '\''; } else { $replace = $bbcode['replacement']; } for ($i = 0; $i < $bbcode['nest']; $i++) { $data['searcharray'][] = $search; $data['replacearray'][] = $replace; } } break; case 'bbcodes_display': while ($bbcode = $db->fetch_array($query)) { $tag = $bbcode['tag']; $bbcode['explanation'] = dhtmlspecialchars(trim($bbcode['explanation'])); $bbcode['prompt'] = addcslashes($bbcode['prompt'], '\\\''); unset($bbcode['tag']); $data[$tag] = $bbcode; } break; case 'smilies': $data = array('searcharray' => array(), 'replacearray' => array(), 'typearray' => array()); while ($smiley = $db->fetch_array($query)) { $data['searcharray'][$smiley['id']] = '/' . preg_quote(dhtmlspecialchars($smiley['code']), '/') . '/'; $data['replacearray'][$smiley['id']] = $smiley['url']; $data['typearray'][$smiley['id']] = $smiley['typeid']; } break; case 'smilies_display': while ($type = $db->fetch_array($query)) { $squery = $db->query("SELECT id, code, url FROM {$tablepre}smilies WHERE type='smiley' AND code<>'' AND typeid='{$type['typeid']}' ORDER BY displayorder"); if ($db->num_rows($squery)) { while ($smiley = $db->fetch_array($squery)) { if ($size = @getimagesize('./images/smilies/' . $type['directory'] . '/' . $smiley['url'])) { $smiley['code'] = dhtmlspecialchars($smiley['code']); $smileyid = $smiley['id']; $s = smthumb($size, $GLOBALS['smthumb']); $smiley['w'] = $s['w']; $smiley['h'] = $s['h']; $l = smthumb($size); $smiley['lw'] = $l['w']; unset($smiley['id'], $smiley['directory']); $data[$type['typeid']][$smileyid] = $smiley; } } } } break; case 'smileytypes': while ($type = $db->fetch_array($query)) { $typeid = $type['typeid']; unset($type['typeid']); $squery = $db->query("SELECT COUNT(*) FROM {$tablepre}smilies WHERE type='smiley' AND code<>'' AND typeid='{$typeid}'"); if ($db->result($squery, 0)) { $data[$typeid] = $type; } } break; case 'icons': while ($icon = $db->fetch_array($query)) { $data[$icon['id']] = $icon['url']; } break; case in_array($cachename, array('fields_required', 'fields_optional')): while ($field = $db->fetch_array($query)) { $choices = array(); if ($field['selective']) { foreach (explode("\n", $field['choices']) as $item) { list($index, $choice) = explode('=', $item); $choices[trim($index)] = trim($choice); } $field['choices'] = $choices; } else { unset($field['choices']); } $data['field_' . $field['fieldid']] = $field; } break; case 'ipbanned': if ($db->num_rows($query)) { $data['expiration'] = 0; $data['regexp'] = $separator = ''; } while ($banned = $db->fetch_array($query)) { $data['expiration'] = !$data['expiration'] || $banned['expiration'] < $data['expiration'] ? $banned['expiration'] : $data['expiration']; $data['regexp'] .= $separator . ($banned['ip1'] == '-1' ? '\\d+\\.' : $banned['ip1'] . '\\.') . ($banned['ip2'] == '-1' ? '\\d+\\.' : $banned['ip2'] . '\\.') . ($banned['ip3'] == '-1' ? '\\d+\\.' : $banned['ip3'] . '\\.') . ($banned['ip4'] == '-1' ? '\\d+' : $banned['ip4']); $separator = '|'; } break; case 'google': $data = unserialize($db->result($query, 0)); $lr = $data['lang'] ? 'lang_' . $data['lang'] : ''; $jsdata = 'var google_host="' . $_SERVER['HTTP_HOST'] . '";var google_charset="' . $charset . '";var google_hl="' . $data['lang'] . '";var google_lr="' . $lr . '";'; $cachedir = DISCUZ_ROOT . './forumdata/cache/'; if (@($fp = fopen($cachedir . 'google_var.js', 'w'))) { fwrite($fp, $jsdata); fclose($fp); } else { exit('Can not write to cache files, please check directory ./forumdata/ and ./forumdata/cache/ .'); } break; case 'medals': while ($medal = $db->fetch_array($query)) { $data[$medal['medalid']] = array('name' => $medal['name'], 'image' => $medal['image']); } break; case 'magics': while ($magic = $db->fetch_array($query)) { $data[$magic['magicid']]['identifier'] = $magic['identifier']; $data[$magic['magicid']]['available'] = $magic['available']; $data[$magic['magicid']]['name'] = $magic['name']; $data[$magic['magicid']]['description'] = $magic['description']; $data[$magic['magicid']]['weight'] = $magic['weight']; $data[$magic['magicid']]['price'] = $magic['price']; } break; case 'birthdays_index': $bdaymembers = array(); while ($bdaymember = $db->fetch_array($query)) { $birthyear = intval($bdaymember['bday']); $bdaymembers[] = '<a href="space.php?uid=' . $bdaymember['uid'] . '" target="_blank" ' . ($birthyear ? 'title="' . $bdaymember['bday'] . '"' : '') . '>' . $bdaymember['username'] . '</a>'; } $data['todaysbdays'] = implode(', ', $bdaymembers); break; case 'birthdays': $data['uids'] = $comma = ''; $data['num'] = 0; while ($bdaymember = $db->fetch_array($query)) { $data['uids'] .= $comma . $bdaymember['uid']; $comma = ','; $data['num']++; } break; case 'modreasons': $modreasons = $db->result($query, 0); $modreasons = str_replace(array("\r\n", "\r"), array("\n", "\n"), $modreasons); $data = explode("\n", trim($modreasons)); break; case substr($cachename, 0, 5) == 'advs_': $data = advertisement(substr($cachename, 5)); break; case 'faqs': while ($faqs = $db->fetch_array($query)) { $data[$faqs['identifier']]['id'] = $faqs['id']; $data[$faqs['identifier']]['keyword'] = $faqs['keyword']; } break; case 'secqaa': $secqaanum = $db->result_first("SELECT COUNT(*) FROM {$tablepre}itempool"); $start_limit = $secqaanum <= 10 ? 0 : mt_rand(0, $secqaanum - 10); $query = $db->query("SELECT question, answer FROM {$tablepre}itempool LIMIT {$start_limit}, 10"); while ($secqaa = $db->fetch_array($query)) { $secqaa['answer'] = md5($secqaa['answer']); $data[] = $secqaa; } while (($secqaas = count($data)) < 10) { $data[$secqaas] = $data[array_rand($data)]; } break; case 'supe_updateusers': global $supe; supe_dbconnect(); if ($supe['status'] && $supe['maxupdateusers']) { $query = $supe['db']->query("SELECT uid, username FROM {$supe[tablepre]}userspaces WHERE islock=0 ORDER BY lastpost DESC LIMIT {$supe['maxupdateusers']}", 'SILENT'); while ($datarow = $supe['db']->fetch_array($query)) { $data[$datarow['uid']] = $datarow; } } break; case 'supe_updateitems': global $supe; supe_dbconnect(); if ($supe['status'] && $supe['items']['status']) { $limit = $supe['items']['rows'] * $supe['items']['columns']; switch ($supe['items']['orderby']) { case '1': $orderby = 'viewnum'; break; case '2': $orderby = 'replynum'; break; case '3': $orderby = 'dateline'; break; case '4': $orderby = 'lastpost'; break; default: $orderby = 'itemid'; } $supe['items']['hours'] = $supe['items']['hours'] > 0 ? $supe['items']['hours'] : 24; $conditions = !in_array($orderby, array('dateline', 'lastpost')) ? 'WHERE folder=1 AND type<>\'news\' AND dateline >=' . ($timestamp - $supe['items']['hours'] * 3600) : 'WHERE folder=1 AND type<>\'news\''; $query = $supe['db']->query("SELECT itemid, uid, username, type, subject FROM {$supe[tablepre]}spaceitems {$conditions} ORDER BY {$orderby} DESC LIMIT {$limit}", 'SILENT'); $itemtable = ''; $items = array(); include language('templates'); while ($item = $supe['db']->fetch_array($query)) { $typename = $language['supe_' . $item['type']]; $items[] = '<em>[<a href="' . $supe['siteurl'] . '/?action-' . $item['type'] . '" target="_blank">' . $typename . '</a>]</em> <cite><a href="' . $supe['siteurl'] . '/?uid-' . $item['uid'] . '" target="_blank">' . addcslashes(addslashes($item['username']), '\\\'') . '</a></cite>: <a href="' . $supe['siteurl'] . '/?action-viewspace-itemid-' . $item['itemid'] . '.html" target="_blank">' . addcslashes(addslashes(cutstr($item['subject'], 35)), '\\\'') . '</a>'; } if ($items) { for ($i = 0; $i < $limit; $i++) { $itemtable .= '<li style="width: ' . intval(100 / $supe['items']['columns']) . '%;">' . (isset($items[$i]) ? $items[$i] : ' ') . '</li>'; } } $data = $itemtable; } break; case 'supe_updatecircles': global $supe; if ($supe['status'] && $supe['circlestatus'] && $supe['updatecircles']) { supe_dbconnect(); $query = $supe['db']->query("SELECT gid, uid, username, groupname, logo, usernum, lastpost FROM {$supe['tablepre']}groups WHERE catid>0 AND flag=1 ORDER BY lastpost DESC LIMIT 8", 'SILENT'); while ($datarow = $supe['db']->fetch_array($query)) { $datarow['groupname'] = cutstr($datarow['groupname'], 30); $data[] = $datarow; } } break; case substr($cachename, 0, 5) == 'tags_': global $tagstatus, $hottags; $tagnames = array(); if ($tagstatus) { if (substr($cachename, 5) == 'index') { if ($hottags) { $tagary = array(); while ($tagrow = $db->fetch_array($query)) { $tagary[] = '<a href="tag.php?name=' . rawurlencode($tagrow['tagname']) . '" target="_blank">' . $tagrow['tagname'] . '<em>(' . $tagrow['total'] . ')</em></a>'; } $data = implode(' ', $tagary); } else { $data = ''; } } else { $data[0] = $data[1] = array(); while ($tagrow = $db->fetch_array($query)) { $data[0][] = $tagrow['tagname']; $data[1][] = rawurlencode($tagrow['tagname']); } $data[0] = '[\'' . implode('\',\'', $data[0]) . '\']'; $data[1] = '[\'' . implode('\',\'', $data[1]) . '\']'; } } break; default: while ($datarow = $db->fetch_array($query)) { $data[] = $datarow; } } $dbcachename = $cachename; $cachename = in_array(substr($cachename, 0, 5), array('advs_', 'tags_')) ? substr($cachename, 0, 4) : $cachename; $curdata = "\$_DCACHE['{$cachename}'] = " . arrayeval($data) . ";\n\n"; $db->query("REPLACE INTO {$tablepre}caches (cachename, type, dateline, data) VALUES ('{$dbcachename}', '1', '{$timestamp}', '" . addslashes($curdata) . "')"); return $curdata; }