X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=quickl3.js;h=39f4fc61700527174d4ba2d7697a06037e338027;hb=3c3a5c028bed3922840a2b5ad7ab861fca092582;hp=ba3e9ef984a62788f691f70ddd6c5e20e1b1a05b;hpb=f229762296dd4504ced5af1025b2413b52b2c1e6;p=ultimatescore diff --git a/quickl3.js b/quickl3.js index ba3e9ef..39f4fc6 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; } @@ -27,7 +28,7 @@ function load_l3(sheet, prefix, cb) text = text.replace(/\n/, '
'); let subtext = response.values[i][3]; if (subtext === undefined || subtext === '') { - subtext = 'TrønDisk 2017'; + subtext = 'Norwegian Ultimate Championships 2018'; } l3s[prefix + number] = { @@ -37,12 +38,12 @@ function load_l3(sheet, prefix, cb) }; let image = response.values[i][4]; if (image !== undefined && image.match(/^file:/) !== null) { - l3s[prefix + number].image = image; + l3s[prefix + number].image = image.match(/^file:(.*)/)[0]; } } 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/1VyLIS2GeohLlIRFs6c8kk6g0ZnBFXXiYNh_JROC-iZM/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU'); req.send(); };