Hunting Mission with party and individual quest

[mightyryan]

Hi,is it possible to add party quest for hunting mission? same reward from the individual one

here is the script: http://pastebin.com/jU576hJS

bump

bump

Edited October 21, 2012 by mightyryan

[AnnieRuru]

monster_hunting_euphy.txt

~~ no offense to Euphy ~~

oh yeah the party killing stuff is direct rip from my own mission board script

EDIT and Reupload : fix if the killer doesn't take any monster hunting quest before, all party members can't get the count

EDIT2:

oh pls remove

#Mission_delay = gettimetick(2);

at the beginning of the script =x

Edited October 22, 2012 by AnnieRuru

[mightyryan]

thanks much!!!!!!!!!!!! i am waiting for this! finally! Is it possible to only allow if the party members have only a gap of 1-20levels

Edited October 23, 2012 by mightyryan

[AnnieRuru]

that long long condition down there

replace with this

    } else {
       .@killedrid = killedrid;
       getmapxy .@map1$, .@x1, .@y1, 0;
       .@origin_level = baselevel;
       getpartymember getcharid(1), 1;
       getpartymember getcharid(1), 2;
       while ( .@j < $@partymembercount ) {
           if ( isloggedin( $@partymemberaid[.@j], $@partymembercid[.@j] ) ) {
               attachrid $@partymemberaid[.@j];
          	 if ( #Mission_Count && Mission1 && sqrt( pow( .@origin_level - baselevel, 2 ) ) <= 20 && hp > 0 ) { // shit I forgot to add dead check
                   getmapxy .@map2$, .@x2, .@y2, 0;
                   if ( .@map1$ == .@map2$ && distance( .@x1, .@y1, .@x2, .@y2 ) <= 30 ) {
                       .@i = 0;
                       while ( .@i < .Quests ) {
                           if ( strmobinfo( 1, .@killedrid ) == strmobinfo( 1, getd("Mission"+.@i) ) ) {
                               if ( getd("Mission"+ .@i +"_") < #Mission_Count) {
                                   dispbottom "[Hunting Mission] Killed "+( set( getd("Mission"+ .@i +"_"), getd("Mission"+ .@i +"_") +1 ) )+" of "+#Mission_Count+" "+strmobinfo(1,.@killedrid)+".";
                                   break;
                               }
                           }
                           .@i++;
                       }
                   }
               }
           }
           .@j++;
       }
   }

will trigger only with party levels within 20 range

[Euphy]

Thanks AnnieRuru, I had no idea an SQL query could do that... (and I was still using the txt database :3)

Added a new version with those features included: http://rathena.org/board/topic/64394-%E2%9C%B0-euphys-scripts-%E2%9C%B0/page__st__380#entry149188

[GmOcean]

-.-; I bet 95% of the scripters alive now wouldn't have thought of using sql that way. Though, that does prove useful even for my disguise event npc, i could litterally remove the black list array, and use that command, with some edits, to make sure it blocks all mobs that aren't normally spawned.

Just missing, checks for monsters with: ' G_ ', ' EVENT_ ', and the infamous ' DREAM_METAL '.

Edited October 24, 2012 by GmOcean

[AnnieRuru]

G_ and EVENT_ has been countered with dropcardid 4001~4999 check

Dream metal has been countered with ~mode & 32 check (not a boss monster)

set .Party,3;// Party options: 0 (exclude party kills), 1 (include party kills), 2 (same map only), 3 (screen area only)

about screen area, the number 30 is just because I like that number XD

the actual screen area is actually getbattleflag("area_size")

I tried use that before on a live server and got people complain it doesn't work, no idea how ( 3 years ago )

that's why I use a fix number

you can try getbattleflag("area_size") *2 ... or something, perhaps ?

its your script anyway

Edited October 24, 2012 by AnnieRuru

[GmOcean]

Ahh, i didn't see the card_id part, however, i ignored the boss monster check only because, i was trying to relate it to the disguise npc.

[Bin4ry]

Looking forward to see GmOcean's updates

Btw, are your update intended to stop those NPC monster appears? (Smoking Orc and etc)

[GmOcean]

Well, if i were to produce an update for the disguise event, then using Annie's sql code, i could limit all of those annoying monster's that just appear in our db because kro can't make up their minds lol.

[AnnieRuru]

I bet 95% of the scripters alive now wouldn't have thought of using sql that way.

want to show you another trick ?

query_sql("SELECT `name`,CAST(`value` AS SIGNED) FROM `global_reg_value` LEFT JOIN `char` ON `global_reg_value`.char_id = `char`.char_id WHERE `global_reg_value`.str = 'Mission_Total' ORDER BY CAST(`value` AS SIGNED) DESC LIMIT 5",.@name$,.@val);

this line, I don't like table join either

select char_id as abc, ( select name from `char` where char_id = abc ), value from global_reg_value where str = 'PC_DIE_COUNTER' order by cast(value as signed) desc limit 5;

topic

http://www.eathena.ws/board/index.php?showtopic=268999

SQL optimization

- try to avoid using JOIN table if possible

the sql will always join both tables together before it start its calculation

- cast( value as signed ) used twice in that script

you might not notice it, but to optimized sql performance, try to avoid having too many commands

well ... I think that's all about his script

replace into runs slower than insert into / update, so its fine

[Aya]

love this script! using this on my server ;D

[Euphy]

Thanks a lot, Annie. :>