brunoshp Posted June 12, 2013 Group: Members Topic Count: 64 Topics Per Day: 0.02 Content Count: 180 Reputation: 7 Joined: 12/19/12 Last Seen: December 6, 2023 Share Posted June 12, 2013 i need to add Ranking wot in this raking pvp. mes "Ok, this is Ranking WoT[TOP 10]"; next; query_sql "SELECT name, wotrank FROM char ORDER BY char DESC LIMIT 10",@name$,@charwot; dispbottom "Ranking WOT [TOP 10]"; dispbottom " "; dispbottom "Player < x > Position"; dispbottom " "; for(set @i,0;@i<=9;set @i,@i+1) { dispbottom "["+(@i+1)+"] < x > "+@name$[@i]+" < x > "+@charwot[@i]+""; } close; my table in database : ALTER TABLE `char` ADD `wotrank` INT NOT NULL ; this not ok, help me to fix!! pls! Quote Link to comment Share on other sites More sharing options...
Capuche Posted June 12, 2013 Group: Developer Topic Count: 10 Topics Per Day: 0.00 Content Count: 2407 Reputation: 613 Joined: 07/05/12 Last Seen: April 15 Share Posted June 12, 2013 Don't forget ` in the query, sometimes that make an issue mes "Ok, this is Ranking WoT[TOP 10]"; next; query_sql "SELECT `name`, `wotrank` FROM `char` where `wotrank` != 0 ORDER BY `wotrank` DESC LIMIT 10", .@name$, .@charwot; if ( .@charwot == 0 ) { dispbottom "The ranking is empty."; close; } dispbottom "Ranking WOT [TOP 10]"; dispbottom " "; dispbottom "Player < x > Position"; dispbottom " "; for(set .@i,0; .@i<=9; set .@i, .@i+1 ) { dispbottom "["+(.@i+1)+"] < x > "+ .@name$[.@i] +" < x > "+ @charwot[.@i] +""; } close; 1 Quote Link to comment Share on other sites More sharing options...
brunoshp Posted June 12, 2013 Group: Members Topic Count: 64 Topics Per Day: 0.02 Content Count: 180 Reputation: 7 Joined: 12/19/12 Last Seen: December 6, 2023 Author Share Posted June 12, 2013 (edited) if i need to reset ranking, how i do? Edited June 12, 2013 by brunoshp Quote Link to comment Share on other sites More sharing options...
Capuche Posted June 12, 2013 Group: Developer Topic Count: 10 Topics Per Day: 0.00 Content Count: 2407 Reputation: 613 Joined: 07/05/12 Last Seen: April 15 Share Posted June 12, 2013 if i need to reset ranking, how i do? update `char` set `wotrank` = 0 1 Quote Link to comment Share on other sites More sharing options...
brunoshp Posted June 12, 2013 Group: Members Topic Count: 64 Topics Per Day: 0.02 Content Count: 180 Reputation: 7 Joined: 12/19/12 Last Seen: December 6, 2023 Author Share Posted June 12, 2013 (edited) Thx for all! Edited June 12, 2013 by brunoshp Quote Link to comment Share on other sites More sharing options...
Question
brunoshp
i need to add Ranking wot in this raking pvp.
mes "Ok, this is Ranking WoT[TOP 10]"; next; query_sql "SELECT name, wotrank FROM char ORDER BY char DESC LIMIT 10",@name$,@charwot; dispbottom "Ranking WOT [TOP 10]"; dispbottom " "; dispbottom "Player < x > Position"; dispbottom " "; for(set @i,0;@i<=9;set @i,@i+1) { dispbottom "["+(@i+1)+"] < x > "+@name$[@i]+" < x > "+@charwot[@i]+""; } close;my table in database :
this not ok, help me to fix!! pls!
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.