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

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #31  
Old 12-18-2003, 09:55 PM
nadineemu's Avatar
nadineemu
Sarnak
 
Join Date: Apr 2003
Location: UK
Posts: 61
Default Super Job

This database is well cool, my heartiest congrats!! though my complaints

The sleeper is missing :( he was there on my other dbs, and i know i can manually spawn him, but getting him right is hard. plus i notice is shows all the traps/command triggers as NPC's not sure if this is supposed to happen or not.

for instance, in the sleepers tomb, in the room where the Keyrafrm spawns, there are the 4 dragon ancients, a couple of other mobs, which i not seen before, and then another npc called 'areadead'

persumably this is the trigger to make Keyrafrm spawn, so i thought i would try killing this trigger lol, nothing happened /sigh


Only other complaint is that all the respawn counters are 0, so something repops as soon as it is killed. mind you i suppose no one will ever fight over camps lol, u could just camp a single mob and have done! lol

Anyway, and excellent database, look forward to seeing it improve.
__________________
me version 1.2
~ No place like home Server Controller~
Reply With Quote
  #32  
Old 12-19-2003, 04:48 AM
cybermax
Sarnak
 
Join Date: Oct 2002
Posts: 90
Default

Hmm.. any quick way to change the "instaspawn" mobs? As it is now, they all insta spawn upon death, and none of them xept the bazaar npcs have any faction message from killing them.

Since there is no faction, there is no aggro, but i still would like the mobs not to instaspawn tho..
Reply With Quote
  #33  
Old 12-19-2003, 07:57 AM
wraithmajere
Fire Beetle
 
Join Date: Mar 2002
Posts: 24
Default - Updates -

Project Moved To The Wy World Db Team, Next Official Release Should Fix / Solve These Issues With The Insta Spawn. As Far As Faction And Such, Its In The Works -)

- All I Can Say Atm, But Stay Tuned -) The Fixes Are Coming Neo!

- There Is No Spoon.
__________________
-=KHaoSZ=-
God-Like Holy-BattleZerker

Chaotic Knights Of Valor [MYWoRLD] Server
Reply With Quote
  #34  
Old 12-19-2003, 08:04 AM
Guest
 
Posts: n/a
Default Re: - Updates -

Quote:
Originally Posted by wraithmajere
Project Moved To The Wy World Db Team, Next Official Release Should Fix / Solve These Issues With The Insta Spawn. As Far As Faction And Such, Its In The Works -)

- All I Can Say Atm, But Stay Tuned -) The Fixes Are Coming Neo!

- There Is No Spoon.
Does this team have a web site ? I never heard of it.
just curious how you guys discuss and build your DB.
Reply With Quote
  #35  
Old 12-19-2003, 08:11 AM
rockocool
Sarnak
 
Join Date: Mar 2003
Location: california
Posts: 63
Default

The instant respawn issue sounds so easy to me, say your db name is eq. and you want all npcs to spawn with a timer of 500. now go to mysql, do a

update eq.spawn2 set respawntime=500 where respawntime=0;

Unless you want to set different respawn time for different NPC, then it will take quite a bit of work.

For faction, you cant do a one query for all. You have to set the column faction right in table npc_type. That involves quite some work to set every npc to the right faction. You can do it relatively easy by run a set of queries for each NPC type (classified by race and texture) that have a faction ID, then you are done. Let's say, for example, the bear in everforst has a npc_faction_id of 3965, and you know bear's race is 43, and texture for polar bear is 2. Then you could do a

update eq.npc_type set npc_faction_id=3965 where race=43 and texture=2;

then woola, all polar bears have their faction now (unless in the database the texture was set wrong, for example, the current db the polar bear in everforst has texture of 0 instead of the correct number 2, and helmtexture of 0 instead of 2).

Another way to do this by feel is use their name, that's even more staightforward. for example, do this:

update eq.npc_type set npc_faction_id=3965 where name LIKE 'a_polar_bear%';


Quote:
Originally Posted by cybermax
Hmm.. any quick way to change the "instaspawn" mobs? As it is now, they all insta spawn upon death, and none of them xept the bazaar npcs have any faction message from killing them.

Since there is no faction, there is no aggro, but i still would like the mobs not to instaspawn tho..
Reply With Quote
  #36  
Old 12-19-2003, 08:44 AM
wraithmajere
Fire Beetle
 
Join Date: Mar 2002
Posts: 24
Default TCS MW Database - Project

Quote From TcsMyWorld:


"The Team for the MW DB is always looking for people to help complete/correct our DB.
There is usually always someone in the irc channel (irc.eqemulator.net channel- #npcmovDB), where we meet and decide who will work on which parts of the DB.
Anyone wanting to help, just stop by and ask what you can do, I'm sure we can find something"
_________________
TCSMYWORLD - Project Coord. , MWnpcmovDB
"We're making EqEmu MOVE, One Zone at a Time"
http://mwnpcmovdb.kicks-ass.net/

-- This Is The TCS MW Database
__________________
-=KHaoSZ=-
God-Like Holy-BattleZerker

Chaotic Knights Of Valor [MYWoRLD] Server
Reply With Quote
  #37  
Old 12-19-2003, 10:13 AM
rockocool
Sarnak
 
Join Date: Mar 2003
Location: california
Posts: 63
Default Re: TCS MW Database - Project

Have you guys merged with MW db team? that would be so cool! I would love to see a fully populated world with mobs moving!

Quote:
Originally Posted by wraithmajere
Quote From TcsMyWorld:


"The Team for the MW DB is always looking for people to help complete/correct our DB.
There is usually always someone in the irc channel (irc.eqemulator.net channel- #npcmovDB), where we meet and decide who will work on which parts of the DB.
Anyone wanting to help, just stop by and ask what you can do, I'm sure we can find something"
_________________
TCSMYWORLD - Project Coord. , MWnpcmovDB
"We're making EqEmu MOVE, One Zone at a Time"
http://mwnpcmovdb.kicks-ass.net/

-- This Is The TCS MW Database
Reply With Quote
  #38  
Old 12-19-2003, 03:23 PM
Synch
Sarnak
 
Join Date: Nov 2003
Posts: 33
Default

Will we still see the same rapid rate of release that we have thusly enjoyed with you, or will you move to a slower release rate?

I ask because I fiend for your new db releases. =)
Reply With Quote
  #39  
Old 12-19-2003, 04:07 PM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default Re: TCS MW Database - Project

Quote:
Originally Posted by rockocool
Have you guys merged with MW db team? that would be so cool! I would love to see a fully populated world with mobs moving!

Quote:
Originally Posted by wraithmajere
Quote From TcsMyWorld:


"The Team for the MW DB is always looking for people to help complete/correct our DB.
There is usually always someone in the irc channel (irc.eqemulator.net channel- #npcmovDB), where we meet and decide who will work on which parts of the DB.
Anyone wanting to help, just stop by and ask what you can do, I'm sure we can find something"
_________________
TCSMYWORLD - Project Coord. , MWnpcmovDB
"We're making EqEmu MOVE, One Zone at a Time"
http://mwnpcmovdb.kicks-ass.net/

-- This Is The TCS MW Database

Yes we are all working together now and hopefully will eventually release a fully functional, complete database under a single name.



ps. resistance is futile
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
Reply With Quote
  #40  
Old 12-19-2003, 04:22 PM
wraithmajere
Fire Beetle
 
Join Date: Mar 2002
Posts: 24
Default Thank You -)

Thank You All, For All The Support You've Given Me.

I, Like The Rest Of You, Had A Vision That One Day We Would Have A Fully Spawned DB, And That Vision Is Starting To Come True, It Takes Alot Of Work, But We Will Be Working As A Team Now On This. The Updates Won't Be As Rapid, But I Can Asure You, The Database Will Work Alot Better, And Be More Complete. We Will Be Able To Add More Content This Way, But It Will Take Tons Of Testing Etc, So Will Be A Little Slower On Updates, But At Least When A New Version IS Released, You Will/Should Be Able To Notice The Difference, And Know That We're Using The Latest Tested Source, And DB Tables, And Newest Items Etc.

-Wraith Majere
__________________
-=KHaoSZ=-
God-Like Holy-BattleZerker

Chaotic Knights Of Valor [MYWoRLD] Server
Reply With Quote
  #41  
Old 12-19-2003, 04:35 PM
DataMan4971
Sarnak
 
Join Date: Dec 2003
Location: Seattle
Posts: 46
Default

Why Are You Writing Like This??

I.E. Capital on Every Word. just wondering
Reply With Quote
  #42  
Old 12-19-2003, 04:43 PM
wraithmajere
Fire Beetle
 
Join Date: Mar 2002
Posts: 24
Default Bad Habits Die Slowly

lol sorry -) don't shoot!

Just a habbit I guess. Will Try To Break The Habbit... doh did it again.

/shrug
__________________
-=KHaoSZ=-
God-Like Holy-BattleZerker

Chaotic Knights Of Valor [MYWoRLD] Server
Reply With Quote
  #43  
Old 12-19-2003, 06:10 PM
Synch
Sarnak
 
Join Date: Nov 2003
Posts: 33
Default

Perhaps public betas of the db would be a good idea? More eyes looking = more bugs found. This is a central tenant of open source software development.

The release early/release often strategy helps maintain interest in your project (not that you have a particular problem in this area) and helps the userbase feel as though progress is being made.

Just relaying some observations from my own experience. =)
Reply With Quote
  #44  
Old 12-19-2003, 06:39 PM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default

There will still be regular releases hehe.. we do however have a short process of internal testing/tweaking/optimizing before there will be a release.

The best way to help is just download the latest publicly availble version, source it in and give feedback.
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
Reply With Quote
  #45  
Old 12-19-2003, 07:41 PM
jardar
Fire Beetle
 
Join Date: Mar 2003
Posts: 8
Default

anyway you can fix can v for shamans? does nothing when you click the hot key for it. also noticed when i was bot and zoning to cy, it zoned me into corair's reefs instead haha. also if there anything i can do to help with the spawns, i have three level 65 toons on eqlive and have access to vex thal. one pop flag away from having elemental access.
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 06:18 AM.


 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3