Utility: [SQL] Mission Board

Kido · June 30, 2014

Maybe it's time to contact and pay someone to fix this, since seems abandoned... i will try to pay someone and if i get the fix of this whole script i will share it with you guys (:

(i will keep the credit of AnnieRuru, Emistry and anyone who worked in this script)

ThisIsSlain · July 4, 2014

Well...Same Error

[Error]: Loading NPC file: npc/custom/missionfilds.txt

script error on npc/custom/missionfilds.txt line 1019

    parse_line: expect command, missing function name or calling undeclared function

1014 :        // max mission per npc take by character

1015 :        .max_mission_per_char = 4;

1016 :

1017 :        // predefined values.

1018 :        .npc_name$ = strnpcinfo(0);

* 1019 :        .server_max_level = getserverdef( 'V'AR_MAX_LEVEL );

1020 :        setarray .base_job,

1021 :                EAJ_SWORDMAN,

1022 :                EAJ_MAGE,

1023 :                EAJ_ARCHER,

1024 :                EAJ_ACOLYTE,

I've updated my rAthena, and no work.

i got that same error too so i'm not using it ):

Replace * 1019 :        .server_max_level = getserverdef( 'V'AR_MAX_LEVEL );

with

.server_max_level = MAX_LEVEL;

as you are no longer able to use VAR_MAX_LEVEL to call for max level as it is not in the in db/const.txt anymore but moved to src/map/script.c as MAX_LEVEL. There are still other errors in this script however.

Edited July 4, 2014 by ThisIsSlain

Kido · July 15, 2014

Well...Same Error

[Error]: Loading NPC file: npc/custom/missionfilds.txt

script error on npc/custom/missionfilds.txt line 1019

    parse_line: expect command, missing function name or calling undeclared function

1014 :        // max mission per npc take by character

1015 :        .max_mission_per_char = 4;

1016 :

1017 :        // predefined values.

1018 :        .npc_name$ = strnpcinfo(0);

* 1019 :        .server_max_level = getserverdef( 'V'AR_MAX_LEVEL );

1020 :        setarray .base_job,

1021 :                EAJ_SWORDMAN,

1022 :                EAJ_MAGE,

1023 :                EAJ_ARCHER,

1024 :                EAJ_ACOLYTE,

I've updated my rAthena, and no work.

i got that same error too so i'm not using it ):
Replace * 1019 :        .server_max_level = getserverdef( 'V'AR_MAX_LEVEL ); 
with
.server_max_level = MAX_LEVEL; 
as you are no longer able to use VAR_MAX_LEVEL to call for max level as it is not in the in db/const.txt anymore but moved to src/map/script.c as MAX_LEVEL. There are still other errors in this script however.

Yeah i already did that, my players got a problem, when they relog they lose the kill count of some mobs, i can't set properly the quest time and so on @_@ thanks for ther help btw o:!

pukay · August 30, 2014

HAHA nomore update for emistry yet still waiting

AnnieRuru · August 30, 2014

Ok,the main problem has been fixed , but i have another problem on "NPC Limitation" When I try to select the letter A, the letter B is selects

I mean that if i active the letter "A" doesn't work, only the letter "B", and if I select the letter "C" doesnt works, and works letter "D"

....

and the options when i try select is disordered without alphabetical order

maybe can use increase the *sleep time inside OnInit: label ...

How do I make the OnNPCKillEvent: Show the mission name instead of the numbers

unfortunately, the way Emistry scripted it, needs to run query_sql every single time to read the `title` from `mission_board` table

and accessing query_sql too frequently can lag a server

well ... I added it, but remains commented

make it stop listing the kills after you reached the amount required

this one possible

tell you the mission is complete to return to the mission board?

this one require lots of checking ...

its better to just type '@mission' to check your progress

And how do i change the cash point reward to free points?

unless you understand the script ... otherwise its even hard to tell how to do it

because everything from zeny to cashpoints are hard-coded

Yeah i already did that, my players got a problem, when they relog they lose the kill count of some mobs, i can't set properly the quest time and so on @_@ thanks for ther help btw o:!

I thought I already fixed them in 1.4 ?

1.6 [paste=ftsocdeysre]

- fix the getserverdef script command

- increase sleep time inside OnInit to make lesser chance of getting unsorted ID

- in commented lines, stop listing the monsters when the kill count reached

- in commented lines, added listing for the mission name instead of mission ID

though, type @mission is a preferable choice

rom3r · August 30, 2014

Ok,the main problem has been fixed , but i have another problem on "NPC Limitation" When I try to select the letter A, the letter B is selects

I mean that if i active the letter "A" doesn't work, only the letter "B", and if I select the letter "C" doesnt works, and works letter "D"

....

and the options when i try select is disordered without alphabetical order

maybe can use increase the *sleep time inside OnInit: label ...

How do I make the OnNPCKillEvent: Show the mission name instead of the numbers
unfortunately, the way Emistry scripted it, needs to run query_sql every single time to read the `title` from `mission_board` table
and accessing query_sql too frequently can lag a server

well ... I added it, but remains commented

make it stop listing the kills after you reached the amount required
this one possible

tell you the mission is complete to return to the mission board?
this one require lots of checking ...
its better to just type '@mission' to check your progress

And how do i change the cash point reward to free points?
unless you understand the script ... otherwise its even hard to tell how to do it
because everything from zeny to cashpoints are hard-coded

Yeah i already did that, my players got a problem, when they relog they lose the kill count of some mobs, i can't set properly the quest time and so on @_@ thanks for ther help btw o:!
I thought I already fixed them in 1.4 ?
1.6 [paste=ftsocdeysre]

- fix the getserverdef script command

- increase sleep time inside OnInit to make lesser chance of getting unsorted ID

- in commented lines, stop listing the monsters when the kill count reached

- in commented lines, added listing for the mission name instead of mission ID

though, type @mission is a preferable choice

thank you but i found out awhile back after messing with it displaying mission name instead of id caused alot of problems lagged my sql out til the point it would lose connection.

Kido · August 31, 2014

Ok,the main problem has been fixed , but i have another problem on "NPC Limitation" When I try to select the letter A, the letter B is selects
I mean that if i active the letter "A" doesn't work, only the letter "B", and if I select the letter "C" doesnt works, and works letter "D"
....
and the options when i try select is disordered without alphabetical order
maybe can use increase the *sleep time inside OnInit: label ...

How do I make the OnNPCKillEvent: Show the mission name instead of the numbers
unfortunately, the way Emistry scripted it, needs to run query_sql every single time to read the `title` from `mission_board` table
and accessing query_sql too frequently can lag a server
well ... I added it, but remains commented

make it stop listing the kills after you reached the amount required
this one possible

tell you the mission is complete to return to the mission board?
this one require lots of checking ...
its better to just type '@mission' to check your progress

And how do i change the cash point reward to free points?
unless you understand the script ... otherwise its even hard to tell how to do it
because everything from zeny to cashpoints are hard-coded

Yeah i already did that, my players got a problem, when they relog they lose the kill count of some mobs, i can't set properly the quest time and so on @_@ thanks for ther help btw o:!
I thought I already fixed them in 1.4 ?

1.6 [paste=ftsocdeysre]
- fix the getserverdef script command
- increase sleep time inside OnInit to make lesser chance of getting unsorted ID
- in commented lines, stop listing the monsters when the kill count reached
- in commented lines, added listing for the mission name instead of mission ID
though, type @mission is a preferable choice

OH god you don't know how much i missed you!

uh yeah still i found some errors (stated above, even with the latest rA rev.) thank you so much for the helpsssssss!!!!!!

/rice

Dolphin86 · October 5, 2014

[Debug]: script debug : 0 110013108 : [ Mission Board ] Total NPC Loaded : 8 ...

what does that means?

Kido · October 5, 2014

[Debug]: script debug : 0 110013108 : [ Mission Board ] Total NPC Loaded : 8 ...

what does that means?

It just tells ypu that 8 npcs were loaded, isn't a problem or error (i'm right D: ? )

Dolphin86 · October 6, 2014

[Debug]: script debug : 0 110013108 : [ Mission Board ] Total NPC Loaded : 8 ...
what does that means?
It just tells ypu that 8 npcs were loaded, isn't a problem or error (i'm right D: ? )

well i know that, but im worry does it will effect the quest? like error or sumthing?

Kido · October 6, 2014

[Debug]: script debug : 0 110013108 : [ Mission Board ] Total NPC Loaded : 8 ...
what does that means?
It just tells ypu that 8 npcs were loaded, isn't a problem or error (i'm right D: ? )
well i know that, but im worry does it will effect the quest? like error or sumthing?

I don't think so, i tested this a hile weeks ago and it worked o:

Dolphin86 · October 6, 2014

ok thanks

joelolopez · October 14, 2014

i wish that the exp reward turns to 1~100% exp reward

Atreides · March 17, 2015

help...

[Error]: script error in file 'npc/pre-re/custom/mission_board.txt' line 1127 column 14
    parse_simpleexpr: unmatched ')'
  1124:         end;
  1125:
  1126: OnCommand:
* 1127:         if ( !strcmp( strnpcinfo(0), .npc_name$ ) ) {
        ~~~~~~~~~~~~~~~~~~~~^
  1128:                 if ( @ms_size ) {
  1129:                         for ( .@i = 0; .@i < @ms_size; .@i++ ) {
  1130:                                 .@mob_size = getarraysize( getd( "@ms_"+ @ms_list$[.@i] +"_list" ) );
[Info]: Done loading '13066' NPCs:
        -'3087' Warps
        -'9' Shops
        -'9955' Scripts
        -'3911' Spawn sets
        -'40461' Mobs Cached
        -'14' Mobs Not Cached
[Status]: Event 'OnInit' executed with '1694' NPCs.
[Status]: Event 'OnInterIfInit' executed with '0' NPCs.
[Status]: Event 'OnInterIfInitOnce' executed with '0' NPCs.

@edit
already resolved.

Edited March 17, 2015 by Soel

joelolopez · March 27, 2015

im looking forward for this script, for me this is one of the coolest scripts of rathena

it'll be much more cooler if it has

-quest progress message prompt like (kill poring 4/5) (kill poring complete!) (30 mins left to complete quest)

-time attack quest

-chain quest

-quest custom variable reward

-call quest cutin (cutin that will display when you register a quest)

-custom variable quest condition (for example quest: be a millionaire - checks you character zeny) (quest: be a mass murderer - checks #kill variable)

-chain mission

-support party-assist , guild-assist to completing the quests .

-quest auto warp (sets a map and coordinates for a certain quest :3)

-automatic reward (after completing the quest, you will be rewarded automatically where ever you are)

hooooooooo this will be a lot of work

bykass · March 30, 2015

help...

[Error]: script error in file 'npc/pre-re/custom/mission_board.txt' line 1127 column 14
    parse_simpleexpr: unmatched ')'
  1124:         end;
  1125:
  1126: OnCommand:
* 1127:         if ( !strcmp( strnpcinfo(0), .npc_name$ ) ) {
        ~~~~~~~~~~~~~~~~~~~~^
  1128:                 if ( @ms_size ) {
  1129:                         for ( .@i = 0; .@i < @ms_size; .@i++ ) {
  1130:                                 .@mob_size = getarraysize( getd( "@ms_"+ @ms_list$[.@i] +"_list" ) );
[Info]: Done loading '13066' NPCs:
        -'3087' Warps
        -'9' Shops
        -'9955' Scripts
        -'3911' Spawn sets
        -'40461' Mobs Cached
        -'14' Mobs Not Cached
[Status]: Event 'OnInit' executed with '1694' NPCs.
[Status]: Event 'OnInterIfInit' executed with '0' NPCs.
[Status]: Event 'OnInterIfInitOnce' executed with '0' NPCs.

@edit

already resolved.

as solved ? I'm having the same problem

Atreides · March 30, 2015

help...

[Error]: script error in file 'npc/pre-re/custom/mission_board.txt' line 1127 column 14
    parse_simpleexpr: unmatched ')'
  1124:         end;
  1125:
  1126: OnCommand:
* 1127:         if ( !strcmp( strnpcinfo(0), .npc_name$ ) ) {
        ~~~~~~~~~~~~~~~~~~~~^
  1128:                 if ( @ms_size ) {
  1129:                         for ( .@i = 0; .@i < @ms_size; .@i++ ) {
  1130:                                 .@mob_size = getarraysize( getd( "@ms_"+ @ms_list$[.@i] +"_list" ) );
[Info]: Done loading '13066' NPCs:
        -'3087' Warps
        -'9' Shops
        -'9955' Scripts
        -'3911' Spawn sets
        -'40461' Mobs Cached
        -'14' Mobs Not Cached
[Status]: Event 'OnInit' executed with '1694' NPCs.
[Status]: Event 'OnInterIfInit' executed with '0' NPCs.
[Status]: Event 'OnInterIfInitOnce' executed with '0' NPCs.

@edit

already resolved.

as solved ? I'm having the same problem

change this

        if ( !strcmp( strnpcinfo(0), .npc_name$ ) ) {

for this

	if ( .npc_name$ == strnpcinfo(0) ) {

i'm use Hercules Emulator

Edited March 30, 2015 by Soel

nicoscene · April 9, 2015

Is there a way to make this work on eAthena?

cutekram · September 6, 2015

I need help pls how to fix this i put this onto my SQL

/*
DROP TABLE IF EXISTS `mission_board`;
CREATE TABLE IF NOT EXISTS `mission_board` (
`id` int(11) unsigned NOT NULL,
`title` varchar(30) NOT NULL default '',
`desc` varchar(255) NOT NULL default '',
`mob_list` varchar(50) NOT NULL default '',
`mob_qty` varchar(50) NOT NULL default '',
`item_list` varchar(50) NOT NULL default '',
`item_qty` varchar(50) NOT NULL default '',
`class_limitation` int(11) unsigned NOT NULL default '0',
`class_branch` int(11) unsigned NOT NULL default '0',
`min_lv` smallint(6) unsigned NOT NULL default '1',
`max_lv` smallint(6) unsigned NOT NULL default '99',
`repeat` smallint(6) unsigned NOT NULL default '0',
`duration` int(11) unsigned NOT NULL default '0',
`reward_list` varchar(50) NOT NULL default '',
`reward_qty` varchar(50) NOT NULL default '',
`base_exp` int(11) unsigned NOT NULL default '0',
`job_exp` int(11) unsigned NOT NULL default '0',
`zeny` int(11) unsigned NOT NULL default '0',
`cash` int(11) unsigned NOT NULL default '0',
`aid` int(11) unsigned NOT NULL default '0',
`name` varchar(30) NOT NULL default '',
`time_update` datetime NOT NULL default '0000-00-00 00:00:00',
`npc_id` varchar(255) NOT NULL default '',
`redo_delay` smallint(6) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `player_mission`;
CREATE TABLE IF NOT EXISTS `player_mission` (
`id` int(11) unsigned NOT NULL,
`mission_id` int(11) unsigned NOT NULL,
`aid` int(11) unsigned NOT NULL default '0',
`cid` int(11) unsigned NOT NULL default '0',
`name` varchar(30) NOT NULL default '',
`mob_hunt` varchar(50) NOT NULL default '',
`expire` int(11) unsigned NOT NULL default '0',
`starting` datetime NOT NULL default '0000-00-00 00:00:00',
`completion` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*/

then rest is the script but i have this error

: DB error - Table 'ragnarok.mission_board' doesnt exist
	[Debug]: at script.c:16142 - SELECT 'id IN ( SELECT 'id FROM 'mission_board ect ect ect


	Can someone can help me pls.?

zaruramen · October 17, 2015

I cant get a quest if that quest have Redo-delay it told me

"You cant pick this mission, you have mission redo delay isnt finish yet."

Edited October 17, 2015 by zaruramen

stealth62 · March 6, 2016

+20 for this

any update of this npc?

query_sql "select timestampdiff( hour, completion, now() ), unix_timestamp( date_add( completion, interval "+ .@redo_delay +" hour ) ) from player_mission where cid = "+ getcharid(0) +" and mission_id = "+ .@id[.@i] +" order by completion desc limit 1", .@diff_delay, .@deny_time;

that line of code might conflict so that npc says "You cant pick this mission, you have mission redo delay isnt finish yet."

Edited March 6, 2016 by stealth61

croxinuz · November 15, 2016

anyone know how to add Zeny Requirement to mission board ??

EvilDesign · December 4, 2016

Links are all down >.< would be great if some one would reupload maybe a working version like the 1.6 from Annie

Thanks!

ex00089 · September 16, 2017

error
EXP setting 2000
Collar reward 1000

NPC said Something went wrong ..
what reason

CyberDevil · June 11, 2018

Can someone post their own collection of missions of the SQL Mission Table (mission_board) with some ready-made quests to get a starting point?
Thank you very much for this...

Sign In

Utility: [SQL] Mission Board

Recommended Posts

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Emistry

AnnieRuru

Emistry

Posted Images

Join the conversation

Recently Browsing 0 members

Announcements