Search results

Blackrock depths min level is 42 (server was set at 50) REPLACE INTO `access_requirement` (`mapId`, `difficulty`, `level_min`, `level_max`, `item_level`, `item`, `item2`, `quest_done_A`, `quest_done_H`, `completed_achievement`, `quest_failed_text`, `comment`) VALUES (230, 0, 42, 0, 0, 0, 0, 0...

Two missing spawns from Razorfen Downs -- https://www.wowhead.com/classic/npc=8567/glutton SELECT MAX(guid)+1 into @var FROM creature; INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`...

Hi All, Back after a long break due to moving home and a new addition to the family. Stratholme Service Entry (EAST) > Bug when dead. There is no linked graveyard so teleported to first (playing horde) which is The Crossroads Barrens Stratholme East is 5917. There is an entry 5916 which maybe...

Quest & Spawns for quest https://www.wowhead.com/quest=27069/steel-thunder There are sea dog crates (gameobjects) spawned but the quest according to the DB info and wowhead requires a npc Orc Crate. Therefore modified the faction and spawned 5 crates. Tested & working fine. Just seems strange...

quests https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer -- missing npc https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer (pc will rephase later but not spawned in first phase) https://www.wowhead.com/quest=27462/to-take-the-barracks -- missing npc...

I deleted the character in question and used a backup restoration from a previous week so a little loss of progress. Problem solved. Thx for the return.

A great piece of work even more so if you take into account the task required. Well done ! :)

Missing spawns https://classic.wowhead.com/npc=11058/fras-siabi missing npc https://www.wowhead.com/npc=10516/the-unforgiven missing npc https://www.wowhead.com/npc=10558/hearthsinger-forresten missing npc https://www.wowhead.com/npc=10808/timmy-the-cruel missing npc Unneeded spawn...

Not working yet as the smart script fix for some reason is not working - posting to see if better/cleverer people can spot the problem and fix it. I posted a temp work-a-round solution below Quest *** NOT WORKING fix for the moment *** https://www.wowhead.com/quest=27089/ace-in-the-hole -- no...

Quests https://www.wowhead.com/quest=24960/the-wakening -- missing npcs -- https://www.wowhead.com/quest=24960/the-wakening -- missing npcs -- https://www.wowhead.com/npc=49230/marshal-redpath -- https://www.wowhead.com/npc=38895/lilian-voss -- https://www.wowhead.com/npc=49231/valdred-moray...

Modified. Thx. Typo error :)

Quests https://www.wowhead.com/quest=26312/crumbling-defenses quest missing npcs -- https://www.wowhead.com/npc=42788/hargoth-dimblaze-relieved missing npc -- https://www.wowhead.com/npc=44352/tawn-winterbluff-relieved missing npc -- https://www.wowhead.com/quest=26312/crumbling-defenses quest...

Quest https://www.wowhead.com/quest=25758/a-gap-in-their-armor -- quest loot missing https://www.wowhead.com/item=55809/twilight-armor-plate from https://www.wowhead.com/npc=41030/twilight-dragonkin-armorer Not important as armor items are also on the ground. --...

I'm playing questing etc. and then when I encounter something I check and try to rectify it. Apart from spawns most changes are done via HeidiSQL and even with spawns I then use HeidiSQL to export the SQL code. Apart from that, I use wowhead as reference and my own memeory from the official (I...

Missing NPC spawn https://www.wowhead.com/npc=49003 -- missing npc (not necessary for quest as you can fly directly, but npc missing nevertheless) -- https://www.wowhead.com/npc=49003 -- missing npc (not necessary for quest but missing nevertheless) SELECT MAX(guid)+1 into @var FROM creature...

Corrected. Small typo DSELECT instead of SELECT. You may want to delete the new spawns (highest GUID, map 564) from the creature table before re-runnning or you'll have doubles.

Quest: https://www.wowhead.com/quest=29570/rescuing-the-expedition (missing npc & event Claw not working) -- https://www.wowhead.com/quest=29570/rescuing-the-expedition (missing npc & event Claw not working) -- https://www.wowhead.com/npc=17885/earthbinder-rayge (missing spawn) SELECT...

https://www.wowhead.com/quest=27511/the-thrill-of-discovery -- switch incorrect npc hidden markers for quest Quest worked before just that the markers were reversed. -- https://www.wowhead.com/quest=27511/the-thrill-of-discovery -- switch incorrect npc hidden markers for quest UPDATE creature...

Well done by connecting. You can just select the world database (make a copy first as suggested above just in case) and copy paste the code above into a querie (tab marked query) and run it. (Run button is the blue arrow). As you can see I have some backup DBs. Simplistic guide but I'm sure...

A lot of these are not fixes, just work-a-rounds so players can advance as closely as possible to the original (quests etc) while real fixes are found and tested. As for applying the fixes look for the guides and help here in the forum. I'm sure there are some posts on how to run SQL queries...