Angelox
09-25-2008, 09:53 AM
Here's some stuff I found and have running in my tutorialB;
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(8, 'tutorialb', 'OBJ_TREEA', -13, -132, 50, 252, 58, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 25, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(9, 'tutorialb', 'OBJ_TREEC', 2, -213.1, 25, 98.4, 58, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 75, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(10, 'tutorialb', 'OBJ_TREEC', -56.4, -80.7, 30, 161.2, 55, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 85, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(11, 'tutorialb', 'OBJ_CAVE_ENTRY_DARK', 147.1, -97.4, 30, 128.2, 56, 0, 0, 0, 0, 0, 0, 0, 'tutorialb', 0, 0, 0, 0, 0, 0, 60, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(14, 'tutorialb', 'OBJ_FORTDOORB', -246, -1679.3, -102, 129, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 105, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(15, 'tutorialb', 'OBJ_FORTDOORA', -264.5, -1679.1, -102, 129, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 105, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(29, 'tutorialb', 'OBJ_JAILDOORB', 107.5, -672.7, 26.5, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 1, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(30, 'tutorialb', 'OBJ_JAILDOORB', 143, -735.5, 26.5, 128, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(31, 'tutorialb', 'OBJ_JAILDOORB', 235.6, -773, 26.5, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(32, 'tutorialb', 'OBJ_JAILDOORB', 235.4, -544.5, 26.5, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(33, 'tutorialb', 'OBJ_JAILDOORB', 175.1, -531.5, 26.5, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(34, 'tutorialb', 'OBJ_JAILDOORB', 284, -639, 26, 128, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(35, 'tutorialb', 'OBJ_JAILDOORB', 411.2, -350.5, 6, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(36, 'tutorialb', 'OBJ_JAILDOORB', 478, -423, 6, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(37, 'tutorialb', 'OBJ_JAILDOORB', 478, -264, 6, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(38, 'tutorialb', 'OBJ_JAILDOORB', 653, -448.3, -6.5, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(39, 'tutorialb', 'OBJ_JAILDOORB', 662.3, -238, -6.5, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(40, 'tutorialb', 'OBJ_JAILDOORB', 736.3, -238, -6.5, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(41, 'tutorialb', 'OBJ_JAILDOORB', 726.6, -448, -6.5, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(42, 'tutorialb', 'OBJ_JAILDOORB', 801, -387, -6.5, 0, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(43, 'tutorialb', 'OBJ_SPIKES', -257, -130, 10, -280, 56, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, -100, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(44, 'tutorialb', 'OBJ_SPIKES', -257, -96, 8, -280, 56, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 1, -100, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(45, 'tutorialb', 'OBJ_TABLE_MARKET_A', -96.5, -238.9, 8.5, 250, 56, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(46, 'tutorialb', 'OBJ_WEAPON_SPEAR_A', -99.1, -93.3, 17, 68.4, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
This will 'pretty up' your tutorialb-
two items you may not want to insert are the new-type ovens and the cave. If you do, you have to add a 'tutorialb_assets.txt' to your eqclient.
It's just a text file and points the emu to the doors;
Should contain these entries;
Tradeskill_objects.eqg
caveswitches.eqg
You also should delete your current tutorialb doors (a lot of them don't even work because they belong to another version of tutorialb)
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(8, 'tutorialb', 'OBJ_TREEA', -13, -132, 50, 252, 58, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 25, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(9, 'tutorialb', 'OBJ_TREEC', 2, -213.1, 25, 98.4, 58, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 75, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(10, 'tutorialb', 'OBJ_TREEC', -56.4, -80.7, 30, 161.2, 55, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 85, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(11, 'tutorialb', 'OBJ_CAVE_ENTRY_DARK', 147.1, -97.4, 30, 128.2, 56, 0, 0, 0, 0, 0, 0, 0, 'tutorialb', 0, 0, 0, 0, 0, 0, 60, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(14, 'tutorialb', 'OBJ_FORTDOORB', -246, -1679.3, -102, 129, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 105, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(15, 'tutorialb', 'OBJ_FORTDOORA', -264.5, -1679.1, -102, 129, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 105, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(29, 'tutorialb', 'OBJ_JAILDOORB', 107.5, -672.7, 26.5, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 1, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(30, 'tutorialb', 'OBJ_JAILDOORB', 143, -735.5, 26.5, 128, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(31, 'tutorialb', 'OBJ_JAILDOORB', 235.6, -773, 26.5, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(32, 'tutorialb', 'OBJ_JAILDOORB', 235.4, -544.5, 26.5, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(33, 'tutorialb', 'OBJ_JAILDOORB', 175.1, -531.5, 26.5, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(34, 'tutorialb', 'OBJ_JAILDOORB', 284, -639, 26, 128, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(35, 'tutorialb', 'OBJ_JAILDOORB', 411.2, -350.5, 6, 0, 0, 0, 0, 86012, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(36, 'tutorialb', 'OBJ_JAILDOORB', 478, -423, 6, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(37, 'tutorialb', 'OBJ_JAILDOORB', 478, -264, 6, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(38, 'tutorialb', 'OBJ_JAILDOORB', 653, -448.3, -6.5, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(39, 'tutorialb', 'OBJ_JAILDOORB', 662.3, -238, -6.5, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(40, 'tutorialb', 'OBJ_JAILDOORB', 736.3, -238, -6.5, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(41, 'tutorialb', 'OBJ_JAILDOORB', 726.6, -448, -6.5, 128, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(42, 'tutorialb', 'OBJ_JAILDOORB', 801, -387, -6.5, 0, 0, 0, 0, 52303, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(43, 'tutorialb', 'OBJ_SPIKES', -257, -130, 10, -280, 56, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, -100, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(44, 'tutorialb', 'OBJ_SPIKES', -257, -96, 8, -280, 56, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 1, -100, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(45, 'tutorialb', 'OBJ_TABLE_MARKET_A', -96.5, -238.9, 8.5, 250, 56, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
INSERT INTO doors
(`doorid`, `zone`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`)
VALUES
(46, 'tutorialb', 'OBJ_WEAPON_SPEAR_A', -99.1, -93.3, 17, 68.4, 0, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100, 0);
This will 'pretty up' your tutorialb-
two items you may not want to insert are the new-type ovens and the cave. If you do, you have to add a 'tutorialb_assets.txt' to your eqclient.
It's just a text file and points the emu to the doors;
Should contain these entries;
Tradeskill_objects.eqg
caveswitches.eqg
You also should delete your current tutorialb doors (a lot of them don't even work because they belong to another version of tutorialb)