Zeile 117 | Zeile 117 |
---|
$query = $db->simple_select("datacache", "title,cache"); while($data = $db->fetch_array($query)) {
|
$query = $db->simple_select("datacache", "title,cache"); while($data = $db->fetch_array($query)) {
|
$this->cache[$data['title']] = my_unserialize($data['cache']);
| $this->cache[$data['title']] = unserialize($data['cache']);
|
} } }
| } } }
|
Zeile 171 | Zeile 171 |
---|
// 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 = my_unserialize($cache_data['cache']);
| $data = unserialize($cache_data['cache']);
|
// Update cache for handler get_execution_time();
| // Update cache for handler get_execution_time();
|
Zeile 200 | Zeile 200 |
---|
} else {
|
} else {
|
$data = my_unserialize($cache_data['cache']);
| $data = unserialize($cache_data['cache']);
|
} }
| } }
|
Zeile 659 | Zeile 659 |
---|
function update_statistics() { global $db;
|
function update_statistics() { global $db;
|
$query = $db->simple_select('forums', 'fid, threads, posts', $fidnot.'type=\'f\'', array('order_by' => 'posts', 'order_dir' => 'DESC', 'limit' => 1)); $forum = $db->fetch_array($query);
| |
$query = $db->simple_select('users', 'uid, username, referrals', 'referrals>0', array('order_by' => 'referrals', 'order_dir' => 'DESC', 'limit' => 1)); $topreferrer = $db->fetch_array($query);
| $query = $db->simple_select('users', 'uid, username, referrals', 'referrals>0', array('order_by' => 'referrals', 'order_dir' => 'DESC', 'limit' => 1)); $topreferrer = $db->fetch_array($query);
|
Zeile 678 | Zeile 675 |
---|
}
$query = $db->query('
|
}
$query = $db->query('
|
SELECT u.uid, u.username, COUNT(*) AS poststoday
| 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.'
| FROM '.TABLE_PREFIX.'posts p LEFT JOIN '.TABLE_PREFIX.'users u ON (p.uid=u.uid) WHERE p.dateline>'.$timesearch.'
|
Zeile 687 | Zeile 684 |
---|
'); $topposter = $db->fetch_array($query);
|
'); $topposter = $db->fetch_array($query);
|
$query = $db->simple_select('users', 'COUNT(*) AS posters', 'postnum>0');
| $query = $db->simple_select('users', 'COUNT(uid) AS posters', 'postnum>0');
|
$posters = $db->fetch_field($query, 'posters');
$statistics = array( 'time' => TIME_NOW,
|
$posters = $db->fetch_field($query, 'posters');
$statistics = array( 'time' => TIME_NOW,
|
'top_forum' => (array)$forum,
| |
'top_referrer' => (array)$topreferrer, 'top_poster' => (array)$topposter,
|
'top_referrer' => (array)$topreferrer, 'top_poster' => (array)$topposter,
|
'posters' => (int)$posters, );
| 'posters' => $posters, );
|
$this->update('statistics', $statistics); }
| $this->update('statistics', $statistics); }
|
Zeile 729 | Zeile 725 |
---|
// Sort children foreach($fcache as $pid => $value)
|
// Sort children foreach($fcache as $pid => $value)
|
{
| {
|
ksort($fcache[$pid]); } ksort($fcache);
| ksort($fcache[$pid]); } ksort($fcache);
|
Zeile 743 | Zeile 739 |
---|
LEFT JOIN ".TABLE_PREFIX."users u ON (m.id=u.uid) WHERE m.isgroup = '0' ORDER BY u.username
|
LEFT JOIN ".TABLE_PREFIX."users u ON (m.id=u.uid) WHERE m.isgroup = '0' ORDER BY u.username
|
"); while($moderator = $db->fetch_array($query)) {
| "); while($moderator = $db->fetch_array($query)) {
|
$this->moderators[$moderator['fid']]['users'][$moderator['id']] = $moderator; }
| $this->moderators[$moderator['fid']]['users'][$moderator['id']] = $moderator; }
|
Zeile 778 | Zeile 774 |
---|
} }
|
} }
|
$this->build_moderators();
| $this->build_moderators();
|
$this->update("moderators", $this->built_moderators); }
| $this->update("moderators", $this->built_moderators); }
|
Zeile 794 | Zeile 790 |
---|
$query = $db->simple_select('users', 'COUNT(uid) AS awaitingusers', 'usergroup=\'5\''); $awaitingusers = (int)$db->fetch_field($query, 'awaitingusers');
|
$query = $db->simple_select('users', 'COUNT(uid) AS awaitingusers', 'usergroup=\'5\''); $awaitingusers = (int)$db->fetch_field($query, 'awaitingusers');
|
$this->update('awaitingactivation', array('users' => $awaitingusers));
| $data = array( 'users' => $awaitingusers, 'time' => TIME_NOW, );
$this->update('awaitingactivation', $data);
|
}
/**
| }
/**
|
Zeile 847 | Zeile 848 |
---|
$forums = array();
// Things we don't want to cache
|
$forums = array();
// Things we don't want to cache
|
$exclude = array("unapprovedthreads", "unapprovedposts", "threads", "posts", "lastpost", "lastposter", "lastposttid", "deletedthreads", "deletedposts");
| $exclude = array("unapprovedthreads", "unapprovedposts", "threads", "posts", "lastpost", "lastposter", "lastposttid", "lastposteruid", "lastpostsubject", "deletedthreads", "deletedposts");
|
$query = $db->simple_select("forums", "*", "", array('order_by' => 'pid,disporder')); while($forum = $db->fetch_array($query))
| $query = $db->simple_select("forums", "*", "", array('order_by' => 'pid,disporder')); while($forum = $db->fetch_array($query))
|
Zeile 1250 | Zeile 1251 |
---|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='mostonline'");
|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='mostonline'");
|
$this->update("mostonline", my_unserialize($db->fetch_field($query, "cache")));
| $this->update("mostonline", unserialize($db->fetch_field($query, "cache")));
|
}
function reload_plugins()
| }
function reload_plugins()
|
Zeile 1258 | Zeile 1259 |
---|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='plugins'");
|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='plugins'");
|
$this->update("plugins", my_unserialize($db->fetch_field($query, "cache")));
| $this->update("plugins", unserialize($db->fetch_field($query, "cache")));
|
}
function reload_last_backup()
| }
function reload_last_backup()
|
Zeile 1266 | Zeile 1267 |
---|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='last_backup'");
|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='last_backup'");
|
$this->update("last_backup", my_unserialize($db->fetch_field($query, "cache")));
| $this->update("last_backup", unserialize($db->fetch_field($query, "cache")));
|
}
function reload_internal_settings()
| }
function reload_internal_settings()
|
Zeile 1274 | Zeile 1275 |
---|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='internal_settings'");
|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='internal_settings'");
|
$this->update("internal_settings", my_unserialize($db->fetch_field($query, "cache")));
| $this->update("internal_settings", unserialize($db->fetch_field($query, "cache")));
|
}
function reload_version_history()
| }
function reload_version_history()
|
Zeile 1282 | Zeile 1283 |
---|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='version_history'");
|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='version_history'");
|
$this->update("version_history", my_unserialize($db->fetch_field($query, "cache")));
| $this->update("version_history", unserialize($db->fetch_field($query, "cache")));
|
}
function reload_modnotes()
| }
function reload_modnotes()
|
Zeile 1290 | Zeile 1291 |
---|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='modnotes'");
|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='modnotes'");
|
$this->update("modnotes", my_unserialize($db->fetch_field($query, "cache")));
| $this->update("modnotes", unserialize($db->fetch_field($query, "cache")));
|
}
function reload_adminnotes()
| }
function reload_adminnotes()
|
Zeile 1298 | Zeile 1299 |
---|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='adminnotes'");
|
global $db;
$query = $db->simple_select("datacache", "title,cache", "title='adminnotes'");
|
$this->update("adminnotes", my_unserialize($db->fetch_field($query, "cache")));
| $this->update("adminnotes", unserialize($db->fetch_field($query, "cache")));
|
}
function reload_mybb_credits()
| }
function reload_mybb_credits()
|