EQEmulator Forums - Doors & stones help please

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - Doors & stones help please (https://www.eqemulator.org/forums/showthread.php?t=7756)

Doors & stones help please

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.

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.

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.

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

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

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

Code:

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

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

Code:

delete from doors;

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

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

http://eqemu.freehomepage.com

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);

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

Forgot, heading is actually a float value

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

Code:

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 &amp; "1"

                                        headtmp=headtmp-i

                                Else

                                        headbin=headbin &amp; "0"

                                End If

                                i=i/2

                        Loop

                        

'                        MsgBox headtmp &amp; ", " &amp; headbin     

                        ' add fractional part of number to the string 

                        If headtmp &lt;> 0 Then

                                headbin=headbin &amp; "."

                                i=2

                                Do While i &lt;=256

                                        If headtmp >= 1/i Then

                                                headbin=headbin &amp; "1"

                                                headtmp=headtmp-1/i

                                        Else

                                                headbin=headbin &amp; "0"

                                        End If

                                        i=i*2

                                Loop

                        End If

'                        MsgBox headbin &amp; ", " &amp; 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 &lt;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 &amp; ", " &amp; binexptmp      

                        i=-1

                        Do While i > -8

                                If headbin>=10^i Then

                                        headtmp=headtmp &amp; "1"

                                        headbin=headbin-10^i

                                Else

                                        headtmp=headtmp &amp; "0"

                                End If

                                i=i-1

                        Loop

'                        MsgBox headbin &amp; ", " &amp; headtmp      

                        

                        ' turn binexptmp into the exp in bin-string format

                        i=128

                        binexp=""

                        Do While i >=1

                                If binexptmp >= i Then

                                        binexp=binexp &amp; "1"

                                        binexptmp=binexptmp-i

                                Else

                                        binexp=binexp &amp; "0"

                                End If

                                i=i/2

                        Loop

                        

                        headfloat=CDbl(binexp &amp; headtmp) ' concentrate E and F together s is always 0 so dosen't matter

'                        MsgBox "0 " &amp; binexp &amp; ", " &amp; headtmp &amp; vbCRLF &amp; 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

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

Code:

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.

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

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

try this:

Code:

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);

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.

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

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

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.

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.

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

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

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 =)

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.

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

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.... =)

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.

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

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.

Quote:

Originally Posted by Lurker_005

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)

Hurrah Lurker, my zones start again !

database update for doors

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

Re: database update for doors

Quote:

Originally Posted by 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;

Thanks of gratitude

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

Re: Thanks of gratitude

Quote:

Originally Posted by soulfood

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:

Quote:

Originally Posted by soulfood

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.

Lurker_005 about doors

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.

In case its of help Lurker_005

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

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

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