phpBB.de

Code: Alles auswählen

// DM Linkx
$user->setup('mods/dm_linkx');

$sql = 'SELECT COUNT(linkx_id) AS number_linkxs
    FROM ' . DM_LINKX_TABLE . '
    WHERE linkx_approval = 1';
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);

$sql2 = 'SELECT *
	FROM ' . DM_LINKX_TABLE . '
	WHERE linkx_approval = 1
	ORDER BY linkx_counter DESC LIMIT 5';
$result2 = $db->sql_query($sql2);

while ( $row2 = $db->sql_fetchrow($result2) )
{	
	$template->assign_block_vars('linkxline', array(
		'LINKX_COUNTER' => sprintf($user->lang['DM_LINKX_COUNTER'], $row2['linkx_counter']),
		'TITEL'			=> $row2['linkx_title'],
	));  
}
$db->sql_freeresult($result);

$template->assign_vars(array(
	'NUMBER_LINKXS'	=> sprintf($user->lang['DM_TOTAL_LINKXS'], $row['number_linkxs']),
));