[RELEASE]Sent Mail Script

[DuaSelipar]

Hallow...Now im gonna explain script how sent mail to player via cq_action,you can make this as reward vip , mission , daily reward and so on


1.Sent via script
there are 2 database table require to make mail

Cq_mailinfo - info mail player that receiving mail
Cq_mailtemplate - your mail template

1.Making script (Cq_action)

(150001, 0000, 0000, 1980, 50265, '30 0 500 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');

Type = 1980 sending mail to player
Data = 50265 mail template id (cq_mailtemplate)
Param =
saveday money emoney emoney2 item1 item1Amount item1Lock item2 item2Amount item2Lock item3 item3Amount item3Lock moonvalue starvalue
Param Detail:
saveday - 30 mean 30 days. When value 0 , it means permanent (100 days)
money - Gold
emoney - EP
emoney2 - PP
item1/2/3 - item id (refer cq_itemtype id)
item1/2/3amount - amount item (make sure that item is stackable)
item1/2/3lock - value 1=lock 0=not lock (bind item)
moonvalue - Lunar Point
startvalue - Star Point

2.Making template mail (Cq_mailtemplate)

INSERT INTO `cq_mailtemplate` VALUES
(50265, 'Reward', 'Test 1 Mok mu ija', 'Admin');

ID = 50265 - this data put in your mail script in cq_action
Title = Reward - your mail title
memo = Description of your mail
fromname = Admin - Sender name

Reminder: When sending items by mail, it is recommended to only send gift packs.

2.Sent via tool

this tool is already translated by me and only can be sent by single player
Note: this is old tool version without star and lunar point but still working fine in divine fire database



NOTE : Please configure your database setting first in ToolConfig.ini

DOWNLOAD :




ADDITIONAL:
This is sample script that i've make daily reward to vip player -auto reward when they log in (everyday) - refer pic above

NOTE = 1000000 default id each time player log in this number will be executed

INSERT INTO `cq_action` VALUES (1000000, 81571400, 81571400, 1080, 13822, 'delete');
INSERT INTO `cq_action` VALUES (81571400, 81571401, 81571404, 1080, 8157, 'isexit');
INSERT INTO `cq_action` VALUES (81571401, 81571402, 0000, 1086, 8157, '1');
INSERT INTO `cq_action` VALUES (81571402, 81571403, 81571403, 1081, 8157, 'begintime reset');
INSERT INTO `cq_action` VALUES (81571403, 81571404, 81571404, 1080, 8157, 'delete');
INSERT INTO `cq_action` VALUES (81571404, 81571405, 0000, 1080, 8157, 'new');
INSERT INTO `cq_action` VALUES (81571405, 81571501, 81571406, 5001, 0, '== 1');
INSERT INTO `cq_action` VALUES (81571406, 81571502, 81571407, 5001, 0, '== 2');
INSERT INTO `cq_action` VALUES (81571407, 81571503, 81571408, 5001, 0, '== 3');
INSERT INTO `cq_action` VALUES (81571408, 81571504, 81571409, 5001, 0, '== 4');
INSERT INTO `cq_action` VALUES (81571409, 81571505, 81571410, 5001, 0, '== 5');
INSERT INTO `cq_action` VALUES (81571410, 81571506, 81571411, 5001, 0, '== 6');
INSERT INTO `cq_action` VALUES (81571411, 81571507, 81571412, 5001, 0, '== 7');
INSERT INTO `cq_action` VALUES (81571412, 81571508, 81571413, 5001, 0, '== 8');
INSERT INTO `cq_action` VALUES (81571413, 81571509, 81571414, 5001, 0, '== 9');
INSERT INTO `cq_action` VALUES (81571414, 81571510, 81571415, 5001, 0, '== 10');
INSERT INTO `cq_action` VALUES (81571415, 81571511, 81571416, 5001, 0, '== 11');
INSERT INTO `cq_action` VALUES (81571416, 81571512, 0000, 5001, 0, '== 12');

INSERT INTO `cq_action` VALUES (81571501, 0000, 0000, 1980, 50265, '30 0 500 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571502, 0000, 0000, 1980, 50265, '30 0 1000 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571503, 0000, 0000, 1980, 50265, '30 0 1500 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571504, 0000, 0000, 1980, 50265, '30 0 2000 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571505, 0000, 0000, 1980, 50265, '30 0 2500 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571506, 0000, 0000, 1980, 50265, '30 0 3000 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571507, 0000, 0000, 1980, 50265, '30 0 3500 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571508, 0000, 0000, 1980, 50265, '30 0 4000 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571509, 0000, 0000, 1980, 50265, '30 0 4500 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571510, 0000, 0000, 1980, 50265, '30 0 5000 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571511, 0000, 0000, 1980, 50265, '30 0 5500 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');
INSERT INTO `cq_action` VALUES (81571512, 0000, 0000, 1980, 50265, '30 0 6000 0 1020790 1 1 1026292 1 1 724043 1 1 0 0');


INSERT INTO `cq_mailtemplate` VALUES (50265, 'VIP Reward', 'Thank you for playing..have fun and good luck adventurer', 'Admin');