ProjectSkyfire/SkyFireEMU — Issue #145: Start Up erros: creature_addon & creature_template_addon
Author: burnham
Created: 2012-02-01 23:41:19+00:00
State: open

Hi comunity, please use this to fix creature_addon & creature_template_addon. This will remove hundreds of errors.

-- Updating addons to new format
UPDATE `creature_addon` SET `auras` = REPLACE(`auras`,' 0','');
UPDATE `creature_template_addon` SET `auras` = REPLACE(`auras`,' 0','');
UPDATE `creature_addon` SET `auras` = REPLACE(`auras`,' 2 ','');
UPDATE `creature_template_addon` SET `auras` = REPLACE(`auras`,' 2 ',' ');
UPDATE `creature_addon` SET `auras` = TRIM(`auras`);
UPDATE `creature_template_addon` SET `auras` = TRIM(`auras`);