I'm doing a ranking for BG and it is working, however, on the SQL table "char_bg" it is just showing char_id not "name" of the character, however, I want it to show the name of the character from another table based on the char_id of the table char_bg.
Can you guys help me?
set .@size, query_sql( "select char_id, rank_points, division from char_bg where rank_points > 0 order by rank_points desc limit "+ .top, .@name$, .@points, .@levelname$ );
for (set .@c, 0; .@c < .@size; set .@c, .@c + 1)
dispbottom "[ #" +(.@c + 1) +" ] : " + .@name$[.@c] +" : " + .@levelname$[.@c] +" : [ " + .@points[.@c] +" ]", 0xe60000;
Question
Strand
Hello community,
I'm doing a ranking for BG and it is working, however, on the SQL table "char_bg" it is just showing char_id not "name" of the character, however, I want it to show the name of the character from another table based on the char_id of the table char_bg.
Can you guys help me?
set .@size, query_sql( "select char_id, rank_points, division from char_bg where rank_points > 0 order by rank_points desc limit "+ .top, .@name$, .@points, .@levelname$ ); for (set .@c, 0; .@c < .@size; set .@c, .@c + 1) dispbottom "[ #" +(.@c + 1) +" ] : " + .@name$[.@c] +" : " + .@levelname$[.@c] +" : [ " + .@points[.@c] +" ]", 0xe60000;
Link to comment
Share on other sites
16 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.