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;
}
Question
stiflerxx
Please use CODEBOX.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.