+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep1 Guides (https://lckb.dev/forum/forumdisplay.php?fid=178)
+----- Thread: Map sql release all maps (/showthread.php?tid=584)
- roseon - 01-04-2012
Here the release for all maps to work
INSERT INTO `t_zonedata` VALUES (0, Juno, 1536, 1536, 1, data/StartZone_1536_1536_0.sat, data/StartZone_1536_1536_0.[CeNsOrEd], 1, 1, 6, 0 0 0 0 0 0, 1102 275 1102 207 156 1440, 942 629 942 1280 121 875, 1122 280 1122 227 161 1444, 962 634 962 1300 126 870, enabled, 1, 1, 2, 0 0, 988 102, 824 1234, 1340 290, 1168 1430, !¶õµ¹¸¶À»!¸¶¸£¸¶À», 0 3);INSERT INTO `t_zonedata` VALUES (1, Belfist Temple, 384, 444, 2, data/Dungeon1_384_444_0.sat data/Dungeon1_384_444_1.sat, data/Dungeon1_384_444_0.[CeNsOrEd] data/Dungeon1_384_444_1.[CeNsOrEd], 1, 0, 1, 0, 178, 231, 193, 252, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (2, Personal Dungeon 1, 768, 768, 1, data/SingleDungeon_768_768_0.sat, data/SingleDungeon_768_768_0.[CeNsOrEd], 100, 0, 1, 0, 28, 265, 28, 265, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (3, Prokion Shrine, 504, 432, 2, data/Dungeon2_504_432_0.sat data/Dungeon2_504_432_1.sat, data/Dungeon2_504_432_0.[CeNsOrEd] data/Dungeon2_504_432_1.[CeNsOrEd], 1, 0, 1, 0, 250, 229, 270, 249, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (4, Dratan, 3072, 3072, 2, data/Dratan_3072_3072_0.sat data/Dratan_3072_3072_1.sat, data/Dratan_3072_3072_0.[CeNsOrEd] data/Dratan_3072_3072_1.[CeNsOrEd], 1, 1, 30, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0, 1795 2926 1624 1624 1624 1624 1624 1624 1624 1624 1590 2535 2915 449 292 208 621 529 464 496 526 204 212 146 97 354 50 653 110 346, 359 1324 1804 1804 1804 1804 1804 1804 1804 1804 1750 2755 241 2684 2428 2706 2665 2845 2895 2946 2968 2418 2485 2569 2447 2675 2300 1651 100 2685, 1817 2932 1653 1653 1653 1653 1653 1653 1653 1653 1600 2563 2920 468 314 227 631 546 478 510 531 218 224 160 111 356 700 671 120 355, 381 1344 1811 1811 1811 1811 1811 1811 1811 1811 1760 2783 246 2703 2443 2724 2675 2861 2909 2960 2983 2432 2493 2583 2461 2693 3000 1655 110 2695, enabled, 1, 1, 2, 0 0, 1596 2474, 108 2688, 2015 2708, 588 2924, ![0] ¶óÀÚ¸£ ¸¶À»![1] ½Ã¶ó½º ¸¶À», 0 11);
INSERT INTO `t_zonedata` VALUES (5, Personal Dungeon 2, 720, 720, 1, data/SingleDungeon2_720_720_0.sat, data/SingleDungeon2_720_720_0.[CeNsOrEd], 100, 0, 1, 0, 28, 287, 28, 287, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (6, Start Map, 768, 768, 1, data/SingleDungeon_768_768_0.sat, data/SingleDungeon_768_768_0.[CeNsOrEd], 1000, 0, 1, 0, 20, 260, 20, 260, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (7, Merac, 1536, 1536, 1, data/Merac_1536_1536_0.sat, data/Merac_1536_1536_0.[CeNsOrEd], 1, 1, 20, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0, 580 78 1342 1071 1215 1240 1375 1375 1020 1012 1012 1020 1020 1012 1020 1012 1160 1460 57 485, 270 844 1021 1027 1028 1028 992 1063 939 962 990 1013 1043 1068 1094 1118 886 865 1247 1332, 610 82 1358 1082 1223 1248 1383 1383 1028 1020 1020 1028 1028 1020 1028 1020 1496 1465 62 486, 290 848 1037 1038 1036 1036 1000 1071 946 970 998 1021 1051 1076 1102 1126 1186 870 1252 1333, enabled, 1, 1, 2, 0 0, 392 0, 0 1088, 780 156, 412 1344, !ÄÉ·à [0] ¸Þ¶óÅ© ¸ÞÀθ¶À»!¸Þ·à [1] ¸Þ¶óÅ© ÀºµÃÀÚ ¸¶À», 0 18);
INSERT INTO `t_zonedata` VALUES (8, Guild Room, 100, 100, 1, data/GuildRoom_100_100_0.sat, data/GuildRoom_100_100_0.[CeNsOrEd], 1000, 0, 1, 0, 36, 63, 36, 63, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (9, Margadum Jail, 504, 504, 1, data/Dungeon3_504_504_0.sat, data/Dungeon3_504_504_0.[CeNsOrEd], 1, 0, 11, 0 0 0 0 0 0 0 0 0 0 0, 53 54 177 177 362 314 78 78 249 249 400, 236 44 266 45 216 79 462 322 472 310 403, 59 58 181 181 366 318 82 82 253 253 404, 242 45 267 46 217 80 463 323 473 311 404, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (10, Personal Dungeon 3, 768, 768, 1, data/SDungeon3_768_768_0.sat, data/SDungeon3_768_768_0.[CeNsOrEd], 100, 0, 1, 0, 687, 181, 691, 185, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (11, Personal Dungeon 4, 504, 504, 1, data/SDungeon4_516_516_0.sat, data/SDungeon4_516_516_0.[CeNsOrEd], 100, 0, 1, 0, 38, 254, 42, 258, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (12, Temple Of Forgetfulness, 1152, 1152, 1, data/PDungeon1_1152_1152_0.sat, data/PDungeon1_1152_1152_0.[CeNsOrEd], 1, 0, 1, 0, 395, 597, 405, 607, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (13, Margadum Jail PVP, 504, 504, 1, data/Dungeon3PVP_504_504_0.sat, data/Dungeon3PVP_504_504_0.[CeNsOrEd], 1, 0, 11, 0 0 0 0 0 0 0 0 0 0 0, 53 54 177 177 362 314 78 78 249 249 400, 236 44 266 45 216 79 462 322 472 310 403, 59 58 181 181 366 318 82 82 253 253 404, 242 45 267 46 217 80 463 323 473 311 404, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (14999, OX Event, 120, 120, 1, data/OXRoom_120_120_0.sat, data/OXRoom_120_120_0.[CeNsOrEd], 1, 0, 3, 0 0 0, 32 21 52, 60 15 15, 40 47 77, 68 55 55, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (15, Egeha, 1536, 1536, 1, data/Egeha_1536_1536_0.sat, data/Egeha_1536_1536_0.[CeNsOrEd], 1, 1, 4, 0 0 0, 1460 309 0 765, 108 985 0 95, 1466 314 0 767, 113 990 0 97, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (16, Egeha PK, 400, 400, 0, data/EgehaPK_400_400_0.sat, data/EgehaPK_400_400_0.[CeNsOrEd], 1, 0, 0, , , , , , enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (17, Lust Trum F1 to F7, 605, 624, 1, data/EgehaDungeon1to7_605_624_0.sat, data/EgehaDungeon1to7_605_624_0.[CeNsOrEd], 1, 0, 2, 0, 540, 150, 542, 152, enabled, 1, 1, 0, , , , , , null, );
INSERT INTO `t_zonedata` VALUES (18, Lust Trum F8, 384, 384, 1, data/EgehaDungeon8F_384_384_0.sat, data/EgehaDungeon8F_384_384_0.[CeNsOrEd], 1, 0, 2, 0 0, 137 0, 204 0, 138 0, 205 0, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (19, Lust Trum F9, 384, 384, 1, data/EgehaDungeon9F_384_384_0.sat, data/EgehaDungeon9F_384_384_0.[CeNsOrEd], 1, 0, 2, 0 0, 62 0, 308 0, 63 0, 309 0, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (20, Lust Trum F10, 448, 448, 1, data/EgehaDungeon10F_448_448_0.sat, data/EgehaDungeon10F_448_448_0.[CeNsOrEd], 1, 0, 1, 0, 260, 313, 261, 314, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (22, Monster Combo, 2400, 2400, 1, data/mCombo_2400_2400_0.sat, data/mCombo_2400_2400_0.[CeNsOrEd], 100, 0, 0, , , , , , no, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (23, Strayana, 1536, 1536, 3, data/Streiana1_1536_1536_0.sat data/Streiana2_1536_1536_0.sat data/Streiana3_1536_1536_0.sat, data/Streiana1_1536_1536_0.[CeNsOrEd] data/Streiana2_1536_1536_0.[CeNsOrEd] data/Streiana3_1536_1536_0.[CeNsOrEd], 1, 1, 6, 0 0 0 0 0 0, 1046 207 1046 371 741 1232, 618 1225 618 911 582 99, 1048 209 1048 373 743 1234, 620 1227 620 913 584 101, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (24, Dratan PVP Arena, 1536, 1536, 2, data/PKTournament1F_1536_1536_0.sat data/PKTournament2F_1536_1536_0.sat, data/PKTournament1F_1536_1536_0.[CeNsOrEd] data/PKTournament2F_1536_1536_0.[CeNsOrEd], 1, 1, 1, 0, 430, 813, 435, 800, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (25, Hexaeder ?????, 384, 384, 0, , , 100, 0, 0, , , , , , no, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (26, The Spirit Cave, 1024, 1024, 1, data/cave3_1024_1024_0.sat, data/cave3_1024_1024_0.[CeNsOrEd], 1, 0, 1, 0, 220, 315, 222, 317, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (27, Echsenhöhle, 1024, 1024, 1, data/cave2_1024_1024_0.sat, data/cave2_1024_1024_0.[CeNsOrEd], 1, 0, 0, 0, 220, 315, 222, 317, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (28, Golemgrube, 1024, 1024, 1, data/cave_1024_1024_0.sat, data/cave_1024_1024_0.[CeNsOrEd], 1, 0, 0, 0, 220, 315, 222, 317, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (29, Ebony Mine, 768, 768, 1, data/DirtyMine_768_768_0.sat, data/DirtyMine_768_768_0.[CeNsOrEd], 1, 0, 1, 0, 538, 178, 542, 182, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (30, Misty Cannon, 768, 768, 1, data/LosePlace_768_768_0.sat, data/LosePlace_768_768_0.[CeNsOrEd], 1, 0, 1, 0, 672, 164, 673, 165, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (31, Floraim Cave, 1024, 1024, 1, data/EgehaCave1_1024_1024_0.sat, data/EgehaCave1_1024_1024_0.[CeNsOrEd], 1, 0, 1, 0, 371, 352, 372, 353, enabled, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (32, MondShine, 3072, 3072, 0, data/AscadiaMondShine_3072_3072_0.sat, data/AscadiaMondShine_3072_3072_0.[CeNsOrEd], 1, 0, 0, , , , , , no, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (33, Kapelle 1F ?????, 0, 0, 0, data/CappellaDungeon_01.sat, data/CappellaDungeon_01.[CeNsOrEd], 100, 0, 0, , , , , , no, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (34, Kapelle 2F ?????, 0, 0, 0, data/CappellaDungeon.sat, data/CappellaDungeon.[CeNsOrEd], 1, 0, 0, , , , , , no, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (35, Altar der Dunkelheit, 0, 0, 0, data/OutsideDungeon1.sat, data/OutsideDungeon1.[CeNsOrEd], 1, 0, 0, , , , , , no, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (36, Akan Tempel, 1024, 1024, 1, data/Akantemple_1024_1024_0.sat, data/Akantemple_1024_1024_0.[CeNsOrEd], 100, 0, 0, , , , , , no, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (37, Drangsal ?????, 0, 0, 0, data/canyon.sat, data/canyon.[CeNsOrEd], 1, 0, 0, , , , , , no, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (38, Royal Rumble, 256, 256, 1, data/PkRoyalRumble_256_256_0.sat, data/PkRoyalRumble_256_256_0.[CeNsOrEd], 1, 0, 0, , , , , , no, 1, 1, 0, null, null, null, null, null, null, null);
INSERT INTO `t_zonedata` VALUES (14, Mondshine, 3072, 3072, 1, data/moora.sat, data/moora.[CeNsOrEd], 1, 0, 1, 0, 395, 280, 397, 282, enabled, 1, 1, 0, , , , , , null, );
INSERT INTO `t_zonedata` VALUES (21, Theos Tomb, 1536, 1536, 1, data/Dratan_siegeWarfare_dungeon_1536_1536_0.sat, data/Dratan_siegeWarfare_dungeon_1536_1536_0.[CeNsOrEd], 1, 0, 1, , 775, 310, 775, 305, enabled, 1, 1, 0, null, null, null, null, null, null, null);
- lol102 - 01-04-2012
Did u can upload the SQL files or not ?
- roseon - 01-04-2012
dude i dont need to upload anything this script easy to use copy it all and paste it to console in navicat just open your t_zonedata and clear it all out den run the console
- Sutz - 01-04-2012
This is my t_zonedata xD from my database that you used this not any good for anyone unless they rename all their sats & [CeNsOrEd] files.
- hallo1234 - 01-04-2012
ty max got i bug with my mora.[CeNsOrEd] but with this script it absolutely should work
- roseon - 01-04-2012
that the point xD
- Sutz - 01-04-2012
no point mate just warning ppl will need to rename
- Koko - 01-04-2012
Im sorry, but...
- As Max said, ppl may have custom names for their sat/[CeNsOrEd], so youll just bring more noobs who cant event check that asking why it doesnt work with ur files and their name...
- Im pretty sure Falo release the same in is "some bugfix" thread
Thanks anyway for taking the time to put it again here