POIs on custom Quest

[Corelith]

Hey folks,


i'm working with AzerothCore and i'm trying to make a custom Quest. Therefor the Quest as itself is already inside the game and working, but i got a Problem on putting in the PointsOfInterest into the maps...

Isn't it inside the database in the tables "quest_poi" and "quest_poi_Points"?!?!

I just put in the coordinates of " .gps " ingame into thoses tables, but those points arent shown in the Quest-Map ingame...

I put into:

quest_poi_points
questid --- the QuestID
idx1 --- the nuber as in "quest_poi"
idx2 --- 0
x --- the global X-Coord (of .gps)
y --- the global Y-Coord (of .gps)
VerifiedBuild --- 0

and into

quest_poi
QuestID --- QuestID
id --- 0 (for a solo-point)
MapID 0 (MapID for Eastern Kingdoms, because it's in stranglethorn vale )
WorldMapAreaId --- 33 (it's jaguero isle )
Floor --- 0 (i don't know for what)
Priority --- 0 (i don't know for what)
Flags --- 0


So why it's not shown in my map??? (of course i restarted the server after and cleared the WDB...)

[stoneharry]

Hey folks,


i'm working with AzerothCore and i'm trying to make a custom Quest. Therefor the Quest as itself is already inside the game and working, but i got a Problem on putting in the PointsOfInterest into the maps...

Isn't it inside the database in the tables "quest_poi" and "quest_poi_Points"?!?!

I just put in the coordinates of " .gps " ingame into thoses tables, but those points arent shown in the Quest-Map ingame...

I put into:

quest_poi_points
questid --- the QuestID
idx1 --- the nuber as in "quest_poi"
idx2 --- 0
x --- the global X-Coord (of .gps)
y --- the global Y-Coord (of .gps)
VerifiedBuild --- 0

and into

quest_poi
QuestID --- QuestID
id --- 0 (for a solo-point)
MapID 0 (MapID for Eastern Kingdoms, because it's in stranglethorn vale )
WorldMapAreaId --- 33 (it's jaguero isle )
Floor --- 0 (i don't know for what)
Priority --- 0 (i don't know for what)
Flags --- 0


So why it's not shown in my map??? (of course i restarted the server after and cleared the WDB...)

Maybe this will help: https://www.ownedcore.com/forums/wor...ml#post2405919 (And another question about quests)

[Corelith]

Maybe this will help: https://www.ownedcore.com/forums/wor...ml#post2405919 (And another question about quests)

Hey, thx 4 this answer....I looked at this link but it's about ArcEmu, so it dosn't work for me... As I wrote, i'm working on AC, you see?... But nevertheless, thank you^^

[stoneharry]

Hey, thx 4 this answer....I looked at this link but it's about ArcEmu, so it dosn't work for me... As I wrote, i'm working on AC, you see?... But nevertheless, thank you^^

It's the same values and system. The emulator doesn't matter, they all use the same structure.

[Corelith]

It's the same values and system. The emulator doesn't matter, they all use the same structure.

Sure, but its just another structure in the Database... for example, i don't have column 'unk4 '

as you wrote:

unk4 = what table of POI. 3 = a single point, 1 = area.

for table 'quest_poi' ...

I got columns:

QuestID - id - ObjectiveIndex - MapID - WorldMapAreaId - Floor - Priority - Flags - VerifiedBuild

in that table... so where to put the 3, is it a flag or a priority or what?!?
(your links in the other post are broken, so i just cannot compare those tables...)

[stoneharry]

Sure, but its just another structure in the Database... for example, i don't have column 'unk4 '

as you wrote:


for table 'quest_poi' ...

I got columns:

QuestID - id - ObjectiveIndex - MapID - WorldMapAreaId - Floor - Priority - Flags - VerifiedBuild

in that table... so where to put the 3, is it a flag or a priority or what?!?
(your links in the other post are broken, so i just cannot compare those tables...)

unk3 = unknown 3. It's the same structure, just when we used ArcEmu back in the day the column was undocumented.

I can't remember off the top of my head how it maps. I haven't worked with it in 5+ years. But you could test it out quite easily and see which column needs that value.

[Corelith]

unk3 = unknown 3. It's the same structure, just when we used ArcEmu back in the day the column was undocumented.

I can't remember off the top of my head how it maps. I haven't worked with it in 5+ years. But you could test it out quite easily and see which column needs that value.

ah ok - thought perhaps you know... ok i'll try and give back my results


edit:// ok after google-ing for ArcEmu Wikis I think, unk4 = Flags in this case.
Now i changed DB and i've to wait 4 restart, because there are some players online now...
I'll restart this night and will tell you tomorrow the result

[stoneharry]

ah ok - thought perhaps you know... ok i'll try and give back my results


edit:// ok after google-ing for ArcEmu Wikis I think, unk4 = Flags in this case.
Now i changed DB and i've to wait 4 restart, because there are some players online now...
I'll restart this night and will tell you tomorrow the result

Create a second developer realm, then you can just copy over the data to live when you want to release to live.

Alternatively set it up locally to test stuff quickly.

[Corelith]

Create a second developer realm, then you can just copy over the data to live when you want to release to live.

Alternatively set it up locally to test stuff quickly.

Hihi - you can't know... I got in case a local server with the same setup to test some time befor, but now the pc is sadly broken and now i'm on search for a new pc for me, to put my oldone on it's place... But 'till then, a testrealm would be an idea...

Buuuut - how to set up a second realm? Is there any tutorial
(You see i'm more or less new on this matters at all)
I found sometuts for Trinity or ArcEmu of course, but i'm not sure if it's like the same for AC, as you told me for the structure^^

[Corelith]

Ok I don't know.. the '3' in Flags dosen't work... so i tried '1', buts the same...

But rather the Q is not shown in my Map, if i mark 'Show Quest Objectives' on.
In my QuestLog the Quest is shown (also for that area), but if i got to the map, it's just away?!?!

Perhaps this helps to find the fail?

[stoneharry]

Ok I don't know.. the '3' in Flags dosen't work... so i tried '1', buts the same...

But rather the Q is not shown in my Map, if i mark 'Show Quest Objectives' on.
In my QuestLog the Quest is shown (also for that area), but if i got to the map, it's just away?!?!

Perhaps this helps to find the fail?

Not sure but I can confirm the information in the original post is up to date. I just gave this a go using TrinityCore for a project I'm working on:



Quest poi - ArcEmu-Wiki

[Corelith]

Sure, so but that's just what i did:

QuestID: 50001
id: 0
ObjectivIndex: 0
MapID: 0
WorldMapAreaId: 297
Flor: 0
Priority: 0
Flags: 3  //<-- your unk4, I think
VerifiedBuild: 0

But i don't know, there is no point displayed in map

[stoneharry]

Sure, so but that's just what i did:

QuestID: 50001
id: 0
ObjectivIndex: 0
MapID: 0
WorldMapAreaId: 297
Flor: 0
Priority: 0
Flags: 3  //<-- your unk4, I think
VerifiedBuild: 0

But i don't know, there is no point displayed in map

Flags should be 1 if you are displaying a single point.