· 8 years ago · Jun 29, 2018, 08:36 AM
1--Author Sonsen AGN Silentera Beta---
2SET FOREIGN_KEY_CHECKS=0;
3-- ----------------------------
4-- Table structure for `droplistxp`
5-- ----------------------------
6DROP TABLE IF EXISTS `droplistxp`;
7CREATE TABLE `droplistxp` (
8 `Id` int(11) NOT NULL AUTO_INCREMENT,
9 `mobId` int(11) NOT NULL DEFAULT '0',
10 `itemId` int(11) NOT NULL DEFAULT '0',
11 `min` int(11) NOT NULL DEFAULT '0',
12 `max` int(11) NOT NULL DEFAULT '0',
13 `chance` float NOT NULL DEFAULT '0',
14 PRIMARY KEY (`Id`)
15) ENGINE=InnoDB AUTO_INCREMENT=1097 DEFAULT CHARSET=utf8;
16
17-- ----------------------------
18-- Records of droplistxp
19-- ----------------------------
20INSERT INTO `droplistxp` VALUES ('160000', '216276', '182400001', '1439', '12269', '95.45');
21INSERT INTO `droplistxp` VALUES ('160001', '216276', '182006270', '1', '1', '50');
22INSERT INTO `droplistxp` VALUES ('160002', '216276', '169000009', '1', '1', '13.64');
23INSERT INTO `droplistxp` VALUES ('160003', '216276', '167000549', '1', '1', '9.09');
24INSERT INTO `droplistxp` VALUES ('160004', '216276', '123000968', '1', '1', '4.55');
25INSERT INTO `droplistxp` VALUES ('160005', '216276', '152010319', '1', '1', '4.55');
26INSERT INTO `droplistxp` VALUES ('160006', '216276', '152011076', '1', '1', '4.55');
27INSERT INTO `droplistxp` VALUES ('160007', '216276', '167000543', '1', '1', '4.55');
28INSERT INTO `droplistxp` VALUES ('160008', '216276', '167000544', '1', '1', '4.55');
29INSERT INTO `droplistxp` VALUES ('160009', '216276', '167000548', '1', '1', '4.55');
30INSERT INTO `droplistxp` VALUES ('160010', '216276', '167000554', '1', '1', '4.55');
31INSERT INTO `droplistxp` VALUES ('160012', '216215', '182006234', '1', '1', '100');
32INSERT INTO `droplistxp` VALUES ('160013', '216215', '152011070', '1', '1', '50');
33INSERT INTO `droplistxp` VALUES ('160014', '216215', '167000545', '1', '1', '50');
34INSERT INTO `droplistxp` VALUES ('160015', '216273', '182005569', '1', '1', '85.71');
35INSERT INTO `droplistxp` VALUES ('160016', '216273', '152010319', '1', '1', '14.29');
36INSERT INTO `droplistxp` VALUES ('160017', '216273', '160003562', '1', '1', '14.29');
37INSERT INTO `droplistxp` VALUES ('160018', '216273', '167000544', '1', '1', '14.29');
38INSERT INTO `droplistxp` VALUES ('160019', '216273', '167000549', '1', '1', '14.29');
39INSERT INTO `droplistxp` VALUES ('160020', '216213', '182400001', '1860', '2104', '100');
40INSERT INTO `droplistxp` VALUES ('160021', '216213', '140000337', '1', '1', '33.33');
41INSERT INTO `droplistxp` VALUES ('160022', '216213', '152011065', '1', '1', '33.33');
42INSERT INTO `droplistxp` VALUES ('160023', '216213', '152011070', '1', '1', '33.33');
43INSERT INTO `droplistxp` VALUES ('160024', '216213', '167000556', '1', '1', '33.33');
44INSERT INTO `droplistxp` VALUES ('160025', '216213', '169000009', '1', '1', '33.33');
45INSERT INTO `droplistxp` VALUES ('160026', '216272', '182005569', '1', '1', '84');
46INSERT INTO `droplistxp` VALUES ('160027', '216272', '152010319', '1', '1', '20');
47INSERT INTO `droplistxp` VALUES ('160028', '216272', '167000548', '1', '1', '12');
48INSERT INTO `droplistxp` VALUES ('160029', '216272', '167000544', '1', '1', '8');
49INSERT INTO `droplistxp` VALUES ('160030', '216272', '167000549', '1', '1', '8');
50INSERT INTO `droplistxp` VALUES ('160031', '216272', '169000009', '1', '1', '8');
51INSERT INTO `droplistxp` VALUES ('160032', '216272', '152011065', '1', '1', '4');
52INSERT INTO `droplistxp` VALUES ('160033', '216272', '152011070', '1', '1', '4');
53INSERT INTO `droplistxp` VALUES ('160034', '216272', '152011071', '1', '1', '4');
54INSERT INTO `droplistxp` VALUES ('16005', '216272', '152011075', '1', '1', '4');
55INSERT INTO `droplistxp` VALUES ('160036', '216272', '162001009', '1', '1', '4');
56INSERT INTO `droplistxp` VALUES ('160037', '216272', '167000543', '1', '1', '4');
57INSERT INTO `droplistxp` VALUES ('160038', '216272', '167000550', '1', '1', '4');
58INSERT INTO `droplistxp` VALUES ('16009', '216272', '167000553', '1', '1', '4');
59INSERT INTO `droplistxp` VALUES ('160040', '216272', '167000560', '1', '1', '4');