Adding Doors to a zone

[Randymarsh9]

Alright, I will try to find some doors. I just need them for a rogue quest I am going to make there. I like the invisible floors.

[Randymarsh9]

ok I don't get it though. How will I find a door when there are no doors listed in that file?

[trevius]

I haven't looked at the content of that file yet, so I don't know for sure if there aren't any door names in it. It could also be that there are still doors, but they may be named something else. Either way, it is an unfinished zone, so it is very possible that they just never added the doors into the file.

[Randymarsh9]

Ok, I never actually create something into a table using mysql, so what is the command to insert something into a table? I know its something like insert into table 'doors' (varname, value) where.... but then I'm not sure if I am correct after that.

[trevius]

For someone with no MySQL experience, you would probably find it MUCH easier to just use something like Navicat to manage your database. Using Navicat is almost as simple as editing a database (like Excel), and looks fairly similar once you open a table. It also makes it easier to see current examples so you know what you need to do to add new ones.

[Randymarsh9]

Yeah that's what I just ended up doing, and I have slight mysql experience; I just normally edit things instead of adding in new things. But besides that, I got a door in the zone in the right spot and it's working correctly! Now just one more to go and I'm done with that.

[nilbog]

Didn't want to start a new thread for basically the same question, so here goes! I can add and manipulate doors without much problem... except in hateplane.

My goal here is pretty simple, I need to cover up one of the doors/breezeways and I don't want to use a perl script mover to "move" people away :p

Hateplane has NO doors or objects in the respective tables.

After looking through s3dspy, i see tons of things in there, but I'm unsure of how or what to name them because I have no reference to anything currently there.

Most of them are named strangely..but I do see parts to the beds, and parts to the barrels. My question is this. If i wanted to add one of the objects, how do I know the exact name for the 'name' field in doors table.

I show things like these in my hateplane_obj.s3d:
bedleg1.bmp
bedleg1.mdf
bedleg1.sps

Is it as simple as BEDLEG1 ?