X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=quickl3.js;h=bec001acb114b23fae458b82942ef96d56d944c5;hb=12b0a68e1897b34861ba10a78c28f024efb21f2d;hp=1f9efdf98a6a1410c72de0e44b345e3f1d8f5a3e;hpb=5e3676c0b149c5bc342fedf54ac87a75fbae88dc;p=ultimatescore diff --git a/quickl3.js b/quickl3.js index 1f9efdf..bec001a 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 = 'Norwegian Ultimate Championships 2018'; + subtext = 'Trøndisk 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:(.*)/)[1]; } } 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/18pTqrwSoqrb9_M9HJkiijMBAPppuSnFDAYEezZTKh00/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU'); req.send(); };