X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=quickl3.js;h=4487c298c80708ca71460cf7a2233307104d56f8;hb=a5e8345fcfe628521d5d6e1e359456c9cb7e8ec0;hp=1f9efdf98a6a1410c72de0e44b345e3f1d8f5a3e;hpb=5e3676c0b149c5bc342fedf54ac87a75fbae88dc;p=ultimatescore diff --git a/quickl3.js b/quickl3.js index 1f9efdf..4487c29 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; } @@ -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/1VyLIS2GeohLlIRFs6c8kk6g0ZnBFXXiYNh_JROC-iZM/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU'); req.send(); };