commit f7cd2d7cb698e4aa0dbd2e90c1538d87b083d439
parent bfead6d0fd0f97286508871de05f98a694fcc9b2
Author: alex wennerberg <alex@alexwennerberg.com>
Date: Tue, 1 Oct 2024 16:48:11 -0400
cleanup
Diffstat:
3 files changed, 7 insertions(+), 4 deletions(-)
diff --git a/sql/delete-last.sql b/sql/delete-last.sql
@@ -1,3 +1,3 @@
-delete from round where id > 62;
-delete from deck where round > 62;
-delete from match where round > 62;
+delete from round where id > 68;
+delete from deck where round > 68;
+delete from match where round > 68;
diff --git a/sql/new.sql b/sql/new.sql
@@ -1,3 +1,6 @@
+.headers off
+.mode list
+
/* awkward and repetitive bc my sql is bad */
select 'New cards this round:';
diff --git a/templates/index.html b/templates/index.html
@@ -15,7 +15,7 @@ tr:hover {background-color: #ddd;}
</head>
<body>
<h1>3 Card Blind Data Analysis</h1>
- Full, cleaned data for <a href="//3cardmagic.org">3 card blind metashape</a>. Source code can be found <a href="//git.alexw.nyc/3cardblind">here</a>. <a href="export.tsv">Download</a> an export as tsv-formatted data.<br>
+ Full, cleaned data for <a href="//3cardmagic.org">3 card blind metashape</a>. Source code can be found <a href="https://git.sr.ht/~aw/3cb-data">here</a>. <a href="export.tsv">Download</a> an export as tsv-formatted data.<br>
Maintained by aw on the 3cb discord. Tag him for questions/comments/feature requests.<br>
<b>Bold</b> represents that that round is the first time this card was played.
<p>Click on a header to sort by that value.</p>
