Michael, Phil, JJ:
I acknowledge that your criticisms of my concern are valid and that I'm
probably the *only* user who sees the current genre handling as a
problem. I said as much to Andy a few years back when we discussed this
on this forum.
It's the arm-chair-musical-historian-and-archivist in me who's painted
me into this corner. I'm way too wedded to genre tags like a_Medieval,
b_Renaissance so that my library disk lay-out is sorted chronologically
too. Switching at this point would cause me too much cognitive
dissonance. But thanks for the suggestions.
Michael: I'm hesitant to file a bug report since I'm pretty sure that my
modifications bring back the original bug that Andy fixed in the first
place. But here's my diff: Note: Genre.pm.org is the latest git pull.
Genre.pm is my modified version.
Code:
--------------------
diff Genre.pm.org Genre.pm
33c33
< $class->utf8_columns(qw/name namesort/);
---
> $class->utf8_columns(qw/name namesort namesearch/);
42c42
< return sprintf('db:genre.name=%s',
URI::Escape::uri_escape_utf8($self->name));
---
> return sprintf('db:genre.namesearch=%s',
URI::Escape::uri_escape_utf8($self->namesearch));
70c70
< my $namesearch =
Slim::Utils::Text::ignoreCaseArticles($genreSub, 1);
---
> #my $namesearch =
Slim::Utils::Text::ignoreCaseArticles($genreSub, 1);
75,76c75,76
< my $sth = $dbh->prepare_cached( 'SELECT id FROM genres WHERE
name = ?' );
< $sth->execute( ucfirst($genreSub) );
---
> my $sth = $dbh->prepare_cached( 'SELECT id FROM genres WHERE
namesearch = ?' );
> $sth->execute($namesort);
87c87
< $sth->execute( $namesort, ucfirst($genreSub),
$namesearch );
---
> $sth->execute( $namesort, ucfirst($genreSub),
$namesort );
--------------------
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=102190
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
