[help] Starting Items (buffs)

07/20/2017 00:19 santimc#1

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

07/20/2017 01:12 Heifnir#2

This script should help you.

Spoiler

Just modify the SkillID and SkillLevel by the one you need. And put the script after SET @[Only registered and activated users can see links. Click Here To Register...]D = IDENT_CURRENT ('Chars') on stored procedure usp_Create_Char_R which can be found in PS_GameData.

07/20/2017 08:35 santimc#3

Quote:

Originally Posted by Heifnir

This script should help you.

Spoiler

INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]D,286,3,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]D,227,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]D,233,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]D,225,1,2592000)

Just modify the SkillID and SkillLevel by the one you need. And put the script after SET @[Only registered and activated users can see links. Click Here To Register...]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

11/08/2019 12:56 golemjose1#4

Quote:

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

11/08/2019 14:26 [ADM]Sky#5

Quote:

Originally Posted by golemjose1

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

:awesome:

11/09/2019 04:08 golemjose1#6

Quote:

Originally Posted by [ADM]Sky

:awesome:

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?

Quote:

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.