createzoneeffectinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    : CreateZoneEffectInfo.sql
#  Description : 
#
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS ZoneEffectInfo;
CREATE TABLE ZoneEffectInfo (
	ID				int(10)		not null	default 0,
	ZoneID			smallint	not null	default 0,
	EffectID		int(10)		not null	default 0,
	LeftX			int(10)		not null	default 0,
	TopY        	int(10)		not null	default 0,
	RightX			int(10)		not null	default 0,
	BottomY			int(10)		not null	default 0,
	Value1			int(10)		not null	default 0,
	Value2			int(10)		not null	default 0,
	Value3			int(10)		not null	default 0,
	
	PRIMARY KEY			(ID),
	KEY IDX_ZONEID		(ZoneID),
	KEY IDX_EFFECTID	(EffectID)
) TYPE=MyISAM;


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

INSERT INTO ZoneEffectInfo VALUES ( 1, 3001,  26,  32,  20,  35,  23, 300,  50,    5 );	# Green Poison  瘤加矫埃 30檬, 5檬寸 5 单固瘤
INSERT INTO ZoneEffectInfo VALUES ( 2, 3001,  27,  62,  32,  65,  35, 100,   0,    0 );	# Yellow Poison 瘤加矫埃 10檬
INSERT INTO ZoneEffectInfo VALUES ( 3, 3001,  29,  38,  38,  53,  53,   0,   0,    0 );	# Darkness
INSERT INTO ZoneEffectInfo VALUES ( 4, 3001,  31,  24,  94,  27,  95,   0,  15, 1000 );	# Acid Swamp	1.5檬寸 1000 单固瘤
INSERT INTO ZoneEffectInfo VALUES ( 5, 3001,  31,  28,  92,  29,  93,   0,  15, 1000 );	# Acid Swamp	1.5檬寸 1000 单固瘤
INSERT INTO ZoneEffectInfo VALUES ( 6, 3001, 242,  68,  68,  71,  71, 150,   0,    0 );	# Ice Field		瘤加矫埃 15檬
INSERT INTO ZoneEffectInfo VALUES ( 7, 3001, 249,  14,  52,  17,  55,   0,  10,    2 );	# Prominence	1檬寸 2单固瘤
INSERT INTO ZoneEffectInfo VALUES ( 8, 3001, 261,  58,  92,  58,  95,  30,  10, 1000 );	# Continual Bloody Wall	3檬付促 affect, 1000 单固瘤