summaryrefslogtreecommitdiffstats
path: root/abs/core-testing/linhes-scripts
diff options
context:
space:
mode:
authorCecil Hugh Watson <knoppmyth@gmail.com>2009-12-25 04:49:26 (GMT)
committerCecil Hugh Watson <knoppmyth@gmail.com>2009-12-25 04:49:26 (GMT)
commite803239f44b43b2a425f47c1f1beb289be031f96 (patch)
treef287680dbc36b58b003270dd785e5971a84565d6 /abs/core-testing/linhes-scripts
parent5869c8aba6e9ee7be29a207a9c7e264442f07b63 (diff)
downloadlinhes_pkgbuild-e803239f44b43b2a425f47c1f1beb289be031f96.zip
linhes_pkgbuild-e803239f44b43b2a425f47c1f1beb289be031f96.tar.gz
linhes_pkgbuild-e803239f44b43b2a425f47c1f1beb289be031f96.tar.bz2
Added script to update schema to reflect changes in 0.22.
Diffstat (limited to 'abs/core-testing/linhes-scripts')
-rw-r--r--abs/core-testing/linhes-scripts/PKGBUILD3
-rw-r--r--abs/core-testing/linhes-scripts/update_schema_021_to_022.sh17
2 files changed, 19 insertions, 1 deletions
diff --git a/abs/core-testing/linhes-scripts/PKGBUILD b/abs/core-testing/linhes-scripts/PKGBUILD
index 7dc200b..1da04cc 100644
--- a/abs/core-testing/linhes-scripts/PKGBUILD
+++ b/abs/core-testing/linhes-scripts/PKGBUILD
@@ -3,7 +3,7 @@
pkgname=linhes-scripts
pkgver=1
-pkgrel=39
+pkgrel=40
pkgdesc="Various scripts that help to make LinHES, LinHES."
arch=('i686' 'x86_64')
license=('GPL2')
@@ -33,6 +33,7 @@ linhes_update.sh
linhes_update2.sh
linhes_update3.sh
install_hulu.sh
+update_schema_021_to_022.sh
)
build() {
diff --git a/abs/core-testing/linhes-scripts/update_schema_021_to_022.sh b/abs/core-testing/linhes-scripts/update_schema_021_to_022.sh
new file mode 100644
index 0000000..9ee3224
--- /dev/null
+++ b/abs/core-testing/linhes-scripts/update_schema_021_to_022.sh
@@ -0,0 +1,17 @@
+#!/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';
+EOF