SQL Mission Board Problem

[schan]

Hi,

I tried Annie's fix for Emistry's SQL Mission board found here: http://rathena.org/board/topic/91042-utility-sql-mission-board/page-3#entry243485

and I found these problems:

1.) It is always 'incomplete' in Monster List even though I finished setting up a monster to kill.

2.) I tried Submitting a mission even though I haven't finished killing all the required number of monster and it let me continue thus giving me the reward.

3.) I checked my db and found out that mob_hunt was blank as seen above.

Can you help me fix these problems?

Thank you!

 

[AnnieRuru]

apparently, that script only works on latest rathena, and not working on latest hercules

but first, what is your server revision

I just setup back rathena test server because of this script <.<





cannot reproduce your problem

2.

the SQL table is only update when the player logout

as you can see them inside OnPCLogoutEvent

I also don't like this way though, my old script update the variable on the spot (but did not use SQL table)

 

[schan]

apparently, that script only works on latest rathena, and not working on latest hercules

but first, what is your server revision

I just setup back rathena test server because of this script <.<

screenrAthena036.jpg

screenrAthena037.jpg

cannot reproduce your problem

2.

the SQL table is only update when the player logout

as you can see them inside OnPCLogoutEvent

I also don't like this way though, my old script update the variable on the spot (but did not use SQL table)

I don't have this dispbottom message when killing monsters.

Still incomplete even though I set it right:

 

I'm currently using 2263dc4660. A little bit old too.

Also, I had this error earlier:

 

It says unmatched ')' , but it wasn't. 

 

[AnnieRuru]

I don't have this dispbottom message when killing monsters.

type '@mission'and see the magic

but I don't think you can see it because your server doesn't support *strcmp

.

.

Also, I had this error earlier:

 

It says unmatched ')' , but it wasn't.

I purposely put that as a test to know the user is using latest rathena or notbecause this script can only use in latest rathena

https://github.com/rathena/rathena/commit/d569d288bd73b9eb076e76302ecf4c17a0340d10

there are a few commands which are not compatible with hercules

however after developer fix this bug, I might consider fix this to use in hercules

 

[schan]

I don't have this dispbottom message when killing monsters.

type '@mission'and see the magic

but I don't think you can see it because your server doesn't support *strcmp

.

.

>Also, I had this error earlier:

 

It says unmatched ')' , but it wasn't.

I purposely put that as a test to know the user is using latest rathena or notbecause this script can only use in latest rathena

https://github.com/rathena/rathena/commit/d569d288bd73b9eb076e76302ecf4c17a0340d10

there are a few commands which are not compatible with hercules

however after developer fix this bug, I might consider fix this to use in hercules

Yay! Great thing you're here in Hercules now.

Thanks!

 

[Samuel]

@AnnieRuru Hmm, you could try this plugin.. I have converted the strcmp script command from rathena into plugin..

http://upaste.me/bf2e10664c663ecb4

 

[AnnieRuru]

@AnnieRuru Hmm, you could try this plugin.. I have converted the strcmp script command from rathena into plugin..

http://upaste.me/bf2e10664c663ecb4

yeah its working finethanks a lot

I just learn how to install a plugin because of this post lol