phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Das gilt dann natürlich auch für Vorgänger-Versionen von phpBB3.2.5oxpus hat geschrieben:Für php 7.3.x ist das phpBB noch nicht offiziell als kompatibel erklärt worden.
Warum versucht es dann nur schon jeder damit?
Nicht alles, was brandneu ist, ist auch fehlerfrei und gut, erst recht nicht in einer Live Umgebung!
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 'ASC, LOWER(u.username) ASC' at line 14 [1064]
SELECT r.status, r.rank, r.user_id, u.username, r.points, IF(r.win=0, '', r.win) AS win FROM phpbb_footb_rank_matchdays AS r LEFT Join phpbb_users AS u ON (r.user_id = u.user_id) WHERE r.season = 2019 AND r.league = 1 AND r.matchday = 23 AND r.status IN (2,3) ORDER BY rank ASC, LOWER(u.username) ASC
Code: Alles auswählen
$sql = "SELECT
r.status,
r.rank,
r.user_id,
u.username,
r.points,
IF(r.win=0, '', r.win) AS win
FROM " . FOOTB_RANKS . ' AS r
LEFT Join ' . USERS_TABLE . " AS u ON (r.user_id = u.user_id)
WHERE r.season = $season
AND r.league = $league
AND r.matchday = $matchday
AND r.status IN (2,3)
ORDER BY rank ASC, LOWER(u.username) ASC";Code: Alles auswählen
$sql = "SELECT
r.status,
r.rank,
r.user_id,
u.username,
r.points,
IF(r.win=0, '', r.win) AS win
FROM " . FOOTB_RANKS . ' AS r
LEFT Join ' . USERS_TABLE . " AS u ON (r.user_id = u.user_id)
WHERE r.season = $season
AND r.league = $league
AND r.matchday = $matchday
AND r.status IN (2,3)
ORDER BY r.rank ASC, LOWER(u.username) ASC";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 'rank, r.user_id, u.username, u.user_colour, r.status AS stat' at line 2 [1064]
SQL
SELECT r.rank_total AS rank, r.user_id, u.username, u.user_colour, r.status AS status, r.points_total AS points, r.win_total AS win FROM phpbb_footb_rank_matchdays AS r LEFT JOIN phpbb_users AS u ON (r.user_id = u.user_id) WHERE r.season = 2019 AND r.league = 1 AND r.matchday = 23 AND r.status IN (2,3) ORDER BY points DESC, LOWER(u.username) ASC
Code: Alles auswählen
$sql = 'SELECT
r.rank_total AS rank,
r.user_id,
u.username,
u.user_colour,
r.status AS status,
r.points_total AS points,
r.win_total AS win
FROM '. FOOTB_RANKS . ' AS r
LEFT JOIN '. USERS_TABLE . " AS u ON (r.user_id = u.user_id)
WHERE r.season = $season
AND r.league = $league
AND r.matchday = $rank_matchday
AND r.status IN (2,3)
ORDER BY points DESC, LOWER(u.username) ASC";Code: Alles auswählen
$sql = 'SELECT
r.rank_total AS rank,
r.user_id,
u.username,
u.user_colour,
r.status AS status,
r.points_total AS points,
r.win_total AS win
FROM '. FOOTB_RANKS . ' AS r
LEFT JOIN '. USERS_TABLE . " AS u ON (r.user_id = u.user_id)
WHERE r.season = $season
AND r.league = $league
AND r.matchday = $rank_matchday
AND r.status IN (2,3)
ORDER BY r.points DESC, LOWER(u.username) ASC";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 'rank, 0.00 AS win, u.user_id, u.username AS username, SUM(IF(m.m' at line 2 [1064]
SQL
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 = '' OR b.goals_guest = '', 1, 0)) AS nobet, SUM(IF(b.goals_home <> '' AND b.goals_guest <> '', 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 <> '' AND b.goals_guest <> '', IF((b.goals_home + 0 < b.goals_guest) <> (m.goals_home + 0 < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home + 0 > b.goals_guest) <> (m.goals_home + 0 > m.goals_guest) , 0 , 1 ) , 0 ) ) AS tendency, SUM(IF(b.goals_home <> '' AND b.goals_guest <> '',IF(b.goals_home <> '' AND b.goals_guest <> '', IF((b.goals_home + 0 < b.goals_guest) <> (m.goals_home + 0 < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home + 0 > b.goals_guest) <> (m.goals_home + 0 > 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), 10 - ABS(b.goals_home - m.goals_home), IF(((10 - ABS(b.goals_home - m.goals_home) - ABS(b.goals_guest - m.goals_guest)) < 3), 3, 10 - ABS(b.goals_home - m.goals_home) - ABS(b.goals_guest - m.goals_guest) ) ) ) ), 0 ), 0 ) )AS points FROM phpbb_footb_matches AS m INNER JOIN phpbb_footb_bets AS b ON (b.season = m.season AND b.league = m.league AND b.match_no = m.match_no) INNER JOIN phpbb_users AS u ON (b.user_id = u.user_id) WHERE m.season = 2019 AND m.league = 1 AND m.matchday = 1 AND m.status IN (2,3) GROUP BY b.user_id ORDER BY points DESC, nobet ASC, username ASC