www.tvcatchup.com
Chris
Little project I have been involved in that has just launched. Most of the backend code (the bit that does the recording off-air and streaming) is by
my own hand...
www.tvcatchup.com
Chris
Query by channel then programmes beinging with P gives:
Query:
SELECT SQL_CALC_FOUND_ROWS s.`id`, s.`name`, s.`description`, c.`name` as `channel`, g.`name` as `genre`, (SELECT COUNT(id) FROM `tvc_episodes` as `e`
WHERE e.`show_id` = s.`id` GROUP BY e.`show_id` ORDER BY e.`show_id`) as `episodes` FROM (`tvc_shows` as `s` LEFT JOIN `tvc_channels` as `c` ON
(s.`channel` = c.`id`)) LEFT JOIN `tvc_genres` as `g` ON (s.`genre` = g.`id`) WHERE `status` = '0' AND `name` LIKE 'p%' ORDER BY
s.`name` ASC LIMIT 0, 10
SQL Error:
1052(Column 'name' in where clause is ambiguous)
Session Closed
Excellent 
Could have done with this last night, whilst having an 'insomniac' episode! 
Fozzie 
quote:
Originally posted by Catpuss
Query by channel then programmes beinging with P gives:
Query:
SELECT SQL_CALC_FOUND_ROWS s.`id`, s.`name`, s.`description`, c.`name` as `channel`, g.`name` as `genre`, (SELECT COUNT(id) FROM `tvc_episodes` as `e` WHERE e.`show_id` = s.`id` GROUP BY e.`show_id` ORDER BY e.`show_id`) as `episodes` FROM (`tvc_shows` as `s` LEFT JOIN `tvc_channels` as `c` ON (s.`channel` = c.`id`)) LEFT JOIN `tvc_genres` as `g` ON (s.`genre` = g.`id`) WHERE `status` = '0' AND `name` LIKE 'p%' ORDER BY s.`name` ASC LIMIT 0, 10
SQL Error:
1052(Column 'name' in where clause is ambiguous)
Session Closed
Sadly cannot sign up either 
the country code and the gender (
) drop down boxes don't work, so it wont let you sign up...... reported that bug through the site though.
It is watchable if you chose something from the left hand menu though.
Fozzie
Very nice. No more missing neighbours 
Yaaah - i missed holly oaks tonight
Very nice!
Makes that Sky+ subscription seen a waste of money now
Same problem as Fozzie thought, cannot signup due to nothing in country and gender dropdown.
Mark
A suggestion:
Play the video in a separate window that can be floated above other windows?
Keep the TV ontop of what you are doing?
Mark
(who annoys the developers at work with lots of silly suggestions )
I think you're onto a winner there Chris!
That's fantastic!!
I love it!
john.
Looks good but you might want to get your lawyers ready. I can see cease and desist orders coming your way.
quote:
Originally posted by RazMan
I think you're onto a winner there Chris!
quote:
Originally posted by Keith Weiland
Looks good but you might want to get your lawyers ready. I can see cease and desist orders coming your way.
Have now managed to sign up!
Thats one bug sorted then!
Great choice of programmes......
ATB Fozzie
Just added a load more to the recording schedule, so will be even more choice in 24 hours or so time.
Chris