diff --git a/src/main/kotlin/net/taehui/twilight/system/DB.kt b/src/main/kotlin/net/taehui/twilight/system/DB.kt index de24e51..d9c06c0 100644 --- a/src/main/kotlin/net/taehui/twilight/system/DB.kt +++ b/src/main/kotlin/net/taehui/twilight/system/DB.kt @@ -326,7 +326,7 @@ """ DELETE FROM tw_favor - WHERE Avatar = ? AND Note_ID = ? + WHERE Note_ID = ? AND Avatar = ? """.trimIndent() ).use { dbStatement -> dbStatement.setString(1, noteID) @@ -974,7 +974,7 @@ """ SELECT Favor FROM tw_favor - WHERE Avatar = ? AND Note_ID = ? + WHERE Note_ID = ? AND Avatar = ? """.trimIndent() ).use { dbStatement -> dbStatement.setString(1, noteID) @@ -1150,7 +1150,7 @@ """ DELETE FROM tw_commentary - WHERE Avatar = ? AND Note_ID = ? + WHERE Note_ID = ? AND Avatar = ? """.trimIndent() ).use { dbStatement -> dbStatement.setString(1, noteID) @@ -1694,8 +1694,8 @@ WHERE Avatar = ? AND Name = ? """.trimIndent() ).use { dbStatement -> - dbStatement.setString(1, bundleName) - dbStatement.setString(2, avatarID) + dbStatement.setString(1, avatarID) + dbStatement.setString(2, bundleName) dbStatement.executeQuery().use { rows -> if (rows.next()) { arrayOf( @@ -2925,11 +2925,11 @@ """ SELECT Handled FROM tw_handled - WHERE Avatar = ? AND Note_ID = ? + WHERE Note_ID = ? AND Avatar = ? """.trimIndent() ).use { dbStatement -> - dbStatement.setString(1, avatarID) - dbStatement.setString(2, noteID) + dbStatement.setString(1, noteID) + dbStatement.setString(2, avatarID) dbStatement.executeQuery().use { rows -> if (rows.next()) Component.Handled.getHandled(rows.getInt("Handled")) else Component.Handled.NOT }