open All Channels
seplocked EVE Technology Lab
blankseplocked Yapeal PHP API library (revision 1203 branches/keys/)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : ... 7 8 9 10 [11] 12 13 14 15 ... : last (24)

Author Topic

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
Posted - 2009.09.06 17:45:00 - [301]
 

Originally by: Elnar Khad
Let me say, thank you to everyone who has worked on this project. It is very well thought out and will be very useful.
I'm coming up against a wall during setup of the scripts. I have followed the windows version of the setup and most things seem to be working. It is correctly pulling down server, map and alliance information, and pulling the characters out of my accounts correctly. The only things that are not getting put into the database are the items that I put into the "ActiveAPI" fields in the utilregisteredcharacter and utilregisteredcorporation tables. Per the instructions, it should be "char" or "corp" and then the name of the api, so I'm putting in items like:
Quote:
charAccountBalance charAssetList charCharacterSheet charIndustryJobs charKillLog charMarketOrders charSkillInTraining charSkillQueue charStandings charWalletJournal charWalletTransactions corpAccountBalance corpAssetList corpCorporationSheet corpDivisions corpWalletDivisions corpLogo corpIndustryJobs corpKillLog corpAttackers corpItems corpVictim corpMarketOrders corpMemberTracking corpStandings corpStarbaseDetail corpCombatSettings corpFuel corpGeneralSettings corpStarbaseList corpWalletJournal corpWalletTransactions


I am not seeing any errors in the logs, and the yapeal/cache/char and corp folders are not getting xml documents.

I've been staring at this for days and I don't see what I'm doing wrong. Any ideas?
Thanks,
Elnar


It looks like your mixing the character and corporation apis. Corporation apis need to be in utilRegisteredCorporation and character apis need to be in utilRegisteredCharacter

Elnar Khad
Minmatar
Legion of the Locust
Posted - 2009.09.06 17:58:00 - [302]
 

Edited by: Elnar Khad on 06/09/2009 18:07:39
Sorry I wasn't clear when I made that post. I do have them split appropriately. I just copy/pasted both sets into the forum for review.
Am I putting the wrong capitalization/spelling in there? Like I said, I know the api's are pulling appropriate information since I'm getting the character lists in accountcharacters and I did get an error message the other day when I let one of the accounts lapse and had to reactivate it.

Just again to confirm, in utilregisteredcharacter I have:
activeAPI=The API's posted prior with "char" in the beginning
characterID=My character ID confirmed from accountcharacters
corporationID=The ID of my corp, also confirmed from accountcharacters
corporationName=The plaintext name of my corporation
graphic=Not touched
graphicType=null is checked, nothing else added
isActive=1
name=The plaintext name of my character
proxy=null is checked, nothing in the box (not using a proxy)
userID=userID for the account that CCP gave me (along with the API)

The utilregisteredcorporation is filled in similarly.

I AM using other character monitoring applications (like EveMon and the windows gadget skill checker made by Lawrence James) Could they be grabbing the information first? I have not had a problem with multiple API applications before.
I'm stumped.
Thanks again for the help.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.06 19:03:00 - [303]
 

Edited by: Dragonaire on 06/09/2009 19:20:52
The problem is the docs haven't caught up the the code it seems, sorry about that. Try putting the API names in without adding "char" or "corp" to them that was a change that was made when updating to use utilSections table etc. that just was done a couple weeks ago. I'll look through the docs again and try to get them updated as it seems I missed that. Maybe a little while as I was just up until 5am re-doing Linux on my development machine after making mistake of trying the bleeding edge version of my desktop and still trying to get everything setup right again Razz.

Also if you could tell me which docs you were looking at might be helpful in tracking down what needs updated Wink

Elnar Khad
Minmatar
Legion of the Locust
Posted - 2009.09.06 20:08:00 - [304]
 

It was the "Getting Started" guide on http://code.google.com/p/yapeal/wiki/GettingStarted

I'll try it out and see if that gets it.
Thanks for the quick replies!
Elnar

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.06 20:40:00 - [305]
 

Guess you missed this:
Deprecated - Use web installerWink

I've updated it to:
WARNING Deprecated - Use web installer

but I did update the part about adding APIs to reflect the setting for ActiveAPI also while I was at it.

Pricecheckinaisle Amarr
Posted - 2009.09.08 13:24:00 - [306]
 

I did miss that, although even using the web installer, a person would still need to put their API information and the items in the "ActiveAPI" field by hand. Unless there is a different web installer I don't know about. Sad

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.08 18:09:00 - [307]
 

In install/setup.php it does have a test character section to it after the basic config but it only does one char and corp. It wasn't made as a full application just something to help people try it out before building their own app around it Wink

We are working on adding some wrapper classes around the utilRegistered* table to make it a bit easier for anyone using it to work with them. They are in alpha testing now and should be done within a couple weeks. Also just started on some per char/corp on-demand style API classes that should be useful for apps that don't want, need, or can't use crontab for some reason.

Elnar Khad
Minmatar
Legion of the Locust
Posted - 2009.09.08 18:12:00 - [308]
 

My web host apparently did not install the CLI version for PHP (only the CGI) I'm paid up through the year, so I don't want to switch hosts yet.
Any idea if I can get this working?
Thanks,
Elnar

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.08 18:19:00 - [309]
 

I know some people have had some luck using Yapeal with CGI instead but it's not something I've done. From what I understand of it you may be able to just use it directly but not sure. Have a look in the issues and wiki for some pointers that might help.

Cory Sopapilla
Minmatar
Kiroshi Group
Posted - 2009.09.14 15:15:00 - [310]
 

My table serverServerStatus still shows the last known good API pull rather than a status of the API being offline. Is this something addressed in a newer version I don't have?

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.14 16:49:00 - [311]
 

When they take the API servers off line like that there's no way to get a new status so it doesn't update it again until a new one is available. If you want to know if it's stale also look at the date/time and if it's more then say 15 minutes old it's probably not being updated. Once again this is something to be handled in the application being developed it's not Yapeal's place to be deciding if it should return something other than what the API servers tell it as that would be beyond it's function which is to only return the most complete and current data as possible in a useful format for you to use.

Quote:
In computer science, a library is a collection of subroutines or classes used to develop software. Libraries contain code and data that provide services to independent programs.
from Wikipedia

You are the programmer for the 'independent program' that uses it but Yapeal isn't the program it just makes it easier to write one IMHO anyway Wink

Cory Sopapilla
Minmatar
Kiroshi Group
Posted - 2009.09.15 15:57:00 - [312]
 

I know. Was just checking to see if you had put any timeouts to grab an error value or something in newer versions before I wrote it myself ;)

Thanks for the feedback though.

Scribbly
Posted - 2009.09.17 02:13:00 - [313]
 

Hi guys,

This looks very promising and I hope I can get it to work correctly as have loads of ideas for it. I have been able to get it to pull data from the API as I now have assets, transactions etc. However it does not seem to be updating my characters account balance. I do see the following message

[2009-09-17 01:15:04.070]
NOTICE:
Message: Upserting 1 records for charAccountBalance
File: /xxx/yapeal/class/YapealDBConnection.php
Line: 240

and should I be concerned about the following message?

[2009-09-17 01:15:10.686]
NOTICE:
Message: Peak memory used:2621440
File: /xxx/yapeal.php
Line: 200

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.17 05:30:00 - [314]
 

The peak memory use is nothing to worry about that is just there as it says as a notice. If you ever see one larger than about 12 MB do let me know as I've been trying to reduce that and in my testing it's not going over about 12 MB now.

Do you see a record in the charAccountBalance table? If not then there might be a problem. First make sure you've activated that API both in the utilSections->char->activeAPI setting and in the utilRegisteredCharacter. You might also try deleting the record and see if it reappears if it does it's being updated but the API isn't changing which is an issue for CCP to solve Wink

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
Posted - 2009.09.17 09:45:00 - [315]
 

Originally by: Dragonaire
The peak memory use is nothing to worry about that is just there as it says as a notice. If you ever see one larger than about 12 MB do let me know as I've been trying to reduce that and in my testing it's not going over about 12 MB now.

Do you see a record in the charAccountBalance table? If not then there might be a problem. First make sure you've activated that API both in the utilSections->char->activeAPI setting and in the utilRegisteredCharacter. You might also try deleting the record and see if it reappears if it does it's being updated but the API isn't changing which is an issue for CCP to solve Wink


I would also check the utilCachedUntil table to see if it has an entry for charAccountBalance.

Scribbly
Posted - 2009.09.18 02:53:00 - [316]
 

ok I have it working!!! This is the coolest thing since sliced bread!

Whats the chances of finding/getting a table with all the eve items in it? Will let me match up transactions, assets etc

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.18 04:37:00 - [317]
 

For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.19 17:38:00 - [318]
 

Ok someone has found an error in the charMarketOrders and corpMarketOrders tables that is cause duplicate records to be created. You can read more about it at
http://code.google.com/p/yapeal/issues/detail?id=21
and find the fix at
http://code.google.com/p/yapeal/wiki/Issue21fix

I'll be releasing an update in a couple days for Yapeal but because of the nature of the error the above instructions MUST be used first or running install/setup.php again will either fail or end up deleting all you data which could be a bad thing on a production application with real data you'd like to keep.

Scribbly
Posted - 2009.09.21 01:31:00 - [319]
 

Originally by: Dragonaire
For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table.


Do you know if any of these dump table names would clash with Yapeal? Would like to know so I can import it all into the same database to keep the complexities of the queries down

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
Posted - 2009.09.21 05:23:00 - [320]
 

Originally by: Scribbly
Originally by: Dragonaire
For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table.


Do you know if any of these dump table names would clash with Yapeal? Would like to know so I can import it all into the same database to keep the complexities of the queries down


nope, and you can set table prefixes for yapeal tables

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.21 16:13:00 - [321]
 

Ok I've deployed the fix for issue 21 to trunk all existing users please make sure to look at http://code.google.com/p/yapeal/wiki/Issue21fix before updating as this revision could cause you problems like lost of data.

ChriztaneE
Posted - 2009.09.27 10:06:00 - [322]
 

Edited by: ChriztaneE on 27/09/2009 10:11:52
Hi. I have a problem with Yapeal, when everything is installed and the setup is finished. Going to the CONFIG menu it keeps asking to update the database, and everytime I UPDATE it takes me to the config menu, but it only sends me back to the update menu again, when hitting any buttons..

Also hitting the command prompt xxx\php5.3.0\php.exe -f xxx\yapeal.ph gives an error in common_backend.php on line 62 <- maybe these problems is connected?

ChriztaneE
Posted - 2009.09.27 10:39:00 - [323]
 

Originally by: ChriztaneE
Edited by: ChriztaneE on 27/09/2009 10:11:52
Hi. I have a problem with Yapeal, when everything is installed and the setup is finished. Going to the CONFIG menu it keeps asking to update the database, and everytime I UPDATE it takes me to the config menu, but it only sends me back to the update menu again, when hitting any buttons..

Also hitting the command prompt xxx\php5.3.0\php.exe -f xxx\yapeal.ph gives an error in common_backend.php on line 62 <- maybe these problems is connected?


Found out it has to do with the date in yapeal.ini.. Tried to change this from $Date:: 2009-08-28 19:31:54 #$ to Date .. Then cmd says im missing all elements in yapeal.ini (Cahce, Databse and Loggin)

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.09.27 19:47:00 - [324]
 

Sound like you maybe try to use an yapeal.ini file from before the latest changes to it's format. I would suggest backing it up and then deleting it and try running setup again and see if it doesn't work better for you. The installer should have been able to update it for you but not sure how well that was tested.

On a related note look for Yapeal to be moving to a totally new and different installation and configuration system soon(tm). It will have a multi-platform GUI and CLI installer instead of the current drop into web directory and configure system. The current system will be kept in place for now but long term it will need to either be rewritten or just dropped if it is determined that it isn't needed anymore.

Zebullon
Gallente
Cursed Inc.
Not Found.
Posted - 2009.10.03 12:16:00 - [325]
 

I have the same problem as ChriztaneE and I can't resolve it...
The problem is certainly with the date or the release version...

The error message when I run the yapeal.php:
Notice: Yapeal version 898 (beta) 2009-09-21 18:06:41 in xxx\inc\common_backend.php on line 62

In my yapeal.ini file, I have this data :
date="$Date:: 2009-09-02 17:59:29 #$"
version="$Revision: 849 $"

If I change the date and version whith the data in error message, it's the same think.
When I delete yapeal.ini and run setup.php, it's again the false data...

I think it's OK for the data base (70 tables created), and I've filled the table correctly...

could you help me ?

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
Posted - 2009.10.03 12:48:00 - [326]
 

Originally by: Zebullon
I have the same problem as ChriztaneE and I can't resolve it...
The problem is certainly with the date or the release version...

The error message when I run the yapeal.php:
Notice: Yapeal version 898 (beta) 2009-09-21 18:06:41 in xxx\inc\common_backend.php on line 62



It always throws that notice, if there are no other problems and your getting data into the database, do not worry about it. Its just to let you know it has ran.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.10.03 19:13:00 - [327]
 

Notice: Talks about something that someone may find interest to look at

Warning: Something probably went wrong but the program could continue to run. Can mean an bug in the program or just some bad input and output (GIGO)

Error: Something went wrong and the program stopped running. Usually a bug in the program that needs fixed. Can be cause by either logic error or getting unexpected data that wasn't taken into consideration by programmer in program which probably needs to be fixed also.

Exception: Similar to a warning and usually used to handle something that might cause an error if it hadn't been caught by the programmer and handled in some way.

Uncaught exception: This is a exception that happens when the programmer some how missed handling an exception but was smart enough to add something to let him know he missed it.

From the above the only ones that normally need to be worried about are warnings, errors, and uncaught exception and be reported as they will need to be fixed or at least figured out why they have happened. Notices and exception are mostly use to help figure out where something want wrong or right, or just so you know something is really happening Wink

Zebullon
Gallente
Cursed Inc.
Not Found.
Posted - 2009.10.04 06:59:00 - [328]
 

OK, thanks form the explication.
My configuration should be OK because the file TranquilityapiseverServerStatus.xml is correctly downloaded... But I have any other file... (I have any notice for the other files in logs)

I have certainly misinformed the rows in Database, but I don't now why...
In the table utilregistereduser : I have filled the full and limited api and userid correctly, and isActive=1.
In the table utilregisteredcorporation : I've only filled AccountBalance in activeAPI for the test, characterID and corporationID are filled and isActive=1. Do I filled the field proxy ? with "http://api.eve-online.com/%2$s/%1$s.xml.aspx" ?
In the table utilregisteredcharacter : I've only filled WalletJournal in activeAPI for the test, corporationName, name, userID, characterID and corporationID are filled and isActive=1. Do I filled the field proxy ? with "http://api.eve-online.com/%2$s/%1$s.xml.aspx" ?
In the table utilconfig : fields charAPIs and corpAPIs are null... is it normal ?

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2009.10.04 16:58:00 - [329]
 

The proxy can be left blank except if you want/need to use one. The default is to use the normal API servers if not set.

Quote:
In the table utilconfig : fields charAPIs and corpAPIs are null... is it normal ?

If you didn't run the config/install that would be normal and that table isn't use by anything but it and can be ignored.

Do make sure in the utilSections table you've add the APIs to activeAPI that you want to get for each section as they act as an admin override to what utilRegisteredCharacter/Corporation are allowed to do and of course isActive needs to be set in it too. Wink

ChillingEchos
Posted - 2009.10.04 17:53:00 - [330]
 

Was wondering if anyone happened to have the solution to working around the killLogs flag field being set to zero except when its drones or cargo bay?

Found in :
/char/KillLog.xml.aspx

Results :
<rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed">
<row typeID="3520" flag="0" qtyDropped="3" qtyDestroyed="1" />
<row typeID="12076" flag="0" qtyDropped="0" qtyDestroyed="1">
<rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed">
<row typeID="12259" flag="0" qtyDropped="0" qtyDestroyed="1" />
<row typeID="1236" flag="0" qtyDropped="2" qtyDestroyed="1" />
<row typeID="2032" flag="0" qtyDropped="1" qtyDestroyed="1" />
</rowset>

Notice how all the flags are 0. in the more broad list there are only flag number 87 and 5 of which are drones and cargo bay items.

Not sure if I have a glitch somewhere or maybe everyone else has found the work around? Or, perhaps like most of my related troubles it is something literally staring me in the face and I just dont see it.

While I'm at it. The yapeal sql for kill data uses the 'lft' 'lvl' 'rgt' fields to show the items. I may need to see if anyone can help me understand the intended use. I really cant help but to think that I may be having a glitch in my Yapeal install cause there are no "apparent" order to the results a couple will be ok and right in terms of how they were fitted on the ship then viola, gets scattered all over the place.

I could use a bail me out our if anyone got a minute and knows what I am doin wrong and can maybe help me figure out what to do with the flags ( god knows having to manually install slots of each item would be awful )

Any help appreciated, and on BIG round of applause to yapeal crew, brilliant work!

Cheers


Pages: first : previous : ... 7 8 9 10 [11] 12 13 14 15 ... : last (24)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only