createdirectiveset.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Game Info
#
#  FileName    : CreateDirectiveSet.sql
#  Description : 阁胶磐 牢傍瘤瓷包访 何盒
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS DirectiveSet;

CREATE TABLE DirectiveSet (
  ID int(10) unsigned NOT NULL default '0',
  Name varchar(30) NOT NULL default '',
  Content text NOT NULL,
  DeadContent text NOT NULL,

  Primary Key(ID)

) TYPE=MyISAM;


################################################################################
# 牢郸胶 积己



################################################################################
# Sequence 积己



################################################################################
# 鼻茄 汲沥 



################################################################################
# 单捞磐 持扁
INSERT INTO DirectiveSet VALUES (0,'Dead Body','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (1,'Turning Dead','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:ImDying)
	(ACTION:Flee)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (3,'Turning Soul','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (2,'Kid','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:ImDying)
	(ACTION:Flee)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (4,'Soldier','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (5,'Captain','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (7,'Alkan','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:ImDying)
	(ACTION:Flee)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ACID_TOUCH,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotGreenPoisoned)
	(ACTION:UseSkill,SKILL_GREEN_POISON,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (20,'Iron Teeth','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (9,'Red Eye','
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ACID_TOUCH,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotGreenPoisoned)
	(ACTION:UseSkill,SKILL_GREEN_POISON,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotYellowPoisoned)
	(ACTION:UseSkill,SKILL_YELLOW_POISON,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (14,'Mutant','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_GREEN_POISON,100)
DIRECTIVE END
');
INSERT INTO DirectiveSet VALUES (15,'Moderas','
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ACID_TOUCH,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotGreenPoisoned)
	(ACTION:UseSkill,SKILL_GREEN_POISON,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotInDarkness)
	(ACTION:UseSkill,SKILL_DARKNESS,10)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:UseSkill,SKILL_ACID_BOLT,10)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (18,'Vandalizer','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (10,'Dirty Strider','
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ACID_TOUCH,50)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotParalyzed)
	(ACTION:UseSkill,SKILL_PARALYZE,10)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotGreenStalkered)
	(ACTION:UseSkill,SKILL_GREEN_STALKER,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotInDarkness)
	(ACTION:UseSkill,SKILL_DARKNESS,10)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (16,'Estroider','
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(CONDITION:ImBat)
	(ACTION:UseSkill,SKILL_UN_TRANSFORM,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:ImWalkingWall)
	(ACTION:UseSkill,SKILL_TRANSFORM_TO_BAT,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (17,'Widows','
DIRECTIVE BEGIN
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ACID_TOUCH,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotGreenPoisoned)
	(ACTION:UseSkill,SKILL_GREEN_POISON,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:UseSkill,SKILL_ACID_BOLT,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (12,'Hoble','
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(CONDITION:ImHiding)
	(ACTION:UseSkill,SKILL_UN_BURROW,90)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:TimingBloodDrain)
	(ACTION:UseSkill,SKILL_BLOOD_DRAIN,30)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ACID_TOUCH,20)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMelee)
	(ACTION:UseSkill,SKILL_ATTACK_MELEE,100)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:UseSkill,SKILL_ACID_BOLT,50)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotGreenStalkered)
	(ACTION:UseSkill,SKILL_GREEN_STALKER,10)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotDarkbluePoisoned)
	(ACTION:UseSkill,SKILL_DARKBLUE_POISON,10)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(CONDITION:EnemyNotParalyzed)
	(ACTION:UseSkill,SKILL_PARALYZE,10)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeMissile)
	(ACTION:Approach)
DIRECTIVE END
DIRECTIVE BEGIN
	(CONDITION:EnemyRangeOutOfSight)
	(ACTION:Forget)
DIRECTIVE END
','');
INSERT INTO DirectiveSet VALUES (19,'BigFang','
DIRECTIVE BEGIN