What access mask should be used???

As you said if you dont use the right one it wont display anything.

I also seem to have a database isssue i imported the database you gave me into my database "jackknife" and all the files are there.

I also edited "eve.config" with my database information and eveDB also in ever eveDB i changed the following;

$def_eve_db = 'jackknife'; // changed to jackknife

public function __construct($server = "localhost", $user= "user", $pass= "*******", $db = null)

and i get the following error;

Yes, for the mean time you can rename the following tables to make it work
stastations->staStations
mapsolarsystems->mapSolarSystems
invgroups->invGroups
invtypes->invTypes
dgmtypeattributes->dgmTypeAttributes

These are the ones I had to rename on my host, however a fixed file should be ready within the hour.

Thank you for the quick reply and yes that seems to be it :) cheers mate.

Thank you for the quick reply and yes that seems to be it :) cheers mate.

also evenames->eveNames

Error at the line 66: ('136daa5bfad608b45b5b0c8005f2f4a6', 0);

Query: --
--
INSERT INTO `api_type_cache` (`keyv`, `type`) VALUES
('8329d8c4a535aaa59309272538704d22', 1),
('230a7a59bcf32e09d83761ea642a279f', 1),
('136daa5bfad608b45b5b0c8005f2f4a6', 0);

MySQL: Duplicate entry '8329d8c4a535aaa59309272538704d22' for key 'key'

Using bigdump to upload sql getting this error. Any ideas?

Thanks for updating this.

I did find one problem though. In itemview.php there are several instances of "phpecho" which I suspect is where you have search/replaced the old short tags.

This causes an unexpected T_VARIABLE error until you put the space in between the tag and the command and then it works fine.

I have tried various ways to import the SQL but server keeps bombing out, any chance of an installer?

Thanks for the update Equto (and ZZJ

Re: jackKnife3-29-12.zi

Some things I noticed

I no longer see an account page option in the menu list. Nor does the account status table appear at the bottom of the 'onepage' view anymore. Without this, to my understanding, we can't really tell if someone is hiding toons or not

Nice touch on being able to get more info on the completed contracts!

I'm sure some people will find the ability to login now, and save API's helpful too.

Suggestions
1. Add the account page back i

2. You can probably remove the text "DESC:" and "ENDED:" etc where they show up. It's pretty obvious whats showing up

3. Standardize all display to CSS and with that, clean up the old table types (ie, border = 1 or whatever is tacky

4. When an error occurs, ensure you keep the top men
Example might be, clicking on kills and it's exhausted.

5. Personally, this is an audit tool with the ability to lookup items as an extra. In fact, I'm not sure what the two have to do with each other :) So i'd suggest that the index default to Audit with perhaps a link to lookup items?


Thanks for all the work!

FATAL SQL ERROR
QUERY: 'SELECT * FROM invTypes WHERE typeID = 25718 LIMIT 1'

When I saw this



The first thing I thought about was "SQL Injection Exploit". Just making sure that you have some sort of validation or parameterization for passed in variables.

Thanks for the update Equto (and ZZJ

Re: jackKnife3-29-12.zi

Some things I noticed

I no longer see an account page option in the menu list. Nor does the account status table appear at the bottom of the 'onepage' view anymore. Without this, to my understanding, we can't really tell if someone is hiding toons or not

Nice touch on being able to get more info on the completed contracts!

I'm sure some people will find the ability to login now, and save API's helpful too.

Suggestions
1. Add the account page back i

2. You can probably remove the text "DESC:" and "ENDED:" etc where they show up. It's pretty obvious whats showing up

3. Standardize all display to CSS and with that, clean up the old table types (ie, border = 1 or whatever is tacky

4. When an error occurs, ensure you keep the top men
Example might be, clicking on kills and it's exhausted.

5. Personally, this is an audit tool with the ability to lookup items as an extra. In fact, I'm not sure what the two have to do with each other :) So i'd suggest that the index default to Audit with perhaps a link to lookup items?


Thanks for all the work!

1. Not going to happen but eve mail me and we might be able to work something out
2. Done
3. Send me a mail with he ones not updated in the current code posted today and I will work on them
4. Done
5. Done.

Links to the installer.zip are broken, and no sign of any install documentation makes installing JackKnife a very frustrating exercise...

Audit.php is missing. Is there a way to get a current version please?

Thanks

Amos

FATAL SQL ERROR

QUERY: 'SELECT solarSystemID, solarSystemName FROM mapSolarSystems WHERE solarSystemID IN ()'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Backtrace:
#0 eveDb->query(SELECT solarSystemID, solarSystemName FROM mapSolarSystems WHERE solarSystemID IN ()) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/eveDb.php:620]
#1 eveDb->cacheLocationIds(Array ([0] => )) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/eveApiContracts.class.php:370]
#2 eveApiContracts->loadAPI() called at [/webpages/astartes.digitalnode.net/public_html/jackknife/eveApi.base.php:57]
#3 eveApi->fetch_xml(/char/Contracts.xml.aspx, Array ([characterID] => 90194439,[keyID] => 1368255,[vCode] => lIfLQTWCZJeVta3sGXFiVHVzk0l84cdgwAjH1etYg9hvx8qGPxbzb8JTeCZNEBSY)) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/eveApiContracts.class.php:173]
#4 eveApiContracts->fetch(90194439, 1368255, lIfLQTWCZJeVta3sGXFiVHVzk0l84cdgwAjH1etYg9hvx8qGPxbzb8JTeCZNEBSY, ) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/pages/auditorContractsPage.class.php:65]
#5 auditorContractsPage->GetOutput(eveDb Object ([link] => Resource id #23,[queries] => 8,[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array ([SELECT stationID, stationName, solarSystemID FROM staStations WHERE stationID IN (60012154,60007573,60014452,60004588,60002860)] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60012154 LIMIT 1] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60007573 LIMIT 1] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60014452 LIMIT 1] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60004588 LIMIT 1] => 1,[SELECT stationID, solarSystemID FROM staStations WHERE stationID = 60002860 LIMIT 1] => 1))) called at [/webpages/astartes.digitalnode.net/public_html/jackknife/index.php:307]

You are correct, for people using the SVN this has been updated.
A patch will be released shortly for everyone else

Everyone might be interested in looking at my post on another thread about why it is important to properly making the change.

https://forums.eveonline.com/default.aspx?g=posts&m=2067392#post2067392

Everyone might be interested in looking at my post on another thread about why it is important to properly making the change.

https://forums.eveonline.com/default.aspx?g=posts&m=2067392#post2067392

Exactly this. Equto's code is incorrect by trying to use eve-online.com for API calls as there is not a valid cert on the domain, and hence CURL freaking out. NO, do not change it to "VALIDATE_PEER" : false.

Simply change the URL to eveonline.com ( no - ) as that domain has a valid wildcard cert. No need for "cert files"...

Actually it still needs a cert file as its ssl and curl needs a cert file to validate the connection.

That is not true. That would mean you need a "file" for every SSL enabled website on the internet. Lol... You only need to import it if it is signed by a untrusted CA or if there is some problem with the certificate validation and you want to explicitly use it anyways.

See command line curl at the following paste. http://pastebin.com/yfp6Wg8u No need to import anything whatsoever if you are using the correct domain...

The reason being almost all installs come with a valid CA cert file. You do not need a valid different file for every website on the internet however in this file ( which is shipped with firefox and chrome mind you) is a public key that allows one to validate the certificate on the website. So this file is used in the validation process of the certificate

edit: http://serverfault.com/questions/241046/what-is-the-cacert-pem-and-for-what-to-use-that explains why the file is needed

If it fails, then you OS's cert bundle is out of date... cURL is using the system-default CA bundle as is uslauuly stored in /etc/pki/tls/certs/ca-bundle.crt. Not something other software is supposed to hack to get working.

Cause https://api.eve-online.com does not have a valid cert. It will never validate unless you go the "import the CA" route. Which is wrong.

I have tested it on both eve-online and eveonline, eveonline replied an error 60 SSL certificate problem,verify that the CA cert is OK. So that file is nessicary

How old is your cURL install? When last have you had a CA bundle updated?

How old is your cURL install? When last have you had a CA bundle updated?
I need to log for the night, but in the meantime I have tested this on 24 of the many servers I have. Not one has complained about the cert. And this is various diffident flavors of *nix, centos, ubuntu gentoo, archlinux and even freebsd :0

Honestly, I'd make 100% sure about this if I were you, before you ship a cert, *.eveonline.com gets a new cert signed by another CA, and you have to do this whole mess all over again :(

No, because this is the public keys from several signing agencies, so unless they do something crazy and sign their own keys without any authority then this will continue to work. Regardless once again this works, if you have a problem with me and other developers shipping necessary files for compatibility reasons then don't use the software.

I know very well, infact, exactly how SSL Certs work. Regardless of what you may believe, if a users cURL install (or anything using libcurl for that matter) cannot verify a GeoTrust cert, and you insist that eve-online.com is valid, then so be it. In such a case the user probably has many more problems to be concerned about than a mere cert, which will be invalidated at some point anyways, bundled in some software for compatibility reasons. Just take the advise.

Your welcome to get another opinion here.
https://www.ssllabs.com/ssltest/analyze.html?d=api.eve-online.com
https://www.ssllabs.com/ssltest/analyze.html?d=api.eveonline.com

Do yourself another favor and cat your bundle grepping for geotrust. Is wget able to validate the cert? What is in CURL_CA_BUNDLE in you env? At least try and check how to update you os flavours CA bundle, or if you have to use a curl specific one, on the curl website, http://curl.haxx.se/ca/cacert.pem

Anyways. As you please.

Is there a class with this that contains all the api queries & calculations that one could include on another site?

I get this when using the installer on a fresh database:

MYSQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '422,NULL165,633,NULL,26,NULL,30),(2004,6LL,0.8),(2161,28,525,69.8),(2161,2054),(' at line 1MYSQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '830952053,(238311200490213,(253,(2382919520)102153,(238291952153,(23782238291952' at line 1

This is during the installation of dgmTypeAttributes.sql.gz how can I get around this?

I get this same error, having to use the older version of jackknife to get around this.

Any chance of fixing this one Equto? <3

The installer doesn't update current installations if you are using it todo that. I will however make an update function in a few days to update things like items. Other than that I am not sure what could be causing the issue

Notice: Use of undefined constant DEBUG - assumed 'DEBUG' in /home/majestic/domains/api.dontpod.me/public_html/eveApi/eveDb.php on line 119
FATAL SQL ERROR

QUERY: 'SELECT * FROM api__invTypes WHERE typeID = '1' LIMIT 1 OFFSET 0;'

Table 'api.api__invTypes' doesn't exist

Backtrace:
#0 eveDb->query(SELECT * FROM api__invTypes WHERE typeID = '1' LIMIT 1 OFFSET 0;) called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveDb.php:483]
#1 eveDb->getTypeFromTypeId(12099) called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveDb.php:386]
#2 eveDb->getNameFromTypeId(12099) called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveApiTraining.class.php:48]
#3 eveApiTraining->loadAPI() called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveApi.base.php:57]
#4 eveApi->fetch_xml(/char/SkillInTraining.xml.aspx, Array ([characterID] => 90278068,[keyID] => 1696661,[vCode] => 4sWQAXzr3Lm1EvszabSy2YA19S1cYsq0KJaBabRWCzAzKNB2BmNgCzoeTMl2V5Ps)) called at [/home/majestic/domains/api.dontpod.me/public_html/eveApi/eveApiTraining.class.php:38]
#5 eveApiTraining->fetch(90278068, 1696661, 4sWQAXzr3Lm1EvszabSy2YA19S1cYsq0KJaBabRWCzAzKNB2BmNgCzoeTMl2V5Ps) called at [/home/majestic/domains/api.dontpod.me/public_html/pages/auditorSkillsPage.class.php:246]
#6 auditorSkillsPage->GetOutput(eveDb Object ([link] => Resource id #23,[queries] => 1,[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array (),[] => Array ())) called at [/home/majestic/domains/api.dontpod.me/public_html/index.php:306]

Hopefully fully fixed now, after fixing the not installing sql errors I had an sql that refused to install and fixed that as well

invUniqueNames-1.sql.gzMYSQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Bouey Sadereroseroil71), 9NDgur',Libo(3010845, 'OpUre Goskhen'an',, 1)ru(3010842' at line 1198

FATAL SQL ERROR
QUERY: 'SELECT * FROM jack_invGroups WHERE groupID IN (107,489,1137,107,420,74,212,85,74,212,85,302,302,302,910,212,377,489,489,490,489,)'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Backtrace:

One suggestion - have a style change on the buttons when you press them (on the installer page).

Edit: Upon loading the api into the system, I get the following errors

Strict Standards: gmmktime(): You should be using the time() function instead in C:\xampp\htdocs\eve\eveApi\eveApiTraining.class.php on line 57

Notice: Array to string conversion in C:\xampp\htdocs\eve\eveApi\eveDb.php on line 558

(Tons of the Array to string - id say about 200+) Image here: http://i.imgur.com/e9uQUpV.png

Then after I scroll down past all the errors the page loads fine. Same thing happens when I try to reload the page.

Edit: Think I fixed the first error:



Still no idea about the second

Edit: Think I fixed the first error:



Still no idea about the second

Notice: Trying to get property of non-object in D:\Inetpub\***\***jackknife\eve.funcs.php on line 222 Notice: Trying to get property of non-object in D:\Inetpub\****\***jackknife\eve.funcs.php on line 227 Fatal error: Call to a member function xpath() on a non-object in D:\Inetpub\****root\****jackknife\eve.funcs.php on line 227

So I went to try this out and after a few clicks I already ran in to this:


( I removed a part of the directories in this post for security purposes )

This happend while trying to pull mails.

So true fact, I suck at setting this kind of stuff up. Could someone give me a quick rundown on if this will run on a centos system and some quick steps on install? I've done webhosting before however I've never dealt with php or databases.