diff options
| author | Philipp Sehmisch <mana@crushnet.org> | 2010-12-27 17:33:41 +0100 |
|---|---|---|
| committer | Philipp Sehmisch <mana@crushnet.org> | 2010-12-27 17:33:41 +0100 |
| commit | a1514113093733b65e36224dad81f6867edcb93c (patch) | |
| tree | 2379ed168c9de7f8f6a920dc850210246c79fc5f /src/sql/sqlite/updates/update_12_to_13.sql | |
| parent | 3f559162b2e3cb0b434095d0bac297f67ff53d86 (diff) | |
| download | manaserv-a1514113093733b65e36224dad81f6867edcb93c.tar.gz manaserv-a1514113093733b65e36224dad81f6867edcb93c.tar.bz2 manaserv-a1514113093733b65e36224dad81f6867edcb93c.tar.xz manaserv-a1514113093733b65e36224dad81f6867edcb93c.zip | |
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
Diffstat (limited to 'src/sql/sqlite/updates/update_12_to_13.sql')
| -rw-r--r-- | src/sql/sqlite/updates/update_12_to_13.sql | 30 |
1 files changed, 30 insertions, 0 deletions
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 00000000..af639df7 --- /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'; + + |