Habs selber hinbekommen:
Code:
#!/bin/bash
date=$(date +%Y%M%d%H%m%S)
recordings=$(mysql -u mythtv -pxxx -D mythconverg --execute="select starttime from recordmatch" | sed 's/\-//g' | sed 's/\://g' | sed 's/\ //g' | sort)
for i in $recordings; do
if [ "$i" -gt "$date" ]; then
nextrecording="$i"
break
fi
done
jahr=${nextrecording%??????????}
monat=${nextrecording%????????}
monat=${monat#????}
tag=${nextrecording%??????}
tag=${tag#??????}
stunde=${nextrecording%????}
stunde=${stunde#????????}
minute=${nextrecording%??}
minute=${minute#??????????}
nextrecording="${jahr}-${monat}-${tag} ${stunde}:${minute}"
channelid=$(mysql -u mythtv -pxxx -D mythconverg --execute="select * from recordmatch" | grep "$nextrecording" | cut -f2)
channel=$(mysql -u mythtv -pxxx -D mythconverg --execute="select chanid,callsign from channel" | grep $channelid | cut -f2)
dsiggi
Lesezeichen