boats in 4.4
 

LethalEncounter: BOATS! To set them up run the sql file included called boats.sql. (NOTE this is for the default db, if you have a different version then you must convert the ids to your db, the names are stormbreaker and sirensbane)


#To get boats run the follow sql commands:


update spawn2 set x=3296,y=1355,z=-12.9,heading=128,respawntime=0 where id=8562;
update spawn2 set x=7483,y=-2099,z=-20,heading=128,respawntime=0 where id=104231;
update spawn2 set x=-1080,y=-6,z=-75,heading=0,respawntime=0 where id=39816;
update spawn2 set x=-9188,y=222,z=-20,heading=64,respawntime=0 where id=104230;
update spawn2 set pathgrid=1 where id=8562;
update spawn2 set pathgrid=2 where id=104231;
update spawn2 set pathgrid=3 where id=39816;
update spawn2 set pathgrid=4 where id=104230;
delete from doors where zone='freporte' and pos_y<-350;
#the reason for the door deletion was because someone put 2 doors on the docks in freporte and it was blocking ppl from getting on the boat :/

INSERT INTO grid VALUES('1', '3', '1', '3296.000000 1355.000000 -12.900000 60', '3296.000000 1355.000000 -12.900000 60', '3295.000000 1181.000000 -8.400000 0', '3359.000000 1104.000000 -8.400000 0', '3509.000000 1030.000000 -8.400000 0', '3750.000000 951.000000 -8.400000 0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO grid VALUES('2', '3', '1', '7483.000000 -2099.000000 -20.000000 60', '7483.000000 -2099.000000 -20.000000 60', '7414.000000 -2994.000000 -20.600000 0', '6868.000000 -4200.000000 -20.600000 0', '5872.000000 -4693.000000 -20.600000 0', '-9005.000000 -4629.000000 -20.600000 0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO grid VALUES('3', '3', '1', '-1080.000000 -6.000000 -75.000000 60', '-1080.000000 -6.000000 -75.000000 60', '-1100.000000 125.000000 -75.000000 0', '-1228.000000 215.000000 -75.000002 0', '-1262.000000 376.000000 -75.000000 0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO grid VALUES('4', '3', '1', '-9188.000000 222.000000 -20.000000 60', '-9188.000000 222.000000 -20.000000 60', '-8640.000000 239.000000 6.400000 0', '-5638.000000 168.000000 6.400000 0', '604.000000 -530.000000 6.400000 0', '1605.000000 -1080.000000 6.400000 0', '2775.000000 -1651.000000 6.400000 0', '7352.000000 1700.000000 6.400000 14', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');




which id's in this example is stormbreaker and which one is sirensbane? I have noticed in drawe's database there is 3 sirensbanes and 3 stormbreakers.

Just check the id's of the ones that are spawning in bbm, freporte,and oot.

I'm looking into fixing this in my DB (there was some boat pathing data in my 1.1 DB but the spawn2 IDs were set up wrong). Now I've found the correct IDs it -should- work, haven't tested it yet.
Now all we need is the Odus, Kunark and Velious boat pathing!

Drawde , can you post the ID's you used for the boats?

Freeport StormBreaker - 11481
OOT StormBreaker - 11482
BB SirensBane - 10658
OOT SirensBane - 10660
Haven't tested these yet but they are the correct IDs as far as I can tell.

Here's a full list of boat IDs (spawn2 IDs, not npc_types) in my current DB. I haven't included the Icebreaker since the IDs for Velious NPCs are likely to change soon when I add more Velious data to my DB.


BB Stormbreaker 11480
EFP Stormbreaker 11481
OOT Stormbreaker 11482
BB SirensBane 10658
OOT SirensBane 10660
EFP SirensBane 10659
EC Golden Maiden 5288
Erudin Golden Maiden 5289
Qeynos Golden Maiden 5290
EC SeaKing 10286
Erudin SeaKing 10287
Qeynos SeaKing 10288
OT Bloated Belly 677
TD Bloated Belly 678
FV Maidens Voyage 7981
TD Maidens Voyage 7982

BB Shuttle 10591
TD Shuttle 10592
Erudin Shuttle (Sabrina) 9881
Halas Shuttle (Gwenavyne) 6058
Oasis Shuttle (Barrel Barge) 442
TD Shuttle ("") 443

clarification please :)
 

which boats go with the id's used in the post in the begining of this thread?
my db is totally different so i need to make a cross ref.

kabalah

Drawde, will the ID changes affect already spawned zones?
I'm currently re-doing the moving npc DB , Using your 1.1 final as the base , and need to know which zones or npcs I should steer clear of until your update comes out.
Any help would be greatly appreciated :)

NPC IDs from 1 to 6476 (old world and Kunark) haven't changed.
All of the Luclin and Velious NPCs will have different IDs though.

I was able to get the boats in OOT and BB to work , but the boat in freeport doesn't move at all , no matter what I do.
Have you gotten it to move Drawde?

ummm i dont know about you, but i dont like being attacked by a boat . . . . . . mainly for example . . in halas . . . . i go to kill the merchants there by the water and . . i get a boat trying to kill me . . . . . well a raft boat thingey.

maybe do your isattackallowed commands on em?


That would throw off your boats when it goes after someone, wouldnt it?

Doesn't seem to work for me either. I've checked all 3 zones and none of the ships move.
This is the exact .sql script:

update spawn2 set pathgrid=1,heading=128,respawntime=0 where id=10658; # BB SirensBane
update spawn2 set pathgrid=2,heading=128,respawntime=0 where id=10660; # OOT SirensBane
update spawn2 set pathgrid=3,heading=0,respawntime=0 where id=11481; # EFP Stormbreaker
update spawn2 set pathgrid=4,heading=64,respawntime=0 where id=11482; # OOT Stormbreaker

INSERT INTO grid VALUES('1', '3', '1', '3296.000000 1355.000000 -12.900000 60', '3296.000000 1355.000000 -12.900000 60', '3295.000000 1181.000000 -8.400000 0', '3359.000000 1104.000000 -8.400000 0', '3509.000000 1030.000000 -8.400000 0', '3750.000000 951.000000 -8.400000 0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO grid VALUES('2', '3', '1', '7483.000000 -2099.000000 -20.000000 60', '7483.000000 -2099.000000 -20.000000 60', '7414.000000 -2994.000000 -20.600000 0', '6868.000000 -4200.000000 -20.600000 0', '5872.000000 -4693.000000 -20.600000 0', '-9005.000000 -4629.000000 -20.600000 0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO grid VALUES('3', '3', '1', '-1080.000000 -6.000000 -75.000000 60', '-1080.000000 -6.000000 -75.000000 60', '-1100.000000 125.000000 -75.000000 0', '-1228.000000 215.000000 -75.000002 0', '-1262.000000 376.000000 -75.000000 0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO grid VALUES('4', '3', '1', '-9188.000000 222.000000 -20.000000 60', '-9188.000000 222.000000 -20.000000 60', '-8640.000000 239.000000 6.400000 0', '-5638.000000 168.000000 6.400000 0', '604.000000 -530.000000 6.400000 0', '1605.000000 -1080.000000 6.400000 0', '2775.000000 -1651.000000 6.400000 0', '7352.000000 1700.000000 6.400000 14', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');


I've checked with EQEmuAdmin and the paths appear to be set up OK. Are there are any other DB values you need to enable to get pathing to work? I have ailevel set to 6, but my account status is currently 150 so I can use the GM commands for testing (this shouldn't affect pathing surely?). This is with 4.4 release version.

heh, you sure your spawn2 id is 10658? Thats probably the npcid, spawn2 id is totally different.

Those are the correct spawn2 IDs, I checked with EQEmuAdmin and the right grid values are assigned to the spawn2 entries.

(With the last released version of my DB, the boat spawn2 IDs were incorrectly set as the npc_types IDs, but I've fixed this now)

I seem to have a few zones that Don't work with pathing correctly.
I have moving boats( awesome fix btw ) in 3 of those zones, but east freeport won't allow run thru the waypoints on the npcs.
I was able to get only 1 npc in eastfreeport to go beyond 1 waypoint, a bartender moving random of 3 waypoints.
All other attepts at movement in that zone result 0.
I don't understand , just going to be happy for now with the 3 boats (btw, I didn't realize the boats actually worked until I got on it and waited, it took off after waitng duration of 2 waypoints, which is what grid called for).
Any ideas about why a zone might neglect waypoint info?
I added memory thinking maybe I was bottlenecking with so many grids, but no change.