Online Quest & Item Creator

[Mac]

These rewrites are pretty good.

I will have a look at your quest-proposals and maybe you like to hear some of my ideas too. I have only ideas for the Warlock quests, when walking around there, I can easily inmagine what the plan was for this.

That would be great, I'd love to hear the ideas.

And yeah, the area itself is really cool to walk around and explore.

[Morticrun]

.

[Hamstercrack93]

I have finally had the time to finish this (deleted the previous post). Hopefully I got all the variables, but probably missing something. The second to last quest also requires a timed explosive device, which might be a an issue. Not sure if there is an in game device already that can be used.

If anyone checks this, please point out any mistakes and I'll keep it in mind for later.


+++++++++++++++++++++++++++++++++++++


For Id’s I just started with Zone ID and then 0001 after. For items, added a 1 to the quest ID.

The idea is a pretty simple quest chain involving the gnolls and silithid in eastern Feralas. Available to both Horde and Alliance.

Two new NPCs, the quest giver and his assistant. A bit to the north of the road coming from Thousand Needles. Would need a small camp area but devoid of stuff (as they have been robbed).


FERALAS QUESTS
Zone ID: 357


Melvyck Fandazzle
3570001
DisplayID 7993
“Goblin”
Gossip Dialogue: 357001_1
“Yeah, wadda ya want?”

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', '');

Jaffa
Melvyck’s Assistant
357002
DisplayID '5256'
“Huge troll”
Gossip Dialogue: 3570002_1
“Me smart assistant. You talk boss goblin, hokay?”

SQL

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', '');

++++++++++++++

They Stole All Our Stuff!
Quest level 42, min 35, max 50
3570003
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.

0/1 Woodpaw Pawprint
0/1 Woodpaw Feather
0/1 Woodpaw Bead

Objective
Find out who raided Melvyck's camp in Feralas.
Progress
Have you found out who raided our camp?
Completion
Gnolls! It had to be Gnolls. I hate those ugly brutes.
Rewards
You will receive: 60s
Gains
Upon completing this quest you will receive
3400 XP

SQL

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');

0/1 Woodpaw Pawprint
35700031
A piece of mud with a gnoll footprint
SQL
replace into item_template values

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);

0/1 Woodpaw Feather
35700032
A dirty feather on a piece of string
SQL
replace into item_template values

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);

0/1 Woodpaw Bead
35700033
A dark colored wooden bead
SQL
replace into item_template values

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);

++++++++++++++

Investigate The Northern Gnoll Camp
Quest level 42, min 35, max 50
3570004
There is a gnoll camp northwest of us $N. Perhaps you could start there and see if you can find our equipment?

0/1 Bent Microspanner
0/1 Broken Ooglescope
0/1 Unusable Spraxcapacitator

Objective
Find Melvyck’s missing equipment in the gnoll camps in Feralas.
Progress
Have you found our equipment yet?
Completion
This is a disaster! We really needed these items. It’s time for plan B. As in plan Boom.
Rewards
You will receive: 60s
Gains
Upon completing this quest you will receive
3400 XP

SQL
replace into quest_template values

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');

Bent Microspanner
35700041
A bent and broken piece of engineering equipment
SQL
replace into item_template values

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);

Broken Ooglescope
35700042
A bent and broken piece of engineering equipment
SQL
replace into item_template values

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);

Unusable Spraxcapacitator
35700043
A bent and broken piece of engineering equipment
SQL
replace into item_template values

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);

++++++++++++++

60Applied Goblin Science
Quest level 43, min 35, max 50
3570005
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.

0/12 Crates of Explosives

Objective
Search for Melvyck’s crates in the gnoll camps in Feralas.
Progress
Have you found our equipment yet?
Completion
Excellent work! This means that we will be able to proceed further.
Rewards
You will receive: 60s
Gains
Upon completing this quest you will receive
3400 XP

SQL
replace into quest_template values

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');

Crate of Explosives
35700041
A heavy wooden crate with the label “Explosives!”
SQL
replace into item_template values

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);

++++++++++++++

What Are Those Things
Quest level 44, min 36, max 50
3570006
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?

0/10 Carapace samples
0/10 Slimy Organ Samples

Objective
Get Melvyck some samples from the strange creatures in Feralas.
Progress
Any luck getting samples from those strange creatures?
Completion
This will work perfectly! Give us a moment to study what you have brought us.
Rewards
You will receive: 60s
Gains
Upon completing this quest you will receive
3500 XP

SQL
replace into quest_template values

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');

Carapace samples
80% drop rate from Zukk'ash Worker and Zukk'ash Wasp
35700061
It’s hard and somewhat smelly
SQL
replace into item_template values

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);

Slimy Organ Samples
80% drop rate from Zukk'ash Worker and Zukk'ash Wasp
35700062
It’s really disgusting
SQL
replace into item_template values

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);

++++++++++++++

Half-digested notebook
Quest level 44, min 36, max 50
35700071
Object drops when on the quest 3570006 “What Are Those Things”
Drop rate 33% from Zukk'ash Worker and Zukk'ash Wasp
This item starts a quest
Unique
Not sure how to mark this item. Set it as Miscellaneous...

SQL
replace into item_template values

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);

The Half-digested Notebook
3570007
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.

Objective
Show the half digested notebook to Melvyck Fandazzle in Feralas.
Progress
Have you found something interesting?
Completion
Brilliant! Know we know the name of those things and where they come from.
Rewards
You will receive: 0c
Gains
Upon completing this quest you will receive
1250 XP

SQL
replace into quest_template values

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');

++++++++++++++


A Golden Opportunity?
Quest level 45, min 36, max 52
3570008
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?

0/30 Smelly Silithid Carapace

Objective
Bring 30 pieces of Silithid carapace to Melvyck Fandazzle in Feralas.
Progress
You won’t find any carapaces standing around here.
Completion
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!
Rewards
You will receive: 80s
Gains
Upon completing this quest you will receive
4750 XP

SQL

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);

Smelly Silithid Carapace
80% drop rate from Zukk'ash Worker, Zukk'ash Wasp, Zukk'ash Tunneler and Zukk'ash Stinger
35700081

SQL
replace into item_template values

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);

++++++++++++++

An Explosive Gesture
Quest level 45, min 36, max 52
3570009
10 minute timer
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.

0/1 Use Massive Scientific Goblin Mining Device
0/1 Useless Carapace Scrap

Idea is as follows:
Effect: blast with 20 y radius dealing 10000 fire damage
Thrown, like you would use an engineering grenade
Need to be kill a Zukkash Stinger or Tunneler, which would be possible just outside tunnels as well
After timer runs out it detonates (sucks to be you)

Objective
Throw the Massive Scientific Goblin Mining Device at a Silithid inside the tunnels in Feralas.
Progress
I would hurry, if I were you!
Completion
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.
Rewards
You will receive: 80s

Gains
Upon completing this quest you will receive
4750 XP


SQL

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);

Useless Carapace Scrap
35700091
A burnt piece of Silithid Carapace
100% drop rate from any silithid killed by the explosion

SQL
replace into item_template values

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);

++++++++++++++



Speak to Zorbin
Quest level 45, min 36, max 52
3570010
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?

Objective
Speak with Zorbin Fandazzle in western Feralas.
Progress
Yeah, wadda ya want?
Completion
Melvyck sent you, huh? Any friend of his is a friend of mine.
Rewards
You will receive: 0c
Gains
Upon completing this quest you will receive
1250 XP



SQL

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);

[Qixel]

So in Vanilla, there are lots of unique weapons that fill a cool niche or have an interesting effect that just don't have any upgrades. These weapons often fall of out favor simply by being outclassed in raw power by newer, higher level weapons, and I feel that's kind of a shame. I think the option to upgrade these interesting weapons would be fantastic. Not to the point that they are stronger than the higher weapons, of course, but to the point that the gap has been closed enough that you could justify using them for their unique functions.

That brings me to a custom NPC, Lorekeeper Chaesys (you can change the name if you want). Chaesys is a high elf, who has been around for millenia, and during his long life has seen many an interesting weapon. He's formed a fascination for weapons, and he's more than happy to help you improve an interesting weapon. He's currently hanging out by Karazhan, because that's surely where a lot of powerful weapons are held, which would also open up the possibility of using him for quests later, too. ;D The Dark Riders of Karazhan had been known to store interesting weapons in the tower, after all.

I've made one quest so far, to improve Hurricane. Now, Hurricane is an interesting weapon; it has an above average speed, and a rare proc effect on a ranged weapon. These functions combine to make it a truly unique weapon, but its level limits its usability. As such, a quest to upgrade it to closer to Molten Core quality. Chaesys will send the player into the Stormwind Vaults to obtain a shard of Arc'tiras, the final boss, along with three nexus crystals to upgrade the bow into Tempest. (Item linking seems to be broken atm, so I will link to a screenshot instead. Sorry for the inconvenience. D: ) The renewed bow gains 1% crit, ups its rate of fire by .1 second, and increases the dps to a level slightly below Striker's Mark.

Code: Select all

**Previous quest:** None
**Title:** A Storm of Arrows
**Quest NPC (Start)**: Lorekeeper Chaesys
**Quest NPC (End)**: Lorekeeper Chaesys
**Quest level:** 60
**Required level:** 60
**Quest zone ID:** 41
**Main description:** Ah, Hurricane! A weapon of great power, but one that is, unfortunately, incomplete. Its true power has been lost to the ravages of time, the elemental magic that once powered it scattered. I saw it once, in my youth. It seemed to thrum with power, as the magnificent archer who wielded it seemed to fire arrows faster than the entire squad around them! It's how it got its name, you know? 'Hurricane', for the sight of the storm of arrows it seemed to let fly.
**\n\n**
I've lived so long, but never did I dream that I would lay eyes upon it once more. Please, champion! Assist me in returning it to its true, glorious form! To accomplish the feat, we'll need the essence of a powerful elemental, several crystals of arcane power to bind the essence to the bow, and of course, Hurricane itself. 
**Short objective:** Obtain Hurricane, a Shard of Crystallized Storm from Arc'tiris, and three Nexus Crystals, and return them to Lorekeeper Chaesys in Deadwind Pass.
**Progress text**: Oh, champion! Please, tell me you've gathered the necessary components! 
**\n\n**
I've heard rumor of a powerful being of ice and storm imprisoned within the Vaults beneath Stormwind; perhaps it would have the power we need to restore the mighty weapon...
**Completion:** Ahhh!  This curvature, this form, the elemental power that seems to hum as you pull the string! It's beautiful. Thank you, champion. To see this marvelous weapon restored to its full potential - nay, to heights greater than its peak! - makes this long life have been worth living. 'Hurricane' no longer seems an apt nomenclature for its power; henceforth and forever more, it shall be 'Tempest'! Go forth, champion! Go, use the great bow Tempest to darken the skies with arrows, to demoralize your enemies with the howling wind of the bowstring, to make sure all know the great power of the storm!
**Required items:** Hurricane, Shard of Crystallized Storm, Nexus Crystal x3
**— Rewards**
**Money:** None
**Reputation:** None
**XP:** 6150XP
**Items:** Tempest
**Additional notes:** If it would be possible for Lorekeeper Chaesys to only offer the quest to players who have Hurricane so that he doesn't just seem like a crazy old man shouting at clouds, that would be awesome, but I don't know how to go about that if it is.

If the concept is enjoyed enough, Chaesys could offer similar quests for other items. :D There's many cool weapons that fall off, after all.

[Bitterman]

I dont have any experience in this, but this is more of a request.
is it possible to add the Second part of the Missing Diplomat questline?

viewtopic.php?f=14&t=2558&sid=4c5ab1429 ... 365a07f41e

[Monmothma21]

I was trying this tool out and had some moderate success. I have a question - is it technicaly possible to make a quest where player would have to challenge 2 friendly npcs in to a duel(not to the death) via talking to them? If yes, how is this going to be handled?

______________________________________________

Thank you.

[Chnams]

So after some discussion in the Paladin channel of the discord server, I came up with a fun little quest about a gnome with a dream. It's a level 29 quest that starts in the Citadel of Light with Brother Sarno about investigating a gnome that allegedly wants to become a paladin. He gets refused, though, so he makes a fuss, gets kicked out of the Cathedral and starts claiming that the priests and paladins are crooks. Also, he's talking some nonsense about... light particles? Your job is to go talk some sense into him and persuade him to leave.

The first quest is as follows (using spoiler tags as to not make the post extremely long):

Code: Select all

**Title:** The Confused Gnome
**Quest NPC (Start)**: 7917, Brother Sarno
**Quest NPC (End)**: Mimlooz Fizzlecrank
**Quest level:** 29
**Required level:** 25
**Quest zone ID:** 1519

**Main description:** %N? May I have a word? There’s been… somewhat of a commotion earlier today. A gnome, clad in some clothing that looked like a mix of fabric and gears, came into the Cathedral this morning, asking to be taken under the wing of Lord Duthorian Rall to be trained as a would-be Paladin. Of course, as you may know, gnomes are not exactly… “sensitive” to the Light, shall we say. They tend to be more inclined towards more earthly pursuits like creating intricate machinery or learning about the arcane. As such, we do not take them in for ecclesiastical training, and we prefer to redirect them to the Mage District. That is what Bishop Farthing told him then. So, after some back-and-forth arguing and the gnome spouting some nonsense about some “Light particles” that allegedly all of us holy men have in our bodies, the Archbishop himself asked the guards to escort him out as he was causing quite the ruckus. Now, he’s been banned from entering the Cathedral proper, but he’s still posted in the surrounding area, claiming to whoever will listen that we are “false holy servants” and “a disgrace to the Light itself”. I feel bad for him, I think he’s confused about the ways of the Light, but he is being very troublesome. Would you please go talk some sense into him? We don’t need someone scaring away the refugees and the future aspirants. Thank you.

**Short objective:** Find the Gnome outside of the Cathedral of Light.
**Progress text**: Yes, $r? What is it?.
**Completion:** What do you want? I'm very busy! The truth shall come out one way or another!
**Required creature kills**: None.
**Required items**: None.
**— Rewards**
**Money:** 
**Reputation:** Stormwind: 25
**XP:** 150XP 
**Additional notes:** No custom mechanics, just go seek out the gnome outside of the Citadel of Light in Stormwind

The second quest is this one:

Code: Select all

*Previous quest:** The Confused Gnome
**Title:** Confused? How Dare They!
**Quest NPC (Start)**: Mimlooz Fizzlecrank
**Quest NPC (End)**: Mimlooz Fizzlecrank
**Quest level:** 30
**Required level:** 25
**Quest zone ID:** 1519

**Main description:** Who sent you? The Bishop? Bah! I don’t need this! This whole church is a fraud! They claim to want to serve the Light? Ha! I wanted to, as well. You see, ever since I was but a young gnome, I’ve always wanted to become a Paladin. I dreamed of glory, of being able to serve the innocent, to heal the sick, and to smite evil. But no, my father wanted me to be an engineer, like his father and grandfather before him, so I could take over the family gizmo shop in Gnomeregan. So I begrudgingly became an apprentice in the ways of engineering and my dreams flew away. That is, until Gnomeregan became an irradiated nightmare overnight and we all had to flee. So, no more gizmo shop! I was finally free to pursue a greater calling! I immediately came to Stormwind, to the great Cathedral of Light, so I could finally receive the training I so wanted. But they refused me! On the basis that I am “just a gnome” and that “I don’t seem like a man of faith” and I must be “confused about the workings of the Light”. Confused? CONFUSED?! OUTRAGEOUS! THAT’S MY DREAM YOU’RE TALKING ABOUT! I’ll show them! I’ll prove to them that a gnome can be just as spiritual as any of them! It’s all about the Holychlorians, you see. Light particles! Every Paladin, every Priest, every holy man has those. That’s how you know they can become men of faith! And I’ll be damned if I let those… nincompoops!... get in the way of my true purpose! I’ll show them that I’m just as capable as they are! With SCIENCE!
Anyway, this is where my engineering knowledge will come in handy. Who knew it would actually help me reach my goal? Unfortunately, I lost most of my possessions when Gnomeregan became uninhabitable.I still have some things left, but I’m going to need more to make a device that will let me measure Light Particles. Let’s see… I’m going to need fabric, some power cores, and an iridescent pearl! I’d make the power cores myself, but I left all my tools in my home, like I said… Irradiated city and all that… If you’re not an Engineer, you can find someone who is and ask them to make you one. Or go have a look at the auction house, surely someone there will be selling one…Could I ask you to get all that for me? Please, help me, %N, you’re my only hope.

**Short objective:** Gather the reagants for Mimlooz's invention.
**Progress text**: Do you have the stuff? Please hurry, my dream is waiting!
**Completion:** That’s it! That’s what I needed! Oh, thank you so much! Here, I don’t have a lot left on me, but I’ll reward you however I can.
**Required creature kills**: None.
**Required items**: 10 Silk Cloth (4306), 2 Gold Power Core (10558), 1 Iridescent Pearl (5500)
**— Rewards**
**Money:** 40s
**Reputation:** Gnomeregan Exiles: 250
**XP:** 4000XP 
**Additional notes:** No custom mechanics. Collect items and come back to the NPC.

The third quest would be this:

Code: Select all

*Previous quest:** Confused? How Dare They!
**Title:** Holychlo-what Now?
**Quest NPC (Start)**: Mimlooz Fizzlecrank
**Quest NPC (End)**: Mimlooz Fizzlecrank
**Quest level:** 30
**Required level:** 25
**Quest zone ID:** 1519

**Main description:** Okay! With what you brought me, I have created a machine that will measure the level of Holychlorians in any given person! I call it the HOL-13R-TH-4N-TH-0U! Kind of a mouthful, I know. I need to work on the name, but that’s not our priority right now. Before I can prove to the fools at the Cathedral of Light that I’m perfectly capable of becoming a gnome of faith, I need to test my invention. But considering I’m still banned from the Cathedral, you’re going to have to do it for me. Here, take it. Use it on some of the practitioners of the Light around here, say a paladin of the Silver Hand, the high priestess, and the Archbishop himself, just to calibrate the device.

**Short objective:** Calibrate the HOL-13R-TH-4N-TH-0U.
**Progress text**: Well? Any results?
**Completion:** Great! Now that it’s calibrated, all that’s left to do is to point it towards myself and admire the results…
**Required creature kills**: Technically not kills, but here are the NPCs you need to use the item on: High Priestess Laurena (376), Duthorian Rall (6171), Archbishop Benedictus (1284).
**Required items**: H0L-13R-TH-4N-TH-0U
**— Rewards**
**Money:** 35s
**Reputation:** Gnomeregan Exiles: 250
**XP:** 3000XP 
**Additional notes:** The quest should give you a usable item called [url=https://dev.turtle-wow.org/#!/itemcreator/WzgwMDAsMTIsMCwiSDBMLTEzUi1USC00Ti1USC0wVSIsIkEgd29lZnVsbHktbmFtZWQgaW52ZW50aW9uIGJ5IE1pbWxvenogRml6emxlY3JhbmsuIiwyMDYyNiwxLDY0LDEsMCwwLDAsLTEsLTEsMCwwLDAsMCwwLDAsMCwwLDAsMCwxLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMzAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMjgwNTYsMCwwLDAsMTAwMDAsMCwtMSwwLDAsMCwwLC0xLDAsLTEsMCwwLDAsMCwtMSwwLC0xLDAsMCwwLDAsLTEsMCwtMSwwLDAsMCwwLC0xLDAsLTEsNCwwLDAsMCwwLDAsMSwxLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDEsIk5VTEwiXQ==]
H0L-13R-TH-4N-TH-0U[/url]. The item would ideally play a "zap" animation (think chain lightning but 0 damage) on the quest NPCs to signify that you're using the item on them. Additionally, for fluff, the item could say in chat "CLICK! Holychlorians detected! Calibrating..." when you use it on a quest NPC, and "CLICK! Holychlorians detected! Calibration complete!" instead when you use it on the final NPC. When you're done, return to the NPC.

At that point, the NPC should zap himself (same animation as for the previous quest), the device should say in chat "CLICK! Extremely high levels of Holychlorians detected!". Mimlozz should then play a "laugh" emote and say in chat “It works! Wait, extremely high…? I knew it! I knew this was my destiny! Beware, foul practitioners of the dark arts, for I, Mimlozz, will soon be a champion of the Light, ready to smite all evildoers!”.

The next quest then becomes available. It auto-completes as you accept it, you only have to turn it in. Mimlooz is very grateful and offers you a reward:

Code: Select all

*Previous quest:** Holychlo-what Now?
**Title:** The Chosen One
**Quest NPC (Start)**: Mimlooz Fizzlecrank
**Quest NPC (End)**: Mimlooz Fizzlecrank
**Quest level:** 30
**Required level:** 25
**Quest zone ID:** 1519

**Main description:** It worked! It worked! Did you hear? It says I have extremely high levels of Holychlorians in my body! I knew it all along! Ever since I was a child, my dreams of honor, of helping the innocent, of curing the ailing, of vanquishing the darkness! I really was destined for something greater than taking care of the family’s stupid gizmo shop! Take that, father! “You’re not fit to be a Paladin”, “You’re too smart for adventures, follow the family trade instead”, yeah right! Now you’ll see what I’m truly capable of! 
I’m going to show these results to Lord Duthorian Rall. He seemed to be the most reasonable out of all of them, surely he’ll understand and he’ll help me achieve my true destiny! Thank you so much for your help, %N! You helped a poor gnome who lost his home to realize his dreams. And for that, you deserve a reward. Like I said before, I don’t have much left since Gnomeregan, but I can give you this. I won’t need that for my new career after all!.

**Short objective:** None, the quest auto-completes
**Progress text**: None, the quest auto-completes
**Completion:** None, the quest auto-completes
**Required creature kills**: None
**Required items**: None
**— Rewards** . You can choose between [url=https://dev.turtle-wow.org/#!/itemcreator/WzgwMDEsNCwwLCJJcnJhZGlhdGVkIEdub21pc2ggUGVuZGFudCIsIkl0J3MgZ2xvd2luZy4uLiBpcyB0aGlzIHNhZmUgdG8gdXNlPyIsNTkyNCwyLDAsMSwwLDEwNTUsMiwtMSwtMSwzMCwwLDAsMCwwLDAsMCwwLDAsMCwxLDAsNSw3LDcsNSw2LDUsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsNSwwLDAsMCwwLDAsMCwwLC0xLDAsLTEsMCwwLDAsMCwtMSwwLC0xLDAsMCwwLDAsLTEsMCwtMSwwLDAsMCwwLC0xLDAsLTEsMCwwLDAsMCwtMSwwLC0xLDEsMCwwLDAsMCwwLDQsMSwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwxLCJOVUxMIl0=][Irradiated Gnomish Pendant][/url], [url=https://dev.turtle-wow.org/#!/itemcreator/WzgwMDIsNCwyLCJXb3Jrc2hvcCBHbG92ZXMiLCJJbnRlZ3JhdGVzIGxpdHRsZSB0b29scyB0byBoZWxwIHRoZSB1c2VyIHdpdGggbWVjaGFuaWNhbCB3b3JrLiBIYW5keSEiLDIxNjQsMiwwLDEsMCwyMTI4LDEwLC0xLC0xLDMwLDAsMCwwLDAsMCwwLDAsMCwwLDEsMCwzLDYsNCw0LDUsNCw3LDQsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCw4MCwwLDAsMCwwLDAsMCwwLDAsMCwwLC0xLDAsLTEsMCwwLDAsMCwtMSwwLC0xLDAsMCwwLDAsLTEsMCwtMSwwLDAsMCwwLC0xLDAsLTEsMCwwLDAsMCwtMSwwLC0xLDEsMCwwLDAsMCwwLDgsMSwwLDAsNDUsMCwwLDAsMCwwLDAsMCwwLDAsMSwiTlVMTCJd]Workshop Gloves[/url], [url=https://dev.turtle-wow.org/#!/itemcreator/WzgwMDMsMiw0LCJPdmVyaGVhdGVkIEFyY2xpZ2h0IFNwYW5uZXIiLCJBbiBmYWlsZWQgYXR0ZW1wdCBhdCBjcmVhdGluZyBhIHRvb2wgdGhhdCBjb3VsZCBjb29sIHlvdSBkb3duIHdoZW4gdXNpbmcgaXQgaW4gYSB3YXJtIHdvcmtzaG9wLiBJdCBmZWVscyB0b2FzdHkgdG8gdGhlIHRvdWNoLiIsNzQ5NCwyLDAsMSwwLDM4MDAsMjEsLTEsLTEsMzAsMCwyMDIsMTUwLDAsMCwwLDAsMCwwLDEsMCw0LDgsMyw4LDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMjAwMCwwLDAsMzAsNDUsMCw1LDEwLDIsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsLTEsMCwtMSwwLDAsMCwwLC0xLDAsLTEsMCwwLDAsMCwtMSwwLC0xLDAsMCwwLDAsLTEsMCwtMSwwLDAsMCwwLC0xLDAsLTEsMSwwLDAsMCwwLDAsMSwzLDAsMCw1MCwwLDAsMCwwLDAsMCwwLDAsMCwxLCJOVUxMIl0=]Overheated Arclight Spanner[/url] and [url=https://dev.turtle-wow.org/#!/itemcreator/WzgwMDQsNCwwLCJNaW1sb296J3MgQ3VzdG9tLU1hZGUgUmluZyIsIllvdSBjYW4gcmVhZCAnQmFkYXNzIE0uRi4nIGVuZ3JhdmVkIG9uIHRoZSBzaWRlLiIsMTU4MjUsMiwwLDEsMCwxODUwLDExLC0xLC0xLDMwLDAsMCwwLDAsMCwwLDAsMCwwLDEsMCwwLG51bGwsMCw0LDUsOSw3LDMsNiw0LDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDAsLTEsMCwtMSwwLDAsMCwwLC0xLDAsLTEsMCwwLDAsMCwtMSwwLC0xLDAsMCwwLDAsLTEsMCwtMSwwLDAsMCwwLC0xLDAsLTEsMSwwLDAsMCwwLDAsNCwxLDAsMCwwLDAsMCwwLDAsMCwwLDAsMCwwLDEsIk5VTEwiXQ==]Mimlozz's Custom-Made Ring[/url]. If the rewards are overtuned, they can of course be adjusted. I would've liked the Workshop Gloves to give a +5 to Engineering but I couldn't figure out how to do that in the item editor. I'm also not sure how useful that would be, so it could be turned into +5 to Mining instead, maybe.  
**Money:** 35s
**Reputation:** Gnomeregan Exiles: 250
**XP:** 3750XP 
**Additional notes:** None. 

The questline ends here. I have ideas on continuing Mimlooz's story at a much higher level in the Western Plaguelands, but that's for another time. I sprinkled some obvious Star Wars references in there as this whole questline came up because of a discussion about Star Wars. However, I think it doesn't stand out too much from the Warcraft universe, just read the quest text and you'll see what I mean. Gnomes have crazy ideas after all.

I hope I formatted my post properly this time. It's also the first time I use the server's item/NPC/quest creation tools and the first time I actually try to create a quest for WoW, so I'd love some feedback on this! :)
And if it somehow makes its way into the game, well, I'd be overjoyed :D

[Mac]

So after some discussion in the Paladin channel of the discord server, I came up with a fun little quest about a gnome with a dream.

That's a very cute little quest line. I really like it.

As for adding +5 Engineering to the gloves, it would be somewhat useful since, if I recall correctly, the level of a summoned engineering pet is based on your Engineering skill level, and a +5 would add a level to their pets. That said, I don't think that's overpowered by any means.

[Linwuyi]

I was thinking that having a cooking trainer in brill would be convenient.. so I basically took a cook from cataclysm and tried making it on a developer tool..

https://dev.turtle-wow.org/#!/npccreato ... wwLCIiXQ==

Since there is no cooking tent outside the tavern, i though of making him walk every 2 minutes between the meat table and the fireplace, like so:
https://cdn.discordapp.com/attachments/ ... 8/chef.png

My proficiency with the tool is not vey good so check if there are any issues with the details of the npc.

[Jam]

Is the turtle wow team still interested in community quests and items? If so, is there any area of focus one should look at for designing quests and items?

[Akalix]

Is the turtle wow team still interested in community quests and items? If so, is there any area of focus one should look at for designing quests and items?

We're still open to community works! There's no specific area we can give you to focus, just find an idea you think is good, do some designing, and toss up a suggestion post. I'll be sure to give it a read :)

[Jam]

Awesome, Akalix! Thanks for the reply. I'll read back through and see what I can get together. It seems the tools and way to submit have changed a little since my last submission.

[Jam]

Custom goblin fishing NPC Gurt Cowdy to be added on the dock south of the bridge between Durotar and The Barrens.

After joining the horde, goblin Gurt Cowdy finds he'd rather fish with a pole than with explosives. Help him by finding bait for his favorite, pointy toothed, river fish. It is Rabbit Season!

Submission Template:
**Previous quest:** None
**Title:** Rabbit Season!
**Quest NPC (Start)**: Gurt Cowdy , New, 202208111
**Quest NPC (End)**: Gurt Cowdy , New, 202208111
**Quest level:** 9
**Required level:** 7
**Quest zone ID:** 14
**Main description:** Fishin' $R, never thought I'd get hooked on it. The gar here are delicious! Good bait is the hard part. I had a bucket of rabbit but a crocolisk drug it into the river. Run across the bridge there and see if you can get any squashed rabbit for me from around those thunder lizards.
**Short objective:** Get 10 Squashed Rabbit Carcasses from Thunder Lizard Gulch for Gurt.
**Progress text**: What are you botherin' me again for?
**Completion:** Thanks! Now I can get back to catchin' some fish!
**Required creature kills: ** Entry (Name), Entry (Name)...
**Required items:** Squashed Rabbit Carcass Item 4879
**Required item quantity** 10

[Jam]

Custom NPC, added to end of dock in Ratchet, Brolli Shipclean

Brolli needs your help! Time to kill some Lobstrosities. Help a diver out and get one of these items. Barnacle Scraper, Salty Bucket, or a nice warm Beach Towel.

**Previous quest:** None
**Title:** Lobstrosities
**Quest NPC (Start)**: Brolli Shipclean , New, 202208121
**Quest NPC (End)**: Brolli Shipclean , New, 202208121
**Quest level:** 18
**Required level:** 15
**Quest zone ID:** 12
**Main description:** I tell ya $N, scraping ships is thankless work. I'm the only thing keeping the hull of this boat from looking like Negolash's backside and not only do I not get paid well, I gotta deal with those blue nightmares clacking around down there! Do me a favor, yeah? Take a dip and bust their heads! That will at least let me work in peace for a day or two.
**Short objective:** Kill 10 Slimeshell Makrura for Brolli.
**Progress text**: How're you coming along with clearing out the bay?
**Completion:** The waters look clear $N. You have my thanks. Pick something to take with you as well!
**Required creature kills:** 6020 Slimeshell Makrura
**Required creature kill quantity:** 10
**Required items:**
**Required item quantity**

[Dalty]

Fletcher's Knapsack.Bag for hunter to use instead of quiver.

[Arraya]

Haven't made quests in so long, noticed the centaurs near Sen'jin aren't part of any objective. So I made this one!

Lar Prowltusk has asked you to kill 8 Kolkar Drudges and 5 Kolkar Outrunners.

SQL:

-- Making it Clear

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 ('0', '0', '14', '7', '5', '8', '0', 'Making it Clear', 'We can't allow these Kolkar centaurs to continue raiding us. Even if you burn their Attack Plans, they might just make more.
$B$B
So while you're at it, go and kill as many as you can. That should send a message that the Horde is not to be trifled with. Maybe then, they will think about it twice... or flee back to wherever they come from.', 'Lar Prowltusk has asked you to kill Kolkar Centaurs found within the Kolkar Crag southwest of Sen'Jin Village.', 'Hurry, $c! They're a nuisance at best, but we have to deal with the problem before it gets worse.', 'You've stopped them, then? Thank you for aiding us. Although we can stop their advances if they come, our villagers will be grateful that they can go foraging without an escort now.', '0', '0', '0', '0', '0', '0', '0', '0', '3119', '8', '3120', '5', '0', '0', '0', '0', '0', '0', '85', '0', '76', '150', '530', '150', '0', '0', '0', '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 (3140, 0);
replace into creature_involvedrelation (id, quest) values (3140, 0);

[Balor]

I made a legendary axe for fun. https://dev.turtle-wow.org/#!/itemcreat ... JOVUxMIl0=
SQL

replace into item_template values
('9000', '2', '1', 'Axe of the Headsman', 'Executions done, over 9000', '32738', '5', '0', '1', '5000000', '4000000', '17', '71', '-1', '75',
'60', '172', '0', '0', '0', '0', '0', '0', '1', '1', '0', '4', '30', '3', '30',
'7', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4200', '0',
'0', '420', '600', '0', '100', '100', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '0', '0',
'0', '0', '0', '8989', '2', '0', '1', '-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', '0', '0', '0', '1', '0', '0', '200', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);

[Balor]

I always wanted to make quests for dungeons to help out factions that had no quests or very little and would still make sense lore wise. This is my first attempt at making a quest with rewards.

First Quest I made is for Deadmines and is for the horde. Lore wise the only reason I could see the horde going into Deadmines would be for Mr.Smite so I made a quest for Magatha to send people there to kill him.

SQL For the Quest

-- Kill the traitor

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 ('0', '90000', '1581', '20', '17', '8', '0', 'Kill the traitor', '$N I hear mentions of your name through gossip that you will do anything as long as it pays well. I have a problem, a traitor to the Grimtotem clan Mr.Smite has joined up with a group of bandits in Westfall and is telling them our secrets. Go in there and take him out and you will be well rewarded, also keep this between us.', 'Kill Mr. Smite in Deadmines.', 'That traitor can\'t be allowed to live.', 'Very nice you just made this old crone very happy.', '0', '0', '0', '0', '0', '0', '0', '0', '646', '1', '0', '0', '0', '0', '0', '0', '0', '0', '6000', '5004', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '90005', '1', '90001', '0', '90002', '0', '90004', '0', '0', '0', '0', '0');

replace into creature_questrelation (id, quest) values (4046, 90000);
replace into creature_involvedrelation (id, quest) values (4046, 90000);

Items I made for quest reward
SQL 1st item reward

replace into item_template values
('90001', '4', '0', 'Grimtotem Ring', '', '1006', '3', '0', '1', '500', '200', '11', '-1', '-1', '21',
'17', '0', '0', '0', '0', '0', '0', '0', '', '1', '0', '4', '4', '3', '4',
'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '0', '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', '0', '0', '4', '1', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0',
'0', '1', NULL);

SQL 2nd item reward

replace into item_template values
('90002', '4', '0', 'Grimtotem Signet', '', '26001', '3', '0', '1', '500', '200', '11', '-1', '-1', '21',
'17', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '5', '4', '6', '4',
'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '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', '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', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);

SQL 3rd item reward

replace into item_template values
('90005', '4', '0', 'Grimtotem Earring', '', '33855', '3', '0', '1', '500', '200', '12', '-1', '-1', '21',
'17', '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', '5', '0', '7708', '1', '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', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);

SQL 4th item reward

replace into item_template values
('90004', '2', '15', 'Grimtotem Shanker', '', '5175', '3', '0', '1', '1000', '900', '22', '-1', '-1', '21',
'20', '173', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '2', '4', '2',
'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1499', '0',
'0', '14', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '0', '0', '7357', '2', '0', '1', '-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', '0', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
'0', '1', NULL);

its a choice of 1 of the 4 rewards.

Here are the links incase SQL isn't enough.
Kill the traitor!

Grimtotem Ring
Grimtotem Signet
Grimtotem Trinket
Grimtotem Dagger

I am still a noob with this stuff so any tips or suggestions would be most welcome. I was trying to figure how to get a quest item to be picked up as proof ( aka Mr.Smites horns or head)

[Kwayver]

Any chance of a spell/ability creating tool?

[Jam]

Any chance of a spell/ability creating tool?

Dragunovi spoke to this quite often prior to the goblin/helf expansion. Using spells that are already in game or reactivating features that blizzard canned is doable but adding custom spells and/or recipes is much more involved and there's a much higher risk of it wildly unbalancing classes, specs, or even NPC's. I don't believe it has ever been said that it is impossible but I think the reward for adding abilities doesn't outweigh the risk.

[Leathertank]

I plan to make quests for all Zepellin Masters/Dock Masters, with a title for completing them all(if admins allow it).
Here is the first. The text was already there, and it's always felt like a quest to me.

Note: the reward is a little high for the level to compensate player for buying sausage
_______________________________________________________________________________
Quest start lvl 10

Zapetta

Buy sausage in org bring back

Rew 4s


Title: Meats for Zapetta
Quest NPC (Start): Zapetta Zeppelin Master
Quest NPC (End): Zapetta Zeppelin Master
Quest level: 10
Required level: 8
Quest zone ID: 45
Main description: My brother said we could make great money with this trade route, but he didn't tell me I would be the one living on this side. If you come back this way on the Zeppelin, could you bring me something to eat? They sell some of the finest meat in Orgrimmar, and I sure could use something that didn't die weeks before it stopped moving.
Short objective: Buy a haunch of meat in Orgrimmar, then return to Zapetta.
Progress text: Got the meats?
Completion: Finally some damn real food.

Required items: Name.
— Rewards
Money: 2s40cXP: 810XP

_________________________________________________

[Kwayver]

I plan to make quests for all Zepellin Masters/Dock Masters, with a title for completing them all(if admins allow it).
Here is the first. The text was already there, and it's always felt like a quest to me.

Note: the reward is a little high for the level to compensate player for buying sausage
_______________________________________________________________________________
Quest start lvl 10

Zapetta

Buy sausage in org bring back

Rew 4s


Title: Meats for Zapetta
Quest NPC (Start): Zapetta Zeppelin Master
Quest NPC (End): Zapetta Zeppelin Master
Quest level: 10
Required level: 8
Quest zone ID: 45
Main description: My brother said we could make great money with this trade route, but he didn't tell me I would be the one living on this side. If you come back this way on the Zeppelin, could you bring me something to eat? They sell some of the finest meat in Orgrimmar, and I sure could use something that didn't die weeks before it stopped moving.
Short objective: Buy a haunch of meat in Orgrimmar, then return to Zapetta.
Progress text: Got the meats?
Completion: Finally some damn real food.

Required items: Name.
— Rewards
Money: 2s40cXP: 810XP

_________________________________________________

+1 to this, and dock masters too. This would educate new players in where travel points are.

[Akalix]

I plan to make quests for all Zepellin Masters/Dock Masters, with a title for completing them all(if admins allow it).
Here is the first. The text was already there, and it's always felt like a quest to me.

Note: the reward is a little high for the level to compensate player for buying sausage
_______________________________________________________________________________
Quest start lvl 10

Zapetta

Buy sausage in org bring back

Rew 4s


Title: Meats for Zapetta
Quest NPC (Start): Zapetta Zeppelin Master
Quest NPC (End): Zapetta Zeppelin Master
Quest level: 10
Required level: 8
Quest zone ID: 45
Main description: My brother said we could make great money with this trade route, but he didn't tell me I would be the one living on this side. If you come back this way on the Zeppelin, could you bring me something to eat? They sell some of the finest meat in Orgrimmar, and I sure could use something that didn't die weeks before it stopped moving.
Short objective: Buy a haunch of meat in Orgrimmar, then return to Zapetta.
Progress text: Got the meats?
Completion: Finally some damn real food.

Required items: Name.
— Rewards
Money: 2s40cXP: 810XP

_________________________________________________

Titles are reserved for extremely significant achievements, such as wielding a Legendary.

[Leathertank]

>Titles are reserved for extremely significant achievements, such as wielding a Legendary.

Yeah I guess the "fun" ones didnt show up until much later, I still want to flesh out the masters and finish the questlines though. Instead of a title, maybe a naster-quest once you've done all of them to join the union or something.

[Leathertank]

Meats for Zapetta, the 1st in a chain of zeppelin/dock master quests, culminating in an epic timed journey across Azeroth.

I input zapetta's ID, not sure if that was correct or if only good for custom NPCs



-- Meats for Zapetta

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 ('0', '16420', '1637', '10', '9', '0', '0', 'Meats for Zapetta', 'My brother said we could make great money with this trade route, but he didn't tell me I would be the one living on this side. If you come back this way on the Zeppelin, could you bring me something to eat? They sell some of the finest meat in Orgrimmar, and I sure could use something that didn't die weeks before it stopped moving.

Could you bring me a haunch of meat from Orgrimmar?', 'Buy a haunch of meat in Orgrimmar, then return to Zapetta.', 'Got the meat yet?', 'Finally some damn real food!', '2474', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-6', '0', '67', '100', '0', '0', '0', '0', '0', '0', '0', '0', '4', '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 (8849, 16420);
replace into creature_involvedrelation (id, quest) values (8849, 16420);

[Demongamer]

wowie

[Balor]

First NPC I made, its a rare spawn Ogre necromancer, Any tips to improve upon is welcome.
Ig'Thor a Necromancer Ogre
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
('0', '0', '11546', '11546', '11546', '11546', 'Ig\'Thor', 'Cult of the Damned', '0', '62', '63',
'25000', '30000', '25000', '30000', '4000', '20', '0', '1', '1.14286', '1', '20',
'5', '0', '2', '4', '500', '600', '5', '200', '1',
'4000', '3000', '8', '8', '4', '1', '0', '0',
'0', '0', '600', '600', '600', '7', '0', '0',
'0', '0', '0', '0', '0', '0', '50', '0', '20812',
'12420', '28599', '20740', '0', '0', '1000', '4000', '', '1',
'3', '0', '0', '', '1853', '0', '0', '67584',
'0', '0', '');

[Condabas]

I don't know how I would get this submitted, but here it goes:

I was thinking about having a 3 wing instance near Bootybay that would be a series of instances that lead into each other.

The first instance would be about Booty Bay being sieged by the Bloodsails and sending the group back to the deadmines to get the dreadnought to break the Bloodsails blockade.

The second instance would be after the dreadnought destroys the blockade (along with itself) and the group has to clear out the remaining Bloodsails around the port and capturing their last remaining ship.

The third instance would be taking that captured ship and assaulting Plunder Isle from the south and defeating Duke Falrevere.

I have ideas on how to make the instances without needing new assets, I just don't know how to get the idea submitted. Also have an idea on how to make a version like Dire Maul Tribute for those who went for the Bloodsail faction.

[Balake]

Cenarion Circle recently got new very good recipes for Blacksmithing and Leatherworking, Tailoring got nothing. It sad being a profession that only exists for mooncloth cooldowns and bloodvine.

And here it is: Shawl of the New Autumn, and the associated recipe.

The material cost should reflect its power, same as the already existing two items. I suggest:
20 bolts of runecloth
15 living essence
5 essence of fire
4 golden pearl
3 mooncloth
1 flask of supreme power

[Balake]

Code: Select all

replace into item_template values
 ('83576', '4', '1', 'Shawl of the New Autumn', '(3rd equip effect is 1% haste, display ID should be same as Cloak of the Fallen God)', '7547', '4', '0', '1', '134811', '26962', '16', '-1', '-1', '68',
 '60', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '5', '5', '4',
 '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
 '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '51', '0', '0', '0',
 '0', '0', '0', '15714', '1', '0', '0', '-1', '0', '-1', '23727', '1', '0', '0', '-1', '0', '-1', '13679', '1',
 '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
 '-1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '65', '0', '', '0',
 '0', '1', NULL);

Code: Select all

replace into item_template values
 ('83577', '9', '2', 'Pattern: Shawl of the New Autumn', 'sold by Mishta', '634', '4', '0', '1', '60000', '15000', '0', '-1', '-1', '66',
 '60', '197', '300', '0', '0', '0', '609', '7', '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', '1', '0', '0', '-1', '0', '-1', '0', '1', '0', '0', '-1', '0', '-1', '0', '1',
 '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0',
 '-1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '65', '0', '', '0',
 '0', '1', NULL);

[Xudo]

There should be a quest to make more detailed investigation of Mankrik's wife death.
Maybe she is alive and faked own death to run from her husband.
Maybe it is her husband killed her and asked us to "find" her.
We don't really know how things were actually happened.

[Aeliren]

There should be a quest to make more detailed investigation of Mankrik's wife death.
Maybe she is alive and faked own death to run from her husband.
Maybe it is her husband killed her and asked us to "find" her.
We don't really know how things were actually happened.

From "Lost in Battle":

We battled in a small tauren camp when we were separated—she held three of the Bristlebacks off by herself. But the odds began to overwhelm us. I led some away only to see her overwhelmed by newcomers. In my rage, I turned to face my enemies, but they brought me down easily with their vast numbers.

I awoke to a tauren druid tending my wounds—he had come across me on the Gold Road as I fell.

I think it's pretty clear that she died from being overwhelmed while fighting quillboar and that Mankrik was knocked out in the fighting. I don't think anything needs to be added, and I don't see the use or point in retroactively making Mankrik the villain of the quest.

[Balor]

does anyone know how to add random suffixes like Of Wrath to a item? i tried google and all it did was give me the definitions of the terms in the item creator not the list of numbers or enchants.

[Balor]

Made a level 62 elite rare spawn ogre for the twilight's hammer. If needed i can make items for him to drop also. Can be used in dungeons or where ever he is needed.
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
('100009', '1.16.5', '18031', '18031', '18031', '18031', 'Gog\'gurn', 'Twilight\'s Hammer', '0', '62', '62',
'15000', '15233', '50000', '50000', '5500', '14', '0', '1', '1.14286', '3', '20',
'10', '0', '2', '3', '400', '500', '0', '400', '1',
'3200', '2500', '8', '8', '0', '1', '0', '0',
'0', '0', '400', '500', '500', '7', '0', '0',
'0', '0', '0', '0', '0', '0', '75', '0', '22917',
'20740', '28310', '26046', '0', '0', '900', '1500', 'AggressorAI', '0',
'3', '0', '0', '2', '5975', '0', '0', '0',
'0', '0', '');

Rare Spawn Gog'gurn

[Isvya]

There should be a quest to make more detailed investigation of Mankrik's wife death.
Maybe she is alive and faked own death to run from her husband.
Maybe it is her husband killed her and asked us to "find" her.
We don't really know how things were actually happened.

From "Lost in Battle":

We battled in a small tauren camp when we were separated—she held three of the Bristlebacks off by herself. But the odds began to overwhelm us. I led some away only to see her overwhelmed by newcomers. In my rage, I turned to face my enemies, but they brought me down easily with their vast numbers.

I awoke to a tauren druid tending my wounds—he had come across me on the Gold Road as I fell.

I think it's pretty clear that she died from being overwhelmed while fighting quillboar and that Mankrik was knocked out in the fighting. I don't think anything needs to be added, and I don't see the use or point in retroactively making Mankrik the villain of the quest.

Perhaps not making him villain but more like a followup in which you need to acquire her spirit bead from the quillboar then using it at a specific altar ( ontop of the wc mountain?) to have a talk with her ghost
After that return to Mankrik and have a final part to avenge her death by killing the murderer in RFK.