Jump to content

Utility: [SQL] Mission Board


Emistry

Recommended Posts


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  24
  • Reputation:   0
  • Joined:  05/21/18
  • Last Seen:  

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.

208262826_Semttulo.png.f7d2c0525121689d0e35662406b16b9f.png

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

Link to comment
Share on other sites

  • 6 months later...

  • Group:  Members
  • Topic Count:  252
  • Topics Per Day:  0.06
  • Content Count:  700
  • Reputation:   15
  • Joined:  01/07/12
  • Last Seen:  

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? 

Link to comment
Share on other sites

  • 7 months later...

  • Group:  Members
  • Topic Count:  162
  • Topics Per Day:  0.05
  • Content Count:  1546
  • Reputation:   192
  • Joined:  07/23/14
  • Last Seen:  

@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)

 

Link to comment
Share on other sites

  • 2 months later...

  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.01
  • Content Count:  120
  • Reputation:   2
  • Joined:  03/21/17
  • Last Seen:  

Hello i tried to create the table in sql and am its giving error Screenshot_20191120-142607__01.thumb.jpg.d7ad476b4ea654fe2df924753aa50064.jpg

Was solved reason was sql strict mode

Link to comment
Share on other sites

  • 4 months later...

  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.01
  • Content Count:  271
  • Reputation:   62
  • Joined:  02/04/19
  • Last Seen:  

Does anyone have the new version of this script?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  252
  • Topics Per Day:  0.06
  • Content Count:  700
  • Reputation:   15
  • Joined:  01/07/12
  • Last Seen:  

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.

208262826_Semttulo.png.f7d2c0525121689d0e35662406b16b9f.png


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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...