Jump to content

Utility: [SQL] Mission Board


Emistry

Recommended Posts


  • Group:  Members
  • Topic Count:  127
  • Topics Per Day:  0.03
  • Content Count:  1445
  • Reputation:   163
  • Joined:  08/17/13
  • Last Seen:  

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)

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  06/14/14
  • Last Seen:  

 

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 by ThisIsSlain
Link to comment
Share on other sites

  • 2 weeks later...

  • Group:  Members
  • Topic Count:  127
  • Topics Per Day:  0.03
  • Content Count:  1445
  • Reputation:   163
  • Joined:  08/17/13
  • Last Seen:  

 

 

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:!

Link to comment
Share on other sites

  • 1 month later...

  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  23
  • Reputation:   1
  • Joined:  05/10/14
  • Last Seen:  

HAHA nomore update for emistry yet still waiting :D

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  18
  • Topics Per Day:  0.00
  • Content Count:  2044
  • Reputation:   682
  • Joined:  10/09/12
  • Last Seen:  

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

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  36
  • Reputation:   1
  • Joined:  05/05/14
  • Last Seen:  

 

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  127
  • Topics Per Day:  0.03
  • Content Count:  1445
  • Reputation:   163
  • Joined:  08/17/13
  • Last Seen:  

 

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

Link to comment
Share on other sites

  • 1 month later...

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

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

what does that means?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  127
  • Topics Per Day:  0.03
  • Content Count:  1445
  • Reputation:   163
  • Joined:  08/17/13
  • Last Seen:  

[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: ? )

Link to comment
Share on other sites


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

 

[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?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  127
  • Topics Per Day:  0.03
  • Content Count:  1445
  • Reputation:   163
  • Joined:  08/17/13
  • Last Seen:  

 

 

[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:

Link to comment
Share on other sites


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

ok thanks

Link to comment
Share on other sites

  • 2 weeks later...

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 5 months later...

  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  40
  • Reputation:   7
  • Joined:  03/16/12
  • Last Seen:  

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 by Soel
Link to comment
Share on other sites

  • 2 weeks later...

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/12
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  02/09/13
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  40
  • Reputation:   7
  • Joined:  03/16/12
  • Last Seen:  

 

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 by Soel
Link to comment
Share on other sites

  • 2 weeks later...

  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  154
  • Reputation:   6
  • Joined:  04/26/12
  • Last Seen:  

Is there a way to make this work on eAthena?

Link to comment
Share on other sites

  • 4 months later...

  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  30
  • Reputation:   0
  • Joined:  08/08/13
  • Last Seen:  

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

  1. /*
  2.  
  3. DROP TABLE IF EXISTS `mission_board`;
  4. CREATE TABLE IF NOT EXISTS `mission_board` (
  5. `id` int(11) unsigned NOT NULL,
  6. `title` varchar(30) NOT NULL default '',
  7. `desc` varchar(255) NOT NULL default '',
  8. `mob_list` varchar(50) NOT NULL default '',
  9. `mob_qty` varchar(50) NOT NULL default '',
  10. `item_list` varchar(50) NOT NULL default '',
  11. `item_qty` varchar(50) NOT NULL default '',
  12. `class_limitation` int(11) unsigned NOT NULL default '0',
  13. `class_branch` int(11) unsigned NOT NULL default '0',
  14. `min_lv` smallint(6) unsigned NOT NULL default '1',
  15. `max_lv` smallint(6) unsigned NOT NULL default '99',
  16. `repeat` smallint(6) unsigned NOT NULL default '0',
  17. `duration` int(11) unsigned NOT NULL default '0',
  18. `reward_list` varchar(50) NOT NULL default '',
  19. `reward_qty` varchar(50) NOT NULL default '',
  20. `base_exp` int(11) unsigned NOT NULL default '0',
  21. `job_exp` int(11) unsigned NOT NULL default '0',
  22. `zeny` int(11) unsigned NOT NULL default '0',
  23. `cash` int(11) unsigned NOT NULL default '0',
  24. `aid` int(11) unsigned NOT NULL default '0',
  25. `name` varchar(30) NOT NULL default '',
  26. `time_update` datetime NOT NULL default '0000-00-00 00:00:00',
  27. `npc_id` varchar(255) NOT NULL default '',
  28. `redo_delay` smallint(6) unsigned NOT NULL default '0',
  29. PRIMARY KEY (`id`)
  30. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  31.  
  32.  
  33. DROP TABLE IF EXISTS `player_mission`;
  34. CREATE TABLE IF NOT EXISTS `player_mission` (
  35. `id` int(11) unsigned NOT NULL,
  36. `mission_id` int(11) unsigned NOT NULL,
  37. `aid` int(11) unsigned NOT NULL default '0',
  38. `cid` int(11) unsigned NOT NULL default '0',
  39. `name` varchar(30) NOT NULL default '',
  40. `mob_hunt` varchar(50) NOT NULL default '',
  41. `expire` int(11) unsigned NOT NULL default '0',
  42. `starting` datetime NOT NULL default '0000-00-00 00:00:00',
  43. `completion` datetime NOT NULL default '0000-00-00 00:00:00',
  44. PRIMARY KEY (`id`)
  45. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  46.  
  47. */

    then rest is the script but i have this error
  48.  
  49. : 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.?
Link to comment
Share on other sites

  • 1 month later...

  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  41
  • Reputation:   0
  • Joined:  08/27/15
  • Last Seen:  

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 by zaruramen
Link to comment
Share on other sites

  • 4 months later...

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  11
  • Reputation:   0
  • Joined:  12/13/12
  • Last Seen:  

+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 by stealth61
Link to comment
Share on other sites

  • 8 months later...

  • Group:  Members
  • Topic Count:  27
  • Topics Per Day:  0.01
  • Content Count:  62
  • Reputation:   0
  • Joined:  03/18/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 3 weeks later...

  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  24
  • Reputation:   1
  • Joined:  11/12/14
  • Last Seen:  

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

Thanks!

Link to comment
Share on other sites

  • 9 months later...

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  4
  • Reputation:   0
  • Joined:  07/24/17
  • Last Seen:  

error
EXP setting 2000
Collar reward 1000

NPC said Something went wrong ..
what reason

Link to comment
Share on other sites

  • 8 months later...

  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  242
  • Reputation:   37
  • Joined:  02/25/18
  • Last Seen:  

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...

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...