Some New zone Access

[alfa]

I have update names and safe loc of some zones:
Drayek's Chamber, Maiden's Gulch, The Trembling Lagoon, The Bastion Of Flames, The Sanctum Of Fear, Maj Dul Residence 1 room model 1, MajDul Residence 2 rooms model 1, Unrest

Code: Select all

insert  into zones values 
(193, 'permafrost_epic01_icebound', 'permafrost_epic01_icebound', 'Drayek\'s Chamber', '1.02', '59.81', '-406.31', '-1e+006'), 
(173, 'lavastorm_epic02_gulch', 'lavastorm_epic02_gulch', 'Maiden\'s Gulch', '-193.04', '-0.92', '-344.69', '-1e+006'), 
(122, 'feerrott_epic01_temple', 'feerrott_epic01_temple', 'The Trembling Lagoon', '-904.3', '-9.78', '302.64', '-1e+006'), 
(247, 'solusekseye_epic02_bastion', 'solusekseye_epic02_bastion', 'The Bastion Of Flames', '-147.93', '-414.98', '-290.9', '-1e+006'), 
(29, 'cazicthule_epic01_sanctum', 'cazicthule_epic01_sanctum', 'The Sanctum Of Fear', '-1.02', '-10', '-178.26', '-1e+006'), 
(47, 'exp01_cty_majdul_1r01', 'exp01_cty_majdul_1r01', 'MajDul Residence 1 Room', '8.46', '0.04', '0.52', '-1e+006'), 
(49, 'exp01_cty_majdul_2r01', 'exp01_cty_majdul_2r01', 'MajDul Residence 2 Room', '-7.98', '-0.05', '-0.49', '-1e+006'), 
(94, 'exp03_dun_estate_of_unrest', 'exp03_dun_estate_of_unrest', 'Unrest', '7.91', '0.3', '-88.33', '-1e+006');

[LethalEncounter]

awesome, I'll push it out to everyone.

[razmalone]

Sweet that rocks.

[alfa]

Direct Link to Zone.sql
I have update safe loc / name of other zones (ex:now you can zone to Clockwork, Crypt of T'Haven,...)
All boat are accessible and named, same for house zone
Note for Dev: For Now zone files
exp01_rgn_pillars_of_flame_epic02_discipline
exp03_dun_mistmoore_catacombs_epic01_freethinker
crash the server at load

[alfa]

Humm add some new update like

Code: Select all

(44, 'everfrost_frostfell', 'everfrost_frostfell', 'Frostfell Wonderland Village', '-540', '-11', '-338', '-1e+006');

and add NEW zone (already in client 4427L but not listed in DB )
The Shard of Fear (preview of RoK style ^^)

Code: Select all

(259, 'shard_of_fear', 'shard_of_fear', 'The Shard of Fear', '-4.66', '11.56', '479.91', '-1e+006');

Add to zone sql file in preview post

[Tiberius]

How do I add this? do I go into PHPadmin, open the zones table and import the .sql file?

[alfa]

How do I add this? do I go into PHPadmin, open the zones table and import the .sql file?

The most easy is:
Go to phpMyAdmin, delete your zone table and apply the zone.sql I linked in previous post. The file content all update I have made atm

[Riven]

For me, the best freeware tool is SQLyog. Try it here

[Tiberius]

Thanks, got them in there now.

[LethalEncounter]

If your world is set to automatically update your db (by default it is), it will download the updates automatically when I implement changes. So therefore, no manual update is required for the vast majority of users.