| Zeile 40 | Zeile 40 |
|---|
if($mybb->user['uid'] == 0 || $mybb->usergroup['canmodcp'] != 1)
{
error_no_permission();
|
if($mybb->user['uid'] == 0 || $mybb->usergroup['canmodcp'] != 1)
{
error_no_permission();
|
| | }
if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1)
{
$mybb->settings['threadsperpage'] = 20;
}
if(!$mybb->settings['postsperpage'] || (int)$mybb->settings['postsperpage'] < 1)
{
$mybb->settings['postsperpage'] = 20;
|
}
$errors = '';
| }
$errors = '';
|
| Zeile 127 | Zeile 137 |
|---|
if($mybb->input['action'] == "reports")
{
add_breadcrumb($lang->mcp_nav_reported_posts, "modcp.php?action=reports");
|
if($mybb->input['action'] == "reports")
{
add_breadcrumb($lang->mcp_nav_reported_posts, "modcp.php?action=reports");
|
if(!$mybb->settings['threadsperpage'])
{
$mybb->settings['threadsperpage'] = 20;
}
// Figure out if we need to display multiple pages.
$perpage = $mybb->settings['threadsperpage'];
if($mybb->input['page'] != "last")
{
$page = intval($mybb->input['page']);
}
|
if(!$mybb->settings['threadsperpage'])
{
$mybb->settings['threadsperpage'] = 20;
}
// Figure out if we need to display multiple pages.
$perpage = $mybb->settings['threadsperpage'];
if($mybb->input['page'] != "last")
{
$page = intval($mybb->input['page']);
}
|
$query = $db->simple_select("reportedposts", "COUNT(rid) AS count", "reportstatus ='0'");
$report_count = $db->fetch_field($query, "count");
|
$query = $db->simple_select("reportedposts", "COUNT(rid) AS count", "reportstatus ='0'");
$report_count = $db->fetch_field($query, "count");
|
|
|
$mybb->input['rid'] = intval($mybb->input['rid']);
if($mybb->input['rid'])
|
$mybb->input['rid'] = intval($mybb->input['rid']);
if($mybb->input['rid'])
|
{
| {
|
$query = $db->simple_select("reportedposts", "COUNT(rid) AS count", "rid <= '".$mybb->input['rid']."'");
$result = $db->fetch_field($query, "count");
if(($result % $perpage) == 0)
{
$page = $result / $perpage;
|
$query = $db->simple_select("reportedposts", "COUNT(rid) AS count", "rid <= '".$mybb->input['rid']."'");
$result = $db->fetch_field($query, "count");
if(($result % $perpage) == 0)
{
$page = $result / $perpage;
|
}
| }
|
else
{
$page = intval($result / $perpage) + 1;
| else
{
$page = intval($result / $perpage) + 1;
|
| Zeile 165 | Zeile 175 |
|---|
if($mybb->input['page'] == "last")
{
$page = $pages;
|
if($mybb->input['page'] == "last")
{
$page = $pages;
|
}
| }
|
if($page > $pages || $page <= 0)
{
|
if($page > $pages || $page <= 0)
{
|
| Zeile 190 | Zeile 200 |
|---|
}
$query = $db->simple_select("forums", "fid, name");
|
}
$query = $db->simple_select("forums", "fid, name");
|
while($forum = $db->fetch_array($query))
{
| while($forum = $db->fetch_array($query))
{
|
$forums[$forum['fid']] = $forum['name'];
|
$forums[$forum['fid']] = $forum['name'];
|
}
$plugins->run_hooks("modcp_reports_start");
| }
$plugins->run_hooks("modcp_reports_start");
|
$reports = '';
$query = $db->query("
|
$reports = '';
$query = $db->query("
|
| Zeile 226 | Zeile 236 |
|---|
$report['postlink'] = get_post_link($report['pid'], $report['tid']);
$report['threadlink'] = get_thread_link($report['tid']);
|
$report['postlink'] = get_post_link($report['pid'], $report['tid']);
$report['threadlink'] = get_thread_link($report['tid']);
|
|
|
$report['posterlink'] = get_profile_link($report['postuid']);
if(!$report['postuid'])
|
$report['posterlink'] = get_profile_link($report['postuid']);
if(!$report['postuid'])
|
{
| {
|
$report['posterlink'] = $report['postlink'];
$report['postusername'] = $lang->guest;
|
$report['posterlink'] = $report['postlink'];
$report['postusername'] = $lang->guest;
|
}
$report['reporterlink'] = get_profile_link($report['uid']);
if($report['uid'] > 0 && !$report['username'])
{
$report['reporterlink'] = $report['postlink'];
$report['username'] = $lang->na_deleted;
}
$reportdate = my_date($mybb->settings['dateformat'], $report['dateline']);
$reporttime = my_date($mybb->settings['timeformat'], $report['dateline']);
| }
$report['reporterlink'] = get_profile_link($report['uid']);
if($report['uid'] > 0 && !$report['username'])
{
$report['reporterlink'] = $report['postlink'];
$report['username'] = $lang->na_deleted;
}
$reportdate = my_date($mybb->settings['dateformat'], $report['dateline']);
$reporttime = my_date($mybb->settings['timeformat'], $report['dateline']);
|
$report['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($report['threadsubject']));
eval("\$reports .= \"".$templates->get("modcp_reports_report")."\";");
| $report['threadsubject'] = htmlspecialchars_uni($parser->parse_badwords($report['threadsubject']));
eval("\$reports .= \"".$templates->get("modcp_reports_report")."\";");
|
| Zeile 262 | Zeile 272 |
|---|
if(!$mybb->settings['threadsperpage'])
{
$mybb->settings['threadsperpage'] = 20;
|
if(!$mybb->settings['threadsperpage'])
{
$mybb->settings['threadsperpage'] = 20;
|
}
| }
|
// Figure out if we need to display multiple pages.
$perpage = $mybb->settings['threadsperpage'];
|
// Figure out if we need to display multiple pages.
$perpage = $mybb->settings['threadsperpage'];
|
| Zeile 289 | Zeile 299 |
|---|
}
}
$postcount = intval($warnings);
|
}
}
$postcount = intval($warnings);
|
$pages = $postcount / $perpage;
$pages = ceil($pages);
if($mybb->input['page'] == "last")
{
$page = $pages;
| $pages = $postcount / $perpage;
$pages = ceil($pages);
if($mybb->input['page'] == "last")
{
$page = $pages;
|
}
if($page > $pages || $page <= 0)
| }
if($page > $pages || $page <= 0)
|
| Zeile 398 | Zeile 408 |
|---|
}
$where = '';
|
}
$where = '';
|
|
|
// Searching for entries by a particular user
if($mybb->input['uid'])
{
| // Searching for entries by a particular user
if($mybb->input['uid'])
{
|
| Zeile 430 | Zeile 440 |
|---|
if($order != "asc")
{
$order = "desc";
|
if($order != "asc")
{
$order = "desc";
|
}
| }
|
$plugins->run_hooks("modcp_modlogs_start");
|
$plugins->run_hooks("modcp_modlogs_start");
|
| Zeile 450 | Zeile 460 |
|---|
}
$postcount = intval($rescount);
|
}
$postcount = intval($rescount);
|
$pages = $postcount / $perpage;
$pages = ceil($pages);
if($mybb->input['page'] == "last")
{
$page = $pages;
}
if($page > $pages || $page <= 0)
{
$page = 1;
}
if($page)
{
$start = ($page-1) * $perpage;
}
else
{
| $pages = $postcount / $perpage;
$pages = ceil($pages);
if($mybb->input['page'] == "last")
{
$page = $pages;
}
if($page > $pages || $page <= 0)
{
$page = 1;
}
if($page)
{
$start = ($page-1) * $perpage;
}
else
{
|
$start = 0;
$page = 1;
}
$multipage = multipage($postcount, $perpage, $page, "modcp.php?action=modlogs&perpage=$perpage&uid={$mybb->input['uid']}&fid={$mybb->input['fid']}&sortby={$mybb->input['sortby']}&order={$mybb->input['order']}");
if($postcount > $perpage)
|
$start = 0;
$page = 1;
}
$multipage = multipage($postcount, $perpage, $page, "modcp.php?action=modlogs&perpage=$perpage&uid={$mybb->input['uid']}&fid={$mybb->input['fid']}&sortby={$mybb->input['sortby']}&order={$mybb->input['order']}");
if($postcount > $perpage)
|
{
| {
|
eval("\$resultspages = \"".$templates->get("modcp_modlogs_multipage")."\";");
}
$query = $db->query("
|
eval("\$resultspages = \"".$templates->get("modcp_modlogs_multipage")."\";");
}
$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 1=1 {$where}{$tflist}
ORDER BY {$sortby} {$order}
LIMIT {$start}, {$perpage}
| WHERE 1=1 {$where}{$tflist}
ORDER BY {$sortby} {$order}
LIMIT {$start}, {$perpage}
|
| Zeile 505 | Zeile 514 |
|---|
if($logitem['fname'])
{
$information .= "<strong>{$lang->forum}</strong> <a href=\"".get_forum_link($logitem['fid'])."\" target=\"_blank\">{$logitem['fname']}</a><br />";
|
if($logitem['fname'])
{
$information .= "<strong>{$lang->forum}</strong> <a href=\"".get_forum_link($logitem['fid'])."\" target=\"_blank\">{$logitem['fname']}</a><br />";
|
}
if($logitem['psubject'])
{
$information .= "<strong>{$lang->post}</strong> <a href=\"".get_post_link($logitem['pid'])."#pid{$logitem['pid']}\">".htmlspecialchars_uni($logitem['psubject'])."</a>";
| |
}
// Edited a user or managed announcement?
|
}
// Edited a user or managed announcement?
|
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'])
|
| Zeile 526 | Zeile 531 |
|---|
}
eval("\$results .= \"".$templates->get("modcp_modlogs_result")."\";");
|
}
eval("\$results .= \"".$templates->get("modcp_modlogs_result")."\";");
|
}
| }
|
if(!$results)
{
eval("\$results = \"".$templates->get("modcp_modlogs_noresults")."\";");
|
if(!$results)
{
eval("\$results = \"".$templates->get("modcp_modlogs_noresults")."\";");
|
}
| }
|
$plugins->run_hooks("modcp_modlogs_filter");
|
$plugins->run_hooks("modcp_modlogs_filter");
|
| Zeile 550 | Zeile 555 |
|---|
if(!$user['username'])
{
$user['username'] = $lang->na_deleted;
|
if(!$user['username'])
{
$user['username'] = $lang->na_deleted;
|
}
| }
|
$selected = '';
if($mybb->input['uid'] == $user['uid'])
{
| $selected = '';
if($mybb->input['uid'] == $user['uid'])
{
|
| Zeile 561 | Zeile 566 |
|---|
}
$forum_select = build_forum_jump("", $mybb->input['fid'], 1, '', 0, true, '', "fid");
|
}
$forum_select = build_forum_jump("", $mybb->input['fid'], 1, '', 0, true, '', "fid");
|
|
|
eval("\$modlogs = \"".$templates->get("modcp_modlogs")."\";");
output_page($modlogs);
}
|
eval("\$modlogs = \"".$templates->get("modcp_modlogs")."\";");
output_page($modlogs);
}
|
|
|
if($mybb->input['action'] == "do_delete_announcement")
|
if($mybb->input['action'] == "do_delete_announcement")
|
{
verify_post_check($mybb->input['my_post_key']);
$aid = intval($mybb->input['aid']);
$query = $db->simple_select("announcements", "aid, subject, fid", "aid='{$aid}'");
$announcement = $db->fetch_array($query);
if(!$announcement['aid'])
{
error($lang->error_invalid_announcement);
}
if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
{
error_no_permission();
| {
verify_post_check($mybb->input['my_post_key']);
$aid = intval($mybb->input['aid']);
$query = $db->simple_select("announcements", "aid, subject, fid", "aid='{$aid}'");
$announcement = $db->fetch_array($query);
if(!$announcement['aid'])
{
error($lang->error_invalid_announcement);
}
if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
{
error_no_permission();
|
}
$plugins->run_hooks("modcp_do_delete_announcement");
| }
$plugins->run_hooks("modcp_do_delete_announcement");
|
| Zeile 601 | Zeile 606 |
|---|
$announcement['subject'] = htmlspecialchars_uni($announcement['subject']);
if(!$announcement['aid'])
|
$announcement['subject'] = htmlspecialchars_uni($announcement['subject']);
if(!$announcement['aid'])
|
{
| {
|
error($lang->error_invalid_announcement);
}
if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
|
error($lang->error_invalid_announcement);
}
if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
|
{
error_no_permission();
| {
error_no_permission();
|
}
$plugins->run_hooks("modcp_delete_announcement");
| }
$plugins->run_hooks("modcp_delete_announcement");
|
| Zeile 629 | Zeile 634 |
|---|
if(!trim($mybb->input['title']))
{
$errors[] = $lang->error_missing_title;
|
if(!trim($mybb->input['title']))
{
$errors[] = $lang->error_missing_title;
|
}
if(!trim($mybb->input['message']))
{
$errors[] = $lang->error_missing_message;
}
| }
if(!trim($mybb->input['message']))
{
$errors[] = $lang->error_missing_message;
}
|
if(!trim($mybb->input['fid']))
{
|
if(!trim($mybb->input['fid']))
{
|
| Zeile 793 | Zeile 798 |
|---|
else
{
$startdateday .= "<option value=\"$i\">$i</option>\n";
|
else
{
$startdateday .= "<option value=\"$i\">$i</option>\n";
|
}
| }
|
if($endday == $i)
{
$enddateday .= "<option value=\"$i\" selected=\"selected\">$i</option>\n";
| if($endday == $i)
{
$enddateday .= "<option value=\"$i\" selected=\"selected\">$i</option>\n";
|
| Zeile 900 | Zeile 905 |
|---|
}
// Mod has permissions to edit this announcement
|
}
// Mod has permissions to edit this announcement
|
if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
| if(($mybb->usergroup['issupermod'] != 1 && $announcement['fid'] == -1) || ($announcement['fid'] != -1 && !is_moderator($announcement['fid'])) || ($unviewableforums && in_array($announcement['fid'], $unviewableforums)))
|
{
error_no_permission();
}
// Basic error checking
if(!trim($mybb->input['title']))
|
{
error_no_permission();
}
// Basic error checking
if(!trim($mybb->input['title']))
|
{
| {
|
$errors[] = $lang->error_missing_title;
}
if(!trim($mybb->input['message']))
{
$errors[] = $lang->error_missing_message;
|
$errors[] = $lang->error_missing_title;
}
if(!trim($mybb->input['message']))
{
$errors[] = $lang->error_missing_message;
|
}
| }
|
if(!trim($mybb->input['fid']))
{
|
if(!trim($mybb->input['fid']))
{
|
| Zeile 927 | Zeile 932 |
|---|
$enddate = @explode(":", $enddate[0]);
if(stristr($mybb->input['starttime_time'], "pm"))
|
$enddate = @explode(":", $enddate[0]);
if(stristr($mybb->input['starttime_time'], "pm"))
|
{
| {
|
$startdate[0] = 12+$startdate[0];
if($startdate[0] >= 24)
{
$startdate[0] = "00";
|
$startdate[0] = 12+$startdate[0];
if($startdate[0] >= 24)
{
$startdate[0] = "00";
|
}
}
| }
}
|
if(stristr($mybb->input['endtime_time'], "pm"))
{
$enddate[0] = 12+$enddate[0];
| if(stristr($mybb->input['endtime_time'], "pm"))
{
$enddate[0] = 12+$enddate[0];
|
| Zeile 954 | Zeile 959 |
|---|
if(!checkdate(intval($mybb->input['starttime_month']), intval($mybb->input['starttime_day']), intval($mybb->input['starttime_year'])) || $startdate < 0 || $startdate == false)
{
$errors[] = $lang->error_invalid_start_date;
|
if(!checkdate(intval($mybb->input['starttime_month']), intval($mybb->input['starttime_day']), intval($mybb->input['starttime_year'])) || $startdate < 0 || $startdate == false)
{
$errors[] = $lang->error_invalid_start_date;
|
}
| }
|
if($mybb->input['endtime_type'] == "2")
{
$enddate = '0';
|
if($mybb->input['endtime_type'] == "2")
{
$enddate = '0';
|
}
else
| }
else
|
{
if(!in_array($mybb->input['endtime_month'], $months))
{
| {
if(!in_array($mybb->input['endtime_month'], $months))
{
|
| Zeile 992 | Zeile 997 |
|---|
'allowmycode' => $db->escape_string($mybb->input['allowmycode']),
'allowsmilies' => $db->escape_string($mybb->input['allowsmilies']),
);
|
'allowmycode' => $db->escape_string($mybb->input['allowmycode']),
'allowsmilies' => $db->escape_string($mybb->input['allowsmilies']),
);
|
|
|
$db->update_query("announcements", $update_announcement, "aid='{$aid}'");
|
$db->update_query("announcements", $update_announcement, "aid='{$aid}'");
|
|
|
log_moderator_action(array("aid" => $announcement['aid'], "subject" => $db->escape_string($mybb->input['title'])), $lang->announcement_edited);
|
log_moderator_action(array("aid" => $announcement['aid'], "subject" => $db->escape_string($mybb->input['title'])), $lang->announcement_edited);
|
|
|
$plugins->run_hooks("modcp_do_edit_announcement_end");
|
$plugins->run_hooks("modcp_do_edit_announcement_end");
|
|
|
$cache->update_forumsdisplay();
redirect("modcp.php?action=announcements", $lang->redirect_edit_announcement);
|
$cache->update_forumsdisplay();
redirect("modcp.php?action=announcements", $lang->redirect_edit_announcement);
|
}
| }
|
else
{
$mybb->input['action'] = 'edit_announcement';
|
else
{
$mybb->input['action'] = 'edit_announcement';
|
}
}
| }
}
|
if($mybb->input['action'] == "edit_announcement")
{
$announcement_fid = intval($mybb->input['fid']);
| if($mybb->input['action'] == "edit_announcement")
{
$announcement_fid = intval($mybb->input['fid']);
|
| Zeile 1114 | Zeile 1119 |
|---|
}
if($endday == $i)
|
}
if($endday == $i)
|
{
| {
|
$enddateday .= "<option value=\"$i\" selected=\"selected\">$i</option>\n";
}
else
| $enddateday .= "<option value=\"$i\" selected=\"selected\">$i</option>\n";
}
else
|
| Zeile 1221 | Zeile 1226 |
|---|
if($mybb->usergroup['issupermod'] == 1)
{
if($global_announcements && $mybb->usergroup['issupermod'] == 1)
|
if($mybb->usergroup['issupermod'] == 1)
{
if($global_announcements && $mybb->usergroup['issupermod'] == 1)
|
{
| {
|
// Get the global announcements
foreach($global_announcements as $aid => $announcement)
{
| // Get the global announcements
foreach($global_announcements as $aid => $announcement)
{
|
| Zeile 1327 | Zeile 1332 |
|---|
}
}
if(is_array($posts_to_approve))
|
}
}
if(is_array($posts_to_approve))
|
{
| {
|
$moderation->approve_posts($posts_to_approve);
}
log_moderator_action(array('pids' => $posts_to_approve), $lang->multi_approve_posts);
| $moderation->approve_posts($posts_to_approve);
}
log_moderator_action(array('pids' => $posts_to_approve), $lang->multi_approve_posts);
|
| Zeile 1922 | Zeile 1927 |
|---|
if(!empty($display_group['usertitle']))
{
|
if(!empty($display_group['usertitle']))
{
|
$defaulttitle = $display_group['usertitle'];
| $defaulttitle = htmlspecialchars_uni($display_group['usertitle']);
|
}
else
{
| }
else
{
|
| Zeile 1969 | Zeile 1974 |
|---|
while($profilefield = $db->fetch_array($query))
{
$profilefield['type'] = htmlspecialchars_uni($profilefield['type']);
|
while($profilefield = $db->fetch_array($query))
{
$profilefield['type'] = htmlspecialchars_uni($profilefield['type']);
|
| | $profilefield['name'] = htmlspecialchars_uni($profilefield['name']);
|
$profilefield['description'] = htmlspecialchars_uni($profilefield['description']);
$thing = explode("\n", $profilefield['type'], "2");
$type = $thing[0];
| $profilefield['description'] = htmlspecialchars_uni($profilefield['description']);
$thing = explode("\n", $profilefield['type'], "2");
$type = $thing[0];
|
| Zeile 2369 | Zeile 2375 |
|---|
$regtime = my_date($mybb->settings['timeformat'], $user['regdate']);
$lastdate = my_date($mybb->settings['dateformat'], $user['lastvisit']);
$lasttime = my_date($mybb->settings['timeformat'], $user['lastvisit']);
|
$regtime = my_date($mybb->settings['timeformat'], $user['regdate']);
$lastdate = my_date($mybb->settings['dateformat'], $user['lastvisit']);
$lasttime = my_date($mybb->settings['timeformat'], $user['lastvisit']);
|
$usergroup = $usergroups_cache[$user['usergroup']]['title'];
| $usergroup = htmlspecialchars_uni($usergroups_cache[$user['usergroup']]['title']);
|
eval("\$users .= \"".$templates->get("modcp_finduser_user")."\";");
}
| eval("\$users .= \"".$templates->get("modcp_finduser_user")."\";");
}
|
| Zeile 2610 | Zeile 2616 |
|---|
$query = $db->query("
SELECT COUNT(pid) AS count
FROM ".TABLE_PREFIX."posts
|
$query = $db->query("
SELECT COUNT(pid) AS count
FROM ".TABLE_PREFIX."posts
|
WHERE {$post_ip_sql}
");
| WHERE {$post_ip_sql} AND visible >= 0
");
|
$post_results = $db->fetch_field($query, "count");
}
|
$post_results = $db->fetch_field($query, "count");
}
|
| Zeile 2761 | Zeile 2767 |
|---|
$query = $db->query("
SELECT username AS postusername, uid, subject, pid, tid, ipaddress
FROM ".TABLE_PREFIX."posts
|
$query = $db->query("
SELECT username AS postusername, uid, subject, pid, tid, ipaddress
FROM ".TABLE_PREFIX."posts
|
WHERE {$post_ip_sql}
| WHERE {$post_ip_sql} AND visible >= 0
|
ORDER BY dateline DESC
LIMIT {$post_start}, {$post_limit}
");
| ORDER BY dateline DESC
LIMIT {$post_start}, {$post_limit}
");
|
| Zeile 3440 | Zeile 3446 |
|---|
}
$query = $db->query("
|
}
$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 l.dateline DESC
LIMIT 5
| {$where}
ORDER BY l.dateline DESC
LIMIT 5
|
| Zeile 3467 | Zeile 3472 |
|---|
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']}\">".htmlspecialchars_uni($logitem['psubject'])."</a>";
| |
}
// Edited a user or managed announcement?
|
}
// Edited a user or managed announcement?
|
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'])
|