$where_sql[] = '(o.expire_date IS NULL OR o.expire_date >= ' . $forum_page['now'] . ')'; } // Fetch warnings count $query = array('SELECT' => 'COUNT(o.id)', 'FROM' => 'om_warnings_reports AS o', 'JOINS' => array(array('JOIN' => 'users AS u', 'ON' => 'o.user_id=u.id'))); if ($where_sql) { $query['WHERE'] = implode(' AND ', $where_sql); } ($hook = get_hook('om_warnings_list_qr_get_warning_count')) ? eval($hook) : null; $result = $forum_db->query_build($query) or error(__FILE__, __LINE__); $forum_page['num_warn'] = $forum_db->result($result); // Handling the pagination $forum_page['num_pages'] = ceil($forum_page['num_warn'] / OM_WARNINGS_WARN_PER_PAGE); $forum_page['page'] = !isset($_GET['p']) || !is_numeric($_GET['p']) || $_GET['p'] <= 1 || $_GET['p'] > $forum_page['num_pages'] ? 1 : intval($_GET['p']); $forum_page['start_from'] = OM_WARNINGS_WARN_PER_PAGE * ($forum_page['page'] - 1); $forum_page['finish_at'] = min($forum_page['start_from'] + OM_WARNINGS_WARN_PER_PAGE, $forum_page['num_warn']); $warnings = om_warnings_get_warning_list($forum_page['start_from'], $forum_page['finish_at'], $where_sql, $forum_page['sort_dir']); $forum_page['items_info'] = $lang_om_warnings['Warning list heading']; // Generate paging links $forum_page['page_post']['paging'] = '<p class="paging"><span class="pages">' . $lang_common['Pages'] . '</span> ' . paginate($forum_page['num_pages'], $forum_page['page'], $forum_url['om_warnings_browse'], $lang_common['Paging separator'], array($forum_page['sort_dir'], $forum_page['show_expired'], $forum_page['username'] != '' ? urlencode($forum_page['username']) : '-')) . '</p>'; // Navigation links for header and page numbering for title/meta description if ($forum_page['page'] < $forum_page['num_pages']) { $forum_page['nav']['last'] = '<link rel="last" href="' . forum_sublink($forum_url['om_warnings_browse'], $forum_url['page'], $forum_page['num_pages'], array($forum_page['sort_dir'], $forum_page['show_expired'], $forum_page['username'] != '' ? urlencode($forum_page['username']) : '-')) . '" title="' . $lang_common['Page'] . ' ' . $forum_page['num_pages'] . '" />'; $forum_page['nav']['next'] = '<link rel="next" href="' . forum_sublink($forum_url['om_warnings_browse'], $forum_url['page'], $forum_page['page'] + 1, array($forum_page['sort_dir'], $forum_page['show_expired'], $forum_page['username'] != '' ? urlencode($forum_page['username']) : '-')) . '" title="' . $lang_common['Page'] . ' ' . ($forum_page['page'] + 1) . '" />'; } if ($forum_page['page'] > 1) { $forum_page['nav']['prev'] = '<link rel="prev" href="' . forum_sublink($forum_url['om_warnings_browse'], $forum_url['page'], $forum_page['page'] - 1, array($forum_page['sort_dir'], $forum_page['show_expired'], $forum_page['username'] != '' ? urlencode($forum_page['username']) : '-')) . '" title="' . $lang_common['Page'] . ' ' . ($forum_page['page'] - 1) . '" />'; $forum_page['nav']['first'] = '<link rel="first" href="' . forum_link($forum_url['om_warnings_browse'], array($forum_page['sort_dir'], $forum_page['show_expired'], $forum_page['username'] != '' ? urlencode($forum_page['username']) : '-')) . '" title="' . $lang_common['Page'] . ' 1" />'; } // Setup the form $forum_page['om_warnings_admin'] = true; $forum_page['fld_count'] = $forum_page['group_count'] = $forum_page['item_count'] = 0;
// New section in profile - om_warnings if ($section == 'om_warnings') { // Load functions if (!defined('OM_WARNINGS_FUNCTIONS_LOADED')) { require $ext_info['path'] . '/functions.php'; } // Save current time to variable to make it consistent on whole page $forum_page['now'] = time(); $forum_page['sort_dir'] = 'DESC'; $forum_page['show_expired'] = '0'; $where_sql[0] = 'u.id = ' . $id; if ($forum_page['show_expired'] != '1') { $where_sql[] = '(o.expire_date IS NULL OR o.expire_date >= ' . $forum_page['now'] . ')'; } // Get list of warnings of current user $warnings = om_warnings_get_warning_list(null, null, $where_sql, $forum_page['sort_dir']); $forum_page['items_info'] = $lang_om_warnings['User warnings']; // Setup breadcrumbs $forum_page['crumbs'] = array(array($forum_config['o_board_title'], forum_link($forum_url['index'])), array(sprintf($lang_profile['Users profile'], $user['username']), forum_link($forum_url['user'], $id)), $lang_om_warnings['Section warnings']); // Setup form $forum_page['om_warnings_admin'] = false; $forum_page['om_warnings_form'] = $forum_user['g_moderator'] == '1' && $forum_user['g_mod_om_warnings'] == '1' || $forum_user['g_id'] == FORUM_ADMIN; $forum_page['group_count'] = $forum_page['item_count'] = $forum_page['fld_count'] = 0; $forum_page['form_action'] = forum_link($forum_url['om_warnings_report_user'], $id); $forum_page['hidden_fields'] = array('csrf_token' => '<input type="hidden" name="csrf_token" value="' . generate_form_token($forum_page['form_action']) . '" />'); ($hook = get_hook('om_warnings_profile_header_load')) ? eval($hook) : null; define('FORUM_PAGE', 'profile-om_warnings'); require FORUM_ROOT . 'header.php'; // START SUBST - <!-- forum_main --> ob_start(); ($hook = get_hook('om_warnings_profile_output_start')) ? eval($hook) : null;