smithi hat geschrieben:Hi Patch,
ja ich hab ein Testboard und da einige Ergebnisse eingetragen auch die Spieltermine in die Vergangenheit gelegt. Dachte vielleicht das es daran scheitert. Aber mein Testprobant hat jemanden überholt und bekommt statt dem grünen Pfeil einen Punkt. Derjenige der runterrutscht bekommt den roten Pfeil.
so ich war jetzt mal mutig und hab bei mir in der heißen DB rumgespielt und bin auf fehlersuche gegangen.
dabei ist mir folgendes aufgefallen: In der functions_em.php gibt es eine Funktion Namens get_timestamp_for_ranking_history. Diese ermittelt die Anstoßzeit des letzten Spieles. Jedoch werden hier nur die Zeiten der Finalspiele herangezogen, nicht die der Vorrundenspiele. Ich vermute das wurde beim WM Tippspiel 2006 nach Anbrechen der Finalrunde korrigert, da es zu diesem Zeitpunkt ebenfalls Probleme mit den Tendenzpfeilen gab.
Folgendes Workout sollte abhilfe schaffen:
öffne functions_em.php
finde:
Code: Alles auswählen
function get_timestamp_for_ranking_history(){
global $db;
$timestamp_now=time();
$month = strftime("%m",$timestamp_now);
$day = strftime("%d",$timestamp_now);
$year = strftime("%Y",$timestamp_now);
$timestamp_today_begin = mktime(0,0,0,$month,$day,$year);
$timestamp_today_end = mktime(23,59,0,$month,$day,$year);
$timestamp_first_game_of_today;
$timestamp_first_game_of_last_day_with_a_game;
$timestamp_last_game_of_last_day_with_a_game;
// get playing times of today
$sql = "SELECT game_time
FROM " . EM_FINALS_TABLE . "
WHERE game_time > ". $timestamp_today_begin ."
AND game_time < ". $timestamp_today_end ."
ORDER BY game_time ASC";
if( !($result_times = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get playing times of today', '', __LINE__, __FILE__, $sql);
}
$row_times = $db->sql_fetchrow($result_times);
$timestamp_first_game_of_today = $row_times['game_time'];
if($timestamp_first_game_of_today < $timestamp_now){
// first game of today has started -> use all results before this game
return $timestamp_first_game_of_today;
}else{
// first game of today is not started
// saerch the first game of last playing day
$sql = "SELECT game_time
FROM " . EM_FINALS_TABLE . "
WHERE game_time < ". $timestamp_today_begin ."
ORDER BY game_time DESC";
if( !($result_times = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get playing times of today', '', __LINE__, __FILE__, $sql);
}
$row_times = $db->sql_fetchrow($result_times);
$timestamp_last_game_of_last_day_with_a_game = $row_times['game_time'];
$month_last_day_with_a_game = strftime("%m",$timestamp_last_game_of_last_day_with_a_game);
$day_last_day_with_a_game = strftime("%d",$timestamp_last_game_of_last_day_with_a_game);
$year_last_day_with_a_game = strftime("%Y",$timestamp_last_game_of_last_day_with_a_game);
$timestamp_last_day_with_a_game_begin =
mktime(0,0,0,$month_last_day_with_a_game,$day_last_day_with_a_game,$year_last_day_with_a_game);
$timestamp_last_day_with_a_game_end =
mktime(23,59,0,$month_last_day_with_a_game,$day_last_day_with_a_game,$year_last_day_with_a_game);
$sql = "SELECT game_time
FROM " . EM_FINALS_TABLE . "
WHERE game_time > ". $timestamp_last_day_with_a_game_begin ."
AND game_time < ". $timestamp_last_day_with_a_game_end ."
ORDER BY game_time ASC";
if( !($result_times = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get playing times of today', '', __LINE__, __FILE__, $sql);
}
$row_times = $db->sql_fetchrow($result_times);
$timestamp_first_game_of_last_day_with_a_game = $row_times['game_time'];
return $timestamp_first_game_of_last_day_with_a_game+1; // +1 becaouse of the < comparison
}
}
ersetze mit:
Code: Alles auswählen
function get_timestamp_for_ranking_history(){
global $db;
$timestamp_now=time();
$month = strftime("%m",$timestamp_now);
$day = strftime("%d",$timestamp_now);
$year = strftime("%Y",$timestamp_now);
$timestamp_today_begin = mktime(0,0,0,$month,$day,$year);
$timestamp_today_end = mktime(23,59,0,$month,$day,$year);
$timestamp_first_game_of_today;
$timestamp_first_game_of_last_day_with_a_game;
$timestamp_last_game_of_last_day_with_a_game;
// get playing times of today
$sql = "SELECT game_time
FROM " . EM_FINALS_TABLE . "
WHERE game_time > ". $timestamp_today_begin ."
AND game_time < ". $timestamp_today_end ."
union
SELECT game_time
FROM " . EM_GAMES_TABLE . "
WHERE game_time > ". $timestamp_today_begin ."
AND game_time < ". $timestamp_today_end ."
ORDER BY game_time ASC";
if( !($result_times = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get playing times of today', '', __LINE__, __FILE__, $sql);
}
$row_times = $db->sql_fetchrow($result_times);
$timestamp_first_game_of_today = $row_times['game_time'];
if($timestamp_first_game_of_today < $timestamp_now){
// first game of today has started -> use all results before this game
return $timestamp_first_game_of_today;
}else{
// first game of today is not started
// saerch the first game of last playing day
$sql = "SELECT game_time
FROM " . EM_FINALS_TABLE . "
WHERE game_time < ". $timestamp_today_begin ."
union
SELECT game_time
FROM " . EM_GAMES_TABLE . "
WHERE game_time < ". $timestamp_today_begin ."
ORDER BY game_time DESC";
if( !($result_times = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get playing times of today', '', __LINE__, __FILE__, $sql);
}
$row_times = $db->sql_fetchrow($result_times);
$timestamp_last_game_of_last_day_with_a_game = $row_times['game_time'];
$month_last_day_with_a_game = strftime("%m",$timestamp_last_game_of_last_day_with_a_game);
$day_last_day_with_a_game = strftime("%d",$timestamp_last_game_of_last_day_with_a_game);
$year_last_day_with_a_game = strftime("%Y",$timestamp_last_game_of_last_day_with_a_game);
$timestamp_last_day_with_a_game_begin =
mktime(0,0,0,$month_last_day_with_a_game,$day_last_day_with_a_game,$year_last_day_with_a_game);
$timestamp_last_day_with_a_game_end =
mktime(23,59,0,$month_last_day_with_a_game,$day_last_day_with_a_game,$year_last_day_with_a_game);
$sql = "SELECT game_time
FROM " . EM_FINALS_TABLE . "
WHERE game_time > ". $timestamp_last_day_with_a_game_begin ."
AND game_time < ". $timestamp_last_day_with_a_game_end ."
union
SELECT game_time
FROM " . EM_GAMES_TABLE . "
WHERE game_time > ". $timestamp_last_day_with_a_game_begin ."
AND game_time < ". $timestamp_last_day_with_a_game_end ."
ORDER BY game_time ASC";
if( !($result_times = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get playing times of today', '', __LINE__, __FILE__, $sql);
}
$row_times = $db->sql_fetchrow($result_times);
$timestamp_first_game_of_last_day_with_a_game = $row_times['game_time'];
return $timestamp_first_game_of_last_day_with_a_game+1; // +1 becaouse of the < comparison
}
}
Ich habe die ersten beiden Spiele Testweise eingetragen:
23.05.2008, 00:00 Schweiz - Tschechien 1 : 2
23.05.2008, 08:00 Portugal - Türkei 3 : 1
Resultat:
[ externes Bild ]
![[ externes Bild ]](http://www.ets-arena.de/forum/userpix/2_sshot1_2.jpg){kind=link}