NPC Related Questions

[flickcorp]

1. Ok I have a couple npcs that should be laying down (2 in Valiance Keep) and they won't lay down how can I get them to.

2. For some strange reason I can't get Matt in Goldshire to equip a fishing pole.

3. How can I get the guards to stop and talk to me instead of them keep walking on.

4. Is it possible to enable mounts in other places other than Northrend and Outworld.

5. I got Footman Rob, Mitch, George, and Chuck and I would like to put beer mugs in their hand and have them drink out of it. I was able to get them to emote the eating/drinking now how would I go about adding the mug.

Thanks in advance

[Kiev]

1. This is done in "creature_spawns" for it to be permanent. Try and find the npc in there, despawn it, and then respawn, and it should be the last entry.

2. This again is the same, its a column in the database, access it via Navicat, SQLyog or Heidisql

3. That im not so sure off, im sorry. (Could be done with lua?)

4. That is through a custom patch, not sure how to do it anymore.

5. Same as the above (1, 2)

[flickcorp]

Thanks kiev for pointing it out I knew it was in one of the databases some where I've been familiarizing myself with them creating fixes here and there I have almost got valiance keep 100% done.

So you are saying to delete them and respawn them and they should start working again?

Now with the footmen I have spawned them to begin with because they were not present and it still didn't work. I haven't tried matt tho ill let you know.

[Ground Zero]

1. Ok I have a couple npcs that should be laying down (2 in Valiance Keep) and they won't lay down how can I get them to.

2. For some strange reason I can't get Matt in Goldshire to equip a fishing pole.

3. How can I get the guards to stop and talk to me instead of them keep walking on.

4. Is it possible to enable mounts in other places other than Northrend and Outworld.

5. I got Footman Rob, Mitch, George, and Chuck and I would like to put beer mugs in their hand and have them drink out of it. I was able to get them to emote the eating/drinking now how would I go about adding the mug.

Thanks in advance

1. Use modify bytes1 6 for the target to be lying down, (Try mod bytes1 (1-9) I can't remember it off by heart, do not modify bytes0/2/3 etc

2. Type .npc equip1 Fishing poleID 1

3. This only works with a gossip menu and only as long as the menu remains open.

4. Yes, you need to edit Unit.cpp before you compile your server.

5. Once again .npc equip1 (a mug id) 1

[stoneharry]

1. Use modify bytes1 6 for the target to be lying down, (Try mod bytes1 (1-9) I can't remember it off by heart, do not modify bytes0/2/3 etc

2. Type .npc equip1 Fishing poleID 1

3. This only works with a gossip menu and only as long as the menu remains open.

4. Yes, you need to edit Unit.cpp before you compile your server.

5. Once again .npc equip1 (a mug id) 1

^
This, but once you equip an item to a npc to make him hold it in his hand do .mod bytes2 1 on it. Also I believe bytes1 3 is for lying down.

[Ground Zero]

Thanks for the correction newb.

[faceroll]

Pretty sure it is possible

[flickcorp]

Thx everyone I'll let you know the outcome

[flickcorp]

Worked great guys (1,2,5) thanks alot here is the fixes if anyone needs them

/* Fixes Sleeping Recruits */
UPDATE `creature_spawns` SET `bytes1` = 3 WHERE `id` = 117790;
UPDATE `creature_spawns` SET `bytes1` = 3 WHERE `id` = 117789;

/*Adds Missing Footmen*/
INSERT INTO `creature_spawns` VALUES (DEFAULT,25258,571,2278.060303,5208.738770,12.494175,1.154537,0,23031,1973,0,0,0,1,423,0,0,0,0,0,0,15972,0,0,0,0);
INSERT INTO `creature_spawns` VALUES (DEFAULT,25259,571,2280.066895,5207.859375,12.494175,1.182016,0,23031,1973,0,0,0,1,423,0,0,0,0,0,0,15972,0,0,0,0);
INSERT INTO `creature_spawns` VALUES (DEFAULT,25260,571,2282.879150,5206.994629,12.494543,1.134892,0,23031,1973,0,0,0,1,423,0,0,0,0,0,0,15972,0,0,0,0);
INSERT INTO `creature_spawns` VALUES (DEFAULT,25261,571,2284.817871,5207.530273,12.494789,2.724542,0,23031,1973,0,0,0,1,423,0,0,0,0,0,0,15972,0,0,0,0);

/* Equips Matt With Fishing Pole */
UPDATE `creature_spawns` SET `bytes2` = 1, `slot1item` = 6256 WHERE `id` = 30;