OnTimer30000: // refresh every 30 seconds. Note the `char` table is unrealiable, player still need to perform certain task to save the character -> see 'save_settings' in conf\map-server.conf
.@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`, "
+ "`pvpladder`.`kills`, `pvpladder`.`streaks`, `pvpladder`.`deaths` "
+ "FROM `char` RIGHT JOIN `pvpladder` ON `char`.`char_id` = `pvpladder`.`char_id` ORDER BY `kills` DESC LIMIT "+ .showstatue;
.@nb = query_sql(.@query$, .@cid, .@name$, .@guild_id, .@class, .@sex$, .@hair, .@hair_color, .@clothes_color, .@body, .@head_top, .@head_mid, .@head_bottom, .@robe, .@kills, .@streaks, .@deaths);
if (.fix_custom_sprite) {
for (.@i = 0; .@i < .@nb; ++.@i) {
setunitdata .statue[.@i +1], UNPC_HEADTOP, 0;
setunitdata .statue[.@i +1], UNPC_HEADMIDDLE, 0;
setunitdata .statue[.@i +1], UNPC_HEADBOTTOM, 0;
setunitdata .statue[.@i +1], UNPC_ROBE, 0;
}
}
for (.@i = 0; .@i < .@nb; ++.@i) {
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_kills[.@i +1] = .@kills[.@i];
.statue_streaks[.@i +1] = .@streaks[.@i];
.statue_deaths[.@i +1] = .@deaths[.@i];
}
for (.@i = .@nb; .@i < .showstatue; ++.@i)
setunitdata .statue[.@i +1], UNPC_CLASS, HIDDEN_WARP_NPC;
initnpctimer;
end;
.fix_custom_sprite = true;
Do you know why it doesn't work? i am using rathena dota 3.6
