Die Erkennung erweitern kannst Du ja nach gut dünken hier:
Oder nimmst halt
Code
case when (INSTR(lower(sub.genre), 'nachrichten') > 0 or INSTR(lower(sub.genre), 'magazin') > 0) and cnt.source <> sub.source
ungetestet.
Um die Events gegenüberzustellen, könntest Du sowas versuchen
Code
case when cnt.source <> sub.source
then concat('||',sub.longdescription, '||', upper(cnt.source),' Event:||',cnt.longdescription)
else case when sub.longdescription is Null then '' else concat('||',sub.longdescription) end
end,
Alles ungetestet.
Die DVB Events laufen dauernd in den epgd und werden neu gemischt.
Code
May 3 15:50:08 homeserver epgd: 1008 DVB pending, mergeepg done after 2.209 seconds
May 3 15:59:27 homeserver epgd: 523 DVB pending, mergeepg done after 2.360 seconds
May 3 16:00:59 homeserver epgd: 565 DVB pending, mergeepg done after 2.259 seconds
May 3 16:04:05 homeserver epgd: 935 DVB pending, mergeepg done after 2.253 seconds
May 3 16:06:09 homeserver epgd: 514 DVB pending, mergeepg done after 2.187 seconds
May 3 16:10:18 homeserver epgd: 518 DVB pending, mergeepg done after 2.177 seconds
May 3 16:11:19 homeserver epgd: 1015 DVB pending, mergeepg done after 2.089 seconds
May 3 16:13:24 homeserver epgd: 980 DVB pending, mergeepg done after 2.304 seconds
May 3 16:14:56 homeserver epgd: 658 DVB pending, mergeepg done after 1.934 seconds
May 3 16:16:29 homeserver epgd: 608 DVB pending, mergeepg done after 1.967 seconds
May 3 16:20:37 homeserver epgd: 600 DVB pending, mergeepg done after 2.170 seconds
May 3 16:22:42 homeserver epgd: 564 DVB pending, mergeepg done after 1.956 seconds
May 3 16:24:45 homeserver epgd: 524 DVB pending, mergeepg done after 1.881 seconds
May 3 16:28:54 homeserver epgd: 507 DVB pending, mergeepg done after 2.112 seconds
Alles anzeigen
Wie oft die jetzt in die Clients wandern, weiss ich grad nicht.