[lcd4linux @ 2004-03-20 23:09:01 by reinelt]

MySQL plugin fixes from Javi

git-svn-id: https://ssl.bulix.org/svn/lcd4linux/trunk@407 3ae390bd-cb1e-0410-b409-cd5a39f66f1f

1 files changed, 38 insertions, 0 deletions

diff --git a/lcd4linux.conf.sample b/lcd4linux.conf.sample
index e5a3f48..971e559 100644
--- a/lcd4linux.conf.sample
+++ b/lcd4linux.conf.sample
@@ -101,6 +101,14 @@ Plugin Seti {
 }
 
 
+Plugin MySQL {
+    server 'gsmlandia.com'	# if none, localhost assumed
+    port 3306			# if none, MySQL default assumed
+    user 'lcd4linux'		# if none, lcd4linux unix owner assumed
+    password 'lcd4linux'	# if none, empty password assumed
+    database 'lcd4linux'	# MUST be specified
+}
+
 Widget OS {
     class 'Text'
     expression '*** '.uname('sysname').' '.uname('release').' ***'
@@ -213,6 +221,24 @@ Widget Eth0Bar {
     update tack
 }
 
+Widget MySQLtest1 {
+	class 'Text'
+	expression MySQLquery('SELECT id FROM table1')
+	width 8
+	align 'R'
+	prefix 'MySQL'
+	update minute
+}
+
+Widget MySQLtest2 {
+	class 'Text'
+	expression MySQLstatus()
+	width 20
+	align 'M'
+	prefix 'Status: '
+	update minute
+}
+
 Widget Heartbeat {
     class 'Icon'
     speed 800
@@ -411,6 +437,18 @@ Layout Test {
 #    Row16.Col1 'Test'
 }
 
+
+Layout testMySQL {
+	Row1 {
+		Col1 'Heartbeat'
+		Col2 'MySQLtest1'
+	}
+	Row2 {
+		Col1 'MySQLtest2'
+	}
+}
+
+
 #Display 'LK204'
 #Display 'HD44780-20x4'
 #Display 'M50530-24x8'