· 5 years ago · Apr 06, 2020, 03:48 PM
1// GET ALL MEMBER GUILD
2// GET ALL MAC GUILD
3// GET ITEM ALL MEMBER + DUPLICATE CHECK MAC = END;
4// SQL REGISTER ALL MAC AND TRUNCATE FOR LOOP
5/*
6
7DROP TABLE IF EXISTS `greward`;
8CREATE TABLE `greward` (
9`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
10`gduniqueid` VARCHAR(100) NOT NULL DEFAULT '',
11PRIMARY KEY (`id`)
12)ENGINE=MyISAM;
13
14*/
15- script rewardgde -1,{
16
17OnRLWinw:
18 // Last Guild
19 query_sql "TRUNCATE TABLE greward";
20 query_sql "SELECT `guild_id` FROM `rwoe` WHERE `last_w`=1",.@lastguildid;
21 query_sql "UPDATE `rwoe` SET `last_win`=0";
22 query_sql "SELECT `char_id` FROM `char` WHERE `guild_id`="+.@lastguildid+"",.@charid;
23 for(.@i=0; .@i<getarraysize(.@charid); .@i++) {
24// CHECK
25query_sql "SELECT `account_id` FROM `char` WHERE `char_id`="+.@charid+"",.@accid;
26query_sql "SELECT `last_unique_id` FROM `login` WHERE `account_id`="+.@accid+"",.@aclid;
27query_sql "SELECT `gduniqueid` FROM `greward` WHERE `gduniqueid`=""+.@aclid+""",.@aclid2;
28if(.@aclid == .@aclid2) { end; }
29// SAVE ID
30query_sql "INSERT INTO greward (gduniqueid) VALUES ("+.@aclid+")";
31// MAHIRO
32 .@sender$ = "Premiação GdE";
33 .@title$ = "Premiação GdE";
34 .@body$ = "Aqui está sua recompensa por vencer está GdE. Faça bom uso!";
35 .@zeny = 0;
36 setarray .@mailitem[0], 607, 608, 609, 613; // PRÊMIOS ID
37 setarray .@mailamount[0], 10, 5, 1, 1; // QUANTIDADE
38 setarray .@mailcard0[0], 0, 0, 0, 0; // CARD1 NO ITEM
39 setarray .@mailcard1[0], 0, 0, 0, 0; // CARD2 NO ITEM
40 setarray .@mailcard2[0], 0, 0, 0, 0; // CARD3 NO ITEM
41 mail .@charid[.@i], .@sender$, .@title$, .@body$, .@zeny, .@mailitem, .@mailamount, .@mailcard0, .@mailcard1, .@mailcard2;
42 }
43 end;
44
45
46OnInit:
47bindatcmd "lwoer",strnpcinfo(3)+"OnRLWinw",99;
48end;
49}