Example #1
0
    $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;
Example #2
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;