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 12-09-2006, 07:37 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default OBJECT Table

Anyone know why a ground-spawn item I made will disappear from the OBJECT table and not respawn?

EDIT
The item spawns as planned, and I can pick it up - after that is when it poofs from the object table in the database.

Last edited by Angelox; 12-09-2006 at 03:41 PM..
Reply With Quote
  #2  
Old 12-09-2006, 10:13 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

NM this, I figured it out
Reply With Quote
  #3  
Old 12-09-2006, 05:52 PM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Cool, glad you brought this up. I found an arrow sticking out of the ground in a GoD zone, picked it up, and it was apparently gone for good. Is this true? How do you get it back? Please educate me.

TIA,
J
Reply With Quote
  #4  
Old 12-09-2006, 11:51 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by John Adams
Cool, glad you brought this up. I found an arrow sticking out of the ground in a GoD zone, picked it up, and it was apparently gone for good. Is this true? How do you get it back? Please educate me.

TIA,
J
I hear ya, it had me stumped for a while - and I couldn't find any thing on this anywhere.
But it's pretty simple - It's all in the GROUND_SPAWNS table! (thanks cbmoder, for the idea).
OBJECT must have some other use, that I don't understand yet.
Take a look at ground_spawns, and you'll see what I mean. What we need now, is a complete ACTORDEF listing (with descriptions) - I only found partial ones that describe other static items.
Reply With Quote
  #5  
Old 12-10-2006, 06:37 PM
bufferofnewbies
Hill Giant
 
Join Date: Dec 2005
Location: Lurking in KY
Posts: 239
Default

Hmm, so items capable of being picked up on a cursor can be implemented into the object table also? very interesting possibilities for single instance spawns. (ok, so it may only be useful for Easter Egg hunts...)

Not sure if the ground_spawn has a 'one-time' field (guess I should have looked before I posted), but this does offer a nice possibility for artifact level item and spell creations/ quests for those whom are first to find out about them.

Good show on finding out what the error was (I missed this post until now :( ), and thanks for giving me yet more to think about so that I never get done with what Im doing now. You're so evil like that... :p
Reply With Quote
  #6  
Old 12-11-2006, 07:07 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Quote:
but this does offer a nice possibility for artifact level item and spell creations/ quests for those whom are first to find out about them.
Everytime I read these forums, nearly every day, I get a new idea for what I'd like to do to customize my server... like this comment above. What I am also finding out is, I am far from the first person to think of anything really cool. hehe... but, the best of all things in one server - now there's a place to call "home".
Reply With Quote
  #7  
Old 12-11-2006, 09:17 PM
EliteSting
Sarnak
 
Join Date: May 2005
Posts: 58
Default

Check out Patience's Mall sometime , it's usually listed under the Jest server when it's up. He's building a mall of objects , really quite interesting , and very handy.
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:58 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