X-Git-Url: https://git.sesse.net/?p=remoteglot;a=blobdiff_plain;f=remoteglot.pl;h=b466d4dc2721c48126f0253ec3f6838e318c40f1;hp=287909f8d8a63590c5cd1f9d0e028470495259bf;hb=bfb31cc6182daab7087e2922fde47c3441e3eb65;hpb=311ed98a1cf3eefa25779aa8a67b8532cb619793 diff --git a/remoteglot.pl b/remoteglot.pl index 287909f..b466d4d 100755 --- a/remoteglot.pl +++ b/remoteglot.pl @@ -929,7 +929,8 @@ sub output_json { push @games, { id => $ref->{'id'}, name => "$white–$black", - url => $ref->{'url'} + url => $ref->{'url'}, + hashurl => $ref->{'hash_url'}, }; }; if ($@) { @@ -972,7 +973,7 @@ sub output_json { $dbh->do('INSERT INTO scores (id, score_type, score_value, engine, depth, nodes) VALUES (?,?,?,?,?,?) ' . ' ON CONFLICT (id) DO UPDATE SET ' . ' score_type=EXCLUDED.score_type, ' . - ' score_value=EXCLUDED.score_vlaue, ' . + ' score_value=EXCLUDED.score_value, ' . ' engine=EXCLUDED.engine, ' . ' depth=EXCLUDED.depth, ' . ' nodes=EXCLUDED.nodes',