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