Reward RW

// 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,{

OnMail:
    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;
    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

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++) {
// 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;
    }
    }
query_sql "TRUNCATE TABLE greward";
end;

}