X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=quickl3.js;h=bec001acb114b23fae458b82942ef96d56d944c5;hb=8b211ae74a29459ee6ad322d29aca768480cd95e;hp=1709cb7c0513bb7b95876515ddc27abcce543692;hpb=f1dc8cfb0b1c65dd065a3353a3056672af20a051;p=ultimatescore diff --git a/quickl3.js b/quickl3.js index 1709cb7..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/1uh7kr5v_hyD072b1G2tbQlhqd_8ldS_6j30CBocQ-4E/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(); };