MW_057DR2_alpha_1 RELEASED!! - Page 2

tcsmyworld · #16 05-18-2004, 04:26 AM

Our Releases generally are complete DB's with ALL fixes/updates added.
Should only need to source the sql from the D/L and, if there are any updates after release, the update sql/s that are listed with the release.
No other sql's needed.

rizzen04 · #17 05-18-2004, 04:29 AM

Ok, so just for clarification the dumps that edgar is doing has nothing to do with your db and shouldnt be sourced in? I am good with code however database stuff is rather new to me and am trying to get the hang of it without screwing things up.

Thanks for this release(even though I havent used it yet) and your previous releases + everyone that has contributed it makes for an awesome eqemu experiance.

astrokitten · #18 05-18-2004, 11:55 AM

Thanks for clueing me in that its not possible to do with this db. Least now I won't be ripping my hair out trying to figure out how to do it :lol:

cabtiz · #19 05-21-2004, 04:38 AM

I am slowly but surely taking all the quests that were in the old Perl_quests.zip and renaming them to the spawnid's used in this DB. I have a couple of zones done. Some zones of course there is I can't match any NPC names obviously zones no one has submitted yet like there are no npc's that spawn in airplane in this DB so i am skipping that zone since i don't know what the ID's will be.

Right now i have the West Freeport done and the akanon almost finished. Of course within these zones there are several NPC's missing that I have the quests for.

Was pretty much just doing it for myself. but once i get a little furthur along i'll prolly throw them up on some webspace as i get zones done if people are interested enough in them.

cabtiz · #20 05-21-2004, 06:32 AM

I think you have 2 maybe 3 zones mixed up as far as spawns in the DB.

erudsxing
erudnint
erudnext

erudnint is the palace you have no spawns for that zone so that may be correct

erudnext is erudin itself but it seems to contain the spawns for erudsxing

erudsxing seems to have the spawns for erudnext, when i zone to erudin there are no spawns.. one time i zoned in and got put in the "box" and all the NPC's were stacked on top of each other in the box.

when i zone into erudsxing which is also known as willowwisp island i can see all the npc's far off in the distance up in the air over the water.

I started looking on allakhazams and sure enough the spawns you have in erudsxing belong in erudnext and vice versa not sure if you have any of the palace spawns thrown in there yet..

Only figured it out cause i was redoing the quests in erudnext but the spawnid's for what zone they were in kept coming up in erudsxing.

Not sure what the easiest way is to fix the database itself is, but i am going to verify the zones the NPC's are supposed to be in that i have quests for and leave them in that zones quest folder.

tcsmyworld · #21 05-21-2004, 05:30 PM

We are aware of the problem with Erudin, it was a problem with the conversion tool, should be fixed in next release.

rizzen04 · #22 05-22-2004, 01:33 AM

is the problem that guildmasters arent training a db issue or server code issue?

cabtiz · #23 05-22-2004, 03:36 AM

Looking at the NPC tables if i had to guess it looks like the class column is set to 0 for the guildmasters. I am pretty sure each class of guildmaster has a unique class number to tells the client its a trainer.

I'm going to experiment with that sometime today

Jezebell · #24 05-22-2004, 04:08 AM

GM Trainers are working as of the 5/20/04 CVS.

rizzen04 · #25 05-22-2004, 04:14 AM

Quote:

GM Trainers are working as of the 5/20/04 CVS.

does anything have to be sourced into the database? I am running the 5/20/04 code but didnt see any sql updates. So the trainers were server code related in this instance?

Jezebell · #26 05-22-2004, 04:16 AM

it appears so, i didn't change anything in my database regarding them and they are working fine now.

rizzen04 · #27 05-22-2004, 04:23 AM

Cool, thanks much

rizzen04 · #28 05-22-2004, 09:02 AM

After doing some testing from what I can see it has to be the database, I am running 5-20-04 and when I use my older database the trainers work fine, when I turn the new database back on(which I have made 3 seperate ones to make sure I didnt mess up) the trainers dont work. I switch back to my old one and they work again. Any thoughts?

Also, when switching to the new database did you just drop your old one(create a new one) or just source the MW57DR2 over your old database?

Jezebell · #29 05-22-2004, 09:10 AM

Actually I am using the old database. mw055alpha1 and alpha2. But it is custom, all the NPC's are custom.

govtcheeze · #30 05-22-2004, 11:30 AM

Quote:

did you just drop your old one(create a new one) or just source the MW57DR2 over your old database

You need to create a new one. You can then copy over your player's data and it will work as intended. Sourcing any DB over another will cause problems and is a Very Bad Thing <tm>.