From 573e49a7ead331219eb6f0d3ca9cf83e793a5c9c Mon Sep 17 00:00:00 2001 From: Adam Date: Mon, 23 Apr 2012 05:08:26 -0400 Subject: Reworked live SQL support yet again --- data/example.conf | 34 ++++++++++++++-------------------- 1 file changed, 14 insertions(+), 20 deletions(-) (limited to 'data') diff --git a/data/example.conf b/data/example.conf index a17b51a36..e27067e9a 100644 --- a/data/example.conf +++ b/data/example.conf @@ -1091,39 +1091,33 @@ db_flatfile * db_sql * * This module allows saving and loading databases using one of the SQL engines. + * This module does not use any real time reading or writing to SQL. Changes to + * the SQL tables not done by Anope will have no effect and will be overwritten. * * WARNING: This module will delete every table in the database it uses. Be sure * to put Anope in its own separate database. */ #module { name = "db_sql" } + +/* + * db_sql_live + * + * This module allows saving and loading databases using one of the SQL engines. + * This module reads and writes to SQL in real time. Changes to the SQL tables + * will be immediately reflected into Anope. This module should not be loaded + * in conjunction with db_sql. + */ +#module { name = "db_sql_live" } + db_sql { /* - * The SQL service db_sql should use, these are configured in modules.conf. + * The SQL service db_sql(_live) should use, these are configured in modules.conf. * For MySQL, this should probably be mysql/main. */ engine = "sqlite/main" } -/* - * db_sql_live_read, db_sql_live_write - * - * Enables (live) SQL support. - * - * The db_sql_live modules are an extension to db_sql, and should only be used if - * db_sql is being used. - * - * The db_sql_live_read module pulls data in real time from - * SQL as it is needed by the core. - * At this time this supports the three main tables: ChannelInfo, NickAlias, and NickCore. - * - * The db_sql_live_write module writes data to SQL in real time as it is modified by - * the core. - * - */ -#module { name = "db_sql_live_read" } -#module { name = "db_sql_live_write" } - /* * [REQUIRED] Encryption modules. * -- cgit