Utility: [SQL] Mission Board

[LordJasz]

How can I fix the positions of NPCs where GM's can select the offer by the npcs.

I'm on Morocc and the quest is set only for Geffen. But I can't pick it in Geffen but I can pick on Morroc.

prontera,151,171,4	duplicate(mission_board)	Prontera Quests#1	837
payon,186,104,4	duplicate(mission_board)	Payon Quests#2	837
morocc,164,110,4	duplicate(mission_board)	Morroc Quests#3	837
geffen,115,165,4	duplicate(mission_board)	Geffen Quests#4	837

These are my 4 NPCs

[Dolphin86]

hi Emistry,

currently i am using this script on my newest server, its all good until i select which npc should each quest goes for,

example : i setup the grape juice quest on mission board A but for somehow its not shown on mission board A, but its shown on mission board H instead,

and there were no error, just had problem to assign which npc to which quest, can help please? 

[Radian]

@Emistry I'm getting this sql error, is there any other way to fix this?

[SQL]: DB error - Incorrect datetime value: '0000-00-00 00:00:00' for column 'completion' at row 1
[Debug]: at script.cpp:16756 - INSERT INTO `player_mission` VALUES ( 1566965080,1566965057,2000000,150000,'Radian','',0,NOW(),'0000-00-00 00:00:00' );
[Debug]: Source (NPC): Mission A#1 at prontera (151,171)

 

[NakedWolf]

Hello i tried to create the table in sql and am its giving error 

Was solved reason was sql strict mode

[M a p l e]

Does anyone have the new version of this script?

[Dolphin86]

if anyone have an updated version of this script please share

@Emistry is it possible to add feature percent completed quest while player doing it?

thanks for reply  

i guess this script is no longer supported

On 7/2/2018 at 7:15 PM, LordJasz said:

How can I fix the positions of NPCs where GM's can select the offer by the npcs.

I'm on Morocc and the quest is set only for Geffen. But I can't pick it in Geffen but I can pick on Morroc.

prontera,151,171,4	duplicate(mission_board)	Prontera Quests#1	837
payon,186,104,4	duplicate(mission_board)	Payon Quests#2	837
morocc,164,110,4	duplicate(mission_board)	Morroc Quests#3	837
geffen,115,165,4	duplicate(mission_board)	Geffen Quests#4	837

These are my 4 NPCs

had the same issue