diff options
| author | KingPin <none@none> | 2008-11-05 09:22:56 -0600 |
|---|---|---|
| committer | KingPin <none@none> | 2008-11-05 09:22:56 -0600 |
| commit | 62ed044d08425bd09053bda18d56113bd9f9a2ce (patch) | |
| tree | 28ed72b77f24d88b47df4f1b3ec3f20582b2c18f /sql/updates | |
| parent | a1981ecc77c3da12cdec29c30a1a79a1011333f0 (diff) | |
[svn] *** Source Mangos ***
*Load npc_options at server startup, use cached data at creature gossip menu init.
* Also new .reload table command added
*Implement npc_option localization support, also store in DB BoxText/BoxMoney/Coded
* Use characters.guid instead low guid value from characters.data in charcter enum data prepering for client.
* Fixed crash at .pinfo command use from console.
* Fixed windows ad.exe build
*Creature related code and DB cleanups.
* Rename 2 creature_template fields to more clean names and related code update also.
* Use enum values instead raw values for type_flags, use halper functions instead code repeating.
* Move tamed pet creating code to new function.
** Small code changes to make things compliant with above changes.
** Another rev with big changes so test away.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/176_world.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/176_world.sql b/sql/updates/176_world.sql new file mode 100644 index 00000000000..03c720d7ef5 --- /dev/null +++ b/sql/updates/176_world.sql @@ -0,0 +1,32 @@ +ALTER TABLE `npc_option`
+ CHANGE COLUMN `id` `id` mediumint(8) unsigned NOT NULL default '0',
+ CHANGE COLUMN `gossip_id` `gossip_id` mediumint(8) unsigned NOT NULL default '0',
+ CHANGE COLUMN `action` `action` mediumint(8) unsigned NOT NULL default '0',
+ ADD COLUMN `box_money` int(10) unsigned NOT NULL default '0' AFTER `action`,
+ ADD COLUMN `coded` tinyint(3) unsigned NOT NULL default '0' AFTER `box_money`,
+ ADD COLUMN `box_text` text AFTER `option_text`;
+
+CREATE TABLE `locales_npc_option` (
+ `entry` mediumint(8) unsigned NOT NULL default '0',
+ `option_text_loc1` text,
+ `option_text_loc2` text,
+ `option_text_loc3` text,
+ `option_text_loc4` text,
+ `option_text_loc5` text,
+ `option_text_loc6` text,
+ `option_text_loc7` text,
+ `option_text_loc8` text,
+ `box_text_loc1` text,
+ `box_text_loc2` text,
+ `box_text_loc3` text,
+ `box_text_loc4` text,
+ `box_text_loc5` text,
+ `box_text_loc6` text,
+ `box_text_loc7` text,
+ `box_text_loc8` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+ALTER TABLE `creature_template`
+ CHANGE COLUMN `flags` `unit_flags` int(10) unsigned NOT NULL default '0',
+ CHANGE COLUMN `flag1` `type_flags` int(10) unsigned NOT NULL default '0';
|