Author Topic: Excel file for items  (Read 1310 times)

0 Members and 1 Guest are viewing this topic.

Offline epinter

  • Member
  • *
  • Posts: 23
  • Country: br
  • Karma: +3/-0
  • Gender: Male
    • View Profile
    • Awards
Re: Excel file for items
« Reply #30 on: 02 April 2018, 14:18:24 »
No, that's not seen by the Collector - at least not yet.  Mind you is that a quest item?

Spoiler for Hiden:
Yes, from the secret quest

Offline MedeaFleecestealer

  • Administrator
  • Full Member
  • *
  • Posts: 835
  • Country: ch
  • Karma: +12/-0
  • Gender: Female
    • View Profile
    • Awards
  • Time Zone: +1
Re: Excel file for items
« Reply #31 on: 02 April 2018, 14:23:46 »
Wouldn't show in the Collector then as it's a quest item.  None of those items do.

Offline Bobinho11

  • Hero Member
  • *
  • Topic Author
  • Posts: 86
  • Country: lu
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Awards
  • Time Zone: ?
Re: Excel file for items
« Reply #32 on: 02 April 2018, 16:02:38 »
I see, so its going out of my list..

Epinter, what are those 6 items i mentioned earlier? Any idea?
Lvl 65 Bone Charmer, lvl 43 Conqueror

Offline MedeaFleecestealer

  • Administrator
  • Full Member
  • *
  • Posts: 835
  • Country: ch
  • Karma: +12/-0
  • Gender: Female
    • View Profile
    • Awards
  • Time Zone: +1
Re: Excel file for items
« Reply #33 on: 02 April 2018, 16:17:36 »
Special sets that can only be gained by using Unlock Codes.  They used to be yellow items, not sure what they are in AE.  They're not really much good actually, but okay for adding to the collection.

274267 Shinobi Shozoku
925678 Garb of the Great Merchant
437626 Garb of Germania
373624 Garb of Gaul
6788 Li'l Lued

Just start playing one of your toons, hit escape to get to Unlock Content, click on it, type in a code and click okay and the set will fall at your feet. Li'l Lued is an Artifact.

Offline Bobinho11

  • Hero Member
  • *
  • Topic Author
  • Posts: 86
  • Country: lu
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Awards
  • Time Zone: ?
Re: Excel file for items
« Reply #34 on: 02 April 2018, 16:24:59 »
I meant these 6 from epinters list:

PI Amulet
PI Axe
PI Greaves
PI Helmet
PI Torso
tagPANTS

I know about the sets you mentioned, medea, but they are not availabe on consoles :/
Lvl 65 Bone Charmer, lvl 43 Conqueror

Offline MedeaFleecestealer

  • Administrator
  • Full Member
  • *
  • Posts: 835
  • Country: ch
  • Karma: +12/-0
  • Gender: Female
    • View Profile
    • Awards
  • Time Zone: +1
Re: Excel file for items
« Reply #35 on: 02 April 2018, 16:47:57 »
Never come across those, so either new for console or something else.

Offline epinter

  • Member
  • *
  • Posts: 23
  • Country: br
  • Karma: +3/-0
  • Gender: Male
    • View Profile
    • Awards
Re: Excel file for items
« Reply #36 on: 02 April 2018, 17:21:23 »
I meant these 6 from epinters list:

PI Amulet
PI Axe
PI Greaves
PI Helmet
PI Torso
tagPANTS

I know about the sets you mentioned, medea, but they are not availabe on consoles :/

The tq database has some items without name that I already ignored. Just found that the "PI *" are items for tutorial. tagPANTS needs to be removed too, looks like another not used item inside the database.

Offline epinter

  • Member
  • *
  • Posts: 23
  • Country: br
  • Karma: +3/-0
  • Gender: Male
    • View Profile
    • Awards
Re: Excel file for items
« Reply #37 on: 02 April 2018, 19:10:59 »
I've made a cleanup in the list, removed:

-Tutorial items
-Dev/test items
-Duplicated mi items (base game/ragnarok)
-Temporary records causing duplicated items

Now the list has 2264 items.

Offline Bobinho11

  • Hero Member
  • *
  • Topic Author
  • Posts: 86
  • Country: lu
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Awards
  • Time Zone: ?
Re: Excel file for items
« Reply #38 on: 02 April 2018, 19:22:54 »
Great, thanks a lot! And i am sorry for pestering both of you with all these questions :)))

Are the quest items still included?

Lvl 65 Bone Charmer, lvl 43 Conqueror

Offline epinter

  • Member
  • *
  • Posts: 23
  • Country: br
  • Karma: +3/-0
  • Gender: Male
    • View Profile
    • Awards
Re: Excel file for items
« Reply #39 on: 02 April 2018, 19:29:18 »
Great, thanks a lot! And i am sorry for pestering both of you with all these questions :)))

Are the quest items still included?

I removed all items with type QuestItem and classification Quest. The only quest related item that is present in the list, is a parchment that is not exactly a quest item...

Offline Bobinho11

  • Hero Member
  • *
  • Topic Author
  • Posts: 86
  • Country: lu
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Awards
  • Time Zone: ?
Re: Excel file for items
« Reply #40 on: 02 April 2018, 19:31:19 »
awesome, i will use this a basis for tracking my collection, thanks a lot! :)
Lvl 65 Bone Charmer, lvl 43 Conqueror

Offline epinter

  • Member
  • *
  • Posts: 23
  • Country: br
  • Karma: +3/-0
  • Gender: Male
    • View Profile
    • Awards
Re: Excel file for items
« Reply #41 on: 02 April 2018, 23:40:21 »
awesome, i will use this a basis for tracking my collection, thanks a lot! :)

Sorry if you started to use it, but I had to update the list again :D

I removed some duplicated Monster Infrequents and Legendary, 1 test formula, 1 test artifact, and 1 test parchment.

Also added some monster infrequents that was missing (some of gigantes items).

19 parchments
93 charms
123 relics
84 formulas
84 artifacts
735 monster infrequents
337 items inside sets (doesn't include 13 items from yellow sets unlockable using code)
792 legendary + epic (excluding items from sets)
Total of 2267 items.

Offline Bobinho11

  • Hero Member
  • *
  • Topic Author
  • Posts: 86
  • Country: lu
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Awards
  • Time Zone: ?
Re: Excel file for items
« Reply #42 on: 02 April 2018, 23:46:33 »
No problem, thanks for doing this and keep me updated please if you make any more changes 😀
Lvl 65 Bone Charmer, lvl 43 Conqueror

Offline AlcyonV

  • Member
  • *
  • Posts: 31
  • Country: fr
  • Karma: +0/-0
    • View Profile
    • Awards
Re: Excel file for items
« Reply #43 on: 03 April 2018, 03:26:29 »
19 parchments
93 charms
123 relics
84 formulas
84 artifacts
735 monster infrequents
337 items inside sets (doesn't include 13 items from yellow sets unlockable using code)
792 legendary + epic (excluding items from sets)
Total of 2267 items.

TQCollector counts 336 set items (without the 13 others) and 791 uniques. I don't know where the difference lies.

Offline epinter

  • Member
  • *
  • Posts: 23
  • Country: br
  • Karma: +3/-0
  • Gender: Male
    • View Profile
    • Awards
Re: Excel file for items
« Reply #44 on: 03 April 2018, 04:37:44 »
In set items, TQCollector is missing "Blackbeard's Hook" (Buccaneer's Garb).

In the uniques, TQCollector is missing "The Sword in the Stone" (Legendary).

These items doesn't drop anywhere.

EDIT: Also, TQCollector has "Outrider's Skullcap" and "Outrider's Tunic" duplicated, in "Centaur" and "Centaurs (Corinth)"
« Last Edit: 03 April 2018, 04:42:49 by epinter »

Tags: