so here's the file you need - name it filelist_xml.php, then it'll be a breeze to use it and tweak it for your mp3 player - i can share mine if you want to, but that's not so important.
-------------------------
usage (the simplest usage you'd need)
-------------------------
define which wcms page will have the mp3 files attached inside of this file. Then, from the file manager, import the mp3 files and insert each one of them as a separate file list content part (might work with all in the same, didn't test them). That's REALLY all.
----------------------------
filelist_xml.php
by Luca Malisan and Fulvio Romanin
-----------------------------
<?php
if (stristr($_SERVER['HTTP_ACCEPT'], "application/xhtml+xml")) {
header("Content-Type: application/xhtml+xml; charset=utf-8");
} else {
header("Content-Type: text/html; charset=utf-8");
}
require_once ("config/phpwcms/conf.inc.php");
require_once ("include/inc_lib/default.inc.php");
$aid = intval($_GET['aid']);
$FILE = array();
$xml = '';
$sql_cnt = "SELECT * FROM ".DB_PREPEND."phpwcms_articlecontent WHERE acontent_aid=".$aid." ".
"AND acontent_visible=1 AND acontent_trash=0 AND acontent_type=7 LIMIT 1";
if($cresult = mysql_query($sql_cnt, $db) or die("error while listing contents for this article")) {
if($crow = mysql_fetch_array($cresult)) {
if($crow["acontent_files"]) {
$file_tmp = '';
$file_id = explode(":", $crow["acontent_files"]);
$file_text = explode("\n", $crow["acontent_text"]);
if(is_array($file_id) && count($file_id)) {
$fx=0; $fxa="";
if(isset($fxb)) {
unset($fxb);
}
foreach($file_id as $key => $value) {
if($fx) {
$fxa .= " OR ";
}
$fxa .= "f_id=".intval($value);
$fxb[$key]["fid"] = intval($value);
$fxc[$key] = '';
$fx++;
}
$file_sql = "SELECT * FROM ".DB_PREPEND."phpwcms_file WHERE f_public=1 AND f_aktiv=1 AND f_kid=1 AND f_trash=0 AND (".$fxa.");";
if($file_result = mysql_query($file_sql, $db) or die ("error while retrieving file list file's info")) {
while($file_row = mysql_fetch_assoc($file_result)) {
$dl_filename = $file_row["f_hash"];
if($file_row["f_ext"]) $dl_filename .= ".".$file_row["f_ext"];
$FILE[] = PHPWCMS_ROOT.$phpwcms["file_path"].$dl_filename;
$xml .= "\t".'<SONG ';
$xml .= "\n\t\t".'info="'.utf8_encode($file_row["f_shortinfo"]).'" ';
$xml .= "\n\t\t".'filename="'.utf8_encode($file_row["f_name"]).'" ';
$xml .= "\n\t\t".'file="'.PHPWCMS_URL.substr($phpwcms["file_path"],1).$dl_filename.'"';
$xml .= "\n\t></SONG>\n";
}
mysql_free_result($file_result);
}
}
}
}
}
echo '<'.'?xml version="1.0" encoding="utf-8"?'.">\n";
echo "<archive>\n";
echo $xml;
echo '</archive>';
?>
