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;}
Question
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
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.