Zeile 258 | Zeile 258 |
---|
*/ 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 666 | Zeile 666 |
---|
break; }
|
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.' AND p.visible=1 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; 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 694 |
---|
'top_poster' => (array)$topposter, 'posters' => $posters );
|
'top_poster' => (array)$topposter, 'posters' => $posters );
|
|
|
$this->update('statistics', $statistics); }
| $this->update('statistics', $statistics); }
|
Zeile 705 | Zeile 714 |
---|
if(!is_array($forum_cache)) { return false;
|
if(!is_array($forum_cache)) { return false;
|
}
| }
|
reset($forum_cache); $fcache = array();
| reset($forum_cache); $fcache = array();
|
Zeile 726 | Zeile 735 |
---|
$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 736 | Zeile 745 |
---|
while($moderator = $db->fetch_array($query)) { $this->moderators[$moderator['fid']]['users'][$moderator['id']] = $moderator;
|
while($moderator = $db->fetch_array($query)) { $this->moderators[$moderator['fid']]['users'][$moderator['id']] = $moderator;
|
}
| }
|
if(!function_exists("sort_moderators_by_usernames")) { function sort_moderators_by_usernames($a, $b)
| if(!function_exists("sort_moderators_by_usernames")) { function sort_moderators_by_usernames($a, $b)
|
Zeile 757 | Zeile 766 |
---|
while($moderator = $db->fetch_array($query)) { $this->moderators[$moderator['fid']]['usergroups'][$moderator['id']] = $moderator;
|
while($moderator = $db->fetch_array($query)) { $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');
|
if(is_array($this->moderators)) { foreach(array_keys($this->moderators) as $fid) { uasort($this->moderators[$fid], 'sort_moderators_by_usernames');
|
} }
$this->build_moderators();
| } }
$this->build_moderators();
|
$this->update("moderators", $this->built_moderators);
|
$this->update("moderators", $this->built_moderators);
|
|
|
return true; }
/** * Update the users awaiting activation cache.
|
return true; }
/** * Update the users awaiting activation cache.
|
*
| *
|
*/ function update_awaitingactivation() {
| */ function update_awaitingactivation() {
|
Zeile 837 | Zeile 846 |
---|
* */ function update_forums()
|
* */ function update_forums()
|
{ global $db;
| { global $db;
|
$forums = array();
// Things we don't want to cache
| $forums = array();
// Things we don't want to cache
|
Zeile 859 | Zeile 868 |
---|
}
$this->update("forums", $forums);
|
}
$this->update("forums", $forums);
|
}
| }
|
/** * Update usertitles cache. *
| /** * Update usertitles cache. *
|
Zeile 901 | Zeile 910 |
---|
"total" => $total['reportcount'], "lastdateline" => $latest['dateline'] );
|
"total" => $total['reportcount'], "lastdateline" => $latest['dateline'] );
|
|
|
$this->update("reportedcontent", $reports); }
| $this->update("reportedcontent", $reports); }
|
Zeile 921 | Zeile 930 |
---|
}
$this->update("mycode", $mycodes);
|
}
$this->update("mycode", $mycodes);
|
}
| }
|
/** * Update the mailqueue cache
| /** * Update the mailqueue cache
|
Zeile 1081 | Zeile 1090 |
---|
}
function update_banned()
|
}
function update_banned()
|
{ global $db;
$bans = array();
| { global $db;
$bans = array();
|
$query = $db->simple_select("banned"); while($ban = $db->fetch_array($query)) {
| $query = $db->simple_select("banned"); while($ban = $db->fetch_array($query)) {
|
Zeile 1249 | Zeile 1258 |
---|
if($reason['appliesto'] == 'all') { foreach($content_types as $content)
|
if($reason['appliesto'] == 'all') { foreach($content_types as $content)
|
{
| {
|
$reasons[$content][] = array( 'rid' => $reason['rid'], 'title' => $reason['title'],
| $reasons[$content][] = array( 'rid' => $reason['rid'], 'title' => $reason['title'],
|
Zeile 1276 | Zeile 1285 |
---|
/* 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 1297 | Zeile 1306 |
---|
$query = $db->simple_select("datacache", "title,cache", "title='last_backup'"); $this->update("last_backup", unserialize($db->fetch_field($query, "cache")));
|
$query = $db->simple_select("datacache", "title,cache", "title='last_backup'"); $this->update("last_backup", unserialize($db->fetch_field($query, "cache")));
|
}
| }
|
function reload_internal_settings() { global $db;
|
function reload_internal_settings() { global $db;
|
|
|
$query = $db->simple_select("datacache", "title,cache", "title='internal_settings'"); $this->update("internal_settings", unserialize($db->fetch_field($query, "cache"))); }
function reload_version_history()
|
$query = $db->simple_select("datacache", "title,cache", "title='internal_settings'"); $this->update("internal_settings", unserialize($db->fetch_field($query, "cache"))); }
function reload_version_history()
|
{ global $db;
| { global $db;
|
$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() { global $db;
|
function reload_adminnotes() { 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');
| |
} }
| } }
|