How to make some skills work with STR player only

[M@hmoud]

How to make some skills work with STR player only and not work with INT player chin

[Ribra]

Originally Posted by M@hmoud

How to make some skills work with STR player only and not work with INT player chin

Add a requirement to learn skill if you have certain amount of STR on the character (just as Snow, means INT chars won't have enough STR to learn it.

(change INT to STR obviously)

[M@hmoud]

Originally Posted by Ribra

Add a requirement to learn skill if you have certain amount of STR on the character (just as Snow, means INT chars won't have enough STR to learn it.

(change INT to STR obviously)

but any player can make acc full str and open skill and change stat acc to int and he can use skill
i need make skill work only with full str and when change stat to int skill stop not work

[Ribra]

Originally Posted by M@hmoud

but any player can make acc full str and open skill and change stat acc to int and he can use skill
i need make skill work only with full str and when change stat to int skill stop not work

you can't open the skill without number of STR required...

[M@hmoud]

Originally Posted by Ribra

you can't open the skill without number of STR required...

yes i know but after open skill i can change stat from str to int and can use skill
i need skill work with player str only and when change stat from str to int skill stop not work
u can give me query if u have

[NorseGodTyr]

Originally Posted by M@hmoud

yes i know but after open skill i can change stat from str to int and can use skill
i need skill work with player str only and when change stat from str to int skill stop not work
u can give me query if u have

SRO_VT_SHARD --> _RefSkill --> ReqCommon_Str (column)
dont forget add same stats in media skilldata_enc

use this query to get the ID from snow shield
select * from SRO_VT_SHARD.._RefSkill where Basic_Code like '%COLD_SHIELD%'

you have to edit by all snow shield skills ReqCommon_Str

[tyr3xFred~]

thx for the info guys

[M@hmoud]

Originally Posted by NorseGodTyr

SRO_VT_SHARD --> _RefSkill --> ReqCommon_Str (column)
dont forget add same stats in media skilldata_enc

use this query to get the ID from snow shield
select * from SRO_VT_SHARD.._RefSkill where Basic_Code like '%COLD_SHIELD%'

you have to edit by all snow shield skills ReqCommon_Str

i make it but player change state str to int after open skill and can use this skill
i need skill stop when change state

[NorseGodTyr]

Originally Posted by M@hmoud

i make it but player change state str to int after open skill and can use this skill
i need skill stop when change state

write a query that remove the snow shield after reset stats point

[M@hmoud]

Originally Posted by NorseGodTyr

write a query that remove the snow shield after reset stats point

u can give me this query

[NorseGodTyr]

Originally Posted by M@hmoud

u can give me this query

next time write alone
add this in your reset scroll procedure

DELETE FROM [SRO_VT_SHARD].[dbo].[_CharSkill] Where SkillID between '8092' And '8122' and CharID=@CharID

this query delete the snow shield skill by skill id and char id

[M@hmoud]

Originally Posted by NorseGodTyr

next time write alone
add this in your reset scroll procedure

DELETE FROM [SRO_VT_SHARD].[dbo].[_CharSkill] Where SkillID between '8092' And '8122' and CharID=@CharID

this query delete the snow shield skill by skill id and char id

thx for help
u have query delete skill snow from old acc chin

[VeRo!]

Originally Posted by M@hmoud

thx for help
u have query delete skill snow from old acc chin

why do you say 'u have query' like we buy it from microsoft for example?
We write it ALONE, you also have to write it ALONE!

[JohnDornel^]

DELETE FROM SRO_VT_SHARD_INIT.dbo._CharSkill WHERE (SkillID IN (SELECT ID FROM SRO_VT_SHARD_INIT.dbo._RefSkill
		where (ReqCommon_Int > 0 or ReqCommon_Str > 0))) AND CharID = [MENTION=395373]Chari[/MENTION]D

Add this after the procedure that takes care of stats reset. It will make sure it deletes any kind of skills that have int or str requirement more than 0 on every stat reset attempt.

To use it on "old characters" as you say :

DECLARE [MENTION=3898309]charname[/MENTION]16 VARCHAR(100) = 'Charname'
DECLARE [MENTION=395373]Chari[/MENTION]D INT = (SELECT CharID FROM SRO_VT_SHARD_INIT.dbo._Char WHERE CharName16 = [MENTION=3898309]charname[/MENTION]16)
DELETE FROM SRO_VT_SHARD_INIT.dbo._CharSkill WHERE (SkillID IN (SELECT ID FROM SRO_VT_SHARD_INIT.dbo._RefSkill
		where (ReqCommon_Int > 0 or ReqCommon_Str > 0))) AND CharID = [MENTION=395373]Chari[/MENTION]D

[M@hmoud]

Originally Posted by JohnDornel^

DELETE FROM SRO_VT_SHARD_INIT.dbo._CharSkill WHERE (SkillID IN (SELECT ID FROM SRO_VT_SHARD_INIT.dbo._RefSkill
		where (ReqCommon_Int > 0 or ReqCommon_Str > 0))) AND CharID = [MENTION=395373]Chari[/MENTION]D

Add this after the procedure that takes care of stats reset. It will make sure it deletes any kind of skills that have int or str requirement more than 0 on every stat reset attempt.

To use it on "old characters" as you say :

DECLARE [MENTION=3898309]charname[/MENTION]16 VARCHAR(100) = 'Charname'
DECLARE [MENTION=395373]Chari[/MENTION]D INT = (SELECT CharID FROM SRO_VT_SHARD_INIT.dbo._Char WHERE CharName16 = [MENTION=3898309]charname[/MENTION]16)
DELETE FROM SRO_VT_SHARD_INIT.dbo._CharSkill WHERE (SkillID IN (SELECT ID FROM SRO_VT_SHARD_INIT.dbo._RefSkill
		where (ReqCommon_Int > 0 or ReqCommon_Str > 0))) AND CharID = [MENTION=395373]Chari[/MENTION]D

thx for help