Wegen des SQL Fehlers konnte der aktuelle Spieltag nicht abgeschlossen werden - daher diese Meldung
Code: Select all
in driver.php line 1020
at driver->sql_error('SELECT 1 AS `rank`, 0.00 AS win, u.user_id, u.username AS username, SUM(IF(m.match_no > 0, 1, 0)) AS matches, SUM(IF(b.goals_home = 0 OR b.goals_guest = 0, 1, 0)) AS nobet, SUM(IF(b.goals_home <> 0 AND b.goals_guest <> 0, IF((b.goals_home = m.goals_home) AND (b.goals_guest = m.goals_guest) , 1 , 0 ) , 0 ) ) AS direct_hit, SUM(IF(b.goals_home > 0 AND b.goals_guest > 0, IF((b.goals_home < b.goals_guest) <> (m.goals_home < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home > b.goals_guest) <> (m.goals_home > m.goals_guest) , 0 , 1 ) , 0 ) ) AS tendency , SUM(, IF(b.bet_time > 0, IF((b.goals_home < b.goals_guest) <> (m.goals_home < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home > b.goals_guest) <> (m.goals_home > m.goals_guest), 0, IF((b.goals_home = m.goals_home) AND (b.goals_guest = m.goals_guest), 10, IF(((b.goals_home - b.goals_guest = m.goals_home - m.goals_guest) AND (m.goals_home <> m.goals_guest)), 7, 5 ) ) ), 0 ), 0 ) )AS points FROM phpbb32_mot_swb_matches AS m INNER JOIN phpbb32_mot_swb_bets AS b ON (b.season = m.season AND b.league = m.league AND b.match_no = m.match_no) INNER JOIN phpbb32_users AS u ON (b.user_id = u.user_id) WHERE m.season = 2024 AND m.league = 1 AND m.matchday = 15 AND m.status IN (2,3) GROUP BY b.user_id ORDER BY points DESC, nobet ASC, username ASC')
in mysqli.php line 202
at mysqli->sql_query('SELECT 1 AS `rank`, 0.00 AS win, u.user_id, u.username AS username, SUM(IF(m.match_no > 0, 1, 0)) AS matches, SUM(IF(b.goals_home = 0 OR b.goals_guest = 0, 1, 0)) AS nobet, SUM(IF(b.goals_home <> 0 AND b.goals_guest <> 0, IF((b.goals_home = m.goals_home) AND (b.goals_guest = m.goals_guest) , 1 , 0 ) , 0 ) ) AS direct_hit, SUM(IF(b.goals_home > 0 AND b.goals_guest > 0, IF((b.goals_home < b.goals_guest) <> (m.goals_home < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home > b.goals_guest) <> (m.goals_home > m.goals_guest) , 0 , 1 ) , 0 ) ) AS tendency , SUM(, IF(b.bet_time > 0, IF((b.goals_home < b.goals_guest) <> (m.goals_home < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home > b.goals_guest) <> (m.goals_home > m.goals_guest), 0, IF((b.goals_home = m.goals_home) AND (b.goals_guest = m.goals_guest), 10, IF(((b.goals_home - b.goals_guest = m.goals_home - m.goals_guest) AND (m.goals_home <> m.goals_guest)), 7, 5 ) ) ), 0 ), 0 ) )AS points FROM phpbb32_mot_swb_matches AS m INNER JOIN phpbb32_mot_swb_bets AS b ON (b.season = m.season AND b.league = m.league AND b.match_no = m.match_no) INNER JOIN phpbb32_users AS u ON (b.user_id = u.user_id) WHERE m.season = 2024 AND m.league = 1 AND m.matchday = 15 AND m.status IN (2,3) GROUP BY b.user_id ORDER BY points DESC, nobet ASC, username ASC', 0)
in factory.php line 345
at factory->sql_query('SELECT 1 AS `rank`, 0.00 AS win, u.user_id, u.username AS username, SUM(IF(m.match_no > 0, 1, 0)) AS matches, SUM(IF(b.goals_home = 0 OR b.goals_guest = 0, 1, 0)) AS nobet, SUM(IF(b.goals_home <> 0 AND b.goals_guest <> 0, IF((b.goals_home = m.goals_home) AND (b.goals_guest = m.goals_guest) , 1 , 0 ) , 0 ) ) AS direct_hit, SUM(IF(b.goals_home > 0 AND b.goals_guest > 0, IF((b.goals_home < b.goals_guest) <> (m.goals_home < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home > b.goals_guest) <> (m.goals_home > m.goals_guest) , 0 , 1 ) , 0 ) ) AS tendency , SUM(, IF(b.bet_time > 0, IF((b.goals_home < b.goals_guest) <> (m.goals_home < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home > b.goals_guest) <> (m.goals_home > m.goals_guest), 0, IF((b.goals_home = m.goals_home) AND (b.goals_guest = m.goals_guest), 10, IF(((b.goals_home - b.goals_guest = m.goals_home - m.goals_guest) AND (m.goals_home <> m.goals_guest)), 7, 5 ) ) ), 0 ), 0 ) )AS points FROM phpbb32_mot_swb_matches AS m INNER JOIN phpbb32_mot_swb_bets AS b ON (b.season = m.season AND b.league = m.league AND b.match_no = m.match_no) INNER JOIN phpbb32_users AS u ON (b.user_id = u.user_id) WHERE m.season = 2024 AND m.league = 1 AND m.matchday = 15 AND m.status IN (2,3) GROUP BY b.user_id ORDER BY points DESC, nobet ASC, username ASC')
in functions_mot_swb.php line 685
at functions_mot_swb->save_ranking_matchday(2024, 1, 15, array('season' => '2024', 'league' => '1', 'league_name' => '1. Bundesliga', 'league_name_short' => '1BL', 'league_timezone' => 'Europe/Berlin', 'league_type' => '1', 'matchdays' => '34', 'matches_on_matchday' => '9', 'win_result' => '0', 'win_result_02' => '0', 'win_matchday' => '10', 'win_season' => '0', 'points_mode' => '5', 'points_result' => '10', 'points_tendency' => '5', 'points_diff' => '7', 'points_last' => '0', 'join_by_user' => '1', 'join_in_season' => '0', 'bet_in_time' => '1', 'rules_post_id' => '12', 'bet_ko_type' => '1', 'bet_points' => '50.00'), false)
in mot_swb_acp_fixtures.php line 450
at mot_swb_acp_fixtures->results()
in mot_swb_fixture_module.php line 43
at mot_swb_fixture_module->main('\\mot\\swb\\acp\\mot_swb_fixture_module', 'results')
in functions_module.php line 676
at p_master->load_active()
in index.php line 81
Die Ergebnisse werden trotzdem alle gespeichert und die einzelnen Spiele auf 3 gesetzt. Nur der Spieltag scheint nicht auf 3 gesetzt zu werden.
Ich habe bei Punktemodus Nr. 5 ausgewählt!
ist falsch. Wenn ich das entsprechend ändere ist die Fehlermeldung verschwunden und der Spieltag steht auch auf 3. Wenn ich dann aber in den User-Modus wechsel bekomme ich einen User-Error ohne weitere angaben.
Warum ist die Funktion bei dir soviel umfangreicher geworden? Bei Football war die Berechnung eigentlich völlig ok.
