-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathhatiData.sql
1970 lines (1715 loc) · 268 KB
/
hatiData.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
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
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- MySQL dump 10.13 Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: localhost Database: hati
-- ------------------------------------------------------
-- Server version 8.0.22
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Table structure for table `account_ban_history`
--
DROP TABLE IF EXISTS `account_ban_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_ban_history` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`account_id` int NOT NULL,
`reason` varchar(255) NOT NULL,
`banned_at` bigint NOT NULL,
`expired_at` bigint NOT NULL,
`banned_by` int NOT NULL,
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`),
KEY `banned_by` (`banned_by`),
KEY `account_id_2` (`account_id`),
KEY `account_id_3` (`account_id`),
KEY `account_id_4` (`account_id`),
KEY `account_id_5` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account_ban_history`
--
LOCK TABLES `account_ban_history` WRITE;
/*!40000 ALTER TABLE `account_ban_history` DISABLE KEYS */;
INSERT INTO `account_ban_history` VALUES (1,1570,'',1579230954,1579835754,4),(2,1926,'30',1579748869,1580353669,4),(3,1596,'',1580356465,1580961265,4);
/*!40000 ALTER TABLE `account_ban_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account_bans`
--
DROP TABLE IF EXISTS `account_bans`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_bans` (
`account_id` int NOT NULL,
`reason` varchar(255) NOT NULL,
`banned_at` bigint NOT NULL,
`expires_at` bigint NOT NULL,
`banned_by` int NOT NULL,
PRIMARY KEY (`account_id`),
KEY `banned_by` (`banned_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account_bans`
--
LOCK TABLES `account_bans` WRITE;
/*!40000 ALTER TABLE `account_bans` DISABLE KEYS */;
/*!40000 ALTER TABLE `account_bans` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account_character_sale`
--
DROP TABLE IF EXISTS `account_character_sale`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_character_sale` (
`id` int NOT NULL AUTO_INCREMENT,
`id_account` int NOT NULL,
`id_player` int NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0',
`price_type` tinyint NOT NULL,
`price_coins` int DEFAULT NULL,
`price_gold` int DEFAULT NULL,
`dta_insert` datetime NOT NULL,
`dta_valid` datetime NOT NULL,
`dta_sale` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `id_player_UNIQUE` (`id_player`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account_character_sale`
--
LOCK TABLES `account_character_sale` WRITE;
/*!40000 ALTER TABLE `account_character_sale` DISABLE KEYS */;
/*!40000 ALTER TABLE `account_character_sale` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account_character_sale_history`
--
DROP TABLE IF EXISTS `account_character_sale_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_character_sale_history` (
`id` int NOT NULL AUTO_INCREMENT,
`id_old_account` int DEFAULT NULL,
`id_player` int DEFAULT NULL,
`id_new_account` int DEFAULT NULL,
`price_type` tinyint(1) DEFAULT NULL,
`price` int DEFAULT NULL,
`char_id` int DEFAULT NULL,
`dta_insert` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`dta_sale` datetime DEFAULT NULL,
`extornada` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `id_old_acc_idx` (`id_old_account`) USING BTREE,
KEY `id_new_acc_idx` (`id_new_account`) USING BTREE,
KEY `id_player_idx` (`id_player`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account_character_sale_history`
--
LOCK TABLES `account_character_sale_history` WRITE;
/*!40000 ALTER TABLE `account_character_sale_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `account_character_sale_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `account_viplist`
--
DROP TABLE IF EXISTS `account_viplist`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_viplist` (
`account_id` int NOT NULL COMMENT 'id of account whose viplist entry it is',
`player_id` int NOT NULL COMMENT 'id of target player of viplist entry',
`description` varchar(128) NOT NULL DEFAULT '',
`icon` tinyint unsigned NOT NULL DEFAULT '0',
`notify` tinyint(1) NOT NULL DEFAULT '0',
UNIQUE KEY `account_player_index` (`account_id`,`player_id`),
KEY `account_id` (`account_id`),
KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `account_viplist`
--
LOCK TABLES `account_viplist` WRITE;
/*!40000 ALTER TABLE `account_viplist` DISABLE KEYS */;
INSERT INTO `account_viplist` VALUES (2,7,'',0,0),(3,5,'',2,0),(3,6,'',2,0),(3,9,'',2,0),(3,13,'',2,0),(3,14,'',0,0),(3,19,'',0,0),(3,28,'',0,0),(3,36,'',0,0),(3,44,'',0,0),(5,4,'',0,0),(5,6,'',0,0),(5,9,'',0,0),(5,42,'',0,0),(6,4,'',0,0),(6,5,'',0,0),(6,28,'',0,0),(8,4,'',0,0),(8,5,'',0,0),(8,6,'',0,0),(8,9,'',0,0),(8,13,'',0,0),(8,28,'',0,0),(9,4,'',0,0),(9,5,'',0,0),(9,8,'',0,0),(9,13,'',0,0),(9,15,'',0,0),(10,3,'',0,0),(12,14,'',0,0),(12,15,'',0,0),(13,12,'',0,0),(13,3479,'',0,0),(14,5,'',0,0),(14,9,'',0,0),(14,11,'',0,0),(14,12,'',0,0),(14,14,'',0,0),(17,20,'',0,0),(19,4,'',0,0),(19,14,'',0,0),(21,14,'',0,0),(22,28,'',0,0),(23,9,'',0,0),(23,28,'',0,0),(26,4,'',0,0),(26,23,'',0,0),(31,4,'',0,0),(35,4,'',0,0),(43,56,'',0,0),(52,56,'',0,0);
/*!40000 ALTER TABLE `account_viplist` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `accounts`
--
DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`password` char(40) NOT NULL,
`secret` char(16) DEFAULT NULL,
`type` int NOT NULL DEFAULT '1',
`premdays` int NOT NULL DEFAULT '0',
`coins` int NOT NULL DEFAULT '0',
`lastday` int unsigned NOT NULL DEFAULT '0',
`email` varchar(255) NOT NULL DEFAULT '',
`creation` int NOT NULL DEFAULT '0',
`jwtVersion` int NOT NULL DEFAULT '0',
`updatedAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`vote` int NOT NULL,
`key` varchar(255) NOT NULL DEFAULT '0',
`email_new` varchar(255) NOT NULL DEFAULT '',
`email_new_time` int NOT NULL DEFAULT '0',
`rlname` varchar(255) NOT NULL DEFAULT '',
`location` varchar(255) NOT NULL DEFAULT '',
`page_access` int NOT NULL DEFAULT '0',
`email_code` varchar(255) NOT NULL DEFAULT '',
`next_email` int NOT NULL DEFAULT '0',
`premium_points` int NOT NULL DEFAULT '0',
`secret_status` tinyint(1) NOT NULL DEFAULT '0',
`create_date` int unsigned NOT NULL DEFAULT '0',
`create_ip` bigint NOT NULL DEFAULT '0',
`last_post` int NOT NULL DEFAULT '0',
`flag` varchar(80) NOT NULL DEFAULT '',
`vip_time` int NOT NULL DEFAULT '0',
`guild_points` int NOT NULL DEFAULT '0',
`guild_points_stats` int NOT NULL DEFAULT '0',
`passed` int NOT NULL DEFAULT '0',
`block` int NOT NULL DEFAULT '0',
`refresh` int NOT NULL DEFAULT '0',
`birth_date` varchar(50) NOT NULL DEFAULT '',
`gender` varchar(20) NOT NULL DEFAULT '',
`profileName` varchar(255) NOT NULL DEFAULT '',
`passwordResetExpires` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`passwordResetToken` varchar(255) NOT NULL DEFAULT '',
`avatar` varchar(255) NOT NULL DEFAULT '',
`loyalty_points` bigint NOT NULL DEFAULT '0',
`authToken` varchar(100) NOT NULL DEFAULT '',
`player_sell_bank` int DEFAULT NULL,
`tournamentBalance` int NOT NULL DEFAULT '0',
`tokens` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `name_2` (`name`),
UNIQUE KEY `name_3` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts`
--
LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` VALUES (1,'ehuae8283@#1l','067d2a52b8a3ae6f465a4210a694e57be8e74307','',1,0,0,0,'',0,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'0','',0,'','',0,'',0,0,0,0,0,0,'unknown',0,0,0,0,0,0,'','','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(2,'899681','169d16cbbe04b2112fb051bf0c0ddaaf2410e592','',5,500,21466,0,'[email protected]',1582573468,0,'2021-05-19 11:28:10.000','2020-10-24 18:45:37.918',0,'E1U6-IGOL-Y1EW-E0IL','',0,'Pedro Henrique','Rio de Janeiro',3,'',0,0,0,0,3014692860,1588797614,'unknown',0,0,0,0,0,0,'10/10/1994','male','CM Pedro','2020-11-05 20:27:43.615','','',0,'',0,0,0),(7,'admin','3c5f649ff3026812a9012ec7afdf8a38a954bf25','',5,500,7525,0,'[email protected]',1588794878,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'ABIX-EXUW-IDAV-Y3OX','',0,'Yago Neno','Rio de Janeiro',3,'',0,0,0,0,2982180554,0,'br',0,0,0,0,0,0,'6/5/1994','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(36,'048637','3c5f649ff3026812a9012ec7afdf8a38a954bf25','',1,500,-20,0,'[email protected]',1597619529,0,'2021-03-10 23:09:19.000','2020-10-24 18:45:37.918',0,'HO7O-QORE-7UQA-JU3Y','',0,'Pedro Henrique Giampietro','Rio de Janeiro',0,'',0,0,0,0,3206584976,1603562256,'unknown',0,0,0,0,0,0,'10/10/1994','male','Mabaz','2020-11-05 20:27:43.615','','uploads/1604853629924-Logo_Hati.png',0,'',0,0,0),(37,'731290Y','c8fb2cc9dabc8f0c6be87cae39ae9cd38145dc48','',1,500,0,0,'[email protected]',1597621800,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'6YPY-7YWO-VA2E-MAZA','',0,'Yago Neno','Rio de Janeiro',0,'',0,0,0,0,2982180358,0,'br',0,0,0,0,0,0,'6/5/1994','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(38,'9475518','759118733ec55bb3d98627cfc72026daa968268b','',1,500,0,0,'[email protected]',1597622997,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'PANE-LI1E-SUWI-8I6U','',0,'Murilo moreno Moreno','Araras',0,'',0,0,0,0,2826550320,0,'unknown',0,0,0,0,0,0,'29/12/1992','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(39,'MASTERINK','e105a6432dcf5fa2cc69595816bedc8bf00a073b','',1,500,0,0,'[email protected]',1597680167,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'0UJE-0I5Y-ZABA-TODO','',0,'Douglas Custodio','Sumare',0,'',0,0,0,0,3370968142,0,'br',0,0,0,0,0,0,'7/10/1980','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(40,'041093','c33175ba659d440c1fb00c5054b25218ec675d88','',1,500,0,0,'[email protected]',1597684064,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'MY5U-RE4E-0UDU-QYLO','',0,'Eduardo Medeiros','Rio de Janeiro',0,'',0,0,0,0,3005404715,0,'unknown',0,0,0,0,0,0,'4/10/1993','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(41,'130395','c33175ba659d440c1fb00c5054b25218ec675d88','',1,500,0,0,'[email protected]',1597684124,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'Y4EX-ESIW-UHUT-UVID','',0,'Leonardo Medeiros','Rio de Janeiro',0,'',0,0,0,0,3005404715,0,'unknown',0,0,0,0,0,0,'8/3/1993','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(42,'151515','3c5f649ff3026812a9012ec7afdf8a38a954bf25','',1,500,0,0,'[email protected]',1597714278,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'5OQY-RYLO-8YXA-VU6E','',0,'Kayky Silva','São Paulo',0,'',0,0,0,0,3381985192,0,'mx',0,0,0,0,0,0,'0/0/0','','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(43,'LUISDEAR','a3828b57af1ec21d70f5da1175cf2a5785e09b48','',1,500,0,0,'[email protected]',1597812575,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'OPE1-UVU4-YLOD-IGIV','',0,'Luis Hgfgfgfgf','Mexico',0,'',0,0,0,0,3147087065,0,'mx',0,0,0,0,0,0,'13/4/1999','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(44,'227099','5d6ee2bc385a041e1498c9eb9b0b3959174a237f','',1,500,0,0,'[email protected]',1597844905,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'2OBA-LO1E-6AXO-PE1E','',0,'X X','X',0,'',0,0,0,0,1841590862,0,'unknown',0,0,0,0,0,0,'1/1/2009','female','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(45,'VOKAHUR','480079dc8b61724ac80d0d08988f6aaf53966750','',1,500,0,0,'[email protected]',1597873053,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'IWU3-EXIZ-I8O5-EMAQ','',0,'Lucas Corrêa','Angra dos reis',0,'',0,0,0,0,2974192961,0,'br',0,0,0,0,0,0,'29/4/2001','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(46,'PHILIPPSEN','f71ea96d4c3c2c1e2e78e1199e0091ad9ebb6c40','',1,500,0,0,'[email protected]',1597885605,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'EJU0-INEJ-EJY8-YDA3','',0,'Jonas Philippsen','Santo Cristo',0,'',0,0,0,0,2973904301,0,'br',0,0,0,0,0,0,'6/3/1979','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(47,'THALISLIKAN','08e5c7b64b0f2042ea1b25a2fbe842517e1eb1e1','',1,500,0,0,'[email protected]',1597915663,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'ONIP-OBO5-UVO3-YNIS','',0,'Davyson Rocha','SP',0,'',0,0,0,0,3014529197,0,'unknown',0,0,0,0,0,0,'8/2/1992','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(48,'ADEILTON','d47a9c06e4fb75f6ccdf4e0bcda9bf5badc19535','',1,500,0,0,'[email protected]',1597920250,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'GU3E-ZE5O-ME1O-NA0E','',0,'Adeilton Pessini','Cariacica',0,'',0,0,0,0,3018520994,0,'unknown',0,0,0,0,0,0,'27/2/1996','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(49,'HJCOUTINHO000','d1820e9ca06e596fbb7cf68899fbfdfc044ef37d','',1,500,0,0,'[email protected]',1597928438,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'EPUJ-A8OS-A0O1-AQEN','',0,'Hilton Junior','Piabeta',0,'',0,0,0,0,2327456745,0,'unknown',0,0,0,0,0,0,'17/4/1992','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(50,'LOCOMASTE1','3bfccc03236bc63aeda8b15932c139cfb5e3964f','',1,500,0,0,'[email protected]',1597951067,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'BIJE-6IGY-DUVE-5Y2U','',0,'Sofia Caste','Mexico',0,'',0,0,0,0,3147087065,0,'mx',0,0,0,0,0,0,'26/7/2000','female','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(51,'510510','f43c177af714f7cd4da75c7777c30698a3ee0ebb','',1,500,0,0,'[email protected]',1598049777,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'BYLY-RY4E-6U6U-BOSI','',0,'Kaique Sarmento de Oliveira','Montes Claros',0,'',0,0,0,0,2970261055,0,'br',0,0,0,0,0,0,'2/12/1992','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(52,'523523','b6d97e161fb218dbbcd7016745da2d39a1c4c8bd','',1,500,0,0,'[email protected]',1598055031,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'ISOD-ISEN-EPEX-OTIV','',0,'Michel Cavalheiro','Rio Grande Rs',0,'',0,0,0,0,3051130848,0,'unknown',0,0,0,0,0,0,'17/2/1995','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(53,'FELIPEH44G','db07aec8e9aebfc1081a1f1bfbb6df66fb47fa84','',1,500,0,0,'[email protected]',1598126284,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'9YXY-XARI-ZYXU-HO7O','',0,'Felipe Haag','Blumenau',0,'',0,0,0,0,2317668289,0,'unknown',0,0,0,0,0,0,'7/11/1997','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(54,'WEVERR123','9792e57a5c226b8976bc89c29ebe2e0106516214','',1,500,0,0,'[email protected]',1598138103,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'1U6O-TY2O-6Y2Y-WULU','',0,'Swerd Outs','Barra do PiraÃÂ',0,'',0,0,0,0,3010171871,0,'unknown',0,0,0,0,0,0,'29/10/1992','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(55,'JONEX15','a2c1b99740bff6e5c721612144c95813e95f3635','',1,500,0,0,'[email protected]',1598195708,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'A2ES-ATA5-EXUJ-EZA1','',0,'Jonas ferreira Reis','Araguari',0,'',0,0,0,0,3149229908,0,'mx',0,0,0,0,0,0,'13/10/1994','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(56,'3236322','8dc26f96c3711f44d8af02edd8efff93194610dc','',1,500,0,0,'[email protected]',1598198382,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'RUZO-9IQI-2UJU-RO5O','',0,'Aquele Um','Logo ali',0,'',0,0,0,0,3138873259,0,'br',0,0,0,0,0,0,'1/12/1989','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(57,'MAHHCPS','172cfdad22934bc5d6a650685d5b3e210e958cf1','',1,500,0,0,'[email protected]',1598233163,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'0OPO-PU1A-4OHI-RYXU','',0,'23123 123213','12312312',0,'',0,0,0,0,3377607370,0,'br',0,0,0,0,0,0,'28/11/1991','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(58,'FELIPEGLIMA','ea0632ac98aa774d2a126683ded17fb9cc30c4d0','',1,500,0,0,'[email protected]',1598244301,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'1E2Y-2ILU-6OXI-8ASE','',0,'Felipe Lima','São Paulo',0,'',0,0,0,0,2974932289,0,'br',0,0,0,0,0,0,'21/1/1999','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(59,'3853855','c316eb726a40ab38c29b37e632da4bd66a8e4904','',1,500,0,0,'[email protected]',1598315115,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'MY8I-ZY0U-5UTE-BAMY','',0,'Guillermo Ernesto','Mexico',0,'',0,0,0,0,3185237115,0,'mx',0,0,0,0,0,0,'10/10/1995','male','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(60,'JOSUEH','3bd13526c3b333d4c568e172d875f9ce267a1269','',1,500,0,0,'[email protected]',1598327671,0,'2020-10-24 18:45:37.966','2020-10-24 18:45:37.918',0,'Y1IT-ERY3-U5I9-IJYV','',0,'Aurora Polar','Candy',0,'',0,0,0,0,2979791997,0,'br',0,0,0,0,0,0,'25/12/1997','female','','2020-11-05 20:27:43.615','','',0,'',0,0,0),(61,'154154','3c5f649ff3026812a9012ec7afdf8a38a954bf25','',1,500,4740,0,'[email protected]',1603561937,0,'2021-03-12 04:54:35.000','2020-10-24 18:45:37.918',0,'BOJA-POPI-MU1I-NODA','',0,'Asdas Asdasd','Sadsa',0,'',0,0,0,0,3014936805,1603562308,'unknown',0,0,0,0,0,0,'17/4/1991','female','Pedro','2020-11-05 20:27:43.615','','uploads/1604865680534-Logo_Hati.png',0,'',0,0,0),(62,'123456789','f7c3bc1d808e04732adf679965ccc34ca7ae3441',NULL,1,0,0,0,'[email protected]',0,0,'2020-11-08 19:26:49.000','2020-11-08 19:26:49.000',0,'0','',0,'','',0,'',0,0,0,0,0,0,'',0,0,0,0,0,0,'','','','2020-11-08 19:26:49.518','','',0,'',NULL,0,0),(63,'654321','dd5fef9c1c1da1394d6d34b248c51be2ad740840',NULL,1,0,0,0,'[email protected]',0,0,'2020-11-08 19:28:02.000','2020-11-08 19:28:02.000',0,'0','',0,'','',0,'',0,0,0,0,0,0,'',0,0,0,0,0,0,'','','','2020-11-08 19:28:02.649','','',0,'',NULL,0,0),(64,'102030','ec7117851c0e5dbaad4effdb7cd17c050cea88cb',NULL,1,0,0,0,'[email protected]',0,0,'2020-11-15 19:31:03.000','2020-11-15 19:30:27.000',0,'0','',0,'Pedro Henrique','Hell de Janeiro',0,'',0,0,0,0,0,0,'',0,0,0,0,0,0,'','','Yinzera','2020-11-15 19:30:27.586','','',0,'',NULL,0,0),(65,'525760','169d16cbbe04b2112fb051bf0c0ddaaf2410e592',NULL,1,0,0,0,'[email protected]',0,0,'2020-11-15 19:32:30.000','2020-11-15 19:32:30.000',0,'0','',0,'','',0,'',0,0,0,0,0,0,'',0,0,0,0,0,0,'','','','2020-11-15 19:32:30.615','','',0,'',NULL,0,0),(66,'321123','169d16cbbe04b2112fb051bf0c0ddaaf2410e592',NULL,1,0,0,0,'[email protected]',0,0,'2020-11-18 00:35:50.000','2020-11-18 00:35:50.000',0,'0','',0,'','',0,'',0,0,0,0,0,0,'',0,0,0,0,0,0,'','','','2020-11-18 00:35:50.610','','',0,'',NULL,0,0),(67,'1020304','169d16cbbe04b2112fb051bf0c0ddaaf2410e592',NULL,1,0,0,0,'[email protected]',0,0,'2020-11-18 02:19:00.000','2020-11-18 02:19:00.000',0,'0','',0,'','',0,'',0,0,0,0,0,0,'',0,0,0,0,0,0,'','','','2020-11-18 02:19:00.316','','',0,'',NULL,0,0),(68,'167167','169d16cbbe04b2112fb051bf0c0ddaaf2410e592',NULL,1,0,0,0,'[email protected]',0,0,'2021-03-14 05:18:44.000','2021-03-14 05:18:44.000',0,'0','',0,'','',0,'',0,0,0,0,0,0,'',0,0,0,0,0,0,'','','','2021-03-14 05:18:44.939','','',0,'',NULL,0,0);
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `accounts_options`
--
DROP TABLE IF EXISTS `accounts_options`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts_options` (
`account_id` int NOT NULL,
`options` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts_options`
--
LOCK TABLES `accounts_options` WRITE;
/*!40000 ALTER TABLE `accounts_options` DISABLE KEYS */;
/*!40000 ALTER TABLE `accounts_options` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `announcements`
--
DROP TABLE IF EXISTS `announcements`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `announcements` (
`id` int NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL,
`text` varchar(255) NOT NULL,
`date` varchar(20) NOT NULL,
`author` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `announcements`
--
LOCK TABLES `announcements` WRITE;
/*!40000 ALTER TABLE `announcements` DISABLE KEYS */;
/*!40000 ALTER TABLE `announcements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `atr_wiki_category`
--
DROP TABLE IF EXISTS `atr_wiki_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `atr_wiki_category` (
`id_atr_wiki_category` int NOT NULL AUTO_INCREMENT,
`nome` varchar(255) NOT NULL,
`descricao` varchar(255) NOT NULL,
`text` text NOT NULL,
`dta_insert` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`dta_update` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`dta_deleted` datetime DEFAULT NULL,
`is_active` tinyint NOT NULL DEFAULT '1',
PRIMARY KEY (`id_atr_wiki_category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `atr_wiki_category`
--
LOCK TABLES `atr_wiki_category` WRITE;
/*!40000 ALTER TABLE `atr_wiki_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `atr_wiki_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `atr_wiki_subcategory`
--
DROP TABLE IF EXISTS `atr_wiki_subcategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `atr_wiki_subcategory` (
`id_atr_wiki_subcategory` int NOT NULL AUTO_INCREMENT,
`id_atr_wiki_category` int NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`text` text NOT NULL,
`dta_insert` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`dta_update` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`dta_deleted` datetime DEFAULT NULL,
`is_active` tinyint NOT NULL DEFAULT '1',
PRIMARY KEY (`id_atr_wiki_subcategory`),
KEY `FK_ID_wiki_CATEGORY_idx` (`id_atr_wiki_category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `atr_wiki_subcategory`
--
LOCK TABLES `atr_wiki_subcategory` WRITE;
/*!40000 ALTER TABLE `atr_wiki_subcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `atr_wiki_subcategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `blessings_history`
--
DROP TABLE IF EXISTS `blessings_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blessings_history` (
`id` int NOT NULL,
`player_id` int NOT NULL,
`blessing` tinyint NOT NULL,
`loss` tinyint(1) NOT NULL,
`timestamp` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `blessings_history`
--
LOCK TABLES `blessings_history` WRITE;
/*!40000 ALTER TABLE `blessings_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `blessings_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `comments`
--
DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `comments` (
`id` int NOT NULL AUTO_INCREMENT,
`post_content` longtext NOT NULL,
`character_name` varchar(255) NOT NULL,
`thread_id` int NOT NULL,
`account_id` int NOT NULL,
`createdAt` datetime NOT NULL,
`updatedAt` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `thread_id` (`thread_id`),
KEY `account_id` (`account_id`),
CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`thread_id`) REFERENCES `threads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `comments`
--
LOCK TABLES `comments` WRITE;
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `daily_reward_history`
--
DROP TABLE IF EXISTS `daily_reward_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `daily_reward_history` (
`id` int NOT NULL AUTO_INCREMENT,
`daystreak` smallint NOT NULL DEFAULT '0',
`player_id` int NOT NULL,
`timestamp` int NOT NULL,
`description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `player_id` (`player_id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `daily_reward_history`
--
LOCK TABLES `daily_reward_history` WRITE;
/*!40000 ALTER TABLE `daily_reward_history` DISABLE KEYS */;
INSERT INTO `daily_reward_history` VALUES (1,0,3479,1587249495,'Claimed reward no. 1. Picked items: 10x mana potion.'),(2,0,14,1588807027,'Claimed reward no. 1. Picked items: 10x health potion.'),(3,0,11,1588814225,'Claimed reward no. 1. Picked items: 10x mana potion.'),(4,0,21,1588817377,'Claimed reward no. 1. Picked items: 10x health potion.'),(5,0,5,1588823346,'Claimed reward no. 1. Picked items: 10x strong health potion.'),(6,0,3,1588859897,'Claimed reward no. 1. Picked items: 10x mana potion.'),(7,0,12,1588860253,'Claimed reward no. 1. Picked items: 10x mana potion.'),(8,1,11,1588882478,'Claimed reward no. 2. Picked items: 10x mana potion.'),(9,1,5,1588910028,'Claimed reward no. 2. Picked items: 10x mana potion.'),(10,1,14,1588910088,'Claimed reward no. 2. Picked items: 10x mana potion.'),(11,1,21,1588915764,'Claimed reward no. 2. Picked items: 10x health potion.'),(12,2,11,1588951183,'Claimed reward no. 3. Picked items: 10x strong mana potion.'),(13,0,36,1588976486,'Claimed reward no. 1. Picked items: 10x mana potion.'),(14,2,14,1589036682,'Claimed reward no. 3. Picked items: 10x mana potion.'),(15,0,9,1589055515,'Claimed reward no. 1. Picked items: 10x strong mana potion.'),(16,2,5,1589070081,'Claimed reward no. 3. Picked items: 10x mana potion.'),(17,0,52,1597867519,'Claimed reward no. 1. Picked items: 10x mana potion.'),(18,0,53,1597867556,'Claimed reward no. 1. Picked items: 10x health potion.'),(19,0,55,1597867852,'Claimed reward no. 1. Picked items: 10x mana potion.'),(20,0,56,1597878827,'Claimed reward no. 1. Picked items: 10x strong mana potion.'),(21,1,52,1597950882,'Claimed reward no. 2. Picked items: 10x great spirit potion.'),(22,1,55,1597950927,'Claimed reward no. 2. Picked items: 10x mana potion.'),(23,1,53,1597950962,'Claimed reward no. 2. Picked items: 10x great spirit potion.'),(24,0,67,1597951664,'Claimed reward no. 1. Picked items: 10x great spirit potion.'),(25,0,68,1597951847,'Claimed reward no. 1. Picked items: 10x great spirit potion.'),(26,0,66,1597952178,'Claimed reward no. 1. Picked items: 10x great spirit potion.'),(27,0,62,1597952336,'Claimed reward no. 1. Picked items: 10x great spirit potion.'),(28,1,56,1597956401,'Claimed reward no. 2. Picked items: 10x strong mana potion.'),(29,0,65,1597961447,'Claimed reward no. 1. Picked items: 10x great spirit potion.'),(30,0,64,1597961676,'Claimed reward no. 1. Picked items: 10x great spirit potion.'),(31,0,63,1597961925,'Claimed reward no. 1. Picked items: 10x great spirit potion.'),(32,2,56,1598021194,'Claimed reward no. 3. Picked items: 10x strong mana potion.'),(33,2,55,1598045492,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(34,2,53,1598045523,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(35,1,67,1598045570,'Claimed reward no. 2. Picked items: 10x great spirit potion.'),(36,1,68,1598045602,'Claimed reward no. 2. Picked items: 10x great spirit potion.'),(37,1,66,1598045630,'Claimed reward no. 2. Picked items: 10x great spirit potion.'),(38,1,62,1598045659,'Claimed reward no. 2. Picked items: 10x great spirit potion.'),(39,1,65,1598045685,'Claimed reward no. 2. Picked items: 10x great spirit potion.'),(40,1,64,1598045713,'Claimed reward no. 2. Picked items: 10x great spirit potion.'),(41,1,63,1598045749,'Claimed reward no. 2. Picked items: 10x great spirit potion.'),(42,2,52,1598045799,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(43,3,52,1598107512,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(44,3,55,1598107536,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(45,3,53,1598107566,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(46,2,63,1598107640,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(47,2,64,1598107672,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(48,2,65,1598107724,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(49,2,62,1598107752,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(50,2,66,1598107783,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(51,2,68,1598107808,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(52,2,67,1598107834,'Claimed reward no. 3. Picked items: 10x great spirit potion.'),(53,3,56,1598114958,'Claimed reward no. 4. Picked items: 20x strong mana potion.'),(54,4,52,1598190213,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(55,4,55,1598190235,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(56,4,53,1598190264,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(57,3,67,1598190326,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(58,3,68,1598190351,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(59,3,66,1598190377,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(60,3,62,1598190404,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(61,3,65,1598190450,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(62,3,64,1598190480,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(63,3,63,1598190508,'Claimed reward no. 4. Picked items: 20x great spirit potion.'),(64,4,56,1598211631,'Claimed reward no. 5. Picked items: 10x strong mana potion.'),(65,5,52,1598275241,'Claimed reward no. 6. Picked items: 2x training rod.'),(66,5,55,1598275265,'Claimed reward no. 6. Picked items: 2x training rod.'),(67,5,53,1598275339,'Claimed reward no. 6. Picked items: 2x training rod.'),(68,4,67,1598275481,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(69,4,68,1598275506,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(70,4,66,1598275530,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(71,4,62,1598275562,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(72,4,65,1598275590,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(73,4,64,1598275617,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(74,4,63,1598275645,'Claimed reward no. 5. Picked items: 10x great spirit potion.'),(75,6,52,1598395947,'Claimed reward no. 7. Picked reward: XP Bonus for 30 minutes.');
/*!40000 ALTER TABLE `daily_reward_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dtt_results`
--
DROP TABLE IF EXISTS `dtt_results`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dtt_results` (
`id` int NOT NULL AUTO_INCREMENT,
`frags_blue` int NOT NULL,
`frags_red` int NOT NULL,
`towers_blue` int NOT NULL,
`towers_red` int NOT NULL,
`data` varchar(255) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
`hora` varchar(255) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dtt_results`
--
LOCK TABLES `dtt_results` WRITE;
/*!40000 ALTER TABLE `dtt_results` DISABLE KEYS */;
/*!40000 ALTER TABLE `dtt_results` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forum_board`
--
DROP TABLE IF EXISTS `forum_board`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `forum_board` (
`id` int NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`topics` int NOT NULL DEFAULT '0',
`posts` int NOT NULL DEFAULT '0',
`createdAt` datetime NOT NULL,
`updatedAt` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forum_board`
--
LOCK TABLES `forum_board` WRITE;
/*!40000 ALTER TABLE `forum_board` DISABLE KEYS */;
INSERT INTO `forum_board` VALUES (1,'News','Hati News;',0,0,'2020-12-02 23:36:54','2020-12-02 23:36:54'),(2,'Trade','Teste',0,0,'2021-04-28 20:18:53','2021-04-28 20:18:53');
/*!40000 ALTER TABLE `forum_board` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `global_misc`
--
DROP TABLE IF EXISTS `global_misc`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `global_misc` (
`key` int NOT NULL,
`world_id` tinyint unsigned NOT NULL DEFAULT '0',
`info` blob NOT NULL,
UNIQUE KEY `key` (`key`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `global_misc`
--
LOCK TABLES `global_misc` WRITE;
/*!40000 ALTER TABLE `global_misc` DISABLE KEYS */;
/*!40000 ALTER TABLE `global_misc` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `global_storage`
--
DROP TABLE IF EXISTS `global_storage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `global_storage` (
`key` int DEFAULT NULL,
`world_id` tinyint unsigned NOT NULL DEFAULT '0',
`value` int DEFAULT NULL,
UNIQUE KEY `key` (`key`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `global_storage`
--
LOCK TABLES `global_storage` WRITE;
/*!40000 ALTER TABLE `global_storage` DISABLE KEYS */;
INSERT INTO `global_storage` VALUES (14110,0,1598518800),(3306,0,1598518877);
/*!40000 ALTER TABLE `global_storage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guild_invites`
--
DROP TABLE IF EXISTS `guild_invites`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guild_invites` (
`id` int NOT NULL AUTO_INCREMENT,
`player_id` int DEFAULT NULL,
`guild_id` int NOT NULL,
`date` datetime DEFAULT NULL,
`createdAt` datetime NOT NULL,
`updatedAt` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `player_id` (`player_id`),
KEY `guild_id` (`guild_id`),
CONSTRAINT `guild_invites_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON UPDATE CASCADE,
CONSTRAINT `guild_invites_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guild_invites`
--
LOCK TABLES `guild_invites` WRITE;
/*!40000 ALTER TABLE `guild_invites` DISABLE KEYS */;
INSERT INTO `guild_invites` VALUES (3,49,10,'2021-03-07 20:48:31','2021-03-07 20:48:31','2021-03-07 20:48:31'),(4,52,10,'2021-04-01 00:13:00','2021-04-01 00:13:00','2021-04-01 00:13:00');
/*!40000 ALTER TABLE `guild_invites` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guild_membership`
--
DROP TABLE IF EXISTS `guild_membership`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guild_membership` (
`id` int NOT NULL AUTO_INCREMENT,
`player_id` int DEFAULT NULL,
`guild_id` int NOT NULL,
`rank` int DEFAULT NULL,
`nick` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `player_id` (`player_id`),
KEY `guild_id` (`guild_id`),
CONSTRAINT `guild_membership_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON UPDATE CASCADE,
CONSTRAINT `guild_membership_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 ;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guild_membership`
--
LOCK TABLES `guild_membership` WRITE;
/*!40000 ALTER TABLE `guild_membership` DISABLE KEYS */;
INSERT INTO `guild_membership` VALUES (10,2,10,3,NULL),(11,83,10,1,NULL);
/*!40000 ALTER TABLE `guild_membership` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guild_ranks`
--
DROP TABLE IF EXISTS `guild_ranks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guild_ranks` (
`id` int NOT NULL AUTO_INCREMENT,
`guild_id` int NOT NULL,
`name` varchar(255) NOT NULL,
`level` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `guild_id` (`guild_id`),
CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 ;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guild_ranks`
--
LOCK TABLES `guild_ranks` WRITE;
/*!40000 ALTER TABLE `guild_ranks` DISABLE KEYS */;
INSERT INTO `guild_ranks` VALUES (28,10,'Leader',3),(29,10,'Vice',2),(30,10,'Member',1);
/*!40000 ALTER TABLE `guild_ranks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guild_wars`
--
DROP TABLE IF EXISTS `guild_wars`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guild_wars` (
`id` int NOT NULL AUTO_INCREMENT,
`guild1` int NOT NULL DEFAULT '0',
`guild2` int NOT NULL DEFAULT '0',
`name1` varchar(255) NOT NULL,
`name2` varchar(255) NOT NULL,
`status` tinyint NOT NULL DEFAULT '0',
`started` bigint NOT NULL DEFAULT '0',
`ended` bigint NOT NULL DEFAULT '0',
`toend` bigint NOT NULL DEFAULT '0',
`buyin` bigint NOT NULL DEFAULT '0',
`fraglimit` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `guild1` (`guild1`),
KEY `guild2` (`guild2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guild_wars`
--
LOCK TABLES `guild_wars` WRITE;
/*!40000 ALTER TABLE `guild_wars` DISABLE KEYS */;
/*!40000 ALTER TABLE `guild_wars` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guilds`
--
DROP TABLE IF EXISTS `guilds`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guilds` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`ownerid` int NOT NULL,
`creationdata` bigint NOT NULL,
`motd` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL,
`guild_logo` mediumblob,
`create_ip` int NOT NULL DEFAULT '0',
`balance` bigint NOT NULL DEFAULT '0',
`last_execute_points` int NOT NULL DEFAULT '0',
`logo_gfx_name` varchar(255) NOT NULL DEFAULT '',
`createdAt` datetime NOT NULL,
`updatedAt` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ownerid` (`ownerid`),
UNIQUE KEY `creationdata` (`creationdata`),
CONSTRAINT `guilds_ibfk_1` FOREIGN KEY (`ownerid`) REFERENCES `players` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guilds`
--
LOCK TABLES `guilds` WRITE;
/*!40000 ALTER TABLE `guilds` DISABLE KEYS */;
INSERT INTO `guilds` VALUES (10,'Cain o Brabo',2,1607911150859,'','é isso mlq :P',NULL,0,0,0,'uploads/guilds/guildLogo-1615679766608-logob-40x40.png','2020-12-14 01:59:10','2021-03-13 23:56:06');
/*!40000 ALTER TABLE `guilds` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guildwar_deaths`
--
DROP TABLE IF EXISTS `guildwar_deaths`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guildwar_deaths` (
`id` int NOT NULL AUTO_INCREMENT,
`player_id` int NOT NULL,
`kills` int NOT NULL,
`deaths` int NOT NULL,
`warid` int NOT NULL DEFAULT '0',
`time` bigint NOT NULL,
PRIMARY KEY (`id`),
KEY `player_id` (`player_id`),
KEY `warid` (`warid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guildwar_deaths`
--
LOCK TABLES `guildwar_deaths` WRITE;
/*!40000 ALTER TABLE `guildwar_deaths` DISABLE KEYS */;
/*!40000 ALTER TABLE `guildwar_deaths` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guildwar_kills`
--
DROP TABLE IF EXISTS `guildwar_kills`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guildwar_kills` (
`id` int NOT NULL AUTO_INCREMENT,
`killer` varchar(50) NOT NULL,
`target` varchar(50) NOT NULL,
`killerguild` int NOT NULL DEFAULT '0',
`targetguild` int NOT NULL DEFAULT '0',
`warid` int NOT NULL DEFAULT '0',
`time` bigint NOT NULL,
PRIMARY KEY (`id`),
KEY `warid` (`warid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guildwar_kills`
--
LOCK TABLES `guildwar_kills` WRITE;
/*!40000 ALTER TABLE `guildwar_kills` DISABLE KEYS */;
/*!40000 ALTER TABLE `guildwar_kills` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `house_lists`
--
DROP TABLE IF EXISTS `house_lists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `house_lists` (
`house_id` int NOT NULL,
`listid` int NOT NULL,
`list` text NOT NULL,
KEY `house_id` (`house_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `house_lists`
--
LOCK TABLES `house_lists` WRITE;
/*!40000 ALTER TABLE `house_lists` DISABLE KEYS */;
INSERT INTO `house_lists` VALUES (2,257,'Yanmi\nMecha'),(3,257,'Mecha');
/*!40000 ALTER TABLE `house_lists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `houses`
--
DROP TABLE IF EXISTS `houses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `houses` (
`id` int NOT NULL AUTO_INCREMENT,
`owner` int NOT NULL,
`paid` int unsigned NOT NULL DEFAULT '0',
`warnings` int NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL,
`rent` int NOT NULL DEFAULT '0',
`town_id` int NOT NULL DEFAULT '0',
`bid` int NOT NULL DEFAULT '0',
`bid_end` int NOT NULL DEFAULT '0',
`last_bid` int NOT NULL DEFAULT '0',
`highest_bidder` int NOT NULL DEFAULT '0',
`size` int NOT NULL DEFAULT '0',
`beds` int NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `owner` (`owner`),
KEY `town_id` (`town_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3171 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `houses`
--
LOCK TABLES `houses` WRITE;
/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
INSERT INTO `houses` VALUES (1,0,0,0,'Verona Temple Lane III',0,2,0,0,0,0,51,1),(2,52,0,0,'Verona Temple Lane I',0,2,0,0,0,0,33,1),(3,53,0,0,'Verona Temple Lane II',0,2,0,0,0,0,27,1),(4,0,0,0,'Verona Shop Flats Ia',0,2,0,0,0,0,17,0),(5,0,0,0,'Verona Shop Flats Ib',0,2,0,0,0,0,17,1),(6,0,0,0,'Verona Shop Flats Ic',0,2,0,0,0,0,13,2),(7,0,0,0,'Verona Temple Lane II (higher floor)',0,2,0,0,0,0,25,1),(8,0,0,0,'Verona Temple Lane III (higher floor)',0,2,0,0,0,0,21,1),(9,0,0,0,'Verona Hotel Apartments I',0,2,0,0,0,0,21,2),(10,0,0,0,'Verona Hotel Apartments II',0,2,0,0,0,0,11,0),(11,0,0,0,'Verona Hotel Apartments III',0,2,0,0,0,0,38,2),(12,0,0,0,'Verona Hotel Apartments IV',0,2,0,0,0,0,22,2),(13,0,0,0,'Verona Hotel Apartments V',0,2,0,0,0,0,14,0),(14,0,0,0,'Verona Hotel Apartments VI',0,2,0,0,0,0,12,0),(15,0,0,0,'Verona Hotel Apartments VII',0,2,0,0,0,0,29,1),(16,0,0,0,'Verona Hotel Apartments VIII',0,2,0,0,0,0,21,2),(17,0,0,0,'Verona Hotel Apartments IX',0,2,0,0,0,0,11,0),(18,0,0,0,'Verona Hotel Apartments X',0,2,0,0,0,0,34,0),(19,0,0,0,'Verona Ship Lane I',0,2,0,0,0,0,16,1),(20,0,0,0,'Verona Ship Lane II',0,2,0,0,0,0,17,1),(21,0,0,0,'Verona Ship Lane III',0,2,0,0,0,0,17,1),(22,0,0,0,'Verona Ship Lane IV (second floor)',0,2,0,0,0,0,17,2),(23,0,0,0,'Verona Ship Lane V (second floor)',0,2,0,0,0,0,13,0),(24,0,0,0,'Verona Ship Lane VI (second floor)',0,2,0,0,0,0,17,1),(25,0,0,0,'Verona Ship Lane III (ground floor)',0,2,0,0,0,0,17,1),(26,0,0,0,'Verona Ship Lane IV (ground floor)',0,2,0,0,0,0,13,0),(27,0,0,0,'Verona Ship Lane V (ground floor)',0,2,0,0,0,0,17,2),(28,0,0,0,'Verona Shop Flats IIa',0,2,0,0,0,0,21,1),(29,0,0,0,'Verona Shop Flats IIb',0,2,0,0,0,0,13,1),(30,0,0,0,'Verona Shop Flats IIc',0,2,0,0,0,0,10,1),(31,0,0,0,'Verona Shop Flats IId',0,2,0,0,0,0,13,1),(32,0,0,0,'Verona Depot Apartments I',0,2,0,0,0,0,22,2),(33,0,0,0,'Verona Depot Apartments II',0,2,0,0,0,0,25,1),(34,0,0,0,'Verona Depot Apartments I (first floor)',0,2,0,0,0,0,22,2),(35,0,0,0,'Verona Depot Apartments II (first floor)',0,2,0,0,0,0,28,1),(36,0,0,0,'Verona Depot Apartments III',0,2,0,0,0,0,24,0),(37,0,0,0,'Verona Depot Apartments IV',0,2,0,0,0,0,19,2),(38,0,0,0,'Verona Depot Apartments III (higher floor)',0,2,0,0,0,0,22,1),(39,0,0,0,'Verona Depot Apartments IV (higher floor)',0,2,0,0,0,0,13,0),(40,0,0,0,'Verona Shop Flats Id',0,2,0,0,0,0,11,0),(41,0,0,0,'Paupers Palace, Flat 27',685,1,0,0,0,0,24,2),(42,0,0,0,'Paupers Palace, Flat 25',585,1,0,0,0,0,24,1),(43,0,0,0,'Paupers Palace, Flat 31',855,1,0,0,0,0,28,1),(44,0,0,0,'Paupers Palace, Flat 32',1135,1,0,0,0,0,32,2),(45,0,0,0,'Paupers Palace, Flat 33',765,1,0,0,0,0,31,1),(46,0,0,0,'Paupers Palace, Flat 34',1675,1,0,0,0,0,51,2),(47,0,0,0,'Salvation Street 1 (Shop)',6240,1,0,0,0,0,200,4),(49,0,0,0,'Dream Street 1 (Shop)',4330,1,0,0,0,0,147,2),(50,0,0,0,'Blessed Shield Guildhall',8090,1,0,0,0,0,274,9),(51,0,0,0,'Dagger Alley 1',2665,1,0,0,0,0,93,2),(52,0,0,0,'Steel Home',13845,1,0,0,0,0,384,13),(53,0,0,0,'Iron Alley 1',3450,1,0,0,0,0,111,4),(54,0,0,0,'Iron Alley 2',3450,1,0,0,0,0,108,4),(55,0,0,0,'Swamp Watch',11090,1,0,0,0,0,347,12),(57,0,0,0,'Salvation Street 2',3790,1,0,0,0,0,123,2),(60,0,0,0,'Salvation Street 3',3790,1,0,0,0,0,129,2),(61,0,0,0,'Silver Street 3',1980,1,0,0,0,0,61,1),(62,0,0,0,'Golden Axe Guildhall',10485,1,0,0,0,0,381,10),(63,0,0,0,'Silver Street 1',2565,1,0,0,0,0,120,1),(64,0,0,0,'Silver Street 2',1980,1,0,0,0,0,66,1),(66,0,0,0,'Silver Street 4',3295,1,0,0,0,0,136,2),(67,0,0,0,'Mystic Lane 2',2980,1,0,0,0,0,99,2),(69,0,0,0,'Mystic Lane 1',2945,1,0,0,0,0,115,3),(70,0,0,0,'Loot Lane 1 (Shop)',4565,1,0,0,0,0,194,3),(71,0,0,0,'Market Street 6',5485,1,0,0,0,0,212,5),(72,0,0,0,'Market Street 7',2305,1,0,0,0,0,110,2),(73,0,0,0,'Market Street 5 (Shop)',6375,1,0,0,0,0,214,4),(194,0,0,0,'Lucky Lane 1 (Shop)',6960,1,0,0,0,0,211,4),(208,0,0,0,'Underwood 1',1495,5,0,0,0,0,41,2),(209,0,0,0,'Underwood 2',1495,5,0,0,0,0,41,2),(210,0,0,0,'Underwood 5',1370,5,0,0,0,0,35,3),(211,0,0,0,'Underwood 3',1685,5,0,0,0,0,44,3),(212,0,0,0,'Underwood 4',2235,5,0,0,0,0,56,4),(213,0,0,0,'Underwood 10',585,5,0,0,0,0,20,1),(214,0,0,0,'Underwood 6',1595,5,0,0,0,0,42,3),(215,0,0,0,'Great Willow 1a',500,5,0,0,0,0,16,1),(216,0,0,0,'Great Willow 1b',650,5,0,0,0,0,22,1),(217,0,0,0,'Great Willow 1c',650,5,0,0,0,0,22,1),(218,0,0,0,'Great Willow 2d',450,5,0,0,0,0,10,1),(219,0,0,0,'Great Willow 2c',650,5,0,0,0,0,21,1),(220,0,0,0,'Great Willow 2b',450,5,0,0,0,0,16,1),(221,0,0,0,'Great Willow 2a',650,5,0,0,0,0,17,1),(222,0,0,0,'Great Willow 3d',450,5,0,0,0,0,17,1),(223,0,0,0,'Great Willow 3c',650,5,0,0,0,0,21,1),(224,0,0,0,'Great Willow 3b',450,5,0,0,0,0,16,1),(225,0,0,0,'Great Willow 3a',650,5,0,0,0,0,20,1),(226,0,0,0,'Great Willow 4b',950,5,0,0,0,0,25,2),(227,0,0,0,'Great Willow 4c',950,5,0,0,0,0,25,2),(228,0,0,0,'Great Willow 4d',750,5,0,0,0,0,26,1),(229,0,0,0,'Great Willow 4a',950,5,0,0,0,0,25,2),(230,0,0,0,'Underwood 7',1460,5,0,0,0,0,39,2),(231,0,0,0,'Shadow Caves 3',300,5,0,0,0,0,16,1),(232,0,0,0,'Shadow Caves 4',300,5,0,0,0,0,18,1),(233,0,0,0,'Shadow Caves 2',300,5,0,0,0,0,18,1),(234,0,0,0,'Shadow Caves 1',300,5,0,0,0,0,16,1),(235,0,0,0,'Shadow Caves 17',300,5,0,0,0,0,16,1),(236,0,0,0,'Shadow Caves 18',300,5,0,0,0,0,17,1),(237,0,0,0,'Shadow Caves 15',300,5,0,0,0,0,16,1),(238,0,0,0,'Shadow Caves 16',300,5,0,0,0,0,17,1),(239,0,0,0,'Shadow Caves 13',300,5,0,0,0,0,16,1),(240,0,0,0,'Shadow Caves 14',300,5,0,0,0,0,19,1),(241,0,0,0,'Shadow Caves 11',300,5,0,0,0,0,16,1),(242,0,0,0,'Shadow Caves 12',300,5,0,0,0,0,18,1),(243,0,0,0,'Shadow Caves 27',300,5,0,0,0,0,14,1),(244,0,0,0,'Shadow Caves 28',300,5,0,0,0,0,17,1),(245,0,0,0,'Shadow Caves 25',300,5,0,0,0,0,16,1),(246,0,0,0,'Shadow Caves 26',300,5,0,0,0,0,17,1),(247,0,0,0,'Shadow Caves 23',300,5,0,0,0,0,16,1),(248,0,0,0,'Shadow Caves 24',300,5,0,0,0,0,19,1),(249,0,0,0,'Shadow Caves 21',300,5,0,0,0,0,16,1),(250,0,0,0,'Shadow Caves 22',300,5,0,0,0,0,17,1),(251,0,0,0,'Underwood 9',585,5,0,0,0,0,17,1),(252,0,0,0,'Treetop 13',1400,5,0,0,0,0,33,2),(254,0,0,0,'Underwood 8',865,5,0,0,0,0,25,2),(255,0,0,0,'Mangrove 4',950,5,0,0,0,0,25,2),(256,0,0,0,'Coastwood 10',1630,5,0,0,0,0,36,3),(257,0,0,0,'Mangrove 1',1750,5,0,0,0,0,42,3),(258,0,0,0,'Coastwood 1',980,5,0,0,0,0,24,2),(259,0,0,0,'Coastwood 2',980,5,0,0,0,0,24,2),(260,0,0,0,'Mangrove 2',1350,5,0,0,0,0,33,2),(262,0,0,0,'Mangrove 3',1150,5,0,0,0,0,29,2),(263,0,0,0,'Coastwood 9',935,5,0,0,0,0,22,1),(264,0,0,0,'Coastwood 8',1255,5,0,0,0,0,31,2),(265,0,0,0,'Coastwood 6 (Shop)',1595,5,0,0,0,0,44,1),(266,0,0,0,'Coastwood 7',660,5,0,0,0,0,19,1),(267,0,0,0,'Coastwood 5',1530,5,0,0,0,0,35,2),(268,0,0,0,'Coastwood 4',1145,5,0,0,0,0,30,2),(269,0,0,0,'Coastwood 3',1310,5,0,0,0,0,34,2),(270,0,0,0,'Treetop 11',900,5,0,0,0,0,26,2),(271,0,0,0,'Treetop 5 (Shop)',1350,5,0,0,0,0,40,1),(272,0,0,0,'Treetop 7',800,5,0,0,0,0,24,1),(273,0,0,0,'Treetop 6',450,5,0,0,0,0,15,1),(274,0,0,0,'Treetop 8',800,5,0,0,0,0,23,1),(275,0,0,0,'Treetop 9',1150,5,0,0,0,0,30,2),(276,0,0,0,'Treetop 10',1150,5,0,0,0,0,34,2),(277,0,0,0,'Treetop 4 (Shop)',1250,5,0,0,0,0,40,1),(278,0,0,0,'Treetop 3 (Shop)',1250,5,0,0,0,0,38,1),(279,0,0,0,'Treetop 2',650,5,0,0,0,0,21,1),(280,0,0,0,'Treetop 1',650,5,0,0,0,0,19,1),(281,0,0,0,'Treetop 12 (Shop)',1350,5,0,0,0,0,40,1),(469,0,0,0,'Darashia 2, Flat 07',1000,10,0,0,0,0,48,1),(470,0,0,0,'Darashia 2, Flat 01',1000,10,0,0,0,0,48,1),(471,0,0,0,'Darashia 2, Flat 02',1000,10,0,0,0,0,42,1),(472,0,0,0,'Darashia 2, Flat 06',520,10,0,0,0,0,24,1),(473,0,0,0,'Darashia 2, Flat 05',1260,10,0,0,0,0,48,2),(474,0,0,0,'Darashia 2, Flat 04',520,10,0,0,0,0,24,1),(475,0,0,0,'Darashia 2, Flat 03',1160,10,0,0,0,0,42,1),(476,0,0,0,'Darashia 2, Flat 13',1160,10,0,0,0,0,42,1),(477,0,0,0,'Darashia 2, Flat 12',520,10,0,0,0,0,24,1),(478,0,0,0,'Darashia 2, Flat 11',1000,10,0,0,0,0,42,1),(479,0,0,0,'Darashia 2, Flat 14',520,10,0,0,0,0,24,1),(480,0,0,0,'Darashia 2, Flat 15',1260,10,0,0,0,0,47,2),(481,0,0,0,'Darashia 2, Flat 16',680,10,0,0,0,0,30,1),(482,0,0,0,'Darashia 2, Flat 17',1000,10,0,0,0,0,48,1),(483,0,0,0,'Darashia 2, Flat 18',680,10,0,0,0,0,30,1),(484,0,0,0,'Darashia 1, Flat 05',1100,10,0,0,0,0,48,2),(485,0,0,0,'Darashia 1, Flat 01',1100,10,0,0,0,0,48,2),(486,0,0,0,'Darashia 1, Flat 04',1000,10,0,0,0,0,42,1),(487,0,0,0,'Darashia 1, Flat 03',2660,10,0,0,0,0,96,4),(488,0,0,0,'Darashia 1, Flat 02',1000,10,0,0,0,0,41,1),(490,0,0,0,'Darashia 1, Flat 12',1780,10,0,0,0,0,66,2),(491,0,0,0,'Darashia 1, Flat 11',1100,10,0,0,0,0,41,2),(492,0,0,0,'Darashia 1, Flat 13',1780,10,0,0,0,0,72,2),(493,0,0,0,'Darashia 1, Flat 14',2760,10,0,0,0,0,108,5),(494,0,0,0,'Darashia 4, Flat 01',1000,10,0,0,0,0,48,1),(495,0,0,0,'Darashia 4, Flat 05',1100,10,0,0,0,0,48,2),(496,0,0,0,'Darashia 4, Flat 04',1780,10,0,0,0,0,72,2),(497,0,0,0,'Darashia 4, Flat 03',1000,10,0,0,0,0,42,1),(498,0,0,0,'Darashia 4, Flat 02',1780,10,0,0,0,0,66,2),(499,0,0,0,'Darashia 4, Flat 13',1780,10,0,0,0,0,78,2),(500,0,0,0,'Darashia 4, Flat 14',1780,10,0,0,0,0,72,2),(501,0,0,0,'Darashia 4, Flat 11',1000,10,0,0,0,0,41,1),(502,0,0,0,'Darashia 4, Flat 12',2560,10,0,0,0,0,96,3),(503,0,0,0,'Darashia 7, Flat 05',1225,10,0,0,0,0,40,2),(504,0,0,0,'Darashia 7, Flat 01',1125,10,0,0,0,0,40,1),(505,0,0,0,'Darashia 7, Flat 02',1125,10,0,0,0,0,41,1),(506,0,0,0,'Darashia 7, Flat 03',2955,10,0,0,0,0,108,4),(507,0,0,0,'Darashia 7, Flat 04',1125,10,0,0,0,0,42,1),(508,0,0,0,'Darashia 7, Flat 14',2955,10,0,0,0,0,108,4),(509,0,0,0,'Darashia 7, Flat 13',1125,10,0,0,0,0,42,1),(510,0,0,0,'Darashia 7, Flat 11',1125,10,0,0,0,0,41,1),(511,0,0,0,'Darashia 7, Flat 12',2955,10,0,0,0,0,95,4),(512,0,0,0,'Darashia 5, Flat 01',1000,10,0,0,0,0,38,1),(513,0,0,0,'Darashia 5, Flat 05',1000,10,0,0,0,0,48,1),(514,0,0,0,'Darashia 5, Flat 02',1620,10,0,0,0,0,57,2),(515,0,0,0,'Darashia 5, Flat 03',1000,10,0,0,0,0,41,1),(516,0,0,0,'Darashia 5, Flat 04',1620,10,0,0,0,0,66,2),(517,0,0,0,'Darashia 5, Flat 11',1780,10,0,0,0,0,66,2),(518,0,0,0,'Darashia 5, Flat 12',1620,10,0,0,0,0,65,2),(519,0,0,0,'Darashia 5, Flat 13',1780,10,0,0,0,0,78,2),(520,0,0,0,'Darashia 5, Flat 14',1620,10,0,0,0,0,66,2),(521,0,0,0,'Darashia 6a',3115,10,0,0,0,0,117,2),(522,0,0,0,'Darashia 6b',3430,10,0,0,0,0,139,2),(523,0,0,0,'Darashia, Villa',5385,10,0,0,0,0,233,4),(525,0,0,0,'Darashia, Western Guildhall',10435,10,0,0,0,0,376,14),(526,0,0,0,'Darashia 3, Flat 01',1100,10,0,0,0,0,40,2),(527,0,0,0,'Darashia 3, Flat 05',1000,10,0,0,0,0,40,1),(529,0,0,0,'Darashia 3, Flat 02',1620,10,0,0,0,0,65,2),(530,0,0,0,'Darashia 3, Flat 03',1100,10,0,0,0,0,42,2),(531,0,0,0,'Darashia 3, Flat 04',1620,10,0,0,0,0,72,2),(532,0,0,0,'Darashia 3, Flat 13',1100,10,0,0,0,0,42,2),(533,0,0,0,'Darashia 3, Flat 14',2400,10,0,0,0,0,102,3),(534,0,0,0,'Darashia 3, Flat 11',1000,10,0,0,0,0,41,1),(535,0,0,0,'Darashia 3, Flat 12',2600,10,0,0,0,0,90,5),(541,0,0,0,'Darashia 8, Flat 11',1990,10,0,0,0,0,66,2),(542,0,0,0,'Darashia 8, Flat 12',1810,10,0,0,0,0,65,2),(544,0,0,0,'Darashia 8, Flat 14',1810,10,0,0,0,0,66,2),(545,0,0,0,'Darashia 8, Flat 13',1990,10,0,0,0,0,78,2),(574,0,0,0,'Oskahl I j',680,9,0,0,0,0,25,1),(575,0,0,0,'Oskahl I f',840,9,0,0,0,0,34,1),(576,0,0,0,'Oskahl I i',840,9,0,0,0,0,30,1),(577,0,0,0,'Oskahl I g',1140,9,0,0,0,0,42,2),(578,0,0,0,'Oskahl I h',1760,9,0,0,0,0,63,3),(579,0,0,0,'Oskahl I d',1140,9,0,0,0,0,36,2),(580,0,0,0,'Oskahl I b',840,9,0,0,0,0,30,1),(581,0,0,0,'Oskahl I c',680,9,0,0,0,0,29,1),(582,0,0,0,'Oskahl I e',840,9,0,0,0,0,33,1),(583,0,0,0,'Oskahl I a',1580,9,0,0,0,0,52,2),(584,0,0,0,'Chameken I',850,9,0,0,0,0,30,1),(585,0,0,0,'Charsirakh III',680,9,0,0,0,0,30,1),(586,0,0,0,'Murkhol I d',440,9,0,0,0,0,21,1),(587,0,0,0,'Murkhol I c',440,9,0,0,0,0,18,1),(588,0,0,0,'Murkhol I b',440,9,0,0,0,0,18,1),(589,0,0,0,'Murkhol I a',440,9,0,0,0,0,20,1),(590,0,0,0,'Charsirakh II',1140,9,0,0,0,0,39,2),(591,0,0,0,'Thanah II h',1400,9,0,0,0,0,40,2),(592,0,0,0,'Thanah II g',1650,9,0,0,0,0,45,2),(593,0,0,0,'Thanah II f',2850,9,0,0,0,0,80,3),(594,0,0,0,'Thanah II b',450,9,0,0,0,0,20,1),(595,0,0,0,'Thanah II c',450,9,0,0,0,0,15,1),(596,0,0,0,'Thanah II d',350,9,0,0,0,0,16,1),(597,0,0,0,'Thanah II e',350,9,0,0,0,0,12,1),(599,0,0,0,'Thanah II a',850,9,0,0,0,0,37,1),(600,0,0,0,'Thrarhor I c (Shop)',1050,9,0,0,0,0,28,1),(601,0,0,0,'Thrarhor I d (Shop)',1050,9,0,0,0,0,21,1),(602,0,0,0,'Thrarhor I a (Shop)',1050,9,0,0,0,0,32,1),(603,0,0,0,'Thrarhor I b (Shop)',1050,9,0,0,0,0,24,1),(604,0,0,0,'Thanah I c',3250,9,0,0,0,0,91,3),(605,0,0,0,'Thanah I d',2900,9,0,0,0,0,80,4),(606,0,0,0,'Thanah I b',3000,9,0,0,0,0,84,3),(607,0,0,0,'Thanah I a',850,9,0,0,0,0,27,1),(608,0,0,0,'Harrah I',5740,9,0,0,0,0,190,10),(609,0,0,0,'Charsirakh I b',1580,9,0,0,0,0,51,2),(610,0,0,0,'Charsirakh I a',280,9,0,0,0,0,15,1),(611,0,0,0,'Othehothep I d',2020,9,0,0,0,0,68,4),(612,0,0,0,'Othehothep I c',1720,9,0,0,0,0,58,3),(613,0,0,0,'Othehothep I b',1380,9,0,0,0,0,49,2),(614,0,0,0,'Othehothep I a',280,9,0,0,0,0,14,1),(615,0,0,0,'Othehothep II e',1340,9,0,0,0,0,44,2),(616,0,0,0,'Othehothep II f',1340,9,0,0,0,0,44,2),(617,0,0,0,'Othehothep II d',840,9,0,0,0,0,32,1),(618,0,0,0,'Othehothep II c',840,9,0,0,0,0,30,1),(619,0,0,0,'Othehothep II b',1920,9,0,0,0,0,67,3),(620,0,0,0,'Othehothep II a',400,9,0,0,0,0,18,1),(621,0,0,0,'Mothrem I',1140,9,0,0,0,0,38,2),(622,0,0,0,'Arakmehn I',1320,9,0,0,0,0,41,3),(623,0,0,0,'Othehothep III d',1040,9,0,0,0,0,36,1),(624,0,0,0,'Othehothep III c',940,9,0,0,0,0,30,2),(625,0,0,0,'Othehothep III e',840,9,0,0,0,0,32,1),(626,0,0,0,'Othehothep III f',680,9,0,0,0,0,27,1),(627,0,0,0,'Othehothep III b',1340,9,0,0,0,0,49,2),(628,0,0,0,'Othehothep III a',280,9,0,0,0,0,14,1),(629,0,0,0,'Unklath I d',1680,9,0,0,0,0,49,3),(630,0,0,0,'Unklath I e',1580,9,0,0,0,0,51,2),(631,0,0,0,'Unklath I g',1480,9,0,0,0,0,51,1),(632,0,0,0,'Unklath I f',1580,9,0,0,0,0,51,2),(633,0,0,0,'Unklath I c',1460,9,0,0,0,0,50,2),(634,0,0,0,'Unklath I b',1460,9,0,0,0,0,50,2),(635,0,0,0,'Unklath I a',1140,9,0,0,0,0,38,2),(636,0,0,0,'Arakmehn II',1040,9,0,0,0,0,38,1),(637,0,0,0,'Arakmehn III',1140,9,0,0,0,0,38,2),(638,0,0,0,'Unklath II b',680,9,0,0,0,0,25,1),(639,0,0,0,'Unklath II c',680,9,0,0,0,0,27,1),(640,0,0,0,'Unklath II d',1580,9,0,0,0,0,52,2),(641,0,0,0,'Unklath II a',1040,9,0,0,0,0,36,1),(642,0,0,0,'Arakmehn IV',1220,9,0,0,0,0,41,2),(643,0,0,0,'Rathal I b',680,9,0,0,0,0,25,1),(644,0,0,0,'Rathal I c',680,9,0,0,0,0,27,1),(645,0,0,0,'Rathal I e',780,9,0,0,0,0,27,2),(646,0,0,0,'Rathal I d',780,9,0,0,0,0,27,2),(647,0,0,0,'Rathal I a',1140,9,0,0,0,0,36,2),(648,0,0,0,'Rathal II b',680,9,0,0,0,0,25,1),(649,0,0,0,'Rathal II c',680,9,0,0,0,0,27,1),(650,0,0,0,'Rathal II d',1460,9,0,0,0,0,52,2),(651,0,0,0,'Rathal II a',1040,9,0,0,0,0,38,1),(653,0,0,0,'Esuph II a',280,9,0,0,0,0,14,1),(654,0,0,0,'Uthemath II',4460,9,0,0,0,0,137,8),(655,0,0,0,'Uthemath I e',940,9,0,0,0,0,32,2),(656,0,0,0,'Uthemath I d',840,9,0,0,0,0,30,1),(657,0,0,0,'Uthemath I f',2440,9,0,0,0,0,86,3),(658,0,0,0,'Uthemath I b',800,9,0,0,0,0,32,1),(659,0,0,0,'Uthemath I c',900,9,0,0,0,0,34,2),(660,0,0,0,'Uthemath I a',400,9,0,0,0,0,18,1),(661,0,0,0,'Botham I c',1700,9,0,0,0,0,49,2),(662,0,0,0,'Botham I e',1650,9,0,0,0,0,44,2),(663,0,0,0,'Botham I d',3050,9,0,0,0,0,80,3),(664,0,0,0,'Botham I b',3000,9,0,0,0,0,83,3),(666,0,0,0,'Horakhal',9420,9,0,0,0,0,277,14),(667,0,0,0,'Esuph III b',1340,9,0,0,0,0,49,2),(668,0,0,0,'Esuph III a',280,9,0,0,0,0,14,1),(669,0,0,0,'Esuph IV b',400,9,0,0,0,0,16,1),(670,0,0,0,'Esuph IV c',400,9,0,0,0,0,18,1),(671,0,0,0,'Esuph IV d',800,9,0,0,0,0,34,1),(672,0,0,0,'Esuph IV a',400,9,0,0,0,0,16,1),(673,0,0,0,'Botham II e',1650,9,0,0,0,0,42,2),(674,0,0,0,'Botham II g',1400,9,0,0,0,0,38,2),(675,0,0,0,'Botham II f',1650,9,0,0,0,0,44,2),(676,0,0,0,'Botham II d',1950,9,0,0,0,0,49,2),(677,0,0,0,'Botham II c',1250,9,0,0,0,0,38,2),(678,0,0,0,'Botham II b',1600,9,0,0,0,0,47,2),(679,0,0,0,'Botham II a',850,9,0,0,0,0,25,1),(680,0,0,0,'Botham III g',1650,9,0,0,0,0,42,2),(681,0,0,0,'Botham III f',2350,9,0,0,0,0,56,3),(682,0,0,0,'Botham III h',3750,9,0,0,0,0,98,3),(683,0,0,0,'Botham III d',850,9,0,0,0,0,27,1),(684,0,0,0,'Botham III e',850,9,0,0,0,0,27,1),(685,0,0,0,'Botham III b',950,9,0,0,0,0,25,2),(686,0,0,0,'Botham III c',850,9,0,0,0,0,27,1),(687,0,0,0,'Botham III a',1400,9,0,0,0,0,36,2),(688,0,0,0,'Botham IV i',1800,9,0,0,0,0,51,3),(689,0,0,0,'Botham IV h',1850,9,0,0,0,0,49,1),(690,0,0,0,'Botham IV f',1700,9,0,0,0,0,49,2),(691,0,0,0,'Botham IV g',1650,9,0,0,0,0,49,2),(692,0,0,0,'Botham IV c',850,9,0,0,0,0,27,1),(693,0,0,0,'Botham IV e',850,9,0,0,0,0,27,1),(694,0,0,0,'Botham IV d',850,9,0,0,0,0,27,1),(695,0,0,0,'Botham IV b',850,9,0,0,0,0,25,1),(696,0,0,0,'Botham IV a',1400,9,0,0,0,0,36,2),(697,0,0,0,'Ramen Tah',7650,9,0,0,0,0,184,16),(698,0,0,0,'Banana Bay 1',450,8,0,0,0,0,25,1),(699,0,0,0,'Banana Bay 2',765,8,0,0,0,0,36,1),(700,0,0,0,'Banana Bay 3',450,8,0,0,0,0,25,1),(701,0,0,0,'Banana Bay 4',450,8,0,0,0,0,25,1),(702,0,0,0,'Shark Manor',8780,8,0,0,0,0,286,15),(703,0,0,0,'Coconut Quay 1',1765,8,0,0,0,0,64,2),(704,0,0,0,'Coconut Quay 2',1045,8,0,0,0,0,42,2),(705,0,0,0,'Coconut Quay 3',2145,8,0,0,0,0,70,4),(706,0,0,0,'Coconut Quay 4',2135,8,0,0,0,0,72,3),(707,0,0,0,'Crocodile Bridge 3',1270,8,0,0,0,0,49,2),(708,0,0,0,'Crocodile Bridge 2',865,8,0,0,0,0,36,2),(709,0,0,0,'Crocodile Bridge 1',1045,8,0,0,0,0,42,2),(710,0,0,0,'Bamboo Garden 1',1640,8,0,0,0,0,63,3),(711,0,0,0,'Crocodile Bridge 4',4755,8,0,0,0,0,176,4),(712,0,0,0,'Crocodile Bridge 5',3970,8,0,0,0,0,157,2),(713,0,0,0,'Woodway 1',765,8,0,0,0,0,36,1),(714,0,0,0,'Woodway 2',585,8,0,0,0,0,30,1),(715,0,0,0,'Woodway 3',1540,8,0,0,0,0,65,2),(716,0,0,0,'Woodway 4',405,8,0,0,0,0,24,1),(717,0,0,0,'Flamingo Flats 5',1845,8,0,0,0,0,84,1),(718,0,0,0,'Bamboo Fortress',21970,8,0,0,0,0,848,20),(719,0,0,0,'Bamboo Garden 3',1540,8,0,0,0,0,63,2),(720,0,0,0,'Bamboo Garden 2',1045,8,0,0,0,0,42,2),(721,0,0,0,'Flamingo Flats 4',865,8,0,0,0,0,36,2),(722,0,0,0,'Flamingo Flats 2',1045,8,0,0,0,0,42,2),(723,0,0,0,'Flamingo Flats 3',685,8,0,0,0,0,30,2),(724,0,0,0,'Flamingo Flats 1',685,8,0,0,0,0,30,2),(725,0,0,0,'Jungle Edge 4',865,8,0,0,0,0,36,2),(726,0,0,0,'Jungle Edge 5',865,8,0,0,0,0,36,2),(727,0,0,0,'Jungle Edge 6',450,8,0,0,0,0,25,1),(728,0,0,0,'Jungle Edge 2',3170,8,0,0,0,0,128,3),(729,0,0,0,'Jungle Edge 3',865,8,0,0,0,0,36,2),(730,0,0,0,'Jungle Edge 1',2495,8,0,0,0,0,98,3),(731,0,0,0,'Haggler\'s Hangout 6',6450,8,0,0,0,0,208,4),(732,0,0,0,'Haggler\'s Hangout 5 (Shop)',1550,8,0,0,0,0,56,1),(733,0,0,0,'Haggler\'s Hangout 4a (Shop)',1850,8,0,0,0,0,56,1),(734,0,0,0,'Haggler\'s Hangout 4b (Shop)',1550,8,0,0,0,0,56,1),(735,0,0,0,'Haggler\'s Hangout 3',7550,8,0,0,0,0,256,4),(736,0,0,0,'Haggler\'s Hangout 2',1300,8,0,0,0,0,49,1),(737,0,0,0,'Haggler\'s Hangout 1',1400,8,0,0,0,0,49,2),(738,0,0,0,'River Homes 1',3485,8,0,0,0,0,128,3),(739,0,0,0,'River Homes 2a',1270,8,0,0,0,0,42,2),(740,0,0,0,'River Homes 2b',1595,8,0,0,0,0,56,3),(741,0,0,0,'River Homes 3',5055,8,0,0,0,0,176,7),(742,0,0,0,'The Treehouse',24120,8,0,0,0,0,897,23),(743,0,0,0,'Corner Shop (Shop)',2215,12,0,0,0,0,96,2),(744,0,0,0,'Tusk Flats 1',765,12,0,0,0,0,40,2),(745,0,0,0,'Tusk Flats 2',835,12,0,0,0,0,42,2),(746,0,0,0,'Tusk Flats 3',660,12,0,0,0,0,34,2),(747,0,0,0,'Tusk Flats 4',315,12,0,0,0,0,24,1),(748,0,0,0,'Tusk Flats 6',660,12,0,0,0,0,35,2),(749,0,0,0,'Tusk Flats 5',455,12,0,0,0,0,30,1),(750,0,0,0,'Shady Rocks 5',2890,12,0,0,0,0,110,2),(751,0,0,0,'Shady Rocks 4 (Shop)',2710,12,0,0,0,0,110,2),(752,0,0,0,'Shady Rocks 3',4115,12,0,0,0,0,154,3),(753,0,0,0,'Shady Rocks 2',2010,12,0,0,0,0,77,4),(754,0,0,0,'Shady Rocks 1',3630,12,0,0,0,0,132,4),(755,0,0,0,'Crystal Glance',19625,12,0,0,0,0,569,24),(756,0,0,0,'Arena Walk 3',3550,12,0,0,0,0,126,3),(757,0,0,0,'Arena Walk 2',1400,12,0,0,0,0,54,2),(758,0,0,0,'Arena Walk 1',3250,12,0,0,0,0,128,3),(759,0,0,0,'Bears Paw 2',2305,12,0,0,0,0,100,2),(760,0,0,0,'Bears Paw 1',1810,12,0,0,0,0,72,2),(761,0,0,0,'Spirit Homes 5',1450,12,0,0,0,0,56,2),(762,0,0,0,'Glacier Side 3',1950,12,0,0,0,0,75,2),(763,0,0,0,'Glacier Side 2',4750,12,0,0,0,0,154,3),(764,0,0,0,'Glacier Side 1',1600,12,0,0,0,0,65,2),(765,0,0,0,'Spirit Homes 1',1700,12,0,0,0,0,56,2),(766,0,0,0,'Spirit Homes 2',1900,12,0,0,0,0,72,2),(767,0,0,0,'Spirit Homes 3',4250,12,0,0,0,0,128,3),(768,0,0,0,'Spirit Homes 4',1100,12,0,0,0,0,49,1),(770,0,0,0,'Glacier Side 4',2050,12,0,0,0,0,75,1),(771,0,0,0,'Shelf Site',4800,12,0,0,0,0,160,3),(772,0,0,0,'Raven Corner 1',855,12,0,0,0,0,45,1),(773,0,0,0,'Raven Corner 2',1685,12,0,0,0,0,60,3),(774,0,0,0,'Raven Corner 3',855,12,0,0,0,0,45,1),(775,0,0,0,'Bears Paw 3',2090,12,0,0,0,0,82,3),(776,0,0,0,'Bears Paw 4',5205,12,0,0,0,0,189,4),(778,0,0,0,'Bears Paw 5',2045,12,0,0,0,0,81,3),(779,0,0,0,'Trout Plaza 5 (Shop)',3880,12,0,0,0,0,144,2),(780,0,0,0,'Pilchard Bin 1',685,12,0,0,0,0,30,2),(781,0,0,0,'Pilchard Bin 2',685,12,0,0,0,0,24,2),(782,0,0,0,'Pilchard Bin 3',585,12,0,0,0,0,24,1),(783,0,0,0,'Pilchard Bin 4',585,12,0,0,0,0,24,1),(784,0,0,0,'Pilchard Bin 5',685,12,0,0,0,0,24,2),(785,0,0,0,'Pilchard Bin 10',450,12,0,0,0,0,20,1),(786,0,0,0,'Pilchard Bin 9',450,12,0,0,0,0,20,1),(787,0,0,0,'Pilchard Bin 8',450,12,0,0,0,0,20,2),(789,0,0,0,'Pilchard Bin 7',450,12,0,0,0,0,20,1),(790,0,0,0,'Pilchard Bin 6',450,12,0,0,0,0,25,1),(791,0,0,0,'Trout Plaza 1',2395,12,0,0,0,0,112,2),(792,0,0,0,'Trout Plaza 2',1540,12,0,0,0,0,64,2),(793,0,0,0,'Trout Plaza 3',900,12,0,0,0,0,36,1),(794,0,0,0,'Trout Plaza 4',900,12,0,0,0,0,45,1),(795,0,0,0,'Skiffs End 1',1540,12,0,0,0,0,70,2),(796,0,0,0,'Skiffs End 2',910,12,0,0,0,0,42,2),(797,0,0,0,'Furrier Quarter 3',1010,12,0,0,0,0,54,2),(798,0,0,0,'Mammoth Belly',22810,12,0,0,0,0,634,30),(799,0,0,0,'Furrier Quarter 2',1045,12,0,0,0,0,56,2),(800,0,0,0,'Furrier Quarter 1',1635,12,0,0,0,0,84,3),(801,0,0,0,'Fimbul Shelf 3',1255,12,0,0,0,0,66,2),(802,0,0,0,'Fimbul Shelf 4',1045,12,0,0,0,0,56,2),(803,0,0,0,'Fimbul Shelf 2',1045,12,0,0,0,0,56,2),(804,0,0,0,'Fimbul Shelf 1',975,12,0,0,0,0,48,2),(805,0,0,0,'Frost Manor',26370,12,0,0,0,0,806,24),(831,0,0,0,'Marble Guildhall',16810,3,0,0,0,0,530,17),(832,0,0,0,'Iron Guildhall',15560,3,0,0,0,0,464,17),(833,0,0,0,'The Market 1 (Shop)',650,3,0,0,0,0,25,1),(834,0,0,0,'The Market 3 (Shop)',1450,3,0,0,0,0,40,1),(835,0,0,0,'The Market 2 (Shop)',1100,3,0,0,0,0,40,1),(836,0,0,0,'The Market 4 (Shop)',1800,3,0,0,0,0,48,1),(837,0,0,0,'Granite Guildhall',17845,3,0,0,0,0,530,17),(838,0,0,0,'Upper Barracks 1',210,3,0,0,0,0,14,1),(850,0,0,0,'Upper Barracks 13',580,3,0,0,0,0,24,2),(851,0,0,0,'Nobility Quarter 4',765,3,0,0,0,0,25,1),(852,0,0,0,'Nobility Quarter 5',765,3,0,0,0,0,25,1),(853,0,0,0,'Nobility Quarter 7',765,3,0,0,0,0,25,1),(854,0,0,0,'Nobility Quarter 6',765,3,0,0,0,0,26,1),(855,0,0,0,'Nobility Quarter 8',765,3,0,0,0,0,26,1),(856,0,0,0,'Nobility Quarter 9',765,3,0,0,0,0,26,1),(857,0,0,0,'Nobility Quarter 2',1865,3,0,0,0,0,50,3),(858,0,0,0,'Nobility Quarter 3',1865,3,0,0,0,0,50,3),(859,0,0,0,'Nobility Quarter 1',1865,3,0,0,0,0,50,3),(863,0,0,0,'The Farms 6, Fishing Hut',1255,3,0,0,0,0,32,2),(864,0,0,0,'The Farms 5',1530,3,0,0,0,0,36,2),(866,0,0,0,'The Farms 3',1530,3,0,0,0,0,36,2),(867,0,0,0,'The Farms 2',1530,3,0,0,0,0,37,2),(868,0,0,0,'The Farms 1',2510,3,0,0,0,0,60,3),(886,0,0,0,'Outlaw Castle',8000,3,0,0,0,0,307,9),(889,0,0,0,'Tunnel Gardens 3',2000,3,0,0,0,0,43,3),(890,0,0,0,'Tunnel Gardens 4',2000,3,0,0,0,0,42,3),(892,0,0,0,'Tunnel Gardens 5',1360,3,0,0,0,0,35,2),(893,0,0,0,'Tunnel Gardens 6',1360,3,0,0,0,0,38,2),(894,0,0,0,'Tunnel Gardens 8',1360,3,0,0,0,0,35,2),(895,0,0,0,'Tunnel Gardens 7',1360,3,0,0,0,0,35,2),(900,0,0,0,'Wolftower',21550,3,0,0,0,0,636,23),(901,0,0,0,'Paupers Palace, Flat 11',315,1,0,0,0,0,12,1),(905,0,0,0,'Botham I a',950,9,0,0,0,0,36,1),(906,0,0,0,'Esuph I',680,9,0,0,0,0,39,1),(907,0,0,0,'Esuph II b',1380,9,0,0,0,0,51,2),(1883,0,0,0,'Aureate Court 1',5240,13,0,0,0,0,276,3),(1884,0,0,0,'Aureate Court 2',4860,13,0,0,0,0,198,2),(1885,0,0,0,'Aureate Court 3',4300,13,0,0,0,0,226,2),(1886,0,0,0,'Aureate Court 4',3980,13,0,0,0,0,208,4),(1887,0,0,0,'Fortune Wing 1',10180,13,0,0,0,0,420,4),(1888,0,0,0,'Fortune Wing 2',5580,13,0,0,0,0,260,2),(1889,0,0,0,'Fortune Wing 3',5740,13,0,0,0,0,258,2),(1890,0,0,0,'Fortune Wing 4',5740,13,0,0,0,0,305,4),(1891,0,0,0,'Luminous Arc 1',6460,13,0,0,0,0,344,2),(1892,0,0,0,'Luminous Arc 2',6460,13,0,0,0,0,301,4),(1893,0,0,0,'Luminous Arc 3',5400,13,0,0,0,0,249,3),(1894,0,0,0,'Luminous Arc 4',8000,13,0,0,0,0,343,5),(1895,0,0,0,'Radiant Plaza 1',5620,13,0,0,0,0,276,4),(1896,0,0,0,'Radiant Plaza 2',3820,13,0,0,0,0,179,2),(1897,0,0,0,'Radiant Plaza 3',4900,13,0,0,0,0,256,2),(1898,0,0,0,'Radiant Plaza 4',7460,13,0,0,0,0,367,3),(1899,0,0,0,'Sun Palace',23120,13,0,0,0,0,974,27),(1900,0,0,0,'Halls of Serenity',23360,13,0,0,0,0,1090,33),(1901,0,0,0,'Cascade Towers',19500,13,0,0,0,0,810,33),(1902,0,0,0,'Sorcerer\'s Avenue 5',2695,2,0,0,0,0,96,1),(1903,0,0,0,'Sorcerer\'s Avenue 1a',1255,2,0,0,0,0,42,2),(1904,0,0,0,'Sorcerer\'s Avenue 1b',1035,2,0,0,0,0,36,2),(1905,0,0,0,'Sorcerer\'s Avenue 1c',1255,2,0,0,0,0,36,2),(1906,0,0,0,'Beach Home Apartments, Flat 06',1145,2,0,0,0,0,40,2),(1907,0,0,0,'Beach Home Apartments, Flat 01',715,2,0,0,0,0,30,1),(1908,0,0,0,'Beach Home Apartments, Flat 02',715,2,0,0,0,0,25,1),(1909,0,0,0,'Beach Home Apartments, Flat 03',715,2,0,0,0,0,30,1),(1910,0,0,0,'Beach Home Apartments, Flat 04',715,2,0,0,0,0,24,1),(1911,0,0,0,'Beach Home Apartments, Flat 05',715,2,0,0,0,0,24,1),(1912,0,0,0,'Beach Home Apartments, Flat 16',1145,2,0,0,0,0,40,2),(1913,0,0,0,'Beach Home Apartments, Flat 11',715,2,0,0,0,0,30,1),(1914,0,0,0,'Beach Home Apartments, Flat 12',880,2,0,0,0,0,30,1),(1915,0,0,0,'Beach Home Apartments, Flat 13',880,2,0,0,0,0,29,1),(1916,0,0,0,'Beach Home Apartments, Flat 14',385,2,0,0,0,0,15,1),(1917,0,0,0,'Beach Home Apartments, Flat 15',385,2,0,0,0,0,15,1),(1918,0,0,0,'Thais Clanhall',8420,2,0,0,0,0,370,10),(1919,0,0,0,'Harbour Street 4',935,2,0,0,0,0,30,1),(1920,0,0,0,'Thais Hostel',6980,2,0,0,0,0,171,24),(1921,0,0,0,'Lower Swamp Lane 1',4740,2,0,0,0,0,166,4),(1923,0,0,0,'Lower Swamp Lane 3',4740,2,0,0,0,0,161,4),(1924,0,0,0,'Sunset Homes, Flat 01',520,2,0,0,0,0,25,1),(1925,0,0,0,'Sunset Homes, Flat 02',520,2,0,0,0,0,30,1),(1926,0,0,0,'Sunset Homes, Flat 03',520,2,0,0,0,0,30,1),(1927,0,0,0,'Sunset Homes, Flat 14',520,2,0,0,0,0,30,1),(1929,0,0,0,'Sunset Homes, Flat 13',860,2,0,0,0,0,35,2),(1930,0,0,0,'Sunset Homes, Flat 12',520,2,0,0,0,0,25,1),(1932,0,0,0,'Sunset Homes, Flat 11',520,2,0,0,0,0,25,1),(1935,0,0,0,'Sunset Homes, Flat 24',520,2,0,0,0,0,30,1),(1936,0,0,0,'Sunset Homes, Flat 23',860,2,0,0,0,0,35,2),(1937,0,0,0,'Sunset Homes, Flat 22',520,2,0,0,0,0,25,1),(1938,0,0,0,'Sunset Homes, Flat 21',520,2,0,0,0,0,25,1),(1939,0,0,0,'Harbour Place 1 (Shop)',1100,2,0,0,0,0,37,1),(1940,0,0,0,'Harbour Place 2 (Shop)',1300,2,0,0,0,0,48,1),(1941,0,0,0,'Warriors Guildhall',14725,2,0,0,0,0,522,11),(1942,0,0,0,'Farm Lane, 1st floor (Shop)',945,2,0,0,0,0,42,0),(1943,0,0,0,'Farm Lane, Basement (Shop)',945,2,0,0,0,0,36,0),(1944,0,0,0,'Main Street 9, 1st floor (Shop)',1440,2,0,0,0,0,47,0),(1945,0,0,0,'Main Street 9a, 2nd floor (Shop)',765,2,0,0,0,0,30,0),(1946,0,0,0,'Main Street 9b, 2nd floor (Shop)',1260,2,0,0,0,0,48,0),(1947,0,0,0,'Farm Lane, 2nd Floor (Shop)',945,2,0,0,0,0,42,0),(1948,0,0,0,'The City Wall 5a',585,2,0,0,0,0,24,1),(1949,0,0,0,'The City Wall 5c',585,2,0,0,0,0,24,1),(1950,0,0,0,'The City Wall 5e',585,2,0,0,0,0,30,1),(1951,0,0,0,'The City Wall 5b',585,2,0,0,0,0,24,1),(1952,0,0,0,'The City Wall 5d',585,2,0,0,0,0,24,1),(1953,0,0,0,'The City Wall 5f',585,2,0,0,0,0,30,1),(1954,0,0,0,'The City Wall 3a',1045,2,0,0,0,0,42,2),(1955,0,0,0,'The City Wall 3b',1045,2,0,0,0,0,35,2),(1956,0,0,0,'The City Wall 3c',1045,2,0,0,0,0,35,2),(1957,0,0,0,'The City Wall 3d',1045,2,0,0,0,0,41,2),(1958,0,0,0,'The City Wall 3e',1045,2,0,0,0,0,30,2),(1959,0,0,0,'The City Wall 3f',1045,2,0,0,0,0,31,2),(1960,0,0,0,'The City Wall 1a',1270,2,0,0,0,0,49,2),(1961,0,0,0,'Mill Avenue 3',1400,2,0,0,0,0,49,2),(1962,0,0,0,'The City Wall 1b',1270,2,0,0,0,0,49,2),(1963,0,0,0,'Mill Avenue 4',1400,2,0,0,0,0,49,2),(1964,0,0,0,'Mill Avenue 5',3250,2,0,0,0,0,128,4),(1965,0,0,0,'Mill Avenue 1 (Shop)',1300,2,0,0,0,0,54,1),(1966,0,0,0,'Mill Avenue 2 (Shop)',2350,2,0,0,0,0,80,2),(1967,0,0,0,'The City Wall 7c',865,2,0,0,0,0,36,2),(1968,0,0,0,'The City Wall 7a',585,2,0,0,0,0,30,1),(1969,0,0,0,'The City Wall 7e',865,2,0,0,0,0,36,2),(1970,0,0,0,'The City Wall 7g',585,2,0,0,0,0,30,1),(1971,0,0,0,'The City Wall 7d',865,2,0,0,0,0,36,2),(1972,0,0,0,'The City Wall 7b',585,2,0,0,0,0,30,1),(1973,0,0,0,'The City Wall 7f',865,2,0,0,0,0,35,2),(1974,0,0,0,'The City Wall 7h',585,2,0,0,0,0,30,1),(1975,0,0,0,'The City Wall 9',955,2,0,0,0,0,50,2),(1976,0,0,0,'Upper Swamp Lane 12',3800,2,0,0,0,0,116,3),(1977,0,0,0,'Upper Swamp Lane 10',2060,2,0,0,0,0,70,3),(1978,0,0,0,'Upper Swamp Lane 8',8120,2,0,0,0,0,216,3),(1979,0,0,0,'Southern Thais Guildhall',22440,2,0,0,0,0,596,16),(1980,0,0,0,'Alai Flats, Flat 04',765,2,0,0,0,0,30,1),(1981,0,0,0,'Alai Flats, Flat 05',1225,2,0,0,0,0,38,2),(1982,0,0,0,'Alai Flats, Flat 06',1225,2,0,0,0,0,48,2),(1983,0,0,0,'Alai Flats, Flat 07',765,2,0,0,0,0,30,1),(1984,0,0,0,'Alai Flats, Flat 08',765,2,0,0,0,0,30,1),(1985,0,0,0,'Alai Flats, Flat 03',765,2,0,0,0,0,36,1),(1986,0,0,0,'Alai Flats, Flat 01',765,2,0,0,0,0,26,1),(1987,0,0,0,'Alai Flats, Flat 02',765,2,0,0,0,0,34,1),(1988,0,0,0,'Alai Flats, Flat 14',900,2,0,0,0,0,33,1),(1989,0,0,0,'Alai Flats, Flat 15',1450,2,0,0,0,0,48,2),(1990,0,0,0,'Alai Flats, Flat 16',1450,2,0,0,0,0,54,2),(1991,0,0,0,'Alai Flats, Flat 17',900,2,0,0,0,0,38,1),(1992,0,0,0,'Alai Flats, Flat 18',900,2,0,0,0,0,38,1),(1993,0,0,0,'Alai Flats, Flat 13',765,2,0,0,0,0,36,1),(1994,0,0,0,'Alai Flats, Flat 12',765,2,0,0,0,0,25,1),(1995,0,0,0,'Alai Flats, Flat 11',765,2,0,0,0,0,35,1),(1996,0,0,0,'Alai Flats, Flat 24',900,2,0,0,0,0,36,1),(1997,0,0,0,'Alai Flats, Flat 25',1450,2,0,0,0,0,52,2),(1998,0,0,0,'Alai Flats, Flat 26',1450,2,0,0,0,0,60,2),(1999,0,0,0,'Alai Flats, Flat 27',900,2,0,0,0,0,38,1),(2000,0,0,0,'Alai Flats, Flat 28',900,2,0,0,0,0,38,1),(2001,0,0,0,'Alai Flats, Flat 23',765,2,0,0,0,0,35,1),(2002,0,0,0,'Alai Flats, Flat 22',765,2,0,0,0,0,25,1),(2003,0,0,0,'Alai Flats, Flat 21',765,2,0,0,0,0,36,1),(2004,0,0,0,'Upper Swamp Lane 4',4740,2,0,0,0,0,165,4),(2005,0,0,0,'Upper Swamp Lane 2',4740,2,0,0,0,0,159,4),(2006,0,0,0,'Sorcerer\'s Avenue Labs 2c',715,2,0,0,0,0,20,1),(2007,0,0,0,'Sorcerer\'s Avenue Labs 2d',715,2,0,0,0,0,20,1),(2008,0,0,0,'Sorcerer\'s Avenue Labs 2e',715,2,0,0,0,0,20,1),(2009,0,0,0,'Sorcerer\'s Avenue Labs 2f',715,2,0,0,0,0,20,1),(2010,0,0,0,'Sorcerer\'s Avenue Labs 2b',715,2,0,0,0,0,24,1),(2011,0,0,0,'Sorcerer\'s Avenue Labs 2a',715,2,0,0,0,0,24,1),(2012,0,0,0,'Ivory Circle 1',4280,7,0,0,0,0,160,2),(2013,0,0,0,'Admiral\'s Avenue 3',4115,7,0,0,0,0,142,2),(2014,0,0,0,'Admiral\'s Avenue 2',5470,7,0,0,0,0,176,4),(2015,0,0,0,'Admiral\'s Avenue 1',5105,7,0,0,0,0,168,2),(2016,0,0,0,'Sugar Street 5',1350,7,0,0,0,0,48,2),(2017,0,0,0,'Freedom Street 1',2450,7,0,0,0,0,84,2),(2018,0,0,0,'Freedom Street 2',6050,7,0,0,0,0,208,4),(2019,0,0,0,'Trader\'s Point 2 (Shop)',5350,7,0,0,0,0,198,2),(2020,0,0,0,'Trader\'s Point 3 (Shop)',5950,7,0,0,0,0,195,2),(2021,0,0,0,'Ivory Circle 2',7030,7,0,0,0,0,214,2),(2022,0,0,0,'The Tavern 1a',2750,7,0,0,0,0,72,4),(2023,0,0,0,'The Tavern 1b',1900,7,0,0,0,0,54,2),(2024,0,0,0,'The Tavern 1c',4150,7,0,0,0,0,132,3),(2025,0,0,0,'The Tavern 1d',1550,7,0,0,0,0,48,2),(2026,0,0,0,'The Tavern 2d',1350,7,0,0,0,0,40,2),(2027,0,0,0,'The Tavern 2c',950,7,0,0,0,0,32,1),(2028,0,0,0,'The Tavern 2b',1700,7,0,0,0,0,62,2),(2029,0,0,0,'The Tavern 2a',5550,7,0,0,0,0,163,5),(2030,0,0,0,'Straycat\'s Corner 4',210,7,0,0,0,0,20,1),(2031,0,0,0,'Straycat\'s Corner 3',210,7,0,0,0,0,20,1),(2032,0,0,0,'Straycat\'s Corner 2',660,7,0,0,0,0,49,1),(2033,0,0,0,'Litter Promenade 5',580,7,0,0,0,0,35,2),(2034,0,0,0,'Litter Promenade 4',390,7,0,0,0,0,30,1),(2035,0,0,0,'Litter Promenade 3',450,7,0,0,0,0,36,1),(2036,0,0,0,'Litter Promenade 2',300,7,0,0,0,0,25,1),(2037,0,0,0,'Litter Promenade 1',400,7,0,0,0,0,25,2),(2038,0,0,0,'The Shelter',13590,7,0,0,0,0,560,31),(2039,0,0,0,'Straycat\'s Corner 6',300,7,0,0,0,0,25,1),(2040,0,0,0,'Straycat\'s Corner 5',760,7,0,0,0,0,48,2),(2042,0,0,0,'Rum Alley 3',330,7,0,0,0,0,28,1),(2043,0,0,0,'Straycat\'s Corner 1',300,7,0,0,0,0,25,1),(2044,0,0,0,'Rum Alley 2',300,7,0,0,0,0,25,1),(2045,0,0,0,'Rum Alley 1',510,7,0,0,0,0,36,1),(2046,0,0,0,'Smuggler Backyard 3',700,7,0,0,0,0,40,2),(2048,0,0,0,'Shady Trail 3',300,7,0,0,0,0,25,1),(2049,0,0,0,'Shady Trail 1',1150,7,0,0,0,0,48,5),(2050,0,0,0,'Shady Trail 2',490,7,0,0,0,0,30,2),(2051,0,0,0,'Smuggler Backyard 5',610,7,0,0,0,0,35,2),(2052,0,0,0,'Smuggler Backyard 4',390,7,0,0,0,0,30,1),(2053,0,0,0,'Smuggler Backyard 2',670,7,0,0,0,0,40,2),(2054,0,0,0,'Smuggler Backyard 1',670,7,0,0,0,0,40,2),(2055,0,0,0,'Sugar Street 2',2550,7,0,0,0,0,84,3),(2056,0,0,0,'Sugar Street 1',3000,7,0,0,0,0,84,3),(2057,0,0,0,'Sugar Street 3a',1650,7,0,0,0,0,54,3),(2058,0,0,0,'Sugar Street 3b',2050,7,0,0,0,0,60,3),(2059,0,0,0,'Harvester\'s Haven, Flat 01',950,7,0,0,0,0,36,2),(2060,0,0,0,'Harvester\'s Haven, Flat 03',950,7,0,0,0,0,30,2),(2061,0,0,0,'Harvester\'s Haven, Flat 05',950,7,0,0,0,0,30,2),(2062,0,0,0,'Harvester\'s Haven, Flat 02',950,7,0,0,0,0,36,2),(2063,0,0,0,'Harvester\'s Haven, Flat 04',950,7,0,0,0,0,30,2),(2064,0,0,0,'Harvester\'s Haven, Flat 06',950,7,0,0,0,0,30,2),(2065,0,0,0,'Harvester\'s Haven, Flat 07',950,7,0,0,0,0,30,2),(2066,0,0,0,'Harvester\'s Haven, Flat 09',950,7,0,0,0,0,30,2),(2067,0,0,0,'Harvester\'s Haven, Flat 11',950,7,0,0,0,0,36,2),(2068,0,0,0,'Harvester\'s Haven, Flat 12',950,7,0,0,0,0,36,2),(2069,0,0,0,'Harvester\'s Haven, Flat 10',950,7,0,0,0,0,30,2),(2070,0,0,0,'Harvester\'s Haven, Flat 08',950,7,0,0,0,0,30,2),(2071,0,0,0,'Marble Lane 4',6350,7,0,0,0,0,192,4),(2072,0,0,0,'Marble Lane 2',6415,7,0,0,0,0,200,3),(2073,0,0,0,'Marble Lane 3',8055,7,0,0,0,0,240,4),(2074,0,0,0,'Marble Lane 1',11060,7,0,0,0,0,320,6),(2075,0,0,0,'Ivy Cottage',30650,7,0,0,0,0,856,26),(2076,0,0,0,'Sugar Street 4d',750,7,0,0,0,0,24,2),(2077,0,0,0,'Sugar Street 4c',650,7,0,0,0,0,24,1),(2078,0,0,0,'Sugar Street 4b',950,7,0,0,0,0,36,2),(2079,0,0,0,'Sugar Street 4a',950,7,0,0,0,0,30,2),(2080,0,0,0,'Trader\'s Point 1',2200,7,0,0,0,0,77,2),(2081,0,0,0,'Mountain Hideout',15550,7,0,0,0,0,486,17),(2082,0,0,0,'Dark Mansion',17845,2,0,0,0,0,569,17),(2083,0,0,0,'Halls of the Adventurers',15380,2,0,0,0,0,518,18),(2084,0,0,0,'Castle of Greenshore',18860,2,0,0,0,0,600,12),(2085,0,0,0,'Greenshore Clanhall',10800,2,0,0,0,0,308,10),(2086,0,0,0,'Greenshore Village 1',2420,2,0,0,0,0,64,3),(2087,0,0,0,'Greenshore Village, Shop',1800,2,0,0,0,0,56,1),(2088,0,0,0,'Greenshore Village, Villa',8700,2,0,0,0,0,263,4),(2089,0,0,0,'Greenshore Village 2',780,2,0,0,0,0,30,1),(2090,0,0,0,'Greenshore Village 3',780,2,0,0,0,0,25,1),(2091,0,0,0,'Greenshore Village 5',780,2,0,0,0,0,30,1),(2092,0,0,0,'Greenshore Village 4',780,2,0,0,0,0,25,1),(2093,0,0,0,'Greenshore Village 6',4360,2,0,0,0,0,118,2),(2094,0,0,0,'Greenshore Village 7',1260,2,0,0,0,0,42,1),(2095,0,0,0,'The Tibianic',34500,2,0,0,0,0,862,22),(2097,0,0,0,'Fibula Village 5',1790,2,0,0,0,0,42,2),(2098,0,0,0,'Fibula Village 4',1790,2,0,0,0,0,42,2),(2099,0,0,0,'Fibula Village, Tower Flat',5105,2,0,0,0,0,161,2),(2100,0,0,0,'Fibula Village 1',845,2,0,0,0,0,30,1),(2101,0,0,0,'Fibula Village 2',845,2,0,0,0,0,30,1),(2102,0,0,0,'Fibula Village 3',3810,2,0,0,0,0,110,4),(2103,0,0,0,'Mercenary Tower',41955,2,0,0,0,0,996,26),(2104,0,0,0,'Guildhall of the Red Rose',27725,2,0,0,0,0,567,15),(2105,0,0,0,'Fibula Village, Bar',5235,2,0,0,0,0,122,2),(2106,0,0,0,'Fibula Village, Villa',11490,2,0,0,0,0,402,5),(2107,0,0,0,'Fibula Clanhall',11430,2,0,0,0,0,290,10),(2108,0,0,0,'Spiritkeep',19210,2,0,0,0,0,783,23),(2109,0,0,0,'Snake Tower',29720,2,0,0,0,0,1064,21),(2110,0,0,0,'Bloodhall',15270,2,0,0,0,0,565,15),(2111,0,0,0,'Senja Clanhall',10575,4,0,0,0,0,396,9),(2112,0,0,0,'Senja Village 2',765,4,0,0,0,0,36,1),(2113,0,0,0,'Senja Village 1a',765,4,0,0,0,0,36,1),(2114,0,0,0,'Senja Village 1b',1630,4,0,0,0,0,66,2),(2115,0,0,0,'Senja Village 4',765,4,0,0,0,0,30,1),(2116,0,0,0,'Senja Village 3',1765,4,0,0,0,0,72,2),(2117,0,0,0,'Senja Village 6b',765,4,0,0,0,0,30,1),(2118,0,0,0,'Senja Village 6a',765,4,0,0,0,0,30,1),(2119,0,0,0,'Senja Village 5',1225,4,0,0,0,0,48,2),(2120,0,0,0,'Senja Village 10',1485,4,0,0,0,0,72,1),(2121,0,0,0,'Senja Village 11',2620,4,0,0,0,0,96,2),(2122,0,0,0,'Senja Village 9',2575,4,0,0,0,0,103,2),(2123,0,0,0,'Senja Village 8',1675,4,0,0,0,0,57,2),(2124,0,0,0,'Senja Village 7',865,4,0,0,0,0,37,2),(2125,0,0,0,'Rosebud C',1340,4,0,0,0,0,70,0),(2127,0,0,0,'Rosebud A',1000,4,0,0,0,0,60,1),(2128,0,0,0,'Rosebud B',1000,4,0,0,0,0,60,1),(2129,0,0,0,'Nordic Stronghold',18400,4,0,0,0,0,718,21),(2130,0,0,0,'Northport Village 2',1475,4,0,0,0,0,40,2),(2131,0,0,0,'Northport Village 1',1475,4,0,0,0,0,48,2),(2132,0,0,0,'Northport Village 3',5435,4,0,0,0,0,178,2),(2133,0,0,0,'Northport Village 4',2630,4,0,0,0,0,81,2),(2134,0,0,0,'Northport Village 5',1805,4,0,0,0,0,56,2),(2135,0,0,0,'Northport Village 6',2135,4,0,0,0,0,64,2),(2136,0,0,0,'Seawatch',25010,4,0,0,0,0,745,19),(2137,0,0,0,'Northport Clanhall',9810,4,0,0,0,0,288,10),(2138,0,0,0,'Druids Retreat D',1180,4,0,0,0,0,54,2),(2139,0,0,0,'Druids Retreat A',1340,4,0,0,0,0,60,2),(2140,0,0,0,'Druids Retreat C',980,4,0,0,0,0,45,2),(2141,0,0,0,'Druids Retreat B',980,4,0,0,0,0,55,2),(2142,0,0,0,'Theater Avenue 14 (Shop)',2115,4,0,0,0,0,83,1),(2143,0,0,0,'Theater Avenue 12',955,4,0,0,0,0,28,2),(2144,0,0,0,'Theater Avenue 10',1090,4,0,0,0,0,45,2),(2145,0,0,0,'Theater Avenue 11c',585,4,0,0,0,0,24,1),(2146,0,0,0,'Theater Avenue 11b',585,4,0,0,0,0,24,1),(2147,0,0,0,'Theater Avenue 11a',1405,4,0,0,0,0,54,2),(2148,0,0,0,'Magician\'s Alley 1',1050,4,0,0,0,0,35,2),(2149,0,0,0,'Magician\'s Alley 1a',700,4,0,0,0,0,29,2),(2150,0,0,0,'Magician\'s Alley 1d',450,4,0,0,0,0,24,1),(2151,0,0,0,'Magician\'s Alley 1b',750,4,0,0,0,0,24,2),(2152,0,0,0,'',0,0,0,0,0,0,16,0),(2153,0,0,0,'Magician\'s Alley 5a',350,4,0,0,0,0,14,1),(2154,0,0,0,'Magician\'s Alley 5b',500,4,0,0,0,0,25,1),(2155,0,0,0,'Magician\'s Alley 5d',500,4,0,0,0,0,20,1),(2156,0,0,0,'Magician\'s Alley 5e',500,4,0,0,0,0,25,1),(2157,0,0,0,'Magician\'s Alley 5c',1150,4,0,0,0,0,35,2),(2158,0,0,0,'Magician\'s Alley 5f',1150,4,0,0,0,0,42,2),(2159,0,0,0,'',0,0,0,0,0,0,51,2),(2160,0,0,0,'',0,0,0,0,0,0,58,2),(2161,0,0,0,'',0,0,0,0,0,0,69,2),(2162,0,0,0,'',0,0,0,0,0,0,63,1),(2163,0,0,0,'',0,0,0,0,0,0,125,3),(2164,0,0,0,'',0,0,0,0,0,0,35,1),(2165,0,0,0,'',0,0,0,0,0,0,49,1),(2166,0,0,0,'',0,0,0,0,0,0,79,2),(2167,0,0,0,'',0,0,0,0,0,0,24,1),(2168,0,0,0,'',0,0,0,0,0,0,44,1),(2169,0,0,0,'',0,0,0,0,0,0,34,2),(2170,0,0,0,'',0,0,0,0,0,0,71,2),(2171,0,0,0,'',0,0,0,0,0,0,25,1),(2172,0,0,0,'',0,0,0,0,0,0,27,1),(2173,0,0,0,'',0,0,0,0,0,0,27,1),(2174,0,0,0,'',0,0,0,0,0,0,30,1),(2175,0,0,0,'',0,0,0,0,0,0,30,1),(2176,0,0,0,'',0,0,0,0,0,0,24,1),(2177,0,0,0,'',0,0,0,0,0,0,49,1),(2178,0,0,0,'',0,0,0,0,0,0,35,1),(2179,0,0,0,'',0,0,0,0,0,0,23,2),(2180,0,0,0,'',0,0,0,0,0,0,139,2),(2181,0,0,0,'',0,0,0,0,0,0,130,2),(2182,0,0,0,'',0,0,0,0,0,0,51,1),(2183,0,0,0,'',0,0,0,0,0,0,41,1),(2184,0,0,0,'',0,0,0,0,0,0,36,1),(2185,0,0,0,'',0,0,0,0,0,0,41,1),(2186,0,0,0,'',0,0,0,0,0,0,33,2),(2187,0,0,0,'',0,0,0,0,0,0,42,1),(2188,0,0,0,'',0,0,0,0,0,0,21,1),(2189,0,0,0,'',0,0,0,0,0,0,12,1),(2190,0,0,0,'',0,0,0,0,0,0,25,1),(2191,0,0,0,'',0,0,0,0,0,0,25,2),(2192,0,0,0,'',0,0,0,0,0,0,33,2),(2193,0,0,0,'',0,0,0,0,0,0,27,1),(2194,0,0,0,'',0,0,0,0,0,0,20,1),(2195,0,0,0,'',0,0,0,0,0,0,24,1),(2196,0,0,0,'',0,0,0,0,0,0,37,1),(2197,0,0,0,'',0,0,0,0,0,0,266,4),(2198,0,0,0,'',0,0,0,0,0,0,63,2),(2199,0,0,0,'Theater Avenue 7, Flat 01',315,4,0,0,0,0,15,1),(2200,0,0,0,'',0,0,0,0,0,0,32,1),(2201,0,0,0,'',0,0,0,0,0,0,79,2),(2202,0,0,0,'',0,0,0,0,0,0,153,0),(2203,0,0,0,'',0,0,0,0,0,0,459,11),(2204,0,0,0,'',0,0,0,0,0,0,24,1),(2205,0,0,0,'Theater Avenue 7, Flat 13',405,4,0,0,0,0,17,1),(2206,0,0,0,'Theater Avenue 7, Flat 15',405,4,0,0,0,0,19,1),(2207,0,0,0,'',0,0,0,0,0,0,143,2),(2208,0,0,0,'',0,0,0,0,0,0,38,2),(2209,0,0,0,'',0,0,0,0,0,0,79,0),(2210,0,0,0,'',0,0,0,0,0,0,25,1),(2211,0,0,0,'',0,0,0,0,0,0,14,1),(2212,0,0,0,'Central Plaza 3',600,4,0,0,0,0,20,0),(2213,0,0,0,'Central Plaza 2',600,4,0,0,0,0,20,0),(2214,0,0,0,'Central Plaza 1',600,4,0,0,0,0,20,0),(2215,0,0,0,'Park Lane 1a',1220,4,0,0,0,0,53,2),(2216,0,0,0,'Park Lane 3a',1220,4,0,0,0,0,48,2),(2217,0,0,0,'Park Lane 1b',1380,4,0,0,0,0,64,2),(2218,0,0,0,'Park Lane 3b',1100,4,0,0,0,0,48,2),(2219,0,0,0,'Park Lane 4',980,4,0,0,0,0,42,2),(2220,0,0,0,'Park Lane 2',980,4,0,0,0,0,42,2),(2221,0,0,0,'Magician\'s Alley 8',1400,4,0,0,0,0,42,2),(2222,0,0,0,'Moonkeep',13020,4,0,0,0,0,522,16),(2225,0,0,0,'Castle, Basement, Flat 01',585,11,0,0,0,0,30,1),(2226,0,0,0,'Castle, Basement, Flat 02',585,11,0,0,0,0,20,1),(2227,0,0,0,'Castle, Basement, Flat 03',585,11,0,0,0,0,20,1),(2228,0,0,0,'Castle, Basement, Flat 04',585,11,0,0,0,0,20,1),(2229,0,0,0,'Castle, Basement, Flat 07',585,11,0,0,0,0,20,1),(2230,0,0,0,'Castle, Basement, Flat 08',585,11,0,0,0,0,20,1),(2231,0,0,0,'Castle, Basement, Flat 09',585,11,0,0,0,0,24,1),(2232,0,0,0,'Castle, Basement, Flat 06',585,11,0,0,0,0,24,1),(2233,0,0,0,'Castle, Basement, Flat 05',585,11,0,0,0,0,24,1),(2234,0,0,0,'Castle Shop 1',1890,11,0,0,0,0,67,1),(2235,0,0,0,'Castle Shop 2',1890,11,0,0,0,0,70,1),(2236,0,0,0,'Castle Shop 3',1890,11,0,0,0,0,67,1),(2237,0,0,0,'Castle, 4th Floor, Flat 09',720,11,0,0,0,0,28,1),(2238,0,0,0,'Castle, 4th Floor, Flat 08',945,11,0,0,0,0,42,1),(2239,0,0,0,'Castle, 4th Floor, Flat 06',945,11,0,0,0,0,36,1),(2240,0,0,0,'Castle, 4th Floor, Flat 07',720,11,0,0,0,0,30,1),(2241,0,0,0,'Castle, 4th Floor, Flat 05',765,11,0,0,0,0,30,1),(2242,0,0,0,'Castle, 4th Floor, Flat 04',585,11,0,0,0,0,25,1),(2243,0,0,0,'Castle, 4th Floor, Flat 03',585,11,0,0,0,0,30,1),(2244,0,0,0,'Castle, 4th Floor, Flat 02',765,11,0,0,0,0,30,1),(2245,0,0,0,'Castle, 4th Floor, Flat 01',585,11,0,0,0,0,30,1),(2246,0,0,0,'Castle, 3rd Floor, Flat 01',585,11,0,0,0,0,30,1),(2247,0,0,0,'Castle, 3rd Floor, Flat 02',765,11,0,0,0,0,30,1),(2248,0,0,0,'Castle, 3rd Floor, Flat 03',585,11,0,0,0,0,25,1),(2249,0,0,0,'Castle, 3rd Floor, Flat 05',765,11,0,0,0,0,30,1),(2250,0,0,0,'Castle, 3rd Floor, Flat 04',585,11,0,0,0,0,25,1),(2251,0,0,0,'Castle, 3rd Floor, Flat 06',1045,11,0,0,0,0,33,2),(2252,0,0,0,'Castle, 3rd Floor, Flat 07',720,11,0,0,0,0,26,1),(2253,0,0,0,'Castle Street 1',2900,11,0,0,0,0,112,3),(2254,0,0,0,'Castle Street 2',1495,11,0,0,0,0,56,2),(2255,0,0,0,'Castle Street 3',1765,11,0,0,0,0,56,2),(2256,0,0,0,'Castle Street 4',1765,11,0,0,0,0,64,2),(2257,0,0,0,'Castle Street 5',1765,11,0,0,0,0,61,2),(2258,0,0,0,'Edron Flats, Basement Flat 2',1540,11,0,0,0,0,48,2),(2259,0,0,0,'Edron Flats, Basement Flat 1',1540,11,0,0,0,0,48,2),(2260,0,0,0,'Edron Flats, Flat 01',400,11,0,0,0,0,20,1),(2261,0,0,0,'Edron Flats, Flat 02',860,11,0,0,0,0,28,2),(2262,0,0,0,'Edron Flats, Flat 03',400,11,0,0,0,0,20,1),(2263,0,0,0,'Edron Flats, Flat 04',400,11,0,0,0,0,20,1),(2264,0,0,0,'Edron Flats, Flat 06',400,11,0,0,0,0,20,1),(2265,0,0,0,'Edron Flats, Flat 05',400,11,0,0,0,0,20,1),(2266,0,0,0,'Edron Flats, Flat 07',400,11,0,0,0,0,20,1),(2267,0,0,0,'Edron Flats, Flat 08',400,11,0,0,0,0,20,1),(2268,0,0,0,'Edron Flats, Flat 11',400,11,0,0,0,0,25,1),(2269,0,0,0,'Edron Flats, Flat 12',400,11,0,0,0,0,25,1),(2270,0,0,0,'Edron Flats, Flat 14',400,11,0,0,0,0,25,1),(2271,0,0,0,'Edron Flats, Flat 13',400,11,0,0,0,0,25,1),(2272,0,0,0,'Edron Flats, Flat 16',400,11,0,0,0,0,20,1),(2273,0,0,0,'Edron Flats, Flat 15',400,11,0,0,0,0,20,1),(2274,0,0,0,'Edron Flats, Flat 18',400,11,0,0,0,0,20,1),(2275,0,0,0,'Edron Flats, Flat 17',400,11,0,0,0,0,20,1),(2276,0,0,0,'Edron Flats, Flat 22',400,11,0,0,0,0,25,1),(2277,0,0,0,'Edron Flats, Flat 21',860,11,0,0,0,0,40,2),(2278,0,0,0,'Edron Flats, Flat 24',400,11,0,0,0,0,20,1),(2279,0,0,0,'Edron Flats, Flat 23',400,11,0,0,0,0,25,1),(2280,0,0,0,'Edron Flats, Flat 26',400,11,0,0,0,0,20,1),(2281,0,0,0,'Edron Flats, Flat 27',400,11,0,0,0,0,20,1),(2282,0,0,0,'Edron Flats, Flat 28',400,11,0,0,0,0,20,1),(2283,0,0,0,'Edron Flats, Flat 25',400,11,0,0,0,0,20,1),(2284,0,0,0,'Central Circle 1',3020,11,0,0,0,0,119,2),(2285,0,0,0,'Central Circle 2',3300,11,0,0,0,0,108,2),(2286,0,0,0,'Central Circle 3',4160,11,0,0,0,0,147,5),(2287,0,0,0,'Central Circle 4',4160,11,0,0,0,0,147,5),(2288,0,0,0,'Central Circle 5',4160,11,0,0,0,0,161,5),(2289,0,0,0,'Central Circle 6 (Shop)',3980,11,0,0,0,0,182,2),(2290,0,0,0,'Central Circle 7 (Shop)',3980,11,0,0,0,0,161,2),(2291,0,0,0,'Central Circle 8 (Shop)',3980,11,0,0,0,0,166,2),(2292,0,0,0,'Central Circle 9a',940,11,0,0,0,0,42,2),(2293,0,0,0,'Central Circle 9b',940,11,0,0,0,0,44,2),(2294,0,0,0,'Sky Lane, Guild 1',21145,11,0,0,0,0,666,23),(2295,0,0,0,'Sky Lane, Guild 2',19300,11,0,0,0,0,672,14),(2296,0,0,0,'Sky Lane, Guild 3',17315,11,0,0,0,0,564,18),(2297,0,0,0,'Sky Lane, Sea Tower',4775,11,0,0,0,0,196,6),(2298,0,0,0,'Wood Avenue 6a',1450,11,0,0,0,0,56,2),(2299,0,0,0,'Wood Avenue 9a',1540,11,0,0,0,0,56,2),(2300,0,0,0,'Wood Avenue 10a',1540,11,0,0,0,0,64,2),(2301,0,0,0,'Wood Avenue 11',7205,11,0,0,0,0,253,6),(2302,0,0,0,'Wood Avenue 8',5960,11,0,0,0,0,198,3),(2303,0,0,0,'Wood Avenue 7',5960,11,0,0,0,0,191,3),(2304,0,0,0,'Wood Avenue 6b',1450,11,0,0,0,0,56,2),(2305,0,0,0,'Wood Avenue 9b',1495,11,0,0,0,0,56,2),(2306,0,0,0,'Wood Avenue 10b',1595,11,0,0,0,0,64,3),(2307,0,0,0,'Wood Avenue 5',1765,11,0,0,0,0,64,2),(2308,0,0,0,'Wood Avenue 4a',1495,11,0,0,0,0,56,2),(2309,0,0,0,'Wood Avenue 4b',1495,11,0,0,0,0,56,2),(2310,0,0,0,'Wood Avenue 4c',1765,11,0,0,0,0,56,2),(2311,0,0,0,'Wood Avenue 4',1765,11,0,0,0,0,64,2),(2312,0,0,0,'Wood Avenue 3',1765,11,0,0,0,0,56,2),(2313,0,0,0,'Wood Avenue 2',1765,11,0,0,0,0,49,2),(2314,0,0,0,'Wood Avenue 1',1765,11,0,0,0,0,64,2),(2315,0,0,0,'Magic Academy, Guild',12025,11,0,0,0,0,412,14),(2316,0,0,0,'Magic Academy, Flat 1',1465,11,0,0,0,0,57,3),(2317,0,0,0,'Magic Academy, Flat 2',1530,11,0,0,0,0,55,2),(2318,0,0,0,'Magic Academy, Flat 3',1430,11,0,0,0,0,55,1),(2319,0,0,0,'Magic Academy, Flat 4',1530,11,0,0,0,0,55,2),(2320,0,0,0,'Magic Academy, Flat 5',1430,11,0,0,0,0,55,1),(2321,0,0,0,'Magic Academy, Shop',1595,11,0,0,0,0,48,1),(2322,0,0,0,'Stonehome Village 1',1780,11,0,0,0,0,74,2),(2323,0,0,0,'Stonehome Flats, Flat 05',400,11,0,0,0,0,20,1),(2324,0,0,0,'Stonehome Flats, Flat 04',400,11,0,0,0,0,25,1),(2325,0,0,0,'Stonehome Flats, Flat 06',400,11,0,0,0,0,20,1),(2326,0,0,0,'Stonehome Flats, Flat 03',400,11,0,0,0,0,20,1),(2327,0,0,0,'Stonehome Flats, Flat 01',400,11,0,0,0,0,20,1),(2328,0,0,0,'Stonehome Flats, Flat 02',740,11,0,0,0,0,30,2),(2329,0,0,0,'Stonehome Flats, Flat 11',740,11,0,0,0,0,35,2),(2330,0,0,0,'Stonehome Flats, Flat 12',740,11,0,0,0,0,35,2),(2331,0,0,0,'Stonehome Flats, Flat 13',400,11,0,0,0,0,20,1),(2332,0,0,0,'Stonehome Flats, Flat 14',400,11,0,0,0,0,20,1),(2333,0,0,0,'Stonehome Flats, Flat 16',400,11,0,0,0,0,20,1),(2334,0,0,0,'Stonehome Flats, Flat 15',400,11,0,0,0,0,20,1),(2335,0,0,0,'Stonehome Village 2',640,11,0,0,0,0,35,1),(2336,0,0,0,'Stonehome Village 3',680,11,0,0,0,0,36,1),(2337,0,0,0,'',0,0,0,0,0,0,7,0),(2338,0,0,0,'',0,0,0,0,0,0,7,0),(2339,0,0,0,'',0,0,0,0,0,0,70,1),(2340,0,0,0,'',0,0,0,0,0,0,31,2),(2341,0,0,0,'',0,0,0,0,0,0,25,2),(2342,0,0,0,'',0,0,0,0,0,0,32,2),(2343,0,0,0,'',0,0,0,0,0,0,10,0),(2344,0,0,0,'',0,0,0,0,0,0,14,0),(2345,0,0,0,'',0,0,0,0,0,0,10,0),(2346,0,0,0,'',0,0,0,0,0,0,13,0),(2347,0,0,0,'',0,0,0,0,0,0,27,2),(2348,0,0,0,'',0,0,0,0,0,0,18,1),(2349,0,0,0,'',0,0,0,0,0,0,11,1),(2350,0,0,0,'',0,0,0,0,0,0,21,1),(2351,0,0,0,'',0,0,0,0,0,0,20,0),(2352,0,0,0,'',0,0,0,0,0,0,13,1),(2353,0,0,0,'',0,0,0,0,0,0,13,1),(2354,0,0,0,'',0,0,0,0,0,0,21,1),(2355,0,0,0,'',0,0,0,0,0,0,21,1),(2356,0,0,0,'Cormaya Flats, Flat 11',450,11,0,0,0,0,20,1),(2357,0,0,0,'',0,0,0,0,0,0,13,0),(2358,0,0,0,'',0,0,0,0,0,0,9,0),(2359,0,0,0,'',0,0,0,0,0,0,13,0),(2360,0,0,0,'',0,0,0,0,0,0,17,0),(2361,0,0,0,'Cormaya 5',4250,11,0,0,0,0,167,3),(2362,0,0,0,'',0,0,0,0,0,0,21,1),(2363,0,0,0,'Cormaya 7',2395,11,0,0,0,0,84,2),(2364,0,0,0,'',0,0,0,0,0,0,28,1),(2365,0,0,0,'',0,0,0,0,0,0,13,0),(2366,0,0,0,'',0,0,0,0,0,0,5,0),(2367,0,0,0,'',0,0,0,0,0,0,7,1),(2368,0,0,0,'',0,0,0,0,0,0,7,0),(2369,0,0,0,'',0,0,0,0,0,0,14,1),(2370,0,0,0,'',0,0,0,0,0,0,7,1),(2371,0,0,0,'',0,0,0,0,0,0,7,1),(2372,0,0,0,'',0,0,0,0,0,0,5,0),(2373,0,0,0,'',0,0,0,0,0,0,7,0),(2374,0,0,0,'',0,0,0,0,0,0,20,1),(2375,0,0,0,'',0,0,0,0,0,0,20,1),(2376,0,0,0,'',0,0,0,0,0,0,27,1),(2377,0,0,0,'',0,0,0,0,0,0,10,0),(2378,0,0,0,'',0,0,0,0,0,0,19,1),(2379,0,0,0,'',0,0,0,0,0,0,19,1),(2380,0,0,0,'Hill Hideout',13950,3,0,0,0,0,346,15),(2381,0,0,0,'Meriana Beach',8230,7,0,0,0,0,184,3),(2382,0,0,0,'',0,0,0,0,0,0,28,1),(2383,0,0,0,'',0,0,0,0,0,0,28,1),(2384,0,0,0,'',0,0,0,0,0,0,25,0),(2385,0,0,0,'',0,0,0,0,0,0,28,2),(2386,0,0,0,'Darashia 8, Flat 05',2665,10,0,0,0,0,85,2),(2387,0,0,0,'Darashia, Eastern Guildhall',12660,10,0,0,0,0,442,16),(2388,0,0,0,'',0,0,0,0,0,0,35,1),(2389,0,0,0,'',0,0,0,0,0,0,15,0),(2390,0,0,0,'',0,0,0,0,0,0,12,0),(2391,0,0,0,'',0,0,0,0,0,0,12,0),(2392,0,0,0,'',0,0,0,0,0,0,12,0),(2393,0,0,0,'',0,0,0,0,0,0,12,0),(2394,0,0,0,'',0,0,0,0,0,0,12,0),(2395,0,0,0,'Outlaw Camp 4',200,3,0,0,0,0,9,1),(2396,0,0,0,'',0,0,0,0,0,0,15,0),(2397,0,0,0,'',0,0,0,0,0,0,12,0),(2398,0,0,0,'',0,0,0,0,0,0,12,0),(2399,0,0,0,'',0,0,0,0,0,0,12,0),(2400,0,0,0,'',0,0,0,0,0,0,12,0),(2401,0,0,0,'',0,0,0,0,0,0,12,0),(2402,0,0,0,'',0,0,0,0,0,0,27,1),(2403,0,0,0,'',0,0,0,0,0,0,12,0),(2404,0,0,0,'',0,0,0,0,0,0,12,0),(2405,0,0,0,'',0,0,0,0,0,0,24,1),(2406,0,0,0,'',0,0,0,0,0,0,36,1),(2407,0,0,0,'Open-Air Theatre',2700,2,0,0,0,0,60,1),(2408,0,0,0,'',0,0,0,0,0,0,40,0),(2409,0,0,0,'',0,0,0,0,0,0,36,0),(2410,0,0,0,'Upper Barracks 3',210,3,0,0,0,0,13,1),(2411,0,0,0,'',0,0,0,0,0,0,48,1),(2412,0,0,0,'',0,0,0,0,0,0,52,1),(2413,0,0,0,'',0,0,0,0,0,0,85,4),(2414,0,0,0,'Upper Barracks 7',210,3,0,0,0,0,12,1),(2415,0,0,0,'',0,0,0,0,0,0,80,2),(2416,0,0,0,'',0,0,0,0,0,0,17,1),(2417,0,0,0,'',0,0,0,0,0,0,15,1),(2418,0,0,0,'',0,0,0,0,0,0,15,1),(2419,0,0,0,'',0,0,0,0,0,0,15,1),(2420,0,0,0,'',0,0,0,0,0,0,15,1),(2421,0,0,0,'',0,0,0,0,0,0,20,1),(2422,0,0,0,'Mammoth House',9300,12,0,0,0,0,218,6),(2423,0,0,0,'',0,0,0,0,0,0,50,1),(2424,0,0,0,'',0,0,0,0,0,0,50,1),(2425,0,0,0,'',0,0,0,0,0,0,35,1),(2426,0,0,0,'',0,0,0,0,0,0,94,2),(2427,0,0,0,'',0,0,0,0,0,0,104,2),(2428,0,0,0,'',0,0,0,0,0,0,120,2),(2429,0,0,0,'',0,0,0,0,0,0,56,1),(2430,0,0,0,'',0,0,0,0,0,0,98,1),(2431,0,0,0,'',0,0,0,0,0,0,98,1),(2432,0,0,0,'',0,0,0,0,0,0,20,1),(2433,0,0,0,'',0,0,0,0,0,0,20,1),(2434,0,0,0,'',0,0,0,0,0,0,29,1),(2435,0,0,0,'',0,0,0,0,0,0,104,2),(2436,0,0,0,'',0,0,0,0,0,0,18,1),(2437,0,0,0,'',0,0,0,0,0,0,24,1),(2438,0,0,0,'',0,0,0,0,0,0,115,3),(2439,0,0,0,'',0,0,0,0,0,0,183,4),(2440,0,0,0,'',0,0,0,0,0,0,20,1),(2441,0,0,0,'',0,0,0,0,0,0,140,3),(2442,0,0,0,'',0,0,0,0,0,0,40,1),(2443,0,0,0,'',0,0,0,0,0,0,20,1),(2444,0,0,0,'',0,0,0,0,0,0,20,1),(2445,0,0,0,'',0,0,0,0,0,0,36,2),(2446,0,0,0,'',0,0,0,0,0,0,184,5),(2447,0,0,0,'Lower Barracks 21',300,3,0,0,0,0,17,1),(2448,0,0,0,'',0,0,0,0,0,0,30,1),(2449,0,0,0,'',0,0,0,0,0,0,35,1),(2450,0,0,0,'',0,0,0,0,0,0,38,1),(2451,0,0,0,'',0,0,0,0,0,0,36,1),(2452,0,0,0,'',0,0,0,0,0,0,36,2),(2453,0,0,0,'',0,0,0,0,0,0,50,1),(2454,0,0,0,'',0,0,0,0,0,0,72,1),(2455,0,0,0,'',0,0,0,0,0,0,210,4),(2456,0,0,0,'The Yeah Beach Project',6525,7,0,0,0,0,183,3),(2460,0,0,0,'Hare\'s Den',7500,3,0,0,0,0,233,4),(2461,0,0,0,'Lost Cavern',14730,3,0,0,0,0,621,7),(2462,0,0,0,'Caveman Shelter',3780,14,0,0,0,0,92,4),(2463,0,0,0,'Old Sanctuary of God King Qjell',21940,28,0,0,0,0,854,6),(2464,0,0,0,'Wallside Lane 1',7590,33,0,0,0,0,295,4),(2465,0,0,0,'Wallside Residence',6680,33,0,0,0,0,223,4),(2466,0,0,0,'Wallside Lane 2',8445,33,0,0,0,0,294,4),(2467,0,0,0,'Antimony Lane 3',3665,33,0,0,0,0,126,3),(2468,0,0,0,'Antimony Lane 2',4745,33,0,0,0,0,159,3),(2469,0,0,0,'Vanward Flats B',7410,33,0,0,0,0,245,4),(2470,0,0,0,'Vanward Flats A',7410,33,0,0,0,0,222,4),(2471,0,0,0,'Bronze Brothers Bastion',35205,33,0,0,0,0,1233,15),(2472,0,0,0,'Antimony Lane 1',7105,33,0,0,0,0,242,5),(2473,0,0,0,'Rathleton Hills Estate',20685,33,0,0,0,0,646,13),(2474,0,0,0,'Rathleton Hills Residence',7085,33,0,0,0,0,228,3),(2475,0,0,0,'Rathleton Plaza 1',2890,33,0,0,0,0,95,2),(2476,0,0,0,'Rathleton Plaza 2',2620,33,0,0,0,0,99,2),(2478,0,0,0,'Antimony Lane 4',5150,33,0,0,0,0,176,3),(2480,0,0,0,'Old Heritage Estate',12075,33,0,0,0,0,422,7),(2481,0,0,0,'Cistern Ave',3745,33,0,0,0,0,173,2),(2482,0,0,0,'Rathleton Plaza 4',5005,33,0,0,0,0,193,2),(2483,0,0,0,'Rathleton Plaza 3',5735,33,0,0,0,0,193,3),(2488,0,0,0,'Thrarhor V e (Shop)',3000,9,0,0,0,0,36,1),(2491,0,0,0,'Isle of Solitude House',3000,31,0,0,0,0,529,14),(2492,0,0,0,'Tunnel Gardens 9',0,3,0,0,0,0,15,2),(2493,0,0,0,'Tunnel Gardens 10',0,3,0,0,0,0,16,2),(2494,0,0,0,'Tunnel Gardens 11',0,3,0,0,0,0,16,2),(2495,0,0,0,'Tunnel Gardens 12',0,3,0,0,0,0,16,2),(2496,0,0,0,'Marketplace 1',0,53,0,0,0,0,111,1),(2497,0,0,0,'Marketplace 2',0,53,0,0,0,0,125,2),(2498,0,0,0,'Palace Vicinity',0,53,0,0,0,0,155,2),(2499,0,0,0,'Quay 1',0,53,0,0,0,0,159,5),(2500,0,0,0,'Quay 2',0,53,0,0,0,0,95,2),(2501,0,0,0,'Wave Tower',0,53,0,0,0,0,274,4),(2502,0,0,0,'Halls of Sun and Sea',0,53,0,0,0,0,473,9),(2503,0,0,0,'Pirate Shipwreck 1',5385,10,0,0,0,0,239,0),(2504,0,0,0,'Pirate Shipwreck 2',5385,10,0,0,0,0,286,0),(2505,0,0,0,'Theater Avenue, Tower',0,4,0,0,0,0,118,3),(2506,0,0,0,'Caretakers Residence',0,1,0,0,0,0,361,7),(2507,0,0,0,'Harbour Place 3',0,1,0,0,0,0,152,2),(2508,0,0,0,'Smugglers Den',0,1,0,0,0,0,334,0),(2509,0,0,0,'Prima Arbor',0,1,0,0,0,0,325,0),(2510,0,0,0,'Iron Alley Watch, Upper',0,1,0,0,0,0,251,0),(2511,0,0,0,'Iron Alley Watch, Lower',0,1,0,0,0,0,251,0),(2512,0,0,0,'Lucky Lane 2 (Tower)',0,1,0,0,0,0,252,0),(2513,0,0,0,'Lucky Lane 3 (Tower)',0,1,0,0,0,0,252,0),(2514,0,0,0,'Mystic Lane 3 (Tower)',0,1,0,0,0,0,252,0),(2515,0,0,0,'Castle, Residence',0,1,0,0,0,0,157,0),(2516,0,0,0,'Harbour Promenade 1',0,1,0,0,0,0,233,0),(2517,0,0,0,'Luminous Arc 5',0,1,0,0,0,0,210,0),(2518,0,0,0,'Stronghold',0,1,0,0,0,0,374,0),(2519,0,0,0,'Lakeside Mansion',0,1,0,0,0,0,222,0),(2520,0,0,0,'Ivory Mansion',0,1,0,0,0,0,414,0),(2521,0,0,0,'Aureate Court 5',0,1,0,0,0,0,225,0),(2522,0,0,0,'Hagglers Hangout 7',0,1,0,0,0,0,216,0),(2523,0,0,0,'Dwarven Magnates Estate',0,3,0,0,0,0,387,0),(2524,0,0,0,'Forge Masters Quarters',0,1,0,0,0,0,480,0),(2525,0,0,0,'Big Game Hunters Lodge',0,1,0,0,0,0,298,0),(2526,0,0,0,'Mad Scientists Lab',0,1,0,0,0,0,289,0),(2555,0,0,0,'',0,0,0,0,0,0,66,2),(2556,0,0,0,'',0,0,0,0,0,0,75,2),(2557,0,0,0,'',0,0,0,0,0,0,77,1),(2558,0,0,0,'',0,0,0,0,0,0,51,1),(2559,0,0,0,'',0,0,0,0,0,0,98,2),(2560,0,0,0,'',0,0,0,0,0,0,104,2),(2561,0,0,0,'',0,0,0,0,0,0,63,1),(2562,0,0,0,'',0,0,0,0,0,0,80,1),(2563,0,0,0,'',0,0,0,0,0,0,97,2),(2564,0,0,0,'',0,0,0,0,0,0,75,2),(2565,0,0,0,'',0,0,0,0,0,0,61,1),(2566,0,0,0,'',0,0,0,0,0,0,64,1),(2567,0,0,0,'',0,0,0,0,0,0,65,1),(2568,0,0,0,'',0,0,0,0,0,0,103,2),(2569,0,0,0,'',0,0,0,0,0,0,71,2),(2570,0,0,0,'',0,0,0,0,0,0,123,2),(2571,0,0,0,'',0,0,0,0,0,0,76,1),(2572,0,0,0,'',0,0,0,0,0,0,84,2),(2573,0,0,0,'',0,0,0,0,0,0,268,6),(2574,0,0,0,'',0,0,0,0,0,0,81,1),(2856,0,0,0,'',0,0,0,0,0,0,42,1),(2859,0,0,0,'',0,0,0,0,0,0,53,1),(2860,0,0,0,'',0,0,0,0,0,0,66,1),(2861,0,0,0,'',0,0,0,0,0,0,72,1),(2862,0,0,0,'',0,0,0,0,0,0,72,1),(2863,0,0,0,'',0,0,0,0,0,0,106,2),(2864,0,0,0,'',0,0,0,0,0,0,94,1),(2865,0,0,0,'',0,0,0,0,0,0,90,1),(2866,0,0,0,'',0,0,0,0,0,0,138,2),(2867,0,0,0,'',0,0,0,0,0,0,36,1),(2868,0,0,0,'',0,0,0,0,0,0,42,1),(2869,0,0,0,'',0,0,0,0,0,0,30,1),(2870,0,0,0,'',0,0,0,0,0,0,35,1),(2872,0,0,0,'Waterside District 1',0,8,0,0,0,0,45,1),(2873,0,0,0,'Extremity 1',0,8,0,0,0,0,36,2),(2874,0,0,0,'East Lane 1',0,8,0,0,0,0,56,2),(2875,0,0,0,'Park Lane 1',0,8,0,0,0,0,25,1),(2876,0,0,0,'Park Lane 2',0,8,0,0,0,0,80,2),(2877,0,0,0,'Park Lane 4',0,8,0,0,0,0,108,3),(2878,0,0,0,'Park Lane 3',0,8,0,0,0,0,70,1),(2879,0,0,0,'Theater Avenue 2',0,8,0,0,0,0,49,1),(2880,0,0,0,'Theater Avenue 1',0,8,0,0,0,0,35,1),(2881,0,0,0,'Theater Avenue 3, 2a',0,8,0,0,0,0,84,2),(2882,0,0,0,'Central Street 4',0,8,0,0,0,0,138,2),(2883,0,0,0,'Central Street 3',0,8,0,0,0,0,146,2),(2884,0,0,0,'Central Street 1',0,8,0,0,0,0,48,1),(2885,0,0,0,'Central Street 2',0,8,0,0,0,0,48,1),(2886,0,0,0,'Magician\'s Alley 1',0,8,0,0,0,0,36,2),(2887,0,0,0,'Magician\'s Alley 2',0,8,0,0,0,0,36,1),(2888,0,0,0,'Magician\'s Alley 3',0,8,0,0,0,0,47,1),(2889,0,0,0,'Magician\'s Alley 5, 2a',0,8,0,0,0,0,31,1),(2890,0,0,0,'Magician\'s Alley 4, 2a',0,8,0,0,0,0,18,1),(2891,0,0,0,'Magician\'s Alley 3, 2a',0,8,0,0,0,0,15,1),(2892,0,0,0,'Western Side 1',0,8,0,0,0,0,25,1),(2893,0,0,0,'Western Side 2',0,8,0,0,0,0,25,2),(2894,0,0,0,'Western Side 3',0,8,0,0,0,0,25,1),(2895,0,0,0,'Western Side 4',0,8,0,0,0,0,30,1),(2896,0,0,0,'Western Side 5',0,8,0,0,0,0,30,2),(2897,0,0,0,'Western Side 5, 2a',0,8,0,0,0,0,30,1),(2898,0,0,0,'Western Side 6, 2a',0,8,0,0,0,0,37,1),(2899,0,0,0,'Central Plaza 1',0,8,0,0,0,0,28,2),(2900,0,0,0,'Central Plaza 2',0,8,0,0,0,0,35,1),(2901,0,0,0,'Central Plaza 3',0,8,0,0,0,0,49,1),(2902,0,0,0,'Northern Street I a',0,8,0,0,0,0,207,4),(2903,0,0,0,'Northern Street I b',0,8,0,0,0,0,63,2),(2904,0,0,0,'Northern Street II',0,8,0,0,0,0,35,1),(2905,0,0,0,'Northern Street 1',0,8,0,0,0,0,30,1),(2906,0,0,0,'Northern Street 2',0,8,0,0,0,0,30,1),(2907,0,0,0,'Northern Street 3',0,8,0,0,0,0,36,1),(2908,0,0,0,'Northern Street 6, 2a',0,8,0,0,0,0,36,1),(2909,0,0,0,'Northern Street 5, 2a',0,8,0,0,0,0,30,1),(2910,0,0,0,'Northern Street 4, 2a',0,8,0,0,0,0,30,1),(2911,0,0,0,'Lonely Sea Side Hostel',0,8,0,0,0,0,96,2),(2912,0,0,0,'The Bath 6',0,4,0,0,0,0,20,0),(2913,0,0,0,'Magic Academy, Flat 2',0,3,0,0,0,0,16,0),(2914,0,0,0,'Central Circle 6 (Shop)',0,3,0,0,0,0,77,1),(2915,0,0,0,'Central Circle 5 (Shop)',0,3,0,0,0,0,56,2),(2916,0,0,0,'Central Circle 7 (Shop)',0,3,0,0,0,0,49,2),(2917,0,0,0,'Central Circle 8 (Shop)',0,3,0,0,0,0,49,2),(2918,0,0,0,'Waterside Flats 1',0,3,0,0,0,0,36,2),(2919,0,0,0,'Waterside Flats 2',0,3,0,0,0,0,33,1),(2920,0,0,0,'Waterside Flats 3',0,3,0,0,0,0,28,1),(2921,0,0,0,'Waterside Street',0,3,0,0,0,0,32,1),(2922,0,0,0,'Central Circle 3',0,3,0,0,0,0,25,1),(2923,0,0,0,'Central Circle 4',0,3,0,0,0,0,20,1),(2924,0,0,0,'Central Circle 2',0,3,0,0,0,0,42,1),(2925,0,0,0,'Central Circle 1',0,3,0,0,0,0,42,1),(2926,0,0,0,'Stonehome Flats, Flat 01',0,3,0,0,0,0,28,0),(2927,0,0,0,'Stonehome Flats, Flat 02',0,3,0,0,0,0,20,0),(2928,0,0,0,'Stonehome Flats, Flat 03',0,3,0,0,0,0,25,0),(2929,0,0,0,'Stonehome Flats, Flat 04',0,3,0,0,0,0,20,0),(2930,0,0,0,'Stonehome Flats, Flat 05',0,3,0,0,0,0,25,0),(2931,0,0,0,'Stonehome Flats, Flat 06',0,3,0,0,0,0,20,0),(2933,0,0,0,'Central Square 10',0,9,0,0,0,0,36,1),(2934,0,0,0,'Central Square 11',0,9,0,0,0,0,42,1),(2935,0,0,0,'Central Square 12',0,9,0,0,0,0,42,1),(2936,0,0,0,'Central Square 13',0,9,0,0,0,0,38,1),(2937,0,0,0,'Central Square 14',0,9,0,0,0,0,20,1),(2938,0,0,0,'Paladin Store',0,9,0,0,0,0,13,0),(2939,0,0,0,'Boatyard 1',0,9,0,0,0,0,15,0),(2940,0,0,0,'Boatyard 2',0,9,0,0,0,0,30,0),(2941,0,0,0,'Boatyard 3',0,9,0,0,0,0,16,0),(2942,0,0,0,'Boatyard 4',0,9,0,0,0,0,16,1),(2943,0,0,0,'Boatyard 5',0,9,0,0,0,0,12,0),(2944,0,0,0,'Boatyard 6',0,9,0,0,0,0,32,1),(2945,0,0,0,'Fishing Hut 1',0,9,0,0,0,0,20,1),(2946,0,0,0,'Fishing Hut 2',0,9,0,0,0,0,35,1),(2947,0,0,0,'Fishing Hut 6',0,9,0,0,0,0,35,1),(2948,0,0,0,'Bothfar Plaza 1',0,9,0,0,0,0,25,0),(2949,0,0,0,'Bothfar Plaza 3',0,9,0,0,0,0,49,1),(2950,0,0,0,'Bothfar Plaza 4',0,9,0,0,0,0,36,1),(2951,0,0,0,'Bothfar Plaza 5',0,9,0,0,0,0,36,1),(2952,0,0,0,'Gunbjorn Valley 1',0,9,0,0,0,0,72,1),(2953,0,0,0,'Gunbjorn Valley 2',0,9,0,0,0,0,50,1),(2954,0,0,0,'Gunbjorn Valley 3',0,9,0,0,0,0,205,4),(2955,0,0,0,'Gunbjorn Valley 4',0,9,0,0,0,0,36,1),(2956,0,0,0,'Helkarakse 1',0,9,0,0,0,0,36,2),(2957,0,0,0,'Helkarakse 2',0,9,0,0,0,0,40,1),(2959,0,0,0,'Helkarakse 3',0,4,0,0,0,0,12,0),(2960,0,0,0,'Helkarakse 4',0,4,0,0,0,0,12,0),(2961,0,0,0,'Helkarakse 5',0,4,0,0,0,0,16,0),(2962,0,0,0,'Mountain Quarters 1',0,4,0,0,0,0,12,0),(2963,0,0,0,'Mountain Quarters 2',0,4,0,0,0,0,12,0),(2964,0,0,0,'Mountain Quarters 3',0,4,0,0,0,0,9,0),(2965,0,0,0,'Mountain Quarters 4',0,4,0,0,0,0,12,0),(2966,0,0,0,'Mountain Quarters 5',0,4,0,0,0,0,9,0),(2967,0,0,0,'Mountain Quarters 6',0,4,0,0,0,0,28,1),(2968,0,0,0,'Mountain Quarters 7',0,4,0,0,0,0,18,1),(2969,0,0,0,'Temple Square 1',0,4,0,0,0,0,12,0),(2970,0,0,0,'Temple Square 2',0,4,0,0,0,0,12,0),(2971,0,0,0,'Temple Square 3',0,4,0,0,0,0,12,0),(2972,0,0,0,'Temple Square 4',0,4,0,0,0,0,9,0),(2973,0,0,0,'Temple Square 5',0,4,0,0,0,0,9,0),(2974,0,0,0,'Temple Square 6',0,4,0,0,0,0,12,0),(2975,0,0,0,'Temple Square 7',0,4,0,0,0,0,24,1),(2976,0,0,0,'Temple Square 8',0,4,0,0,0,0,28,2),(2977,0,0,0,'Temple Square 9',0,4,0,0,0,0,16,0),(2978,0,0,0,'Temple Square 10',0,4,0,0,0,0,28,1),(2979,0,0,0,'Temple Square 11',0,4,0,0,0,0,28,1),(2980,0,0,0,'Village\'s Suburb 1',0,4,0,0,0,0,36,0),(2981,0,0,0,'Village\'s Suburb 2',0,4,0,0,0,0,31,1),(2982,0,0,0,'Village\'s Suburb 3',0,4,0,0,0,0,36,0),(2984,0,0,0,'Othehothep I b',0,7,0,0,0,0,20,1),(2985,0,0,0,'Othehothep I a',0,7,0,0,0,0,25,1),(2986,0,0,0,'Othehothep II a',0,7,0,0,0,0,35,2),(2987,0,0,0,'Othehothep II b',0,7,0,0,0,0,191,5),(2988,0,0,0,'Oskahl I',0,7,0,0,0,0,20,0),(2989,0,0,0,'Unklath I a',0,7,0,0,0,0,20,1),(2990,0,0,0,'Unklath II a',0,7,0,0,0,0,149,3),(2991,0,0,0,'Unklath II b',0,7,0,0,0,0,48,1),(2992,0,0,0,'Thanah I a',0,7,0,0,0,0,206,4),(2993,0,0,0,'Rathal, Flat 1',0,7,0,0,0,0,18,1),(2994,0,0,0,'Rathal, Flat 2',0,7,0,0,0,0,24,1),(2995,0,0,0,'Rathal Tower I a',0,7,0,0,0,0,115,3),(2996,0,0,0,'Botham II',0,7,0,0,0,0,98,1),(2997,0,0,0,'Botham I',0,7,0,0,0,0,98,1),(2998,0,0,0,'Charsirakh I a',0,7,0,0,0,0,64,1),(2999,0,0,0,'Salazart, Flat 2',0,7,0,0,0,0,20,1),(3000,0,0,0,'Salazart, Flat 4',0,7,0,0,0,0,15,1),(3001,0,0,0,'Salazart, Flat 6',0,7,0,0,0,0,15,1),(3002,0,0,0,'Salazart, Flat 5',0,7,0,0,0,0,15,1),(3003,0,0,0,'Salazart, Flat 3',0,7,0,0,0,0,15,1),(3004,0,0,0,'Salazart, Flat 1',0,7,0,0,0,0,20,1),(3005,0,0,0,'Salazart, Flat 7, 2a',0,7,0,0,0,0,50,1),(3006,0,0,0,'Salazart, Flat 8, 2a',0,7,0,0,0,0,50,1),(3007,0,0,0,'Salazart Flat 10, 3a',0,7,0,0,0,0,35,1),(3008,0,0,0,'Salazart Flat 9, 3a',0,7,0,0,0,0,42,0),(3009,0,0,0,'Green Embankment',0,7,0,0,0,0,97,2),(3010,0,0,0,'Esuph II',0,7,0,0,0,0,108,2),(3011,0,0,0,'Esuph I',0,7,0,0,0,0,96,2),(3012,0,0,0,'Quay 1',0,7,0,0,0,0,85,4),(3013,0,0,0,'Quay 2',0,7,0,0,0,0,101,2),(3014,0,0,0,'Stonehome Flats, Flat 07',0,3,0,0,0,0,30,0),(3015,0,0,0,'Magic Academy, Flat 1',0,3,0,0,0,0,20,0),(3016,0,0,0,'Stable Road 1',0,12,0,0,0,0,85,2),(3017,0,0,0,'Stable Road 2',0,12,0,0,0,0,80,1),(3018,0,0,0,'Stable Road 3',0,12,0,0,0,0,53,1),(3019,0,0,0,'Stable Road 4',0,12,0,0,0,0,100,2),(3020,0,0,0,'Stable Road 5',0,12,0,0,0,0,69,1),(3021,0,0,0,'Outcasts Place',0,12,0,0,0,0,109,2),(3022,0,0,0,'Boat Yard 1',0,12,0,0,0,0,120,2),(3023,0,0,0,'Boat Yard 2',0,12,0,0,0,0,75,2),(3024,0,0,0,'Depot Boulevard 1',0,12,0,0,0,0,88,1),(3025,0,0,0,'Depot Boulevard 2',0,12,0,0,0,0,102,2),(3026,0,0,0,'Depot Boulevard 3',0,12,0,0,0,0,82,2),(3027,0,0,0,'Depot Boulevard 4',0,12,0,0,0,0,62,1),(3028,0,0,0,'Corn Farm',0,12,0,0,0,0,72,1),(3029,0,0,0,'Fishermans Hut',0,12,0,0,0,0,25,1),(3030,0,0,0,'Embankment 1',0,12,0,0,0,0,60,1),(3031,0,0,0,'Embankment 2',0,12,0,0,0,0,84,1),(3032,0,0,0,'Embankment 3',0,12,0,0,0,0,132,2),(3033,0,0,0,'Embankment 4',0,12,0,0,0,0,76,1),(3034,0,0,0,'Green Square 1',0,12,0,0,0,0,83,2),(3035,0,0,0,'Main Street 1',0,12,0,0,0,0,300,6),(3036,0,0,0,'Main Street 2',0,12,0,0,0,0,82,1),(3038,0,0,0,'Main Street 3',0,13,0,0,0,0,74,1),(3039,0,0,0,'Main Street 4',0,13,0,0,0,0,74,1),(3040,0,0,0,'Main Street 5',0,13,0,0,0,0,72,1),(3041,0,0,0,'Shelf Site',0,13,0,0,0,0,94,1),(3042,0,0,0,'Trout Plaza 1',0,13,0,0,0,0,106,2),(3043,0,0,0,'Trout Plaza 3',0,13,0,0,0,0,90,1),(3044,0,0,0,'Dwarven Magnate\'s Estate',0,4,0,0,0,0,40,0),(3045,0,0,0,'Nobility Quarter 1',0,4,0,0,0,0,36,0),(3046,0,0,0,'Nobility Quarter 2',0,4,0,0,0,0,36,1),(3047,0,0,0,'The Farms 1',0,4,0,0,0,0,12,0),(3048,0,0,0,'The Farms 2',0,4,0,0,0,0,12,0),(3049,0,0,0,'The Farms 3',0,4,0,0,0,0,28,1),(3050,0,0,0,'The Farms 4',0,4,0,0,0,0,28,1),(3051,0,0,0,'The Farms 5',0,4,0,0,0,0,12,0),(3052,0,0,0,'The Farms 6',0,4,0,0,0,0,9,0),(3053,0,0,0,'The Farms 7',0,4,0,0,0,0,12,0),(3054,0,0,0,'The Farms 8',0,4,0,0,0,0,9,0),(3055,0,0,0,'The Farms 9',0,4,0,0,0,0,12,0),(3056,0,0,0,'The Farms 10',0,4,0,0,0,0,9,0),(3057,0,0,0,'The Farms, Fishing Hut',0,4,0,0,0,0,24,1),(3058,0,0,0,'The Farms 12',0,4,0,0,0,0,9,0),(3059,0,0,0,'The Farms 11',0,4,0,0,0,0,12,0),(3060,0,0,0,'The Farms 14',0,4,0,0,0,0,9,0),(3061,0,0,0,'The Farms 13',0,4,0,0,0,0,12,0),(3062,0,0,0,'The Farms 16',0,4,0,0,0,0,9,0),(3063,0,0,0,'The Farms 15',0,4,0,0,0,0,12,0),(3064,0,0,0,'Hares Den 3',0,4,0,0,0,0,28,2),(3065,0,0,0,'Hares Den 4',0,4,0,0,0,0,16,0),(3066,0,0,0,'Hares Den 1',0,4,0,0,0,0,28,1),(3067,0,0,0,'Hares Den 2',0,4,0,0,0,0,28,1),(3068,0,0,0,'Arakmehn I',0,7,0,0,0,0,49,1),(3069,0,0,0,'Arakmehn II',0,7,0,0,0,0,42,1),(3070,0,0,0,'Charsirakh, Flat 3',0,7,0,0,0,0,30,1),(3071,0,0,0,'Charsirakh, Flat 1',0,7,0,0,0,0,20,1),(3072,0,0,0,'Charsirakh, Flat 2',0,7,0,0,0,0,15,1),(3073,0,0,0,'Charsirakh I b',0,7,0,0,0,0,99,2),(3074,0,0,0,'Old Lighthouse',0,5,0,0,0,0,84,2),(3075,0,0,0,'Seagull Walk 1',0,5,0,0,0,0,85,2),(3076,0,0,0,'Seagull Walk 2',0,5,0,0,0,0,80,1),(3077,0,0,0,'Market Street 1',0,5,0,0,0,0,102,2),(3078,0,0,0,'Market Street2',0,5,0,0,0,0,78,2),(3079,0,0,0,'Market Street3',0,5,0,0,0,0,63,1),(3080,0,0,0,'Iron Alley 1',0,5,0,0,0,0,71,1),(3081,0,0,0,'Iron Alley 2',0,5,0,0,0,0,20,1),(3082,0,0,0,'Iron Alley 3, 2a',0,5,0,0,0,0,52,1),(3083,0,0,0,'Dream Street 1 (Shop)',0,5,0,0,0,0,130,2),(3084,0,0,0,'Dream Street 1, 2a',0,5,0,0,0,0,76,1),(3085,0,0,0,'Mystic Lane 1',0,5,0,0,0,0,75,2),(3086,0,0,0,'Mystic Lane 2',0,5,0,0,0,0,128,2),(3087,0,0,0,'Mystic Lane (Tower)',0,5,0,0,0,0,84,1),(3088,0,0,0,'Mystic Lane (Depot)',0,5,0,0,0,0,60,1),(3089,0,0,0,'Mystic Lane 3',0,5,0,0,0,0,80,1),(3090,0,0,0,'Mystic Lane 5',0,5,0,0,0,0,111,2),(3091,0,0,0,'Mystic Lane 4',0,5,0,0,0,0,107,2),(3092,0,0,0,'Mystic Lane 6',0,5,0,0,0,0,88,1),(3093,0,0,0,'Elm Watch',0,5,0,0,0,0,84,1),(3094,0,0,0,'Paupers Salvation',0,5,0,0,0,0,84,2),(3095,0,0,0,'Lucky Lane',0,5,0,0,0,0,299,6),(3096,0,0,0,'Glacier Side 1',0,9,0,0,0,0,72,1),(3097,0,0,0,'Glacier Side 2',0,9,0,0,0,0,72,1),(3098,0,0,0,'Glacier Side 3',0,9,0,0,0,0,72,1),(3099,0,0,0,'Glacier Side 4',0,9,0,0,0,0,42,1),(3100,0,0,0,'Glacier Side 6, 2a',0,9,0,0,0,0,35,1),(3101,0,0,0,'Glacier Side 5',0,9,0,0,0,0,36,1),(3102,0,0,0,'Glacier Side 7, 2a',0,9,0,0,0,0,30,1),(3103,0,0,0,'Glacier Side 8',0,9,0,0,0,0,87,1),(3104,0,0,0,'Bears Paw 1',0,9,0,0,0,0,106,2),(3105,0,0,0,'Bears Paw 2',0,9,0,0,0,0,90,1),(3106,0,0,0,'The Big Bears Paw',0,9,0,0,0,0,137,2),(3107,0,0,0,'Mammoth House',0,9,0,0,0,0,54,1),(3108,0,0,0,'Sky Lane',0,3,0,0,0,0,42,0),(3114,0,0,0,'Verona Harbour Lane',0,2,0,0,0,0,24,0),(3115,0,0,0,'Stone Guild Hall',0,2,0,0,0,0,193,0),(3137,0,0,0,'Ivory Circle 1',0,6,0,0,0,0,36,1),(3138,0,0,0,'Marble Lane 1',0,6,0,0,0,0,36,1),(3139,0,0,0,'Gunbjorn Valley 1',0,6,0,0,0,0,35,1),(3140,0,0,0,'Boatyard, Flat 1',0,6,0,0,0,0,30,0),(3141,0,0,0,'Boatyard, Flat 2',0,6,0,0,0,0,16,0),(3142,0,0,0,'Boatyard, Flat 3',0,6,0,0,0,0,16,1),(3143,0,0,0,'Boatyard, Flat 4',0,6,0,0,0,0,12,0),(3144,0,0,0,'Boatyard 3',0,6,0,0,0,0,48,1),(3145,0,0,0,'Boatyard 2',0,6,0,0,0,0,25,0),(3146,0,0,0,'Boatyard 1',0,6,0,0,0,0,36,1),(3147,0,0,0,'Ivory Circle 2',0,6,0,0,0,0,42,1),(3148,0,0,0,'Marble Lane 2',0,6,0,0,0,0,42,1),(3149,0,0,0,'Gunbjorn Valley 2',0,6,0,0,0,0,36,1),(3150,0,0,0,'Boatyard, Flat 6',0,6,0,0,0,0,20,1),(3151,0,0,0,'Boatyard, Flat 5',0,6,0,0,0,0,32,1),(3152,0,0,0,'Boatyard 5, 2a',0,6,0,0,0,0,35,1),(3153,0,0,0,'Boatyard 4, 2a',0,6,0,0,0,0,36,1),(3154,0,0,0,'Boatyard 6, 3a',0,6,0,0,0,0,35,1),(3155,0,0,0,'Boatyard, Flat 9',0,6,0,0,0,0,15,0),(3156,0,0,0,'Boatyard, Flat 10',0,6,0,0,0,0,12,0),(3157,0,0,0,'Boatyard, Flat 8',0,6,0,0,0,0,20,1),(3158,0,0,0,'Harvester\'s Haven',0,6,0,0,0,0,37,1),(3159,0,0,0,'Gunbjorn Valley 3',0,6,0,0,0,0,36,2),(3160,0,0,0,'Shady Trail 3',0,6,0,0,0,0,50,1),(3161,0,0,0,'Shady Trail 2',0,6,0,0,0,0,72,1),(3162,0,0,0,'Shady Trail 1',0,6,0,0,0,0,183,4),(3163,0,0,0,'East Lane 2, 2a',0,8,0,0,0,0,56,2),(3164,0,0,0,'Extremity 2',0,8,0,0,0,0,45,1),(3165,0,0,0,'Extremity 3, 2a',0,8,0,0,0,0,78,2),(3166,0,0,0,'Tasheath, Flaroh',0,8,0,0,0,0,20,1),(3167,0,0,0,'Green Village, Residence 1',0,8,0,0,0,0,45,2),(3168,0,0,0,'Green Village, Residence 2',0,8,0,0,0,0,154,2),(3169,0,0,0,'Warriors\' Guildhall',0,8,0,0,0,0,506,11),(3170,0,0,0,'Verona Depot Apartments V',0,2,0,0,0,0,14,1);
/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `inventories`
--
DROP TABLE IF EXISTS `inventories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inventories` (
`id` int NOT NULL AUTO_INCREMENT,
`account_id` int NOT NULL,
`itemid` int NOT NULL,
`item_amount` int DEFAULT NULL,
`item_title` varchar(255) NOT NULL,
`item_description` longtext,
`shop_image` varchar(255) DEFAULT NULL,
`createdAt` datetime NOT NULL,
`updatedAt` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`),
CONSTRAINT `inventories_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `inventories`
--
LOCK TABLES `inventories` WRITE;
/*!40000 ALTER TABLE `inventories` DISABLE KEYS */;
/*!40000 ALTER TABLE `inventories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ioe`
--
DROP TABLE IF EXISTS `ioe`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ioe` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`hora` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`itemid` int NOT NULL,
`boss` int NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ioe`
--
LOCK TABLES `ioe` WRITE;
/*!40000 ALTER TABLE `ioe` DISABLE KEYS */;
/*!40000 ALTER TABLE `ioe` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ip_bans`
--
DROP TABLE IF EXISTS `ip_bans`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ip_bans` (
`ip` int unsigned NOT NULL,
`reason` varchar(255) NOT NULL,
`banned_at` bigint NOT NULL,
`expires_at` bigint NOT NULL,
`banned_by` int NOT NULL,
PRIMARY KEY (`ip`),
KEY `banned_by` (`banned_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ip_bans`
--
LOCK TABLES `ip_bans` WRITE;
/*!40000 ALTER TABLE `ip_bans` DISABLE KEYS */;
/*!40000 ALTER TABLE `ip_bans` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `links`
--
DROP TABLE IF EXISTS `links`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `links` (
`account_id` int NOT NULL,
`code` varchar(50) NOT NULL,
`code_date` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `links`
--
LOCK TABLES `links` WRITE;
/*!40000 ALTER TABLE `links` DISABLE KEYS */;
/*!40000 ALTER TABLE `links` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `market_history`
--
DROP TABLE IF EXISTS `market_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `market_history` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`player_id` int NOT NULL,
`sale` tinyint(1) NOT NULL DEFAULT '0',
`itemtype` int unsigned NOT NULL,
`amount` smallint unsigned NOT NULL,
`price` int unsigned NOT NULL DEFAULT '0',
`expires_at` bigint unsigned NOT NULL,
`inserted` bigint unsigned NOT NULL,
`state` tinyint unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `player_id` (`player_id`,`sale`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `market_history`
--
LOCK TABLES `market_history` WRITE;
/*!40000 ALTER TABLE `market_history` DISABLE KEYS */;
INSERT INTO `market_history` VALUES (1,5,1,2323,1,30000,1591481724,1597530488,2);
/*!40000 ALTER TABLE `market_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `market_offers`
--
DROP TABLE IF EXISTS `market_offers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `market_offers` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`player_id` int NOT NULL,
`sale` tinyint(1) NOT NULL DEFAULT '0',
`itemtype` int unsigned NOT NULL,
`amount` smallint unsigned NOT NULL,
`created` bigint unsigned NOT NULL,
`anonymous` tinyint(1) NOT NULL DEFAULT '0',
`price` int unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `sale` (`sale`,`itemtype`),
KEY `created` (`created`),
KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `market_offers`
--
LOCK TABLES `market_offers` WRITE;
/*!40000 ALTER TABLE `market_offers` DISABLE KEYS */;
/*!40000 ALTER TABLE `market_offers` ENABLE KEYS */;
UNLOCK TABLES;