[Help] contour and effects E4.2

[killuas]

second - problem with paintings, contour and effects
E3.5 was easy, there was only one table: ti_ItemMixingInfo; and now there are two of them in E4.2: ti_ItemMixingInfo and ti_ItemMixingElement.
Ive tried to make it like on 3.5 but with tables from 4.2 as a result then im trying to change gear painting i achieve a definitely new gear
Can you at least give me an example how it should be made on E4.2 ?

[MentaL]

[Future]

It's a rare effort of masang to improve data relationship database wise.

Basically ti_ItemMixingInfo got rid of all source items and only contains the target item together with all information on the mixing / combining process now. While ti_ItemMixingElement contains the source items. Connected via the "UniqueID", they are forming a one-to-many relationship. Looking at it for a while, it shouldn't be too hard to grasp at.

So you get the target item, then the UniqueID of the combination and can then relate all source items to it. Optimally you'd have an editor for stuff like that and not fiddle with DB data directly, however you can also write a View to display these in the "old fashion".

Joining the two tables on the Id might give you a better visualization of the combinations:

SELECT info.UniqueID, info.TargetItemNum, info.MixingProbability, info.MixingCost, info.Visible, elem.SourceItemNum, elem.SourceItemCount
FROM ti_ItemMixingInfo info
LEFT JOIN ti_ItemMixingElement elem
ON info.UniqueID = elem.UniqueID
ORDER BY info.UniqueID ASC

Should be easy from there

[killuas]

It's a rare effort of masang to improve data relationship database wise.

Basically ti_ItemMixingInfo got rid of all source items and only contains the target item together with all information on the mixing / combining process now. While ti_ItemMixingElement contains the source items. Connected via the "UniqueID", they are forming a one-to-many relationship. Looking at it for a while, it shouldn't be too hard to grasp at.

So you get the target item, then the UniqueID of the combination and can then relate all source items to it. Optimally you'd have an editor for stuff like that and not fiddle with DB data directly, however you can also write a View to display these in the "old fashion".

Joining the two tables on the Id might give you a better visualization of the combinations:

SELECT info.UniqueID, info.TargetItemNum, info.MixingProbability, info.MixingCost, info.Visible, elem.SourceItemNum, elem.SourceItemCount
FROM ti_ItemMixingInfo info
LEFT JOIN ti_ItemMixingElement elem
ON info.UniqueID = elem.UniqueID
ORDER BY info.UniqueID ASC

Should be easy from there

I understand that, but can you give an example how to change gear view without creating a new gear with other characteristics
I`m doing for example: like upgrade lvl of shop gear, but for changing view
9083 8189100 10000 17200 1 7022770 1
9083 8189100 10000 17200 1 8189000 1
May be problem is thet ti_ItemInfo kind = 16 gear 19=modul for view change LinkItem=8940200 on: [Bomber Painting] Gold ?

[Future]

can you give an example how to change gear view without creating a new gear with other characteristics
I`m doing for example: like upgrade lvl of shop gear, but for changing view
9083 8189100 10000 17200 1 7022770 1
9083 8189100 10000 17200 1 8189000 1
May be problem is thet ti_ItemInfo kind = 16 gear 19=modul for view change LinkItem=8940200 on: [Bomber Painting] Gold ?

Glad that helped. I'm not really sure what you mean by "give me an example how to change gear view without creating a new gear with other characteristics". The result set looks good, I'm getting the same. And different kinds of source items are not an issue. It's not unusual that armor upgrades are card or ingredient types.

What are you ultimately trying to do?

[killuas]

Glad that helped. I'm not really sure what you mean by "give me an example how to change gear view without creating a new gear with other characteristics". The result set looks good, I'm getting the same. And different kinds of source items are not an issue. It's not unusual that armor upgrades are card or ingredient types.

What are you ultimately trying to do?

I`m trying to change gear view to white paint or gold paint

[killuas]

Glad that helped. I'm not really sure what you mean by "give me an example how to change gear view without creating a new gear with other characteristics". The result set looks good, I'm getting the same. And different kinds of source items are not an issue. It's not unusual that armor upgrades are card or ingredient types.

What are you ultimately trying to do?

Paintings for gears and weapons from 3.5 doesn`t work on 4.2
All of this do work on 4.2:
7038350 19 \e[Veil Contour] GNGWC 2012 Regional\e
7038360 19 \e[Defender Contour] GNGWC 2012 Regional
7038370 19 \e[Binder Contour] GNGWC 2012 Regional
7038380 19 \e[Guarder Contour] GNGWC 2012 Regional
7038390 19 \a[Veil Contour] GNGWC 2012 Regional\a
7038400 19 \a[Defender Contour] GNGWC 2012 Regional
7038410 19 \a[Binder Contour] GNGWC 2012 Regional
7038420 19 \a[Guarder Contour] GNGWC 2012 Regional
7038430 19 \y[Veil Contour] GNGWC 2012 Regional\y
7038440 19 \y[Defender Contour] GNGWC 2012 Regional
7038450 19 \y[Binder Contour] GNGWC 2012 Regional
7038460 19 \y[Guarder Contour] GNGWC 2012 Regional
7038470 19 \e[Veil Contour] GNGWC 2012 Final\e
7038480 19 \e[Defender Contour] GNGWC 2012 Final\e
7038490 19 \e[Binder Contour] GNGWC 2012 Final\e
7038500 19 \e[Guarder Contour] GNGWC 2012 Final\e
7038510 19 \a[Veil Contour] GNGWC 2012 Final\a
7038530 19 \a[Defender Contour] GNGWC 2012 Final\a
7038540 19 \a[Binder Contour] GNGWC 2012 Final\a
7038550 19 \a[Guarder Contour] GNGWC 2012 Final\a
7038560 19 \y[Veil Contour] GNGWC 2012 Final\y
7038570 19 \y[Defender Contour] GNGWC 2012 Final\y
7038580 19 \y[Binder Contour] GNGWC 2012 Final\y
7038590 19 \y[Guarder Contour] GNGWC 2012 Final\y
7038620 19 \l[Adv. Weapon Effect] GNGWC 2012\l
7038630 19 \e[Adv. Weapon Effect] GNGWC 2012\e
7038640 19 \a[Gun Contour] GNGWC 2012\a
7038650 19 \e[Gun Contour] GNGWC 2012\e
7040050 19 \a[Smash Contour] GNGWC 2012\a
7040060 19 \e[Smash Contour] GNGWC 2012\e
I cant understand why paintings and effects from 3.5 doesnt work on 4.2
What should i do to make them work on 4.2?