Minor fixes

[vanokron]

It's more cosmetic fixes for the database.
If you want, I'll post more queries SQL. Maybe in a more convenient format for you?
http://filebeam.com/2b42f8b7c0deb43fb7bac449a30596f3
Quest does not work quest=8346

 

[kamui2040]

A bit more info on what you have fixed would be great though.

 

[Zafire]

I have inspected some of them and the updates seem accurate.
Thank you for your contribution!

Zafire

 

[vanokron]

OK, when I make corrections for DB, sign more accurately.

 

[Zenc]

Very kind of u to contribute to bug fixes very nice thanks bud. Just as they said. When posting fixes, make sure to write details of what u have done and what it will fix.

 

[vanokron]

-- Lexington Mortaim - Remove duplicate creature
DELETE FROM `creature` WHERE (`guid`=65568);
-- Bethor Iceshard - Remove duplicate creature
DELETE FROM `creature` WHERE (`guid`=65567);
-- Luther Pickman - Remove duplicate creature
DELETE FROM `creature` WHERE (`guid`=65610);
-- Kaal Soulreaper - Remove duplicate creature
DELETE FROM `creature` WHERE (`guid`=65608);
-- Martha Strain - Remove duplicate creature
DELETE FROM `creature` WHERE (`guid`=65595);
-- Godrick Farsan - Remove duplicate creature
DELETE FROM `creature` WHERE (`guid`=65572);
-- Kaelystia Hatebringer - Remove duplicate creature
DELETE FROM `creature` WHERE (`guid`=65574);
-- Pierce Shackleton - Remove duplicate creature
DELETE FROM `creature` WHERE (`guid`=65593);
-- Ophelia Montague Banker - Remove staff from hands
DELETE FROM `creature_equip_template` WHERE (`entry`=4550);
-- Water Barrel - Remove trash game object
DELETE FROM `gameobject` WHERE (`guid`=289743);

 

[xaryon]

I might get flamed for asking this, but how to implement those fixes? just download and replace old files or...?

 

[Zafire]

I might get flamed for asking this, but how to implement those fixes? just download and replace old files or...?

• Download a software called "HeidiSQL", download the latest version.
• Open the .SQL files with HeidiSQL and click on the "play" button to execute.
• Restart your worldserver for effect.

 

[xaryon]

Thx, I just used those fixes using that program, went smoothly It would be a good thing to upload all minor fixes in this thread.