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.' 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 808 | Zeile 817 |
---|
{ 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 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 930 | Zeile 939 |
---|
* @param int $lock_time */ function update_mailqueue($last_run=0, $lock_time=0)
|
* @param int $lock_time */ function update_mailqueue($last_run=0, $lock_time=0)
|
{ global $db;
| { global $db;
|
$query = $db->simple_select("mailqueue", "COUNT(*) AS queue_size"); $queue_size = $db->fetch_field($query, "queue_size");
| $query = $db->simple_select("mailqueue", "COUNT(*) AS queue_size"); $queue_size = $db->fetch_field($query, "queue_size");
|
Zeile 961 | Zeile 970 |
---|
);
$this->update("update_check", $update_cache);
|
);
$this->update("update_check", $update_cache);
|
}
| }
|
/** * Update default_theme cache */
| /** * Update default_theme cache */
|
Zeile 1002 | Zeile 1011 |
---|
/** * Updates the banned IPs cache
|
/** * Updates the banned IPs cache
|
*/
| */
|
function update_bannedips() { global $db;
| function update_bannedips() { global $db;
|
Zeile 1056 | Zeile 1065 |
---|
$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 1071 | Zeile 1080 |
---|
$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 1168 | Zeile 1177 |
---|
$time = TIME_NOW; // Look for announcements that don't end, or that are ending some time in the future $query = $db->simple_select("announcements", "fid", "enddate = '0' OR enddate > '{$time}'", array("order_by" => "aid"));
|
$time = TIME_NOW; // Look for announcements that don't end, or that are ending some time in the future $query = $db->simple_select("announcements", "fid", "enddate = '0' OR enddate > '{$time}'", array("order_by" => "aid"));
|
|
|
if($db->num_rows($query)) { while($forum = $db->fetch_array($query))
| if($db->num_rows($query)) { while($forum = $db->fetch_array($query))
|
Zeile 1176 | Zeile 1185 |
---|
if(!isset($fd_statistics[$forum['fid']]['announcements'])) { $fd_statistics[$forum['fid']]['announcements'] = 1;
|
if(!isset($fd_statistics[$forum['fid']]['announcements'])) { $fd_statistics[$forum['fid']]['announcements'] = 1;
|
} } }
| } } }
|
// Do we have any mod tools to use in our forums? $query = $db->simple_select("modtools", "forums, tid", '', array("order_by" => "tid"));
| // Do we have any mod tools to use in our forums? $query = $db->simple_select("modtools", "forums, tid", '', array("order_by" => "tid"));
|
Zeile 1206 | Zeile 1215 |
---|
}
$this->update("forumsdisplay", $fd_statistics);
|
}
$this->update("forumsdisplay", $fd_statistics);
|
}
/**
| }
/**
|
* Update profile fields cache. * */
| * Update profile fields cache. * */
|
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(
| { $reasons[$content][] = array(
|
'rid' => $reason['rid'], 'title' => $reason['title'], 'extra' => $reason['extra'],
| 'rid' => $reason['rid'], 'title' => $reason['title'], 'extra' => $reason['extra'],
|
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');
| |
} }
| } }
|