HubsInfo Network
Social PHP Linux Material Design Web Hosting Online Games SimCity BuildIt

How to make daily quests!

0 Members and 1 Guest are viewing this topic.

How to make daily quests!
« on: May 24, 2014, 06:56:43 AM »
# 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');

Re: How to make daily quests!
« Reply #1 on: May 24, 2014, 06:57:47 AM »
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);

 


Linux Ubuntu Guides Linux games - Lutris.net