README

README
------

NAFLM 2020 
is an updated version of the original OBBLM for the Blood Bowl 2020 rules
NAFLM 2020 updated by Val Catella (2020-2023) for the NAF

Please visit https://thenaf.obblm.com/ to register for a NAF hosted league

If installing NAFLM on your own server please copy all files then run install.php from a browser

If database is already installed from v3 and updating to v4.1 (latest as of March 2019) then please run the following script in your database to add new fields:

ALTER TABLE teams
ADD COLUMN fav_rule SMALLINT(5) UNSIGNED DEFAULT NULL AFTER win_pct;
ALTER TABLE players
ADD COLUMN date_retired DATETIME NULL DEFAULT NULL AFTER date_died;
ALTER TABLE mv_coaches
ADD COLUMN bonus SMALLINT(6) NULL DEFAULT NULL AFTER smp;
ALTER TABLE mv_players
ADD COLUMN bonus SMALLINT(6) NULL DEFAULT NULL AFTER smp;
ALTER TABLE mv_races
ADD COLUMN bonus SMALLINT(6) NULL DEFAULT NULL AFTER smp;
ALTER TABLE mv_teams
ADD COLUMN bonus SMALLINT(6) NULL DEFAULT NULL AFTER smp;
ALTER TABLE matches
ADD COLUMN bonus1 TINYINT(4) NOT NULL DEFAULT 0 AFTER tv2;
ALTER TABLE matches
ADD COLUMN bonus2 TINYINT(4) NOT NULL DEFAULT 0 AFTER bonus1;

THEN replace files, after which in NAFLM core panel, please run Re-install database first, then synchronise

NOV 2023 
in order to fix a bug with returning niggles/injuries after admin removed them, please make sure you have all the latest files (v4.3) and run the following script to add new columns to your DB:

ALTER TABLE `players` 
ADD COLUMN `ma_mod` TINYINT(3) SIGNED DEFAULT '0' AFTER `inj_ni`,
ADD COLUMN `st_mod` TINYINT(3) SIGNED DEFAULT '0' AFTER `ma_mod`,
ADD COLUMN `ag_mod` TINYINT(3) SIGNED DEFAULT '0' AFTER `st_mod`,
ADD COLUMN `pa_mod` TINYINT(3) SIGNED DEFAULT '0' AFTER `ag_mod`,
ADD COLUMN `av_mod` TINYINT(3) SIGNED DEFAULT '0' AFTER `pa_mod`,
ADD COLUMN `ni_mod` TINYINT(3) SIGNED DEFAULT '0' AFTER `av_mod`;