| Pages: 1 [2] 3 4 :: one page |
| Author |
Thread Statistics | Show CCP posts - 6 post(s) |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
2100
   |
Posted - 2013.11.29 20:16:00 -
[31] - Quote
oops, missed the certMasteries table.
updated the release. if you already have it, you just need certMasteries.sql.bz2
Steve Ronuken for CSM 9!
http://www.fuzzwork.co.uk/
Twitter: @fuzzysteve on Twitter |
Captain Thunk
Sniggerdly
Pandemic Legion
137
|
Posted - 2013.11.30 01:23:00 -
[32] - Quote
Haven't checked V1.04 but V1.0 didn't have extra dgmAttribute data concerning the mobile siphons - things like the ranges. |
|
CCP Creber Cattus
C C P
C C P Alliance
21
|
Posted - 2013.11.30 01:54:00 -
[33] - Quote
Rob Crowley wrote:
Cool. CCP Creber Cattus best Cattus! Btw, did you misspell Creeper Cactus?
No, correctly spelled... it's actually Latin 
Captain Thunk wrote:Haven't checked V1.04 but V1.0 didn't have extra dgmAttribute data concerning the mobile siphons - things like the ranges.
I'm at home now... might remember to check for you after the weekend if it is stored in dgmAttributes or if it is somewhere else. No promises though as I might forget. |
|
Golden Gnu
EVE University
Ivy League
105
|
Posted - 2013.12.03 11:19:00 -
[34] - Quote
@CCP Creber Cattus
Fat Cat 
Download is the meaning of life, upload is the meaning of intelligent life
http://eve.nikr.net - home of jEveAssets |
Leviticus Payne Thuel
Dystopian Archons
0
|
Posted - 2013.12.03 13:32:00 -
[35] - Quote
Is there any way to have the items only available in the market put into a text or xls file? I cannot get the sql stuff to work on my machine. |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
2115
|
Posted - 2013.12.03 13:37:00 -
[36] - Quote
Leviticus Payne Thuel wrote:Is there any way to have the items only available in the market put into a text or xls file? I cannot get the sql stuff to work on my machine.
Grab the invTypes.xls.bz2 file from my site, unzip it with 7zip.
Then you want just the stuff on the market, look for everything with an entry in the marketgroupid column.
Steve Ronuken for CSM 9!
http://www.fuzzwork.co.uk/
Twitter: @fuzzysteve on Twitter |
Leviticus Payne Thuel
Dystopian Archons
0
|
Posted - 2013.12.03 17:41:00 -
[37] - Quote
Thank you so much, this really helps me out. +1 for you my good sir.  |
Leviticus Payne Thuel
Dystopian Archons
0
|
Posted - 2013.12.03 18:49:00 -
[38] - Quote
On a second note I am curious if there is a simple way to import multiple typeids, such as all the ore types for example, and see 5 different values from each xml item:
max buy, avg buy, min sell, avg sell, volume all.
So I would have a simple layout of items on the left and the 5 values for each item to the right.
I can do this using a single API key for each item but that's 7000+ items in the market.
So do I need a single API key for each item to see those 5 results for each or can I write a VBA code that looks at all 7000 items and pulls the data from each individual xml?
thanks in advance to anyone who knows this solution. |
iwannadig
Unione Sapiens
RUST415
0
|
Posted - 2013.12.04 05:34:00 -
[39] - Quote
How to get such database, but for Dust 514? |
Rob Crowley
State War Academy
258
|
Posted - 2013.12.04 08:23:00 -
[40] - Quote
iwannadig wrote:How to get such database, but for Dust 514? Well, some Dust stuff is in the SDE, e.g. there are some items in the invTypes table. There are also Dust icons in the toolkit. One thing that seems to be missing so far is catma attributes of the items. I don't think those were made available by CCP yet. |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
2130
|
Posted - 2013.12.04 10:18:00 -
[41] - Quote
iwannadig wrote:How to get such database, but for Dust 514?
Right now, you can't.
I've heard rumblings from devs that they're working on something, but so far, nothing has emerged.
Steve Ronuken for CSM 9!
http://www.fuzzwork.co.uk/
Twitter: @fuzzysteve on Twitter |
Udonor
Native Freshfood
Minmatar Republic
44
|
Posted - 2013.12.06 22:06:00 -
[42] - Quote
Sounds like CCP is going carebear stupid again.
Logging off to avoid combat used to be an exploit in itself !!!
Yes I realize its so common and natural a metagaming idea that CCP gave up enforcing it.
CCP turned around and told us how easy it was for players to enforce logging off as being pointless instead.
But that enforcement sort of ties up a lot of forces until the violator logs back on.
Heck it can even be used in ambushes as a way to bait without really risking a ship. (Sounds like another exploit idea to me.)
OK new CCP employees no longer remember the original exploits and are raining down hell because
some clever individuals figured out how to minimize the costs of player enforcement vs exploiters logging on at random times.
Yes CCP has the power to change things as they want.
But with this new announcement CCP has effectively reclaimed responsibility for enforcement of combat logoff exploits.
Yes the invention of PVP timers a couple years ago goes half way.
 Apparently CCP has signed up to preventing log off in the same grid as potential hostiles (non-alliance folk at minimum). Or perhaps a pop-up with emergency auto-destruction should you go ahead and log off.
Whatever happened to the idea that logging off in open space was considered dangerous even if not actively in combat? What about the idea that logging off in open space right before combat began and where potential enemies could observe your log off location was intended to be suicide?
Whatever happened to the idea that the only way to log off and on safely was to dock in a station or place your ship in a POS maintenance array?
|
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
2130
|
Posted - 2013.12.06 22:55:00 -
[43] - Quote
Udonor wrote:Sounds like CCP is going carebear stupid again. Logging off to avoid combat used to be an exploit in itself !!! Yes I realize its so common and natural a metagaming idea that CCP gave up enforcing it. CCP turned around and told us how easy it was for players to enforce logging off as being pointless instead. But that enforcement sort of ties up a lot of forces until the violator logs back on. Heck it can even be used in ambushes as a way to bait without really risking a ship. (Sounds like another exploit idea to me.) OK new CCP employees no longer remember the original exploits and are raining down hell because some clever individuals figured out how to minimize the costs of player enforcement vs exploiters logging on at random times. Yes CCP has the power to change things as they want. But with this new announcement CCP has effectively reclaimed responsibility for enforcement of combat logoff exploits.Yes the invention of PVP timers a couple years ago goes half way. Apparently CCP has signed up to preventing log off in the same grid as potential hostiles (non-alliance folk at minimum). Or perhaps a pop-up with emergency auto-destruction should you go ahead and log off. Whatever happened to the idea that logging off in open space was considered dangerous even if not actively in combat? What about the idea that logging off in open space right before combat began and where potential enemies could observe your log off location was intended to be suicide? Whatever happened to the idea that the only way to log off and on safely was to dock in a station or place your ship in a POS maintenance array?
Wrong post.
Aside from that, you do know that if someone logs off, they ewarp, then you can scan them down (within a minute), shoot them, giving them a pvp flag which keeps them in space for 15 minutes ( extend by shooting them some more) https://forums.eveonline.com/default.aspx?g=posts&m=2079573#post2079573
Steve Ronuken for CSM 9!
http://www.fuzzwork.co.uk/
Twitter: @fuzzysteve on Twitter |
Gismork
French Wing
0
|
Posted - 2013.12.29 20:08:00 -
[44] - Quote
Hi,
I downloaded the latest SDE icons package and I found that the filenames inside don't use the same pattern that the images in the type package.
Filenames in the icons package are like :
8_64_1.png
8_64_10.png
8_64_11.png
8_64_12.png
8_64_13.png
8_64_14.png
8_64_15.png
8_64_16.png
8_64_2.png
....
As we can see, the size information "64" is in the middle of the filename (instead of at the end).
When we check the iconsID.yaml and take for example the iconID 293 (corresponding to hiSlots attributeID 14 in dgmAttributesTypes table) we find the following informations :
293:
description: Ship slot - HiSlot
iconFile: 08_11
In order to find the icon corresponding to the hiSlot attribute, we will need to put the size information in the middle of the iconFile found in the yaml file, that will give us 08_xx_11 where xx will be the size. The only icon corresponding in the Icons folder is 08_64_11.
I see 2 issues from this behavior :
- Weird to put the size info in the middle of the filename to be able to find the right icon.
- The icon only exists in one size in the icons folder, mostly 64 pixels but sometimes it's 32 or even 16. That means you will have to try multiple size to find the icon you need.
Nothing that we can't deal with but that's a bit weird. The behavior is perfect for the types folder.
Is it an intentional behavior or there is something wrong ?
Would be really appreciated if you could enlighten me on this ;)
Thanks ! |
Velia Starbeam
Vetus Inmortales
Insidious Empire
4
|
Posted - 2013.12.29 22:48:00 -
[45] - Quote
I cant retrieve the renders when clicking the link provided,
http://cdn1.eveonline.com/data/Rubicon_1.0.8_Renders.zip
gives
"The information you requested could not be retrieved." |
DeeJ1
BetaMax Beta
4
|
Posted - 2014.01.02 11:08:00 -
[46] - Quote
iwannadig wrote:How to get such database, but for Dust 514?
CCP FoxFour provides such SDE if you didn't notice already - https://forums.dust514.com/default.aspx?g=posts&t=127907&find=unread
Also CCP Prism X please put SoxFour out of his misery - he's doing the dumps in SQLite! |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
2522
|
Posted - 2014.01.02 14:08:00 -
[47] - Quote
https://forums.dust514.com/default.aspx?g=posts&t=126658&find=unread
And if you want it in an alternate format:
https://www.fuzzwork.co.uk/dump/dust/
Steve Ronuken for CSM 9!
http://www.fuzzwork.co.uk/
Twitter: @fuzzysteve on Twitter |
Thak Dallocort
Null Corporation
0
|
Posted - 2014.01.14 14:10:00 -
[48] - Quote
I am still having the same issue as you. I've even sent a request for support in via the email links but to no avail. |
Thak Dallocort
Null Corporation
0
|
Posted - 2014.01.14 15:01:00 -
[49] - Quote
Thak Dallocort wrote:I am still having the same issue as you. I've even sent a request for support in via the email links but to no avail.
All seems to be good now. Thanks. |
Quesa
D00M.
Northern Coalition.
26
|
Posted - 2014.01.23 02:51:00 -
[50] - Quote
Using MS Sql Server Mngt Studio 2012, it keeps looking for a log file that wasn't in the package.
Never had this much of an issue restoring the backup. |
Darkblad
Hilfe is like Free Entertainment
90
|
Posted - 2014.01.24 22:30:00 -
[51] - Quote
Couldn't find an announcement so a short note:
The Community Toolkit page now has the SDE of Rubicon 1.1 94321 ready for download.
EvE Infolinks-áGÇô Umfangreiche Sammlung von Links mit informationen ++ber EvE, inklusive Guides und Infos von mir selbst |
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
2589
|
Posted - 2014.01.25 01:27:00 -
[52] - Quote
Conversions, now including updated icon data and the new certificates (look for the cert* tables)
https://www.fuzzwork.co.uk/dump/mysql56-rubicon-1.1-94321.tbz2
https://www.fuzzwork.co.uk/dump/rrubicon-1.1-94321rubicon11.sqlite.bz2
https://www.fuzzwork.co.uk/dump/rubicon-1.1-94321/postgres-rubicon-1.194321.sql.bz2
csvs and sql dumps in.
https://www.fuzzwork.co.uk/dump/rubicon-1.1-94321/
Blueprint calculator is updated, though I've not updated the base database, which is used for autocomplete. If you give it the full name, and specify the right db, it'll work. Mobile Scan Inhibitor for example. https://www.fuzzwork.co.uk/blueprints/9/33589/0/5/0/5
Steve Ronuken for CSM 9!
http://www.fuzzwork.co.uk/
Twitter: @fuzzysteve on Twitter |
Kid Delicious
Blue Republic
RvB - BLUE Republic
16
|
Posted - 2014.01.25 03:37:00 -
[53] - Quote
Steve Ronuken wrote:Conversions...
Did I ever mention how much I appreciate you doing these? I know I have, but let me do it again, thank you so much!
|
Rob Crowley
State War Academy
275
|
Posted - 2014.01.25 17:25:00 -
[54] - Quote
Ooooh! I just ran into a problem regarding ship bonuses missing from invTypes.description, so I searched around a bit and found them in dgmTypeEffects and dgmTypeAttributes now. I don't know yet where the corresponding text for each ship bonus type is hidden, but this is potentially a hugely useful change. |
Kid Delicious
Blue Republic
RvB - BLUE Republic
16
|
Posted - 2014.01.25 18:08:00 -
[55] - Quote
Rob Crowley wrote:Ooooh! I just ran into a problem regarding ship bonuses missing from invTypes.description, so I searched around a bit and found them in dgmTypeEffects and dgmTypeAttributes now. I don't know yet where the corresponding text for each ship bonus type is hidden, but this is potentially a hugely useful change.
I haven't found the text for the traits tab either. I think the bonus keys you're describing have always been in the dogma tables.
I'm not sure how do differentiate those bonus keys and build the traits tab. Probably missing something here, if anyone figures this out please let us know... diving back in... |
Desmont McCallock
360
|
Posted - 2014.01.25 19:43:00 -
[56] - Quote
The description for the values can be found in the 'dgmAttributeTypes' table, column "displayName" (ship bonuses are with categoryID = 7) although some lack a proper 'displayName' (e.g. eliteBonusHeavyInterdictors1, eliteBonusElectronicAttackShip1, eliteBonusBlackOps1 etc.) |
Kid Delicious
Blue Republic
RvB - BLUE Republic
16
|
Posted - 2014.01.25 20:37:00 -
[57] - Quote
Unfortunately I don't think the text is in there. Using the Nestor as an example I grepped Steve's dump for "Amarr Battleship bonuses" which appears in the traits tab for that ship and got nothing. Similar strings return come up with nothing. Maybe that's 100% conclusive but I'm going to stop digging for now and start working on a work around. (I image this stuff should appear in the translation tables at least.) |
Rob Crowley
State War Academy
275
|
Posted - 2014.01.26 00:20:00 -
[58] - Quote
Desmont McCallock wrote:The description for the values can be found in the 'dgmAttributeTypes' table, column "displayName" (ship bonuses are with categoryID = 7) although some lack a proper 'displayName' (e.g. eliteBonusHeavyInterdictors1, eliteBonusElectronicAttackShip1, eliteBonusBlackOps1 etc.) The vast majority of ship bonuses in dgmTypeAttributes have generic attributes from category 7 or 9 that don't have a display name and don't reference the type of bonus at all. What would be required would be a displayName for the ship bonus effect in dgmTypeEffects.
And there's also the problem of linking the bonus values in dgmTypeAttributes with the appropriate entries in dgmTypeEffects. E.g. for a Merlin we have "shipBonusCF = -4" and "shipBonusCF2 = 5", but in dgmTypeEffects there's "shipShield*ResistanceCF2" and "shipHybridDamageBonusCF2". So I don't really see a way to link the right numbers to the corresponding effects.
Kid Delicious wrote:Using the Nestor as an example I grepped Steve's dump for "Amarr Battleship bonuses" which appears in the traits tab for that ship and got nothing. Well, the "Amarr Battleship" part is apparently coded as "AB" which would still be somewhat usable, what I'm missing more is the text description of the bonus' effect. |
Darkblad
Hilfe is like Free Entertainment
91
|
Posted - 2014.01.27 08:33:00 -
[59] - Quote
The 1.0.4 dump featured a column in that table which was helpful for what I'm doing. The factionID column, next to some others. Unfortunately, there appears to be no way to match up typeIDs of e.g. Pirate faction Ships to their correct faction with the 1.1 dump. raceID only points to the empires. Was this a one time only exception for the 1.0.4 dump? Previous dumps neither did contain these columns.
EvE Infolinks-áGÇô Umfangreiche Sammlung von Links mit informationen ++ber EvE, inklusive Guides und Infos von mir selbst |
Desmont McCallock
360
|
Posted - 2014.01.27 20:46:00 -
[60] - Quote
This also. |
| |
|
| Pages: 1 [2] 3 4 :: one page |
| First page | Previous page | Next page | Last page |