Ladder Problem

[LatSo]

Hi I have a problem here

 

brasilis,232,322,5    script    Class S na Halimaw    897,{
    
    query_sql "SELECT `char`.`name`,CAST(`value` AS UNSIGNED) " + 
                  "FROM global_reg_value " + 
                  "LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id " +
               "WHERE global_reg_value.`str`='class_s' " + 
                  "ORDER BY CAST(`value` AS UNSIGNED) DESC LIMIT 20",.@aid$,.@var;
                    mes "[Class-S na Halimaw]";
                for (set .@i,0; .@i<8; set .@i,.@i+1) {
                    mes (.@i+1) +". ^0000FF"+ .@aid$[.@i]           +"^000000 ["+ .@var[.@i] +"]";
                    close;
                }
                end;
        }

The ladder is just showing 1 player, it should show at least 8 but I dont how to do it. I tried but fail

 

please help.

Edited July 9, 2013 by LatSo

[Capuche]

                for (set .@i,0; .@i<8; set .@i,.@i+1) {
                    mes (.@i+1) +". ^0000FF"+ .@aid$[.@i]           +"^000000 ["+ .@var[.@i] +"]";
-                   close;
                }
+               close;

your script close the window and put an end on for loop after one iteration

[Capuche]

it should show at least 8 but I dont how to do it.

you have more than 8 players with a value? I don't see anything wrong in this script

[LatSo]

It only show 1 player on the ladder instead of showing only the top 8

 

it should show at least 8 but I dont how to do it.

you have more than 8 players with a value? I don't see anything wrong in this script

any1 help?

[LatSo]

about that, already fixed that the other day sorry if i did not update the status of this.

 

anyways thanks

Sir capuche

 

how to do this script, Before you can warp into map x, you need to be included in the ladder?

[Capuche]

query_sql "SELECT `char`.`name`,CAST(`value` AS UNSIGNED) " +

"FROM global_reg_value " +

"LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id " +

"WHERE global_reg_value.`str`='class_s' " +

"ORDER BY CAST(`value` AS UNSIGNED) DESC LIMIT 20",.@aid$,.@var;

.@name$ = strcharinfo(0);

for (set .@i,0; .@i<8; set .@i,.@i+1)

if ( .@aid$[.@i] == .@name$ ) break;// is in the top 8 ladder

if ( .@i == 8 ) {

mes "you need to be include in the ladder";

close;

}

warp "prontera",0,0;

[LatSo]

So that code will warp a player to prontera?

 

I tried but it did not work

[Capuche]

So that code will warp a player to prontera?

-     .@name$ = strcharinfo(0);
+     set .@name$, strcharinfo(0);

it will warp a top 8 in prontera

change this if you don't use rathena