[lcd4linux @ 2004-03-21 22:05:53 by reinelt]

MySQL plugin fixes from Javi

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

2 files changed, 19 insertions, 16 deletions

diff --git a/lcd4linux.conf.sample b/lcd4linux.conf.sample
index 971e559..40cc963 100644
--- a/lcd4linux.conf.sample
+++ b/lcd4linux.conf.sample
@@ -222,21 +222,21 @@ Widget Eth0Bar {
 }
 
 Widget MySQLtest1 {
-	class 'Text'
-	expression MySQLquery('SELECT id FROM table1')
-	width 8
-	align 'R'
-	prefix 'MySQL'
-	update minute
+    class 'Text'
+    expression MySQL::query('SELECT id FROM table1')
+    width 20
+    align 'R'
+    prefix 'MySQL test:'
+    update minute
 }
 
 Widget MySQLtest2 {
-	class 'Text'
-	expression MySQLstatus()
-	width 20
-	align 'M'
-	prefix 'Status: '
-	update minute
+    class 'Text'
+    expression MySQL::status()
+    width 20
+    align 'M'
+    prefix 'Status: '
+    update minute
 }
 
 Widget Heartbeat {
@@ -440,8 +440,7 @@ Layout Test {
 
 Layout testMySQL {
 	Row1 {
-		Col1 'Heartbeat'
-		Col2 'MySQLtest1'
+		Col1 'MySQLtest1'
 	}
 	Row2 {
 		Col1 'MySQLtest2'
@@ -467,4 +466,5 @@ Layout  'L16x2'
 Variables {
    tick 500
    tack 100
+   minute 60000
 }
diff --git a/plugin_mysql.c b/plugin_mysql.c
index e234dc9..7372472 100644
--- a/plugin_mysql.c
+++ b/plugin_mysql.c
@@ -1,4 +1,4 @@
-/* $Id: plugin_mysql.c,v 1.2 2004/03/20 23:09:01 reinelt Exp $
+/* $Id: plugin_mysql.c,v 1.3 2004/03/21 22:05:53 reinelt Exp $
  *
  * plugin for execute SQL queries into a MySQL DBSM.
  *
@@ -23,6 +23,9 @@
  *
  *
  * $Log: plugin_mysql.c,v $
+ * Revision 1.3  2004/03/21 22:05:53  reinelt
+ * MySQL plugin fixes from Javi
+ *
  * Revision 1.2  2004/03/20 23:09:01  reinelt
  * MySQL plugin fixes from Javi
  *
@@ -138,7 +141,7 @@ int plugin_init_mysql (void)
   free(s);
   
   if (cfg_number(Section, "port", 0, 1, 65536, &port)<1) {
-    /* using * as default port because mysql_real_connect() will convert it to real default one */
+    /* using 0 as default port because mysql_real_connect() will convert it to real default one */
     info ("[MySQL] no '%s.port' entry from %s using MySQL's default", Section, cfg_source());
   }