Pages: [1] 2 3 4 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Equto
EXURO VITA GREATER ITAMO MAFIA
1
|
Posted - 2011.12.14 13:38:00 -
[1] - Quote
To get the Formalities out of the way. I did not develop this, I have only modified this to work with the new api system. All credit for original work goes to ZigZagJoe.
Now I have modified JackKnife api auditor to work with the new API system entirely including corps and deciding what is accessible by reading the access mask. I have not added any new pages to the system or modified it in any other way. If people want however I can modify it further.
http://whinis.com/JackKnife Here is the URL to test it for yourself. Please understand that JackKnife will only recognize access mask that it can use, so having an api with just contracts or calendar events will show nothing.
Since I wouldn't trust anything without the source and the original product was GPL v2 license here is the source. JackKnife.zip
Included in the zip files is the modified php files and modified SQL files that have also been updated to crucible. |
PsyKzz
Bat Country Goonswarm Federation
7
|
Posted - 2011.12.14 14:41:00 -
[2] - Quote
Good effort! Meh. |
Equto
EXURO VITA GREATER ITAMO MAFIA
1
|
Posted - 2011.12.17 21:24:00 -
[3] - Quote
no one is interested? |
Axari
0
|
Posted - 2011.12.18 18:56:00 -
[4] - Quote
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
EXURO VITA GREATER ITAMO MAFIA
1
|
Posted - 2011.12.18 20:31:00 -
[5] - Quote
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
Kickass inc Controlled Chaos
3
|
Posted - 2011.12.19 01:38:00 -
[6] - Quote
What access mask should be used???
As you said if you dont use the right one it wont display anything. |
Equto
EXURO VITA GREATER ITAMO MAFIA
1
|
Posted - 2011.12.19 02:21:00 -
[7] - Quote
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: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] 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
Kickass inc Controlled Chaos
3
|
Posted - 2011.12.19 02:36:00 -
[8] - Quote
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. |
Equto
EXURO VITA GREATER ITAMO MAFIA
1
|
Posted - 2011.12.19 03:04:00 -
[9] - Quote
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
Kickass inc Controlled Chaos
3
|
Posted - 2011.12.19 03:06:00 -
[10] - Quote
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
EXURO VITA GREATER ITAMO MAFIA
1
|
Posted - 2011.12.19 03:08:00 -
[11] - Quote
Louis Vitton wrote: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. 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
EXURO VITA GREATER ITAMO MAFIA
1
|
Posted - 2011.12.19 03:39:00 -
[12] - Quote
Louis Vitton wrote: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 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
EXURO VITA GREATER ITAMO MAFIA
1
|
Posted - 2011.12.25 01:01:00 -
[13] - Quote
Updated to check for expired Api keys instead of just saying failed to load. Happy holidays people |
bloateus
Rattius Maximus
0
|
Posted - 2011.12.28 23:28:00 -
[14] - Quote
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' |
Andy Moo
the united Negative Ten.
0
|
Posted - 2011.12.29 12:35:00 -
[15] - Quote
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
EXURO VITA GREATER ITAMO MAFIA
1
|
Posted - 2011.12.29 19:11:00 -
[16] - Quote
bloateus wrote: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' 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
|
Darlington
VIRTUAL LIFE VANGUARD
0
|
Posted - 2011.12.30 21:52:00 -
[17] - Quote
Dear All
TBH This has to be the best piece of Kit I have used for security
Regards
Darlingtion |
Equto
EXURO VITA GREATER ITAMO MAFIA
4
|
Posted - 2012.01.05 03:58:00 -
[18] - Quote
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
EXURO VITA GREATER ITAMO MAFIA
4
|
Posted - 2012.01.05 15:04:00 -
[19] - Quote
I am having trouble uploading to eve-files currently. As soon as this is resolved I will fix the download link. |
Equto
EXURO VITA GREATER ITAMO MAFIA
6
|
Posted - 2012.01.07 04:06:00 -
[20] - Quote
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
|
|
Equto
EXURO VITA GREATER ITAMO MAFIA
7
|
Posted - 2012.01.10 04:33:00 -
[21] - Quote
Currently my main computer has broke ( all 4 ram sticks burnt out) so I can't work on jack knfie as I am unsure the exact changes between the website code and my developer code without the change log also on the computer and I don't have access to the changed code. So for now I would like to ask what Corporation and Alliance recruiters would like to see in this tool as I develop it that is not already in it.
So please post your ideas. Currently suggested: A way to store keys for future reference. |
Reileen Kawahara
3
|
Posted - 2012.01.14 11:48:00 -
[22] - Quote
I have tried various ways to import the SQL but server keeps bombing out, any chance of an installer? |
Equto
EXURO VITA GREATER ITAMO MAFIA
7
|
Posted - 2012.01.14 14:08:00 -
[23] - Quote
I thought about an installer however the long parts of the sql would still likely time out due to their size. Most of the Sql isn't even what the script creates its the data dump from Eve to convert the ID's into weapon,system, and ship names. |
Reileen Kawahara
3
|
Posted - 2012.01.14 14:36:00 -
[24] - Quote
I'm sure it wouldn't time out if it was split into a few pieces and would allow more people to install it who are not comfortable in messing. |
Mandy Moo
Leonora Corporation Negative Ten.
0
|
Posted - 2012.01.15 00:36:00 -
[25] - Quote
Reileen Kawahara wrote:I have tried various ways to import the SQL but server keeps bombing out, any chance of an installer? If you import the SQL from the command line it won't time out.
If you can't / wont do the command line I would suggest you use bigdump or a similar script. You'll need the Eve SDD as well which is 380MB or something like that so you'll have to import a lot of SQL. |
Equto
EXURO VITA GREATER ITAMO MAFIA
7
|
Posted - 2012.01.15 00:45:00 -
[26] - Quote
I may have found a simpler way of making the script work. However I will have to wait until my main computer is up and running until I can push out an update. |
Equto
EXURO VITA GREATER ITAMO MAFIA
7
|
Posted - 2012.01.15 20:00:00 -
[27] - Quote
Well, instead of waiting on computer parts and since I already had everything I needed to make the installer script here it is. It will create the config file and upload the database files. JackKnife installer
How to run script: 1. Contents of Zip into main jackknife folder 2. navigate to the Installer.php 3. Fill out database information and click save 4. when next page loads click installs, it will take 5-15 minutes depending on your host. 5. use jackknife. |
Reileen Kawahara
3
|
Posted - 2012.01.16 21:07:00 -
[28] - Quote
I tried the installer and get this error.
Warning: Cannot modify header information - headers already sent by (output started at /homepages/xxxxxx/Installer.php:2) in /homepages/xxxxx/Installer.php on line 164
Any idea? |
Equto
EXURO VITA GREATER ITAMO MAFIA
7
|
Posted - 2012.01.16 22:10:00 -
[29] - Quote
Sounds like an error attemping to create the config file, try this installer Installer.zip |
Reileen Kawahara
3
|
Posted - 2012.01.16 23:19:00 -
[30] - Quote
Still same error but line 165 now |
|
|
|
|
Pages: [1] 2 3 4 :: one page |
First page | Previous page | Next page | Last page |