API tools faq
paste
Guest User

yapeal starbasedetail summary

a guest
Aug 15th, 2014
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.07 KB | None | 0 0
raw download clone embed print report
  1. //Logfile
  2. ---------------
  3. [2014-08-15 23:45:41] yapeal.DEBUG: Starting autoMagic for Corp/StarbaseDetail [] []
  4. [2014-08-15 23:45:41] yapeal.DEBUG: Starting autoMagic for Corp/StarbaseList [] []
  5. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT ac."corporationID",urk."keyID",urk."vCode" FROM "evedb"."yp2_accountKeyBridge" AS akb JOIN "evedb"."yp2_accountAPIKeyInfo" AS aaki ON (akb."keyID" = aaki."keyID") JOIN "evedb"."yp2_utilRegisteredKey" AS urk ON (akb."keyID" = urk."keyID") JOIN "evedb"."yp2_accountCharacters" AS ac ON (akb."characterID" = ac."characterID") WHERE aaki."type" = 'Corporation' AND urk."isActive"=1 AND (urk."activeAPIMask" & aaki."accessMask" & 524288) <> 0 [] []
  6. [2014-08-15 23:45:41] yapeal.DEBUG: Checking if cache expired on table corpStarbaseList for ownerID = 98067338 [] []
  7. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseList' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  8. [2014-08-15 23:45:41] yapeal.DEBUG: Checking if cache expired on table corpStarbaseList for ownerID = 98300065 [] []
  9. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseList' AND "sectionName" = 'Corp' AND "ownerID" = 98300065 [] []
  10. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT sl."itemID",ac."corporationID",urk."keyID",urk."vCode" FROM "evedb"."yp2_accountKeyBridge" AS akb JOIN "evedb"."yp2_accountAPIKeyInfo" AS aaki ON (akb."keyID" = aaki."keyID") JOIN "evedb"."yp2_utilRegisteredKey" AS urk ON (akb."keyID" = urk."keyID") JOIN "evedb"."yp2_accountCharacters" AS ac ON (akb."characterID" = ac."characterID") JOIN "evedb"."yp2_corpStarbaseList" AS sl ON (ac."corporationID" = sl."ownerID") WHERE aaki."type" = 'Corporation' AND urk."isActive"=1 AND (urk."activeAPIMask" & aaki."accessMask" & 131072) <> 0 [] []
  11. [2014-08-15 23:45:41] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  12. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  13. [2014-08-15 23:45:41] yapeal.DEBUG: No UtilCachedUntil record found [] []
  14. [2014-08-15 23:45:41] yapeal.INFO: select get_lock('fe93c8701732cbc1f6aef0f0db132e83',5) [] []
  15. [2014-08-15 23:45:41] yapeal.DEBUG: Started filesystem retrieve for corp/StarbaseDetail [] []
  16. [2014-08-15 23:45:41] yapeal.DEBUG: Could NOT get XML data {"exception":"[object] (Yapeal\\Exception\\YapealRetrieverFileException: Could NOT find accessible cache file was given /htdocs/eve/yapealneu/cache/corp/StarbaseDetailfe93c8701732cbc1f6aef0f0db132e83.xml at /htdocs/eve/yapealneu/lib/Xml/FileCacheRetriever.php:146)"} []
  17. [2014-08-15 23:45:41] yapeal.DEBUG: Started network retrieve for corp/StarbaseDetail [] []
  18. [2014-08-15 23:45:41] yapeal.DEBUG: Started XSD validating [] []
  19. [2014-08-15 23:45:41] yapeal.DEBUG: state => 1 [] []
  20. [2014-08-15 23:45:41] yapeal.DEBUG: stateTimestamp => 2013-09-24 13:04:48 [] []
  21. [2014-08-15 23:45:41] yapeal.DEBUG: onlineTimestamp => 0001-01-01 00:00:00 [] []
  22. [2014-08-15 23:45:41] yapeal.INFO: Have 1 row(s) to upsert into corpStarbaseDetail table [] []
  23. [2014-08-15 23:45:41] yapeal.INFO: INSERT INTO "evedb"."yp2_corpStarbaseDetail" ("ownerID","itemID","onlineTimestamp","state","stateTimestamp") VALUES (?,?,?,?,?) ON DUPLICATE KEY UPDATE "ownerID"=values("ownerID"),"itemID"=values("itemID"),"onlineTimestamp"=values("onlineTimestamp"),"state"=values("state"),"stateTimestamp"=values("stateTimestamp") [] []
  24. [2014-08-15 23:45:41] yapeal.DEBUG: 98067338,1004057602236,0001-01-01 00:00:00,1,2013-09-24 13:04:48 [] []
  25. [2014-08-15 23:45:41] yapeal.INFO: Have 2 row(s) to upsert into corpFuel table [] []
  26. [2014-08-15 23:45:41] yapeal.INFO: INSERT INTO "evedb"."yp2_corpFuel" ("ownerID","itemID","typeID","quantity") VALUES (?,?,?,?),... ON DUPLICATE KEY UPDATE "ownerID"=values("ownerID"),"itemID"=values("itemID"),"typeID"=values("typeID"),"quantity"=values("quantity") [] []
  27. [2014-08-15 23:45:41] yapeal.DEBUG: 98067338,1004057602236,16275,8333,98067338,1004057602236,4312,174 [] []
  28. [2014-08-15 23:45:41] yapeal.INFO: Have 1 row(s) to upsert into corpCombatSettings table [] []
  29. [2014-08-15 23:45:41] yapeal.INFO: INSERT INTO "evedb"."yp2_corpCombatSettings" ("ownerID","itemID","onAggressionEnabled","onCorporationWarEnabled","onStandingDropStanding","onStatusDropEnabled","onStatusDropStanding","useStandingsFromOwnerID") VALUES (?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE "ownerID"=values("ownerID"),"itemID"=values("itemID"),"onAggressionEnabled"=values("onAggressionEnabled"),"onCorporationWarEnabled"=values("onCorporationWarEnabled"),"onStandingDropStanding"=values("onStandingDropStanding"),"onStatusDropEnabled"=values("onStatusDropEnabled"),"onStatusDropStanding"=values("onStatusDropStanding"),"useStandingsFromOwnerID"=values("useStandingsFromOwnerID") [] []
  30. [2014-08-15 23:45:41] yapeal.DEBUG: 98067338,1004057602236,0,1,490,1,0,99001323 [] []
  31. [2014-08-15 23:45:41] yapeal.INFO: Have 1 row(s) to upsert into corpGeneralSettings table [] []
  32. [2014-08-15 23:45:41] yapeal.INFO: INSERT INTO "evedb"."yp2_corpGeneralSettings" ("ownerID","itemID","usageFlags","deployFlags","allowCorporationMembers","allowAllianceMembers") VALUES (?,?,?,?,?,?) ON DUPLICATE KEY UPDATE "ownerID"=values("ownerID"),"itemID"=values("itemID"),"usageFlags"=values("usageFlags"),"deployFlags"=values("deployFlags"),"allowCorporationMembers"=values("allowCorporationMembers"),"allowAllianceMembers"=values("allowAllianceMembers") [] []
  33. [2014-08-15 23:45:41] yapeal.DEBUG: 98067338,1004057602236,3,0,1,1 [] []
  34. [2014-08-15 23:45:41] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  35. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  36. [2014-08-15 23:45:41] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  37. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  38. [2014-08-15 23:45:41] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  39. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  40. [2014-08-15 23:45:41] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  41. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  42. [2014-08-15 23:45:41] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  43. [2014-08-15 23:45:41] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  44. [2014-08-15 23:45:41] yapeal.DEBUG: Starting autoMagic for Char/SkillQueue [] []
  45.  
  46. //Original xml manually fetched with the same keyID/vcode and for Starbase itemID=1015376388319
  47. ---------------------------------------
  48. <eveapi version="2">
  49. <currentTime>2014-08-15 21:52:24</currentTime>
  50. <result>
  51. <state>4</state>
  52. <stateTimestamp>2014-08-15 21:51:51</stateTimestamp>
  53. <onlineTimestamp>2014-07-22 11:51:27</onlineTimestamp>
  54. <generalSettings>
  55. <usageFlags>3</usageFlags>
  56. <deployFlags>0</deployFlags>
  57. <allowCorporationMembers>1</allowCorporationMembers>
  58. <allowAllianceMembers>1</allowAllianceMembers>
  59. </generalSettings>
  60. <combatSettings>
  61. <useStandingsFrom ownerID="98067338"/>
  62. <onStandingDrop standing="0"/>
  63. <onStatusDrop enabled="0" standing="0"/>
  64. <onAggression enabled="0"/>
  65. <onCorporationWar enabled="0"/>
  66. </combatSettings>
  67. <rowset name="fuel" key="typeID" columns="typeID,quantity">
  68. <row typeID="4051" quantity="10007"/>
  69. <row typeID="16275" quantity="8333"/>
  70. <row typeID="24592" quantity="3413"/>
  71. </rowset>
  72. </result>
  73. <cachedUntil>2014-08-15 21:57:11</cachedUntil>
  74. </eveapi>
  75.  
  76. StarbaseList table from db
  77. --------------------------------
  78. "ownerID","itemID","locationID","moonID","onlineTimestamp","standingOwnerID","state","stateTimestamp","typeID"
  79. "98067338","1004057602236","31000274","40365173","0001-01-01 00:00:00","99001323","1","2013-09-24 13:04:48","20063"
  80. "98067338","1009916983156","30005082","40321639","0001-01-01 00:00:00","98067338","1","2014-06-26 12:56:47","20061"
  81. "98067338","1009916985195","30003532","40224146","0001-01-01 00:00:00","98067338","1","2013-03-23 21:43:50","16213"
  82. "98067338","1015376387594","30005054","40319976","0001-01-01 00:00:00","98067338","1","2014-07-22 11:24:08","20062"
  83. "98067338","1015376388319","30005054","40319975","2014-07-22 11:51:27","98067338","4","2014-08-15 21:51:51","20061"
  84. "98067338","1015415243221","30005054","40319978","0001-01-01 00:00:00","98067338","1","2014-07-22 11:35:13","20062"
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!