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.
 

EvEHQ - Is there a way to edit the value of items in the database?
Author
Previous Topic Next Topic
Jada Kautsuoi
Deep Core Mining Inc.
Caldari State
#1 - 2013-05-15 16:43:19 UTC
Hello everyone,


I have a question about EveHQ. Is it possible to change/edit a value on items in EveHQ? With the up coming cruise missile changes I'm trying to change the Fury Cruise Missile values to get a better idea of what to expect in the next patch update that will be released on June 4th, however I was able to only change the value of the Caldari Navy Raven in the HQF Editor. Very cool BTW! Any help would be appreciated.
Rob Crowley
State War Academy
#2 - 2013-05-16 16:40:48 UTC
Yes-ish. There's no support to do this within EveHQ (tbh I didn't even know the HQF Editor existed), but you can do that manually if you know some basic SQL. All these item attributes are coming from the SDE released by CCP, which is converted to a SQL CE DB file called EveHQ.sdf. Open and edit this file (I use Compact View for that), then delete the HQF cache in %appdata%\EveHQ\HQF\Cache and start EveHQ to rebuild the cache.

The hard part of this is probably finding the values you want to change in the DB. They will be in the table dgmtypeattributes, the typeids of Fury Cruises are 2621, 24531, 24533 and 24535 (which you can find in the table invtypes). The listing of attributeids is in the table dgmattributetypes.

Btw, chances of quick helpful answers are probably better if you post on the EveHQ forums at www.evehq.net.
Jada Kautsuoi
Deep Core Mining Inc.
Caldari State
#3 - 2013-05-28 21:22:32 UTC
Rob Crowley wrote:
Yes-ish. There's no support to do this within EveHQ (tbh I didn't even know the HQF Editor existed), but you can do that manually if you know some basic SQL. All these item attributes are coming from the SDE released by CCP, which is converted to a SQL CE DB file called EveHQ.sdf. Open and edit this file (I use Compact View for that), then delete the HQF cache in %appdata%\EveHQ\HQF\Cache and start EveHQ to rebuild the cache.

The hard part of this is probably finding the values you want to change in the DB. They will be in the table dgmtypeattributes, the typeids of Fury Cruises are 2621, 24531, 24533 and 24535 (which you can find in the table invtypes). The listing of attributeids is in the table dgmattributetypes.

Btw, chances of quick helpful answers are probably better if you post on the EveHQ forums at www.evehq.net.




Thanks for the reply and I'm sorry for the delayed response. I think I'll just wait it out until the patch and until they update EveHQ.
Rob Crowley
State War Academy
#4 - 2013-05-28 22:17:07 UTC
Jada Kautsuoi wrote:
Thanks for the reply and I'm sorry for the delayed response. I think I'll just wait it out until the patch and until they update EveHQ.

No worries. You shouldn't have to wait too long for that cause I have a strong hunch that "they" are already working on it so it's ready shortly after the patch. Blink