search

classicdb / database

Classic DB is a content database for CMaNGOS Classic: world, NPCs, objects, quests and so on.
https://github.com/cmangos/mangos-classic
Other
87 stars 56 forks source link

[Mob] Centipaar Worker (damage) #828

Closed Phatcat closed 8 years ago

Phatcat commented 8 years ago

The damage done by Centipaar workers were out of line with similar mobs of the same level and area. Brough to correct levels.

cala commented 8 years ago

Thank you. Fixed in [1322]. Please note that we are using incremental SQL updates files to avoid updating the whole DB dump file everytime.

Phatcat commented 8 years ago

so if I were to make this fix as an update, how would I put it`? this is my first time working with SQL.

I see it in the commit you've done, so UPDATE, SET and WHERE is basically how you do it?

cala commented 8 years ago

Yes, commits https://github.com/classicdb/database/commit/11ac74e5100bc3a3fa79909e75033568397333fb , https://github.com/classicdb/database/commit/cca1c6af0cfef3ae04257c5dcf97c532778cf85d and https://github.com/classicdb/database/commit/55889799f33ba8d143bd8ffaed1c6f8e955be5e0 are good example of how we create updates for the database. There are also more complex update files like: https://github.com/classicdb/database/commit/936a9f24060ad7d5f461f715d4eba169afd6f70e or https://github.com/classicdb/database/commit/bc0a7a9e0c082d6262aca7c7779e4cf71a7bba3a I hope that helps.