diff options
| author | QAston <none@none> | 2009-04-06 13:31:14 +0200 |
|---|---|---|
| committer | QAston <none@none> | 2009-04-06 13:31:14 +0200 |
| commit | 20c02ef7606557a3932d2a3ca052242224a53b4a (patch) | |
| tree | 8b7718b7938184f9c0d0aa3dba70a46316786bfa /sql | |
| parent | 850537ece97dde9ee788ebc6e2c8edd7285b0d00 (diff) | |
*Update of aura system.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/2412_characters.sql | 10 | ||||
| -rw-r--r-- | sql/updates/2412_world.sql.txt | 2 |
2 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/2412_characters.sql b/sql/updates/2412_characters.sql new file mode 100644 index 00000000000..22b5a751e71 --- /dev/null +++ b/sql/updates/2412_characters.sql @@ -0,0 +1,10 @@ +DELETE FROM `character_aura` WHERE 'effect_index'>'1'; + ALTER TABLE `character_aura` CHANGE `effect_index` `effect_mask` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; + ALTER TABLE `character_aura` CHANGE `amount` `amount0` INT( 11 ) NOT NULL DEFAULT '0'; + ALTER TABLE `character_aura` ADD `amount1` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount0`; + ALTER TABLE `character_aura` ADD `amount2` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount1`; +DELETE FROM `pet_aura` WHERE 'effect_index'>'1'; + ALTER TABLE `pet_aura` CHANGE `effect_index` `effect_mask` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; + ALTER TABLE `pet_aura` CHANGE `amount` `amount0` INT( 11 ) NOT NULL DEFAULT '0'; + ALTER TABLE 'pet_aura` ADD `amount1` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount0`; + ALTER TABLE `pet_aura` ADD `amount2` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount1`;
\ No newline at end of file diff --git a/sql/updates/2412_world.sql.txt b/sql/updates/2412_world.sql.txt new file mode 100644 index 00000000000..c31c22b3d72 --- /dev/null +++ b/sql/updates/2412_world.sql.txt @@ -0,0 +1,2 @@ +UPDATE `trinity_string` SET `content_default` = 'id: %d effmask: %d charges: %d stack: %d slot %d duration: %d maxduration: %d' WHERE `entry` =468; +UPDATE `trinity_string` SET `content_default` = 'id: %d eff: %d amount: %d' WHERE `trinity_string`.`entry` =470;
\ No newline at end of file |