Ik heb een nieuwe siteutil gemaakt met de naam "RTL Gemist". Deze is dus ongeveer het zelfde als de Gemist2 van de RTL XL util van doskabouter.
Momenteel is de bron nog enkel van de iPad, maar ik wil hier in de toekomst (volgende week? ) ook die van NetTV bijvoegen.
Ik zou zeggen, test het uit en zeg wat je er van vind
SELECT
IF(serienaam = title, serienaam, CONCAT(serienaam, " - ", title)) as title,
DATE_FORMAT(broadcastdatetime, "%e-%m-%Y %H:%i") as date,
CONCAT("Zender: ", UPPER(station),"\n", "Titel: ", title, "\n", samenvattinglang) as beschrijving,
CONCAT("http://iptv.rtl.nl/xl/Images/512/288/",thumbnail) as thumbnail,
CONCAT("http://iptv.rtl.nl/ipadxlapp/",movie) as movie,
classname as extra
FROM items
WHERE
DATE(broadcastdatetime) = DATE(NOW()) - INTERVAL '.$_GET['daysback'].' DAY
ORDER BY broadcastdatetime DESC
SELECT * FROM
(
(SELECT
IF(serienaam = title, serienaam, CONCAT(serienaam, " - ", title)) as title,
DATE_FORMAT(broadcastdatetime, "%e-%m-%Y %H:%i") as date,
CONCAT("Zender: ", UPPER(station),"\n", "Titel: ", title, "\n", samenvattinglang) as beschrijving,
CONCAT("http://iptv.rtl.nl/xl/Images/512/288/",thumbnail) as thumbnail,
CONCAT("http://iptv.rtl.nl/ipadxlapp/",movie) as movie,
classname as extra,
broadcastdatetime,
"ipadxlapp" as tbl
FROM items
WHERE
NOT EXISTS (
SELECT
1
FROM items_nettv
WHERE items.uniqueid=items_nettv.uniqueid
))
UNION
(SELECT
IF(serienaam = title, serienaam, CONCAT(serienaam, " - ", title)) as title,
DATE_FORMAT(DATE_ADD(broadcastdatetime, INTERVAL 1 HOUR), "%e-%m-%Y %H:%i") as date,
CONCAT("Zender: ", UPPER(station),"\n", "Titel: ", title, "\n", samenvattinglang) as beschrijving,
CONCAT("http://iptv.rtl.nl/nettv/",thumbnail) as thumbnail,
CONCAT("http://iptv.rtl.nl/nettv/",movie) as movie,
classname as extra,
DATE_ADD(broadcastdatetime, INTERVAL 1 HOUR) as broadcastdatetime,
"nettv" as tbl
FROM items_nettv)
) as t
WHERE
DATE(broadcastdatetime) = DATE(NOW()) - INTERVAL '.$_GET['daysback'].' DAY
ORDER BY broadcastdatetime DESC