createoptionclassinfo.sql

天之炼狱OpenDE_SQL.tar.gz

-- MySQL dump 8.22
--
-- Host: 61.78.53.167    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.54-log

--
-- Table structure for table 'OptionClassInfo'
--

DROP TABLE IF EXISTS OptionClassInfo;
CREATE TABLE OptionClassInfo (
  OptionClassType int(11) NOT NULL default '0',
  Name varchar(50) NOT NULL default '',
  HName varchar(50) NOT NULL default '',

  Level					int(11)		NOT NULL default 0, # 可记狼 鞭荐
  TotalGrade			int(11)		NOT NULL default 0,	# 可记狼 醚 窜拌 荐
  OptionGroup			smallint(5)	NOT NULL default 0,	# 可记狼 弊缝盒幅
  PRIMARY KEY  (OptionClassType)
) TYPE=MyISAM;

--
-- Dumping data for table 'OptionClassInfo'
--


INSERT INTO OptionClassInfo VALUES (0,'STR','力量', 1, 5, 0);
INSERT INTO OptionClassInfo VALUES (1,'DEX','敏捷', 2, 5, 0);
INSERT INTO OptionClassInfo VALUES (2,'INT','智力', 1, 5, 0);
INSERT INTO OptionClassInfo VALUES (3,'HP','HP', 2, 5, 1);
INSERT INTO OptionClassInfo VALUES (4,'MP','MP', 1, 5, 1);
INSERT INTO OptionClassInfo VALUES (5,'HP Steal','吸收HP', 3, 3, 4);
INSERT INTO OptionClassInfo VALUES (6,'MP Steal','吸收MP', 3, 3, 4);
INSERT INTO OptionClassInfo VALUES (7,'HP Regeneration','HP再生力', 0, 3, 4);
INSERT INTO OptionClassInfo VALUES (8,'MP Regeneration','MP再生力', 0, 3, 4);
INSERT INTO OptionClassInfo VALUES (9,'ToHit','命中率', 1, 5, 1);
INSERT INTO OptionClassInfo VALUES (10,'Defense','回避', 1, 5, 1);
INSERT INTO OptionClassInfo VALUES (11,'Damage','损害', 2, 5, 2);
INSERT INTO OptionClassInfo VALUES (12,'Protection','防御', 1, 5, 1);
INSERT INTO OptionClassInfo VALUES (13,'Durability','耐久性', 1, 5, 4);
INSERT INTO OptionClassInfo VALUES (14,'Poison Resistance','对毒魔法的抵抗力', 2, 3, 3);
INSERT INTO OptionClassInfo VALUES (15,'Acid Resistance',' 对酸魔法的抵抗力', 2, 3, 3);
INSERT INTO OptionClassInfo VALUES (16,'Curse Resistance',' 对诅咒魔法的抵抗力', 2, 3, 3);
INSERT INTO OptionClassInfo VALUES (17,'Blood Resistance',' 对血魔法的抵抗力', 2, 3, 3);
INSERT INTO OptionClassInfo VALUES (18,'Vision','视野', 0, 3, 4);
INSERT INTO OptionClassInfo VALUES (19,'Attack Speed','攻击速度', 2, 5, 2);
INSERT INTO OptionClassInfo VALUES (20,'Critical Hit','有效打击', 0, 5, 2);
INSERT INTO OptionClassInfo VALUES (21,'Luck','幸运', 4, 3, 4);
INSERT INTO OptionClassInfo VALUES (22,'All Registance','抵抗力总和', 4, 5, 3);
INSERT INTO OptionClassInfo VALUES (23,'All Attributes','能力值总和', 4, 3, 0);

INSERT INTO OptionClassInfo VALUES (24, "Ater Balance", "力量转换为敏捷", 0,1,5);
INSERT INTO OptionClassInfo VALUES (25, "Ianthinus Balance", "力量转换为智力", 0,1,5);
INSERT INTO OptionClassInfo VALUES (26, "Croceus Balance", "敏捷转换为力量", 0,1,5);
INSERT INTO OptionClassInfo VALUES (27, "Cyan Balance", "敏捷转换为智力", 0,1,5);
INSERT INTO OptionClassInfo VALUES (28, "Magenta Balance", "智力转换为力量", 0,1,5);
INSERT INTO OptionClassInfo VALUES (29, "Glaucus Balance", "智力转换为敏捷", 0,1,5);

INSERT INTO OptionClassInfo VALUES (30, "Cosume MP", "MP 家葛樊", 0,1,5);
INSERT INTO OptionClassInfo VALUES (31, "Translation", "烹开", 0,1,5);
INSERT INTO OptionClassInfo VALUES (32, "Magic Damage", "付过 单固瘤", 0,1,5);
INSERT INTO OptionClassInfo VALUES (33, "Physical Damage", "拱府 单固瘤", 0,1,5);
INSERT INTO OptionClassInfo VALUES (34, "Gamble Price", "白喉 啊拜", 0,1,5);
INSERT INTO OptionClassInfo VALUES (35, "Potion Price", "器记(趋没) 啊拜", 0,1,5);