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
Bado Roul
Deep Core Mining Inc.
Caldari State
#141 - 2011-12-01 12:31:22 UTC
I only have one corp key because I was trying to isolate the problem.
I'm on my machine again, I didn't update since 20h ago or so and, after that modification, yapeal.php took 35 seconds to finish. Now there are 2000 records on corpWalletTransactions and corpWalletJournal which seems fine Big smile

About API key in char section, I will add everything as I had before in my VPS and I will see.

Thanks!
Dragonaire
Here there be Dragons
#142 - 2011-12-01 16:15:44 UTC  |  Edited by: Dragonaire
Ok I'll push out new version with fix then and we'll see how it goes.

Update out
version 11.335.1737

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

Bado Roul
Deep Core Mining Inc.
Caldari State
#143 - 2011-12-02 09:42:46 UTC
With char wallets, CPU graph has spikes to 20-35%.

I checked last version and I see you've removed "FALSE" in char wallets. Testing now Smile

Thanks!
Somerset Mahm
Cognitive Distortion
#144 - 2011-12-06 22:16:21 UTC
Hiya Dragonaire,

So I'm about to make the leap to new-API-key Yapeal. What's the preferred way to migrate data? Do I have to set up a new database and manually run queries to change formats? Will Yapeal upgrade schemas for me if I rerun createMySQLTables (and preserve data)?

Just taking it slow :P

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

Dragonaire
Here there be Dragons
#145 - 2011-12-06 23:49:58 UTC
There where some docs about converting around the time Yapeal changed over which you'll on the old thread in the archives and some stuff in the CHANGELOG as well but the basic process is to backup everything up and drop all the tables outside of char* and corp* ones then do upgrade and the missing tables will be recreated. Or you can just make a new database following the install instructions then copy over the data from char and corp tables from the old database. There are enough changes to the account tables to cause problems and they'll refill automatically anyway you don't want to keep them.

If you need any more help let me know.

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

Somerset Mahm
Cognitive Distortion
#146 - 2011-12-07 04:25:23 UTC
Yeah, *walletJournal and *walletTransactions are the ones I'm really concerned with. Thanks!

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

Louis Vitton
Viziam
Amarr Empire
#147 - 2011-12-07 04:50:39 UTC
Hey,

I am trying to install yapeal but when i run ".\checkForRequirements.php" in windows 7 all that happens is that it opens in notepad++ no messages are displayed.
Dragonaire
Here there be Dragons
#148 - 2011-12-07 04:58:01 UTC
That's because Windows doesn't think files ending in .php can be ran. Try it from command line and pass it to PHP by trying this:

php -f .\checkForRequirements.php

It should work right if you're PHP is setup correctly with that. Make sure you are following the instructions in INSTALL.md

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

Louis Vitton
Viziam
Amarr Empire
#149 - 2011-12-07 06:13:35 UTC
I dont have php installed locally but i did try to run it though xampp's portable one and still did the same thing. when i used php -f all it did was say didnt recognize it. Do i need to install php locally?
Dragonaire
Here there be Dragons
#150 - 2011-12-07 06:24:53 UTC  |  Edited by: Dragonaire
Sounds like it's not finding you PHP either so yes you will need to have PHP installed to use it. Guess I thought it was pretty plain that a working local copy of PHP is a requirement for anything to work if you are going to try using it on your local computer Blink

Edit : I'm really sorry if this comes across badly but what you are basically asking is "Do I really have to install the software needed to run your script?"

It was very hard not to answer that with something like this "No of course not you should instill Perl and Python and use them to write your own interpreter which converts it into Java code and run it that way"

Hopefully you understand I'm not really trying to be mean or anything but I just really never expect anyone to ask that question.

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

Louis Vitton
Viziam
Amarr Empire
#151 - 2011-12-07 09:27:41 UTC
Dragonaire wrote:
Sounds like it's not finding you PHP either so yes you will need to have PHP installed to use it. Guess I thought it was pretty plain that a working local copy of PHP is a requirement for anything to work if you are going to try using it on your local computer Blink

Edit : I'm really sorry if this comes across badly but what you are basically asking is "Do I really have to install the software needed to run your script?"

It was very hard not to answer that with something like this "No of course not you should instill Perl and Python and use them to write your own interpreter which converts it into Java code and run it that way"

Hopefully you understand I'm not really trying to be mean or anything but I just really never expect anyone to ask that question.


Yes i realize how it sounds i tried to run it in the xampp directories though and it wouldn't even find it there where php is.

The wording of the question wasn't quiet right more could i use this portable version of xampp rather then installing the php on my drive itself but that has been answered.
Dragonaire
Here there be Dragons
#152 - 2011-12-07 14:55:54 UTC
Ok np I'd never heard of a portable version of xampp either but I'm glad to hear was mostly the question not being clear to me then you were really asking if PHP was needed.Smile I don't know why but xampp never seems to work as well with Yapeal where as the BitNami WAMPStack always does. You can get it from http://bitnami.org/stack/wampstack. When I test Yapeal on Windows that's what I use and it always just seems to work Smile Once in a while I do do some tweaks to a couple settings in the my.cnf file or in php.ini but it should really run without them they just seem to make a few things run smoother for my needs in testing. They are the same tweaks I usually make to the same settings in Linux so they aren't anything really special to make it work.

Anyway if you can finally get PHP working for you let me know if you have any more problems.

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

Satis Iqulenax
Free Imperial Vikings
#153 - 2011-12-08 02:34:31 UTC
Hi Dragonaire.
long time no see Big smile

I had the time to come back for a short time and want to test out what was new in Yapeal since I left the old web installer for Yapeal.

I must say that I'm impressed with the work that been done and the util classes to help adding keys, characters and corporations.

I have a Api key for you to play with if you like.
Just contact me on Pidgin or send me an gmail if you are interested in that.

Now for a problem I have encountered:
I the charWalletJournal and charWalletTransactions only have 250 rows of data in it but I know that I have more rows in it since I have started to trade more and build stuff to sell off.
Do I misunderstand how the wallet walking is working since I thought it would catch some of the data, parse it and then catch the next part of them and then parse those until it have reaches the 1 month limit.

for the same account I also get an warning when I runs the yapeal.php in cli witch is:
Quote:
2011-12-08 01:26:49.693
WARN: Caching invalid API XML for char/KillLog
File: F:\Web\ProSeller\ext\yapeal\class\YapealApiCache.php(196)
2011-12-08 01:28:17.001
WARN: Caching invalid API XML for char/CharacterSheet
File: F:\Web\ProSeller\ext\yapeal\class\YapealApiCache.php(196)


witch in my case don't update my characterSheet and all the table associated with that xml file + the killlog.

Did CCP change something in those XML dumps since last release ?

I have the latest release of yapeal

Kind regards
Satis aka Satissis on google code

Committer of Yapeal for Eve API. Developer of XMLSchema. A database schema tool for PHP

Dragonaire
Here there be Dragons
#154 - 2011-12-08 05:39:52 UTC
I'm not aware of any changes to them but it wouldn't be the first time CCP made changes without telling us about them or I missed it. I didn't see it in the patch notes anyway Blink I do think there was some changes to killlog but I haven't had any kills to look at yet to make the updates for them but I'll take a look at it this weekend and get it updated. Been busy with other things the last couple of weeks.

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

Satis Iqulenax
Free Imperial Vikings
#155 - 2011-12-09 02:15:37 UTC
Okay. I have the xml dump file from my character that is giving those warnings. Should I make an issue and attach those 2 files for you to play with ?

Committer of Yapeal for Eve API. Developer of XMLSchema. A database schema tool for PHP

Dragonaire
Here there be Dragons
#156 - 2011-12-09 04:26:01 UTC
sure I might spot the change with some addition examples faster Blink

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

Spike Keikira
Noob's with Rockets
#157 - 2011-12-10 05:19:46 UTC
I become this error:

2011-12-10 05:15:40.092
WARN: Caching invalid API XML for char/KillLog
File: /var/www/yapeal/class/YapealApiCache.php(196)

and the charKilllog is emty.
anyone an idea ?
Satis Iqulenax
Free Imperial Vikings
#158 - 2011-12-10 06:27:25 UTC
Spike Keikira wrote:
I become this error:

2011-12-10 05:15:40.092
WARN: Caching invalid API XML for char/KillLog
File: /var/www/yapeal/class/YapealApiCache.php(196)

and the charKilllog is emty.
anyone an idea ?

Yeah I think most of us have that warning.
Dragonaire is aware about this.
Dragonaire wrote:
I do think there was some changes to killlog but I haven't had any kills to look at yet to make the updates for them but I'll take a look at it this weekend and get it updated. Been busy with other things the last couple of weeks.

There is also an warning on char/CharacterSheet so my character don't update as well.
Dragonaire is also aware about this.Smile

Kind regards
Satis

Committer of Yapeal for Eve API. Developer of XMLSchema. A database schema tool for PHP

Dragonaire
Here there be Dragons
#159 - 2011-12-10 09:15:10 UTC
Ok should have fix for KillLog errors try out version 11.344.0112

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
#160 - 2011-12-11 01:30:37 UTC
So thanks to Satis Iqulenax for letting me have access to a couple new keys to do more testing then I've been able to lately and some stepping through code in WalletJournals etc I've fixed the last walking issues in journals and transactions now I think Big smile

I also finished the fix to killLog for singleton now it seems so give it a try.

Version 11.344.1722

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