nickfrerichs / fflproject Goto Github PK

In my league, one of the new rules passed this offseason was adding negative points to Team Defense when they give up 30+ points.
-1pt 30-39
-2pt 40+

In the Scoring Definitions, under D_ST, there is an Away Team Score, and under team Offense there is a Home Score. How can I go about making this work without getting to crazy?

Hi -
Having trouble getting system to update for 2018 season. I've tried a few things but best I've done is change to 2017 postseason. right now update.py -hello returns Year 2017 week 17 week type REG

Use team_division table for divisions and save historic settings similar to scoring defs and positions.

What files would I need to edit in order to add in an IR slot under the Bench view for My Team/Roster ?

David Johnson had been drafted and when "reset NFL rankings" click, he would be listed again.

This may have been caused by a manual edit to the DB and since it's not reproducible, we'll never know. I'm closing the issue for now, if it happens again I'll look into it again.

I've setup the league but every time I try to start the draft it says it's the offseason. I also noticed it won't let me toggle the "auto start" for draft. anyone else experience this problem?

This isn't an actual issue but still looking for something that we could use to mark injured players. That was one of the biggest things we had problems with.
I have my site updated to latest development version looking good.

Noticed that the "roster" table does not contain any means to know when a player was acquired or released, so when looking at history cannot calculate "bench" score by week. Maybe we add two columns to roster table - week added and week removed, so you can see historically what the bench was in prior weeks?

have tried -all and -all -recalc_all but continue getting these errors -

Udpating NFL Statistics (2017-09-22 00:43:03)

Reading NFL stats for Week 1
Got all games
--- 0.318994045258 seconds ---

KC (42) at NE (27) - Q: Final, 00:39
NYJ (12) at BUF (21) - Q: Final, 00:39
ATL (23) at CHI (17) - Q: Final, 00:03
BAL (20) at CIN (0) - Q: Final, 00:25
PIT (21) at CLE (18) - Q: Final, 00:36
ARI (23) at DET (35) - Q: Final, 00:18
JAX (29) at HOU (7) - Q: Final, 00:32
OAK (26) at TEN (16) - Q: Final, 00:07
PHI (30) at WAS (17) - Q: Final, 00:25
IND (9) at LA (46) - Q: Final, 00:00
SEA (9) at GB (17) - Q: Final, 00:39
CAR (23) at SF (3) - Q: Final, 00:25
NYG (3) at DAL (19) - Q: Final, 00:04
NO (19) at MIN (29) - Q: Final, 00:28
LAC (21) at DEN (24) - Q: Final, 00:01
Purged 0 nfl_statistic rows.
--- 5.89258694649 seconds ---

Calculating and storing fantasy values

****** 6596 fantasy_statistics to calculate

Traceback (most recent call last):
File "livestats.py", line 654, in
main()
File "livestats.py", line 46, in main
update_games(year, week, weektype, args.all)
File "livestats.py", line 76, in update_games
update_fantasy_statistics(year, week, weektype)
File "livestats.py", line 432, in update_fantasy_statistics
scoring_def = get_scoring_def_dict(leagueid, year)
File "livestats.py", line 511, in get_scoring_def_dict
cur.execute(query)
File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'None' in 'where clause'")

when I try for week 2 it won't return game scores -
python livestats.py -week 2 -all -recalc_all
Udpating NFL Statistics (2017-09-22 00:46:35)

Reading NFL stats for Week 2
Traceback (most recent call last):
File "livestats.py", line 654, in
main()
File "livestats.py", line 46, in main
update_games(year, week, weektype, args.all)
File "livestats.py", line 67, in update_games
(live_changes_made, livegamecount) = update_nfl_statistics(year, week, weektype, update_all)
File "livestats.py", line 109, in update_nfl_statistics
games = nflgame.games(int(year), week=int(week), kind=weektype)
File "/usr/lib/python2.7/site-packages/nflgame/init.py", line 229, in games
return list(games_gen(year, week, home, away, kind, started))
TypeError: 'NoneType' object is not iterable

Hi -
I have completed the instructions for installation and now get the init page and link to create super user. When I click this however, I receive an error indicating:

Not Found
The requested URL /fflproject/accounts/register was not found on this server.

Any advice on what I have done incorrectly is appreciated!

thx
Brandon

Pretty much got everything working except having an issue where draft information is not updated unless everyone refreshes the page after someone picks. Any ideas or suggestions?

The table doesn't always update and sometimes the page needs to be refreshed to make it work. It also doesn't update correctly if an owner is skipped when time expires.

Where enforced, make sure the no min/no max position values work as they should.

One idea:
Once it's detected that an NFL season has completed based on the schedule (ex: next game in the NFL schedule is the new season), give the option to a league admin to reset rosters and start the next season. Then, I could store "current_season" in the league table.

I am in a .5 PPR league, and the scoring definitions keep rounding the receptions to 1 pt instead of leaving it at .5. How can I bypass rounding?

getting an error related to Xavier Brown when trying to import players for 2017

Updating local FF database....
New player: 00-0029713 Xavier Brown (0 - 0)
Traceback (most recent call last):
File "update.py", line 867, in
main()
File "update.py", line 69, in main
update_players(year, week, weektype)
File "update.py", line 374, in update_players
cur.execute(query)
File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1366, "Incorrect integer value: '' for column 'height' at row 1")

Defensive TDS or safety's dont seem to get pulled after running livestats.py........Although, running nflgame and pulling stats from a player, i don't think they show up either.

An example would be 1 defensive TD from Kwon Alexander, week 3, TB vs LA

Any hints on where to look next. probably a nflgame issue tho....

I've added some screen shots - but can't see the starters. If I go into admin mode - I can see them -

Hi - I've attempted to get the project running - but right now I can only get an error message on step 1 -
"Your config file does not appear to be formatted correctly."

I have placed the fflproject directory in my /var/www/http directory.
I copied the config-example.php to /fflproject/application/config/config.php and modified as below:

This is my config.php file:

keep getting problem running update.py -players

I've tried running multiple times but always same record - is this something to be concerned with?

python update.py -players
Loading games for REG 2017 week 3
Downloading team rosters...
32/32 complete. (100.00%)
Done!

There were some errors during the download. Usually this is a
result of an HTTP request timing out, which means the
resulting "players.json" file is probably missing some data.
An appropriate solution is to re-run the script until there
are no more errors (or when the errors are problems on
NFL.com side.)

Could not get player info from roster row:

Exception:

Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/nflgame/update_players.py", line 419, in run
roster.append(meta_from_soup_row(team, row))
File "/usr/lib/python2.7/site-packages/nflgame/update_players.py", line 179, in meta_from_soup_row
last_name, first_name = map(lambda s: s.strip(), name.split(','))
ValueError: too many values to unpack

Updating local FF database....
Added: 0 players.
Updated: 7660 players.
Completed 2017-09-23 00:55:19.054504

Set lineups.

Are the player photos working with the normal install method? or are there any extra steps. Before I go digging into the script :)

Since the last update, the chat no longer updates unless the page is refreshed. I know I had a problem with chat in a previous issue report, but not sure where the settings lie now that chat.php has been mostly commented out.

Anyone having trouble with email notifications not sending. Im using a gmail account settings in config file with ssl smtp with port 465. and getting nothing. enabled smtp in gmail settings also.

I'm not sure if this is a caching thing with the web browser or not, but when uploading a new team photo it seems to take a few a tries. Since I use the team_id in the filename of the team photos, it may cause other web browser caching behavior when they change.

Good Morning,

Just wanted to let you know of an issue with the new push. When going to the Join League page this is what I get:

So far the other pages I've gone to appear to be fine.

I just updated my development area to the latest Development cut and the trade button visually doesn't appear to do anything when pushed. After I manually refresh I do see the trade.
Installed on Debian 7

While trying to run the update.py script, I receive the follow error. And I have tried it with all the different variables to no avail. Not sure it's a me error or a script error, thought I'd post it here for more research.

As the draft progresses and the live draft updates, the watch list slowly gets emptied out with the new endless scroll.

I attempted to install this project and I am unable to create a super admin account. I am using a local MAMP server configuration and I get the following error:

Not Found

The requested URL /accounts/register was not found on this server.

It definitely is setup correctly with the SQL code and everything is in the root of the htdocs folder. Everytime I go and look for a view or anything to be able to setup the super admin I cannot find anything about it in the code. Am I missing something here?

When I run the update.py script with the option -players, I receive this error:

I have checked any possible permission that could be involved, and have been running it as root to see if I can run it, but cannot.

Any other option I give update.py runs flawlessly. I have gone through the depths of the internet trying to see if this is a generic problem but it doesn't seem to be. Thanks in advance!

One idea is to have some default templates that are available read-only to league admins, but also let leagues create their own which are viewable only for the league they were created in.

I'm having an issue again this year. The page is not refreshing chat/draft data. I can navigate to http:///sse/stream and I echo'd the count so I can see it updating every half second. I can also immediately see when messages are posted. The actual page though doesn't register the change. I know it may have had something to do with FPM previously, but I got it working by changing while(1) to while($count > 0) but since its now while($count > 0) by default, i'm not sure where to look or if its possible. Doesn't need to be efficient, just needs to work (mainly for draft) :)

Update:
Funny part is the draft will work but responds very slowly. Actions such as starting the draft etc take 30 seconds. Picks are much quicker. Chats update as picks are made/etc but not otherwise.

This is a nflgame data issue. After recent player updates all the former SD players show nfl_team_id=0 instead of 8. I went in to the database and changed the chargers Team abbrev to LAC from SD. I did a test and changed Philip Rivers back to nfl_team_id=8 in the database then reran the player update and it changed Rivers back to nfl_team_id=0.

What am I missing. I will check the nflgame page and see if I see anything there.

If you are on your propose trade page and you have one team selected to trade with and use the (change) and select a different team, the add/remove draft picks list doesn't seem to update unless the page is refreshed.

The chat box doesn't allow scrolling.

I have changed the config-example.php to config.php and added my db information and i get these errors. Please help

A PHP Error was encountered

Severity: Warning

Message: mysqli::real_connect(): (28000/1045): Access denied for user 'jrpost7'@'ip-107-180-54-253.ip.secureserver.net' (using password: YES)

Filename: mysqli/mysqli_driver.php

Line Number: 202

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/jrpost77/public_html/system/core/Exceptions.php:272)

Filename: core/Common.php

Line Number: 568

A Database Error Occurred

Unable to connect to your database server using the provided settings.

Filename: core/MY_Controller.php

Line Number: 141

When a pick 6 or fumble recover for a TD occurs, live scoring reports the offense scored a TD in the offensive players' status. The scoring is correct, so it's a cosmetic issue.

So I got this to work with my Synology NAS device. It's the perfect way to have a league up and running 24/7 without dedicating a PC or server to the job. Hopefully this info is helpful to someone in the future. A few changes were needed to get it to work. I wrote this in a chronological order. Start at the top and do each step in order.

Install the following packages on the NAS:
start with the phpmyadmin package as it will automatically install the next 3 on the list
mariadb
php5
web station
python module(not python3)

Set up database:
Open mariadb from main menu
Click "Change MariaDB password"
Leave all the options alone and just hit the ok button
Username will show as root, and you can enter a password (this will be the database username and pass you will use in the future)
Open phpmyadmin using the username and pass you just created in MariaDB.
Create a new database. (this database name will be needed later on)
Click the newly created database and click import
Import the fflproject.sql from the fflproject-master folder

Configure the NAS:
In control panel under terminal and snmp, enable ssh.
SSH into the NAS. You can use putty if you want (https://the.earth.li/~sgtatham/putty/latest/x86/putty.exe)
Login as admin
run command "sudo su" and enter your admin password
run command "wget https://bootstrap.pypa.io/get-pip.py"
run command "python get-pip.py" (may take awhile)
run command "pip install argparse"
run command "pip install nflgame"
run command "pip install pymysql"
run command "pip install tzlocal"

Configure phpffl files:
Download the fflproject
Go into the folder fflproject-master
Make a copy of config-example.php and name it config.php
edit the config.php file making sure
$fflp_dbhost = 'localhost';
$fflp_dbuser = 'root';

Go into the folder python and make a copy of config-example.py and name it config.py
Edit the config.py file making sure
DBHOST = "localhost"
DBUSER = "root"
BASEDIR = "/volume1/web"
PLAYER_UPDATE_CMD = "/usr/bin/nflgame-update-players"

Edit update.py in the python folder:
Replace the 2nd and 3rd import with
import pymysql as MySQLdb
import pymysql.cursors
Replace the db line near the top with:
db = MySQLdb.connect(host=c.DBHOST, user=c.DBUSER, passwd=c.DBPASS, db=c.DBNAME, cursorclass=pymysql.cursors.DictCursor)

Edit livestats.py and replace the 2nd and 3rd import with
import pymysql as MySQLdb
import pymysql.cursors
Replace the db line near the top with:
db = MySQLdb.connect(host=c.DBHOST, user=c.DBUSER, passwd=c.DBPASS, db=c.DBNAME, cursorclass=pymysql.cursors.DictCursor)
Comment out the line "if game != None and (game.playing() or update_all):"

Moving files to the NAS:
Open file station.
delete index.html and web_images from web shared folder
move fflproject-master contents to web shared folder

Setting up manual and automated tasks:
Open control panel.
Click task manager.
Create user defined script for each command below. Make sure enabled is unchecked and run each task as needed
python /volume1/web/python/update.py -players
python /volume1/web/python/update.py -schedule

Create a task using the script below and set the schedule to run it every tuesday morning
python /volume1/web/python/update.py -stats_summary
python /volume1/web/python/livestats.py

Currently, the live draft doesn't check position limits before allowing the player to be drafted.

Watch table doesn't always update properly when a player is picked. Sometimes you have to refresh the entire page to correct it.

My league doesn't do this, so I have no clue what currently happens when players are traded during the live draft. I'll see if it's something that can be added prior to the next season.

I got the first errors fixed and i get this page:

I click on create account and get this error:
No input file specified

Here is my code for config.py

and my htaccess code

sorry for all the questions and thanks for the help in advance

I have created a league I am using for testing - 2 teams, defined scoring, set line up for week 1, 2, 3 but when I try to load the stats for prior weeks I keep getting an error - the current week stats (3) are working fine, but no matter what I try for -week 1 or 2 I get the following:

]$ python livestats.py -year 2017 -week 1 -all -recalc_all
Udpating NFL Statistics (2017-09-24 17:32:46)

Reading NFL stats for Week 1
Traceback (most recent call last):
File "livestats.py", line 656, in
main()
File "livestats.py", line 46, in main
update_games(year, week, weektype, args.all)
File "livestats.py", line 67, in update_games
(live_changes_made, livegamecount) = update_nfl_statistics(year, week, weektype, update_all)
File "livestats.py", line 109, in update_nfl_statistics
games = nflgame.games(int(year), week=int(week), kind=weektype)
File "/usr/lib/python2.7/site-packages/nflgame/init.py", line 229, in games
return list(games_gen(year, week, home, away, kind, started))
TypeError: 'NoneType' object is not iterable

I think I successfully got step one complete - but I can't seem to get the php warning to stop showing....
at the top of each page I've got these warning boxes that keep showing up - I've changed my php.ini file to turn off logging - my config.php file has log level set to 1 - (I've tried 0, 4 always same output) . Anyone have suggestions?

thx
Brandon

A PHP Error was encountered
Severity: Warning

Message: date(): It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone.

Filename: helpers/fflproject_helper.php

Line Number: 33

I'm having an issue with a user staying logged in. For example, after they get the join leage invite URL, they create an account and login. After login session data doesn't seem to persist.

Any tips or suggestions greatly appreciated!

Dez Bryant was only listed in the watch list, not in player search.

Complication is that free agents in this scenario show up with active = 0 and get grouped with the 5,000+ former players, and we don't want all of those showing up.

One solution might be to track when a player was last "seen" in the player update process, then including players with active = 0 as long as they've been seen a certain time frame in the past.

When does update.py -stats_summary -hello report something other than
Year: 2015, Week: 5, Weektype: POST