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