Jump to content

Recommended Posts

yeah I bet everyone still using version 2.9, that outdated version from eathena

honestly there isn't much change with previous version, version 2.9 still works fine if you know how to fix it

 

Download: 3.6

hercules - script

rathena - script

soundeffect

 

 

Spoiler

2.9 - script

widely circulate on both rathena and hercules forum

 

3.0 - script

- fix a bug for hercules, BaseLevel is case-sensitive

- modernize the script

--- remove all set/setd/getd

--- looping the map change from for-loop into while-loop

--- rework sit-killing variable, no longer have any loop or stupid 128 limit

 

3.1 - script

- optimized query_sql execution from 4 times to just twice in every single way
- fix a bug sit-killing can cause value into negative
- remove OnWhisperGlobal ... I don't really see any use case for it

 

3.2 - script

- index the table properly

 

3.3 - script

- add PVP Ladder statues

 

3.4 - script

- fix the missing body style not display correctly

 

3.5 - script

- add .fix_custom_sprite setting to fix your server having custom animation equipment

 

3.6 - script

- fix a missing sprite change from LOOK_ROBE

 

if your server has custom animation sprite, remember to set .fix_custom_sprite to true

 

 

Questions:

when people ask to make modification to this script, it always comes down to these 2

 

1. monthly/weekly reset

ladder will reset monthly or weekly ... self explain

 

2. "@dotaannounce" off

hmm ... after talked to some people, they want the announcement set to global, but then some players want to see who are dead, and some players doesn't bother

and I also saw this is a custom modification ... can be made into this script but ... nah ... I'll do it when I feel like it

Edited by AnnieRuru

Share this post


Link to post
Share on other sites

damn ... forgot to index the table properly

 

3.2

script

- index the table properly

 

for those who already have the script installed, index these keys to make the query return faster, specifically when viewing the top 10

alter table pvpladder add key (`kills`);
alter table pvpladder add key (`streaks`);
alter table ownladder add key (`highestown`);

 

and yeah, this is the base script for public releases

any further modification, try ask here or open a new topic in script request ... or maybe as a paid request

Share this post


Link to post
Share on other sites

there are already 4 members asked me about pvp statue in discord ......

2 from hercules side, 2 from rathena side ....

.... I think I just release this to public

 

in case those who doesn't know what pvp statue is ->

https://rathena.org/board/topic/124379-pvp-ladder-show-top-5-player/

https://rathena.org/board/topic/126090-pvp-ladder-show-top-5-player-statue/

https://rathena.org/board/topic/125602-statue-npc-not-pvp-rankings/

 

 

screen2020Hercules003.jpg

 

3.3 - script

- add PVP ladder statues

 

 

Question ... should I also make this for rathena ?
I don't mind adding this simple stuff in version 2.9

Edited by AnnieRuru

Share this post


Link to post
Share on other sites

3.4 - script

- fix the missing body style not display correctly

 

thanks to this unknown member but AHHHHH HE REALLY BOTHER ME A LOT IN DISCORD for telling me that
IT'S YOUR PROBLEM that YOUR SERVER HAS CUSTOM COSTUME ITEM OK ??
this script HAS to show offline players' data, that's why can't show if the player is actually wearing 3rd job or 4th job costume

its your custom item fault OK ???

    OnEquipScript: <" changebase roclass(eaclass()|EAJL_THIRD); ">
    OnUnequipScript: <" changebase Class; ">

 

Share this post


Link to post
Share on other sites

Wow this is huge jump from 2.9. This comes with statues too! Is it Christmas? Thanks annie! 

 

Will this work to rathena?

Edited by gidzdlcrz
Asking if its working on rathena

Share this post


Link to post
Share on other sites

another server from rathena side told me his server has animated sprite overlapping on the statue

so again its YOUR problem that having animated sprite ... but at least this one can be fix easily by resetting the UDT_HEADTOP|UDT_HEADMIDDLE|UDT_HEADBOTTOM back to 0

statue_overlap_sprite.jpg

 

3.5 - script

- add .fix_custom_sprite setting to fix your server having custom animation equipment

 

16 hours ago, gidzdlcrz said:

Will this work to rathena?

simple script conversion

https://github.com/AnnieRuru/Release/blob/master/scripts/PvP %26 GvG/Dota PVP ladder/dota_sql_ladder_3.5r.txt

 

 

 

at least I don't find anything hassle to convert this script into rathena ... unlike promotion code ... already 3 rathena members ask me to do that, and I turn down every time

Edited by AnnieRuru

Share this post


Link to post
Share on other sites
12 hours ago, AnnieRuru said:

another server from rathena side told me his server has animated sprite overlapping on the statue

so again its YOUR problem that having animated sprite ... but at least this one can be fix easily by resetting the UDT_HEADTOP|UDT_HEADMIDDLE|UDT_HEADBOTTOM back to 0

statue_overlap_sprite.jpg

 

3.5 - script

- add .fix_custom_sprite setting to fix your server having custom animation equipment

 

simple script conversion

https://github.com/AnnieRuru/Release/blob/master/scripts/PvP %26 GvG/Dota PVP ladder/dota_sql_ladder_3.5r.txt

 

 

 

at least I don't find anything hassle to convert this script into rathena ... unlike promotion code ... already 3 rathena members ask me to do that, and I turn down every time


OMG its really Christmas! Those small fonts. 😁

Share this post


Link to post
Share on other sites

For the people who wants their costume robe to show up!

Find these  lines and add this BOLD.

Quote

[email protected]$  = "SELECT `char`.`char_id`, `char`.`name`, `char`.`guild_id`, `char`.`class`, `char`.`sex`, `char`.`hair`, `char`.`hair_color`, `char`.`clothes_color`, `char`.`body`, `char`.`head_top`, `char`.`head_mid`, `char`.`head_bottom`, `char`.`robe`, ";

 

Quote

 

Quote

        setunitdata .statue[[email protected] +1], UNPC_HEADTOP, [email protected]_top[[email protected]];
        setunitdata .statue[[email protected] +1], UNPC_HEADMIDDLE, [email protected]_mid[[email protected]];
        setunitdata .statue[[email protected] +1], UNPC_HEADBOTTOM, [email protected]_bottom[[email protected]];
        setunitdata .statue[[email protected] +1], UNPC_ROBE, [email protected][[email protected]];

 

Alright.

 

*Edit again. I forgot to mention that this is for rathena. 😝

Edited by gidzdlcrz
typos

Share this post


Link to post
Share on other sites
select * from item_db where type = 5 and equip_locations & 4 and view_sprite > 0;

yeah my RO knowledge is again outdated, never thought robes can show sprite change

 

3.6 - script

- fix a missing sprite change from LOOK_ROBE

 

 

PS: why the wings on my character is being chop off but the statue is display correctly ? WTF ??

screen2020Hercules006.jpg

Share this post


Link to post
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.   Restore formatting

  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.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.