From d1ac4d5cd3b605526f2b1a3caa3339718962d415 Mon Sep 17 00:00:00 2001 From: Philipp Sehmisch Date: Mon, 27 Dec 2010 18:11:27 +0100 Subject: Added @kick and @kill commands. @kick disconnects the client connection of a character. The new error- code 11 (ERRMSG_ADMINISTRATIVE_LOGOFF) is not supported by the client yet. It will show a generic "The connection to server was lost" message instead. @kill kills the character by setting its HP to 0. Added @kick transaction code I forgot in last commit. Considering that this was just minutes ago I think that noone updated his database yet. So I don't think that a new database version is justified for this. Reviewed-by: Bertram --- src/sql/mysql/createTables.sql | 1 + src/sql/mysql/updates/update_12_to_13.sql | 1 + src/sql/sqlite/createTables.sql | 1 + src/sql/sqlite/updates/update_12_to_13.sql | 1 + 4 files changed, 4 insertions(+) (limited to 'src/sql') diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index ab07cbda..eb62d869 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -477,3 +477,4 @@ INSERT INTO mana_transaction_codes VALUES ( 50, 'Command SHUTDOWN_ALL', 'Com 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' ); +INSERT INTO mana_transaction_codes VALUES ( 54, 'Command KICK', 'Commands' ); diff --git a/src/sql/mysql/updates/update_12_to_13.sql b/src/sql/mysql/updates/update_12_to_13.sql index 27cb8340..a2387cd2 100644 --- a/src/sql/mysql/updates/update_12_to_13.sql +++ b/src/sql/mysql/updates/update_12_to_13.sql @@ -20,6 +20,7 @@ INSERT INTO mana_transaction_codes VALUES ( 50, 'Command SHUTDOWN_ALL', 'Com 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' ); +INSERT INTO mana_transaction_codes VALUES ( 54, 'Command KICK', 'Commands' ); -- Update database version. UPDATE mana_world_states diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index e279aece..3ab59d76 100644 --- a/src/sql/sqlite/createTables.sql +++ b/src/sql/sqlite/createTables.sql @@ -462,3 +462,4 @@ INSERT INTO mana_transaction_codes VALUES ( 50, 'Command SHUTDOWN_ALL', 'Com 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' ); +INSERT INTO mana_transaction_codes VALUES ( 54, 'Command KICK', 'Commands' ); diff --git a/src/sql/sqlite/updates/update_12_to_13.sql b/src/sql/sqlite/updates/update_12_to_13.sql index af639df7..9f28fc16 100644 --- a/src/sql/sqlite/updates/update_12_to_13.sql +++ b/src/sql/sqlite/updates/update_12_to_13.sql @@ -20,6 +20,7 @@ INSERT INTO mana_transaction_codes VALUES ( 50, 'Command SHUTDOWN_ALL', 'Com 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' ); +INSERT INTO mana_transaction_codes VALUES ( 54, 'Command KICK', 'Commands' ); -- update the database version, and set date of update UPDATE mana_world_states -- cgit v1.2.3-70-g09d2