AnnieRuru

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

 
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

HAHAHA !! my reputation is spoiled now !!
damn, I didn't make this mistake in a very long time
 
just rip from `char` table ?
fine ...
 
I used OnInit to persist the data so it survive server restart (or `@reloadscript`)
using function means ... needs to have at least 3, better do this as duplicate npc
 

 
1.2 - script
- fix a bug that server throw rid2name not found error
- add more name limitation such as npc name can't have # symbol
- allow to add more than one statue
- allow to search for offline player

HAHAHA !! my reputation is spoiled now !!
damn, I didn't make this mistake in a very long time
 
just rip from `char` table ?
fine ...
 
I used OnInit to persist the data so it survive server restart (or `@reloadscript`)
using function means ... needs to have at least 3, better do this as duplicate npc
 

 
1.2 - script
- fix a bug that server throw rid2name not found error
- add more name limitation such as npc name can't have # symbol
- allow to add more than one statue
- allow to search for offline player

Hi Maam Annie! I'm trying this wonderful script right now and I'm receiving this error:
 

 
Is this normal? The poring changes to a players sprite but whenever I talk to the NPC, it gives me that error notif.

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; ">  

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

1.2 - script
- fix a bug after the code expire, the "list player has claimed this code" option is missing
- fix a bug that when the code suddenly triggered/start, GM still can do edit
- add some text to tell why players can't claim the code
- add announcement when the Promotion Code activate and expire
 
EDIT: found another bug, when using EDIT start/expire time, the announcement doesn't react ....
I don't know how to fix this one <-- let's try trigger every hour
 
 
a big word NO
2 conditions then I'll consider
 
No.1 - tell rathena developers to merge *getcalendartime script command
https://github.com/HerculesWS/Hercules/commit/79b69495bbc5d758529a485eb1144bd64b8ea50f
 
No.2 - tell rathena developers that *preg_match to follow the exact PHP style format, that can return $array
https://www.php.net/manual/en/function.preg-match.php
 
currently rathena's preg_match is like this
*preg_match(<regular expression pattern>,<string>{,<offset>})
I want this
*preg_match(<regular expression pattern>,<string>{,<offset>{,<output array>,{<flag>}}})
 
if rathena has these 2 script commands, then only I'll consider
because this script is using them, without these 2 script commands it just won't feel the same functionality if these 2 features are scrap

ok so I have been annoyed by some people claiming that statue doesn't work
so I tackle this topic instead -> https://rathena.org/board/topic/125602-statue-npc-not-pvp-rankings/
 
let GM do whatever they want with this npc,
let it disguise as a player to reward them as a champion in an event, or just to shame a player for doing wrong things
whatever
 
Download: 1.4
script
 
Remember the color code

remember Navigation link and Item Link

 
 
 

ok so I have been annoyed by some people claiming that statue doesn't work
so I tackle this topic instead -> https://rathena.org/board/topic/125602-statue-npc-not-pvp-rankings/
 
let GM do whatever they want with this npc,
let it disguise as a player to reward them as a champion in an event, or just to shame a player for doing wrong things
whatever
 
Download: 1.4
script
 
Remember the color code

remember Navigation link and Item Link

 
 
 

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; ">  

HAHAHA !!
already like more than 5 people reminds me about this on discord XD
 
oh yeah I take this time to tell hercules community
few days ago a server that runs on hercules complained that we don't have enough battleground scripts
then I check my repo -> https://github.com/AnnieRuru/Release/tree/master/scripts/Battlegrounds
ONLY ONE which is bg_assasination -> https://github.com/AnnieRuru/Release/blob/master/scripts/Battlegrounds/bg_assassination.txt <-- yes this is safe to use in live server
the rest are rathena .... !
LMAO !!
 
I actually has more than 8 battlegrounds scripts, although many in same variations, but its still a quite amount
I think can start ONLY the battleground part after the `@packetfilter` done
2 more paid service to go (1 of them is yours)

Hi @AnnieRuru do you dropped this awesome project 🐀 ?
 
 

I got 2 rep up for making that grumbling post, that just shows how many members really like this idea
and of course I knew many topics talking about this script again and again and again and again and again and again and again and again and again and again and again and again !!!
so I make one myself and hopefully don't want see people talking about that bug script again !!
 
What this script does ?
GM generate some sort of gibberish word and promotes it on social media
then players input that gibberish word and able claim the items
 
honestly I don't really see the point of gibberish word,
I made this script in a drop down menu, players can just select it from the menu and claim it <_<
 
Download: 1.3
script
 
here's an example by Philippine RO, from this post

 
TODO :
1. add coloring to the text
2. HULD compatible ?
3. maybe someday can rewrite this whole damn thing with .npc_var sync with SQL variables so don't have to call query_sql too frequently
 
 

1.3 - script
- fix a bug the 'Promotion code has Started' didn't even activate after a server restart
- fix a bug when GM edit the start/expire date field, the announcement didn't update along with it ... should have just disable it when countdown initiated
- fix a bug when GM close a promo code, it doesn't announce a GM has closed it, yet its still make announcement about still can claim promo code
 
OKies I'm gonna leave this script and go do some other project ...
maybe some other day can come back and rewrite this script entirely with .npc_var only sync with SQL variables so don't have to call query_sql so frequently ...
but as it stands now, this script is 1400 lines, not something to be underestimate

/** * Loads persistent NPC Barter Data from SQL **/ static void npc_barter_fromsql(void) { struct SqlStmt *stmt = SQL->StmtMalloc(map->mysql_handle); char name[NAME_LENGTH + 1]; int itemid; int amount; int removeId; int removeAmount; if (SQL_ERROR == SQL->StmtPrepare(stmt, "SELECT `name`, `itemId`, `amount`, `priceId`, `priceAmount` FROM `%s`", map->npc_barter_data_db) || SQL_ERROR == SQL->StmtExecute(stmt) ) { SqlStmt_ShowDebug(stmt); SQL->StmtFree(stmt); return; } npc_barter_data_db is
https://github.com/HerculesWS/Hercules/blob/stable/conf/common/inter-server.conf#L120
npc_barter_data_db: "npc_barter_data"  
means you are missing a table name `npc_barter_data`
https://github.com/HerculesWS/Hercules/blob/stable/sql-files/upgrades/2018-12-29--07-51.sql
 
how can you ignore the SQL update file ?

*1 month later*
 
ok let's see
already done here, also I tried in my test server, my hexed client doesn't have additional body style support for soul linker etc ...
so its your custom stuffs
 
each body style has its own array ? its own CSV style string again ?
..... you dummy baka baka baka baka baka
 
use *changelook instead of *setlook
add .@reverse_order variable
 
1.7 - script
- add reverse_order to swap Next/Previous order
- now players don't have to go to flux cp every time to reset their look when client crash, since this script uses changelook instead of setlook now
 
 
 
.... account ?
if I have a 3rd job, save this built, apply to summoner job,
BAM client crash
nice idea but isn't very practical to have ....
 
for example Rushia changed her hair color from Green to Pink ... I can't recognize her for awhile
and all the fan art about her has green color hair =/
she try to change her look but what she did was smack her own fan art
 
EDIT: I think can make this possible JUST don't give save/load option for doram class ...

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

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

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/
 
 

 
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

can do this as paid service ?
 
if there are other members willing to do, feel free to post on the forum
 
but this seems very custom like, should be done as paid service ... contact me on discord

OnMinute40: if (mobcount(.Map$, strnpcinfo(0)+"::OnMobKilled") == 0) end; killmonster .Map$, strnpcinfo(0)+"::OnMobKilled"; announce "All left over mushroom has been removed", bc_all; end;  
I don't use rAthena but should work

src/map/skill.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/map/skill.c b/src/map/skill.c index 748570792..07dd365ca 100644 --- a/src/map/skill.c +++ b/src/map/skill.c @@ -4895,7 +4895,7 @@ static int skill_castend_damage_id(struct block_list *src, struct block_list *bl unit->movepos(src, bl->x+x, bl->y+y, 1, 1); } - clif->slide(src, src->x, src->y); +// clif->slide(src, src->x, src->y); clif->fixpos(src); clif->spiritball(src); }  
..... WEIRD ..... why disable the clif->slide shows the sliding animation for non-renewal client ????
 
hmm .... this is something I could never figure out, yeah the code works fine for renewal clients, but for non-renewal client, just disable that line ... what ??
 
honestly I'm not that good in coding skills nor client side ... clif.c stuffs,
this actually not within my field of expertise especially I have to download multiple client version just to test this

conf\map\battle\client.conf
// Limits use of blank (transparent) pixels in guild emblems to a set // percentage of the total. // Official servers do not enforce this technically to date, but some disallow // use of blank emblems in their rules. (Note 2) // A value of 100 (allowing 100% blank pixels) disables this check. // NOTE: Enabling this option slightly degrades performance. client_emblem_max_blank_percent: 100  
I think this is the answer you are looking for
@Kuroyama

now using client 2020, some thing has to update
 
1.2 - script
- use NST_BARTER
- split the query_sql into multiple lines for better readability

OnMinute40: if (mobcount(.Map$, strnpcinfo(0)+"::OnMobKilled") == 0) end; killmonster .Map$, strnpcinfo(0)+"::OnMobKilled"; announce "All left over mushroom has been removed", bc_all; end;  
I don't use rAthena but should work