playgron

Hey can I get a mirror link for this ? it's expired. and if GM use it on a player will they remain sit ? thx

im talking about pre-renewal server , you tested it on renewal, and my server stats looks just like that (renewal) but I disabled renewal already. I tried on other server pre-renewal , the damage is so much difference, not like mine. And im a old player , I play on pre-renewal alot , but this card damage is just change slightly , like atk weapon is better , for example: Hunter bow[1] hydra is better than Composite Bow [4] Hydra hydra skel worker skel worker , when the compo bow shouldve give bigger damage on pre-renewal

Hello guys so my server is using pre-renewal , but the damage seems weird. For example(for pvp/monster I tried it all): Sniper using hunter bow +0 , attacking player damage is 527 per hit (DS), and while he's using compo [4 hydra], attacking player damage is 570 per hit (DS) The difference is so small like renewal, but I already setting all on pre-renewal, any solutions ? same goes to monster , hunter bow damage almost the same with compo with 4 card elements. This is not only hunter bow , others aswell, like atk is better than card effect (Renewal).

nothing , still not showing anything when I moved the cursor oh my ... topic solved thanks.

I tried, still not showing buff timer , etc

Update: I used stateicon lua files etc , but still not working. Tried so many times , is it the client 2018-06-20e problem ?

Hello guys , I had a problem with status icon , im using 2018-06-20e RagexeRE , it doesnt show anything when u move/click your cursor on it. I want it to show the buff timer , etc. please help thx

PROBLEM FIXED , just some error with custom commands thanks

Hello guys so im using mvp script with rank every week player will get rewards (automated) , can any of you modify the script to change the reward into monthly ? thanks. OnInit: // set reward here ... 1st place won 10 red pot, 2nd place won 9 orange pot ... etc ... setarray .reward, 501, 502, 503; setarray .amount, 10, 9, 8; if ( !$mvp_rank_1st_sunday ) query_sql "select curdate() - dayofweek( curdate() ) +1", $mvp_rank_1st_sunday; // TRICK !! how to save the 1st sunday once the script installed OnSun0000: query_sql "select datediff( curdate(), '"+ $mvp_rank_1st_sunday +"' ) /7", .this_week_index; if ( .this_week_index == $mvp_rank_week_index ) end; .@query$ = "SELECT char_id, `name`, IF(@d=t.`mvp_kills`, @r, @r:=@i), @d:=t.`mvp_kills`, @i:=@i+1 "; .@query$ += "FROM `mvp_rank` t, (SELECT @d:=0, @r:=0, @i:=1)q "; .@query$ += "ORDER BY `mvp_kills` DESC LIMIT 10"; .@nb = query_sql(.@query$, .@cid, .@name$, .@rank, .@kills, .@dummy); if ( .@nb ) { for ( .@i = 0; .@i < .@nb; ++.@i ) { .@reward_query$[.@i] = "( "+ .@cid[.@i] +", "+ $mvp_rank_week_index +", "+ .@rank[.@i] +" )"; .@archive_query$[.@i] = "( "+ $mvp_rank_week_index +", "+ .@rank[.@i] +", "+ .@cid[.@i] +", '"+ escape_sql(.@name$[.@i]) +"', "+ .@kills[.@i] +" )"; } // query_sql "truncate table mvp_rank_archive"; // uncomment this line if you love to periodically clean your data query_sql "insert into mvp_rank_reward values "+ implode( .@reward_query$, ", " ); query_sql "insert into mvp_rank_archive values "+ implode( .@archive_query$, ", " ); query_sql "truncate table mvp_rank"; } $mvp_rank_week_index = .this_week_index; end;

bump

Hello guys I have a question about manual updates on github (linux). So from the commits , do I have to add each script manually ? because some of them have X sign what does that mean ? Please someone explain to me thanks

SOLVED I forgot to give access to my other sql user for drop , closed.

So im using this kinda script to truncate my mvp_rank table on every sunday , this is the example of the script: brasilis,223,189,3 script testtt 900,{ query_sql "truncate table mvp_rank"; end; } but when I tried it , it gave me errors [SQL]: DB error - DROP command denied to user 'asda'@'localhost' for table 'mvp_rank' [Debug]: at script.cpp:16557 - truncate table mvp_rank Anyone know how to make this possible ?

finally! I removed those and it worked! thank you so much ?

I did comment the renewal since the start. // Copyright (c) rAthena Dev Teams - Licensed under GNU GPL // For more information, see LICENCE in the main folder #ifndef CONFIG_RENEWAL_HPP #define CONFIG_RENEWAL_HPP //quick option to disable all renewal option, used by ./configure #define PRERE #ifndef PRERE /** * rAthena configuration file (http://rathena.org) * For detailed guidance on these check http://rathena.org/wiki/SRC/config/ **/ /** * @INFO: This file holds general-purpose renewal settings, for class-specific ones check /src/config/classes folder **/ /// Game renewal server mode /// (disable by commenting the line) /// /// Leave this line to enable renewal specific support such as renewal formulas //#define RENEWAL /// Renewal cast time /// (disable by commenting the line) /// /// Leave this line to enable renewal casting time algorithms and enable fixed cast bonuses. /// See also default_fixed_castrate in conf/battle/skill.conf for default fixed cast time (default is 20%). /// Cast time is altered be 2 portion, Variable Cast Time (VCT) and Fixed Cast Time (FCT). /// By default FCT is 20% of VCT (some skills aren't) /// - VCT is decreased by DEX * 2 + INT. /// - FCT is NOT reduced by stats, reduced by equips or buffs. /// Example: /// On a skill whos cast time is 10s, only 8s may be reduced. the other 2s are part of a FCT //#define RENEWAL_CAST /// Renewal drop rate algorithms /// (disable by commenting the line) /// /// Leave this line to enable renewal item drop rate algorithms /// While enabled a special modified based on the difference between the player and monster level is applied /// Based on the http://irowiki.org/wiki/Drop_System#Level_Factor table //#define RENEWAL_DROP /// Renewal exp rate algorithms /// (disable by commenting the line) /// /// Leave this line to enable renewal item exp rate algorithms /// While enabled a special modified based on the difference between the player and monster level is applied //#define RENEWAL_EXP /// Renewal level modifier on damage /// (disable by commenting the line) /// // Leave this line to enable renewal base level modifier on skill damage (selected skills only) //#define RENEWAL_LVDMG /// Renewal ASPD [malufett] /// (disable by commenting the line) /// /// Leave this line to enable renewal ASPD /// - shield penalty is applied /// - AGI has a greater factor in ASPD increase /// - there is a change in how skills/items give ASPD /// - some skill/item ASPD bonuses won't stack //#define RENEWAL_ASPD /// Renewal stat calculations /// (disable by commenting the line) /// /// Leave this line to enable renewal calculation for increasing status/parameter points //#define RENEWAL_STAT #endif #endif /* CONFIG_RENEWAL_HPP */