New Emu, New DB?

Oldwulf · #1 04-19-2002, 05:30 PM

I'm assuming that since they changed some of the db format in the new Emu we will be needing all new databases. And since the test server appears to be running a fully spawned db I was hoping someone could be so kind as to post a populated db. I personally am not proficient at building spawns and the such and rely in the talent of true db builders. You guys have been great so far and I'm sure you will only be getting better.

Oldwulf

Lurker_005 · #2 04-19-2002, 05:37 PM

Not a major change, but regardless I think I'll release my Lurker0.3 DB in a bit....

Oldwulf · #3 04-19-2002, 05:43 PM

Yeah there are only a couple of hundred entries in DB9 where the column count didn't match the value count.

It's good to hear that your working on your latest db though. Can't wait to see it.

Oldwulf

Sauron · #4 04-19-2002, 06:30 PM

In the mean time if you download Ariak's DB and just source that in withough sourcing in the DB that comes with the emulator it does work. The world server loads fine and the Zone server states

Using database 'eq' at localhost
Loading items & NPCs...DB Query Error
Error #1054: Unknown column 'd_meele_texture1' in 'field list'
NPCs loaded - using old database format
done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...done.
Loading faction data...done
Connect to worldserver: 127.0.0.1:9000
Entering sleep mode

So if you source in an old database it appears that the emulator will use some form of backwards compatability. So until the DBs are updated for the table additions you can use the old ones without any problems other than 1 complaint by the zone server.

Shortlived · #5 04-19-2002, 06:48 PM

doesn't that basicly make your server a 3.0 server?

Lurker_005 · #6 04-19-2002, 06:57 PM

no, there were many changes not related to the npc_types table change.

ninja_looter · #7 04-21-2002, 09:02 AM

alot of the zones are broke now in 3.1.1, such as soldungb using D's and tried A's same brokeness.. Havent escalated to Lurk yet

Lurker_005 · #8 04-21-2002, 09:22 AM

My DB really isn't that different that Ariak's or Drawde's, I just add some more zones, and have tried to get rid of import errors ect. What are you refering to as broken? Stuck unmoving at safepoint? I am not sure if this is something new or not, the ones I have gotten stuckin I hadn't visited prior to 3.1

Ariak · #9 04-21-2002, 09:35 AM

My DB, 10.0, is compatible with 0.3.1.1

I am working on Skyshrine spawns now.. A lot's been done

Merkur · #10 04-21-2002, 10:05 AM

there are some changes in npc_types (and only in this table) in 3.1. The emu will accept old databases though but of course not forever (means in 3.2 or 3.3 it won't support 3.0 databases anymore). The new fields (5) are atm only used with the databaseupdate which we will be published soon.

Lurker_005 · #11 04-21-2002, 10:32 AM

Quote:

Originally Posted by Ariak

A lot's been done

*groan* more things to incorperate into mine

J/K keep up the good work!

Oldwulf · #12 04-21-2002, 04:06 PM

Ariak, is your DB10 released yet? Haven't seen any links for it and would love to take a look.

Oldwulf

Shawn319 · #13 04-21-2002, 04:09 PM

Doesn't look like it.

Oldwulf · #14 04-21-2002, 06:40 PM

that's what i thought. hope it is released soon.

Ariak · #15 04-21-2002, 11:29 PM

I had to delete a couple hundred spawns in Skyshrine due to a mysteriously well-hidden bugged-spawn.

I have 1/11 of the zone spawned now, yay..

I have added a bunch of items. I went and hand-checked EVERY item I added with Magelo and fixxed the icon. I will add EQ's Skyshrine. In 11.0, I will add EQ's Kael, and remove the temporary Kael I have now..

Stay Tuned!