| Pages: [1] 2 3 :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
VolatileVoid
Balanced Unity
Fatal Ascension
0
   |
Posted - 2013.02.16 21:17:00 -
[1] - Quote
Hi to the community.
Description of what the tool should do: (english not my motherlanguage)
Preface: This tool does not send information outside.
I am posting this with my main char.
A tool useful for watching POS fuel and reactions. Written in C# and using SQLite as database.
The tool updates its information regularly though most information relies to the long api cache
which is 6h for assets and applies to silos. If you own hidden pos it might show them, infact i dont know what that is.
2 Screenshots [url]http://www.myimg.de/?img=fuel09ba99.jpg[/url] [url]http://www.myimg.de/?img=reaction0c7429.jpg[/url].
As its highly beta version it may contain bugs and that is the reason why it needs testing.
To start working you need your and a corp api key (new api) entered in the Settings page.
Type in your character name like ingame including capitals. Copy and paste the apiid and vcode
and click store char key. Then overwrite the apiid and vcode with the corp one and store corp key.
If everything goes well, you can select your name on the upper left drop down box. After selection
it will take a while until data is displayed. The tool needs some more api data as listed below.
account/Characters, char/CharacterSheet, eve/ConquerableStationList, map/Sovereignty, corp/AssetList,
corp/StarbaseList, corp/StarbaseDetail, corp/Locations, think that are all which you need to enable for the api key aswell.
Fuel page: Pretty much self explaining except 3 things. You can double click has Sov. if you own a pos
in other player controlled space. You may enter a group name in the group column to filter the view by groups.
If you doubleclick the field cleared your name and the time will appear. This can be used as reminder
and if you setup an external mysql database it will be seen by other corpmember that have same access.
Reaction page: Most of the configurations are recognized by the reaction type like daisy chaining. Some configurations
arent so you may doubleclick dir. which sets the direction of the silo (mostly not needed).
In the remark column you can enter a reminder like what todo with the stuff. The cleared column works same as fuel page.
Assets page: This lists corp assets relating pos like fuel, reaction material and pos modules.
Ammunition and Fitting page: Not much to say here except, as the api lacks some important information you may see this
as a glance what might possibly come in the future. The api dont know about the online, armor, hull,... status of pos modules and
dont know charges insides guns except crystals. I really would like to know if a gun (although it would only possible every 6h)
is empty but unfortunately the api dont know.
There is a cache folder generated in C:\[user documents]\EveXmlCache there will be the sqlite data aswell except the static db
which stays in the program folder. The software may need some .net4 things from microsoft which will be handled by the
click once installation of visual studio.
A word to the api. The api is sometimes not reliable and a little buggy. In this case the software tries to use cached data
and ignore the api errors. Its not documented how the api handles same api calls from different clients.
If you still interested download and try: [url]http://balanced-unity.de/data/EvePos.zip[/url]
Teamwork: If its running well (i dont ownn a non german os) and you need to manage the poses by several corp members there
is the possibility on the settings page to use an own (external) mysql server. This requires deeper knowledge an several aspects.
You need to insert the connection string in the following format:
Data Source=your_server_adress;Port=your_mysql_port_number;Database=evepostool;UserID=your_db_user;Password=your_db_password;
You should use a limited user and a non default port number and so on...
There will be 2 tables used with the following contens:
CREATE TABLE `silo` (
`itemID` bigint(20) NOT NULL,
`corpID` bigint(20) NOT NULL,
`direction` varchar(1) DEFAULT NULL,
`remark` varchar(100) DEFAULT NULL,
`cleared` bit(1) DEFAULT NULL,
`clearedBy` varchar(100) DEFAULT NULL,
`clearedTimestamp` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`itemID`,`corpID`)
)
CREATE TABLE `tower` (
`itemID` bigint(20) NOT NULL,
`corpID` bigint(20) NOT NULL,
`groupName` varchar(100) DEFAULT NULL,
`hasSov` bit(1) DEFAULT NULL,
`cleared` bit(1) DEFAULT NULL,
`clearedBy` varchar(100) DEFAULT NULL,
`clearedTimestamp` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`itemID`,`corpID`)
)
The software has an export function for the corp api key as encrypted plain text for copy and paste which is intended
to be able giving user view rights even if they arent director. I'm not sure if this is a good idea but the key can only be
imported by the character which name was entered by exporting. The key will stop working if the player left the corp.
Please post (most likely helpful) information here (or contact ingame). |
VolatileVoid
Balanced Unity
Fatal Ascension
0
|
Posted - 2013.02.18 10:05:00 -
[2] - Quote
I dont think this is working perfect, so give me please some hint. In the case it's working perfect, donate me some isk that i get an idea if its useful in any way:) |
Lord Battlestar
CALIMA COLLABORATIVE
Atrox Urbanis Respublique Abundatia
25
|
Posted - 2013.02.18 18:49:00 -
[3] - Quote
Looks like a very useful too so far, i like that it is a stand alone application compared to the online applications that some of us are not good at using yet lol.
I once podded myself by blowing a huge fart. |
VolatileVoid
Balanced Unity
Fatal Ascension
0
|
Posted - 2013.02.18 22:29:00 -
[4] - Quote
Thank you very much for being the first writing something.
Switched installer to english but shows still german maybe i need to install english visual studio.
A corpmate told me aswell that the Setting page isnt well done.
I changed it a little. For being able to see tower related stuff its not really necessary to have a char key input.
But if the user of leaves the corp he shouldnt be able to see corp stuff anymore. So i need 2 steps to register.
First enter the character name like ingame (regarding capitals) copy and paste the API id and vCode then click
Store char key which should display key valid and stored.
After that the corp name will be displayed in the grey box.
Second copy and paste the corp API in the next 2 fields and click Store corp key. The key isnt verified at this point
which will be changed in the future.
I hope this will fix the misunderstandings a little. The new version is up at the same location, just overwrite the old one.
|
VolatileVoid
Balanced Unity
Fatal Ascension
1
|
Posted - 2013.02.20 11:24:00 -
[5] - Quote
Added a link for prebuild api, personal and corp. Added a page with personal assets related pos caus some dont use corp office for maintaining pos. Fixed a bug where an api error message was cached. If this insist to display you could press the Clear XML cache button on the Setting page. |
VolatileVoid
Balanced Unity
Fatal Ascension
1
|
Posted - 2013.02.26 20:27:00 -
[6] - Quote
Fixed some bugs with displaying corp/char assets and fitting. Btw. i am seeking voluntary tester:)
New version is uploaded. |
Krezh
Lycosa Syndicate
Surely You're Joking
0
|
Posted - 2013.02.28 05:20:00 -
[7] - Quote
Interesting tool. |
Malkuth Shahul
Republic Military School
Minmatar Republic
0
|
Posted - 2013.02.28 05:21:00 -
[8] - Quote
I've added two different API's, tho one won't show.
ANd that's the one with most poses, and with poses in w-space.
I wonter what's causing this? |
VolatileVoid
Balanced Unity
Fatal Ascension
1
|
Posted - 2013.02.28 09:06:00 -
[9] - Quote
Thank you for the replys, i really hoped w-space would work. As me and my friends dont have pos there i wasnt able to test it. There are 2 possible reasons:
1. Your w-space holder has some special characters in the name, to verify that you could send me the linked name by ingame mail. Please attach a description what happens if you choose the w-space character.
2. W-space is different in the api. I need to find w-space and setup a small pos for testing. I will do that today or friday and report the result here if i am done.
|
Angellis Ketatsu
Anonymous Technology
Red Alliance
0
|
Posted - 2013.02.28 11:13:00 -
[10] - Quote
You can ask for a more convenient interface to connect to the database with test connection |
Malkuth Shahul
Republic Military School
Minmatar Republic
0
|
Posted - 2013.02.28 13:02:00 -
[11] - Quote
VolatileVoid wrote:Thank you for the replys, i really hoped w-space would work. As me and my friends dont have pos there i wasnt able to test it. There are 2 possible reasons:
1. Your w-space holder has some special characters in the name, to verify that you could send me the linked name by ingame mail. Please attach a description what happens if you choose the w-space character.
2. W-space is different in the api. I need to find w-space and setup a small pos for testing. I will do that today or friday and report the result here if i am done.
No special characters in the name so that's not the issue.
The issues must be as you say the w-space api bit. |
Malkuth Shahul
Republic Military School
Minmatar Republic
0
|
Posted - 2013.02.28 19:19:00 -
[12] - Quote
By the way, you could add verison numbers to your updates, so it will be easier to tell if the download link is to a new release. |
VolatileVoid
Balanced Unity
Fatal Ascension
2
|
Posted - 2013.02.28 21:39:00 -
[13] - Quote
If you got many assets you need to wait maybe 2 mins until then it displays nothing for the first time. But i setup a pos in w-space and here is what i get displayed: http://www.myimg.de/?img=WhFuelbd611.jpg
Also added the version number on the settings page and set it to 1.1.1. hope i can add an update checker later on.
Now there is a Test button next to the MySql connection string, didnt think that someone was already at the point to use the software with more ppl.
Please continue with this helpful posts, thank you.
|
Malkuth Shahul
Republic Military School
Minmatar Republic
0
|
Posted - 2013.03.01 16:16:00 -
[14] - Quote
I've waited for the program to get the pos values from my char's API now for over 10 hours, anothing has happened. I still can't see WH poses. |
VolatileVoid
Balanced Unity
Fatal Ascension
2
|
Posted - 2013.03.01 16:23:00 -
[15] - Quote
Im sure you have the new version which sais its version 1.1.1 on the settings page, could you press the clear cache button down left on the setting page which will close the program and you need to start it again. |
Malkuth Shahul
Republic Military School
Minmatar Republic
0
|
Posted - 2013.03.01 19:39:00 -
[16] - Quote
VolatileVoid wrote:Im sure you have the new version which sais its version 1.1.1 on the settings page, could you press the clear cache button down left on the setting page which will close the program and you need to start it again. Just a stupid question, did you enter the corp key for the other character?
Yupp, I've got the latest version, I've added different API keys.. still I get no showing of the poses from WH-Space |
Gabba Cyno
27
|
Posted - 2013.03.02 03:18:00 -
[17] - Quote
I am getting "character not in api" error when i try to store char key.
. |
VolatileVoid
Balanced Unity
Fatal Ascension
2
|
Posted - 2013.03.02 08:45:00 -
[18] - Quote
Gabba Cyno could you send me your ingame name by ingame mail caus there may be a difference with the visual studio character set and the one used by eve.
Malkuth Shahul is it possible to contact me ingame, i really want to know whats so special with your w-space setup?
This toon is more or less frequent online.
|
VolatileVoid
Balanced Unity
Fatal Ascension
2
|
Posted - 2013.03.04 08:44:00 -
[19] - Quote
(Beta) Version 1.1.2 is downloadable now. Changes are the following:
- Changed the startmenu group to EVE, didnt recognize fast enough that the old group was stupid:)
- Removed an unnessesary data loop (and cpu usage) while refreshing the display every 10 mins.
- Added an option for debug purposes only next to the Clear cahe button.
- Fixed 2 internal bugs of which i am not sure if they could be seen in the data displayed.
If you get the message while installing that it cant be started from this location, deinstall it first from control panel/software.
|
Angellis Ketatsu
Anonymous Technology
RA Citizens
0
|
Posted - 2013.03.09 09:20:00 -
[20] - Quote
I am getting "character not in api" error when i try to store char key. |
VolatileVoid
Balanced Unity
Fatal Ascension
2
|
Posted - 2013.03.10 15:45:00 -
[21] - Quote
Version 1.1.3.0 is up.
- Fixes Character set conversion
Names and Character Names should now show the same ingame and in the tool.
Should fix character not in api if the character had a foreign (seen from USA) letter in it.
|
VolatileVoid
Balanced Unity
Fatal Ascension
2
|
Posted - 2013.03.12 16:54:00 -
[22] - Quote
New Version 1.1.4.0.
Fixes:
- Fuel page stayed empty by a partly unsuccessful api update
- The last material in the summary on the reaction page was missing.
|
Angellis Ketatsu
Anonymous Technology
RA Citizens
0
|
Posted - 2013.03.13 12:03:00 -
[23] - Quote
pls convo my ingame bacaus error continues (Character not in api) |
Gabba Cyno
30
|
Posted - 2013.03.29 03:15:00 -
[24] - Quote
For the Corp API part, can you tell us what exactly needs to be selected when creating the API?
. |
VolatileVoid
Balanced Unity
Fatal Ascension
2
|
Posted - 2013.03.31 09:48:00 -
[25] - Quote
Hello all,
the API page update broke the predefined key's. For the tool to work you need to enter the following:
Your charname in the field Ingame Name (including capitals). Create a Character API which contains
Locations, Characterinfo, CharacterSheet, AssetList and enter it in the Fields Char API ID, Char vCode
and press Store char key. This is needed to verify that you are in the corp the tower belong to and
to display the private pos related assets with their location.
After this create a API key of type corporation (must be director) which contains
Starbase List, Starbase Detail, Locations, CorporationSheet, AssetList and enter it in Corp API ID
and Corp vCode and press Store corp key. This is all you need to do if you got a director key.
|
VolatileVoid
ELVE Industries
Brothers of Tangra
3
|
Posted - 2013.06.07 19:58:00 -
[26] - Quote
New version is available 1.1.6.
Fixes: Added new materials into db.
Corrected corpname with '.
Button Testconnection now uses current connection string.
Its now possible to enter the corp api key.
Sorry for inconvenience, still looks like this tool isnt useful. |
Veronika Avada
Miner's Heaven
0
|
Posted - 2013.06.09 11:37:00 -
[27] - Quote
VolatileVoid wrote:...
Sorry for inconvenience, still looks like this tool isnt useful.
It's VERY useful - fixes are made just a few minutes after reporting problems.
Thanks for this tool, keep on great work.
|
Midas Shi
Hamsters Corporation
Brothers of Tangra
0
|
Posted - 2013.06.25 20:51:00 -
[28] - Quote
0/
How my config this
Source=your_server_adress;Port=your_mysql_port_number;Database=evepostool;UserID=your_db_user;Password=your_db_password;
if :
Source=localhost
Port=3306
Database=test
UserID=admin
Password= non have |
VolatileVoid
ELVE Industries
Brothers of Tangra
4
|
Posted - 2013.06.26 07:04:00 -
[29] - Quote
as i wrote the external mysql database is only needed for groupwork and not for a local installation. the tool uses sqlite like evemon does and works without mysql, if this was your question. |
Midas Shi
Hamsters Corporation
Brothers of Tangra
0
|
Posted - 2013.07.02 21:03:00 -
[30] - Quote
I want to do for a few people and I can not write a true test database connection |
| |
|
| Pages: [1] 2 3 :: one page |
| First page | Previous page | Next page | Last page |