EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Doors for Newer Zones (https://www.eqemulator.org/forums/showthread.php?t=25420)

trevius 06-08-2008 07:03 PM

Doors for Newer Zones
 
I am trying to add some doors to Dreadspire and I was wondering if anyone could tell me where to pull the door names from. I notice that PEQ has something like 700+ door names and I was wondering if those were attained from packet collecting, or if the door names could be found from the EQG files or something somehow.

I tried setting all of the ones currently in PEQ (from the list of doors in the wiki), but I was only able to find 3 or 4 that actually worked in Dreadspire and they all seemed like Global objects like the message board, a crate, and the PoK scroll. I am sure there are at least 3 or 4 doors that must be custom loaded to Dreadspire from somewhere. I just need to find their names so I can start adding them.

If anyone knows how to do this, I will gladly post the SQL needed to add them all into the zone for anyone else who wants to do so. I am pretty sure the doors I am looking for are a bookcase, a wall looking door and maybe 1 or 2 others. Most of them are for secret passageways and they aren't very secret without doors lol! I imagine once I have them, it might take a while for me to get them all in, but I will definitely share the database info once they are all complete.

I am guessing that the best person to answer this question is Cavedude. So, if you see this one, can you please let me know the answer? Or if anyone else knows where to pull these names from, it would be appreciated. Thanks!

For reference, I figured I would post links to the door related Wiki pages. So, anyone who finds this post in the future can easily get most of the door related information they might be looking for. Here are the links:

Door Table Schema wiki page:

http://www.eqemulator.net/wiki/wikka...uDBSchemadoors

Door List from PEQ wiki page:

http://www.eqemulator.net/wiki/wikka...=DoorsNameList

cavedude 06-08-2008 07:35 PM

Doors come from packet collects. Looking through my files, I don't have any logs for Dreadspire at all. Now the problem of course is we don't have a packet collector that works with Live that can export to a format that eqextractor can use (that's the tool used to extract door data) Worse yet, eqextractor wouldn't work with Live collects anyway, as it also would need to be updated :(

If anybody feels brave and wants to try to update both the packet collector and eqextractor (so that it can extract door/object/etc data AND export to EQBuilder) I would forever be in your debt, and would spend the summer collecting all of the newer zones. The big problem is going to be the spawn opcodes, as they are a royal pain to get.

trevius 06-09-2008 03:40 AM

Woot! I was sure that info had to be in the EQG files somewhere, so I kept trying to figure out how to find the names. Finally, I remembered trying out S3DSpy a while back and seeing object names in there. I installed it and sure enough, it lists all EQG files as well!

When you pull up the list, you can see all of the object names, because they all end in .mod. The naming convention has changed as well and actually seems much better than the old door and object naming system lol.

Here is a Link to GeorgeS emu page where you can find the S3DSpy app in the bottom section there.

http://66.159.225.58/eqemu/eq.html

And here is an example of the new format for doors and other objects. I didn't think it was going to work because the format is much different now. They now have OBJ in front of all object names and they also use underscores as well. Some of the new names are slightly longer than the old names, so the table might need to be adjusted to allow for longer names so it doesn't cut them off. Here is the list I made for Dreadspire:

OBJ_BDRM_LDOOR
OBJ_BDRM_RDOOR
OBJ_ARTIFACTS_DO
OBJ_BEAKER_A
OBJ_CAULDREN_A
OBJ_CENTER_PIECE
OBJ_DINE_LDOOR
OBJ_DINE_RDOOR
OBJ_DOORFACADE
OBJ_HIDDENDOOR
OBJ_LIBRARY_CASE
OBJ_LIBRY_HIDEDO
OBJ_LIBRY_LDOOR
OBJ_LIBRY_RDOOR
OBJ_LIBRY_SWITCH
OBJ_LIBRYSWTCHB
OBJ_MAINCASTLE_D
OBJ_MNGBOOKS
OBJ_RESEARCH_DOO
OBJ_RESEARCHDOOR
OBJ_SEEING_DOOR
OBJ_STAIRWELL_DO
OBJ_STUDY_BOOKSH
OBJ_STUDY_DOOR
OBJ_TORTURE_DOOR
OBJ_WHITEBLOCK

That worked perfectly.

If you have Navicat, you can copy the following and paste it into your table to view these doors. Just go to the loc near where the doors are:

Field Order:
ID DOORID ZONE NAME POS_Y POS_X POS_Z HEADING OPENTYPE GUILD LOCKPICK KEYITEM TRIGGERDOOR TRIGGERTYPE DOORISOPEN DOOR_PERAM DEST_ZONE DEST_X DEST_Y DEST_Z DEST_HEADING INVERT_STATE INCLINE SIZE BUFFER
Code:

13001        1        dreadspire        OBJ_BDRM_LDOOR        2450        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13002        2        dreadspire        OBJ_BDRM_RDOOR        2452        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13003        3        dreadspire        OBJ_ARTIFACTS_DO        2453        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13004        4        dreadspire        OBJ_BEAKER_A        2454        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13005        5        dreadspire        OBJ_CAULDREN_A        2455        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13006        6        dreadspire        OBJ_CENTER_PIECE        2456        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13007        7        dreadspire        OBJ_DINE_LDOOR        2457        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13008        8        dreadspire        OBJ_DINE_RDOOR        2458        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13009        9        dreadspire        OBJ_DOORFACADE        2459        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13010        10        dreadspire        OBJ_HIDDENDOOR        2460        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13011        11        dreadspire        OBJ_LIBRARY_CASE        2461        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13012        12        dreadspire        OBJ_LIBRY_HIDEDO        2462        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13013        13        dreadspire        OBJ_LIBRY_LDOOR        2463        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13014        14        dreadspire        OBJ_LIBRY_RDOOR        2464        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13015        15        dreadspire        OBJ_LIBRY_SWITCH        2465        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13016        16        dreadspire        OBJ_LIBRYSWTCHB        2466        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13017        17        dreadspire        OBJ_MAINCASTLE_D        2467        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13018        18        dreadspire        OBJ_MNGBOOKS        2468        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13019        19        dreadspire        OBJ_RESEARCH_DOO        2469        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13020        20        dreadspire        OBJ_RESEARCHDOOR        2470        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13021        21        dreadspire        OBJ_SEEING_DOOR        2471        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13022        22        dreadspire        OBJ_STAIRWELL_DO        2472        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13023        23        dreadspire        OBJ_STUDY_BOOKSH        2473        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13024        24        dreadspire        OBJ_STUDY_DOOR        2474        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13025        25        dreadspire        OBJ_TORTURE_DOOR        2475        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0
13026        26        dreadspire        OBJ_WHITEBLOCK        2476        0        100.1        0        55        0        0        0        0        0        0        -1        NONE        0        0        0        0        0        0        10        0

You can easily adjust the ID number if needed in case the newer versions of PEQ have higher than that. This will just show an example of the doors. I plan to get them all in the right place as far as where I imagine they should all be. Once I have that done, I will post the table lines for them so everyone can add them as well.

Angelox 06-09-2008 06:52 AM

Quote:

Originally Posted by trevius (Post 150342)
Some of the new names are slightly longer than the old names, so the table might need to be adjusted to allow for longer names so it doesn't cut them off. Here is the list I made for Dreadspire:

'name' in table 'doors' is VARCHAR(16) - if you increase the size, the bigger name will be accepted in the database, but EqEmu still will not read past this restriction, so the object with exceeding characters will not apply.

trevius 06-09-2008 08:09 AM

Looks like many of the doors for the later expansions (using dreadspire as an example) are more than 16 characters. This may also be the case for other objects as well. But, I am only focusing on doors at this point.

So, I changed my table design to use 32 max characters for the door name field. And, it still wasn't working, so I started looking at the source and saw that it was set to 16 in many places there as well.

Every case that I found 16 set for door names, I changed it. After the following changes, all doors were gone when I started the server, so it must have messed something up lol. Here are the changes I made.

All code changes are marked in red:

zone/doors.cpp:
Code:

Doors::Doors(const Door* door)
:    close_timer(5000)
{
        db_id = door->db_id;
        door_id = door->door_id;
        strncpy(zone_name,door->zone_name,16);
        strncpy(door_name,door->door_name,32);


Code:

        if (RunQuery(query, strlen(query), errbuf, &result)) {
                safe_delete_array(query);
                sint32 r;
                for(r = 0; (row = mysql_fetch_row(result)); r++) {
                        if(r >= iDoorCount) {
                                cerr << "Error, Door Count of " << iDoorCount << " exceeded." << endl;
                                break;
                        }
                        memset(&into[r], 0, sizeof(Door));
                        into[r].db_id = atoi(row[0]);
                        into[r].door_id = atoi(row[1]);
                        strncpy(into[r].zone_name,row[2],16);
                        strncpy(into[r].door_name,row[3],32);



zone/doors.h:

Code:

private:
int32        db_id;
sint8        door_id;
char        zone_name[16];
char        door_name[32];


zone/entity.cpp:

Code:

bool EntityList::MakeDoorSpawnPacket(EQApplicationPacket* app)
{
        int32 count = door_list.Count();
        if( !count || count>500)
                return false;
        int32 length = count * sizeof(Door_Struct);
        uchar* packet_buffer = new uchar[length];
        memset(packet_buffer, 0, length);
        uchar* ptr = packet_buffer;
        Doors *door;
        LinkedListIterator<Doors*> iterator(door_list);
        Door_Struct nd;
        iterator.Reset();
        while(iterator.MoreElements()){
                door = iterator.GetData();
                if(door && strlen(door->GetDoorName()) > 3){
                        memset(&nd, 0, sizeof(nd));
                        memcpy(nd.name, door->GetDoorName(), 32);


common/dbsharemem.cpp:

Code:

                        max_door_type = atoi(row[0]);
                        mysql_free_result(result);
                        Door tmpDoor;
                                MakeAnyLenString(&query, "SELECT id,doorid,zone,name,pos_x,pos_y,pos_z,heading,opentype,guild,lockpick,keyitem,triggerdoor,triggertype from doors");//WHERE zone='%s'", zone_name
                                if (RunQuery(query, strlen(query), errbuf, &result))
                                {
                                        safe_delete(query);
                                        while((row = mysql_fetch_row(result))) {
                                                memset(&tmpDoor, 0, sizeof(Door));
                                                tmpDoor.db_id = atoi(row[0]);
                                                tmpDoor.door_id = atoi(row[1]);
                                                strncpy(tmpDoor.zone_name,row[2],16);
                                                strncpy(tmpDoor.door_name,row[3],32); //was set to 10 previously


common/eq_packet_structs.h:

Code:

struct Door_Struct
{
/*0000*/ char    name[32];            // Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade //changed both to 32: Trevius


utils/schema.xml:

Code:

<TABLE ID="4543" Tablename="doors" PrevTableName="" XPos="2108" YPos="2375" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="14" >
<COLUMNS>
<COLUMN ID="4906" ColName="id" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="(11)" Width="0" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="4907" ColName="doorid" PrevColName="" Pos="2" idDatatype="2" DatatypeParams="(4)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="4908" ColName="zone" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(16)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
<OPTIONSELECTED>
<OPTIONSELECT Value="0" />
</OPTIONSELECTED>
</COLUMN>
<COLUMN ID="4909" ColName="name" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">


zone/zonedump.h:

Code:

struct Door {
int32        db_id;
int8        door_id;
char        zone_name[16];
char        door_name[32];


common/patches/anniversary_structs.h:

Code:

struct Door_Struct
{
/*0000*/ char    name[32];            // Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade // changed to 32: Trevius


common/patches/client62_structs.h:
Code:

struct Door_Struct
{
/*0000*/ char    name[32];            // Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade // changed to 32: Trevius


common/patches/live_structs.h

Code:

struct Door_Struct
{
/*0000*/ char    name[32];            // Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade // changed to 32: Trevius


common/patches/titanium_structs.h

Code:

struct Door_Struct
{
/*0000*/ char    name[32];            // Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade // changed to 32: Trevius

So, I must have made some change that caused the doors to disapear. I will look into this more tomorrow, but if anyone can help out with fixing this, it would be appreciated! I plan to add in a Server Code Submission for this when it is done so it can get added to the source. If anyone else helps, they will get credit of course. I also plan to add this into my source and will post the completed source with these changes and the previous ones I have posted.

Angelox 06-09-2008 09:35 AM

Any name you pull out of an .eqg file can be any size - apparently, SOE changed that with the newer eqg format, and is why a lot of things will not work.
Quote:

// Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade
It must complicated, as it looks like this is some sort of a hack to enable 16 over what was 10.

trevius 06-09-2008 04:49 PM

Maybe I accidentally changed something else door related in the source while I was making these changes. I will go through them all again tonight and make absolutely sure that nothing else was changed that might have caused it to get messed up.

What I did was search the source directory for all files containing the word "door" and then 1 by 1, I went through each file and looked to see if any of them had door name set to 16. I am pretty sure I got them all, but there is still the possibility I missed something. I don't see why this change would cause doors to disappear. Maybe there is some setting that limits the field to 16 that I am not aware of (maybe like a uint setting or something). I am not a coder, so I would really appreciate if a coder could have a quick look at this.

This might not seem too major, but as far as using zones from later expansions go, we will always be limited with objects until this is fixed. I imagine that the object table will probably need similar name updates as well. I think this is the final thing needed to allow all Titanium zones to be used fully. Sure, you can use them now without doors, but IMO, doors are required in many to complete the zone.

Now that I look at it, maybe my changes in utils/schema.xml are what caused the problem. I don't know much about that file and have never changed it before. Maybe this change is what broke it:

Quote:

<COLUMN ID="4909" ColName="name" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(32)" Width="0" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
Maybe that still has to be set to 16. I notice that it says Params (parameter I suppose) and not anything about length of the column. Can anyone confirm how that is supposed to be set?

trevius 06-09-2008 10:40 PM

Here are the sections of code that I suspect one of them being the cause of doors disappearing when I change them. I changed all of the ones highlighted in red to 32 as shown in the earlier post. The red values here show the original values for coders to compare. All other changes above were all 16 to begin with.

dbmemshare.cpp: (note that this one was previously set to 10 and not 16 like all of the others. So, this leads me to believe that it either isn't used anymore, or maybe I need to leave it set to 10 for whatever reason...)

Code:

bool Database::DBLoadDoors(int32 iDoorCount, int32 iMaxDoorID) {
        cout << "Loading Doors from database..." << endl;
        char errbuf[MYSQL_ERRMSG_SIZE];
    char *query = 0;
    MYSQL_RES *result;
    MYSQL_ROW row;
        query = new char[256];
        strcpy(query, "SELECT MAX(id), Count(*) FROM doors");
        if (RunQuery(query, strlen(query), errbuf, &result))
        {
                safe_delete(query);
                row = mysql_fetch_row(result);
                if (row && row[0]) {
                        if (atoi(row[0]) > iMaxDoorID) {
                                cout << "Error: Insufficient shared memory to load doors." << endl;
                                cout << "Max(id): " << atoi(row[0]) << ", iMaxDoorID: " << iMaxDoorID << endl;
                                cout << "Fix this by increasing the MMF_MAX_Door_ID define statement" << endl;
                                return false;
                        }
                        if (atoi(row[1]) != iDoorCount) {
                                cout << "Error: Insufficient shared memory to load doors." << endl;
                                cout << "Count(*): " << atoi(row[1]) << ", iDoorCount: " << iDoorCount << endl;
                                return false;
                        }
                        max_door_type = atoi(row[0]);
                        mysql_free_result(result);
                        Door tmpDoor;
                                MakeAnyLenString(&query, "SELECT id,doorid,zone,name,pos_x,pos_y,pos_z,heading,opentype,guild,lockpick,keyitem,triggerdoor,triggertype from doors");//WHERE zone='%s'", zone_name
                                if (RunQuery(query, strlen(query), errbuf, &result))
                                {
                                        safe_delete(query);
                                        while((row = mysql_fetch_row(result))) {
                                                memset(&tmpDoor, 0, sizeof(Door));
                                                tmpDoor.db_id = atoi(row[0]);
                                                tmpDoor.door_id = atoi(row[1]);
                                                strncpy(tmpDoor.zone_name,row[2],16);
                                                strncpy(tmpDoor.door_name,row[3],10);
                                                tmpDoor.pos_x = (float)atof(row[4]);
                                                tmpDoor.pos_y = (float)atof(row[5]);
                                                tmpDoor.pos_z = (float)atof(row[6]);
                                                tmpDoor.heading = atoi(row[7]);
                                                tmpDoor.opentype = atoi(row[8]);
                                                tmpDoor.guild_id = atoi(row[9]);
                                                tmpDoor.lockpick = atoi(row[10]);
                                                tmpDoor.keyitem = atoi(row[11]);
                                                tmpDoor.trigger_door = atoi(row[12]);
                                                tmpDoor.trigger_type = atoi(row[13]);
                                                EMuShareMemDLL.Doors.cbAddDoor(tmpDoor.db_id, &tmpDoor);
                                                Sleep(0);
                                        }
                                        mysql_free_result(result);
                                }
                                else
                                {
                                        cerr << "Error in DBLoadDoors query '" << query << "' " << errbuf << endl;
                                        delete[] query;
                                        return false;
                                }
                        }
                }
        return true;
}
#endif


doors.cpp:

Code:

Doors::Doors(const Door* door)
:    close_timer(5000)
{
        db_id = door->db_id;
        door_id = door->door_id;
        strncpy(zone_name,door->zone_name,16);
        strncpy(door_name,door->door_name,16);
        pos_x = door->pos_x;
        pos_y = door->pos_y;
        pos_z = door->pos_z;
        heading = door->heading;
        incline = door->incline;
        opentype = door->opentype;
        guild_id = door->guild_id;
        lockpick = door->lockpick;
        keyitem = door->keyitem;
        trigger_door = door->trigger_door;
        trigger_type = door->trigger_type;
        triggered=false;
        door_param = door->door_param;
        size = door->size;
        invert_state = door->invert_state;
        SetOpenState(false);

        close_timer.Disable();
   
        strncpy(dest_zone,door->dest_zone,16);
        dest_x = door->dest_x;
        dest_y = door->dest_y;
        dest_z = door->dest_z;
        dest_heading = door->dest_heading;

}

Code:

//        Door tmpDoor;
        MakeAnyLenString(&query, "SELECT id,doorid,zone,name,pos_x,pos_y,pos_z,heading,"
                "opentype,guild,lockpick,keyitem,triggerdoor,triggertype,dest_zone,dest_x,"
                "dest_y,dest_z,dest_heading,door_param,invert_state,incline,size "
                "FROM doors WHERE zone='%s' ORDER BY doorid asc", zone_name);
        if (RunQuery(query, strlen(query), errbuf, &result)) {
                safe_delete_array(query);
                sint32 r;
                for(r = 0; (row = mysql_fetch_row(result)); r++) {
                        if(r >= iDoorCount) {
                                cerr << "Error, Door Count of " << iDoorCount << " exceeded." << endl;
                                break;
                        }
                        memset(&into[r], 0, sizeof(Door));
                        into[r].db_id = atoi(row[0]);
                        into[r].door_id = atoi(row[1]);
                        strncpy(into[r].zone_name,row[2],16);
                        strncpy(into[r].door_name,row[3],16);
                        into[r].pos_x = (float)atof(row[4]);
                        into[r].pos_y = (float)atof(row[5]);
                        into[r].pos_z = (float)atof(row[6]);
                        into[r].heading = (float)atof(row[7]);
                        into[r].opentype = atoi(row[8]);
                        into[r].guild_id = atoi(row[9]);
                        into[r].lockpick = atoi(row[10]);
                        into[r].keyitem = atoi(row[11]);
                        into[r].trigger_door = atoi(row[12]);
                        into[r].trigger_type = atoi(row[13]);
            strncpy(into[r].dest_zone,row[14],16);
            into[r].dest_x = (float) atof(row[15]);
            into[r].dest_y = (float) atof(row[16]);
            into[r].dest_z = (float) atof(row[17]);
            into[r].dest_heading = (float) atof(row[18]);
                        into[r].door_param=atoi(row[19]);
                        into[r].invert_state=atoi(row[20]);
                        into[r].incline=atoi(row[21]);
                        into[r].size=atoi(row[22]);
                }
                mysql_free_result(result);
        }
        else
        {
                cerr << "Error in DBLoadDoors query '" << query << "' " << errbuf << endl;
                safe_delete_array(query);
                return false;
        }
        return true;
}

doors.h:

Code:

private:
int32        db_id;
sint8        door_id;
char        zone_name[16];
char        door_name[16];
float        pos_x;
float        pos_y;
float        pos_z;
float        heading;
int incline;
int8        opentype;
int32        guild_id;
int16        lockpick;
uint32        keyitem;
int8        trigger_door;
int8        trigger_type;
int32        door_param;
int16        size;
int invert_state;
int32        entity_id;
bool        isopen;
Timer        close_timer;
//Timer        trigger_timer;

char    dest_zone[16];
float  dest_x;
float  dest_y;
float  dest_z;
float  dest_heading;


};

entity.cpp:

Code:

bool EntityList::MakeDoorSpawnPacket(EQApplicationPacket* app)
{
        int32 count = door_list.Count();
        if( !count || count>500)
                return false;
        int32 length = count * sizeof(Door_Struct);
        uchar* packet_buffer = new uchar[length];
        memset(packet_buffer, 0, length);
        uchar* ptr = packet_buffer;
        Doors *door;
        LinkedListIterator<Doors*> iterator(door_list);
        Door_Struct nd;
        iterator.Reset();
        while(iterator.MoreElements()){
                door = iterator.GetData();
                if(door && strlen(door->GetDoorName()) > 3){
                        memset(&nd, 0, sizeof(nd));
                        memcpy(nd.name, door->GetDoorName(), 16);
                        nd.xPos = door->GetX();
                        nd.yPos = door->GetY();
                        nd.zPos = door->GetZ();
                        nd.heading = door->GetHeading();
                        nd.incline = door->GetIncline();
                        nd.size = door->GetSize();
                        nd.doorId = door->GetDoorID();                               
                        nd.opentype = door->GetOpenType();
                        nd.state_at_spawn = door->GetInvertState() ? !door->IsDoorOpen() : door->IsDoorOpen();
                        nd.invert_state = door->GetInvertState();
                        nd.door_param = door->GetDoorParam();       
                        memcpy(ptr, &nd, sizeof(nd));
                        ptr+=sizeof(nd);
                        *(ptr-1)=0x01;
                        *(ptr-3)=0x01;
                }
                iterator.Advance();
        }

#if EQDEBUG >= 5
//        LogFile->write(EQEMuLog::Debug, "MakeDoorPacket() packet length:%i qty:%i ", length, qty);
#endif
        app->SetOpcode(OP_SpawnDoor);
        app->size = length;
        app->pBuffer = packet_buffer;
        return true;       
}


trevius 06-10-2008 08:12 AM

Well, I didn't get any code working for greater than 16 char door names yet, but I did get a new wiki page added. Noting it here since it is door related. I tested every opentype and created a nice reference list with descriptions for anyone wanting to create their own doors. Here is the completed list:

http://www.eqemulator.net/wiki/wikka.php?wakka=OpenType

I still want to get the 16 char limit raised in the source, but I think I may need more help with it.

Derision 06-10-2008 08:40 AM

Quote:

Originally Posted by trevius (Post 150388)
I still want to get the 16 char limit raised in the source, but I think I may need more help with it.

The size of the door name appears to be set to 16 characters in the packet the server sends to the client, i.e. 16 characters is all the client will accept, in which case it can't be changed.

Angelox 06-10-2008 03:15 PM

Quote:

Originally Posted by Derision (Post 150390)
The size of the door name appears to be set to 16 characters in the packet the server sends to the client, i.e. 16 characters is all the client will accept, in which case it can't be changed.

There are so many items that can be placed, but exist over the 16 character limit - would it be possible to upgrade the portion of source involving packets sent to the client?

Scorpious2k 06-10-2008 03:34 PM

I haven't had time to look into this a lot, but I noticed this:

Code:

struct Door_Struct
{
/*0000*/ char    name[16];            // Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade
/*0016*/ char    unknown0016[16];

So, if you change name to be name[32] I think it would be a good guess that the unknown0016[16] is actually the other half of the name. So... to keep from breaking the packet struct, you should remove the line that says /*0016*/ char unknown0016[16]; when you change the one above it to /*0000*/ char name[32];

trevius 06-10-2008 04:08 PM

Ahh, worth a shot! So, 2 parts of the packet would essentially become 1 but use the same space so that packet structure doesn't change?

I will see if I can get a compiler working on my windows pc so I can compile the source over and over testing each way without having to impact my players all night lol.

And to Derision; I think this should be adjustable because of the note in the comment below showing that it was previously set to 10 and it is now 16. So, if it can go from 10 to 16, it should be able to go higher.

Quote:

// Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade
What S2K said makes alot of sense to me. Basically it sounds like that unknown packet is just set there to fill the gap of the missing 16 chars from the size of the name that should actually be 32. I bet there is actually nothing at all in that space currently and that is why it was able to be adjusted in the past. I wish that note from Daeken was a little clearer lol. I wonder if he means "subtracted the 6 from the unknown below which was previously 22 and added that to the name so it went from 10 to 16".

Angelox 06-10-2008 06:07 PM

Quote:

Originally Posted by Scorpious2k (Post 150397)
I haven't had time to look into this a lot, but I noticed this:

Code:

struct Door_Struct
{
/*0000*/ char    name[16];            // Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade
/*0016*/ char    unknown0016[16];

So, if you change name to be name[32] I think it would be a good guess that the unknown0016[16] is actually the other half of the name. So... to keep from breaking the packet struct, you should remove the line that says /*0016*/ char unknown0016[16]; when you change the one above it to /*0000*/ char name[32];

We'll try this out in a while - tell ya what happened.

Aramid 06-10-2008 06:15 PM

Quote:

Originally Posted by trevius (Post 150399)
I will see if I can get a compiler working on my windows pc so I can compile the source over and over testing each way without having to impact my players all night lol.
.

Trev, The DEV Kit will let you compile EQEMU. I've set it up on a machine and it works perfectly and you can register the Trial Version of VC++ Express 2005 for Free.

Here's the link. http://www.eqemulator.net/forums/showthread.php?t=25372


All times are GMT -4. The time now is 04:27 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.