-
Notifications
You must be signed in to change notification settings - Fork 6
/
01_data.sql
136 lines (127 loc) · 4.81 KB
/
01_data.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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
--
-- Accounts for test server
--
-- 356a192b7913b04c54574d18c28d46e6395428ab = 1
--
INSERT INTO `accounts`
(`id`, `name`, `email`, `password`, `type`, `coins`)
VALUES
(100, 'test0', '@a', '356a192b7913b04c54574d18c28d46e6395428ab', 1, 100000000),
(101, 'test1', '@b', '356a192b7913b04c54574d18c28d46e6395428ab', 1, 10000),
(102, 'test2', '@c', '356a192b7913b04c54574d18c28d46e6395428ab', 1, 10000),
(103, 'test3', '@d', '356a192b7913b04c54574d18c28d46e6395428ab', 1, 10000);
INSERT INTO `players`
(`id`,`name`,`group_id`,`account_id`,`level`,
`vocation`, `health`, `healthmax`, `experience`,
`lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`,
`mana`, `manamax`, `town_id`, `conditions`, `cap`, `sex`)
VALUES
(0, 'ADM1', 6, 101, 1500, 0, 150, 150, 0, 113, 95, 78, 116, 75, 5, 5, 3, '', 400, 1),
(0, 'ADM2', 6, 102, 1500, 0, 150, 150, 0, 113, 95, 78, 116, 75, 5, 5, 3, '', 400, 1),
(0, 'ADM3', 6, 103, 1500, 0, 150, 150, 0, 106, 95, 78, 116, 75, 5, 5, 3, '', 400, 1);
-- inserindo players na conta @a/1
INSERT INTO `players`
(`id`, `name`, `group_id`, `account_id`,
`level`, `vocation`, `health`, `healthmax`,
`experience`,`maglevel`,`mana`, `manamax`,
`soul`, `town_id`, `cap`, `sex`, `balance`,
`skill_shielding`, `prey_wildcard`, `forge_dusts`, `forge_dust_level`, `conditions`)
VALUES
(0, 'Sorcerer', 1, 100,
800, 5, 4145, 4145,
8469559800, 120, 23800, 23800,
200, 8, 8390, 1, 100000000,
43, 50, 215, 215, '');
INSERT INTO `players`
(`id`, `name`, `group_id`, `account_id`,
`level`, `vocation`, `health`, `healthmax`,
`experience`,`maglevel`,`mana`, `manamax`,
`soul`, `town_id`, `cap`, `sex`, `balance`,
`skill_shielding`, `prey_wildcard`, `forge_dusts`, `forge_dust_level`, `conditions`)
VALUES
(0, 'Druid', 1, 100,
800, 6, 4145, 4145,
8469559800, 120, 23800, 23800,
200, 8, 8390, 1, 100000000,
43, 50, 215, 215, '');
INSERT INTO `players`
(`id`, `name`, `group_id`, `account_id`,
`level`, `vocation`, `health`, `healthmax`,
`experience`,`maglevel`,`mana`, `manamax`,
`soul`, `town_id`, `cap`, `sex`, `balance`,
`skill_dist`, `skill_shielding`, `prey_wildcard`, `forge_dusts`,
`forge_dust_level`, `conditions`)
VALUES
(0, 'Paladin', 1, 100,
800, 7, 8105, 8105,
8469559800, 37, 11920, 11920,
200, 8, 16310, 1, 100000000,
140, 106, 50, 215,
215, '');
INSERT INTO `players`
(`id`, `name`, `group_id`, `account_id`,
`level`, `vocation`, `health`, `healthmax`,
`experience`,`maglevel`,`mana`, `manamax`,
`soul`, `town_id`, `cap`, `sex`, `balance`,
`skill_club`, `skill_sword`, `skill_axe`, `skill_shielding`,
`prey_wildcard`, `forge_dusts`, `forge_dust_level`, `conditions`)
VALUES
(0, 'Knight', 1, 100,
800, 8, 12065, 12065,
8469559800, 14, 4000, 4000,
200, 8, 20270, 1, 100000000,
130, 130, 130, 112,
50, 215, 215, '');
-- inserindo players na conta @b/1
INSERT INTO `players`
(`id`, `name`, `group_id`, `account_id`,
`level`, `vocation`, `health`, `healthmax`,
`experience`,`maglevel`,`mana`, `manamax`,
`soul`, `town_id`, `cap`, `sex`, `balance`,
`skill_shielding`, `prey_wildcard`, `forge_dusts`, `forge_dust_level`, `conditions`)
VALUES
(0, 'Sorcerer01', 1, 101,
800, 5, 4145, 4145,
8469559800, 120, 23800, 23800,
200, 8, 8390, 1, 100000000,
43, 50, 215, 215, '');
INSERT INTO `players`
(`id`, `name`, `group_id`, `account_id`,
`level`, `vocation`, `health`, `healthmax`,
`experience`,`maglevel`,`mana`, `manamax`,
`soul`, `town_id`, `cap`, `sex`, `balance`,
`skill_shielding`, `prey_wildcard`, `forge_dusts`, `forge_dust_level`, `conditions`)
VALUES
(0, 'Druid01', 1, 101,
800, 6, 4145, 4145,
8469559800, 120, 23800, 23800,
200, 8, 8390, 1, 100000000,
43, 50, 215, 215, '');
INSERT INTO `players`
(`id`, `name`, `group_id`, `account_id`,
`level`, `vocation`, `health`, `healthmax`,
`experience`,`maglevel`,`mana`, `manamax`,
`soul`, `town_id`, `cap`, `sex`, `balance`,
`skill_dist`, `skill_shielding`, `prey_wildcard`, `forge_dusts`,
`forge_dust_level`, `conditions`)
VALUES
(0, 'Paladin01', 1, 101,
800, 7, 8105, 8105,
8469559800, 37, 11920, 11920,
200, 8, 16310, 1, 100000000,
140, 106, 50, 215,
215, '');
INSERT INTO `players`
(`id`, `name`, `group_id`, `account_id`,
`level`, `vocation`, `health`, `healthmax`,
`experience`,`maglevel`,`mana`, `manamax`,
`soul`, `town_id`, `cap`, `sex`, `balance`,
`skill_club`, `skill_sword`, `skill_axe`, `skill_shielding`,
`prey_wildcard`, `forge_dusts`, `forge_dust_level`, `conditions`)
VALUES
(0, 'Knight01', 1, 101,
800, 8, 12065, 12065,
8469559800, 14, 4000, 4000,
200, 8, 20270, 1, 100000000,
130, 130, 130, 112,
50, 215, 215, '');