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

 
  • Topic is locked indefinitely.
 

Yapeal PHP API library (version 1.0.5)

First post
Author
Previous Topic Next Topic
Sable Blitzmann
24th Imperial Crusade
Amarr Empire
#321 - 2012-10-26 04:17:15 UTC  |  Edited by: Sable Blitzmann
How difficult would it be to add in table relations to the table schema via foreign keys?

EDIT: also, how are things inserted into the database? For example - assets. Is everything owned by the character that Yapeal is updating deleted then re-inserted? Same goes for StarbaseList, etc

EDIT 2: Also, charKillLog table... isn't it supposed to show ownerID that points to character ID?
Dragonaire
Here there be Dragons
#322 - 2012-10-28 10:23:28 UTC  |  Edited by: Dragonaire
Kivorno - Double check that all the tables were created correctly and also make sure you've followed the full install instructions.


Sable Blitzmann - It all depends on the table how it is handled. Tables like Assets are cleared for the char/corp and re-created since you have things like moving stuff in and out of containers. others do not like kills.

There was a time when I tried having foreign keys but they ended up being more trouble than they were worth.

Yes the ownerID will be the same as the other columns in a few tables per design.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
JunoTan
Garoun Investment Bank
Gallente Federation
#323 - 2012-11-06 13:40:51 UTC
Messed around with yapeal a bit, i'm missing the fetching of skill names trough.

is there a way to add it to yapeal?

(haven't really looked around in yapeal files yet, decided to ask before i break anything)
Dragonaire
Here there be Dragons
#324 - 2012-11-07 04:19:46 UTC
Skills API is one of the more complex ones to do and no one has finished it that started working on it including myself Blink I've never really had anything where I needed it so I've never got very far with my tries. If you just want the list of skill names but not the full tree with what skills with levels you need for other skills that is available from the static data dump. If you want to work on it you are also welcome to do so.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Crassus Detlator
Tribal Liberation Force
Minmatar Republic
#325 - 2012-11-12 13:28:14 UTC
I have been messing around with YAPEAL and to get the skill names and other stuff, I just added the proper tables form the static dump to my database.
It wasn't difficult to implement, you should give that a try.
Steven Trux
Amarr Research Laboratories
#326 - 2012-11-13 10:52:11 UTC
Hi all, I'm trying to install yapeal on my server, and i cannot create tables... the error is:
Quote:
Dictionary driver '.../yapeal/ext/ADOdb/datadict/datadict-.inc.php' not available

Requisites test runs without errors.

Thank you for help

ARLAB Shop BPOs Showcase Manufacturing Service
Dragonaire
Here there be Dragons
#327 - 2012-11-14 00:46:03 UTC

Crassus Detlator - Yapeal is for working with the Eve API not a one stop solution to everything Eve related so it doesn't deal with anything having to do with the SDD but they are usually both needed to make anything useful. I have thought about including parts of the SDD but what is useful to someone developing a killboard vs something for skill management are often very different and including any of it with Yapeal would just add stuff that isn't needed by everyone.

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
#328 - 2012-11-14 00:52:47 UTC
Steven Trux - Make sure you've gone through all the steps in the install.md(test) file. I'm thinking you missed step where you test DB connection that you'll find in step 9. Also make sure you got everything and if you're updating from an old version that all the files updated correctly.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Steven Trux
Amarr Research Laboratories
#329 - 2012-11-14 08:36:38 UTC
Dragonaire wrote:
Steven Trux - Make sure you've gone through all the steps in the install.md(test) file. I'm thinking you missed step where you test DB connection that you'll find in step 9. Also make sure you got everything and if you're updating from an old version that all the files updated correctly.

Thanks for reply, but that's not the problem. Step 9 works just fine Ugh
Still got the same error when running /install//createMySQLTables.php -s localhost -u YapealUser -p secret --database=yapeal

ARLAB Shop BPOs Showcase Manufacturing Service
Dragonaire
Here there be Dragons
#330 - 2012-11-15 16:29:06 UTC  |  Edited by: Dragonaire
Steven Trux wrote:
Dragonaire wrote:
Steven Trux - Make sure you've gone through all the steps in the install.md(test) file. I'm thinking you missed step where you test DB connection that you'll find in step 9. Also make sure you got everything and if you're updating from an old version that all the files updated correctly.

Thanks for reply, but that's not the problem. Step 9 works just fine Ugh
Still got the same error when running /install//createMySQLTables.php -s localhost -u YapealUser -p secret --database=yapeal
If you haven't found it yet check out http://sourceforge.net/p/yapeal/wiki/StarterGuide/

You also shouldn't have to add any of the -s, -u etc part if you've got a config/yapeal.ini file setup. One other cause of major problems with the tables part is a bad my.cnf setting for max_allowed_packet. It needs to be at least 2M to generally not cause problems during install and while running Yapeal later.

Just on the off chance you really are missing something check that you have 2 files in ext/ADOdb/datadict/. I'm not sure if it's just a bad cut and paste from your error or if it really said 'datadict/datadict-.inc.php' which would be missing the 'mysql' part.

If none of those things correct your issue please E-mail me a copy of your exact error messages and any Yapeal log files and I'll take a look and see if there's a clue that's been missed.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Steven Trux
Amarr Research Laboratories
#331 - 2012-11-16 12:09:42 UTC
Dragonaire wrote:
Steven Trux wrote:
Dragonaire wrote:
Steven Trux - Make sure you've gone through all the steps in the install.md(test) file. I'm thinking you missed step where you test DB connection that you'll find in step 9. Also make sure you got everything and if you're updating from an old version that all the files updated correctly.

Thanks for reply, but that's not the problem. Step 9 works just fine Ugh
Still got the same error when running /install//createMySQLTables.php -s localhost -u YapealUser -p secret --database=yapeal
If you haven't found it yet check out http://sourceforge.net/p/yapeal/wiki/StarterGuide/

You also shouldn't have to add any of the -s, -u etc part if you've got a config/yapeal.ini file setup. One other cause of major problems with the tables part is a bad my.cnf setting for max_allowed_packet. It needs to be at least 2M to generally not cause problems during install and while running Yapeal later.

Just on the off chance you really are missing something check that you have 2 files in ext/ADOdb/datadict/. I'm not sure if it's just a bad cut and paste from your error or if it really said 'datadict/datadict-.inc.php' which would be missing the 'mysql' part.

If none of those things correct your issue please E-mail me a copy of your exact error messages and any Yapeal log files and I'll take a look and see if there's a clue that's been missed.

Thank you, I'm away from home for a week. I'll try as soon as I come back.

ARLAB Shop BPOs Showcase Manufacturing Service
Sable Blitzmann
24th Imperial Crusade
Amarr Empire
#332 - 2012-11-24 04:17:05 UTC  |  Edited by: Sable Blitzmann
Dragon,

Can you confirm: When changing the expiration of the API key on the EVE-O site, yapeal DOES NOT update this in the database. Is this by design or is it an oversight?

EDIT:

Don't mind me, I'm an idiot. the cache had not expired and thus it was not updated. <_<
Makkosh
Metaxa Labs
#333 - 2012-11-28 14:44:10 UTC
I am trying to get EVE data for my web-application with yapeal. On my home computer everything works fine.
But when i moved it to the hosting server i've got error:

Quote:
Unknown cipher in list: AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5

for all APIs.

Hosting has all needed for yapeal extensions and versions.
Hosting support manager wrote that they support curl (cURL Information 7.19.7) with SSL (NSS/3.13.1.0)
What it could be?
Somerset Mahm
Cognitive Distortion
#334 - 2012-11-30 06:43:30 UTC
I just got this same error on a new server with Yapeal as well.

Quote:
Unknown cipher in list: AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5

SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)
Somerset Mahm
Cognitive Distortion
#335 - 2012-11-30 07:35:49 UTC
Sorted it out. It's because curl on this server isn't compiled with OpenSSL:

Quote:
curl --version
curl 7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.13.1.0 zlib/1.2.3 libidn/1.18 libssh2/1.2.2


I just commented out these lines for now :P

Quote:

//$this->options['CURLOPT_SSL_VERIFYPEER'] = 1; // verify ssl certs
//$this->options['CURLOPT_SSL_VERIFYHOST'] = 1; // verify ssl host
//$this->options['CURLOPT_SSL_CIPHER_LIST'] = 'AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5'; // use these ciphers only
//$this->options['CURLOPT_CAINFO'] = YAPEAL_CONFIG . 'eveonline.crt';

SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)
Makkosh
Metaxa Labs
#336 - 2012-11-30 10:09:53 UTC
Resolved Big smile
My development system has cURL with OpenSSL, hosting server has cURL with NSS. OpenSSL and NSS use different names for ciphers. Ciphers are in file: yapeal\ext\eac_httprequest\eac_httprequest.curl.php
Defaut string for OpenSSL:
Quote:
$this->options['CURLOPT_SSL_CIPHER_LIST'] = 'AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5';

And this string for NSS should be:
Quote:
$this->options['CURLOPT_SSL_CIPHER_LIST'] = 'rsa_aes_128_sha,rsa_aes_256_sha,rsa_3des_sha,rsa_rc4_128_sha,rsa_rc4_128_md5';
Dragonaire
Here there be Dragons
#337 - 2012-12-02 02:29:25 UTC
Sorry everyone been busy in RL with holidays etc. Glad you figured out what the issue was as I wasn't even aware anyone use anything but OpenSSL with cURL or I might have added checks for it.

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
#338 - 2012-12-04 01:07:37 UTC
Will Yapeal's curl implementation take advantage of GZIP API responses when they come out in a few weeks, or do I need to tweak the config? :)

SOMER Blink Microlotteries that finish in minutes! Running for over 2 years :)
Dragonaire
Here there be Dragons
#339 - 2012-12-04 15:56:59 UTC
Quote:
$this->options['CURLOPT_ENCODING'] = 'gzip';// allow gzip compression


It's been waiting on them for over a year Blink

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Talos Katuma
Helion Production Labs
Independent Operators Consortium
#340 - 2012-12-12 22:01:02 UTC
I didn't find any way to report a defect on sourceforge (only see tickets but did not find a way to open a new one), therefore I'll report it here:

I think there's a bug in maintCleanCache.php Line 94


$sql = ' delete from `' . YAPEAL_TABLE_PREFIX . 'utilXmlCache`';
$sql .= ' where';
$sql .= ' `modified` = ';


Shouldn't this be
$sql .= ' `modified` <= ';