#!/bin/bash

mysql mythconverg <<EOF
update gameplayers set commandline = '/usr/bin/sdlmame -rp /myth/games/xmame/roms %s' where commandline = '/usr/game/mame -rp /myth/games/xmame/roms %s';
update settings set data = '/myth/video_stuff/coverart' where value = 'VideoArtworkDir';
update settings set data = '/myth/video_stuff/fanart' where value = 'mythvideo.fanartDir';
update settings set data = '/myth/video_stuff/screenshots' where value = 'mythvideo.screenshotDir';
update settings set data = '/myth/video_stuff/banners' where value = 'mythvideo.bannerDir';
update settings set data = '/myth/video_stuff/trailers' where value = 'mythvideo.TrailersDir';
update settings set data = '1' where value = 'mythvideo.TrailersRandomEnabled';
update settings set data = '1' where value = 'mythvideo.EnableAlternatePlayer';
update settings set data = '/myth/video_stuff/screenshots' where value = 'ScreenShotPath';
update settings set data = '/myth/games/screenshots' where value = 'mythgame.screenshotdir';
update settings set data = '/myth/games/fanart' where value = 'mythgame.fanartdir';
update settings set data = '/myth/games/boxart' where value = 'mythgame.boxartdir';
update settings set data = '3' where value = 'OverrideExitMenu';
update settings set data = 'sudo sv start mythbackend' where value = 'BackendStartCommand';
update settings set data = 'sudo sv stop mythbackend' where value = 'BackendStopCommand';
update settings set data = '/usr/share/mythtv/mythvideo/scripts/tmdb.pl -M' where value = 'MovieListCommandLine';
update settings set data = replace(data, 'imdb.pl', 'tmdb.pl');
EOF