query_sql change 128rows to more

[mleo1]

http://rathena.org/wiki/Query_sql

this only returns 128. How to change array size? I want to have 500rows or more

tried

set .@nb, query_sql("SELECT name, fame FROM `char` ORDER BY fame DESC", .@name$, .@fame);
mes "Hall Of Fame";
for(set .@i,1; .@i <= .@nb; set .@i,.@i+1)
mes .@i+". "+.@name$[.@i-1]+" ("+.@fame[.@i-1]+")";

Sorry for the bad english.

Edited October 24, 2012 by mleo1

[Emistry]

trunk/src/map/script.c

/// Maximum amount of elements in script arrays
#define SCRIPT_MAX_ARRAYSIZE 128

you can try increase the size, but i dunno how far it can extend..

[mleo1]

I got what I want, I just needed to see all the rows. But thanks for the support again Emistry xD.

just sharing

mes "Test";
set .@start, 0;
while(1){		
	set .@nb, query_sql("SELECT `name` FROM `char` ORDER BY `char_id` LIMIT " +.@start+ ",128", .@name$);
	if(.@nb==0)
		break;

	mes (.@start+1) +" to "+ (.@start+128);
	for(set .@i,1; .@i <= .@nb; set .@i,.@i+1)
		mes (.@i+.@start) +". "+ .@name$[.@i-1];

	deletearray .@name$, getarraysize(.@name$);
	set .@start, .@start+128;
	next;
}
close;

[AnnieRuru]

the answer is OFFSET

select * from mob_db limit 10 OFFSET 5;

but yeah ... putting a limit 5,5 also works, like you did

select * from mob_db limit 5,10;