Update for Zones list

[alfa]

Here please post loc / files we need to update Zones table

Code: Select all

(280, 'exp04_dun_karnors_castle_epic01_pawbuster', 'exp04_dun_karnors_castle_epic01_pawbuster', 'The Execution Throne Room', '-12.86', '1.95', '29.54', '-1e+006'), 

[John Adams]

You want to come up with 'friendlier' zone names while we're at it? The one you just posted could be:

Code: Select all

(280, 'PawBuster', 'exp04_dun_karnors_castle_epic01_pawbuster', 'The Execution Throne Room', '-12.86', '1.95', '29.54', '-1e+006'),

...for example (I think that is the column that can be whatever we want it to be, for the /zone PawBuster command).

[alfa]

Code: Select all

(281, 'ProtectorRealm', 'exp04_dun_sebilis_epic01_crypt', 'The Protector's Realm', '-12,90', '-13,09', '344,01', '-1e+006'),

[ZexisStryfe]

Isn't 'exp04_dun_sebilis_epic01_crypt' the Crypt of Agony?

[alfa]

Isn't 'exp04_dun_sebilis_epic01_crypt' the Crypt of Agony?

Same file but simply multiple use

[John Adams]

Code: Select all

(281, 'ProtectorRealm', 'exp04_dun_sebilis_epic01_crypt', 'The Protector's Realm', '-12,90', '-13,09', '344,01', '-1e+006'),

Alfa, be careful where you put your apostrophes.
'The Protector's Realm' would break SQL insert. Might ESC it first: 'The Protector\'s Realm' or use different quotes on your inserts.

[alfa]

Code: Select all

(281, 'ProtectorRealm', 'exp04_dun_sebilis_epic01_crypt', 'The Protector's Realm', '-12,90', '-13,09', '344,01', '-1e+006'),

Alfa, be careful where you put your apostrophes.
'The Protector's Realm' would break SQL insert. Might ESC it first: 'The Protector\'s Realm' or use different quotes on your inserts.

Yup sorry I have not take attention (I use Navicat and it convert automaticly. I will dump data with MyAdmin for commit now. Thx for advise

[John Adams]

Aye, I use SQLYog and phpMyAdmin. They are both smarter than me.