From: Steinar H. Gunderson <sgunderson@bigfoot.com>
Date: Fri, 16 Mar 2018 19:30:31 +0000 (+0100)
Subject: Update the rosters for the new NM2018 sheet.
X-Git-Url: https://git.sesse.net/?p=ultimatescore;a=commitdiff_plain;h=6326db7bf5bf6b75ae574b2d4c34467e946cde8e

Update the rosters for the new NM2018 sheet.
---

diff --git a/quickl3.js b/quickl3.js
index 1709cb7..0ef871e 100644
--- a/quickl3.js
+++ b/quickl3.js
@@ -8,7 +8,8 @@ function load_l3(sheet, prefix, cb)
 		let l3s = [];
 		let i;
 		for (i = 0; i < response.values.length; ++i) {
-			if (response.values[i][0] === 'Number') {
+			if (response.values[i][0] === 'Number' ||
+			    response.values[i][0] === 'Fake #') {
 				++i;
 				break;
 			}
@@ -42,7 +43,7 @@ function load_l3(sheet, prefix, cb)
 		}
 		cb(l3s, sheet);
 	};
-	req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1uh7kr5v_hyD072b1G2tbQlhqd_8ldS_6j30CBocQ-4E/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
+	req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1VyLIS2GeohLlIRFs6c8kk6g0ZnBFXXiYNh_JROC-iZM/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
 	req.send();
 };
 
diff --git a/roster.js b/roster.js
index b5dd4db..3524189 100644
--- a/roster.js
+++ b/roster.js
@@ -33,7 +33,7 @@ function load_roster(sheet, cb)
 		}
 		cb(team_name, roster);
 	};
-	req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1uh7kr5v_hyD072b1G2tbQlhqd_8ldS_6j30CBocQ-4E/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
+	req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1VyLIS2GeohLlIRFs6c8kk6g0ZnBFXXiYNh_JROC-iZM/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
 	req.send();
 };