Quote:
|
Originally Posted by John Adams
Ok, here they are as promised. Sorry it took a month (been in hell lately...). These are not perfectly placed, so please feel free to move them around to your liking and post updates if you choose.
What you see here are inserts into the DOORS table for the 2 building faces for Guild Lobby and Bazaar. I stumbled upon them while wandering through 3DSpy, clicking on the poknowledge_obj3.eqg file, looking for these buggers... I knew they had to be in there somewhere. Welp, apparently they are, and they were called "facade.mod". Just by dumb luck, I used the door name "FACADE" and it worked. Yay.
Also in these inserts are the clickable doors to get OUT of guild lobby and guild hall, but I hadn't gotten to zone points back out of Bazaar yet (there's at least one that's sorta auto-zone, and I believe the other needs another door hung).
Notes:
* I did remove the primary keys, but did not do any adjusting to the doorid's per zone.
* I'm not sure of those doors I used in the guild lobby and hall are accurate gfx, so check that too.
* Be wary of the extra spaces this forum CODE command might put into the middle of these inserts... I wish I could host a SQL file, but I have nowhere to do that right now.
No further delay, here's your inserts. As usual, backup first, check your columns, and enjoy.
Code:
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) VALUES (138, 'PoKnowledge', 'FACADE', -370, 1400, -120, 64, 58, 0, 0, 0, 0, 0, 0, 0, 'guildlobby', 18, -46, 6, 0, 0, 0, 100);
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) VALUES (139, 'PoKnowledge', 'FACADE', 340, 1445, -120, 445, 58, 0, 0, 0, 0, 0, 0, 0, 'bazaar', -425, 0, -25, 0, 0, 0, 100);
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) VALUES (140, 'guildlobby', 'TRANS_ENTRY', -59, 19, 10, 135, 58, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 1380, -300, -121, 0, 0, 0, 100);
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) VALUES (141, 'guildlobby', 'GUILD_DOOR_', 624.45, 48.375, 4.95, 385, 58, 0, 0, 0, 0, 0, 0, 0, 'guildhall', 0, 0, 0, 0, 0, 0, 105);
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) VALUES (142, 'guildlobby', 'GUILD_DOOR_', 624.45, -48.375, 4.95, 385, 58, 0, 0, 0, 0, 0, 0, 0, 'guildhall', 0, 0, 0, 0, 0, 0, 105);
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) VALUES (143, 'guildhall', 'GUILD_DOOR', -162.25, -3.375, 7, 128, 58, 0, 0, 0, 0, 0, 0, 0, 'guildlobby', 0, 585, 0, 180, 0, 0, 100);
If you have trouble, post here and I'll see what I can do.
But if you didn't backup DOORS first, I don't know you. 
PS: For Angelox, this work was in Cavedude's raw database. I'm pretty sure it'll slide right in to PEQ and ax_peq. I think the Doors tables are all the same. |
I don't get it; these inserts have doorid, but no id? My table begins with id. If 138 - 143 is id then they are already taken. Probably something to do with the way you made the insert?
Also, if you need space or FTP for linking sqls . PM me, and I'll set you up here.
|