summaryrefslogtreecommitdiff
path: root/scripts/epgd-showdones
blob: 86cd7b4edfbab750c701c040bedaa49a696b8d95 (plain)
1
2
3
4
5
6
#!/bin/bash

export MYSQL_PWD=epg

mysql -u epg2vdr -Depg2vdr -e " \
  select from_unixtime(updsp, '%d.%m %H:%m') as upd, id, state as s, substr(title,1,35), shorttext, episodecompname, episodecomppartname, expression from timersdone where state != 'D';"