shaiya auto apply skills

[Admin]Slice · 05/25/2016, 07:53

Okay, so the auto apply skills only apply for 1 character, i want them for all characters. any idea why this only sets for 1 character?
here are the scripts.

SnickQ · 05/26/2016, 15:10

Add this to usp_Try_GameLogin_Taiwan

This should work even as a player will be inactive for more than 30 days

Declare @

int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='0' and del ='0')
Declare @

2 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='1' and del ='0')
Declare @

3 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='2' and del ='0')
Declare @

4 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='3' and del ='0')
Declare @

5 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='4' and del ='0')

update PS_GameData.dbo.chars
Set LeaveDate=GETDATE()
where CharID in @

@

2 @

3 @

4 @

5)

--- @

---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

--- @

2 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

2,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

2,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

2,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

2,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

2

--- @

3 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

3,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

3,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

3,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

3,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

3

--- @

4 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

4,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

4,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

4,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

4,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

4

--- @

5 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

5,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

5,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

5,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @

5,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

5

[Admin]Slice · 05/26/2016, 21:16

Quote:

Originally Posted by SnickQ

Add this to usp_Try_GameLogin_Taiwan

This should work even as a player will be inactive for more than 30 days

Declare @ int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='0' and del ='0')
Declare @2 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='1' and del ='0')
Declare @3 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='2' and del ='0')
Declare @4 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='3' and del ='0')
Declare @5 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='4' and del ='0')

update PS_GameData.dbo.chars
Set LeaveDate=GETDATE()
where CharID in @ @2 @3 @4 @5)

--- @ ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

--- @2 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @2,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @2,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @2,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @2,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @2

--- @3 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @3,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @3,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @3,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @3,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @3

--- @4 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @4,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @4,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @4,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @4,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @4

--- @5 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @5,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @5,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @5,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @5,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @5

okay i'll give it a try thank you.

Quote:

Originally Posted by SnickQ

Add this to usp_Try_GameLogin_Taiwan

This should work even as a player will be inactive for more than 30 days

Declare @ int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='0' and del ='0')
Declare @2 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='1' and del ='0')
Declare @3 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='2' and del ='0')
Declare @4 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='3' and del ='0')
Declare @5 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='4' and del ='0')

update PS_GameData.dbo.chars
Set LeaveDate=GETDATE()
where CharID in @ @2 @3 @4 @5)

--- @ ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @

--- @2 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @2,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @2,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @2,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @2,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @2

--- @3 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @3,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @3,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @3,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @3,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @3

--- @4 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @4,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @4,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @4,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @4,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @4

--- @5 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @5,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @5,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @5,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @5,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @5

Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 116
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 120
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 121
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 122
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 124
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 125
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 126
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 128
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 129
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 130
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 132
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 133
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 134
Incorrect syntax near '@toon1'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 138
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 139
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 140
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 142
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 143
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 144
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 146
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 147
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 148
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 150
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 151
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 152
Incorrect syntax near '@TooN2'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 156
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 157
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 158
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 160
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 161
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 162
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 164
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 165
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 166
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 168
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 169
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 170
Incorrect syntax near '@TooN3'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 174
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 175
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 176
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 178
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 179
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 180
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 182
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 183
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 184
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 186
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 187
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 188
Incorrect syntax near '@TooN4'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 192
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 193
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 194
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 196
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 197
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 198
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 200
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 201
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 202
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 204
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 205
Incorrect syntax near '@TooN5'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 206
Incorrect syntax near '@TooN5'.

SnickQ · 05/26/2016, 22:20

The problem is, because forum change my script O_o

Try this

hronolight · 05/26/2016, 22:42

Wow wow. Why so long script?

Try this way.

Spoiler

[Admin]Slice · 05/26/2016, 23:18

Quote:

Originally Posted by hronolight

Wow wow. Why so long script?

Try this way.

Spoiler

USE [PS_Gamedata]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author: VicSind
-- =============================================

ALTER Proc [dbo].[usp_Read_Char_ApplySkills_R]

@D int

AS

SET NOCOUNT ON

SELECT SkillID,SkillLevel,LeftResetTime FROM CharApplySkills WHERE CharID @D AND SkillID not in (225,227,233,234,286)
UNION ALL SELECT 286 AS [SkillID], 3 AS SkillLevel, 2592800 AS LeftResetTime
UNION ALL SELECT 225 AS [SkillID], 1 AS SkillLevel, 2592800 AS LeftResetTime
UNION ALL SELECT 227 AS [SkillID], 1 AS SkillLevel, 2592800 AS LeftResetTime
UNION ALL SELECT 234 AS [SkillID], 1 AS SkillLevel, 2592800 AS LeftResetTime
UNION ALL SELECT 233 AS [SkillID], 1 AS SkillLevel, 2592800 AS LeftResetTime

SET NOCOUNT OFF

will try when i get a chance. thank you.

thank you guys for the help. problem solved.

Quote:

Originally Posted by hronolight

Wow wow. Why so long script?

Try this way.

Spoiler

USE [PS_Gamedata]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author: VicSind
-- =============================================

ALTER Proc [dbo].[usp_Read_Char_ApplySkills_R]

@D int

AS

SET NOCOUNT ON

SELECT SkillID,SkillLevel,LeftResetTime FROM CharApplySkills WHERE CharID @D AND SkillID not in (225,227,233,234,286)
UNION ALL SELECT 286 AS [SkillID], 3 AS SkillLevel, 2592800 AS LeftResetTime
UNION ALL SELECT 225 AS [SkillID], 1 AS SkillLevel, 2592800 AS LeftResetTime
UNION ALL SELECT 227 AS [SkillID], 1 AS SkillLevel, 2592800 AS LeftResetTime
UNION ALL SELECT 234 AS [SkillID], 1 AS SkillLevel, 2592800 AS LeftResetTime
UNION ALL SELECT 233 AS [SkillID], 1 AS SkillLevel, 2592800 AS LeftResetTime

SET NOCOUNT OFF

sorry for my nubness lol, but :
2016-05-26 21:49:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_CharApplySkills'. Cannot insert duplicate key in object 'dbo.CharApplySkills'. The duplicate key value is (35, 236, 1)., SQL STATE: 23000, NATIVE ERROR: 2627 (0xA43)

2016-05-26 21:49:02 ::SaveCharacter 35 [Dev]Aviate ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(35,236,1,2592800)}

hronolight · 05/27/2016, 23:47

Quote:

Originally Posted by [Admin]Slice

sorry for my nubness lol, but :
2016-05-26 21:49:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_CharApplySkills'. Cannot insert duplicate key in object 'dbo.CharApplySkills'. The duplicate key value is (35, 236, 1)., SQL STATE: 23000, NATIVE ERROR: 2627 (0xA43)

2016-05-26 21:49:02 ::SaveCharacter 35 [Dev]Aviate ret=-1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(35,236,1,2592800)}

If you add a new skill, then add it to the block "not in (your skillID)"

Spoiler