| Zeile 120 | Zeile 120 |
|---|
$perpage = intval($mybb->input['perpage']);
if(!$perpage)
{
|
$perpage = intval($mybb->input['perpage']);
if(!$perpage)
{
|
| | if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1)
{
$mybb->settings['threadsperpage'] = 20;
}
|
$perpage = $mybb->settings['threadsperpage'];
|
$perpage = $mybb->settings['threadsperpage'];
|
}
$where = 'WHERE 1=1';
| }
$where = 'WHERE 1=1';
|
// Searching for entries by a particular user
if($mybb->input['uid'])
|
// Searching for entries by a particular user
if($mybb->input['uid'])
|
| Zeile 133 | Zeile 138 |
|---|
// Searching for entries in a specific forum
if($mybb->input['fid'] > 0)
|
// Searching for entries in a specific forum
if($mybb->input['fid'] > 0)
|
{
| {
|
$where .= " AND l.fid='".intval($mybb->input['fid'])."'";
}
| $where .= " AND l.fid='".intval($mybb->input['fid'])."'";
}
|
| Zeile 160 | Zeile 165 |
|---|
$query = $db->query("
SELECT COUNT(l.dateline) AS count
|
$query = $db->query("
SELECT COUNT(l.dateline) AS count
|
FROM ".TABLE_PREFIX."moderatorlog l
| FROM ".TABLE_PREFIX."moderatorlog l
|
{$where}
");
$rescount = $db->fetch_field($query, "count");
| {$where}
");
$rescount = $db->fetch_field($query, "count");
|
| Zeile 203 | Zeile 208 |
|---|
$table->construct_header($lang->ipaddress, array("class" => "align_center", 'width' => '10%'));
$query = $db->query("
|
$table->construct_header($lang->ipaddress, array("class" => "align_center", 'width' => '10%'));
$query = $db->query("
|
SELECT l.*, u.username, u.usergroup, u.displaygroup, t.subject AS tsubject, f.name AS fname, p.subject AS psubject
| SELECT l.*, u.username, u.usergroup, u.displaygroup, t.subject AS tsubject, f.name AS fname
|
FROM ".TABLE_PREFIX."moderatorlog l
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=l.uid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid)
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=l.fid)
|
FROM ".TABLE_PREFIX."moderatorlog l
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=l.uid)
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=l.tid)
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=l.fid)
|
LEFT JOIN ".TABLE_PREFIX."posts p ON (p.pid=l.pid)
| |
{$where}
ORDER BY {$sortby} {$order}
LIMIT {$start}, {$perpage}
| {$where}
ORDER BY {$sortby} {$order}
LIMIT {$start}, {$perpage}
|
| Zeile 228 | Zeile 232 |
|---|
if($logitem['fname'])
{
$information .= "<strong>{$lang->forum}</strong> <a href=\"../".get_forum_link($logitem['fid'])."\" target=\"_blank\">".htmlspecialchars_uni($logitem['fname'])."</a><br />";
|
if($logitem['fname'])
{
$information .= "<strong>{$lang->forum}</strong> <a href=\"../".get_forum_link($logitem['fid'])."\" target=\"_blank\">".htmlspecialchars_uni($logitem['fname'])."</a><br />";
|
}
if($logitem['psubject'])
{
$information .= "<strong>{$lang->post}</strong> <a href=\"../".get_post_link($logitem['pid'])."#pid{$logitem['pid']}\" target=\"_blank\">".htmlspecialchars_uni($logitem['psubject'])."</a>";
| |
}
|
}
|
if(!$logitem['tsubject'] || !$logitem['fname'] || !$logitem['psubject'])
| if(!$logitem['tsubject'] || !$logitem['fname'])
|
{
$data = unserialize($logitem['data']);
if($data['uid'])
| {
$data = unserialize($logitem['data']);
if($data['uid'])
|