boats in 4.4 - Page 2

muhi · #1 06-18-2003, 09:11 AM

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.