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 page1617181920Next pageLast page

Yapeal PHP API library (version 1.0.5) First post
Author

Previous Topic Next Topic

Thaddea

Clive's Crew

Likes received: 6

#341 - 2012-12-15 06:31:48 UTC

Gilgamoth wrote:

2012-07-18 18:15:16.031
WARN: Insert/upsert failed for charSkillQueue
File: D:\yapeal\class\YapealQueryBuilder.php(493)

I was also getting this so I added a line to log the exception and it appears this is caused by characters on an account that aren't training but do have a skill queue setup. The endTime and startTime are blank in the xml returned from the API request.

Here is the output from the log:

WARN: Exception => exception 'ADODB_Exception' with message 'mysqli error: [1292: Incorrect datetime value: '' for column 'endTime' at row 1] in EXECUTE("insert into `charSkillQueue` (`endSP`,`endTime`,`level`,`ownerID`,`queuePosition`,`startSP`,`startTime`,`typeID`) values (45255,'',4,1035432898,0,8000,'',16595),(512000,'',5,1035432898,1,90510,'',3446)")

Not a big problem which can be ignored or you can remove the training queue on characters you don't plan on training.

Thaddea

Clive's Crew

Likes received: 6

#342 - 2012-12-25 22:14:04 UTC

Hi Dragonaire, this is an awesome project. I started building my own but stopped when I found yours since it was exactly what I wanted to do. It is so nice having everything available in a database so that I just need to query what I need.

In order to get familiar with the workings of Yapeal I looked into the problem above about empty endTime and startTime values in the charSkillQueue. I made the table allow nulls and I modified the query builder to allow null date/time types.

I also needed a few more of the APIs for my tools so I went ahead and implemented charLocations, corpLocations (to get all the named containers I use) and eveSkillTree. I'll contact you at SourceForge if you want me to upload the changes for you to look at.

Thanks again for making such a great tool.

Caldari Provisions Caldari State 0
Gladi Caldari Provisions Caldari State Likes received: 0	#343 - 2013-01-04 15:10:56 UTC ok do i understand this correctly: I set your library up, let the cron run every x time and my mysql DB is uptodate with the API keys i put in. I then can just work the DB and dont need to use any eve api calls etc? what would i need your other functions for that you provide?

Dragonaire

Here there be Dragons

Likes received: 92

#344 - 2013-01-06 18:43:05 UTC

Talos Katuma - You're right it should be. I started to work on the maintenance stuff but didn't get very far into it before I got busy with other things.

Gladi - Most of the other classes in class/util are there to make integrate Yapeal with your software easier but if you don't think you need them they can be ignored.

Thaddea - I'd be interested in looking at what you have done do contract me on SF. If you already did might try it a gain because I was deleting some SPam the other day and think I got some other stuff as well

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

Tek Handle

Vanishing Point.

The Initiative.

Likes received: 55

#345 - 2013-01-07 04:47:03 UTC | Edited by: Tek Handle

Hey, I tried Yapeal as an alternative to Ale the first time tonight. It's a whole new story, but it looks neat. I got a few questions tho. Is there an easy way to change the order in which the API pages are fetched? By default corpstarbasedetail is fetched before corpstarbaselist, leading to no details for newly placed towers for the interval time of the cronjob. You get the issue at this point? Speaking of interval, is there any suggestion on which one's optimal?

One more question: Any objection on setting the cache_output setting to none? I take it Yapeal uses the cacheduntil timestamps stored in the database to prevent requests based on those timestamps? If so I don't see a reason to keep them data cached.

Dragonaire

Here there be Dragons

Likes received: 92

#346 - 2013-01-11 17:06:53 UTC

Yapeal actually calls the APIs in a random order so any bugs or API server errors don't end up block another API call and since it's hardwared into the code it can't be changed.
The crontab should be ran every minute as I've stated multiple times since Yapeal manages work load internally to spend out the API calls to keep from cause API server spikes. If there's nothing for it to do it does cause any load on your server since it only does a few DB calls to check the cached times.

Wither you have the caching on or off is up to you as Yapeal doesn't need it but it can be useful when trying to track down errors.

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

Mikokoel

Mining Industry Exile Foundation

Synergy of Steel

Likes received: 38

#347 - 2013-01-22 20:18:09 UTC

Oh my god. Ugh

I posted this last August:

Mikokoel wrote:

Since 3 days, the cronjob running Yapeal doesn't output anything, but there are no log files and no updates in the database.

Edit: Nevermind, fixed it

I fixed the problem and simply edited it in. Now I had the same problem again in another project.

And it took me 3h until i figured out what it was. But this time I'm smart and writing it here, so my brain can find it again Big smile

Apparently, on some server configurations, log4php doesn't like the paths to the log files (e.g. "log/yapeal_error.log").
After changing all those to absoulte paths (/www/htdocs/...), it finally works.

Debugging is seriously ****, when the part which should print the errors doesn't work!

Mikokoel

Mikokoel | Head FC League of Unaligned Master Pilots

Iax Masali

Doomheim

Likes received: 17

#348 - 2013-01-27 21:22:16 UTC

Went though all the Installation Steps in the install.txt no error were shown.

Came to Yapeal Testing

Entered php -f yapeal.php into the CLI and it has thrown this at me.

Quote:

File: C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\yapeal.php(150)
2013-01-27 21:06:44.244
FATAL: mysqli error: [1146: Table 'yapeal.eve-utilsections' doesn't exist] in EXECUTE("select `section` from `EVE-utilSections`")

Code: 1146
Trace:
#0 C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\ext\ADOdb\adodb.inc.php(1042): adodb_throw('mysqli', 'EXECUTE', 1146, 'Table 'yapeal.e...', 'select `section...', false, Object(ADODB_mysqli))
#1 C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\ext\ADOdb\adodb.inc.php(1017): ADOConnection->_Execute('select `section...', false)
#2 C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\ext\ADOdb\adodb.inc.php(1470): ADOConnection->Execute('select `section...', false)
#3 C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\yapeal.php(147): ADOConnection->GetCol('select `section...')
#4 {main}
--------- END TRACE ----------

File: C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\yapeal.php(150)

2013-01-27 21:06:44.281
ERROR: No sections were found in utilSections check database.
File: C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\test\yapeal\yapeal.php(154)

I have deleted the Database and went though the install steps again but same result

I saw that this poster had the same Error

Controller Vrelk wrote:

What is the correct way to add an API key to the system? I manually added one to utilregisteredkey and set `active` to 1 and the existing example one to `active`=0.

When I run yapeal.php from console I get this:

Quote:

ERROR: No sections were found in utilSections check database.
File: /home/****/*****/ratter/yapeal/yapeal.php(155)

It also does not add the other information to the rest of the tables. The key has access to char/WallerJournal only.

I tried going through the wiki (which is outdated, as you have said before) and code to find the correct way of doing so, but didn't find anything that seemed to do what I wanted.

and read your response

Dragonaire wrote:

Make sure the char section in utilSections has isActive=1
It sound like you did the rest right though you didn't say what your activeAPIMask value was but if it's NULL the one from sections will control it.

As to the wiki yes it is outdated on a lot of stuff but the UsingClassUtilClasses and UtilDatabaseTableDependences are still useful for understanding the things you're having trouble with and have been updated to the current way things work since I last wrote about them being outdated.
If you have any other questions just ask I'm much better answering questions here than I ever have been trying to write about how to use stuff for new people in general Blink

so I check the utilSections in phpmyadmin and yes char isActive=1 is how it is set.

Any ideas?

Thanks

Cognitive Distortion 239
Somerset Mahm Cognitive Distortion Likes received: 239	#349 - 2013-01-28 21:16:53 UTC You're checking utilSections, but it looks like you've defined a database prefix of EVE- in yapeal.ini. Try removing the prefix. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)


Iax Masali Doomheim Likes received: 17	#350 - 2013-01-29 14:31:20 UTC Somerset Mahm wrote: You're checking utilSections, but it looks like you've defined a database prefix of EVE- in yapeal.ini. Try removing the prefix. Thanks that got it working

Amarr Research Laboratories 69
Steven Trux Amarr Research Laboratories Likes received: 69	#351 - 2013-02-18 23:12:54 UTC 1 Hi all and thanks in advance for your help. I can't fetch corp contracts. I've followed all the instructions in the wiki, added the corp api and so on. Assets, industry jobs, market orders, work fine but not contracts... I try to solve the problem in the last three days with no luck. ARLAB Shop BPOs Showcase Manufacturing Service

Full Stack Capsuleers 16
Seres Kashuken Full Stack Capsuleers Likes received: 16	#352 - 2013-02-27 22:00:53 UTC 1 Thanks for this useful tool! Still futzing with it but I think I got it working as supposed to. Roid mining space hippie.

Dragonaire

Here there be Dragons

Likes received: 92

#353 - 2013-05-28 14:13:45 UTC

As Everybody has probably noticed I've become very inactive in Eve over the last few months and having been updating Yapeal either. There are many reasons for this but in the end it doesn't matter much to most of you. Given that I don't see my interest level increasing in the near future I'd like to find someone to take over development and the day to day maintenance of Yapeal. If you are interest in taking over the project Eve-mail me and I'll also probably contact a couple of people I believe would be good at continue the project as well. It's hard to let the project go since I've worked on it for almost as long as I played Eve and actually spend more time on it then I did playing but it's really past time for me to step down and let someone else take the lead in moving forward. It's been fun and I've learn a lot both from working on Yapeal and from all of the other developers here on the forums.

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

#354 - 2013-06-04 16:32:37 UTC

Ok so at least one of my account now only has a few days left on it and I don't plan on keeping it going and I may not keep the main one either so thought I better make one more post before it does too. None of the people I talked to were interest in keeping Yapeal going and no one else stepped forward on their own either so I expect development to stop completely now which it had mostly done already in the last few month since I haven't been doing anything. The good thing about is it's open source and host where it'll be available for a long time. I'd still welcome having someone else take over the project and be available to help consult on understand the inner works of Yapeal but have no interest in adding to it or rewriting it myself though it probably could use that again in areas.

Anyway thanks all of you who have help me along and been friends for years both in and out of game as a player and a developer with the Eve API over the last 6 years and maybe I'll see you all again someday flying around in EVE which is still one of the best games I've ever played.

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 Likes received: 239	#355 - 2013-06-04 20:26:31 UTC 1 I'd be happy to PLEX your account to keep a line of contact open. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)


Somerset Mahm Cognitive Distortion Likes received: 239	#356 - 2013-06-26 18:04:37 UTC Ogads, the API changed and now Yapeal is broken. Time to put on my big kid pants and try to figure out how to change the schemas. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)


Somerset Mahm Cognitive Distortion Likes received: 239	#357 - 2013-06-26 19:16:50 UTC 1 I did it yay. I'll post a diff soon with the needed changes to get your Yapeal working once more. It's basically just updating xml and table schemas. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)

New Edens Freeports 317
Dasola New Edens Freeports Likes received: 317	#358 - 2013-06-26 19:56:14 UTC Sad to see development of this project suspend.. if i would be better programmer i would offer to take over. But my php skills, nahhh... We are Minmatar, Our ship are made of scraps, but look what our scraps can do...


Somerset Mahm Cognitive Distortion Likes received: 239	#359 - 2013-06-26 22:56:25 UTC 2 Dragonaire is going to add me as a committer so I can at least try to help Yapeal limp along for now. SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)

Goosewarms Tactical Hunters and Gatherers 25
Zaepho Goosewarms Tactical Hunters and Gatherers Likes received: 25	#360 - 2013-06-27 03:34:24 UTC Somerset Mahm wrote: Dragonaire is going to add me as a committer so I can at least try to help Yapeal limp along for now. Thank goodness!! Just looked at my logs after a few days away and saw all the errors and got really really scared. Thanks for helping all of us limp along until somebody with the time and desire to maintain the project can step up.