[Only registered and activated users can see links. Click Here To Register...]
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
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
[Only registered and activated users can see links. Click Here To Register...]
NOTE : Please configure your database setting first in ToolConfig.ini
DOWNLOAD :[Only registered and activated users can see links. Click Here To Register...]
ADDITIONAL:
This is sample script that i've make daily reward to vip player -auto reward when they log in (everyday) - refer pic above
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
1.Making script (Cq_action)Quote:
Cq_mailinfo - info mail player that receiving mail
Cq_mailtemplate - your mail template
2.Making template mail (Cq_mailtemplate)Quote:
(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
Quote:
INSERT INTO `cq_mailtemplate` VALUES
(50265, 'Reward', 'Test 1 Mok mu ija', 'Admin');
Reminder: When sending items by mail, it is recommended to only send gift packs.Quote:
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
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
[Only registered and activated users can see links. Click Here To Register...]
NOTE : Please configure your database setting first in ToolConfig.ini
DOWNLOAD :[Only registered and activated users can see links. Click Here To Register...]
ADDITIONAL:
This is sample script that i've make daily reward to vip player -auto reward when they log in (everyday) - refer pic above
Quote:
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');