Ok da stehts echt mit den halben , aber wieso auf anderen seiten net ?Dr.Death hat geschrieben:Ich selbst nutze das Webportal von http://www.motorsport-total.com/f1/
Rennabbruch
Wird das Rennen in den ersten zwei Runden abgebrochen, erfolgt ein Neustart. Sind zwischen zwei Runden und 75 Prozent der Renndistanz gefahren, wird das Rennen neu gestartet. Der zweite Start erfolgt dann unter Safety-Car-Regeln: Die Autos starten in der Reihenfolge des Abbruchs des ersten Rennens; die Zeitrückstände werden nicht berücksichtigt, es sei denn, sie betragen mehr als eine Runde.
Sollte ein Neustart nicht möglich sein, werden halbe Punkte vergeben. Bei einem Abbruch nach mehr als 75 Prozent der Gesamtdistanz wird die volle Punktzahl vergeben.
Wenn der die 000.000 denn so darstellt gehtsalso 10.000 Punkte für den ersten Platz - 50.000 Strafpunkte usw.
1. Naja, wenn man keine Familie hat und öfters mal zu Hause ist und dann nur am Rechner sitzt, kann man das mitbekommen, wenn aber alles läuft und man nicht die Zeit hat, wozu auch wenn alles Läuft wie man es willSorry, aber das war auch vor der Saison 2009 klar.
Und nochmals sorry, aber mittlerweile sind die Fahrer und Team Tabellen nicht mehr mit dem phpBB2 F1 WebTipp kompatibel.
Hier ist meine Version, vielleicht gefällt sie euch:klausm hat geschrieben:Hallo Dr.Death,
wie kann ich das in dieser Version realisieren?overunder hat geschrieben:in der formel.php sind doch die Top-Spieler aufgeführt. Statt der 1 würde ich gerne ein geeignetes Bild einfügen evtl. in Form eines Pokals.
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);
$rank = $real_rank = 0;
$previous_points = false;
while ($row = $db->sql_fetchrow($result))
{
$real_rank++;
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'])
);
}
$db->sql_freeresult($result);
// Get all wm points and fill top10 drivers
$sql = 'SELECT sum(wm_points) AS total_points, wm_driver
FROM ' . FORMEL_WM_TABLE . '
GROUP BY wm_driver
ORDER BY total_points DESC LIMIT 5';
$result = $db->sql_query($sql);
//Stop! we have to recalc the driver WM points... maybe we have some penalty !
$recalc_drivers = array();
while ($row = $db->sql_fetchrow($result))
{
$recalc_drivers[$row['wm_driver']]['total_points'] = $row['total_points'] - $drivers[$row['wm_driver']]['driver_penalty'];
$recalc_drivers[$row['wm_driver']]['driver_name'] = $drivers[$row['wm_driver']]['driver_name'];
}
// re-sort the drivers. Big points first ;-)
arsort($recalc_drivers);
$rank = $real_rank = 0;
$previous_points = false;
foreach ($recalc_drivers as $driver_id => $driver)
{
$real_rank++;
if ($driver['total_points'] <> $previous_points)
{
$rank = $real_rank;
$previous_points = $driver['total_points'];
}
$wm_drivername = $driver['driver_name'];
$template->assign_block_vars('top_drivers', array(
'RANK' => $rank,
'WM_DRIVERNAME' => $wm_drivername,
'WM_POINTS' => $driver['total_points'],
)
);
}
$db->sql_freeresult($result);
// Get all wm points and fill top10 teams
$sql = 'SELECT sum(wm_points) AS total_points, wm_team
FROM ' . FORMEL_WM_TABLE . '
GROUP BY wm_team
ORDER BY total_points DESC LIMIT 5';
$result = $db->sql_query($sql);
//Stop! we have to recalc the team WM points... maybe we have some penalty !
$recalc_teams = array();
while ($row = $db->sql_fetchrow($result))
{
$recalc_teams[$row['wm_team']]['total_points'] = $row['total_points'] - $teams[$row['wm_team']]['team_penalty'];
$recalc_teams[$row['wm_team']]['team_name'] = $teams[$row['wm_team']]['team_name'];
$recalc_teams[$row['wm_team']]['team_img'] = $teams[$row['wm_team']]['team_img'];
$recalc_teams[$row['wm_team']]['team_car'] = $teams[$row['wm_team']]['team_car'];
}
// re-sort the teams. Big points first ;-)
arsort($recalc_teams);
$rank = $real_rank = 0;
$previous_points = false;
foreach ($recalc_teams as $team_id => $team)
{
$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'],
)
);
}
$db->sql_freeresult($result);
// Find current race
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 20';
$result = $db->sql_query($sql);
$first_rank = $phpbb_root_path . "images/formel/pokal.jpg";
$secound_rank = $phpbb_root_path . "images/formel/silberpokal.gif";
$third_rank = $phpbb_root_path . "images/formel/bronzepokal.gif";
$rank = $real_rank = 0;
$previous_points = false;
while ($row = $db->sql_fetchrow($result))
{
$real_rank++;
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'])
);
}
$db->sql_freeresult($result);
// Get all wm points and fill top10 drivers
$sql = 'SELECT sum(wm_points) AS total_points, wm_driver
FROM ' . FORMEL_WM_TABLE . '
GROUP BY wm_driver
ORDER BY total_points DESC LIMIT 24';
$result = $db->sql_query($sql);
//Stop! we have to recalc the driver WM points... maybe we have some penalty !
$recalc_drivers = array();
while ($row = $db->sql_fetchrow($result))
{
$recalc_drivers[$row['wm_driver']]['total_points'] = $row['total_points'] - $drivers[$row['wm_driver']]['driver_penalty'];
$recalc_drivers[$row['wm_driver']]['driver_name'] = $drivers[$row['wm_driver']]['driver_name'];
}
// re-sort the drivers. Big points first ;-)
arsort($recalc_drivers);
$first_rank = $phpbb_root_path . "images/formel/pokal.jpg";
$secound_rank = $phpbb_root_path . "images/formel/silberpokal.gif";
$third_rank = $phpbb_root_path . "images/formel/bronzepokal.gif";
$rank = $real_rank = 0;
$previous_points = false;
foreach ($recalc_drivers as $driver_id => $driver)
{
$real_rank++;
if ($driver['total_points'] <> $previous_points)
{
$rank = $real_rank;
$previous_points = $driver['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_drivername = $driver['driver_name'];
$template->assign_block_vars('top_drivers', array(
'RANK' => $rank_img,
'WM_DRIVERNAME' => $wm_drivername,
'WM_POINTS' => $driver['total_points'],
)
);
}
$db->sql_freeresult($result);
// Get all wm points and fill top10 teams
$sql = 'SELECT sum(wm_points) AS total_points, wm_team
FROM ' . FORMEL_WM_TABLE . '
GROUP BY wm_team
ORDER BY total_points DESC LIMIT 20';
$result = $db->sql_query($sql);
//Stop! we have to recalc the team WM points... maybe we have some penalty !
$recalc_teams = array();
while ($row = $db->sql_fetchrow($result))
{
$recalc_teams[$row['wm_team']]['total_points'] = $row['total_points'] - $teams[$row['wm_team']]['team_penalty'];
$recalc_teams[$row['wm_team']]['team_name'] = $teams[$row['wm_team']]['team_name'];
$recalc_teams[$row['wm_team']]['team_img'] = $teams[$row['wm_team']]['team_img'];
$recalc_teams[$row['wm_team']]['team_car'] = $teams[$row['wm_team']]['team_car'];
}
// re-sort the teams. Big points first ;-)
arsort($recalc_teams);
$first_rank = $phpbb_root_path . "images/formel/pokal.jpg";
$secound_rank = $phpbb_root_path . "images/formel/silberpokal.gif";
$third_rank = $phpbb_root_path . "images/formel/bronzepokal.gif";
$rank = $real_rank = 0;
$previous_points = false;
foreach ($recalc_teams as $team_id => $team)
{
$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'],
)
);
}
$db->sql_freeresult($result);
// Find current race
