$userId = $app['user']::get('id');
$pl = \Model\Pl::find_by_userid_and_id($userId, $request->get('playlistId'));
if ($pl) {
$vkid = $request->get('vkId');
$vkTrack = $app['openplayer']->audioGetById($vkid);
$vkTrack = $vkTrack->audio;
$plTrack = \Model\PlTrack::find_by_plid_and_vkid($pl->id, $vkid);
if (!$plTrack) {
$plTrack = new \Model\PlTrack();
$plTrack->plid = $pl->id;
$plTrack->artist = $vkTrack->artist;
$plTrack->name = $vkTrack->title;
$plTrack->vkid = $vkid;
$plTrack->lyricsid = $vkTrack->lyrics_id;
$plTrack->duration = $vkTrack->duration;
$plTrack->save();
}
}
return new Response(json_encode(array('status' => true)));
});
$app->post('/user/pltrackremove', function (Request $request) use($app) {
$userId = $app['user']::get('id');
$pl = \Model\Pl::find_by_userid_and_id($userId, $request->get('playlistId'));
if ($pl) {
$vkid = $request->get('vkId');
$plTrack = \Model\PlTrack::find_by_plid_and_vkid($pl->id, $vkid);
if ($plTrack) {
$plTrack->delete();
}
}
return new Response(json_encode(array('status' => true)));
$f = $res[0];
}
if ( $f ) {
$vkid = $f['owner_id'].'_'.$f['aid'];
$pltrack = new Model\PlTrack;
$pltrack->plid = $one->plid;
$pltrack->artist = $f['artist'];
$pltrack->name = $f['title'];
$pltrack->vkid = $vkid;
$pltrack->lyricsid = $f['lyrics_id'];
$pltrack->duration = $f['duration'];
$pltrack->pos = 666;
$pltrack->save();
$sql = "DELETE FROM `pl_song` WHERE id = {$one->id}";
$res = $app['pdo']->query( $sql );
$res->execute();
} else {
echo "<br/><br/>Track {$q} not found<br/><br/>";
}
}
} else {
// $sql = 'DROP TABLE `pl_song`';
// $res = $app['pdo']->query( $sql );
// $res->execute();
// $sql = 'TRUNCATE TABLE `cache`';
// $res = $app['pdo']->query( $sql );
