بص حضرتك خلاصه الكلام
اول مشكله سببها إن فيه ID مشابه او skills name مشابه
تاني مشكله هتعمل حاجه صغيره
هتروح عند SRO_VT_SHARD
_AddNewChar
Search
INSERT _CharNameList VALUES(@CharName, @NewCharID)
and put it down
---------------------------------------------------------------------------------
---- Add Mastery For Gm'S
-----------------------------------------------------------------------------
DECLARE @sec_primary TINYINT,
@sec_content TINYINT
SELECT @sec_primary = sec_primary,
@sec_content = sec_primary
FROM Dan_Acc.dbo.TB_User
WITH (NOLOCK)
WHERE JID = @UserJID
IF @sec_primary != 3
AND @sec_content ! = 3
BEGIN
INSERT INTO _CharSkillMastery
VALUES
(
@NewCharID,
'289',
1
)
END
IF @@ERROR != 0
BEGIN
ROLLBACK TRANSACTION
RETURN
END
-----------------------------------------------------------------------------