The prize is not given to players.

[madtoyz]

The prize is not given to players.

- script AutoFunEvent -1,{
OnClock0100:
OnClock0300:
OnClock0500:
OnClock0700:
OnClock0900:
OnClock1100:
OnClock1300:
OnClock1500:
OnClock1700:
OnClock1900:
OnClock2100:
OnClock2300:
while(1)
{
 query_sql "select account_id from `char` where online = 1 order by rand() limit 1", .@aid;
 attachrid .@aid;
 if(CheckVending())
 {
  DetachRID();
  continue;
 }
 announce strcharinfo(0) +" won in Lucky Pick Event.", 0;
 set $@ran2, rand(1,8);
if ($@ran2 == 8) set @prize,4399;
if ($@ran2 == 7) set @prize,579;//Fresh Fish
if ($@ran2 == 6) set @prize,13710;
if ($@ran2 == 5) set @prize,674;
if ($@ran2 == 4) set @prize,969;
if ($@ran2 == 3) set @prize,671;
if ($@ran2 == 2) set @prize,14524;
if ($@ran2 == 1) set @prize,7773;
set $@ran3, rand(1,3);
if ($@ran3 == 3) set @amount,50;
if ($@ran3 == 2) set @amount,10;
if ($@ran3 == 1) set @amount,100;
 break;
}
end;
}

[michaelsoftman]

query_sql "select 'account_id' from `char` where online = 1 ORDER BY rand() LIMIT 1", .@aid;

Also, I'm not sure if you can do where online = 1? Unless you've edited your SQL database as such.

If you want, I have a non SQL script that can give everyone a prize, and you can limit it to a map if you'd like.

Edited October 23, 2012 by michaelsoftman

[madtoyz]

query_sql "select 'account_id' from `char` where online = 1 ORDER BY rand() LIMIT 1", .@aid;

Also, I'm not sure if you can do where online = 1? Unless you've edited your SQL database as such.

If you want, I have a non SQL script that can give everyone a prize, and you can limit it to a map if you'd like.

can support this script ?

because i take it from here : http://rathena.org/board/topic/53877-lucky-pick-event/

[michaelsoftman]

Actually, I just realized the problem.

Add this to your script, before the last break;

getitem @prize,@amount;

So like this.

set $@ran2, rand(1,8);
if ($@ran2 == 8) set @prize,4399;
if ($@ran2 == 7) set @prize,579;//Fresh Fish
if ($@ran2 == 6) set @prize,13710;
if ($@ran2 == 5) set @prize,674;
if ($@ran2 == 4) set @prize,969;
if ($@ran2 == 3) set @prize,671;
if ($@ran2 == 2) set @prize,14524;
if ($@ran2 == 1) set @prize,7773;
set $@ran3, rand(1,3);
if ($@ran3 == 3) set @amount,50;
if ($@ran3 == 2) set @amount,10;
if ($@ran3 == 1) set @amount,100;
getitem @prize, @amount;
 break;
}
end;
}

[madtoyz]

getitem @prize,@amount;

its will detect random right ?

[michaelsoftman]

Yep, it'll work properly with random prizes.

[madtoyz]

Yep, it'll work properly with random prizes.

thanks allot...

[AnnieRuru]

http://www.eathena.ws/board/index.php?showtopic=275732

lol ... my script is really everywhere

rand(<some number>) will always return a fixed table order, unlike rand() return randomize order

@madtoyz

better use the script on post#13

the solution provide by Kenpachi doesn't work

well ... kenpachi always gave wrong info ...

I'm more surprised that topic has 3 pages and yet nobody said anything about it being bug x.x

---

- script AutoFunEvent -1,{
OnStartLuck:
do
{
query_sql "select account_id from `char` where online = 1 order by rand() limit 1", .@aid;
attachrid .@aid;
if (CheckVending()) detachrid;
}
while (CheckVending())
announce strcharinfo(0) +" won in Lucky Pick Event.", 0;
getitem 671,1;
end;
}

hmm ... reloop the query_sql is a big no-no ...

[Boy]

Hi Annie Ruru

i already test this script but got this error " [Warning]: npc_scriptcont: failed npc_checknear test."

- script AutoFunEvent -1,{
OnWhisperGlobal:
OnClock2030:
set .@rand, rand(2000000000);
while ( getusers(1) > .@count ) {
 set .@nb, query_sql("select account_id from `char` where online = 1 order by rand("+ .@rand +") limit 128 offset "+ .@count, .@aid );
 set .@i, 0;
 while ( .@i < .@nb ) {
  if ( attachrid(.@aid[.@i]) ) {
if ( getgmlevel() < 60 && !checkvending() ) { // false condition
 announce strcharinfo(0) +" won", 0;
 getitem 501,1;
 end;
}
  }
  set .@i, .@i +1 ;
 }
 set .@count, .@count + 128;
 sleep ( getusers(1) > .@count );
}
end;
}

Edited October 25, 2012 by Boy

[AnnieRuru]

how the **** can you get npc_checknear error from a floating npc ????

unless you are using some other emulator like eamod or other eathena ?

[Boy]

Problem Solved.

Thanks Annie Rura.