phpBB.nl

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}&nbsp;( {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>