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.768 921,-113.998970,17375,58,0),
(109,'PoKnowledge','VTBKSHF302',824.282043,650.241 211,-113.998970,17024,58,0),
(108,'PoKnowledge','VSWRACKS303',833.632629,614.95 8557,-113.998978,17152,58,0),
(107,'PoKnowledge','VSWRACKS304',880.304321,615.08 8928,-113.998978,17344,58,0),
(106,'PoKnowledge','VSWRACKS304',833.294189,556.89 1296,-113.998978,17216,58,0),
(105,'PoKnowledge','VSWRACKS304',829.010376,619.65 5884,-113.998970,17280,58,0),
(104,'PoKnowledge','VSWRACKS303',885.114136,610.30 0110,-113.998970,0,58,0),
(103,'PoKnowledge','VSWRACKS303',821.624817,568.95 4102,-114.248970,17216,58,0),
(102,'PoKnowledge','VSWRACKS303',881.403137,557.27 7710,-113.998970,17312,58,0),
(101,'PoKnowledge','VSWRACKS301',884.507813,620.90 7532,-113.998970,0,58,0),
(100,'PoKnowledge','VSWRACKS301',829.202515,608.79 7058,-113.998970,17280,58,0),
(99,'PoKnowledge','VSWRACKS301',892.010193,569.168 396,-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.968 018,-127.997971,17280,5,0),
(78,'PoKnowledge','POKDOOR500',413.967255,1042.053 467,-103.997971,17152,5,0),
(77,'PoKnowledge','POKDOOR500',408.966644,1065.917 236,-103.997971,17280,5,0),
(76,'PoKnowledge','POKDOOR500',370.015320,888.0304 57,-95.997978,17344,5,0),
(75,'PoKnowledge','POKDOOR500',376.070831,850.0729 98,-95.997978,0,5,0),
(74,'PoKnowledge','POKDOOR500',358.094849,919.9799 80,-95.997978,17152,5,0),
(73,'PoKnowledge','POKDOOR500',376.187897,970.0109 25,-95.997971,0,5,0),
(72,'PoKnowledge','POKDOOR500',381.962860,919.9799 80,-95.997978,17152,5,0),
(71,'PoKnowledge','POKDOOR500',393.956543,888.0299 68,-95.997978,17344,5,0),
(70,'PoKnowledge','POKDOOR500',398.010681,795.9501 34,-95.997978,17152,5,0),
(69,'PoKnowledge','POKDOOR500',383.947479,774.0256 96,-95.997978,0,5,0),
(68,'PoKnowledge','POKDOOR500',445.972076,450.0429 69,-127.997971,17344,5,0),
(67,'PoKnowledge','POKDOOR500',37.992420,230.99618 5,-127.997971,17280,5,0),
(66,'PoKnowledge','POKDOOR500',56.042866,273.10571 3,-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.0624 39,-127.997978,17280,77,0),
(47,'PoKnowledge','POKDOOR500',852.076965,1027.934 692,-159.997955,17344,5,0),
(46,'PoKnowledge','POKDOOR500',839.915710,1100.112 671,-159.997971,17152,5,0),
(45,'PoKnowledge','POKDOOR501',801.996887,1063.946 289,-159.997955,0,27,0),
(44,'PoKnowledge','POKDOOR501',863.979919,710.9558 72,-159.997955,17152,77,0),
(43,'PoKnowledge','POKDOOR501',856.955200,660.7529 91,-113.997978,17344,77,0),
(42,'PoKnowledge','POKDOOR500',844.002197,335.9191 89,-159.997955,17344,5,0),
(41,'PoKnowledge','POKDOOR500',895.992554,336.0554 50,-159.997955,17344,5,0),
(40,'PoKnowledge','POKDOOR501',910.000916,350.0624 08,-159.997955,17280,27,0),
(39,'PoKnowledge','POKDOOR500',656.095337,123.9821 47,-159.997955,0,5,0),
(38,'PoKnowledge','POKDOOR500',656.195496,175.9573 06,-159.997955,0,5,0),
(37,'PoKnowledge','POKDOOR501',594.012573,146.0241 70,-159.997971,0,27,0),
(26,'PoKnowledge','POKELEVATOR500',0.027769,917.38 3789,-0.997999,17152,59,0),
(23,'PoKnowledge','POKRVPORT500',908.667664,1228.0 56763,-156.247955,17344,58,0),
(22,'PoKnowledge','POKKELPORT500',908.392334,883.5 65674,-156.247955,17344,58,0),
(21,'PoKnowledge','POKKALPORT500',908.506226,475.2 92755,-156.147964,17344,58,0),
(20,'PoKnowledge','POKHALPORT500',908.600464,132.1 08978,-155.997971,17152,58,0),
(19,'PoKnowledge','POKFELPORT500',811.879089,37.13 7459,-155.997971,17280,58,0),
(18,'PoKnowledge','POKERPORT500',594.483582,35.937 756,-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.96323 4,-159.997955,0,27,0),
(50,'PoKnowledge','POKDOOR500',396.031708,108.0022 81,-159.997971,17152,5,0),
(51,'PoKnowledge','POKDOOR500',407.990875,35.96679 3,-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.932 739,-111.997971,17344,5,0),
(81,'PoKnowledge','POKDOOR500',80.007164,1439.9713 13,-111.997971,0,5,0),
(82,'PoKnowledge','POKDOOR500',54.014759,1399.8857 42,-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.417 480,-155.998947,17216,58,0),
(112,'PoKnowledge','VTBKSHF302',904.722595,560.202 087,-155.998962,17312,58,0),
(113,'PoKnowledge','VTBKSHF302',904.412964,699.215 210,-159.998947,17375,58,0),
(114,'PoKnowledge','VTBKSHF302',823.745178,699.684 998,-159.998947,17024,58,0),
(115,'PoKnowledge','VSSHELF301',912.881775,651.226 379,-152.248947,17344,58,0),
(116,'PoKnowledge','VSSHELF301',912.881165,632.711 548,-152.245407,17344,58,0),
(119,'PoKnowledge','VSPSHELF301',847.741455,551.99 9939,-150.248962,17280,58,0),
(120,'PoKnowledge','VSPSHELF301',839.988708,551.93 6584,-150.248169,17280,58,0),
(121,'PoKnowledge','VTDESK302',878.979919,643.9085 08,-163.998947,17280,58,0),
(122,'PoKnowledge','VTDESK302',850.420166,664.7010 50,-163.998962,17344,58,0),
(123,'PoKnowledge','VTCHAIR302',879.349976,647.565 857,-163.998947,17389,58,0),
(124,'PoKnowledge','VTCHAIR302',846.144287,664.317 078,-163.998947,17103,58,0),
(125,'PoKnowledge','POPCRATE501',844.073242,623.04 6265,-163.998947,17344,58,0),
(126,'PoKnowledge','POPCRATE501',849.955444,628.80 3406,-163.998947,17370,58,0),
(127,'PoKnowledge','POPCRATE501',843.228638,629.50 5066,-158.064911,17188,58,0),
(-128,'PoKnowledge','POPCRATE501',851.230835,622.973 083,-157.748947,17300,58,0),
(-127,'PoKnowledge','POPCRATE500',851.278687,622.474 365,-163.998947,17344,58,0),
(-126,'PoKnowledge','POPCRATE500',849.902527,628.721 924,-159.998947,17280,58,0),
(-125,'PoKnowledge','POPCRATE500',844.154053,630.103 699,-163.998947,17280,58,0),
(-124,'PoKnowledge','SHBOOK306',879.286621,644.08483 9,-160.248947,17388,58,0),
(-123,'PoKnowledge','SHBOOK307',913.082153,648.33422 9,-146.998947,17152,58,0),
(-122,'PoKnowledge','SHBOOK306',912.862000,636.74670 4,-148.748947,17191,58,0),
(-121,'PoKnowledge','SHBOOK303',913.278137,631.96386 7,-146.102997,17152,58,0),
(-119,'PoKnowledge','SHBOOK302',912.868835,635.37774 7,-148.188995,17152,58,0),
(-117,'PoKnowledge','SHBOOK301',913.123901,630.56439 2,-146.116989,17152,58,0),
(-116,'PoKnowledge','SHBOOK302',913.160339,631.05297 9,-146.123962,17152,58,0),
(-115,'PoKnowledge','VSWRACKS304',816.764526,670.776 184,-159.998947,17152,58,0),
(-114,'PoKnowledge','VSWRACKS303',816.671814,685.794 373,-159.998947,17152,58,0);

[Krathis]

Error: EMuShareMem: pDLLLoadDoors: iMaxDoorID > MMF_MAX_Door_ID
You need to increase the define in Doors.h.

sorry, but i got this error with that stuff.

[Krathis]

its definatly the 4.4ddr1 thats causing it. i loaded 4.3 and it gives no errors. so this doesn't work for 4.4ddr1

[Krathis]

going to experament a bit, but 4.3 doesn't give any errors but at the same time nuthing is showing in game.

[Krathis]

Ok, this is getting me very upset. i've tried everything and all im getting is either nuthing or bags. I realy could use some help here. but the only one thats willing to help is Lurker_005. Where are the once that did the other zones? Im trying to make this emu complete. spent 3 days trying to get this to work.

[Lurker_005]

The doors that are in DB.sql I think were packer collected a long time ago. The ones I posted, and those in the DB Addon are converted from the eqcollectors database (hackersquest data)

I havn't been keeping up with the changes in the current code, perhaps I'll have time to see about getting everything up to date and check things out myself in game.

[Krathis]

Thanks for your help. seems nobody else cares or willing to help.

[Krathis]

Lurker_005, have you done any testing on this yet? would realy like to get these in the game.

[Bigpull]

Fixed.. And I broke all your databases in the process.

You'll need to convert the heading fields to float, extend the name field to 16, and add
varchar(16) dest_zone
float's dest_x,dest_y,dest_z,dest_heading

The good news is now door objects can actualy teleport you, inner and inter zone =)

[Lurker_005]

First Yea for fixing it!

Boo for breaking the existing DB's ;)

*EDIT* realized what you meant about changing heading to a float :p I assume heading is in the range of 0 - 512 ( corasponds to 0-360 degrees) or were you really nice and made it a degree value like npc headings?

If someone can get me a nice lest of items that you click on to teleport, with the items locand zone are, dest zone, and dest loc/heading I'll see about getting a new doors table generated.

Oh and while I think about it, lift data: loc, startz endz trigger loc(s) and I'll try to get that into it also.

I'll probably generate the doors, and release it then start adding the new data to it.

[Trumpcard]

BP, I made an update SQL in release, could you modify it with the other changes?

put the new fields from the ST comments, but didnt realize there were any ALTER's

[Bigpull]

Ok i added the alter for the name and heading and added the example pok doors then changed my mind and removed them because of the incorrect format headings


If someone could convert that DecToFloat into a mysql function so it can be pasted into the door updater.... =)

[DeletedUser]

Lurker could you please update the doors asap, and the change was made because the original way the heading was set was wrong. EQ uses a float when we were using an int16.

[Lurker_005]

I'll post new doors tonight when I get home.

[Lurker_005]

OK got the new doors uploaded

http://lurker.eqemu.net/DBFiles/doors-06112003.zip

It drops the doors and objects table, then loads em back up. I included the updates for gfaydark lifts at the end. If anyone gets more working, please foward the updates in the same format to me.

Things I noticed that I havn't heard talked about before:
- Lift height isn't working. They always seem to go to the same height from their starting place 68.0 in the z acording to #loc
- Objects direction isn't working, they all face the same direction regardless of what is in the DB.

[IAsoulfood]

OK got the new doors uploaded

http://lurker.eqemu.net/DBFiles/doors-06112003.zip

It drops the doors and objects table, then loads em back up. I included the updates for gfaydark lifts at the end. If anyone gets more working, please foward the updates in the same format to me.

Things I noticed that I havn't heard talked about before:
- Lift height isn't working. They always seem to go to the same height from their starting place 68.0 in the z acording to #loc
- Objects direction isn't working, they all face the same direction regardless of what is in the DB.

Heya bud couldnt help but inform ya what an awesome and fast job you did here, but one small issue I'm workin on.
In order to zone anyone importing database must also add the following:
destin_zone, dest_x, dest_y, and dest_x minimum for the zones to accept them.
Otherwise: "Zone is not ready to receive you" pop's up.
The database for doors is extremely well organized and I truly appreciate all your hard work.
Keepin it real =)
Soulfood (Ex-Kane Bayle)
Pantora (Ex-Kane Bayle)

[Trumpcard]

Hurrah Lurker, my zones start again !

[IAsoulfood]

Lurker_005: don't worry about the destination: zone, x, y, z
I've completed all of that already and the POK and all POKTELE500 doors will port you within millimeters of your destination door. I have not included "dest_heading" as you'll notice it is still "0".
Hope it helps out.
A new doors.zip file can be accessed directly at:

http://my.core.com/~tgarland/doors.zip

I know its not as nice looking as yours but it is in the same order anyhow =)

Everyone will have to drop their doors table manually unless you care to fix this part I'm more of a Systems/Networking Guru and only an enthusiast of Programming =)

Soulfood

[Zern]

Lurker_005: don't worry about the destination: zone, x, y, z
I've completed all of that already and the POK and all POKTELE500 doors will port you within millimeters of your destination door. I have not included "dest_heading" as you'll notice it is still "0".
Hope it helps out.
A new doors.zip file can be accessed directly at:

http://my.core.com/~tgarland/doors.zip

I know its not as nice looking as yours but it is in the same order anyhow =)

Everyone will have to drop their doors table manually unless you care to fix this part I'm more of a Systems/Networking Guru and only an enthusiast of Programming =)

Soulfood


Just add the following to the start of your sql file:



DROP TABLE IF EXISTS doors;
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 float 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',
dest_zone varchar(16) default "NONE",
dest_x float default 0,
dest_y float default 0,
dest_z float default 0,
dest_heading float default 0,
PRIMARY KEY (id)
) TYPE=MyISAM;

[IAsoulfood]

WOOOT Ya Bud!!!

I've learned more about databases and MySql then I ever really wanted to know I've sourced enough times that the fat lady sang and died LMAO.

Major Thanks,
Soulfood

[Zern]

I've learned more about databases and MySql then I ever really wanted to know I've sourced enough times that the fat lady sang and died LMAO.


haha :lol:

[Lurker_005]

In order to zone anyone importing database must also add the following:
destin_zone, dest_x, dest_y, and dest_x minimum for the zones to accept them.


Yes, but I didn't include any "doors" that would teleport, so those values should be default right now and not produce any error messages. If they do, give me the zone and loc of the item and I'll look into it.

[IAsoulfood]

Lurker_005,
Heya bud. I know you didnt make the doors teleport that is what I added to them at the following weblink in this post.
Been working hard on these doors at the web-url I posted earlier. The destinations are in that zip file. But there are 2 things that must be fixed and I can only get one of them.

1) All the POK[zone_abbreviation]PORT500 and POKTELE500 type's must be set with open_type=58 not 57 or places like "The Nexus" you will not be able to left click, right click or walk onto to zone. Using open_type=58 makes these doors left click to port to dest_zone, dest_x, dest_y, dest_z, dest_heading.

2) No matter what I do with FreportW I cannot get the POKTELE500_DMSPRITEDEF to present itself as POKTELE500 as I can in the other zones that I've have tested.

Side_note: You must have destination (zone) bare minimum to use database safe_coords or my preference of dest_zone, dest_x, dest_y, dest_z which I have already set so your standing to any given side of the POK 500 doortype, depending on which side the dest_x had an added +5.0 in order not to zone ontop of the destination objects[doors].
Download the zip file and take a look I'm going to put what I have so far up there as of right now =) hope you have better luck than me.

http://my.core.com/~tgarland/doors.zip

Thanks for all the work you've been putting into this project it makes it well worth it =)
Soulfood.

[IAsoulfood]

I've taken the zone.exe that was running during entry into the Freeport West zone and the world.exe logs from their respective dos windows hope posting will shed some light.

[Status] CURRENT_ZONE_VERSION: EQEMu 0.4.4-DR1
[Error] CURRENT_ZONE_VERSION: EQEMu 0.4.4-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
EMuShareMem.dll loaded.
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from spells_en.txt
[Status] FileLoadSPDat() spells loaded: 3568
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
Init: Loading zone lists, zone state or spawn list, player corpsesZonepoints loa
ded into memory
, timezone data - Done. ZoneID = 202; Time Offset = 0
Couldn't find/read ./cfg/poknowledge.cfg. (returning -1)
Couldn't find/read ./cfg/poknowledge.cfg. (returning -1)
Corrupt (or nonexistant) zhdr file ./cfg/poknowledge.cfg -- fread count = -1 (sh
ould be 170)
Using default zone header data...
[Status] Loading Objects from DB...
Loading zones doors...done.
Petition 0 pettime = 0
-----------
Zone server 'poknowledge' listening on port:8000
-----------
[Status] Zone Bootup: poknowledge (202)
Default weather type for zone is 1
Weather changes in 2884 seconds. (weather is now 1)
[Error] Script error 113343
Parser::LoadScript() Error, runaway quote
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [10:27 am]
[Status] 253404 New client from ip:127.0.0.1 port:1682
Loaded playerprofile for Pantora - size: 8460/8460
Loaded alt_adv_table for Pantora - size: 258/258
Setting stats for BL Pet for Race: 130
Summoning BeastLord Pet: +
Setting stats for BL Pet for Race: 10
Summoning BeastLord Pet: +
Setting stats for BL Pet for Race: 130
Summoning BeastLord Pet: +
Setting stats for BL Pet for Race: 2
Summoning BeastLord Pet: +
Pantora casting #261, slot=6, invslot=65535
Unknown SpawnAppearance type: 0x0013 value: 0x00000002
above two lines are from the spell_list slot #6 with spell being "Levitate" if that makes a difference during your scan of this data
Setting stats for BL Pet for Race: 130
Summoning BeastLord Pet: +
Setting stats for BL Pet for Race: 2
Summoning BeastLord Pet: +
Setting stats for BL Pet for Race: 130
Summoning BeastLord Pet: +
0: B3 01 00 00 00 00 50 00 - 00 00 00 00 01 00 00 00 | ......P.........
16: E7 03 00 00 | ....
0: B3 01 00 00 00 00 FF FF - 00 00 00 00 01 00 00 00 | ................
16: 01 00 00 00 | ....
0: B3 01 00 00 00 00 05 01 - 00 00 00 00 00 00 00 00 | ................
16: E7 03 00 00 | ....
0: B3 01 00 00 00 00 FF FF - 00 00 00 00 00 00 00 00 | ................
16: 01 00 00 00 | ....
Zone request for:Pantora to: freportw(9)
Player at x:-234 y:-448 z:-151.6
Zoning to specified cords: freportw (9), x=77, y=-682, z=-34.8048
Zoning player to:freportw (9) x:77 y:-682 z:-34.8048
Setting stats for BL Pet for Race: 130
Summoning BeastLord Pet: +
Player attempting to delete spawn: Pantora
Flushing Queue!
Queue Flushed!
Client disconnected (cs=d): Pantora
Dropping client: Process=false, ip=127.0.0.1, port=1682
Automatic shutdown
[Status] Zone Shutdown: poknowledge (202)
Zone shutdown: going to sleep


[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
Loading Variables, zone names & items...
EMuShareMem.dll loaded.
Loading items from database...
...done.
LoginServer.ini read.
Loading guild ranks...done.
Loading EQ time of day..."./eqtime.cfg" is NOT a vaild EQTime file. File version
is 0; EQTime version is 1000 - failed.
Deleted 0 stale player corpses from database.
Deleted -1 stale player backups from database.
Formatting drive C:
TCP listening on: localhost:9000
World server listening on: localhost:9000
Connected to LoginServer: localhost:5999
12839 New TCP connection: 127.0.0.1:1668
12849 New TCP connection: 127.0.0.1:1669
12849 New TCP connection: 127.0.0.1:1670
12849 New TCP connection: 127.0.0.1:1671
12849 New TCP connection: 127.0.0.1:1672
New zoneserver: #1 127.0.0.1:1668
12859 New TCP connection: 127.0.0.1:1673
New zoneserver: #2 127.0.0.1:1673
New zoneserver: #3 127.0.0.1:1672
New zoneserver: #4 127.0.0.1:1671
New zoneserver: #5 127.0.0.1:1670
New zoneserver: #6 127.0.0.1:1669
Zoneserver SetConnectInfo: 127.0.0.1:1668: localhost:8000
Zoneserver SetConnectInfo: 127.0.0.1:1669: localhost:7997
Zoneserver SetConnectInfo: 127.0.0.1:1670: localhost:7996
Zoneserver SetConnectInfo: 127.0.0.1:1671: localhost:7999
Zoneserver SetConnectInfo: 127.0.0.1:1672: localhost:7995
Zoneserver SetConnectInfo: 127.0.0.1:1673: localhost:7998
69971 New client from ip: 127.0.0.1 port: 1676
Logged in: Local: eqemu
Sending list of guilds
Unknown opcode: 0x3541 size:2056
Unknown opcode: 0x3941 size:2056
Error: InflatePacket: inflate() returned -3 'unknown compression method'
Packet contents:Pantora
Attempting autobootup of necropolis (123) for Pantora
Zoneserver SetZone: localhost:7999 necropolis (123)
Enter world: Pantora: necropolis (123)
Broadcasting a world time update
Zoneserver SetZone: localhost:7999 necropolis (123)
Client disconnected
Removing client from ip:127.0.0.1 port:1676
Zoneserver SetZone: localhost:8000 poknowledge (202)
Broadcasting a world time update
265182 New client from ip: 127.0.0.1 port: 1680
Logged in: Local: eqemu
Unknown opcode: 0x3541 size:2056
Unknown opcode: 0x3941 size:2056
Error: InflatePacket: inflate() returned -3 'unknown compression method'
Packet contents:Pantora
Enter world: Pantora: poknowledge (202)
Zoneserver SetZone: localhost:8000 poknowledge (202)
Zoneserver SetZone: localhost:7999 (0)
Zoneserver SetZone: localhost:7999 (0)
Client disconnected
Removing client from ip:127.0.0.1 port:1680
Zoneserver SetZone: localhost:7998 freportw (9)
Broadcasting a world time update
Zoneserver SetZone: localhost:8000 (0)
362311 New client from ip: 127.0.0.1 port: 1684
Logged in: Local: eqemu
Zoneserver SetZone: localhost:8000 (0)
Unknown opcode: 0x3541 size:2056
Unknown opcode: 0x3941 size:2056
Error: InflatePacket: inflate() returned -3 'unknown compression method'
Packet contents:Pantora
Enter world: Pantora: freportw (9)
Zoneserver SetZone: localhost:7998 freportw (9)
Client disconnected
Removing client from ip:127.0.0.1 port:1684
475784 New client from ip: 127.0.0.1 port: 1688
Logged in: Local: eqemu
Sending list of guilds
Zoneserver SetZone: localhost:7998 (0)
Zoneserver SetZone: localhost:7998 (0)
Unknown opcode: 0x3541 size:2056
Unknown opcode: 0x3941 size:2056
Client disconnected
Removing client from ip:127.0.0.1 port:1688
127.0.0.1:1672: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7995)
127.0.0.1:1670: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7996)
127.0.0.1:1669: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7997)
127.0.0.1:1673: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7998)
127.0.0.1:1671: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (localhost:7999)

I'm currently up to date with the CVS as it stands at SourceForge.net I may have to downstep the branch I'm not certain if that is the issue with Freeport West's Portal/Door either.

Sorry for the long input thought it would be better to put it in down to closing zones.exe out =)
Soulfood

[jdankanyin]

Ok this is my db im using with the code that luker put in for the doors and it works fine but when i used the second code the doors were all moved 90 degrees can someone help me. Ok here is the db with moving mobs and krushers items db beta 5 with pok 85% done. Ok when i try to upload my db i get this error so i cant show you

[IAsoulfood]

jdankanyin,
Re-download my doors database I have at my weblink
http://my.core.com/~tgarland/doors.zip
Then open mysql and resource this doors.sql file.
If your still having a problem please make certain that you have a fresh download since I just uploaded it as of this post and that you have verify at the top of the file doors.sql it will say the following#

MySQL-Front Dump 2.5
#
# --------------------------------------------------------
# Server version 4.0.13-nt

If it does not say this you have the wrong load of my doors.sql zip-file.
If you are running MySql version lower than 4.0.13 and there is an incompatability issue leave a post I check this forum frequently and will work on making just the commands to update the database without changing it.

ALWAYS MAKE A BACKUP OF YOUR DATABASE BEFORE "SOURCING" NEW FILES INTO IT.

Thanks
Soulfood

[jdankanyin]

:o Hey i already got it but i was saying that the first part worked great but when i added yours it made all my doors be 90 degrees off that was it . Also this is where my servers and desk are for my computers.

[IAsoulfood]

jdankanyin,
Sorry about them being off by 90degrees I do not have the know how to fix it. You can use Lurker_005's door_db or hope someone here can help out fixing it. I wish I knew why. Still in Freeport West the portal to POK does not show up on my system, just an FYI kinda thing if its the same for you I am unsure since my doors are not at a 90degree change.
Hoping Lurker_005 see's this one =)
Soulfood.

[Lurker_005]

soulfood I was tired last night and didn't notice that I skiped some posts. I didn't see your doors.zip till today :p

Good news is I was tired from working with doors. Mostly what you had done in your doors file :p Anyhow some of the changes you made I think were causing problems. Specifically changing the doorid field. That has to be unique for each door in the zone. This may be why you had problems with the freport book. As for the doors being 90 deg???? The rest of the files data is identical to mine. I can only guess it has to do with a different CVS version.

Anyhow, I'll post another copy of the doors this weekend with more stuff working. Regarding that, I know there was a request for the Tower of frozen shadow. Someone want to get a list of locs from, and too, also the key item# or at least name.

If someone wants to make the changes and post them that would be great. I would prefer they be in an update format with comments for each section or zone. here is a line from one I have done.
UPDATE doors SET dest_zone="Tox" ,dest_y=-2344.14 ,dest_x=295.884 ,dest_z=-47 ,dest_heading=371.01 WHERE zone LIKE "PoKnowledge" AND name LIKE "POKPPORT500";


Oh and for when the object is the same as others, it is probably best to add AND doorid=id# to the where part

[IAsoulfood]

Lurker_005,
Sorry about changing the unique door id's I was so tired of Freeport West I was trying alot of things with that zone and forgot to reset the unique door id's I was playing with. Thanks for catching it.
I'll take your doors.zip and add the id's to my database until this weekend.
If I can be of any assistance with this database don't hesitate to point me in a direction or two. I'd love the opportunity.
=)
Keepin it real
Soulfood

[Lurker_005]

Well I worked on the doors some more, give these a try.

http://lurker.eqemu.net/DBFiles/doors-06142003.zip

It has Plane of Knowledge books (to and from) some plane of tranquility ones, a first go at tower of frozen shadow, and 2 non working elevators :(

Let me know what you find. I probably won't be working on this any more today, but perhaps sunday...

[Bigpull]

YAY doors! i've added some Error printing to cvs should help those darn stuborn not wanting to spawn doors some ;)


[Status] Loading doors for freportw ...
[Error] Database errror, Not Sending door: i:824 door:0x41965766 db_id:824 zone_name:FreportW zone:freportw door_id:154
[Error] Database errror, Not Sending door: i:825 door:0x419657c8 db_id:825 zone_name:FreportW zone:freportw door_id:153
[Error] Database errror, Not Sending door: i:894 door:0x41967232 db_id:894 zone_name:FreportW zone:freportw door_id:177


894 happens to be that pok book that was giving troubles if you don't recognise the number

[Bigpull]

And yes i fixed the door_id to sint8 -128 to 127 like we've been expecting them /mumble

So tofs mirrors look great and our MovePC() sucks =) can't move thru walls atm.

[IAsoulfood]

Gonna keep working on finding more of these door and zoning issues. I'll take a look at it tonight. Father's Day tomorrow so I may not get a chance to respond until tomorrow night. =)

WOOOT we're getting closer =) BTW Tradeskills and those forges ovens etc... I click on em and walla when in inventory they actually open now. =) musta had something to do with the objects you put in Lurker_005 Thanks bud.


Soulfood

[Lurker_005]

And yes i fixed the door_id to sint8 -128 to 127 like we've been expecting them /mumble

So tofs mirrors look great and our MovePC() sucks =) can't move thru walls atm.

I thought doorid was sint8... Is the 4.4 release expecting 0-255? I can easily change the data to 0-255 it would make more sense too. Up to you, hate to make you change stuff back and forth. You doing such a great job finding and fixing these little bugs.

As for the MovePC() It works as long as the target loc is "valid" If you would spawn below the world or in a wall/floor it just seems to move you inside the current enclosure. It is wierd how it works though.

[Bigpull]

Yes if you'll notice when i added the error printing that many doors are over 127, That pok book that wouldn't show up was -79, le oops. And honestly they likely are 0-255 actualy, but the code (minus the new door struct) was looking at -128 127.

About door_id, This only needs to be unique to the extend of if you click another door with the same door_id the client sends a click for the first door you sent. So in short you can link two port doors and only have to maintain one dest_ set

About open_type, these really really need documented.

[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. doors.sql is all my doors except your TOFS which I do not have at this moment and doors.csv makes this step easier for you...it is only the POK and destination portal/doors that I have fixed/updated. Hope that it makes it faster for you since there are less than 30 total =)
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.
Thanks again,
Soulfood.