[help] Starting Items (buffs)

[santimc]

Please help to make so that at creation of the hero, activated items from the item
For example; the Stone of experience and

[Heifnir]

This script should help you.

 Spoiler

INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @D,286,3,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @D,227,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @D,233,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @D,225,1,2592000)

Just modify the SkillID and SkillLevel by the one you need. And put the script after SET @D = IDENT_CURRENT ('Chars') on stored procedure usp_Create_Char_R which can be found in PS_GameData.

[santimc]

Originally Posted by Heifnir

This script should help you.

 Spoiler

INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @D,286,3,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @D,227,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @D,233,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @D,225,1,2592000)

Just modify the SkillID and SkillLevel by the one you need. And put the script after SET @D = IDENT_CURRENT ('Chars') on stored procedure usp_Create_Char_R which can be found in PS_GameData.

Hi! Thank you for your help! I get this error

Msg 102, Level 15, State 1, Procedure usp_Create_Char_R, Line 94
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure usp_Create_Char_R, Line 95
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure usp_Create_Char_R, Line 96
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure usp_Create_Char_R, Line 97
Incorrect syntax near '@CharID'.

I solved the problem! thank you

[golemjose1]

Originally Posted by santimc

Hi! Thank you for your help! I get this error

Msg 102, Level 15, State 1, Procedure usp_Create_Char_R, Line 94
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure usp_Create_Char_R, Line 95
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure usp_Create_Char_R, Line 96
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure usp_Create_Char_R, Line 97
Incorrect syntax near '@CharID'.

I solved the problem! thank you

Hello, how did you solve the problem? Please reply ASAP. Thanks ahead

[[ADM]Sky]

Originally Posted by golemjose1

Hello, how did you solve the problem? Please reply ASAP. Thanks ahead

[golemjose1]

Originally Posted by [ADM]Sky

Hello Sky, I executed your Read_Char_Apply_Skills_R in sql and I am getting Character load error. How can I get rid of this?

Originally Posted by Bowie

in that query, the ( is missing before @ CharID

the arguments for VALUES need to be wrapped in parentheses. one is missing on each line.

Yes thanks Bowie I fix the error now, but I am getting a Character load error.