EQEmulator Forums - Myra spawn db

Page 3 of 3

Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - Myra spawn db (https://www.eqemulator.org/forums/showthread.php?t=10756)

cybermax

12-14-2003 02:11 PM

Oki.. for now doing it in this order then :

source db.sql
source dumpeditems.sql
ALTER TABLE npc_types DROP lastname;
source myradb.sql
ALTER TABLE npc_types ADD lastname VARCHAR(32) AFTER name;

And that took care of that for now :)

Scorpious2k

12-14-2003 02:18 PM

Good solution :-)

AK1122

12-14-2003 04:03 PM

Scorp, Myra

I think you just need to source with older db.sql and run 052-update.sql

When u have a working db email it to me so i can reupdate host :D

Scorpious2k

12-15-2003 02:07 AM

Quote:

Originally Posted by AK1122

When u have a working db email it to me so i can reupdate host :D

She got it all done last night, but didn't get a chance to send it out. She's in school right now, but will be able to send it out when she gets home.

Scorpious2k

12-15-2003 02:10 AM

Here's a fix in the meantime for the merchant problem:

Code:

# shopkeeper, banker, beastlord gm, enchanter gm, magician gm 

update `npc_types` set class=41 where class=32;  

update `npc_types` set class=34 where class=31; 

update `npc_types` set class=33 where class=30; 

update `npc_types` set class=32 where class=29; 

# wizard gm, necro gm, shaman gm, rogue gm, bard gm 

update `npc_types` set class=31 where class=28; 

update `npc_types` set class=30 where class=27; 

update `npc_types` set class=29 where class=26; 

update `npc_types` set class=28 where class=25; 

update `npc_types` set class=27 where class=24; 

# monk gm, druid gm, shadowknight gm, ranger gm, paladin gm 

update `npc_types` set class=26 where class=23; 

update `npc_types` set class=25 where class=22; 

update `npc_types` set class=24 where class=21; 

update `npc_types` set class=23 where class=20; 

update `npc_types` set class=22 where class=19; 

# cleric gm, warrior gm & banker 

update `npc_types` set class=21 where class=18; 

update `npc_types` set class=20 where class=17; 

update `npc_types` set class=40 where class=16;

Bearik

12-15-2003 09:47 AM

Hats off to you Myra, this DB is A+

Testing it out on my server, so far no problems other than a crash in Tox. Sourcing it in is a bit messy but i'm sure we can get it a little smoother :)

And Scorp thanks for that fix.

Myra	12-15-2003 03:21 PM

Quote:

Originally Posted by Scorpious2k

Quote:

Originally Posted by AK1122

When u have a working db email it to me so i can reupdate host :D

She got it all done last night, but didn't get a chance to send it out. She's in school right now, but will be able to send it out when she gets home.

Sent. :wink:

rockocool

12-16-2003 05:40 PM

I just source this DB and use eqadmin to check which zones are poped, and it seems it's missing most of the planes, which are poped in telmet's DB. ;) So great job Myra, but if you could add in those missing zones from telmets, it would be a plus! :P

rockocool

12-16-2003 06:00 PM

Is this included in the updated myraDB or not yet?

Quote:

Originally Posted by Scorpious2k

Here's a fix in the meantime for the merchant problem:

Code:

# shopkeeper, banker, beastlord gm, enchanter gm, magician gm 

update `npc_types` set class=41 where class=32;  

update `npc_types` set class=34 where class=31; 

update `npc_types` set class=33 where class=30; 

update `npc_types` set class=32 where class=29; 

# wizard gm, necro gm, shaman gm, rogue gm, bard gm 

update `npc_types` set class=31 where class=28; 

update `npc_types` set class=30 where class=27; 

update `npc_types` set class=29 where class=26; 

update `npc_types` set class=28 where class=25; 

update `npc_types` set class=27 where class=24; 

# monk gm, druid gm, shadowknight gm, ranger gm, paladin gm 

update `npc_types` set class=26 where class=23; 

update `npc_types` set class=25 where class=22; 

update `npc_types` set class=24 where class=21; 

update `npc_types` set class=23 where class=20; 

update `npc_types` set class=22 where class=19; 

# cleric gm, warrior gm & banker 

update `npc_types` set class=21 where class=18; 

update `npc_types` set class=20 where class=17; 

update `npc_types` set class=40 where class=16;

Scorpious2k

12-16-2003 09:55 PM

The merchants are fixed in what she sent to AK1122, if he has the new version up for download.

Myra	12-17-2003 03:10 PM

All the bugs are worked out, and a host has been found.

http://www.bossmob.com/Myra/MyraDB.zip

Create the database, source the latest db.sql, items, then source my db. Thats it.

Myra	12-17-2003 03:35 PM

Quote:

Originally Posted by rockocool

I get of school next week, I have to have something to do. (I'm doing it next week for those who want me to spell it out for them.)

cbarnes

12-17-2003 05:22 PM

i must be doing something wrong

Ok I noticed that the file is the exact file (time, date, size) as the one that was posted earlier. I'm still getting the same errors (Error 1062: Duplicate.. etc)

Any ideas?

I believe I'm doing everything correct, its just erroring out on the Myradb.sql source part.

Thanks in advance

Bearik

12-17-2003 08:51 PM

I'm getting tons of errors, mostly duplicate blah blah.

The last one didnt do this using cybermax' method though

AK1122

12-17-2003 11:54 PM

Sorry am on work trip atm... had 2 hours notice before having to jet :S

am testing stuff, there are a FEW spawns that are messed up (im guessing that the spawns were messed in telmet's or drawdes)

As soon as im back (jan 2nd) gnna start the real testing on the DB.. till then, good work Myra :D

(please update ur first post with the URL thou, helps) :D

All times are GMT -4. The time now is 12:51 AM.

Page 3 of 3

Show 40 post(s) from this thread on one page