Events
Event Manage:
Code:
130 18 Halloween checkPeriodByGmt(0, 2021/08/30-09:00, 2021/11/02-09:00) 1007, 2002, 1020, 1021, 3014, 5003, 7097, 3008
EventContents:
Code:
7 1007 C_SetEventMap Halloween 0 0 0
24 2002 C_SetEventUI Halloween 0 0 0
20 1020 C_SetEventMap Halloween_02 0 0 0
21 1021 C_SetItemDropEffect fL_EventBox_Halloween_02A(l),fL_EventBox_Halloween_01A(L),L_Event_Drop_Candy_03A(L) 0 0 0
40 3014 S_SpawnCharacter 35679,23924 0 0 0
88 5003 C_SetSoundEvent Night-5,32,77,202,229,735 257 0 0
117 7097 S_SpawnRandomFieldBoss 23924 0 0 0
35 3008 S_SpawnCharacter 37125 0 0 0
EDIT: The following things need to be Added/Inserted in datasheets.bexcel with BexcelEditor2 in the client
Quests: Do not ask me for those individually , look them up or use import wizzard in navicat or whatever you are using with the files below
Spawn Isabela: the trigger is set , but the spawn is not done , i do not know how to fill the spawn ... i do not know where to set the spawn based on the event in the files.
Please share if you figure it out , as this is the last thing i am missing in figuring out the events
Drop : you have to set them manually/ or download the files for drop bellow - i don't think there's a event drop condition somewhere set up
, if you know ... Sharing is Caring
Replace/Edit if you are missing the following lines.
Activating and using the events:
First i will take as a example Halloween event.
You must be registered to see links
First you go into your Database -> Table : EventManage & EventContents
EventManage - Starts the event with the given conditions,
*For example: Setting the Start/End date of the event, spawning npc's required for events, mobs, quests, "drops" <- this i don't know if its possible i just did it manually
EventContents - Contains what specificaly you add in EventManage -> Collumn : SettedEvent
* This actually contains: What event based on a number , and you can assign for example to spawn Kzarka on number 232123 and just add it in EventManage to the event you are creating,
*if you do not want or you don't understand the logic then just copy the Collumn : EventContentNo from EventContents -> EventManage -> Collumn : SettedEvent
TBH : There's no restrictions on what events you can start : i haven't tested actually, but i believe you can start everything in the same Start/End date
Now heres a tricky part: Quests , yes you can spawn the npc which contains and do the dialogue to start the quests but the quests itself have a condition collumn : AcceptConditions in the Table : Quest_Table that will have a Start/End date by itself, and its not override it by the event conditions in the previous tables ( I know its dumb , i would've created a column that says 1= Event Quest , 0 = Isn't a Event Quest ) and made the script read the condition to start the quest when event date = what i assigned previously but
yeah . Do this if the NPC that holds the quests doesn't give the quests.
This is to understand most of the logic and what i have discovered so far , here is copy paste to start the event:
Check if you have the line if you don't then create a new one, if you do have it, EDIT IT , its not a requirement but if you don't want to screw up something do it.
Files of the event: ONLY USE IT IF YOU DO NOT HAVE MODIFICATIONS IN THE TABLES THAT EACH SQL FILE IS NAMED.
LINK TO EVENTS TO IMPORT IN THE DATABASE -
You must be registered to see links
