-
Content Count
47 -
Avg. Content Per Day
0 -
Joined
-
Last visited
Community Reputation
0 NeutralAbout powkda
-
Rank
Drops
Recent Profile Visitors
675 profile views
-
In GM and normal, if I configure to show the% of HP appears the emp also
-
I have the same problem, Emperium% HP is showing
-
add item information directly to iteminfo within the system
-
I tried to leave the sprite name as follows but also unsuccessful 어세신_남_31510_검 어세신_남_31510_단검 어세신_남_31510_도끼
-
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
-
check if the player is from the guild that has the castle
powkda replied to powkda's question in Scripting Support
gave error on line 18 -
check if the player is from the guild that has the castle
powkda replied to powkda's question in Scripting Support
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 -
check if the player is from the guild that has the castle
powkda replied to powkda's question in Scripting Support
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 -
check if the player is from the guild that has the castle
powkda replied to powkda's question in Scripting Support
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 -
check if the player is from the guild that has the castle
powkda posted a question in Scripting Support
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 -
Thank you very much friend, it was exactly the way I wanted
-
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
-
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; }
-
- 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
-
thank you very much my friend, i will test and give you the feedback ♥