Update the rosters for the new NM2018 sheet.

[ultimatescore] / roster.js

diff --git a/roster.js b/roster.js
index b9230fd113ab1c9a68f04559e3587d85bda8d01c..3524189a741c799dfb823582504f1a24b60bfcc9 100644 (file)
--- a/roster.js
+++ b/roster.js
@@ -1,28 +1,31 @@
+'use strict';
+
 function load_roster(sheet, cb)
 {
-       var req = new XMLHttpRequest();
+       let req = new XMLHttpRequest();
        req.onload = function(e) {
-               var response = JSON.parse(req.responseText);
+               let response = JSON.parse(req.responseText);
 
-               var team_name = '';
+               let team_name = '';
                if (response.values[0].length >= 1 &&
                    response.values[0][0] !== undefined &&
                    response.values[0][0] !== null) {
                        team_name = response.values[0][0];
                }
 
-               var roster = [];
-               var i;
+               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;
                        }
                }
 
                for ( ; response.values[i] !== undefined && response.values[i].length >= 3; ++i) {
-                       var display_number = response.values[i][1];
-                       var name = response.values[i][2];
+                       let display_number = response.values[i][1];
+                       let name = response.values[i][2];
                        roster.push({
                                "number": display_number,
                                "name": name
@@ -30,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/1VyLIS2GeohLlIRFs6c8kk6g0ZnBFXXiYNh_JROC-iZM/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
        req.send();
 };
 
@@ -38,7 +41,7 @@ function display_roster(team_name, roster)
 {
        document.getElementById('entire-bug').style.display = 'none';
 
-       var carousel = document.getElementById('carousel');
+       let carousel = document.getElementById('carousel');
        clear_carousel(carousel);
 
        if (team_name === '') {
@@ -47,8 +50,8 @@ function display_roster(team_name, roster)
                addheading(carousel, 4, 'Team lineup<br />' + team_name);
        }
 
-       for (var i = 0; i < roster.length; i += 2) {
-               var tr = document.createElement("tr");
+       for (let i = 0; i < roster.length; i += 2) {
+               let tr = document.createElement("tr");
 
                addth(tr, "playernum", roster[i].number);
                addtd(tr, "playername", roster[i].name);
@@ -79,11 +82,11 @@ function showroster_from_state()
 
 function showrostercarousel(sheet1, sheet2)
 {
-       var team_names = [null, null];
-       var rosters = [null, null];
-       var num_left = 2;
+       let team_names = [null, null];
+       let rosters = [null, null];
+       let num_left = 2;
 
-       var cb = function(id, team_name, roster) {
+       let cb = function(id, team_name, roster) {
                team_names[id] = team_name;
                rosters[id] = roster;
                if (--num_left == 0) {