Posted: Sun Apr 27, 2008 4:34 am
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;Page 4 of 5
Posted: Fri Aug 22, 2008 3:50 pm
Code: Select all
'exp05_dun_veksar', 'exp05_dun_veksar', 'Veksar', '0', '0', '0', '-1e+006'
VEKSAR!
Also it seems as if Shard of Hate was never added to the database....
Posted: Fri Aug 22, 2008 4:02 pm
Nice. When you zone in, are you bobbing in water (0,0,0)? If so, I'm adding it now. 
Thanks!
Thanks!
Posted: Fri Aug 22, 2008 4:04 pm
Yes indeed, you are bobbing in water.
Posted: Fri Aug 22, 2008 4:17 pm
Going through the Zone list, I found 9 other zones missing. I am going to go through them right now for the safe coordinates.
Posted: Fri Aug 22, 2008 5:12 pm
Hmm veksar, I will have to check that out...ZexisStryfe wrote: New zone that is available starting with client 5016L:
VEKSAR!
Also it seems as if Shard of Hate was never added to the database....
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.
Posted: Fri Aug 22, 2008 5:23 pm
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.
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.
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'
Posted: Fri Aug 22, 2008 5:45 pm
Awesome. Added!
Posted: Fri Aug 22, 2008 6:33 pm
Added and tested. First 3 work, last the server couldn't find.
Posted: Fri Aug 22, 2008 7:00 pm
Which one, shard_of_hate? I got into that on my test server. I'll try it on my life one in a sec.
Posted: Fri Aug 22, 2008 8:10 pm
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.
Posted: Sat Aug 23, 2008 10:42 am
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'
Posted: Sat Aug 23, 2008 11:32 am
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.
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.
Posted: Sat Aug 23, 2008 11:34 am
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.JCL wrote: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'
Posted: Sat Aug 23, 2008 11:53 am
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.ZexisStryfe wrote:I had a problem with that when I downloaded the update with those zones in it.
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');