Code: Select all
/* BEGIN changed by webwit */
$wiki_pages = $wiki_revisions = $last_post_url_wiki = '';
if ('/wiki' === $u_viewforum)
{
if (@mysql_connect($sqlhost, $sqluser, $sqlpass) && @mysql_select_db($sqldb)) {
$query = "
SELECT
ss_good_articles,ss_total_edits
FROM
site_stats
";
$result = mysql_query($query);
if ($result && mysql_num_rows($result))
{
$wiki_pages = mysql_result($result, 0);
$wiki_revisions = mysql_result($result, 0, 1);
}
$query = "
SELECT
rev_user_text, rev_timestamp, page_title
FROM
revision
LEFT JOIN
page
ON
revision.rev_page = page.page_id
ORDER BY
rev_id DESC
LIMIT
1
";
$result = mysql_query($query);
if ($result && mysql_num_rows($result))
{
$rev_user_text = mysql_result($result, 0);
$rev_timestamp = mysql_result($result, 0, 1);
$php_timestamp = mktime(substr($rev_timestamp, 8, 2), substr($rev_timestamp, 10, 2), substr($rev_timestamp, 12, 2),
substr($rev_timestamp, 4, 2), substr($rev_timestamp, 6, 2), substr($rev_timestamp, 0, 4));
$php_timestamp += $config['board_timezone'] * 3600;
$php_timestamp += $config['board_dst'] * 3600;
$last_post_time = $user->format_date($php_timestamp);
$last_post_url_wiki = '/wiki/' . mysql_result($result, 0, 2);
$sql = "
SELECT
user_id, username
FROM
" . USERS_TABLE . "
WHERE
username_clean = '" . strtolower(mysql_escape_string($rev_user_text)) . "'
";
$result = $db->sql_query($sql);
if ($user_row = $db->sql_fetchrow($result))
{
$row['forum_last_poster_id'] = $user_row['user_id'];
$row['forum_last_poster_name'] = $user_row['username'];
$row['forum_last_poster_colour'] = '';
}
$db->sql_freeresult($result);
}
}
}
