root/trunk/sql/updates/176_world.sql @ 174

Revision 168, 1.2 kB (checked in by yumileroy, 17 years ago)

[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.

Original author: KingPin?
Date: 2008-11-05 09:22:56-06:00
Line 
1ALTER TABLE `npc_option`
2  CHANGE COLUMN `id` `id` mediumint(8) unsigned NOT NULL default '0',
3  CHANGE COLUMN `gossip_id` `gossip_id` mediumint(8) unsigned NOT NULL default '0',
4  CHANGE COLUMN `action` `action` mediumint(8) unsigned NOT NULL default '0',
5  ADD COLUMN `box_money` int(10) unsigned NOT NULL default '0' AFTER `action`,
6  ADD COLUMN `coded` tinyint(3) unsigned NOT NULL default '0' AFTER `box_money`,
7  ADD COLUMN `box_text` text AFTER `option_text`;
8
9CREATE TABLE `locales_npc_option` (
10  `entry` mediumint(8) unsigned NOT NULL default '0',
11  `option_text_loc1` text,
12  `option_text_loc2` text,
13  `option_text_loc3` text,
14  `option_text_loc4` text,
15  `option_text_loc5` text,
16  `option_text_loc6` text,
17  `option_text_loc7` text,
18  `option_text_loc8` text,
19  `box_text_loc1` text,
20  `box_text_loc2` text,
21  `box_text_loc3` text,
22  `box_text_loc4` text,
23  `box_text_loc5` text,
24  `box_text_loc6` text,
25  `box_text_loc7` text,
26  `box_text_loc8` text,
27  PRIMARY KEY  (`entry`)
28) ENGINE=MyISAM DEFAULT CHARSET=utf8;
29
30ALTER TABLE `creature_template`
31  CHANGE COLUMN `flags` `unit_flags` int(10) unsigned NOT NULL default '0',
32  CHANGE COLUMN `flag1` `type_flags` int(10) unsigned NOT NULL default '0';
Note: See TracBrowser for help on using the browser.