Thread: [Device Plugin] Kobo Touch Extended Driver
View Single Post
Old 06-11-2013, 02:15 AM   #421
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
After a while, all my old managers stopped using the word "bad" in that context.

To keep this off topic, the following trigger will do what taming wants:

Code:
CREATE TRIGGER Activity_DismissNewBookTiles
after insert on Activity 
for each row 
when ( new.Type IN ('RecentBook') AND EXISTS 
(SELECT 1 FROM content c where c.contentId = new.Id and c.ReadStatus = 0)
)
begin
	update Activity
	set Enabled	= 'false'
	where rowid = new.rowid;
end
It could be combines with the other trigger, but personally, I won't be using this.
davidfor is offline   Reply With Quote