LearningRO Posted July 2, 2017 Group: Members Topic Count: 107 Topics Per Day: 0.02 Content Count: 778 Reputation: 73 Joined: 02/10/12 Last Seen: Saturday at 11:40 PM Share Posted July 2, 2017 [Warning]: script:query_sql: Only 128/288 rows have been stored i got warning on my console this is my script set .@nb, query_sql("select name, kills, deaths from pvpladder order by kills desc limit 10"+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@kills, .@deaths); if ( .@nb == 0 ) { mes "["+ .@npcname$ +"]"; mes "The ladder currently is empty."; next; } for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) { mes "["+ .@npcname$ +"]"; for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) { mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AA00["+ .@kills[.@i] +"] ^FF0000<"+ .@deaths[.@i] +">^000000"; } close; } how to fix this Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted July 3, 2017 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2373 Joined: 10/28/11 Last Seen: Saturday at 09:29 AM Share Posted July 3, 2017 set .@nb, query_sql("select name, kills, deaths from pvpladder order by kills desc limit 10"+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@kills, .@deaths); Change to set .@nb, query_sql("select name, kills, deaths from pvpladder order by kills desc limit "+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@kills, .@deaths); Quote Link to comment Share on other sites More sharing options...
0 LearningRO Posted July 6, 2017 Group: Members Topic Count: 107 Topics Per Day: 0.02 Content Count: 778 Reputation: 73 Joined: 02/10/12 Last Seen: Saturday at 11:40 PM Author Share Posted July 6, 2017 okay i will testing thx b4 Quote Link to comment Share on other sites More sharing options...
Question
LearningRO
[Warning]: script:query_sql: Only 128/288 rows have been stored
i got warning on my console
this is my script
set .@nb, query_sql("select name, kills, deaths from pvpladder order by kills desc limit 10"+ getvariableofnpc(.showtotal,"DOTAPVP"), .@name$, .@kills, .@deaths); if ( .@nb == 0 ) { mes "["+ .@npcname$ +"]"; mes "The ladder currently is empty."; next; } for ( set .@j,0; .@j < .@nb; set .@j, .@j + getvariableofnpc(.showpage,"DOTAPVP") ) { mes "["+ .@npcname$ +"]"; for ( set .@i, .@j; .@i < (getvariableofnpc(.showpage,"DOTAPVP") + .@j) && .@i < .@nb; set .@i, .@i + 1 ) { mes "^996600"+ (.@i+1) +": ^006699"+ .@name$[.@i] +" ^00AA00["+ .@kills[.@i] +"] ^FF0000<"+ .@deaths[.@i] +">^000000"; } close; }
how to fix this
Link to comment
Share on other sites
2 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.