Auto Reward 3x Guilds

[Mahiro]

Hi,

next I'm trying to make in DAY X, TIME X, the script below happens. So far so good.

The problem starts when I'm trying to get the ID all three different Guild characters to send everyone email with items, but that does not happen he just delivers to everyone from the first Guild, and ignores the other two.

I believe the problem is in SQL Query

if someone can give help, tell me where I'm wrong thank you ^^

 

PS: It's been a while since I started scripting so let's take it easy

 

if(gettime(DT_DAYOFMONTH) == 16){
	OnClock2127:
	query_sql "UPDATE `rwoe` SET `kd`= (`kills`-`deaths`) WHERE `rwoe`.`guild_id` >=1";
	query_sql "SELECT `guild_id` FROM `rwoe` ORDER BY `kd` DESC LIMIT 3",.@guild_id;
	query_sql "SELECT `char_id` FROM `char` WHERE `guild_id`="+.@guild_id+"",.@charid;
	for(.@i=0; .@i<getarraysize(.@charid); .@i++) {
	.@sender$ = "1";
	.@title$ = "1";
	.@body$ = "1";
	.@zeny = 0;
	setarray .@mailitem[0], 607, 608, 609, 610; 
	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; 
	// EMAIL
	mail .@charid[.@i], .@sender$, .@title$, .@body$, .@zeny, .@mailitem, .@mailamount, .@mailcard0, .@mailcard1, .@mailcard2;
	}
	end;
	}

 

[Mahiro]

3 hours ago, Sehrentos said:

Hey, you can do one extra for loop for the [email protected]_id too.

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.

[Sehrentos]

On 9/17/2018 at 3:36 AM, Mahiro said:

for(.@i=0; .@i<getarraysize(.@charid); .@i++)

Hey, you can do one extra for loop for the [email protected]_id too.