// GET ALL MEMBER GUILD
// GET ALL MAC GUILD
// GET ITEM ALL MEMBER + DUPLICATE CHECK MAC = END;
// SQL REGISTER ALL MAC AND TRUNCATE FOR LOOP
/*

DROP TABLE IF EXISTS `greward`;
CREATE TABLE `greward` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`gduniqueid` VARCHAR(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
)ENGINE=MyISAM;

*/
- script rewardgde -1,{

OnRLWinw:
 // Last Guild
 query_sql "TRUNCATE TABLE greward";
 query_sql "SELECT `guild_id` FROM `rwoe` WHERE `last_w`=1",.@lastguildid;
 query_sql "UPDATE `rwoe` SET `last_win`=0";
 query_sql "SELECT `char_id` FROM `char` WHERE `guild_id`="+.@lastguildid+"",.@charid;
    for(.@i=0; .@i<getarraysize(.@charid); .@i++) {
// CHECK
query_sql "SELECT `account_id` FROM `char` WHERE `char_id`="+.@charid+"",.@accid;
query_sql "SELECT `last_unique_id` FROM `login` WHERE `account_id`="+.@accid+"",.@aclid;
query_sql "SELECT `gduniqueid` FROM `greward` WHERE `gduniqueid`="+.@aclid+"",.@aclid2;
if(.@aclid == .@aclid2) { end; }
// SAVE ID
query_sql "INSERT INTO greward (gduniqueid) VALUES ("+.@aclid+")";
// MAHIRO
    .@sender$ = "Premiação GdE";
    .@title$ = "Premiação GdE";
    .@body$ = "Aqui está sua recompensa por vencer está GdE. Faça bom uso!";
    .@zeny = 0;
    setarray .@mailitem[0], 607, 608, 609, 613; // PRÊMIOS ID
    setarray .@mailamount[0], 10, 5, 1, 1; // QUANTIDADE
    setarray .@mailcard0[0], 0, 0, 0, 0; // CARD1 NO ITEM
    setarray .@mailcard1[0], 0, 0, 0, 0; // CARD2 NO ITEM
    setarray .@mailcard2[0], 0, 0, 0, 0; // CARD3 NO ITEM
    mail .@charid[.@i], .@sender$, .@title$, .@body$, .@zeny, .@mailitem, .@mailamount, .@mailcard0, .@mailcard1, .@mailcard2;
    }
    end;


OnInit:
bindatcmd "lwoer",strnpcinfo(3)+"OnRLWinw",99;
end;
}