- Joined
- Mar 29, 2019
- Messages
- 1,032
- Reaction score
- 1,188
There's 2 ways to do it,
1. Web Admin Tool
World Events > Play Time Event Rewards
Ex.
2. Through DB
Set what AccountTrait should get the benefits, "0" for all or customize to whatever you want like 333 (EME) and date (start/end)
PlanetDB_2800
Code:
INSERT INTO [dbo].[PlayTimeEvent]([eventId], [accountTraitId], [startTime], [endTime]) VALUES (1, 0, '2022-05-28 16:25:00.000', '2022-06-28 16:25:00.000');
Explanation,
accounttraitid = ID from AccountTrait.xml (0 for all)
starttime = start date/time
endtime = end date/time
Code:
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 1, 1, 600, 950078, 2, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 1, 2, 1800, 950078, 4, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 1, 3, 3000, 950078, 6, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 1, 4, 4200, 950078, 8, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 1, 5, 4800, 950078, 10, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 1, 6, 6000, 950078, 15, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 2, 1, 30, 369, 1, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 2, 2, 60, 369, 2, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 2, 3, 120, 369, 3, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 2, 4, 180, 369, 4, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 2, 5, 240, 369, 5, 0);
INSERT INTO [dbo].[PlayTimeEventRewardInfo]([eventId], [eventType], [rewardId], [playTime], [itemTemplateId], [itemAmount], [awsomiumId]) VALUES (1, 2, 6, 360, 369, 6, 0);
Explanation
eventid = the eventid you set in PlayTimeEvent
eventType = "2" daily, "1" total
rewardid = the position of the reward (max 6 for daily, and max 6 for total)
playtime = amount of time in minutes
itemtemplateid = itemid (ex, 369 for Diamond)
itemamout = amout of items to give
awesomiumid = 0