### das script ###

#!/bin/bash

find /home/titan/glftpd/glftpd/site/REQUESTS/ -name \*.mp3 -print | while read file
do


output=`mp3info -p "%f %a %t %l %c %n %y %g %F %k %C %L %o %u %b %Q %S" "$file"`
fileName=`echo $output | awk '{print $1}'`
artistName=`echo $output | awk '{print $2}'`
rlsName=`echo $file | rev | awk -F/ '{print $2}' | rev`
titleName=`echo $output | awk '{print $3}'`
albumName=`echo $output | awk '{print $4}'`
commentName=`echo $output | awk '{print $5}'`
trackName=`echo $output | awk '{print $6}'`
yearName=`echo $output | awk '{print $7}'`
genreName=`echo $output | awk '{print $8}'`
filesizeName=`echo $output | awk '{print $9}'`
copyrightName=`echo $output | awk '{print $10}'`
layerName=`echo $output | awk '{print $11}'`
stereoName=`echo $output | awk '{print $12}'`
goodframesName=`echo $output | awk '{print $13}'`
badframesName=`echo $output | awk '{print $14}'`
frequencyName=`echo $output | awk '{print $15}'`
playtimeName=`echo $output | awk '{print $16}'`




#echo "INSERT INTO MP3INFO (rlsname,filename,artist) VALUES (\'"$rlsName"'\,\'"$fileName"\',\'"$artistName"\',\'"$titleName"\,\'"$albumName"\,\'"$commentName"\,\'"$trackName"\,\'"$yearName"\,\'"$genreName"\,\'"$filesizeName"\,\'"$copyrightName"\,\'"$layerName"\,\'"$stereoName"\,\'"$goodframesName"\,\'"$badframesName"\,\'"$frequencyName"\,\'"$playtimeName"\)" >> uschi.sql

echo 1. rls:		"$rlsName" 
echo 2. file:		"$fileName" 
echo 3. artist: 	"$artistName" 
echo 4. title: 	"$titleName"
echo 5. album: 	"$albumName"
echo 6. comment:	"$commentName"
echo 7. year:		"$trackName"
echo 8. genre:	"$genreName"
echo 9. filesize:	"$filesize"
echo 10. copyright:	"$copyrightName"
echo 11. layer:	"$layerName"
echo 12. stereo:	"$stereo"
echo 13. goodframes:	"$goodframesName"
echo 14. badframes:	"$badframesName"
echo 15. frequency:	"$frequencyName"
echo 16. playtime:	"$playtimeName"

done