So, jetzt habe ich endlich ne Lösung gefunden, ist zwar nicht die feinste Art und Weise - aber es geht!
Code:
#!/bin/bash
####
#
# die letzten 5 Alben
#
album1=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT album FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 4,1"`
album2=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT album FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 3,1"`
album3=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT album FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 2,1"`
album4=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT album FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 1,1"`
album5=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT album FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 0,1"`
####
#
# die letzten 5 Artist
#
artist1=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT artist FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 4,1"`
artist2=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT artist FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 3,1"`
artist3=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT artist FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 2,1"`
artist4=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT artist FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 1,1"`
artist5=`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT artist FROM musicmetadata GROUP BY album ORDER BY intid DESC LIMIT 0,1"`
###
#
# In Array speichern
#
album[4]=${album1:6}
artist[4]=${artist1:7}
album[3]=${album2:6}
artist[3]=${artist2:7}
album[2]=${album3:6}
artist[2]=${artist3:7}
album[1]=${album4:6}
artist[1]=${artist4:7}
album[0]=${album5:6}
artist[0]=${artist5:7}
###
#
# Songs speichern
#
songs1=(`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT intid FROM musicmetadata WHERE album='${album[0]}' AND artist='${artist[0]}' ORDER BY intid
DESC"`)
songs2=(`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT intid FROM musicmetadata WHERE album='${album[1]}' AND artist='${artist[1]}' ORDER BY intid
DESC"`)
songs3=(`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT intid FROM musicmetadata WHERE album='${album[2]}' AND artist='${artist[2]}' ORDER BY intid
DESC"`)
songs4=(`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT intid FROM musicmetadata WHERE album='${album[3]}' AND artist='${artist[3]}' ORDER BY intid
DESC"`)
songs5=(`mysql -umythtv -pmythtv -Dmythconverg -e "SELECT intid FROM musicmetadata WHERE album='${album[4]}' AND artist='${artist[4]}' ORDER BY intid
DESC"`)
dummy_var="x"
for var in ${songs1[*]}
do
if [ $dummy_var = "y" ]
then
songliste=`echo $songliste, $var`
fi
dummy_var="y"
done
dummy_var="x"
for var in ${songs2[*]}
do
if [ $dummy_var = "y" ]
then
songliste=`echo $songliste, $var`
fi
dummy_var="y"
done
dummy_var="x"
for var in ${songs3[*]}
do
if [ $dummy_var = "y" ]
then
songliste=`echo $songliste, $var`
fi
dummy_var="y"
done
dummy_var="x"
for var in ${songs4[*]}
do
if [ $dummy_var = "y" ]
then
songliste=`echo $songliste, $var`
fi
dummy_var="y"
done
dummy_var="x"
for var in ${songs5[*]}
do
if [ $dummy_var = "y" ]
then
songliste=`echo $songliste, $var`
fi
dummy_var="y"
done
songliste=${songliste:2}
echo `mysql -umythtv -pmythtv -Dmythconverg -e "UPDATE musicplaylist SET songlist = '' WHERE playlistid = 3"`
echo `mysql -umythtv -pmythtv -Dmythconverg -e "UPDATE musicplaylist SET songlist = '$songliste' WHERE playlistid = 3"`
Aber wenn jemand ne bessere Lösung weiß oder überhaupt etwas zu verbessern wüßte, dann soll er es sagen
Lesezeichen