OFFSET

[Faeroth]

Hello,

 

SQL_RESET(1, "@count"); // Array reset.

query_sql "SELECT count(`nameid`) FROM `inventory` WHERE `char_id` = '" + @char_id[@c]+ "'", @count; // Getting the amount of datasets. Works!

set @current, 0; // OFFSET count reset.

while(@current <= @count[0]) { // As long as there are datasets remaining.

SQL_RESET(2, "@nameid", "@amount"); // Array reset.

query_sql "SELECT `nameid` , `amount` FROM `inventory` WHERE `char_id` = '" + @char_id[@c] + "' LIMIT '" + @current + "' OFFSET 127", @nameid, @amount; // Does not work!

set @current, @current + 127; // Next time start 127 onward.

for( set @i, 0; @i < getarraysize(@nameid); set @i, @i + 1 )

	mes @nameid[@i] + " -> " + @amount[@i]; // Return the datasets. Does not work!

next; // Ignore this.

}

 

That's the idea:

In this script language, there is a limit of 127 indexes for the arrays.

Therefore I wanted to let MYSQL get only 127 datasets and the next time the following 127.

The first MYSQL-Query works fine, but the second with the OFFSET does not.

I guess I did not understand OFFSET correctly...

 

Thanks in advance!