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 > 1714242681 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
Rules

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Paydirt Football.com Forum Index -> Accepted Trades - Neon Sportz Website
View previous topic :: View next topic  
Author Message
Death Angel
Commish


Joined: 01 Oct 2011
Posts: 7332
Location: Yonkers, NY
PostPosted: Fri Nov 24, 2023 10:55 am    Post subject: Rules Reply with quote
TRADING
- All trades MUST be approved by the commissioner, and league administrators before they will be processed on the file. If any trade is denied by (4) of the administrators, the deal is officially denied. Once (4) administrators approve a trade, then it is official. League administrators cannot vote on their own trades.
- No trade shall be approved that causes a team to go over (25) million in cap penalty for the current season or the following season. Once an owner reaches (25) million dollars in cap penalty, they may not trade again until the following season, unless the trade does not cause a cap hit.
- You may NOT trade for draft picks further in the future than the next draft.
- You may not trade rookies or players you picked up in UFA/Practice Squad (in their 1st year on your team)

1) Each trade can only be a max of 6 items, players/picks per team
IE: 6 players or 6 picks or any combination but a max of 6 in total per team
- this is a Madden standard

2) Each trade is judged solely on the value of that given trade. Other subsequent trades that happen are independent of any previous trades.
- So teams can't make 2 or more trades and have their combined value prove the worth of the trades.

3) 6th and 7th round picks can not be traded.
- We will only have a 5 round draft.
- 6th and 7th round picks will be simmed
- the team may keep the players drafted if they so choose

4) "Pick for pick" trades are solely based on the draft value chart.

- https://russellstreetreport.com/wp-content/uploads/2015/03/Screenshot-2015-03-24-07.46.26.png

- The value must be equal or greater then the value of the highest pick's value but not more then 200 points greater. It becomes a simple math equation.
- The trade committee will not need to approve pick for pick trades.
--- the pick for pick trades still need to be posted in the forums
--- the Commish must still approve the trade
- this will allow us to trade picks during the off-the-clock draft.
--- up to and including the 3rd round
--- once we go live there is no trading

5) Players in their last year of their contract can not be traded

6) Players 29 & older can't be traded

- If a trade is posted but not yet processed, and an owner involved in the trade leaves the league, the trade is nullified.
- If you verbally agree to a trade, it is unethical to back out because you change your mind for any reason. Therefore, you should keep your word, and go through with the deal.
- The trade deadline is before your game in week (8).
- You may NOT trade a player in the season you just traded for him.
- You may NOT trade a UFA in the year you picked him up.
- Below is a guideline or a way to gauge draft pick value but there will be variations from year to year

Draft Pick OVR's by RD

1st 83 - 79
2nd 78 - 75
3rd 74 - 70
4th 69 - 65
5th 64 - 60
6th 59 - 56
7th 55-
_________________

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:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Paydirt Football.com Forum Index -> Accepted Trades - Neon Sportz Website 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