Mahiro

there are four variables that have not been set
 

Well I tried like that but it failed.
I've been giving a search to try via SQL and it worked out fine:
 
query_sql "SELECT `guild_id` FROM `rwoe` ORDER BY `kd` DESC LIMIT 3",.@guild_id; for(.@i=0; .@i<getarraysize(.@guild_id); .@i++){ query_sql "UPDATE rwoe SET ord = "+(.@i+1)+" WHERE guild_id="+.@guild_id[.@i]+""; } query_sql "SELECT `guild_id`,`ord` FROM `rwoe` WHERE `ord`=1",.@guild_id1,.@top1; // G1 query_sql "SELECT `guild_id`,`ord` FROM `rwoe` WHERE `ord`=2",.@guild_id2,.@top2; // G2 query_sql "SELECT `guild_id`,`ord` FROM `rwoe` WHERE `ord`=3",.@guild_id3,.@top3; // G3 soon after I joined with an If:
if(.@top1 == 1){ // TOP 1 query_sql "SELECT `char_id` FROM `char` WHERE `guild_id`="+.@guild_id1+"",.@charid; for(.@i=0; .@i<getarraysize(.@charid); .@i++) { .@sender$ = "1"; .@title$ = "1"; .@body$ = "1"; .@zeny = 0; setarray .@mailitem[0], 607, 608, 609, 613; setarray .@mailamount[0], 10, 5, 1, 1; setarray .@mailcard0[0], 0, 0, 0, 0; setarray .@mailcard1[0], 0, 0, 0, 0; setarray .@mailcard2[0], 0, 0, 0, 0; mail .@charid[.@i], .@sender$, .@title$, .@body$, .@zeny, .@mailitem, .@mailamount, .@mailcard0, .@mailcard1, .@mailcard2; } One for each TOP.

- ID: 240500     Group: "AG_GET_ITEM"     Name: "Jogador BETA"     Condition: " ARG0 >= 3000000 "     Reward:       TitleID: 1035     Score: 30 [240500] = { UI_Type = 0, group = "GET_ITEM", major = 1, minor = 2, title = "Jogador BETA", content = { summary = "Seja BETA", details = "Teste o servidor em sua segunda fase.", }, resource = { [1] = { text = "Dado aos Jogadores que ajudaram o servidor em sua fase BETA. Obrigado!" } }, reward = { title = 1035 }, score = 30, } [1035] = "BETA"
friend,
I have no idea what version of rAthena you are using, or what date you are using, but I just got the same lines as the one you sent in the above Quote and works perfectly as you can see.
Edit: In your 'achievement_db' file, the 'Reward:' and 'TitleID: ID'