summaryrefslogtreecommitdiffstats
path: root/src/sql
diff options
context:
space:
mode:
authorPhilipp Sehmisch <mana@crushnet.org>2010-12-27 18:11:27 +0100
committerPhilipp Sehmisch <mana@crushnet.org>2010-12-27 18:11:27 +0100
commitd1ac4d5cd3b605526f2b1a3caa3339718962d415 (patch)
tree2b8e43ae739eed4583d9a82c7d9613fd781a930f /src/sql
parenta1514113093733b65e36224dad81f6867edcb93c (diff)
downloadmanaserv-d1ac4d5cd3b605526f2b1a3caa3339718962d415.tar.gz
manaserv-d1ac4d5cd3b605526f2b1a3caa3339718962d415.tar.xz
manaserv-d1ac4d5cd3b605526f2b1a3caa3339718962d415.zip
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
Diffstat (limited to 'src/sql')
-rw-r--r--src/sql/mysql/createTables.sql1
-rw-r--r--src/sql/mysql/updates/update_12_to_13.sql1
-rw-r--r--src/sql/sqlite/createTables.sql1
-rw-r--r--src/sql/sqlite/updates/update_12_to_13.sql1
4 files changed, 4 insertions, 0 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index ab07cbd..eb62d86 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 27cb834..a2387cd 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 e279aec..3ab59d7 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 af639df..9f28fc1 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