API tools faq
paste
Advertisement
Guest User

yapeal starbasedetail

a guest
Aug 15th, 2014
63
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.59 KB | None | 0 0
raw download clone embed print report
  1. [2014-08-09 07:40:11] yapeal.DEBUG: Starting autoMagic for Corp/StarbaseDetail [] []
  2. [2014-08-09 07:40:11] yapeal.DEBUG: Starting autoMagic for Corp/StarbaseList [] []
  3. [2014-08-09 07:40:11] 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 [] []
  4. [2014-08-09 07:40:11] yapeal.DEBUG: Checking if cache expired on table corpStarbaseList for ownerID = 98067338 [] []
  5. [2014-08-09 07:40:11] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseList' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  6. [2014-08-09 07:40:11] yapeal.DEBUG: Checking if cache expired on table corpStarbaseList for ownerID = 98300065 [] []
  7. [2014-08-09 07:40:11] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseList' AND "sectionName" = 'Corp' AND "ownerID" = 98300065 [] []
  8. [2014-08-09 07:40:11] yapeal.DEBUG: Expired UtilCachedUntil record found [] []
  9. [2014-08-09 07:40:11] yapeal.INFO: select get_lock('505800a64083f7bc69cbea018f51dfe0',5) [] []
  10. [2014-08-09 07:40:11] yapeal.DEBUG: Started filesystem retrieve for corp/StarbaseList [] []
  11. [2014-08-09 07:40:11] yapeal.DEBUG: Deleting expired cache file /htdocs/eve/yapealneu/cache/corp/StarbaseList505800a64083f7bc69cbea018f51dfe0.xml [] []
  12. [2014-08-09 07:40:11] yapeal.DEBUG: Started network retrieve for corp/StarbaseList [] []
  13. [2014-08-09 07:40:11] yapeal.DEBUG: Started XSD validating [] []
  14. [2014-08-09 07:40:11] yapeal.INFO: DELETE FROM "evedb"."yp2_corpStarbaseList" WHERE "ownerID"= '98300065' [] []
  15. [2014-08-09 07:40:11] 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 [] []
  16. [2014-08-09 07:40:11] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  17. [2014-08-09 07:40:11] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  18. [2014-08-09 07:40:11] yapeal.DEBUG: Expired UtilCachedUntil record found [] []
  19. [2014-08-09 07:40:11] yapeal.INFO: select get_lock('074867833ff687e70b79e19fa540b4b9',5) [] []
  20. [2014-08-09 07:40:11] yapeal.DEBUG: Started filesystem retrieve for corp/StarbaseDetail [] []
  21. [2014-08-09 07:40:11] yapeal.DEBUG: Deleting expired cache file /htdocs/eve/yapealneu/cache/corp/StarbaseDetail074867833ff687e70b79e19fa540b4b9.xml [] []
  22. [2014-08-09 07:40:11] yapeal.DEBUG: Started network retrieve for corp/StarbaseDetail [] []
  23. [2014-08-09 07:40:11] yapeal.DEBUG: Started XSD validating [] []
  24. [2014-08-09 07:40:11] yapeal.DEBUG: state => 1 [] []
  25. [2014-08-09 07:40:11] yapeal.DEBUG: stateTimestamp => 2013-09-24 13:04:48 [] []
  26. [2014-08-09 07:40:11] yapeal.DEBUG: onlineTimestamp => 0001-01-01 00:00:00 [] []
  27. [2014-08-09 07:40:11] yapeal.INFO: Have 1 row(s) to upsert into corpStarbaseDetail table [] []
  28. [2014-08-09 07:40:11] 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") [] []
  29. [2014-08-09 07:40:11] yapeal.DEBUG: 98067338,1004057602236,0001-01-01 00:00:00,1,2013-09-24 13:04:48 [] []
  30. [2014-08-09 07:40:11] yapeal.INFO: Have 2 row(s) to upsert into corpFuel table [] []
  31. [2014-08-09 07:40:11] 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") [] []
  32. [2014-08-09 07:40:11] yapeal.DEBUG: 98067338,1004057602236,16275,8333,98067338,1004057602236,4312,174 [] []
  33. [2014-08-09 07:40:11] yapeal.INFO: Have 1 row(s) to upsert into corpCombatSettings table [] []
  34. [2014-08-09 07:40:11] 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") [] []
  35. [2014-08-09 07:40:11] yapeal.DEBUG: 98067338,1004057602236,0,1,490,1,0,99001323 [] []
  36. [2014-08-09 07:40:11] yapeal.INFO: Have 1 row(s) to upsert into corpGeneralSettings table [] []
  37. [2014-08-09 07:40:11] 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") [] []
  38. [2014-08-09 07:40:11] yapeal.DEBUG: 98067338,1004057602236,3,0,1,1 [] []
  39. [2014-08-09 07:40:11] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  40. [2014-08-09 07:40:11] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  41. [2014-08-09 07:40:11] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  42. [2014-08-09 07:40:11] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  43. [2014-08-09 07:40:11] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  44. [2014-08-09 07:40:11] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  45. [2014-08-09 07:40:11] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  46. [2014-08-09 07:40:11] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  47. [2014-08-09 07:40:11] yapeal.DEBUG: Checking if cache expired on table corpStarbaseDetail for ownerID = 98067338 [] []
  48. [2014-08-09 07:40:11] yapeal.DEBUG: SELECT "expires" FROM "evedb"."yp2_utilCachedUntil" WHERE "apiName" = 'StarbaseDetail' AND "sectionName" = 'Corp' AND "ownerID" = 98067338 [] []
  49. [2014-08-09 07:40:11] yapeal.DEBUG: Class not found Yapeal\Database\Char\KillMails [] []
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!