Quest POI Problems

[Jakkal]

So I'm setting up the first "Training" quests in Halgarad. It's not nice and neat like Dahknarg where all the trainers are in one building. And worse, only one class got the scripts, so all we had in the DBE was the heavy fighter version of this quest.

So I had to make the quests for the Offensive Fighters, Healers and Spellcasters myself.

I'm just running into one problem, no matter what I've tried, the marker always points to the heavy fighter instructor. It should point to Ayin Alora. Now, I had to add in her POI manually, as one didn't exist for her in the DBE. So I don't know if that requires a server restart or whatnot. But I don't know why it continues to point to the heavy fighter instructor.

I even put the "AddPOI" command in the quest script hoping that would change it, but it doesn't. It keeps pointing to the heavy fighter instructor. I also put her POI's location ID in the locations tab of the quest, but again, it did nothing.

Here's the quest http://editor.vgoemulator.net:9302/ques ... or&id=9079

[zippyzee]

Make sure location2 in the quest table is the new poi that you want. It should correspond to the poi that should trigger when the quest is complete. If that's not it, location1 is the first location that shows up in the compass when the quest is accepted, so you might need to change it as well.

This isn't our design; that's how they did it originally and we don't have much control over the compass.

[Jakkal]

Yeah, I tried changing both of those. I added a location in the quest location tab. I added a POI in the script itself. Nothing seems to have changed it. I might have to delete the quests that I created, and recreate them with the proper POI. Maybe then it'll work. :/

[Jakkal]

Okay, at some point the server crashed. And when it restarted (Presumably with the new POI for Ayin), it works now! Yay!

[theFoof]

Opening this back up because I saw another character having SQL query errors on POIs when I glanced at the console. Not sure what the error would be from but I think something is going wrong as far as server->DB syncing for POIs.

Code: Select all

00:23:07.291 D Quest    Deleted objective progress on quest 3205 for character id: 2341 (XXXXXXX) during SaveCharacterQuestProgress.
00:23:07.307 E Database Error running MySQL query (1062): Duplicate entry '2341-1216' for key 'CharacterPOIIDX'
INSERT INTO `character_poi` (`char_id_fk`,`location_id_fk`)
VALUES (2341, 1216); 
00:23:07.307 E Quest    Unable to save poi id 1216 in table for character XXXXXX.

EDIT: Moving to server bugs

[Xinux]

Basically it's just saying they already have that POI under character_poi. They could have talked to a guard to get directions somewhere again and when it went to add that same poi in it was already there.

[zippyzee]

I'll look at it. There should be a system in place to avoid adding a poi to a character if they already have it. There could be an instance where they had it, deleted it, and re-added it between saves, so I need to adjust how that operates to prevent trying to add a duplicate key.

[Jakkal]

There was a couple of times that I looked for a character by name, and it did not come up in the DBE. But when I checked by their title (like "instructor"), it would come up. There's a good chance there are duplicates from people just looking up names and getting nothing, then adding the POI manually.

[Xinux]

Which is the reason i said search different variations of the poi you are looking for.