SECRET

3 files changed, 14 insertions, 2 deletions

diff --git a/cli.js b/cli.js
index be454a6..5b20d54 100755
--- a/cli.js
+++ b/cli.js
@@ -250,6 +250,16 @@ if ((idx = params.indexOf("-r")) > -1) {
                 i++;
             }
 
+            // SECRET!!
+            textex = "\\begin{tabularx}{\\textwidth}{*{3}{>{\\RaggedRight\\arraybackslash}X}}\n\n";
+            await data.secrets.forEach(async (secret, ind) => {
+                textex += `{\\small ${secret.secret}}`;
+                textex += ((ind + 1) % 3 == 0 ? "\\\\" : "&") + "\n";
+                if ((ind + 1) % 3 == 0) textex += "\\specialrule{.03em}{0em}{0em}\n";
+            });
+            textex += "\\end{tabularx}\n";
+            await fs.writeFile(__dirname + "/zeitung/parts/generated/secrets.tex", textex);
+
             // Final spinal vinyl
             textex = "\\begin{tabular}{l l l}\n\n";
             await data.users.forEach(async (user, ind) => {
diff --git a/db.js b/db.js
index 6b5c9d7..c8b83e8 100644
--- a/db.js
+++ b/db.js
@@ -298,7 +298,9 @@ class DB {
             "SELECT q.id, a.name, a.middlename, a.surname, q.quote, c.name class FROM quotes q INNER JOIN users a ON q.author_id = a.id INNER JOIN class c ON a.class_id = c.id ORDER BY c.id, a.surname, a.name, a.middlename",
         );
 
-        return { users, profile, questions, ranking, quotes };
+        const secrets = await this.query("SELECT id, secret FROM secrets ORDER BY CHAR_LENGTH(secret)");
+
+        return { users, profile, questions, ranking, quotes, secrets };
     }
 
     async query(query, params) {
diff --git a/zeitung/parts/secrets.tex b/zeitung/parts/secrets.tex
index 323595d..a387859 100644
--- a/zeitung/parts/secrets.tex
+++ b/zeitung/parts/secrets.tex
@@ -1,2 +1,2 @@
 \title{Es ist kein Geheimnis, dass...}
-\lipsum[1-2]
+\generated{secrets}