Emucoach Announcement | MoP Premium 4 Release Date | Cataclysm VIP 17 Release Date | Happy New Years!
What's new

How to make daily quests!

lissandra

lissandra

Verified Member
11
2019
0
Code: 
# Default
INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('QUEST ID', '80', '80', '4812', '62', '0', '4096', 'REWARD ID', 'AMMOUNT', '631', '-355.011932', '2211.669189',
'3.149650', 'QUEST TITLE ', 'QUEST OBJECTIVE', 'QUEST DETAILS', 'COMPLETE QUEST TEXT', 'NPC ID', 'AMMOUNT KILLS FOR NPC', '12340');


# ICC Daily Quests Model
INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77777', '80', '80', '4812', '62', '0', '4096', '49426', '5', '631', '-355.011932', '2211.669189', '3.149650',
'Lord Marrowgar', 'Kill Lord Marrowgar', 'Kill Lord Marrowgar in Icecrown Citadel, and return to me.', 'Good Job! Next you will be facing Lady Deathwhisper, Goodluck you will need it.', '36612', '1', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77776', '80', '80', '4812', '62', '0', '4096', '49426', '5', '631', '-599.832031', '2211.700928', '3.141403',
'Lady Deathwhisper', 'Kill Lady Deathwhisper', 'Kill Lady Deathwhisper in Icecrown Citadel, and return to me.', 'Good Job! Next you will be facing Deathbringer Saurfang, Goodluck you will need it.', '36855', '1', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77775', '80', '80', '4812', '62', '0', '4096', '49426', '5', '631', '-531.528931', '2211.397705', '6.268458',
'Deathbringer Saurfang', 'Kill Deathbringer Saurfang', 'Kill Deathbringer Saurfang in Icecrown Citadel, and return to me.', 'Good Job! Next you will be facing Festergut, Goodluck you will need it.', '37813', '1', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77774', '80', '80', '4812', '62', '0', '4096', '49426', '5', '631', '4267.919922', '3137.260010', '4.677480',
'Festergut', 'Kill Festergut', 'Kill Festergut in Icecrown Citadel, and return to me.', 'Good Job! Next you will be facing Rotface, Goodluck you will need it.', '36626', '1', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77773', '80', '80', '4812', '62', '0', '4096', '49426', '5', '631', '4383.228027', '3026.663818', '0.051922',
'Rotface', 'Kill Rotface', 'Kill Rotface in Icecrown Citadel, and return to me.', 'Good Job! Next you will be facing Professor, Goodluck you will need it.', '36627', '1', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77772', '80', '80', '4812', '62', '0', '4096', '49426', '5', '631', '4356.811035', '3224.969482', '1.563081',
'Professor', 'Kill Professor', 'Kill Professor in Icecrown Citadel, and return to me.', 'Good Job! Next you will be facing Blood-Queen, Goodluck you will need it.', '36678', '1', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77771', '80', '80', '4812', '62', '0', '4096', '49426', '5', '631', '4577.146973', '2769.327881', '6.269732',
'Blood-Queen', 'Kill Blood-Queen', 'Kill Blood-Queen in Icecrown Citadel, and return to me.', 'Good Job! Next you will be facing Sindragosa, Goodluck you will need it.', '37955', '1', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77770', '80', '80', '4812', '62', '0', '4096', '49426', '5', '631', '4343.884766', '2484.039307', '0.007052',
'Sindragosa', 'Kill Sindragosa', 'Kill Sindragosa in Icecrown Citadel, and return to me.', 'Good Job! Next you will be facing The Lich King, Goodluck you will need it.', '36853', '1', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77769', '80', '80', '4812', '62', '0', '4096', '49426', '5', '631', '515.172761', '-2124.340332', '3.152285',
'The Lich King', 'Kill The Lich King', 'Kill The Lich King in Icecrown Citadel, and return to me.',
'Good Job! You have completed Icecrown Citadel and therefore you will receive "The Kingslayer" and 25 man Icecrown is unlocked.', '36597', '1', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemId2`, `RewardItemCount1`, `RewardItemCount2`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77768', '80', '80', '4812', '62', '0', '4096', '31535', '40216', '10', '0', '0', '0', '0',
'They will see you!', 'Kill The Watchers...', 'The Secret in Their Eyes.. Kill 22 Citadel Watchers in Icecrown Citadel, and return to me.',
'Good Job! You have completed this quest and therefore you will receive your reward.', '31787', '22', '12340');

INSERT INTO `quest_template` (`Id`, `Level`, `MinLevel`, `ZoneOrSort`, `Type`, `RewardHonorMultiplier`, `Flags`, `RewardItemId1`, `RewardItemCount1`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`,
`Objectives`, `Details`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGoCount1`, `WDBVerified`) VALUES ('77767', '80', '80', '4812', '62', '0', '4096', '43135', '10', '0', '0', '0', '0',
'Avenge Me!', 'Slay 5 Death Knight Adepts at Malykriss: The Vile Hold.', 'A Dying Berserker has asked that you slay 5 Death Knight Adepts at Malykriss: The Vile Hold in Icecrown Citadel, and return to me.',
'Good Job! You have completed this quest and therefore you will receive your reward.', '31042', '5', '12340');



Code: 
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77777);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77776);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77775);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77774);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77773);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77772);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77771);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77770);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77769);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77768);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (800084, 77767);


INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77777);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77776);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77775);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77774);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77773);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77772);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77771);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77770);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77769);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77768);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (800084, 77767);


INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`,
`gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`,
`rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`,
`lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`,
`PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`,
`questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`)
VALUES (800084, 0, 0, 0, 0, 0, 30686, 0, 0, 0, 'Dark Ranger Vorel', 'ICC Raid Quests', '', 0, 1, 80, 2, 35, 35, 2, 1, 1, 1, 1, 346, 499, 0, 287, 7.5, 2000, 0, 1, 2, 0, 0, 0, 0, 0, 0, 315, 468, 69, 7, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 500, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1221, 0, 2, '', 12340);


;)
 
Gnarlsbarkly

Gnarlsbarkly

Veteran Member
Verified Member
36
2018
4
Location
Canada
:O !!!!!!
Thank You :D

ive been slowly trying to learn how to do stuff like this. these really help
 
You must log in or register to reply here.
Top