Added LUA script bindings for manipulating the specials available to a character.

Added script call for getting the cost of a special (recharge only for now)

Deleting specials works server-sided but the client isn't informed about it properly. Specials without recharge cost don't appear for the player. Both of these features require an additional netcode message.

Reviewed-by: Freeyorp

1 files changed, 16 insertions, 0 deletions

diff --git a/src/sql/sqlite/updates/update_8_to_9.sql b/src/sql/sqlite/updates/update_8_to_9.sql
new file mode 100644
index 0000000..efc0d02
--- /dev/null
+++ b/src/sql/sqlite/updates/update_8_to_9.sql
@@ -0,0 +1,16 @@
+CREATE TABLE mana_char_specials
+(
+    char_id     INTEGER     NOT NULL,
+    special_id  INTEGER     NOT NULL,
+	PRIMARY KEY (char_id, special_id),
+    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
+);
+
+CREATE INDEX mana_char_specials_char on mana_char_specials ( char_id );
+
+-- update the database version, and set date of update
+UPDATE mana_world_states
+   SET value      = '9',
+       moddate    = strftime('%s','now')
+ WHERE state_name = 'database_version';
+