Myra spawn db

[cybermax]

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]

Good solution

[AK1122]

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

[Scorpious2k]

Originally Posted by AK1122

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

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]

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

# 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]

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]

Originally Posted by Scorpious2k

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.

[rockocool]

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]

Is this included in the updated myraDB or not yet?

Originally Posted by Scorpious2k

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

# 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]

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

[Myra]

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]

Originally Posted by rockocool

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

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]

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]

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

The last one didnt do this using cybermax' method though

[AK1122]

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

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