Jump to content

Captain

Members
  • Content Count

    17
  • Avg. Content Per Day

    0
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Captain

  • Rank
    Poring

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. 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
  2. not related to this bug
  3. 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 ?
  4. Hi i use this simple script for my pvp ranking : prontera,141,175,5 script PVP Ranking 430,{ [email protected] = 10; [email protected] = 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: [email protected]$ = "MONTH"; [email protected]$ = "Classement du mois"; break; case 2: [email protected]$ = "WEEK"; [email protected]$ = "Classement de la semaine"; break; case 3: [email protected]$ = "DAY"; [email protected]$ = "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 " + [email protected]$ + "(`pvplog`.`pvp_date`) = " + [email protected]$ + "(CURRENT_DATE()) GROUP BY `char`.`name` ORDER BY count_kill DESC LIMIT " + [email protected], [email protected], [email protected]$, [email protected]_kill, [email protected]_death); mes [email protected]$; for( @i = 0; @i < getarraysize([email protected]$); @i++ ) { mes "Top " + (@i+1) + ": ^2ecc71" + [email protected]$[@i] + "^000000 kill/death: ^e74c3c" + [email protected]_kill[@i] + "/"+ [email protected]_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 " + [email protected], [email protected]$, [email protected]_kill); mes "Top your enemies:"; for( @i = 0; @i < getarraysize([email protected]$); @i++ ) { mes "Top 1: ^e74c3c" + [email protected]$[0] + "^000000 kill you ^2ecc71" + [email protected]_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 " + [email protected]$ + "(`pvplog`.`pvp_date`) = " + [email protected]$ + "(CURRENT_DATE()) GROUP BY `char`.`name` ORDER BY count_kill DESC LIMIT " + [email protected], [email protected], [email protected]$, [email protected]_kill, [email protected]_death); How to remove the lag?
  5. Hi, I'm still looking for how to do it
  6. Hi I would like to know if someone had @battleinfo and @packetfilter for rathena? thx
  7. 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
  8. Hi Anyone know how to add the minutes? to program a woe from 18:00 to 19:30 for example?
  9. @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 :
  10. @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
  11. Hi Any idea? rAthena Version Git Hash: 53761b952af832455526401acfc8b388a60a5d84
  12. 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
  13. 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
×
×
  • Create New...

Important Information

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