Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 .. 18 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Dragonaire
Corax. PURgE Alliance
7
|
Posted - 2011.09.08 14:20:00 -
[1] - Quote
Yapeal has now been in development for nearly three years and proven to be useful for many people in their Eve API applications and websites. For a description of what it does check out the project home page at GoogleCode.
Yapeal has now moved out of what I considered 'Alpha' into 'Beta' stage of development. For people use to Mircosoft's way of doing things Yapeal is now Win98 vs Win3.11 or Win95 (It actually works for more than 5 minutes
Yapeal is licensed under GNU LGPL 3
HOME PAGE http://code.google.com/p/yapeal/
You can find my public API key on the home page as well.
I have a blog for Yapeal called Peeling Yapeal that everyone is invited to follow as well.
It's now recommended that everyone uses the downloads of the non-installer versions which are available at: https://sourceforge.net/projects/yapeal/files/trunk/ CAK branch is in https://sourceforge.net/projects/yapeal/files/keys/ Yapeal is also still available through the SVN at: http://code.google.com/p/yapeal/source/checkout
For more information about Subversion see http://subversion.tigris.org/ Windows users may find http://tortoisesvn.tigris.org/ easier to use.
Please report any bugs you find in this thread or as as issue on the website.
You can contact me through the developer name from the project @ gmail.com Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
Dragonaire
Corax. PURgE Alliance
7
|
Posted - 2011.09.08 14:32:00 -
[2] - Quote
Here an extend explanation of what Yapeal does since it a little different then the other PHP API libraries people are using.
It doesn't only grab the data from the API for you but also saves the new data into a MySQL database for you. It was made to be ran from a crontab job and works in the background to 'Auto-magically' as I call it, keep the database updated so all you have to do is work with the database tables not the API and XML. It's made to be set and forget once configured.
Some features:
- Auto download of API data
- Auto updating of database tables
- Can be ran from crontab (preferred setup)
- Can be run from command-line for debugging or special needs
- Keeps track in the database of API cachedUntil times so it is API friendly even if ran every minute in crontab
- Does optional local caching of XML file from API
- Multiple corporations and multiple characters by just adding their information to database tables
Many other features but those are the main ones for now. Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
Ruziel
Twilight Military Industrial Complex
0
|
Posted - 2011.09.08 22:32:00 -
[3] - Quote
Trying out the new keys version. Found one issue so far:
The schema for the size of the errorText field in the the eveErrorList table needs to be updated. The current size is VARCHAR(255), there's a new error being returned by the API with a text length of 305 characters or so. Specifically error code 904 = "Your IP address has been temporarily blocked because it is causing too many errors. See the cacheUntil timestamp for when it will be opened again. IPs that continually cause a lot of errors in the API will be permanently banned, please take measures to minimize problematic API calls from your application." |
PsyKzz
Bat Country Goonswarm Federation
0
|
Posted - 2011.09.08 22:43:00 -
[4] - 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. |
Johnathan Roark
The Graduates Morsus Mihi
3
|
Posted - 2011.09.09 00:29:00 -
[5] - Quote
PsyKzz wrote: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.
There are helper classes in class/util/ for managing keys. EVEVERIFY - A recruiting API Verification and Audit Tool
Also try out Yapeal for your php api needs |
Miko Kiun
Narshan Industries
0
|
Posted - 2011.09.09 05:49:00 -
[6] - Quote
Is there any current plan to incorporate the new feature in CharacterInfo.xml.aspx including employment history? |
Dragonaire
Corax. PURgE Alliance
7
|
Posted - 2011.09.09 06:19:00 -
[7] - Quote
Not really in the main Yapeal code as for some unknown reason CCP decide to put an API that requires key etc in eve section where none of the other APIs do. Until they fix that by putting it where it belongs in char section it can't be supported really. Having said that I will say that some work has been done to add what I call a retriever to Yapeal for stuff like during website sign up where you might just need one or two API calls without waiting on normal Yapeal crontab etc. I plan to make it more versatile when it comes to the parameters that you can have it pass to the APIs which should allow it to be used for some of the oddball APIs like CharacterInfo as well. Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
Dragonaire
Corax. PURgE Alliance
7
|
Posted - 2011.09.11 06:58:00 -
[8] - Quote
I've been working on updating some of the wiki pages for CAK and have finished with the last of the featured ones. Take a look and if something doesn't seem to be clear or you find an error let me know.
In other news I'm looking to merge branches/keys/ over to trunk/ soon as I believe it is complete and there doesn't seem to be any bugs. I've already made a last tag from the current pre-CAK trunk/ just to have it as a reference for the future. There is some work being done on contracts that I'm hoping can be merged into keys soon and once it's been tested and reviewed a little the process to make branches/keys/ the new trunk/ will begin.
I've also had someone come up with an idea for how to work around the issues surrounding the IMHO misplaced /eve/CharacterInfo API. If it proves out the API should be added to the grow number of APIs Yapeal supports. Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
Fredrick Engly
RaVal Thyokill Industies Inc. Intergalactic Exports Group
0
|
Posted - 2011.09.13 01:41:00 -
[9] - Quote
Is there support yet for the new Contract API? |
Johnathan Roark
The Graduates Morsus Mihi
3
|
Posted - 2011.09.13 03:08:00 -
[10] - Quote
Fredrick Engly wrote:Is there support yet for the new Contract API?
*Johnathan Roark whistles EVEVERIFY - A recruiting API Verification and Audit Tool
Also try out Yapeal for your php api needs |
|
Dragonaire
Corax. PURgE Alliance
8
|
Posted - 2011.09.13 03:17:00 -
[11] - Quote
I've been waiting to see if someone would finish the other couple contract APIs before releasing it (Looks at Roark) but doesn't look like that going to happen for a few more days anyway so I'll probably be merging what's been done into keys in the next day or two once it's been tested a little bit since QA (me) has found a couple problems and thought it might be a good idea Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
Fredrick Engly
RaVal Thyokill Industies Inc. Intergalactic Exports Group
0
|
Posted - 2011.09.13 06:05:00 -
[12] - Quote
groovy thx guys..
Is there a nublette way of upgrading also? svn update, database script to run?
Dont really want to loose whatever data I have in there at the moment but if I must then I must
|
EcicIdol
0
|
Posted - 2011.09.13 18:24:00 -
[13] - Quote
Cant wait for an update. Thanks for your hard work. |
Johnathan Roark
The Graduates Morsus Mihi
4
|
Posted - 2011.09.13 23:13:00 -
[14] - Quote
Fredrick Engly wrote:groovy thx guys..
Is there a nublette way of upgrading also? svn update, database script to run?
Dont really want to loose whatever data I have in there at the moment but if I must then I must
The way I would do it is first make a backup. Delete all of the util* tables. You may also want to delete all of the account tables as well. Run the createmysqltables.php file and see if it works. EVEVERIFY - A recruiting API Verification and Audit Tool
Also try out Yapeal for your php api needs |
Dragonaire
Corax. PURgE Alliance
9
|
Posted - 2011.09.14 04:42:00 -
[15] - Quote
As Johnathan Roark said make a good backup or two then delete the util* and account* tables and run the script. There are only minor changes to the other tables that it should handle without problems. You can find some more complete instructions in INSTALL.txt just insert the above in the correct places.
Quote:Is there support yet for the new Contract API? Merge the contract branch into keys and uploaded some updated archives on SourceForge as well. Work on the other two contract APIs is in progress as well. Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
Dragonaire
Corax. PURgE Alliance
9
|
Posted - 2011.09.15 04:30:00 -
[16] - Quote
Ok I've gone ahead and merged branches/keys into trunk/ It's as good as it was going to get in the near future and seems to be as bug free as can be without wider testing. enjoy.
revision 1228 Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
EcicIdol
0
|
Posted - 2011.09.15 15:17:00 -
[17] - Quote
Dragonaire,
I am a bit confused about the utilRegisteredCharacter and utilRegisteredCorporation.
In the utilRegisteredCorporation, I see 5 rows. http://i51.tinypic.com/2qdtr37.jpg
Could you explain what I am suppose to do with that? I have my new custom API key entered in the utilRegisteredKey The wording on your wiki is a bit off and I am confused. My goal is to pull the following data for my corp.
AccountBalance AssetList CorporationSheet Divisions WalletDivisions Logo IndustryJobs KillLog Attackers Items Victim MarketOrders MemberTracking Standings StarbaseDetail Fuel GeneralSettings StarbaseList WalletJournal WalletTransactions |
Dragonaire
Corax. PURgE Alliance
9
|
Posted - 2011.09.15 21:08:00 -
[18] - Quote
You have the option to ignore it depending on your needs actually. Make sure you've read the updated http://code.google.com/p/yapeal/wiki/UtilDatabaseTableDependences and http://code.google.com/p/yapeal/wiki/UsingClassUtilClasses wiki pages as they have been updated in the last few days. You'll want to pay attention to the part about them being optional if registered_mode is set to that. Now to try to help out on understanding the table you asked about the classes use what are called magic methods to make the columns from the tables look like properties in the class. which makes setting and changing them very easy. You can also get them as well. There are also a couple methods addActiveAPI() and deleteActiveAPI() which let you just use the API names instead. To set the $corp->activeAPIMask directly you'll need to use a bitmap instead just like I show near the end there. Hopeful this little extra info will get you headed in the right way but if not I'll try to do a long explanation after work for you Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
EcicIdol
0
|
Posted - 2011.09.16 05:39:00 -
[19] - Quote
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. |
Drapko Nitzhonot
Abdera Dukedom
0
|
Posted - 2011.09.16 06:02:00 -
[20] - Quote
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
|
|
EcicIdol
0
|
Posted - 2011.09.16 07:07:00 -
[21] - Quote
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. utilRegisteredCorporationutilRegisteredKey
- 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
Thank you very much. Now I am getting this.
[/home/yapeal]# php -f /home/yapeal/yapeal.php [2011-09-16 07:05:33.314] NOTICE: Undefined variable: mask File: /home/yapeal/class/SectionCorp.php(292) [2011-09-16 07:05:36.206] WARNING: Row was missing required fields (rawQuantity) that are needed for corpAssetList File: /home/yapeal/class/YapealQueryBuilder.php(182)
I get that WARNING message several hundred times. |
Dragonaire
Corax. PURgE Alliance
10
|
Posted - 2011.09.16 15:29:00 -
[22] - Quote
Actually the Notice error you are getting might be part of the problem you're having as it's a bug that seem to have crape in with a bad cut and paste I've updated svn and archives to fix it.
Make sure you are using the archives (zip/bz2) or current svn from trunk/. If you are using archive check the revision in revision.php the YAPEAL_VERSION line will let you know which you are running. It should be 1231 or later. Also make sure if you do use archives you cleared out old version before unpacking the new one where you have it installed. Clear just the class/ directory should be enough but it doesn't hurt to backup your config/yapeal.ini file and wipe the whole thing if you still have problems. Also remember the RegisteredCorporation/Character tables can be totally empty when using registered_mode=optional like you are using but do make sure in utilSections that account row's isActive=1 or it'll come back to bite you later.
BTW you can also get the corporationID etc from the accountCharacters table just like Yapeal does for active keys Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
EcicIdol
0
|
Posted - 2011.09.16 15:50:00 -
[23] - Quote
Dragonaire wrote:Actually the Notice error you are getting might be part of the problem you're having as it's a bug that seem to have crape in with a bad cut and paste I've updated svn and archives to fix it. Make sure you are using the archives (zip/bz2) or current svn from trunk/. If you are using archive check the revision in revision.php the YAPEAL_VERSION line will let you know which you are running. It should be 1231 or later. Also make sure if you do use archives you cleared out old version before unpacking the new one where you have it installed. Clear just the class/ directory should be enough but it doesn't hurt to backup your config/yapeal.ini file and wipe the whole thing if you still have problems. Also remember the RegisteredCorporation/Character tables can be totally empty when using registered_mode=optional like you are using but do make sure in utilSections that account row's isActive=1 or it'll come back to bite you later. BTW you can also get the corporationID etc from the accountCharacters table just like Yapeal does for active keys
This fixed my problem. Deleted class folder, updated to 1231 code, and everything is working now. Thank you.
If I wanted to add info from more than one corp, should I use the same DB and just added another corp and key into the utilregisteredkey and utilregisteredcorporation? Or create a new DB for the new corp? I assume that if I use the same DB it will keep all of the records separate for each corp? |
Dragonaire
Corax. PURgE Alliance
10
|
Posted - 2011.09.16 21:04:00 -
[24] - Quote
Yes you can have as many as your system can keep up with in a single DB. Everything is either keyed by keyID, characterID, corporationID in each table. If a column by those names don't exist in the XML I add an ownerID column with the correct type for the section of the API it's in. So for char section API it will be characterID etc Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
EcicIdol
0
|
Posted - 2011.09.16 21:43:00 -
[25] - Quote
Perfect. Thank you. My next question is what is the utilgraphics table for? I am assuming that I can use icons from some dump of files. How does that work? |
Dragonaire
Corax. PURgE Alliance
10
|
Posted - 2011.09.17 03:46:00 -
[26] - Quote
The only place in Yapeal that table was used was with some of the scripts in install/. They were used to interface with a GUI installer that I tried with it at one point but few people liked it or used it so it was dropped at least for now. The scripts still exist they are the addTestCharacter.php and addTestCorporation.php scripts. In the installer it would show you pictures of chars/corps to choose from on an account to add to the Yapeal database for testing. At one time the pictures were in the Registered tables but to streamline and normalize them I moved the pics to where they are now. Since they aren't really used in Yapeal you would be free to use them in your application if you want just keep in mind that at some point I may start using them in Yapeal for what they were made for so I would keep them just for character and corporation pictures. Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
7
|
Posted - 2011.09.17 14:30:00 -
[27] - Quote
SectionAccount.php is missing a part of the query in the getSQLQuery function.
The second query for a YAPEAL_REGISTERED_MODE of 'ignored' does not return either a RKActive or a RKMask field, the RKActive of which means that all rows will always be filtered by the function below that, ignoredFilter.
I think it would be good to change this.
In addition, I'm getting:
Quote:[2011-09-17 14:24:00.718] NOTICE: SkillInTraining is an unknown API for section char File: /var/www/core/lib/yapeal/class/util/CachedInterval.php(93) [2011-09-17 14:24:52.871] NOTICE: Contracts is an unknown API for section char File: /var/www/core/lib/yapeal/class/util/CachedInterval.php(93) Nothing major, but it's odd :P [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Dragonaire
Corax. PURgE Alliance
10
|
Posted - 2011.09.17 16:31:00 -
[28] - Quote
Your right there was an error in getSQLQuery(). Actually all 3 modes can use the same query so I'm dropping the switch. (Fixed in revision 1232)
I'm not seeing the notices and I believe those errors were cleared up in a revision of keys so I'm guess you're using an old version of it and not the latest trunk/. There are some errors popping up for some of the API that aren't implemented yet and I'll try to make some changes so Yapeal returns a different error message so it's clearer what is actually happening. Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
Callean Drevus
Icosahedron Crafts and Shipping Silent Infinity
7
|
Posted - 2011.09.17 18:04:00 -
[29] - Quote
Actually I just updated to the latest trunk, though with the converted database of an older version, so I guess it might have something to do with that. Not giving problems of any kind though, I believe the tables are even updated even though the notices appear. [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images? |
Dragonaire
Corax. PURgE Alliance
10
|
Posted - 2011.09.17 18:31:00 -
[30] - Quote
Yeah database needs to be updated to get the changes made in util* tables etc
Did a couple more updates the install/*.xml tables that should make database updates work better. Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. Check out the Yapeal forum thread |
|
|
|
|
Pages: [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 .. 18 :: one page |
First page | Previous page | Next page | Last page |