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

MYSQL_PWD=${MYSQL_PWD:-epg}
export MYSQL_PWD

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';"