phpBB.de

Code: Alles auswählen

function get_em_user_points_up_to_yesterday() {

	global $db;

	// Load Config
	$em_config    = array();  // Config values
	$em_config    = get_em_config();

	$timestamp_last_game_before_this_day = get_timestamp_for_ranking_history();

	//
	// Get users data
	//

	$int_userpkt = -1;
	$int_userpos = 0;

	$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  " . EM_TIPPS_TABLE . " A
       LEFT JOIN " . EM_TIPPS_TABLE . " B ON A.tipp_id = B.tipp_id
       AND A.tipp_points = " . $em_config['points_tendency'] . "
       LEFT JOIN " . EM_TIPPS_TABLE . " C ON A.tipp_id = C.tipp_id
       AND A.tipp_points = " . $em_config['points_tordiff'] . "
       LEFT JOIN " . EM_TIPPS_TABLE . " D ON A.tipp_id = D.tipp_id
       AND A.tipp_points >= " . $em_config['points_match'] . "
       inner join (Select game_id, Game_time FROM " . EM_GAMES_TABLE . " Union Select game_id, Game_time FROM " . EM_FINALS_TABLE . ") as E on E.game_id = A.tipp_game and   E.game_time  < ". intval($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, tipp_user ASC";

	if( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not get historical user tipps data', '', __LINE__, __FILE__, $sql);
	}

	$em_user_points_up_to_yesterday = array();
	while ( $row = $db->sql_fetchrow($result) )
	{
		//   $em_users[][$row['tipp_user']] = $row;

		if ($int_userpkt != $row['user_points']) {$int_userpos =  $int_userpos + 1;}

		$int_userpkt =$row['user_points'];
		$tipp_id =    $row['tipp_user'];

		$em_user_points_up_to_yesterday[$tipp_id] =   $int_userpos;
		
	}
	$db->sql_freeresult($result);
    #print_r($em_user_points_up_to_yesterday);
	return $em_user_points_up_to_yesterday;
}

Code: Alles auswählen

 function get_rank_of_yesterday($userid){


   $em_user_points_up_to_yesterday = get_em_user_points_up_to_yesterday();



   $rank_of_yesterday = $em_user_points_up_to_yesterday[intval($userid)];


    return $rank_of_yesterday;
 }

Code: Alles auswählen

$em_user_points_up_to_yesterday[$tipp_id] =   $int_userpos; 

Array( [12]=> 4)

Code: Alles auswählen

   $rank_of_yesterday = $em_user_points_up_to_yesterday[intval($userid)]; 

   $rank_of_yesterday = $em_user_points_up_to_yesterday[12]; 

$rank_of_yesterday = 4