Thread: [Needed] A solution for marking text messages as read without opening them
View Single Post
Char is offline Char
2011-01-17 , 08:16
Posts: 255 | Thanked: 107 times | Joined on Nov 2010
#9
that could be possible with a bit of sql magic
see: ~/.rtcom-eventlogger/el-v1.db

i did a minor bit of research
xterminal:
Code:
cd .rtcom-eventlogger
cp el-v1.db el-v1.db.bak
sqlite3 el-v1.db
don't miss the ;
(the cp step is optional, it just backs up your database in case something goes wrong)
Code:
update Events set is_read = 1 where is_read = 0 and event_type_id = 11;
.quit
killall rtcom-messaging-ui
and all your messages will be marked as read
if you simply want to see your unread messages then
Code:
select * from Events where event_type_id = 11 and is_read = 0;
will work inside sqlite3

if something wrong happens simply copy el-v1.db.bak back to el-v1.db and killall rtcom-messaging-ui, everything /should/ be fine again
Last edited by Char; 2011-01-17 at 08:40.
 

The Following 3 Users Say Thank You to Char For This Useful Post: