Search results

-- 47119 Glenn Arbuckle DELETE FROM `creature` WHERE `id`=47119; INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`...

-- 46591 Colin Thundermar UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 46591; DELETE FROM `smart_scripts` WHERE (`entryorguid`=46591 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`...

-- 47121 Aquinastrasz flight master DELETE FROM `creature` WHERE `id`=47121; INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`...

-- 42536 Revantusk Stalker auras update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 42536);

-- 42518 Wildhammer Warrior auras update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 42518);

-- 48269 Dark Ranger update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 48269);

-- 721 Rabbit update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 721);

-- 883 Deer wrong auras update `creature_addon` set `auras` = '' where guid in (select guid from creature where id = 883);

Should not have instance flags in SAI as it causes console errors -- 15631 Spotlight UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 15631; DELETE FROM `smart_scripts` WHERE (`entryorguid`=15631 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`...

These creatures are not in an instance, They are out side, their scripts caused console error spamming, And was changed to non instanced scripts. -- 4284 Scarlet Augur 4285 Scarlet Disciple UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 4284; DELETE FROM `smart_scripts`...

Make a backup of your existing databases by right clicking and choose sql dump, Check the boxes next to drop and create first. These should be emucoach-auth, emucoach-char, And emucoach world databases, However they are currently named. Rename your old _Server Folder to _Serverbak Extract the...

Wrong target creatures, Broken spells. ect. -- 12676 Sabotage UPDATE `quest_template` SET `RequiredNpcOrGo1` = 28778 WHERE `Id` = 12676; -- 39165 Explosive Charges -- 52315 Place Charges -- 28778 Scourgewagon Bunny UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 28778...

This is still a little buggy, When a Geist harvests a blight crystal and runs through his waypoints, It seems to cause all of the Geists to despawn or die. It may be caused by the control spell hitting all of the Geists instead of just one. I set their respawn timer to 30 seconds to make up...

Mount and Rider. Fixes spawning, pathing, mounting, vehicleid, Spells, and scripts. and removes wrong spawns. -- 29863 Persistence UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=29863; UPDATE `creature_template` SET `VehicleId` = 203 WHERE `entry` = 29863; DELETE FROM...

-- 12663 Reunited -- 28666 Gorebag UPDATE `creature_template` SET `speed_walk`=2.4, `speed_run`=0.992063, `AIName`='SmartAI' WHERE `entry`=28666; DELETE FROM `smart_scripts` WHERE (`entryorguid`=28666 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`...

Ok this doesn't work exactly as intended, And i'm not sure that the grab and throw spells work at all. But it pre spawns a Gymer vehicle, So that when you click the non vehicle Gymer, It won't give you the invalid target error. The reason is because using summon creature or the summon Gymer...

-- 191548 Scourge Enclosure UPDATE `gameobject_template` SET `data2` = 120000 WHERE `entry` = 191548;

-- 29453 Vargul Plaguetalon UPDATE `creature_template` SET `InhabitType` = 4 WHERE `entry` = 29453;

-- 12914 Gymer's Salvation -- 41504 Banshee Essence DELETE FROM `creature_loot_template` WHERE `entry`=29646 AND `item`=41504; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (29646, 41504, -75, 1, 0, 1...

-- 28243 Thrym UPDATE `creature_template` SET `speed_walk` = 3, `speed_run` = 3.14286, `MovementType` = 2 WHERE `entry` = 28243;