Hi
First of all I'd like to say thank you for this excellent script.
One thing I was wondering though....
Is it possible to change or re-order the genres? For example, I'd like to take Rock and Alternative out of Pop and have them on their own. Also maybe add a new genre called Punk Rock.
Would I just change them in the database using phpMyAdmin?
Many thanks
Michael
Change Genres
- wbartels
- netjukebox developer
- Posts: 881
- Joined: Thu Nov 04, 2004 3:12 pm
- Location: Netherlands
- Contact:
Yes, you can change the genres with phpMyAdmin.
Here you see an example how the genre_id is related to the genre structure.
viewtopic.php?p=616#616
If I have the time, I will make a web interface to manipulate the genre structure.
But for now you have to do it with phpMyAdmin
Here you see an example how the genre_id is related to the genre structure.
viewtopic.php?p=616#616
If I have the time, I will make a web interface to manipulate the genre structure.
But for now you have to do it with phpMyAdmin
Thank you for your help.
One problem though that I can't seem to figure out though. I'd taken Alternative out from the Pop genre and created a new Alternative one using a new letter, following on from the others... j I think. Anyway, I changed one of my Artists To the new Alternative genre and now it shows up as Rock. lol
Is there another table in the database that will need updating to reflect this change?
Thanks again
Michael
One problem though that I can't seem to figure out though. I'd taken Alternative out from the Pop genre and created a new Alternative one using a new letter, following on from the others... j I think. Anyway, I changed one of my Artists To the new Alternative genre and now it shows up as Rock. lol
Is there another table in the database that will need updating to reflect this change?
Thanks again
Michael
- wbartels
- netjukebox developer
- Posts: 881
- Joined: Thu Nov 04, 2004 3:12 pm
- Location: Netherlands
- Contact:
StrangeMichael wrote:One problem though that I can't seem to figure out though. I'd taken Alternative out from the Pop genre and created a new Alternative one using a new letter, following on from the others... j I think. Anyway, I changed one of my Artists To the new Alternative genre and now it shows up as Rock. lol
You can go with the mouse over the genre you have set and see if the genre is set to the right genre_id (in your case j).
Code: Select all
browse.php?command=view1&genre_id=j
Table genre is the only table for the genre structure.Michael wrote:Is there another table in the database that will need updating to reflect this change?
In the table album there is a genre_id field witch is pointing to genre_id from the genre table.