function getNamePlsByID($id_user, $name)
{
$sql = "select id from user_playlist where id_user = '******' and name = '{$name}'";
$qr = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($qr) > 0) {
$res = mysql_fetch_assoc($qr);
$id = $res["id"];
} else {
$id = -1;
}
return $id;
}
// Добавляем каталог в базу
if ($_POST["action"] == "add_folder") {
$path = $_POST["path"];
if (addFolder($path)) {
echo "true";
} else {
echo "false";
}
}
if ($_POST["action"] == "get_count") {
$id_user = $_POST["id_user"];
$id_track = $_POST["id_track"];
$sql = "select my.count myCount,allUsers.count allCount\r\n\t\t\tfrom\r\n\t\t\t(select count from counts where id_user = '******' and id_track = '{$id_track}') my,\r\n\t\t\t(select sum(count) count from counts where id_track = '{$id_track}') allUsers";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res);
// if(count($row)>0)
// $myCount = $row["myCount"];
// $allCount = $row["allCount"];
// echo "get_count";
// Displaying the form to edit a folder language info
case "modtext":
$folderid = isset($_GET['folderid']) ? intval($_GET['folderid']) : 0;
$languageid = isset($_GET['languageid']) ? $_GET['languageid'] : 'new';
xoops_cp_header();
editfolder_text(true, $folderid, $languageid);
break;
// Adding or editing a folder in the db
// Adding or editing a folder in the db
case "addfolder":
addFolder(false);
break;
// Adding or editing a folder language info in the db
// Adding or editing a folder language info in the db
case "addfolder_text":
addFolder(true);
break;
// deleting a folder
// deleting a folder
case "del":
global $smartmedia_folder_handler, $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB, $_GET;
$module_id = $xoopsModule->getVar('mid');
$gperm_handler =& xoops_gethandler('groupperm');
$folderid = isset($_POST['folderid']) ? intval($_POST['folderid']) : 0;
$folderid = isset($_GET['folderid']) ? intval($_GET['folderid']) : $folderid;
$categoryid = isset($_POST['categoryid']) ? intval($_POST['categoryid']) : 0;
$categoryid = isset($_GET['categoryid']) ? intval($_GET['categoryid']) : $categoryid;
$folderObj = $smartmedia_folder_handler->get($folderid);
// Check to see if this item has children
if ($folderObj->hasChild()) {
redirect_header("folder.php", 3, _AM_SMEDIA_FOLDER_CANNOT_DELETE_HAS_CHILD);
function controlFile($id)
{
$app = Slim\Slim::getInstance();
$app->contentType('application/json');
$server = $id[0];
$path = implode("/", array_slice($id, 1));
if (!$path) {
$path = "/";
} else {
$path = "/" . $path;
}
$id = implode("/", $id);
$file = getOption('root') . '/' . $id;
$request = $app->request();
$control = $request->getBody();
$response = $app->response();
$result = "error";
if (is_file($file)) {
switch ($control["command"]) {
case "play":
$result = play($file);
break;
case "add":
$result = addFile($file);
break;
case "remove":
$result = removeFile($file);
break;
default:
$result = "illegal command";
$response->status(400);
break;
}
} else {
if (is_dir($file)) {
switch ($control["command"]) {
case "play":
$result = playFolder($file);
break;
case "add":
$result = addFolder($file);
break;
case "remove":
$result = removeFolder($file);
break;
case "search":
return search($server, "/_search/" . $control["value"]);
default:
$result = "illegal command";
$response->status(400);
break;
}
} else {
$response->status(404);
}
}
$body = array();
$body['command'] = $control["command"];
$body['result'] = $result;
echo json_encode($body);
}
