Thanksgiving Quest

**Turmoiltoad** · #1 11-21-2017, 03:17 PM

Hi all! I put together a Thanksgiving Quest and thought I would share.

This one is a bit complex to get installed--it makes use of the Task System, adds grounds spawns, a handful of NPCs, etc. Please proceed cautiously!

Story arc:

Farmer Glumr's turkeys have gone wild (what's Thanksgiving without some Wild Turkey, amiright?). Your fearless adventurers will have to find and kill the Wild Turkey pack before any more of his corn is stolen and the rest of his turkeys cannot survive the Winter.

Completing the quest results in Endless Turkeys (an item that summons Cooked Turkey--a decent stat food with FT).

Quest write-up:

http://gatesoftime.com/wiki/index.ph...ving_Turkeyday

NPCs:

Farmer Glumr

Code:

INSERT INTO `npc_types` (`id`, `name`, `lastname`, `level`, `race`, `class`, `bodytype`, `hp`, `mana`, `gender`, `texture`, `helmtexture`, `herosforgemodel`, `size`, `hp_regen_rate`, `mana_regen_rate`, `loottable_id`, `merchant_id`, `alt_currency_id`, `npc_spells_id`, `npc_spells_effects_id`, `npc_faction_id`, `adventure_template_id`, `trap_template`, `mindmg`, `maxdmg`, `attack_count`, `npcspecialattks`, `special_abilities`, `aggroradius`, `assistradius`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_eyecolor2`, `luclin_beardcolor`, `luclin_beard`, `drakkin_heritage`, `drakkin_tattoo`, `drakkin_details`, `armortint_id`, `armortint_red`, `armortint_green`, `armortint_blue`, `d_melee_texture1`, `d_melee_texture2`, `ammo_idfile`, `prim_melee_type`, `sec_melee_type`, `ranged_type`, `runspeed`, `MR`, `CR`, `DR`, `FR`, `PR`, `Corrup`, `PhR`, `see_invis`, `see_invis_undead`, `qglobal`, `AC`, `npc_aggro`, `spawn_limit`, `attack_speed`, `attack_delay`, `findable`, `STR`, `STA`, `DEX`, `AGI`, `_INT`, `WIS`, `CHA`, `see_hide`, `see_improved_hide`, `trackable`, `isbot`, `exclude`, `ATK`, `Accuracy`, `Avoidance`, `slow_mitigation`, `version`, `maxlevel`, `scalerate`, `private_corpse`, `unique_spawn_by_name`, `underwater`, `isquest`, `emoteid`, `spellscale`, `healscale`, `no_target_hotkey`, `raid_target`, `armtexture`, `bracertexture`, `handtexture`, `legtexture`, `feettexture`, `light`, `walkspeed`, `peqid`, `unique_`, `fixed`, `ignore_despawn`, `show_name`, `untargetable`)
VALUES
	(202502, 'Farmer_Glumr', 'Thanksgiving Quest Giver', 60, 2, 41, 1, 4367, 0, 0, 20, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 48, 105, -1, '', '', 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'IT10', 28, 28, 7, 1.25, 61, 61, 61, 61, 61, 61, 65, 0, 0, 0, 266, 0, 0, -7.63418, 29, 0, 220, 220, 220, 220, 220, 220, 220, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 1, 0, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);

Spawngroup:

Code:

INSERT INTO `spawngroup` (`id`, `name`, `spawn_limit`, `dist`, `max_x`, `min_x`, `max_y`, `min_y`, `delay`, `mindelay`, `despawn`, `despawn_timer`)
VALUES
	(275236, 'poknowledge_farmer_glumr', 0, 0, 0, 0, 0, 0, 0, 15000, 0, 0);

Spawnentry:

Code:

INSERT INTO `spawnentry` (`spawngroupID`, `npcID`, `chance`)
VALUES
	(275236, 202502, 100);

Spawn2:

Code:

INSERT INTO `spawn2` (`id`, `spawngroupID`, `zone`, `version`, `x`, `y`, `z`, `heading`, `respawntime`, `variance`, `pathgrid`, `_condition`, `cond_value`, `enabled`, `animation`)
VALUES
	(250615, 275236, 'poknowledge', 0, 1233.050049, -355.350006, -124.620003, 80.500000, 640, 0, 0, 0, 1, 1, 0);

Master Glumr

Code:

INSERT INTO `npc_types` (`id`, `name`, `lastname`, `level`, `race`, `class`, `bodytype`, `hp`, `mana`, `gender`, `texture`, `helmtexture`, `herosforgemodel`, `size`, `hp_regen_rate`, `mana_regen_rate`, `loottable_id`, `merchant_id`, `alt_currency_id`, `npc_spells_id`, `npc_spells_effects_id`, `npc_faction_id`, `adventure_template_id`, `trap_template`, `mindmg`, `maxdmg`, `attack_count`, `npcspecialattks`, `special_abilities`, `aggroradius`, `assistradius`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_eyecolor2`, `luclin_beardcolor`, `luclin_beard`, `drakkin_heritage`, `drakkin_tattoo`, `drakkin_details`, `armortint_id`, `armortint_red`, `armortint_green`, `armortint_blue`, `d_melee_texture1`, `d_melee_texture2`, `ammo_idfile`, `prim_melee_type`, `sec_melee_type`, `ranged_type`, `runspeed`, `MR`, `CR`, `DR`, `FR`, `PR`, `Corrup`, `PhR`, `see_invis`, `see_invis_undead`, `qglobal`, `AC`, `npc_aggro`, `spawn_limit`, `attack_speed`, `attack_delay`, `findable`, `STR`, `STA`, `DEX`, `AGI`, `_INT`, `WIS`, `CHA`, `see_hide`, `see_improved_hide`, `trackable`, `isbot`, `exclude`, `ATK`, `Accuracy`, `Avoidance`, `slow_mitigation`, `version`, `maxlevel`, `scalerate`, `private_corpse`, `unique_spawn_by_name`, `underwater`, `isquest`, `emoteid`, `spellscale`, `healscale`, `no_target_hotkey`, `raid_target`, `armtexture`, `bracertexture`, `handtexture`, `legtexture`, `feettexture`, `light`, `walkspeed`, `peqid`, `unique_`, `fixed`, `ignore_despawn`, `show_name`, `untargetable`)
VALUES
	(15196, 'Master_Glumr', '', 60, 71, 41, 1, 4367, 0, 0, 4, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 48, 105, -1, '', '', 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'IT10', 28, 28, 7, 1.25, 61, 61, 61, 61, 61, 61, 65, 0, 0, 0, 266, 0, 0, -7.63418, 29, 0, 220, 220, 220, 220, 220, 220, 220, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 1, 0, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);

Spawngroup:

Code:

INSERT INTO `spawngroup` (`id`, `name`, `spawn_limit`, `dist`, `max_x`, `min_x`, `max_y`, `min_y`, `delay`, `mindelay`, `despawn`, `despawn_timer`)
VALUES
	(275232, 'eastkarana_master_glumr', 0, 0, 0, 0, 0, 0, 0, 15000, 0, 0);

Spawnentry:

Code:

INSERT INTO `spawnentry` (`spawngroupID`, `npcID`, `chance`)
VALUES
	(275233, 15197, 100);

Spawn2:

Code:

INSERT INTO `spawn2` (`id`, `spawngroupID`, `zone`, `version`, `x`, `y`, `z`, `heading`, `respawntime`, `variance`, `pathgrid`, `_condition`, `cond_value`, `enabled`, `animation`)
VALUES
	(250612, 275233, 'eastkarana', 0, -2009.069946, -2657.489990, 8.080000, 1.200000, 640, 0, 0, 0, 1, 1, 0);

Lady Glumr

Code:

INSERT INTO `npc_types` (`id`, `name`, `lastname`, `level`, `race`, `class`, `bodytype`, `hp`, `mana`, `gender`, `texture`, `helmtexture`, `herosforgemodel`, `size`, `hp_regen_rate`, `mana_regen_rate`, `loottable_id`, `merchant_id`, `alt_currency_id`, `npc_spells_id`, `npc_spells_effects_id`, `npc_faction_id`, `adventure_template_id`, `trap_template`, `mindmg`, `maxdmg`, `attack_count`, `npcspecialattks`, `special_abilities`, `aggroradius`, `assistradius`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_eyecolor2`, `luclin_beardcolor`, `luclin_beard`, `drakkin_heritage`, `drakkin_tattoo`, `drakkin_details`, `armortint_id`, `armortint_red`, `armortint_green`, `armortint_blue`, `d_melee_texture1`, `d_melee_texture2`, `ammo_idfile`, `prim_melee_type`, `sec_melee_type`, `ranged_type`, `runspeed`, `MR`, `CR`, `DR`, `FR`, `PR`, `Corrup`, `PhR`, `see_invis`, `see_invis_undead`, `qglobal`, `AC`, `npc_aggro`, `spawn_limit`, `attack_speed`, `attack_delay`, `findable`, `STR`, `STA`, `DEX`, `AGI`, `_INT`, `WIS`, `CHA`, `see_hide`, `see_improved_hide`, `trackable`, `isbot`, `exclude`, `ATK`, `Accuracy`, `Avoidance`, `slow_mitigation`, `version`, `maxlevel`, `scalerate`, `private_corpse`, `unique_spawn_by_name`, `underwater`, `isquest`, `emoteid`, `spellscale`, `healscale`, `no_target_hotkey`, `raid_target`, `armtexture`, `bracertexture`, `handtexture`, `legtexture`, `feettexture`, `light`, `walkspeed`, `peqid`, `unique_`, `fixed`, `ignore_despawn`, `show_name`, `untargetable`)
VALUES
	(15197, 'Lady_Glumr', '', 60, 71, 41, 1, 4367, 0, 1, 4, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 48, 105, -1, '', '', 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'IT10', 28, 28, 7, 1.25, 61, 61, 61, 61, 61, 61, 65, 0, 0, 0, 266, 0, 0, -7.63418, 29, 0, 220, 220, 220, 220, 220, 220, 220, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 1, 0, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);

Spawngroup:

Code:

INSERT INTO `spawngroup` (`id`, `name`, `spawn_limit`, `dist`, `max_x`, `min_x`, `max_y`, `min_y`, `delay`, `mindelay`, `despawn`, `despawn_timer`)
VALUES
	(275233, 'eastkarana_lady_glumr', 0, 0, 0, 0, 0, 0, 0, 15000, 0, 0);

Spawnentry:

Code:

INSERT INTO `spawnentry` (`spawngroupID`, `npcID`, `chance`)
VALUES
	(275233, 15197, 100);

Spawn2:

Code:

INSERT INTO `spawn2` (`id`, `spawngroupID`, `zone`, `version`, `x`, `y`, `z`, `heading`, `respawntime`, `variance`, `pathgrid`, `_condition`, `cond_value`, `enabled`, `animation`)
VALUES
	(250612, 275233, 'eastkarana', 0, -2009.069946, -2657.489990, 8.080000, 1.200000, 640, 0, 0, 0, 1, 1, 0);

Old Lady Einarr

Code:

INSERT INTO `npc_types` (`id`, `name`, `lastname`, `level`, `race`, `class`, `bodytype`, `hp`, `mana`, `gender`, `texture`, `helmtexture`, `herosforgemodel`, `size`, `hp_regen_rate`, `mana_regen_rate`, `loottable_id`, `merchant_id`, `alt_currency_id`, `npc_spells_id`, `npc_spells_effects_id`, `npc_faction_id`, `adventure_template_id`, `trap_template`, `mindmg`, `maxdmg`, `attack_count`, `npcspecialattks`, `special_abilities`, `aggroradius`, `assistradius`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_eyecolor2`, `luclin_beardcolor`, `luclin_beard`, `drakkin_heritage`, `drakkin_tattoo`, `drakkin_details`, `armortint_id`, `armortint_red`, `armortint_green`, `armortint_blue`, `d_melee_texture1`, `d_melee_texture2`, `ammo_idfile`, `prim_melee_type`, `sec_melee_type`, `ranged_type`, `runspeed`, `MR`, `CR`, `DR`, `FR`, `PR`, `Corrup`, `PhR`, `see_invis`, `see_invis_undead`, `qglobal`, `AC`, `npc_aggro`, `spawn_limit`, `attack_speed`, `attack_delay`, `findable`, `STR`, `STA`, `DEX`, `AGI`, `_INT`, `WIS`, `CHA`, `see_hide`, `see_improved_hide`, `trackable`, `isbot`, `exclude`, `ATK`, `Accuracy`, `Avoidance`, `slow_mitigation`, `version`, `maxlevel`, `scalerate`, `private_corpse`, `unique_spawn_by_name`, `underwater`, `isquest`, `emoteid`, `spellscale`, `healscale`, `no_target_hotkey`, `raid_target`, `armtexture`, `bracertexture`, `handtexture`, `legtexture`, `feettexture`, `light`, `walkspeed`, `peqid`, `unique_`, `fixed`, `ignore_despawn`, `show_name`, `untargetable`)
VALUES
	(13131, 'Old_Lady_Einarr', '', 60, 71, 41, 1, 4367, 0, 1, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 48, 105, -1, '', '', 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'IT10', 28, 28, 7, 1.25, 61, 61, 61, 61, 61, 61, 65, 0, 0, 0, 266, 0, 0, -7.63418, 29, 0, 220, 220, 220, 220, 220, 220, 220, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 1, 0, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);

Spawngroup:

Code:

INSERT INTO `spawngroup` (`id`, `name`, `spawn_limit`, `dist`, `max_x`, `min_x`, `max_y`, `min_y`, `delay`, `mindelay`, `despawn`, `despawn_timer`)
VALUES
	(275234, 'northkarana_old_lady_einarr', 0, 0, 0, 0, 0, 0, 0, 15000, 0, 0);

Spawnentry:

Code:

INSERT INTO `spawnentry` (`spawngroupID`, `npcID`, `chance`)
VALUES
	(275234, 13131, 100);

Spawn2:

Code:

INSERT INTO `spawn2` (`id`, `spawngroupID`, `zone`, `version`, `x`, `y`, `z`, `heading`, `respawntime`, `variance`, `pathgrid`, `_condition`, `cond_value`, `enabled`, `animation`)
VALUES
	(250613, 275234, 'northkarana', 0, 1950.500000, -2172.570068, -3.120000, 191.500000, 640, 0, 0, 0, 1, 1, 0);

A Corny Scarecrow

Code:

INSERT INTO `npc_types` (`id`, `name`, `lastname`, `level`, `race`, `class`, `bodytype`, `hp`, `mana`, `gender`, `texture`, `helmtexture`, `herosforgemodel`, `size`, `hp_regen_rate`, `mana_regen_rate`, `loottable_id`, `merchant_id`, `alt_currency_id`, `npc_spells_id`, `npc_spells_effects_id`, `npc_faction_id`, `adventure_template_id`, `trap_template`, `mindmg`, `maxdmg`, `attack_count`, `npcspecialattks`, `special_abilities`, `aggroradius`, `assistradius`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_eyecolor2`, `luclin_beardcolor`, `luclin_beard`, `drakkin_heritage`, `drakkin_tattoo`, `drakkin_details`, `armortint_id`, `armortint_red`, `armortint_green`, `armortint_blue`, `d_melee_texture1`, `d_melee_texture2`, `ammo_idfile`, `prim_melee_type`, `sec_melee_type`, `ranged_type`, `runspeed`, `MR`, `CR`, `DR`, `FR`, `PR`, `Corrup`, `PhR`, `see_invis`, `see_invis_undead`, `qglobal`, `AC`, `npc_aggro`, `spawn_limit`, `attack_speed`, `attack_delay`, `findable`, `STR`, `STA`, `DEX`, `AGI`, `_INT`, `WIS`, `CHA`, `see_hide`, `see_improved_hide`, `trackable`, `isbot`, `exclude`, `ATK`, `Accuracy`, `Avoidance`, `slow_mitigation`, `version`, `maxlevel`, `scalerate`, `private_corpse`, `unique_spawn_by_name`, `underwater`, `isquest`, `emoteid`, `spellscale`, `healscale`, `no_target_hotkey`, `raid_target`, `armtexture`, `bracertexture`, `handtexture`, `legtexture`, `feettexture`, `light`, `walkspeed`, `peqid`, `unique_`, `fixed`, `ignore_despawn`, `show_name`, `untargetable`)
VALUES
	(14197, 'A_Corny_Scarecrow', '', 60, 82, 1, 1, 4367, 0, 2, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 48, 105, -1, '', '', 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'IT10', 28, 28, 7, 1.25, 61, 61, 61, 61, 61, 61, 65, 0, 0, 0, 266, 0, 0, -7.63418, 29, 0, 220, 220, 220, 220, 220, 220, 220, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 1, 0, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);

Spawngroup:

Code:

INSERT INTO `spawngroup` (`id`, `name`, `spawn_limit`, `dist`, `max_x`, `min_x`, `max_y`, `min_y`, `delay`, `mindelay`, `despawn`, `despawn_timer`)
VALUES
	(275235, 'southkarana_a_corny_scarecrow', 0, 0, 0, 0, 0, 0, 0, 15000, 0, 0);

Spawnentry:

Code:

INSERT INTO `spawnentry` (`spawngroupID`, `npcID`, `chance`)
VALUES
	(275235, 14197, 100);

Spawn2:

Code:

INSERT INTO `spawn2` (`id`, `spawngroupID`, `zone`, `version`, `x`, `y`, `z`, `heading`, `respawntime`, `variance`, `pathgrid`, `_condition`, `cond_value`, `enabled`, `animation`)
VALUES
	(250614, 275235, 'southkarana', 0, 633.309998, 485.950012, 0.600000, 163.399994, 3600, 360, 111, 0, 1, 1, 0);

Grid:

Code:

[INSERT INTO `grid` (`id`, `zoneid`, `type`, `type2`)
VALUES
	(111, 14, 0, 1);

Grid_Entries:

Code:

INSERT INTO `grid_entries` (`gridid`, `zoneid`, `number`, `x`, `y`, `z`, `heading`, `pause`)
VALUES
	(111, 14, 1, 633.31, 485.95, 0.6, -1, 0),
	(111, 14, 2, 42.05, 24.37, 0.6, -1, 0),
	(111, 14, 3, -668.61, -41.84, 0.6, -1, 0),
	(111, 14, 4, -1135.77, 270.91, 0.6, -1, 0),
	(111, 14, 5, -1423.02, 650.23, 0.6, -1, 0),
	(111, 14, 6, -1458.11, 1174.28, 39.94, -1, 0),
	(111, 14, 7, -1343.91, 1710.18, 54.89, -1, 0),
	(111, 14, 8, -1085.41, 2078.68, 92.66, -1, 0),
	(111, 14, 9, -493.76, 2184.19, 21.68, -1, 0),
	(111, 14, 10, 141.02, 1962.87, 61.75, -1, 0),
	(111, 14, 11, 697.33, 1576.78, 42.51, -1, 0),
	(111, 14, 12, 1354.99, 968.17, 36.07, -1, 0),
	(111, 14, 13, 1465.66, 556.77, 0.6, -1, 0),
	(111, 14, 14, 1028.96, 299.35, 0.6, -1, 0),
	(111, 14, 15, 473.17, 389.62, 0.6, -1, 0);

A Wild Turkey

Code:

INSERT INTO `npc_types` (`id`, `name`, `lastname`, `level`, `race`, `class`, `bodytype`, `hp`, `mana`, `gender`, `texture`, `helmtexture`, `herosforgemodel`, `size`, `hp_regen_rate`, `mana_regen_rate`, `loottable_id`, `merchant_id`, `alt_currency_id`, `npc_spells_id`, `npc_spells_effects_id`, `npc_faction_id`, `adventure_template_id`, `trap_template`, `mindmg`, `maxdmg`, `attack_count`, `npcspecialattks`, `special_abilities`, `aggroradius`, `assistradius`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_eyecolor2`, `luclin_beardcolor`, `luclin_beard`, `drakkin_heritage`, `drakkin_tattoo`, `drakkin_details`, `armortint_id`, `armortint_red`, `armortint_green`, `armortint_blue`, `d_melee_texture1`, `d_melee_texture2`, `ammo_idfile`, `prim_melee_type`, `sec_melee_type`, `ranged_type`, `runspeed`, `MR`, `CR`, `DR`, `FR`, `PR`, `Corrup`, `PhR`, `see_invis`, `see_invis_undead`, `qglobal`, `AC`, `npc_aggro`, `spawn_limit`, `attack_speed`, `attack_delay`, `findable`, `STR`, `STA`, `DEX`, `AGI`, `_INT`, `WIS`, `CHA`, `see_hide`, `see_improved_hide`, `trackable`, `isbot`, `exclude`, `ATK`, `Accuracy`, `Avoidance`, `slow_mitigation`, `version`, `maxlevel`, `scalerate`, `private_corpse`, `unique_spawn_by_name`, `underwater`, `isquest`, `emoteid`, `spellscale`, `healscale`, `no_target_hotkey`, `raid_target`, `armtexture`, `bracertexture`, `handtexture`, `legtexture`, `feettexture`, `light`, `walkspeed`, `peqid`, `unique_`, `fixed`, `ignore_despawn`, `show_name`, `untargetable`)
VALUES
	(14198, 'A_Wild_Turkey', '', 63, 13, 1, 1, 42000, 1000, 2, 0, 0, 0, 9, 28, 10, 110175, 0, 0, 3017, 0, 0, 0, 0, 60, 250, -1, '', '13,1^14,1^15,1^16,1^17,1^21,1^31,1', 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'IT10', 28, 28, 7, 2.325, 50, 50, 50, 50, 50, 50, 75, 1, 0, 0, 293, 0, 0, -18, 12, 0, 234, 234, 234, 234, 234, 234, 234, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 1, 0, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);

Loottable:

Code:

INSERT INTO `loottable` (`id`, `name`, `mincash`, `maxcash`, `avgcoin`, `done`)
VALUES
	(110175, 'A_Wild_Turkey', 0, 0, 0, 0);

Loottable_entries:

Code:

INSERT INTO `loottable_entries` (`loottable_id`, `lootdrop_id`, `multiplier`, `droplimit`, `mindrop`, `probability`)
VALUES
	(110175, 176299, 1, 1, 1, 100);

Lootdrop:

Code:

INSERT INTO `lootdrop` (`id`, `name`)
VALUES
	(176299, '110175_A_Wild_Turkey_');

Lootdrop_entries:

Code:

INSERT INTO `lootdrop_entries` (`lootdrop_id`, `item_id`, `item_charges`, `equip_item`, `chance`, `disabled_chance`, `minlevel`, `maxlevel`, `multiplier`)
VALUES
	(176299, 147637, 1, 0, 100, 0, 0, 127, 1);

Items

Ear of Corn

Code:

INSERT INTO `items` (`id`, `minstatus`, `Name`, `aagi`, `ac`, `accuracy`, `acha`, `adex`, `aint`, `artifactflag`, `asta`, `astr`, `attack`, `augrestrict`, `augslot1type`, `augslot1visible`, `augslot2type`, `augslot2visible`, `augslot3type`, `augslot3visible`, `augslot4type`, `augslot4visible`, `augslot5type`, `augslot5visible`, `augslot6type`, `augslot6visible`, `augtype`, `avoidance`, `awis`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `bardtype`, `bardvalue`, `book`, `casttime`, `casttime_`, `charmfile`, `charmfileid`, `classes`, `color`, `combateffects`, `extradmgskill`, `extradmgamt`, `price`, `cr`, `damage`, `damageshield`, `deity`, `delay`, `augdistiller`, `dotshielding`, `dr`, `clicktype`, `clicklevel2`, `elemdmgtype`, `elemdmgamt`, `endur`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `filename`, `focuseffect`, `fr`, `fvnodrop`, `haste`, `clicklevel`, `hp`, `regen`, `icon`, `idfile`, `itemclass`, `itemtype`, `ldonprice`, `ldontheme`, `ldonsold`, `light`, `lore`, `loregroup`, `magic`, `mana`, `manaregen`, `enduranceregen`, `material`, `herosforgemodel`, `maxcharges`, `mr`, `nodrop`, `norent`, `pendingloreflag`, `pr`, `procrate`, `races`, `range`, `reclevel`, `recskill`, `reqlevel`, `sellrate`, `shielding`, `size`, `skillmodtype`, `skillmodvalue`, `slots`, `clickeffect`, `spellshield`, `strikethrough`, `stunresist`, `summonedflag`, `tradeskills`, `favor`, `weight`, `UNK012`, `UNK013`, `benefitflag`, `UNK054`, `UNK059`, `booktype`, `recastdelay`, `recasttype`, `guildfavor`, `UNK123`, `UNK124`, `attuneable`, `nopet`, `updated`, `comment`, `UNK127`, `pointtype`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `UNK134`, `UNK137`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `UNK142`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`, `UNK147`, `focustype`, `focuslevel2`, `focuslevel`, `UNK152`, `scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `UNK157`, `serialized`, `verified`, `serialization`, `source`, `UNK033`, `lorefile`, `UNK014`, `svcorruption`, `skillmodmax`, `UNK060`, `augslot1unk2`, `augslot2unk2`, `augslot3unk2`, `augslot4unk2`, `augslot5unk2`, `augslot6unk2`, `UNK120`, `UNK121`, `questitemflag`, `UNK132`, `clickunk5`, `clickunk6`, `clickunk7`, `procunk1`, `procunk2`, `procunk3`, `procunk4`, `procunk6`, `procunk7`, `wornunk1`, `wornunk2`, `wornunk3`, `wornunk4`, `wornunk5`, `wornunk6`, `wornunk7`, `focusunk1`, `focusunk2`, `focusunk3`, `focusunk4`, `focusunk5`, `focusunk6`, `focusunk7`, `scrollunk1`, `scrollunk2`, `scrollunk3`, `scrollunk4`, `scrollunk5`, `scrollunk6`, `scrollunk7`, `UNK193`, `purity`, `evoitem`, `evoid`, `evolvinglevel`, `evomax`, `clickname`, `procname`, `wornname`, `focusname`, `scrollname`, `dsmitigation`, `heroic_str`, `heroic_int`, `heroic_wis`, `heroic_agi`, `heroic_dex`, `heroic_sta`, `heroic_cha`, `heroic_pr`, `heroic_dr`, `heroic_fr`, `heroic_cr`, `heroic_mr`, `heroic_svcorrup`, `healamt`, `spelldmg`, `clairvoyance`, `backstabdmg`, `created`, `elitematerial`, `ldonsellbackrate`, `scriptfileid`, `expendablearrow`, `powersourcecapacity`, `bardeffect`, `bardeffecttype`, `bardlevel2`, `bardlevel`, `bardunk1`, `bardunk2`, `bardunk3`, `bardunk4`, `bardunk5`, `bardname`, `bardunk7`, `UNK214`, `UNK219`, `UNK220`, `UNK221`, `heirloom`, `UNK223`, `UNK224`, `UNK225`, `UNK226`, `UNK227`, `UNK228`, `UNK229`, `UNK230`, `UNK231`, `UNK232`, `UNK233`, `UNK234`, `placeable`, `UNK236`, `UNK237`, `UNK238`, `UNK239`, `UNK240`, `UNK241`, `epicitem`)
VALUES
	(147636, 0, 'Ear of Corn', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '0', 65535, 4278190080, '0', -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, 6412, 'IT63', 0, 14, 0, 0, 0, 0, 'Sweet corn', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 65535, 0, 0, 0, 0, 1, 0, 1, -1, 0, 0, -1, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2017-11-20 08:31:45', '', 0, 0, 0, 0, 20, 0, 1, '', 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, NULL, '2017-11-20 08:31:45', NULL, 'CUSTOM', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, 0, '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2017112083145', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Sack of Corn

Code:

INSERT INTO `items` (`id`, `minstatus`, `Name`, `aagi`, `ac`, `accuracy`, `acha`, `adex`, `aint`, `artifactflag`, `asta`, `astr`, `attack`, `augrestrict`, `augslot1type`, `augslot1visible`, `augslot2type`, `augslot2visible`, `augslot3type`, `augslot3visible`, `augslot4type`, `augslot4visible`, `augslot5type`, `augslot5visible`, `augslot6type`, `augslot6visible`, `augtype`, `avoidance`, `awis`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `bardtype`, `bardvalue`, `book`, `casttime`, `casttime_`, `charmfile`, `charmfileid`, `classes`, `color`, `combateffects`, `extradmgskill`, `extradmgamt`, `price`, `cr`, `damage`, `damageshield`, `deity`, `delay`, `augdistiller`, `dotshielding`, `dr`, `clicktype`, `clicklevel2`, `elemdmgtype`, `elemdmgamt`, `endur`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `filename`, `focuseffect`, `fr`, `fvnodrop`, `haste`, `clicklevel`, `hp`, `regen`, `icon`, `idfile`, `itemclass`, `itemtype`, `ldonprice`, `ldontheme`, `ldonsold`, `light`, `lore`, `loregroup`, `magic`, `mana`, `manaregen`, `enduranceregen`, `material`, `herosforgemodel`, `maxcharges`, `mr`, `nodrop`, `norent`, `pendingloreflag`, `pr`, `procrate`, `races`, `range`, `reclevel`, `recskill`, `reqlevel`, `sellrate`, `shielding`, `size`, `skillmodtype`, `skillmodvalue`, `slots`, `clickeffect`, `spellshield`, `strikethrough`, `stunresist`, `summonedflag`, `tradeskills`, `favor`, `weight`, `UNK012`, `UNK013`, `benefitflag`, `UNK054`, `UNK059`, `booktype`, `recastdelay`, `recasttype`, `guildfavor`, `UNK123`, `UNK124`, `attuneable`, `nopet`, `updated`, `comment`, `UNK127`, `pointtype`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `UNK134`, `UNK137`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `UNK142`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`, `UNK147`, `focustype`, `focuslevel2`, `focuslevel`, `UNK152`, `scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `UNK157`, `serialized`, `verified`, `serialization`, `source`, `UNK033`, `lorefile`, `UNK014`, `svcorruption`, `skillmodmax`, `UNK060`, `augslot1unk2`, `augslot2unk2`, `augslot3unk2`, `augslot4unk2`, `augslot5unk2`, `augslot6unk2`, `UNK120`, `UNK121`, `questitemflag`, `UNK132`, `clickunk5`, `clickunk6`, `clickunk7`, `procunk1`, `procunk2`, `procunk3`, `procunk4`, `procunk6`, `procunk7`, `wornunk1`, `wornunk2`, `wornunk3`, `wornunk4`, `wornunk5`, `wornunk6`, `wornunk7`, `focusunk1`, `focusunk2`, `focusunk3`, `focusunk4`, `focusunk5`, `focusunk6`, `focusunk7`, `scrollunk1`, `scrollunk2`, `scrollunk3`, `scrollunk4`, `scrollunk5`, `scrollunk6`, `scrollunk7`, `UNK193`, `purity`, `evoitem`, `evoid`, `evolvinglevel`, `evomax`, `clickname`, `procname`, `wornname`, `focusname`, `scrollname`, `dsmitigation`, `heroic_str`, `heroic_int`, `heroic_wis`, `heroic_agi`, `heroic_dex`, `heroic_sta`, `heroic_cha`, `heroic_pr`, `heroic_dr`, `heroic_fr`, `heroic_cr`, `heroic_mr`, `heroic_svcorrup`, `healamt`, `spelldmg`, `clairvoyance`, `backstabdmg`, `created`, `elitematerial`, `ldonsellbackrate`, `scriptfileid`, `expendablearrow`, `powersourcecapacity`, `bardeffect`, `bardeffecttype`, `bardlevel2`, `bardlevel`, `bardunk1`, `bardunk2`, `bardunk3`, `bardunk4`, `bardunk5`, `bardname`, `bardunk7`, `UNK214`, `UNK219`, `UNK220`, `UNK221`, `heirloom`, `UNK223`, `UNK224`, `UNK225`, `UNK226`, `UNK227`, `UNK228`, `UNK229`, `UNK230`, `UNK231`, `UNK232`, `UNK233`, `UNK234`, `placeable`, `UNK236`, `UNK237`, `UNK238`, `UNK239`, `UNK240`, `UNK241`, `epicitem`)
VALUES
	(147637, 0, 'Sack of Corn', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '0', 65535, 4278190080, '0', -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, 1145, 'IT62', 0, 11, 0, 0, 0, 0, 'A sack of Wild Turkey Corn', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 65535, 0, 0, 0, 0, 1, 0, 3, -1, 0, 0, -1, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2017-11-20 10:24:39', '', 0, 0, 0, 0, 1, 0, 0, '', 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, NULL, '2017-11-20 10:24:39', NULL, 'CUSTOM', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '20171120102439', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Note to Farmer Glumr

Code:

INSERT INTO `items` (`id`, `minstatus`, `Name`, `aagi`, `ac`, `accuracy`, `acha`, `adex`, `aint`, `artifactflag`, `asta`, `astr`, `attack`, `augrestrict`, `augslot1type`, `augslot1visible`, `augslot2type`, `augslot2visible`, `augslot3type`, `augslot3visible`, `augslot4type`, `augslot4visible`, `augslot5type`, `augslot5visible`, `augslot6type`, `augslot6visible`, `augtype`, `avoidance`, `awis`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `bardtype`, `bardvalue`, `book`, `casttime`, `casttime_`, `charmfile`, `charmfileid`, `classes`, `color`, `combateffects`, `extradmgskill`, `extradmgamt`, `price`, `cr`, `damage`, `damageshield`, `deity`, `delay`, `augdistiller`, `dotshielding`, `dr`, `clicktype`, `clicklevel2`, `elemdmgtype`, `elemdmgamt`, `endur`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `filename`, `focuseffect`, `fr`, `fvnodrop`, `haste`, `clicklevel`, `hp`, `regen`, `icon`, `idfile`, `itemclass`, `itemtype`, `ldonprice`, `ldontheme`, `ldonsold`, `light`, `lore`, `loregroup`, `magic`, `mana`, `manaregen`, `enduranceregen`, `material`, `herosforgemodel`, `maxcharges`, `mr`, `nodrop`, `norent`, `pendingloreflag`, `pr`, `procrate`, `races`, `range`, `reclevel`, `recskill`, `reqlevel`, `sellrate`, `shielding`, `size`, `skillmodtype`, `skillmodvalue`, `slots`, `clickeffect`, `spellshield`, `strikethrough`, `stunresist`, `summonedflag`, `tradeskills`, `favor`, `weight`, `UNK012`, `UNK013`, `benefitflag`, `UNK054`, `UNK059`, `booktype`, `recastdelay`, `recasttype`, `guildfavor`, `UNK123`, `UNK124`, `attuneable`, `nopet`, `updated`, `comment`, `UNK127`, `pointtype`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `UNK134`, `UNK137`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `UNK142`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`, `UNK147`, `focustype`, `focuslevel2`, `focuslevel`, `UNK152`, `scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `UNK157`, `serialized`, `verified`, `serialization`, `source`, `UNK033`, `lorefile`, `UNK014`, `svcorruption`, `skillmodmax`, `UNK060`, `augslot1unk2`, `augslot2unk2`, `augslot3unk2`, `augslot4unk2`, `augslot5unk2`, `augslot6unk2`, `UNK120`, `UNK121`, `questitemflag`, `UNK132`, `clickunk5`, `clickunk6`, `clickunk7`, `procunk1`, `procunk2`, `procunk3`, `procunk4`, `procunk6`, `procunk7`, `wornunk1`, `wornunk2`, `wornunk3`, `wornunk4`, `wornunk5`, `wornunk6`, `wornunk7`, `focusunk1`, `focusunk2`, `focusunk3`, `focusunk4`, `focusunk5`, `focusunk6`, `focusunk7`, `scrollunk1`, `scrollunk2`, `scrollunk3`, `scrollunk4`, `scrollunk5`, `scrollunk6`, `scrollunk7`, `UNK193`, `purity`, `evoitem`, `evoid`, `evolvinglevel`, `evomax`, `clickname`, `procname`, `wornname`, `focusname`, `scrollname`, `dsmitigation`, `heroic_str`, `heroic_int`, `heroic_wis`, `heroic_agi`, `heroic_dex`, `heroic_sta`, `heroic_cha`, `heroic_pr`, `heroic_dr`, `heroic_fr`, `heroic_cr`, `heroic_mr`, `heroic_svcorrup`, `healamt`, `spelldmg`, `clairvoyance`, `backstabdmg`, `created`, `elitematerial`, `ldonsellbackrate`, `scriptfileid`, `expendablearrow`, `powersourcecapacity`, `bardeffect`, `bardeffecttype`, `bardlevel2`, `bardlevel`, `bardunk1`, `bardunk2`, `bardunk3`, `bardunk4`, `bardunk5`, `bardname`, `bardunk7`, `UNK214`, `UNK219`, `UNK220`, `UNK221`, `heirloom`, `UNK223`, `UNK224`, `UNK225`, `UNK226`, `UNK227`, `UNK228`, `UNK229`, `UNK230`, `UNK231`, `UNK232`, `UNK233`, `UNK234`, `placeable`, `UNK236`, `UNK237`, `UNK238`, `UNK239`, `UNK240`, `UNK241`, `epicitem`)
VALUES
	(147638, 0, 'Note to Farmer Glumr', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '0', 65535, 4278190080, '0', -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, 868, 'IT63', 0, 11, 0, 0, 0, 0, 'A description of your great deeds!', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 65535, 0, 0, 0, 0, 1, 0, 1, -1, 0, 0, -1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2017-11-20 10:32:32', '', 0, 0, 0, 0, 1, 0, 0, '', 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, NULL, '2017-11-20 10:32:32', NULL, 'CUSTOM', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '20171120103232', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Ground Spawns:

These are the Ears of Corn that grow in North Karana:

Code:

INSERT INTO `ground_spawns` (`id`, `zoneid`, `version`, `max_x`, `max_y`, `max_z`, `min_x`, `min_y`, `heading`, `name`, `item`, `max_allowed`, `comment`, `respawn_timer`)
VALUES
	(1728, 13, 0, 2028, -2280, -9.87, 2028, -2280, 0, 'IT_Corn1', 147636, 1, 'row1', 7200000),
	(1729, 13, 0, 2028, -2286, -9.87, 2028, -2286, 0, 'IT_Corn2', 147636, 1, 'row2', 7200000),
	(1730, 13, 0, 2028, -2292, -9.87, 2028, -2292, 0, 'IT_Corn3', 147636, 1, 'row3', 7200000),
	(1731, 13, 0, 2028, -2298, -9.87, 2028, -2298, 0, 'IT_Corn4', 147636, 1, 'row4', 7200000),
	(1732, 13, 0, 2038, -2280, -9.87, 2038, -2280, 0, 'IT_Corn5', 147636, 1, 'row1', 7200000),
	(1733, 13, 0, 2048, -2280, -9.87, 2048, -2280, 0, 'IT_Corn6', 147636, 1, 'row1', 7200000),
	(1734, 13, 0, 2058, -2280, -9.87, 2058, -2280, 0, 'IT_Corn7', 147636, 1, 'row1', 7200000),
	(1735, 13, 0, 2068, -2280, -9.87, 2068, -2280, 0, 'IT_Corn8', 147636, 1, 'row1', 7200000),
	(1736, 13, 0, 2078, -2280, -9.87, 2078, -2280, 0, 'IT_Corn9', 147636, 1, 'row1', 7200000),
	(1737, 13, 0, 2088, -2280, -9.87, 2088, -2280, 0, 'IT_Corn10', 147636, 1, 'row1', 7200000),
	(1738, 13, 0, 2038, -2286, -9.87, 2038, -2286, 0, 'IT_Corn11', 147636, 1, 'row2', 7200000),
	(1739, 13, 0, 2048, -2286, -9.87, 2048, -2286, 0, 'IT_Corn12', 147636, 1, 'row2', 7200000),
	(1740, 13, 0, 2058, -2286, -9.87, 2058, -2286, 0, 'IT_Corn13', 147636, 1, 'row2', 7200000),
	(1741, 13, 0, 2068, -2286, -9.87, 2068, -2286, 0, 'IT_Corn14', 147636, 1, 'row2', 7200000),
	(1742, 13, 0, 2078, -2286, -9.87, 2078, -2286, 0, 'IT_Corn15', 147636, 1, 'row2', 7200000),
	(1743, 13, 0, 2088, -2286, -9.87, 2088, -2286, 0, 'IT_Corn16', 147636, 1, 'row2', 7200000),
	(1744, 13, 0, 2038, -2292, -9.87, 2038, -2292, 0, 'IT_Corn17', 147636, 1, 'row3', 7200000),
	(1745, 13, 0, 2048, -2292, -9.87, 2048, -2292, 0, 'IT_Corn18', 147636, 1, 'row3', 7200000),
	(1746, 13, 0, 2058, -2292, -9.87, 2058, -2292, 0, 'IT_Corn19', 147636, 1, 'row3', 7200000),
	(1747, 13, 0, 2068, -2292, -9.87, 2068, -2292, 0, 'IT_Corn20', 147636, 1, 'row3', 7200000),
	(1748, 13, 0, 2078, -2292, -9.87, 2078, -2292, 0, 'IT_Corn21', 147636, 1, 'row3', 7200000),
	(1749, 13, 0, 2088, -2292, -9.87, 2088, -2292, 0, 'IT_Corn22', 147636, 1, 'row3', 7200000),
	(1750, 13, 0, 2038, -2298, -9.87, 2038, -2298, 0, 'IT_Corn23', 147636, 1, 'row4', 7200000),
	(1751, 13, 0, 2048, -2298, -9.87, 2048, -2298, 0, 'IT_Corn24', 147636, 1, 'row4', 7200000),
	(1752, 13, 0, 2058, -2298, -9.87, 2058, -2298, 0, 'IT_Corn25', 147636, 1, 'row4', 7200000),
	(1753, 13, 0, 2068, -2298, -9.87, 2068, -2298, 0, 'IT_Corn26', 147636, 1, 'row4', 7200000),
	(1754, 13, 0, 2078, -2298, -9.87, 2078, -2298, 0, 'IT_Corn27', 147636, 1, 'row4', 7200000),
	(1755, 13, 0, 2088, -2298, -9.87, 2088, -2298, 0, 'IT_Corn28', 147636, 1, 'row4', 7200000);

Tasks:

There is one overall task with a number of activities.

Code:

INSERT INTO `tasks` (`id`, `duration`, `title`, `description`, `reward`, `rewardid`, `cashreward`, `xpreward`, `rewardmethod`, `startzone`, `minlevel`, `maxlevel`, `repeatable`)
VALUES
	(273, 0, 'Help find my turkeys!', '[1, Speak with my son\'.][2, Find some corn\'.][3, Speak with Old Lady\'.][4, Speak with a scarecrow\'.][5, Give a scarecrow some corn\'.][6. Kill a wild turkey\'.][Speak with Master Glumbr\'.]', 'Save Turkey Day', 0, 0, 0, 0, 202, 0, 0, 0);

Activities:

Code:

INSERT INTO `activities` (`taskid`, `activityid`, `step`, `activitytype`, `text1`, `text2`, `text3`, `goalid`, `goalmethod`, `goalcount`, `delivertonpc`, `zoneid`, `optional`)
VALUES
	(273, 0, 1, 4, 'Master Glumbr', 'Speak with Farmer Glumbr\'s son', '', 0, 2, 1, 0, 0, 0),
	(273, 1, 2, 3, 'the ground', 'Ear of Corn', '', 0, 2, 1, 0, 0, 0),
	(273, 2, 3, 4, 'Old Lady Einarr', '', '', 0, 2, 1, 0, 0, 0),
	(273, 3, 4, 4, 'A Corny Scarecrow', '', '', 0, 2, 1, 0, 0, 0),
	(273, 4, 5, 1, 'A Corny Scarecrow', 'Ear of Corn', '', 0, 2, 1, 0, 0, 0),
	(273, 5, 6, 2, 'A Wild Turkey', '', '', 14198, 0, 1, 0, 0, 0),
	(273, 6, 7, 1, 'Master Glumbr', 'Sack of Corn', '', 0, 2, 1, 0, 0, 0);

Quest Code:

South Karana:

A_Corny_Scarecrow.pl

Code:

# Zone: The Southern Plains of Karana (southkarana) >> A_Corny_Scarecrow (14197)

sub EVENT_SPAWN {
	quest::SetRunning(1);
}

sub EVENT_SAY {
	if ($text=~/hail/i) {
		if (quest::istaskactivityactive(273, 3)) { # Task: Help find my turkeys! 
			quest::say("Hello $name.  It is a good thing you found me--I was carried off by those [" . quest::saylink("wild turkeys") . "]. I am still trying to find my way home.");
		}
		else {
			quest::say("Hello $name.  I am sorry I cannot stay and chat--I have got to find my way home.");
		}
	}
	elsif ($text=~/wild turkeys/i) {
		if (quest::istaskactivityactive(273, 3)) { # Task: Help find my turkeys! [4, Finish off the wild turkey'.]
			quest::say("You seek wild turkeys?  If you give me some corn I will call them in for you--but be careful, they are a dangerous lot!");
			quest::updatetaskactivity(273, 3, 1);
		}
		else {
			quest::say("If you happen across any wild turkeys, I would run away!");
		}
	}
}

sub EVENT_ITEM {
	if (plugin::check_handin(\%itemcount, 147636 =>1 )) {
		if (quest::istaskactivityactive(273, 4)) { # Task: Help find my turkeys! 
			quest::updatetaskactivity(273, 4, 1); # Task: Help find my turkeys! 
			quest::say("Okay, $name.  Watch how quickly these wild turkeys come after this corn");
			quest::settimer(1,30);
			quest::doanim(43);
			quest::emote("lets out an eerie howl.");
		}
		else {
			quest::say("Thank you so much for this corn!");
		}
	}
	plugin::return_items(\%itemcount);
}

sub EVENT_TIMER {
	if ($timer == 1) {
		quest::stoptimer(1);
		quest::spawn2(14198,0,0,$x - 200,$y,$z,$h);
		quest::spawn2(14198,0,0,$x + 200,$y,$z,$h);
		quest::spawn2(14198,0,0,$x,$y - 200,$z,$h);
		quest::ze(1,"Off in the distance, a cold, shrill gobble permeates the solitude of the plain.");
		quest::settimer(2,30);
	}
	if ($timer == 2) {
		quest::stoptimer(2);
		quest::spawn2(14198,0,0,$x - 200,$y,$z,$h);
		quest::spawn2(14198,0,0,$x + 200,$y,$z,$h);
		quest::spawn2(14198,0,0,$x,$y - 200,$z,$h);
		quest::ze(1,"Off in the distance, another cold, shrill gobble permeates the solitude of the plain.");
	}
}

# Zone: The Southern Plains of Karana (southkarana) >> A_Corny_Scarecrow (14197)

14198.pl (A_Wild_Turkey)

Code:

# Zone: The Southern Plains of Karana (southkarana) >> A_Wild_Turkey (14198)

sub EVENT_SPAWN {
	if ($entity_list->GetClientList()) {
		my $rClient = $entity_list->GetRandomClient($x,$y,$z, 900);
		if ($rClient) {
			quest::attack($rClient->GetName());
		}
		else {
			quest::settimer(1,2); # if we can't find anyone, let's go away
		}
	}
}

sub EVENT_TIMER {
	if ($timer == 1) {
		quest::stoptimer(1);
		quest::depop();
	}
}

# EOF Zone: The Southern Plains of Karana (southkarana) >> A_Wild_Turkey (14198)

North Karana

Old_Lady_Einarr.pl

Code:

# Zone: The Northern Plains of Karana (northkarana) >> Old_Lady_Einarr (13131)

sub EVENT_SAY {
	if ($text=~/hail/i) {
		if (quest::istaskactivityactive(273, 2)) { # Task: Help find my turkeys! 
			quest::say("Hello $name.  Is it [" . quest::saylink("wisdom") . "] you seek?");
		}
		else {
			quest::say("Hello $name.  Welcome to my home.");
		}
	}
	elsif ($text=~/wisdom/i) {
		if (quest::istaskactivityactive(273, 2)) { # Task: Help find my turkeys! 
			quest::say("Summoning wild turkey is no easy task. Our scarecrow knew the way, though. It's too bad he was kidnapped and taken South!");
			quest::updatetaskactivity(273, 2, 1); # Task: Help find my turkeys! 
		}
		else { # To Do:  Randomize a bunch of 'wise' answers for fun
			quest::say("The ones who are crazy enough to think that they can change the world, are the ones who do."); 
		}
	}
}

sub EVENT_ITEM {
	plugin::return_items(\%itemcount);
}

# EOF Zone: The Northern Plains of Karana (northkarana) >> Old_Lady_Einarr (13131)

player.pl (Add this to the END of your existing player.pl quest file)

Code:

sub EVENT_PLAYER_PICKUP {
	if ($picked_up_id == 147636) { # Ear of Corn (147636)
		if (quest::istaskactivityactive(273, 1)) {
			$client->Message(15, "yay, some corn!  But now what?");
			quest::updatetaskactivity(273, 1, 1);
		}
		else {
			$client->Message(15, "yay, some corn!");
		}
	}
}

East Karana

Lady_Glumr.pl

Code:

# Zone: Eastern Plains of Karana (eastkarana) >> Lady Glumr (15197)

sub EVENT_SAY {
	if ($text=~/hail/i) {
		if (quest::istaskactivityactive(273, 1)) { #Task: Help find my turkeys! 
			quest::say("Hello $name.  I come from up North--perhaps you can find some corn at my family's farm...if they have avoided the wild turkey.");
		}
		else {
			quest::say("Hello $name.  Welcome to my home.");
		}
	}
}

sub EVENT_ITEM {
	plugin::return_items(\%itemcount);
}

# EOF Zone: Eastern Plains of Karana (eastkarana) >> Lady Glumr (15197)

Master_Glumr.pl

Code:

# Zone: Eastern Plains of Karana (eastkarana) >> Master Glumr (13131)

sub EVENT_SAY {
	if ($text=~/hail/i) {
		if (quest::istaskactivityactive(273, 0)) { #Task: Help find my turkeys! 
			quest::say("Hello $name.  Look at this broken fence!  Some of our turkeys heard a [" . quest::saylink("wild call") . "] off in the distance and went crazy--they ran off with all of our corn.");
		}
		else {
			quest::say("Hello $name.  Would you just look at this broken fence!");
		}
	}
	elsif ($text=~/wild call/i) {
		if (quest::istaskactivityactive(273, 0)) { #Task: Help find my turkeys! 
			quest::say("Last night, right after sun down, an eerie call rose up from across the plain.  I've never heard anything like it. At once, our turkeys went mad!  They smashed through the fence, grabbed all the [" . quest::saylink("corn") . "], and ran off to the North!");
		}
		else {
			quest::say("Yes, we've heard those eerie calls as well. Perhaps you should ask my father if you're interested in them.");
		}
	}
	elsif ($text=~/corn/i) {
		if (quest::istaskactivityactive(273, 0)) { #Task: Help find my turkeys! 
			quest::say("We're poor farmers--the only thing we have to trade is our turkey meat.  Without corn, our turkeys will starve.  If you can find some corn, you may be able to lure them into the open so that we can recapture them.");
			quest::updatetaskactivity(273, 0, 1); #Task: Help find my turkeys! 
		}
		else {
			quest::say("Mmm--I love me some corn.");
		}
	}
}

sub EVENT_ITEM {
	if (plugin::check_handin(\%itemcount, 147637 =>1 )) {
		if (quest::istaskactivityactive(273, 6)) {
			quest::say("It's a miracle! Thank you so much, $name.  With this food our turkeys are sure to live.");
			quest::summonitem(147638); # Note to Farmer Glumr (147638)
			quest::say("Please take this note to my father to let him know of your great deeds!");
			quest::updatetaskactivity(273, 6, 1);
			quest::ding();
			quest::exp(600000);
		}
		else {
			quest::say("Thank you so much for this corn!");
			quest::ding();
			quest::exp(60000);
		}
	}
	plugin::return_items(\%itemcount);
}

# EOF Zone: Eastern Plains of Karana (eastkarana) >> Master Glumr (13131)

Plane of Knowledge

Farmer_Glumr.pl

Code:

# Zone: The Plane of Knowledge (poknowledge) >> Farmer_Glumr (202502)

sub EVENT_SPAWN {
	quest::settimer(1,600);
}

sub EVENT_TIMER {
	if ($timer == 1) {
		quest::say("Here turkey turkey turkey!");
	}
}

sub EVENT_SAY {
	if ($text=~/hail/i) {
		if (quest::istaskactivityactive(273,0)) { # Task: Help find my turkeys! 
			quest::say("Hello $name. Do you have any news on my turkeys?");
		}
		else {
			quest::say("Hello $name. I have prayed to Karana that a great $class like you would arrive to assist me--my turkeys have gone wild and all flown the coop!  Can you [" . quest::saylink("help") . "] me?");
		}
	}
	elsif ($text=~/help/i) {
		if (quest::istaskactivityactive(273,0)) { # Task: Help find my turkeys! 
			quest::say("So you do not have any news on my turkeys?");
		}
		else {
			quest::say("You must find them for me--head to my farm and speak with my son...he can tell you more.  Good luck, $name!");
			quest::assigntask(273, 0); # Task: Help find my turkeys! 
		}
	}
}

sub EVENT_ITEM {
	if (plugin::check_handin(\%itemcount, 147638 =>1 )) { # Note to Farmer Glumr (147638)
		quest::say("Thank you so much, $name!  Please, take some turkey meat for your troubles!");
		quest::summonitem(56051);  # Endless Turkeys (56051)
		quest::ding();
		quest::exp(600000);
	}
	plugin::return_items(\%itemcount);
}

# EOF Zone: The Plane of Knowledge (poknowledge) >> Farmer_Glumr (202502)

ghanja · #2 11-21-2017, 05:24 PM

Nice contribution bud, a bit corny but.. (tada)

May want to make use of last_insert_rowid() in the case of tasks id, but, you did give fair warning. Tried not to read it all, would rather play it.