EVE Search - Crucible database dump

All Channels

EVE Technology Lab

Crucible database dump

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: 1 2 3 :: [one page]
Author	Thread Statistics \| Show CCP posts - 7 post(s)
mancert Resilience. Northern Coalition. 0	Posted - 2011.11.30 07:03:00 - [1] - Quote Anyone know when a dump of the database will be availeble?
TorTorden NorCorp Enterprise No Holes Barred 14	Posted - 2011.11.30 10:59:00 - [2] - Quote It's out but only from ccp direct so no mysql version yet :S http://www.eveonline.com/community/toolkit.asp
Desmont McCallock 50	Posted - 2011.11.30 11:47:00 - [3] - Quote Would be nice if it included the SQL script file.
Kekkekir Order of the Domain The Polaris Syndicate 1	Posted - 2011.11.30 12:56:00 - [4] - Quote The dump seems to be available now here: http://www.eveonline.com/community/toolkit.asp Just need someone to convert it to SQL now :
Arskaff Adhocracy Incorporated Adhocracy 4	Posted - 2011.11.30 18:46:00 - [5] - Quote Desmont McCallock wrote: Changes (possible breaking) found: - eveNames -> renamed to invNames - eveLocations -> removed - eveOwners -> removed Edit 2: cruc10-sqlite3-v.1.db.7z Thanx for the SQLite version. About eveLocations and eveOwners: weren't those simply subsets of tables such as eveNames and invItems ?
mancert Resilience. Northern Coalition. 0	Posted - 2011.11.30 19:07:00 - [6] - Quote Sweet, 'im currently uploading a mysql version to eve-files! I'll post again when it's there
KillMinusNine League of Obsidian Blades 0	Posted - 2011.11.30 19:27:00 - [7] - Quote Found this thread: https://forums.eveonline.com/default.aspx?g=posts&t=39958&find=unread
mancert Resilience. Northern Coalition. 0	Posted - 2011.11.30 19:34:00 - [8] - Quote Haha... i need has faster internet! well here is the db i converted anyways! http://eve-files.com/dl/249921 Have fun!
Desmont McCallock 51	Posted - 2011.11.30 19:37:00 - [9] - Quote Arskaff wrote: Desmont McCallock wrote: Changes (possible breaking) found: - eveNames -> renamed to invNames - eveLocations -> removed - eveOwners -> removed Edit 2: cruc10-sqlite3-v.1.db.7z Thanx for the SQLite version. About eveLocations and eveOwners: weren't those simply subsets of tables such as eveNames and invItems ? Yes and having them in SDD was doubling the file size. Praise they got rid of those tables.
Scrapyard Bob EVE University Ivy League 413	Posted - 2011.11.30 20:23:00 - [10] - Quote Crossing my fingers for a pgsql version.
TorTorden NorCorp Enterprise No Holes Barred 15	Posted - 2011.11.30 20:26:00 - [11] - Quote Just as a warning been quick looking at the two conversions now and they are both with extended inserts, not a problem for me, since I don't bother with bigdump etc.
Luminocity Filthy Thirteen 2	Posted - 2011.11.30 22:34:00 - [12] - Quote I have not checked any of the other conversions at this point so they might be completely valid. But here is another version I created using the same approach as the one I did for the last Incarna dump. (among other things no extended inserts): crucible1.0.57975-mysql5-v1.zip
Ruziel Twilight Military Industrial Complex 1	Posted - 2011.12.01 02:50:00 - [13] - Quote One more mysql conversion for the pile: cru100-mysql5-v1.zip Used the same scripts that Jercy used for all his previous conversions.

CCP Prism X C C P C C P Alliance 214	Posted - 2011.12.01 08:50:00 - [14] - Quote There were some errors in the original dump that were discovered when the same static data hit TQ. That and general post expansion busyness is causing this delay. Terribly sorry, will get the ball rolling on this ASAP. ~ CCP Prism X EVE Database Developer "Prism X is my first world problem." ~ CCP FLX If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it.

Cyerus Galactic Dominion Eternal Strife 13	Posted - 2011.12.02 01:34:00 - [15] - Quote CCP Prims X: Once these issues are fixed, would you mind making a sticky topic will all the conversions?
Zifrian Deep Space Innovations 48	Posted - 2011.12.02 02:27:00 - [16] - Quote CCP Prism X wrote: There were some errors in the original dump that were discovered when the same static data hit TQ. That and general post expansion busyness is causing this delay. Terribly sorry, will get the ball rolling on this ASAP. So the current download has errors? Or am I misreading? Maximze your Industry Potential! - Get EVE Isk per Hour! https://sourceforge.net/projects/eveiph/

CCP Prism X C C P C C P Alliance 220	Posted - 2011.12.02 08:46:00 - [17] - Quote It currently has errors. SELECT * FROM dbo.agtAgents WHERE locationID < 60000000 Will show you that all agents in space have locationIDs of stations (Because we all know that the only valid locations for agents are stations and solar systems so that anything below 60Mils must be located in systems!). It's because of a change in our internal processes with how we treat NPC Characters VS Player Characters and how that static data is copied around our servers. It has been fixed internally and I'm tryingto push for its (SDEs) regeneration and deployment but people are just very busy these post-expansion-deployment-days. P.S. I am very disappointed in these forums forcing me to break our SQL coding standards! ~ CCP Prism X EVE Database Developer "Prism X is my first world problem." ~ CCP FLX If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it.

Pizzutz Capital Industries Research And Development Fidelas Constans 0	Posted - 2011.12.02 11:39:00 - [18] - Quote Will we be getting an updated invControlTowerResources table when the fuel block switchover happens, or will the fuel resources be managed a different way?
Celebrain 1st Steps Academy Fidelas Constans 0	Posted - 2011.12.02 20:37:00 - [19] - Quote I've been using the eveOwners table to detect and display the bloodline (and therefore race too) of each individual agent. You can see an example here: http://www.eveiverse.com/agents/akinoma_nimpalius Another side effect of losing bloodline info is that I can no longer generate IGB eve info popup urls for these agents any longer... since they are all encoded, both for player characters and npc characters with a typeID that represents each bloodline. So that will be very frustrating too, and potentially a really big functionality problem. :( Please, if you are able, either restore that table, or add a new column with this info to the agtAgents table, just like you did for the isLocator column when you removed the agtConfig table. Otherwise my site will have to lose data and functionality that some people may have found interesting and/or useful. Of course adding gender and ancestry would be cool too, but losing data is more painful than not adding new cool stuff. Cele
TorTorden NorCorp Enterprise No Holes Barred 15	Posted - 2011.12.03 16:46:00 - [20] - Quote Any ETA on the non bugged datadump or is it out already ?
Desmont McCallock 52	Posted - 2011.12.03 16:52:00 - [21] - Quote Try again on Monday.
Zifrian Deep Space Innovations 54	Posted - 2011.12.04 01:07:00 - [22] - Quote The invItems table seems to be incomplete (I hope). There are no asteroids in the table anymore. This is from Incarna: Select top 10 invTypes.typeName, invGroups.groupName from invTypes, invItems, invGroups where invTypes.typeID = invItems.typeID and invTypes.groupID = invGroups.groupID and invGroups.categoryID = 25 group by invGroups.groupName, invTypes.typeName Returns: Fiery KerniteKernite PyroxeresPyroxeres Solid PyroxeresPyroxeres VeldsparVeldspar Condensed ScorditeScordite KerniteKernite Viscous PyroxeresPyroxeres Concentrated VeldsparVeldspar Dense VeldsparVeldspar ScorditeScordite Same query in Crucible returns no rows. Maximze your Industry Potential! - Get EVE Isk per Hour! https://sourceforge.net/projects/eveiph/
Celebrain 1st Steps Academy Fidelas Constans 0	Posted - 2011.12.04 20:50:00 - [23] - Quote Celebrain wrote: I've been using the eveOwners table to detect and display the bloodline (and therefore race too) of each individual agent. You know what? never mind on this one, I finally found the "missing" agent bloodline type data, in the invItems table. :P
Mnengli Noiliffe Imperial Academy Amarr Empire 10	Posted - 2011.12.04 21:48:00 - [24] - Quote Desmont McCallock wrote: Edit 2: cruc10-sqlite3-v.1.db.7z Notice: Not compatible with EAM I can only use sqlite export... tried this one, and new t2 modules' material requirements are not the same as the ones shown in game for t2 bpo.
Desmont McCallock 52	Posted - 2011.12.05 07:03:00 - [25] - Quote Because T2 modules requirements are combination of invTypeMaterials and ramTypeRequirements. Search the forums, there are at least a dozen topics on the subject.

CCP Prism X C C P C C P Alliance 225	Posted - 2011.12.05 08:02:00 - [26] - Quote Zifrian wrote: The invItems table seems to be incomplete (I hope). There are no asteroids in the table anymore. This is from Incarna: Select top 10 invTypes.typeName, invGroups.groupName from invTypes, invItems, invGroups where invTypes.typeID = invItems.typeID and invTypes.groupID = invGroups.groupID and invGroups.categoryID = 25 group by invGroups.groupName, invTypes.typeName No, we sanitized a lot of stuff out of invItems, asteroids included. Desmont McCallock wrote: Would be nice if it included the SQL script file. Not very hot on releasing anything about our own internal structure of things. Not that obscurity is security but transparency isn't either. Desmont McCallock wrote: Changes (possible breaking) found: - agtConfig -> empty table ??? (edit: related data have been inserted in agtAgents table, which was about time) - dgmAttributeTypes -> some attributeName values are NULL (intended?) - eveNames -> renamed to invNames - eveLocations -> removed - eveOwners -> removed - invPositions -> added - invUniqueNames -> added - translationLaguages -> added (typo error on table name - contains no data, should be removed) - translationTables -> added - trnTranslationLanguages -> added - warCombatZoneSystems -> added - warCombatZones -> added I thought the changelog had mentioned that eveNames and eveOwners were now invNames and invUniqueNames as well as that eveLocations is now invPositions. The dogma attributes missing names is probably due to our new translation system, will look at that. ~ CCP Prism X EVE Database Developer "Prism X is my first world problem." ~ CCP FLX If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it.

Lutz Major Austriae Est Imperare Orbi Universo 50	Posted - 2011.12.05 08:05:00 - [27] - Quote Zifrian wrote: The invItems table seems to be incomplete (I hope). There are no asteroids in the table anymore. This is from Incarna: Select top 10 invTypes.typeName, invGroups.groupName from invTypes, invItems, invGroups where invTypes.typeID = invItems.typeID and invTypes.groupID = invGroups.groupID and invGroups.categoryID = 25 group by invGroups.groupName, invTypes.typeName Remove the invItems table from your query and it should work again
Zifrian Deep Space Innovations 71	Posted - 2011.12.05 12:20:00 - [28] - Quote Lutz Major wrote: Zifrian wrote: The invItems table seems to be incomplete (I hope). There are no asteroids in the table anymore. This is from Incarna: Select top 10 invTypes.typeName, invGroups.groupName from invTypes, invItems, invGroups where invTypes.typeID = invItems.typeID and invTypes.groupID = invGroups.groupID and invGroups.categoryID = 25 group by invGroups.groupName, invTypes.typeName Remove the invItems table from your query and it should work again Nah, I was linking this to the map tables by the location id in invitems to find out where certain asteroids spawned. So this was just a partial query. Maximze your Industry Potential! - Get EVE Isk per Hour! https://sourceforge.net/projects/eveiph/
Desmont McCallock 52	Posted - 2011.12.05 14:22:00 - [29] - Quote @CCP Prism X Is there any particular reason why the invNames table key is bigint? Same goes for invPositions.
Mnengli Noiliffe Imperial Academy Amarr Empire 10	Posted - 2011.12.05 14:30:00 - [30] - Quote Desmont McCallock wrote: Because T2 modules requirements are combination of invTypeMaterials and ramTypeRequirements. Search the forums, there are at least a dozen topics on the subject. I am talking about basic requirements like tritanium etc. besides t1 base module. is it also modified to include t1's requirements? so I have to subtract i.e. tritanium needed for t1 module from t2's count?
Xander Hunt 2	Posted - 2011.12.06 01:48:00 - [31] - Quote Desmont McCallock wrote: @CCP Prism X Is there any particular reason why the invNames table key is bigint? Same goes for invPositions. 64-bit.
Xander Hunt 2	Posted - 2011.12.06 02:08:00 - [32] - Quote CCP Prism X wrote: Desmont McCallock wrote: Would be nice if it included the SQL script file. Not very hot on releasing anything about our own internal structure of things. Not that obscurity is security but transparency isn't either. I can understand the idea of not wanting to release internal structure details, and I don't THINK MS-SQL will export true SQL statements in any form, a simple VB script that connects, reads the table data you define, then exports sanitized SQL code isn't that hard to do. Many bonuses to doing it this way. A> I don't have to have MS SQL installed anywhere. B> Script ~~kiddies~~ writers can take the SQL code and modify it to whatever their DB preferences are C> When you upgrade to the next version of MS SQL, we won't have to either D> You can limit what tables are exported E> If so inclined, any table that hasn't been changed doesn't need to be included in a new dump. Downsides: A> Table locking while data is exported - This'll hurt on larger tables, but this could be done on and mirrored server. However, if option E above is done and assuming the bigger tables may not be touched that often, may be a moot point. B> Large export of data that has to live somewhere until its compressed
Desmont McCallock 52	Posted - 2011.12.06 06:56:00 - [33] - Quote Xander Hunt wrote: Desmont McCallock wrote: @CCP Prism X Is there any particular reason why the invNames table key is bigint? Same goes for invPositions. 64-bit. Well, that's the point. It doesn't need to be 64bit. The id numbering still fits in 32bit (int).
Mnengli Noiliffe Imperial Academy Amarr Empire 10	Posted - 2011.12.06 07:06:00 - [34] - Quote Desmont McCallock wrote: Because T2 modules requirements are combination of invTypeMaterials and ramTypeRequirements. Search the forums, there are at least a dozen topics on the subject. ok here is the example. the new t2 gang links, according to the game, have the following common requirements: 106 tritanium 8 transmitter 0.5 RAM Electronics 6 nocxium -- except for skirmish 4 morphite 1 megacyte 13 isogen 1 hypersynaptic fibers 1 link I 3 nanotransistors 8 X microprocessor now let's see what we get form the export. I am using sqlite version so it might be outdated or wrong... select (select typeName from invTypes where typeID=materialTypeID),quantity from invTypeMaterials where typeID==(select typeID from invTypes where typeName="Armored Warfare Link - Damage Control II" and published) => [(u'Tritanium', 939), (u'Isogen', 110), (u'Nocxium', 55), (u'Megacyte', 11), (u'Morphite', 3), (u'Nanotransistors', 22), (u'Hypersynaptic Fibers', 11)]
Desmont McCallock 52	Posted - 2011.12.06 07:13:00 - [35] - Quote Yet again. Your query returns what you get when you reprocess the item, not what it requires to produce.
Mnengli Noiliffe Imperial Academy Amarr Empire 10	Posted - 2011.12.06 07:39:00 - [36] - Quote so the correct way is to subtract any matching t1 materials from t2 materials, in case there is a t1 consumed item in RAM list? ok, thanks for the hint and sorry if it's an off topic.
Lutz Major Austriae Est Imperare Orbi Universo 51	Posted - 2011.12.06 07:55:00 - [37] - Quote Mnengli Noiliffe wrote: so the correct way is to subtract any matching t1 materials from t2 materials, in case there is a t1 consumed item in RAM list? ok, thanks for the hint and sorry if it's an off topic. No. You must only subtract the recycled materials of any recycle-flagged item in the ramTypeRequirements table For example: Expanded Cargohold II: SELECT * FROM ramTypeRequirements WHERE typeID = 1320 You see, that the Expanded Cargohold I (requiredTypeID = 1317) is marked as recycle. Now you must subtract the materials from the Expanded Cargohold I from the other materials in the ramTypeRequirements table See also http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1220024&page=1#30
Desmont McCallock 52	Posted - 2011.12.06 12:11:00 - [38] - Quote Listen to Lutz. He has a PhD on the subject.
Lutz Major Austriae Est Imperare Orbi Universo 52	Posted - 2011.12.06 12:14:00 - [39] - Quote Desmont McCallock wrote: Listen to Lutz. He has a PhD on the subject. Unfortunately I have only a Minmatar Graduation Certificate ... and it isn't even signed
Desmont McCallock 53	Posted - 2011.12.06 15:16:00 - [40] - Quote Any ETA for fixed SDE?

CCP Prism X C C P C C P Alliance 226	Posted - 2011.12.06 15:18:00 - [41] - Quote Stillman just posted the fixed version up in a sticky. Sorry about the delay, I blame the plague. ~ CCP Prism X EVE Database Developer "Prism X is my first world problem." ~ CCP FLX If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it.


CCP Stillman C C P C C P Alliance 120	Posted - 2011.12.06 15:19:00 - [42] - Quote Desmont McCallock wrote: Any ETA for fixed SDE? Yep Associate QA Tester for Team EVESec.

Desmont McCallock 53	Posted - 2011.12.06 15:27:00 - [43] - Quote This is the definition of "Sync".
Xander Hunt 2	Posted - 2011.12.06 15:45:00 - [44] - Quote Desmont McCallock wrote: Xander Hunt wrote: Desmont McCallock wrote: @CCP Prism X Is there any particular reason why the invNames table key is bigint? Same goes for invPositions. 64-bit. Well, that's the point. It doesn't need to be 64bit. The id numbering still fits in 32bit (int). The point is that the database has been expanded to SUPPORT 64-bit. Whether or not the ID still fits within the 32-bit range isn't the point. However, that said, I haven't looked at this particular table to see a record count, but I probably will later tonight as I'm writing my own MS SQL Export utility. http://www.eveonline.com/devblog.asp?a=blog&bid=798 http://www.eveonline.com/devblog.asp?a=blog&bid=813 http://www.eveonline.com/devblog.asp?a=blog&bid=870

CCP Prism X C C P C C P Alliance 226	Posted - 2011.12.06 15:52:00 - [45] - Quote The itemID is 64bit because the API can return 64bit itemIDs and the prudent developer might want to commit data he does not expect to change much to his local DB for a spell. ~ CCP Prism X EVE Database Developer "Prism X is my first world problem." ~ CCP FLX If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it.

Desmont McCallock 53	Posted - 2011.12.06 16:02:00 - [46] - Quote @ Xander Hunt I'm fully aware of the subject you linked. Still the PKs for those tables don't necessarily need to be 64bit. But again they may be part of another section of EVE DB that needs them to be 64bit. Never the less, I'll find a workaround on the issue the use of 64bit PKs are causing to EVEMon's data file generation. Edit: Wrote before seeing Prism X post.
Zeta Zhul Preemptive Paranoia 14	Posted - 2011.12.06 17:15:00 - [47] - Quote Do the previously posted MySQL data conversions included the updated data? Is there a MySQL data conversion that includes the updated data? Bueller? :) Any help would be greatly appreciated thanks!
Desmont McCallock 53	Posted - 2011.12.06 17:20:00 - [48] - Quote Patients. I'm sure people are working on it (at least I am). Probably they will post the links on the sticky thread.
Wind Jammer Molden Heath Software Company 10	Posted - 2011.12.06 23:31:00 - [49] - Quote Small point here. The blueprints of the new T2 mods do not have a techLevel attribute on dgmtypeattributes. For example. these rows from dgmtypeattributes have a techLevel attribute for both the module and the module's blueprint. typeIDattributeIDvalueIntvalueFloat 23334222(null) 23344222(null) (where 2333,2334 = Survey Scanner II, Survey Scanner II Blueprint). With the new T2 modules, the techLevel is set for the module, and not the blueprint. Here are a few of the new T2 modules' blueprints: select * from dgmtypeattributes where typeid in (4263,4265,4267,4269,4271,4273,4275,4277,4279,4281,4283,4285,4287,4289) and attributeID = 422 -- no rows found IDs are: 4262Armored Warfare Link - Damage Control II 4263Armored Warfare Link - Damage Control II Blueprint 4264Armored Warfare Link - Passive Defense II 4265Armored Warfare Link - Passive Defense II Blueprint 4266Armored Warfare Link - Rapid Repair II 4267Armored Warfare Link - Rapid Repair II Blueprint 4268Information Warfare Link - Electronic Superiority II 4269Information Warfare Link - Electronic Superiority II Blueprint 4270Information Warfare Link - Recon Operation II 4271Information Warfare Link - Recon Operation II Blueprint 4272Information Warfare Link - Sensor Integrity II 4273Information Warfare Link - Sensor Integrity II Blueprint 4274Mining Foreman Link - Harvester Capacitor Efficiency II 4275Mining Foreman Link - Harvester Capacitor Efficiency II Blueprint 4276Mining Foreman Link - Laser Optimization II 4277Mining Foreman Link - Laser Optimization II Blueprint 4278Mining Foreman Link - Mining Laser Field Enhancement II 4279Mining Foreman Link - Mining Laser Field Enhancement II Blueprint 4280Siege Warfare Link - Active Shielding II 4281Siege Warfare Link - Active Shielding II Blueprint 4282Siege Warfare Link - Shield Efficiency II 4283Siege Warfare Link - Shield Efficiency II Blueprint 4284Siege Warfare Link - Shield Harmonizing II 4285Siege Warfare Link - Shield Harmonizing II Blueprint 4286Skirmish Warfare Link - Evasive Maneuvers II 4287Skirmish Warfare Link - Evasive Maneuvers II Blueprint 4288Skirmish Warfare Link - Interdiction Maneuvers II 4289Skirmish Warfare Link - Interdiction Maneuvers II Blueprint [url]http://eveproductionmixer.appspot.com[/url]
Ruziel Twilight Military Industrial Complex 1	Posted - 2011.12.07 02:45:00 - [50] - Quote See here for MySQL conversion.
Pizzutz Capital Industries Research And Development Fidelas Constans 0	Posted - 2011.12.07 12:21:00 - [51] - Quote Pizzutz wrote: Will we be getting an updated invControlTowerResources table when the fuel block switchover happens, or will the fuel resources be managed a different way?
Desmont McCallock 64	Posted - 2011.12.10 08:02:00 - [52] - Quote In case you didn't noticed. SDE conversions.
Mesar Thorrn Imperial Academy Amarr Empire 0	Posted - 2011.12.10 15:46:00 - [53] - Quote Hello! I-¦m looking for a TypeID to ItemName conversion .txt file Does anyone know a file, up to date with the Crucible expansion or is able to generate one out of the database-dump? The only list I-¦ve found http://eve-files.com/chribba/typeid.txt isnt up to date. Thanks in advance.

Chribba Otherworld Enterprises Otherworld Empire 1138	Posted - 2011.12.10 16:07:00 - [54] - Quote Mesar Thorrn wrote: Hello! I-¦m looking for a TypeID to ItemName conversion .txt file Does anyone know a file, up to date with the Crucible expansion or is able to generate one out of the database-dump? The only list I-¦ve found http://eve-files.com/chribba/typeid.txt isnt up to date. Thanks in advance. I'm gonna update that one asap. I'm just a bit delayed. edit/updated. sorry for the delay. /c GÿàGÿàGÿà Secure 3rd party service GÿàGÿàGÿà Visit my in-game channel 'Holy Veldspar' Follow me on Twitter @Chribba

Desmont McCallock 64	Posted - 2011.12.10 16:17:00 - [55] - Quote Oh, what an honor ! Posting right after your highness.
M Kernel Karma Tec 2	Posted - 2012.01.05 12:25:00 - [56] - Quote So I've now tried all 3 MySQL conversions from the official SDE Thread. However, on 2 of them (Luminocity and Desmont's) I have charset issues. When i do Quote: SELECT `description` FROM `invtypes` WHERE `typeID` =2869 i get this. Ruziel's conversions seems to work thogh. Can anyone confirm/deny this? (or, tell me what I did wrong?)

CCP Prism X C C P C C P Alliance 480	Posted - 2012.01.05 13:17:00 - [57] - Quote "Only the highly advanced Ukomi superconductor can be rendered small enough for use in nano-factories, microscopic devices programmed to absorb and recycle ambient material into useful matter. Each factory is built from reactive metals, ensuring that they interact properly GÇô or not at all GÇô with their environment, while a mote of industrial explosive automatically destroys them when they have completed their task." From the DB we generate the backup from. ~ CCP Prism X EVE Database Developer If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it.

Desmont McCallock 98	Posted - 2012.01.05 13:42:00 - [58] - Quote M Kernel wrote: So I've now tried all 3 MySQL conversions from the official SDE Thread. However, on 2 of them (Luminocity and Desmont's) I have charset issues. When i do Quote: SELECT `description` FROM `invtypes` WHERE `typeID` =2869 i get this. Ruziel's conversions seems to work thogh. Can anyone confirm/deny this? (or, tell me what I did wrong?) "CHARSET=utf8" is what I use. Jercy also used this CHARSET. In my MySQL DB, description shows up fine.
Phoenix Pryde 3-I Area 42 0	Posted - 2012.01.07 14:39:00 - [59] - Quote Is there by chance some MySQL dump with individual tables ? (my upload sucks, making the singlefile ones a pain to use ^^)
DerStrick ZERO T0LERANCE RAZOR Alliance 0	Posted - 2012.01.21 00:10:00 - [60] - Quote Hi theres, is there a known dump for spaceships only? I am currently working at a table for this but sorting out all the ships is a mess. tyvm regards
Scrapyard Bob EVE University Ivy League 662	Posted - 2012.01.29 01:26:00 - [61] - Quote Anyone have a Crucible 1.1 version of the database dump in PostgreSQL (pgsql) format? Whoops, just found it at: https://forums.eveonline.com/default.aspx?g=posts&t=61544
Takhion AWE Corporation Intrepid Crossing 0	Posted - 2012.02.02 17:25:00 - [62] - Quote The database dump I pulled from this thread does not seem to have fuelBlocks in its item database, nor is the invControlTowerResources* table updated. Is there a mysql dump which is updated post CCP's Fuel Block slop over?
Desmont McCallock 120	Posted - 2012.02.02 17:29:00 - [63] - Quote Funny as it may sound, the thread you are looking for, is provided by the link just above your post.

Pages: 1 2 3 :: [one page]

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.