Fyre

On 2/3/2025 at 3:30 PM, Gooby said:

Hey Fyre! Appreciate the guide. I've been playing around with private servers lately and learning how to do a few things. Your guide is super helpful! I created my first quest today and put my cat in the game. Super fitting for her lol.

That's awesome!! Thank you for sharing your NPC + quest!

I really like the text for the quest too! Haha!

How was the guide - easy to follow? Anything that you think I could have presented in a different manner?

I'm recording a list of the status of various quests in M3 for the Uldum.

---------------------------------------------------------------------

Thanks to help from:

• Calytras

---------------------------------------------------------------------

Total Quests in This Area: UNKNOWN

---------------------------------------------------------------------

Lead-up to Uldum

Horde:

[27953] The Reliquary- Semi-Working - Couldn't be picked up. However, added by command and was able to turn in.

[27005] The Twilight Plot - Working 

[27041] Decryption Made Easy - Working - Fixed by Calytras (Commit fd7aa44)

[27059] The Wrong Sequence - To Be Tested -

[28293] That's No Pyramid! - To Be Tested -

[28296] Meetup with the Caravan - To Be Tested -

[28557] Warchief's Command: Uldum! - Working - It is worth noting that when visiting the caravan in Tanaris, most of the caravan is not visible - will be a phasing issue.

Alliance:

[27952] The Explorers - To Be Tested -

[27004] The Twilight Plot - To Be Tested -

[27040] Decryption Made Easy - To Be Tested -

[27058] The Wrong Sequence - To Be Tested -

[28292] That's No Pyramid! - To Be Tested -

[28295] Meetup with the Caravan - To Be Tested -

[28558] Hero's Call: Uldum! - To Be Tested - Same end NPC as 28557 above, so same note.

Quests in Uldum

[27003] Easy Money - Broken - Cannot click to mount "Lady Humps" the camel. This SHOULD create a series of cut scenes and ultimately move the player to a locked cage at APPROXIMATELY [Map, x, y, z] 1, -11002.90, -1248.02, 13.3259 (.go xyz -11002.90 -1248.02 13.3259 1). Even when traveling manually to this location, the quest is not completable due to the objective (Caravan Escorted) not being complete. https://www.youtube.com/watch?v=ZKifh9orPv8

[27922] Traitors! - Broken - Hiding behind the plant does not trigger a cutscene. Quest completion is not possible.

[27923] Smoke in Their Eyes - Broken - Using the Brazier Torch (Item ID: 63027) provided beside a Bale of Hay provides the "Invalid target" message. At each ingame spawn of the Bale of Hay, there appears to be 2 gameobjects with the same name (Entry: 206682 & 206684) - confirmed at 5 locations.

[27924] Budd's Plan - Working 

[28105] Kavem the Callous - Working 

[28112] Escape from the Lost City - Semi-Working- There should be a cutscene triggered immediately. The player should then be moved to APPROXIMATELY [Map, x, y, z] 1, -9441.75, -959.64, 111.01 (.go xyz -9441.75 -959.64 111.01 1). Player can go to the end point manually and hand in quest for completion.

[28134] Impending Retribution - Broken - Sun Priest Asaris (Entry: 27715, Guid: 290399), Asaq (Entry: 47930, Guid: 290376), and Nomarch Teneth (Entry: 46603, Guid: 287738) does not have any gossip menus for players on this quest. https://www.youtube.com/watch?v=DUU4ZIaCAE4

Quests in Lost City of the Tol'vir

[28781] Targets of Opportunity - Working 

[28783] The Source of Their Power - Working 

[28870] Return to the Lost City - Working 

Are you using SPP as was mentioned by the previous poster?

SPP is a completely different project that we don't provide support for.

Yes, my usual method is just to whisper yourself. 

/w pit .revive

Fantastic! All the best!

Is it working now?

Hi Pit! Welcome here. 

What you're describing sounds like an indirect ipaddress in the realmlist table. 

Are you able to clarify your setup? Are you setting this up purely local? Or setting it up as a public server? 

The Remote Access (disabled) is fine. It's uncommon that people need to enable RA for most setups.

Hey! 

I'm sorry, I don't have any experience with that particular registration page, but I did create 2 things myself that might help you out. 

These are INDEPENDENT of one another. You do not need both (but you can if you really to).

Web CMS: https://github.com/i-am-fyre/BasicCMS

Discord bot: https://github.com/i-am-fyre/MaNGOS-Discord-Register-Bot

Good evening!

Here is a quick tutorial/guide on how to create a NPC that acts as a quest giver/receiver, has a custom quest, and some custom text.

You will need access to your WORLD database - this will work for all cores (M0 - M3). In my screenshots/links, I'm using M3 - so keep that in mind that there may be differences in columns/expected values.

STEP 1: CREATE YOUR NPC

We will start by using the "creature_template" table. This is the base information for your NPC.
Documentation Link: https://www.getmangos.eu/wiki/referenceinfo/dbinfo/mangosdb/mangosthreeworlddb/creature_template-r7028/

I gave the creature an entity value of 1,000,000 just so that it was far out of the way. But you can give it any unused value - regardless, you need to remember this number as you will use it a few times throughout the tutorial.
For the Modelid1 - I selected a Wolpertinger model by going to Wowhead and using the model number associated with an existing npc.
All other values are really up to you - refer to the documentation about expected values, masks, etc.
I've included all of my values here for your reference if you're wanting to replicate this exactly.

Start up your mangosd executable/binary, and in-game you should be able to use the following command to spawn the NPC. Use your entry id as appropriate.

.npc add 1000000

STEP 2: GIVE IT SOME CUSTOM "GOSSIP" TEXT

When you right-click a NPC in game, it often provides you with a "gossip menu" window where you can see some playful text and/or interact with it through a menu. In order for us to replicate this we will need to use two more tables:

1. npc_text (Documentation Link: https://www.getmangos.eu/wiki/referenceinfo/dbinfo/mangosdb/mangosthreeworlddb/npc_text-r7094)
2. gossip_menu (Documentation Link: https://www.getmangos.eu/wiki/referenceinfo/dbinfo/mangosdb/mangosthreeworlddb/gossip_menu-r7068/)

We begin with the 'npc_text' table to actually put our string of text into the game.
The ID again needs to be unique, I've arbitrarily chosen 200,000. Most other values I just assigned 0 to -- I wasn't worried about them for this example.

The 'gossip_menu' table is next. This is where we tell the server to use our new text within a gossip menu window.
I found out that the entry value is a smallint(6) unsigned - meaning that it can only go up to 65,535. I chose to keep it below that value. 
The text_id is the ID from the `npc_text` entry that we just made.

Now we need to go back to our `creature_template` table and assign this gossip_menu entry to our buddy Wolper. You'll see that we've added 65,534 to the GoosipMenuID.

Give your mangosd executable/binary a restart, and just to be safe - I always close my client, delete the Cache folder, and re-open my WoW.exe.

Right click Wolper and we now have custom text in our gossip menu!

STEP 3: CREATE A QUEST!

What is a custom NPC without a custom quest?

We will need 2 more tables:

1. quest_template (Documentation Link: https://www.getmangos.eu/wiki/referenceinfo/dbinfo/mangosdb/mangosthreeworlddb/quest_template-r7120/)
2. quest_relations (Documentation Link: https://www.getmangos.eu/wiki/referenceinfo/dbinfo/mangosdb/mangosthreeworlddb/quest_relations-r7166/)

There are a LOT of fields that can be filled in for 'quest_template' depending on the type of quest, rewards (items, currency, gold, reputation, etc. etc. etc.) - I keep it fairly simple here with a quest that requires 1 item and has a 5 minute timer.
Once again, I've chosen an arbitrary entry value of 50,000.

Refer to the documentation for the fields - but you can see what I used below:

That is the quest created. Now we need to setup the quest giver and quest receiver. That is where the 'quest_relations' table comes in.

We need to have TWO entries for this table.
Both will be using a creature (actor = 0), the custom npc (entry = 1,000,000), and the custom quest (quest = 50,000). The role 0 = quest giver, role 1 = quest receiver.

Give your mangosd executable/binary a restart, and just to be safe - I close the client, delete the Cache folder, and re-open the WoW.exe.

Right click Wolper and we now have the custom quest in the gossip menu!!

Below are a few pictures to show how the quest presents itself in game.

And there you go! You've created a new NPC, given it some custom text, created a custom quest - and tied them all together.

Of course, there is SO much more that you can do with custom NPCs and custom quests - look at other examples in the database, look at the documentation, and never be afraid to experiment!

Share with us some examples that you make! We can all learn from each other!

All the best!
- Fyre

Playerbots are not actually supported in M3.

Hi Spikey,

Make sure your account is set for expansion level 3.

Hi phraggers,

Your error is actually showing you that you have not updated your database to where it's expected to be. You need to apply some database updates first.

When you're looking to integrate your new table into your core, you will use C++ for the communication. 

You can see an example of this when I did something similar: 

https://github.com/mangoszero/server/commit/6483e7de74211b02aa1c716ba4cc063ff86f4265

May I ask what your added tables do?

I appreciate the time that you've spent in playing and the experience that has provided you. 

As MaNGOS aims to replicate the original state of Vanilla, we do look backwards to ensure that we have proof/evidence for a change before we make it. I personally won't push a fix until I've reviewed it and confirmed that it was accurate. It's quality control and quality assurance. 

We have no affiliation to Blizzard or Riot, so we can not speak to their decisions. Nor do we engage in calling their work "bugs."

Any screenshots you have of the objects that are of concern (carts, labels, etc.) would be appreciated. 

I personally have played since Vanilla days - but only as a Horde player. So my knowledge of Stormwind is fairly limited. I am familiar with the auction house but not the lanterns that you speak about.

As a final reminder, please keep your posts here as collaborative and positive as possible. A lot of work goes into this project and is based on community support and contributions. We always welcome questions and look to engage with all community members as much as possible! 

Thanks!

Good morning! 

Would you be able to submit your bugs to our Bug Tracker?

Please include screenshots of the cart.

And if you can find old screenshots of videos that confirm your statement, that is even better! 

Then I can take a look into it.

Thanks!

Just so you know, everything can be edited. This is a fully open source project. I'm not sure why you continue to refer to it being closed, hidden, etc. 

There are two methods for scripting within MaNGOS. 

1) Database/SQL scripting that used the dbscripts table.

2) SD3 scripting that uses C++ in the server. 

The ScriptDev3 code is in its own repository on GitHub, and is linked to the server code. 

https://github.com/mangos/ScriptDev3

Hopefully that helps you understand the structure of the server and that is not a hidden/locked down library somewhere. 

Thanks for your contribution Hochdeutscher!

Would you be willing to put a fix into the MangosZero database for this?

Hey!
I adapted an ItemMall for MangosOne that was for a different emulator project.

You're welcome to take it, and change the locations if you don't want it taking up Tyr's Hand (since it's likely needed for quests in M0), change the items and types of mines, etc. to match it for M0.

https://github.com/i-am-fyre/MaNGOS1-Mall

If you do adjust it for M0, it would be great if you could fork and share the results as well.  

Hi @mvoogd!

Unfortunately, MangosTwo does not support PlayerBots.

There was some work done in the form of a PR on the GitHub Repo - but it was still a work in progress by the author and has not been finished.

Good morning!

I've seen this issue come up a few times in the past. 

It looks like the updates have all been applied to the database, but the db_version hasn't been updated.

Use the following command in your MariaDB:

```
INSERT INTO db_version (version, `structure`, content, description, comment) VALUES(22, 1, 1, 'Release 22', 'Release 22');
```

Then you could be good to go.

When you build the project, it generates a number of tools. Mmaps, VMaps, map extractors/generators/etc.

Are you saying that you're only missing the one? Or do you not have any of them?

I'm recording a list of the status of various quests in M3 for the Twilight Highlands.

---------------------------------------------------------------------

Thanks to help from:

• Crispy81 (Quest Testing/Bug Hunting)

---------------------------------------------------------------------

Total Quests in This Area: UNKNOWN

---------------------------------------------------------------------

[26788] Cementing Our Victory - Working

[27299] Torn Ground - Working - The "Tentacles of Iso'rath" were invisible (no ModelID assigned to them). Added ModelIDs. (Fixed: Commit 8ffdafe)

[27300] Pushing Back - Working 

[27302] Simple Solutions - Working 

[27303] Mercy for the Bound - Working 

[27375] The Weeping Wound - Working

[27376] The Maw of Iso'rath - Broken - Cannot mount gryphon to join the attack.

[27377] Devoured - Broken - Event doesn't start.

[27378] The Worldbreaker - Broken - Cannot join/start the event.

[27379] The Terrors of Iso'rath - Broken - The Shaman cannot be saved, unable to complete quest objectives.

[27380] Nightmare - Broken - Shaman's do not assist or buff player when defeating Brain of Iso'rath. Making quest impossible to complete.

[27485] Warm Welcome - To Be Tested

[27486] Warm Welcome - Broken - NPC doesn't recognize proximity to player, quest cannot be turned in.

[27491] Kor'kron Drop - Broken - Jon-Jon Jellyneck does not have any menu text to complete the quest. (Quest Footage: https://www.youtube.com/watch?v=_8sJwgYAN00

[27494] Move the Mountain - To Be Tested

[27495] Move the Mountain - Broken - Detonating the explosives does nothing, quest doesn't update. No quest giver to hand in.

[27497] Call in the Artillery - Broken - When using the Artillery Flare, it doesn't call an artillery bombardment.

[27503] Up to the Citadel - Broken - Speaking to the Commander does nothing.

[27505] Draconic Mending - Broken - Menders cannot be defended, counter doesn't register any defended menders.

[27506] Life From Death - Broken - Planting seed on a corpse does nothing.

[27508] Far From the Nest - Broken - Eggs cannot be interacted with, cannot be picked up.

[27509] Breach in the Defenses - Broken - Note cannot be planted.

[27583] The Northern Flank - Working

[27584] Blood in the Surf - Working

[27586] Shells on the Sea Shore - Working

[27590] Signal the Attack - Broken - Unable to use the Attack Signal on top of the towers.

[27606] Blast Him! - Semi-working - Use Heth'Jatari Conch (Item: 61928) between the 2 flags on the beach (this works). This should spawn Fathom-Lord Heth'Jatar at the water's edge (he spawns at your location instead of near the water.). There should be incoming mortar barrage that kills him (this is not working). (Quest Footage: https://www.youtube.com/watch?v=JdPHLRAJRQU) // Also, there is already a Fathom-Lord Heth'Jatar spawned on the beach (fixed: Commit d557d5a).

[27609] Four Heads are Better than None - Working

[27688] Distract Them For Me -To Be Tested

[27689] Distract Them For Me - Broken - Target mobs do not exist; not spawned.

[27690] Narkrall, the Drake-Tamer - Working

[27700] Dragon, Unchained - To Be Tested

[27701] Dragon, Unchained - Broken - No chains holding dragon, so cannot complete quest.

[27702] Coup De Grace - To Be Tested

[27703] Coup De Grace - Broken - Not scripted, no dragons battling in the sky. No quest mobs falling to the ground to execute.

[27720] Mr. Goldmine's Wild Ride - Broken - There is no mine cart to ride.

[27744] Rune Ruination - Working - Script added to destroy Rune of Earth. (fixed: https://github.com/mangosthree/database/pull/111)

[27747] Total War - Broken - Thundermar Ale Keg is clickable, but not doing anything else. It should provide a kill credit (NPC: 46551) and cast an explosive spell/graphic (Quest Footage: https://www.youtube.com/watch?v=CYpeW8NCSXU). Possible fix may include: Spawning a NPC 46551 at every Thundermar Ale Keg location (ID: 206195), then gobject should kill the NPC for the kill credit.

[27750] War Forage - Working

[27751] Crushing the Wildhammer - Working

[27787] Skullcrusher the Mountain - To Be Tested

[27788] Skullcrusher the Mountain - Broken - No cinematic to backhand player. Altar's not able to be interreacted with and no scripting prompting player to do so.

[27863] The Crucible of Carnage: The Bloodeye Bruiser! - Broken - Hurp'derp does spawn in the ring but should start at the far end and run towards the center. Gurgthock does not give a spiel about the incoming fight. Killing Hurp'derp does not result in completion. (Quest Footage: https://www.youtube.com/watch?v=o-t3fpwl24E

[27929] Drag 'em Down - Broken - There are Thundermar War Gryphon flying in the air, and you can use the Barbed Flesh Hook but it doesn't pull the gryphon riders to the ground. // Also, there are Thundermar Gryphon Riders floating in the air.

[27945] Paint it Black - Working - ~ 1/20 drop rate. As expected.

[27947] A Vision of Twilight - Working

[27951] We All Must Sacrifice - Working - There were no "Shaman of the Black" spawned in the area, but there are a number spawned in a nearby village (fixed: Commit bef2ec1).

[27954] The Eyes Have It - Semi-working... The quest can be turned in. However, the "Eye of Twilight" gameobject is not spawned - which is required for the next quest (27955).

[27955] Eye Spy - Broken - The "Eye of Twilight" gameobject is not spawned, so the quest cannot be completed.

[28038] Blood in the Highlands - Semi-working... I handed in the quest, but didn't get any gold/reward or even quest completion notification. Something felt incomplete. 

[28041] Bait and Throttle - Working

[28043] How to Maim Your Dragon - Broken - Laying down bait does nothing.

[28092] If the Key Fits - Broken - Not scripted, gob squad doesn't follow you.

[28093] Pressing Forward - Broken - Doesn't recognize player proximity, so can't be handed in. Potentially not having gob squad with the player is the problem.

[28097] The Gates of Grim Batol - Broken - No NPC to hand quest into. Warlord Krogg is not there.

[28108] If the Key Fits - To Be Tested

[28109] Pressing Forward - To Be Tested

[28123] The Demon Chain - Broken - Item cannot be acquired, NPC has no interaction options and cannot be attacked.

[28170] Night Terrors - Broken - Cannot be started. NPC Ucheck has no text or option to switch to spirit realm.

[28171] And The Sky Streaked Red - Broken - Unable to join the assault.

[28176] Following the Young Home - Broken - Eggs cannot be targeted, so they never hatch. Cannot infiltrate lair. Quest cannot be completed.

[28247] Last of Her Kind - Broken - Never lands, and isn't targetable.

[28758] Battle of Life and Death - Broken - Cannot mount drake to do the quest.

[28871] Crushing the Wildhammer - To Be Tested

[28872] Total War - Broken - See [27747] Total War // This should only be available after [27747] Total War is completed, this is a Daily Quest (fixed: Commit 1e22dfb).

[28873] Another Maw to Feed - Working  // This should only be available after [27750] War Forage is completed, this is a Daily Quest (fixed: Commit: 5f53dad).

[28874] Hook 'em High - Broken - See [27929] Drag 'em Down // This should only be available after [27929] Drag 'em Down is completed, this is a Daily Quest (fixed: Commit ebd50d2).

[28875] Bring Down the High Shaman - To Be Tested

[28885] Mr. Goldmine's Wild Ride - Broken - There is no mine cart to ride.

This has been patched.

https://github.com/mangosthree/database/commit/710f247bbc3b98c2e050a3c2706be4b031b11f46

This appears to be related to an event that is triggered at this time of year.

You can type ingame: .event stop 48

And that will resolve it.

I'm going to see what I can do to investigate the reason for the event and hopefully we can apply some fixes.

Excellent - thank you for reporting your issue! And I'm glad the fix worked.
Going to get this fix integrated naturally so it doesn't raise again for people in the future.  

Wish you the best - if you need any other support, reach out via the Forums (or Discord)!

Which strategy did you go with? The first one?