From 8770f610305315222015644fb77e3a0f14ab31d3 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Fri, 24 Jul 2020 17:21:14 +0200
Subject: work on auto-installation

---
 server-build/QEMU-autobuild/buildWebstore.sh | 6 +++---
 server-build/QEMU-autobuild/test.sh          | 6 +-----
 2 files changed, 4 insertions(+), 8 deletions(-)

(limited to 'server-build/QEMU-autobuild')

diff --git a/server-build/QEMU-autobuild/buildWebstore.sh b/server-build/QEMU-autobuild/buildWebstore.sh
index bc8a862..e0873ae 100755
--- a/server-build/QEMU-autobuild/buildWebstore.sh
+++ b/server-build/QEMU-autobuild/buildWebstore.sh
@@ -180,11 +180,11 @@ echo
 SNIPPET=`cat KUDOS-WooCommerce-Support.php.txt`
 
 cat | mysql wordpress <<EOF
-PREPARE stmt FROM 'INSERT INTO wp_snippets (name, description, code, scope, priority, active, modified, tags)';
+PREPARE stmt FROM 'INSERT INTO wp_snippets (name, description, code, scope, priority, active, modified) VALUES (?,?,?,?,?,?,?,?)';
 SET @name='KUDOS currency support';
-SET @description='This snippets adds support for the KUDOS currency of the Taler demo to WooCommerce'
+SET @description='This snippets adds support for the KUDOS currency of the Taler demo to WooCommerce';
 SET @code="$SNIPPET";
-EXECUTE stmt USING @name, @description, @code, "global", 0, 1, NOW(), "code-snippets-plugin";
+EXECUTE stmt USING @name, @description, @code, "global", 10, 1, NOW();
 EOF
 
 
diff --git a/server-build/QEMU-autobuild/test.sh b/server-build/QEMU-autobuild/test.sh
index a80a6d5..8b07841 100644
--- a/server-build/QEMU-autobuild/test.sh
+++ b/server-build/QEMU-autobuild/test.sh
@@ -5,15 +5,11 @@ SNIPPET=`cat KUDOS-WooCommerce-Support.php.txt`
 cat | mysql wordpress <<EOF
 PREPARE stmt FROM 'INSERT INTO wp_snippets (name, description, code, scope, priority, active, modified, tags) VALUES (?,?,?,?,?,?,?,?)';
 SET @name='KUDOS currency support';
-SET @description='This snippets adds support for the KUDOS currency of the Taler demo to WooCommerce'
+SET @description='This snippets adds support for the KUDOS currency of the Taler demo to WooCommerce';
 SET @code="$SNIPPET";
 EXECUTE stmt USING @name, @description, @code, "global", 0, 1, NOW(), "code-snippets-plugin";
 EOF
 
-
-echo "INSERT INTO wp_snippets (name, description, code, scope, priority, active, modified, tags) VALUES ('KUDOS currency support','This snippets adds support for the KUDOS currency of the Taler demo to WooCommerce','${SQLSNIPPET}'
-mysql wordpress
-
 echo
 echo '2. You must set up WooCommerce defaults.  To do this:'
 echo '   a. Log into the WooTaler site in your host system at 127.0.0.1:9999/wp-admin/.'
-- 
cgit v1.2.3