These rewrites are pretty good.
That would be great, I'd love to hear the ideas.
And yeah, the area itself is really cool to walk around and explore.
These rewrites are pretty good.
That would be great, I'd love to hear the ideas.
Code: Select all
SQL
replace into creature_template (
entry, patch, display_id1, display_id2, display_id3, display_id4, name, subname, gossip_menu_id, level_min, level_max,
health_min, health_max, mana_min, mana_max, armor, faction, npc_flags, speed_walk, speed_run, scale, detection_range,
call_for_help_range, leash_range, rank, xp_multiplier, dmg_min, dmg_max, dmg_school, attack_power, dmg_multiplier,
base_attack_time, ranged_attack_time, unit_class, unit_flags, dynamic_flags, beast_family, trainer_type, trainer_spell,
trainer_class, trainer_race, ranged_dmg_min, ranged_dmg_max, ranged_attack_power, type, type_flags, loot_id,
pickpocket_loot_id, skinning_loot_id, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, spell_id1,
spell_id2, spell_id3, spell_id4, spell_list_id, pet_spell_list_id, gold_min, gold_max, ai_name, movement_type,
inhabit_type, civilian, racial_leader, regeneration, equipment_id, trainer_id, vendor_id, mechanic_immune_mask,
school_immune_mask, flags_extra, script_name)
values
('3570001', '0', '7993', '7993', '7993', '7993', 'Melvyck Fandazzle', '', '0', '42', '42',
'1850', '1850', '0', '0', '1200', '0', '2', '1', '1.14286', '1', '20',
'5', '0', '0', '1', '0', '0', '0', '0', '1',
'0', '0', '', '2', '0', '1', '0', '0',
'0', '0', '0', '0', '0', '7', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '', '0',
'3', '0', '0', '', '0', '0', '0', '0',
'0', '0', '');
Code: Select all
replace into creature_template (
entry, patch, display_id1, display_id2, display_id3, display_id4, name, subname, gossip_menu_id, level_min, level_max,
health_min, health_max, mana_min, mana_max, armor, faction, npc_flags, speed_walk, speed_run, scale, detection_range,
call_for_help_range, leash_range, rank, xp_multiplier, dmg_min, dmg_max, dmg_school, attack_power, dmg_multiplier,
base_attack_time, ranged_attack_time, unit_class, unit_flags, dynamic_flags, beast_family, trainer_type, trainer_spell,
trainer_class, trainer_race, ranged_dmg_min, ranged_dmg_max, ranged_attack_power, type, type_flags, loot_id,
pickpocket_loot_id, skinning_loot_id, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, spell_id1,
spell_id2, spell_id3, spell_id4, spell_list_id, pet_spell_list_id, gold_min, gold_max, ai_name, movement_type,
inhabit_type, civilian, racial_leader, regeneration, equipment_id, trainer_id, vendor_id, mechanic_immune_mask,
school_immune_mask, flags_extra, script_name)
values
('357002', '0', '5256', '5256', '5256', '5256', 'Jaffa', 'Melvyck\'s Assistant', '0', '42', '42',
'2450', '2450', '0', '0', '1800', '0', '1', '1', '1.14286', '1', '20',
'5', '0', '0', '1', '0', '0', '0', '0', '1',
'0', '0', '', '2', '0', '1', '0', '0',
'0', '0', '0', '0', '0', '7', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '', '0',
'3', '0', '0', '', '0', '0', '0', '0',
'0', '0', '');
Code: Select all
replace into quest_template values
('3570003', '0', '2', '357', '35', '42', '50', '0', '0', '0', '0',
'0', '0', '0', '0', '0','0',
'0', '0', '0', '0', '0', '0', '3570004', '0', '0',
'0', '0', '0', 'They Stole All Our Stuff!', 'Hey, I have heard about you! You’re %N, aren’t you? Starting to get quite the name for yourself. Well, I got a suggestion for you that will be good for that reputation of yours and help me too!
$B
$B
I heard about this weird infestation in the southern part of Feralas and just had to check it out. When strange things happen, gold can be made!
$B
$B
Me and my assistant, Jaffa, was about to survey the area when disaster struck! We were attacked at night and our camp raided. All our equipment lost. I simply cannot proceed without it. Could you help me get it back? I suppose there are clues somewhere about who did it.', 'Find out who raided Melvyck\'s camp in Feralas.', '', 'Have you found out who raided our camp?', 'Gnolls! It had to be Gnolls. I hate those ugly brutes.', '', '',
'', '', '35700031', '35700032', '35700033', '0', '1', '1', '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', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '', '0', '0', '0',
'0', '6000', '2040', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '1', '21', '0', '0',
'0', '0', '0', '0', '0','0',
0, 0);
replace into creature_questrelation values ('3570001','3570003','10','10');
replace into creature_involvedrelation values ('3570001','3570003','10','10');
Code: Select all
('35700033', '0', '12', '0', 'Woodpaw Pawprint', 'A piece of mud with a gnoll footprint', '8621', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('35700033', '0', '12', '0', 'Woodpaw Feather', 'A dirty feather on a piece of string', '19571', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('35700033', '0', '12', '0', 'Woodpaw Bead', 'A dark colored wooden bead', '16209', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('3570004', '0', '2', '357', '35', '42', '50', '0', '0', '0', '0',
'0', '0', '0', '0', '0','0',
'0', '0', '0', '0', '0', '3570003', '3570005', '0', '0',
'0', '0', '0', 'Investigate The Northern Gnoll Camp', 'There is a gnoll camp northwest of us $N. Perhaps you could start there and see if you can find our equipment?', 'Find Melvyck’s missing equipment in the gnoll camps in Feralas.', 'This is a disaster! We really needed these items. It’s time for plan B. As in plan Boom.', 'Have you found our equipment yet?', '', '', '',
'', '', '35700041', '35700042', '35700043', '0', '1', '1', '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', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '0',
'0', '6000', '2040', '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);
replace into creature_questrelation values ('3570001','3570004','10','10');
replace into creature_involvedrelation values ('3570001','3570004','10','10');
Code: Select all
('35700041', '0', '12', '0', 'Bent Microspanner', 'A bent and broken piece of engineering equipment', '7494', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '4', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('35700042', '0', '12', '0', 'Broken Ooglescope', 'A bent and broken piece of engineering equipment', '4283', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '4', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('35700043', '0', '12', '0', 'Unusable Spraxcapacitator', 'A bent and broken piece of engineering equipment', '31515', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '4', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('3570005', '0', '2', '357', '35', '43', '50', '0', '0', '0', '0',
'0', '0', '0', '0', '0','0',
'0', '0', '0', '0', '0', '3570004', '3570006', '0', '0',
'0', '0', '0', 'Investigate The Northern Gnoll Camp', 'I think we can skip some of the preliminary studies we intended and focus on the important stuff. We had a dozen crates of highly advanced goblin technology. The type of material that is essential to any scientist doing fieldwork.
$B
$B
Jaffa has learned that there are gnoll camps to the southeast. Perhaps you will have better luck there.', 'Search for Melvyck’s crates in the gnoll camps in Feralas.', 'Excellent work! This means that we will be able to proceed further.', 'Have you found our equipment yet?', '', '', '',
'', '', '35700041', '0', '0', '0', '12', '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', '0', '0', '0',
'0', '6000', '2040', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '21', '0', '0',
'0', '0', '0', '0', '0','0',
0, 0);
replace into creature_questrelation values ('3570001','3570005','10','10');
replace into creature_involvedrelation values ('3570001','3570005','10','10');
Code: Select all
('35700041', '0', '12', '0', 'Crate of Explosives', 'A heavy wooden crate that is nailed shut.', '7914', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '4', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('3570006', '0', '2', '357', '36', '44', '50', '0', '0', '0', '0',
'0', '0', '0', '0', '0','0',
'0', '0', '0', '0', '0', '3570005', '3570008', '0', '0',
'0', '0', '0', 'What Are Those Things', 'Before we perform our scientific experiments we should maybe learn a thing or two about those creatures that have tunneled into Feralas. Can you gather samples from the creatures scurrying around above ground?', 'Get Melvyck some samples from the strange creatures in Feralas.', 'This will work perfectly! Give us a moment to study what you have brought us.', 'Any luck getting samples from those strange creatures?', '', '', '',
'', '', '35700061', '35700062', '0', '0', '10', '10', '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', '0', '0',
'0', '6000', '2100', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '21', '0', '0',
'0', '0', '0', '0', '0','0',
0, 0);
replace into creature_questrelation values ('3570001','3570006','10','10');
replace into creature_involvedrelation values ('3570001','3570006','10','10');
Code: Select all
('35700061', '0', '12', '0', 'Carapace samples', 'A heavy wooden crate that is nailed shut.', '13002', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '4', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('35700062', '0', '12', '0', 'Slimy Organ Samples', 'A heavy wooden crate that is nailed shut.', '3341', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '4', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('35700033', '0', '12', '0', 'Woodpaw Pawprint', 'A piece of mud with a gnoll footprint', '16209', '1', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
('3570007', '0', '2', '357', '36', '44', '50', '0', '0', '0', '0',
'0', '0', '0', '0', '0','0',
'0', '0', '0', '0', '0', '', '', '0', '0',
'0', '0', '0', 'The Half-digested Notebook', 'A leather notebook with most of the cover and pages ruined. Whomever owned it must have studied the strange insectoids in southern Feralas. It is possible to read enough to understand what the creatures are called and where they come from: Silithids from the desert lands to the south.
$B
$B
The notebook is unreadable, with the exception of a few short passages. It will probably be of interest to the goblin Melvyck Fandazzle.', 'Show the half digested notebook to Melvyck Fandazzle in Feralas.', 'Brilliant! Know we know the name of those things and where they come from.', 'Have you found something interesting?', '', '', '',
'', '', '35700071', '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', '0',
'0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '0',
'0', '', '750', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '21', '0', '0',
'0', '0', '0', '0', '0','0',
0, 0);
replace into creature_questrelation values ('3570001','3570007','10','10');
replace into creature_involvedrelation values ('3570001','3570007','10','10');
Code: Select all
-- A Golden Opportunity?
replace into quest_template (prevquestid, entry, zoneorsort, questlevel, minlevel, questflags, specialflags, title, details, objectives, requestitemstext, offerrewardtext, reqitemid1, reqitemcount1, reqitemid2, reqitemcount2, reqitemid3, reqitemcount3, reqitemid4, reqitemcount4, reqcreatureorgoid1, reqcreatureorgocount1, reqcreatureorgoid2, reqcreatureorgocount2, reqcreatureorgoid3, reqcreatureorgocount3, reqcreatureorgoid4, reqcreatureorgocount4, srcitemid, srcitemcount, reworreqmoney, rewmoneymaxlevel, rewrepfaction1, rewrepvalue1, rewrepfaction2, rewrepvalue2, rewrepfaction3, rewrepvalue3, rewrepfaction4, rewrepvalue4, rewspell, rewspellcast, completeemote, rewitemid1, rewitemcount1, rewitemid2, rewitemcount2, rewitemid3, rewitemcount3, rewitemid4, rewitemcount4, rewchoiceitemid1, rewchoiceitemcount1, rewchoiceitemid2, rewchoiceitemcount2, rewchoiceitemid3, rewchoiceitemcount3, rewchoiceitemid4, rewchoiceitemcount4, rewchoiceitemid5, rewchoiceitemcount5, rewchoiceitemid6, rewchoiceitemcount6) values ('3570007', '3570008', '357', '45', '36', '0', '0', 'A Golden Opportunity?', 'I have studied the Silithid samples you brought me and I think I have an idea: we can fashion the carapaces into armor. It’s tough, only smells a bit and the way those things breed we will have an infinite supply! How about getting me enough bits to get started?', 'Bring 30 pieces of Silithid carapace to Melvyck Fandazzle in Feralas.', 'You won’t find any carapaces standing around here.', 'Excellent work. I am sure I am on the brink of the most successful venture goblinkind has seen since the invention of the pneumatic toothbrush!', '35700081', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '2850', '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');
replace into creature_questrelation (id, quest) values (3570001, 3570008);
replace into creature_involvedrelation (id, quest) values (3570001, 3570008);
Code: Select all
('35700081', '12', '15', 'Smelly Silithid Carapace', 'It\'s really disgusting.', '13002', '7601', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '-1', '0', '0', '0', '3570006', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
-- An Explosive Gesture
replace into quest_template (prevquestid, entry, zoneorsort, questlevel, minlevel, questflags, specialflags, title, details, objectives, requestitemstext, offerrewardtext, reqitemid1, reqitemcount1, reqitemid2, reqitemcount2, reqitemid3, reqitemcount3, reqitemid4, reqitemcount4, reqcreatureorgoid1, reqcreatureorgocount1, reqcreatureorgoid2, reqcreatureorgocount2, reqcreatureorgoid3, reqcreatureorgocount3, reqcreatureorgoid4, reqcreatureorgocount4, srcitemid, srcitemcount, reworreqmoney, rewmoneymaxlevel, rewrepfaction1, rewrepvalue1, rewrepfaction2, rewrepvalue2, rewrepfaction3, rewrepvalue3, rewrepfaction4, rewrepvalue4, rewspell, rewspellcast, completeemote, rewitemid1, rewitemcount1, rewitemid2, rewitemcount2, rewitemid3, rewitemcount3, rewitemid4, rewitemcount4, rewchoiceitemid1, rewchoiceitemcount1, rewchoiceitemid2, rewchoiceitemcount2, rewchoiceitemid3, rewchoiceitemcount3, rewchoiceitemid4, rewchoiceitemcount4, rewchoiceitemid5, rewchoiceitemcount5, rewchoiceitemid6, rewchoiceitemcount6) values ('3570008', '3570009', '357', '45', '36', '0', '0', 'An Explosive Gesture', 'Ever heard of strip mining? Well, we goblins have taken it a step further. The science is probably beyond you but suffice to say that we call it boom mining. I am sure we could apply it in our venture here to ensure a large amount of only slightly charred carapaces at once. With your wits, you’re the right %R for the job! I have rigged a device to use in the Silithid tunnels. You have to hurry though. I had to go manual on this so the ignition device is what we in the trade call a fuse.
$B
$B
Remember, a crucial part in using a device like this is a hasty removal of yourself from the area. If it goes boom, you’re not gonna like it!
$B
$B
When you’ve thrown it, keep your distance. Then just gather the carapaces.', 'Throw the Massive Scientific Goblin Mining Device at a Silithid inside the tunnels in Feralas.', 'I would hurry, if I were you!', 'Darn it! Back to the drawing board. Oh well. It was a fun boom, wasn’t it? If I come up with any other bright ideas I will get in touch with you again. So long %N.', '35700091', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '8000', '2850', '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');
replace into creature_questrelation (id, quest) values (3570001, 3570009);
replace into creature_involvedrelation (id, quest) values (3570001, 3570009);
Code: Select all
('35700091', '12', '0', 'Useless Carapace Scrap', 'A burnt piece of Silithid Carapace', '34172', '0', '0', '1', '0', '0', '0', '-1', '-1', '0',
'0', '0', '0', '0', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0',
'0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
'-1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);
Code: Select all
-- Speak to Zorbin
replace into quest_template (prevquestid, entry, zoneorsort, questlevel, minlevel, questflags, specialflags, title, details, objectives, requestitemstext, offerrewardtext, reqitemid1, reqitemcount1, reqitemid2, reqitemcount2, reqitemid3, reqitemcount3, reqitemid4, reqitemcount4, reqcreatureorgoid1, reqcreatureorgocount1, reqcreatureorgoid2, reqcreatureorgocount2, reqcreatureorgoid3, reqcreatureorgocount3, reqcreatureorgoid4, reqcreatureorgocount4, srcitemid, srcitemcount, reworreqmoney, rewmoneymaxlevel, rewrepfaction1, rewrepvalue1, rewrepfaction2, rewrepvalue2, rewrepfaction3, rewrepvalue3, rewrepfaction4, rewrepvalue4, rewspell, rewspellcast, completeemote, rewitemid1, rewitemcount1, rewitemid2, rewitemcount2, rewitemid3, rewitemcount3, rewitemid4, rewitemcount4, rewchoiceitemid1, rewchoiceitemcount1, rewchoiceitemid2, rewchoiceitemcount2, rewchoiceitemid3, rewchoiceitemcount3, rewchoiceitemid4, rewchoiceitemcount4, rewchoiceitemid5, rewchoiceitemcount5, rewchoiceitemid6, rewchoiceitemcount6) values ('3570009', '3570010', '357', '52', '36', '0', '0', 'Speak to Zorbin', 'I’ve got a cousin you should speak to, Zorbin Fandazzle. He hangs out down by the shore, next to where the boats to Feathermoon Stronghold leave. Zorbin was in need of some assistance in regards to his research. Why don’t you head over there and see if you can lend him a hand?', 'Speak with Zorbin Fandazzle in western Feralas.', 'Yeah, wadda ya want?', 'Melvyck sent you, huh? Any friend of his is a friend of mine', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '750', '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');
replace into creature_questrelation (id, quest) values (3570001, 3570010);
replace into creature_involvedrelation (id, quest) values (14637, 3570010);
That's a very cute little quest line. I really like it.