root/log.php

<?php</span>
<span class="code-lang">$root_path = './';
require ($root_path . 'include/config.php');
require ($root_path . 'include/functions_search.php');
require ($root_path . 'languages/lang_' . $config['default_lang'] . '/lang_modcomment_log.php');

/* */
function search_id_from_string ( $string ) {</span>
<span class="code-keyword">
    $ary = array();

    while ( true ) {
        $first_pos = strpos($string, '<!--S-->');

        if ( $first_pos !== false ) {
            $last_pos = strpos($string, '<!--E-->');
            $_pos = strpos($string, '_');
            $_pos = strpos($string, '_', $_pos + 1);
            $substr = substr($string, $first_pos + 8, $_pos - $first_pos - 8);

            $_pos = strpos($substr, '_');

            $id = substr($substr, $_pos + 1);
            $type = substr($substr, 0, $_pos);

            $string = preg_replace('/<!--S-->' . $type . '_' . $id . '_(.*?)<!--E-->/si', '', $string);

            $ary[$id] = $type;
        }
        else {
            break;
        }
    }

    if ( sizeof($ary) ) {
        return $ary;
    }
    else {
        return false;
    }
}
/* */

$userdata = session_pagestart($user_ip);
init_userprefs($userdata);
loggedinorreturn();

$log_level_view = request_var('log_level_view', -1);
$query = request_var('query', '');</span>
<span class="code-lang">
if ( $userdata['class'] == UC_MODERATOR ) {
    $level = LOG_VIEW_MOD;
}
elseif ( $userdata['class'] == UC_ADMINISTRATOR ) {
    $level = LOG_VIEW_ADMIN;
}
elseif ( $userdata['class'] == UC_SYSOP ) {
    $level = LOG_VIEW_SYSOP;
}
else {
    $level = LOG_VIEW_USER;
}

if ( $log_level_view > $level && $log_level_view <> -1 ) {
    $log_level_view = $level;
}

$colors = array();
$colors_ary = array('#33CC00', '#FF0000', '#FF0000', '#3399FF');</span>
<span class="code-lang">
for ( $i = 0; $i < sizeof($lang['log_highlights_ary']); ++$i ) {
    $colors[$lang['log_highlights_ary'][$i]] = $colors_ary[$i];
}

if ( $level <> LOG_VIEW_USER ) {
    $log_level_select  = '<select name="log_level_view">';
    $log_level_select .= '<option value="-1"' . ( $log_level_view == -1 ? ' selected="selected"' : '' ) . '>' . $lang['log_level'] . '</option>';
    $log_level_select .= '<option value="' . LOG_VIEW_USER . '"' . ( $log_level_view == LOG_VIEW_USER ? ' selected="selected"' : '' ) . '>' . $lang['log_level_user'] . '</option>';
    $log_level_select .= '<option value="' . LOG_VIEW_MOD . '"' . ( $log_level_view == LOG_VIEW_MOD ? ' selected="selected"' : '' ) . '>' . $lang['log_level_mod'] . '</option>';
    $log_level_select .= ( $userdata['class'] > UC_MODERATOR ? '<option value="' . LOG_VIEW_ADMIN . '"' . ( $log_level_view == LOG_VIEW_ADMIN ? ' selected="selected"' : '' ) . '>' .  $lang['log_level_admin'] . '</option>' : '' );
    $log_level_select .= ( $userdata['class'] > UC_ADMINISTRATOR ? '<option value="' . LOG_VIEW_SYSOP . '"' . ( $log_level_view == LOG_VIEW_SYSOP ? ' selected="selected"' : '' ) . '>' .  $lang['log_level_sysop'] . '</option>' : '' );
    $log_level_select .= '</select>';
}
else {
    $log_level_select = '';
}

$template->assign_vars(array(</span>
<span class="code-lang">        'S_FORM_ACTION' => append_sid('log.php')
));

if ( $query ) {
    $template->assign_vars(array(
            'SEARCH_RESULTS' => sprintf($lang['search_results'], $query),
            'SEARCH_VALUE' => $query
    ));

    $query = searchfield($query);
}
// delete items older than 2 weeks
$secs = time() - 2 * 7 * 24 * 60 * 60;
$sql = 'DELETE FROM ' . SITELOG_TABLE . ' WHERE added < ' . $secs;
$db->sql_query($sql);

$template->assign_vars(array(</span>
<span class="code-lang">        'LOG_LEVEL_SELECT' => $log_level_select
));


$sql = 'SELECT COUNT(*) AS count</span>
<span class="code-lang">        FROM ' . SITELOG_TABLE . '
        WHERE ' . ( $log_level_view <> -1 ? 'log_view_level = ' . $log_level_view : 'log_view_level <= ' . $level ) .
        ( $query ? ' AND txt LIKE ' . "'%" . $db->sql_escape($query) . "%'" : '' );
$result = $db->sql_query($sql);
$count = ( $row = $db->sql_fetchrow($result) ) ? $row['count'] : 0;</span>
<span class="code-lang">
if ( $count ) {
    list($pagertop, $pagerbottom, $offset, $limit) = pager(50, $count, 'log.php?' . ( $query ? 'query=' . $query . '&amp;' : '' ) . ( $log_level_view <> -1 ? 'log_level_view=' . $log_level_view . '&amp;' : '' ) );
    $template->assign_vars(array(
            'PAGERBOTTOM' => $pagerbottom
    ));

    $sql = 'SELECT added, txt
            FROM ' . SITELOG_TABLE . '
            WHERE ' . ( $log_level_view <> -1 ? 'log_view_level = ' . $log_level_view : 'log_view_level <= ' . $level ) .
            ( isset($query) ? ' AND txt LIKE ' . "'%" . $db->sql_escape($query) . "%'" : '' ) . ' ORDER BY added DESC';
    $result = $db->sql_query_limit($sql, $limit, $offset);

    $tor_ary = array();
    $user_ary = array();
    $log_ary = array();
    $cats = $cache->obtain_cats();

    while ( $row = $db->sql_fetchrow($result) ) {
        if ( $search = search_id_from_string($row['txt']) ) {
            foreach ( $search AS $id => $type ) {
                switch ( $type ) {
                    case 'TORRENT':
                        $tor_ary[] = $id;
                    break;
                    case 'USER':
                        $user_ary[] = $id;
                    break;
                }
            }
        }

        $log_ary[] = $row;
    }
    if ( sizeof($user_ary) ) {
        $user_ary = array_unique($user_ary);
        $sql = 'SELECT name, privacy, uid FROM ' . USERS_TABLE . ' WHERE uid IN (' . implode(',', $user_ary)  . ')';
        $result = $db->sql_query($sql);
        $user_ary = array();
        while ( $row = $db->sql_fetchrow($result) ) {
            $user_ary[$row['uid']] = $row;
        }
    }
    if ( sizeof($tor_ary) ) {
        $tor_ary = array_unique($tor_ary);
        $sql = 'SELECT name, fid, category FROM ' . TORRENTS_TABLE . ' WHERE fid IN (' . implode(',', $tor_ary)  . ')';
        $result = $db->sql_query($sql);
        $tor_ary = array();
        while ( $row = $db->sql_fetchrow($result) ) {
            $tor_ary[$row['fid']] = $row;
        }
    }

    foreach ( $log_ary AS $_null => $ary ) {

        $date = create_date($ary['added']);
        $text = $ary['txt'];
        $continue = false;

        $log_color = '';
        foreach ( $colors AS $txt => $color ) {
            if ( strpos($text, $txt) ) {
                $log_color = $color;
            }
        }

        if ( $search = search_id_from_string($text) ) {
            foreach ( $search AS $id => $type ) {
                switch ( $type ) {
                    case 'TORRENT':
                        if ( isset($tor_ary[$id]['category']) ) {
                            $cat_id = $tor_ary[$id]['category'];
                            $cat_parent_id = ( isset($cats[$cats[$cat_id]['cat_parent']]['cat_id']) ? $cats[$cats[$cat_id]['cat_parent']]['cat_id'] : 0 );
                            // www.phpBB-SEO.com SEO TOOLKIT BEGIN
                            if ( $cat_parent_id ) {
                                $seo->set_url($cats[$cat_parent_id]['cat_name'], $cat_parent_id, $seo->seo_static['browse']);
                                $seo->set_parent($cat_id, $seo->seo_static['browse'], $cat_parent_id, $seo->seo_static['browse']);
                            }

                            $seo->set_url($cats[$cat_id]['cat_name'], $cat_id, $seo->seo_static['browse']);

                            $seo->set_parent($id, $seo->seo_static['details'], $cat_id, $seo->seo_static['browse']);

                            $seo->set_url($tor_ary[$id]['name'], $id, $seo->seo_static['details']);
                            // www.phpBB-SEO.com SEO TOOLKIT END

                            $text = preg_replace('/<!--S-->TORRENT_' . $id . '_(.*?)<!--E-->/', '<a href="' . append_sid($root_path . 'details.php?id=' . $id) . '">' . $tor_ary[$id]['name'] . '</a>', $text);
                        }
                        else {
                            $text = preg_replace('/<!--S-->TORRENT_' . $id . '_(.*?)<!--E-->/', '\\1', $text);
                        }
                    break;
                    case 'USER':
                        if ( $user_ary[$id]['privacy'] == PRIVACY_LEVEL_HIGH && $userdata['class'] < UC_MODERATOR && $userdata['name'] <> $user_ary[$id]['name'] ) {
                            if ( $query ) {
                                $continue = true;
                            }
                            $text = preg_replace('/<!--S-->USER_' . $id . '_(.*?)<!--E-->/', $lang['anonymous'], $text);
                        }
                        else {
                            // www.phpBB-SEO.com SEO TOOLKIT START
                            $seo->set_user_url($user_ary[$id]['name'], $id);
                            // www.phpBB-SEO.com SEO TOOLKIT END

                            $text = preg_replace('/<!--S-->USER_' . $id . '_(.*?)<!--E-->/', '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $id) . '">' . $user_ary[$id]['name'] . '</a>', $text);
                        }
                    break;
                }
            }
        }

        if ( $continue ) {
            continue;
        }

        $template->assign_block_vars('log_row', array(
                'COLOR' => $log_color,
                'DATE' => $date,
                'ACTION' => $text
        ));
    }

}
else {
    $template->assign_block_vars('log_empty', array());
}

stdhead($lang['log']);
$template->set_filenames(array(</span>
<span class="code-lang">        'body' => 'log.html')
);
stdfoot();
?>