rendered paste body<?php
$phpbb_dbc = _phpbb_db();
$prefix = _phpbb_prefix();
$query = "SELECT COUNT(*) FROM phpbb_posts LEFT JOIN phpbb_users ON phpbb_posts.post_time > phpbb_users.user_lastvisit WHERE user_id = $user->uid;"
$result = mysql_query($query, $phpbb_dbc) or die('Query failed: ' . mysql_error() . " \n" . $query . "\n");
$list = array();
//$res = db_query($query);
//$row = db_fetch_array($res);
$url = '/forum/search.php?search_id=newposts&sr=posts';
$list[] = "<a href=\"$url\">Uleste innlegg ({$row['COUNT(*)']})\n";
return theme('item_list', $list);
?>