Exemple #1
0
function playlists()
{
    $app = Reg::get('app');
    $pls = array();
    $pltrs = array();
    if ($app['user']::get('id')) {
        $pls = Model\Pl::find_all_by_userid($app['user']::get('id'), array('order' => 'pos'));
        $plids = array();
        foreach ($pls as $pl) {
            $plids[] = $pl->id;
        }
        if ($plids) {
            $pltracks = Model\PlTrack::find_all_by_plid($plids, array('order' => 'pos'));
            $pltrs = array();
            foreach ($pltracks as $pltrack) {
                $pltrs[$pltrack->plid][] = $pltrack;
            }
        }
    }
    return $app['view']->render(null, "part/playlist.phtml", array('pls' => $pls, 'pltrs' => $pltrs));
}
Exemple #2
0
			$found = false;
			foreach ( $res as $r ) {
				if ( !$found && $info['name'] == $r['title'] && $info['artist'] == $r['artist'] ) {
					$found = true;
					$f = $r;
				}
			}

			if ( !$found ) {
				$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/>";