rem This will goto the MySQL directory and then modify the database
rem      to change tv show names and clear out any episode numbers it collected
rem      in the mc2xml grabbing such that episodescanner can go get them! 
rem
c:
cd C:\Program Files\MySQL\MySQL Server 5.1\bin
rem pause
mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET episodeNum='' WHERE episodeNum!='' AND seriesNum='' AND title!='America\'s Got Talent' AND title!='This Old House' AND title!='The This Old House Hour';"
rem pause
mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Law & Order: Los Angeles' where title='Law & Order: LA';"
mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Frontline (PBS)' where title='Frontline';"
mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Undercover Boss (US)' where title='Undercover Boss';"
rem mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Hawaii Five-0 (2010)' where title='Hawaii Five-0';"
mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Hawaii Five-0' where title='Hawaii Five-0 (2010)';"
rem mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Law and Order: Special Victims Unit' where title='Law & Order: Special Victims Unit';"
mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Charlie\'s Angels (2011)' where title='Charlie\'s Angels';"
mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Prime Suspect (US)' where title='Prime Suspect';"
rem pause
d:
cd D:\Downloads\MediaPortal 1_2_Beta\episodescanner
rem
bin\episodescanner.exe
rem pause