Dagguh

Yea, I'm runnin' on Lynx3d's fix for a few days now and the only wrong thing encountered were few mobs with uber low damage, but that's plainly DB's fault (e.g. http://www.wowhead.com/?npc=18131 dealing 1-2 damage). In conclusion: get raw values for your db from Seizer, apply Lynx3d's patch, and await/help with updates to the UDB (unit_classes and some mobs that are heavily off).

There is no problem in correcting the formula itself. You have used values calculated by me, and as you can see they work perfectly. However, we have a huge problem with obtaining the data for DB. There is no effective way to obtain these values for all mobs. You'd have to run around on official with 0 damage reduction get hit many times to probably get all the possible damage values (min-max range) and try that again with a weak AP debuff and a maximum one you can achieve. This is too much hard work, unless we get multiple "workers". The case of Maexxna was quickly solved thanks to the Beast Lore skill. http://www.wowhead.com/?spell=1462

So he'll remain with 192 AP. So a -192 DemoShout will decrease his DMG by 192 => his DPS by 96. Looking at tankspot, on official -414 DemoShout is not enough to bring his AP to zero (in fact 571 is needed) and even stripping him out of his entire 571 * multiplier AP would decrease his DPS by ~ 92. So a skill that is 3 times weaker here than on the official is stronger than the official. BTW. Are mobs that do not have any class going to receive it some day? You sadi yourself, that Jormungar is a Warrior, so unit_class should be = 1 Yea that amount of damage would be ridiculous,. So, you are going to fill DB with these pure values, and core forumla should be adjusted so that the output is blizzlike? If so, I'm gonna look into this tonight. For a temporary addition to my core revert, if anyone wants to play with AP buffs/debuffs working OK, I am updating my first post with a SQL "solution" which involves subjecting mindmg, maxdmg and attackpower values to minlevel.

I never calculated AP that is > 900. BTW. I didn't mean that baseattacktime needs changes, (even thought it might), the caluclated differences are negligible ( < 1%) and might come from precision errors. A series of question to Seizer. Please answer them, if you would be so kind: You say DB has correct AP values for mobs 1-81 and the rest is derived, do you mean 381 or the upcoming 382? Because on 381 e.g. Infesting Jormungar has 192 AP, and you said he should have 642. Are you planning to utilize dmg_modifier? Are you going to adjust DB data to match current core mob damage formula or do you consider the current formula right? Could you give me an example of min/max dmg, ap and multiplier for Maexxna that the next updatepack will use?

That is not what I meant. This is what I inferred from tankspot data. I can present you the math if you want. Also not that it is 571, not 574.

If data in tankspot is remotely true, this worm has to have 571 AP * multiplier, because a 571 debuff would strip it off all the AP bonus damage. Now assuming Seizer's data to be true as well, the dmg multilpier = 1.125 [HIGHLIGHT=cpp]571 AP 2010 baseattacktime 293 mindmg 439 maxdmg 1,125 multiplier[/HIGHLIGHT]

Excuse me, what hacks? And how do you know what values should they have? The values you are getting might be already processed. E.g. they already include AP.

Using data from tankspot and according to my calculations, Infesting Jormungar should have: [HIGHLIGHT=cpp]571 AP 2010 baseattacktime 339 mindmg 505 maxdmg 1 multiplier[/HIGHLIGHT] The AP contribution here is 16,26984 % Apparently the 70:30 proportion is not in power, at least not for 60+/70+/80+ level mobs. Wiki says it is a general distribution, and we all know that on higher levels, things work out a bit differently with mobs. @Seizer: Well, tehre are some discrepancies and this is understandable, because results coming from you and tankspot are a bit different, but that IMO is negligible. I infer that they might have some imprecise data.

This. This is everything I am trying to do here. And I can't stress it out more: this patch is supposed to work with original, blizzard values in DB and vastly needs DB support. Yes, of course. I was just reffering to Lynx3d, telling him that trying to manipulate with current DB data, will not fix things. This is what I was replying to, and you must agree, that it's not the way to do it.

Azure Mage Slayer is a Dungeon Elite and deserves that higher multiplier I was a bit surprised by the 40 factor as well, but after thinking about it for a while, you can see how Blizz made their job easier via this multiplier. They don't have to code AP buffs/debuffs differently for different mobs. Thanks to multipliers, they are useful against both trash mobs and bosses and still are not imbalanced. Gj Blizz. Yea, that would fix AP contribution, but would also mess up the min-max dmg influence terribly. Especially when now all creatures with unit_class != 0 and ap != 0 havbe theri min-max dmg divided by 7.

Works just fine.

Exactly. But it has indirect relevance Basic math: (a + b) * m = a*m + b*m If anything happens to b (dmg_from_ap), it happens m times harder. A player has a -1400 AP Demoralizing Shout. Mob A has multiplier = 1 and 1400 AP and attacks once per second => dmg_from_ap = 100 Players uses DS, mob loses all his dmg_from_ap => DS decreased the total dmg by 100 Mob B has multiplier = 40 and 1400 AP and attacks once per second => dmg_from_ap = 4000 Players uses DS, mob loses all his dmg_from_ap => DS decreased the total dmg by 4000 The same spell, but works with different power on mobs with different multipliers. Multipliers are here to make static ap buffs/debuffs work on hard mobs too. Nobody would even bother putting talents into Demoralizing Shout if it has worked 40 times weaker than currently.

Tested in the first place, didn't work.

Thanks for the link. Their research says that after stripping around 573 AP from boss, you cannot strip more, ergo it has ~ 573 AP. But you are forgetting dmg_multilpier, which is high on Bosses. My calculations (corresponding to formula presented on wowwiki): 32.8 AP reduction difference = 191 damage difference 574 total AP / 32.8 = 17.5 times a 32.8 AP reduction has to be stacked in order to make Maexxna have 0 AP 17.5 times AP reduction * 191 damage difference from this AP reduction = 3342.5 DMG coming from AP Assuming 2000 (2 sec) baseattacktime Before multiplier => 574 AP would give 82 DMG multiplier = 3342.5 / 82 ~= 40 With my patch applied Maexnna should have: [HIGHLIGHT=cpp]573 AP 2000 baseattacktime 405,5 mindmg 587,5 maxdmg 40 multiplier[/HIGHLIGHT] And it is not about arguing, it's about finding out the truth.

No, no, no... 720 AP in db table = 720 AP in core calculations. And that is bonus DPS that is = 51 in that case. -510 AP from Demoralizing Shout would make it 210 AP which makes the bonus DPS 15 instead of 51. BTW. If a Naxx boss has only 720 AP, that's just wrong data, it would mean that he has ~ 170 DPS * multiplier. Before my patch it would give him +720 DMG instead of +720/14 DPS adn that may be the cause of wrong data in DB. As I said earlier, no, and you cannot have negative AP. It is the same on mobs. Mobs are different from players only thanks to the dmg_muliplier. And it is 14 AP = 1 DPS , not the other way. If you want to add 1000 DPS via pure attackpower then yes, you'd have to add 14 000 AP, and yes, it would be a bad idea. Because you should increase mindmg and maxdmg too..... And that's all we need to do.

Changes in playerdmg was purely cosmetic. The /14 is needed, because it affects the way how do AP buffs/debuffs work on mobs. Without / 14 and having all mobs AP multiplied by 14 in DB, all players AP debuffs would be effectively 14 times weaker against mobs. It is better to keep formulas blizzlike. Attackspeed is directly relevant when considering DPS and DPS is relevant when considering AP.

Shouldn't it be urand(0,62832) / 10000 ?

Yeah, I thought it might be a revert. I was surprised to see this working that way, since Players get their damage calculated properly. Apparently someone messed up. Didn't know about ROUND(), thnx.

You can use PDO in your PHP to secure yourself from SQL Injections. He probably meant disabling access from remote machines.

You're wrong. It IS whole lotta easier. It's the hardest thing to convert, decode, operate on, especially for new users. Thanks, hunuza

It works perfectly now I'm getting Arcane Potency after my Clearcasts. Thank You EDIT: Please accept the second fix too.

Ah yes, I have applied this patch in the past, but since it haven't been accepted, it got lost as I always make a clean clone. Forgot to thank you and Naicisum for your work. Hope it gets accepted very soon.

Ok. Some more info: I noticed that they slide on the ground when they die really close to the mob they are running to. They don't reach him (the guy who is supposed to help), but they are in his aggro range (IMO). EDIT: It just happened with Syndicate Assassin almost reaching a Syndicate Enforcer to help.

Still, it sometimes doesn't work Oo Tested on Witherbark Trolls: http://www.wowhead.com/?npc=2557 http://www.wowhead.com/?npc=2556 http://www.wowhead.com/?npc=2555 Run for assistance and when they die in the process, they still slide and are unlootable afterward. Btw. when they DO get assistance, they come back at you, but walking instead of running. MaNGOS/0.13.0-DEV (* * Revision 7955 - *) for Win32 (little-endian) Using script library: ScriptDev2 (for MaNGOS 7951+) Revision [1120] 2009-06-04 22:51:38 (Win32) Using World DB: UDB 0.11.5 (380) for MaNGOS 7894 with SD2 SQL for rev. 1106 Using creature EventAI: ACID 0.1.0 - Full Release

You should emphasize the last line, as it carries rather high level of importance. You might want to make it bold and enlarge the font size.