Northshire Peasant walks through a tree then takes a perpetual break
Location: Northshire Abbey
Coordinates: -8840.38, -271.402, 80.9516
NPC: Northshire Peasant GUID: 80119
Whilst in Northshire (on my own MaNGOS Zero game server), I noticed one of the peasants was doing nothing, other than staring at a tree with a load of logs on its shoulders. It refused to do anything else.
I left my toon looking at the spot. Rebooted the server, and went back in game.
After a short while I saw the Northshire peasant walk towards its tree, destination of work. It came on to the tree from the opposite side to where it needed to do its chopping. That did not bother the peasant. He just walked straight through it, then turned around and faced the tree and assumed the holding logs on shoulder pose.
I acquired the peasants guid (80119), then searched for it in the database.
Two locations found that relate to this situation:
creature table
creature_movement table
There was only 1 record in the creature_movement table for this NPC. I searched the table again, this time using the GUID of a peasant who was doing as it should, and noticed it had many entries (records) in the creature_movement table. Obviously each representing a destination within the path/route.
So, I reasoned that either our confused peasant has not had its path defined properly, or that it is not supposed to move around, and just stay there chop, chop, chopping.
I logged on to a popular private server to see what this NPC did on there, and as I thought, it was just chop, chop, chopping away. Never moving.
So, my proposed fix results in the NPC being spawned in place, facing the right way, and in the position to start his life of chop, chop, chopping, and singing dodgy songs about women's clothing.
Pointless having him walk there, seeing as the likelyhood of anyone witnessing it, is minute.
[SIZE=3]FIX (SQL Script):[/SIZE]
creature table
UPDATE mangos.creature SET position_x = -8840.38, position_y = -271.402, position_z = 80.9516, orientation = 1.12229, modelid = 308 WHERE guid = 80119;
creature_movement table
UPDATE mangos.creature_movement SET orientation = 1.12229, model1 = 308 WHERE id = 80119;
(BEFORE FIX) IMPATIENT LUMBERJACK CAN'T BE BOTHERED TO WALK AROUND A TREE
[IMG]http://chuckyworld.co.uk/MaNGOS/Issues/Database/ImALumberjackAndImNotOkay/NorthshirePeasantWalksThroughATree.jpg[/IMG]
(BEFORE FIX) OUR CONFUSED LUMBERJACK
[IMG]http://chuckyworld.co.uk/MaNGOS/Issues/Database/ImALumberjackAndImNotOkay/NorthshirePeasantDoesNothing.jpg[/IMG]
(AFTER FIX APPLIED) FINALLY, WE HAVE HIM CHOP, CHOP, CHOPPING AWAY :D
[IMG]http://chuckyworld.co.uk/MaNGOS/Issues/Database/ImALumberjackAndImNotOkay/NorthshirePeasantHardAtWork.jpg[/IMG]
Recommended Comments
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now