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='';"
mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Law & Order: Los Angeles' where title='Law & Order: LA';"
rem
d:
cd D:\Downloads\MediaPortal 1_2_Beta\episodescanner
rem
bin\episodescanner.exe
rem pause