Reply To: Inteligent playlists

#7574
fizze
Participant

well, just use the select frmo the script, and in line 2 in the script use the variables for the log-table.

be careful with the create statement though. indices, and keys etc.

the primary key should be path & date/time. You should also use indices for the path and date/time, otherwise its gonna be very slow.

Id also setup a job that eliminates date from that log DB which is older than, say, a few weeks.