createeventquestlootinginfo.sql

来自「天之炼狱OpenDE_SQL.tar.gz」· SQL 代码 · 共 758 行 · 第 1/5 页

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    : CreateEventQuestLootingInfo.sql
#  Description : 涅胶飘 捞亥飘矫 漂沥 酒捞袍 风泼犬伏钎
#
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS EventQuestLootingInfo;
CREATE TABLE EventQuestLootingInfo
(
 	ID				int				NOT NULL	auto_increment,
 	QuestLevel		smallint(5)		NOT NULL	DEFAULT 0,
	LootingType		enum ('ZONE','MONSTER','BOTH','NONE')
									NOT NULL	DEFAULT 'NONE',
	LootingZone		smallint(5)		NOT NULL	DEFAULT 0,
	LootingMType	smallint(5)		NOT NULL	DEFAULT 0,
	LootingIClass	smallint(5)		NOT NULL	DEFAULT 0,
	LootingITypeMin	smallint(5)		NOT NULL	DEFAULt 0,
	LootingITypeMax smallint(5)		NOT NULL	DEFAULT 0,

	Race			tinyint(3)		NOT NULL	DEFAULT 0,
	MinGrade		smallint(5)		NOT NULL	DEFAULT 0,
	MaxGrade		smallint(5)		NOT NULL	DEFAULt 0,

	PRIMARY KEY (ID)
);

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

INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 660, 53, 11, 11, 0, 30, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 661, 53, 12, 12, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 662, 53, 13, 13, 0, 96, 130);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 663, 53, 14, 14, 0, 131, 170);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 664, 53, 15, 15, 0, 171, 210);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 665, 53, 16, 16, 0, 211, 240);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 666, 53, 17, 17, 0, 241, 270);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 667, 53, 18, 18, 0, 271, 290);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 668, 53, 19, 19, 0, 291, 300);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 669, 53, 20, 20, 0, 301, 885);

INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 12, 0, 47, 29, 40, 0, 30, 130);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 1002, 0, 47, 29, 40, 0, 131, 210);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 33, 0, 47, 29, 40, 0, 211, 270);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 53, 0, 47, 29, 40, 0, 271, 299);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 1121, 0, 47, 29, 40, 0, 300, 885);

INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 660, 53, 11, 11, 1, 1, 10);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 661, 53, 12, 12, 1, 11, 20);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 662, 53, 13, 13, 1, 21, 30);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 663, 53, 14, 14, 1, 31, 40);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 664, 53, 15, 15, 1, 41, 50);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 665, 53, 16, 16, 1, 51, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 666, 53, 17, 17, 1, 61, 70);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 667, 53, 18, 18, 1, 71, 80);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 668, 53, 19, 19, 1, 81, 90);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 669, 53, 20, 20, 1, 91, 150);

INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 23, 0, 47, 29, 40, 1, 1, 30);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 22, 0, 47, 29, 40, 1, 31, 50);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 34, 0, 47, 29, 40, 1, 51, 70);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 1126, 0, 47, 29, 40, 1, 71, 90);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 1124, 0, 47, 29, 40, 1, 91, 150);

INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 660, 53, 11, 11, 2, 1, 10);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 661, 53, 12, 12, 2, 11, 20);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 662, 53, 13, 13, 2, 21, 30);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 663, 53, 14, 14, 2, 31, 40);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 664, 53, 15, 15, 2, 41, 50);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 665, 53, 16, 16, 2, 51, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 666, 53, 17, 17, 2, 61, 70);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 667, 53, 18, 18, 2, 71, 80);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 668, 53, 19, 19, 2, 81, 90);
INSERT INTO EventQuestLootingInfo VALUES (0, 1, 'MONSTER', 0, 669, 53, 20, 20, 2, 91, 150);

INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 81, 0, 47, 29, 40, 2, 1, 30);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 32, 0, 47, 29, 40, 2, 31, 50);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 44, 0, 47, 29, 40, 2, 51, 70);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 53, 0, 47, 29, 40, 2, 71, 90);
INSERT INTO EventQuestLootingInfo VALUES (0, 3, 'ZONE', 1125, 0, 47, 29, 40, 2, 91, 150);

INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 5, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 38, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 39, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 40, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 41, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 42, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 43, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 44, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 45, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 46, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 7, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 56, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 57, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 58, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 59, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 60, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 61, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 62, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 63, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 64, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 4, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 29, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 30, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 31, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 32, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 33, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 34, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 35, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 36, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 37, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 6, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 47, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 48, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 49, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 50, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 51, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 52, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 53, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 54, 53, 22, 26, 0, 10, 60);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 55, 53, 22, 26, 0, 10, 60);

INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 9, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 74, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 75, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 76, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 77, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 78, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 79, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 80, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 81, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 82, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 8, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 65, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 66, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 67, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 68, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 69, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 70, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 71, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 72, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 73, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 106, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 129, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 130, 53, 22, 26, 0, 61, 95);
INSERT INTO EventQuestLootingInfo VALUES (0, 4, 'MONSTER', 0, 131, 53, 22, 26, 0, 61, 95);