Transaction logging of various command, new transaction codes and style fix.

The @mute, @goto, @attribute and @announce commands now logs transactions
to the database.

Added new transaction codes to database. I've preliminarily added a lot
of codes for not yet supported commands so that we needn't do a database
update with every single commit which implements one.

Also using the equivalent "say" helper function in place of the
"GameState::sayTo" method in the command handler.

Reviewed-by: Kage

4 files changed, 101 insertions, 0 deletions

diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index e080ec6..ab07cbd 100644
--- a/src/sql/mysql/createTables.sql
+++ b/src/sql/mysql/createTables.sql
@@ -456,3 +456,24 @@ INSERT INTO mana_transaction_codes VALUES ( 29, 'Trade money',              'Act
 INSERT INTO mana_transaction_codes VALUES ( 30, 'Trade items',              'Actions' );
 INSERT INTO mana_transaction_codes VALUES ( 31, 'Attribute increased',      'Character' );
 INSERT INTO mana_transaction_codes VALUES ( 32, 'Attribute decreased',      'Character' );
+INSERT INTO mana_transaction_codes VALUES ( 33, 'Command MUTE',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 34, 'Command EXP',              'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 35, 'Command INVISIBLE',        'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 36, 'Command COMBAT',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 37, 'Command ANNOUNCE',         'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 38, 'Command ANNOUNCE_LOCAL',   'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 39, 'Command KILL',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 40, 'Command FX',               'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 41, 'Command LOG',              'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 42, 'Command KILLMONSTER',      'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 43, 'Command GOTO',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 44, 'Command GONEXT',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 45, 'Command GOPREV',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 46, 'Command IPBAN',            'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 47, 'Command WIPE_ITEMS',       'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 48, 'Command WIPE_LEVEL',       'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 49, 'Command SHUTDOWN_THIS',    'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 50, 'Command SHUTDOWN_ALL',     'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 51, 'Command RESTART_THIS',     'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 52, 'Command RESTART_ALL',      'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 53, 'Command ATTRIBUTE',        'Commands' );
diff --git a/src/sql/mysql/updates/update_12_to_13.sql b/src/sql/mysql/updates/update_12_to_13.sql
new file mode 100644
index 0000000..27cb834
--- /dev/null
+++ b/src/sql/mysql/updates/update_12_to_13.sql
@@ -0,0 +1,29 @@
+-- insert new transaction codes
+INSERT INTO mana_transaction_codes VALUES ( 33, 'Command MUTE',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 34, 'Command EXP',              'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 35, 'Command INVISIBLE',        'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 36, 'Command COMBAT',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 37, 'Command ANNOUNCE',         'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 38, 'Command ANNOUNCE_LOCAL',   'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 39, 'Command KILL',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 40, 'Command FX',               'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 41, 'Command LOG',              'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 42, 'Command KILLMONSTER',      'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 43, 'Command GOTO',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 44, 'Command GONEXT',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 45, 'Command GOPREV',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 46, 'Command IPBAN',            'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 47, 'Command WIPE_ITEMS',       'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 48, 'Command WIPE_LEVEL',       'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 49, 'Command SHUTDOWN_THIS',    'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 50, 'Command SHUTDOWN_ALL',     'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 51, 'Command RESTART_THIS',     'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 52, 'Command RESTART_ALL',      'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 53, 'Command ATTRIBUTE',        'Commands' );
+
+-- Update database version.
+UPDATE mana_world_states
+SET value = '13',
+moddate = UNIX_TIMESTAMP()
+WHERE state_name = 'database_version';
+ 
diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql
index 6ce5290..e279aec 100644
--- a/src/sql/sqlite/createTables.sql
+++ b/src/sql/sqlite/createTables.sql
@@ -441,3 +441,24 @@ INSERT INTO mana_transaction_codes VALUES ( 29, 'Trade money',              'Act
 INSERT INTO mana_transaction_codes VALUES ( 30, 'Trade items',              'Actions' );
 INSERT INTO mana_transaction_codes VALUES ( 31, 'Attribute increased',      'Character' );
 INSERT INTO mana_transaction_codes VALUES ( 32, 'Attribute decreased',      'Character' );
+INSERT INTO mana_transaction_codes VALUES ( 33, 'Command MUTE',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 34, 'Command EXP',              'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 35, 'Command INVISIBLE',        'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 36, 'Command COMBAT',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 37, 'Command ANNOUNCE',         'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 38, 'Command ANNOUNCE_LOCAL',   'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 39, 'Command KILL',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 40, 'Command FX',               'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 41, 'Command LOG',              'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 42, 'Command KILLMONSTER',      'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 43, 'Command GOTO',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 44, 'Command GONEXT',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 45, 'Command GOPREV',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 46, 'Command IPBAN',            'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 47, 'Command WIPE_ITEMS',       'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 48, 'Command WIPE_LEVEL',       'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 49, 'Command SHUTDOWN_THIS',    'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 50, 'Command SHUTDOWN_ALL',     'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 51, 'Command RESTART_THIS',     'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 52, 'Command RESTART_ALL',      'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 53, 'Command ATTRIBUTE',        'Commands' );
diff --git a/src/sql/sqlite/updates/update_12_to_13.sql b/src/sql/sqlite/updates/update_12_to_13.sql
new file mode 100644
index 0000000..af639df
--- /dev/null
+++ b/src/sql/sqlite/updates/update_12_to_13.sql
@@ -0,0 +1,30 @@
+-- insert new transaction codes
+INSERT INTO mana_transaction_codes VALUES ( 33, 'Command MUTE',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 34, 'Command EXP',              'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 35, 'Command INVISIBLE',        'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 36, 'Command COMBAT',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 37, 'Command ANNOUNCE',         'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 38, 'Command ANNOUNCE_LOCAL',   'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 39, 'Command KILL',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 40, 'Command FX',               'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 41, 'Command LOG',              'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 42, 'Command KILLMONSTER',      'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 43, 'Command GOTO',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 44, 'Command GONEXT',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 45, 'Command GOPREV',           'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 46, 'Command IPBAN',            'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 47, 'Command WIPE_ITEMS',       'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 48, 'Command WIPE_LEVEL',       'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 49, 'Command SHUTDOWN_THIS',    'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 50, 'Command SHUTDOWN_ALL',     'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 51, 'Command RESTART_THIS',     'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 52, 'Command RESTART_ALL',      'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 53, 'Command ATTRIBUTE',        'Commands' );
+
+-- update the database version, and set date of update
+UPDATE mana_world_states
+   SET value      = '13',
+       moddate    = strftime('%s','now')
+ WHERE state_name = 'database_version';
+ 
+