Hi. I need someone help me about this error I edit script pvp leader
and I get some error. Who know how to fix it?
This error and my script
- script stand_system -1,{
end;
OnInit:
sleep 1;
OnTimer30000:
.@query$ = "SELECT `char`.`char_id`, `char`.`name`, `char`.`guild_id`, `char`.`class`, `char`.`sex`, `char`.`hair`, `char`.`hair_color`, `char`.`clothes_color`, `char`.`body`, `char`.`head_top`, `char`.`head_mid`, `char`.`head_bottom`, `char`.`robe`, "
+ "`pvp_for_show_c1`.`points` "
+ "FROM `char` RIGHT JOIN `pvp_for_show_c1` ON `char`.`char_id` = `pvp_for_show_c1`.`char_id` ORDER BY `points` DESC LIMIT 3";
.@nb = query_sql(.@query$, .@cid, .@name$, .@guild_id, .@class, .@sex$, .@hair, .@hair_color, .@clothes_color, .@body, .@head_top, .@head_mid, .@head_bottom, .@robe, .@points);
for (set .@i,0; .@i < .@nb; set .@i,.@i+1) {
setunitdata .statue[.@i +1], UNPC_CLASS, .@class[.@i];
setunitdata .statue[.@i +1], UNPC_SEX, (.@sex$[.@i] == "F")? SEX_FEMALE:SEX_MALE;
setunitdata .statue[.@i +1], UNPC_HAIRSTYLE, .@hair[.@i];
setunitdata .statue[.@i +1], UNPC_HAIRCOLOR, .@hair_color[.@i];
setunitdata .statue[.@i +1], UNPC_CLOTHCOLOR, .@clothes_color[.@i];
setunitdata .statue[.@i +1], UNPC_BODY2, .@body[.@i];
setunitdata .statue[.@i +1], UNPC_HEADTOP, .@head_top[.@i];
setunitdata .statue[.@i +1], UNPC_HEADMIDDLE, .@head_mid[.@i];
setunitdata .statue[.@i +1], UNPC_HEADBOTTOM, .@head_bottom[.@i];
setunitdata .statue[.@i +1], UNPC_ROBE, .@robe[.@i];
setnpcdisplay "pvp_ladder_statue#"+(.@i +1), .@name$[.@i];
.statue_name$[.@i +1] = .@name$[.@i];
.statue_guild$[.@i +1] = getguildname(.@guild_id[.@i]);
.statue_points[.@i +1] = .@points[.@i];
}
for (set .@i,.@nb; .@i < .showstatue; set .@i,.@i+1)
setunitdata .statue[.@i +1], UNPC_CLASS, HIDDEN_WARP_NPC;
initnpctimer;
end;
}
- script pvp_ladder_statue FAKE_NPC,{
.@id = getelementofarray(getvariableofnpc(.npcgid, "stand_system"), getnpcid(0));
mes "^996600[ Class 1 TOP "+ .@id +" ]";
mes "^006699ชื่อ : "+ getelementofarray(getvariableofnpc(.statue_name$, "stand_system"), .@id);
.@guildname$ = getelementofarray(getvariableofnpc(.statue_guild$, "stand_system"), .@id);
mes "^00AAAAกิลด์ : "+((.@guildname$ == "null")? "^AAAAAANone": .@guildname$);
mes "^00AA00แต้ม : ["+ getelementofarray(getvariableofnpc(.statue_points, "stand_system"), .@id) +"]";
close;
OnInit:
.@id = strnpcinfo(2);
set getvariableofnpc(.statue[.@id], "stand_system"), getnpcid(0);
set getvariableofnpc(.npcgid[getnpcid(0)], "stand_system"), .@id;
end;
}
- script stand_system2 -1,{
end;
OnInit:
sleep 1;
OnTimer30000:
.@query$ = "SELECT `char`.`char_id`, `char`.`name`, `char`.`guild_id`, `char`.`class`, `char`.`sex`, `char`.`hair`, `char`.`hair_color`, `char`.`clothes_color`, `char`.`body`, `char`.`head_top`, `char`.`head_mid`, `char`.`head_bottom`, `char`.`robe`, "
+ "`pvp_for_show_c2`.`points` "
+ "FROM `char` RIGHT JOIN `pvp_for_show_c2` ON `char`.`char_id` = `pvp_for_show_c2`.`char_id` ORDER BY `points` DESC LIMIT 3";
.@nb = query_sql(.@query$, .@cid, .@name$, .@guild_id, .@class, .@sex$, .@hair, .@hair_color, .@clothes_color, .@body, .@head_top, .@head_mid, .@head_bottom, .@robe, .@points);
for (set .@i,0; .@i < .@nb; set .@i,.@i+1) {
setunitdata .statue[.@i +1], UNPC_CLASS, .@class[.@i];
setunitdata .statue[.@i +1], UNPC_SEX, (.@sex$[.@i] == "F")? SEX_FEMALE:SEX_MALE;
setunitdata .statue[.@i +1], UNPC_HAIRSTYLE, .@hair[.@i];
setunitdata .statue[.@i +1], UNPC_HAIRCOLOR, .@hair_color[.@i];
setunitdata .statue[.@i +1], UNPC_CLOTHCOLOR, .@clothes_color[.@i];
setunitdata .statue[.@i +1], UNPC_BODY2, .@body[.@i];
setunitdata .statue[.@i +1], UNPC_HEADTOP, .@head_top[.@i];
setunitdata .statue[.@i +1], UNPC_HEADMIDDLE, .@head_mid[.@i];
setunitdata .statue[.@i +1], UNPC_HEADBOTTOM, .@head_bottom[.@i];
setunitdata .statue[.@i +1], UNPC_ROBE, .@robe[.@i];
setnpcdisplay "pvp_ladder_statue2#"+(.@i +1), .@name$[.@i];
.statue_name$[.@i +1] = .@name$[.@i];
.statue_guild$[.@i +1] = getguildname(.@guild_id[.@i]);
.statue_points[.@i +1] = .@points[.@i];
}
for (set .@i,.@nb; .@i < .showstatue; set .@i,.@i+1)
setunitdata .statue[.@i +1], UNPC_CLASS, HIDDEN_WARP_NPC;
initnpctimer;
end;
}
- script pvp_ladder_statue2 FAKE_NPC,{
.@id = getelementofarray(getvariableofnpc(.npcgid, "stand_system2"), getnpcid(0));
mes "^996600[ Class 2 TOP "+ .@id +" ]";
mes "^006699ชื่อ : "+ getelementofarray(getvariableofnpc(.statue_name$, "stand_system2"), .@id);
.@guildname$ = getelementofarray(getvariableofnpc(.statue_guild$, "stand_system2"), .@id);
mes "^00AAAAกิลด์ : "+((.@guildname$ == "null")? "^AAAAAANone": .@guildname$);
mes "^00AA00แต้ม : ["+ getelementofarray(getvariableofnpc(.statue_points, "stand_system2"), .@id) +"]";
close;
OnInit:
.@id = strnpcinfo(2);
set getvariableofnpc(.statue[.@id], "stand_system2"), getnpcid(0);
set getvariableofnpc(.npcgid[getnpcid(0)], "stand_system2"), .@id;
end;
}
////////////////////////////////////////////////////////////////////////// RANKING CLASS1 //////////////////////////////////////////////////////
morocc,152,156,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#1 1_F_MARIA
morocc,152,156,4 script Ranking Number#1 844,{
end;
OnInit:
waitingroom " [Class:1] No.1",0;
end;
}
morocc,155,156,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#2 1_F_MARIA
morocc,155,156,4 script Ranking Number#2 844,{
end;
OnInit:
waitingroom " [Class:1] No.2",0;
end;
}
morocc,158,156,4 duplicate(pvp_ladder_statue) pvp_ladder_statue#3 1_F_MARIA
morocc,158,156,4 script Ranking Number#3 844,{
end;
OnInit:
waitingroom " [Class:1] No.3",0;
end;
}
////////////////////////////////////////////////////////////////////////// RANKING CLASS2 //////////////////////////////////////////////////////
morocc,161,156,4 duplicate(pvp_ladder_statue2) pvp_ladder_statue2#1 1_F_MARIA
morocc,161,156,4 script Ranking Number#4 844,{
end;
OnInit:
waitingroom " [Class:2] No.1",0;
end;
}
morocc,164,156,4 duplicate(pvp_ladder_statue2) pvp_ladder_statue2#2 1_F_MARIA
morocc,164,156,4 script Ranking Number#5 844,{
end;
OnInit:
waitingroom " [Class:2] No.2",0;
end;
}
morocc,167,156,4 duplicate(pvp_ladder_statue2) pvp_ladder_statue2#3 1_F_MARIA
morocc,167,156,4 script Ranking Number#6 844,{
end;
OnInit:
waitingroom " [Class:2] No.3",0;
end;
}