query_sql ("SELECT DISTINCT `last_map` FROM `ragnarok`.`char` WHERE `online` = '1'",.@maps$);
i got confuse on this part why i got,
DB:Error how to fix this? Thanks in Advance.
- script News -1,{
OnInit:
set .Time,30; // Announce every x Seconds.
setarray .News$[0], // Random Message to be Announced
"Message 1",
"Message 2",
"Message 3";
while(1)
{
query_sql ("SELECT DISTINCT `last_map` FROM `ragnarok`.`char` WHERE `online` = '1'",.@maps$);
for (.@i = 0 ; .@i < getarraysize(.@maps$) ; .@i++) soundeffectall "voice_man5.wav",0,.@maps$[.@i];
announce .News$[ rand( getarraysize( .News$ ) ) ],bc_all,0xffb9f3;
sleep ( .Time * 1000 );
}
end;
}