| Pages: 1 2 [3] 4 :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 3 post(s) |
Rynlam
Gallente
   |
Posted - 2008.02.12 17:24:00 -
[61]
Um... maybe I'm blind, but where do I get the info on number of low/med/hi slots? I can't find it in invTypes, nor a reference to another table with the info.
|
Vessper
Indicium Technologies
|
Posted - 2008.02.13 09:28:00 -
[62]
Check the dgmTypeAttributes table. You'll find details of slots where attributeID=:
12 (low slot)
13 (mid slot)
14 (high slot)
1137 (rig slot)
101 (launcher slot)
102 (turret slot)
- - - - - -
EveHQ Character App | Item DB |
Yuwan Sum
Caldari
|
Posted - 2008.02.13 11:57:00 -
[63]
Didn't see the already provided sqlite version here, so I used this to convert from the mssql files:
#!/bin/sh
for i in `find . -type f`
do
echo Importing $i
sed -e 's/dbo\.\|COMMIT;\|-- Data export copyright 1997-2007 by CCP Games\.//g;s/,true/,1/g;s/,false/,0/g' $i | sqlite3 eve.s3db
done
Just posting this for informational purposes, the available download
is probably better.
Blog: http://www.itcrowd.be
AIM: [email protected] (intactive e-mail address)
MSN: [email protected] (inactive e-mail address) |
Lambda Expression
|
Posted - 2008.02.13 18:21:00 -
[64]
Since I couldn't seem to download the file, I decided to upload my version instead.
You can get it here http://www.mediafire.com/?6tru1h2ymzz
|
Adria Eqviis
|
Posted - 2008.02.19 11:39:00 -
[65]
Hi, does anybody know how to get the Ice types available in a system that has Ice fields? securityclass seems ununsable since:
30005082 Enal, sec class B2 has Clear Icicle
30005238 Menai, sec class B2 has Clear Icicle, Glare Crust
(Data from fluidorbit.co.uk)
So two systems with the same security have different ices... does someone know where fluidorbit gets its data and/or whether that data actually is correct?
|
Rynlam
Gallente
|
Posted - 2008.02.21 02:00:00 -
[66]
Anybody know where shipBonusCC, shipBonusCC2 (and the rest of shipBonusXX# fields) relate to? I can find them for each individual ship by looking at the ship info ingame, but is there a table somewhere with something like itemID, shipBonusName, shieldCapacityModifier (or whatever the bonus modifies)?
|
Adria Eqviis
|
Posted - 2008.02.21 20:14:00 -
[67]
 Originally by: Rynlam
Anybody know where shipBonusCC, shipBonusCC2 (and the rest of shipBonusXX# fields) relate to?
shipBonus* are parameters for the effects in dgmEffects. For example, take a Caracal:
shipBonusCC = 5
shipBonusCC2 = 10.0
in dgmEffects, it has:
shipMissileKineticDamageCC
shipMissileHeavyVelocityBonusCC2
shipMissileLightVelocityBonusCC2
shipMissileAssaultMissileVelocityBonusCC2
Each of the effects is a bonus the Caracal gets. The first one uses the value from shipBonusCC and results in a 5% bonus to missile kinetic damage. The other three ones use the shipBonusCC2 value to give a 10% bonus to missile velocities.
The reason for this layout probably is that the different effects in dgmEffects all have associated code fragments to do something. But if you want to balance, tweak or nerf something, it's easier if you don't have to change some code. Therefore, the code uses these parameters.
|
Jack Toad
Federal Space Academy
Red Army Alliance
|
Posted - 2008.02.22 07:26:00 -
[68]
Originally by: Yuwan Sum
Didn't see the already provided sqlite version here, so I used this to convert from the mssql files:
#!/bin/sh
for i in `find . -type f`
do
echo Importing $i
sed -e 's/dbo\.\|COMMIT;\|-- Data export copyright 1997-2007 by CCP Games\.//g;s/,true/,1/g;s/,false/,0/g' $i | sqlite3 eve.s3db
done
Just posting this for informational purposes, the available download
is probably better.
http://oldforums.eveonline.com/?a=topic&threadID=650828&page=1#30
I've checked it. It's still there.
|
Walfadr Wreath
|
Posted - 2008.02.27 14:35:00 -
[69]
Edited by: Walfadr Wreath on 27/02/2008 14:35:20
Hi.
I'm bit confused of asking my question but... where exactly I can find agent names... ?
|
Gilgamoth
Eldritch Storm
|
Posted - 2008.02.29 00:29:00 -
[70]
Originally by: Walfadr Wreath
where exactly I can find agent names... ?
Agent names are in evenames where itemID matches the agentID from agtagents.
Regards,
Gil
Live on Eden Underground Radio every Wednesday 19:00 - 21:00 GMT. |
|
|
Nanirso Kayen
Caldari
Oberon Incorporated
Morsus Mihi
|
Posted - 2008.03.03 11:38:00 -
[71]
Edited by: Nanirso Kayen on 03/03/2008 11:43:10
Edited by: Nanirso Kayen on 03/03/2008 11:42:59
Edited by: Nanirso Kayen on 03/03/2008 11:39:01
I'm trying to import the MySQL export into my database but want it in UTF8 and not latin1. Anyone been able to solve this? I keep getting ERROR 1046 (42000) at new lines while importing all databases at the same time.
Just importing chrCareers worked fine so thinking about importing them one by one. |
Amonshige
Axe Gang
|
Posted - 2008.03.09 05:01:00 -
[72]
Hi
I downloaded the 1.4.0 (Trinity) rev 322 kb from http://www.eve-dev.net and noticed the missing premium icons for 32 and 64 pixel icons.
I searched around and couldn't find an update so i went about downloading the static data in this thread, and of course found the released data is incorrect for the smaller icon sizes (old ship models). So I resized the 256's down to 64. Gave them a little unsharp mask.
I then made a little script to find all the external ship id's with a tech level 2 as well as ships with class greater than 29 (this was for marauders, electronic attack frigates, HICs etc - these don't have tech level 2 set in the kb database). Used those numbers and grafted my own t2 tag to them. I then resized them down to 32.
If you want them, you can grab them from here:
http://dl.eve-files.com/media/corp/epvb/trinity_kb_icons_32_and_64.zip |
sandshark
|
Posted - 2008.03.13 10:53:00 -
[73]
Any news on when we can expect an fresh database export with the recent changes in them?
(and maybe an update SQL script with only the changed values? so i don't have to to whole import)
Thanks in advance,
sand
|
Enterrer Vivant
|
Posted - 2008.03.13 22:22:00 -
[74]
Quote:
Here it is: http://dl.eve-files.com/media/0712/trinity_1.0_sqlite3.db.zip [~60Mb]
PS: It's conversion of the Mysql5 version of the dump with the same keys and indexes.
This is great! Only I can't reach it. Is there something wrong with the eve-files downloads? I can't seem to get a complete file for sqlite or postgres off this site.
Does anyone know an alternative address for these extracts?
Any help much appreciated,
--- EV
PS. I can reach the CCP stuff, ie. MSSQL download no problem at all.
|
Neo Aztec
Aliastra
|
Posted - 2008.03.18 14:53:00 -
[75]
Great stuff! Thanks for doing that mysql dump.
I am currently using it with my EVE API Java library - you are now able to fetch data about every object in EVE with my library - so... thanks ALOT!
---
JEVEAPI Java library (Discussion) |
Coyl
Sacred Temple
United Legion
|
Posted - 2008.03.27 03:16:00 -
[76]
Found a strange problem while developing a web-ui for the database:
SELECT typeID, typeName, t.graphicID, icon FROM invtypes t left outer join evegraphics g on ( g.graphicID = t.graphicID ) where t.typeID = 23338 or typeName like '%Raven'
All these ships look like Raven, but no icons are provided.
Each of these files:
trinity_1.0_img_types_dx8.zip [71MB]
trinity_1.0_img_types_dx9.zip [73MB]
contains only dx9_png\shiptypes_png\256_256\638.png, an icon for the Raven itself, typeID=638.
So, where to get icons for other ships? There is a series of ships with graphicID=2158 (exterminators and all other ravens piloted by guristas) and no icons fo them: no files named after their typeID (like in the case of Raven) or... named after graphicsID.
|
menne
|
Posted - 2008.03.31 19:30:00 -
[77]
Hey i am thinking about playing around with this data a bit. Someone has expereince how stable the database schema is meaning does it get changed very often? are new columns / tables added quite frequently with new releases? If there are quite a lot of changes how fast does ccp publish them?
thanks,
philipp
|
Tonto Auri
|
Posted - 2008.04.01 17:02:00 -
[78]
Originally by: Nanirso Kayen
I'm trying to import the MySQL export into my database but want it in UTF8 and not latin1. Anyone been able to solve this? I keep getting ERROR 1046 (42000) at new lines while importing all databases at the same time.
Just importing chrCareers worked fine so thinking about importing them one by one.
To have Your database in the right encoding, do the following:
1. Create Your database. Set up all tables as You want, with right encoding.
2. Fire up mysql commandline tool and connect to Your database.
3. Tell the database tp "SET NAMES <insert the encoding of Your SQL files here>;"
4. Import all stuff.
MySQL will do all character encoding conversion for You (if that even possible).
Do not try to import russian text into swedish tables :) It's pointless.
Thanks CCP for cu |
Dragonwarrior
British Space Corporation
Tactical Narcotics Team
|
Posted - 2008.04.01 20:18:00 -
[79]
Edited by: Dragonwarrior on 01/04/2008 20:35:56
is there comming a new db update ? soon
MD
|
Khelia
Stardust Heavy Industries
Majesta Empire
|
Posted - 2008.04.26 00:35:00 -
[80]
Originally by: Raquel Smith
Edited by: Raquel Smith on 11/12/2007 22:18:44
Postgres 8.1 dump available here: http://dl.eve-files.com/media/corp/crudvis/trinity-postgres-8.1.zip
edit: linky
Wonderful, thank you very much. :-D |
|
|
Dewar Scrabulous
Minmatar
Dreugan Enterprises
|
Posted - 2008.05.07 20:07:00 -
[81]
I'm working with the Access database provided in this thread trying to find an accurate count of how much minerals I can get for recycling something, as the Item Database here on eve-online.com appears to be out of date. I've found the item typeID from the invtypes table, but I'm not sure where I have to take that value to find how much of each type of mineral it provides when recycled. I'm sure I'm just missing something obvious, it's been a while since I worked with databases. Can anyone help me out?
---
|
Vessper
The Machmen
|
Posted - 2008.05.08 08:37:00 -
[82]
Originally by: Dewar Scrabulous
I'm working with the Access database provided in this thread trying to find an accurate count of how much minerals I can get for recycling something, as the Item Database here on eve-online.com appears to be out of date. I've found the item typeID from the invtypes table, but I'm not sure where I have to take that value to find how much of each type of mineral it provides when recycled. I'm sure I'm just missing something obvious, it's been a while since I worked with databases. Can anyone help me out?
Check out the TL2Materials table. It should provide details of all materials used to build (activity=1) as well as what you get from recycling (activity=6).
- - - - - -
EveHQ Char App | Item DB |
Dewar Scrabulous
Minmatar
Dreugan Enterprises
|
Posted - 2008.05.08 17:34:00 -
[83]
Thanks a bunch
---
|
Kaven Kantrix
Two Brothers Mining Corp.
Friend or Enemy
|
Posted - 2008.06.02 17:43:00 -
[84]
Ok, call me stupid, because I have a stupid question.
I decided I wanted to look at the database. I downloaded and installed MySql 5. Its running, and I am using the command line client to access it.
From the documentation, it seems the "import" command is "<".
So I use the "use test" command to switch to a test db, then tried "< filename.sql" where filename.sql is any of the files in the dump.
It tells me there is an error on line 1 of the file, and doesnt import anything.
What am I doing wrong?
|
Kaven Kantrix
Two Brothers Mining Corp.
Friend or Enemy
|
Posted - 2008.06.02 17:48:00 -
[85]
Forgot to mention, using windows XP.
|
Tkar vonBiggendorf
Snake Eyes Inc
Friend or Enemy
|
Posted - 2008.06.04 22:27:00 -
[86]
o/ Kaven
The data you seek is the securityClass field.
Look in mapSolarSystemMinerals for the matching securityClass, and there's your answer.
Here's an example for everyone's favorite region, The Forge:
select
ss.solarSystemName, security=CONVERT(decimal(6,4),ss.security),
ss.securityClass,
radiusAU=(ss.radius/149597870300.9203),
mineralGroup=g.groupName
from mapSolarSystems ss
LEFT JOIN mapSolarSystemMinerals ssm ON ss.securityClass=ssm.securityClass
LEFT JOIN invGroups g ON ssm.mineralGroupID=g.groupID
WHERE ss.regionID=10000002
ORDER BY ss.solarSystemName, g.groupName
Also note that the securityClass for the drone regions is incorrect.
I promise nothingÖ. --CCP Prism X |
Kaven Kantrix
Two Brothers Mining Corp.
Friend or Enemy
|
Posted - 2008.06.06 04:45:00 -
[87]
Well, that explains it. The data dump I have (the mysql one from the original post, and/or the access conversion of it that someone was nice enough to post) dont have that table mapSolarSystemMinerals in it. I also dont see it references in the schema picture someone posted.
So is it just missing from the MySQL version, but available in theMS SQL version, or did you get your data dump from someplace else?
P.S. Thanks for the help. Assuming I get my hands on that table, that will be perfect for me.
|
Ralle030583
The Wild Hunt
Pure.
|
Posted - 2008.06.11 15:24:00 -
[88]
Edited by: Ralle030583 on 11/06/2008 15:24:29
EA Data Export plz :)
---------------------
You need a free Killboard?
check: http:\\www.eve-kill.net
Originally by: CCP Sharkbait
i have untrashed this bug report and i will take car |
WoogyDude
GoonFleet
GoonSwarm
|
Posted - 2008.06.12 00:24:00 -
[89]
An updated dump of the system/stargate list would be much appreciated. We want to update evemap with the new systems.
|
DaOpa
Static Corp
|
Posted - 2008.06.14 14:53:00 -
[90]
Has there been a new DB dump for Empyrean Age yet?
----------
Static Corp Website |
|
|
|
|
| |
|
| Pages: 1 2 [3] 4 :: one page |
| First page | Previous page | Next page | Last page |