Request script pls!

[Vince Jimenez]

i have an script lucky pick event every 10mins random players online..

 

but my problem even my vendor win


can someone help me how to ignore all vendors ? here is my script?

 

-	script	AutoFunEvent	-1,{
OnMinute00:
OnMinute10:
OnMinute20:
OnMinute30:
OnMinute40:
OnMinute50:
	query_sql "select account_id from `char` where online = 1 order by rand() limit 1", .@aid;
	attachrid .@aid;
	announce strcharinfo(0) +" won on lucky pick event", 0;
	getitem 12248,3;
	getitem 20619,1;
	end;
}

thanks in advance

 

 

 

[Capuche]

what about

select account_id from `char` where online = 1 and account_id not in ( select account_id from vendings ) order by rand() limit 1

to exclude vendor?

[Stolao]

                if(CheckVending() ){

                    DetachRID();

                }

[Vince Jimenez]

what about

select account_id from `char` where online = 1 and account_id not in ( select account_id from vendings ) order by rand() limit 1

to exclude vendor?

Working Thanks!

[cutekram]

share please:)