[mythtv-users] updated mythlink.sh

[Edward Rudd]

that's an easy one to fix..
in the script where the SQL query is add an " ORDER BY starttime" so it
looks like this.
mysql -uroot  mythconverg -B --exec "select
chanid,starttime,endtime,title,subtitle from recorded order by
starttime;" >/tmp/mythlink.$$

On Sat, 2003-10-25 at 21:39, Joel Melohn wrote:
> One thing that I have encounterd with mythlink.sh is that if you have a set
> of episodes of the same program that do not have a subtitle, you end up with
> a subdirectory containing 1.nuv, 2.nuv, 3.nuv, etc. However, the files are
> not numbered in chronological order. You could sort the directory by
> creation date, but it would be helpful if the numeric names were in
> chronological order.
> 
> Is there a simple way to enhance the script to do this.
> 
> Again, thanks for all you work on this script. It is very useful.
> 
> Joel
> 
> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org
> [mailto:mythtv-users-bounces at mythtv.org]On Behalf Of Joel Melohn
> Sent: Saturday, October 25, 2003 9:31 PM
> To: Discussion about mythtv
> Subject: RE: [mythtv-users] updated mythlink.sh
> 
> 
> Edward and none,
> 
> Thanks for your work on mythlink.sh. It makes viewing recorded programs on
> Windows XP much more usable.
> 
> I make a minor enhancement to the mythlink.sh script that replaces the ";"
> with " -" which makes the subtitles more readable. For example, from one of
> my wife's recordings, the subtitle:
> 
> Silver Beads; Ceramist; Stamping Products
> 
> without this patch becomes:
> 
> Silver_Beads__Ceramist__Stamping_Products
> 
> with the new patch, it becomes:
> 
> Silver_Beads_-_Ceramist_-_Stamping_Products
> 
> which I think is more readable.
> 
> 
> The patch adds the single line:
> 
> $nfn =~ s/;/ -/g;
> 
> as follows:
> 
> @@ -26,6 +26,7 @@
>                  my $nfn = "${subtitle}";
>                  $nfn =~ s/ /_/g;
>                  $nfn =~ s/&/+/g;
> +                $nfn =~ s/;/ -/g;
>                  $nfn =~ s/[^+0-9a-zA-Z_-]+/_/g;
>  		my $nfn_orig = $nfn;
>  		my $file_conflict = 1;
> 
> 
> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org
> [mailto:mythtv-users-bounces at mythtv.org]On Behalf Of Edward Rudd
> Sent: Friday, October 24, 2003 11:39 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] updated mythlink.sh
> 
> 
> OK here is an updated version of the mythlink.sh with your patch, and
> various fixes to resolve name collisions. and "/"s in show titles..
> Enjoy..
> 
> On Fri, 2003-10-24 at 21:56, None Spencer wrote:
> > Hi all,
> >
> >   Here is a small patch for the mythlink.sh.  Instead of making all the
> > links in one directory it will create a directory for each Show title with
> > the actual link name being the subtitle.  So if you had this before:
> >
> > /path/you/use/09052100_Stargate_SG-1_Fallen
> >
> > you will end up with this:
> >
> > /path/you/use/Stargate SG-1/Fallen.nuv
> >
> > This makes it easier for my wife to find what she is looking for when she
> is
> > using windows and takes
> > care of the file extensions.
> >
> > Enjoy.
> >
> > _________________________________________________________________
> > Concerned that messages may bounce because your Hotmail account has
> exceeded
> > its 2MB storage limit? Get Hotmail Extra Storage!
> > http://join.msn.com/?PAGE=features/es
> >
> > ______________________________________________________________________
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> --
> Edward Rudd <eddie at omegaware.com>
> Home Page <http://urkle.drip.ws/>
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-- 
Edward Rudd <eddie at omegaware.com>
Home Page <http://urkle.drip.ws/>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20031025/8244a55d/attachment.pgp