Adding More Genres

Locked
Shizzle
User
Posts: 65
Joined: Sat May 28, 2005 9:00 am
Location: Gresham, OR USA
Contact:

Adding More Genres

Post by Shizzle »

well after finally getting close to my media filestructure and renaming all the media and making sure that the albums have the correct id3 tags ( :x ) I noticed that the genre list is just a sample...

well I took the list that is in WMP and put it into the sql file but since each genre is in a specific letter listing I thought that since I have a total of like 127 different genres that I could use a number instead... for instance

I know this isn't correct but I don't know what the line is exactly off the top of my head:

Code: Select all

INSERT INTO genre ('1' , 'Alternative');
then just continuing the list but changing the number and increasing it by 1
but it doesn't work. So my question is do the genre have to be ordered using the alpha system instead of numbers and if so if there a easier way of adding 100+ genres?

Anyone have any ideas? Or atleast steer me in the right direction

any and all help is greatly appreciated.... :lol:
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by wbartels »

The genre uses letters because of the hierarchical structure.
Each character represents a directory level.
Here's an example:

Code: Select all

a    [+]-- Pop
aa    |--- Alternative 
ab    |---[+] Rock
aba        |-- Hard rock
abb        |-- Symphonic rock
The caracters doesn't give the alfabetical order.
But get sorted by the genre description.
This will give the same sorting order:

Code: Select all

a    [+]-- Pop
ab    |--- Alternative 
aa    |---[+] Rock
aab        |-- Hard rock
aaa        |-- Symphonic rock
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Re: Adding More Genres

Post by wbartels »

Genre structure can be edit by the webinterface since netjukebox 5.14.
Locked