phpBB.de

Code: Alles auswählen

		// Get all tips and fill top10
		$sql = 'SELECT sum(tipp_points) AS total_points, tipp_user 
			FROM ' . FORMEL_TIPPS_TABLE . '
			GROUP BY tipp_user
			ORDER BY total_points DESC LIMIT 5';
		$result = $db->sql_query($sql);

Code: Alles auswählen

			$first_rank = $phpbb_root_path . "images/formel/goldpokal.gif";
      		$secound_rank = $phpbb_root_path . "images/formel/silberpokal.gif";
      		$third_rank = $phpbb_root_path . "images/formel/bronzepokal.gif";

Code: Alles auswählen

			if ($row['total_points'] <> $previous_points) 
			{ 
				$rank = $real_rank; 
				$previous_points = $row['total_points']; 
			}
			
			$tipp_user_row		= get_formel_userdata($row['tipp_user']);
			$tipp_username_link	= get_username_string('full', $tipp_user_row['user_id'], $tipp_user_row['username'], $tipp_user_row['user_colour']);
			
			$template->assign_block_vars('top_tippers', array(
				'TIPPER_NAME' 	=> $tipp_username_link,
				'RANK'			=> $rank,
				'TIPPER_POINTS' => $row['total_points'],
				)
			);
		}

Code: Alles auswählen

			if ($row['total_points'] <> $previous_points) 
			{ 
				$rank = $real_rank; 
				$previous_points = $row['total_points']; 
			}
			  			
			if ($rank === 1)
   			{
      			$rank_img = '<img src="' . $first_rank . '" alt="1. Platz" title="1. Platz" />';
   			}
   			elseif ($rank === 2)
   			{
      			$rank_img = '<img src="' . $secound_rank . '" alt="2. Platz" title="2. Platz" />';
   			}
   			elseif ($rank === 3)
   			{
      			$rank_img = '<img src="' . $third_rank . '" alt="3. Platz" title="3. Platz" />';
   			}
   			else
   			{
      			$rank_img = $rank;
   			}
			
			$tipp_user_row		= get_formel_userdata($row['tipp_user']);
			$tipp_username_link	= get_username_string('full', $tipp_user_row['user_id'], $tipp_user_row['username'], $tipp_user_row['user_colour']);
			
			$template->assign_block_vars('top_tippers', array(
				'TIPPER_NAME' 	=> $tipp_username_link,
				'RANK'			=> $rank_img,
				'TIPPER_POINTS' => $row['total_points'],
				)
			);
		}

Code: Alles auswählen

		// re-sort the drivers. Big points first ;-)
		arsort($recalc_drivers);

Code: Alles auswählen

			$first_rank = $phpbb_root_path . "images/formel/goldpokal.gif";
      		$secound_rank = $phpbb_root_path . "images/formel/silberpokal.gif";
      		$third_rank = $phpbb_root_path . "images/formel/bronzepokal.gif";

Code: Alles auswählen

		foreach ($recalc_drivers as $driver_id => $driver) 
		{ 
			if ($limit == 5) 
			{
				break;
			}
			
			++$rank; 

			$wm_drivername = $driver['driver_name'];
			
			$template->assign_block_vars('top_drivers', array(
				'RANK'			=> $rank,
				'WM_DRIVERNAME'	=> $wm_drivername,
				'WM_POINTS'		=> $driver['total_points'],
				)
			);
			
			++$limit;
		}

Code: Alles auswählen

		foreach ($recalc_drivers as $driver_id => $driver) 
		{ 
			if ($limit == 5) 
			{
				break;
			}
			
			++$rank; 

   			if ($rank === 1)
   			{
      				$rank_img = '<img src="' . $first_rank . '" alt="1. Platz" title="1. Platz" />';
   			}
   				elseif ($rank === 2)
   			{
      				$rank_img = '<img src="' . $secound_rank . '" alt="2. Platz" title="2. Platz" />';
   			}
   				elseif ($rank === 3)
   			{
      				$rank_img = '<img src="' . $third_rank . '" alt="3. Platz" title="3. Platz" />';
   			}
   			else
   			{
      				$rank_img = $rank;
   			}
			
			$wm_drivername = $driver['driver_name'];
			
			$template->assign_block_vars('top_drivers', array(
				'RANK'			=> $rank_img,
				'WM_DRIVERNAME'	=> $wm_drivername,
				'WM_POINTS'		=> $driver['total_points'],
				)
			);
			
			++$limit;
		}

Code: Alles auswählen

		// re-sort the teams. Big points first ;-)
		arsort($recalc_teams);

Code: Alles auswählen

			$first_rank = $phpbb_root_path . "images/formel/goldpokal.gif";
      		$secound_rank = $phpbb_root_path . "images/formel/silberpokal.gif";
      		$third_rank = $phpbb_root_path . "images/formel/bronzepokal.gif";

Code: Alles auswählen

		foreach ($recalc_teams as $team_id => $team) 
		{ 
			if ($limit == 5) 
			{
				break;
			}
			
			++$real_rank;
			
			if ($team['total_points'] <> $previous_points) 
			{ 
				$rank = $real_rank; 
				$previous_points = $team['total_points']; 
			}
			
			$wm_teamname = $team['team_name'];
			$template->assign_block_vars('top_teams', array(
				'RANK'			=> $rank,
				'WM_TEAMNAME'	=> $wm_teamname,
				'WM_POINTS'		=> $team['total_points'],
				)
			);
			
			++$limit;
		}

Code: Alles auswählen

		foreach ($recalc_teams as $team_id => $team) 
		{ 
			if ($limit == 5) 
			{
				break;
			}
			
			++$real_rank;
			
			if ($team['total_points'] <> $previous_points) 
			{ 
				$rank = $real_rank; 
				$previous_points = $team['total_points']; 
			}
			
			if ($rank === 1)
   			{
      				$rank_img = '<img src="' . $first_rank . '" alt="1. Platz" title="1. Platz" />';
   			}
   			elseif ($rank === 2)
   			{
      				$rank_img = '<img src="' . $secound_rank . '" alt="2. Platz" title="2. Platz" />';
   			}
   			elseif ($rank === 3)
   			{
      				$rank_img = '<img src="' . $third_rank . '" alt="3. Platz" title="3. Platz" />';
   			}
   			else
   			{
      				$rank_img = $rank;
   			}
			
			$wm_teamname = $team['team_name'];
			$template->assign_block_vars('top_teams', array(
				'RANK'			=> $rank_img,
				'WM_TEAMNAME'	=> $wm_teamname,
				'WM_POINTS'		=> $team['total_points'],
				)
			);
			
			++$limit;
		}