Jump to content

powkda

Members
  • Content Count

    47
  • Avg. Content Per Day

    0
  • Joined

  • Last visited

Community Reputation

0 Neutral

About powkda

  • Rank
    Drops

Recent Profile Visitors

675 profile views
  1. In GM and normal, if I configure to show the% of HP appears the emp also
  2. I have the same problem, Emperium% HP is showing
  3. add item information directly to iteminfo within the system
  4. I tried to leave the sprite name as follows but also unsuccessful 어세신_남_31510_검 어세신_남_31510_단검 어세신_남_31510_도끼
  5. Good night family, I need some help ... add a custom weapon for the assassin, i have her sprite for when assassin equips both weapons, but when i equip both the sprite doesn’t appear, how do i make the sprite appear when he equips these two custom weapons? I took this image on the net as an example, two weapons equipped but there is no sprite
  6. Thanks, but it's giving the same problem, when the war is active, the members of the other guilds are unable to enter the castle, they are teleported
  7. Good night, thanks for the help friend, but it is not working, member of another guild is entering the gp map, which should block from what I saw you put it in order not to check during the war, but then players from another guild will enter the map that they cannot, only those with the castle can enter, regardless of whether they are having the war or not
  8. I tried as follows, the problem is that in the castle at the time of the war the other guilds cannot enter - script Guarda -1,{ OnPCLoadMapEvent: set [email protected], GetCastleData("prtg_cas01",1); if (getcharid(2) == [email protected]) { dispbottom "[Sala do Clã]: Seja bem vindo a Sala do Clã"; end; } else { dispbottom "[Sala do Clã]: Apenas os Guerreiros que conquistaram o Castelo de Kriemhild podem estar neste lugar!"; warp "kalindor",146,169; end; } } gp mapflag loadevent
  9. good night friends, i want the npc to check if the player on the map is from the guild with the card, if it isn’t expelled from the map, i tried it in some ways here but without success
  10. Thank you very much friend, it was exactly the way I wanted
  11. Good night guys, I'm using this table CREATE TABLE `rankpvp01` ( `char_id` int(11) NOT NULL, `name` varchar(23) DEFAULT NULL, `kills_pvp1` int(11) DEFAULT NULL, `deaths_pvp1` int(11) DEFAULT NULL, `saldo_pvp1` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; and the following commands - script OnPCDieEvent#1 -1,{ OnPCDieEvent: getmapxy @mapdie1$,@x,@y; if (@mapdie1$ != "coca_cola") end; set @CID,getcharid(0);set @name$,"";set @points,0; query_sql "SELECT `deaths_pvp1` FROM `rankpvp01` WHERE `char_id`="[email protected]+"",@points; query_sql "SELECT `name` FROM `rankpvp01` WHERE `char_id`="[email protected]+"",@name$; if ( @name$ == "" ) { query_sql "INSERT INTO `rankpvp01` (`char_id`,`name`,`deaths_pvp1`) VALUES ("[email protected]+",'"+strcharinfo(0)+"',1)",@esc$; end; } query_sql "UPDATE `rankpvp01` SET `deaths_pvp1` = `deaths_pvp1` + 1 WHERE `char_id`="[email protected]+"",@esc$; end; } and - script OnPCKillEvent#pvp1 -1,{ OnPCKillEvent: getmapxy @map1$,@x,@y; if ( @map1$ != "coca_cola" ) end; set @CID,getcharid(0);set @name$,"";set @points,0; query_sql "SELECT `kills_pvp1` FROM `rankpvp01` WHERE `char_id`="[email protected]+"",@points; query_sql "SELECT `saldo_pvp1` FROM `rankpvp01` WHERE `char_id`="[email protected]+"",@saldo; query_sql "SELECT `name` FROM `rankpvp01` WHERE `char_id`="[email protected]+"",@name$; if ( @name$ == "" ) { query_sql "INSERT INTO `rankpvp01` (`char_id`,`name`,`kills_pvp1`) VALUES ("[email protected]+",'"+strcharinfo(0)+"',1)",@esc$; dispbottom "Você Matou seu primeiro jogador"; end; } query_sql "UPDATE `rankpvp01` SET `kills_pvp1` = `kills_pvp1` +1 WHERE `char_id`="[email protected]+"",@esc$; query_sql "UPDATE `rankpvp01` SET `saldo_pvp1` = `saldo_pvp1` +1 WHERE `char_id`="[email protected]+"",@esc$; set @points,@points+1; announce "Você matou [ "+rid2name(killedrid)+" ] e chegou a "[email protected]+" jogadores mortos.",bc_self,0x90FFFF; end; } but the saldo_pvp1 is not being accounted for I want that every time the player dies she loses 1 point in the saldo_pvp1 and every time he kills he gets 1 point already tried everything and does not leave 0 someone who can help me? thank you very much
  12. yes, I made the table, follow below CREATE TABLE `rankpvp01` ( `char_id` int(11) NOT NULL, `name` varchar(23) DEFAULT NULL, `kills_pvp1` int(11) DEFAULT NULL, `deaths_pvp1` int(11) DEFAULT NULL, `saldo_pvp1` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; the ratio that is "saldo_pvp1" is not being accounted for I'll post the npc here for you to take a look - script OnPCDieEvente#pvp1 -1,{ OnPCDieEvent: getmapxy @mapdie1$,@x,@y; if (@mapdie1$ != "coca_cola")end; set @id,getcharid(0); set @name$,""; query_sql "SELECT `name` FROM `rankpvp01` WHERE `char_id`="[email protected]+"",@name$; if ( @name$ == "" ) { query_sql "INSERT INTO `rankpvp01` (`char_id`,`name`,`deaths_pvp1`,`saldo_pvp1`) VALUES ("[email protected]+",'"+strcharinfo(0)+"',1)"; query_sql "UPDATE `rankpvp01` SET `saldo_pvp1` = `saldo_pvp1` - 1 WHERE `char_id`='"+getcharid(0)+"'"; end; } query_sql "UPDATE `rankpvp01` SET `deaths_pvp1` = `deaths_pvp1` + 1 WHERE `char_id`='"+getcharid(0)+"'"; query_sql "UPDATE `rankpvp01` SET `saldo_pvp1` = `saldo_pvp1` - 1 WHERE `char_id`='"+getcharid(0)+"'"; set @kill1,0; end; } - script OnPCKillEvent#pvp1 -1,{ OnPCKillEvent: getmapxy @map1$,@x,@y; if (@map1$!="coca_cola")end; set Antifk,killedrid; set @id,getcharid(0); set @name$,""; query_sql "SELECT `name` FROM `rankpvp01` WHERE `char_id`="[email protected]+"",@name$; if ( @name$ == "" ) { query_sql "INSERT INTO `rankpvp01` (`char_id`,`name`,`kills_pvp1`) VALUES ("[email protected]+",'"+strcharinfo(0)+"',1)"; query_sql "UPDATE `rankpvp01` SET `saldo_pvp1` = `kills_pvp1` - `deaths_pvp1` WHERE `char_id`='"+getcharid(0)+"'"; end; } query_sql "UPDATE `rankpvp01` SET `kills_pvp1` = `kills_pvp1` + 1 WHERE `char_id`='"+getcharid(0)+"'"; query_sql "UPDATE `rankpvp01` SET `saldo_pvp1` = `kills_pvp1` - `deaths_pvp1` WHERE `char_id`='"+getcharid(0)+"'"; set @kill1,@kill1+1; }
  13. - script OnPCDieEvente#pvp1 -1,{ OnPCDieEvent: getmapxy @mapdie1$,@x,@y; if (@mapdie1$ != "coca_cola")end; set @id,getcharid(0); set @name$,""; query_sql "SELECT `name` FROM `rankpvp01` WHERE `char_id`="[email protected]+"",@name$; if ( @name$ == "" ) { query_sql "INSERT INTO `rankpvp01` (`char_id`,`name`,`deaths_pvp1`,`saldo_pvp1`) VALUES ("[email protected]+",'"+strcharinfo(0)+"',1)"; query_sql "UPDATE `rankpvp01` SET `saldo_pvp1` = `saldo_pvp1` - 1 WHERE `char_id`='"+getcharid(0)+"'"; end; } query_sql "UPDATE `rankpvp01` SET `deaths_pvp1` = `deaths_pvp1` + 1 WHERE `char_id`='"+getcharid(0)+"'"; query_sql "UPDATE `rankpvp01` SET `saldo_pvp1` = `saldo_pvp1` - 1 WHERE `char_id`='"+getcharid(0)+"'"; set @kill1,0; end; } Good morning guys, I'm having difficulties with the sql of the pvp arena I'm doing, the balance is not counting Would you help me? I thank you for your attention
  14. thank you very much my friend, i will test and give you the feedback ♥
×
×
  • Create New...

Important Information

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