phpBB.de

Code: Alles auswählen

	// Show Top 3
	$i = 1;
	$sql_array = array(
		'SELECT'	=> 'u.user_id, u.username, u.user_colour, k.*',

		'FROM'		=> array(
			USERS_TABLE	=> 'u',
		),

		'LEFT_JOIN'	=> array(
			array(
				'FROM'	=> array(KNUFFEL_TABLE => 'k'),
				'ON'	=> 'u.user_id = k.user_id'
			),
		),

		'WHERE'		=> 'k.score > 0',
		'ORDER_BY'	=> 'k.score DESC, k.average DESC',
	);

	$sql = $db->sql_build_query('SELECT', $sql_array);
	$result = $db->sql_query_limit($sql, 3);

	while ( $row = $db->sql_fetchrow($result) )
	{
		$highscore_position = "<img src='knuffel/images/rank/".$i.".gif' alt='*' />";

		$template->assign_block_vars('highscore', array(
			'POSITION'	=> $highscore_position,
			'NAME'		=> get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
			'POINTS'	            => $row['score'],
		));
		$i++;  
	}
	$db->sql_freeresult($result);	

Code: Alles auswählen

		// Clear the general cache as well as the templates, imagesets and themes cache
		'cache_purge' => array(
			array(),
			array('imageset'),
			array('template'),
			array('theme'),
		),