Dafür hab ich bereits eine Lösung gecodet und weiter vorne auch schon gepostet. Muss jetzt leider weg.zweistein hat geschrieben:Soki Sokrates hat geschrieben: Dann sollte es bei gleichem Punktstand alphabetisch sortiert sein und zwei gleichplatzierte den gleichen Platz inne haben.
O.K. Danke. ich such gleich mal. Ansonsten warte ich noch gespannt auf zweisteins Ranglisten. *hoff*jorymiller hat geschrieben:Dafür hab ich bereits eine Lösung gecodet und weiter vorne auch schon gepostet. Muss jetzt leider weg.zweistein hat geschrieben:Soki Sokrates hat geschrieben: Dann sollte es bei gleichem Punktstand alphabetisch sortiert sein und zwei gleichplatzierte den gleichen Platz inne haben.
Empfehle Dir die Suchfunktion. Ansonsten post ich morgen noch mal den Link auf meinen Beitrag.
Code: Alles auswählen
#
#-----[ COPY ]------------------------------------------
#
images/wm/up.gif
images/wm/stay.gif
images/wm/down.gif
#
#-----[ OPEN ]------------------------------------------
#
include/functions_wm.php
#
#-----[ FIND ]------------------------------------------
#
$db->sql_freeresult($result);
return $wm_users;
}
#
#-----[ ADD, AFTER ]------------------------------------------
#
// Get wm users data and points up to yesterday
// for historical information
function get_wm_user_points_up_to_yesterday() {
global $db;
// Load Config
$wm_config = array(); // Config values
$wm_config = get_wm_config();
$timestamp_last_game_before_this_day = get_timestamp_for_ranking_history();
//
// Get users data
//
$sql = "SELECT A.tipp_user , sum( A.tipp_points ) AS user_points, count( A.tipp_points ) AS user_total_tipps, count( B.tipp_points ) AS user_points_tendency, count( C.tipp_points ) AS user_points_difference, count( D.tipp_points ) AS user_points_result
FROM " . WM_TIPPS_TABLE . " A
LEFT JOIN " . WM_TIPPS_TABLE . " B ON A.tipp_id = B.tipp_id
AND A.tipp_points = " . $wm_config['points_tendency'] . "
LEFT JOIN " . WM_TIPPS_TABLE . " C ON A.tipp_id = C.tipp_id
AND A.tipp_points = " . $wm_config['points_tordiff'] . "
LEFT JOIN " . WM_TIPPS_TABLE . " D ON A.tipp_id = D.tipp_id
AND A.tipp_points = " . $wm_config['points_match'] . "
WHERE A.tipp_time < ". $timestamp_last_game_before_this_day ."
GROUP BY A.tipp_user
ORDER BY user_points DESC, user_points_result DESC, user_points_difference DESC, user_points_tendency DESC";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get historical user tipps data', '', __LINE__, __FILE__, $sql);
}
$wm_user_points_up_to_yesterday = array();
while ( $row = $db->sql_fetchrow($result) )
{
// $wm_users[][$row['tipp_user']] = $row;
$wm_user_points_up_to_yesterday[] = $row['tipp_user'];
}
$db->sql_freeresult($result);
return $wm_user_points_up_to_yesterday;
}
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 " . WM_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 " . WM_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 " . WM_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
}
}
function get_rank_of_yesterday($userid){
$wm_user_points_up_to_yesterday = get_wm_user_points_up_to_yesterday();
$rank_of_yesterday = array_search($userid, $wm_user_points_up_to_yesterday) + 1; // +1 because erray starts with index 0
return $rank_of_yesterday;
}
#
#-----[ OPEN ]------------------------------------------
#
wm_stats.php
#
#-----[ FIND ]------------------------------------------
#
for ( $i = 0; $i < count($wm_users_data); $i++ )
{
#
#-----[ ADD, AFTER ]------------------------------------------
#
// absolute position now
$int_userpos_absolute = $i+1;
// user position yesterday
$int_userpos_yesterday = get_rank_of_yesterday($wm_users_data[$i]['tipp_user']);
// compare the absolute positions
if($int_userpos_yesterday < $int_userpos_absolute ){
$userpos_change = '<img src="./images/wm/down.gif" alt="Down" border="0" />';
}else if ($int_userpos_yesterday == $int_userpos_absolute ){
$userpos_change = '<img src="./images/wm/stay.gif" alt="Stay" border="0" />';
}else if ($int_userpos_yesterday > $int_userpos_absolute ){
$userpos_change = '<img src="./images/wm/up.gif" alt="Up" border="0" />';
}
#
#-----[ FIND ]------------------------------------------
#
'USER_WM_MADE' => $wm_users_data[$i]['user_total_tipps'],
#
#-----[ ADD, AFTER ]------------------------------------------
#
'USER_WM_POS_CHANGE' => $userpos_change,
#
#-----[ OPEN ]------------------------------------------
#
wm_stats_body.tpl
#
#-----[ FIND ]------------------------------------------
#
><span class="cattitle"><a href="#">{L_WM_TITLE}</a></span></td>
#
#-----[ ATTENTION - special change ]------------------------------------------
#
Count up the colspan, for example
CHANGE <td class="cat" colspan="8">
TO <td class="cat" colspan="9">
#
#-----[ FIND ]------------------------------------------
#
<td class="row2" align="center" nowrap="nowrap" valign="middle"> <strong><span class="genmed">{L_WM_STATS_POS}</span></strong> </td>
#
#-----[ ADD, AFTER ]------------------------------------------
#
<td class="row2" align="center" nowrap="nowrap" valign="middle"> </td>
#
#-----[ FIND ]------------------------------------------
#
<td class="row1" align="center" nowrap="nowrap" valign="middle"> <strong><span class="genmed">{userrow.USER_POS}</span></strong> </td>
#
#-----[ ADD, AFTER ]------------------------------------------
#
<td class="row1" align="center" nowrap="nowrap" valign="middle"> {userrow.USER_WM_POS_CHANGE}</td>
Hier der Pfeil in grün mit Transparenz in den Aussenbereichen:Soki Sokrates hat geschrieben:Klappt wunderbar! BRAVO.
Ein grüner Pfeil wäre wohl wirklich schöner, jedoch hat der gepostete Pfeil von Solo1905 den Nachteil an entsprechender Stelle nicht transparent zu sein und somit etwas unschön zu sein auf z.B. ockergelben Background. Habe deshalb wieder den blauen genommen.
BRAVO, BRAVO!
Weiter so. Vielleicht bist du ja schneller als Don.
selber gemacht ^^
![[ externes Bild ]](http://img114.imageshack.us/img114/1444/screentendenzrang5sj.th.jpg){kind=link}
![[ externes Bild ]](http://upload4.postimage.org/392158/up_jpg.jpg){kind=link}
![[ externes Bild ]](http://dbs-lin.rub.de/fsi/templates/fisubsilversh/images/icon_minigender_female.gif){kind=link}
![[ externes Bild ]](http://dbs-lin.rub.de/fsi/templates/fisubsilversh/images/icon_minigender_male.gif){kind=link}
![[ externes Bild ]](http://www.poplatschky.de/images/wm/up.gif){kind=link}