OLDIFS=$IFS
IFS=$'\n'
databasedump="/Users/joel/Documents/database.txt"
echo "*********Dumping Database to $databasedump file"
sqlite3 /Users/joel/Library/Application\ Support/DVDpedia/Database.pediadata '.dump ZENTRY' > "$databasedump"
sleep 1
echo "************Changing to Working Directory"
cd "/Volumes/Mac Pro Storage/4-Tagging"

for SOURCE in $(find * -maxdepth 0 -print) ; do
   echo "Tagging $SOURCE"
   sleep 1

filename=$(basename "$SOURCE")
	echo "Filename: $filename"
	echo "$filename" > "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
directory=$(dirname "$SOURCE")
echo "$directory"
parentdirectory=$(dirname "$directory")
find "$directory" -type f -name ".*" -exec rm {} \;
filename=$((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" - "/";"/g)
	echo "$filename" > "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
title=$((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 1 ) | sed s/"_"/":"/g ) | sed s/" #00"//g )
	echo "Movie Title: $title"
	echo "Movie Title: $title" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
episodenum=$((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/\#/\;#/g ) | cut -d \; -f 2 ) | cut -c 1 )
	if [ "$episodenum" = "#" ] ;
		then

			episodenum=$((((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 1 ) | sed s/"_"/":"/g ) | cut -d \# -f 2 ) | cut -d \; -f 1 ) | sed s/"-"//g )
			echo "Episode Number: $episodenum"
			echo "Episode Number: $episodenum" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
	else
			episodenum=""
	fi
artist=$(((((grep "Movie Title:" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" #"/";#"/g ) | sed s/"_"/":"/g ) | cut -c 14- ) | cut -d \; -f 1 )
	echo "Artist/AlbumArtist: $artist"
	echo "Artist/AlbumArtist: $artist" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" 
artistorder=$((((grep "Movie Title:" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" #"/";#"/g ) | cut -c 14- ) | cut -d \; -f 1 )
	echo "Artist Sort Order: $artistorder"
	echo "Artist Sort Order: $artistorder" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
album=$((((((grep "Movie Title:" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" #"/";#"/g ) | cut -c 14- ) | cut -d \; -f 2 ) | sed s/"_"/":"/g ) | cut -c 1-5 )
	if [ "$album" = "#00: " ] ;
		then	
			album=$((((((grep "Movie Title:" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" #"/";#"/g ) | cut -c 14- ) | cut -d \; -f 2 ) | sed s/"_"/":"/g ) | cut -c 6- )
		else
			album=$(((((grep "Movie Title:" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" #"/";#"/g ) | cut -c 14- ) | cut -d \; -f 2 ) | sed s/"_"/":"/g )
	fi
albumorder=$((((((grep "Movie Title:" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" #"/";#"/g ) | cut -c 14- ) | cut -d \; -f 2 ) | sed s/"_"/":"/g ) | cut -c 1-5 )
	if [ "$albumorder" = "#00: " ] ;
		then	
			albumorder=$((((((grep "Movie Title:" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" #"/";#"/g ) | cut -c 14- ) | cut -d \; -f 2 ) | sed s/"_"/":"/g ) | cut -c 6- )
		else
			albumorder=$(((((grep "Movie Title:" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" #"/";#"/g ) | cut -c 14- ) | cut -d \; -f 2 ) | sed s/"_"/":"/g )
	fi
year=$((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 2 )
	if [ "$year" = "0000" ] ;
		then
		year=""
	else
		year="$year"
	fi
	echo "Year: $year"
	echo "Year: $year" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
rating=$((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 3 )
	echo "Movie Rating: $rating"
	echo "Movie Rating: $rating" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
comment=$((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 4 ) | sed s/".m4v"//g ) | sed s/".mp4"//g )
stik="Short Film"
tvseason=""
	if [ "$comment" = "TVDVD" ] ;
		then
			stik="TV Show"
			tvseason=$(((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 1 ) | sed s/"_"/":"/g ) | cut -d \# -f 2 ) | cut -c 1 )
			tvseason="$tvseason"
			echo "TV Season Number: $tvseason"
			title=$(((((grep "Movie Title:" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | sed s/" #"/";#"/g ) | cut -c 14- ) | cut -d \; -f 2 ) | sed s/"_"/":"/g )
			echo "New Title: $title"
	fi
	if [ "$comment" = "TVDVD" ] ;
		then
			album="$artist, Season $tvseason"
			albumorder="$artist, Season $tvseason"
	fi
	echo "Album Order: $album"
	echo "Album Order: $album" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
	echo "Album Sort Order: $albumorder"
	echo "Album Sort Order: $albumorder" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"

	if [ "$comment" = "MVDVD" ] ;
		then
			stik="Music Video"
	fi
			echo "Media Kind: $stik"			
			echo "Media Kind: $stik" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"

	if [ "$comment" = "Files" ] ;
		then
			comment="Converted from a File"
			echo "Comments: $comment"
			echo "Comments: $comment" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
	else
			comment="Ripped From DVD"
			echo "Comments: $comment"
			echo "Comments: $comment" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
fi
grouping=$((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 5 ) | sed s/".m4v"//g ) | sed s/".mp4"//g ) 
	if [ "$grouping" = "iTouch" ] ;
		then
			grouping="iPod Touch"	
	fi
	if [ "$grouping" = "HDAppleTV" ] ;
		then
		grouping="High Def AppleTV"
	fi
	if [ "$grouping" = "SDAppleTV" ] ;
		then
		grouping="Standard Def AppleTV"
	fi
	if [ "$grouping" = "AppleTV" ] ;
		then
		grouping="Standard Def AppleTV"
	fi
	echo "Grouping: $grouping"
	echo "Grouping: $grouping" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
genre=$((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 6 ) | sed s/".m4v"//g ) | sed s/".mp4"//g )
	echo "Genre: $genre"
	echo "Genre: $genre" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
advisory=$(((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 6 ) | sed s/".m4v"//g ) | sed s/".mp4"//g ) | cut -c 1-5 )
	if [ "$advisory" = "Adult" ] ;
		then
			advisory="explicit"
			echo "Advisory: $advisory"
			echo "Advisory: $advisory" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
	else
			advisory=""
			echo "Advisory: $advisory"
			echo "Advisory: $advisory" >> "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
	fi			
if [ "$genre" = "Adult" ] ;
	then
		artwork=$(((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 1 ) | sed s/" #00"//g )
		artwork="$artwork/$artwork #000.jpg"
		artwork="/Users/joel/Pictures/Downloaded/$artwork"
	else
		artwork=$(((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 1 ) | sed s/" #00"//g )
		artwork="/Users/joel/Pictures/DVD Artwork/$artwork.jpg"
fi	
UPC=$((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 7 ) | sed s/".m4v"//g ) | sed s/".mp4"//g )
artworkuid=$((((((((((((grep "$UPC" "$databasedump") | sed s/"INSERT INTO "//g) | sed s/\"ZENTRY\"\ VALUES\(//g) | sed s/");"//g) | sed s/"NULL"/"'NULL'"/g) | sed s/"','"/";"/g) | sed s/"'"//g) | sed s/\"//g) | sed s/", "/" - "/g) | sed s/","/";"/g) | sed s/" - "/", "/g) | cut -d \; -f 9 )
artwork="/Users/joel/Library/Application Support/DVDpedia/Covers/$artworkuid.jpg"
#len=${#cnID}
#if [ "$len" -gt 9 ] ;
#	then
#		cnID=$(((((grep "$filename" "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt" ) | cut -d \; -f 7 ) | sed s/".m4v"//g ) | sed s/".mp4"//g ) | cut -c 4- )
#fi
cnID=$(((RANDOM%(999999999-111111111+1))/1*1+111111111))
echo "UPC: $UPC"
director=$((((grep "$UPC" "/Users/joel/Documents/Library.txt") | sed s/\"\,\"/\"\;\"/g ) | sed s/\"//g ) | cut -d \; -f 8 )
echo "Director: $director"
producer=$((((grep "$UPC" "/Users/joel/Documents/Library.txt") | sed s/\"\,\"/\"\;\"/g ) | sed s/\"//g ) | cut -d \; -f 9 )
echo "Producer: $producer"
summary=$((((grep "$UPC" "/Users/joel/Documents/Library.txt") | sed s/\"\,\"/\"\;\"/g ) | sed s/\"//g ) | cut -d \; -f 10 )
echo "Summary: $summary"
starring=$((((grep "$UPC" "/Users/joel/Documents/Library.txt") | sed s/\"\,\"/\"\;\"/g ) | sed s/\"//g ) | cut -d \; -f 11 )
echo "Starring: $starring"
studio=$((((grep "$UPC" "/Users/joel/Documents/Library.txt") | sed s/\"\,\"/\"\;\"/g ) | sed s/\"//g ) | cut -d \; -f 12 )
echo "Studio: $studio"
writer=$((((grep "$UPC" "/Users/joel/Documents/Library.txt") | sed s/\"\,\"/\"\;\"/g ) | sed s/\"//g ) | cut -d \; -f 15 )
echo "Writer: $writer"
echo "cnID: $cnID"
#cnID=$(date "+%m%d%H%M%S")
echo "Artwork File: $artwork"
purchasedate=$(date "+%Y-%m-%d")

sleep 1
if [ -f "$artwork" ] ;
	then
		echo "Encoding WITH Artwork"
		art="1"
		"/Volumes/Mac Pro Storage/0-Applications/./AtomicParsley32" "$SOURCE" --title "$title" --artist "$artist" --albumArtist "$artist" --album "$album" --TVShowName "$artist" --TVSeasonNum "$tvseason" --TVEpisodeNum "$episodenum" --TVEpisode "$episodenum" --grouping "$grouping" --tracknum "" --disk "" --stik "$stik" --contentRating "$rating" --year "$year" --comment "$comment" --genre "$genre" --advisory "$advisory" --artwork="$artwork" --purchaseDate="$purchasedate" --encodingTool="$UPC" --overWrite
		wait
		sleep 1
		echo "Writing other Tags"
		"/Volumes/Mac Pro Storage/0-Applications/SublerCLI" -i "$SOURCE" -t "{cnID:$cnID}{Director:$director}{Producers:$producer}{Long Description:$summary}{Cast:$starring}{Screenwriter:$writer}{Copyright:$studio}"
		sleep 1
else
		echo "Encoding WITHOUT Artwork"
		art="2"
		"/Volumes/Mac Pro Storage/0-Applications/./AtomicParsley32" "$SOURCE" --title "$title" --artist "$artist" --albumArtist "$artist" --album "$album" --TVShowName "$artist" --TVSeasonNum "$tvseason" --TVEpisodeNum "$episodenum" --TVEpisode "$episodenum" --grouping "$grouping" --tracknum "" --disk "" --stik "$stik" --contentRating "$rating" --year "$year" --comment "$comment" --genre "$genre" --advisory "$advisory" --purchaseDate="$purchasedate" --encodingTool="GIJOEL" --overWrite
		wait
		sleep 1
		echo "Writing Other Tags"
		"/Volumes/Mac Pro Storage/0-Applications/SublerCLI" -i "$SOURCE" -t "{cnID:$cnID}{Director:$director}{Producers:$producer}{Long Description:$summary}{Cast:$starring}{Screenwriter:$writer}{Copyright:$studio}{Encoded By:GIJOEL}"
		sleep 1
fi

if [ "$art" = "1" ] ;
	then
	echo "$art"
	if [ "$grouping" = "High Def AppleTV" ] ;
		then
			echo "**********Moving to Subler Optimize Folder"
			mv "$SOURCE" "/Volumes/Mac Pro Storage/5-Add HD Tag/"
		else
			echo "**********Waiting on Subler"
			mv "$SOURCE" "/Volumes/Mac Pro Storage/5-Subler Optimize/"
	fi
fi
if [ "$art" = "2" ] ;
	then
		echo "**********Waiting on MetaX"
		mv "$SOURCE" "/Volumes/Mac Pro Storage/6-Waiting for MetaX/"
fi

rm "/Volumes/Mac Pro Storage/0-Temp Files/movietagging.txt"
done
IFS="$OLDIFS"
sleep 5
"/Volumes/Mac Pro Storage/0-Applications/tag-optimize"