Show set bonuses about iagd HOT 9 CLOSED

I think, there is no need to show all set bonuses. Show set bonuses will lead to readability degradation from screen. But you can specify the membership of a particular set, somethink like this:

If user click a set name, IA show all set item which he has.
It will be very convenient!

from iagd.

Good suggestion.

However, I have no immediate plans on doing the set bonuses.
Time is ever an issue, though hopefully someone else will pick this one up.

from iagd.

For whomever ends up implementing this, here's some queries to help identify set items:

-- Easy query to find all sets:
SELECT *, (SELECT Name FROM DatabaseItem_v2 WHERE id_databaseitem = S.id_databaseitem) as SetName from DatabaseItemStat_v2 S where Stat = 'itemSetName' ORDER BY textvalue


-- Find name for a given set:
SELECT T.name FROM DatabaseItemStat_v2 S, ItemTag T
WHERE id_databaseitem IN (
	SELECT id_databaseitem FROM DatabaseItem_v2 WHERE baserecord = 'records/items/lootsets/itemset_c001.dbr'
)
AND S.stat = 'setName'
AND T.tag = S.TextValue


-- Combining these two we get:

SELECT *, 
(
	SELECT T.name FROM DatabaseItemStat_v2 ST, ItemTag T WHERE id_databaseitem IN (SELECT id_databaseitem FROM DatabaseItem_v2 db WHERE db.baserecord = S.TextValue)
	AND ST.stat = 'setName' AND T.tag = ST.TextValue
) as SetName, 
(SELECT Name FROM DatabaseItem_v2 WHERE id_databaseitem = S.id_databaseitem) as ItemName 

from DatabaseItemStat_v2 S 
where Stat = 'itemSetName' 
AND SetName IS NOT NULL
ORDER BY textvalue

-- Discover all the stats of a specific set (in this case set 7355112)
SELECT * FROM DatabaseItemStat_v2 WHERE id_databaseitem = (
	SELECT id_databaseitem FROM DatabaseItem_v2 WHERE baserecord = (
		SELECT TextValue FROM DatabaseItemStat_v2 S WHERE id_databaseitem = 7355112 AND stat = 'setMembers'
	)
)
ORDER BY TextValue

A set is much like an item, and IA should be able to render a set roughly as well as it renders an item. A set has triggers, skills etc just like items do.

from iagd.

The most efficient thing would probably be to pre-compute the sets and set them on initial load, and then simply check if each rendered item is in a set.

If in a set: List the set name, and make it clickable to show other items in the set (and how many of each)

from iagd.

Thinking something ala:

• Sets are exposed as JSON to the web ui
• When rendering an item, ask some service (in JS) if it's part of a set
• Render which set its in, clickable
• OnClick => Poll C# for all items owned in this set
• Render a view of the set, its bonuses and which items are owned / missing.

Polling on click will help with performance (lazy load), and should be a very simple query when its on a specific set basis.

from iagd.

Are there news on this issue? It would be nice to have something like that inside IA

from iagd.

No more progress just yet.
I am still in the middle of moving cross-continents.

I do intend for there to be progress on this task, though it will come after certain bugfixes and QoL fixes.

from iagd.

Are there news on this issue? It would be nice to have something like that inside IA

Partially implemented a few patches ago.

from iagd.

Now longer relevant after the introduction of real item stats

from iagd.