aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorreinelt <>2006-01-20 15:58:05 +0000
committerreinelt <>2006-01-20 15:58:05 +0000
commitb18235a45d3cade7f862abec063f2e8121541a48 (patch)
treeefdaa21da22b860fcb680bf54a611db9fd6478c7
parent4651cdff898368b9a739c63028dad51af128f93e (diff)
downloadlcd4linux-b18235a45d3cade7f862abec063f2e8121541a48.tar.gz
[lcd4linux @ 2006-01-20 15:58:05 by reinelt]
MySQL::count() added again
Diffstat (limited to '')
-rw-r--r--lcd4linux.conf.sample8
-rw-r--r--plugin_mysql.c11
2 files changed, 10 insertions, 9 deletions
diff --git a/lcd4linux.conf.sample b/lcd4linux.conf.sample
index 06c423e..7df0053 100644
--- a/lcd4linux.conf.sample
+++ b/lcd4linux.conf.sample
@@ -929,7 +929,7 @@ Layout testMySQL {
#Display 'LCM-162'
#Display 'CF631'
#Display 'CF632'
-Display 'CF633'
+#Display 'CF633'
#Display 'Curses'
#Display 'M50530-24x8'
#Display 'LCDTerm'
@@ -937,7 +937,7 @@ Display 'CF633'
#Display 'BA63'
#Display 'CT20x4'
#Display 'T6963-240x64'
-#Display 'XWindow'
+Display 'XWindow'
#Display 'USBLCD'
#Display 'BWCT'
#Display 'Image'
@@ -945,12 +945,12 @@ Display 'CF633'
#Display 'LPH7508-serdisplib'
#Display 'LPH7508'
-#Layout 'Default'
+Layout 'Default'
#Layout 'L8x2'
#Layout 'L16x2'
#Layout 'L20x2'
#Layout 'Test'
#Layout 'Test2'
-Layout 'TestGPO'
+#Layout 'TestGPO'
diff --git a/plugin_mysql.c b/plugin_mysql.c
index fd35e11..1ccdb0e 100644
--- a/plugin_mysql.c
+++ b/plugin_mysql.c
@@ -1,4 +1,4 @@
-/* $Id: plugin_mysql.c,v 1.9 2006/01/20 15:43:25 reinelt Exp $
+/* $Id: plugin_mysql.c,v 1.10 2006/01/20 15:58:05 reinelt Exp $
*
* plugin for execute SQL queries into a MySQL DBSM.
*
@@ -23,6 +23,9 @@
*
*
* $Log: plugin_mysql.c,v $
+ * Revision 1.10 2006/01/20 15:58:05 reinelt
+ * MySQL::count() added again
+ *
* Revision 1.9 2006/01/20 15:43:25 reinelt
* MySQL::query() returns a value, not the number of rows
*
@@ -162,9 +165,7 @@ static int configure_mysql(void)
return configured;
}
-#if 0
-/* removed because you can use 'query("select count(*)")' */
-static void my_MySQLquery(RESULT * result, RESULT * query)
+static void my_MySQLcount(RESULT * result, RESULT * query)
{
char *q;
double value;
@@ -195,7 +196,6 @@ static void my_MySQLquery(RESULT * result, RESULT * query)
SetResult(&result, R_NUMBER, &value);
}
-#endif
static void my_MySQLquery(RESULT * result, RESULT * query)
@@ -259,6 +259,7 @@ static void my_MySQLstatus(RESULT * result)
int plugin_init_mysql(void)
{
#ifdef HAVE_MYSQL_MYSQL_H
+ AddFunction("MySQL::count", 1, my_MySQLcount);
AddFunction("MySQL::query", 1, my_MySQLquery);
AddFunction("MySQL::status", 0, my_MySQLstatus);
#endif