phpBB.de

Code: Alles auswählen

 function get_timestamp_for_ranking_history(){

    global $db;

   $sql = "SELECT  max(Games.game_time) as MaxTime
      FROM  " . EM_RESULTS_TABLE . " Res inner join (Select game_id, game_time from  " . EM_GAMES_TABLE . " union  SELECT  game_id, game_time  FROM  " . EM_FINALS_TABLE . " ) as Games
      on Games.game_id = Res.result_game";

   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['MaxTime'];

   return $timestamp_first_game_of_today;

Code: Alles auswählen

 function get_timestamp_for_ranking_history(){

    global $db;
    $timestamp_first_game_of_today = '';

   $sql = "SELECT game_time as MaxTime
      FROM  " . EM_RESULTS_TABLE . " Res inner join  " . EM_FINALS_TABLE . " final on final.game_id = Res.result_game order by game_time desc  LIMIT 0 , 1";

   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['MaxTime'];


if ($timestamp_first_game_of_today == '' || $timestamp_first_game_of_today == 0) {

   $sql = "SELECT  game_time as MaxTime
      FROM  " . EM_RESULTS_TABLE . " Res inner join  " . EM_GAMES_TABLE . " games on games.game_id = Res.result_game order by game_time desc  LIMIT 0 , 1";

   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['MaxTime'];
}


   return $timestamp_first_game_of_today;

Code: Alles auswählen

$sql = "SELECT userid from phpbb_em_torschuetzen_user u inner join phpbb_em_torschuetzen t on t.spielerid = u.spielerid where userid = (select tipp_user from phpbb_em_tipps where tipp_id = " . $em_tipps[$current_game_id][$u]['tipp_id'] . ") and tore = (Select max(tore) from phpbb_em_torschuetzen)";

Code: Alles auswählen

Could not get playing times of today

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Select game_id, game_time from phpbb2_em_games union SELECT

SELECT max(Games.game_time) as MaxTime FROM phpbb2_em_results Res inner join (Select game_id, game_time from phpbb2_em_games union SELECT game_id, game_time FROM phpbb2_em_finals ) as Games on Games.game_id = Res.result_game

Line : 180
File : functions_em.php

Code: Alles auswählen

Could not get historical user tipps data

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Select game_id, Game_time FROM phpbb2_em_games Union Select gam

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 phpbb2_em_tipps A LEFT JOIN phpbb2_em_tipps B ON A.tipp_id = B.tipp_id AND A.tipp_points = 1 LEFT JOIN phpbb2_em_tipps C ON A.tipp_id = C.tipp_id AND A.tipp_points = 2 LEFT JOIN phpbb2_em_tipps D ON A.tipp_id = D.tipp_id AND A.tipp_points = 3 inner join (Select game_id, Game_time FROM phpbb2_em_games Union Select game_id, Game_time FROM phpbb2_em_finals) as E on E.game_id = A.tipp_game and E.game_time < 0 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

Line : 148
File : functions_em.php