From aeb5c84e9c3a013f0ae12b4a7b2297f6f45dca4c Mon Sep 17 00:00:00 2001
From: George Hazan <george.hazan@gmail.com>
Date: Thu, 10 Apr 2025 14:03:38 +0300
Subject: Dbx_Sqlite: fix for database checker & unread events

---
 plugins/Dbx_sqlite/src/dbcheck.cpp | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'plugins/Dbx_sqlite/src/dbcheck.cpp')

diff --git a/plugins/Dbx_sqlite/src/dbcheck.cpp b/plugins/Dbx_sqlite/src/dbcheck.cpp
index 661b87f1ff..d6cad456c4 100644
--- a/plugins/Dbx_sqlite/src/dbcheck.cpp
+++ b/plugins/Dbx_sqlite/src/dbcheck.cpp
@@ -93,6 +93,23 @@ int CDbxSQLite::CheckPhase4()
 	return 0;
 }
 
+/////////////////////////////////////////////////////////////////////////////////////////
+// update unsynced flags & is_read field
+
+int CDbxSQLite::CheckPhase5()
+{
+	sqlite3_stmt *pQuery;
+	int rc = sqlite3_prepare_v2(m_db, "UPDATE events SET flags = flags | 4 WHERE is_read = 1", -1, &pQuery, nullptr);
+	logError(rc, __FILE__, __LINE__);
+	if (rc)
+		return rc;
+
+	rc = sqlite3_step(pQuery);
+	logError(rc, __FILE__, __LINE__);
+	sqlite3_finalize(pQuery);
+	return 0;
+}
+
 ///////////////////////////////////////////////////////////////////////////////
 // MIDatabaseChecker
 
@@ -103,6 +120,7 @@ int CDbxSQLite::CheckDb(int phase)
 	case 1: return CheckPhase2();
 	case 2: return CheckPhase3();
 	case 3: return CheckPhase4();
+	case 4: return CheckPhase5();
 	}
 
 	DBFlush(true);
-- 
cgit v1.2.3