Music Database [3.1]

[Cccddd]

Link to Mod

EDIT:  Latest version for RC2 here

This mod will add a comprehensive music database to your message board/website, that allows for storage and sorting by genre, artist, album, and song. Coupled with my file manager mod, you can upload artist photos, album covers, and mp3/various song file formats to go with your lyrics database. In fact it's designed so even if you don't have lyrics, you can still just have a place for people to download their favorite music!

And of course you can rate artists, albums, and songs!



A working version of this software can be found over at charlottezweb's site! This is probably the largest music database running on this mod right now!

http://www.psychopathicforums.com/forum/index.php?action=music



Changelog -

3.1) completely revamped admin page for song editing
3.1) fixed filemanager functionality
3.1) moved German language files to separate package to facilitate separate updates
3.1) removed old unused language file entries

3.0.3) cleaned up changelog. now only contains changes from 3.0+. see thread to find old changes
3.0.3) more eval error fixes. this time focused on file manager related eval errors. (Help from DIN1031)
3.0.3) re-added MusicAdmin.german.php. For some reason the updated file didn't get included in the last two releases?

3.0.1 to 3.0.2
* previous versions were generating lots of eval errors in the error log

3.0 to 3.0.1
* fixed template looking for musicadmin.gif when should look for music_admin.gif
* workaround for SMF 1.1 uses $txt['months'] instead of $months
* install_sql.php now runs upgrade_sql.php separate. helps locate issues
* upgrade_sql.php was trying to fill released table before creating table
* fixed problem where dates still weren't sorting right
* added Music.german.php and MusicAdmin.german.php language file (thanks to Norbert!)
* fixed pagination bug

v3.0 beta 5 to 3.0 (final)
* new theme!
* fixed bug where 1st artist name showed instead of "Various Artists" on multi-artist albums

v3.0 beta 4 to beta 5:
* fixed sort_xx%20.gif issue
* removed upgrade from 2.6 *code*. Now ONLY upgrades SQL
* removed old version checker. Was broken.
* fixed month bug

v3.0 beta 3 to beta 4:
* fixed problem where filemanager features wouldn't show
* added play button to song page
* song page now works even without lyrics so you can have just mp3 database
* moved all text except errors to language files
* finally added sql upgrading
* created a script that checks for old versions of mdb code from broken/partial uninstalls
* page title finally set. took way too long to do that

v3.0 beta 2 to beta 3:
* The mod now runs even if filemanager not installed
* enable/disable fm features in admin page
* set max lyrics character count in admin page
* a lot of security fixes in the admin page
* fixed catbg in admin page

version 2.5 to version 3.0 beta 2:
* added netflix-style star rating
* removed Rate It! column
* album page sorts dates by month AND year now
* renamed and reorganized all sql tables
* standardized array, form, and sql column names
* cleaned up all code
* replaced a lot of if statements with cases
* moved some repetitive code to functions
* added play button to song list
* added filemanager functionality and interoperability
* folder selection added to forum admin page
* photo link added to artist list
* songs are no longer links if no lyrics
* columns are stored in associative arrays now like they should have been in the first place
* column sorting done associatively now
* category links now images
* search bar moved above rest of template
* source code split into Music.php MusicAdmin.php and Subs-Music.php
* default maxItems set to 25
* page errors done via fatal_error() instead of die() now
* links to genre, artist, album, song now graphics

[mennou]

nice  but   i have  difficulty to  download it...
Package Manager - Install Actions
Install Actions for archive musicdb.3.0.tar.gz:
Installing this package will perform the following actions:  Type Action Description
1. Execute Code install_sql.php 
2. Execute Modification ./index.php Success
3. Execute Modification ./Sources/ManagePermissions.php Success
4. Execute Modification ./Sources/ModSettings.php Success
5. Execute Modification ./Themes/default/index.template.php Success
6. Execute Modification ./Themes/default/languages/ManagePermissions.english.php Success
7. Execute Modification ./Themes/default/languages/Errors.english.php Success
8. Execute Modification ./Themes/default/languages/ModSettings.english.php Success
9. Extract File ./Sources/Music.php 
10. Extract File ./Sources/MusicAdmin.php 
11. Extract File ./Sources/Subs-Music.php 
12. Extract File ./Themes/default/Music.template.php 
13. Extract File ./Themes/default/MusicAdmin.template.php 
14. Extract File ./Themes/default/languages/Music.english.php 
15. Extract File ./Themes/default/languages/MusicAdmin.english.php 
16. Extract File ./Themes/default/images/english/music.gif 
17. Extract File ./Themes/default/images/english/music_admin.gif 
18. Extract File ./Themes/default/images/english/music_albums.gif 
19. Extract File ./Themes/default/images/english/music_artists.gif 
20. Extract File ./Themes/default/images/english/music_genres.gif 
21. Extract File ./Themes/default/images/english/music_songs.gif 
22. Extract File ./Themes/default/images/english/music_header.gif 
23. Extract File ./Themes/default/images/english/music_header_admin.gif 
24. Extract File ./Themes/default/images/music_staroff.gif 
25. Extract File ./Themes/default/images/music_staron.gif 
26. Extract File ./Themes/default/images/music_play.gif 


FTP Information Required
Some of the files this package needs to modify are not writable. This needs to be changed by logging into FTP and chmoding the files. 
i've changed  it to 777  still not working...can u help??

[Elijah Bliss]

Cool!

[Cccddd]

mennou you need to have your Sources directory, and the files in it set to 777 (rwxrwxrwx), as well as the Themes/default directory and all sub directories. Oh and your root index.php file should be 777 too.

usually you can just set the whole damn thing to 777 and get away with it.

[SeaOfSin]

I seem to be getting an error myself

Unknown column 'released' in 'field list'
File: /home/user/public_html/forum/Packages/temp/install_sql.php
Line: 19

any ideas?

[mennou]

i will  try that thanks...

[Cccddd]

I seem to be getting an error myself

Unknown column 'released' in 'field list'
File: /home/user/public_html/forum/Packages/temp/install_sql.php
Line: 19

any ideas?

are you installing from a previous beta?

please include more information so i can figure out where you are getting these errors from. the straight up normal package is not broken, so you must be getting these errors from some old version trying to play with the new version.

[SeaOfSin]

I seem to be getting an error myself

Unknown column 'released' in 'field list'
File: /home/user/public_html/forum/Packages/temp/install_sql.php
Line: 19

any ideas?

are you installing from a previous beta?

please include more information so i can figure out where you are getting these errors from. the straight up normal package is not broken, so you must be getting these errors from some old version trying to play with the new version.

Hi Cheschire

I uninstalled version 2.6 and installed the version 3.0, I'll check to see if 2.6 uninstalled correctly then try 3.0 again!

[edchapman]

Is there anywhere to see the MOD in action?

[Norbert]

I want to install the Music Database on my forum about NEW order. But I have to do it manual, because my webserver runs in safe mode.
How can I put the sql-File into my database with phpMyAdmin.

[Norbert]

I have put the modification in the database with phpMyadmin. If I want to see the Songs, I get this error message:

Unknown column 'smf_music_songs.rating' in 'field list'
Datei: /home/www/web34/html/forum/Sources/Music.php
Zeile: 196

There is a Problem with install_sql.php: Default 0 instead of Default NULL

Solved! It works now fine for me. Thanks!

[JayBachatero]

Is there anywhere to see the MOD in action?

im going to set up a new smf test board up tonight to have a clean install of both mods so that you can take a look.

[Cccddd]

thanks man. the biggest database i have seen running is on charlottezweb's site, but i think he is still running 2.5 or 2.6. *looks* nope its not even running it right now. he probably took it down and is waiting for 3.0.

[Norbert]

Here is a demo.

There is problem with the sort order for Album Releases.

[Cccddd]

woo. problems!

yeah wtf why is it only sorting the months? very odd. i tested that thing out but i guess i missed something obvious. either that or i changed something after i tested. stupid me :\

[Cccddd]

Hey would you mind posting the language file you are using? I would love to include more languages with this thing.

[Norbert]

Here is my Music.german.php

<?php
// Version: 3.0; Music

$txt['music'] = array(
   'colalbum' => 'Album',
   'colartist' => 'K&uuml;nstler',
   'colgenre' => 'Genre',
   'colrating' => 'Bewertung',
   'colreleasedate' => 'ver&ouml;ffentlicht',
   'colsong' => 'Song',
   'maxitems' => 'Max. Anzahl pro Seite:',
   'nomatch' => 'Keine Suchergebnisse gefunden!',
   'numalbums' => ' Alben',
   'numartists' => ' K&uuml;nstler',
   'numphotos' => ' Fotos',
   'numsongs' => ' Tracks',
   'pages' => 'Seiten ',
   'search' => 'Suchen',
   'searchartists' => 'K&uuml;nstler',
   'searchbutton' => 'Los',
   'searchalbums' => 'Alben',
   'searchlyrics' => 'Songtexte',
   'searchsongs' => 'Songs',
   'songinfo' => 'Song-Info',
   'songinfoartist' => 'K&uuml;nstler',
   'songinfoalbum' => 'Album',
   'songinfolyrics' => 'Songtext',
   'songinfolength' => 'L&auml;nge',
   'songmp3' => 'Spielen',
   'title' => ' Musik Datenbank',
   'variousartists' => 'Verschiedene K&uuml;nstler',
);
?>

I'm going to translate MusicAdmin.german.php till end of the week.

[charlottezweb]

I seem to be getting an error myself

Unknown column 'released' in 'field list'
File: /home/user/public_html/forum/Packages/temp/install_sql.php
Line: 19

any ideas?

I'm also getting this message.  Though I was running 2.4 before uninstalling and trying to move to 3.0 today.

-Jason

[DoW Kid Rock]

I like the mod allot, but is there any way to be able to let members add to the database?  or have each member have their own music list.  or at least attach a members name to the song, artist or album title

[Norbert]

I like the mod allot, but is there any way to be able to let members add to the database?  or have each member have their own music list.  or at least attach a members name to the song, artist or album title

Yes, you can do managing the permissions.