X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=quickl3.js;h=39f4fc61700527174d4ba2d7697a06037e338027;hb=3c3a5c028bed3922840a2b5ad7ab861fca092582;hp=1f9efdf98a6a1410c72de0e44b345e3f1d8f5a3e;hpb=5e3676c0b149c5bc342fedf54ac87a75fbae88dc;p=ultimatescore diff --git a/quickl3.js b/quickl3.js index 1f9efdf..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; } @@ -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(); };