From f1dc8cfb0b1c65dd065a3353a3056672af20a051 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Thu, 15 Mar 2018 21:01:10 +0100 Subject: [PATCH] Adjustments for getting data from NM 2018. --- carousel.js | 2 +- quickl3.js | 2 +- roster.js | 5 +++-- 3 files changed, 5 insertions(+), 4 deletions(-) diff --git a/carousel.js b/carousel.js index aefe6db..153d425 100644 --- a/carousel.js +++ b/carousel.js @@ -584,7 +584,7 @@ function get_group(group_name, cb) req.onload = function(e) { cb(JSON.parse(req.responseText), group_name); }; - req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/122tIwrXTi5ug0Vv6Np5w3pVwEWE2KkjWxtzQQfGtOZA/values/\'' + group_name + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU'); + req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1uh7kr5v_hyD072b1G2tbQlhqd_8ldS_6j30CBocQ-4E/values/\'' + group_name + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU'); req.send(); }; diff --git a/quickl3.js b/quickl3.js index 1f9efdf..1709cb7 100644 --- a/quickl3.js +++ b/quickl3.js @@ -42,7 +42,7 @@ function load_l3(sheet, prefix, cb) } cb(l3s, sheet); }; - req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1RciMlauWxqM9LYKdsY6lPjJbIAcHJpCXTqyZSEHxH3U/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU'); + req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1uh7kr5v_hyD072b1G2tbQlhqd_8ldS_6j30CBocQ-4E/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU'); req.send(); }; diff --git a/roster.js b/roster.js index 02ff92e..b5dd4db 100644 --- a/roster.js +++ b/roster.js @@ -16,7 +16,8 @@ function load_roster(sheet, cb) let roster = []; 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; } @@ -32,7 +33,7 @@ function load_roster(sheet, cb) } cb(team_name, roster); }; - req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1RciMlauWxqM9LYKdsY6lPjJbIAcHJpCXTqyZSEHxH3U/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU'); + req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1uh7kr5v_hyD072b1G2tbQlhqd_8ldS_6j30CBocQ-4E/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU'); req.send(); }; -- 2.39.2