How do i make npc as a vendor, and give quests?

[Salaramon]

I have npc and quest ready in my database. What is the npc missing? Or what is missing?

INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`, `isTrainingDummy`, `guardtype`, `summonguard`) 
VALUES (102001, 100, 100, 7, 1200000000, 1200000000, 0, 1, 129, 800, 0, 60000, 100000, 0, 0, 0, 0, 4294967295, 200000, 0, 0, 0, 0, 0, 0, 0, 0, '0', 1, 2000000000, 0, 0, 8, 16, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);

[Toffster]

You made this on wow-v? If so you need to make sure you ticked quest and vendor.

[Salaramon]

Y, i did make it on v-wow ^^. "ticket quest" ? where?
(I'm using arcemu.)

[Emanuel095]

You need to change the flags of the npc. Just go in-game and do, .npc flags 6 and that should work

[Salaramon]

I kno how to change it in database ^^.
Going to test now.

---------- Post added at 11:38 AM ---------- Previous post was at 11:32 AM ----------

I set the flag, restarted server. Spoke with the guy and he was just a quest giver not a vendor. I need the npc to be both ^^.

[Bloodprince]

Did you remember to make the quest etc on wow-v etc and quest item it gives and so on ??

[I Hypnotoad I]

ArcEmu?

I hope you remembered to 'Link' the NPC to the quest via a field in the 'Quests' DBC.
Otherwise he won't have a nice ol' quest for you.

[Salaramon]

I think i know what i need, i need a flag that is for gossip quest and vendor. I used .npc info on a npc with quests, some training and, vendor. And then it came up with a flag for that.
So i think i need a flag just for, gossip, vendor and quest. Anyone know the flag number, or an npc that only is vendor and quest giver?

[Matis02]

Remember These please. Just add them together to make multiple flag requests.
e.g. Quest giver and trainer: 1+2+16=19 (the 1 is for gossip if you want that)

1        = Gossip
2        = Quest Giver 
4        = Unknown 
8        = Unknown 
16        = Trainer 
32        = Class Trainer 
64        = Profession Trainer 
128        = Vendor 
256        = Ammo Vendor 
512        = Food Vendor 
1024        = Poison Vendor 
2048        = Reagent Vendor 
4096        = Repairer 
8192        = Flight Master 
16384        = Spirit Healer 
32768        = Spirit Guide 
65536        = Innkeeper 
131072        = Banker 
262144        = Arena Charter 
524288        = Tabard Vendor 
1048576        = Battle Master 
2097152        = Auctioneer
4194304        = Stable Master 
8388608        = Guild Bank

[shadowknight513]

Remember These please. Just add them together to make multiple flag requests.
e.g. Quest giver and trainer: 1+2+16=19 (the 1 is for gossip if you want that)

1        = Gossip
2        = Quest Giver 
4        = Unknown 
8        = Unknown 
16        = Trainer 
32        = Class Trainer 
64        = Profession Trainer 
128        = Vendor 
256        = Ammo Vendor 
512        = Food Vendor 
1024        = Poison Vendor 
2048        = Reagent Vendor 
4096        = Repairer 
8192        = Flight Master 
16384        = Spirit Healer 
32768        = Spirit Guide 
65536        = Innkeeper 
131072        = Banker 
262144        = Arena Charter 
524288        = Tabard Vendor 
1048576        = Battle Master 
2097152        = Auctioneer
4194304        = Stable Master 
8388608        = Guild Bank

When making an NPC with more than one flag, it is best to ALWAYS flag them with "1" (Gossip) to prevent errors. WoW-V says so themselves when making an NPC.

[Matis02]

Correct......

[Aellya]

Actually arcemu has been throwing errors on gossip flags a lot latey. If npc's cannot be interacted with, removing that flag generally helps.
Gossip means the window with text NPCs can offer, like on a Inn keeper where you choose if you want to browse his goods or set your heartstone.

In this case, the correct flag for vendor+quest giver is 1(gossip)+2(Questgiver)+128(Vendor) so = 131.
Should the infamous gossip bug strike, you can also set it as 130 and it should work again, however, then people must do the quest before they can open the vendor interface, as the NPC no longer can give you the option to choose.

So:
Update creature_proto set npcflags=131 where entry=THEIDOFYOURNPC;

[Salaramon]

Thx for help Walshie and Aellya, rep+ to both . Rep+ to you Walshie later when i can rep you for second time^^