about summary refs log tree commit diff
path: root/src/database.rs
diff options
context:
space:
mode:
authorgennyble <gen@nyble.dev>2025-08-03 16:51:48 -0500
committergennyble <gen@nyble.dev>2025-08-03 16:51:48 -0500
commit53e34df1ba9ff24708339ae1253ca86ab910771a (patch)
tree35a83cd35fed22b1612fed47ad2952fe60a60458 /src/database.rs
parentdc1f9d30968fe393a15ccc0dfc79af237259b9de (diff)
downloadleaberblord-53e34df1ba9ff24708339ae1253ca86ab910771a.tar.gz
leaberblord-53e34df1ba9ff24708339ae1253ca86ab910771a.zip
dewarn
Diffstat (limited to 'src/database.rs')
-rw-r--r--src/database.rs11
1 files changed, 1 insertions, 10 deletions
diff --git a/src/database.rs b/src/database.rs
index d5ccf92..5bdb4f4 100644
--- a/src/database.rs
+++ b/src/database.rs
@@ -168,7 +168,7 @@ impl Database {
 		let conn = self.conn.lock().unwrap();
 
 		let sql = lb.sql("SELECT * FROM leaderboard_LBID WHERE user_id=?1");
-		let user_handle: String = conn
+		let _user_handle: String = conn
 			.query_row(&sql, params![user], |row| row.get(1))
 			.map_err(|_| Error::UserNotExist)?;
 
@@ -233,15 +233,6 @@ const CREATE_TABLE_LEADERBOARD_HISTORY: &'static str = "\
 		points INTEGER NOT NULL DEFAULT 0
 	);";
 
-const CREATE_TRIGGER_LDBCHANGETIME_UPDATE: &'static str = "\
-	CREATE TRIGGER ldbchangetime_update_LBID
-		AFTER UPDATE ON leaderboard_LBID
-		FOR EACH ROW
-		WHEN NEW.score_updated < OLD.score_updated OR OLD.score_updated IS NULL
-		BEGIN
-			UPDATE leaderboard_LBID SET score_updated=CURRENT_TIMESTAMP WHERE user_id=OLD.user_id;
-		END;";
-
 const CREATE_TRIGGER_LDBHIST_UPDATE: &'static str = "\
 	CREATE TRIGGER ldbdhist_update_LBID BEFORE UPDATE ON leaderboard_LBID
 		BEGIN