Zone safe loc

[alfa]

Code: Select all

UPDATE zones SET name='soh', file='shard_of_hate', description='Shard of Hate', safe_x='222.45', safe_y='33.23', safe_z='-32.01', underworld='-1000000' WHERE id=268;

Replace City of Mist by Shard of Hate, because city of mist is a part of kunzar jungle, not a zone

[ZexisStryfe]

Code: Select all

'exp05_dun_veksar', 'exp05_dun_veksar', 'Veksar', '0', '0', '0', '-1e+006' 

New zone that is available starting with client 5016L:
VEKSAR!
Also it seems as if Shard of Hate was never added to the database....

[John Adams]

Nice. When you zone in, are you bobbing in water (0,0,0)? If so, I'm adding it now.
Thanks!

[ZexisStryfe]

Yes indeed, you are bobbing in water.

[ZexisStryfe]

Going through the Zone list, I found 9 other zones missing. I am going to go through them right now for the safe coordinates.

[JCL]

New zone that is available starting with client 5016L:
VEKSAR!
Also it seems as if Shard of Hate was never added to the database....

Hmm veksar, I will have to check that out...
And I also noticed with Shard of Hate, wondered why it wasn't added.
I used to be an end game raider, so it is nice to see some of these zones unpopulated, giving a chance to check out the designs.

[ZexisStryfe]

Alright John, got 8 new zones for you to add. These Zones are 100% correct in name and zone in loc. Feel free to test them out (I have been to most of these zones in the Live game). A few of them were once part of the database, but at some point they were lost.

Code: Select all

 'exp04_dun_charasis_north', 'exp04_dun_charasis_north', 'Charasis: Vault of Eternal Sleep', '0', '0', '23', '-1e+006'  
 
'exp04_dun_charasis_south', 'exp04_dun_charasis_south', 'Charasis: Maiden's Chamber', '0', '0', '-23', '-1e+006'  
 
'exp04_dun_chardok_epic01_throne', 'exp04_dun_chardok_epic01_throne', 'The Temple of Kor-Sha', '816', '-27', '206', '-1e+006'  
 
'exp04_dun_chardok_epic02_prison', 'exp04_dun_chardok_epic02_prison', 'The Court of Korucust', '-650', '-66', '204', '-1e+006'  
 
'exp04_dun_chelsith_epic01_behemoth', 'exp04_dun_chelsith_epic01_behemoth', 'The Chamber of Destiny', '192', '-10', '29', '-1e+006'  
 
'exp04_dun_sebilis_epic02_venril', 'exp04_dun_sebilis_epic02_venril', 'Venril Sathir's Lair', '0', '-10', '144', '-1e+006'  
 
'exp04_dun_veeshans_peak_epic01_trakanon', 'exp04_dun_veeshans_peak_epic01_trakanon', 'Veeshan's Peak: Trakanon's Lair', '0', '0', '0', '-1e+006'  
 
'shard_of_hate', 'shard_of_hate', 'The Shard of Hate', '45', '0.2', '290', '-1e+006'  

In addition to these zones, there is also 'exp04_dun_sebilis_quarters' although I cannot seem to find the safe locs in this zone. I think this zone might be another like Stormguard Hall- a zone file with nothing in it.

[John Adams]

Awesome. Added!

[JCL]

Added and tested. First 3 work, last the server couldn't find.

[John Adams]

Which one, shard_of_hate? I got into that on my test server. I'll try it on my life one in a sec.

[ZexisStryfe]

What Client are you running JCL? Shard of Hate was added on April 8th of this year as part of Update 44 so if you are running an older client, it won't be there.

[JCL]

No I am running 5016L. These ones do not work when I import and start up the server. When I get into the server they say the zones do not exit, but the others added do.

Code: Select all

'exp04_dun_chardok_epic02_prison', 'exp04_dun_chardok_epic02_prison', 'The Court of Korucust', '-650', '-66', '204', '-1e+006'  
  
'exp04_dun_chelsith_epic01_behemoth', 'exp04_dun_chelsith_epic01_behemoth', 'The Chamber of Destiny', '192', '-10', '29', '-1e+006'  
  
'exp04_dun_sebilis_epic02_venril', 'exp04_dun_sebilis_epic02_venril', 'Venril Sathir's Lair', '0', '-10', '144', '-1e+006'  
  
'exp04_dun_veeshans_peak_epic01_trakanon', 'exp04_dun_veeshans_peak_epic01_trakanon', 'Veeshan's Peak: Trakanon's Lair', '0', '0', '0', '-1e+006'  
  
'shard_of_hate', 'shard_of_hate', 'The Shard of Hate', '45', '0.2', '290', '-1e+006'  

[John Adams]

JCL, go to your clients "paks" folder and see that the files in the 'file' column are present. They may have a _SG.vpk or just a .vpk added to the end of the name.
If those are missing, your 5016L is not completely patched. Maybe extended data was not turned on? I think I d/l everything imaginable when I patch each time from SOE.

[ZexisStryfe]

No I am running 5016L. These ones do not work when I import and start up the server. When I get into the server they say the zones do not exit, but the others added do.

Code: Select all

'exp04_dun_chardok_epic02_prison', 'exp04_dun_chardok_epic02_prison', 'The Court of Korucust', '-650', '-66', '204', '-1e+006'  
  
'exp04_dun_chelsith_epic01_behemoth', 'exp04_dun_chelsith_epic01_behemoth', 'The Chamber of Destiny', '192', '-10', '29', '-1e+006'  
  
'exp04_dun_sebilis_epic02_venril', 'exp04_dun_sebilis_epic02_venril', 'Venril Sathir's Lair', '0', '-10', '144', '-1e+006'  
  
'exp04_dun_veeshans_peak_epic01_trakanon', 'exp04_dun_veeshans_peak_epic01_trakanon', 'Veeshan's Peak: Trakanon's Lair', '0', '0', '0', '-1e+006'  
  
'shard_of_hate', 'shard_of_hate', 'The Shard of Hate', '45', '0.2', '290', '-1e+006'  

Hmm I just tested them all and they do all work for me. Just a stupid question, but can you make sure that all the zones are updated in your database? I had a problem with that when I downloaded the update with those zones in it.

[John Adams]

I had a problem with that when I downloaded the update with those zones in it.

Hmm? What kind of problem? The update uses a "replace into", so if you had zones with the same IDs, it would have overwritten your entries - but otherwise, there should have been no errors.
Here is the query on the update server, if you want to run it manually to see what's going wrong.

Code: Select all

replace into `zones` (`id`, `name`, `file`, `description`, `safe_x`, `safe_y`, `safe_z`, `underworld`, `always_loaded`, `city_zone`) values
('293','runnyeye_advanced', 'runnyeye_advanced', 'The Gathering', '-93.4526', '-27.4416', '58.496', '-1e+006', '0', '0'),
('294','exp05_dun_veksar', 'exp05_dun_veksar', 'Veksar', '0', '0', '0', '-1e+006', '0', '0'),
('295','exp04_dun_charasis_north', 'exp04_dun_charasis_north', 'Charasis: Vault of Eternal Sleep', '0', '0', '23', '-1e+006', '0', '0'),
('296','exp04_dun_charasis_south', 'exp04_dun_charasis_south', 'Charasis: Maiden\'s Chamber', '0', '0', '-23', '-1e+006', '0', '0'),
('297','exp04_dun_chardok_epic01_throne', 'exp04_dun_chardok_epic01_throne', 'The Temple of Kor-Sha', '816', '-27', '206', '-1e+006', '0', '0'),
('298','exp04_dun_chardok_epic02_prison', 'exp04_dun_chardok_epic02_prison', 'The Court of Korucust', '-650', '-66', '204', '-1e+006', '0', '0'),
('299','exp04_dun_chelsith_epic01_behemoth', 'exp04_dun_chelsith_epic01_behemoth', 'The Chamber of Destiny', '192', '-10', '29', '-1e+006', '0', '0'),
('300','exp04_dun_sebilis_epic02_venril', 'exp04_dun_sebilis_epic02_venril', 'Venril Sathir\'s Lair', '0', '-10', '144', '-1e+006', '0', '0'),
('301','exp04_dun_veeshans_peak_epic01_trakanon', 'exp04_dun_veeshans_peak_epic01_trakanon', 'Veeshan\'s Peak: Trakanon\'s Lair', '0', '0', '0', '-1e+006', '0', '0'),
('302','shard_of_hate', 'shard_of_hate', 'The Shard of Hate', '45', '0.2', '290', '-1e+006', '0', '0');