createmonsterkillquestinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    : CreateMonsterKillQuestInfo.sql
#  Description : 缴敲 涅胶飘 沥焊
#
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS MonsterKillQuestInfo;
CREATE TABLE MonsterKillQuestInfo
(
	QuestID			int(10)			NOT NULL	DEFAULT 0,
	NPC				varchar(20)		NOT NULL	DEFAULT '',
	TargetSType		smallint(5)		NOT NULL	DEFAULT 0,
	IsChief			tinyint(3)		NOT NULL	DEFAULT 0,
	Goal			int(10)			NOT NULL	DEFAULT 0,
	TimeLimitSec	int(10)			NOT NULL	DEFAULT 0,

	Race			tinyint(3)		NOT NULL	DEFAULT 0,
	MinGrade		int(10)			NOT NULL	DEFAULT 0,
	MaxGrade		int(10)			NOT NULL	DEFAULT 0,

	RewardClass		int(10)			NOT NULL	DEFAULT 0,

	EventQuest		tinyint(3)		NOT NULL	DEFAULT 0,
	QuestLevel		smallint(5)		NOT NULL	DEFAULT 0,

	PRIMARY KEY (QuestID)
);

DROP TABLE IF EXISTS ItemRewardInfo;
CREATE TABLE ItemRewardInfo
(
	RewardClass		int(10)			NOT NULL	DEFAULT 0,
	NPC				varchar(20)		NOT NULL	DEFAULT '',
	RewardID		int(10)			NOT NULL	auto_increment,

	IClass			smallint(5)		NOT NULL	DEFAULT 0,
	IType			smallint(5)		NOT NULL	DEFAULT 0,
	OptionType		varchar(50)		NOT NULL	DEFAULT '',

	TimeLimitSec	int(10)			NOT NULL	DEFAULT 0,

	PRIMARY KEY (RewardID)
);

DROP TABLE IF EXISTS SlayerWeaponRewardInfo;
CREATE TABLE SlayerWeaponRewardInfo
(
	RewardClass		int(10)			NOT NULL	DEFAULT 0,
	NPC				varchar(20)		NOT NULL	DEFAULT '',
	RewardID		int(10)			NOT NULL	auto_increment,

	IClass			smallint(5)		NOT NULL	DEFAULT 14,
	IType			smallint(5)		NOT NULL	DEFAULT 0,
	OptionType		varchar(50)		NOT NULL	DEFAULT '',

	TimeLimitSec	int(10)			NOT NULL	DEFAULT 0,

	PRIMARY KEY (RewardID)
);

################################################################################
# 牢郸胶 积己
CREATE INDEX ItemRewardInfo_RewardClass ON ItemRewardInfo(RewardClass);

################################################################################
# 单捞磐 持扁

# 单靛官叼
INSERT INTO MonsterKillQuestInfo VALUES (1 ,'农府胶', 5, 0, 80, 1800, 0, 30, 70, 1, 0, 0);

INSERT INTO SlayerWeaponRewardInfo VALUES (1, '农府胶', 0, 14, 2, 'CRI+2', 3600);
INSERT INTO SlayerWeaponRewardInfo VALUES (1, '农府胶', 0, 15, 2, 'CRI+2', 3600);
INSERT INTO SlayerWeaponRewardInfo VALUES (1, '农府胶', 0, 22, 2, 'CRI+2', 3600);
INSERT INTO SlayerWeaponRewardInfo VALUES (1, '农府胶', 0, 35, 2, 'HP+2', 3600);
INSERT INTO SlayerWeaponRewardInfo VALUES (1, '农府胶', 0, 17, 2, 'HP+2', 3600);

# 磐醋单靛
INSERT INTO MonsterKillQuestInfo VALUES (2 ,'农府胶', 8, 0, 40, 1800, 0, 30, 70, 2, 0, 0);

INSERT INTO ItemRewardInfo VALUES (2, '农府胶', 0, 11, 4, 'VIS+1', 3600);
INSERT INTO ItemRewardInfo VALUES (2, '农府胶', 0, 12, 4, 'VIS+1', 3600);
INSERT INTO ItemRewardInfo VALUES (2, '农府胶', 0, 19, 2, 'HP+1', 3600);
INSERT INTO ItemRewardInfo VALUES (2, '农府胶', 0, 18, 2, 'MPSTL+2', 3600);
INSERT INTO ItemRewardInfo VALUES (2, '农府胶', 0, 13, 2, 'PORES+2', 3600);

# 虐靛
INSERT INTO MonsterKillQuestInfo VALUES (3 ,'农府胶', 6, 0, 20, 1800, 0, 30, 70, 3, 0, 0);

INSERT INTO ItemRewardInfo VALUES (3, '农府胶', 0, 8, 2, 'STR+2', 3600);
INSERT INTO ItemRewardInfo VALUES (3, '农府胶', 0, 10, 2, 'DEX+2', 3600);
INSERT INTO ItemRewardInfo VALUES (3, '农府胶', 0, 9, 2, 'HP+3', 3600);

# 舅沫
INSERT INTO MonsterKillQuestInfo VALUES (4 ,'农府胶', 42, 0, 50, 3600, 0, 71, 100, 4, 0, 0);

INSERT INTO SlayerWeaponRewardInfo VALUES (4, '农府胶', 0, 14, 4, 'CRI+2', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (4, '农府胶', 0, 15, 4, 'CRI+2', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (4, '农府胶', 0, 22, 4, 'CRI+2', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (4, '农府胶', 0, 35, 4, 'HP+2', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (4, '农府胶', 0, 17, 4, 'HP+2', 7200);

# 困档快令
INSERT INTO MonsterKillQuestInfo VALUES (5 ,'农府胶', 61, 0, 30, 3600, 0, 71, 100, 5, 0, 0);

INSERT INTO ItemRewardInfo VALUES (5, '农府胶', 0, 11, 6, 'VIS+1', 7200);
INSERT INTO ItemRewardInfo VALUES (5, '农府胶', 0, 12, 6, 'VIS+1', 7200);
INSERT INTO ItemRewardInfo VALUES (5, '农府胶', 0, 19, 3, 'HP+1', 7200);
INSERT INTO ItemRewardInfo VALUES (5, '农府胶', 0, 18, 3, 'MPSTL+2', 7200);
INSERT INTO ItemRewardInfo VALUES (5, '农府胶', 0, 13, 3, 'PORES+2', 7200);

# 孤畔飘
INSERT INTO MonsterKillQuestInfo VALUES (6 ,'农府胶', 60, 0, 40, 3600, 0, 71, 100, 6, 0, 0);

INSERT INTO ItemRewardInfo VALUES (6, '农府胶', 0, 8, 3, 'STR+2', 7200);
INSERT INTO ItemRewardInfo VALUES (6, '农府胶', 0, 10, 3, 'DEX+2', 7200);
INSERT INTO ItemRewardInfo VALUES (6, '农府胶', 0, 9, 3, 'HP+3', 7200);

# 农覆郊浇肺磐
INSERT INTO MonsterKillQuestInfo VALUES (7 ,'农府胶', 72, 0, 30, 3600, 0, 101, 130, 7, 0, 0);

INSERT INTO SlayerWeaponRewardInfo VALUES (7, '农府胶', 0, 14, 5, 'DAM+1', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (7, '农府胶', 0, 15, 5, 'DAM+1', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (7, '农府胶', 0, 22, 5, 'DAM+1', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (7, '农府胶', 0, 35, 5, 'HP+3', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (7, '农府胶', 0, 17, 5, 'HP+3', 7200);

# 墨坷胶唱捞飘
INSERT INTO MonsterKillQuestInfo VALUES (8 ,'农府胶', 71, 0, 20, 3600, 0, 101, 130, 8, 0, 0);

INSERT INTO ItemRewardInfo VALUES (8, '农府胶', 0, 11, 8, 'HPSTL+1', 7200);
INSERT INTO ItemRewardInfo VALUES (8, '农府胶', 0, 12, 8, 'HPSTL+1', 7200);
INSERT INTO ItemRewardInfo VALUES (8, '农府胶', 0, 19, 4, 'MP+4', 7200);
INSERT INTO ItemRewardInfo VALUES (8, '农府胶', 0, 18, 4, 'MPSTL+3', 7200);
INSERT INTO ItemRewardInfo VALUES (8, '农府胶', 0, 13, 4, 'ACRES+2', 7200);

# 府欺
INSERT INTO MonsterKillQuestInfo VALUES (9 ,'农府胶', 74, 0, 30, 3600, 0, 101, 130, 9, 0, 0);

INSERT INTO ItemRewardInfo VALUES (9, '农府胶', 0, 8, 4, 'ATTR+2', 7200);
INSERT INTO ItemRewardInfo VALUES (9, '农府胶', 0, 10, 4, 'DAM+2', 7200);
INSERT INTO ItemRewardInfo VALUES (9, '农府胶', 0, 9, 4, 'CURES+3', 7200);

# 墨坷胶啊叼攫
INSERT INTO MonsterKillQuestInfo VALUES (10 ,'农府胶', 47, 0, 30, 3600, 0, 131, 160, 10, 0, 0);

INSERT INTO SlayerWeaponRewardInfo VALUES (10, '农府胶', 0, 14, 6, 'DAM+1', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (10, '农府胶', 0, 15, 6, 'DAM+1', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (10, '农府胶', 0, 22, 6, 'DAM+1', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (10, '农府胶', 0, 35, 6, 'HP+3', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (10, '农府胶', 0, 17, 6, 'HP+3', 7200);

# 秋啊叼攫
INSERT INTO MonsterKillQuestInfo VALUES (11 ,'农府胶', 75, 0, 30, 3600, 0, 131, 160, 11, 0, 0);

INSERT INTO ItemRewardInfo VALUES (11, '农府胶', 0, 11, 10, 'HPSTL+1', 7200);
INSERT INTO ItemRewardInfo VALUES (11, '农府胶', 0, 12, 10, 'HPSTL+1', 7200);
INSERT INTO ItemRewardInfo VALUES (11, '农府胶', 0, 19, 5, 'MP+4', 7200);
INSERT INTO ItemRewardInfo VALUES (11, '农府胶', 0, 18, 5, 'MPSTL+3', 7200);
INSERT INTO ItemRewardInfo VALUES (11, '农府胶', 0, 13, 5, 'ACRES+2', 7200);

# 促农胶农府赣
INSERT INTO MonsterKillQuestInfo VALUES (12 ,'农府胶', 70, 0, 40, 3600, 0, 131, 160, 12, 0, 0);

INSERT INTO ItemRewardInfo VALUES (12, '农府胶', 0, 8,  6, 'ATTR+2', 7200);
INSERT INTO ItemRewardInfo VALUES (12, '农府胶', 0, 10, 6, 'DAM+2', 7200);
INSERT INTO ItemRewardInfo VALUES (12, '农府胶', 0, 9,  6, 'CURES+3', 7200);

# 肺靛促农聪胶
INSERT INTO MonsterKillQuestInfo VALUES (13 ,'农府胶', 73, 0, 30, 3600, 0, 161, 190, 13, 0, 0);

INSERT INTO SlayerWeaponRewardInfo VALUES (13, '农府胶', 0, 14, 8, 'DAM+2,HP+2', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (13, '农府胶', 0, 15, 8, 'DAM+2,HP+2', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (13, '农府胶', 0, 22, 8, 'DAM+2,HP+2', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (13, '农府胶', 0, 35, 7, 'HP+3,RES+4', 7200);
INSERT INTO SlayerWeaponRewardInfo VALUES (13, '农府胶', 0, 17, 7, 'HP+3,RES+4', 7200);

# 促农啊叼攫
INSERT INTO MonsterKillQuestInfo VALUES (14 ,'农府胶', 88, 0, 20, 3600, 0, 161, 190, 14, 0, 0);

INSERT INTO ItemRewardInfo VALUES (14, '农府胶', 0, 11, 12, 'BLRES+1,HP+3', 7200);
INSERT INTO ItemRewardInfo VALUES (14, '农府胶', 0, 12, 12, 'BLRES+1,HP+3', 7200);
INSERT INTO ItemRewardInfo VALUES (14, '农府胶', 0, 19, 6,  'BLRES+3,MPSTL+3', 7200);
INSERT INTO ItemRewardInfo VALUES (14, '农府胶', 0, 18, 6, 'CURES+3,DEF+4', 7200);
INSERT INTO ItemRewardInfo VALUES (14, '农府胶', 0, 13, 6, 'CURES+3,PRO+4', 7200);

# 肺靛墨坷胶
INSERT INTO MonsterKillQuestInfo VALUES (15 ,'农府胶', 89, 0, 30, 3600, 0, 161, 190, 15, 0, 0);

INSERT INTO ItemRewardInfo VALUES (15, '农府胶', 0, 8,  7, 'ATTR+2,RES+4', 7200);
INSERT INTO ItemRewardInfo VALUES (15, '农府胶', 0, 10, 7, 'DAM+3,ASPD+4', 7200);
INSERT INTO ItemRewardInfo VALUES (15, '农府胶', 0, 9,  7, 'HP+4,LUCK+3', 7200);

# 墨坷胶弊府靛
INSERT INTO MonsterKillQuestInfo VALUES (16 ,'农府胶', 90, 0, 40, 7200, 0, 191, 215, 16, 0, 0);

INSERT INTO SlayerWeaponRewardInfo VALUES (16, '农府胶', 0, 14, 9, 'DAM+2,HP+3', 14400);