//Author : Goddameit
//Version : 2011/12/16 - 01:04
function script AllGuildMemberEvent {
if(!set(.@gid,getcastledata(getarg(0),1)))
return;
query_sql("select account_id, char_id from `guild_member` where guild_id = '"+.@gid+"'", .@gmaid, .@gmcid);
for(set .@i,0;.@i<getarraysize(.@gmcid);set .@i,.@i+1)
{
if(isloggedin(.@gmaid[.@i]))
message rid2name(.@gmaid[.@i]),getarg(9);
if(!isloggedin(.@gmaid[.@i])&&!getarg(1))
continue;
query_sql "insert into mail ( send_name, dest_id, title, message, nameid, amount, identify, zeny, time ) values ( '"+escape_sql(getarg(2))+"',"+.@gmcid[.@i]+", '"+escape_sql(getarg(3))+"', '"+escape_sql(getarg(4))+"', "+getarg(5)+", "+getarg(6)+", "+getarg(7)+", "+getarg(8)+", unix_timestamp( now() ) )";
}
return;
}
- script AGME -1,{
OnAGME:
setarray .@maps$[0],"aldeg_cas01","aldeg_cas02","aldeg_cas03","aldeg_cas04","aldeg_cas05";
setarray .@maps$[5],"gefg_cas01","gefg_cas02","gefg_cas03","gefg_cas04","gefg_cas05";
setarray .@maps$[10],"payg_cas01","payg_cas02","payg_cas03","payg_cas04","payg_cas05";
setarray .@maps$[15],"prtg_cas01","prtg_cas02","prtg_cas03","prtg_cas04","prtg_cas05";
for( set .@i,0; .@i <= 19; set .@i, .@i+1)
{
callfunc "AllGuildMemberEvent",.@maps$[.@i],1,
"System","WoE Victory Reward","Congratulations! Your guild succeeded in occupying "+ getcastlename(.@maps$[.@i]) +". This is your rewards.",
501,1,1,0,
"[You got a mail!! Please relogin to reupdate your mail list.]";
}
end;
}
Script from goddameit i found on eathena. Might help you.