From bfaa59f4e9325f0a273c6c47861117ec7d4e6495 Mon Sep 17 00:00:00 2001 From: reinelt Date: Sun, 21 Mar 2004 22:05:53 +0000 Subject: [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 --- lcd4linux.conf.sample | 28 ++++++++++++++-------------- plugin_mysql.c | 7 +++++-- 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()); } -- cgit v1.2.3