Schmoozerd

fix this unexpected error; there must be some logs in the directory into which mysql was installed

the core updates are self-protecting, to prevent double applying. UDB delivers a collection of the mangos sql updates with each updatepack, so they are only there to make yourself the life easier(1) so, it doesn't matter if you apply the updates from mangos or udb(or another db-provider providing them), they are the same. Which updates you need, you can always see when checking the db_version table (for world-database) or character_db_version table (for characters database) (1) depending on the changes of the core fixes, you might get problems when trying to apply an updatepack to some (for this updatepack's view) future or past db_version hence the suggested way to apply is xyz_corepatch_mangos.sql xyz_updatepack.sql xyz+1_corepatch_mangos.sql xyz+1_updatepack.sql ... apply all remaining sql-updates from MaNGOS sql/updates folder, to be up-to-date <update-process then> apply remaining sql-updates from MaNGOS, to be on finish stand of zyx_corepatch_mangos.sql apply zyx_updatepack.sql ...

not really, in my view the main problem that the target for spell-casts is not set properly, which is also described in the threat you linked (not related to movement of bosses)

thaddius dosn't move, and preferes melee targets archimonde has some special attack in case no one is within melee range, at least this is current implementation within sd2, I cannot tell how good/ bad this is

an easy way to test crashes should be doable with gm commands; take any GM command which requires at least one placeholder, and change this GM command in the command table temporarily to not use a placeholder, then your core will crash when using this command.

yes, guides will be updated "soon" - this is that I got this funny purple color for

you must apply the sd2 one compatibility patch within the ScriptDev2 directory, and not the MaNGOS base directory; any further discussion however should be moved on SD2 forums.

hmm, on the system I am currently I get some information, so maybe I just missed it the other day; thanks for testing

the time difference in ms since the update functions had been called last.

I think that with recent update, now there is no more notification for new PMs (like PM(1) ) or similar

I doubt this very much.. IF I understand it correctly, the spells work on two npcs and both firing their laser-salves around, so I guess the spell_script_target is no dummy npc, but the other npc triggering the laser salves.. (Reason: Neither Devourer, CThun nor Lurker use any dummy npc)

orientation is something else than visual effect.. you need to add to the spell that is triggered (every 200ms or so) some setOrientation codes- if this spell is the spell from devourer of souls, you actually need to send movement messages with SPLINETYPE_FACINGANGLE and additionally need to setOrientation Actually I don't know what the scriptTarget(effect0) is used for, this would be a slightly new case for me from first looks

they aren't ignored, this is a (wotlk-) client restriction, there is some patch in core-mod section which might still be usable

this means, you need to add a SpellProcEvent (hardcoded by spell-id) to DummyAura proc Edit: see SpellAuraProcResult Unit::HandleDummyAuraProc

What bug does the patch fix? What features does the patch add? Add some better support for GO-locked and GO-nonInteractive Add command to toggle these flags For which repository revision was the patch created? 11556 Is there a thread in the bug report section or at lighthouse? If yes, please add a link to the thread. doubt it Who has been writing this patch? Please include either forum user names or email addresses. me http://paste2.org/p/1441453 1. Part: - Rename GO_FLAG_UNK1 to GO_FLAG_NO_INTERACT - Prevent restoring Locked-flags in GO-"respawn" in instances (will make the combat door at boss-thermaplugg fixable) - Additional Safeguards preventing exploits for non-interact or despawned GOs (for direct player use) 2. Part: Add a new command to play with GO_FLAG_LOCKED and GO_FLAG_NO_INTERACT with DB-Scripting. (I have especially the events in Zul'Aman related to the time-reward chests in mind)

partly related. I guess we simply must extend DoCastSpellIfCan to set caster's targetGuid to be the spell-target (in case of successfull casting without triggered) and then prevent to call AttackStart while mobs are casting (this is at least also here in SelectHostileTarget) Main problem I atm see are AoE spells which have self as target, what happens for them? (target self, or target empty)? Also there might comeup problems with getVictim which is afaik the one in targetGuid

As I truely love paint, this should help you: http://imageshack.us/photo/my-images/844/sincos.png/ (remark that the wow-coordinate system is quite crazy, so 0-degree means towards south (I think) ) Edit: From memory: to eastern should be angle alpha = Pi/2, to the western side should be angle alpha =3/2*Pi

ensure you have no untracked files in the directory and subdirectory, delete your files (except .git directory) and then reset --hard this should solve your issues.

Update your SD2, SD2 is atm at rev 2129

ah, yes, my typo A(10537) is less than B(11489) so ofc you need to apply all files that are bigger than A (10537) the first then would be: 10551_01_mangos_spell_proc_event.sql

the smoothest way is to copy all files that are _bigger_ than 11489 into a temp folder, and then use for f in *_mangos_*; do mysql -uUsername -pPassword mangos < $f; done

hmm, perhaps a wild guess, but are there any knockback effects that knockback players in water? Edit: No this not the case, however players in water should not be knocked back as far as player on land

Likely related spells: 37429 5min dureation, periodic trigger, 200ms, triggers 37433 37430 same, except can be used while stunned 37433 AoE TARGET_IN_FRONT_OF_CASTER - has effect knockback and damage 37431 ScriptEffect, self cast, 3s casting time 42581 5 min duration, periodic trigger, 200ms, triggers 42584 (remark other visual than 37429) 42582 same spell.. 42584 AoE TARGET_IN_FRONT_OF_CASTER - has knockback effect ******* also triggers 42835 on self 42835 AoE TARGET_IN_FRONT_OF_CASTER - damage effect I am pretty sure, that there was a fix for one of the knockback or dmg spells to ignore enemies in water recently, but I cannot find it

for mangosscript.dll (Scripting Library) you need to compile ie ScriptDev2 (www.scriptdev2.com)

first crash - Pet.cpp on my core break; and this wasn't changed since core rev 11490. Also the line which crashes for you (like "Not controlled pet"...) doesn't exist in clean core So this is clearly related to custom code