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

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » Yapeal PHP API library (version 1.0.5)

Topic is locked indefinitely.

First pagePrevious page910111213Next pageLast page

Yapeal PHP API library (version 1.0.5) First post
Author

Previous Topic Next Topic

Dragonaire

Here there be Dragons

Likes received: 92

#201 - 2012-01-11 23:20:11 UTC

Callean Drevus wrote:

Hey Dragonaire,

I've just taken a look at my yap_accountAccountStatus table, and it's pretty messed up :P is it by any chance possible that a new item is created every time yapeal queries for this information? EMK certainly doesn't have 255.000 accounts...

I've now added a primary key on keyID to keep it from doing things like this again, but I do not know if that's entirely correct.

In addition, does yapeal EVER clean it's utilXmlCache table? Mine seems to be filling up like there's no tomorrow Blink

(15 GB?)

There well be a accountStatus record for every key since the keyID is the only thing to work with in Account section.

no it doesn't clear the utilXmlCache table. It's been on the TODO list for a while but not very high so far. Think you've set a new record on the size though Blink

I'll look into at least making something that can be ran from a crontab to clear out anything over a set age maybe this weekend. File cache is the same way it never stops growing.

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

Deafside 4
okcerg Deafside Likes received: 4	#202 - 2012-01-12 14:00:24 UTC Hi Dragonaire, I'm starting to write a new application and I'll be using Yapeal and save a lot of time, so thanks in advance for your amazing work. Now I've read Yapeal works with MySQL only and I'd like to know if you consider making it compatible with PostgreSQL in the future. Thanks

Dragonaire

Here there be Dragons

Likes received: 92

#203 - 2012-01-12 18:36:21 UTC

Actual most parts of Yapeal would work with PostgreSQL but there are a few places where some MySQL only stuff is used. Creating the tables come to mind plus the upsert method in YapealQueryBuilder. There are a few others I'm sure as well. Most all of them are inside methods where it could be updated without problems. The biggest issue right now for it would be some issues with how ADOSchema works which I'm working on another project to replace it. Once it is replaced it may open up Yapeal to make many changes to how it manages the database connection but for now it would be hard.

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

Perkone Caldari State 137
Callean Drevus Perkone Caldari State Likes received: 137	#204 - 2012-01-12 21:18:38 UTC Well, my problem was that there wasn't 350 items in accountStatus, it was 255000. EMK has (only) 350 keys. The accountstatus table seemed to be missing a PK, meaning the upsert would probaby constantly insert. Problem with xml schema maybe? Developer/Creator of EVE Marketeer

Dragonaire

Here there be Dragons

Likes received: 92

#205 - 2012-01-12 22:48:04 UTC

KeyID is set to be the primary key on the table on mine and looking at the install/account.xml it also says it is so looks like something just not right with your table Blink

Did you run the install/createMySQLTables.php script when you were updating? Maybe you got old one where userID was key or something?

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

Grion Dalrend

Brutor Tribe

Minmatar Republic

Likes received: 0

#206 - 2012-01-13 16:34:35 UTC

Hello.

I am having a look at Yapeal. It´s concise, clear, crisp. I like it. Well done!

And yet it´s driving me nuts.

I have yapeal setup and it runs like a charm ( means it runs and gets the example information from the preentered API key ), but where do I go from there? Where do i enter the account information? Is there a beginners documentation?

Everything from setup to firing it up is written up in detail, but actually getting my API keys into Yapeal seems impossible. Where Do I put them? The table "accountAPIKeyInfo" seems to be using bigint to store any values, but the API Keys are much longer than that?

I anyone could find the time to point me to a resource I´ve been missing, I´d be most grateful.

Thanks for any help in advance.

Dragonaire

Here there be Dragons

Likes received: 92

#207 - 2012-01-13 17:56:16 UTC | Edited by: Dragonaire

http://code.google.com/p/yapeal/wiki/KeyFiles
http://code.google.com/p/yapeal/wiki/UsingClassUtilClasses
Those should get you started but look through the other wiki pages that are link from those and the others.

But to get you started you need to put your keys etc into utilRegisteredKey table.

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

Likes received: 1

#208 - 2012-01-14 02:55:00 UTC

Grion Dalrend wrote:

I have spoken a bit with Dragonaire about this and I will start create a starter guide today or it might be tomorrow, so stay tuned on this post as I will post info to where the Starter Guide will be and when it's finished.

Kind regards
Satis

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

Satis Iqulenax

Free Imperial Vikings

Likes received: 1

#209 - 2012-01-15 06:46:24 UTC

As I'm writing this, Dragonaire is making a new archive version of Yapeal that can be found on SourceForge.

A new release on google code for Mercurial users have been made as well.

The new release contains:

Fix for corpContracts table that was not pushed the last time and should now fix it to work correctly without any warnings.
I have added Factional Warfare Stats API for char, corp and eve section. FacWarStats is disabled by default for char and corp section since we need your help to test it and give feedbacks on it, so would those who have active characters or corporations in factional warfare please turn it on and try it out. The eve section is turned on by default since we were able to test it for our self.
I have added Factional Warfare Top Stats API to eve section. FacWarTopStats is turned on by default since we were able to test it for our self.
Some smaller fixes that should help on the install when cache_output in yapeal.ini is set to "database" or "both".

As for the Starter Guide it is also being creates as I'm writing this. It's still not finished but well under way and in a few days it should be complete. (Yeah I also have a real life to tent to

so not going to be done today Blink

)
You can however get a sneak peak on it here, just remember it's not finished and that it can change allot in the mean while.

Kind regards
Satis

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

Dragonaire

Here there be Dragons

Likes received: 92

#210 - 2012-01-15 07:48:12 UTC

Thanks Satis Iqulenax for the work you did on faction warfare stuff and the stuff you are working on for the wiki.

So it was also time for the annual update to the Yapeal copyright for the new year so I also pushed that out to the repos and archives while I was at it.

version 12.015.0739

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

Likes received: 92

#211 - 2012-01-15 21:08:17 UTC

Quote:

In addition, does yapeal EVER clean it's utilXmlCache table? Mine seems to be filling up like there's no tomorrow (15 GB?)

Ok I've added an ALPHA cache cleaning script for anyone that is interested in try it out. You can find it in install/cacheCleaner.php. It is made to be ran manually or from crontab/scheduled task. There is a new setting for it in [Cache] section which you'll find in config/ yapeal-example.ini you may want to adjust in your config/yapeal.ini depending on your needs. I would run it at least once manually if you have a large backlog of XML cached as it will put a large load on your server the first time through after that if you set it up to run about 4 times a day your load shouldn't be very high at all. I will be refining it some more as time goes on but I wanted some feedback on how it's working before adding anything more to it.

version 12.015.1701

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


Callean Drevus Perkone Caldari State Likes received: 137	#212 - 2012-01-16 07:07:54 UTC Yay! Will try out cache cleaner as soon as I get a chance. Not that 15 gb cache is bothering me much, but it's just silly Developer/Creator of EVE Marketeer


Grion Dalrend Brutor Tribe Minmatar Republic Likes received: 0	#213 - 2012-01-16 12:41:50 UTC Just wanted to give my thanks for the quick help and I already found the Work-in-Progress Yapeal beginners guide. It´s very easy to understand and looks like it´ll be very useful for future use. Good work and two thumbs up!

Satis Iqulenax

Free Imperial Vikings

Likes received: 1

#214 - 2012-01-20 17:25:08 UTC

Hi all.

I have finished Yapeal Starter Guide.

The Starter Guide contains info on how to install, setup settings, manipulate Yapeal, making Yapeal automatic and more.
It's both a guide for new and experienced web developer so there should be something for all in it.

You can find it on Google code in Yapeal's wiki. (Link: Starter Guide)

Hope it's useful and it will clear up some questions people have on how to use Yapeal.

Kind regards
Satis

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

Viziam Amarr Empire 88
Louis Vitton Viziam Amarr Empire Likes received: 88	#215 - 2012-01-20 23:53:04 UTC Thanks for finishing the guide i will have a read of it today :) give you some feedback if i can. Cheers Louis.

Greased Lightning Engineering 2
No La Greased Lightning Engineering Likes received: 2	#216 - 2012-01-23 10:32:18 UTC I have a question aboput Yapeals ability to recover from api issues. Today I noticed that i was missing almost an entire day of market journal data. 21 Jan. was fine, only a few transactions from the 22e were there and 23 was fine again. Will Yapeal just continue to get new data from the 23rd, or will it also get the missing data from the 22nd ? thnks, No La


Dragonaire Here there be Dragons Likes received: 92	#217 - 2012-01-23 15:36:34 UTC It should try to fill it back in for you as it always tries to walk back as far as it can. Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.

Gabba Cyno

Likes received: 43

#218 - 2012-01-23 18:43:07 UTC

Satis Iqulenax wrote:

Maybe add in here how to upgrade to a new code as well?


Dragonaire Here there be Dragons Likes received: 92	#219 - 2012-01-23 22:45:10 UTC If you're talking about how to update Yapeal that is covered in INSTALL.md. You basically just install the new over the old except if some special instruction are posted here or in the CHANGELOG Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.


Gabba Cyno Likes received: 43	#220 - 2012-01-23 23:16:29 UTC Dragonaire wrote: If you're talking about how to update Yapeal that is covered in INSTALL.md. You basically just install the new over the old except if some special instruction are posted here or in the CHANGELOG I was talking about that but since there is a starter guide, figured that might be something good to add to it also. .

First pagePrevious page910111213Next pageLast page

EVE Technology Lab

Here there be Dragons

Deafside

Perkone

Caldari State

Brutor Tribe

Minmatar Republic

Free Imperial Vikings

Viziam

Amarr Empire

Greased Lightning Engineering