Doors & stones help please

[Krathis]

id-doorid-zone-name-loc y-x-z open type guild lockpick keyitem triggerdoor triggertype doorisopen lifthight

#1. does the loc for the doors go by /loc or #loc?
#2.What goes in id & doorid are these just the next number in line?
#3.zone i get-the short name for the zone
#4.name door type name-know what this means but is there a list somewhere where i can get the names?
#5.open type-???
#6.guild-probably to tie it to a guild where only people of that guild can enter/use
#7.lockpick- how hard it is to pick it?
#8.keyitem- type of key to unlock it.
#9.trigger door-i guess this is how the door/object is used (click.right click,ect..)??
#10.trigger type ?? something to do with #9?
#11.doorisopen-0 closed 1 open?
#12.lifthight- hu? no clue

Thanks for any help in advanced. I know this is part of 3rd party tools but it also has to do with world building. so i posted it here.

[Lurker_005]

ID is just a unique number for each entry (sequential)
DoorID -126 thru 127 unique by zone (think this should be an unsigned value, but that is just how the code is right now)
zone zone short name
name Door model name in zone obj file (open the zone obj file with kaiyodo's model viewer for a list for each zone)
XYZ loc probably #loc I'll check when I'm home
heading Float value, see post below
open type values aren't recorded, but corosponds to sliding swinging up right left ect... someone want to document this by trial and error?
guild for guild use obviously, not sure how this was implemented of the top of my head
lockpick skill required to pick it I think
Keyitem Item number that is the key to open it
triggerdoor enter another doorID to have this triger the other door to open
triggertype umm not positive, see open type :p
Doorisopen flag for the position of the door
liftheight distance to move lifts (presumably the z distance from the starting spot)

Best I can do without digging in the code. If someone gets all the info labeled and values maped, please share it.

[Krathis]

Hmm im confused. the item viewer for the item i want shows

pokaaport500_dmsprite.. rest i can't read. first part can't fit in the fild. but pokaa will or port500 ? not sure.

[Krathis]

ok, i kinda got this down but still having problems. i don't see any objects.

this is what i put into the db

INSERT INTO doors VALUES(9998,9998,'poknowledge','pokaa',156.46,-337.17, 151.62,0,5,0,0,0,0,0,0,0);


the name field won't hold but 10 characters witch the name is 12.

Pokaa
pokaaport
pokaaport5

i've tried these and their not working.

btw. here is a list of some of the other objects if someone else can get this to work

Pokcabport500
pokchair500
pokdoor500
pokelevator500

[Krathis]

btw. i didn't see it before. but by after i did that insert into the db i see a bag in mid air over the stone port stands. and if i click on it they rotate. So im getting close, just got to figure how to get pokaaport500 to show up.
Maybee soon i can have pok look like live. I also updated my site last night with more of pok spawned. I started out spawning where the soulbinder is and got that area all spawned then i went to the inside circle and worked my way around the whole circle. Next i have to do the other stone porter area's then finaly the tower then i will have pok completly done.


"It is far better to help with the emu instead of begging for stuff"

http://eqemu.freehomepage.com

[Lurker_005]

It looks like the code can handle 16 char for the door, but DB.sql still has it set to just 10. Change the DB name field to be 16 char long and it should work.

Oh and here is the sql to change it

ALTER TABLE `doors` CHANGE `name` `name` VARCHAR(16)  NOT NULL;

you will need to delete the doors and re source them.

delete from doors;

[Zern]

OK Krathis I'm starting to feel bad for you so I'll explain how it goes. Sorry for the delay, I read this post before but was inclined to giving out information when I, myself got shit on by so many others when asking for a piece of information even by an "Op" of this whole project who will remain nameless.

One more piece of information. You are correct the table in the database is only 10 characters long for the name of the door, however in code it is expanded up to 16 characters.

i.e.:

************************************************** **
[ In File eq_packet_structs.h ]

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
// uint8 unknown0008[6]; // This is "supposed" to be with name hehe

************************************************** **

To fix this problem you can either

A) Source out the door table, then drop the doors table and paste the following into a txt file and then source it back into the database


************************************************** ***
CREATE TABLE `doors` (
`id` int(11) NOT NULL auto_increment,
`doorid` smallint(4) NOT NULL default '0',
`zone` varchar(16) NOT NULL default '',
`name` varchar(16) NOT NULL default '',
`pos_y` float NOT NULL default '0',
`pos_x` float NOT NULL default '0',
`pos_z` float NOT NULL default '0',
`heading` int(11) NOT NULL default '0',
`opentype` smallint(4) NOT NULL default '0',
`guild` smallint(4) NOT NULL default '0',
`lockpick` smallint(4) NOT NULL default '0',
`keyitem` int(11) NOT NULL default '0',
`triggerdoor` smallint(4) NOT NULL default '0',
`triggertype` smallint(4) NOT NULL default '0',
`doorisopen` smallint(4) NOT NULL default '0',
`liftheight` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
************************************************** **


and then source back in your door data that you sourced out.
Be sure to open the sourced out door data and remove the CREATE table at the top so it doesn't interfer with the new table you just sourced in.

or

B) Update the table directly which I think is possible but I don't have the command near me so don't quote me on this one.



------------------------------------------------------------------------------------

Now onto your main problem ...
(Will explain the minor details in case others read this)


First as you are doing, use the EQModel viewer and load up the zone you wish to peek into for the objects/doors you wish to spawn.

[Load up the Zone_Name.obj file]

Now look for the object you want.

For example say you want FSMFORGE301_DMSPRITEDEF
What you would put for the name value in the doors table in the database is "FSMFORGE301" Put everything up until the first underscore.


Then do what you just explained, get the coords, etc insert values for the other data values in the table and then reload your world.exe and your new object should show.


Any questions feel free to pop on the server [LEGIT]Memories of Vex.


-David
ServerOp of Memories of Vex

[Krathis]

Thanks for the help, i think i can finaly spawn the pok doors & stones. You guys rock!










http://eqemu.freehomepage.com

[Krathis]

Slight problem. now its just showing bags instead of the object. not sure whats wrong. this is what i did.


INSERT INTO doors VALUES (9991,1,'poknowledge','pokaaport500',156.46,-337.17,-151.62,0,2,0,0,0,0,0,0,0);

[Zern]

Are you rebooting your world.exe after you insert the new door?

[Lurker_005]

Forgot, heading is actually a float value

Since I was working in VBScript and it neglected a DecToFloat function here is what I made...

Function DecToFloat(heading)
	Dim headbin, headtmp, binexptmp, binexp, headfloat, i
			'			Convert to decimal representation of first 16 bits of a float
			headtmp=CSng(heading)
			i=512
			headbin=""
			' get whole part of number into bin-string
			Do While i >=1
				If headtmp >= i Then
					headbin=headbin & "1"
					headtmp=headtmp-i
				Else
					headbin=headbin & "0"
				End If
				i=i/2
			Loop
			
'			MsgBox headtmp & ", " & headbin     
			' add fractional part of number to the string 
			If headtmp <> 0 Then
				headbin=headbin & "."
				i=2
				Do While i <=256
					If headtmp >= 1/i Then
						headbin=headbin & "1"
						headtmp=headtmp-1/i
					Else
						headbin=headbin & "0"
					End If
					i=i*2
				Loop
			End If
'			MsgBox headbin & ", " & headtmp      
			
			' Treat the bin number as a regular number and set to 1.xxx format
			headbin=CDbl(headbin)
				i=0
			If headbin >=1 Then
				Do While headbin > 2
					headbin=headbin/10
					i=i+1
				Loop
			ElseIf headbin > 0 Then
				' already in 1.xxx or smaller
				Do While headbin <1
					headbin=headbin*10
					i=i+1
				Loop
			End If
			' make headtmp a bin-string of the F part of the float
			headtmp=""
			binexptmp=i+127
			headbin=headbin-1
'			MsgBox headbin & ", " & binexptmp      
			i=-1
			Do While i > -8
				If headbin>=10^i Then
					headtmp=headtmp & "1"
					headbin=headbin-10^i
				Else
					headtmp=headtmp & "0"
				End If
				i=i-1
			Loop
'			MsgBox headbin & ", " & headtmp      
			
			' turn binexptmp into the exp in bin-string format
			i=128
			binexp=""
			Do While i >=1
				If binexptmp >= i Then
					binexp=binexp & "1"
					binexptmp=binexptmp-i
				Else
					binexp=binexp & "0"
				End If
				i=i/2
			Loop
			
			headfloat=CDbl(binexp & headtmp) ' concentrate E and F together s is always 0 so dosen't matter
'			MsgBox "0 " & binexp & ", " & headtmp & vbCRLF & headfloat     
			'convert the bin number to a decimal for EQEmu
			i=14
			heading=0
			Do While i >=0
				If headfloat >= 10^i Then
					heading=heading+2^i
					headfloat=headfloat-10^i
				End If
				i=i-1
			Loop
			

	DecToFloat=heading
End Function

[Krathis]

Yes, i resart the whole server. still having some problems

INSERT INTO doors VALUES (9998,128,'poknowledge','POKCABPORT500',-335.0,146.0,-151.6,0,1,0,0,0,0,0,0,0);

this puts the floating(direction) at 0 so should be fine. ugg *boggle* trying 1 more thing though to see.

[Krathis]

Also not sure if it makes a differance but im using an early version of 4.4ddr1

[Krathis]

UGG, now im not even showing a bag, nuthing is there :( this keeps getting more and more frustrating

[Lurker_005]

try this:

delete from doors where zone like 'poknowledge';
INSERT IGNORE INTO doors (doorid, zone, name, pos_y, pos_x, pos_z, heading, opentype, keyitem) VALUES
  (-111,'PoKnowledge','VSRUGS301',-831.421509,655.155029,-163.961639,17344,58,0),
  (-112,'PoKnowledge','VSRUGS301',-831.664551,626.831177,-163.840469,17344,58,0),
  (-113,'PoKnowledge','VSRUGS301',-831.411560,585.638367,-155.971878,17152,58,0),
  (110,'PoKnowledge','VTBKSHF302',889.777710,649.768921,-113.998970,17375,58,0),
  (109,'PoKnowledge','VTBKSHF302',824.282043,650.241211,-113.998970,17024,58,0),
  (108,'PoKnowledge','VSWRACKS303',833.632629,614.958557,-113.998978,17152,58,0),
  (107,'PoKnowledge','VSWRACKS304',880.304321,615.088928,-113.998978,17344,58,0),
  (106,'PoKnowledge','VSWRACKS304',833.294189,556.891296,-113.998978,17216,58,0),
  (105,'PoKnowledge','VSWRACKS304',829.010376,619.655884,-113.998970,17280,58,0),
  (104,'PoKnowledge','VSWRACKS303',885.114136,610.300110,-113.998970,0,58,0),
  (103,'PoKnowledge','VSWRACKS303',821.624817,568.954102,-114.248970,17216,58,0),
  (102,'PoKnowledge','VSWRACKS303',881.403137,557.277710,-113.998970,17312,58,0),
  (101,'PoKnowledge','VSWRACKS301',884.507813,620.907532,-113.998970,0,58,0),
  (100,'PoKnowledge','VSWRACKS301',829.202515,608.797058,-113.998970,17280,58,0),
  (99,'PoKnowledge','VSWRACKS301',892.010193,569.168396,-113.998978,17024,58,0),
  (96,'PoKnowledge','POKDOOR503',0.023378,804.070618,0.002001,17152,27,0),
  (95,'PoKnowledge','POKDOOR500',-316.458099,879.035095,-95.997978,0,5,0),
  (94,'PoKnowledge','POKDOOR500',-317.057953,794.006714,-95.997971,17344,5,0),
  (79,'PoKnowledge','POKDOOR500',173.913666,1473.968018,-127.997971,17280,5,0),
  (78,'PoKnowledge','POKDOOR500',413.967255,1042.053467,-103.997971,17152,5,0),
  (77,'PoKnowledge','POKDOOR500',408.966644,1065.917236,-103.997971,17280,5,0),
  (76,'PoKnowledge','POKDOOR500',370.015320,888.030457,-95.997978,17344,5,0),
  (75,'PoKnowledge','POKDOOR500',376.070831,850.072998,-95.997978,0,5,0),
  (74,'PoKnowledge','POKDOOR500',358.094849,919.979980,-95.997978,17152,5,0),
  (73,'PoKnowledge','POKDOOR500',376.187897,970.010925,-95.997971,0,5,0),
  (72,'PoKnowledge','POKDOOR500',381.962860,919.979980,-95.997978,17152,5,0),
  (71,'PoKnowledge','POKDOOR500',393.956543,888.029968,-95.997978,17344,5,0),
  (70,'PoKnowledge','POKDOOR500',398.010681,795.950134,-95.997978,17152,5,0),
  (69,'PoKnowledge','POKDOOR500',383.947479,774.025696,-95.997978,0,5,0),
  (68,'PoKnowledge','POKDOOR500',445.972076,450.042969,-127.997971,17344,5,0),
  (67,'PoKnowledge','POKDOOR500',37.992420,230.996185,-127.997971,17280,5,0),
  (66,'PoKnowledge','POKDOOR500',56.042866,273.105713,-127.997971,17344,5,0),
  (65,'PoKnowledge','POKDOOR500',-38.031536,243.032104,-127.997971,0,5,0),
  (64,'PoKnowledge','POKDOOR500',-44.009003,273.086365,-127.997971,17344,5,0),
  (48,'PoKnowledge','POKDOOR501',639.982056,926.062439,-127.997978,17280,77,0),
  (47,'PoKnowledge','POKDOOR500',852.076965,1027.934692,-159.997955,17344,5,0),
  (46,'PoKnowledge','POKDOOR500',839.915710,1100.112671,-159.997971,17152,5,0),
  (45,'PoKnowledge','POKDOOR501',801.996887,1063.946289,-159.997955,0,27,0),
  (44,'PoKnowledge','POKDOOR501',863.979919,710.955872,-159.997955,17152,77,0),
  (43,'PoKnowledge','POKDOOR501',856.955200,660.752991,-113.997978,17344,77,0),
  (42,'PoKnowledge','POKDOOR500',844.002197,335.919189,-159.997955,17344,5,0),
  (41,'PoKnowledge','POKDOOR500',895.992554,336.055450,-159.997955,17344,5,0),
  (40,'PoKnowledge','POKDOOR501',910.000916,350.062408,-159.997955,17280,27,0),
  (39,'PoKnowledge','POKDOOR500',656.095337,123.982147,-159.997955,0,5,0),
  (38,'PoKnowledge','POKDOOR500',656.195496,175.957306,-159.997955,0,5,0),
  (37,'PoKnowledge','POKDOOR501',594.012573,146.024170,-159.997971,0,27,0),
  (26,'PoKnowledge','POKELEVATOR500',0.027769,917.383789,-0.997999,17152,59,0),
  (23,'PoKnowledge','POKRVPORT500',908.667664,1228.056763,-156.247955,17344,58,0),
  (22,'PoKnowledge','POKKELPORT500',908.392334,883.565674,-156.247955,17344,58,0),
  (21,'PoKnowledge','POKKALPORT500',908.506226,475.292755,-156.147964,17344,58,0),
  (20,'PoKnowledge','POKHALPORT500',908.600464,132.108978,-155.997971,17152,58,0),
  (19,'PoKnowledge','POKFELPORT500',811.879089,37.137459,-155.997971,17280,58,0),
  (18,'PoKnowledge','POKERPORT500',594.483582,35.937756,-155.997955,17344,58,0),
  (16,'PoKnowledge','POKTNPORT500',460.964691,-76.371353,-156.097946,17152,58,0),
  (15,'PoKnowledge','POKTGDPORT500',459.375549,-235.677505,-156.247955,0,58,0),
  (14,'PoKnowledge','POKSHPORT500',363.597595,-332.178619,-156.097946,17280,58,0),
  (13,'PoKnowledge','POKQNSPORT500',147.520615,-331.698303,-156.247955,17344,58,0),
  (12,'PoKnowledge','POKPTPORT500',-147.699265,-332.219818,-155.997925,0,58,0),
  (11,'PoKnowledge','POKFVPORT500',-364.253540,-331.822662,-156.347961,17344,58,0),
  (10,'PoKnowledge','POKFPTPORT500',-461.026367,-235.181366,-156.147964,17152,58,0),
  (9,'PoKnowledge','POKAAPORT500',-460.388733,-76.482666,-156.247971,17280,58,0),
  (8,'PoKnowledge','POKOVPORT500',-897.068054,872.220398,-159.347961,17344,58,0),
  (0,'PoKnowledge','POKCABPORT500',-596.697144,36.121975,-155.997955,0,58,0),
  (1,'PoKnowledge','POKGROPORT500',-801.225220,46.983891,-159.247955,0,58,0),
  (3,'PoKnowledge','POKNRKPORT500',-909.187378,131.793137,-156.147964,17280,58,0),
  (4,'PoKnowledge','POKOGPORT500',-906.998169,443.858795,-156.147964,17280,58,0),
  (7,'PoKnowledge','POKPPORT500',-896.652588,1215.843384,-159.347946,17344,58,0),
  (28,'PoKnowledge','POKDOOR502',-802.014648,279.938446,-159.997971,0,27,0),
  (29,'PoKnowledge','POKDOOR500',-851.974365,242.032471,-159.997971,17152,5,0),
  (30,'PoKnowledge','POKDOOR500',-839.962463,318.122559,-159.997971,17344,5,0),
  (31,'PoKnowledge','POKDOOR502',-832.086914,699.960510,-159.997971,17344,77,0),
  (32,'PoKnowledge','POKDOOR502',-825.024536,649.949402,-113.997978,17152,77,0),
  (33,'PoKnowledge','POKDOOR502',-909.997681,1090.023315,-159.997955,0,27,0),
  (34,'PoKnowledge','POKDOOR500',-822.008728,1103.904053,-159.997955,17344,5,0),
  (35,'PoKnowledge','POKDOOR500',-883.993652,1069.922363,-159.997955,17344,5,0),
  (36,'PoKnowledge','POKDOOR502',-627.056702,1025.937622,-127.997978,0,77,0),
  (49,'PoKnowledge','POKDOOR503',351.939606,71.963234,-159.997955,0,27,0),
  (50,'PoKnowledge','POKDOOR500',396.031708,108.002281,-159.997971,17152,5,0),
  (51,'PoKnowledge','POKDOOR500',407.990875,35.966793,-159.997971,17344,5,0),
  (52,'PoKnowledge','POKDOOR503',223.123672,-201.066788,-113.997971,17280,77,0),
  (53,'PoKnowledge','POKDOOR503',173.029938,-193.985672,-160.071976,17280,77,0),
  (54,'PoKnowledge','POKDOOR503',-73.941803,-145.869110,-159.997971,17152,27,0),
  (55,'PoKnowledge','POKDOOR500',-123.982536,-184.070038,-159.997971,17344,5,0),
  (56,'PoKnowledge','POKDOOR500',-39.994114,-184.083496,-159.997971,17344,5,0),
  (57,'PoKnowledge','POKDOOR503',-289.950928,-145.977264,-160.247971,17152,27,0),
  (58,'PoKnowledge','POKDOOR500',-312.083466,-171.959000,-159.997971,17280,5,0),
  (59,'PoKnowledge','POKDOOR500',-255.983582,-184.090363,-159.997971,17344,5,0),
  (60,'PoKnowledge','POKDOOR503',-321.998871,-78.000412,-159.997955,17152,27,0),
  (61,'PoKnowledge','POKDOOR500',-301.957977,-52.003029,-159.997971,0,5,0),
  (62,'PoKnowledge','POKDOOR500',-334.044495,-41.959698,-159.997971,17280,5,0),
  (63,'PoKnowledge','POKDOOR503',-0.037455,91.942261,-127.997978,17152,77,0),
  (80,'PoKnowledge','POKDOOR500',100.011917,1399.932739,-111.997971,17344,5,0),
  (81,'PoKnowledge','POKDOOR500',80.007164,1439.971313,-111.997971,0,5,0),
  (82,'PoKnowledge','POKDOOR500',54.014759,1399.885742,-111.997971,17344,5,0),
  (83,'PoKnowledge','POKDOOR500',-41.990246,1399.961792,-111.997978,17344,5,0),
  (84,'PoKnowledge','POKDOOR500',-88.039398,1399.882935,-111.997971,17344,5,0),
  (85,'PoKnowledge','POKDOOR500',-80.084541,1428.005981,-111.997971,17280,5,0),
  (86,'PoKnowledge','POKDOOR500',-173.913605,1486.004761,-127.997978,0,5,0),
  (88,'PoKnowledge','POKDOOR500',-343.015900,905.526794,-95.997971,17152,5,0),
  (89,'PoKnowledge','POKDOOR500',-466.422485,550.081665,-127.997971,0,5,0),
  (90,'PoKnowledge','POKDOOR500',-377.941193,523.942749,-127.997971,17344,5,0),
  (91,'PoKnowledge','POKDOOR500',-408.046326,504.152771,-127.997971,0,5,0),
  (92,'PoKnowledge','POKDOOR500',-389.948517,413.811676,-127.997971,17152,5,0),
  (93,'PoKnowledge','POKDOOR500',-360.360443,527.804138,-93.997971,17280,5,0),
  (97,'PoKnowledge','POKELESWTCH500',-12.000710,930.749939,5.001999,0,109,0),
  (98,'PoKnowledge','POKELESWTCH500',-10.188633,904.009521,392.001953,17152,109,0),
  (111,'PoKnowledge','VTBKSHF302',822.980591,560.417480,-155.998947,17216,58,0),
  (112,'PoKnowledge','VTBKSHF302',904.722595,560.202087,-155.998962,17312,58,0),
  (113,'PoKnowledge','VTBKSHF302',904.412964,699.215210,-159.998947,17375,58,0),
  (114,'PoKnowledge','VTBKSHF302',823.745178,699.684998,-159.998947,17024,58,0),
  (115,'PoKnowledge','VSSHELF301',912.881775,651.226379,-152.248947,17344,58,0),
  (116,'PoKnowledge','VSSHELF301',912.881165,632.711548,-152.245407,17344,58,0),
  (119,'PoKnowledge','VSPSHELF301',847.741455,551.999939,-150.248962,17280,58,0),
  (120,'PoKnowledge','VSPSHELF301',839.988708,551.936584,-150.248169,17280,58,0),
  (121,'PoKnowledge','VTDESK302',878.979919,643.908508,-163.998947,17280,58,0),
  (122,'PoKnowledge','VTDESK302',850.420166,664.701050,-163.998962,17344,58,0),
  (123,'PoKnowledge','VTCHAIR302',879.349976,647.565857,-163.998947,17389,58,0),
  (124,'PoKnowledge','VTCHAIR302',846.144287,664.317078,-163.998947,17103,58,0),
  (125,'PoKnowledge','POPCRATE501',844.073242,623.046265,-163.998947,17344,58,0),
  (126,'PoKnowledge','POPCRATE501',849.955444,628.803406,-163.998947,17370,58,0),
  (127,'PoKnowledge','POPCRATE501',843.228638,629.505066,-158.064911,17188,58,0),
  (-128,'PoKnowledge','POPCRATE501',851.230835,622.973083,-157.748947,17300,58,0),
  (-127,'PoKnowledge','POPCRATE500',851.278687,622.474365,-163.998947,17344,58,0),
  (-126,'PoKnowledge','POPCRATE500',849.902527,628.721924,-159.998947,17280,58,0),
  (-125,'PoKnowledge','POPCRATE500',844.154053,630.103699,-163.998947,17280,58,0),
  (-124,'PoKnowledge','SHBOOK306',879.286621,644.084839,-160.248947,17388,58,0),
  (-123,'PoKnowledge','SHBOOK307',913.082153,648.334229,-146.998947,17152,58,0),
  (-122,'PoKnowledge','SHBOOK306',912.862000,636.746704,-148.748947,17191,58,0),
  (-121,'PoKnowledge','SHBOOK303',913.278137,631.963867,-146.102997,17152,58,0),
  (-119,'PoKnowledge','SHBOOK302',912.868835,635.377747,-148.188995,17152,58,0),
  (-117,'PoKnowledge','SHBOOK301',913.123901,630.564392,-146.116989,17152,58,0),
  (-116,'PoKnowledge','SHBOOK302',913.160339,631.052979,-146.123962,17152,58,0),
  (-115,'PoKnowledge','VSWRACKS304',816.764526,670.776184,-159.998947,17152,58,0),
  (-114,'PoKnowledge','VSWRACKS303',816.671814,685.794373,-159.998947,17152,58,0);