ChrisW
|
| posted on 25/5/07 at 07:46 PM |
|
|
Shameless plug: Check this out... latest project!
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
|
|
|
|
|
Catpuss
|
| posted on 25/5/07 at 08:31 PM |
|
|
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
|
|
|
Fozzie
|
| posted on 25/5/07 at 08:36 PM |
|
|
Excellent 
Could have done with this last night, whilst having an 'insomniac' episode! 
Fozzie 
'Racing is Life!...anything before or after is just waiting'....Steve McQueen
|
|
|
ChrisW
|
| posted on 25/5/07 at 08:38 PM |
|
|
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
Ooops! Luckily, not my code... will tell the web developer though!
Thanks for pointing it out.
Chris
|
|
|
Fozzie
|
| posted on 25/5/07 at 08:44 PM |
|
|
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
'Racing is Life!...anything before or after is just waiting'....Steve McQueen
|
|
|
Benzine
|
| posted on 25/5/07 at 08:47 PM |
|
|
Very nice. No more missing neighbours 
|
|
|
MikeR
|
| posted on 25/5/07 at 10:03 PM |
|
|
Yaaah - i missed holly oaks tonight
|
|
|
Paradoxia0
|
| posted on 25/5/07 at 10:19 PM |
|
|
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
There is no replacement for displacement...
|
|
|
Paradoxia0
|
| posted on 25/5/07 at 10:22 PM |
|
|
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 )
There is no replacement for displacement...
|
|
|
RazMan
|
| posted on 26/5/07 at 08:48 AM |
|
|
I think you're onto a winner there Chris!
Cheers,
Raz
When thinking outside the box doesn't work any more, it's time to build a new box
|
|
|
Marlon
|
| posted on 26/5/07 at 09:59 AM |
|
|
That's fantastic!!
I love it!
john.
Band Anyone?
Linky to SWMBO 's band
Linky to Brother in laws band
MKoc 1081
|
|
|
Keith Weiland
|
| posted on 26/5/07 at 10:00 AM |
|
|
Looks good but you might want to get your lawyers ready. I can see cease and desist orders coming your way.
|
|
|
ChrisW
|
| posted on 26/5/07 at 11:27 AM |
|
|
quote:
Originally posted by RazMan
I think you're onto a winner there Chris!
There are lots of ways we could make the TV more 'watchable', but at the end of the day the site is funded by advertising (or will be - we
need to hit certain user targets before we can get any ads that are worthwhile). This means we have to ensure that people see the adverts and doing
fullscreen, floatable windows, etc would hide the ads meaning far less income.
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.
I'm expecting that to be the case too. Luckily, out of the team of three that are behind the project, we have one techy (me!), one artisitic
guy who does the website side of things, and a solicitor who will deal with the legal fallout. According to him there is a loophole we can use, which
is where the whole project started from. I guess time will tell though!
Chris
|
|
|
Fozzie
|
| posted on 27/5/07 at 05:19 PM |
|
|
Have now managed to sign up!
Thats one bug sorted then!
Great choice of programmes......
ATB Fozzie
'Racing is Life!...anything before or after is just waiting'....Steve McQueen
|
|
|
ChrisW
|
| posted on 27/5/07 at 05:35 PM |
|
|
Just added a load more to the recording schedule, so will be even more choice in 24 hours or so time.
Chris
|
|
|
.jpg)
