Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2008, 07:03 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default 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
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #2  
Old 06-08-2008, 07:35 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

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.

Last edited by cavedude; 06-09-2008 at 03:39 AM..
Reply With Quote
  #3  
Old 06-09-2008, 03:40 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #4  
Old 06-09-2008, 06:52 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by trevius View Post
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.
Reply With Quote
  #5  
Old 06-09-2008, 08:09 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #6  
Old 06-09-2008, 09:35 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

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.
Reply With Quote
  #7  
Old 06-09-2008, 04:49 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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?
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #8  
Old 06-09-2008, 10:40 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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;	
}
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #9  
Old 06-10-2008, 08:12 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #10  
Old 06-10-2008, 08:40 AM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

Quote:
Originally Posted by trevius View Post
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.
Reply With Quote
  #11  
Old 06-10-2008, 03:15 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by Derision View Post
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?
Reply With Quote
  #12  
Old 06-10-2008, 03:34 PM
Scorpious2k's Avatar
Scorpious2k
Demi-God
 
Join Date: Mar 2003
Location: USA
Posts: 1,067
Default

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];
__________________
Maybe I should try making one of these servers...
Reply With Quote
  #13  
Old 06-10-2008, 04:08 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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".
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #14  
Old 06-10-2008, 06:07 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by Scorpious2k View Post
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.
Reply With Quote
  #15  
Old 06-10-2008, 06:15 PM
Aramid
Discordant
 
Join Date: May 2006
Posts: 356
Default

Quote:
Originally Posted by trevius View Post
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
__________________
Random Segments of Code....
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:02 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3