- script allwoecashrewards -1,{
OnAgitEnd:
setarray .@castle_map$, "prtg_cas01", "prtg_cas02", "prtg_cas03", "prtg_cas04", "prtg_cas05","aldeg_cas05", "payg_cas04", "gefg_cas02", "aldeg_cas02";// your castle map
.@size = getarraysize( .@castle_map$ );
while( .@j < .@size ) {
.@guild_id = getcastledata( .@castle_map$[.@j],1 );
if ( .@guild_id ) {
.@count = query_sql( "select account_id from guild_member where guild_id = "+ .@guild_id +" and online = 1", .@account_id );
for ( .@i = 0; .@i < .@count; .@i++ ) {
if ( attachrid .@account_id[.@i] ) #CASHPOINTS += 30;
}
query_sql "INSERT INTO `global_reg_value` (`char_id`, `str`, `value`, `type`, `account_id`) select '0', '#CASHPOINTS', '30', '2', `guild_member`.`account_id` from `guild_member` where guild_id = "+ .@guild_id +" and online = 0 on duplicate key update `value` = `value` +30";
}
.@j++;
}
end;
}
there was an error with insert into too
Also this script give a reward for each member in the guild regardless their account/ip... I should rewrite it