EVE Technology Lab

Oh, I don't remember answering that when I made my account. Maybe Quantix added it in the meantime to keep spambots out. Anyway I wouldn't expect the answer to be more complicated than "Jita", but I'll ask.

You probably won't get far in that regard with SQL alone (though I'm not an SQL wizard). I'd use some actual programming language to convert the SQL output data into the preferred format which is probably what Steve will do.

Thanks, it's working. Can you help in addition?

Is it possible to add category field? (frigate,cruiser, etc)
And "flyable" - have players acces to that shiptype.

How to add long, but compact "where" construction like
WHERE
at.attributeName = "agility" OR
at.attributeName = "armorHP" OR
at.attributeName = "armorThermalDamageResonance" OR
at.attributeName = "droneBandwidth"
etc

?

You could use the invTypes.groupID field for that to filter out all the different frigate or cruiser groups.

You mean to filter out stuff like Polaris ships and such? My best idea would be to check for "invTypes.published = 1", but I'm not sure if that gets rid of all ships that aren't accessible for players.

To filter out lines with attributes you're not interested in? Just add this with an "AND" instead of the "WHERE" at the end of the above query and use single quotes ' instead of ". You could also use "AND at.attributeName in ('agility','armorHP','droneBandwidth')" instead.

Can't say I ever had performance issues and until recently I ran EveHQ on an absurdly old PC. You might wanna check out the new version in a couple days, we recently did some extensive backend work which decreased startup time quite a bit.

Thanks for the report, I'll look into it once the Rubicon update work is done.

I don't know for sure why .NET was originally chosen, but it certainly contributed to EveHQ having a way more user-friendly (and also prettier) UI than many other tools. If you want to code a 100k LoC project in another way to increase performance more power to you. If it turns out as good as EveHQ and faster I'll be your first user.

Another user with this error has had success after installing the Visual C++ 2010 redistributable, which appears to be a dependency for the new SQLite.

You can check http://forums.evehq.net/chat/crash-on-start-evehq-2-13-1-2548 for the details and links to the necessary files.

I'm not sure if this is a bug or not, but I don't seem to be able to add the new mobile structures to my cargo hold in the Fitter plug-in. They don't show up as usable items no matter what usability/fittability settings I'm using.

I really like that my dashboard now loads properly on start-up every time though. :)

And just confirming that mobile structures should be available in the next update (that includes mobile warp disruptors as well as the new depots, tractor units etc).

just installed new version and now i get this. and splash screen just stays on screen "converting evehq settings'


*EveHQ Error Report*

EveHQ Version: 2.13.4.2602
Date: 01/12/2013 20:52:53
Error: Positive number required.
Parameter name: culture

---

\\{panel:title=StackTrace|borderStyle=dashed|bordercolor=#ccc|titleBGColor=#eee|bgColor=#eee} at System.Globalization.CultureInfo.GetCultureInfo(Int32 culture)
at System.Globalization.TextInfo.OnDeserialized()
at System.Globalization.TextInfo.OnDeserialized(StreamingContext ctx)
at System.Runtime.Serialization.SerializationEvents.InvokeOnDeserialized(Object obj, StreamingContext context)
at System.Runtime.Serialization.ObjectManager.RaiseOnDeserializedEvent(Object obj)
at System.Runtime.Serialization.ObjectManager.RegisterObject(Object obj, Int64 objectID, SerializationInfo info, Int64 idOfContainingObj, MemberInfo member, Int32[] arrayIndex)
at System.Runtime.Serialization.Formatters.Binary.ObjectReader.RegisterObject(Object obj, ParseRecord pr, ParseRecord objectPr, Boolean bIsString)
at System.Runtime.Serialization.Formatters.Binary.ObjectReader.ParseObjectEnd(ParseRecord pr)
at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Parse(ParseRecord pr)
at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.Run()
at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
at EveHQ.Forms.FrmSplash.ConvertSettings(Boolean useLocalSwitch, String settingsFolder)
at EveHQ.Forms.FrmSplash.frmSplash_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

========== Plug-ins ==========



========= System Info =========

Operating System: Microsoft Windows NT 6.1.7601 Service Pack 1
.Net Framework Version: 4.0.30319.1008
EveHQ Location: C:\Program Files (x86)\EveHQ
EveHQ Cache Locations: C:\Users\xxxxx\AppData\Roaming\EveHQ
\\{panel}

OK, did that. Thanks. Now, I think my old version's Transaction Trading Report had a total for the total profit column, was that removed for some reason?

i do like this program. you did a good job