Reply To: Limit smart playlists ?

#7914
riro
Participant

Well.. another script that I cron every night works…

SQLITE="sqlite3"
DATABASE="/opt/var/mt-daapd/songs3.db"
PLSLIMIT=$1
PLSNAME=$2

echo "# --- Auto generated" >$PLSNAME
echo "# Generated `date` " >>$PLSNAME
$SQLITE $DATABASE 'SELECT path FROM songs ORDER BY time_added DESC LIMIT '$PLSLIMIT';'>>$PLSNAME