Hi, All how to solved script atcommand when nickname have space ex : "A B C"
Example Script atcommand
- script DonationUpdate -1,{
OnInit:
start:
initnpctimer;
end;
OnTimer5000:
set $@nb2,query_sql("SELECT COUNT(*) FROM test_donation WHERE status=0",$@count);
if($@count != 0) {
set $@nb,query_sql("SELECT id, account_id,donate,status FROM test_donation WHERE status='0'",$@id,$@account_id,$@donate,$@status);
for (.@i = 0; .@i < $@nb; .@i++) {
if (isloggedin($@account_id[.@i])) { // check if player online
atcommand "#cash "+rid2name($@account_id[.@i])+" "+$@donate[.@i];
query_sql("UPDATE test_donation SET status='1' WHERE id='"+$@id[.@i]+"' AND account_id='"+$@account_id[.@i]+"'");
}
}
} else
finish:
stopnpctimer;
goto start;
}
this script only work when nickname player doesn't have space
any idea to solved this issue?