hunuza

item_instance is not only used by character_inventory but also by guild_bank_item, auctionhouse, mail_items...

Didn't try it but I think this should work:

DELETE FROM corpse WHERE player = GUID;
DELETE FROM character_aura WHERE guid = GUID AND (spell = 20584 OR spell = 8326);
UPDATE characters SET health=1 WHERE guid = GUID;

No, in case of holy >= 0, you don't need to do anything..

Did you try that commit? http://github.com/Lynx3d/mangos/commit/ca35635a767b52c99891581bd3f6bb303724d2f5

Do not post any links like that again.

There will be no support for any alpha clients on this forums.

Stop this. There will be no support for 4.0.0 in the near future...

It might be safe to delete skills when we display the error message that the skill does not exist...

But I plan to do a character database cleaner, that we can run on client switches etc.

Or simply use git revert...

Skill 40 is the poison skill that no longer exists since 3.0.2. You can safely drop those from the database...

That file is over 600KB, and it is in patch.mpq and common-2.mpq. Problem was that there was a 0-size file in another mpq.

I don't know which mpq is proper to pick data from, so do we just get one that has usable data? That's what my fix does.

Data in patch mpqs overrides data in common mpq. I think if they add file with size=0 they want to delete data from old mpq, without acutally editing the old mpq itself...

You also compile MaNGOS in 64bit mode?

You can either add it to character_stats or calculate it by equipped items...

Derex told me that he has finished the patch support, but he would need to update it for 3.3.3a and he is currently very busy...

No, currently we send the packet only to the person who used the command.

This should no longer be a problem as honor and arena points are stored in a separate column in characters table...

You could try this query: http://gist.github.com/361944

Accepted in [9696]. Thank you.

So you mean that dps = 0.004*lvl²+0.675*lvl? Well it's hard to say whether it should be quadratic or not, with only 3 points... Maybe somebody can provide us with more data?

Anyway I think that this discussion is not really related to original patch...

I am pretty sure that this flag is correct, but it should not only be checked for hunter+warlock pets, but also for e.g. ghouls pets.

I think this flag is also used when a NPC controls a player to decide whether it should use that spell or not.

I think it should either be level*1,03-7 or level*1,05-8,2.

Current code uses 1,05 coefficient, so I would tend to the second formula, but it would only give 21,2 dps on level 28 instead of 22. The first one would give about 21,8 dps on level 28.

But I asked somebody who plays on official servers and he had a base dps of 27,5 on level 34. In this case the first formula would fit better...

In the google cache thread you linked a level 28 druid has 17-27 base attack damage - that is 22 dps.

But (0.714+1.114)/2 * 28= 25.956 dps

Added new table character_stats in [9680].

Vladimir suggested to maybe add config to determine when to save (e.g. not only logout) which I consider to implement soon...

It's exactly what yasuno demanded -- showing real count in parentheses.

Name limiting to 49 is client side limitation that you can't avoid with MaNGOS.

Welcome Laise

What about Lynx3d btw?

I think saving that data in a character_stats table would be the best choice. You should be able to configure whether you want it to be saved or not (if you don't use the data you don't need to waste resources on saving it). Saving it on character logout should be sufficient.

Any other suggestions?