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.
 

pos planning tools
Author
Previous Topic Next Topic
Noel Lark
The Maythorn
#1 - 2013-10-04 14:03:17 UTC
Is there any pos tools out there that are up to date? I know of eve.1019.net and myPOS but is there a more comprehensive level tool such as eveHQ or EFT. If not I guess I could learn to design a pos tool based on what's already availible.

The pos tool I'm making is by c# and is purely experimental since I'm still learning c# so I'll expect the program to fall apart. There's somethings I'd like to know first tho. I have downloaded the datadump provided by ccp and restored it on msSQL. What I don't seem to get is how I can access the database in c#; have I over looked something? Do I just import the database into c# or do I have to connect to my local sql server and extract/query the database?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-10-04 14:31:32 UTC
You have options when it comes to the database:
1: Require a full sql server instance to make your application work.
2: translate the data into a different format and use that. Such an an sqlite database (single file, no process other than your application)
3: embed the data you actually care about into your application.


2 or 3 are probably the best route, unless this is just for personal use.
3 requires no additional information, you just need to store the data in a static array, in your code. If new things come out, or other changes happen to the numbers, you'll need to rework it and recompile.
2 allows for updating numbers, without needing to recompile.



http://msdn.microsoft.com/en-us/library/bb655884(v=vs.90).aspx may be of interest.
as may http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki and http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/#/

https://www.fuzzwork.co.uk/dump/odyssey-1.1-91288/odyssey11.sqlite.bz2 is a copy of the SDE in sqlite format. I'd suggest using a cut down copy, as it contains everything. you almost certainly won't need everything in there. mapDenormalize and trnTranslations are examples of tables you probably won't need.

For POS details, it's probably going to be invTypes, dgmTypeAttributes, and dgmAttributeTypes. Maybe dgmEffects and dgmTypeEffects as well.

Note: I don't use c#, so I can't really help there.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Rob Crowley
State War Academy
#3 - 2013-10-04 16:00:36 UTC
EveHQ used to have a plug-in called POS Manager. I never used it myself but from what I read about it it was quite popular and apparently the most comprehensive POS tool. Here's a pic: http://www.cronos-titan.org/uploads/posManager.png

You might have noticed the past tense. It hasn't been maintained for quite some time and therefore got removed from EveHQ a while ago. But maybe working with what's there and updating it might be easier than writing something from scratch. It was written in C#.

Regarding the DB Steve already told you the options. EveHQ uses #2 per default (an SQL CE file in this case), but also supports #1.
Noel Lark
The Maythorn
#4 - 2013-10-05 00:26:09 UTC  |  Edited by: Noel Lark
Thanks guys for pointing me in the right direction. I'll certainly look into sqlite and I guess msSQL isn't needed anymore.


* I do have one problem with installing... I don't know which I'm suppose to download. Do I get the .net binary or do I download the windows runtime?