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

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » JackKnife 2.0

Topic is locked indefinitely.

JackKnife 2.0 First post
Author

Previous Topic Next Topic

Equto

Imperium Technologies

Sigma Grindset

Likes received: 58

#1 - 2011-12-14 13:38:18 UTC | Edited by: Equto

After having talked with the original creator and developer of jackknife we together have developed jackknife 2.
Update 11-13-13
-Fixed mails not working bug

Update 6-4-13
-Updated Database dump to Odyssey
-Added a updater to the installer, no need to remove old tables again
-Updated skills page

Major Feature
*Api auditing program now with contract
*Api information now saved between visits
*Installer to setup and install database and config
*Login system to save multiple api keys as well as note
*Character select screen can now show isk and sp for each character
*Now works with odyssey

Now for the important stuff
Package for Download JackKnife 2.0 11-13-13 update Odyssey
Website with current version http://beta.whinis.com/jackKnife/
Source:Source

Republic Military School Minmatar Republic 13
PsyKzz Republic Military School Minmatar Republic Likes received: 13	#2 - 2011-12-14 14:41:52 UTC Good effort! Meh.


Equto Imperium Technologies Sigma Grindset Likes received: 58	#3 - 2011-12-17 21:24:15 UTC no one is interested?

6
Axari Likes received: 6	#4 - 2011-12-18 18:56:45 UTC Equto, Thanks for updating this tool. So far it seems to work for me. It's just hit or miss, based on the access mask. Might want to update the "I don't know my api!" link to the current support.eveonline.com/api one :) Nice job!


Equto Imperium Technologies Sigma Grindset Likes received: 58	#5 - 2011-12-18 20:31:19 UTC Thanks for letting me know about the api link, as far as the access mask goes I had to hard code it, so if you see one that does not work just let me know so I can fix it.

Louis Vitton

Viziam

Amarr Empire

Likes received: 88

#6 - 2011-12-19 01:38:14 UTC | Edited by: Louis Vitton

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;

Quote:

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

Table 'jackknife.invTypes' doesn't exist

Backtrace:
#0 eveDb->query(SELECT * FROM invTypes WHERE typeID = 25718 LIMIT 1) called at [/var/www/jackKnife/eveApi/eveDb.php:354]
#1 eveDb->getTypeFromTypeId(25718) called at [/var/www/jackKnife/eveApi/eveDb.php:286]
#2 eveDb->getNameFromTypeId(25718) called at [/var/www/jackKnife/eveApi/eveApiTraining.class.php:48]

Equto

Imperium Technologies

Sigma Grindset

Likes received: 58

#7 - 2011-12-19 02:21:43 UTC | Edited by: Equto

For Skills:
Private: CharacterInfo
Private: SkillInTraining
Private: SkillQueue

For Kills:
Public Information:KillLog

For Mail:
Communication: MailMessages
Communication: MailBodies

For Notifications:
Communications: NotificationText
Communications: Notifications

For Assets:
Private:AssetList

For Journal:
Account and Market: WalletJournal

For Transactions:
Account and Market: WalletTransactions

For Orders:
Account and Market: MarketOrders

I could give you the access mask for each one however they are added together to give the total access, so comparing it to your current would be useless.

Louis Vitton wrote:

Quote:

That error is a Uppercase/lowercase issue. In the database the tables are in their correct case however when exported they do not keep the correct case so the code looks for invTypes however mysql reports invtypes. I will look into a quick fix for this.


Louis Vitton Viziam Amarr Empire Likes received: 88	#8 - 2011-12-19 02:36:41 UTC \| Edited by: Louis Vitton Thank you for that i read thought some of the files and in the end made one with all that. Thank you. Could you help with the issue above please. So in the mean time a quick fix would be to just update it with the correct one manually?


Equto Imperium Technologies Sigma Grindset Likes received: 58	#9 - 2011-12-19 03:04:44 UTC 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.

Louis Vitton

Viziam

Amarr Empire

Likes received: 88

#10 - 2011-12-19 03:06:09 UTC | Edited by: Louis Vitton

Equto wrote:

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.

also evenames->eveNames

Equto

Imperium Technologies

Sigma Grindset

Likes received: 58

#11 - 2011-12-19 03:08:55 UTC

Louis Vitton wrote:

Equto wrote:

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

No Problem, forgot that different host use different mysql setups. Didn't gear the sql to all host however I am updating it now

Equto

Imperium Technologies

Sigma Grindset

Likes received: 58

#12 - 2011-12-19 03:39:17 UTC

Louis Vitton wrote:

Equto wrote:

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

also evenames->eveNames

Thanks, I just renamed all my table on the host and created SQL file there. The next version is up with the updated SQL files and a built in access mask retrieve should it somehow be removed from the url


Equto Imperium Technologies Sigma Grindset Likes received: 58	#13 - 2011-12-25 01:01:30 UTC Updated to check for expired Api keys instead of just saying failed to load. Happy holidays people

bloateus

Brutor Tribe

Minmatar Republic

Likes received: 0

#14 - 2011-12-28 23:28:14 UTC

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

Quote:

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'

The Scope Gallente Federation 11
Andy Moo The Scope Gallente Federation Likes received: 11	#15 - 2011-12-29 12:35:27 UTC 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.

Equto

Imperium Technologies

Sigma Grindset

Likes received: 58

#16 - 2011-12-29 19:11:12 UTC

bloateus wrote:

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

Quote:

It seems as if your bigdump script has already ran this section of the sql and you can't have 2 entries of 8329d8c4a535aaa59309272538704d22. I would suggest that you check in your database to see if this is the case.

Andy Moo wrote:

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 not tested the item search yet because I was unsure how many people used it. Thanks for letting me know I will upload a new copy as soon as I test the rest of the item search

Triglovian-Clades xX SERENITY Xx 0
Darlington Triglovian-Clades xX SERENITY Xx Likes received: 0	#17 - 2011-12-30 21:52:40 UTC Dear All TBH This has to be the best piece of Kit I have used for security Regards Darlingtion

Equto

Imperium Technologies

Sigma Grindset

Likes received: 58

#18 - 2012-01-05 03:58:07 UTC

Just updated Jackknife to include an account status page which shows date created, times logged in, time logged in, and time left on account. I also updated the kill logs to know between BPC and BPO, this is untested so please give me some feedback. I also added the flag for implants to kill logs to show if the implant was in the cargo or installs. Finally I fixed the item search page and added a change log. As always you can report problems here or via evemail.


Equto Imperium Technologies Sigma Grindset Likes received: 58	#19 - 2012-01-05 15:04:06 UTC \| Edited by: Equto Fixed

Equto

Imperium Technologies

Sigma Grindset

Likes received: 58

#20 - 2012-01-07 04:06:05 UTC

Alright another update down the line.
Fixed an issue where the asset list would report correct number of items but not show them
Added blueprint copy and original detecting to asset list
Redid account page to show an overview of all characters on the account.
WARNING: when you first load the page depending on your host it can take 30-90 seconds to get all api's
Added ability to select account from character select screen by clicking" View all Characters"
Move all functions from the display page pages to audit.func.php

123Next pageLast page

EVE Technology Lab

Imperium Technologies

Sigma Grindset

Republic Military School

Minmatar Republic

Viziam

Amarr Empire

Brutor Tribe

Minmatar Republic

The Scope

Gallente Federation

Triglovian-Clades

xX SERENITY Xx