wael
wael
Offline
0
Hi
It's not a problem in the muscol but I just need a little advice
I am creating a new flash app on my website to play a song that jwplayer plays but I add a recording feature to make my users record their covers on an instrumental music.
I need to query the current song "filename" or song path from database by using php file then sending the url of the song as a new variable to my new flash app.
The problem is I don't know how you made jwplayer get the songs "filename", "url" or "path" from database I notice in file com_muscol/views/song/view.html.php this line

$plugins = JPluginHelper::getPlugin('muscolplayers');
$plugin = $plugins[0];
// we use only one player, the first in the plugin item list
$plugin_ok = JPluginHelper::importPlugin('muscolplayers',$plugin->name);

if( ($song->filename != "" || $song->video != "") && $plugin_ok){
$player = plgMuscolplayers::renderPlayer($song, false, array("force_show_player" => true));



But I still don't know how to make my flash app know the current song filename form database like jwplaer dose.

Is there a way to know the current song ID so that I can use "select filename from muscol_songs where id = …" on the database query ?

Also despite that there is xml for albums like this one http://www.startsing.com/index.php/karaoke/p/the-pussycat-dolls/pcd?format=feed&type=xspf

I can't find it for the current song page, is it possible to know the current song "filename" "URL"" Path" from xml instead of query database if there is no way to know the current song filename from database?
Responses (4)
  • Accepted Answer

    wael
    wael
    Offline
    Sunday, November 06 2011, 01:52 AM - #Permalink
    0
    for example if user is currently on this page

    http://localhost/startlocal/index.php/u/45-usher/57-confessions/171-burn
    i need my app to query:
    SELECT filename from #__muscol_songs WHERE id = 171

    if user on
    http://localhost/startlocal/index.php/u/45-usher/57-confessions/89-caught-up

    i need my app to query:

    SELECT filename from #__muscol_songs WHERE id = 89

    any idea how to do that?
    The reply is currently minimized Show
  • Accepted Answer

    wael
    wael
    Offline
    Monday, October 24 2011, 09:11 PM - #Permalink
    0
    yes i know but i need the id to vary from one song to another. for example if i make it SELECT filename from #__muscol_songs WHERE id = 16 my application will retrieve only the filename of song 16 i want it to retrieve the song of the current song page which means if the user on song id 16 it retrieve song 16 if the song id is 17 it retrieve file name for song 17 and son on.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, October 24 2011, 09:29 AM - #Permalink
    0
    retrieve the filename:

    SELECT filename from #__muscol_songs WHERE id = XXX
    The reply is currently minimized Show
  • Accepted Answer

    wael
    wael
    Offline
    Sunday, October 23 2011, 11:59 PM - #Permalink
    0
    i guess you are using flashvar, am i right?
    The reply is currently minimized Show
Your Reply