How to include offline members on rewards for Euphy's WoE Controller

[GodKnows Jhomz]

Is there any way to include offline members of the winning guild when I set the rewards send thru mail?
I tried to comment out the " && isloggedin(.@aid[.@j],.@cid[.@j]) " in the line but it didn't work.
Hopefully someone can provide me a solution or an idea how to make it work.
Thanks in advance.

[Aureon]

@GodKnows Jhomz Hello, Im not 100% sure about this so please test this first on your local server.

First,
from your script, kindly look for this line:

set .@sql$, ((.Options&4)?"position = 0":"online = 1");

and replace it with this:

set .@sql$,"position = 0";

 

Second,
from your script, kindly look again for this line:

set .@size, query_sql("SELECT account_id,char_id FROM `guild_member` WHERE guild_id = '"+.@gid+"' AND "+.@sql$,.@aid,.@cid);

and replace it with this:

if (.Options&4){ set .@size, query_sql("SELECT account_id,char_id FROM `guild_member` WHERE guild_id = '"+.@gid+"' AND "+.@sql$,.@aid,.@cid); }
else { set .@size, query_sql("SELECT account_id,char_id FROM `guild_member` WHERE guild_id = "+.@gid,.@aid,.@cid); }

 

[GodKnows Jhomz]

18 minutes ago, Aureon said:

@GodKnows Jhomz Hello, Im not 100% sure about this so please test this first on your local server.

First,
from your script, kindly look for this line:

set .@sql$, ((.Options&4)?"position = 0":"online = 1");

and replace it with this:

set .@sql$,"position = 0";

 

Second,
from your script, kindly look again for this line:

set .@size, query_sql("SELECT account_id,char_id FROM `guild_member` WHERE guild_id = '"+.@gid+"' AND "+.@sql$,.@aid,.@cid);

and replace it with this:

if (.Options&4){ set .@size, query_sql("SELECT account_id,char_id FROM `guild_member` WHERE guild_id = '"+.@gid+"' AND "+.@sql$,.@aid,.@cid); }
else { set .@size, query_sql("SELECT account_id,char_id FROM `guild_member` WHERE guild_id = "+.@gid,.@aid,.@cid); }

 

Thanks. It works. But I need to adjust my modification on the reward area to make it work.