Paydirt Football.com Forum Index
 TWR.comLeague Site  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getSetting(im_protocol); failed:

SELECT value FROM MYSQL_DATABASE.league_settings WHERE setting = 'im_protocol'

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`league_settings`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGM(59); failed:

SELECT DISTINCT u.user_id, u.username, u.user_email, u.user_, u.user_lastvisit, IFNULL(t.team, 'NFL') as _team, IFNULL(n.full_name, '') FROM MYSQL_DATABASE.phpbb_users u LEFT JOIN MYSQL_DATABASE.league_gms_yearly t ON t.user_id = u.user_id AND t.year = DEFAULT_START_YEAR AND t.end_date > 1711621745 LEFT JOIN MYSQL_DATABASE.league_gms_yearly at ON at.user_id = u.user_id LEFT JOIN MYSQL_DATABASE.MYSQL_STANDINGS s ON s.team = t.team AND s.year = DEFAULT_START_YEAR LEFT JOIN MYSQL_DATABASE.league_gms n ON n.user_id = u.user_id WHERE u.user_id = 59

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`phpbb_users`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getHistory(); failed:

SELECT MIN(t.start_date) as join_date, MAX(t.year) as last_year, MIN(t.year) as first_year, MAX(t.end_date) FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id =

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year, t.team, t.first_week, t.last_week, t.start_date, t.end_date FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT DISTINCT t.team FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = AND t.team = '' ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.team = '' ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1

Joined LEAGUE_NAME: January 01, 1970
GM Experience: to
Main :: Trophy Case :: vs. Other GMs
TEAM W L T .PCT
0.000
LEAGUE_NAME 0.000
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getSetting(im_protocol); failed:

SELECT value FROM MYSQL_DATABASE.league_settings WHERE setting = 'im_protocol'

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`league_settings`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGM(4); failed:

SELECT DISTINCT u.user_id, u.username, u.user_email, u.user_, u.user_lastvisit, IFNULL(t.team, 'NFL') as _team, IFNULL(n.full_name, '') FROM MYSQL_DATABASE.phpbb_users u LEFT JOIN MYSQL_DATABASE.league_gms_yearly t ON t.user_id = u.user_id AND t.year = DEFAULT_START_YEAR AND t.end_date > 1711621745 LEFT JOIN MYSQL_DATABASE.league_gms_yearly at ON at.user_id = u.user_id LEFT JOIN MYSQL_DATABASE.MYSQL_STANDINGS s ON s.team = t.team AND s.year = DEFAULT_START_YEAR LEFT JOIN MYSQL_DATABASE.league_gms n ON n.user_id = u.user_id WHERE u.user_id = 4

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`phpbb_users`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getHistory(); failed:

SELECT MIN(t.start_date) as join_date, MAX(t.year) as last_year, MIN(t.year) as first_year, MAX(t.end_date) FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id =

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year, t.team, t.first_week, t.last_week, t.start_date, t.end_date FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT DISTINCT t.team FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = AND t.team = '' ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.team = '' ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1

Joined LEAGUE_NAME: January 01, 1970
GM Experience: to
Main :: Trophy Case :: vs. Other GMs
TEAM W L T .PCT
0.000
LEAGUE_NAME 0.000
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getSetting(im_protocol); failed:

SELECT value FROM MYSQL_DATABASE.league_settings WHERE setting = 'im_protocol'

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`league_settings`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGM(105); failed:

SELECT DISTINCT u.user_id, u.username, u.user_email, u.user_, u.user_lastvisit, IFNULL(t.team, 'NFL') as _team, IFNULL(n.full_name, '') FROM MYSQL_DATABASE.phpbb_users u LEFT JOIN MYSQL_DATABASE.league_gms_yearly t ON t.user_id = u.user_id AND t.year = DEFAULT_START_YEAR AND t.end_date > 1711621745 LEFT JOIN MYSQL_DATABASE.league_gms_yearly at ON at.user_id = u.user_id LEFT JOIN MYSQL_DATABASE.MYSQL_STANDINGS s ON s.team = t.team AND s.year = DEFAULT_START_YEAR LEFT JOIN MYSQL_DATABASE.league_gms n ON n.user_id = u.user_id WHERE u.user_id = 105

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`phpbb_users`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getHistory(); failed:

SELECT MIN(t.start_date) as join_date, MAX(t.year) as last_year, MIN(t.year) as first_year, MAX(t.end_date) FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id =

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year, t.team, t.first_week, t.last_week, t.start_date, t.end_date FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT DISTINCT t.team FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = AND t.team = '' ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.team = '' ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1

Joined LEAGUE_NAME: January 01, 1970
GM Experience: to
Main :: Trophy Case :: vs. Other GMs
TEAM W L T .PCT
0.000
LEAGUE_NAME 0.000
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getSetting(im_protocol); failed:

SELECT value FROM MYSQL_DATABASE.league_settings WHERE setting = 'im_protocol'

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`league_settings`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGM(87); failed:

SELECT DISTINCT u.user_id, u.username, u.user_email, u.user_, u.user_lastvisit, IFNULL(t.team, 'NFL') as _team, IFNULL(n.full_name, '') FROM MYSQL_DATABASE.phpbb_users u LEFT JOIN MYSQL_DATABASE.league_gms_yearly t ON t.user_id = u.user_id AND t.year = DEFAULT_START_YEAR AND t.end_date > 1711621745 LEFT JOIN MYSQL_DATABASE.league_gms_yearly at ON at.user_id = u.user_id LEFT JOIN MYSQL_DATABASE.MYSQL_STANDINGS s ON s.team = t.team AND s.year = DEFAULT_START_YEAR LEFT JOIN MYSQL_DATABASE.league_gms n ON n.user_id = u.user_id WHERE u.user_id = 87

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`phpbb_users`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getHistory(); failed:

SELECT MIN(t.start_date) as join_date, MAX(t.year) as last_year, MIN(t.year) as first_year, MAX(t.end_date) FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id =

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year, t.team, t.first_week, t.last_week, t.start_date, t.end_date FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT DISTINCT t.team FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = AND t.team = '' ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.team = '' ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1

Joined LEAGUE_NAME: January 01, 1970
GM Experience: to
Main :: Trophy Case :: vs. Other GMs
TEAM W L T .PCT
0.000
LEAGUE_NAME 0.000
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getSetting(im_protocol); failed:

SELECT value FROM MYSQL_DATABASE.league_settings WHERE setting = 'im_protocol'

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`league_settings`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGM(27); failed:

SELECT DISTINCT u.user_id, u.username, u.user_email, u.user_, u.user_lastvisit, IFNULL(t.team, 'NFL') as _team, IFNULL(n.full_name, '') FROM MYSQL_DATABASE.phpbb_users u LEFT JOIN MYSQL_DATABASE.league_gms_yearly t ON t.user_id = u.user_id AND t.year = DEFAULT_START_YEAR AND t.end_date > 1711621745 LEFT JOIN MYSQL_DATABASE.league_gms_yearly at ON at.user_id = u.user_id LEFT JOIN MYSQL_DATABASE.MYSQL_STANDINGS s ON s.team = t.team AND s.year = DEFAULT_START_YEAR LEFT JOIN MYSQL_DATABASE.league_gms n ON n.user_id = u.user_id WHERE u.user_id = 27

MySQL said: SELECT command denied to user 'pfl1'@'localhost' for table `MYSQL_DATABASE`.`phpbb_users`
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getHistory(); failed:

SELECT MIN(t.start_date) as join_date, MAX(t.year) as last_year, MIN(t.year) as first_year, MAX(t.end_date) FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id =

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year, t.team, t.first_week, t.last_week, t.start_date, t.end_date FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT DISTINCT t.team FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in numTableEntries(MYSQL_TEAM_INFO); failed:

SELECT COUNT(*) FROM MYSQL_TEAM_INFO

MySQL said: Table 'pfl1.MYSQL_TEAM_INFO' doesn't exist
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getTeamHistory(); failed:

SELECT t.year FROM MYSQL_DATABASE.league_gms_yearly t WHERE t.user_id = AND t.team = '' ORDER BY t.year ASC, t.start_date ASC

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.team = '' ORDER BY t.year ASC, t.start_date ASC' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score > s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score < s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1
UTIL_NAME UTIL_VERSION Fatal Error:
The following query in getGMHistory(); failed:

SELECT COUNT(*) FROM MYSQL_DATABASE.league_gms_yearly y JOIN MYSQL_DATABASE.MYSQL_SCHEDULES s ON s.year = y.year AND s.team = y.team AND s.played = 'yes' AND s.opponent <> 'BYE' AND s.week >= y.first_week AND s.week < y.last_week AND s.team_score = s.opp_score WHERE y.user_id = AND s.week < 18

MySQL said: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND s.week < 18' at line 1

Joined LEAGUE_NAME: January 01, 1970
GM Experience: to
Main :: Trophy Case :: vs. Other GMs
TEAM W L T .PCT
0.000
LEAGUE_NAME 0.000
The 10X PFL Week 6 Power Rankings

 
Post new topic   Reply to topic    Paydirt Football.com Forum Index -> League Articles
View previous topic :: View next topic  
Author Message
Bojack
Team Owner


Joined: 25 Sep 2013
Posts: 1316
Location: Indiana

PostPosted: Thu Aug 06, 2020 6:05 pm    Post subject: The 10X PFL Week 6 Power Rankings Reply with quote

I have created the 10X Power Rankings. I am hoping we can use this to talk about who agree's/disagree's etc. Welcome to the first installment of the 10X PFL Power Rankings. I used some schedule of strength and overall performance.

1. Pats
2. Bucs
3. Bears
4. Rams
5. Chiefs
6. Giants
7. Jags
8. Seahawks
9. Bengals
10. Colts
11. Packers
12. Titans
13. Falcons
14. Redskins
15. Browns
16. Cowboys
17. Eagles
18. Dolphins
19. Jets
20. Saints
21. Broncos
22. Ravens
23. Raiders
24. Panthers
25. Cardinals
26. Texans
27. 49ers
28. Vikings
29. Chargers
30. Steelers
31. Bills
32. Lions
_________________

www.twitch.tv/average_joker
Back to top
View user's profile Send private message Send e-mail AIM Address
JimQB16
Commish


Joined: 01 Oct 2011
Posts: 2781
Location: Weston, Florida

PostPosted: Thu Aug 06, 2020 6:18 pm    Post subject: Reply with quote

Very nice! Thank you for putting this together.
_________________
Back to top
View user's profile Send private message Visit poster's website AIM Address
Livo
Retired


Joined: 08 Jan 2020
Posts: 336

PostPosted: Fri Aug 07, 2020 4:38 am    Post subject: Reply with quote

kudos to put this together....few thoughts on rankings:

- no disrespect to Pats but Buccs should be #1 easily at the moment i think that ozi lost like 4 games in last 3 seasons and until he lose this year he should be #1

- dont know how the hell the Bears are at #3 all their wins this year were against the teams with loosing record the only game against the team with winning record they lost badly

- i think that both bengals and colts should be higher on the list and same goes for 49ers and Panthers
Back to top
View user's profile Send private message AIM Address
Bojack
Team Owner


Joined: 25 Sep 2013
Posts: 1316
Location: Indiana

PostPosted: Fri Aug 07, 2020 7:19 am    Post subject: Reply with quote

Thanks for the comments. I cannot argue your points and this ranking will change as the weeks pass. This was just based upon week 1 to now.

Many of these tops teams have had easy schedules. The Pats have had the easiest ranked schedule by far. Bears schedule I had it ranked as the 5th easiest schedule.

It will be interesting to see the movers week over week.
_________________

www.twitch.tv/average_joker
Back to top
View user's profile Send private message Send e-mail AIM Address
Soup Can
Retired


Joined: 27 Feb 2017
Posts: 433
Location: Baltimore, MD

PostPosted: Fri Aug 07, 2020 6:50 pm    Post subject: Reply with quote

I don't agree with the Seahawks.... If I had those 3 cheat codes I would win 3 SB in a row too. Yeah I don't deserve to be in the top ten. I need 2 or 3 seasons.
Back to top
View user's profile Send private message Send e-mail AIM Address
Oompa Loompas
Team Owner


Joined: 01 Oct 2011
Posts: 1062
Location: Cleveland, OH

PostPosted: Fri Aug 07, 2020 11:02 pm    Post subject: Reply with quote

Great read Mike G.
Looking forward to seeing the next one.

When posting your rankings, would you please highlight the Broncos.
_________________
Back to top
View user's profile Send private message AIM Address
Bojack
Team Owner


Joined: 25 Sep 2013
Posts: 1316
Location: Indiana

PostPosted: Fri Aug 07, 2020 11:32 pm    Post subject: Reply with quote

LOL GLen
_________________

www.twitch.tv/average_joker
Back to top
View user's profile Send private message Send e-mail AIM Address
Display posts from previous:   
Post new topic   Reply to topic    Paydirt Football.com Forum Index -> League Articles All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group