These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Yapeal PHP API library (version 1.0.5)

First post
Author
Tiberius Zol
Moira.
#441 - 2013-10-22 12:44:21 UTC
nevermind. i figured it out myself. damn api errors.

Mr. Tibbers on twitter: @Mr_Tibbers

Mr. Tibbers Blog: www.eve-versum.de

Zack Ormand
Push Industries
Push Interstellar Network
#442 - 2014-01-05 17:06:10 UTC
Are there any know issue surrounding Contracts?

I'm having the issue that while all of the other tables for are updating, corpContracts are not. I've looked into the cache and that is updating.
I'm also getting no errors in logs.

Push Industries - Don't move it, Push It Serving highsec, lowsec and nullsec - and we do it faster and more reliably than anyone else. Ingame channel: PUSHX

Somerset Mahm
Cognitive Distortion
#443 - 2014-01-05 22:24:46 UTC
I use corpContracts every day, so it's definitely working in the latest build. I'd make sure that your table structure is up to date (maybe try a fresh install to test).

SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)

Zack Ormand
Push Industries
Push Interstellar Network
#444 - 2014-01-06 16:14:30 UTC
I re-installed it. Sadly to no avail.

Push Industries - Don't move it, Push It Serving highsec, lowsec and nullsec - and we do it faster and more reliably than anyone else. Ingame channel: PUSHX

Somerset Mahm
Cognitive Distortion
#445 - 2014-01-06 20:54:28 UTC
I will try to find you in game and have a chat, corpContracts is super useful.

SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)

Jack Haydn
Magellanic Itg
Goonswarm Federation
#446 - 2014-01-15 21:52:32 UTC  |  Edited by: Jack Haydn
The wiki suggests to set the cronjob to execute every minute. Is there anyone with a huge amount of keys in their database? (//edit: Dumb question. Certainly you do, Somer) In those cases, you're inevitably going to run into issues where it takes longer than one minute for the script to finish. Does that throw things off or how does Yapeal handle such cases?

Also, is it somehow possible to run an update only for one specific key?
Somerset Mahm
Cognitive Distortion
#447 - 2014-01-15 23:28:53 UTC
In cases like Eveboard or a corp where you want to load data sort of on-the-fly, unfortunately Yapeal doesn't have a good mechanism to do this built-in. I would suggest a simple script that goes through utilRegisteredChar and sets isActive to 0 for all except the one that you want, then runs Yapeal.

If your primary use case is this on-demand sort of thing, honestly Yapeal is probably not the best choice.

I use a simple locking mechanism to ensure that Yapeal doesn't collide-- I touch a lockfile in my homedir before running Yapeal, and exit if the lockfile still exists. When Yapeal is done, I remove the lockfile.

SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)

Zynen
#448 - 2014-01-21 08:31:49 UTC
Thanks for making and maintaining yapeal!

Question -

I'm looking at this API Call -
http://wiki.eve-id.net/APIv2_Corp_StarbaseDetail_XML

And I can't find the data anywhere in Yapeal. I see corpStarbaseDetail, where I think it should be. But it's nearly a mirror of corpStarbaseList. I don't see any of the combat settings, etc.

Can anyone tell me where to find corpStarbaseDetail information in Yapeal?


I checked SourceForge Issues, but I didn't see it listed. So perhaps I'm just missing something.
Umnumun
Regnum demens Deus
#449 - 2014-01-21 09:06:43 UTC
Drapko Nitzhonot wrote:
EcicIdol wrote:
So what tables should I enter data into for corp API? Could you take a screenshot of the places to enter in data to pull corp info? Just some dummy info in a screenshot would be great. Thanks.


utilRegisteredCorporation


utilRegisteredKey

  • activeAPIMask: same as before
  • isActive: 1
  • keyID: it's the ID of your API key
  • proxy: if you don't know, don't touch it
  • vCode: it's the vCode of your API key


utilSections

  • corp row: change isActive to 1




Is this pretty much the same for characters but in the Registered character tab?
Drapko Nitzhonot
Abdera Logistics
#450 - 2014-01-21 16:25:02 UTC
Umnumun wrote:
Drapko Nitzhonot wrote:
EcicIdol wrote:
So what tables should I enter data into for corp API? Could you take a screenshot of the places to enter in data to pull corp info? Just some dummy info in a screenshot would be great. Thanks.


utilRegisteredCorporation


utilRegisteredKey

  • activeAPIMask: same as before
  • isActive: 1
  • keyID: it's the ID of your API key
  • proxy: if you don't know, don't touch it
  • vCode: it's the vCode of your API key


utilSections

  • corp row: change isActive to 1




Is this pretty much the same for characters but in the Registered character tab?

Actually I have utilRegisteredCharacter and utilRegisteredCorporation empty. I track Characters and Corps with only utilRegisteredKey table.
Somerset Mahm
Cognitive Distortion
#451 - 2014-01-21 23:11:16 UTC
Zynen wrote:
Thanks for making and maintaining yapeal!

Question -

I'm looking at this API Call -
http://wiki.eve-id.net/APIv2_Corp_StarbaseDetail_XML

And I can't find the data anywhere in Yapeal. I see corpStarbaseDetail, where I think it should be. But it's nearly a mirror of corpStarbaseList. I don't see any of the combat settings, etc.

Can anyone tell me where to find corpStarbaseDetail information in Yapeal?


I checked SourceForge Issues, but I didn't see it listed. So perhaps I'm just missing something.


They get extracted into several sibling tables. For example combat settings for POSes are in corpCombatSettings, and there is a posID field that you can reference.

SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)

Zynen
#452 - 2014-01-22 02:54:42 UTC
Somerset Mahm wrote:


They get extracted into several sibling tables. For example combat settings for POSes are in corpCombatSettings, and there is a posID field that you can reference.


Much appreciated!
Umnumun
Regnum demens Deus
#453 - 2014-01-22 06:55:15 UTC
Drapko Nitzhonot wrote:

Actually I have utilRegisteredCharacter and utilRegisteredCorporation empty. I track Characters and Corps with only utilRegisteredKey table.


Hmm okay. I have this in the utilRegisteredKey table and it doesn't add a new key. Feel free to point out how wrong I am....

http://pastebin.com/1pF7hBut
Umnumun
Regnum demens Deus
#454 - 2014-01-22 10:05:09 UTC
Ok nevermind. I'm very special. Solved my issue.
Zynen
#455 - 2014-03-12 05:31:45 UTC
Apologies if this has been covered somewhere. After reading pieces of the wiki and half the pages in this thread I gave up :(

I’ve built a few corp tools using Yapeal that only has our corp key in it. This works great!

We have another copy of Yapeal installed on a separate server that has all our member API keys. This takes 4-5 hours to run through all the keys/data.

What I’d like to do, is merge these two installs.

My question is, once I do that, will my corp API data be delayed because there’s always a back log of member keys to roll through?

If the answer is yes, is it safe to run a second install of Yapeal on a separate database so they can update independently?
Dragonaire
Here there be Dragons
#456 - 2014-03-27 00:38:54 UTC
Hi all I've got a little time so thought I'd check in on things here again.

Zynen wrote:
Apologies if this has been covered somewhere. After reading pieces of the wiki and half the pages in this thread I gave up :(

I’ve built a few corp tools using Yapeal that only has our corp key in it. This works great!

We have another copy of Yapeal installed on a separate server that has all our member API keys. This takes 4-5 hours to run through all the keys/data.

What I’d like to do, is merge these two installs.

My question is, once I do that, will my corp API data be delayed because there’s always a back log of member keys to roll through?

If the answer is yes, is it safe to run a second install of Yapeal on a separate database so they can update independently?


The corp stuff could be delayed though how much is hard to say you would just have to test. You could use the same DB for both copies of Yapeal you have running as well without to much of a problem using the 'table_prefix' option in the yapeal.ini so you can have separate util tables. Main thing is you'll want to do some testing to figure out where most of the delay is happening. Main areas that have shown up have been Network I/O, DB transaction limits, and / or Disk I/O limits which can seem to be DB limits without careful testing. Also remember that Yapeal is not a typical web app in that it uses a lot of incoming network I/O with little outgoing which is backwards to how most hosting is setup. The Reason for that is it's more of a client then a service at least as seen from outside.

Note that the idea of using 'table_prefix' might also help with the 4-5 hour runs on member keys as well but can make your queries to the DB a little harder as you'd have to merge from multiple tables.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.

Dragonaire
Here there be Dragons
#457 - 2014-03-27 20:19:27 UTC  |  Edited by: Dragonaire
So pushed out update to repo for people to test. Mostly update to *.xml and *.xsds for Eve API changes that have been made. Just a warning there might be some other refactoring changes also mixed in that I was working on a few months ago so good backups and test server use only until you've tested it highly recommended as I'm not able to do any testing right now

WARNING: Did include some work in progress so you'll need to just extract the needed updated files. The list of files needed should be as follows:
class/api/char/charCharacterSheet.php
install/map.xml
install/char.xml

From lib/Yapeal/Caching/:
char/CharacterSheet.xsd
char/MailMessages.xsd
map/FacWarSystems.xsd

to cache/ directory.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.

Lluerssen
Viziam
Amarr Empire
#458 - 2014-04-04 05:40:33 UTC  |  Edited by: Lluerssen
Just updated to latest yapeal through hg.

> php -v
PHP 5.4.26 (cli) (built: Mar 12 2014 12:15:56)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies

> php -f yapeal.php
Could not find required auto class loader. Aborting ...

This is clean hg clone, with yapeal.ini moved from previous version.

Sister of EvE: http://SisterOfEvE.ru/ Loot History Analyzer: http://SisterOfEvE.ru/loot_history/

Zynen
#459 - 2014-04-04 08:09:16 UTC  |  Edited by: Zynen
I successfully installed a second install of Yapeal, and up until a few days ago everything has been working great.

yapeal Corp = My Corporation Key only
yapeal Member = All my member's keys

My corp install (the one with only my corp key) will no longer pull API data from the key.

I suspect the notice below could have something to do with it?
Quote:
INFO: No corporations for corp section
File: /var/www/yapCorp/class/SectionCorp.php(82)


  • The corp key works in EveHQ fine. So the key is good.
  • I created a new key, just in case. That one works in EveHQ, but not Yapeal just like the original one.
  • I cleared the cache (was database, switched it to file to see if that would help, but still the same problem)
  • I've done a fresh install of Yapeal latest (1.03) including database tables.
  • I have my key in utilRegisteredKey
  • I have my corp in utilRegisteredCorporation (tried with, and without. Was working before with it)
  • My IP is not banned @ CCP
  • If it helps, I'm on Ubuntu 12.04 at the moment


The only data that's populating is the non-key tables. For example, mapSovereignty, eveAllianceList, etc.

When I turned on TRACE in the yapeal.ini file, I occasionally see these on the Member install. And for a while, constantly on the Corp install. Since the fresh Corp install however, I haven't seen them.

Quote:
INFO: 403 Forbidden for API https://api.eveonline.com/account/APIKeyInfo.xml.aspx
File: /var/www/yapCorp/class/YapealNetworkConnection.php(103)


I'm at a loss at what else to check. I haven't messed with the install since I confirmed it was working after the second (Member) install. (That was around March 13th or 14th)

Any advice/direction would be appreciated.



Update -

APIKeyInfo was not populating accountKeyBridge, AccountCharacters, accountAPIKeyInfo tables. Manually populated these tables, and it's pulling again.

Side note, my corp key won't pull on my Member install either. Same issue.
Dragonaire
Here there be Dragons
#460 - 2014-04-04 22:07:40 UTC
Lluerssen wrote:
Just updated to latest yapeal through hg.

> php -v
PHP 5.4.26 (cli) (built: Mar 12 2014 12:15:56)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies

> php -f yapeal.php
Could not find required auto class loader. Aborting ...

This is clean hg clone, with yapeal.ini moved from previous version.


If you instilled after my above post you got the broken version with some in progress alpha code so check that first. You might try grabbing the tagged version 1.0.3 with hg or rev 509 as anything after then is likely broken. I'll look into fixing the default branch again so it does NOT cause any more issues for people but I have to sort out which of the later changes I really did want to apply to the default branch.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.