Made cooldowns of abilities scriptable

 - Removed hardcoded using of attributes
 - Simply introduced lua functions to set global and ability cooldowns
 - Requires database update
 - Bumps the protocol

2 files changed, 35 insertions, 2 deletions

diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql
index 72a70090..9d7d1c2c 100644
--- a/src/sql/sqlite/createTables.sql
+++ b/src/sql/sqlite/createTables.sql
@@ -110,7 +110,6 @@ CREATE TABLE mana_char_abilities
 (
     char_id                 INTEGER     NOT NULL,
     ability_id              INTEGER     NOT NULL,
-    ability_current_points  INTEGER     NOT NULL,
 	PRIMARY KEY (char_id, ability_id),
     FOREIGN KEY (char_id) REFERENCES mana_characters(id)
 );
@@ -409,7 +408,7 @@ AS
 
 INSERT INTO mana_world_states VALUES('accountserver_startup',-1,'0', strftime('%s','now'));
 INSERT INTO mana_world_states VALUES('accountserver_version',-1,'0', strftime('%s','now'));
-INSERT INTO mana_world_states VALUES('database_version',     -1,'23', strftime('%s','now'));
+INSERT INTO mana_world_states VALUES('database_version',     -1,'24', strftime('%s','now'));
 
 -- all known transaction codes
 
diff --git a/src/sql/sqlite/updates/update_23_to_24.sql b/src/sql/sqlite/updates/update_23_to_24.sql
new file mode 100644
index 00000000..83b129eb
--- /dev/null
+++ b/src/sql/sqlite/updates/update_23_to_24.sql
@@ -0,0 +1,34 @@
+BEGIN;
+
+CREATE TABLE mana_char_abilities_backup
+(
+    char_id                 INTEGER     NOT NULL,
+    ability_id              INTEGER     NOT NULL,
+    PRIMARY KEY (char_id, ability_id),
+    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
+);
+
+INSERT INTO mana_char_abilities_backup SELECT char_id, ability_id FROM mana_char_abilities;
+
+DROP TABLE mana_char_abilities;
+
+CREATE TABLE mana_char_abilities
+(
+    char_id                 INTEGER     NOT NULL,
+    ability_id              INTEGER     NOT NULL,
+    PRIMARY KEY (char_id, ability_id),
+    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
+);
+
+INSERT INTO mana_char_abilities SELECT char_id, ability_id FROM mana_char_abilities_backup;
+
+DROP TABLE mana_char_abilities_backup;
+
+-- Update the database version, and set date of update
+UPDATE mana_world_states
+   SET value      = '24',
+       moddate    = strftime('%s','now')
+   WHERE state_name = 'database_version';
+
+END;
+