Erro to update.... script npc

[stiflerxx]

not getting to see where I went wrong ... the emulator is giving these two error:
 
erro 1:

: Erro de banco de dados - Out of range value for column 'timer' at row 1

[Depurar]: em c:\users\usuario\desktop\trabalhos ragnarok\ragna-field\emulador\s
rc\map\script.c:15905 - UPDATE `houses` SET `timer`=`timer`-'1'
erro 2:
[Depurar]: Source (NPC): #controller_house (invisible/not on a map)
 
script:
 

- script #controller_house -1,{

OnInit:
bindatcmd "house", strnpcinfo(0)+"::OnHouseInfo";
initnpctimer;
end;
 
OnTimer60000:
query_sql "UPDATE `houses` SET `timer`=`timer`-'1'";
query_sql "SELECT `auto_id`, `name`, `mapname` FROM `houses` WHERE `timer`<='0' AND `status`='1'", .@auto_id, .@name$, .@mapname$;
for( set .@i, 0; .@i < getarraysize(.@auto_id); set .@i, .@i + 1 )
{
query_sql "UPDATE `houses` SET `status`='0', `master_id`='0', `timer`='0', `invitation`='0' WHERE `auto_id`='" + .@auto_id[.@i] + "'";
query_sql "DELETE FROM `houses_members` WHERE `house_id`='" + .@auto_id[.@i] + "'";
 
announce "A " + .@name$[.@i] + " foi desoculpada.",bc_all,"0x00FF00";
mapwarp .@mapname$[.@i], "prontera", 156, 191;
}
setnpctimer 0;
end;
}

thank you = D
 

 

[Monsieur Panda]

Did you read the error ? Erro de banco de dados - Out of range value for column 'timer' at row 1 

I guess in your database, timer is INT, so that is why you got error. Change it to varchar and you will not get this error again.

 

[stiflerxx]

Did you read the error ? Erro de banco de dados - Out of range value for column 'timer' at row 1 

I guess in your database, timer is INT, so that is why you got error. Change it to varchar and you will not get this error again.

 perfect

thank you =D