Pages: [1] 2 3 4 5 6 7 8 9 10 11 .. 11 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Dragonaire
Here there be Dragons
56
|
Posted - 2014.07.24 22:21:00 -
[1] - Quote
Yet Another Php Eve Api Library also know as Yapeal which can be used to access the Eve Online API data and place it into a database.
Welcome to the new Yapeal forum thread.
I decided with all the changes that have been happening with Yapeal it was time to start a new one since 99% of the old one was of no use to anyone interest in the current version of Yapeal. The old version lasted over 5 years with all the updates to it but it's time to let it go and start looking to the future now.
You can find the old thread here. All 26 pages of it. The last couple pages might be useful to you for this version but I expect all the info you might have found there to end up here soon again as well. Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |
Dragonaire
Here there be Dragons
56
|
Posted - 2014.07.24 22:21:00 -
[2] - Quote
Reserved Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |
Legedric Striker
Blue Republic RvB - BLUE Republic
31
|
Posted - 2014.07.25 03:57:00 -
[3] - Quote
Ok, as I am at my pc again and I tried the new master branch with composer, here is what I get after I run "composer install -o":
Quote:C:\yapeal-master>composer install -o Loading composer repositories with package information Installing dependencies (including require-dev) from lock file Warning: The lock file is not up to date with the latest changes in composer.jso n. You may be getting outdated dependencies. Run update to update them. Your requirements could not be resolved to an installable set of packages.
Problem 1 - The requested package php could not be found in any version, there may be a typo in the package name. Problem 2 - The requested PHP extension ext-xsl * is missing from your system. Problem 3 - The requested package php could not be found in any version, there may be a typo in the package name. Problem 4 - Installation request for guzzle/guzzle v3.9.1 -> satisfiable by guzzle/guzzle[v3.9.1]. - guzzle/guzzle v3.9.1 requires php >=5.3.3 -> no matching package found.
Several others follow after this until Problem 37. But they more or less repeat what problem 4 is saysing: A package is being requested, the package needs php 5.3.X and there is no matching package found...
However, I do have PHP 5.4.31 installed on my machine and it is running for several other projects just fine in my IIS webserver, so I don't know why composer refuses to recognize my php installment, although I selected the right PHP folder patch during the composer installation :(
So "Problem 1" is my real issue, the rest are just follow up issues. Join R-v-B-- The MOST active PVP community in EVE! |
Dragonaire
Here there be Dragons
56
|
Posted - 2014.07.25 04:40:00 -
[4] - Quote
Okay so basically though you might have PHP 5.4 installed for your webserver it doesn't seem to be in your path where composer can find it or it is finding a different version. Try running 'php --version' from cmd prompt and see if it sees the correct version if not you'll need to fix your path. Use 'env' if you are getting a different version and look at your PATH setting in there to see if there's a older version listed before PHP 5.4. You'll need to go in and fix it if it's wrong. You'll need t do web search for how to updated path for your version of Windows because there are some difference how you get to it depending on version used etc.
A neat tool I found for things like this is http://www.rapidee.com/en/about you might want to check it out.
Once you have the path set right so composer can find and use the correct version most if not all of your problems should be solved as you said. Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |
Legedric Striker
Blue Republic RvB - BLUE Republic
31
|
Posted - 2014.07.25 05:32:00 -
[5] - Quote
Oh boy, of course I forgot to set the PATH variable to the new PHP path... shame on me
However, the Composer part worked but your next step, the CONFIG.md ends quite abrupt in line 94:
Quote:Let say you have a `config/yapeal.yaml` file that has these settings:
``` Yapeal: Database: database: yapeal password: secret tablePrefix: '' userName: YapealUser ... ```
And you have
No more content after this line, so I guess your file got somehow corrupted or you committed an incomplete file
PS: I pulled a fresh zip from your master branch which included the incomplete CONFIG.md file. Join R-v-B-- The MOST active PVP community in EVE! |
Legedric Striker
Blue Republic RvB - BLUE Republic
31
|
Posted - 2014.07.25 05:58:00 -
[6] - Quote
Ok so I continued on my own and took my "cmd" to the yapeal\bin folder and executed the "yc" command. First error I encountered was that the system tries to find the config file in "yapeal/bin/config/yapeal.yaml" which isn't there as it is in yapeal/config/.
So I too -c as an argument and added a configuration file manually... still "not accessible" error...
After that I passed the database configuration with single arguments (-u... -p... etc.) and the next error... Could NOT find SQL file yapeal/bin/bin/sql/CreateDatabase.sql .... (continued for each .sql file)
So I went into Console\Command\DatabaseInitialized.php and change line 312 from
Quote:$file = $this->getCwd() . '/bin/sql/Create' . $fileName . '.sql';
to
Quote:$file = $this->getCwd() . '/sql/Create' . $fileName . '.sql';
To get rid of the double "bin" in there with the result that all my tables are setup properly right now
I will try to figure out the next steps and keep you posted about what trouble I encounter Join R-v-B-- The MOST active PVP community in EVE! |
Legedric Striker
Blue Republic RvB - BLUE Republic
31
|
Posted - 2014.07.25 06:39:00 -
[7] - Quote
Ok as your wiki seems to be outdated (I know, you told me so in your OP) I want to ask some questions:
1. Which file should I have to include into my project to get yapeal functionality into it? Should it be lib/Yapeal.php? I know you prefer to use composer, but I don't
2. When I want to add and API key, do I only have to populate the tables accountapikeyinfo, accountcharacters and accountkeybridge or also the table utilregisteredkey?
3. How do I refresh the API data for a single character? I only found the instructions to just start "auto magic", which will updated all active API keys - which may get me some huge performance issues as I am planning to have many characters/accounts within my database.
4. How do I refresh the API data just for a single section? So for example: Only the wallet section of one character and not all API information for this character at once?
Thanks in advance! Join R-v-B-- The MOST active PVP community in EVE! |
Dragonaire
Here there be Dragons
56
|
Posted - 2014.07.25 16:42:00 -
[8] - Quote
Easiest way to get a good working yapeal.yaml is much like with the older version where you copy over the yapeal-example. * file and make any needed changes to it.
For getting help on any of the 'yc' command just run it without any parameters or options. For the individual commands themselves use 'yc help command'. To understand the new console commands in general look at the docs for the Symfony2 console as that is what's being used to create them.
The reason you were having problems run the 'yc D:I' command is it was made to be run from the root directory so needs to be run from 'yapeal' directory from your example. It does need some work to make it better as it was kind of hacked together in just a day or two but works well within it's limitations. The reason it was adding 'bin' in your case is anytime you give it a relative path it assume you want it to use the current working directory. This is common with many other CLI commands on all platforms. If you look in the bin/yc file you'll see where it gets the CWD and passes it on for the commands to use.
1. How do I refresh the API data for a single character? First I'll state that Yapeal is made to be run as a crontab or scheduled task EVERY minute to keep everything up to date. If you do run it this way even though no one seems to believe it it'll actually help increase your performance over all by NOT having all the APIs 'come due' so to say at the same time. The idea is you have a database that is always as up to date as the API server allows and you don't need do anything to make that happen in your application.
That being said the new version has been design to allow individual API classes to be called directly. This is mainly meant for things in your application like new account creation where you need something more interactive. It can also be used for cases where you want a single snapshot of the data and don't want to have it changing while looking at it.
To use Yapeal in this mode you'll be using the oneShot() method. This method is the same method that autoMagic() calls to do the actual work of getting the XML and putting it into the DB. I thought about trying to add a quick guide here on how to use oneShot() but it would be to long and the formating on the forums here sucks to put it kindly. I think its better to do this a wiki page so I'll try to put one together that should help everyone find their way on this new feature. Finds camping stations from the inside much easier. Designer of Yapeal-á for Eve API. Check out the Yapeal PHP Library thread for more information. |
Legedric Striker
Blue Republic RvB - BLUE Republic
31
|
Posted - 2014.07.25 17:51:00 -
[9] - Quote
Sounds great!
I worked on my project nearly the whole day and I managed to integrate the first parts of Yapeal into it and it's working like a charm
In addition, as I did not know about the oneShot method, I managed to rework parts of my project for being able to run Yapeal the way it is intended to be run: As a fixed cronjob every couple of minutes.
Looks great so far and I will continue working on my project. Although it will still take some weeks at least to be ready I can't wait to launch the project and see how Yapeal will work with lots of users in my database Join R-v-B-- The MOST active PVP community in EVE! |
Tiberius Zol
22
|
Posted - 2014.07.25 22:58:00 -
[10] - Quote
I get it working on a seperate DB now.. so far so good... My question is: what is to do if i want to upgrade from 1.0 to this version? Is there any table conversion with all my old data? And which APIs don't work in 2.0. ? |
|
Dragonaire
Here there be Dragons
56
|
Posted - 2014.07.26 05:56:00 -
[11] - Quote
Tiberius Zol - If you do a data only export on most of the API tables they should import into the new ones okay. There are several APIs of course like IndustryJobs that have had a lot of changes to them which probably won't work without a lot of work. Also most of the old util Tables have had major changes to them. The only one that really matters there is utilRegisteredKey. If you delete the couple of columns that no longer exist on it you can export and import it as well. There is a outdated bin/sql/Update_1.0.4-1.1.x.sql file you may find some what useful but mostly not.
I can look into making a SQL file that would make the transfer easier but if there's only a couple of people needing to do so it might be just as easy to help them directly with problems and continue working more APIs than spend time on making something that will only be used a couple times.
As to which APIs have been done the best way to know is to look if there is an existing class for it in lib/Database/* directories. If you see a php and xsd file for it it's should be a working API but also have a look at the Database/TODO.md which I just updated. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Tiberius Zol
22
|
Posted - 2014.07.26 18:48:00 -
[12] - Quote
yeah i see.. will wait for some more working APIs (like AssetLists and Standing, ...). noobquestion: i downloaded your stuff via git.. how can i update it if you do some changes? never worked with git before.. |
Dragonaire
Here there be Dragons
56
|
Posted - 2014.07.26 20:22:00 -
[13] - Quote
git update should work for you. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Tiberius Zol
22
|
Posted - 2014.07.26 22:25:00 -
[14] - Quote
this is...easy.. ^^ i will try it later |
Dragonaire
Here there be Dragons
56
|
Posted - 2014.07.29 20:39:00 -
[15] - Quote
Hi all so if you been paying attention to master branch you've seen a lot of bug fixing and several APIs added. In some cases APIs had been done on char/corp but not the other and the hole has now been filled.
I now need some input on which APIs people want to see done next so I've decided to try to get some. I'm calling it the 'Vote for your most needed API' campaign. I've added 'enhancement' issues for several of APIs on GitHub and I'd like to have people vote on their top 3 APIs they would like to see done next. I didn't add all of the missing APIs so if you want one that's not list please go ahead and add it since I was guessing at which ones people might want and part of the reason for the campaign is to let me know if I'm right. I plan on looking at the votes in about a week and no that doesn't mean I won't working on some other APIs this week just really need some feedback here.
Another thing that would help speed up getting some of the APIs done would be some helpers. I've had one person helping me a some of the APIs in Stephen but he got busy again in RL it seems so it's back to just me doing everything for now. So I'm looking for people that are interesting in learn more about Yapeal, the APIs, PHP, XML, or XSD to help with some of the APIs. This is also a good chance for people that really need an API done so they can finish their application they are write or hope to write with Yapeal to maybe get it a little sooner. Understand this isn't where I just throw an API at you and expect you to do it all by yourself though that cool if someone wants to try it but where I'm more of a mentor/QA/programmer available to help you as needed to make it work.
I'll also take help with re-doing/starting over on the Wiki or the include docs like CONFIG.md which I started but haven't got back to. Basically any place someone would like to do something just let me know so I can make sure not duping work.
Anyway as always thanks for use Yapeal. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Tiberius Zol
26
|
Posted - 2014.07.31 10:49:00 -
[16] - Quote
For me: - Char/AssetList - Char/SkillInTraining - Corp/AssetList - Corp/CorporationSheet
I really would help, but my PHP/Mysql knowledge are not more than rudimentary.. only theoretical OOP knowledge. Never used it in PHP. |
Legedric Striker
Blue Republic RvB - BLUE Republic
31
|
Posted - 2014.07.31 14:30:00 -
[17] - Quote
For me it would be: - Char/Mailbody - Char/AssetList
No need for the others ;)
Who needs SkillInTraining when you have the complete skill queue at hand? Join R-v-B-- The MOST active PVP community in EVE! |
Kolb
Novaku Inc Novaku Alliance
3
|
Posted - 2014.07.31 15:46:00 -
[18] - Quote
I think the CONFIG.md file cut off mid sentence, and I'm not 'getting' how to add api's to the system.
In the old system I made a util.php that included the classes, but I don't see an equivalent in version 2. |
Dragonaire
Here there be Dragons
56
|
Posted - 2014.07.31 17:02:00 -
[19] - Quote
Yeah I didn't finish writing the CONFIG.md I'll try to get back to it and push it out. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Tiberius Zol
26
|
Posted - 2014.07.31 18:53:00 -
[20] - Quote
Legedric Striker wrote:For me it would be:
Who needs SkillInTraining when you have the complete skill queue at hand?
yeah right.. shouldn't post after 40h without sleep.. |
|
Dragonaire
Here there be Dragons
56
|
Posted - 2014.07.31 21:48:00 -
[21] - Quote
Okay finished off what I was doing with CONFIG.md and pushed it along with some other minor things I noticed while writing it. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Kolb
Novaku Inc Novaku Alliance
3
|
Posted - 2014.08.01 13:08:00 -
[22] - Quote
Without the code from here in my script... https://github.com/Dragonrun1/yapeal/wiki/Using%20Yapeal%20Utils
I'm getting the error:
Fatal error: Class 'RegisteredKey' not found in /var/www/tools/applications/working.php on line 16
With the code I get:
/var/www/lib/yapeal/inc/common_paths.php): failed to open stream: No such file or directory in /var/www/lib/yapeal/util.php on line 12
Fatal error: require_once(): Failed opening required '/var/www/lib/yapeal/inc/common_paths.php' (include_path='.:/usr/share/php:/usr/share/pear')
I'm sure I'm just missing something obvious here but I'm blind to it. Can anyone give me a hand? |
Dragonaire
Here there be Dragons
56
|
Posted - 2014.08.01 13:48:00 -
[23] - Quote
That wiki page is for the older version (1.0.x) of Yapeal which is no longer really supported since it doesn't work with all the changes to the Eve APIs that have happened. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Kolb
Novaku Inc Novaku Alliance
3
|
Posted - 2014.08.01 13:59:00 -
[24] - Quote
:-)
So I've gathered, I'm just not seeing how to rework my app to use the new version of yapeal.
I know I'm just missing something, but I don't know what....
Is there a replacement method for:
// Make a new RegisteredKey instance. $regKey = new RegisteredKey(1156); // Add the vCode to keyID 1156. $regKey->vCode = 'abc123'; // Add the API Mask to keyID 1156. $regKey->activeAPIMask = 8388608; // Activate the API key. $regKey->isActive = 1; // Save the new API Key into the database. if ($regKey->store()) { print 'Registered new API Key: ' . $regKey->keyID . ' to the database.' . PHP_EOL; } else { print "API Key couldn't be added!" . PHP_EOL; } // Release everything. $regKey = NULL; unset($regKey); ?> |
Dragonaire
Here there be Dragons
56
|
Posted - 2014.08.01 14:33:00 -
[25] - Quote
Kolb - At this time none of the old Util classes have been replaced. Some of them of course are no longer needed because the tables don't exist like utilRegisteredChar|Corp|Section. I will look at possible add something to manage the couple of other tables like utilEveApi and utilRegisteredKey which are at this time the only ones you'll need to make changes to. Everything that was done with the other tables can be manages with just these two now. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Kolb
Novaku Inc Novaku Alliance
3
|
Posted - 2014.08.01 15:13:00 -
[26] - Quote
So, I need to directly add the API information into the yapeal_utilRegisteredKey table and let the yapeal cron job run?
Sorry if I'm being a hassle, I'm still a neophyte when it comes to coding. |
Legedric Striker
Blue Republic RvB - BLUE Republic
31
|
Posted - 2014.08.02 06:16:00 -
[27] - Quote
Kolb wrote:So, I need to directly add the API information into the yapeal_utilRegisteredKey table and let the yapeal cron job run?
Sorry if I'm being a hassle, I'm still a neophyte when it comes to coding.
As that's how I did it and it's working I'd say: Yes Join R-v-B-- The MOST active PVP community in EVE! |
Tiberius Zol
26
|
Posted - 2014.08.02 11:54:00 -
[28] - Quote
i have filled up the RegisteredKey table but the char/corp tables don't get filled.. cache dir are empty... i have run /bin/yapeal.php several times.. but yapeal fetch some account stuff only. Did i miss something? |
Kolb
Novaku Inc Novaku Alliance
3
|
Posted - 2014.08.02 14:11:00 -
[29] - Quote
Tiberius Zol wrote:i have filled up the RegisteredKey table but the char/corp tables don't get filled.. cache dir are empty... i have run /bin/yapeal.php several times.. but yapeal fetch some account stuff only. Did i miss something?
That's the same results I had, I think the scripts to populate those results are not ready? I'm also getting a segfault on corp wallets.
|
Dragonaire
Here there be Dragons
56
|
Posted - 2014.08.02 17:13:00 -
[30] - Quote
Clean install is best. All the APIs are on by default so as long as the class for that API has been done it'll work. Make sure when you add your info to utilRegisteredKey that isActive = 1 or the only thing you will see is the account stuff since basically it's hardwired on for account/APIKeyInfo and account/Characters. If it still doesn't seem to be working check the log files. log/yapeal.log and log/error.log should be helpful. If there's no error.log file that's normal but if it exist there something more troubling going on. As always make sure the cache directory is writable.
Kolb - About the segfault are you sure you are using PHP 5.4? Try running 'php --version' to check. Also if you can copy it for us here so we can see it or better yet open issue on GitHub with it and any log files were I can take a look at what's going on should be able to figure it out.
As always it's a good idea to go back through the steps in INSTALL.md and CONFIG.md files and make sure you didn't miss something. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
|
|
|
|
Pages: [1] 2 3 4 5 6 7 8 9 10 11 .. 11 :: one page |
First page | Previous page | Next page | Last page |