forked from adrianopteodoro/dboserver
-
Notifications
You must be signed in to change notification settings - Fork 4
/
dbogamedata.sql
154 lines (107 loc) · 11.8 KB
/
dbogamedata.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
/*
SQLyog Community v12.2.2 (64 bit)
MySQL - 5.7.12-log : Database - dbogamedata
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`dbogamedata` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `dbogamedata`;
/*Table structure for table `pcdata` */
DROP TABLE IF EXISTS `pcdata`;
CREATE TABLE `pcdata` (
`pcID` bigint(20) NOT NULL,
`Race` int(11) NOT NULL,
`Gender` int(11) NOT NULL,
`Class` int(11) NOT NULL,
`PriorClassID` int(11) NOT NULL,
`ClassBitFlag` bigint(20) NOT NULL,
`BaseLP` int(11) NOT NULL,
`BaseEP` int(11) NOT NULL,
`BaseRP` int(11) NOT NULL,
`BasePhysicalOffence` int(11) NOT NULL,
`BasePhysicalDefence` int(11) NOT NULL,
`BaseEnergyOffence` int(11) NOT NULL,
`BaseEnergyDefence` int(11) NOT NULL,
`BaseStr` int(11) NOT NULL,
`BaseCon` int(11) NOT NULL,
`BaseFoc` int(11) NOT NULL,
`BaseDex` int(11) NOT NULL,
`BaseSol` int(11) NOT NULL,
`BaseEng` int(11) NOT NULL,
`LevelUpLP` float(11,6) NOT NULL,
`LevelUpEP` float(11,6) NOT NULL,
`LevelUpRP` float(11,6) NOT NULL,
`LevelUpPhysicalOffence` float(11,6) NOT NULL,
`LevelUpPhysicalDefence` float(11,6) NOT NULL,
`LevelUpEnergyOffence` float(11,6) NOT NULL,
`LevelUpEnergyDefence` float(11,6) NOT NULL,
`LevelUpStr` float(11,6) NOT NULL,
`LevelUpCon` float(11,6) NOT NULL,
`LevelUpFoc` float(11,6) NOT NULL,
`LevelUpDex` float(11,6) NOT NULL,
`LevelUpSol` float(11,6) NOT NULL,
`LevelUpEng` float(11,6) NOT NULL,
`Scale` int(11) NOT NULL,
`ChildRunSpeedOrigin` float(11,6) NOT NULL,
`ChildRunSpeed` int(11) NOT NULL,
`AdultRunSpeedOrigin` float(11,6) NOT NULL,
`AdultRunSpeed` int(11) NOT NULL,
`Radius` float(11,6) NOT NULL,
`AttackSpeedRate` int(11) NOT NULL,
`AttackType` int(11) NOT NULL,
`AttackRange` int(11) NOT NULL,
`BaseAttackRate` int(11) NOT NULL,
`BaseDodgeRate` int(11) NOT NULL,
`BaseBlockRate` int(11) NOT NULL,
`BaseCurseSuccessRate` int(11) NOT NULL,
`BaseCurseToleranceRate` int(11) NOT NULL,
`BaseAggroPoint` int(11) NOT NULL,
PRIMARY KEY (`pcID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `pcdata` */
insert into `pcdata`(`pcID`,`Race`,`Gender`,`Class`,`PriorClassID`,`ClassBitFlag`,`BaseLP`,`BaseEP`,`BaseRP`,`BasePhysicalOffence`,`BasePhysicalDefence`,`BaseEnergyOffence`,`BaseEnergyDefence`,`BaseStr`,`BaseCon`,`BaseFoc`,`BaseDex`,`BaseSol`,`BaseEng`,`LevelUpLP`,`LevelUpEP`,`LevelUpRP`,`LevelUpPhysicalOffence`,`LevelUpPhysicalDefence`,`LevelUpEnergyOffence`,`LevelUpEnergyDefence`,`LevelUpStr`,`LevelUpCon`,`LevelUpFoc`,`LevelUpDex`,`LevelUpSol`,`LevelUpEng`,`Scale`,`ChildRunSpeedOrigin`,`ChildRunSpeed`,`AdultRunSpeedOrigin`,`AdultRunSpeed`,`Radius`,`AttackSpeedRate`,`AttackType`,`AttackRange`,`BaseAttackRate`,`BaseDodgeRate`,`BaseBlockRate`,`BaseCurseSuccessRate`,`BaseCurseToleranceRate`,`BaseAggroPoint`) values
(1,0,0,0,-1,1,10,10,100,6,5,5,4,13,9,9,13,9,7,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.150000,1.000000,1.000000,1.100000,0.850000,0.900000,1,5.384615,7,7.272727,8,0.500000,1000,0,1,110,110,30,90,90,10),
(2,0,1,0,-1,1,10,10,100,6,5,5,4,13,9,9,13,9,7,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.150000,1.000000,1.000000,1.100000,0.850000,0.900000,1,5.000000,7,7.272727,8,0.500000,1000,0,1,110,110,30,90,90,10),
(3,0,0,1,-1,2,8,12,100,5,5,6,4,7,9,11,9,13,11,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.850000,0.850000,1.150000,1.000000,1.200000,0.950000,1,5.384615,7,7.272727,8,0.500000,1000,1,22,90,90,25,110,110,5),
(4,0,1,1,-1,2,8,12,100,5,5,6,4,7,9,11,9,13,11,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.850000,0.850000,1.150000,1.000000,1.200000,0.950000,1,5.000000,7,7.272727,8,0.500000,1000,1,22,90,90,25,110,110,5),
(5,0,0,2,-1,4,9,11,100,7,4,5,4,11,8,10,11,13,8,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.200000,0.850000,1.000000,1.100000,1.000000,0.850000,1,5.384615,7,7.272727,8,0.500000,1000,0,20,100,110,25,100,90,5),
(6,0,1,2,-1,4,9,11,100,7,4,5,4,11,8,10,11,13,8,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.200000,0.850000,1.000000,1.100000,1.000000,0.850000,1,5.000000,7,7.272727,8,0.500000,1000,0,20,100,110,25,100,90,5),
(7,1,2,3,-1,8,11,9,100,4,7,4,5,11,12,10,7,12,8,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.100000,1.200000,1.000000,1.000000,0.850000,0.850000,1,5.000000,7,6.666667,8,0.500000,1000,0,1,110,100,35,90,100,15),
(8,1,2,4,-1,10,8,20,100,4,4,4,4,6,8,11,8,9,18,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.900000,0.900000,1.150000,0.850000,1.100000,1.100000,1,5.000000,7,6.666667,8,0.500000,1000,1,22,90,80,25,110,120,5),
(9,2,0,5,-1,20,11,9,100,5,5,4,6,12,11,9,7,7,14,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.100000,1.100000,0.900000,0.900000,0.850000,1.150000,1,7.000000,7,8.000000,8,0.600000,1000,0,1,100,100,35,90,110,12),
(10,2,1,5,-1,20,11,9,100,5,5,4,6,12,11,9,7,7,14,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.100000,1.100000,0.900000,0.900000,0.850000,1.150000,1,7.000000,7,8.000000,8,0.500000,1000,0,1,100,100,35,90,110,12),
(11,2,0,6,-1,40,8,12,100,5,4,7,4,6,12,12,7,11,12,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.900000,0.900000,1.000000,1.100000,1.200000,0.900000,1,4.666667,7,6.153846,8,0.600000,1000,1,22,90,90,30,110,110,5),
(12,2,1,6,-1,40,8,12,100,5,4,7,4,6,12,12,7,11,12,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.900000,0.900000,1.000000,1.100000,1.200000,0.900000,1,4.666667,7,7.272727,8,0.500000,1000,1,22,90,90,30,110,110,5),
(13,0,0,7,0,81,10,10,100,27,25,25,23,15,10,9,14,10,8,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.050000,1.100000,1.000000,1.100000,0.850000,0.900000,1,5.384615,7,7.272727,8,0.500000,1000,0,1,115,105,30,90,90,10),
(14,0,1,7,0,81,10,10,100,27,25,25,23,15,10,9,14,10,8,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.050000,1.100000,1.000000,1.100000,0.850000,0.900000,1,5.000000,7,7.272727,8,0.500000,1000,0,1,115,105,30,90,90,10),
(15,0,0,8,0,101,10,10,100,30,22,26,22,16,9,10,13,10,8,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.150000,1.000000,1.000000,1.100000,0.850000,0.900000,1,5.384615,7,7.272727,8,0.500000,1000,0,1,105,115,30,90,90,10),
(16,0,1,8,0,101,10,10,100,30,22,26,22,16,9,10,13,10,8,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.150000,1.000000,1.000000,1.100000,0.850000,0.900000,1,5.000000,7,7.272727,8,0.500000,1000,0,1,105,115,30,90,90,10),
(17,0,0,9,1,202,8,12,100,28,17,35,20,8,9,13,10,16,12,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.850000,0.850000,1.150000,1.000000,1.200000,0.950000,1,5.384615,7,7.272727,8,0.500000,1000,1,22,80,90,25,120,110,5),
(18,0,1,9,1,202,8,12,100,28,17,35,20,8,9,13,10,16,12,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.850000,0.850000,1.150000,1.000000,1.200000,0.950000,1,5.000000,7,7.272727,8,0.500000,1000,1,22,80,90,25,120,110,5),
(19,0,0,10,1,402,8,12,100,30,20,30,20,7,10,12,9,15,13,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.000000,0.850000,1.150000,1.000000,1.100000,0.900000,1,5.384615,7,7.272727,8,0.500000,1000,1,22,95,90,25,105,110,5),
(20,0,1,10,1,402,8,12,100,30,20,30,20,7,10,12,9,15,13,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.000000,0.850000,1.150000,1.000000,1.100000,0.900000,1,5.000000,7,7.272727,8,0.500000,1000,1,22,95,90,25,105,110,5),
(21,0,0,11,2,804,9,11,100,35,20,25,20,12,9,11,12,14,9,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.200000,0.850000,1.000000,1.100000,1.000000,0.850000,1,5.384615,7,7.272727,8,0.500000,1000,0,20,105,110,25,95,90,5),
(22,0,1,11,2,804,9,11,100,35,20,25,20,12,9,11,12,14,9,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.200000,0.850000,1.000000,1.100000,1.000000,0.850000,1,5.000000,7,7.272727,8,0.500000,1000,0,20,105,110,25,95,90,5),
(23,0,0,12,2,1004,9,11,100,27,23,27,23,12,9,11,12,14,9,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.150000,0.900000,1.000000,1.100000,1.000000,0.850000,1,5.384615,7,7.272727,8,0.500000,1000,0,20,100,110,25,100,90,5),
(24,0,1,12,2,1004,9,11,100,27,23,27,23,12,9,11,12,14,9,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.150000,0.900000,1.000000,1.100000,1.000000,0.850000,1,5.000000,7,7.272727,8,0.500000,1000,0,20,100,110,25,100,90,5),
(25,1,2,13,3,2008,11,9,100,20,33,20,27,12,15,10,7,12,10,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.050000,1.250000,1.000000,1.000000,0.850000,0.850000,1,5.000000,7,6.666667,8,0.500000,1000,0,1,110,100,35,90,100,15),
(26,1,2,14,3,4008,11,9,100,25,30,20,25,11,14,12,7,13,9,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.050000,1.200000,1.050000,1.000000,0.850000,0.850000,1,5.000000,7,6.666667,8,0.500000,1000,0,1,100,110,35,90,100,15),
(27,1,2,15,4,8010,8,30,100,19,22,22,22,6,9,13,8,10,20,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.900000,0.900000,1.150000,0.850000,1.100000,1.100000,1,5.000000,7,6.666667,8,0.500000,1000,1,22,90,80,25,105,125,5),
(28,1,2,16,4,10010,8,30,100,19,21,24,21,6,10,11,10,11,18,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.900000,0.900000,1.100000,0.850000,1.150000,1.100000,1,5.000000,7,6.666667,8,0.500000,1000,1,22,90,80,25,110,120,5),
(29,2,0,17,5,20020,11,9,100,20,25,20,35,14,12,10,7,7,16,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.100000,1.100000,0.900000,0.900000,0.850000,1.150000,1,4.666667,7,6.153846,8,0.600000,1000,0,1,100,100,35,90,110,12),
(30,2,1,17,5,20020,11,9,100,20,25,20,35,14,12,10,7,7,16,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.100000,1.100000,0.900000,0.900000,0.850000,1.150000,1,4.666667,7,7.272727,8,0.500000,1000,0,1,100,100,35,90,110,12),
(31,2,0,18,5,40020,11,9,100,22,25,21,32,14,12,9,8,7,16,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.150000,1.100000,0.900000,0.900000,0.850000,1.100000,1,4.666667,7,6.153846,8,0.600000,1000,0,1,100,100,35,95,105,12),
(32,2,1,18,5,40020,11,9,100,22,25,21,32,14,12,9,8,7,16,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1.150000,1.100000,0.900000,0.900000,0.850000,1.100000,1,4.666667,7,7.272727,8,0.500000,1000,0,1,100,100,35,95,105,12),
(33,2,0,19,6,80040,8,12,100,25,20,35,20,6,14,13,7,12,14,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.900000,0.850000,1.000000,1.100000,1.250000,0.900000,1,4.666667,7,6.153846,8,0.600000,1000,1,22,90,90,30,115,105,5),
(34,2,1,19,6,80040,8,12,100,25,20,35,20,6,14,13,7,12,14,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.900000,0.850000,1.000000,1.100000,1.250000,0.900000,1,4.666667,7,7.272727,8,0.500000,1000,1,22,90,90,30,115,105,5),
(35,2,0,20,6,100040,8,12,100,22,23,32,23,6,14,12,8,12,14,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.900000,0.900000,1.000000,1.100000,1.200000,0.900000,1,4.666667,7,6.153846,8,0.600000,1000,1,22,90,90,30,105,115,5),
(36,2,1,20,6,100040,8,12,100,22,23,32,23,6,14,12,8,12,14,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.900000,0.900000,1.000000,1.100000,1.200000,0.900000,1,4.666667,7,7.272727,8,0.500000,1000,1,22,90,90,30,105,115,5);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;