Jump to content

whateverhafiz

Members
  • Posts

    5
  • Joined

  • Last visited

Profile Information

  • Gender
    Male
  • Location
    Malaysia

whateverhafiz's Achievements

Poring

Poring (1/15)

0

Reputation

  1. can anyone make this SQL script For me? thanks. - script Arena#PCDie -1,{ OnPCDieEvent: if(BaseLevel!=255) end; getmapxy @map$,@x,@y,0; if ( @map$ == $pvp$[$pvp] ) goto PvP; if ( @map$ == $gvg$[$gvg] ) goto GvG; if ( @map$ == $nvn$[$nvn] ) goto NvN; end; PvP: set @CID,getcharid(0);set @name$,"";set @points,0; query_sql "SELECT `deaths` FROM `pvp` WHERE `char_id`="+@CID+"",@points; query_sql "SELECT `name` FROM `pvp` WHERE `char_id`="+@CID+"",@name$; if ( @name$ == "" ) { query_sql "INSERT INTO `pvp` (`char_id`,`name`,`deaths`) VALUES ("+@CID+",'"+strcharinfo(0)+"',1)",@esc$; dispbottom "Kill Count: 1"; end; } query_sql "UPDATE `pvp` SET `deaths` = `deaths` + 1 WHERE `char_id`="+@CID+"",@esc$; end; GvG: set @GID,getcharid(2);set @name$,"";set @gpoints,0; query_sql "SELECT `deaths` FROM `gvg` WHERE `guild_id`="+@GID+"",@gpoints; query_sql "SELECT `name` FROM `gvg` WHERE `guild_id`="+@GID+"",@name$; if ( @name$ == "" ) { query_sql "INSERT INTO`gvg` (`guild_id`,`name`,`deaths`) VALUES ("+@GID+",'"+strcharinfo(2)+"',1)",@esc$; dispbottom "Pontuação da Guild: 1"; end; } query_sql "UPDATE `gvg` SET `deaths` = `deaths` + 1 WHERE `guild_id`="+@GID+"",@esc$; end; NvN: set @CID,getcharid(0);set @name$,"";set @points,0; query_sql "SELECT `deaths` FROM `pvp` WHERE `char_id`="+@CID+"",@points; query_sql "SELECT `name` FROM `pvp` WHERE `char_id`="+@CID+"",@name$; if ( @name$ == "" ) { query_sql "INSERT INTO `pvp` (`char_id`,`name`,`deaths`) VALUES ("+@CID+",'"+strcharinfo(0)+"',1)",@esc$; dispbottom "Kill Count: 1"; end; } query_sql "UPDATE `pvp` SET `deaths` = `deaths` + 1 WHERE `char_id`="+@CID+"",@esc$; end; } Anyone can help me? npcs.txt
  2. tq Sir. But, while i'm using old SVN ( year 2009 ), client 2009. this error not accour. i'm using trunk version 2012, new client , this problem accour. other custom map working fine. this map only. any solution sir?
  3. i want to use this map as a custom map. ( Aeven map from rathena ) everything i follow. ( guide ) but. when i want to go that map. this error happend ( loading screen ) anyone know ?
×
×
  • Create New...