This probably belongs into Third Party Support, I've read the read note too late, sorry. :/
So for now I have this:
query_sql "SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='PvPKDA1' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 50", .@char_idpvp, .@namepvp$, .@countpvp;
To get my PvP Ladder sorted by PvPKDA1, now every player also has an entry called PvPKills.
And I want to get the Top 50 ordered by PvPKDA1, but only those who have over 50 Kills.
So something like
WHERE global_reg_value.str='PvPKDA1' and PvPKills > 50
I guess it's something like:
WHERE global_reg_value.str='PvPKDA1' and (SELECT global_reg_value.`value` FROM global_reg_value WHERE global_reg_value.str='PvPKills') > 50
But I somehow need to add that it should just select the one I am referring at the moment.. D:
Question
Yuka
This probably belongs into Third Party Support, I've read the read note too late, sorry. :/
So for now I have this:
To get my PvP Ladder sorted by PvPKDA1, now every player also has an entry called PvPKills.
And I want to get the Top 50 ordered by PvPKDA1, but only those who have over 50 Kills.
So something like
I guess it's something like:
But I somehow need to add that it should just select the one I am referring at the moment.. D:
Edited by GreyfordLink to comment
Share on other sites
9 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.