Re: Re:
Verfasst: 09.04.2009 06:12
Dank dir dafür , hab nur die Pokalbilder ersetztbacci hat geschrieben:Die Bilder muss Du natürlich noch nach: images/formel/ kopieren, oder den Pfad eben ändern.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
Hey , hast du auch die richtige Sql Anweisung befolgt ?FF27Q hat geschrieben:hmm komisch , ich kann immer noch keine halbe punkte eintragen obwohl ich das von dr.death eingebaut habe ... .
Damit hats bi mir auch funktioniertDr.Death hat geschrieben: Kleine Verbesserung für die SQL Anweisung:
Bitte nur folgenden SQL Code nutzen ( kann auch über die bereits aktualisierten Tabellen durchgeführt werden )
Grund: Nicht jede Datenbank hat "FLOAT" als Typ zur Verfügung.Code: Alles auswählen
ALTER TABLE `phpbb_formel_teams` CHANGE `team_penalty` `team_penalty` DECIMAL( 5, 2 ) UNSIGNED NOT NULL DEFAULT '0' ; ALTER TABLE `phpbb_formel_drivers` CHANGE `driver_penalty` `driver_penalty` DECIMAL( 5, 2 ) UNSIGNED NOT NULL DEFAULT '0' ;
