New Public DB upcoming

A forum for releases and discussions on database releases by the community

Moderators: Project Admin, Support Team, Database Team

Post a reply

New Public DB upcoming

Postby PlanarChaosRvrtwo » Thu Jul 07, 2016 6:29 am

Hey guys i shared allready some stuff before but couse harddrive total crash i do new server and lost login data for old Account to forums.
Im going to combine all kind of existing databases and add and remove useless stuff.
Its not a big help but here as a first release of that work a full list of livelike teleports locs defined for database (cant tell that the Inconu crypt / kobold undercity / shar laby locs are livelike but they work correct and port you near the center of those cities)
-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server Version: 10.1.14-MariaDB - mariadb.org binary distribution
-- Server Betriebssystem: Win64
-- HeidiSQL Version: 9.1.0.4867
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!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' */;
-- Exportiere Daten aus Tabelle dol.teleport: ~97 rows (ungefähr)
DELETE FROM `teleport`;
/*!40000 ALTER TABLE `teleport` DISABLE KEYS */;
INSERT INTO `teleport` (`Type`, `TeleportID`, `Realm`, `RegionID`, `X`, `Y`, `Z`, `Heading`, `LastTimeRowUpdated`, `Teleport_ID`) VALUES
('Midgard Town Teleporter', 'Midgard Town', 2, 163, 597650, 304878, 8088, 3151, '2000-01-01 00:00:00', '0224aef6-3cdd-49a2-97f8-c2d694f9c283'),
('Mid Training Teleporter', 'Jordheim', 1, 101, 31665, 27495, 8800, 3077, '2000-01-01 00:00:00', '04359c4b-8eea-4989-967f-5d836b704c29'),
('Djinn', 'Druim Ligen', 3, 200, 334435, 419941, 5184, 184, '2000-01-01 00:00:00', '0441c39c-bf5d-4633-b27b-49e10bfcff57'),
('Albion Town Teleporter', 'Albion Town', 1, 163, 677193, 568367, 8088, 3822, '2000-01-01 00:00:00', '0651a6a6-0d09-467c-9d19-1cd7e6356f12'),
('Teleporter', 'Catterick Hamlet', 1, 163, 677276, 568343, 8088, 184, '2000-01-01 00:00:00', '09f89ab0-9a3e-413e-b89d-996ef01800e4'),
('', 'Holtham', 1, 27, 94940, 91818, 5024, 1803, '2000-01-01 00:00:00', '114c2ce0-04d9-4ff2-a152-a9c43efa570a'),
('Cotswold Teleporter', 'Sure', 1, 1, 561015, 511367, 2313, 697, '2000-01-01 00:00:00', '14c1ecdb-f75b-45d6-aa23-c1678d1ae4e4'),
('Drizzle', 'Camelot', 1, 10, 36085, 31155, 8002, 2994, '2000-01-01 00:00:00', '14fd9659-175d-4f02-a4a5-4f2d6ecabf3b'),
('Djinn', 'Svasud Faste', 2, 100, 765518, 673661, 5736, 1671, '2000-01-01 00:00:00', '2467cee2-9966-438d-bf01-22fa9cefb629'),
('Djinn', 'Camelot', 1, 10, 36213, 29881, 7969, 47, '2000-01-01 00:00:00', '2f6d1858-98d6-48fb-995e-f24e10899474'),
('Teleporter', 'Crair Treflan', 1, 163, 373944, 572847, 8040, 719, '2000-01-01 00:00:00', '36c14bd9-a616-44b7-82d9-ced99c6dc1ce'),
('', 'AlbThroneRoom', 2, 394, 32328, 31795, 15901, 17, '2000-01-01 00:00:00', '3b9b72a9-76cc-4b97-ade9-1d1e1ab91655'),
('Djinn', 'Snowdonia Fortress', 1, 1, 515959, 372539, 8208, 3325, '2000-01-01 00:00:00', '50958d9e-ba6b-4510-8a14-0d96c291e390'),
('Djinn', 'Tir na Nog', 3, 201, 33198, 31407, 8000, 2068, '2000-01-01 00:00:00', '526b4375-74d8-482f-9b5d-5d2e9252c705'),
('', 'MidThroneExit', 2, 101, 31752, 27053, 8830, 27, '2000-01-01 00:00:00', '58668bba-c72c-4d39-8184-e83b8ab44668'),
('Drizzle', 'Tir na Nog', 1, 201, 30224, 32653, 7919, 2717, '2000-01-01 00:00:00', '5a6262fe-39ef-4ffc-bf9a-41a6af0a625e'),
('Djinn', 'Druim Cain', 3, 200, 421156, 486429, 1824, 2407, '2000-01-01 00:00:00', '5d4902cc-6eb1-4a18-b14b-3cc39c87769b'),
('', 'MidThroneRoom', 2, 360, 32331, 30410, 15563, 3, '2000-01-01 00:00:00', '69e10769-3556-4a60-87f5-ff001c25da38'),
('', 'Hafheim', 2, 27, 226050, 223025, 5056, 2146, '2000-01-01 00:00:00', '75857982-e7fc-40d2-80c3-a38bd5ce834a'),
('Hib Training Teleporter', 'Tir na Nog', 1, 201, 32242, 32604, 7998, 3049, '2000-01-01 00:00:00', '7b526264-d21d-490a-8670-8e4d88479298'),
('Drizzle', 'Jordheim', 1, 101, 31871, 27878, 8800, 244, '2000-01-01 00:00:00', '849e0b90-2fd7-4355-b8ab-baa17fe9ccc1'),
('Djinn', 'Vindsaul Faste', 2, 100, 704110, 738883, 5704, 1845, '2000-01-01 00:00:00', '8f72e2be-4d3e-4f92-8aae-0fd6d36ed6b8'),
('', 'Fintain', 3, 27, 357012, 353642, 5056, 1894, '2000-01-01 00:00:00', '95e6e9a0-a980-44e5-8c09-19b5ea4a6598'),
('Hibernia NF Teleporter', 'Cruachan Gorge', 3, 163, 396557, 618469, 9825, 1941, '2000-01-01 00:00:00', '969a2fe2-17ee-4110-ae44-8cdc2c8f61f5'),
('Djinn', 'Castle Sauvage', 1, 1, 583668, 486493, 2184, 3217, '2000-01-01 00:00:00', '9ca6f0bb-52b7-42b0-863c-ad6d4fe7a4fd'),
('Midgard NF Teleporter', 'Uppland', 2, 163, 651761, 313723, 9432, 1020, '2000-01-01 00:00:00', 'a73cecb0-3599-448c-b78f-0a8d0773dcb3'),
('', 'Avalon Marsh', 1, 1, 462144, 633058, 1739, 1769, '2000-01-01 00:00:00', 'alb_avalon_marsh'),
(NULL, 'Diogel', 1, 51, 403748, 503110, 4680, 1106, '2000-01-01 00:00:00', 'alb_caer_diogel'),
('', 'Camelot', 1, 10, 36230, 29846, 7970, 11, '2000-01-01 00:00:00', 'alb_camelot'),
('', 'Castle Sauvage', 1, 1, 583913, 487012, 2184, 2048, '2000-01-01 00:00:00', 'alb_castle_sauvage'),
('', 'Forest Sauvage', 1, 163, 652700, 617189, 9560, 2815, '2000-01-01 00:00:00', 'alb_forest_sauvage'),
(NULL, 'Gwyntell', 1, 51, 426851, 416460, 5712, 1295, '2000-01-01 00:00:00', 'alb_fort_gwyntell'),
(NULL, 'Gothwaite', 1, 51, 535158, 548589, 4805, 463, '2000-01-01 00:00:00', 'alb_gothwaite'),
(NULL, 'housing', 1, 0, 0, 0, 0, 0, '2000-01-01 00:00:00', 'alb_housing'),
(NULL, 'entrance', 1, 2, 585071, 561548, 3576, 1036, '2000-01-01 00:00:00', 'alb_housing_entrance'),
(NULL, 'guild', 1, 2, 585071, 561548, 3576, 1036, '2000-01-01 00:00:00', 'alb_housing_guild'),
(NULL, 'hearth', 1, 2, 585071, 561548, 3576, 1036, '2000-01-01 00:00:00', 'alb_housing_hearth'),
(NULL, 'personal', 1, 2, 585071, 561548, 3576, 1036, '2000-01-01 00:00:00', 'alb_housing_personal'),
(NULL, 'Inconnu Crypt', 1, 65, 32900, 35568, 16353, 31, '2000-01-01 00:00:00', 'alb_inconnu_Crypt'),
(NULL, 'Oceanus', 1, 73, 271184, 539600, 8344, 645, '2000-01-01 00:00:00', 'alb_oceanus'),
(NULL, 'Shrouded Isles', 1, 0, 0, 0, 0, 0, '2000-01-01 00:00:00', 'alb_shrouded_isles'),
('', 'Snowdonia Fortress', 1, 1, 516801, 373238, 8208, 1757, '2000-01-01 00:00:00', 'alb_snowdonia_fortress'),
(NULL, 'Wearyall', 1, 51, 434585, 493128, 3088, 1043, '2000-01-01 00:00:00', 'alb_wearyall'),
('DR', 'MidThroneExit', 1, 101, 31753, 27073, 8830, 6, '2000-01-01 00:00:00', 'b742967e-9835-4e51-8924-a89accbd0b14'),
('DR', 'HibThroneExit', 1, 201, 33176, 32914, 8008, 2048, '2000-01-01 00:00:00', 'b9d40db2-4fff-47c3-a1c7-242a8f223024'),
('svasud', 'hillshire', 1, 27, 95644, 101313, 5340, 1024, '2000-01-01 00:00:00', 'bb633231-208d-4e31-ac01-6f49beedd9c3'),
('DR', 'AlbThroneExit', 1, 10, 32689, 24326, 8447, 3080, '2000-01-01 00:00:00', 'c20b0e54-cdd8-4b0b-beec-c4979a83729a'),
('', 'HibThroneExit', 2, 201, 33180, 32939, 8008, 2078, '2000-01-01 00:00:00', 'c4517625-0a43-44b7-9298-9e219d948d31'),
('Teleporter', 'Godrborg', 1, 163, 597563, 304676, 8088, 1606, '2000-01-01 00:00:00', 'ccdd5633-0994-4b0f-9d27-25121673411d'),
('Alb Training Teleporter', 'Camelot', 1, 10, 33092, 24981, 8447, 1482, '2000-01-01 00:00:00', 'd4c912f4-aab2-479e-b7ea-617624ee7e8a'),
('Hibernia Town Teleporter', 'Hibernia Town', 3, 163, 373626, 572884, 8040, 2189, '2000-01-01 00:00:00', 'dcf603b0-4e86-45f7-8d76-f9b00e3e8e35'),
('Midgard NF Teleporter', 'Yggdra Forest', 2, 163, 715347, 364830, 9432, 284, '2000-01-01 00:00:00', 'e18686f0-d84a-4938-8e7c-1eb0aa8114b5'),
('Djinn', 'Jordheim', 2, 101, 31928, 27447, 8800, 2218, '2000-01-01 00:00:00', 'eeebe3e6-f73b-4d94-bf7d-ea902c5da226'),
('', 'HibThroneRoom', 2, 395, 32329, 31779, 15715, 12, '2000-01-01 00:00:00', 'f2a3428c-d3c3-4d3a-ad31-113b41db1361'),
('Hibernia NF Teleporter', 'Valley of Bri Leith', 3, 163, 432550, 680367, 9752, 2480, '2000-01-01 00:00:00', 'f2f2cf69-c026-40c7-862b-6aeaf13806ca'),
('', 'Accept', 1, 100, 759130, 700085, 6366, 1486, '2000-01-01 00:00:00', 'f3ca9134-2213-4ea1-a3c8-8aed3cac00a8'),
('', 'AlbThroneExit', 2, 10, 32633, 24324, 8447, 3079, '2000-01-01 00:00:00', 'f48d34bd-33eb-431a-9f6d-01e8f5088ef9'),
(NULL, 'Aalid Feie', 3, 181, 313726, 352686, 3592, 747, '2000-01-01 00:00:00', 'hib_aalid_feie'),
('', 'Cruachan Gorge', 3, 163, 395474, 618665, 9816, 2616, '2000-01-01 00:00:00', 'hib_cruachan_gorge'),
(NULL, 'Domnann', 3, 181, 423089, 444756, 5959, 2060, '2000-01-01 00:00:00', 'hib_domnann'),
(NULL, 'Droighaid', 3, 181, 379081, 420975, 5528, 1159, '2000-01-01 00:00:00', 'hib_droghaid'),
('', 'Druim Cain', 3, 200, 421264, 486315, 1824, 2013, '2000-01-01 00:00:00', 'hib_druim_cain'),
('', 'Druim Ligen', 3, 200, 334342, 419994, 5184, 2309, '2000-01-01 00:00:00', 'hib_druim_ligen'),
(NULL, 'housing', 3, 0, 0, 0, 0, 0, '2000-01-01 00:00:00', 'hib_housing'),
(NULL, 'entrance', 3, 202, 555552, 526123, 3008, 83, '2000-01-01 00:00:00', 'hib_housing_entrance'),
(NULL, 'guild', 3, 202, 555552, 526123, 3008, 83, '2000-01-01 00:00:00', 'hib_housing_guild'),
(NULL, 'hearth', 3, 202, 555552, 526123, 3008, 83, '2000-01-01 00:00:00', 'hib_housing_hearth'),
(NULL, 'Necht', 3, 181, 428182, 320796, 3411, 3104, '2000-01-01 00:00:00', 'hib_necht'),
(NULL, 'Oceanus', 3, 130, 271184, 539600, 8344, 645, '2000-01-01 00:00:00', 'hib_oceanus'),
('', 'Shannon Estuary', 3, 200, 309968, 645164, 4848, 1137, '2000-01-01 00:00:00', 'hib_shannon_estuary'),
(NULL, 'Shar Labyrinth', 3, 93, 24307, 27567, 17537, 4059, '2000-01-01 00:00:00', 'hib_shar_labyrinth'),
(NULL, 'Shrouded Isles', 3, 0, 0, 0, 0, 0, '2000-01-01 00:00:00', 'hib_shrouded_isles'),
('', 'Tir na Nog', 3, 201, 33415, 31336, 7999, 2048, '2000-01-01 00:00:00', 'hib_tir_na_nog'),
(NULL, 'Aegirhamn', 2, 151, 293910, 356255, 3488, 1199, '2000-01-01 00:00:00', 'mid_Aegirhamn'),
(NULL, 'City of Aegirhamn', 2, 151, 293910, 356255, 3488, 1199, '2000-01-01 00:00:00', 'mid_Aegirhamn_City'),
(NULL, 'Bjarken', 2, 151, 289954, 301796, 4160, 2660, '2000-01-01 00:00:00', 'mid_Bjarken'),
('', 'Gotar', 2, 100, 771152, 836380, 4624, 364, '2000-01-01 00:00:00', 'mid_gotar'),
(NULL, 'Hagall', 2, 151, 379380, 384696, 7752, 31, '2000-01-01 00:00:00', 'mid_Hagall'),
('', 'housing', 2, 0, 0, 0, 0, 0, '2000-01-01 00:00:00', 'mid_housing'),
('', 'entrance', 2, 102, 526303, 561704, 3640, 3114, '2000-01-01 00:00:00', 'mid_housing_entrance'),
('', 'guild', 2, 102, 526303, 561704, 3640, 3114, '2000-01-01 00:00:00', 'mid_housing_guild'),
('', 'hearth', 2, 102, 526303, 561704, 3640, 3114, '2000-01-01 00:00:00', 'mid_housing_hearth'),
('', 'personal', 2, 102, 526303, 561704, 3640, 3114, '2000-01-01 00:00:00', 'mid_housing_personal'),
('', 'Jordheim', 2, 101, 31986, 27564, 8800, 2048, '2000-01-01 00:00:00', 'mid_jordheim'),
(NULL, 'Knarr', 2, 151, 302623, 433312, 3204, 3065, '2000-01-01 00:00:00', 'mid_Knarr'),
(NULL, 'Kobold Undercity', 2, 243, 31320, 28930, 16398, 1741, '2000-01-01 00:00:00', 'mid_kobold_undercity'),
(NULL, 'Oceanus', 2, 30, 271184, 539600, 8344, 645, '2000-01-01 00:00:00', 'mid_oceanus'),
(NULL, 'Shrouded Isles', 2, 0, 0, 0, 0, 0, '2000-01-01 00:00:00', 'mid_shrouded_isles'),
('', 'Svasud Faste', 2, 100, 765694, 673509, 5736, 1115, '2000-01-01 00:00:00', 'mid_svasud_faste'),
('', 'Uppland', 2, 163, 651611, 315012, 9432, 1934, '2000-01-01 00:00:00', 'mid_uppland'),
('', 'Vindsaul Faste', 2, 100, 704829, 738364, 5704, 773, '2000-01-01 00:00:00', 'mid_vindsaul_faste'),
('DOL.GS.FrontierTeleporter', 'Agramon', 1, 163, 546877, 480723, 9272, 3471, '2000-01-01 00:00:00', 'nf_ag_alb'),
('DOL.GS.FrontierTeleporter', 'Agramon', 3, 163, 505864, 478304, 9135, 3948, '2000-01-01 00:00:00', 'nf_ag_hib'),
('DOL.GS.FrontierTeleporter', 'Agramon', 2, 163, 525422, 439601, 9253, 1662, '2000-01-01 00:00:00', 'nf_ag_mid'),
('DOL.GS.FrontierTeleporter', 'Albion Coast', 1, 163, 563401, 505021, 7879, 0, '2000-01-01 00:00:00', 'nf_alb'),
('DOL.GS.FrontierTeleporter', 'Hibernian Coast', 3, 163, 483487, 501098, 7879, 0, '2000-01-01 00:00:00', 'nf_hib'),
('DOL.GS.FrontierTeleporter', 'Midgard Coast', 2, 163, 537800, 417585, 7893, 0, '2000-01-01 00:00:00', 'nf_mid');
/*!40000 ALTER TABLE `teleport` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
DOL dint only gaved me the data to start my server,
it also gaved me 16 amazing years with nice peeps,
and now its on me to return the favor.
User avatar
PlanarChaosRvrtwo
Database Team
 
Posts: 517
Joined: Thu Jul 07, 2016 6:21 am
Top

Re: New Public DB upcoming

Postby HunabKu » Fri Jul 08, 2016 5:09 am

Hi PlanarChaosRvrtwo.
I try to make this help with "my" db.
So it would be better to merge your work in it.
As you want :D.
"C'est l'ignorance qui apporte le chaos, pas la connaissance."
Scarlett Johansson dans "Lucy" de Luc Besson
-------------------------------------------------------------------------------
"Ignorance brings chaos, not knowledge."
Scarlett Johansson on "Lucy" by Luc Besson
User avatar
HunabKu
Developer
 
Posts: 1905
Joined: Sat Jun 18, 2011 4:48 am
Top

Re: New Public DB upcoming

Postby PlanarChaosRvrtwo » Sat Jul 09, 2016 1:36 am

If you can show me what you working on and such i could help you
DOL dint only gaved me the data to start my server,
it also gaved me 16 amazing years with nice peeps,
and now its on me to return the favor.
User avatar
PlanarChaosRvrtwo
Database Team
 
Posts: 517
Joined: Thu Jul 07, 2016 6:21 am
Top

Re: New Public DB upcoming

Postby HunabKu » Sat Jul 09, 2016 8:27 am

Sure, i go to holidays, i contact you after.
"C'est l'ignorance qui apporte le chaos, pas la connaissance."
Scarlett Johansson dans "Lucy" de Luc Besson
-------------------------------------------------------------------------------
"Ignorance brings chaos, not knowledge."
Scarlett Johansson on "Lucy" by Luc Besson
User avatar
HunabKu
Developer
 
Posts: 1905
Joined: Sat Jun 18, 2011 4:48 am
Top

Re: New Public DB upcoming

Postby PlanarChaosRvrtwo » Mon Jul 18, 2016 3:36 pm

Here a small example for my work if you want see how exact i work

https://github.com/Furorteutonicus/Nalf ... %20(2).jpg
DOL dint only gaved me the data to start my server,
it also gaved me 16 amazing years with nice peeps,
and now its on me to return the favor.
User avatar
PlanarChaosRvrtwo
Database Team
 
Posts: 517
Joined: Thu Jul 07, 2016 6:21 am
Top

Re: New Public DB upcoming

Postby HunabKu » Tue Jul 19, 2016 10:31 am

Hey I'm back.
Please PlanarChaosRvrtwo, contact me by PM or eMail.
"C'est l'ignorance qui apporte le chaos, pas la connaissance."
Scarlett Johansson dans "Lucy" de Luc Besson
-------------------------------------------------------------------------------
"Ignorance brings chaos, not knowledge."
Scarlett Johansson on "Lucy" by Luc Besson
User avatar
HunabKu
Developer
 
Posts: 1905
Joined: Sat Jun 18, 2011 4:48 am
Top
Post a reply

Return to “%s” Database Releases

Who is online

Users browsing this forum: No registered users and 1 guest

Website by Etaew - © 2012 Dawn of Light - Powered by phpBB © 2011 phpBB Group

Artwork and screen shots Copyright © 2001-2004 Mythic Entertainment, Inc. All rights reserved. Used with permission of Mythic Entertainment. Mythic Entertainment, the Mythic Entertainment logo, "Dark Age of Camelot," "Shrouded Isles," "Foundations," "New Frontiers," "Trials of Atlantis," "Catacombs," "Darkness Rising," the Dark Age of Camelot and subsequent logos, and the stylized Celtic knot are trademarks of Mythic Entertainment, Inc.