From c071aca5c5c16d56aafe38ace2b2c158e1b875fc Mon Sep 17 00:00:00 2001 From: Daniel Hader Date: Fri, 5 Jun 2026 19:29:40 -0500 Subject: server text sanitation, username/email filters, and code length measurement --- src/database/sql/fetch_display_submissions.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/database/sql/fetch_display_submissions.sql') diff --git a/src/database/sql/fetch_display_submissions.sql b/src/database/sql/fetch_display_submissions.sql index 5e836b3..aaceaca 100644 --- a/src/database/sql/fetch_display_submissions.sql +++ b/src/database/sql/fetch_display_submissions.sql @@ -3,8 +3,9 @@ submission.id AS id, user.username AS username, submission.language AS language, submission.details AS details, -submission.code AS code +submission.code AS code, +submission.code_length as code_length FROM submission JOIN user ON user.id = submission.user_id WHERE submission.problem_id = ?1 -ORDER BY length(submission.code); +ORDER BY submission.code_length; -- cgit v1.2.3