| Pages: 1 [2] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 9 post(s) |
Tonto Auri
Vhero' Multipurpose Corp
    |
Posted - 2010.12.11 01:05:00 -
[31]
Originally by: derivativo
As for MySQL, PostgreSQL and SQLite, some of the most used free database servers, they run under many operating systems. Therefore, why not officially release a dump for any, or all, of these databases? I hardly believe that most 3rd party developers use MSSQL anyway, and there got to be someone in CCP who do know how to convert database formats...
Because they don't have them on hand, don't have infrastructure to test them, and, as said, these formats are not easy for them to maintain?
Seriously though, your *****ing is just annoying..
--
Thanks CCP for cu |
derivativo
|
Posted - 2010.12.11 01:55:00 -
[32]
Originally by: Tonto Auri
Because they don't have them on hand, don't have infrastructure to test them, and, as said, these formats are not easy for them to maintain?
You speak for CCP?
Originally by: Tonto Auri
Seriously though, your *****ing is just annoying..
I'm sorry it bothers you.
|
|
CCP Explorer
|
Posted - 2010.12.11 11:30:00 -
[33]
Originally by: Celebrain
Originally by: Sarah Fourleaf
I can't find any new icons (with top left corner cursor for deadspace, pirate faction, officer, etc.)) in it.
You have to figure this out for yourself and add them, if you want them. That's the way it's always been for T2 and T3 corners, just now they have new faction, deadspace, etc ones. The new corners themselves (by themselves) are in the new image dump for us to use.
If you look in dgmAttributeTypes then you will find
1692/metaGroupID/meta group of type
If you then "select * from dgmTypeAttributes where attributeID = 1692" then you find the list of types that have a meta group and the meta group value. You should be interested in tech levels 2 and 3 and meta groups 3, 4, 5 and 6.
The Python code that generates the overlay is approx. as follows:
"""
aa techII = 2
aa Storyline = 3
aa faction = 4
aa Officer = 5
aa Deadspace = 6
aa techIII = 14
"""
groupDict = {
aa 3 : "ui_73_16_245",
aa 4 : "ui_73_16_246",
aa 5 : "ui_73_16_248",
aa 6 : "ui_73_16_247",
aa}
techLevel = dogma.GetTypeInformation(typeID).techLevel
groupID = dogma.GetTypeAttribute(typeID, 1692)
if groupID or techLevel in (2,3):
aa if groupID:
aaaa icon = groupDict.get(groupID)
aa else:
aaaa icon = {
aaaa 2:("ui_73_16_242"),
aaaa 3:("ui_73_16_243"),
aaaa }.get(techLevel, None)
# else it is a regular tech 1 item and no overlay
Erlendur S. Thorsteinsson
Software Director
EVE Online, CCP Games |
|
|
CCP Explorer
|
Posted - 2010.12.11 11:40:00 -
[34]
Originally by: derivativo
As for MySQL, PostgreSQL and SQLite, some of the most used free database servers, they run under many operating systems. Therefore, why not officially release a dump for any, or all, of these databases? I hardly believe that most 3rd party developers use MSSQL anyway, and there got to be someone in CCP who do know how to convert database formats...
Because we use Microsoft SQL Server at CCP and that's the format we can and will officially support.
Erlendur S. Thorsteinsson
Software Director
EVE Online, CCP Games |
|
Celebrain
1st Steps Academy
Fidelas Constans
|
Posted - 2010.12.11 20:28:00 -
[35]
Originally by: CCP Explorer
The Python code that generates the overlay is approx. as follows:
I found that in addition to the logic outlined above by CCP Explorer, I also had to check if the associated marketGroupName contained the string "Faction" because not every faction ship was in the faction meta group that was listed in the new faction market groups. Only the ones that were based on a Tech 1 hull were.
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2010.12.11 23:14:00 -
[36]
Originally by: Celebrain
Originally by: CCP Explorer
The Python code that generates the overlay is approx. as follows:
I found that in addition to the logic outlined above by CCP Explorer, I also had to check if the associated marketGroupName contained the string "Faction" because not every faction ship was in the faction meta group that was listed in the new faction market groups. Only the ones that were based on a Tech 1 hull were.
You could, you know, put them there... and save yourself a headache for future.
Also don't hesitete to report it, as it looks like an obvious bug.
--
Thanks CCP for cu |
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.12.11 23:41:00 -
[37]
Originally by: derivativo
Therefore, why not officially release a dump for any, or all, of these databases? I hardly believe that most 3rd party developers use MSSQL anyway, and there got to be someone in CCP who do know how to convert database formats...
ccp actualy did provide mysql dumps in 2007. kinda. check the timeline. if you find the joke, you can keep it.
i do consider it unreasonable to expect ccp to provide the full set of formats. because otherwise, where draw the line? hey, we need those halfdozen nosql things too! or not.
have ccp do one format, and do it timely and well. let the users sort out the rest. they do.
the "problem" with the current dump isnt that it is mssql. it is the "binary format that requires special tools to read". and in a way that even has half the mssql userbase cursing: those who are using mssql 2005 and cant read the backup made by mssql 2008. some of those actualy grab the mssql script file i make as first step of the conversion dance.
i currently see a need for mssql, mysql, sqlite, postgres. because thats what people actualy ask for each time.
Originally by: derivativo
I understand it is better than nothing. And of course that 99%+ of players don't even care about this, as they don't develop anything.
even 99% of the eve app developers wont care, because it doesnt make a difference for them.
the ccp dump delivery format details matter to ccp and the halfdozen people who are actualy doing conversions.
any change from what we get pretty reliably for two years now means additional work for those people. including me.
that, and the schema / column type problem has me somewhat opposed to a change from a working mssql setup to csv just to have stuff more "open".
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.12.11 23:43:00 -
[38]
Originally by: CCP Explorer
Because we use Microsoft SQL Server at CCP and that's the format we can and will officially support.
you actualy can have both MSSQL and silence the penguinhuggers.
just dump the MSSQL as script-file instead of the binary backup.
ccp probably has some non-EXPRESS MSSQL around that will even admit it can do script dumps.
so probably very little onetime work for the change CCP-side, and no additional tools or steps involved in the dump process.
even the download size stays the same, the power of 7z.
for the users, it is the same with mssql2008, and works a lot better with mssql2005. hi Chribba.
those doing conversions off mssql fall in one of the above two categories.
those who do text-to-text conversions and just use mssql to load the bak and dump it out as text may be spared those two steps, if they wish.
this includes apps like evemon which are already attached somewhere in the tree created above, and can just stay there at no effort or choose to move closer to the root...
so we would get a dump in the same mssql quality as now that doesnt mean additional ongoing work for anyone involved and is as "open" as any other flat text file format.
|
Triallian Dent
Astrometric Services Interstellar Corporation
|
Posted - 2010.12.13 16:26:00 -
[39]
Edited by: Triallian Dent on 13/12/2010 16:26:53
Edited by: Triallian Dent on 13/12/2010 16:26:17
Hello all! Don't know how useful the last one was but once again here's a mongodump for mongodb
http://rudelinux.org/inc100-mongo.tar.gz
|
|
CCP Stillman
|
Posted - 2010.12.14 14:55:00 -
[40]
Updated with 1.0.1 versions.
|
|
|
|
CCP Zymurgist
Gallente
C C P
|
Posted - 2010.12.14 15:41:00 -
[41]
Locked by request, New thread is located here.
Zymurgist
Community Representative
CCP Hf, EVE Online
Contact Us |
|
|
|
| |
|
| Pages: 1 [2] :: one page |
| First page | Previous page | Next page | Last page |