Zeile 93 | Zeile 93 |
---|
case "apc": require_once MYBB_ROOT."/inc/cachehandlers/apc.php"; $this->handler = new apcCacheHandler();
|
case "apc": require_once MYBB_ROOT."/inc/cachehandlers/apc.php"; $this->handler = new apcCacheHandler();
|
| break; // APCu cache case "apcu": require_once MYBB_ROOT."/inc/cachehandlers/apcu.php"; $this->handler = new apcuCacheHandler(); break; // Redis cache case "redis": require_once MYBB_ROOT."/inc/cachehandlers/redis.php"; $this->handler = new redisCacheHandler();
|
break; }
if($this->handler instanceof CacheHandlerInterface)
|
break; }
if($this->handler instanceof CacheHandlerInterface)
|
{
| {
|
if(!$this->handler->connect())
|
if(!$this->handler->connect())
|
{
| {
|
$this->handler = null; } }
| $this->handler = null; } }
|
Zeile 108 | Zeile 118 |
---|
// Database cache $query = $db->simple_select("datacache", "title,cache"); while($data = $db->fetch_array($query))
|
// Database cache $query = $db->simple_select("datacache", "title,cache"); while($data = $db->fetch_array($query))
|
{
| {
|
$this->cache[$data['title']] = unserialize($data['cache']); } }
| $this->cache[$data['title']] = unserialize($data['cache']); } }
|
Zeile 133 | Zeile 143 |
---|
// If we're not hard refreshing, and this cache doesn't exist, return false // It would have been loaded pre-global if it did exist anyway... else if($hard == false && !($this->handler instanceof CacheHandlerInterface))
|
// If we're not hard refreshing, and this cache doesn't exist, return false // It would have been loaded pre-global if it did exist anyway... else if($hard == false && !($this->handler instanceof CacheHandlerInterface))
|
{ return false; }
if($this->handler instanceof CacheHandlerInterface) { get_execution_time();
$data = $this->handler->fetch($name);
| { return false; }
if($this->handler instanceof CacheHandlerInterface) { get_execution_time();
$data = $this->handler->fetch($name);
|
$call_time = get_execution_time(); $this->call_time += $call_time; $this->call_count++;
| $call_time = get_execution_time(); $this->call_time += $call_time; $this->call_count++;
|
Zeile 159 | Zeile 169 |
---|
// No data returned - cache gone bad? if($data === false)
|
// No data returned - cache gone bad? if($data === false)
|
{
| {
|
// Fetch from database $query = $db->simple_select("datacache", "title,cache", "title='".$db->escape_string($name)."'"); $cache_data = $db->fetch_array($query);
|
// Fetch from database $query = $db->simple_select("datacache", "title,cache", "title='".$db->escape_string($name)."'"); $cache_data = $db->fetch_array($query);
|
$data = unserialize($cache_data['cache']);
| $data = my_unserialize($cache_data['cache']);
|
// Update cache for handler get_execution_time();
| // Update cache for handler get_execution_time();
|
Zeile 186 | Zeile 196 |
---|
$query = $db->simple_select("datacache", "title,cache", "title='$name'"); $cache_data = $db->fetch_array($query);
|
$query = $db->simple_select("datacache", "title,cache", "title='$name'"); $cache_data = $db->fetch_array($query);
|
if(!$cache_data['title'])
| if(empty($cache_data['title']))
|
{ $data = false; }
| { $data = false; }
|
Zeile 194 | Zeile 204 |
---|
{ $data = unserialize($cache_data['cache']); }
|
{ $data = unserialize($cache_data['cache']); }
|
}
| }
|
// Cache locally $this->cache[$name] = $data;
| // Cache locally $this->cache[$name] = $data;
|
Zeile 213 | Zeile 223 |
---|
* Update cache contents. * * @param string $name The cache content identifier.
|
* Update cache contents. * * @param string $name The cache content identifier.
|
* @param string $contents The cache content.
| * @param mixed $contents The cache content.
|
*/ function update($name, $contents) {
| */ function update($name, $contents) {
|
Zeile 222 | Zeile 232 |
---|
$this->cache[$name] = $contents;
// We ALWAYS keep a running copy in the db just incase we need it
|
$this->cache[$name] = $contents;
// We ALWAYS keep a running copy in the db just incase we need it
|
$dbcontents = $db->escape_string(serialize($contents));
| $dbcontents = $db->escape_string(my_serialize($contents));
|
$replace_array = array( "title" => $db->escape_string($name),
| $replace_array = array( "title" => $db->escape_string($name),
|
Zeile 231 | Zeile 241 |
---|
$db->replace_query("datacache", $replace_array, "", false);
// Do we have a cache handler we're using?
|
$db->replace_query("datacache", $replace_array, "", false);
// Do we have a cache handler we're using?
|
if($this->handler instanceof CacheHandlerInterface) { get_execution_time();
$hit = $this->handler->put($name, $contents);
$call_time = get_execution_time(); $this->call_time += $call_time; $this->call_count++;
if($mybb->debug_mode)
| if($this->handler instanceof CacheHandlerInterface) { get_execution_time();
$hit = $this->handler->put($name, $contents);
$call_time = get_execution_time(); $this->call_time += $call_time; $this->call_count++;
if($mybb->debug_mode)
|
{ $this->debug_call('update:'.$name, $call_time, $hit); }
| { $this->debug_call('update:'.$name, $call_time, $hit); }
|
Zeile 258 | Zeile 268 |
---|
*/ function delete($name, $greedy = false) {
|
*/ function delete($name, $greedy = false) {
|
global $db, $mybb, $cache;
| global $db, $mybb, $cache;
|
// Prepare for database query. $dbname = $db->escape_string($name);
| // Prepare for database query. $dbname = $db->escape_string($name);
|
Zeile 466 | Zeile 476 |
---|
$types = array();
|
$types = array();
|
$query = $db->simple_select("attachtypes", "*");
| $query = $db->simple_select('attachtypes', '*', 'enabled=1');
|
while($type = $db->fetch_array($query)) { $type['extension'] = my_strtolower($type['extension']);
| while($type = $db->fetch_array($query)) { $type['extension'] = my_strtolower($type['extension']);
|
Zeile 531 | Zeile 541 |
---|
}
$this->update("badwords", $badwords);
|
}
$this->update("badwords", $badwords);
|
}
/**
| }
/**
|
* Update the usergroups cache. * */
| * Update the usergroups cache. * */
|
Zeile 550 | Zeile 560 |
---|
}
$this->update("usergroups", $gs);
|
}
$this->update("usergroups", $gs);
|
}
/**
| }
/**
|
* Update the forum permissions cache. * * @return bool When failed, returns false.
| * Update the forum permissions cache. * * @return bool When failed, returns false.
|
Zeile 561 | Zeile 571 |
---|
{ global $forum_cache, $db;
|
{ global $forum_cache, $db;
|
$this->built_forum_permissions = array(0);
| $this->forum_permissions = $this->built_forum_permissions = array(0);
|
// Get our forum list cache_forums(true);
| // Get our forum list cache_forums(true);
|
Zeile 589 | Zeile 599 |
---|
// Fetch forum permissions from the database $query = $db->simple_select("forumpermissions"); while($forum_permission = $db->fetch_array($query))
|
// Fetch forum permissions from the database $query = $db->simple_select("forumpermissions"); while($forum_permission = $db->fetch_array($query))
|
{
| {
|
$this->forum_permissions[$forum_permission['fid']][$forum_permission['gid']] = $forum_permission; }
|
$this->forum_permissions[$forum_permission['fid']][$forum_permission['gid']] = $forum_permission; }
|
|
|
$this->build_forum_permissions(); $this->update("forumpermissions", $this->built_forum_permissions);
| $this->build_forum_permissions(); $this->update("forumpermissions", $this->built_forum_permissions);
|
Zeile 607 | Zeile 617 |
---|
* @param int $pid An optional permission id. */ private function build_forum_permissions($permissions=array(), $pid=0)
|
* @param int $pid An optional permission id. */ private function build_forum_permissions($permissions=array(), $pid=0)
|
{
| {
|
$usergroups = array_keys($this->read("usergroups", true));
|
$usergroups = array_keys($this->read("usergroups", true));
|
if($this->forum_permissions_forum_cache[$pid])
| if(!empty($this->forum_permissions_forum_cache[$pid]))
|
{ foreach($this->forum_permissions_forum_cache[$pid] as $main) {
| { foreach($this->forum_permissions_forum_cache[$pid] as $main) {
|
Zeile 618 | Zeile 628 |
---|
$perms = $permissions; foreach($usergroups as $gid) {
|
$perms = $permissions; foreach($usergroups as $gid) {
|
if($this->forum_permissions[$forum['fid']][$gid])
| if(isset($this->forum_permissions[$forum['fid']][$gid]) && $this->forum_permissions[$forum['fid']][$gid])
|
{ $perms[$gid] = $this->forum_permissions[$forum['fid']][$gid]; }
|
{ $perms[$gid] = $this->forum_permissions[$forum['fid']][$gid]; }
|
if($perms[$gid])
| if(!empty($perms[$gid]))
|
{ $perms[$gid]['fid'] = $forum['fid']; $this->built_forum_permissions[$forum['fid']][$gid] = $perms[$gid];
| { $perms[$gid]['fid'] = $forum['fid']; $this->built_forum_permissions[$forum['fid']][$gid] = $perms[$gid];
|
Zeile 665 | Zeile 675 |
---|
$group_by = 'p.uid'; break; }
|
$group_by = 'p.uid'; break; }
|
$query = $db->query(' SELECT u.uid, u.username, COUNT(pid) AS poststoday FROM '.TABLE_PREFIX.'posts p LEFT JOIN '.TABLE_PREFIX.'users u ON (p.uid=u.uid) WHERE p.dateline>'.$timesearch.' GROUP BY '.$group_by.' ORDER BY poststoday DESC LIMIT 1 '); $topposter = $db->fetch_array($query);
| $query = $db->query(" SELECT u.uid, u.username, COUNT(*) AS poststoday FROM {$db->table_prefix}posts p LEFT JOIN {$db->table_prefix}users u ON (p.uid=u.uid) WHERE p.dateline > {$timesearch} AND p.visible=1 GROUP BY {$group_by} ORDER BY poststoday DESC ");
$most_posts = 0; $topposter = array(); while($user = $db->fetch_array($query)) { if($user['poststoday'] > $most_posts) { $most_posts = $user['poststoday']; $topposter = $user; } }
|
$query = $db->simple_select('users', 'COUNT(uid) AS posters', 'postnum>0'); $posters = $db->fetch_field($query, 'posters');
| $query = $db->simple_select('users', 'COUNT(uid) AS posters', 'postnum>0'); $posters = $db->fetch_field($query, 'posters');
|
Zeile 685 | Zeile 705 |
---|
'top_poster' => (array)$topposter, 'posters' => $posters );
|
'top_poster' => (array)$topposter, 'posters' => $posters );
|
|
|
$this->update('statistics', $statistics); }
/** * Update the moderators cache.
|
$this->update('statistics', $statistics); }
/** * Update the moderators cache.
|
*
| *
|
* @return bool Returns false on failure */ function update_moderators()
| * @return bool Returns false on failure */ function update_moderators()
|
Zeile 726 | Zeile 746 |
---|
$this->moderators = array();
// Fetch moderators from the database
|
$this->moderators = array();
// Fetch moderators from the database
|
$query = $db->query("
| $query = $db->query("
|
SELECT m.*, u.username, u.usergroup, u.displaygroup FROM ".TABLE_PREFIX."moderators m LEFT JOIN ".TABLE_PREFIX."users u ON (m.id=u.uid)
| SELECT m.*, u.username, u.usergroup, u.displaygroup FROM ".TABLE_PREFIX."moderators m LEFT JOIN ".TABLE_PREFIX."users u ON (m.id=u.uid)
|
Zeile 734 | Zeile 754 |
---|
ORDER BY u.username "); while($moderator = $db->fetch_array($query))
|
ORDER BY u.username "); while($moderator = $db->fetch_array($query))
|
{
| {
|
$this->moderators[$moderator['fid']]['users'][$moderator['id']] = $moderator; }
| $this->moderators[$moderator['fid']]['users'][$moderator['id']] = $moderator; }
|
Zeile 743 | Zeile 763 |
---|
function sort_moderators_by_usernames($a, $b) { return strcasecmp($a['username'], $b['username']);
|
function sort_moderators_by_usernames($a, $b) { return strcasecmp($a['username'], $b['username']);
|
} }
| } }
|
//Fetch moderating usergroups from the database $query = $db->query("
| //Fetch moderating usergroups from the database $query = $db->query("
|
Zeile 755 | Zeile 775 |
---|
ORDER BY u.title "); while($moderator = $db->fetch_array($query))
|
ORDER BY u.title "); while($moderator = $db->fetch_array($query))
|
{
| {
|
$this->moderators[$moderator['fid']]['usergroups'][$moderator['id']] = $moderator;
|
$this->moderators[$moderator['fid']]['usergroups'][$moderator['id']] = $moderator;
|
}
if(is_array($this->moderators)) { foreach(array_keys($this->moderators) as $fid) { uasort($this->moderators[$fid], 'sort_moderators_by_usernames'); }
| }
foreach(array_keys($this->moderators) as $fid) { if(isset($this->moderators[$fid]['users'])) { uasort($this->moderators[$fid]['users'], 'sort_moderators_by_usernames'); }
|
}
$this->build_moderators();
| }
$this->build_moderators();
|
Zeile 787 | Zeile 807 |
---|
$data = array( 'users' => $awaitingusers,
|
$data = array( 'users' => $awaitingusers,
|
'time' => TIME_NOW
| 'time' => TIME_NOW
|
);
$this->update('awaitingactivation', $data);
| );
$this->update('awaitingactivation', $data);
|
Zeile 808 | Zeile 828 |
---|
{ foreach($main as $forum) {
|
{ foreach($main as $forum) {
|
$forum_mods = '';
| $forum_mods = array();
|
if(count($moderators)) { $forum_mods = $moderators;
| if(count($moderators)) { $forum_mods = $moderators;
|
Zeile 819 | Zeile 839 |
---|
if(is_array($forum_mods) && count($forum_mods)) { $forum_mods = array_merge($forum_mods, $this->moderators[$forum['fid']]);
|
if(is_array($forum_mods) && count($forum_mods)) { $forum_mods = array_merge($forum_mods, $this->moderators[$forum['fid']]);
|
}
| }
|
else { $forum_mods = $this->moderators[$forum['fid']];
| else { $forum_mods = $this->moderators[$forum['fid']];
|
Zeile 837 | Zeile 857 |
---|
* */ function update_forums()
|
* */ function update_forums()
|
{ global $db;
$forums = array();
| { global $db;
$forums = array();
|
// Things we don't want to cache $exclude = array("unapprovedthreads", "unapprovedposts", "threads", "posts", "lastpost", "lastposter", "lastposttid", "lastposteruid", "lastpostsubject", "deletedthreads", "deletedposts");
| // Things we don't want to cache $exclude = array("unapprovedthreads", "unapprovedposts", "threads", "posts", "lastpost", "lastposter", "lastposttid", "lastposteruid", "lastpostsubject", "deletedthreads", "deletedposts");
|
Zeile 856 | Zeile 876 |
---|
} } $forums[$forum['fid']] = $forum;
|
} } $forums[$forum['fid']] = $forum;
|
}
| }
|
$this->update("forums", $forums); }
/** * Update usertitles cache.
|
$this->update("forums", $forums); }
/** * Update usertitles cache.
|
*
| *
|
*/ function update_usertitles() {
| */ function update_usertitles() {
|
Zeile 885 | Zeile 905 |
---|
*/ function update_reportedcontent() {
|
*/ function update_reportedcontent() {
|
global $db, $mybb;
| global $db;
|
$query = $db->simple_select("reportedcontent", "COUNT(rid) AS unreadcount", "reportstatus='0'");
|
$query = $db->simple_select("reportedcontent", "COUNT(rid) AS unreadcount", "reportstatus='0'");
|
$num = $db->fetch_array($query);
| $unreadcount = $db->fetch_field($query, 'unreadcount');
|
$query = $db->simple_select("reportedcontent", "COUNT(rid) AS reportcount");
|
$query = $db->simple_select("reportedcontent", "COUNT(rid) AS reportcount");
|
$total = $db->fetch_array($query);
$query = $db->simple_select("reportedcontent", "dateline", "reportstatus='0'", array('order_by' => 'dateline', 'order_dir' => 'DESC')); $latest = $db->fetch_array($query);
$reasons = array();
if(!empty($mybb->settings['reportreasons'])) { $options = $mybb->settings['reportreasons']; $options = explode("\n", $options);
foreach($options as $option) { $option = explode("=", $option); $reasons[$option[0]] = $option[1]; } }
| $reportcount = $db->fetch_field($query, 'reportcount'); $query = $db->simple_select("reportedcontent", "dateline", "reportstatus='0'", array('order_by' => 'dateline', 'order_dir' => 'DESC', 'limit' => 1)); $dateline = $db->fetch_field($query, 'dateline');
|
$reports = array(
|
$reports = array(
|
"unread" => $num['unreadcount'], "total" => $total['reportcount'], "lastdateline" => $latest['dateline'], "reasons" => $reasons
| 'unread' => $unreadcount, 'total' => $reportcount, 'lastdateline' => $dateline,
|
);
$this->update("reportedcontent", $reports);
| );
$this->update("reportedcontent", $reports);
|
Zeile 1071 | Zeile 1076 |
---|
$threads = array();
|
$threads = array();
|
$query = $db->simple_select("threads", "tid, subject, replies, fid", "visible='1'", array('order_by' => 'replies', 'order_dir' => 'DESC', 'limit_start' => 0, 'limit' => $mybb->settings['statslimit']));
| $query = $db->simple_select("threads", "tid, subject, replies, fid, uid", "visible='1'", array('order_by' => 'replies', 'order_dir' => 'DESC', 'limit_start' => 0, 'limit' => $mybb->settings['statslimit']));
|
while($thread = $db->fetch_array($query)) { $threads[] = $thread;
| while($thread = $db->fetch_array($query)) { $threads[] = $thread;
|
Zeile 1086 | Zeile 1091 |
---|
$threads = array();
|
$threads = array();
|
$query = $db->simple_select("threads", "tid, subject, views, fid", "visible='1'", array('order_by' => 'views', 'order_dir' => 'DESC', 'limit_start' => 0, 'limit' => $mybb->settings['statslimit']));
| $query = $db->simple_select("threads", "tid, subject, views, fid, uid", "visible='1'", array('order_by' => 'views', 'order_dir' => 'DESC', 'limit_start' => 0, 'limit' => $mybb->settings['statslimit']));
|
while($thread = $db->fetch_array($query)) { $threads[] = $thread;
| while($thread = $db->fetch_array($query)) { $threads[] = $thread;
|
Zeile 1095 | Zeile 1100 |
---|
$this->update("most_viewed_threads", $threads); }
|
$this->update("most_viewed_threads", $threads); }
|
| /** * @deprecated */
|
function update_banned()
|
function update_banned()
|
{ global $db;
$bans = array();
$query = $db->simple_select("banned"); while($ban = $db->fetch_array($query)) { $bans[$ban['uid']] = $ban; }
$this->update("banned", $bans);
| { // "banned" cache removed
|
}
|
}
|
|
|
function update_birthdays()
|
function update_birthdays()
|
{ global $db;
| { global $db;
|
$birthdays = array();
// Get today, yesterday, and tomorrow's time (for different timezones)
| $birthdays = array();
// Get today, yesterday, and tomorrow's time (for different timezones)
|
Zeile 1132 | Zeile 1130 |
---|
if($bday['birthdayprivacy'] != 'all') {
|
if($bday['birthdayprivacy'] != 'all') {
|
++$birthdays[$bday['bday']]['hiddencount'];
| if(isset($birthdays[$bday['bday']]['hiddencount'])) { ++$birthdays[$bday['bday']]['hiddencount']; } else { $birthdays[$bday['bday']]['hiddencount'] = 1; }
|
continue;
|
continue;
|
}
| }
|
// We don't need any excess caleries in the cache unset($bday['birthdayprivacy']);
|
// We don't need any excess caleries in the cache unset($bday['birthdayprivacy']);
|
| if(!isset($birthdays[$bday['bday']]['users'])) { $birthdays[$bday['bday']]['users'] = array(); }
|
$birthdays[$bday['bday']]['users'][] = $bday; }
| $birthdays[$bday['bday']]['users'][] = $bday; }
|
Zeile 1153 | Zeile 1163 |
---|
$query = $db->simple_select("groupleaders"); while($groupleader = $db->fetch_array($query))
|
$query = $db->simple_select("groupleaders"); while($groupleader = $db->fetch_array($query))
|
{
| {
|
$groupleaders[$groupleader['uid']][] = $groupleader; }
| $groupleaders[$groupleader['uid']][] = $groupleader; }
|
Zeile 1208 | Zeile 1218 |
---|
foreach($forums as $forum) { if(!$forum)
|
foreach($forums as $forum) { if(!$forum)
|
{
| {
|
$forum = -1;
|
$forum = -1;
|
}
| }
|
if(!isset($fd_statistics[$forum]['modtools'])) {
| if(!isset($fd_statistics[$forum]['modtools'])) {
|
Zeile 1225 | Zeile 1235 |
---|
/** * Update profile fields cache.
|
/** * Update profile fields cache.
|
* */
| * */
|
function update_profilefields()
|
function update_profilefields()
|
{ global $db;
| { global $db;
|
$fields = array(); $query = $db->simple_select("profilefields", "*", "", array('order_by' => 'disporder'));
| $fields = array(); $query = $db->simple_select("profilefields", "*", "", array('order_by' => 'disporder'));
|
Zeile 1239 | Zeile 1249 |
---|
}
$this->update("profilefields", $fields);
|
}
$this->update("profilefields", $fields);
|
| }
/** * Update the report reasons cache. * */ function update_reportreasons($no_plugins = false) { global $db;
$content_types = array('post', 'profile', 'reputation'); if(!$no_plugins) { global $plugins; $content_types = $plugins->run_hooks("report_content_types", $content_types); }
$reasons = array();
$query = $db->simple_select("reportreasons", "*", "", array('order_by' => 'disporder')); while($reason = $db->fetch_array($query)) { if($reason['appliesto'] == 'all') { foreach($content_types as $content) { $reasons[$content][] = array( 'rid' => $reason['rid'], 'title' => $reason['title'], 'extra' => $reason['extra'], ); } } elseif($reason['appliesto'] != '') { $appliesto = explode(",", $reason['appliesto']); foreach($appliesto as $content) { $reasons[$content][] = array( 'rid' => $reason['rid'], 'title' => $reason['title'], 'extra' => $reason['extra'], ); } } }
$this->update("reportreasons", $reasons);
|
}
/* Other, extra functions for reloading caches if we just changed to another cache extension (i.e. from db -> xcache) */ function reload_mostonline()
|
}
/* Other, extra functions for reloading caches if we just changed to another cache extension (i.e. from db -> xcache) */ function reload_mostonline()
|
{ global $db;
| { global $db;
|
$query = $db->simple_select("datacache", "title,cache", "title='mostonline'"); $this->update("mostonline", unserialize($db->fetch_field($query, "cache")));
| $query = $db->simple_select("datacache", "title,cache", "title='mostonline'"); $this->update("mostonline", unserialize($db->fetch_field($query, "cache")));
|
Zeile 1280 | Zeile 1338 |
---|
$query = $db->simple_select("datacache", "title,cache", "title='version_history'"); $this->update("version_history", unserialize($db->fetch_field($query, "cache")));
|
$query = $db->simple_select("datacache", "title,cache", "title='version_history'"); $this->update("version_history", unserialize($db->fetch_field($query, "cache")));
|
}
| }
|
function reload_modnotes()
|
function reload_modnotes()
|
{ global $db;
| { global $db;
|
$query = $db->simple_select("datacache", "title,cache", "title='modnotes'"); $this->update("modnotes", unserialize($db->fetch_field($query, "cache")));
|
$query = $db->simple_select("datacache", "title,cache", "title='modnotes'"); $this->update("modnotes", unserialize($db->fetch_field($query, "cache")));
|
}
| }
|
function reload_adminnotes()
|
function reload_adminnotes()
|
{
| {
|
global $db;
|
global $db;
|
|
|
$query = $db->simple_select("datacache", "title,cache", "title='adminnotes'"); $this->update("adminnotes", unserialize($db->fetch_field($query, "cache")));
|
$query = $db->simple_select("datacache", "title,cache", "title='adminnotes'"); $this->update("adminnotes", unserialize($db->fetch_field($query, "cache")));
|
}
function reload_mybb_credits() { admin_redirect('index.php?module=home-credits&fetch_new=-2');
| |
} }
| } }
|