aboutsummaryrefslogtreecommitdiff
path: root/mottovote
diff options
context:
space:
mode:
Diffstat (limited to 'mottovote')
-rw-r--r--mottovote/index.js2
-rw-r--r--mottovote/public/style.css1
2 files changed, 2 insertions, 1 deletions
diff --git a/mottovote/index.js b/mottovote/index.js
index 2df985d..eb553e8 100644
--- a/mottovote/index.js
+++ b/mottovote/index.js
@@ -6,7 +6,7 @@ const app = express.Router();
app.use("/", checkUser, express.static(__dirname + "/public/"));
app.get("/api/list", checkUser, async (req, res) => {
- const mottos = await db.query("SELECT id, name, description FROM mottos");
+ const mottos = await db.query("SELECT id, name, description FROM mottos ORDER BY name, description");
const votes = await db.query("SELECT motto_id, votes FROM motto_votes WHERE user_id = ?", [req.session.uid]);
for (const vote of votes) {
diff --git a/mottovote/public/style.css b/mottovote/public/style.css
index 01c368f..1c993f1 100644
--- a/mottovote/public/style.css
+++ b/mottovote/public/style.css
@@ -32,6 +32,7 @@ main {
#voteButton {
height: 10%;
+ margin-bottom: 10px;
}
#vote {