shaiya auto apply skills

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

Add this to usp_Try_GameLogin_Taiwan

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

Declare @[Only registered and activated users can see links. Click Here To Register...] int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='0' and del ='0')
Declare @[Only registered and activated users can see links. Click Here To Register...]2 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='1' and del ='0')
Declare @[Only registered and activated users can see links. Click Here To Register...]3 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='2' and del ='0')
Declare @[Only registered and activated users can see links. Click Here To Register...]4 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='3' and del ='0')
Declare @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]2 @[Only registered and activated users can see links. Click Here To Register...]3 @[Only registered and activated users can see links. Click Here To Register...]4 @[Only registered and activated users can see links. Click Here To Register...]5)

--- @[Only registered and activated users can see links. Click Here To Register...] ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...])
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...])
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...])
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...])
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]

--- @[Only registered and activated users can see links. Click Here To Register...]2 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2

--- @[Only registered and activated users can see links. Click Here To Register...]3 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3

--- @[Only registered and activated users can see links. Click Here To Register...]4 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4

--- @[Only registered and activated users can see links. Click Here To Register...]5 ---

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,286, 3, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,225, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,227, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5

IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5)
INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,233, 1, 2592000)
ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5

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 @[Only registered and activated users can see links. Click Here To Register...] int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='0' and del ='0') Declare @[Only registered and activated users can see links. Click Here To Register...]2 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='1' and del ='0') Declare @[Only registered and activated users can see links. Click Here To Register...]3 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='2' and del ='0') Declare @[Only registered and activated users can see links. Click Here To Register...]4 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='3' and del ='0') Declare @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]2 @[Only registered and activated users can see links. Click Here To Register...]3 @[Only registered and activated users can see links. Click Here To Register...]4 @[Only registered and activated users can see links. Click Here To Register...]5) --- @[Only registered and activated users can see links. Click Here To Register...] --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...] IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...] IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...] IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...] --- @[Only registered and activated users can see links. Click Here To Register...]2 --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]2) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]2 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2 --- @[Only registered and activated users can see links. Click Here To Register...]3 --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]3) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]3 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3 --- @[Only registered and activated users can see links. Click Here To Register...]4 --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]4) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]4 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4 --- @[Only registered and activated users can see links. Click Here To Register...]5 --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]5) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]5 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...] int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='0' and del ='0') Declare @[Only registered and activated users can see links. Click Here To Register...]2 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='1' and del ='0') Declare @[Only registered and activated users can see links. Click Here To Register...]3 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='2' and del ='0') Declare @[Only registered and activated users can see links. Click Here To Register...]4 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID =@UserUID and slot ='3' and del ='0') Declare @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]2 @[Only registered and activated users can see links. Click Here To Register...]3 @[Only registered and activated users can see links. Click Here To Register...]4 @[Only registered and activated users can see links. Click Here To Register...]5) --- @[Only registered and activated users can see links. Click Here To Register...] --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...] IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...] IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...] IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...],233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...] --- @[Only registered and activated users can see links. Click Here To Register...]2 --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]2) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]2 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]2,233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]2 --- @[Only registered and activated users can see links. Click Here To Register...]3 --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]3) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]3 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]3,233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]3 --- @[Only registered and activated users can see links. Click Here To Register...]4 --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]4) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]4 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]4,233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]4 --- @[Only registered and activated users can see links. Click Here To Register...]5 --- IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]5) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,286, 3, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 286 AND SkillLevel = 3 and CharID @[Only registered and activated users can see links. Click Here To Register...]5 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,225, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 225 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,227, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 227 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5 IF NOT EXISTS (SELECT * FROM PS_GameData.dbo.CharApplySkills WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]5) INSERT PS_GameData.dbo.CharApplySkills (CharID,SkillID, SkillLevel, LeftResetTime) VALUES @[Only registered and activated users can see links. Click Here To Register...]5,233, 1, 2592000) ELSE UPDATE PS_GameData.dbo.CharApplySkills SET LeftResetTime = 2592000 WHERE SkillID = 233 AND SkillLevel = 1 and CharID @[Only registered and activated users can see links. Click Here To Register...]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'.

The problem is, because forum change my script O_o

Try this

Wow wow. Why so long script?

Try this way.

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] @[Only registered and activated users can see links. Click Here To Register...]D int AS SET NOCOUNT ON SELECT SkillID,SkillLevel,LeftResetTime FROM CharApplySkills WHERE CharID @[Only registered and activated users can see links. Click Here To Register...]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] @[Only registered and activated users can see links. Click Here To Register...]D int AS SET NOCOUNT ON SELECT SkillID,SkillLevel,LeftResetTime FROM CharApplySkills WHERE CharID @[Only registered and activated users can see links. Click Here To Register...]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)}

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)"