Captain

Hi, I am looking for an NPC which could give rental item with card for example a rental knife [4] and the possibility to choose which card we want to put in it (drops/cecil damon ) because currently if a player puts cards in an item rental slot it disappears with the item

not related to this bug

Hi, I have a bug with the display of the cursor on the homunculus, instead of having a sword in pvp there is a circle which makes the homunculus impossible to focus with skill/ or regular attack : /ns or shift doesn't work How i can replace the circle by the sword because currently it is impossible to kill a homunculus at pvp ?

Hi i use this simple script for my pvp ranking : prontera,141,175,5 script PVP Ranking 430,{ .@limitRanking = 10; .@limitEnemies = 10; mes "[PvP Ranking]"; //menu "Classement du mois", L_RankMonth, "Classement de la semaine", L_RankWeek, "Classement du jour", L_RankDay; select "Classement du mois", "Classement de la semaine", "Classement du jour", "Mes ennemis"; if (@menu < 4) { // Ranking switch(@menu) { case 1: .@ranking$ = "MONTH"; .@message$ = "Classement du mois"; break; case 2: .@ranking$ = "WEEK"; .@message$ = "Classement de la semaine"; break; case 3: .@ranking$ = "DAY"; .@message$ = "Classement du jour"; break; } query_sql("SELECT `pvplog`.`killer_id` AS CID, `char`.`name`, COUNT(`pvplog`.`killer_id`) AS count_kill, (SELECT COUNT(`pvplog`.`victim_id`) from pvplog where victim_id = CID) FROM `pvplog` INNER JOIN `char` ON `char`.`char_id` = `pvplog`.`killer_id` WHERE " + .@ranking$ + "(`pvplog`.`pvp_date`) = " + .@ranking$ + "(CURRENT_DATE()) GROUP BY `char`.`name` ORDER BY count_kill DESC LIMIT " + .@limitRanking, .@cid, .@name$, .@count_kill, .@count_death); mes .@message$; for( @i = 0; @i < getarraysize(.@name$); @i++ ) { mes "Top " + (@i+1) + ": ^2ecc71" + .@name$[@i] + "^000000 kill/death: ^e74c3c" + .@count_kill[@i] + "/"+ .@count_death[@i] + "^000000"; } } else if (@menu == 4) { query_sql("SELECT `char`.`name`, COUNT(`char`.`name`) AS count_kill FROM `pvplog` INNER JOIN `char` ON `char`.`char_id` = `pvplog`.`killer_id` WHERE `pvplog`.`victim_id` = " + getcharid(0) + " GROUP BY `char`.`name` ORDER BY count_kill DESC LIMIT " + .@limitEnemies, .@name$, .@count_kill); mes "Top your enemies:"; for( @i = 0; @i < getarraysize(.@name$); @i++ ) { mes "Top 1: ^e74c3c" + .@name$[0] + "^000000 kill you ^2ecc71" + .@count_kill[0] + "^000000 times" + "^000000"; } } close; L_RankMonth: mes "Ranking of month"; close; L_RankWeek: mes "Ranking of week"; close; L_RankDay: mes "Ranking of day"; close; end; OnInit : waitingroom "[ PVP Ranking ]",0; } - script pvplog -1,{ OnPCKillEvent: if (strcharinfo(3) == "guild_vs3") { query_sql("INSERT INTO `pvplog` (`killer_id`, `victim_id`, `map`) VALUES ('" + getcharid(0) + "', (SELECT `char_id` FROM `char` WHERE `name` = '" + rid2name(killedrid) + "'), '" + strcharinfo(3) + "');"); end; } } The ranking work, but when there are more than ~1000-1200 log in the table, when using the NPC there is a lag/freeze of 3-4 seconds before displaying the ranking. The sql part which displays the ranking query_sql("SELECT `pvplog`.`killer_id` AS CID, `char`.`name`, COUNT(`pvplog`.`killer_id`) AS count_kill, (SELECT COUNT(`pvplog`.`victim_id`) from pvplog where victim_id = CID) FROM `pvplog` INNER JOIN `char` ON `char`.`char_id` = `pvplog`.`killer_id` WHERE " + .@ranking$ + "(`pvplog`.`pvp_date`) = " + .@ranking$ + "(CURRENT_DATE()) GROUP BY `char`.`name` ORDER BY count_kill DESC LIMIT " + .@limitRanking, .@cid, .@name$, .@count_kill, .@count_death); How to remove the lag?

Hi, I'm still looking for how to do it

Any idea ?

Hi I would like to know if someone had @battleinfo and @packetfilter for rathena? thx

Hi I am trying to configure the skill mindbreak and provoke to work on guild members only in WoE/GVG map I added the flag "guildonly : true " but it"s possible to use on guild members everywhere Name: PF_MINDBREAKER Description: Mind Breaker MaxLevel: 5 TargetType: Attack DamageFlags: NoDamage: true Flags: GuildOnly: true There is a flag for only gvg/woe map ? Thx

Hi Anyone know how to add the minutes? to program a woe from 18:00 to 19:30 for example?

@latios The problem is you can't equip the costume headgear if you not have the requirement of not costume headgear example on novice with costume apple of archer :

@latios Thx for the update, but to be able to equip the costume you must have the requirements of the normal headgear example : a costume apple of archer require lvl 30 and can't equip by a novice

Hi Any idea? rAthena Version Git Hash: 53761b952af832455526401acfc8b388a60a5d84

Hi I have bug with "debuff" skill the skill like lex aterna / lex divina / eske doesn't work on ghost race monster The skill is cast but has no effect only on ghost monster it's a feature or a bug ? Thx

Hi I don't know how the gladiator skill solar/lunar/stellar heat does no damage : it was still working a few hours ago Any idea ? Thx

Thx a lot it work !