ZnoteOTHire/testplayers.sql at master · peonso/ZnoteOTHire · GitHub

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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
INSERT INTO `accounts` (`id`, `password`, `email`, `premend`, `blocked`, `warnings`) VALUES
(1, '356a192b7913b04c54574d18c28d46e6395428ab', '[email protected]', 1408918935, 0, 0);

INSERT INTO `players` (`id`, `name`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `manamax`, `manaspent`, `soul`, `direction`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `save`, `conditions`, `skull_type`, `skull_time`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items`, `loss_containers`, `town_id`, `balance`, `online`, `rank_id`, `guildnick`) VALUES
(1, 'God Peonso', 1, 5, 1, 0, 100, 2, 0, 185, 185, 35, 35, 0, 0, 2, 10, 10, 10, 10, 75, 224, 229, 7, 0, 1406326989, 1406327188, 16777343, 0, '', 0, 0, 10, 10, 10, 10, 100, 1, 0, 0, 3, ''),
(2, 'Knight Test', 1, 1, 1, 4, 15757308, 100, 6, 1565, 1565, 495, 495, 191326, 8, 2, 38, 10, 78, 76, 160, 224, 229, 7, 2770, 1406338362, 1406338748, 16777343, 0, 0x010040000002ffffffff03204e0000150100000014c0d40100fe010020000002ffffffff03302d0c0004d0070000050500000006d00700000702000000fe0100010000020000000003408a030010d7000000110800000012606d000013f47e0000fe, 0, 0, 10, 10, 10, 10, 100, 1, 0, 0, 3, ''),
(3, 'Druid Test', 1, 1, 0, 2, 15699000, 100, 59, 645, 645, 2795, 2795, 0, 0, 2, 88, 114, 132, 94, 136, 224, 229, 7, 1400, 1406338359, 1406338361, 16777343, 0, 0x010040000002ffffffff0388900000150100000014c0d40100fe, 0, 0, 10, 10, 10, 10, 100, 1, 0, 0, 0, ''),
(4, 'Sorc Test', 1, 1, 1, 1, 15699000, 100, 59, 645, 645, 2795, 2795, 187201, 0, 2, 94, 88, 38, 41, 144, 224, 229, 7, 1390, 1406321197, 1406321198, 16777343, 0, 0x010040000002ffffffff03b8050100150100000014c0d40100fe, 0, 0, 10, 10, 10, 10, 100, 1, 0, 0, 0, ''),
(5, 'Pala Test', 1, 1, 0, 3, 15744120, 100, 18, 1105, 1105, 1415, 1415, 190151, 5, 2, 80, 68, 54, 41, 137, 224, 229, 7, 2310, 1406321194, 1406321196, 16777343, 0, 0x010020000002ffffffff03a0bb0d0004d0070000050400000006d00700000703000000fe0100010000020000000003082e060010d7000000110800000012307500001367d40000fe, 0, 0, 10, 10, 10, 10, 100, 1, 0, 0, 0, ''),
(6, 'Lowlevel sorc Test', 1, 1, 1, 1, 4326, 8, 0, 185, 185, 35, 35, 18, 0, 2, 69, 95, 78, 97, 128, 224, 224, 7, 470, 1406321020, 1406321185, 16777343, 1, 0x0100010000020000000003204e00001b001c0000000010d7000000110600000012102700001371780000fe010020000002ffffffff0358c70d001b001c000000000470170000050100000006b80b00000702000000fe010040000002ffffffff0390dc01001b001c00000000150100000014c0d40100fe, 0, 0, 10, 10, 10, 10, 100, 1, 0, 0, 0, '');

INSERT INTO `player_items` (`player_id`, `sid`, `pid`, `itemtype`, `count`, `attributes`) VALUES
(1, 101, 3, 1988, 1, ''),
(1, 102, 101, 2789, 100, 0x0f64),
(1, 103, 101, 2160, 2, 0x0f02),
(1, 104, 101, 2120, 1, ''),
(1, 105, 101, 2554, 1, ''),
(1, 106, 101, 2420, 1, ''),
(1, 107, 101, 2553, 1, ''),
(1, 108, 101, 2550, 1, ''),
(1, 109, 101, 2580, 1, ''),
(1, 110, 101, 1949, 1, 0x06140057656c636f6d6520746f204775696c636572612e130700474d2054657374),
(1, 111, 101, 2175, 1, ''),
(1, 112, 101, 1988, 1, ''),
(1, 113, 101, 1988, 1, ''),
(1, 114, 101, 1988, 1, ''),
(1, 115, 101, 1988, 1, ''),
(1, 116, 112, 2183, 1, ''),
(1, 117, 112, 2472, 1, ''),
(1, 118, 112, 2471, 1, ''),
(1, 119, 112, 2469, 1, ''),
(1, 120, 112, 2171, 1, ''),
(1, 121, 112, 2195, 1, ''),
(1, 122, 112, 2523, 1, ''),
(1, 123, 112, 2431, 1, ''),
(1, 124, 112, 2390, 1, ''),
(1, 125, 112, 2646, 1, ''),
(1, 126, 112, 2456, 1, ''),
(1, 127, 112, 2455, 1, ''),
(1, 128, 112, 2189, 1, ''),
(1, 129, 112, 2187, 1, ''),
(1, 130, 112, 2181, 1, ''),
(1, 131, 113, 2546, 100, 0x0f64),
(1, 132, 113, 2546, 100, 0x0f64),
(1, 133, 113, 2546, 100, 0x0f64),
(1, 134, 113, 2546, 100, 0x0f64),
(1, 135, 113, 2547, 100, 0x0f64),
(1, 136, 113, 2547, 100, 0x0f64),
(1, 137, 113, 2547, 100, 0x0f64),
(1, 138, 113, 2547, 100, 0x0f64),
(1, 139, 113, 2547, 100, 0x0f64),
(1, 140, 113, 2547, 100, 0x0f64),
(1, 141, 113, 2547, 100, 0x0f64),
(1, 142, 113, 2547, 100, 0x0f64),
(1, 143, 113, 2547, 100, 0x0f64),
(1, 144, 114, 2291, 100, 0x0c64),
(1, 145, 114, 2293, 100, 0x0c64),
(1, 146, 114, 2313, 100, 0x0c64),
(1, 147, 114, 2313, 100, 0x0c64),
(1, 148, 114, 2305, 100, 0x0c64),
(1, 149, 114, 2304, 100, 0x0c64),
(1, 150, 114, 2304, 100, 0x0c64),
(1, 151, 114, 2278, 100, 0x0c64),
(1, 152, 114, 2262, 100, 0x0c64),
(1, 153, 114, 2273, 100, 0x0c64),
(1, 154, 114, 2273, 100, 0x0c64),
(1, 155, 114, 2261, 100, 0x0c64),
(1, 156, 114, 2268, 100, 0x0c64),
(1, 157, 114, 2268, 100, 0x0c64),
(1, 158, 115, 2164, 20, 0x0c14),
(1, 159, 115, 2169, 1, ''),
(1, 160, 115, 2167, 1, ''),
(1, 161, 115, 2165, 1, ''),
(1, 162, 115, 2207, 1, ''),
(1, 163, 115, 2208, 1, ''),
(1, 164, 115, 2209, 1, ''),
(1, 165, 115, 2213, 1, ''),
(1, 166, 115, 2214, 1, ''),
(1, 167, 115, 2173, 1, ''),
(1, 168, 115, 2197, 1, 0x0c01),
(2, 101, 1, 2471, 1, ''),
(2, 102, 2, 2171, 1, ''),
(2, 103, 3, 1988, 1, ''),
(2, 104, 4, 2472, 1, ''),
(2, 105, 6, 2390, 1, ''),
(2, 106, 7, 2469, 1, ''),
(2, 107, 8, 2195, 1, ''),
(2, 108, 103, 2789, 94, 0x0f5e),
(2, 109, 103, 2160, 2, 0x0f02),
(2, 110, 103, 2120, 1, ''),
(2, 111, 103, 2554, 1, ''),
(2, 112, 103, 2420, 1, ''),
(2, 113, 103, 2553, 1, ''),
(2, 114, 103, 2550, 1, ''),
(2, 115, 103, 2580, 1, ''),
(2, 116, 103, 1949, 1, 0x06140057656c636f6d6520746f204775696c636572612e130700474d2054657374),
(2, 117, 103, 2175, 1, ''),
(2, 118, 103, 1988, 1, ''),
(2, 119, 103, 1988, 1, ''),
(2, 120, 103, 1988, 1, ''),
(2, 121, 103, 1988, 1, ''),
(2, 122, 118, 2006, 7, 0x0f07),
(2, 123, 118, 2006, 7, 0x0f07),
(2, 124, 118, 2006, 7, 0x0f07),
(2, 125, 118, 2006, 7, 0x0f07),
(2, 126, 118, 2006, 7, 0x0f07),
(2, 127, 118, 2006, 7, 0x0f07),
(2, 128, 118, 2006, 7, 0x0f07),
(2, 129, 118, 2006, 7, 0x0f07),
(2, 130, 118, 2006, 7, 0x0f07),
(2, 131, 118, 2006, 7, 0x0f07),
(2, 132, 118, 2006, 7, 0x0f07),
(2, 133, 118, 2006, 7, 0x0f07),
(2, 134, 118, 2006, 7, 0x0f07),
(2, 135, 118, 2006, 7, 0x0f07),
(2, 136, 118, 2006, 7, 0x0f07),
(2, 137, 118, 2006, 7, 0x0f07),
(2, 138, 118, 2006, 7, 0x0f07),
(2, 139, 118, 2006, 7, 0x0f07),
(2, 140, 118, 2006, 7, 0x0f07),
(2, 141, 118, 2006, 7, 0x0f07),
(2, 142, 119, 2431, 1, ''),
(2, 143, 119, 2523, 1, ''),
(2, 144, 119, 2456, 1, ''),
(2, 145, 119, 2646, 1, ''),
(2, 146, 119, 2546, 100, 0x0f64),
(2, 147, 119, 2546, 100, 0x0f64),
(2, 148, 119, 2546, 100, 0x0f64),
(2, 149, 119, 2546, 100, 0x0f64),
(2, 150, 120, 2291, 99, 0x0c63),
(2, 151, 120, 2313, 84, 0x0c54),
(2, 152, 120, 2313, 99, 0x0c63),
(2, 153, 120, 2305, 99, 0x0c63),
(2, 154, 120, 2304, 97, 0x0c61),
(2, 155, 120, 2304, 99, 0x0c63),
(2, 156, 120, 2273, 72, 0x0c48),
(2, 157, 120, 2273, 100, 0x0c64),
(2, 158, 120, 2261, 100, 0x0c64),
(2, 159, 121, 2164, 20, 0x0c14),
(2, 160, 121, 2169, 1, ''),
(2, 161, 121, 2167, 1, ''),
(2, 162, 121, 2165, 1, ''),
(2, 163, 121, 2207, 1, ''),
(2, 164, 121, 2208, 1, ''),
(2, 165, 121, 2213, 1, ''),
(2, 166, 121, 2214, 1, ''),
(2, 167, 121, 2173, 1, ''),
(2, 168, 121, 2197, 1, 0x0c01),
(3, 101, 1, 2471, 1, ''),
(3, 102, 2, 2171, 1, ''),
(3, 103, 3, 1988, 1, ''),
(3, 104, 4, 2472, 1, ''),
(3, 105, 5, 2523, 1, ''),
(3, 106, 6, 2183, 1, ''),
(3, 107, 7, 2469, 1, ''),
(3, 108, 8, 2195, 1, ''),
(3, 109, 103, 2789, 100, 0x0f64),
(3, 110, 103, 2160, 2, 0x0f02),
(3, 111, 103, 2120, 1, ''),
(3, 112, 103, 2554, 1, ''),
(3, 113, 103, 2420, 1, ''),
(3, 114, 103, 2553, 1, ''),
(3, 115, 103, 2550, 1, ''),
(3, 116, 103, 2580, 1, ''),
(3, 117, 103, 1949, 1, 0x06140057656c636f6d6520746f204775696c636572612e130700474d2054657374),
(3, 118, 103, 2175, 1, ''),
(3, 119, 103, 1988, 1, ''),
(3, 120, 103, 1988, 1, ''),
(3, 121, 103, 1988, 1, ''),
(3, 122, 103, 1988, 1, ''),
(3, 123, 119, 2006, 7, 0x0f07),
(3, 124, 119, 2006, 7, 0x0f07),
(3, 125, 119, 2006, 7, 0x0f07),
(3, 126, 119, 2006, 7, 0x0f07),
(3, 127, 119, 2006, 7, 0x0f07),
(3, 128, 119, 2006, 7, 0x0f07),
(3, 129, 119, 2006, 7, 0x0f07),
(3, 130, 119, 2006, 7, 0x0f07),
(3, 131, 119, 2006, 7, 0x0f07),
(3, 132, 119, 2006, 7, 0x0f07),
(3, 133, 119, 2006, 7, 0x0f07),
(3, 134, 119, 2006, 7, 0x0f07),
(3, 135, 119, 2006, 7, 0x0f07),
(3, 136, 119, 2006, 7, 0x0f07),
(3, 137, 119, 2006, 7, 0x0f07),
(3, 138, 119, 2006, 7, 0x0f07),
(3, 139, 119, 2006, 7, 0x0f07),
(3, 140, 119, 2006, 7, 0x0f07),
(3, 141, 119, 2006, 7, 0x0f07),
(3, 142, 119, 2006, 7, 0x0f07),
(3, 143, 120, 2182, 1, ''),
(3, 144, 120, 2181, 1, ''),
(3, 145, 120, 2456, 1, ''),
(3, 146, 120, 2546, 100, 0x0f64),
(3, 147, 120, 2546, 100, 0x0f64),
(3, 148, 120, 2546, 100, 0x0f64),
(3, 149, 120, 2546, 100, 0x0f64),
(3, 150, 121, 2291, 100, 0x0c64),
(3, 151, 121, 2293, 100, 0x0c64),
(3, 152, 121, 2313, 100, 0x0c64),
(3, 153, 121, 2313, 100, 0x0c64),
(3, 154, 121, 2305, 100, 0x0c64),
(3, 155, 121, 2304, 100, 0x0c64),
(3, 156, 121, 2304, 100, 0x0c64),
(3, 157, 121, 2278, 100, 0x0c64),
(3, 158, 121, 2262, 100, 0x0c64),
(3, 159, 121, 2273, 100, 0x0c64),
(3, 160, 121, 2273, 100, 0x0c64),
(3, 161, 121, 2261, 100, 0x0c64),
(3, 162, 121, 2268, 100, 0x0c64),
(3, 163, 121, 2268, 100, 0x0c64),
(3, 164, 122, 2164, 20, 0x0c14),
(3, 165, 122, 2169, 1, ''),
(3, 166, 122, 2167, 1, ''),
(3, 167, 122, 2165, 1, ''),
(3, 168, 122, 2213, 1, ''),
(3, 169, 122, 2214, 1, ''),
(3, 170, 122, 2173, 1, ''),
(3, 171, 122, 2197, 1, 0x0c01),
(4, 101, 1, 2471, 1, ''),
(4, 102, 2, 2171, 1, ''),
(4, 103, 3, 1988, 1, ''),
(4, 104, 4, 2472, 1, ''),
(4, 105, 5, 2523, 1, ''),
(4, 106, 6, 2187, 1, ''),
(4, 107, 7, 2469, 1, ''),
(4, 108, 8, 2195, 1, ''),
(4, 109, 103, 2789, 100, 0x0f64),
(4, 110, 103, 2160, 2, 0x0f02),
(4, 111, 103, 2120, 1, ''),
(4, 112, 103, 2554, 1, ''),
(4, 113, 103, 2420, 1, ''),
(4, 114, 103, 2553, 1, ''),
(4, 115, 103, 2550, 1, ''),
(4, 116, 103, 2580, 1, ''),
(4, 117, 103, 1949, 1, 0x06140057656c636f6d6520746f204775696c636572612e130700474d2054657374),
(4, 118, 103, 2175, 1, ''),
(4, 119, 103, 1988, 1, ''),
(4, 120, 103, 1988, 1, ''),
(4, 121, 103, 1988, 1, ''),
(4, 122, 103, 1988, 1, ''),
(4, 123, 119, 2006, 7, 0x0f07),
(4, 124, 119, 2006, 7, 0x0f07),
(4, 125, 119, 2006, 7, 0x0f07),
(4, 126, 119, 2006, 7, 0x0f07),
(4, 127, 119, 2006, 7, 0x0f07),
(4, 128, 119, 2006, 7, 0x0f07),
(4, 129, 119, 2006, 7, 0x0f07),
(4, 130, 119, 2006, 7, 0x0f07),
(4, 131, 119, 2006, 7, 0x0f07),
(4, 132, 119, 2006, 7, 0x0f07),
(4, 133, 119, 2006, 7, 0x0f07),
(4, 134, 119, 2006, 7, 0x0f07),
(4, 135, 119, 2006, 7, 0x0f07),
(4, 136, 119, 2006, 7, 0x0f07),
(4, 137, 119, 2006, 7, 0x0f07),
(4, 138, 119, 2006, 7, 0x0f07),
(4, 139, 119, 2006, 7, 0x0f07),
(4, 140, 119, 2006, 7, 0x0f07),
(4, 141, 119, 2006, 7, 0x0f07),
(4, 142, 119, 2006, 7, 0x0f07),
(4, 143, 120, 2190, 1, ''),
(4, 144, 120, 2189, 1, ''),
(4, 145, 120, 2456, 1, ''),
(4, 146, 120, 2546, 100, 0x0f64),
(4, 147, 120, 2546, 100, 0x0f64),
(4, 148, 120, 2546, 100, 0x0f64),
(4, 149, 120, 2546, 100, 0x0f64),
(4, 150, 121, 2291, 100, 0x0c64),
(4, 151, 121, 2293, 100, 0x0c64),
(4, 152, 121, 2313, 100, 0x0c64),
(4, 153, 121, 2313, 100, 0x0c64),
(4, 154, 121, 2305, 100, 0x0c64),
(4, 155, 121, 2304, 100, 0x0c64),
(4, 156, 121, 2304, 100, 0x0c64),
(4, 157, 121, 2278, 100, 0x0c64),
(4, 158, 121, 2262, 100, 0x0c64),
(4, 159, 121, 2273, 100, 0x0c64),
(4, 160, 121, 2273, 100, 0x0c64),
(4, 161, 121, 2261, 100, 0x0c64),
(4, 162, 121, 2268, 100, 0x0c64),
(4, 163, 121, 2268, 100, 0x0c64),
(4, 164, 122, 2164, 20, 0x0c14),
(4, 165, 122, 2169, 1, ''),
(4, 166, 122, 2167, 1, ''),
(4, 167, 122, 2165, 1, ''),
(4, 168, 122, 2213, 1, ''),
(4, 169, 122, 2214, 1, ''),
(4, 170, 122, 2173, 1, ''),
(4, 171, 122, 2197, 1, 0x0c01),
(5, 101, 1, 2471, 1, ''),
(5, 102, 2, 2171, 1, ''),
(5, 103, 3, 1988, 1, ''),
(5, 104, 4, 2472, 1, ''),
(5, 105, 6, 2455, 1, ''),
(5, 106, 7, 2469, 1, ''),
(5, 107, 8, 2195, 1, ''),
(5, 108, 10, 2547, 100, 0x0f64),
(5, 109, 103, 2789, 94, 0x0f5e),
(5, 110, 103, 2160, 2, 0x0f02),
(5, 111, 103, 2120, 1, ''),
(5, 112, 103, 2554, 1, ''),
(5, 113, 103, 2420, 1, ''),
(5, 114, 103, 2553, 1, ''),
(5, 115, 103, 2550, 1, ''),
(5, 116, 103, 2580, 1, ''),
(5, 117, 103, 1949, 1, 0x06140057656c636f6d6520746f204775696c636572612e130700474d2054657374),
(5, 118, 103, 2175, 1, ''),
(5, 119, 103, 1988, 1, ''),
(5, 120, 103, 1988, 1, ''),
(5, 121, 103, 1988, 1, ''),
(5, 122, 103, 1988, 1, ''),
(5, 123, 119, 2006, 7, 0x0f07),
(5, 124, 119, 2006, 7, 0x0f07),
(5, 125, 119, 2006, 7, 0x0f07),
(5, 126, 119, 2006, 7, 0x0f07),
(5, 127, 119, 2006, 7, 0x0f07),
(5, 128, 119, 2006, 7, 0x0f07),
(5, 129, 119, 2006, 7, 0x0f07),
(5, 130, 119, 2006, 7, 0x0f07),
(5, 131, 119, 2006, 7, 0x0f07),
(5, 132, 119, 2006, 7, 0x0f07),
(5, 133, 119, 2006, 7, 0x0f07),
(5, 134, 119, 2006, 7, 0x0f07),
(5, 135, 119, 2006, 7, 0x0f07),
(5, 136, 119, 2006, 7, 0x0f07),
(5, 137, 119, 2006, 7, 0x0f07),
(5, 138, 119, 2006, 7, 0x0f07),
(5, 139, 119, 2006, 7, 0x0f07),
(5, 140, 119, 2006, 7, 0x0f07),
(5, 141, 119, 2006, 7, 0x0f07),
(5, 142, 119, 2006, 7, 0x0f07),
(5, 143, 120, 2389, 5, 0x0f05),
(5, 144, 120, 2547, 12, 0x0f0c),
(5, 145, 120, 2547, 100, 0x0f64),
(5, 146, 120, 2547, 100, 0x0f64),
(5, 147, 120, 2547, 100, 0x0f64),
(5, 148, 120, 2547, 100, 0x0f64),
(5, 149, 120, 2547, 100, 0x0f64),
(5, 150, 120, 2547, 100, 0x0f64),
(5, 151, 120, 2547, 100, 0x0f64),
(5, 152, 120, 2547, 100, 0x0f64),
(5, 153, 120, 2547, 100, 0x0f64),
(5, 154, 120, 2547, 100, 0x0f64),
(5, 155, 120, 2547, 100, 0x0f64),
(5, 156, 120, 2547, 100, 0x0f64),
(5, 157, 121, 2291, 100, 0x0c64),
(5, 158, 121, 2293, 99, 0x0c63),
(5, 159, 121, 2313, 100, 0x0c64),
(5, 160, 121, 2313, 100, 0x0c64),
(5, 161, 121, 2305, 100, 0x0c64),
(5, 162, 121, 2304, 100, 0x0c64),
(5, 163, 121, 2304, 100, 0x0c64),
(5, 164, 121, 2262, 99, 0x0c63),
(5, 165, 121, 2273, 95, 0x0c5f),
(5, 166, 121, 2273, 100, 0x0c64),
(5, 167, 121, 2261, 100, 0x0c64),
(5, 168, 121, 2268, 87, 0x0c57),
(5, 169, 121, 2268, 92, 0x0c5c),
(5, 170, 122, 2164, 20, 0x0c14),
(5, 171, 122, 2169, 1, ''),
(5, 172, 122, 2167, 1, ''),
(5, 173, 122, 2165, 1, ''),
(5, 174, 122, 2213, 1, ''),
(5, 175, 122, 2214, 1, ''),
(5, 176, 122, 2173, 1, ''),
(5, 177, 122, 2197, 1, 0x0c01),
(6, 101, 1, 2471, 1, ''),
(6, 102, 3, 1988, 1, ''),
(6, 103, 4, 2484, 1, ''),
(6, 104, 5, 2190, 1, ''),
(6, 105, 6, 2530, 1, ''),
(6, 106, 7, 2649, 1, ''),
(6, 107, 8, 2643, 1, ''),
(6, 108, 102, 2789, 95, 0x0f5f),
(6, 109, 102, 2160, 2, 0x0f02),
(6, 110, 102, 2120, 1, ''),
(6, 111, 102, 2554, 1, ''),
(6, 112, 102, 2420, 1, ''),
(6, 113, 102, 2553, 1, ''),
(6, 114, 102, 2580, 1, ''),
(6, 115, 102, 1949, 1, 0x06140057656c636f6d6520746f204775696c636572612e130700474d2054657374),
(6, 116, 102, 1988, 1, ''),
(6, 117, 116, 2291, 100, 0x166400),
(6, 118, 116, 2293, 100, 0x166400),
(6, 119, 116, 2313, 100, 0x166400),
(6, 120, 116, 2313, 100, 0x166400),
(6, 121, 116, 2305, 100, 0x166400),
(6, 122, 116, 2304, 100, 0x166400),
(6, 123, 116, 2304, 100, 0x166400),
(6, 124, 116, 2278, 100, 0x166400),
(6, 125, 116, 2262, 100, 0x166400),
(6, 126, 116, 2273, 100, 0x166400),
(6, 127, 116, 2273, 100, 0x166400),
(6, 128, 116, 2261, 100, 0x166400),
(6, 129, 116, 2268, 100, 0x166400),
(6, 130, 116, 2268, 100, 0x166400);

TRUNCATE player_skills;

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(1, 0, 10, 0),
(1, 1, 10, 0),
(1, 2, 10, 0),
(1, 3, 10, 0),
(1, 4, 10, 0),
(1, 5, 10, 0),
(1, 6, 10, 0),
(2, 0, 10, 0),
(2, 1, 10, 0),
(2, 2, 95, 0),
(2, 3, 95, 100000),
(2, 4, 10, 0),
(2, 5, 95, 100000),
(2, 6, 10, 0),
(3, 0, 10, 0),
(3, 1, 10, 0),
(3, 2, 11, 10),
(3, 3, 10, 0),
(3, 4, 10, 0),
(3, 5, 10, 0),
(3, 6, 10, 0),
(4, 0, 10, 0),
(4, 1, 10, 0),
(4, 2, 10, 10),
(4, 3, 10, 0),
(4, 4, 10, 0),
(4, 5, 10, 0),
(4, 6, 10, 0),
(5, 0, 10, 0),
(5, 1, 10, 0),
(5, 2, 10, 10),
(5, 3, 10, 0),
(5, 4, 98, 0),
(5, 5, 10, 0),
(5, 6, 10, 0),
(6, 0, 10, 0),
(6, 1, 10, 0),
(6, 2, 10, 0),
(6, 3, 11, 0),
(6, 4, 10, 0),
(6, 5, 29, 200009),
(6, 6, 10, 0);