/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; SET @FLAG_DISPELABLE = 1; -- 0x00000001 SET @FLAG_ERASABLE = 2; -- 0x00000002 SET @FLAG_ATTACK = 4; -- 0x00000004 SET @FLAG_EMPATHY = 8; -- 0x00000008 SET @FLAG_DAMAGE = 16; -- 0x00000010 SET @FLAG_DEATH = 32; -- 0x00000020 SET @FLAG_MAGIC_BEGIN = 64; -- 0x00000040 SET @FLAG_MAGIC_END = 128; -- 0x00000080 SET @FLAG_ON_ZONE = 256; -- 0x00000100 SET @FLAG_NO_LOSS_MESSAGE = 512; -- 0x00000200 SET @FLAG_INVISIBLE = 1024; -- 0x00000400 SET @FLAG_DETECTABLE = 2048; -- 0x00000800 SET @FLAG_NO_REST = 4096; -- 0x00001000 SET @FLAG_PREVENT_ACTION = 8192; -- 0x00002000 SET @FLAG_WALTZABLE = 16384; -- 0x00004000 SET @FLAG_FOOD = 32768; -- 0x00008000 SET @FLAG_SONG = 65536; -- 0x00010000 SET @FLAG_ROLL = 131072; -- 0x00020000 SET @FLAG_SYNTH_SUPPORT = 262144; -- 0x00040000 SET @FLAG_CONFRONTATION = 524288; -- 0x00080000 SET @FLAG_LOGOUT = 1048576; -- 0x00100000 SET @FLAG_BLOODPACT = 2097152; -- 0x00200000 SET @FLAG_ON_JOBCHANGE = 4194304; -- 0x00400000 SET @FLAG_NO_CANCEL = 8388608; -- 0x00800000 SET @FLAG_INFLUENCE = 16777216; -- 0x01000000 SET @FLAG_OFFLINE_TICK = 33554432; -- 0x02000000 SET @FLAG_AURA = 67108864; -- 0x04000000 SET @FLAG_HIDE_TIMER = 134217728; -- 0x08000000 SET @FLAG_ON_ZONE_PATHOS = 268435456; -- 0x10000000 SET @FLAG_ALWAYS_EXPIRING = 536870912; -- 0x20000000 SET @FLAG_ON_ATTACK = 1073741824; -- 0x40000000 -- -- Table structure for table `status_effects` -- DROP TABLE IF EXISTS `status_effects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `status_effects` ( `id` smallint(5) unsigned NOT NULL, `name` varchar(50) NOT NULL, `flags` int(8) unsigned NOT NULL DEFAULT 0, `type` smallint(5) unsigned NOT NULL DEFAULT 0, -- This needs renamed eventually. See struct EffectParams_t in status_effect_container.cpp `negative_id` smallint(5) unsigned DEFAULT 0, `overwrite` smallint(5) unsigned NOT NULL DEFAULT 0, `block_id` smallint(5) unsigned DEFAULT 0, `remove_id` smallint(5) unsigned NOT NULL DEFAULT 0, `element` smallint(5) unsigned NOT NULL DEFAULT 0, `min_duration` smallint(5) unsigned NOT NULL DEFAULT 0, `sort_key` smallint(5) unsigned NOT NULL DEFAULT 0, `wear_off_message_id` smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=Aria TRANSACTIONAL=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `status_effects` -- LOCK TABLES `status_effects` WRITE; /*!40000 ALTER TABLE `status_effects` DISABLE KEYS */; INSERT INTO `status_effects` VALUES (0,'ko',@FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (1,'weakness',@FLAG_NO_CANCEL,0,0,3,0,0,0,1,0,204); INSERT INTO `status_effects` VALUES (2,'sleep',@FLAG_DAMAGE | @FLAG_DEATH | @FLAG_NO_CANCEL,2,19,1,193,0,8,1,0,204); INSERT INTO `status_effects` VALUES (3,'poison',@FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,2,0,0,6,1,0,204); INSERT INTO `status_effects` VALUES (4,'paralysis',@FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,1,0,0,2,1,0,204); INSERT INTO `status_effects` VALUES (5,'blindness',@FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,1,0,0,8,1,0,204); INSERT INTO `status_effects` VALUES (6,'silence',@FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,2,0,0,3,1,0,204); INSERT INTO `status_effects` VALUES (7,'petrification',@FLAG_DEATH | @FLAG_NO_CANCEL,7,0,2,10,0,4,1,0,204); INSERT INTO `status_effects` VALUES (8,'disease',@FLAG_DEATH | @FLAG_NO_REST | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,8,0,2,0,0,1,1,0,204); INSERT INTO `status_effects` VALUES (9,'curse',@FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,9,0,2,0,0,8,1,0,204); INSERT INTO `status_effects` VALUES (10,'stun',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_NO_CANCEL,0,0,2,7,0,5,1,0,204); INSERT INTO `status_effects` VALUES (11,'bind',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,2,0,0,2,1,0,204); INSERT INTO `status_effects` VALUES (12,'weight',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,32,1,0,0,3,1,0,204); INSERT INTO `status_effects` VALUES (13,'slow',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,33,1,0,0,4,1,0,NULL); INSERT INTO `status_effects` VALUES (14,'charm',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,2,0,0,7,0,0,204); INSERT INTO `status_effects` VALUES (15,'doom',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,2,0,0,8,1,0,204); INSERT INTO `status_effects` VALUES (16,'amnesia',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,2,0,0,1,1,0,204); INSERT INTO `status_effects` VALUES (17,'charm',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,2,0,0,7,0,0,204); INSERT INTO `status_effects` VALUES (18,'gradual_petrification',@FLAG_DEATH | @FLAG_NO_CANCEL,7,0,2,0,0,4,1,0,204); INSERT INTO `status_effects` VALUES (19,'sleep',@FLAG_DAMAGE | @FLAG_DEATH | @FLAG_NO_CANCEL,2,0,1,0,0,8,1,0,204); INSERT INTO `status_effects` VALUES (20,'curse',@FLAG_DEATH | @FLAG_NO_REST | @FLAG_NO_CANCEL,9,0,2,0,0,8,1,0,204); INSERT INTO `status_effects` VALUES (21,'addle',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,2,0,0,1,1,0,NULL); INSERT INTO `status_effects` VALUES (22,'intimidate',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,2,0,0,0,1,0,204); INSERT INTO `status_effects` VALUES (23,'kaustra',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,228,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (28,'terror',@FLAG_DEATH | @FLAG_NO_CANCEL,7,0,0,0,0,8,1,0,204); INSERT INTO `status_effects` VALUES (29,'mute',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,2,0,6,3,1,0,204); INSERT INTO `status_effects` VALUES (30,'bane',@FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,2,0,9,8,1,0,204); INSERT INTO `status_effects` VALUES (31,'plague',@FLAG_DEATH | @FLAG_NO_REST | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,8,0,2,0,0,1,1,0,204); INSERT INTO `status_effects` VALUES (32,'flee',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,12,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (33,'haste',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,13,0,0,0,3,0,100,NULL); INSERT INTO `status_effects` VALUES (34,'blaze_spikes',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,34,0,0,0,0,1,0,800,NULL); INSERT INTO `status_effects` VALUES (35,'ice_spikes',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,34,0,0,0,0,2,0,800,NULL); INSERT INTO `status_effects` VALUES (36,'blink',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,36,0,0,66,0,3,0,50,NULL); INSERT INTO `status_effects` VALUES (37,'stoneskin',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,5,0,0,4,0,600,NULL); INSERT INTO `status_effects` VALUES (38,'shock_spikes',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,34,0,0,0,0,5,0,800,NULL); INSERT INTO `status_effects` VALUES (39,'aquaveil',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,6,0,650,NULL); INSERT INTO `status_effects` VALUES (40,'protect',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,7,0,200,NULL); INSERT INTO `status_effects` VALUES (41,'shell',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,7,0,250,NULL); INSERT INTO `status_effects` VALUES (42,'regen',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,7,0,700,NULL); INSERT INTO `status_effects` VALUES (43,'refresh',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,7,0,750,NULL); INSERT INTO `status_effects` VALUES (44,'mighty_strikes',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (45,'boost',@FLAG_ATTACK | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (46,'hundred_fists',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (47,'manafont',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (48,'chainspell',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (49,'perfect_dodge',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (50,'invincible',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (51,'blood_weapon',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,94,0,0,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (52,'soul_voice',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (53,'eagle_eye_shot',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (54,'meikyo_shisui',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (55,'astral_flow',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (56,'berserk',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (57,'defender',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (58,'aggressor',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (59,'focus',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (60,'dodge',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (61,'counterstance',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (62,'sentinel',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (63,'souleater',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (64,'last_resort',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (65,'sneak_attack',@FLAG_ATTACK | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (66,'copy_image',@FLAG_DISPELABLE | @FLAG_DEATH,0,0,0,0,36,3,0,50,NULL); INSERT INTO `status_effects` VALUES (67,'third_eye',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (68,'warcry',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,460,0,0,400,NULL); INSERT INTO `status_effects` VALUES (69,'invisible',@FLAG_DISPELABLE | @FLAG_ATTACK | @FLAG_DEATH | @FLAG_MAGIC_BEGIN | @FLAG_ON_ZONE | @FLAG_INVISIBLE | @FLAG_DETECTABLE | @FLAG_LOGOUT,0,0,2,0,0,3,0,850,NULL); INSERT INTO `status_effects` VALUES (70,'deodorize',@FLAG_DISPELABLE | @FLAG_ATTACK | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_DETECTABLE | @FLAG_LOGOUT,0,0,2,0,0,3,0,1100,NULL); INSERT INTO `status_effects` VALUES (71,'sneak',@FLAG_DISPELABLE | @FLAG_ATTACK | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_DETECTABLE | @FLAG_LOGOUT,0,0,2,0,0,3,0,1150,NULL); INSERT INTO `status_effects` VALUES (72,'sharpshot',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (73,'barrage',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,73,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (74,'holy_circle',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (75,'arcane_circle',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (76,'hide',@FLAG_DISPELABLE | @FLAG_ATTACK | @FLAG_DEATH | @FLAG_MAGIC_BEGIN | @FLAG_ON_ZONE | @FLAG_INVISIBLE | @FLAG_DETECTABLE | @FLAG_LOGOUT,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (77,'camouflage',@FLAG_DISPELABLE | @FLAG_ATTACK | @FLAG_DEATH | @FLAG_MAGIC_BEGIN | @FLAG_ON_ZONE | @FLAG_INVISIBLE | @FLAG_DETECTABLE | @FLAG_LOGOUT,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (78,'divine_seal',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_MAGIC_END | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (79,'elemental_seal',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_MAGIC_END | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (80,'str_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,136,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (81,'dex_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,137,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (82,'vit_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,138,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (83,'agi_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,139,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (84,'int_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,140,0,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (85,'mnd_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,141,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (86,'chr_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,142,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (87,'trick_attack',@FLAG_ATTACK | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (88,'max_hp_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,144,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (89,'max_mp_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,145,0,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (90,'accuracy_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,146,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (91,'attack_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,147,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (92,'evasion_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,148,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (93,'defense_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,149,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (94,'enfire',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,1,0,1200,NULL); INSERT INTO `status_effects` VALUES (95,'enblizzard',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,2,0,1200,NULL); INSERT INTO `status_effects` VALUES (96,'enaero',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,3,0,1200,NULL); INSERT INTO `status_effects` VALUES (97,'enstone',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,4,0,1200,NULL); INSERT INTO `status_effects` VALUES (98,'enthunder',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,5,0,1200,NULL); INSERT INTO `status_effects` VALUES (99,'enwater',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,6,0,1200,NULL); INSERT INTO `status_effects` VALUES (100,'barfire',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,100,0,0,0,0,6,0,500,NULL); INSERT INTO `status_effects` VALUES (101,'barblizzard',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,100,0,0,0,0,1,0,500,NULL); INSERT INTO `status_effects` VALUES (102,'baraero',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,100,0,0,0,0,2,0,500,NULL); INSERT INTO `status_effects` VALUES (103,'barstone',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,100,0,0,0,0,3,0,500,NULL); INSERT INTO `status_effects` VALUES (104,'barthunder',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,100,0,0,0,0,4,0,500,NULL); INSERT INTO `status_effects` VALUES (105,'barwater',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,100,0,0,0,0,5,0,500,NULL); INSERT INTO `status_effects` VALUES (106,'barsleep',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,106,0,0,0,0,7,0,500,NULL); INSERT INTO `status_effects` VALUES (107,'barpoison',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,106,0,0,0,0,5,0,500,NULL); INSERT INTO `status_effects` VALUES (108,'barparalyze',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,106,0,0,0,0,1,0,500,NULL); INSERT INTO `status_effects` VALUES (109,'barblind',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,106,0,0,0,0,7,0,500,NULL); INSERT INTO `status_effects` VALUES (110,'barsilence',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,106,0,0,0,0,2,0,500,NULL); INSERT INTO `status_effects` VALUES (111,'barpetrify',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,106,0,0,0,0,3,0,500,NULL); INSERT INTO `status_effects` VALUES (112,'barvirus',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,106,0,0,0,0,6,0,500,NULL); INSERT INTO `status_effects` VALUES (113,'reraise',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,0,7,0,900,NULL); INSERT INTO `status_effects` VALUES (114,'cover',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (115,'unlimited_shot',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,73,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (116,'phalanx',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,7,0,1050,NULL); INSERT INTO `status_effects` VALUES (117,'warding_circle',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (118,'ancient_circle',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (119,'str_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (120,'dex_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (121,'vit_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (122,'agi_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (123,'int_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (124,'mnd_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (125,'chr_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (126,'spirit_surge',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (127,'costume',@FLAG_ATTACK | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_MAGIC_END,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (128,'burn',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,133,129,1,0,0,NULL); INSERT INTO `status_effects` VALUES (129,'frost',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,128,130,2,0,0,NULL); INSERT INTO `status_effects` VALUES (130,'choke',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,129,131,3,0,0,NULL); INSERT INTO `status_effects` VALUES (131,'rasp',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,130,132,4,0,0,NULL); INSERT INTO `status_effects` VALUES (132,'shock',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,131,133,5,0,0,NULL); INSERT INTO `status_effects` VALUES (133,'drown',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,132,128,6,0,0,NULL); INSERT INTO `status_effects` VALUES (134,'dia',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,134,1,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (135,'bio',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,134,1,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (136,'str_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,80,6,0,0,NULL); INSERT INTO `status_effects` VALUES (137,'dex_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,81,4,0,0,NULL); INSERT INTO `status_effects` VALUES (138,'vit_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,82,3,0,0,NULL); INSERT INTO `status_effects` VALUES (139,'agi_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,83,2,0,0,NULL); INSERT INTO `status_effects` VALUES (140,'int_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,84,1,0,0,NULL); INSERT INTO `status_effects` VALUES (141,'mnd_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,85,5,0,0,NULL); INSERT INTO `status_effects` VALUES (142,'chr_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,86,8,0,0,NULL); INSERT INTO `status_effects` VALUES (143,'level_restriction',@FLAG_NO_LOSS_MESSAGE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (144,'max_hp_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,88,8,0,0,NULL); INSERT INTO `status_effects` VALUES (145,'max_mp_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,89,7,0,0,NULL); INSERT INTO `status_effects` VALUES (146,'accuracy_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,90,4,0,0,NULL); INSERT INTO `status_effects` VALUES (147,'attack_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,91,6,0,0,NULL); INSERT INTO `status_effects` VALUES (148,'evasion_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,92,2,0,0,NULL); INSERT INTO `status_effects` VALUES (149,'defense_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,93,3,0,0,NULL); INSERT INTO `status_effects` VALUES (150,'physical_shield',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (151,'arrow_shield',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (152,'magic_shield',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (153,'damage_spikes',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_NO_CANCEL,34,0,0,0,0,0,0,800,NULL); INSERT INTO `status_effects` VALUES (154,'shining_ruby',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (155,'medicine',@FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (156,'flash',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,1,0,0,7,0,0,204); INSERT INTO `status_effects` VALUES (157,'sj_restriction',@FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (158,'provoke',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (159,'penalty',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (160,'preparations',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (161,'sprint',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (162,'enchantment',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (163,'azure_lore',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (164,'chain_affinity',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (165,'burst_affinity',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (166,'overdrive',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (167,'magic_def_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (168,'inhibit_tp',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (169,'potency',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (170,'regain',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (171,'pax',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (172,'intension',@FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (173,'dread_spikes',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,34,0,0,0,0,0,0,800,NULL); INSERT INTO `status_effects` VALUES (174,'magic_acc_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (175,'magic_atk_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (176,'quickening',@FLAG_ATTACK | @FLAG_EMPATHY | @FLAG_DAMAGE | @FLAG_DEATH | @FLAG_ON_JOBCHANGE | @FLAG_ON_ATTACK,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (177,'encumbrance',@FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (178,'firestorm',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (179,'hailstorm',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (180,'windstorm',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (181,'sandstorm',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (182,'thunderstorm',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (183,'rainstorm',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (184,'aurorastorm',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (185,'voidstorm',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (186,'helix',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (187,'sublimation_activated',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (188,'sublimation_complete',@FLAG_DEATH | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (189,'max_tp_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (190,'magic_atk_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (191,'magic_def_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (192,'requiem',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,1,0,0,7,0,2000,NULL); INSERT INTO `status_effects` VALUES (193,'lullaby',@FLAG_DAMAGE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,2,19,2,2,0,7,1,2000,NULL); INSERT INTO `status_effects` VALUES (194,'elegy',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,0,0,0,4,0,2000,NULL); INSERT INTO `status_effects` VALUES (195,'paeon',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,7,0,2000,NULL); INSERT INTO `status_effects` VALUES (196,'ballad',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,7,0,2000,NULL); INSERT INTO `status_effects` VALUES (197,'minne',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,4,0,2000,NULL); INSERT INTO `status_effects` VALUES (198,'minuet',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,1,0,2000,NULL); INSERT INTO `status_effects` VALUES (199,'madrigal',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,5,0,2000,NULL); INSERT INTO `status_effects` VALUES (200,'prelude',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (201,'mambo',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (202,'aubade',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (203,'pastoral',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (204,'hum',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (205,'fantasia',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (206,'operetta',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (207,'capriccio',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (208,'serenade',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (209,'round',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (210,'gavotte',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (211,'fugue',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (212,'rhapsody',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (213,'aria',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (214,'march',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (215,'etude',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (216,'carol',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (217,'threnody',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,1,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (218,'hymnus',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (219,'mazurka',@FLAG_DISPELABLE | @FLAG_ATTACK | @FLAG_DAMAGE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_ON_ATTACK | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (220,'sirvente',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (221,'dirge',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (222,'scherzo',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_SONG | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (223,'nocturne',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (227,'store_tp',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (228,'embrava',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,23,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (229,'manawell',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (230,'spontaneity',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (231,'marcato',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (233,'auto-regen',@FLAG_DEATH,0,0,4,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (234,'auto-refresh',@FLAG_DEATH,0,0,4,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (235,'fishing_imagery',@FLAG_DEATH | @FLAG_SYNTH_SUPPORT | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (236,'woodworking_imagery',@FLAG_DEATH | @FLAG_SYNTH_SUPPORT | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (237,'smithing_imagery',@FLAG_DEATH | @FLAG_SYNTH_SUPPORT | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (238,'goldsmithing_imagery',@FLAG_DEATH | @FLAG_SYNTH_SUPPORT | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (239,'clothcraft_imagery',@FLAG_DEATH | @FLAG_SYNTH_SUPPORT | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (240,'leathercraft_imagery',@FLAG_DEATH | @FLAG_SYNTH_SUPPORT | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (241,'bonecraft_imagery',@FLAG_DEATH | @FLAG_SYNTH_SUPPORT | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (242,'alchemy_imagery',@FLAG_DEATH | @FLAG_SYNTH_SUPPORT | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (243,'cooking_imagery',@FLAG_DEATH | @FLAG_SYNTH_SUPPORT | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (244,'imagery',@FLAG_DEATH | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (245,'imagery',@FLAG_DEATH | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (246,'imagery',@FLAG_DEATH | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (247,'imagery',@FLAG_DEATH | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (248,'imagery',@FLAG_DEATH | @FLAG_NO_CANCEL,244,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (249,'dedication',@FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (250,'ef_badge',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (251,'food',@FLAG_DEATH | @FLAG_FOOD | @FLAG_NO_CANCEL,0,0,2,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (252,'mounted',@FLAG_ATTACK | @FLAG_DEATH | @FLAG_MAGIC_END | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (253,'signet',@FLAG_INFLUENCE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,1000,NULL); INSERT INTO `status_effects` VALUES (254,'battlefield',@FLAG_CONFRONTATION | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (256,'sanction',@FLAG_INFLUENCE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,1000,NULL); INSERT INTO `status_effects` VALUES (257,'besieged',@FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (258,'illusion',@FLAG_ATTACK | @FLAG_DAMAGE | @FLAG_DEATH | @FLAG_MAGIC_END | @FLAG_ON_ZONE | @FLAG_NO_REST,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (259,'encumbrance',@FLAG_ON_ZONE_PATHOS | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (260,'obliviscence',@FLAG_ON_ZONE_PATHOS | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (261,'impairment',@FLAG_ON_ZONE_PATHOS | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (262,'omerta',@FLAG_ON_ZONE_PATHOS | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (263,'debilitation',@FLAG_ON_ZONE_PATHOS | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (264,'pathos',@FLAG_ON_ZONE_PATHOS | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (265,'flurry',@FLAG_DEATH | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (266,'concentration',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (267,'allied_tags',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_CONFRONTATION | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (268,'sigil',@FLAG_INFLUENCE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (269,'level_sync',@FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (270,'aftermath_lv1',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (271,'aftermath_lv2',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (272,'aftermath_lv3',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (273,'aftermath',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (274,'enlight',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (275,'auspice',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,94,51,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (276,'confrontation',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_CONFRONTATION | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (277,'enfire_ii',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (278,'enblizzard_ii',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (279,'enaero_ii',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (280,'enstone_ii',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (281,'enthunder_ii',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (282,'enwater_ii',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (283,'perfect_defense',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (284,'egg',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (285,'visitant',@FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_OFFLINE_TICK,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (286,'baramnesia',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,106,0,0,0,0,0,0,500,NULL); INSERT INTO `status_effects` VALUES (287,'atma',@FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,4,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (288,'endark',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,94,51,0,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (289,'enmity_boost',@FLAG_DEATH,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (290,'subtle_blow_plus',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (291,'enmity_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE,0,0,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (292,'pennant',@FLAG_DEATH | @FLAG_CONFRONTATION | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (293,'negate_petrify',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,7,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (294,'negate_terror',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,28,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (295,'negate_amnesia',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,16,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (296,'negate_doom',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,15,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (297,'negate_poison',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,3,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (298,'critical_hit_evasion_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (299,'overload',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (300,'fire_maneuver',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,3000,NULL); INSERT INTO `status_effects` VALUES (301,'ice_maneuver',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,3000,NULL); INSERT INTO `status_effects` VALUES (302,'wind_maneuver',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,3000,NULL); INSERT INTO `status_effects` VALUES (303,'earth_maneuver',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,3000,NULL); INSERT INTO `status_effects` VALUES (304,'thunder_maneuver',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,3000,NULL); INSERT INTO `status_effects` VALUES (305,'water_maneuver',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,3000,NULL); INSERT INTO `status_effects` VALUES (306,'light_maneuver',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,3000,NULL); INSERT INTO `status_effects` VALUES (307,'dark_maneuver',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,3000,NULL); INSERT INTO `status_effects` VALUES (308,'double-up_chance',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2050,NULL); INSERT INTO `status_effects` VALUES (309,'bust',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,4,0,0,0,0,2050,NULL); INSERT INTO `status_effects` VALUES (310,'fighters_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (311,'monks_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (312,'healers_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (313,'wizards_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (314,'warlocks_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (315,'rogues_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (316,'gallants_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (317,'chaos_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (318,'beast_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (319,'choral_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (320,'hunters_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (321,'samurai_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (322,'ninja_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (323,'drachen_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (324,'evokers_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (325,'maguss_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (326,'corsairs_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (327,'puppet_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (328,'dancers_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (329,'scholars_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (330,'bolters_roll',@FLAG_DISPELABLE | @FLAG_ATTACK | @FLAG_EMPATHY | @FLAG_DAMAGE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_ON_ATTACK | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (331,'casters_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (332,'coursers_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (333,'blitzers_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (334,'tacticians_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (335,'allies_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (336,'misers_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (337,'companions_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (338,'avengers_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (339,'naturalists_roll',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,2000,NULL); INSERT INTO `status_effects` VALUES (340,'warriors_charge',@FLAG_ATTACK | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (341,'formless_strikes',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (342,'assassins_charge',@FLAG_ATTACK | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (343,'feint',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (344,'fealty',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (345,'dark_seal',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_MAGIC_END,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (346,'diabolic_eye',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (347,'nightingale',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (348,'troubadour',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (349,'killer_instinct',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (350,'stealth_shot',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (351,'flashy_shot',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (352,'sange',@FLAG_DEATH | @FLAG_ON_ZONE,73,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (353,'hasso',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,353,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (354,'seigan',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE,353,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (355,'convergence',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (356,'diffusion',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (357,'snake_eye',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (358,'light_arts',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (359,'dark_arts',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (360,'penury',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (361,'parsimony',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (362,'celerity',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (363,'alacrity',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (364,'rapture',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (365,'ebullience',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (366,'accession',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (367,'manifestation',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (368,'drain_samba',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,368,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (369,'aspir_samba',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,368,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (370,'haste_samba',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,368,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (371,'velocity_shot',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (375,'building_flourish',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (376,'trance',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (377,'tabula_rasa',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (378,'drain_daze',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (379,'aspir_daze',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (380,'haste_daze',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (381,'finishing_move',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (382,'finishing_move',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (383,'finishing_move',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (384,'finishing_move',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (385,'finishing_move',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (386,'lethargic_daze_1',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (387,'lethargic_daze_2',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (388,'lethargic_daze_3',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (389,'lethargic_daze_4',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (390,'lethargic_daze_5',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (391,'sluggish_daze_1',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (392,'sluggish_daze_2',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (393,'sluggish_daze_3',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (394,'sluggish_daze_4',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (395,'sluggish_daze_5',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (396,'weakened_daze_1',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (397,'weakened_daze_2',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (398,'weakened_daze_3',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (399,'weakened_daze_4',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (400,'weakened_daze_5',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (401,'addendum_white',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (402,'addendum_black',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (403,'reprisal',@FLAG_DISPELABLE | @FLAG_DEATH,34,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (404,'magic_evasion_down',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_WALTZABLE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (405,'retaliation',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (406,'footwork',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (407,'klimaform',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (408,'sekkanoki',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (409,'pianissimo',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (410,'saber_dance',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (411,'fan_dance',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (412,'altruism',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (413,'focalization',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (414,'tranquility',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (415,'equanimity',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (416,'enlightenment',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (417,'afflatus_solace',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (418,'afflatus_misery',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (419,'composure',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (420,'yonin',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,420,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (421,'innin',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,420,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (422,'carbuncles_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (423,'ifrits_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (424,'shivas_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (425,'garudas_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (426,'titans_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (427,'ramuhs_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (428,'leviathans_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (429,'fenrirs_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (430,'diaboloss_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (431,'avatars_favor',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_OFFLINE_TICK | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (432,'multi_strikes',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (433,'double_shot',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (434,'transcendency',@FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (435,'restraint',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (436,'perfect_counter',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (437,'mana_wall',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (438,'divine_emblem',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (439,'nether_void',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (440,'sengikori',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (441,'futae',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (442,'presto',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (443,'climactic_flourish',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (444,'copy_image',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,36,0,0,0,0,0,0,50,NULL); INSERT INTO `status_effects` VALUES (445,'copy_image',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,36,0,0,0,0,0,0,50,NULL); INSERT INTO `status_effects` VALUES (446,'copy_image',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,36,0,0,0,0,0,0,50,NULL); INSERT INTO `status_effects` VALUES (447,'multi_shots',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (448,'bewildered_daze_1',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (449,'bewildered_daze_2',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (450,'bewildered_daze_3',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (451,'bewildered_daze_4',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (452,'bewildered_daze_5',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (453,'divine_caress',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (454,'saboteur',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (455,'tenuto',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (456,'spur',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (457,'efflux',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (458,'earthen_armor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (459,'divine_caress',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (460,'blood_rage',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,68,0,0,0,NULL); INSERT INTO `status_effects` VALUES (461,'impetus',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (462,'conspirator',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (463,'sepulcher',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (464,'arcane_crest',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (465,'hamanoha',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (466,'dragon_breaker',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (467,'triple_shot',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (468,'striking_flourish',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (469,'perpetuance',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (470,'immanence',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (471,'migawari',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (472,'ternary_flourish',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (473,'muddle',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (474,'prowess',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (475,'voidwatcher',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (476,'ensphere',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (477,'sacrosanctity',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (478,'palisade',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (479,'scarlet_delirium',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (480,'scarlet_delirium',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (481,'abdhaljs_seal',@FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (482,'decoy_shot',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,482,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (483,'hagakure',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (484,'issekigan',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (485,'unbridled_learning',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (486,'counter_boost',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (487,'endrain',@FLAG_DEATH | @FLAG_ON_ZONE,94,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (488,'enaspir',@FLAG_DEATH | @FLAG_ON_ZONE,94,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (489,'afterglow',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (490,'brazen_rush',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (491,'inner_strength',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (492,'asylum',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (493,'subtle_sorcery',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (494,'stymie',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (495,'macro_test',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_LOSS_MESSAGE | @FLAG_HIDE_TIMER | @FLAG_ALWAYS_EXPIRING,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (496,'intervene',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (497,'soul_enslavement',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (498,'unleash',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (499,'clarion_call',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (500,'overkill',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (501,'yaegasumi',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (502,'mikage',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (503,'fly_high',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (504,'astral_conduit',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (505,'unbridled_wisdom',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (506,'grace',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (507,'grand_pas',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (508,'widened_compass',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (509,'odyllic_subterfuge',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (510,'ergon_might',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (511,'reive_mark',@FLAG_DEATH | @FLAG_CONFRONTATION | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (512,'ionis',@FLAG_INFLUENCE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (513,'bolster',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (515,'lasting_emanation',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (516,'ecliptic_attrition',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (517,'collimated_fervor',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (518,'dematerialize',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (519,'theurgic_focus',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (522,'elemental_sforzo',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (523,'ignis',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (524,'gelus',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (525,'flabra',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (526,'tellus',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (527,'sulpor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (528,'unda',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (529,'lux',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (530,'tenebrae',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,4,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (531,'vallation',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (532,'swordplay',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (533,'pflug',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (534,'emboldened',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (535,'valiance',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,531,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (536,'gambit',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_NO_CANCEL,0,0,2,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (537,'liement',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (538,'one_for_all',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (539,'geo_regen',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (540,'geo_poison',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (541,'geo_refresh',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (542,'geo_str_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (543,'geo_dex_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (544,'geo_vit_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (545,'geo_agi_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (546,'geo_int_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (547,'geo_mnd_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (548,'geo_chr_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (549,'geo_attack_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (550,'geo_defense_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (551,'geo_magic_atk_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (552,'geo_magic_def_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (553,'geo_accuracy_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (554,'geo_evasion_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (555,'geo_magic_acc_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (556,'geo_magic_evasion_boost',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (557,'geo_attack_down',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (558,'geo_defense_down',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (559,'geo_magic_atk_down',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (560,'geo_magic_def_down',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (561,'geo_accuracy_down',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (562,'geo_evasion_down',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (563,'geo_magic_acc_down',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (564,'geo_magic_evasion_down',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (565,'geo_slow',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (566,'geo_paralysis',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (567,'geo_weight',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (568,'foil',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (569,'blaze_of_glory',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (570,'battuta',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (571,'rayke',@FLAG_ERASABLE | @FLAG_DEATH | @FLAG_NO_CANCEL,0,0,2,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (572,'avoidance_down',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (573,'deluge_spikes',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,6,0,800,NULL); INSERT INTO `status_effects` VALUES (574,'fast_cast',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (575,'gestation',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (576,'doubt',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (577,'cait_siths_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (578,'fishy_intuition',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (579,'commitment',@FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (580,'geo_haste',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (581,'flurry_ii',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (582,'contradance',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (583,'apogee',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_BLOODPACT | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (584,'entrust',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (585,'costume',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,204); INSERT INTO `status_effects` VALUES (586,'curing_conduit',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (587,'tp_bonus',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (588,'finishing_move',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (589,'firestorm_ii',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (590,'hailstorm_ii',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (591,'windstorm_ii',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (592,'sandstorm_ii',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (593,'thunderstorm_ii',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (594,'rainstorm_ii',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (595,'aurorastorm_ii',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (596,'voidstorm_ii',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (597,'inundation',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (598,'cascade',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (599,'consume_mana',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (600,'runeists_roll',@FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ROLL | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (601,'crooked_cards',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (602,'vorseal',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (603,'elvorseal',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (604,'mighty_guard',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (605,'gale_spikes',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,34,0,0,0,0,3,0,800,NULL); INSERT INTO `status_effects` VALUES (606,'clod_spikes',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,34,0,0,0,0,4,0,800,NULL); INSERT INTO `status_effects` VALUES (607,'glint_spikes',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,34,0,0,0,0,7,0,800,NULL); INSERT INTO `status_effects` VALUES (608,'negate_virus',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (609,'negate_curse',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (610,'negate_charm',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (611,'magic_evasion_boost_ii',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (612,'colure_active',@FLAG_ON_ZONE | @FLAG_LOGOUT | @FLAG_NO_CANCEL,0,0,3,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (613,'mumors_radiance',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (614,'ullegores_gloom',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (615,'boost_ii',@FLAG_ATTACK | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (616,'artisanal_knowledge',@FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (617,'sacrifice',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (618,'emporoxs_gift',@FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (619,'spirit_bond',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (620,'awaken',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (621,'majesty',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (622,'guarding_rate_boost',@FLAG_DISPELABLE | @FLAG_EMPATHY | @FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (623,'rampart',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_LOGOUT | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (624,'winds_blessing',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (625,'sirens_favor',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (626,'negate_sleep',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (627,'mobilization',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_ON_JOBCHANGE | @FLAG_ON_ATTACK,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (628,'hover_shot',@FLAG_DISPELABLE | @FLAG_DEATH | @FLAG_ON_ZONE,482,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (629,'moogle_amplifier',@FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (630,'taint',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (631,'haunt',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (632,'black_sanctus',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (633,'animated',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (634,'serpents_guile',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (635,'resolved',@FLAG_ON_ZONE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); -- TODO: flags need review INSERT INTO `status_effects` VALUES (768,'abyssea_str',@FLAG_ON_ZONE,0,0,0,0,0,1,0,0,NULL); INSERT INTO `status_effects` VALUES (769,'abyssea_dex',@FLAG_ON_ZONE,0,0,0,0,0,5,0,0,NULL); INSERT INTO `status_effects` VALUES (770,'abyssea_vit',@FLAG_ON_ZONE,0,0,0,0,0,4,0,0,NULL); INSERT INTO `status_effects` VALUES (771,'abyssea_agi',@FLAG_ON_ZONE,0,0,0,0,0,3,0,0,NULL); INSERT INTO `status_effects` VALUES (772,'abyssea_int',@FLAG_ON_ZONE,0,0,0,0,0,2,0,0,NULL); INSERT INTO `status_effects` VALUES (773,'abyssea_mnd',@FLAG_ON_ZONE,0,0,0,0,0,6,0,0,NULL); INSERT INTO `status_effects` VALUES (774,'abyssea_chr',@FLAG_ON_ZONE,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (775,'abyssea_hp',@FLAG_ON_ZONE,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (776,'abyssea_mp',@FLAG_ON_ZONE,0,0,0,0,0,8,0,0,NULL); INSERT INTO `status_effects` VALUES (777,'prowess_casket_rate',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (778,'prowess_skill_rate',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (779,'prowess_crystal_yeild',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (780,'prowess_th',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (781,'prowess_attack_speed',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (782,'prowess_hp_mp',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (783,'prowess_acc_racc',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (784,'prowess_att_ratt',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (785,'prowess_macc_matk',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (786,'prowess_cure_potency',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (787,'prowess_ws_dmg',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (788,'prowess_killer',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (790,'mark_of_seed',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (791,'all_miss',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (792,'super_buff',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (793,'ninjutsu_ele_debuff',@FLAG_DEATH | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (794,'healing',@FLAG_ATTACK | @FLAG_DAMAGE | @FLAG_DEATH | @FLAG_MAGIC_BEGIN | @FLAG_ON_ZONE | @FLAG_LOGOUT,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (795,'leavegame',@FLAG_ATTACK | @FLAG_DAMAGE | @FLAG_DEATH | @FLAG_MAGIC_BEGIN | @FLAG_ON_ZONE | @FLAG_LOGOUT,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (796,'haste_samba_haste',@FLAG_MAGIC_BEGIN | @FLAG_ON_ZONE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (797,'teleport',@FLAG_DEATH | @FLAG_ON_JOBCHANGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (798,'chainbound',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (799,'skillchain',@FLAG_DEATH,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (800,'dynamis',@FLAG_OFFLINE_TICK,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (801,'meditate',@FLAG_DEATH | @FLAG_ON_ZONE,0,0,0,0,0,7,0,0,NULL); INSERT INTO `status_effects` VALUES (802,'elemental_resistance_down',@FLAG_DEATH | @FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (803,'full_speed_ahead',@FLAG_ON_ZONE | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (805,'tomahawk',@FLAG_DEATH | @FLAG_NO_LOSS_MESSAGE,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (807,'trust_aura_chr',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (808,'trust_aura_haste',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (809,'trust_aura_exp',@FLAG_DEATH | @FLAG_NO_CANCEL,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (810,'trust_aura_acc',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (811,'trust_aura_refresh',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (812,'trust_aura_regen',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); INSERT INTO `status_effects` VALUES (813,'trust_aura_magic_attack',@FLAG_DEATH | @FLAG_NO_CANCEL | @FLAG_HIDE_TIMER,0,0,0,0,0,0,0,0,NULL); /*!40000 ALTER TABLE `status_effects` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;