EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   Re-Invention Of The Wheel (12-21-03) Fully Spawned DB *NEW* (https://www.eqemulator.org/forums/showthread.php?t=10820)

nadineemu 12-18-2003 09:55 PM

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.

cybermax 12-19-2003 04:48 AM

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..

wraithmajere 12-19-2003 07:57 AM

- 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.

12-19-2003 08:04 AM

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.

rockocool 12-19-2003 08:11 AM

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..


wraithmajere 12-19-2003 08:44 AM

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

rockocool 12-19-2003 10:13 AM

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


Synch 12-19-2003 03:23 PM

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. =)

Shawn319 12-19-2003 04:07 PM

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

wraithmajere 12-19-2003 04:22 PM

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

DataMan4971 12-19-2003 04:35 PM

Why Are You Writing Like This??

I.E. Capital on Every Word. :roll: just wondering

wraithmajere 12-19-2003 04:43 PM

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

Synch 12-19-2003 06:10 PM

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. =)

Shawn319 12-19-2003 06:39 PM

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.

jardar 12-19-2003 07:41 PM

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.


All times are GMT -4. The time now is 06:44 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.