Originally by: Johnathan Roark

---

I haven't taken the time to look at it, but I'll see if it works better for some of my projects. I think you kind of miss the point of yapeal. Its not really a library in the traditional since. Most projects are going to take data from the API, do what ever, then that data ends up in a database. Yapeal skips directly to putting the data into a database. I do agree that documentation could be better.

---

Quote:

---

Even with that goals it should be configureable through Code, not by ini only ...

---

Quote:

---

... putting direct in the database means you have to fetch from there, process the data, and then put it down in the way you need it

---

Originally by: Dragonaire

---

Quote:

---

... putting direct in the database means you have to fetch from there, process the data, and then put it down in the way you need it

---

You're doing something wrong if you're trying to store the data again outside the DB instead of using it directly through selects with joins etc as needed.

---

Originally by: Catari Taga

---

Libraries are a convenience, they make coding faster, never your application.

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

Originally by: Dragonaire

---

The only things that are in the ini is the DB user/password stuff (can't store them in the DB since they are needed to access it ) and stuff dealing with logging and caching which really doesn't need to be configure by anyone but the developer using it as a library in their application.

---

Originally by: Dragonaire

---

You're doing something wrong if you're trying to store the data again outside the DB instead of using it directly through selects with joins etc as needed. If you're not use to DBs, which I wasn't really until a couple projects ago, you try doing stuff like that instead of letting the DB work for you. Once I learned how they can help you for things like this I'd never go back but I also know they aren't for every project either.

---

Originally by: Dragonaire

---

In the end it all depends on the application. For people use to developing 2-3 tier web applications Yapeal is a better fit.

---

Originally by: Dragonaire

---

For simple one tier ones like your talking about what you've made works well and the project that Yapeal grow out of had much the same idea but in the end didn't scale well until it move to something with a database and the more modern multiple tier model. There's always room for other ideas how to do things and hopefully some people will find Pheal useful for them in some of their projects just like many people have found Yapeal and ALE to be in many others.

---

Originally by: Catari Taga

---

we are discussing special purpose vs. do it all code, special purpose will almost always be more efficient, even or in particular on OS level

---

Originally by: Zeke Mobius

---

I swear the catholic church was faster at admitting the earth was round than CCP at fixing stuff.

---

Originally by: Amida Ta

---

Or in EveAI if you need Blueprints for Products thats a single memory read. It's impossible to be more efficient than that. No matter how special-purpose your code is.

---

Originally by: Peter Powers

---

Originally by: Amida Ta

---

Or in EveAI if you need Blueprints for Products thats a single memory read. It's impossible to be more efficient than that. No matter how special-purpose your code is.

---

Is it?, even if i have a list of products,
an exclusion list of products, and only need those that
are not excluded with blueprints, but need all of 'em to be in my object tree?
if this is one read, then i end up either with data that i dont use (using your generic implementation),

---

Quote:

---

As a developer using it as a library i am not supposed to know how the database setup, or the pathes for caches are at the users side.
i do want to offer the user a way to configure it, but i do not want him to edit ini files of libraries that he does not need to know about.

---

Quote:

---

Cached data does not belong in the database, unprocessed data, which is stored processed in the database does not need to be there either, no point in having double the amount of data arround.

---

Quote:

---

Data that does not need to be processed at all - well can be served directly from the cache, being much faster than using a database inbetween.

---

Quote:

---

No.

---

Quote:

---

And as soon as the data you serve gets more complex, the last thing you want todo is serve complex joins straight from the database. You serve them through various ways of caching, or you kill you whole setup.

---

Originally by: Dragonaire

---

Right so you offer the option to configure them along with anything else you let your end users change in your application and you handle updating the ini file inside the application because they don't care what part of the code you are using needs it.

---

Originally by: Dragonaire

---

I agree that if you already have it in a preprocessed/full processed state you really don't need to store the raw data too but as I found out lots of people wanted the XML cached where they could get at it so listening to my users (the application developers) I give them the option to cache the XML as files or in the DB but it's not required for Yapeal to work and can be turned off if not wanted.

---

Originally by: Dragonaire

---

Originally by: Peter Powers

---

Data that does not need to be processed at all - well can be served directly from the cache, being much faster than using a database inbetween.

---

If you are showing the XML directly to the user than that is true but I'm guessing you aren't doing that

---

Originally by: Dragonaire

---

once you have to start translating all those wonderful TypeID numbers etc into names and pictures in your application using the static data dump from a DB it makes more sense to combine the API data from a DB table with it than having to process the XML on every page refresh for hundreds or thousands of items.

---

Originally by: Dragonaire

---

Are there ways to do it so you don't have to do that yes but once you start coding things to do that you're starting to duplicate in you application things that have already been solved by other people in all the exist caching libraries for PHP, in the web server or in effect making your own custom DB server.

---

Originally by: Dragonaire

---

Originally by: Peter Powers

---

No.

---

???

---

Originally by: Dragonaire

---

I agree and was in effect saying much the same thing above. Simple joins on tables with good indexes don't take any extra time. If that wasn't true why would DBs have been developed to start with

---

Originally by: Dragonaire

---

You've developed Pheal/EAAL for an application/framework you've made which is much the way the code that became Yapeal started out as in an application I developed for my corp. So it was a solution to a need you had which is good and it seems you took some time to make it in a way that allowed it to be translated fairly easily from Ruby to PHP which is great

---

Originally by: Dragonaire

---

You seem to have even made it in a general enough way that others might be able to use it as well

---

Originally by: Dragonaire

---

but I'll bet the chances are once people do start using it in ways you never thought of yourself you'll find changes will need to be made.

---

Originally by: Dragonaire

---

Yapeal has been doing that every since I made it public over a year ago and continues to change as the APIs and the applications it is used in grow and change as well.

---

Originally by: Peter Powers

---

right, because writing a config file through the application is much more efficient, than using configuration which the application needs anyways.
If i for example use a database, then i dont want it to be configured in two places,
i want my frameworks / applications database connection data, and IF i'd agree (which i dont) with an API library writing to the database (yeah, a data import library which writes to the database directly not using my model...), then i would want my application to directly tell the library what todo, not write an additional file.

...

---

$db = mysql_connect(...);
$ale = AleFactory::getEVEOnline(array('cache.db' => $db));

Originally by: Peter Powers

---

EAAL and Pheal are designed to NOT need changes when CCP adds new pages to the API, thats one of the design goals, and it works for EAAL quite well (and will for Pheal too). Its one of the things that i think where missing in Yapeal or Ale.

---

Originally by: Lumy

---

And that's why Ale allows you to pass it active database connection. Something like this:

$db = mysql_connect(...);
$ale = AleFactory::getEVEOnline(array('cache.db' => $db));

For what it matters, you can define/override any value from config file in same way.

Just saying...

---

Originally by: Peter Powers

---

EAAL and Pheal are designed to NOT need changes when CCP adds new pages to the API, thats one of the design goals, and it works for EAAL quite well (and will for Pheal too). Its one of the things that i think where missing in Yapeal or Ale.

---

Originally by: Kaylana Syi

---

I have both but currently really enjoying Mecurial, and it is github's main competitor. It doesn't really need to have all the change tracking, but it would be nice to be able to use the latest repo using Mecurial. I don't want you to do double work but it would be nice to get better accessibility.

---

Originally by: Kelas Tovat

---

Hi, I have been playing around with this library, it's pretty nice. I have one problem though, I have been using it on a dev server I have at home but when it gets really cold here my internet connection gets flaky, this causes a problem when the cache file is out of date and the API server can't be contacted.

I think it would be nice if you added an argument to the cache->load method that allows for forced loading of the cached file. That way if you can't load data from the API you can simply force the loading of expired data from the cache.

---

Originally by: Kelas Tovat

---

I think it would be nice if you added an argument to the cache->load method that allows for forced loading of the cached file. That way if you can't load data from the API you can simply force the loading of expired data from the cache.

---

Originally by: "code"

---

PhealConfig::getInstance()->cache = new PhealFileCache();

---

Originally by: "code"

---

PhealConfig::getInstance()->cache = new PhealFileCacheForced();

---

Originally by: Peter Powers

---

I don't know if Wollari is going to add a few words to this thread.

---

Quote:

---

echo $api->CharacterSheet(array("characterID" => $character->characterID))->skills[24]->skillpoints;

---

Originally by: Ghorth

---

echo $api->CharacterSheet(array("characterID" => $character->characterID))->skills[24]->skillpoints;

This will get me the amount of skillpoints for the skill at index 24.

But what if you want to get ALL your skills?
and how do you get the naming of the skill (typeID to name)?

Regards

---

try {
 $API = new Pheal($userID, $apiKey, 'char');
 $sheet = $API->CharacterSheet(array('characterID' => $characterID));
} catch (PhealException $E) {
 // do something with the error $E->getCode();
 // maybe mark your API Key as Invalid (see CCP's error codes, etc)
}

$skillpoints = 0;
foreach($sheet->skills AS $skill)
 $skillpoints += $skill->skillpoints;

Quote:

---

Warning: SimpleXMLElement::__construct()

---

Quote:

---

$pheal = new Pheal();
try {
$result = $pheal->eveScope->FacWarStats();
$result = $pheal->ApiPage();
$rawxml = $pheal->xml;
} catch(PhealException $e) {
echo 'error: ' . $e->code . ' meesage: ' . $e->getMessage();
}

---

Originally by: Wollari

---

Originally by: Ghorth

---

echo $api->CharacterSheet(array("characterID" => $character->characterID))->skills[24]->skillpoints;

This will get me the amount of skillpoints for the skill at index 24.

But what if you want to get ALL your skills?
and how do you get the naming of the skill (typeID to name)?

Regards

---

You just loop through the skills and count them

try {
 $API = new Pheal($userID, $apiKey, 'char');
 $sheet = $API->CharacterSheet(array('characterID' => $characterID));
} catch (PhealException $E) {
 // do something with the error $E->getCode();
 // maybe mark your API Key as Invalid (see CCP's error codes, etc)
}

$skillpoints = 0;
foreach($sheet->skills AS $skill)
 $skillpoints += $skill->skillpoints;

For the real names of the Skills/Items you better take a look into the Static Database Dump (invTypes/eveNames) and match this with the typeID

---

$skillpoints = 0;
foreach($sheet->skills AS $skill){
 $skillpoints = $skill->skillpoints;
}

Originally by: Aglaia Adrastos

---

I'm trying some tests to get to know this library but i gather its only me getting issues :P

Quote:

---

Warning: SimpleXMLElement::__construct()

---

and a lot of them. the code I'm using is;

Quote:

---

$pheal = new Pheal();
try {
$result = $pheal->eveScope->FacWarStats();
$result = $pheal->ApiPage();
$rawxml = $pheal->xml;
} catch(PhealException $e) {
echo 'error: ' . $e->code . ' meesage: ' . $e->getMessage();
}

---

Maybe i'm miss understanding something but it caches the file fine and so on, just doesn't print the xml.

---

Originally by: Aglaia Adrastos

---

found the foreach was adding up skill points to display total not each one as a new record.

$skillpoints = 0;
foreach($sheet->skills AS $skill){
 $skillpoints = $skill->skillpoints;
}

---

Originally by: Aglaia Adrastos

---

I'm trying some tests to get to know this library but i gather its only me getting issues :P

Quote:

---

Warning: SimpleXMLElement::__construct()

---

and a lot of them. the code I'm using is;

Quote:

---

$pheal = new Pheal();
try {
$result = $pheal->eveScope->FacWarStats();
$result = $pheal->ApiPage();
$rawxml = $pheal->xml;
} catch(PhealException $e) {
echo 'error: ' . $e->code . ' meesage: ' . $e->getMessage();
}

---

Maybe i'm miss understanding something but it caches the file fine and so on, just doesn't print the xml.

---

Quote:

---

$skillpoints = 0;
foreach($sheet->skills AS $skill){

$ergebnis = mysql_query("SELECT * FROM " . $evedb . ".invTypes WHERE typeID = '".$skill->typeID."'", $intel);
while($ds = mysql_fetch_array($ergebnis)) {
$skilltype = $ds['typeName'];
}

$skillpoints = $skill->skillpoints;
$level = $skill->level;
echo ' - '. $skilltype . ', ' .$skillpoints . 'sp, L' . $level . '<br />';
}

---

Originally by: MJ Maverick

---

Any idea how I would pull a list of corporationIDs that are members of a specified alliance from AllianceList? I'm trying to pull them in but just can't find an example to go off and what I have tried so far pulls in nothing.

---

Originally by: MJ Maverick

---

Ah, damn. So basically dump the AllianceList.xml into a DB?

Is there a function in Pheal to do that? If not any ideas what the best way to do it would be and an example database structure?

---

Originally by: Spartan 019

---

Edited by: Spartan 019 on 11/03/2011 09:19:07
Ok, I've been playing with this thing for the past few hours... lol. I'm a nub at php really.

I've got it displaying the characters per your example... but how do I go about finding how to display other things like a characters corporation, alliance, skills... etc?

I've been looking everywhere for documentation beyond the readme... and it's pretty bleak.

Please help. =)

---

Originally by: Spartan 019

---

Edited by: Spartan 019 on 11/03/2011 09:19:07
Ok, I've been playing with this thing for the past few hours... lol. I'm a nub at php really.

I've got it displaying the characters per your example... but how do I go about finding how to display other things like a characters corporation, alliance, skills... etc?

I've been looking everywhere for documentation beyond the readme... and it's pretty bleak.

Please help. =)

---

Originally by: MJ Maverick

---

FYI:
Strict Standards: date_default_timezone_get() [function.date-default-timezone-get]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Chicago' for 'CDT/-5.0/DST' instead in /home/*****/public_html/forumapi/pheal/PhealResult.php on line 70

---

Originally by: MJ Maverick

---

Ah k, I can't find anything like that in my php.ini, do you know what the field actually is? I've CTRL+F'd "time" and "date" and can't find anything similar.

---

Quote:

---

date_default_timezone_set("UTC");

---

Quote:

---

date.timezone = "Europe/London"

---

Originally by: MJ Maverick

---

Hmm, I added

Quote:

---

date.timezone = "Europe/London"

---

to php.ini (PHP v5.2.14) but I'm still getting it. :/

---

Quote:

---

include "pheal/Pheal.php";
spl_autoload_register("Pheal::classload");
PhealConfig::getInstance()->cache = new PhealFileCache(".pheal/cache/");
$pheal = new Pheal($userID, $APIKey, $charID, "corp");
$sheet = $pheal->CorporationSheet();

---

Quote:

---

include "pheal/Pheal.php";
spl_autoload_register("Pheal::classload");
PhealConfig::getInstance()->cache = new PhealFileCache(".pheal/cache/");
$pheal = new Pheal($userID, $APIKey, "corp");
$sheet = $pheal->CorporationSheet(array(characterID=>$charID));

---

Originally by: Snipes2083

---

Quote:

---

$sheet = $pheal->CorporationSheet(array(characterID=>$charID));

---

---

Quote:

---

$fullCharID = "your full API key";
$refID ='1234567890';
$charJournal = $corpPheal->WalletJournal(array('characterID'=>$fullCharID,'beforeRefID'=>$refID));

---