My custom quest isn't in MySQL but still ingame

[ConnorJ]

Hello, My custom quest is in the game and I can pick it up, complete, turn it in. But when I go back on MySQL database for world and quests nothing shows up for it, I tried the entry id (9000000) and it's saying it can't find anything, I searched for the name of the quest, the npc id, the npc id that you need to kill to finnish the quest, it all comes back with no results It's weird because I can still acquire and complete the quest in game. I can't find it anywhere in MySQL.

Does somebody know how I can find this quest and change the entry Id from 9000000 to something more realistic like 1206 (the last entry id on mysql list is 1205)



As you can see, the NPC has the quest and I can pick it up, complete, turn in, but when I try to find the quest on MySQL with the entry id it can't find it

Thanks in advance

[ConnorJ]

It also finds it in game and allows you to .start quest

[ConnorJ]

I have resorted to deleting the quest and I'll have to make it again but not with a stupid id, does anyone know why it wasn't showing up in mysql? is it because of the jump from 1205 - 9000000 ?

Turns out I didn't delete the quest whole, I just removed it from that npc I hope I can still make the new quest and it not interfere.

[stoneharry]

SELECT * FROM quests WHERE entry = '9000000';
SELECT * FROM creature_quest_starter WHERE questId = '9000000';

You shouldn't use entries this high for multiple reasons. The main reason is that a integer has a fixed size limit, and if the value is too big, it won't be able to be stored correctly and will cause all sort of overflow issues. Also the data types in MySQL and the emulator may not match.

[ConnorJ]

Even with the entry id being low it still doesn't show in quest or creature_quest_start / end

[stoneharry]

You can use the follow commands:

.quest list
.quest addboth id
.quest delboth id

It takes a restart for changes to work.