[Compiles] Mangos + YTDB + Scriptdev2 + Changelog

[Dj Aligator]

YTDB 314
+ all fixes from forum;
+ spawn;
+ quest scripts
+ mob's gossip menues;
+ new templates from WDB;
+ fix spawn: Blackrock Depths
+ fix spawn: Lower Blackrock Spire
+ fix spawn: Upper Blackrock Spire
+ fix spawn: Stratholme
+ mounts models fix;
+ fix quest conditions;
+ fix some vendors;
+ fix loot;
+ mob's stats fix;
+ filling "quest_poi" and "quest_poi_points" (Thanks Blizzy) ;
+ processed 265 caches (3.3.2) - last;
+ processed 28 caches (3.3.3);

Mangos 9650 - 9667
Some corpse related clean ups.

Old bones remove code anyway was dead, so remove it.
Correct code for quest points of interest.

Adjusting field names and type, and send data accordingly to avoid client
crash not using auto-generated id.

Due to the nature of the primary keys, two tables are truncated. Be sure
to make backup if you have data you do now want to loose.

In addition, speed up load times of data from quest_poi_points, thanks
Hunuza for helping out.
Avoid corpse save at arenas also, small cleanups.
Correctly update talent free points in diff cases.

Before at .unlearn or .learn all_mytalents commands free talent points not
updated correctly.
Same for .learn all_mypettalents.
Restore action bar proper content show at spec switch.
Fixed bug with possible double remove spell.

In case when saved in DB spell remove triggering by
dependendences chain self remove attempt.
Implement '.list talents' command.

Command show really know by selected player talent ranks,
including bugged cases like 2 rank same talent known and etc.
Also command claculated count of talents and total used talent
points cost of known talent ranks.

Can be helpful in bug debuging and cheating cases.
Not include in .list talents disabled spells

Also some more cleanups in free talent points update calls.
Remove SPELL_EFFECT_TITAN_GRIP flag at related spell remove.

This let have correct state for flag at .unlearn related spell and etc.
Not only at full talent reset.
Simplify resetTalent code.

Currently all code related to deepndent spells unlern exist in removeSpell

so not need do it in special way in talentReset.
Simplify talents reset for pet case.
Implement dual talent specializations in talent switch part.

* Implement talent specs switch functionality.
* Only gossip part still not implemented.
* At update server to this commit or later character talents will be reset

with some spam in logs about wrong places talents in character_spell.
It can be ignored as part of conversion to new table support.

Thanks to all getmangos.com community members who take part
in creating and updating original dual spec patch.
Use the db-user 'mangos' instead of 'root' in the config file.

Change done for consistence with 'mangos' created in sql/create_mysql.sql

NOTE: for secirity reason better not use this user name (and password)
in real configs/MySQL.
Include entry of gameobject in gobject near command
Fix what author of [9663] messed up, and include the changes in
mangos.sql
Add another exception to IsNoStackSpellDueToSpell.
Check max. honor points on characteacter login.
Implement 57849 and ranks.










Yea but my thread it will get like old and could no one see that is exist anymore so no views and no downloads. It will be a ghost thread. On every forum that i keep upgrade the mangos releases i do like thins and no one said nothing.
If the moders or other peopel don't like it they can delete the thread or close it and i will leave this forum and don't post anymore updates with mangos.

[DONalex]

oane importan question. Do i have to download all the links to create a single db(updates) . Ther is noe full db of 3.3.3 with all updates?

[Dj Aligator]

Mangos 9668 - 9678
Add .DS_Store to gitignore.
Restore build at some old GCC versions

Old GCC hash_map::erase not return next iterator point
Add dummy effect of spell 55364.
fix resilience applying to periodic leech auras
Add some research for spell attributes.
Updated OpenSSL to version 1.0.0.
Fixed few typos.

Conflicts:

src/game/Unit.cpp
Renamed HMACSHA1 to something that will not conflict with feature
HMACSHA256 and HMACSHA512.

Conflicts:

src/shared/Auth/AuthCrypt.cpp
src/shared/Auth/HMACSHA1.cpp
Small backport from other branch.

Conflicts:

src/game/Player.cpp
src/game/SharedDefines.h
src/game/UpdateFields.h
src/realmd/AuthCodes.h
src/shared/Auth/AuthCrypt.cpp
src/shared/Auth/HMACSHA1.cpp
Updated AuthResult enum.
Added some info about realm list and auth response packets.
Added few dbc structs and updated related enums.
Fixed realm flags enum.
Implemented SMSG_BUY_BANK_SLOT_RESULT opcode.
Fixed console spam.
How this happened?
Added one more git ignore.
Fixed VS2010 build after commits:
Commit 2e4a3ca5e6f3cb11cce5d70f45f997f158d8f908 to mangos's mangos - GitHub
8f908
Commit 0833a9c56673966e0dc2b1f4517e9bcc310c5aa1 to mangos's mangos - GitHub
c5aa1
Fix crash in ActivateSpec
Fix SPELL_DAMAGE_CLASS_NONE hit result
Not counting gems at broken item for meta gem requirements.

This is fit as cleint show meta gem state and fix cheating with gems at
broken items.
Implement ITEM_MOD_BLOCK_VALUE support in item stat mods and
enhantments.
Some comments for realmd data.


313 i wrote that it's full db

[Harambeqt]

Also post all CL's in [code] [code]

[Dj Aligator]

Mangos 9679 - 9709
Some more research on spell attributes.
Create new table character_stats for external tools.

Added new config value to define whether it should be updated.

This table will only be updated on logout, not on periodic save.
Add config to decide whether character stats should only be saved 
on logout.
Fixed random base poinst part calculation

0 - unused, 1 -> always +1, other in ranges (rand...1) or (1..rand)
Update IsExplicitDiscoverySpell/IsLootCraftingSpell and related code.
Clarify areatrigger related tables loading errors.
Clarify areatrigger related tables loading errors.

(based on 330 commit 71c1d67)
Implement AURA_252
Drop dead code in 3.x for spell 29801. 
Add helper function to check if a string is numeric

(based on DasBlub's repo commit 1d5b209)
Remove outdated spell proc data and update code for 44394 and ranks.
Code style cleanups in quest code.
Implement support weekly quests cooldowns.

Part code provided by zhenya.
Add to mangos.conf options for daily/weekly reset time.

* Quests.Daily.ResetHour (0..23) for daily quests
* Quests.Weekly.ResetWeekDay (0..6) and Quests.Weekly.ResetHour (0..23) 
for weekly quests.
* Drop time from character_queststatus_daily and use same way as weekly 
quest reset time store.
Fixed typo in daily quest reset time init.
Merge branch 'master' into 330
Fixed typo in daily/weekly flags conflict check.
fix item 47670 spell proc event
Up to date mangos_spell_check old data and add some new.
Merge branch 'master' into 330
Now BG honor marks not reawrded in BG

* And related spells not create items.
* Update code for allow creat marks for single existed case: outfield bg
  that not yet implemented in mangos.
Switch to support client 3.3.3a (build 11723)

Merge branch '330'

You need regenerate dbc/map/vmap files.

Thanks to TOM_RUS who make most work for adding 3.3.3 support. ;)
Update spell 6572 and ranks for 3.3.3
Not crash in case unknown spell expected to be learned at spec 
switch.

It will output error insteed and continue.
Fixed typo in error output string.
Fix 16972 and ranks.

Thanks to vdpqtc and darkstalker.
Include changes from [9692] to characters.sql

mangos.sql part already updated.
Fixed .pdump work after 'data' drop.

Also add `character_talent` including to pdump
Also drop save `item_text` as not used in items/mails now after switch to 
3.3.3
Drop item text ids generation.

Now item text not used as independent object (real item texts associated 
with item guid)
Update comments for two quest flags.
Fix basepoints calculation
Drop now redundent `item_text` table.

* In beggining bad news: at 3.3.3 switch has been forgoted 
item_instance.data field chnage.
  In result items with texts (mail copy in to inventory, some other) lost 
  text content.
* That why in current commit item_text droped without convertion. In 
result all itesm with texts
  will lost text. Sorry for this as i think small porblem :(
* Now text stored in item itself.
Include in pdumps more tables.

* character_account_data and then will partly included macros/settings 
local for character.
       Mostyl used account wide macros not included.
* character_declinedname
* character_equipmentsets
* character_glyphs
* character_pet_declinedname
Add to achievement_reward support gender dependent rewards.

For example for achievement 1793
Fixed typo.

This fixes assert in Player::AddQuest when quest log is full.
Correctly update next daily quest reset timestamp in DB after 
reset.
Fixed typo added by Vladimir to patch in [9704].
Also add check to prevent have NONE gender with some other for same entry
in `achievement_reward` and `locales_achievement_reward`.
Compile fix under GCC.
 change case 0 handle for basepoints calculation


YTDB316
+ All fixes from forum;
+ spawn;
+ quest scripts;
+ mob's gossip menues;
+ new templates from WDB;
+ fix fields "item_template" by WDB;
+ fix fields "quest_template" by WDB;
+ fix spawn: The Violet Hold;
+ fix spawn: The Obsidian Sanctum;
+ fix spawn: Utgarde Pinnacle;
+ processed 56 caches (3.3.3);
- last for 3.3.2;

[Dj Aligator]

Mangos 9710 - 9748
Add gm possibilities reset talents for all specs.

* At login reset '.reset all talents' will reset all spec talents.
* New command '.reset specs' will reset its online/offline.
* Command '.reset talents' now not support offline player case.
Include in 9692_02_characters_mail.sql convertor for items.

It included in swith time sql update for use in cases not converted yes 
characters DB.
It can be not 100% safe used for already used in 3.3.3 mode chaarcters 
data.
BUT if you want you can use it at own choice ofc.

Fixed durability problem after switch. Converted non-bag items only.
Bags not have normally item text and durability.
Use enum for effect index
Update future release info in NEWS
Replace tab with spaces, just to make at least one push today.
Implement required basic elements for dual spec learn gossips.

Required DB data for real work. This is final part required at core side 
for support.

Also note that commit include

* generic implementation money cost gossip menu items so let
  implement in DB many money cost gossip operations with _fixed_ cost.
* useful CONDITION_SPELL that let implemtn menu item visible if specific
  spell known/don't known also wide used case for diff gossips.
Allow to vendor have same items in list with different extanded 
price.
Fixed [9716] sql update.
Grr... git_id tool corrupt old sql update (it drop sometime all except 
guards)
and i copy old not fixed version for restore :/
Use proper index for character_pet_declinedname in pdump code.
Drop very old item amount calculation hack code.

Use pre-calculated normal effect value as amount.
This also must fix recent item amount crafted items.
Implement Glyph of Siphon Life and fix Siphon Life proc
Updated high guids. Renamed few files. Added some comments.
Please include spell names in comments in code and and avoid its 
used in commit notes.
Finaly cleanup usage ventorslot values.

This is also fix recent showup problem buy items
from vendors in case when some items usable (and then show in list)
only for some class/races.
Temporary back to 0 player highguid.

This is resolve "none from players see each other" problem.
Please, reapply non-0 player guid only with or after this problem resolve.


Some ObjectGuid use cleanups added while reseach porblem source.
removed PlayerNotifier and related Map::UpdatePlayerVisibility 
function, used UpdateObjectVisibility instead

(based on SilverIce's repo commit e226019)
Note: this changes not affect in any good/bad way recent problem with 
player guids.
Restore map outdated format protection and copyright years.

Tom, please update in UpdateFields.h generator 2009->2010 ;)
Build equiped item data only for item's owner

This is must decrease amount of data send to network
at player enter to visibility radius for another player.

(based on SilverIce's repo commit 8c60a80)
Correct icon for one option in default gossip menu
Client not like vendor slot 0 so restore send slots counted from 1

This is must fix not selling first item in list by vendor.
Mail send related fixes in recent code.

* Avoid use explicit MailReciever/MailSender where not need.
  Types specially added for autoconvertion from common cases.

* Prevent allow copy text auction mails. It anyway store encoded data.
  Same for some another non-player mails.
Cleanup in skil steps code.

* Move step arg in SetSkill to end for make possible for it default value.

* Merge GetSkillStep function to SetSkill, base at fact that old 
GetSkillStep
  code can be != 0 only for already known spell, so at update
Remove another case hardcoded set skill step.

We not have currently way set proper set skill step at loading,
but this not required, because important only for new learned rank have 
different step.
Also drop outdated (as tested) comment.
Make Replenishment only affect its caster in arena
Removed outdated code for 33702,33697,20572
Fix proc for 53709 and ranks
Added more usable interface for grid visits

(based on SilverIce's repo commit f20f01e)
Fix number of ticks calculation for 53209 (1978 and ranks part)
Restore build on *nix

Also fix my typo in Unit::SelectRandomUnfriendlyTarget
Use local var value instead recalculation.
Update in comment indexes for SpellEntry

No real code changes.
Implement DOT related part of 54049 and ranks
Final cleanup in non proper now EffectBasePoints use.
fix spell_check.sql
Prevent adding .vsp files from VS10 to repo
Update equipment at aura transform apply/remove for creature case
Implement show realm version and build in realm list.

* Rename `realmlist`.`color` field to `realmflags`

* Client 2.x and later support show in realm list supported
  client version for specific realm.

  For client 1.x this implemented by adding version to name
  in similar way as it look in more recent clients.

  For enable version show each affected realm must have in `realmflags` 
  set
  flag 4.

  For realm work with not officially supported builds (build > last 
  suported)
  will show version 0.0.0 and correct build value.
Fixed bg template max/min per team values
Fixed startup problems after recent realmd DB.

[Dj Aligator]

Mangos 9749 - 9756
Partly revert "[9736] Added more usable interface for grid visits"

In part related broadcasts by explicit provided Map pointer (in different 
object GetMap() requested)

This is must fix recent crashes in Map::MessageBroadcast
Add structure of SMSG_REDIRECT_CLIENT (0x50D).

Thanks to TOM_RUS for help with research.
Add index by `spell` to `character_spell`

This is must fix porblem with long logins at
many broken spells in `character_spell` after client switch/etc.
Add storage for min/maxgold of gameobject
Add default value for parent-field in instance_template
Rename flight speed related auras and fix spell 40120
Possibility drop (hide infact) records from DBStore/SQLStorage.
Cleanups in `instance_template` and map entrance DBC data.
Fixed sql update version and related data
Avoid database query on tutorial save by caching tutorial state.



YTDB 317
+ switch 3.3.2 => 3.3.3a (templates/spawn/vendors)
+ all fixes from forum;
+ spawn;
+ quest scripts;
+ mob's gossip menues;
+ new templates from WDB
+ fix spawn: Utgarde Keep
+ fix spawn: Frozen Halls
+ fix spawn: Nexus
+ fix spawn: Azjol-Nerub
+ fix spawn: Ahn'kahet
+ fix spawn: Culling of Stratholme
+ fix spawn: Halls of Stone
+ fix spawn: Halls of Lightning
+ fix spawn: Hellfire Ramparts
+ processed 78 caches (3.3.3)




added 
realmd 3.3.3
characters 3.3.3

[vaniva]

thank keep it up

[Dj Aligator]

Mangos 9757 - 9774
Add triggered spell(strength buff) for 71904
Include SharedDefines.h to AchievementMgr.h for provided used enum 
type definition.
Comment cleanups related to spell base points use.
Add missing argument causing crash using .list obj, after change in 
[9663]
Restore .list object output.

No reason have different command output in chat and console
just because need fix crash.
 Init client build at reconnect (logout back to char list)

This fix bug with show all realms as offline at view relam list after 
logout.
Use min/max BG/arena levels from DBC. Update table content.

* Use min/mac level from dbc because anyway list real selectable
  for player level bg/arena backets set min/max range.
* Drop related fields and update per team min/max values.
Remove outdated code for 15286
Prevent crash at use .npc delitem to item with multiply extanded 
costs.
Remove outdated code for 54936
Add the posibility to keep deleted characters in the database for a 
while and also add related commands.

Added commands:
* .character deleted list [$guid|$name]
* .character deleted restore $guid|$name [$newname]
* .character deleted delete $guid|$name
* .character deleted old [$keepdays]

Command .character delete renamed to .character erase
Fixed my last sec. fix problem :/

Also make $/# in consistence in new command help texts.
Fixed typo in characters.sql.
Use more proper std::istringstream for parse args.

This must fix build problem at *nix.
Fixed typos in mangosd.conf comments
Make GCC happy and restore buuild at *unix now really.

Just for note: this still look as not code problem but GCC bug in C++ std. 
library.
Fixed typo in code comment.
Fix periodic damage combat log displaying

[Dj Aligator]

YTDB 319

+ All fixes from forum;
+ spawn;
+ quest scripts;
+ mob's gossip menues;
+ new templates from WDB
+ fix fields "item_template" by WDB
+ fix fields "gameobject_template" by WDB
+ fix fields "creature_template" by WDB
+ fix fields "quest_template" by WDB
+ fix spawn: The Culling of Stratholme
+ processed 112 caches (3.3.3)


Mangos 9775 - 9792
Cleanups in framework library.

* Removed last bits of threading in grid code.
* Removed some weird and unneeded declarations.
* General code style fixes.
* (Perhaps some things I forgot.)

Thanks to Lynx3d for the usual GCC-stabbing...
Set m_mover to NULL on remove SPELL_AURA_MOD_POSSESS by delete.

This should fix a related crash.
Fixed `instance_template` error output arg in one from cases.
Old gcc hash_map not have support for std::string keys.

In different from tr1 unordered_map
Drop trailing whitespaces.
Change CalcAbsorbResist/isBlocked to be called from target side
One more typo in instance_template loading error output.
Small clean up in 2 method names
Update 33851 and ranks according to 3.1.0 patch notes
Update 33851 and ranks according to 3.1.0 patch notes
Remove special dagger starting outfit amount.

Now DBC data provide special off-hand instead.
Also update structure comments.
Fixed crash at drop vendor items (anorther way).
Allow propertly remove attack speed buff/debuff at death.

Check wrong and redundent (not use in other similar auras).
If we use "debug bg" it must ignore that we are lonely on the bg.
Implement spell selection, for creatures in instances, based on map 
difficulty
No reason lost time at other checks if spell diff id not provided.
Fixed problem with character deleting at some server platforms.
Fix wrong damage dealing from commit [9784]

[Found]

Thanks for this, too bad some people have to leech around here.. Ah well +Rep x3 from m.

[Dj Aligator]

Mangos 9793 - 9818
 Add 'Logout Player' output to the Char.log
Implement ".account characters" command

Console/chat command output characters list for specific account.
Fixed sql update for avoid apply problems.
Implement CONDITION_INSTANCE_SCRIPT (mapid, some_id)

True if mapid fit to called instance map id and instance script confirm success 
for some_id case.
Controlled unit should be a source of movement packets, not 
player-controller.

Now movements of controlled unit are visible for nearby players,
even when controller too far from controlled unit

This new type of packet broadcasting used in HandleMovementOpcodes handler only,

maybe it can be used somewhere else.

(based on SilverIce's repo commit d2387ca)
Prevent interect with NPC/Gameobject player in non-react state

* (stun,confuse,fleeing).
* This also fix cheating with taxi use.
Implement basic splitting for caster/target part damage/heal bonus 
calculations, periodic damage/heal over time auras will now store m_amount with 
caster side bonuses applied and calculate target part on each tick. Currently 
critical chance/bonus calculations are not affected by this change
Remove duplicate code causing next reset of daily/weekly quests to double 
up
Not need explicit value numbering for internal server side enum
Typo in enum name.
Fix 17962 damage broken after [9798] commit
Fix typo in taken damage/healing bonus calculations and fix damage of 
64085
Add script effect of spell 52941
Fixed lost flight mount/form for GM in old contentes.
Fixed player loading to transport.

Bug exist already some time but possible hide by another code way work or
client change maybe.
Add some missing (dummy) opcode handlers to the list.
Simplify TaxiPathNodes data use, specially for transport case.
Drop dead code after switch.
Move pre-switch sql updates (except realmd related) to subdir.
Update/fix some opcode names.
Fix a typo.
Add VS2010 project files to git_id
Add filter files to VC100 projects

Its store file groupping info into projects.
Some cleanups in vc100 project files.

* More wide use $() for have same textual values for all build modes
* Fix NoPCH_Debug build.
Add script effect of spell 44462
Add dummy effect of spell 53808
Fix display bug when spell with more than 1 persistent area aura effect 
had several icons

YTDB 320
+ all fixes from forum;
+ spawn;
+ quest scripts;
+ mob's gossip menues;
+ new templates from WDB;
+ fix all fields "*_template" by WDB
+ fix loot of Archavon the Stone Watcher
+ processed 133 caches (3.3.3a)

[Dj Aligator]

Mangos 9819 - 9842
Rename some more opcodes.

Also fix the name of some older opcodes that were marked as obsolete but no 
longer are.
Fix some handlers (correctly use Handle_ServerSide).
Rename two more opcodes...
Fix link error in gcc after [9816] and include needed header
Really fixed link error in gcc after [9816].
Use in taxi flight movegen original taxipath data.
Rename one more opcode.
Fix spell 38736
Rename two more opcodes (related to projectiles).
Fix TARGET_AREAEFFECT_CUSTOM
Avoid redundent data copy in transport waypoints generation.
Implement taxi/transport event scripts support.
Fix type conversion in spell/healing bonus calculations
Move function to select an attacking target from EventAi to Creature 
class

Also rename function to a more descriptive name, SelectAttackingTarget
Allow TARGET_AREAEFFECT_CUSTOM to target invisible/not targetable npc if 
script target for them exists
 Fix damage bonus applying from 49471 and ranks to 49143 and ranks
Fix broken compilation after [9831]. Thanks to VladimirMangos.
Make log output code more consistent for diff build modes.

* Make possible have debug output if build in release mode.
* But preserver current optimization in avoid debug output args
  calculation if debug ouput disabled if done using DEBUG_LOG
* Implement in same way BASIC_LOG, DETAIL_LOG. Recommended use
  its instead explicit access to sLog
* Use variadic macros for DEBUG_LOG and other new defines.
  All supported VS/GCC have its support as C++ extension.
* Add DEBUG_FILTER_LOG and semilar defines for filered log output and use its.
* Also move recent added debug output for transport events under 
LOG_FILTER_TRANSPORT_MOVES
Remove calls to Taken part when its not used for damage dealing and fix 
HoT tick amount used in 18562 code(Thanks to insider42)
More log filters and macro uses.

* LogFilter_Weather
* LogFilter_PeriodicAffects
* LogFilter_PlayerMoves
* LogFilter_SQLText
* LogFilter_AIAndMovegens
* LogFilter_PlayerStats
Fix shadow damage part of 55090 and ranks
 Include Timer.h for getMSTime in SendMonsterMoveByPath
Really fix invisible target selection for TARGET_AREAEFFECT_CUSTOM
Remove a line of whitespace


YTDB 321

+ all fixes from forum;
+ spawn;
+ quest scripts;
+ mob's gossip menues;
+ new templates from WDB;
+ loot from Lich-King in Icecrown Citadel - H10/H25 (now all the loot in Icecrown Citadel)
+ processed 151 caches (3.3.3a)

[Dj Aligator]

Mangos 9843 - 9891
Restore need seelction show at loot roll.

Also some clanups including merge 2 roll type enum.
Fix some whitespace errors.
Fix dispel damage for 30108 and ranks
Restore work of 44745 and rank/s
 Add dummy effect of spell 50546, 50547 and 50548
Add script effect of spell 47393, 47615 and 47638
Implement character database clean up.

This can be disabled by config option.

Flag for clean up can be set for example on client version change.
Fixed target selection for area spells casted from aura at enemy.

* Spell::GetCastingObject must be use for selection visual/point cast,
  not for friend/enemy checks. Add extanded GetAffectiveCasterObject
  for proper provide for referecned checks wild gameobject casted case.

* Also support chain damage spells casted by gameobjects.
Restore work of 1856 and ranks
Disable forced alteration of specialFlags in quest_template at startup.

This will allow quest 10162 to work properly with the expected data in 
quest_template (no specialFlags is needed), but will still give a startup error 
for spell 33824.
Add dummy effect of spell 61832
Fix negative amounts for spell base damage/healing and fix heal effects 
to correctly benefit from heal increasing/reducing auras
Fix some sqls from prev. commit
Add dummy effect of spell 51840
Fix double damage dealing of 63625 and ranks. Thanks to Revils
Restore work of 1064 and ranks, broken in [9854]
Add dummy effect of spell 51964
Add script effect of spell 54182
Backporting some code chnages from 400 branch.

(based on 400's commit 0f37423)
(based on 400's commit 636cfef)
(based on 400's commit 0bbe3a7)
(based on 400's commit ce86b56)
(based on 400's commit b74c6a8)
Defines for some spelentry arrays.

* Move and rename MAX_REAGENTS to DBC Strcuture.h.
  It used only afore access to SpellEntry field and so part of strcuture 
  definition.
* Add MAX_SPELL_TOTEMS and MAX_SPELL_TOTEM_CATEGORIES for same reasons, and use 
in code.
Implement SPELL_EFFECT_BREAK_PLAYER_TARGETING (93)
Use proper arg for player name send.
Add support split damage for spells 66765, 67333.
Also small cleanup in mangos_spell_check.sql
More weapon damage split spells.
Prevent another potion drink until combat end.
Impliment glyph 42905.
Extend SCRIPT_COMMAND_QUEST_EXPLORED to allow player<->player as 
source/target

Additional code cleanup and output script id in error messages.
Add script id to all remaining SCRIPT_COMMAND_* error message outputs.

Note that script id can be id from different DB tables. It will however make it 
easier to find the source of any error.
More code cleanup and style corrections.
Implement movement impairing effects for spell 58875.
Replaced hardcoded value with enum.
Added some comments.
Drop outdated code for 18788
Fix auras with custom periodic damage not entering spell/melee bonus 
damage done methods
Fix immunity ignoring for delayed spells
Fixed TARGET_ALL_FRIENDLY_UNITS_AROUND_CASTER work

TARGET_ALL_FRIENDLY_UNITS_AROUND_CASTER expected seelction friendly targets
for spell caster around spell caster (so ignore original caster faction).
This meaning that for begative spell also selected friendly targets for
spell caster object.
One more meteor-like spell.
Set for client battleground weekend event world state.
Update battleground weekend world state at start/stop event.
Prepare world state inint packet data in more clean way.

* Avoid use hardcoded field amount values
* Avoid use world state update packets just after world state init packet
* Attempt make code look less horrible in general.
Add additional fields to *_scripts tables for storage of more data.

Currently not in use by any SCRIPT_COMMAND_* but we have secret plans to be 
revealed in the future!
Add support for mounts dependent from riding skill and location
Change SCRIPT_COMMAND_TALK to support CHAT_TYPE_* using enum ChatType

Making data consistent with other, similar tables like EventAI's text tables.
This convert existing data and also adds support for all chat types.
Code style fixes thx to hunuza & Wowka321
Added VS2010 projects for maps extractor.

(based on commit 211997d)
Implement new commands for account search

* .lookup account email, .lookup account ip, .lookup account name
* For new commands and for .lookup player versions use first arg as part of 
email/ip/name search
* Use similar output format for player/account lists.
Fix special mounts using in Dalaran
Party restore IsKnowHowFlyIn and add area arg
Extend features available for SCRIPT_COMMAND_TALK

* Allow other than Creature to talk.
* Add "buddy-talk", using creature entry in datalong2 (the npc who will do the 
talk instead of the original source). Value in datalong3 is how far to look for 
the buddy.
* Add data_flags making it possible to have conversations between units, 
controlling who does the talking and to whom, including make player do the 
talking when player is not already the source.

Notes and details are added in the comments for SCRIPT_COMMAND_TALK
Add TYPEMASK_WORLDOBJECT to enum TypeMask

Check typemask and replace a few dynamic_cast with more simple casts.
Implement *_scripts for creature_movement

New field script_id in creature_movement can be filled for each waypoint point 
and run the corresponding script from creature_movement_scripts.
Script_id can be any value and several points/creatures can share the same 
script (with limits of course, such as script depending on location and other 
factors).

DB projects are advised to move current text, spells and emotes data in 
creature_movement fields as these fields are strictly no longer needed and may 
be fully removed in the future.

YTDB 322

+ All fixes from forum;
+ fix spawn;
+ quest scripts;
+ mob's gossip menues;
+ new templates from WDB
+ fix loot in Vault of Archavon (Full)
+ processed 187 caches (3.3.3a)

[DONalex]

dont you have a full scriptdev2?
Or do i have to download all the sqls from the site?
I apreciate your work and thx