| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Linkex
Caldari
Unholy Crusader Mining Corp
   |
Posted - 2007.10.01 18:18:00 -
[1]
I need to find a method for populating a database with item info, specifically, the items name, id, and required skills. Other stuff such as slot, volume etc would be great. I have tryed the data exports, but there dosen't seem to be any docs I can find, and the database is so huge, I am struggling to see if what I need is in there.
Is this info in the export, or am I barking up the wrong wooden thingy?
|
Dal Rath
|
Posted - 2007.10.01 18:34:00 -
[2]
I built an entire clone of http://www.eve-online.com/itemdatabase/EN/default.asp using the db export, so I know the data is in there. keep looking. |
Linkex
Caldari
Unholy Crusader Mining Corp
|
Posted - 2007.10.01 18:51:00 -
[3]
Thanks for the help :)
I have found all the valume etc info, which is great, unfortunatly, its the required skills that I really need. Did you get those into your database clone as well? Cos I've hand scoured every table in the database, as well as running various searches, and nothing. :(
|
AliasXNeo
Gallente
|
Posted - 2007.10.01 19:01:00 -
[4]
Edited by: AliasXNeo on 01/10/2007 19:02:34
 Originally by: Linkex
Thanks for the help :)
I have found all the valume etc info, which is great, unfortunatly, its the required skills that I really need. Did you get those into your database clone as well? Cos I've hand scoured every table in the database, as well as running various searches, and nothing. :(
One of the script I use has all the required skills for other skills, so I'm pretty sure they should be in there. I really can't remember the name, and I'm on a different computer atm, but I know they are in the attributes table.
*Edit*
I'm pretty sure the Attribute name went like:
- RequiredSkill1
- RequiredSkill2
Then the levels for the skills was like:
- RequiredSkill1Level
- RequiredSkil2Level
Try searching for those.
------------------------------
~ Eve Online API Programmer ~
- Evewebspace Developer -
Like my stuff? Donate to Neo XX!
My Creations:
- EveAuth
- PHP IGB
- EveXML |
Shinhan
Phoenix Knights
Dark Nebula Galactic Empire
|
Posted - 2007.10.02 06:47:00 -
[5]
I think required skills might be in dgmTypeAttributes or dgmAttributeTypes.
Im not at home so dont have access to DB dump to check.
--
Selling apples, 1 signature each.
ѼѼѼѼѼѼѼ |
Rhispa
Merch Industrial
GoonSwarm
|
Posted - 2007.10.02 08:18:00 -
[6]
You might want to check out the eve-dev wiki for a description of every table/field.
http://wiki.eve-dev.net/Database_Tables_Explained
|
Linkex
Caldari
Unholy Crusader Mining Corp
|
Posted - 2007.10.03 03:19:00 -
[7]
Thanks for the help guys, got it working now.
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |