Masters, I want to add the player's guild after the player's name in the ranking.
I have two classifications in different scripts. But both show only Position | Player | Points
I would like this. example: Position| Player | Guild| Points
I have no idea what code should be added to 'query_sql' or how to set it in the script.
Please, if anyone can help me with this I would be very grateful.
Ranking Empbreaker:
mes "Top 10 Emperium Breaker";if(!(.@nb= query_sql("SELECT `char_id`, `count` FROM `breaker_ladder` ORDER BY `count` DESC LIMIT 10",.@cid,.@count))){
mes "No data found.";
close;}for(.@i=0;.@i<.@nb;.@i++){
query_sql("SELECT `name` FROM `char` WHERE `char_id` = '"+.@cid[.@i]+"'",.@name$);
mes (.@i+1)+". "+.@name$+" ~ "+.@count[.@i]+" breaks.";}
close;
and
Ranking WoT:
mes "Position | Player | Points";
query_sql "SELECT `name`, `baus` FROM `char` WHERE '"+getcharid(0)+"' AND `baus` > '0' ORDER BY `baus` DESC LIMIT 10",.@nome$,.@baus;for(set.@i,0;.@i< getarraysize(.@nome$);set.@i,.@i+1)
mes (.@i+1)+"º^000000 | ^228B22"+.@nome$[.@i]+"^000000 | ^00B2EE"+.@baus[.@i]+"^000000";break;}
close;
Question
driver
Masters, I want to add the player's guild after the player's name in the ranking.
I have two classifications in different scripts. But both show only Position | Player | Points
I would like this. example: Position| Player | Guild | Points
I have no idea what code should be added to 'query_sql' or how to set it in the script.
Please, if anyone can help me with this I would be very grateful.
Ranking Empbreaker:
and
Ranking WoT:
Thank you very much.
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.