2019-12-13, 04:59
(2017-02-03, 09:48)BigMong Wrote: Update: Database Version 116 [aka Leia]this helped so much. thank you!!
for now we share 1 set of stats - content is segregated by tags: wife, kid
in our primary DB - we add/remove the kids tag using context.manageTags ( shameless plug )
the 2nd-db is now safe for a 4yr old
ex:
sql:CREATE ALGORITHM=MERGE DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `episode` AS
SELECT x.*
FROM `xbmcvid116`.`episode` x
LEFT JOIN `xbmcvid116`.`tag_link` tl
ON ( x.idShow = tl.media_id AND tl.media_type = "tvshow" )
WHERE tl.tag_id=2 ;