Doors schema changed 4.4 rel??

[Jrodo]

Hey gang, GREAT work on this software.

I do have a question and a suggestion. I tried to compile the new 4.4 release software to match the 4.4 binaries. These sources is not what built the supplied binaries. Also the re-compiled binaries won't work with current database schema. The doors.cpp requires the doors table to have extra dest_x,y,z,hdg fields added yet no database ( that I can find) has this installed?

Suggestion, please add the best available database ( meaning one that matches EQlive the most ) to the released server software package. or at least one that will play with the files. Also add the following files to the released src if possible (zlib.lib,Zlib.h, Zconf.h ) It will save a lot of headaches!

I am still tring to get a compiled version to actually play with an up-to-date database. No luck so far. 1 week and counting.....

Thanks for all your hard work!!!

[Trumpcard]

Theres a thread where Lurker released an updated doors sql file converted to the new format.

No, we won't release a database with the software, for possible legal reasons.

We just work on the server. What you do with it is up to you.

The zlib libraries are not a part of the eqemu project, they are third party, and should be kept that way. Theres no reason to bundle that in there, we might as well bundle the mysql includes and libs, the mysql server, etc. All of these things bring up legal questions.

[Lurker_005]

The VC++ *.dsp files were not in the 4.4 source release for some reason. I found that if you compiled eqemu before, it would remember where the old copy of these were. The result? it compiles the old code :( just copy the dsp fies to the propper directories in the 4.4 source tree and it works right.

[Jrodo]

OK the doors files will prolly correct the database version. Thanks! I will try it in a bit..

As far as the copying the *DSP to thier proper location, still won't work.. For example, the Doors.cpp is not in the old project and several other file changes are appearent. Either we all have to remake the whole project for it to compile correctly. or please someone post the complete projects (*,dsp and *.dsw for world and zone )for VC6. Unless I am totally loosing it, which is entirely possible.

Unfortunatly, I understand why you can't post a working database.... Can you at least post a current schema for the version required for the software to work and an empty DB.sql ( one that creates the required empty tables) so that we may source in our own data?

P.S. Not getting pushy, just curious.. you guys are doing a great job!

[Trumpcard]

I've been thinking about moving all the data out of the db.sql for awhile now and all the 'optional' data into another sql file.

I'll see about doing that for the next release. Their should be enough update sql's in the release directory to get the database to a decent state.

If you need the updated dsp, just pull it off cvs , it's up there.

[Jrodo]

Finally, I got the whole thing to compile and actually run

For some reason it seems unstable... the 44dr1 execs seemed to be more stable by far... for example the NPC are jumping around and everytime I zone I crash to login window.. getting a lot of the "unknown compression method" errors from the inflatepacket routine in world.

It did compile without errors! and I am testing it on my private lan. I have a 3 computer network. and both clients crash so the problem must be the host software.

But I am happy I finally got the project to compile and run! Thanks to all of you that helped.

[IAmariusaz]

That is caused by incorrect Z cordinates in the spawn table.

[IAsoulfood]

Lurker_005,
The doors jam bud.
Again http://my.core.com/~tgarland/doors.zip
This time there are two files inside the zip one is doors.sql and other is doors.csv. The reason is all POK portal/doors are working properly. It is the only thing I have verified. I spent a hell of a long time working on exact locations etc... Because portal/doors that zone somewhere CANNOT have a negative door_id they must be positive or they will not show up in the zone I correctly about 7 of those along with all the corresponding books in the zones your supposed to go to from the POK like Plane of Tranquility and the rest all work back and forth properly =)
Please update this in your doors.sql with the TOFS information as I do not have this info installed yet and it'd be cool to have it all together.
I'm to tired at this point to clean it up and make it a prettier package for ya bud. LMAO
Reply when you have it updated with a URL and I'll download then.

In case its missed in the following post:
http://forums.eqemu.net/viewtopic.php?t=8415

Thanks again,
Soulfood.


I have compiled the CVS every night for the last 2 weeks and have not had any problems related to crashing etc... but I have been using Lurker_005's doors while editing and correcting with him POK portals/doors to their destinations and back properly. once he adds in my doors.csv to his with TOFS then we'll really be rockin =)
I've zipped up my eqemu cvs binaries for testing by anyone that wishes. That zip of binaries is at:
http://my.core.com/~tgarland/cvs441.zip
I hope they help out.
IMPORTANT NOTE:
The doors.zip should not be downloaded from me unless it's Lurker_005 doing the download since he has other changes to go with this information =)
Thanks all
Soulfood
Keepin it real.