Online Quest & Item Creator

User avatar
Jam
Posts: 24
Location: Seville, FL

Re: Online Quest & Item Creator

Post by Jam » Tue Aug 09, 2022 11:56 pm

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?
“The place where you made your stand never mattered. Only that you were there.. and still on your feet.”

User avatar
Akalix
Posts: 398
Location: United States
Has liked: 1 time
Likes: 9 times

Re: Online Quest & Item Creator

Post by Akalix » Wed Aug 10, 2022 7:38 am

Jam wrote:
Tue Aug 09, 2022 11:56 pm
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 :)
Public Relations / Community Manager / Head of Recruitment

Looking to join Turtle? Need media information? Contact me!

User avatar
Jam
Posts: 24
Location: Seville, FL

Re: Online Quest & Item Creator

Post by Jam » Wed Aug 10, 2022 11:19 am

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.
“The place where you made your stand never mattered. Only that you were there.. and still on your feet.”

User avatar
Jam
Posts: 24
Location: Seville, FL

Re: Online Quest & Item Creator

Post by Jam » Fri Aug 12, 2022 1:01 am

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
Last edited by Jam on Sun Aug 14, 2022 8:10 pm, edited 1 time in total.
“The place where you made your stand never mattered. Only that you were there.. and still on your feet.”

User avatar
Jam
Posts: 24
Location: Seville, FL

Re: Online Quest & Item Creator

Post by Jam » Sun Aug 14, 2022 12:21 pm

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**
Last edited by Jam on Thu Aug 18, 2022 11:01 pm, edited 2 times in total.
“The place where you made your stand never mattered. Only that you were there.. and still on your feet.”

User avatar
Dalty
Posts: 1

Re: Online Quest & Item Creator

Post by Dalty » Wed Aug 17, 2022 8:42 am

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


Image

User avatar
Arraya
Posts: 17

Re: Online Quest & Item Creator

Post by Arraya » Sun Aug 21, 2022 11:41 pm

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

User avatar
Balor
Posts: 9

Re: Online Quest & Item Creator

Post by Balor » Thu Aug 25, 2022 2:08 am

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

User avatar
Balor
Posts: 9

Re: Online Quest & Item Creator

Post by Balor » Fri Aug 26, 2022 9:34 pm

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)

User avatar
Kwayver
Posts: 116
Location: Australia

Re: Online Quest & Item Creator

Post by Kwayver » Fri Aug 26, 2022 10:40 pm

Any chance of a spell/ability creating tool?

User avatar
Jam
Posts: 24
Location: Seville, FL

Re: Online Quest & Item Creator

Post by Jam » Sun Aug 28, 2022 11:30 am

Kwayver wrote:
Fri Aug 26, 2022 10:40 pm
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.
“The place where you made your stand never mattered. Only that you were there.. and still on your feet.”

Leathertank
Posts: 33

Re: Online Quest & Item Creator

Post by Leathertank » Mon Sep 05, 2022 10:58 pm

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

_________________________________________________
https://thefamily.quest Social PVE/PVP crossfaction guild for adults

User avatar
Kwayver
Posts: 116
Location: Australia

Re: Online Quest & Item Creator

Post by Kwayver » Tue Sep 06, 2022 1:15 am

Leathertank wrote:
Mon Sep 05, 2022 10:58 pm
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.

User avatar
Akalix
Posts: 398
Location: United States
Has liked: 1 time
Likes: 9 times

Re: Online Quest & Item Creator

Post by Akalix » Tue Sep 06, 2022 1:53 am

Leathertank wrote:
Mon Sep 05, 2022 10:58 pm
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.
Public Relations / Community Manager / Head of Recruitment

Looking to join Turtle? Need media information? Contact me!

Leathertank
Posts: 33

Re: Online Quest & Item Creator

Post by Leathertank » Wed Sep 07, 2022 4:25 am

>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.
https://thefamily.quest Social PVE/PVP crossfaction guild for adults

Leathertank
Posts: 33

Re: Online Quest & Item Creator

Post by Leathertank » Thu Sep 08, 2022 9:03 pm

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);
https://thefamily.quest Social PVE/PVP crossfaction guild for adults

Demongamer
Posts: 1

Re: Online Quest & Item Creator

Post by Demongamer » Thu Sep 08, 2022 9:24 pm

wowie
hiding_smth_turtle

User avatar
Balor
Posts: 9

Re: Online Quest & Item Creator

Post by Balor » Thu Sep 08, 2022 10:38 pm

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
Posts: 4

Re: Online Quest & Item Creator

Post by Condabas » Mon Sep 12, 2022 6:27 pm

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
Posts: 736

Re: Online Quest & Item Creator

Post by Balake » Mon Sep 19, 2022 9:20 pm

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
Posts: 736

Re: Online Quest & Item Creator

Post by Balake » Tue Sep 20, 2022 10:35 am

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
Posts: 1470
Has liked: 47 times
Likes: 5 times

Re: Online Quest & Item Creator

Post by Xudo » Tue Sep 20, 2022 4:48 pm

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.
Xudo - tauren warrior 19 Sergeant armory.
I don't raid and rank, so you can not bother asking.
Nerf high level enchants on low level gear
Add lvl requirement to bandages
Best and optimal gear for 10-19 twinks
Have fun not only at 60.

Aeliren
Posts: 92

Re: Online Quest & Item Creator

Post by Aeliren » Tue Sep 20, 2022 5:02 pm

Xudo wrote:
Tue Sep 20, 2022 4:48 pm
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.
Characters:
Coilspring - 60 gnome hunter
Megwynn - 60 human rogue

Suggestions:
Pyrewood Village Suggestions
Hunter Epic Ammo Pouch Suggestion

User avatar
Balor
Posts: 9

Re: Online Quest & Item Creator

Post by Balor » Thu Sep 22, 2022 12:50 am

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.

User avatar
Balor
Posts: 9

Re: Online Quest & Item Creator

Post by Balor » Mon Sep 26, 2022 7:44 pm

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

User avatar
Isvya
Posts: 222
Location: hungary

Re: Online Quest & Item Creator

Post by Isvya » Mon Sep 26, 2022 10:02 pm

Aeliren wrote:
Tue Sep 20, 2022 5:02 pm
Xudo wrote:
Tue Sep 20, 2022 4:48 pm
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.

Xudo
Posts: 1470
Has liked: 47 times
Likes: 5 times

Re: Online Quest & Item Creator

Post by Xudo » Tue Oct 04, 2022 8:44 pm

After running WC 10 times I noticed that lot of players need Leggings of the Fang even warriors and paladins. So I propose to add alternative mail leggings to Mutantus drop.

Code: Select all

replace into item_template values
 ('0', '4', '3', 'Mutant Scale Legguards', '', '35345', '3', '0', '1', '10000', '2000', '7', '-1', '-1', '19',
 '19', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '7', '9', '3', '4',
 '4', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
 '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '170', '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', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
 '0', '1', NULL);
Stats are copied from Leggings of the fang. Stamina and agility values was exchanged.
Xudo - tauren warrior 19 Sergeant armory.
I don't raid and rank, so you can not bother asking.
Nerf high level enchants on low level gear
Add lvl requirement to bandages
Best and optimal gear for 10-19 twinks
Have fun not only at 60.

User avatar
Yordlefetish
Posts: 2

Re: Online Quest & Item Creator

Post by Yordlefetish » Mon Oct 17, 2022 12:42 pm

Suggestion to change item.

I got Orb of the Hellcaller from Akkrilus in Ashenvale and I think the item could use a buff.

Currently what the item does is deal 375 fire damage over 10 seconds in a huge area with 60 minute cooldown.
I think it would be better to narrow the area of effect and give it a less harsher cooldown , say 5-15 minutes so it would at least be usable semi frequently , considering it is a 10 % drop rate from a rare mob.

Novumaurora
Posts: 1

Re: Online Quest & Item Creator

Post by Novumaurora » Wed Nov 09, 2022 6:04 pm

In Felwood there's a questline to free the night elf Arko'narin from captivity in Jaedenar. Along the way she gets the sword Lightforge that was used by her deceased paladin friend Trey Lightforge, and I expected it to be a reward from the end of the chain but it's not.

I think it'd be great if Arko'narin were made an NPC in Darnassus and then after the completion of the chain she sends a mail to the player asking them to come meet her, where she then gives them the sword Lightforge, probably a blue item considering the chain is pretty long and difficult and currently only provides underwhelming rewards.

If someone more experienced with the tool could put this together, I think it'd be a very cool moment to end a chain that's often overlooked and make it a bit more worthwhile.

Knnib4l
Posts: 17

Re: Online Quest & Item Creator

Post by Knnib4l » Wed Dec 07, 2022 5:58 pm

Decided to make a caster trinket to try my hand at the itemization formula, see how crazy things could get turtle_tongue_head

Khadgar's Puzzlebox
Bind on Pickup (Rare quality)
Trinket
Requires level 58 (ilv 63)
+6 Intellect
Equip: Increases your attack and casting speed by 1%. (id 13679)
Equip: Improves your chance to get a critical strike with spells by 1%. (id 18384)

User avatar
Moriena
Posts: 35

Re: Online Quest & Item Creator

Post by Moriena » Fri Jan 13, 2023 7:05 am

Hello everyone!

I've been working on a questline involving the unused night elf NPC Sentinel Keldara Sunblade in the Haldarr Encampment in Azshara - she has (presumably) a sister in Darnassus' Temple of the Moon, who also serves no purpose atm.

The questline follows the adventurer accepting Dalia's request to look for her sister Keldara, who left Darnassus for Ashenvale on an investigation of sentinel abductions, which ultimately lead to Azshara. The adventurer meets with Captain Arrowsong (custom NPC) and finds Keldara's body for her amidst a satyr camp, realizing that her soul has been taken. Captain Arrowsong tells the player to look for clues in Keldara's journal and with that, they are able to find a wounded satyr - the reason for her actions. The satyr Xanarem (custom NPC) is someone who knows Dalia and Keldara from even before the Sundering - not being able to avenge her himself, he requests assistance of the adventurer to retrieve the souls of the satyr victims off of Master Ol'vrir (custom NPC enemy) and eventually, save them in the process.

I tried my best to work around with the dev creation tool, but I do not have enough experience with it, so instead of half-heartedly scrambling something together, I wrote a document containing all information, questtext, NPC spreadsheets and rewards.

Azshara questline: https://docs.google.com/document/d/1PtC ... sp=sharing

smiling_turtle_head
Last edited by Moriena on Sun Mar 05, 2023 5:50 pm, edited 1 time in total.

Aubury
Posts: 4

Re: Online Quest & Item Creator

Post by Aubury » Fri Jan 20, 2023 2:35 pm

Moriena wrote:
Fri Jan 13, 2023 7:05 am
Hello everyone!

I've been working on a questline involving the unused night elf NPC Sentinel Keldara Sunblade in the Haldarr Encampment in Azshara - she has (presumably) a sister in Darnassus' Temple of the Moon, who also serves no purpose atm.

The questline follows Dalia's request of the adventurer to look after Keldara, as she left to Ashenvale on an investigation of sentinel abductions, which ultimately lead to Azshara. There the player meet with Captain Arrowsong (custom NPC) and find Keldara's body for her, finding out that her soul has been taken. Captain Arrowsong tells the player to look for clues in Keldara's journal and with that, they are able to find a wounded satyr - the reason for her actions. The satyr Xanarem (custom NPC) is someone who knows Dalia and Keldara from even before the Sundering - not being able to avenge her himself, he requests assistance of the adventurer to retrieve the souls of the satyr victims off of Master Ol'vrir (custom NPC enemy) and eventually, save them in the process.

I tried my best to work around with the dev creation tool, but I do not have enough experience with it, so instead of half-heartedly scrambling something together, I wrote a document containing all information, questtext, NPC spreadsheets and rewards.

Azshara questline: https://docs.google.com/document/d/1PtC ... sp=sharing

smiling_turtle_head
What a lovely quest chain. I hope it gets implemented, so we can experience the story to the full extent.

User avatar
Kefke
Posts: 341

Re: Online Quest & Item Creator

Post by Kefke » Tue Jan 24, 2023 12:21 pm

I had a silly little idea for a quest, but I haven't quite got the utilities down. I tried my best.

The general idea was that somewhere out in the world would be an invisible NPC with a large and meandering patrol route. If you find them, you will see that they are Breeze Shadowhoof, a female Tauren with the Rogue class, and appropriate gear. Talking to her, you'd get the dialogue; "Wait...you are talking to ME? You SAW me?"

And they would have an available quest; There are no Tauren rogues (Link)

In addition to the small amount of faction rep and experience, the player would get a Satchel of Coins. In addition to random gold, the Satchel of Coins would also give the player a Mysterious Satchel.

Mac
Posts: 803
Likes: 1 time

Re: Online Quest & Item Creator

Post by Mac » Tue Jan 24, 2023 1:04 pm

Kefke wrote:
Tue Jan 24, 2023 12:21 pm
I had a silly little idea for a quest, but I haven't quite got the utilities down. I tried my best.

The general idea was that somewhere out in the world would be an invisible NPC with a large and meandering patrol route. If you find them, you will see that they are Breeze Shadowhoof, a female Tauren with the Rogue class, and appropriate gear. Talking to her, you'd get the dialogue; "Wait...you are talking to ME? You SAW me?"

And they would have an available quest; There are no Tauren rogues (Link)

In addition to the small amount of faction rep and experience, the player would get a Satchel of Coins. In addition to random gold, the Satchel of Coins would also give the player a Mysterious Satchel.
That's a great quest idea, and the sort of thing that fits in well on this server.

Ghostjunk
Posts: 1

Re: Online Quest & Item Creator

Post by Ghostjunk » Tue Apr 11, 2023 6:35 pm

Hello Everyone!

I was working on a quest line for one of my favorite short stories that I feel never got the right amount of love in WoW Classic. It's definitely a questline that is a lot of work but gives out a really nice reward. Hopefully those of you who read it will enjoy.

https://drive.google.com/file/d/1CfoxqL ... share_link

Locked