Webinterface for Radiodj database

[Aeolus]

Hey Guys,

I'm currently working on a webinterface that talks directly with the mysql database of Radiodj. I'm doing this because it makes my life a lot easier maintaining the songsdatabase. At this point it can only show a list of songs in the database, edit the artist/title/album/subcategory, delete songs and disable songs. New functionality can (and will) be added in the future. My main question is, are other people interested in this? Maybe people who want to help test it or whatever? If there's a lot of interest for it, it can be released for download. Let me know your thoughts! See the attached screenshots for an impression to what it looks like.


[attachment deleted by admin]

[DJ Garybaldy]

Looks great.... Always good to see people having a stab at various web interfaces for RadioDJ. 

[plauri]

I would be very interested if you could add the intro's and the lenght's songs. I will appreciate if all this could be easily printed

[Aeolus]

Well, that duration one was easy... but for the intro one i have to figure out how to grab it from the database and put it on the page.

In the mean time: if there are php programmers here who know how to grab &sta=0.0422902494331066&int=20.6312556689342&xta=229.122630385488&end=232.304784580499&fin=0&fou=3.18215419501135 from the database, and just grab the value of int=20.6312556689342, please let me know. In the mean time i will be searching for it myself

[attachment deleted by admin]

[Valdis]

Well, that duration one was easy... but for the intro one i have to figure out how to grab it from the database and put it on the page.

In the mean time: if there are php programmers here who know how to grab &sta=0.0422902494331066&int=20.6312556689342&xta=229.122630385488&end=232.304784580499&fin=0&fou=3.18215419501135 from the database, and just grab the value of int=20.6312556689342, please let me know. In the mean time i will be searching for it myself

That string can be parsed to get array of parameters using parse_str function. Actual intro duration should be calculated by subtracting sta (start cue) from int (intro cue).
Representation in mm:ss may be achieved using gmdate function.

Code Select Expand


<?php
$cue_points_string = "&sta=0.0422902494331066&int=20.6312556689342&xta=229.122630385488&end=232.304784580499&fin=0&fou=3.18215419501135";
$cue_points_arr = array();
parse_str($cue_points_string, $cue_points_arr);

$actual_intro = isset($cue_points_arr['int']) && isset($cue_points_arr['sta']) ? $cue_points_arr['int']-$cue_points_arr['sta'] : 0;

$intro_display_string = gmdate('i:s', round($actual_intro));
echo $intro_display_string;
?>


[marcbeinder]

I'm interested in this! I'll help test it if I can.

[Aeolus]

@Valdis: thanks! i'll try this soon!

@marcbeinder: cool, i'll get in contact with you soon.

[ThP]

I'm interested.

Can you provide a link for download (alpha, beta ... version).

You can send private message.

Thanks.

[igherardia]

  if i can help in the code!!!

ignacio.gherardi@gmail.com

[marcbeinder]

When you're ready just email me! mbeinder@ruolradio.com

[Aeolus]

Alright, in the couple of days i have some days off, so i'll be working on it a bit more, and hopefully after the weekend i can put something up on github or something.

[Echers]

I would love to become a tester of this!
This would help maintaining and editing my library directly from my own PC, instead of having to go to the actual RDJ machine to edit this.

If I may, please include me as a tester!

[marcbeinder]

What's the latest development on this?

[GSE]

Adding intros would be total bliss for me. Having to constantly listen to tracks, write down a list of intros and then remote into my server and take blind shots via a slow connection is a killer personally for me.

Also adding a filename for the album art would be pretty nice too.. I store all of my album art in a public directory on the same server so that RDJ can push out file names and allow my website to do the joining part.

[Aeolus]

Hey guys,

It's been a while, i'm sorry for that. Some other important stuff got between it. I put it online on github: https://github.com/RaymondTebru/rda

1 important thing: the songlist does not have pagination. If you have a very large database of songs, you can get into trouble using this. All usage is on your own risk.