EnglishGermanFrenchRussianPolishItalianSpanish
Log inRegister
 
[Docn] AP Steam patches Documentation (v3.2 cat 04)
Post new topic Reply to topic Goto page Previous  1, 2, 3  Next
View previous topic :: View next topic
Author Message
apricotslice





Joined: 16 May 2004
Posts: 13627 on topic
Location: In the Hunter Legacy Universe
Thank you for registering your game
PostPosted: Fri, 13. Jul 12, 09:55    Post subject: Reply with quote Print

Does that mean the hotkey issue was in the L\ obj files ?


_________________
Apricot Mapping Services HQ
CLICK HERE for X3 Handbook; TC and AP Guides, Mods, Scripts & Downloads
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Cycrow
Moderator (Script&Mod)
Moderator (Script&Mod)



Joined: 15 Nov 2004
Posts: 20429 on topic
Location: London
Thank you for registering your game
PostPosted: Fri, 13. Jul 12, 12:40    Post subject: Reply with quote Print

it was yes


_________________
My Scripts | MY X3TC Scripts | X3 Plugin Manager | Custom Gui
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
X2-Illuminatus
Moderator (Deutsch)
Moderator (Deutsch)

MEDALMEDALMEDAL

Joined: 02 Apr 2006
Posts: 19918 on topic

Thank you for registering your game
PostPosted: Tue, 24. Jul 12, 22:48    Post subject: Reply with quote Print

A new update: version 2.5

Reuses cat/dat number 3.

Changed:
    addon\03.cat/dat
    addon\scripts\!fight.war.attackplayer.pck
    addon\scripts\!fight.war.protectsector.pck
    addon\scripts\!move.jumptogate.nearest.pck
    addon\scripts\!ship.cmd.freightransfer.pre.pck
    addon\scripts\plugin.rrf.count.enemies.pck
    addon\scripts\plugin.rrf.fight.attack.wing.pck
    addon\scripts\plugin.rrf.fire.missile.pck
    addon\scripts\plugin.rrf.jump.global.pck
    addon\scripts\plugin.rrf.m8.logic.pck
    addon\scripts\plugin.rrf.monitor.4.signal.pck
    addon\scripts\plugin.rrf.patrol.pck
    addon\scripts\plugin.rrf.repair.restock.pck
    addon\scripts\plugin.rrf.stock.m8.pck
    addon\scripts\plugin.rrf.ufo.pickup1.pck
    addon\x3files.xml
    addon\t\0002*.pck
    addon\Documents\*.txt

Added/changed in 03.cat:
    addon\director\2.022 Albion Prelude Terran Plot.pck
    addon\director\3.02 Plot Missions.pck
    addon\director\mdfiles.pck
    addon\director\start.pck
    addon\director\U.16 Follow Anxiety MaxRange.pck
    addon\director\images\AP_Earth_Torus.tga
    addon\maps\WareTemplate.pck
    addon\t\0001-L*.pck
    addon\t\0003-L086.pck
    addon\t\0003-L088.pck
    addon\t\conversations.pck
    addon\types\gamestarts.pck
    addon\types\hq.pck
    addon\types\Jobs.pck
    addon\types\TDocks.pck
    addon\types\TShips.pck
    L\x3config.obj
    L\x3galedit.obj
    L\x3intro.obj
    L\x3story.obj
    objects\stations\Cadius\USC\Headquarters_Scene.pbd
    objects\stations\Cadius\USC\Headquarters\bottom.pbb
    objects\stations\Cadius\USC\Headquarters\docking_moor_bottom.pbb
    objects\stations\Cadius\USC\Headquarters\docking_moor_top.pbb
    objects\stations\Cadius\USC\Headquarters\solar_panels.pbb
    objects\stations\Cadius\USC\Headquarters\top.pbb

The X3AP-NoSteam.exe can still be used.


_________________
Ab sofort verfügbar: Farnhams Legende und Nopileos als E-Books!

"People who think they know everything are a great annoyance to those of us who do." - Isaac Asimov
Back to top
View user's profile Send private message Visit poster's website
apricotslice





Joined: 16 May 2004
Posts: 13627 on topic
Location: In the Hunter Legacy Universe
Thank you for registering your game
PostPosted: Wed, 25. Jul 12, 02:33    Post subject: Reply with quote Print

Anyone know what they changed in tships and hq ? Also gamestarts.

Obviously they added a dock, but are the ship and hq changes cosmetic, or did they add new ships or functions to the hq ?

Just trying to get a sense of the urgency of needing to upgrade mods.


_________________
Apricot Mapping Services HQ
CLICK HERE for X3 Handbook; TC and AP Guides, Mods, Scripts & Downloads
Back to top
View user's profile Send private message Send e-mail Visit poster's website
kurush



MEDALMEDALMEDAL

Joined: 07 Nov 2005
Posts: 3950 on topic

Thank you for registering your game
PostPosted: Wed, 25. Jul 12, 04:19    Post subject: Reply with quote Print

apricotslice wrote:
Anyone know what they changed in tships and hq ? Also gamestarts.

Obviously they added a dock, but are the ship and hq changes cosmetic, or did they add new ships or functions to the hq ?

Just trying to get a sense of the urgency of needing to upgrade mods.

The hq.xml apparently has a new section for the terran HQ that now has whooping 700000 storage units vs 500000 in the commonwealth PHQ.

In TShips it seems to be only Boron M8 change mentioned in the readme.

Back to top
View user's profile Send private message
X2-Illuminatus
Moderator (Deutsch)
Moderator (Deutsch)

MEDALMEDALMEDAL

Joined: 02 Apr 2006
Posts: 19918 on topic

Thank you for registering your game
PostPosted: Fri, 3. Aug 12, 20:11    Post subject: Reply with quote Print

A small hotfix: 2.5 -> 2.5.1

Reuses 03.cat/dat.

Added/changed:
    addon\scripts\!lib.mtc.buysell.pck
    addon\scripts\!patch.rrf.2.51.pck
    addon\scripts\plugin.rrf.fire.missile.pck
    addon\scripts\plugin.rrf.monitor.4.sig.handler.pck
    addon\scripts\plugin.rrf.repair.restock.pck
    addon\scripts\plugin.rrf.volley.pck

Added/changed in 03.cat:
    addon\director\2.022 Albion Prelude Terran Plot.pck
    addon\t\0001-L033.pck
    addon\t\0001-L039.pck
    addon\t\0001-L049.pck
    addon\types\TDocks.pck
    L\*.obj

The NoSteam.exe can still be used.


_________________
Ab sofort verfügbar: Farnhams Legende und Nopileos als E-Books!

"People who think they know everything are a great annoyance to those of us who do." - Isaac Asimov
Back to top
View user's profile Send private message Visit poster's website
apricotslice





Joined: 16 May 2004
Posts: 13627 on topic
Location: In the Hunter Legacy Universe
Thank you for registering your game
PostPosted: Sat, 4. Aug 12, 08:25    Post subject: Reply with quote Print

Thanks for that. Smile

Updated in OP.

Does anyone know what was changed in tships in the patch before last ? I havent had the opportunity to check myself.


_________________
Apricot Mapping Services HQ
CLICK HERE for X3 Handbook; TC and AP Guides, Mods, Scripts & Downloads
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Yacek



MEDALMEDAL

Joined: 18 Jul 2007
Posts: 3157 on topic
Location: Kraków
Thank you for registering your game
PostPosted: Sat, 4. Aug 12, 11:13    Post subject: Reply with quote Print

apricotslice wrote:
Does anyone know what was changed in tships in the patch before last ? I havent had the opportunity to check myself.


http://forum.egosoft.com/viewtopic.php?p=3921546#3921546

- Fixed Marlin cargo bay size


_________________
X3:AP 3.1+XRM 1.30d+MSP 1.7+LoCo 2.01+IR 2.0
Zapraszamy wszystkich chêtnych na forum XUDB, gdzie znajdziesz FAQ, opisy skryptów, modów i fabu³, oraz Mamut HQ.
Back to top
View user's profile Send private message
apricotslice





Joined: 16 May 2004
Posts: 13627 on topic
Location: In the Hunter Legacy Universe
Thank you for registering your game
PostPosted: Sat, 4. Aug 12, 11:20    Post subject: Reply with quote Print

Thanks. No biggie for most ship mods then.


_________________
Apricot Mapping Services HQ
CLICK HERE for X3 Handbook; TC and AP Guides, Mods, Scripts & Downloads
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Playbahnosh





Joined: 25 Mar 2009
Posts: 754 on topic

Thank you for registering your game
PostPosted: Sat, 4. Aug 12, 11:42    Post subject: Reply with quote Print

This seems really useful! Maybe sticky this? Or add it to one of the stickies?


_________________
___________________________________
Back to top
View user's profile Send private message
apricotslice





Joined: 16 May 2004
Posts: 13627 on topic
Location: In the Hunter Legacy Universe
Thank you for registering your game
PostPosted: Sat, 4. Aug 12, 11:56    Post subject: Reply with quote Print

It was added to the guides sticky for listing. I'm unsure if it ever was though.


_________________
Apricot Mapping Services HQ
CLICK HERE for X3 Handbook; TC and AP Guides, Mods, Scripts & Downloads
Back to top
View user's profile Send private message Send e-mail Visit poster's website
X2-Illuminatus
Moderator (Deutsch)
Moderator (Deutsch)

MEDALMEDALMEDAL

Joined: 02 Apr 2006
Posts: 19918 on topic

Thank you for registering your game
PostPosted: Thu, 29. Nov 12, 19:55    Post subject: Reply with quote Print

A small hotfix: 2.5.1 -> 2.5.2

Reuses 03.cat/dat.

Added/changed:
addon\scripts\!fight.war.protectsector.pck

addon\t\002.pck
addon\t\002-L007.pck
addon\t\002-L033.pck
addon\t\002-L034.pck
addon\t\002-L039.pck
addon\t\002-L042.pck
addon\t\002-L048.pck
addon\t\002-L049.pck
addon\t\002-L081.pck
addon\t\002-L086.pck
addon\t\002-L088.pck

addon\x3files.xml

Added/changed in 03.cat:
L\*.obj
L\true\LoadScrHD-L007.jpg (added)
t\0001-L007.pck
t\0001-L086.pck (removed)
t\0001-L088.pck (removed)

The NoSteam.exe can still be used, with the exception of a minor linebreak issue in Chinese and Japanese releases.


_________________
Ab sofort verfügbar: Farnhams Legende und Nopileos als E-Books!

"People who think they know everything are a great annoyance to those of us who do." - Isaac Asimov
Back to top
View user's profile Send private message Visit poster's website
Snickly





Joined: 05 Nov 2004
Posts: 139 on topic
Location: South Germany
Thank you for registering your game
PostPosted: Tue, 4. Dec 12, 11:53    Post subject: Update Reply with quote Print

Thanks X2-Illuminatus Smile


_________________
Snickly -signing off
Back to top
View user's profile Send private message
X2-Illuminatus
Moderator (Deutsch)
Moderator (Deutsch)

MEDALMEDALMEDAL

Joined: 02 Apr 2006
Posts: 19918 on topic

Thank you for registering your game
PostPosted: Tue, 22. Jan 13, 23:58    Post subject: Reply with quote Print

A small hotfix: 2.5.2 -> 2.5.3

Reuses 03.cat/dat.

Added/changed:
addon\scripts\plugin.rrf.patrol.pck
addon\t\002*.pck
addon\x3files.xml

Added/changed in 03.cat:
L\*.obj

The NoSteam.exe can still be used, with the exception of a minor linebreak issue in Chinese and Japanese releases.


_________________
Ab sofort verfügbar: Farnhams Legende und Nopileos als E-Books!

"People who think they know everything are a great annoyance to those of us who do." - Isaac Asimov
Back to top
View user's profile Send private message Visit poster's website
X2-Illuminatus
Moderator (Deutsch)
Moderator (Deutsch)

MEDALMEDALMEDAL

Joined: 02 Apr 2006
Posts: 19918 on topic

Thank you for registering your game
PostPosted: Thu, 16. May 13, 14:25    Post subject: Reply with quote Print

A new update: Version 3.0.

Reuses 03.cat/dat.

Added/changed:
  • Changed
      addon\Documents\Changelog_xx.txt

      addon\scripts\!job.trade.iceminer.pck
      addon\scripts\plugin.rrf.stock.m8.pck
      addon\scripts\plugin.st.ex.Nat.wares.pck

      addon\t\0002-****.pck

  • Added
      addon\scripts\al.plugin.bw.detector.event.pck
      addon\scripts\plugin.bw.detector.detect.ship.pck
      addon\scripts\plugin.bw.detector.detect.ware.pck
      addon\scripts\plugin.bw.detector.fwd.project.pck
      addon\scripts\plugin.bw.detector.mute.pck
      addon\scripts\plugin.bw.detector.start.pck
      addon\scripts\plugin.bw.detector.stop.pck
      addon\scripts\plugin.mini.game.anagram.create.full.scramble.pck
      addon\scripts\plugin.mini.game.anagram.create.pck
      addon\scripts\plugin.mini.game.cipher.pck
      addon\scripts\plugin.mini.game.decrypt.pck
      addon\scripts\plugin.mini.game.find.password.menu.loop.pck
      addon\scripts\plugin.mini.game.find.password.pck
      addon\scripts\plugin.mini.game.lower.case.pck
      addon\scripts\plugin.mini.game.messagebox.pck
      addon\scripts\plugin.mini.game.pck
      addon\scripts\plugin.mini.game.string.tokenize.pck
      addon\scripts\setup.plugin.mini.game.pck

      soundtrack\08700.mp3

Added/changed in 03.cat/dat:
  • Changed:
      addon\director\2.022 Albion Prelude Terran Plot.pck
      addon\director\3.02 Plot Missions.pck
      addon\director\mdfiles.pck
      addon\director\start.pck

      addon\maps\WareTemplate.pck

      addon\t\0001-L007.pck
      addon\t\0001-L033.pck
      addon\t\0001-L034.pck
      addon\t\0001-L039.pck
      addon\t\0001-L044.pck
      addon\t\0001-L048.pck
      addon\t\0001-L049.pck
      addon\t\conversations.pck

      addon\types\gamestarts.pck
      addon\types\Jobs.pck
      addon\types\TShips.pck

      L\x3config.obj
      L\x3galedit.obj
      L\x3intro.obj
      L\x3story.obj

  • Added:
      addon\cutscenes\L2M024_Cut1.pck

      addon\director\0.1 Assassinate 1.pck
      addon\director\0.13 Follow Ship.pck
      addon\director\0.22 Build Stations.pck
      addon\director\0.24 Deploy Objects.pck
      addon\director\0.3 Transport Passenger.pck
      addon\director\0.35 Defend Object.pck
      addon\director\0.4 Return Wares.pck
      addon\director\0.8 Battle Enemy Ships.pck
      addon\director\0.80 Repair Station.pck
      addon\director\0.81 Multiple Transport.pck
      addon\director\0.82 Tour Of A Lifetime.pck
      addon\director\0.83 Dual Convoy.pck
      addon\director\2.020 Albion Prelude HUB Plot.pck
      addon\director\2.023 Shady Business.pck
      addon\director\2.024 Player Corp.pck
      addon\director\2.119 Trade Convoy.pck
      addon\director\2.129 Deliver Matching Ship.pck
      addon\director\2.134 Generic Patrol.pck
      addon\director\2.180 Repair Station.pck
      addon\director\2.181 Multiple Transport.pck
      addon\director\2.182 Tour Of A Lifetime.pck
      addon\director\2.183 Dual Convoy.pck
      addon\director\3.01 Generic Missions.pck
      addon\director\3.08 Sector Management.pck
      addon\director\director.xsd
      addon\director\dirobjdb.xsd
      addon\director\DSG.pck
      addon\director\images
      addon\director\OBS.pck
      addon\director\SRST.pck
      addon\director\StockExchange.pck
      addon\director\U.183 Raiding Parties.pck
      addon\director\U.184 Xenon Invasions.pck

      addon\director\images\cp_argon_sx.tga
      addon\director\images\cp_atreus_hq.tga
      addon\director\images\cp_boron_sx_1.tga
      addon\director\images\cp_broken_gate.tga
      addon\director\images\cp_dukes_hq.tga
      addon\director\images\cp_gate.tga
      addon\director\images\cp_neptune_ods.tga
      addon\director\images\cp_otas_hq.tga
      addon\director\images\cp_paranid_sx.tga
      addon\director\images\cp_split_sx_1.tga
      addon\director\images\cp_strong_arms_hq.tga
      addon\director\images\cp_teladi_sx.tga
      addon\director\images\cp_terracorp_hq.tga
      addon\director\images\cp_terran_sx_1.tga
      addon\director\images\EoL_Ozias_TPs.tga
      addon\director\images\FamilyPride_Dragon.tga
      addon\director\images\LostOrder_SplitTL.tga
      addon\director\images\Starburst_FR.tga
      addon\director\images\TP_Angel.tga
      addon\director\images\TP_Geochen.tga
      addon\director\images\TP_Hermes.tga
      addon\director\images\TP_Mani.tga
      addon\director\images\TP_Ocelot.tga
      addon\director\images\TP_Phantom.tga
      addon\director\images\UFJDSector_CPU_Wreck.tga

      addon\maps\2024_Player_Corp.pck
      addon\maps\APCP_ufjd.pck
      addon\maps\x3_universe_NOwar.pck

      addon\t\0003-L081.pck

      addon\types\Components.pck
      addon\types\Dummies.pck
      addon\types\TBackgrounds.pck
      addon\types\TCockpits.pck
      addon\types\TFactories.pck
      addon\types\TWareN.pck

      dds\game_over_diff-L081.pck
      dds\nebula_closeplanet_background_part_01_diff.pck
      dds\nebula_closeplanet_background_part_02_diff.pck
      dds\nebula_closeplanet_background_part_03_diff.pck
      dds\nebula_closeplanet_background_part_04_diff.pck
      dds\nebula_closeplanet_stars_orange_diff.pck
      dds\nebula_orangeblackhole_background_part_01_diff.pck
      dds\nebula_orangeblackhole_background_part_02_diff.pck
      dds\nebula_orangeblackhole_background_part_03_diff.pck
      dds\nebula_orangeblackhole_background_part_04_diff.pck
      dds\nebula_orangeblackhole_stars_orange_diff.pck
      dds\nebula_yellowrift_background_part_01_diff.pck
      dds\nebula_yellowrift_background_part_02_diff.pck
      dds\nebula_yellowrift_background_part_03_diff.pck
      dds\nebula_yellowrift_background_part_04_diff.pck
      dds\nebula_yellowrift_stars_orange_diff.pck
      dds\XTC_m6a_enginefx.dds.pck

      L\true\LoadScrBOT-L081.jpg
      L\true\LoadScrGAMEPAD-L007.tga
      L\true\LoadScrGAMEPAD-L033.tga
      L\true\LoadScrGAMEPAD-L034.tga
      L\true\LoadScrGAMEPAD-L039.tga
      L\true\LoadScrGAMEPAD-L042.tga
      L\true\LoadScrGAMEPAD-L048.tga
      L\true\LoadScrGAMEPAD-L049.tga
      L\true\LoadScrGAMEPAD-L086.tga
      L\true\LoadScrGAMEPAD-L088.tga
      L\true\LoadScrGAMEPAD.tga

      objects\cut\00749.pbd
      objects\effects\engines
      objects\effects\engines\fx_xtc_split_m6turbo_mid.pbd
      objects\effects\engines\fx_xtc_split_m6turbo_out.pbd
      objects\environments\nebulae
      objects\environments\nebulae\closeplanet
      objects\environments\nebulae\orangeblackhole
      objects\environments\nebulae\yellowrift
      objects\environments\nebulae\closeplanet\nebula_closeplanet_background_01.pbb
      objects\environments\nebulae\closeplanet\nebula_closeplanet_stars_01.pbb
      objects\environments\nebulae\orangeblackhole\nebula_orangeblackhole_background_01.pbb
      objects\environments\nebulae\orangeblackhole\nebula_orangeblackhole_stars_01.pbb
      objects\environments\nebulae\yellowrift\nebula_yellowrift_background_01.pbb
      objects\environments\nebulae\yellowrift\nebula_yellowrift_stars_01.pbb
      objects\ships\argon\XTC_argon_ts_plus.pbb
      objects\ships\argon\XTC_argon_ts_plus_scene.pbd
      objects\ships\props\KG_Split_GUN.pbb
      objects\ships\props\KG_Split_turret_body.pbb
      objects\ships\props\KG_Split_turret_body_1.pbb
      objects\ships\props\KG_Split_turret_body_2.pbb
      objects\ships\props\KG_Split_turret_body_3.pbb
      objects\ships\props\KG_Split_turret_dummy.pbb
      objects\ships\props\KG_Split_turret_dummy_1.pbb
      objects\ships\props\KG_Split_turret_dummy_2.pbb
      objects\ships\props\KG_Split_turret_dummy_3.pbb
      objects\ships\props\KG_Split_turret_frame.pbd
      objects\ships\props\KG_Split_turret_frame_1.pbb
      objects\ships\props\KG_Split_turret_frame_2.pbb
      objects\ships\props\KG_Split_turret_frame_3.pbb
      objects\ships\props\KG_Split_turret_Guns.pbb
      objects\ships\props\KG_Split_turret_Guns_1.pbb
      objects\ships\props\KG_Split_turret_Guns_2.pbb
      objects\ships\props\KG_Split_turret_Guns_3.pbb
      objects\ships\props\KG_Split_turret_Scene.pbd
      objects\ships\split\KG_Split_M2+.pbb
      objects\ships\split\KG_Split_M2+_1.pbb
      objects\ships\split\KG_Split_M2+_2.pbb
      objects\ships\split\KG_Split_M2+_3.pbb
      objects\ships\split\KG_Split_M2+_scene.pbd
      objects\ships\xtc\props\XTC_split_m6aturret_barrel1.pbb
      objects\ships\xtc\props\XTC_split_m6aturret_barrel1_scene.pbd
      objects\ships\xtc\props\XTC_split_m6aturret_barrel2.pbb
      objects\ships\xtc\props\XTC_split_m6aturret_barrel2_scene.pbd
      objects\ships\xtc\props\XTC_split_m6aturret_body.pbb
      objects\ships\xtc\props\XTC_split_m6aturret_dummy1.pbb
      objects\ships\xtc\props\XTC_split_m6aturret_dummy2.pbb
      objects\ships\xtc\props\XTC_split_m6a_gbarrel.pbb
      objects\ships\xtc\props\XTC_split_m6a_gdummy_l.pbb
      objects\ships\xtc\props\XTC_split_m6a_gdummy_r.pbb
      objects\ships\xtc\props\XTC_split_m6a_gscene_l_moving.pbd
      objects\ships\xtc\props\XTC_split_m6a_gscene_r_moving.pbd
      objects\ships\xtc\props\XTC_split_m6a_gscene_static.pbd
      objects\ships\xtc\split\XTC_split_m6turbo.pbb
      objects\ships\xtc\split\XTC_split_m6turbo_scene.pbd
      objects\ships\xtc\split\XTC_split_m6turbo_turb_l.pbb
      objects\ships\xtc\split\XTC_split_m6turbo_turb_r.pbb
      objects\stations\docks\M6dockCarrier_quicklaunch_body.pbb
      objects\stations\docks\M6dockCarrier_quicklaunch_doorlower.pbb
      objects\stations\docks\M6dockCarrier_quicklaunch_doorupper.pbb
      objects\stations\docks\M6dockCarrier_quicklaunch_scene.pbd
      objects\stations\x3ap\others\XTC_boron_EQD.pbb
      objects\stations\x3ap\others\XTC_boron_EQD_runner.pbb
      objects\stations\x3ap\scenes\argon_trading_station_stockmarket_scene.pbd

      tex\true\1125-L081.jpg


There is a new NoSteam.exe for version 3.0.


_________________
Ab sofort verfügbar: Farnhams Legende und Nopileos als E-Books!

"People who think they know everything are a great annoyance to those of us who do." - Isaac Asimov
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic Reply to topic Goto page Previous  1, 2, 3  Next
 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Control Panel
Login Data
The time now is Tue, 30. May 17, 09:16

All times are GMT + 2 Hours


Board Security

Copyright © EGOSOFT 1989-2017
Powered by phpBB © 2001, 2005 phpBB Group
Template created by Avatar & BurnIt!
Debug: page generation = 0.68640 seconds, sql queries = 29