root/trunk/sql/world_updates/2860_items.sql @ 2860

Revision 2860, 0.8 kB (checked in by Vlack, 12 months ago)

Notice: Trunk is now 3.2.0

FIXED: Mail sending (by providing a missing item for the world database, this item is necessary for the client - for the item, thanks goes to Darkgrööm)
FIXED: Battleground selection crash (now the server will queue you on Isle of Conquest - note: this does not mean you can play on it, but it solves the instant crash when players selected it)
FIXED: Glyphs (till we properly implement dual spec)
FIXED: A9 target GUID sending (on flags & UPDATEFLAG_HAS_TARGET - thanks Alleycat)
FIXED: Re-enabled ground targeted spells (on m_targetMask & TARGET_FLAG_DEST_LOCATION - if a spell where you can select the area of its effect crashes the client in the future, we'll revise this part)
FIXED: A9 (actually just moved the already existing code pieces up/down to better suit the required format, but to know the format right, I had looked into Mangos code too, as I haven't got months to figure out the right structure)
FIXED: TaxiMgr::GetGlobalTaxiNodeMask? (index check, as with the new DBCs we have a "to" with value "-1", and when that's used as an uint, it'll result in an index of 255, while the structure is from 0 to 11).
ADDED: Override support (this extends the core with special features for special gameobjects, like what's required for trams and transports, which include features as: "override update fields", "never despawn on same map", "announce on greater range" and "push to player on map entry").
FIXED: static map object pushing (repaired the buffer handling error which duplicated buffer content in a pretty unique way).
ADDED: SQL fixes for Deeprun and Ulduar Trams (retail data, but it works right only with the override system).
UPDATED: UpdateFields?.h
UPDATED: DBCs (thanks Xuni)
UPDATED: Error codes (thanks Hopla)
FIXED: various packets, especially the following ones: character enumeration, mail list, group details (raid difficulty), movement-related packets
FIXED: The display of quest rewards the player can choose from on the quest page before accepting it.
FIXED: A nasty bug when un-equipping an item to a bag and not to the backpack. The problem was that I have missed 2 for loops where the visible items get nulled out on unequip, it erased 17 fields instead of just 2, so it made the character pretty much naked.

Line 
1ALTER TABLE `gameobject_names`
2  ADD COLUMN `QuestItem5` int(11) UNSIGNED DEFAULT '0' NOT NULL after `QuestItem4`,
3  ADD COLUMN `QuestItem6` int(11) UNSIGNED DEFAULT '0' NOT NULL after `QuestItem5`;
4
5ALTER TABLE `creature_names`
6  ADD COLUMN `QuestItem1` int(11) UNSIGNED DEFAULT '0' NOT NULL after `info_str`,
7  ADD COLUMN `QuestItem2` int(11) UNSIGNED DEFAULT '0' NOT NULL after `QuestItem1`,
8  ADD COLUMN `QuestItem3` int(11) UNSIGNED DEFAULT '0' NOT NULL after `QuestItem2`,
9  ADD COLUMN `QuestItem4` int(11) UNSIGNED DEFAULT '0' NOT NULL after `QuestItem3`,
10  ADD COLUMN `QuestItem5` int(11) UNSIGNED DEFAULT '0' NOT NULL after `QuestItem4`,
11  ADD COLUMN `QuestItem6` int(11) UNSIGNED DEFAULT '0' NOT NULL after `QuestItem5`;
12
13ALTER TABLE `items`
14  ADD COLUMN `faction` int(11) UNSIGNED DEFAULT '0' NOT NULL after `flags`;
Note: See TracBrowser for help on using the browser.