Weet iemand waar de fout zit?
portal.php
Code: Selecteer alles
//
// Recent Links
//
$sql = "SELECT l.link_url, l.link_title, l.link_desc, l.link_id, lc.cat_title, lc.cat_id, u.username, u.user_id
FROM " . LINKS_TABLE . " l, " . LINK_CATEGORIES_TABLE . " lc, " . USERS_TABLE . " u
WHERE l.link_active = 1
AND l.link_category = lc.cat_id
AND l.user_id = u.user_id
ORDER BY l.link_joined DESC
LIMIT 0,".$board_config['recent_links'];
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query links information', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
$template->assign_block_vars('recent_links', array(
'LINK_URL' => '<a href="'.append_sid("links.$phpEx?action=go&link_id=" . $row['link_id']).'" target="_blank" onMouseOver="document.all.recent_links.stop()" onMouseOut="document.all.recent_links.start()"><b>'.$row['link_title'].'</b></a>',
'LINK_CAT' => '<a href="'.append_sid("links.$phpEx?t=sub_pages&cat=" . $row['cat_id']).'" onMouseOver="document.all.recent_links.stop()" onMouseOut="document.all.recent_links.start()"><i>'.$row['cat_title'].'</i></a>',
'LINK_DESC' => $row['link_desc'],
'LINK_AUTHOR' => '<a href="'.append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']).'" onMouseOver="document.all.recent_links.stop()" onMouseOut="document.all.recent_links.start()">'.$row['username'].'</a>')
);
}
$template->assign_vars(array(
'L_RECENT_LINKS' => $lang['Recent_links'])
);
//
// Maak de pagina
//
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
Code: Selecteer alles
</tr>
</table>
<br />
<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
<tr>
<td class="row2" height="25" align="center"><span class="genmed"><b>{L_RECENT_LINKS}</b></span></td>
</tr>
<tr>
<td class="row1"><span class="gensmall">
<marquee id="recent_links" behavior="scroll" direction="up" height="100" scrolldelay="75" scrollamount="2">
<!-- BEGIN recent_links -->
<center>{recent_links.LINK_URL} ( {recent_links.LINK_AUTHOR} )
<br />{recent_links.LINK_CAT}<br />{recent_links.LINK_DESC}<br /></center>
<!-- END recent_links -->
</marquee></span></td>
</tr>
</table>
<br />
</td></tr></table>
</td>
</tr>
</table>