creating quest help

[jackthripper]

ive never tried making a quest b4 so i thought i would start simple. "go kill a bunch of these, some back and get a reward." i made the questgiver, mob, and quest sql but when i add the sql and start up the server... the npc has no quest. the only thing i can think of is the faction of the questgiver is wrong or zone id is wrong. maybe you have thoughts.

INSERT INTO `quests` (`entry`, `ZoneId`, `sort`, `MinLevel`, `questlevel`, `Type`, `RequiredRaces`, `RequiredClass`, `srcItem`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `CompletionText`, `IncompleteText`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqKillMobOrGOId1`, `ReqKillMobOrGOId2`, `ReqKillMobOrGOId3`, `ReqKillMobOrGOId4`, `ReqKillMobOrGOCount1`, `ReqKillMobOrGOCount2`, `ReqKillMobOrGOCount3`, `ReqKillMobOrGOCount4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewMoney`, `RewXP`, `RewardMoneyAtMaxLevel`, `RequiredQuest1`, `RequiredQuest2`, `RequiredQuest3`, `RequiredQuest4`, `IsRepeatable`, `bonushonor`, `rewardtalents`, `suggestedplayers`, `RequiredTradeskill`, `RequiredTradeskillValue`, `RequiredRepFaction`, `RequiredRepValue`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepFaction6`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewRepValue6`, `rewardtitleid`, `CastSpell`, `RewRepLimit`) 
VALUES ('999905', '0', '284', '1', '1', '0', '-1', '-1', '0', '0', 'Cough It Up !!!', '$N, you must help Marklar and the Murlocks.', 'Those nasty Money Pigs that roam the hills got their nose into our money bags. They ate a good chunk of our Gold. I want revenge. Go kill 20 of those blasted animals and report back to me.', 'Good work $C. Now go gamble your life away.', 'What are you doing here? get back to killing!', '0', '0', '0', '0', '0', '0', '0', '0', '999903', '0', '0', '0', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '80010', '0', '0', '0', '100', '0', '0', '0', '1000000', '5000', '1000000', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '95', '0', '0');
INSERT INTO `creature_quest_finisher` (`id`, `quest`) 
VALUES ('999904', '999905');
INSERT INTO `creature_quest_starter` (`id`, `quest`) 
VALUES ('999904', '999905');

[Ground Zero]

Did you remember to set your NPC as Quest giver flags?

[jackthripper]

oops. whats the flag for quest giver. 3.2.2.

[jackthripper]

i figured it out with ur help Ground Zero. the flags for quest giver is 2

here are some more in case ppl need them

1... Guide-Always lable your NPC with this.
2... Quest Giver
16... Class Trainer
128... Vendor
4096... Repairer
8192... Taxi
1634... Profession Trainer
32768... Spirit Healer
65536... Binder
131072... Banker
262144... Charter
524288... Tabard Vendor
1048576... Battle Master
2097152... Auction House
41844304... Stable
8388608... Guild Bank