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.
 

JackKnife 2.0

First post
Author
Previous Topic Next Topic
Equto
Imperium Technologies
Sigma Grindset
#41 - 2012-03-30 01:28:47 UTC
Update is Official
Equto
Imperium Technologies
Sigma Grindset
#42 - 2012-04-01 00:27:34 UTC
Bump
Equto
Imperium Technologies
Sigma Grindset
#43 - 2012-04-03 13:07:45 UTC
Remember any bugs you can post here, on the google code now, or send me an in game mail.
Axari
#44 - 2012-04-04 00:27:25 UTC
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!
Equto
Imperium Technologies
Sigma Grindset
#45 - 2012-04-04 12:34:55 UTC  |  Edited by: Equto
Axari wrote:
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!


The account page was removed due to it being difficult to maintain with the new backend codebase, however at the top of the page it will now display what type of api key you have, so you no longer need to go to a specific account page.

2 I can look into and it doesn't seem all that hard

3 I tried to standardize most of the css however some of those tables it was just easier at the time to add it directly into the code line as they change depending on the information.

4 that should be easy enough
Barakach
Caldari Provisions
Caldari State
#46 - 2012-04-05 17:19:00 UTC
When I saw this

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


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.
Equto
Imperium Technologies
Sigma Grindset
#47 - 2012-04-05 18:25:48 UTC
Barakach wrote:
When I saw this

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


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.

what page was this on ? and yes as far as I can tell all variables going into the database are first sanitized.
Equto
Imperium Technologies
Sigma Grindset
#48 - 2012-04-10 12:56:39 UTC
Axari wrote:
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.
Axari
#49 - 2012-04-10 20:57:09 UTC
Equto wrote:

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.


This is great! I didn't realize when I saw "Account" that it was the type of account. An actual Account page isn't needed imho then.

Work has been taking up a lot of my time lately, but as soon as I get a moment, I'll install the new package and get back to you.


Thank you!
Wibla
Tactical Narcotics Team
#50 - 2012-06-20 13:04:46 UTC
Links to the installer.zip are broken, and no sign of any install documentation makes installing JackKnife a very frustrating exercise...
Equto
Imperium Technologies
Sigma Grindset
#51 - 2012-06-20 23:00:57 UTC
Wibla wrote:
Links to the installer.zip are broken, and no sign of any install documentation makes installing JackKnife a very frustrating exercise...

The download on the first post has a zip with the installer in it. The installer is also on the google code SVN.
Amos Zota
#52 - 2012-06-22 19:35:36 UTC
Audit.php is missing. Is there a way to get a current version please?

Thanks

Amos
Equto
Imperium Technologies
Sigma Grindset
#53 - 2012-06-23 12:48:37 UTC
Amos Zota wrote:
Audit.php is missing. Is there a way to get a current version please?

Thanks

Amos

I renamed it index.php so as to avoid the front page. Now there is a link to go to the item search rather than a index to decide where to go. I assume the audit was used more than other parts.
Equto
Imperium Technologies
Sigma Grindset
#54 - 2012-06-25 19:37:35 UTC
I have updated the download, it fixes some bugs that popped up when I renamed audit.php
Equto
Imperium Technologies
Sigma Grindset
#55 - 2012-07-25 15:24:26 UTC
updated to include account info on character select screen if accessible and load now also shows characters birth date
Go0fBall
State War Academy
Caldari State
#56 - 2012-08-03 01:34:15 UTC
Thanks for the update. Fairly new to this, but is there a way to save say fleet concept fits in the database to check against to see if a pilot can fly them, rather than have to import EFT fits each time?
Equto
Imperium Technologies
Sigma Grindset
#57 - 2012-08-03 21:41:38 UTC
After you post a fit there is a link underneath it that you can save. If you paste that link in the url bar it will check that fit against the character currently selected.
Equto
Imperium Technologies
Sigma Grindset
#58 - 2012-09-11 16:35:58 UTC
Security Update has been pushed to the Svn and OP has been updated with new download
dbrummer
ASTARTES CORP
Hashashin Cartel
#59 - 2012-10-03 22:37:40 UTC
A few things. First, thank you for putting this together, it's greatly appreciated.

When I ran through the install, it did not execute the .sql included in the RAR, I had to manually execute it.

When veiwing a full apis contracts, I receive this error:

Quote:

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]


All of my assets show 'UNKNOWN TYPE', is that expected?

Thanks.
dbrummer
ASTARTES CORP
Hashashin Cartel
#60 - 2012-10-03 22:49:17 UTC
Disregard everything in my previous post, didn't see the .sql.gz files there. Imported them all and I'm good now. THANKS!