Page 1 of 1
Quest POI Problems
Posted: Sat Sep 10, 2016 11:31 am
by 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
Re: Quest POI Problems
Posted: Sat Sep 10, 2016 3:27 pm
by 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.
Re: Quest POI Problems
Posted: Sat Sep 10, 2016 4:57 pm
by 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. :/
Re: Quest POI Problems
Posted: Sat Sep 10, 2016 7:53 pm
by Jakkal
Okay, at some point the server crashed. And when it restarted (Presumably with the new POI for Ayin), it works now! Yay!
Re: Quest POI Problems
Posted: Mon Sep 12, 2016 12:49 am
by 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
Re: Quest POI Problems
Posted: Mon Sep 12, 2016 2:02 pm
by 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.
Re: Quest POI Problems
Posted: Mon Sep 12, 2016 2:06 pm
by 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.
Re: Quest POI Problems
Posted: Mon Sep 12, 2016 4:09 pm
by 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.
Re: Quest POI Problems
Posted: Mon Sep 12, 2016 4:12 pm
by Xinux
Which is the reason i said search different variations of the poi you are looking for.