Release ED ToolBox - A companion app

Walter Harriman · Sep 27, 2016

tehface said:
as per ticket on github, how do i fix high mysqld cpu usages? between 75%-95%

Replied to the ticket.

Alec Turner · Sep 28, 2016

Hey Walter, can we get the list of visited systems out of ED Toolbox in a format suitable for importing into the ED cache as described here?

https://forums.frontier.co.uk/showthread.php/291643-The-Visited-Stars-cache

Walter Harriman · Sep 28, 2016

Alec Turner said:
Hey Walter, can we get the list of visited systems out of ED Toolbox in a format suitable for importing into the ED cache as described here?

https://forums.frontier.co.uk/showthread.php/291643-The-Visited-Stars-cache

You can use the database manager to run this query:

Code:

SELECT system_name FROM user_visited_systems

You can then export the data to a CSV file which will include one visited system name per line.

The username for the database is root, password is in the data/server_config.inc.php file. Database is elite_log.

AnthorNet · Oct 4, 2016

Can you please fix, your sending to EDSM.

Code:

$visited_on_utc = date("Y-m-d H:i:s");
$export = file_get_contents("http://www.edsm.net/api-logs-v1/set-log?commanderName=" . urlencode($settings["edsm_cmdr_name"]) . "&apiKey=" . $settings["edsm_api_key"] . "&systemName=" . urlencode($curSys["name"]) . "&dateVisited=" . urlencode($visited_on_utc) . "&fromSoftwareVersion=" . $settings["edtb_version"] . "&fromSoftware=ED+ToolBox&x=" . urlencode($curSys["x"]) . "&y=" . urlencode($curSys["y"]) . "&z=" . urlencode($curSys["z"]));

The visited date should always be the one in the logs converted in UTC. Not the current date.
The coordinates sent are modified by your own database by looking at them before in the edtb_systems or the user_systems_own table, instead of keeping the ones from the logs.

This led to some coordinates sent twice by your software with a slight difference in our database.

Thanks.

Walter Harriman · Oct 5, 2016

AnthorNet said:
Can you please fix, your sending to EDSM.

Code:

$visited_on_utc = date("Y-m-d H:i:s"); $export = file_get_contents("http://www.edsm.net/api-logs-v1/set-log?commanderName=" . urlencode($settings["edsm_cmdr_name"]) . "&apiKey=" . $settings["edsm_api_key"] . "&systemName=" . urlencode($curSys["name"]) . "&dateVisited=" . urlencode($visited_on_utc) . "&fromSoftwareVersion=" . $settings["edtb_version"] . "&fromSoftware=ED+ToolBox&x=" . urlencode($curSys["x"]) . "&y=" . urlencode($curSys["y"]) . "&z=" . urlencode($curSys["z"]));

The visited date should always be the one in the logs converted in UTC. Not the current date.
The coordinates sent are modified by your own database by looking at them before in the edtb_systems or the user_systems_own table, instead of keeping the ones from the logs.

This led to some coordinates sent twice by your software with a slight difference in our database.

Thanks.

Ah, sorry. Can you confirm changing it to this works as intended:

Code:

$export = file_get_contents("http://www.edsm.net/api-logs-v1/set-log?commanderName=" . urlencode($settings["edsm_cmdr_name"]) . "&apiKey=" . $settings["edsm_api_key"] . "&systemName=" . urlencode($curSys["name"]) . "&dateVisited=" . urlencode($visited_on) . "&fromSoftwareVersion=" . $settings["edtb_version"] . "&fromSoftware=ED+ToolBox&x=" . urlencode($curSys["x"]) . "&y=" . urlencode($curSys["y"]) . "&z=" . urlencode($curSys["z"]));

tonkepen · Oct 5, 2016

Hello:

Sorry for my English.

Install the program and it works perfect, but in the photographs section, showing photos, jumps a permissions problem, so it does not show catches, which could be ?.

Thanks.

AnthorNet · Oct 5, 2016

Walter Harriman said:

Ah, sorry. Can you confirm changing it to this works as intended:

Code:

$export = file_get_contents("http://www.edsm.net/api-logs-v1/set-log?commanderName=" . urlencode($settings["edsm_cmdr_name"]) . "&apiKey=" . $settings["edsm_api_key"] . "&systemName=" . urlencode($curSys["name"]) . "&dateVisited=" . urlencode($visited_on) . "&fromSoftwareVersion=" . $settings["edtb_version"] . "&fromSoftware=ED+ToolBox&x=" . urlencode($curSys["x"]) . "&y=" . urlencode($curSys["y"]) . "&z=" . urlencode($curSys["z"]));

Seems good to me for the coordinates, not sure about the date, but I think so.

Walter Harriman · Oct 8, 2016

AnthorNet said:
Seems good to me for the coordinates, not sure about the date, but I think so.

I've updated EDTB and hopefully this bug is now fixed.

Jorge · Oct 18, 2016

Walter Harriman said:
I've updated EDTB and hopefully this bug is now fixed.

Hey Walter. Is it normal that I get the "no data, reconnect API" message every time I launch the app? I have to keep triggering inputting the email password for it to work.

Walter Harriman · Oct 18, 2016

Jorge said:
Hey Walter. Is it normal that I get the "no data, reconnect API" message every time I launch the app? I have to keep triggering inputting the email password for it to work.

Unfortunately it is. I haven't been able to get it to work properly.

Jorge · Oct 18, 2016

Walter Harriman said:
Unfortunately it is. I haven't been able to get it to work properly.

Not a huge deal. I just wanted to make sure I wasn't missing anything.

One question though. What data am I missing when the API is not connected? Is it just the 3 numbers at the top right (integrity, fuel & occupied cargo space)?

Walter Harriman · Oct 19, 2016

Jorge said:
Not a huge deal. I just wanted to make sure I wasn't missing anything.

One question though. What data am I missing when the API is not connected? Is it just the 3 numbers at the top right (integrity, fuel & occupied cargo space)?

That, and the amount of credits.

I'm hoping we can do away with the API completely at some point.

Jorge · Oct 20, 2016

Walter Harriman said:
That, and the amount of credits.

I'm hoping we can do away with the API completely at some point.

Cool, all information that is pretty easy to access, so not a big problem then.

Thanks!

denali · Oct 20, 2016

When I try to log into the API, it never triggers the verification email to be sent. The logs say it may be a username or password error, but when I use ED Market Connector with the same username and password, I log in and get my verification email with no problems. Any ideas?

Apache Error Log:

Code:

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net

EDTB error log:

Code:

[21.10.2016 08:02:40][D:\Program Files (x86)\ED ToolBox\EDTB\Admin\API_login.php on line 61] Error: API login failed, possibly mistyped password or email.
[21.10.2016 08:03:39][D:\Program Files (x86)\ED ToolBox\EDTB\action\updateAPIdata.php on line 78] Error: no output from API, see http://edtb.xyz/?q=common-issues#api_info for help
[21.10.2016 08:04:54][D:\Program Files (x86)\ED ToolBox\EDTB\action\updateAPIdata.php on line 78] Error: no output from API, see http://edtb.xyz/?q=common-issues#api_info for help
[21.10.2016 08:09:01][D:\Program Files (x86)\ED ToolBox\EDTB\action\updateAPIdata.php on line 78] Error: no output from API, see http://edtb.xyz/?q=common-issues#api_info for help

sutex · Oct 23, 2016

You may like this thread , as EDtoolbox allows networking , .https://forums.frontier.co.uk/showt...ts-for-third-party-apps?p=4668504#post4668504

Walter Harriman · Oct 24, 2016

denali said:

When I try to log into the API, it never triggers the verification email to be sent. The logs say it may be a username or password error, but when I use ED Market Connector with the same username and password, I log in and get my verification email with no problems. Any ideas?

Apache Error Log:

Code:

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed


  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0curl: (6) Could not resolve host: companion.orerve.net

EDTB error log:

Code:

[21.10.2016 08:02:40][D:\Program Files (x86)\ED ToolBox\EDTB\Admin\API_login.php on line 61] Error: API login failed, possibly mistyped password or email.
[21.10.2016 08:03:39][D:\Program Files (x86)\ED ToolBox\EDTB\action\updateAPIdata.php on line 78] Error: no output from API, see http://edtb.xyz/?q=common-issues#api_info for help
[21.10.2016 08:04:54][D:\Program Files (x86)\ED ToolBox\EDTB\action\updateAPIdata.php on line 78] Error: no output from API, see http://edtb.xyz/?q=common-issues#api_info for help
[21.10.2016 08:09:01][D:\Program Files (x86)\ED ToolBox\EDTB\action\updateAPIdata.php on line 78] Error: no output from API, see http://edtb.xyz/?q=common-issues#api_info for help

Googling the Apache error would suggest it's because you have IPV6 enabled. You might want to try disabling it to see if that helps.

denali · Oct 25, 2016

Walter Harriman said:
Googling the Apache error would suggest it's because you have IPV6 enabled. You might want to try disabling it to see if that helps.

IPv6 has been disabled for quite some time. I had to disable it in order to watch Netflix. I verified that it is still disabled when I read your response.

Alec Turner · Oct 26, 2016

Hey Walter, now that 2.2 is live could I maybe persuade you to try/post a brief set of instructions on how to export the list of previously visited systems that's held in EDToolbox and then import that list into the new in-game previously visited cache?

I think the ED side of things is described in this thread ..

https://forums.frontier.co.uk/showthread.php/291643-The-Visited-Stars-cache

.. via the creation of a file called "ImportStars.txt" in "c:\\Appdata\Local\Frontier Developments\Elite Dangerous".

AnthorNet · Oct 26, 2016

Alec Turner said:
Hey Walter, now that 2.2 is live could I maybe persuade you to try/post a brief set of instructions on how to export the list of previously visited systems that's held in EDToolbox and then import that list into the new in-game previously visited cache?

I think the ED side of things is described in this thread ..

https://forums.frontier.co.uk/showthread.php/291643-The-Visited-Stars-cache

.. via the creation of a file called "ImportStars.txt" in "c:\\Appdata\Local\Frontier Developments\Elite Dangerous".

If you have synchronised with EDSM, you can generate the file here: https://www.edsm.net/settings/export

Alec Turner · Oct 26, 2016

AnthorNet said:
If you have synchronised with EDSM, you can generate the file here: https://www.edsm.net/settings/export

Actually I haven't ... is that easy to do? (I should probably just re-read the EDToolbox instructions!).