not getting to see where I went wrong ... the emulator is giving these two error:
erro 1:
[SQL]: 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