|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
PsyKzz
Bat Country Goonswarm Federation
0
|
Posted - 2011.09.08 22:43:00 -
[1] - Quote
My only problem with Yapeal is the management of our api in the database,
I understand when this was brought up originally you said you wanted to leave this open to allow the dev to completely customise how he wants to store the keys.
However, i'm still confused on the proper storage and looking through the avilable wiki on google code didn't help me either.
Is there anything you could provide. For example a quick function on adding a single char / api and all options checked.
Meh. |
PsyKzz
Bat Country Goonswarm Federation
2
|
Posted - 2011.10.30 18:14:00 -
[2] - Quote
Can you support adding a character id to the db and fetch the publicly available data for them? Meh. |
PsyKzz
Bat Country Goonswarm Federation
2
|
Posted - 2011.10.30 18:46:00 -
[3] - Quote
Dragonaire wrote: You can get all the same information from the other APIs anyway so I've never seen why anyone would find it that useful as it is.
With the application im trying to make i just want to minimise the the different number of systems i have to use.
Could you not make it possible to add a character ID to the utilRegisteredCharacter and get yapeal to download a charCharacterSheet for them?
Also off topic, CorpCorporationContactList should populate without the need for a corp key, it is available to every member of a corp regardless and yapeal should accommodate to that.
Meh. |
PsyKzz
Bat Country Goonswarm Federation
3
|
Posted - 2011.10.30 18:51:00 -
[4] - Quote
Dragonaire wrote:Quote:Also, could someone with more experience with yapeal help me to understand walking the wallet journal and transactions? also, I'm guessing it's the same principal with getting mail message bodies??? Yapeal should do this for you by default but CCP has made some changes in the past that may have broke it and I don't have enough activity on my chars to do any testing
You dont need to do anything just SELECT * WHERE ownerID={YOUR_GUY} SORT BY data ASC / DESC
That would just list them in order. You wouldn't have to worry about anything. Meh. |
PsyKzz
Bat Country Goonswarm Federation
3
|
Posted - 2011.10.30 18:56:00 -
[5] - Quote
Quote:Also off topic, CorpCorporationContactList should populate without the need for a corp key, it is available to every member of a corp regardless and yapeal should accommodate to that. All of the corp APIs have been changed to require a key from a director or the CEO and there is no way around that. [/quote]
Can you not add a bypass? OR a dummy key that runs if a dummy key is input?
Meh. |
PsyKzz
Bat Country Goonswarm Federation
5
|
Posted - 2011.10.30 19:07:00 -
[6] - Quote
Dragonaire wrote:Public access to the corp APIs has been turned off you have to have a corp key now to access them there isn't a way to bypass.
Or to put it another way NO and it can't be done
Is that clear enough?
http://api.eveonline.com/corp/CorporationSheet.xml.aspx?corporationID=238510404
I beg to differ...
Meh. |
PsyKzz
Bat Country Goonswarm Federation
6
|
Posted - 2011.10.30 19:33:00 -
[7] - Quote
Dragonaire wrote:Not really since that ability is going away when old keys do from what I understand and once again by design Yapeal expects to have keys etc for anything in account, char, or corp sections in the requests plus the database expect the full data you only get from having the keys. Yapeal is a made to be used when you have the required keys etc not for just general random access to the APIs if that's what you need there are several other libraries for that but of course it's up to you then to parser the XML and put it in the database yourself too Instead of just trying to say indirectly that Yapeal is doing something wrong why don't you learn how to use it correctly first.
Okay, so to help me out then, when adding / updating data to the db does yapeal overwrite data if it finds any? For example if i created my own to add the data to the database would yapeal, if it ever got a key for such corp, replace it? Meh. |
PsyKzz
Bat Country Goonswarm Federation
6
|
Posted - 2011.10.30 19:45:00 -
[8] - Quote
Dragonaire wrote:Miko Kiun wrote:Dragonaire wrote:If you are talking about /eve/CharacterID.xml.aspx and /eve/CharacterName.xml.aspx they are really outside of the scope of what Yapeal does and it's unlikely I'll add support for them except maybe in some kind of util script if I find and need for it or a few extra days with nothing else to do If you mean /eve/CharacterInfo.xml.aspx it would have already been done except CCP was stupid and put an API that requires apiKeys and vCodes in the eve section instead of where it belonged in char or account. You can get all the same information from the other APIs anyway so I've never seen why anyone would find it that useful as it is. I've got some ideas for changes to Yapeal that MAY in some distance future be able to overcome CCP's stupidity on the placement of this API but let's just say being able to support this API is going to be purely an afterthought in any changes. I'm confused, characterinfo doesn't require keys. https://api.eveonline.com/eve/CharacterInfo.xml.aspx?characterID=90338329Is corp history accessed somewhere else? I can't find it anywhere in the yapeal tables To get the full information from that API you do need the keys etc. I believe you need a key with at least the low access level to get the corp history info but I could be wrong as I've not looked at it since they added that to it and the examples on eve-id aren't really clear on that point. The main thing is Yapeal doesn't currently support having APIs with and without parameters in the same section of the API as it now works so any API that doesn't follow the 'normal' pattern for a section can't be added at this time. As I've said in some of my other posts I've had some ideas on how to make changes that might lift that limitation but it will require basically a total rewrite of much of Yapeal so it's not something that can happen overnight.
Honestly that didnt answer my question, i understand for yapeal to work it requires more keys with access. What i am planning to do in the mean time is my own calls and fill the DB with my own data.
What i am worried about is when yapeal goes to input something is it going to spurg and be all like 'oh **** data already exists' or is it going to just delete and replace? Meh. |
PsyKzz
Bat Country Goonswarm Federation
7
|
Posted - 2011.11.04 22:56:00 -
[9] - Quote
Dragonaire wrote:Yeah it has to read the config file or stuff doesn't work
Why is it now so complicated when before we could just implement common_backend.php ? Meh. |
PsyKzz
Bat Country Goonswarm Federation
7
|
Posted - 2011.11.20 14:45:00 -
[10] - Quote
I was wondering if you could explain a way i could link data back to the API Key it came from?
I know you make use of ownerID for alot of data, but can you add a way to trace it back to the api key? Meh. |
|
PsyKzz
Bat Country Goonswarm Federation
7
|
Posted - 2011.11.21 10:24:00 -
[11] - Quote
I guess for the nature of my application i think i should just maintain another table that lists the character / corporation IDs it has access to, that way i can just counter reference the table to find the key i need.
Meh. |
PsyKzz
Bat Country Goonswarm Federation
9
|
Posted - 2012.02.23 20:21:00 -
[12] - Quote
The Magez wrote:Hello, i have this problem, i had an industry job that i cancelled ingame (Material Effiency job) and since then yapeal stopped fetching new corpIndustryJobs xml, or atleast its not putting it into database as it should, tried to truncate the table but its still not updating it, also tried to truncate another table (corpStandingsFromFactions) and that fetched fine even after truncated.
Thanks
Truncate means to empty. It wont make a difference to how anything works. Meh. |
PsyKzz
Bat Country Goonswarm Federation
12
|
Posted - 2012.06.26 23:54:00 -
[13] - Quote
I seem to be having troubles updating with adoSchema Looking through the code i've added a few outputs to know how far the script gets but it hands indefinably on:
createMySQLTables.php Line (150) : Quote: $result = $schema->ExecuteSchema($sql);
I've got quite an old version of Yapeal that i am trying to update maybe that is the cause? I would prefer not having to start the DB again and dont know if you know a way i can update without a loss of data?
Quick notes: Executed via cli, running PHP 5.3.3. Meh. |
|
|
|