How to make some skills work with STR player only

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

Quote:

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.
[Only registered and activated users can see links. Click Here To Register...]
(change INT to STR obviously)

Quote:

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. [Only registered and activated users can see links. Click Here To Register...] (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

Quote:

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...

Quote:

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

Quote:

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

thx for the info guys

Quote:

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

Quote:

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

Quote:

Originally Posted by NorseGodTyr write a query that remove the snow shield after reset stats point

u can give me this query

Quote:

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

Quote:

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

Quote:

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!

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 :

Quote:

Originally Posted by JohnDornel^ Code: 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 : Code: 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