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(19); 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 > 1711708866 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 = 19

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
Week 04 Radio Show

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    Paydirt Football.com Forum Index -> Radio Show
View previous topic :: View next topic  
Author Message
Death Angel
Commish


Joined: 01 Oct 2011
Posts: 7291
Location: Yonkers, NY

PostPosted: Mon May 30, 2022 8:13 pm    Post subject: Week 04 Radio Show Reply with quote

https://www.twitch.tv/videos/1313573243
_________________

Super Bowl XXXII Champs
Super Bowl XLII Champs
Super Bowl XLV Champs
Back to top
View user's profile Send private message AIM Address
Death Angel
Commish


Joined: 01 Oct 2011
Posts: 7291
Location: Yonkers, NY

PostPosted: Tue May 31, 2022 3:54 pm    Post subject: Reply with quote

BROADCAST REWARDS
- talked about on the radio show
- questions or concerns please post or message me
- FOR NEXT SEASON

Points per game broadcasted
.6 - overlay - 10 pts(max)
.475 - no overlay - 8 points (max)
Rounded down

These points can be applied as the owner wishes within the frame work of normal TC ratings limitations. The exception will be, instead of a max of 2 to any rating - it would be a max of 4 and all points can go to one player, no restriction on points to a player
- IE: +4 AWR, +4 STR, +2 RBK could be applied to your OL
- for Broadcast points only



Tier 0
1 - 7 games broadcasted

Reward
- points based on # of games broadcasted and if overlay is used or not

Tier 1
8 games broadcasted

Reward
- points based on # of games broadcasted and if overlay is used or not
- add 1 4yr negotiation(RESIGN) for the season

Tier 2
12 games broadcasted

Reward
- points based on # of games broadcasted and if overlay is used or not
- add 1 5yr negotiation(RESIGN) for the season
- 1 trait change
- one 77 OVR UFA signing automatic (No bidding)
--- just have to post in the forums and then go sign in the game
--- don't have to use it right away but has to be used before completion of week 18 games

Tier 3
17 games broadcasted

Reward
- points based on # of games broadcasted and if overlay is used or not
- Trade one player that is in his last year of his contract
---- still has to be 28 yrs old or younger
---- Would of course have to be a future credit as trading will be close when awarded


1 more 5 year deal
1 more 4 year deal
- does not roll over


When rewards will be handed out with be the following:

50% of season 9 games
--- so after week 9 games are played reward owners

75% of season 13 games.
--- so after week 13 games are played reward owners

100% of season 17 games
--- so after week 18 games are played reward owners

No reward for playoff broadcast
- if owner want points you must broadcast playoffs and post in the forums & broadcast chat
- if owner doesn't broadcast playoffs and post, they can only get points the following season and at 50% deduction
_________________

Super Bowl XXXII Champs
Super Bowl XLII Champs
Super Bowl XLV Champs
Back to top
View user's profile Send private message AIM Address
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.    Paydirt Football.com Forum Index -> Radio Show 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