-
Notifications
You must be signed in to change notification settings - Fork 202
Expand file tree
/
Copy pathr281_scriptdev2.sql
More file actions
35 lines (24 loc) · 1.28 KB
/
r281_scriptdev2.sql
File metadata and controls
35 lines (24 loc) · 1.28 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
ALTER TABLE eventai_scripts
ADD event_chance tinyint(3) unsigned NOT NULL default 100 AFTER event_inverse_phase_mask;
-- EVENT_T_TIMER_REPEAT
UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 0 AND event_param3 < 0;
-- EVENT_T_TIMER_SINGLE
UPDATE eventai_scripts SET event_chance = event_param2 WHERE event_type = 1;
-- EVENT_T_TIMER_OOC_REPEAT
UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 2 AND event_param3 < 0;
-- EVENT_T_TIMER_OOC_SINGLE
UPDATE eventai_scripts SET event_chance = event_param2 WHERE event_type = 3;
-- EVENT_T_HP_SINGLE
UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 4 AND event_param3 < 0;
-- EVENT_T_MANA_SINGLE
UPDATE eventai_scripts SET event_chance = -event_param3 WHERE event_type = 5 AND event_param3 < 0;
-- EVENT_T_AGGRO
UPDATE eventai_scripts SET event_chance = event_param1 WHERE event_type = 6;
-- EVENT_T_KILL
UPDATE eventai_scripts SET event_chance = event_param2 WHERE event_type = 7;
-- EVENT_T_DEATH
UPDATE eventai_scripts SET event_chance = event_param1 WHERE event_type = 8;
-- EVENT_T_EVADE
UPDATE eventai_scripts SET event_chance = event_param1 WHERE event_type = 9;
-- EVENT_T_SPELLHIT
UPDATE eventai_scripts SET event_chance = event_param3 WHERE event_type = 10;