PlanetCalypsoForum.com :: Entropia Universe Discussion and Resources
Page 3 of 4 FirstFirst 1 2 3 4 LastLast
Results 21 to 30 of 35
  1. #21
    Guardian raxxor's Avatar
    Joined
    Dec 2011
    Gender | Ingame
    Male | Male
    Location
    Sweden
    Avatar
    Mr raxxor Swedir
    Society
    Swedish rangers
    Posts
    272
    Images
    20
    Nice I'm going to tank it down and store it. If someone hasn't created a second Entropedia site by summer and I'm not too busy I'll build a new Entropedia site just for the fun of it and as a bakup for myself if Entropedia goes down(or I'm getting to furious with waiting for a response from entropiawiki.com, hehe ).
    Raxxor

  2. #22
    Elite forgo's Avatar
    Joined
    Apr 2006
    Gender | Ingame
    Male | Male
    Location
    US
    Avatar
    Forgo Forgorth Lundain
    Society
    Guess Who
    Posts
    2,846
    Blog Entries
    1
    Images
    228
    I am fairly new with sql files, and I have it uploaded, but it is a bit too big to break into smaller files without root access I guess.

    Is there a program that can take a base file like the one released and break it into separate database files? This would make it a snap to move around. Thanks


    Quote Originally Posted by Caillend View Post
    This quote is hidden because you are ignoring this member. Show Quote
    Not possible, since you can't read out the loot itself or stats of items/mobs automatically. There was a tool working with Entropedia in the past that could track your team loot for a mob and you could then upload it to entropedia.
    This is possible but the code is a bit tricky. You need to use the same OCR libraries that skill scanner uses, and you could read the loot as it pops up on the overall window (not loot box) with training.
    Records to date: 7454 Caldorite / 40680 Brood of Unruly / 35186 Explosive Projectiles
    I offer crafting on demand with over 1600 unique blueprints, many rares, and many high QR.

    2008 cashout(profit) / 2011-2017 5k-416k total natural skills and still goin.
    My work in progress site for Entropia data and info (backup of entropedia):
    includes my searchable inventory and blueprints if you need items or things crafted!(over 1600 unique bps!)




  3. #23
    Prowler SoReal's Avatar
    Joined
    Oct 2005
    Gender | Ingame
    Male | Male
    Society
    Age of Enlightenment
    Posts
    1,667
    Images
    81
    Quote Originally Posted by forgo View Post
    This quote is hidden because you are ignoring this member. Show Quote
    I am fairly new with sql files, and I have it uploaded, but it is a bit too big to break into smaller files without root access I guess.

    Is there a program that can take a base file like the one released and break it into separate database files? This would make it a snap to move around. Thanks




    This is possible but the code is a bit tricky. You need to use the same OCR libraries that skill scanner uses, and you could read the loot as it pops up on the overall window (not loot box) with training.
    I would stick it on a server and use Navicat to look at the structure and data , you can also move stuff around if you want using this and copy tables as well really easily.

    SoReal's Quad-Wing Equus Warp Services.
    Arkadia Shop : Celeste Island 2

    TOS Normandie Pilot: PM me in game or in forum for flight/skilling details.

  4. #24
    Site Admin
    711's Avatar
    Joined
    Aug 2006
    Gender | Ingame
    Male | Male
    Location
    EntropiaForum.com
    Posts
    4,983
    Blog Entries
    5
    Images
    393
    I have created another archive which contains each Entropedia database table in a separate .sql file for those having trouble with a single large file.

    http://www.entropiaforum.com/downloa...dia_tables.tgz

    Note that these .sql files do not contain database creation commands, so you will need to create the database manually before importing these individual table files.

  5. #25
    Elite forgo's Avatar
    Joined
    Apr 2006
    Gender | Ingame
    Male | Male
    Location
    US
    Avatar
    Forgo Forgorth Lundain
    Society
    Guess Who
    Posts
    2,846
    Blog Entries
    1
    Images
    228
    Quote Originally Posted by 711 View Post
    This quote is hidden because you are ignoring this member. Show Quote
    I have created another archive which contains each Entropedia database table in a separate .sql file for those having trouble with a single large file.

    http://www.entropiaforum.com/downloa...dia_tables.tgz

    Note that these .sql files do not contain database creation commands, so you will need to create the database manually before importing these individual table files.
    This sir is beautiful. Thank you.

    I have created a method in which to update databases from within the game via an Overwolf app. If I ever finish this as a releasable version I will surely post it here.
    Records to date: 7454 Caldorite / 40680 Brood of Unruly / 35186 Explosive Projectiles
    I offer crafting on demand with over 1600 unique blueprints, many rares, and many high QR.

    2008 cashout(profit) / 2011-2017 5k-416k total natural skills and still goin.
    My work in progress site for Entropia data and info (backup of entropedia):
    includes my searchable inventory and blueprints if you need items or things crafted!(over 1600 unique bps!)




  6. #26
    Elite forgo's Avatar
    Joined
    Apr 2006
    Gender | Ingame
    Male | Male
    Location
    US
    Avatar
    Forgo Forgorth Lundain
    Society
    Guess Who
    Posts
    2,846
    Blog Entries
    1
    Images
    228
    Worked great, couple of small questions though.

    Regarding the images database, it is quite massive. Before I break this one apart, what does it contain?


    Does this actually contain the images in the database or just references to images stored on the entropedia site?

    Previously I had manually grabbed each item I didn't have a SS for from encyclopedia and put into a gallery on my site to grab from, but that takes a ton of time.

    Is there a way to grab the image galleries another way, in a bulk fashion? I would much prefer to link images via directories than via mysql. I assume you would rather I not be pulling from your sites images every time someone needed an image from my site.

    Thanks again.
    Records to date: 7454 Caldorite / 40680 Brood of Unruly / 35186 Explosive Projectiles
    I offer crafting on demand with over 1600 unique blueprints, many rares, and many high QR.

    2008 cashout(profit) / 2011-2017 5k-416k total natural skills and still goin.
    My work in progress site for Entropia data and info (backup of entropedia):
    includes my searchable inventory and blueprints if you need items or things crafted!(over 1600 unique bps!)




  7. #27
    Slayer
    Become a premium member today and enjoy enhanced PlanetCalypsoForum features!
    JohnCapital's Avatar
    Joined
    Jul 2006
    Gender | Ingame
    Male | Male
    Location
    Las Vegas
    Avatar
    John Teacher Capital
    Society
    Guess Who
    Posts
    9,457
    Images
    508
    Quote Originally Posted by forgo View Post
    This quote is hidden because you are ignoring this member. Show Quote
    Regarding the images database, it is quite massive. Before I break this one apart, what does it contain?
    The images themselves. But the encoding is eluding me.

  8. #28
    Elite jdegre's Avatar
    Joined
    Dec 2005
    Gender | Ingame
    Male | Male
    Location
    Madrid, Spain
    Avatar
    Jesus jdegre de Gregorio
    Society
    Survival Program
    Posts
    2,937
    Images
    98
    Quote Originally Posted by JohnCapital View Post
    This quote is hidden because you are ignoring this member. Show Quote
    The images themselves. But the encoding is eluding me.
    they are gifs, and their binary stream (in different image sizes) is put into blobs (binary objects) in the database.

    there is a "Type" field in the table set to "image/gif", and also you can see the first bytes of each binary image containing "GIF89a" as specific format version.
    The Chipping Optimizer Tool
    &
    Skill Scanner
    Automatically extract your skills from in-game screenshots





  9. #29
    Slayer
    Become a premium member today and enjoy enhanced PlanetCalypsoForum features!
    JohnCapital's Avatar
    Joined
    Jul 2006
    Gender | Ingame
    Male | Male
    Location
    Las Vegas
    Avatar
    John Teacher Capital
    Society
    Guess Who
    Posts
    9,457
    Images
    508
    Quote Originally Posted by JohnCapital View Post
    This quote is hidden because you are ignoring this member. Show Quote
    The images themselves. But the encoding is eluding me.
    Quote Originally Posted by jdegre View Post
    This quote is hidden because you are ignoring this member. Show Quote
    they are gifs, and their binary stream (in different image sizes) is put into blobs (binary objects) in the database.

    there is a "Type" field in the table set to "image/gif", and also you can see the first bytes of each binary image containing "GIF89a" as specific format version.
    Sorry, that's not what I meant. I completely understood they were images in blob form. Thus, how I answered.

    When opening that table sql in Workbench, it says "Unknown file encoding..." and asks me to choose a character encoding set. I went with Latin1 at first, but had no luck in running the query to install the table. Well, it made the table fine, but chokes on all the insert queries.

    However, after working with it, I believe Latin1 was the correct encoding, but the issue was elsewhere.

  10. #30
    Site Admin
    711's Avatar
    Joined
    Aug 2006
    Gender | Ingame
    Male | Male
    Location
    EntropiaForum.com
    Posts
    4,983
    Blog Entries
    5
    Images
    393
    A new dump of the Entropedia database is now available:

    http://www.entropiaforum.com/downloa...6-11-08.sql.gz (707 MB)

    The latest data dump will be updated in the opening post of this thread.

Page 3 of 4 FirstFirst 1 2 3 4 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Follow Planet Calypso on Twitter  Follow Planet Calypso on Facebook