Index: scripts/zones/Aht_Urhgan_Whitegate/Zone.lua =================================================================== --- scripts/zones/Aht_Urhgan_Whitegate/Zone.lua (revision 2503) +++ scripts/zones/Aht_Urhgan_Whitegate/Zone.lua (working copy) @@ -23,14 +23,17 @@ cs = -1; -- MOG HOUSE EXIT if ((player:getXPos() == 0) and (player:getYPos() == 0) and (player:getZPos() == 0)) then - if (prevZone == 46) then - cs = 0x00C9; - player:setPos(-11.958, 2.000, -136.811, 192); - else - position = math.random(1,5) - 83; - player:setPos(-100,0,position,0); + if(prevZone == 46) then + cs = 0x00c9; + elseif(prevZone == 59) then + cs = 0x00cc; + elseif(prevZone == 58) then + cs = 0x00cc; + else + position = math.random(1,5) - 83; + player:setPos(-100,0,position,0); end - end + end return cs; end; @@ -39,9 +42,13 @@ ----------------------------------- function onTransportEvent(player,transport) - if (transport == 46) then + if ((transport == 46) or (transport == 47)) then player:startEvent(0x00c8); end + if (transport == 58) or (transport == 59) then + player:startEvent(0x00cb); + +end end; ----------------------------------- @@ -60,7 +67,13 @@ function onEventFinish(player,csid,option) --printf("CSID: %u",csid); --printf("RESULT: %u",option); - if (csid == 0x00c8) then - player:setPos(0,0,0,0,47); - end +if(csid == 0x00c9)then +player:setPos(-11,2,-142,192); +elseif(csid == 0x00cc)then +player:setPos(11,2,142,64); +elseif(csid == 0x00c8) then +player:setPos(0,-2,0,0,47); +elseif(csid == 0x00cb) then +player:setPos(0,-2,0,0,58); +end end; \ No newline at end of file Index: scripts/zones/Bibiki_Bay/Zone.lua =================================================================== --- scripts/zones/Bibiki_Bay/Zone.lua (revision 2503) +++ scripts/zones/Bibiki_Bay/Zone.lua (working copy) @@ -13,18 +13,29 @@ ----------------------------------- function onInitialize(zone) +zone:registerRegion(1,481,-7,602,503,5,701); +zone:registerRegion(2,-410,-7,-385,-383,5,-354); +zone:registerRegion(3,487,-6,708,491,-1,717); +zone:registerRegion(4,-394,-7,-396,-391,-1,-385); end; ----------------------------------- -- onZoneIn ----------------------------------- -function onZoneIn(player,prevZone) - cs = -1; - if ((player:getXPos() == 0) and (player:getYPos() == 0) and (player:getZPos() == 0)) then - player:setPos(669.917,-23.138,911.655,111); - end - return cs; +function onZoneIn(player,prevZone) +bibiki = player:getVar("bibiki"); + cs = -1; +if ((player:getXPos() == 0) and (player:getYPos() == 0) and (player:getZPos() == 0))then + if((prevZone == 3) and (bibiki == 3))then + cs = 0x000B; + elseif((prevZone ==3) and (bibiki == 4))then + cs = 0x000A; + else + player:setPos(669.917,-23.138,911.655,111); +end +end +return cs; end; ----------------------------------- @@ -32,9 +43,63 @@ ----------------------------------- function onRegionEnter(player,region) + + switch (region:GetRegionID()): caseof + { + [1] = function (x) + + player:setVar("bibiki",1); + end, + + [2] = function (x) + + player:setVar("bibiki",2) + end, + [3] = function (x) + + player:setVar("bibiki",0); + end, + + [4] = function (x) + + player:setVar("bibiki",0) + end, + +} end; ----------------------------------- +-- onRegionLeave +----------------------------------- + +function onRegionLeave(player,region) + switch (region:GetRegionID()): caseof + { + [1] = function (x) + player:setVar("bibiki",3); + end, + + [2] = function (x) + + player:setVar("bibiki",4) + end, +} +end; + +----------------------------------- +-- onTransportEvent +----------------------------------- +function onTransportEvent(player,transport) + +if(player:getVar("bibiki") == 1) then +player:startEvent(0x000E); +end +if(player:getVar("bibiki") == 2) then +player:startEvent(0x0010); +end +end; + +----------------------------------- -- onEventUpdate ----------------------------------- @@ -50,4 +115,16 @@ function onEventFinish(player,csid,option) --printf("CSID: %u",csid); --printf("RESULT: %u",option); +if(csid == 0x000E) then +player:setPos(0,0,0,0,3) +end +if(csid == 0x000b) then +player:startEvent(0x000d) +end +if(csid == 0x0010) then +player:setPos(0,0,0,0,3) +end +if (csid == 0x000A) then +player:startEvent(0x000c) +end end; Index: scripts/zones/Manaclipper/Zone.lua =================================================================== --- scripts/zones/Manaclipper/Zone.lua (revision 2503) +++ scripts/zones/Manaclipper/Zone.lua (working copy) @@ -18,7 +18,6 @@ ----------------------------------- -- onZoneIn ----------------------------------- - function onZoneIn(player,prevZone) cs = -1; if ((player:getXPos() == 0) and (player:getYPos() == 0) and (player:getZPos() == 0)) then @@ -27,13 +26,10 @@ return cs; end; ------------------------------------ --- onRegionEnter ------------------------------------ -function onRegionEnter(player,region) +function onTransportEvent(player,transport) +player:startEvent(0x0064) end; - ----------------------------------- -- onEventUpdate ----------------------------------- @@ -50,6 +46,9 @@ function onEventFinish(player,csid,option) --printf("CSID: %u",csid); --printf("RESULT: %u",option); +if(csid == 0x0064) then +player:setPos(0,0,0,0,4) +end end; Index: scripts/zones/Mhaura/npcs/Dieh_Yamilsiah.lua =================================================================== --- scripts/zones/Mhaura/npcs/Dieh_Yamilsiah.lua (revision 2503) +++ scripts/zones/Mhaura/npcs/Dieh_Yamilsiah.lua (working copy) @@ -1,45 +1,49 @@ ------------------------------------ --- Area: Mhaura --- NPC: Dieh Yamilsiah --- Reports the time remaining before boat arrival. --- @pos 7.057 -2.364 2.489 249 ------------------------------------ -package.loaded["scripts/zones/Mhaura/TextIDs"] = nil; ------------------------------------ - ------------------------------------ --- onTrade Action ------------------------------------ - -function onTrade(player,npc,trade) -end; - ------------------------------------ --- onTrigger Action ------------------------------------ - -function onTrigger(player,npc) - - -- The boat comes every 1152 seconds. - timer = 1152 - ((os.time() - 1009810584)%1152); - player:startEvent(0x00e7,timer); - -end; - ------------------------------------ --- onEventUpdate ------------------------------------ - -function onEventUpdate(player,csid,option) --- printf("CSID: %u",csid); --- printf("RESULT: %u",option); -end; - ------------------------------------ --- onEventFinish ------------------------------------ - -function onEventFinish(player,csid,option) --- printf("CSID: %u",csid); --- printf("RESULT: %u",option); +----------------------------------- +-- Area: Mhaura +-- NPC: Dieh Yamilsiah +-- Reports the time remaining before boat arrival. +-- @pos 7.057 -2.364 2.489 249 +----------------------------------- +package.loaded["scripts/zones/Mhaura/TextIDs"] = nil; +----------------------------------- + +----------------------------------- +-- onTrade Action +----------------------------------- + +function onTrade(player,npc,trade) +end; + +----------------------------------- +-- onTrigger Action +----------------------------------- + +function onTrigger(player,npc) + + -- The boat comes every 1152 seconds. + timer = 1152 - ((os.time() - 1009810584)%1152); + timer2 = timer+300; + player:startEvent(0x00e7,timer2,0,0,47); + +end; + +----------------------------------- +-- onEventUpdate +----------------------------------- + +function onEventUpdate(player,csid,option) +-- printf("CSID: %u",csid); +-- printf("RESULT: %u",option); +end; + +----------------------------------- +-- onEventFinish +----------------------------------- + +function onEventFinish(player,csid,option) +-- printf("CSID: %u",csid); +-- printf("RESULT: %u",option); +if(csid == 0x00e7) then +player:startEvent(0x00e7,timer); +end end; \ No newline at end of file Index: scripts/zones/Mhaura/Zone.lua =================================================================== --- scripts/zones/Mhaura/Zone.lua (revision 2503) +++ scripts/zones/Mhaura/Zone.lua (working copy) @@ -37,7 +37,7 @@ ----------------------------------- function onTransportEvent(player,transport) - if (transport == 47) then + if ((transport == 47) or (transport == 46)) then if (not(player:hasKeyItem(BOARDING_PERMIT))) then player:setPos(8.200,-1.363,3.445,192); player:messageSpecial(DO_NOT_PROSSESS, BOARDING_PERMIT); Index: scripts/zones/Nashmau/Zone.lua =================================================================== --- scripts/zones/Nashmau/Zone.lua (revision 2503) +++ scripts/zones/Nashmau/Zone.lua (working copy) @@ -13,6 +13,7 @@ ----------------------------------- function onInitialize(zone) +zone:registerRegion(1,10.816,-2,-105,13.221,2,-103.1); end; ----------------------------------- @@ -21,20 +22,45 @@ function onZoneIn(player,prevZone) cs = -1; - if ((player:getXPos() == 0) and (player:getYPos() == 0) and (player:getZPos() == 0)) then - player:setPos(40.658,-7.527,-24.001,128); - end - return cs; + if ((player:getXPos() == 0) and (player:getYPos() == 0) and (player:getZPos() == 0))then +if(prevZone == 58) then +cs = 0x00C9; +player:setPos(11,2,-102,128); +else +player:setPos(40.658,-7.527,-24.001,128); +end +end +return cs; end; ----------------------------------- -- onRegionEnter ----------------------------------- +function onRegionEnter(player,region) +if(GetNPCByID(16994321):getAnimation() == 8) then +player:setPos(11.384,1.289,-108.847,63) +end +end; -function onRegionEnter(player,region) -end; ----------------------------------- +-- onRegionLeave +----------------------------------- + +function onRegionLeave(player,region) +end; + + +----------------------------------- +-- onTransportEvent +----------------------------------- +function onTransportEvent(player,transport) +if(transport == 59)then +player:startEvent(0x00c8,0,0,0,0,0,0,0,0,59); +end +end; + +----------------------------------- -- onEventUpdate ----------------------------------- @@ -48,6 +74,7 @@ ----------------------------------- function onEventFinish(player,csid,option) - --printf("CSID: %u",csid); - --printf("RESULT: %u",option); +if(csid == 0x00c8) then + player:setPos(0,-2,0,0,59); +end end; Index: scripts/zones/Silver_Sea_route_to_Al_Zahbi/Zone.lua =================================================================== --- scripts/zones/Silver_Sea_route_to_Al_Zahbi/Zone.lua (revision 2503) +++ scripts/zones/Silver_Sea_route_to_Al_Zahbi/Zone.lua (working copy) @@ -33,6 +33,14 @@ end; ----------------------------------- +-- onTransportEvent +----------------------------------- + +function onTransportEvent(player,transport) + player:startEvent(0x0401); +end; + +----------------------------------- -- onEventUpdate ----------------------------------- @@ -48,7 +56,11 @@ function onEventFinish(player,csid,option) --printf("CSID: %u",csid); --printf("RESULT: %u",option); + if(csid == 0x0401) then + player:setPos(0,0,0,0,50); + end end; + Index: scripts/zones/Silver_Sea_route_to_Nashmau/Zone.lua =================================================================== --- scripts/zones/Silver_Sea_route_to_Nashmau/Zone.lua (revision 2503) +++ scripts/zones/Silver_Sea_route_to_Nashmau/Zone.lua (working copy) @@ -24,7 +24,14 @@ return cs; end; +----------------------------------- +-- onTransportEvent +----------------------------------- +function onTransportEvent(player,transport) + player:startEvent(0x0401); +end; + ----------------------------------- -- onRegionEnter ----------------------------------- @@ -48,6 +55,9 @@ function onEventFinish(player,csid,option) --printf("CSID: %u",csid); --printf("RESULT: %u",option); +if(csid == 0x0401) then +player:setPos(0,0,0,0,53) +end end; Index: sql/npc_list.sql =================================================================== --- sql/npc_list.sql (revision 2503) +++ sql/npc_list.sql (working copy) @@ -128,7 +128,7 @@ INSERT INTO `npc_list` VALUES ('16793904', 'TAKARA_GOB_NPC', '0', '-322.993', '-2.631', '-457.733', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000F70100000000000000000000000000000000, '32', '4'); INSERT INTO `npc_list` VALUES ('16793905', 'Fheli_Lapatzuo', '196', '488.793', '-3.003', '709.473', '23', '40', '40', '0', '1', '0', '0', '27', 0x0100070714101F20003087400350006000700000, '32', '4'); INSERT INTO `npc_list` VALUES ('16793906', 'Noih_Tahparawh', '72', '-392.274', '-3.000', '-385.541', '16', '40', '40', '0', '1', '0', '0', '27', 0x01000D0774108620003000400850006000700000, '32', '4'); -INSERT INTO `npc_list` VALUES ('16793907', '', '128', '-391.373', '0.000', '-364.200', '98310', '40', '40', '21', '0', '0', '2', '2051', 0x0400000000000000000000000000000000000000, '0', '4'); +INSERT INTO `npc_list` VALUES ('16793907', '', '0', '-391.373', '0.000', '-364.200', '98310', '40', '40', '21', '0', '0', '2', '2051', 0x0400000000000000000000000000000000000000, '0', '4'); INSERT INTO `npc_list` VALUES ('16793908', '_04s', '0', '489.593', '-5.236', '707.984', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '4'); INSERT INTO `npc_list` VALUES ('16793909', '_04t', '0', '-393.839', '-2.784', '-384.703', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '4'); INSERT INTO `npc_list` VALUES ('16793910', 'Pohka_Chichiyowahl', '254', '-416.388', '-2.154', '-430.095', '6', '40', '40', '0', '1', '0', '0', '27', 0x01000B077D106620083066400850006000700000, '32', '4'); @@ -2736,9 +2736,9 @@ INSERT INTO `npc_list` VALUES ('16982036', 'Baya_Hiramayuh', '192', '-12.082', '1.999', '-143.367', '314', '13', '40', '0', '1', '0', '0', '4194331', 0x010002071410172008300A400350006000700000, '32', '50'); INSERT INTO `npc_list` VALUES ('16982037', 'Khoi_Gamduhla', '64', '3.438', '0.000', '94.903', '21', '40', '40', '0', '1', '0', '0', '27', 0x010005071410172008300A400350006000700000, '32', '50'); INSERT INTO `npc_list` VALUES ('16982038', 'Muji_Tsalahn', '192', '-3.414', '0.000', '-94.906', '14', '40', '40', '0', '1', '0', '0', '27', 0x010004071410172008300A400350006000700000, '32', '50'); -INSERT INTO `npc_list` VALUES ('16982039', '_1es', '0', '-11.692', '1.690', '-144.423', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); +INSERT INTO `npc_list` VALUES ('16982039', '_1es', '0', '-11.692', '1.690', '-144.423', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '127', '50'); INSERT INTO `npc_list` VALUES ('16982040', '_1et', '0', '12.066', '1.385', '144.424', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); -INSERT INTO `npc_list` VALUES ('16982041', '', '0', '-20.726', '3.389', '-154.231', '98311', '40', '40', '19', '0', '0', '2', '2051', 0x0400000000000000000000000000000000000000, '0', '50'); +INSERT INTO `npc_list` VALUES ('16982041', '', '0', '-20.726', '3.389', '-154.231', '98311', '40', '40', '18', '0', '0', '2', '2051', 0x0400000000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982042', 'Zhamwaa', '0', '-103.323', '0.000', '-76.504', '14', '40', '40', '0', '0', '0', '0', '27', 0x01000301AE10AB20AB309F409F50006000700000, '32', '50'); INSERT INTO `npc_list` VALUES ('16982043', 'Moogle', '64', '0.000', '0.000', '1.500', '32776', '40', '40', '0', '1', '0', '2', '3', 0x0000520000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982045', 'qm1', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '2', '2051', 0x0000340000000000000000000000000000000000, '0', '50'); @@ -2751,6 +2751,7 @@ INSERT INTO `npc_list` VALUES ('16982054', '_1ec', '0', '0.349', '-2.000', '104.819', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982055', '_1ed', '0', '20.000', '-2.000', '95.182', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982056', '_1e0', '0', '-150.340', '-0.445', '0.030', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); + INSERT INTO `npc_list` VALUES ('16982059', '_1e4', '0', '111.975', '-1.670', '24.867', '1', '40', '40', '9', '0', '0', '0', '4099', 0x0200000000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982060', 'Sharin-Garin', '73', '122.658', '-0.315', '33.001', '7', '40', '40', '0', '1', '0', '0', '27', 0x01000305AB10AB20AB30AB40AB50006000700000, '32', '50'); INSERT INTO `npc_list` VALUES ('16982061', 'Door_Kokba_Hostel', '0', '112.979', '-7.984', '-64.061', '1', '40', '40', '9', '0', '0', '0', '4099', 0x0200000000000000000000000000000000000000, '0', '50'); @@ -2760,10 +2761,10 @@ INSERT INTO `npc_list` VALUES ('16982065', '_1e7', '0', '107.913', '-1.951', '-80.073', '1', '40', '40', '9', '0', '0', '0', '4099', 0x0200000000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982066', '_1e9', '0', '80.000', '-1.949', '-107.940', '1', '40', '40', '9', '0', '0', '0', '4099', 0x0200000000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982067', 'Runic_Portal', '0', '125.000', '-4.213', '64.400', '32769', '40', '40', '0', '0', '0', '0', '3', 0x0000340000000000000000000000000000000000, '0', '50'); -INSERT INTO `npc_list` VALUES ('16982068', '_1eg', '0', '-15.100', '1.000', '-145.000', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); -INSERT INTO `npc_list` VALUES ('16982069', '_1eh', '0', '-8.899', '1.000', '-145.000', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); -INSERT INTO `npc_list` VALUES ('16982070', '_1ei', '0', '8.899', '1.000', '145.000', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); -INSERT INTO `npc_list` VALUES ('16982071', '_1ej', '0', '15.100', '1.000', '145.000', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); +INSERT INTO `npc_list` VALUES ('16982068', '_1eg', '0', '-14.900', '1.000', '-145.50', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); +INSERT INTO `npc_list` VALUES ('16982069', '_1eh', '0', '-9.5', '1.000', '-145.50', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); +INSERT INTO `npc_list` VALUES ('16982070', '_1ei', '0', '8.899', '-1.200', '145.000', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); +INSERT INTO `npc_list` VALUES ('16982071', '_1ej', '0', '15.100', '-1.200', '145.000', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982072', 'Imperial_Whitegate', '137', '154.296', '-4.199', '0.030', '32769', '40', '40', '0', '0', '0', '0', '3', 0x0000340000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982073', '_fj0', '0', '0.000', '-2.000', '0.599', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '50'); INSERT INTO `npc_list` VALUES ('16982074', 'Gate_Chocobo_Circuit', '0', '-80.000', '-2.000', '108.000', '32769', '40', '40', '0', '0', '0', '0', '3', 0x0000340000000000000000000000000000000000, '0', '50'); @@ -3504,14 +3505,16 @@ INSERT INTO `npc_list` VALUES ('16994314', 'Moogle', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '2', '4194307', 0x0000520000000000000000000000000000000000, '0', '53'); INSERT INTO `npc_list` VALUES ('16994315', 'Abihaal', '127', '5.148', '0.000', '-59.025', '8', '40', '40', '0', '1', '0', '0', '27', 0x010002021410172008300A400350006000700000, '32', '53'); INSERT INTO `npc_list` VALUES ('16994316', 'Sajhra', '0', '14.830', '0.000', '-61.005', '1', '40', '40', '0', '1', '0', '0', '27', 0x010000011410172008300A400350006000700000, '32', '53'); -INSERT INTO `npc_list` VALUES ('16994317', 'Bellowing_Scout', '64', '20.000', '0.000', '-55.189', '21', '40', '40', '0', '1', '0', '0', '27', 0x010003081410172008300A400350006000700000, '32', '53'); +INSERT INTO `npc_list` VALUES ('16994317', 'Bellowing_Scout', '64', '20.000', '0.000', '-55.189', '21', '40', '40', '0', '1', '0', '0', '27', 0x010003081410172008300A400350006000700000, '32', '53'); INSERT INTO `npc_list` VALUES ('16994318', 'Belligerent_Sheep', '192', '0.349', '0.000', '-64.815', '15', '40', '40', '0', '1', '0', '0', '27', 0x01000F081410172008300A400350006000700000, '32', '53'); INSERT INTO `npc_list` VALUES ('16994319', 'Yohj_Dukonlhy', '191', '10.049', '1.999', '-103.451', '323', '13', '40', '0', '1', '0', '0', '4194331', 0x010001071410172008300A400350006000700000, '32', '53'); INSERT INTO `npc_list` VALUES ('16994320', 'Teco_Chatpaya', '190', '3.397', '0.000', '-54.952', '1', '40', '40', '0', '1', '0', '0', '27', 0x010003071410172008300A400350006000700000, '32', '53'); -INSERT INTO `npc_list` VALUES ('16994323', '_1h0', '0', '0.349', '-2.000', '-64.815', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '53'); -INSERT INTO `npc_list` VALUES ('16994324', '_1h1', '0', '20.000', '-2.000', '-55.189', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '53'); -INSERT INTO `npc_list` VALUES ('16994325', '_1h2', '0', '9.449', '1.399', '-104.500', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '53'); -INSERT INTO `npc_list` VALUES ('16994326', '_1h3', '0', '14.550', '1.399', '-104.500', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '53'); +INSERT INTO `npc_list` VALUES ('16994321', '_1h7', '0', '12.028', '-4', '-104', '1', '40', '40', '9', '0', '0', '0', '2051', 0x0300000000000000000000000000000000000000, '0', '53'); +INSERT INTO `npc_list` VALUES ('16994322', '', '0', '3.24', '3.389', '-114.221', '98311', '40', '40', '18', '0', '0', '2', '2051', 0x0400000000000000000000000000000000000000, '0', '53'); +INSERT INTO `npc_list` VALUES ('16994323', '_1h0', '0', '0.349', '1.000', '-64.815', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '53'); +INSERT INTO `npc_list` VALUES ('16994324', '_1h1', '0', '20.000', '1.000', '-55.189', '1', '40', '40', '9', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '53'); +INSERT INTO `npc_list` VALUES ('16994326', '_1h3', '0', '9', '-1.2', '-105.68', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '53'); +INSERT INTO `npc_list` VALUES ('16994325', '_1h2', '0', '14.266', '-1.2', '-105.68', '1', '40', '40', '8', '0', '0', '0', '6147', 0x0200000000000000000000000000000000000000, '0', '53'); INSERT INTO `npc_list` VALUES ('16994327', 'Home_Point', '28', '-19.860', '0.000', '-25.441', '1', '40', '40', '0', '0', '0', '0', '3', 0x0000330000000000000000000000000000000000, '0', '53'); INSERT INTO `npc_list` VALUES ('16994332', 'Jajaroon', '183', '-13.645', '0.000', '29.120', '7', '40', '40', '0', '0', '0', '0', '27', 0x0000C80600000000000000000000000000000000, '32', '53'); INSERT INTO `npc_list` VALUES ('16994333', 'Jijiroon', '74', '15.913', '0.000', '-32.676', '21', '40', '40', '0', '0', '0', '0', '27', 0x0000C80600000000000000000000000000000000, '32', '53'); @@ -10767,7 +10770,6 @@ INSERT INTO `npc_list` VALUES ('17514554', 'qm1', '185', '-540.000', '-257.000', '-66.800', '1', '40', '40', '0', '0', '0', '0', '3', 0x0000340000000000000000000000000000000000, '0', '180'); INSERT INTO `npc_list` VALUES ('17514555', 'qm1', '185', '499.000', '-332.000', '-43.800', '1', '40', '40', '0', '0', '0', '0', '3', 0x0000340000000000000000000000000000000000, '0', '180'); INSERT INTO `npc_list` VALUES ('17514576', 'Cermet_Door', '0', '13.000', '13.000', '13.000', '1', '40', '40', '0', '0', '0', '0', '3', 0x0000340000000000000000000000000000000000, '0', '180'); - INSERT INTO `npc_list` VALUES ('17514548', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000980500000000000000000000000000000000, '32', '180'); INSERT INTO `npc_list` VALUES ('17514549', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000970500000000000000000000000000000000, '32', '180'); INSERT INTO `npc_list` VALUES ('17514550', 'CrystalKnight', '0', '0.000', '0.000', '0.000', '0', '40', '40', '0', '0', '0', '6', '27', 0x0000990500000000000000000000000000000000, '32', '180'); Index: sql/transport.sql =================================================================== --- sql/transport.sql (revision 2503) +++ sql/transport.sql (working copy) @@ -1,65 +1,70 @@ --- phpMyAdmin SQL Dump --- version 3.3.8 --- http://www.phpmyadmin.net --- --- Serveur: localhost --- Généré le : Dim 01 Avril 2012 à 13:05 --- Version du serveur: 6.0.0 --- Version de PHP: 5.2.9-2 - -SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; - - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; - --- --- Base de données: `dspdb` --- - --- -------------------------------------------------------- - --- --- Structure de la table `transport` --- - -DROP TABLE IF EXISTS `transport`; -CREATE TABLE IF NOT EXISTS `transport` ( - `id` tinyint(3) unsigned NOT NULL, - `name` tinytext NOT NULL, - `transport` int(10) unsigned NOT NULL DEFAULT '0', - `door` int(10) unsigned NOT NULL DEFAULT '0', - `dock_x` float(7,3) NOT NULL DEFAULT '0.000', - `dock_y` float(7,3) NOT NULL DEFAULT '0.000', - `dock_z` float(7,3) NOT NULL DEFAULT '0.000', - `dock_rot` tinyint(3) unsigned NOT NULL DEFAULT '0', - `boundary` smallint(5) unsigned NOT NULL DEFAULT '0', - `anim_arrive` tinyint(3) unsigned NOT NULL DEFAULT '0', - `anim_depart` tinyint(3) unsigned NOT NULL DEFAULT '0', - `time_offset` smallint(5) unsigned NOT NULL DEFAULT '0', - `time_interval` smallint(5) unsigned NOT NULL DEFAULT '0', - `time_anim_arrive` tinyint(3) unsigned NOT NULL DEFAULT '0', - `time_waiting` smallint(5) unsigned NOT NULL DEFAULT '0', - `time_anim_depart` tinyint(3) unsigned NOT NULL DEFAULT '0', - `zone` tinyint(3) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- --- Contenu de la table `transport` --- - -INSERT INTO `transport` VALUES(1, 'Kazham-Jeuno_Airship', 17801316, 17801315, -4.000, -3.497, 32.125, 128, 512, 18, 19, 90, 360, 20, 50, 20, 226); -INSERT INTO `transport` VALUES(2, 'Jeuno-Kazham_Airship', 17784932, 17784931, -4.000, 10.450, 117.000, 64, 477, 24, 25, 270, 360, 20, 50, 20, 226); -INSERT INTO `transport` VALUES(3, 'Jeuno-Sandoria_Airship', 17784932, 17784928, -68.000, 10.450, 117.000, 64, 474, 18, 19, 0, 360, 12, 60, 12, 223); -INSERT INTO `transport` VALUES(4, 'Jeuno-Windurst_Airship', 17784932, 17784930, -6.000, 10.450, -117.000, 192, 476, 22, 23, 90, 360, 12, 60, 12, 225); -INSERT INTO `transport` VALUES(5, 'Jeuno-Bastok_Airship', 17784932, 17784929, -70.000, 10.450, -117.000, 192, 475, 20, 21, 180, 360, 12, 60, 16, 224); -INSERT INTO `transport` VALUES(6, 'Sandoria-Jeuno_Airship', 17727594, 17727591, 20.000, -2.000, 44.000, 64, 369, 18, 19, 180, 360, 12, 60, 16, 223); -INSERT INTO `transport` VALUES(7, 'Windurst-Jeuno_Airship', 17760416, 17760415, 242.281, -3.522, 61.994, 96, 416, 18, 19, 270, 360, 18, 60, 14, 225); -INSERT INTO `transport` VALUES(8, 'Bastok-Jeuno_Airship', 17743967, 17743961, -36.458, 6.365, -77.322, 128, 315, 18, 19, 0, 360, 14, 60, 16, 224); -INSERT INTO `transport` VALUES(9, 'Selbina-Mhaura_Boat', 17793084, 17793083, 9.294, 0.000, -69.775, 0, 485, 18, 19, 382, 480, 18, 80, 16, 220); -INSERT INTO `transport` VALUES(10, 'Mhaura-Selbina_Boat', 17797178, 17797177, -0.516, 0.003, -8.409, 0, 493, 18, 19, 382, 480, 18, 80, 16, 221); -INSERT INTO `transport` VALUES(11, 'Mhaura-Whitegate_Boat', 17797178, 17797177, -0.516, 0.003, -8.409, 0, 493, 18, 19, 142, 480, 18, 80, 16, 47); -INSERT INTO `transport` VALUES(12, 'Whitegate-Mhaura_Boat', 16982041, 16982039, -20.726, 3.389, -154.231, 0, 569, 18, 19, 142, 480, 18, 80, 16, 46); +-- phpMyAdmin SQL Dump +-- version 3.3.8 +-- http://www.phpmyadmin.net +-- +-- Serveur: localhost +-- Généré le : Dim 01 Avril 2012 à 13:05 +-- Version du serveur: 6.0.0 +-- Version de PHP: 5.2.9-2 + +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; + + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; + +-- +-- Base de données: `dspdb` +-- + +-- -------------------------------------------------------- + +-- +-- Structure de la table `transport` +-- + +DROP TABLE IF EXISTS `transport`; +CREATE TABLE IF NOT EXISTS `transport` ( + `id` tinyint(3) unsigned NOT NULL, + `name` tinytext NOT NULL, + `transport` int(10) unsigned NOT NULL DEFAULT '0', + `door` int(10) unsigned NOT NULL DEFAULT '0', + `dock_x` float(7,3) NOT NULL DEFAULT '0.000', + `dock_y` float(7,3) NOT NULL DEFAULT '0.000', + `dock_z` float(7,3) NOT NULL DEFAULT '0.000', + `dock_rot` tinyint(3) unsigned NOT NULL DEFAULT '0', + `boundary` smallint(5) unsigned NOT NULL DEFAULT '0', + `anim_arrive` tinyint(3) unsigned NOT NULL DEFAULT '0', + `anim_depart` tinyint(3) unsigned NOT NULL DEFAULT '0', + `time_offset` smallint(5) unsigned NOT NULL DEFAULT '0', + `time_interval` smallint(5) unsigned NOT NULL DEFAULT '0', + `time_anim_arrive` tinyint(3) unsigned NOT NULL DEFAULT '0', + `time_waiting` smallint(5) unsigned NOT NULL DEFAULT '0', + `time_anim_depart` tinyint(3) unsigned NOT NULL DEFAULT '0', + `zone` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Contenu de la table `transport` +-- + +INSERT INTO `transport` VALUES(1, 'Kazham-Jeuno_Airship', 17801316, 17801315, -4.000, -3.497, 32.125, 128, 512, 18, 19, 90, 360, 20, 50, 20, 226); +INSERT INTO `transport` VALUES(2, 'Jeuno-Kazham_Airship', 17784932, 17784931, -4.000, 10.450, 117.000, 64, 477, 24, 25, 270, 360, 20, 50, 20, 226); +INSERT INTO `transport` VALUES(3, 'Jeuno-Sandoria_Airship', 17784932, 17784928, -68.000, 10.450, 117.000, 64, 474, 18, 19, 0, 360, 12, 60, 12, 223); +INSERT INTO `transport` VALUES(4, 'Jeuno-Windurst_Airship', 17784932, 17784930, -6.000, 10.450, -117.000, 192, 476, 22, 23, 90, 360, 12, 60, 12, 225); +INSERT INTO `transport` VALUES(5, 'Jeuno-Bastok_Airship', 17784932, 17784929, -70.000, 10.450, -117.000, 192, 475, 20, 21, 180, 360, 12, 60, 16, 224); +INSERT INTO `transport` VALUES(6, 'Sandoria-Jeuno_Airship', 17727594, 17727591, 20.000, -2.000, 44.000, 64, 369, 18, 19, 180, 360, 12, 60, 16, 223); +INSERT INTO `transport` VALUES(7, 'Windurst-Jeuno_Airship', 17760416, 17760415, 242.281, -3.522, 61.994, 96, 416, 18, 19, 270, 360, 18, 60, 14, 225); +INSERT INTO `transport` VALUES(8, 'Bastok-Jeuno_Airship', 17743967, 17743961, -36.458, 6.365, -77.322, 128, 315, 18, 19, 0, 360, 14, 60, 16, 224); +INSERT INTO `transport` VALUES(9, 'Selbina-Mhaura_Boat', 17793084, 17793083, 9.294, 0.000, -69.775, 0, 485, 18, 19, 0, 434, 18, 83, 18, 220); +INSERT INTO `transport` VALUES(10, 'Mhaura-Selbina_Boat', 17797178, 17797177, -0.516, 0.003, -8.409, 0, 493, 18, 19, 0, 434, 18, 83, 18, 221); +INSERT INTO `transport` VALUES(11, 'Mhaura-Whitegate_Boat', 17797178, 17797177, -0.516, 0.003, -8.409, 0, 493, 18, 19, 300, 434, 18, 83, 18, 46); +INSERT INTO `transport` VALUES(12, 'Whitegate-Mhaura_Boat', 16982041, 16982039, -20.726, 3.389, -154.231, 0, 569, 18, 19, 300, 434, 18, 83, 18, 47); +INSERT INTO `transport` VALUES(13, 'Whitegate-Nashmau_Boat', 16982041, 16982040, 20.726, 3.389, 154.231, 128, 570, 20, 21, 0, 434, 18, 83, 18, 58); +INSERT INTO `transport` VALUES(14, 'Nashmau-Whitegate_Boat', 16994322, 16994321, 3.24, 3.389, -114.221, 0, 571, 22, 23, 0, 434, 18, 83, 18, 59); +INSERT INTO `transport` VALUES(15, 'Manaclip_PUR_BIBI', 16793907, 16793908, 491.5, 0, 687.4, 128, 0, 18, 19, 0, 434, 20, 80, 20, 3); +INSERT INTO `transport` VALUES(16, 'MANA_BIBI_PUR', 16793907, 16793909, -392, 0, -364, 128, 0, 20, 21, 300, 434, 20, 80, 20, 3); +