Search results

There were six ores, Which is wrong, And they were a hundred feet high in the air. This places them on the ground, and adds them in all listed areas. -- 202740 Rich Pyrite Deposit DELETE FROM `gameobject` WHERE `id`=202740; INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`...

-- 45405 Master Sergeant Pietro Zaren DELETE FROM `creature` WHERE `id`=45405; INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`...

This is a workaround for non functioning area trigger. But it's better than autocomplete. Also the village was supposed to be dead and burning, this fixes that. -- 27349 Break in Communications: Dreadwatch Outpost -- 45345 Abomination -- 182090 Vector Coil Fire -- 6246 Areatrigger UPDATE...

Hmm, I fixed both of those a while back, Hope i still have that fix around. No actually I didn't. Whats going on is the C++ script for boss broggok is using out of date guid numbers for the objects and npc's involved, And needs to be updated. Exo will have to look into that.

It seems that some of the data in creature template bugged out when it was copied into the creature table. Deleting and reinserting these creatures makes them visible again. -- 4614 Martha Alliestar Invis Fix -- 4615 Katrina Alliestar Invis Fix DELETE FROM `creature` WHERE `id`=4614; INSERT...

-- 5662 Sergeant Houser missing text DELETE FROM `creature_text` WHERE `entry`=5662 AND `groupid`=0 AND `ID`=0; INSERT INTO `creature_text` (`entry`, `groupid`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `comment`) VALUES (5662, 0, 0, 'You...

-- 21419 Infernal Attacker UPDATE `creature_template` SET `modelid2` = 17312 WHERE `entry` = 21419;

Nothing about this worked. I gave it waypoints, But I can't seem to control how fast it flies. If anyone knows a fix for this, Just let me know. -- 27290 To Forsaken Forward Command -- 44365 Lady Sylvanas Windrunner -- 46032 Arthura -- 85869 Summon Arthura -- 84683 Ride Vehicle - Seat 1 spell...

No part of this quest worked. Everything is new. Worgen pathing is buggy, But quest can be completed. Worgens stop spawning once the player is out of line of sight from the control panel. And their also set to a 60 second despawn timer. -- 27232 The Waters Run Red... -- 45270 Hillsbrad Worgen...

Nothng worked, This Places the mortars, And missing creatures, And fixes everything. -- 14471 First Degree Mortar -- To increase visibility distance on your server edit worldserver.conf -- Visibility.Distance.Continents = 200 -- However this will not increase the range of the mortar -- 69280...

Missing Spawns, Missing Scripts, Missing Text -- 27231 Reinforcements from Fenris -- 27226 Hair Of The Dog -- 45196 Orc Sea Dog -- 60870 Barrel Of Explosive Ale -- 84514 Barrel of Explosive Ale Channeled Spell -- 84516 Barrel of Explosive Ale Player Buff -- 84511 Mortally Wounded -- 44916...

Removed the phasing from npc, And added it to spell area table. Added Backup shredders to phase 2 for quest. Added despawn timers to Talrendis Raiders, To stop potential server crash. Removed autocomplete from quest. -- Defend the Gates! 14146 -- 14155 Arborcide -- 66893 Grenade Launcher --...

This makes him close gossip immediately instead of showing an empty gossip box. -- 33266 Wounded Mor'shan Defender DELETE FROM `smart_scripts` WHERE (`entryorguid`=33266 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`...

This quest drops you in the middle of the lake, Instead of returning you to Forsaken High command. First I Increased the bats run speed to 2, Then I removed mmaps from him, Because mmaps seemed to causing his waypoints to fail. He would assume that I was at waypoint 21 and despawn, When i...

This is how you add a creature to the pool tables to simulate random spawning. It can also be done with gameobjects such as ores and herbs, But by using the pool gameobject table instead. Pay special attention to the section on creatures, It will show you the correct way to add new creatures to...

This should fix the crabs and their loot. -- 26177 Feeling Crabby? -- 42339 Canal Crab -- 57175 Canal Crab Item UPDATE `creature_template` SET `npcflag` = 1, `unit_flags` = 33536, `AIName` = 'SmartAI' WHERE `entry` = 42339; DELETE FROM `smart_scripts` WHERE `entryorguid`=42339; INSERT INTO...

This adjusts the overall Hp of the boats, Because the spell damage is extremely low. -- 48286 Wellson Supply Boat -- 48283 Wellson Cannon UPDATE `creature` SET `spawndist`='0', `curhealth`='50', `MovementType`='0' WHERE `id`=48286; UPDATE `creature_template` SET `MovementType` = 0...

Missing Trainer Spells -- 50001 Parata Priest Trainer DELETE FROM `npc_trainer` WHERE `entry`=50001 AND `spell`=-200005; INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES (50001, -200005, 0, 0, 0, 0);

25035 Breaking the Line Waypoints were extremely wrong and out of order. -- 38991 Bloodtalon Thrasher DELETE FROM `waypoints` WHERE `entry`=38991; INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES (38991, 1, -1286.36, -5553.36...

This sets the flags on all involved creatures, Sets the vehicle id for the Golem. And makes the general unattackable while he rides the golem. And upon golem death, The general becomes attackable. The query that adds the riflemen to the combat area is commented out, Because it should only be...