Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2006, 10:15 PM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default PoK Gunthak Portal

If you're tired of seeing that Translocator that sends you to Gunthak, try this out. This should put the Gunthak portal stone on it's platform near where it should be in PoK evil side. As usual, mind the 'doorid' value when inserting or replacing records, and make a backup of your 'doors' table first.

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 
(137, 'PoKnowledge', 'POKGTHPORT500', -760, 1230, -159.248, 0, 58, 0, 0, 0, 0, 0, 0, 0, 'gunthak', -1030, 1780, 60, 0, 0, 0, 100),
(136, 'PoKnowledge', 'POKGTHPORT501', -760, 1230, -159.248, 0, 58, 0, 0, 0, 0, 0, 0, 0, 'NONE', 0, 0, 0, 0, 0, 0, 100);
I was able to get just the head stone (POKGTHPORT500) to appear before, but it looked silly sitting in the grass all by itself. I decided to use the EQModelViewer and see what was in the .WLD files - and accidentally stumbled upon the platform, too (POKGTHPORT501). I was so happy, I almost pee'd. And here it is, 3am. Time for sleep.

I fear I will dream of zoning in and out of Gunthak and PoK tonight... 1000 times.

Enjoy!
Reply With Quote
  #2  
Old 12-14-2006, 01:43 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

This is really good John Adams, Thank you! - And I'll be damned if I missed this post, else it would have been in the ax_peq database a long time ago.
I'm about to start on the LoY zones again, and add more detail, such as quests, merchant-detail, faction, etc. And started by trying to figure out the PoK stone problem. You already had it for me a long time ago!
I take you applied this to the ax_peq db? if so , which version?

If ever you or anyone else sees fixes like this, post them , but PM me the link so you make sure I see it too. I think i hit the Eqemu forums so much, that I actually "freak it out" to where it thinks I already read some posts (once in a while).
Reply With Quote
  #3  
Old 12-14-2006, 01:47 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Aye, I placed this portal in PEQ, Cavedude, and ax_peq, but it has been quite a while ago... I cannot remember what ax_peq, honestly... but it works ok. Placement was a bitch, because the whole heading thing is a mystery to me. We don't seem to have true 360 degrees, but 255 degrees in some cases.

I had to set a heading at around 450 degrees for the PoK facades (which I haven't had time to post yet) for Bazaar and Guild Lobby. Coming soon (unless someone else has them already).
Reply With Quote
  #4  
Old 12-14-2006, 02:02 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

It was probably ax_peq since you mentioned the translocator , which was my doings. Cavedudes DB is under the ax_peq hood anyways.
I was just wondering if some PoK work I did recently would get in the way, but I already tested and it works fine.
It will be included with the next version.
Reply With Quote
  #5  
Old 12-15-2006, 07:40 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Awesome. Anything at all I can do to help. I've been around long enough, time to start earning my keep.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:59 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3