Vsro Action Overlap

[ILowe]

hello guys!

How is Action Overlap calculated? For example, when I add a new skill, it may conflict with different skills. How should I calculate it so it doesn't work with a skill?

[Athena']

Originally Posted by ILowe

hello guys!

How is Action Overlap calculated? For example, when I add a new skill, it may conflict with different skills. How should I calculate it so it doesn't work with a skill?

Ok, let me know if i got that right. You're basically trying to avoid a skill while a diffrent skill is in use?

Like.. If bless spell is in use, you want to disable usage of pain quote, for example? Did i get it?

[ILowe]

I want to calculate a new overlaps.
If I give a random overlap to a skill or item usage, another skill is affected.

[hacinuri]

Hello,

 Spoiler

WITH Temp AS (
SELECT
Basic_Code as SkillName,
Action_Overlap as OverlapValue,
SUBSTRING(CAST (Action_Overlap AS VARBINARY), 1, 1) AS byte1,
SUBSTRING(CAST (Action_Overlap AS VARBINARY), 2, 1) AS byte2,
SUBSTRING(CAST (Action_Overlap AS VARBINARY), 3, 1) AS byte3,
SUBSTRING(CAST (Action_Overlap AS VARBINARY), 4, 1) AS byte4
FROM
SRO_VT_SHARD.._RefSkill WHERE Action_Overlap <> 0)
SELECT * FROM Temp ORDER BY OverlapValue ASC

you can use this query for calculate overlap value. You have to make unique byte value if you dont want to affect other skills

[Kabloz™]

Originally Posted by ILowe

I want to calculate a new overlaps.
If I give a random overlap to a skill or item usage, another skill is affected.

simple you can use it

 Spoiler

DECLARE @ INT = 1795162206;
DECLARE @ INT = 90048778;
DECLARE @ INT = @ & 0xFFFF0000) | @ & 0x0000FFFF);
SELECT @ AS Int1, @ AS Int2, @ AS MergedInt;
UPDATE dbo._RefSkill SET Action_Overlap = (CAST(1795162206 AS INT) & 0xFFFF0000)|(CAST(90048778 AS INT) & 0x0000FFFF) WHERE Basic_Code LIKE '%amalrun%';

to see if there a same byte of not

SELECT 1795162206, SUBSTRING(CAST (1795162206 AS VARBINARY), 1, 1) AS byte1,
SUBSTRING(CAST (1795162206 AS VARBINARY), 2, 1) AS byte2,
SUBSTRING(CAST (1795162206 AS VARBINARY), 3, 1) AS byte3,
SUBSTRING(CAST (1795162206 AS VARBINARY),*4,*1)*AS*byte4

SELECT 90048778, SUBSTRING(CAST (90048778 AS VARBINARY), 1, 1) AS byte1,
SUBSTRING(CAST (90048778 AS VARBINARY), 2, 1) AS byte2,
SUBSTRING(CAST (90048778 AS VARBINARY), 3, 1) AS byte3,
SUBSTRING(CAST (90048778 AS VARBINARY),*4,*1)*AS*byte4