FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › General Discussion › Inteligent playlists › Reply To: Inteligent playlists
01/12/2006 at 1:28 PM
#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.