[Debug] Command SQL return notice in map-server

[Hyroshima]

Hello again! xD

I'm having a problem when using the SQL SHOW command.

I created two columns in the login table and using the command below displays the following error:

query_sql "SHOW COLUMNS FROM `login` LIKE 'magic_shop%'",.@rtn$; return getarraysize(.@rtn$);

ERRO:

 

Thank you very much xD 

 

[Emistry]

it return more than 1 field.

 

you need to provide the array to store other fields that returned from the query.

query_sql("SHOW COLUMNS FROM `login` LIKE 'magic_shop%'", .@field$, .@type$, .@null$, .@key$, .@default$, .@extra$); 
return getarraysize(.@field$);

 

[Hyroshima]

3 hours ago, Emistry said:

it return more than 1 field.

 

you need to provide the array to store other fields that returned from the query.

query_sql("SHOW COLUMNS FROM `login` LIKE 'magic_shop%'", .@field$, .@type$, .@null$, .@key$, .@default$, .@extra$); 
return getarraysize(.@field$);

 

Thanks again Emistry, I did not know I needed to specify the other column outputs.