IF (@Operation=41 AND @ItemRefID between'45255'and'45265') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
DECLARE @gender int =(Select RefObjID from SRO_VT_SHARD.dbo._Char where CharID= @charID)
DECLARE @skillSORGU int
IF (@gender between '1907'and'1932') --Char CH ISE yapar. ELSE koyman laz?m EU için
BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33900'and'33903') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33900'and'33903'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33900,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33905'and'33908') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33905'and'33908'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33905,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33910'and'33913') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33910'and'33913'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33910,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33915'and'33918') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33915'and'33918'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33915,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33920'and'33923') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33920'and'33923'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33920,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33925'and'33928') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33925'and'33928'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33925,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33930'and'33932') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33930'and'33932'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33930,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33934'and'33936') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33934'and'33936'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33934,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33938'and'33939') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33938'and'33939'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33938,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33941'and'33941') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33941'and'33941'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33941,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33943'and'33943') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33943'and'33943'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33943,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END
IF (@Operation=41 AND @ItemRefID between'78057'and'78067') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
IF (@gender not between '1907'and'1932') --Char EU ISE yapar.
BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33945'and'33948') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33945'and'33948'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33945,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33950'and'33953') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33950'and'33953'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33950,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33955'and'33958') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33955'and'33958'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33955,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33960'and'33963') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33960'and'33963'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33960,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33965'and'33968') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33965'and'33968'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33965,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33970'and'33973') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33970'and'33973'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33970,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33975'and'33977') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33975'and'33977'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33975,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33979'and'33981') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33979'and'33981'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33979,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33983'and'33984') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33983'and'33984'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33983,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33986'and'33986') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33986'and'33986'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33986,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33989'and'33989') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33989'and'33989'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33989,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END
المشاركة الأصلية كتبت بواسطة pop2009
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
استخدم ده
كود:
IF (@Operation=41 AND @ItemRefID between'45255'and'45265') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
DECLARE @gender int =(Select RefObjID from SRO_VT_SHARD.dbo._Char where CharID= @charID)
DECLARE @skillSORGU int
IF (@gender between '1907'and'1932') --Char CH ISE yapar. ELSE koyman laz?m EU için
BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33900'and'33903') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33900'and'33903'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33900,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33905'and'33908') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33905'and'33908'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33905,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33910'and'33913') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33910'and'33913'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33910,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33915'and'33918') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33915'and'33918'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33915,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33920'and'33923') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33920'and'33923'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33920,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33925'and'33928') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33925'and'33928'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33925,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33930'and'33932') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33930'and'33932'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33930,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33934'and'33936') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33934'and'33936'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33934,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33938'and'33939') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33938'and'33939'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33938,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33941'and'33941') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33941'and'33941'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33941,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33943'and'33943') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33943'and'33943'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33943,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END
IF (@Operation=41 AND @ItemRefID between'78057'and'78067') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
IF (@gender not between '1907'and'1932') --Char EU ISE yapar.
BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33945'and'33948') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33945'and'33948'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33945,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33950'and'33953') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33950'and'33953'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33950,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33955'and'33958') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33955'and'33958'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33955,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33960'and'33963') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33960'and'33963'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33960,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33965'and'33968') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33965'and'33968'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33965,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33970'and'33973') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33970'and'33973'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33970,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33975'and'33977') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33975'and'33977'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33975,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33979'and'33981') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33979'and'33981'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33979,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33983'and'33984') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33983'and'33984'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33983,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33986'and'33986') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33986'and'33986'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33986,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33989'and'33989') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33989'and'33989'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33989,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END
طب ما تجيب لينك الموضوع ده لان ده الارقام ال فيها هتلخبطني مش هعرف اضفهم نفس الارقام ال عندى ؟
المشاركة الأصلية كتبت بواسطة pop2009
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
استخدم ده
كود:
IF (@Operation=41 AND @ItemRefID between'45255'and'45265') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
DECLARE @gender int =(Select RefObjID from SRO_VT_SHARD.dbo._Char where CharID= @charID)
DECLARE @skillSORGU int
IF (@gender between '1907'and'1932') --Char CH ISE yapar. ELSE koyman laz?m EU için
BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33900'and'33903') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33900'and'33903'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33900,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33905'and'33908') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33905'and'33908'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33905,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33910'and'33913') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33910'and'33913'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33910,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33915'and'33918') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33915'and'33918'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33915,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33920'and'33923') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33920'and'33923'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33920,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33925'and'33928') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33925'and'33928'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33925,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33930'and'33932') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33930'and'33932'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33930,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33934'and'33936') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33934'and'33936'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33934,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33938'and'33939') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33938'and'33939'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33938,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33941'and'33941') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33941'and'33941'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33941,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33943'and'33943') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33943'and'33943'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33943,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END
IF (@Operation=41 AND @ItemRefID between'78057'and'78067') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
IF (@gender not between '1907'and'1932') --Char EU ISE yapar.
BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33945'and'33948') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33945'and'33948'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33945,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33950'and'33953') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33950'and'33953'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33950,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33955'and'33958') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33955'and'33958'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33955,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33960'and'33963') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33960'and'33963'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33960,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33965'and'33968') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33965'and'33968'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33965,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33970'and'33973') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33970'and'33973'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33970,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33975'and'33977') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33975'and'33977'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33975,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33979'and'33981') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33979'and'33981'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33979,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33983'and'33984') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33983'and'33984'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33983,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33986'and'33986') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33986'and'33986'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33986,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33989'and'33989') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33989'and'33989'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33989,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END
اقتباس:
المشاركة الأصلية كتبت بواسطة #Gamer1337
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
---
شوف الموضوع ده .. كامل كل حاجه
منا عامل الموضوع ده برضو لما استعمل سكرول ما بيحصلش حاجه ؟
8437 Warrior European 513 8447 Warrior European 513 8465 Warrior European 513 8476 Warrior European 513 8496 Warrior European 513 8512 Warrior European 513 8522 Warrior European 513 8571 Warrior European 513 8581 Warrior European 513 8595 Warrior European 513 8624 Warrior European 513 8645 Warrior European 513 8658 Warrior European 513 8668 Warrior European 513 8695 Warrior European 513 8710 Warrior European 513 8721 Warrior European 513 8752 Warrior European 513 8772 Warrior European 513 8812 Warrior European 513 8827 Warrior European 513 8879 Warrior European 513 8893 Warrior European 513 8903 Warrior European 513 8930 Warrior European 513 8958 Warrior European 513 8974 Warrior European 513 8994 Warrior European 513 9034 Warrior European 513 9040 Warrior European 513 9072 Warrior European 513 9100 Warrior European 513 9114 Warrior European 513 9124 Warrior European 513 9142 Warrior European 513 9170 Warrior European 513 9187 Warrior European 513 9210 Warrior European 513 9249 Warrior European 513 9262 Warrior European 513 9282 Warrior European 513 9322 Warrior European 513 9337 Warrior European 513 21224 Warrior European 513 11187 Bard European 517 11199 Bard European 517 11209 Bard European 517 11216 Bard European 517 11243 Bard European 517 11259 Bard European 517 11282 Bard European 517 11295 Bard European 517 11299 Bard European 517 11337 Bard European 517 11339 Bard European 517 11350 Bard European 517 11355 Bard European 517 11363 Bard European 517 11365 Bard European 517 11375 Bard European 517 11379 Bard European 517 11387 Bard European 517 11388 Bard European 517 11399 Bard European 517 11432 Bard European 517 11443 Bard European 517 11462 Bard European 517 11471 Bard European 517 11479 Bard European 517 11486 Bard European 517 11492 Bard European 517 11496 Bard European 517 11513 Bard European 517 11515 Bard European 517 11522 Bard European 517 11523 Bard European 517 30197 Bard European 517 30213 Bard European 517 30222 Bard European 517 30242 Bard European 517 30247 Bard European 517 9951 Wizard European 514 9956 Wizard European 514 9965 Wizard European 514 9970 Wizard European 514 9999 Wizard European 514 10017 Wizard European 514 10028 Wizard European 514 10041 Wizard European 514 10046 Wizard European 514 10062 Wizard European 514 10068 Wizard European 514 10076 Wizard European 514 10078 Wizard European 514 10104 Wizard European 514 10122 Wizard European 514 10133 Wizard European 514 10161 Wizard European 514 10166 Wizard European 514 10182 Wizard European 514 10188 Wizard European 514 10200 Wizard European 514 10205 Wizard European 514 10232 Wizard European 514 10262 Wizard European 514 10278 Wizard European 514 10296 Wizard European 514 10304 Wizard European 514 10323 Wizard European 514 10413 Wizard European 514 10489 Wizard European 514 10492 Wizard European 514 10519 Wizard European 514 10537 Wizard European 514 10548 Wizard European 514 10561 Wizard European 514 10566 Wizard European 514 10582 Wizard European 514 10602 Wizard European 514 10621 Wizard European 514 10623 Wizard European 514 9363 Rouge European 515 9369 Rouge European 515 9372 Rouge European 515 9378 Rouge European 515 9381 Rouge European 515 9388 Rouge European 515 9391 Rouge European 515 9397 Rouge European 515 9399 Rouge European 515 9407 Rouge European 515 9410 Rouge European 515 9417 Rouge European 515 9420 Rouge European 515 9428 Rouge European 515 9429 Rouge European 515 9437 Rouge European 515 9444 Rouge European 515 9448 Rouge European 515 9453 Rouge European 515 9454 Rouge European 515 9479 Rouge European 515 9488 Rouge European 515 9498 Rouge European 515 9514 Rouge European 515 9528 Rouge European 515 9541 Rouge European 515 9574 Rouge European 515 9585 Rouge European 515 9601 Rouge European 515 9609 Rouge European 515 9623 Rouge European 515 9629 Rouge European 515 9670 Rouge European 515 9685 Rouge European 515 9701 Rouge European 515 9713 Rouge European 515 9720 Rouge European 515 9734 Rouge European 515 9742 Rouge European 515 9768 Rouge European 515 9785 Rouge European 515 9796 Rouge European 515 9843 Rouge European 515 9866 Rouge European 515 9880 Rouge European 515 9895 Rouge European 515 9938 Rouge European 515 10650 Warlock European 516 10659 Warlock European 516 10685 Warlock European 516 10702 Warlock European 516 10730 Warlock European 516 10746 Warlock European 516 10772 Warlock European 516 10784 Warlock European 516 10805 Warlock European 516 10816 Warlock European 516 10830 Warlock European 516 10836 Warlock European 516 10846 Warlock European 516 10851 Warlock European 516 10860 Warlock European 516 10864 Warlock European 516 10872 Warlock European 516 10875 Warlock European 516 10902 Warlock European 516 10915 Warlock European 516 10942 Warlock European 516 10960 Warlock European 516 10971 Warlock European 516 10975 Warlock European 516 10986 Warlock European 516 10991 Warlock European 516 11001 Warlock European 516 11005 Warlock European 516 11011 Warlock European 516 11014 Warlock European 516 11040 Warlock European 516 11069 Warlock European 516 11086 Warlock European 516 11094 Warlock European 516 11107 Warlock European 516 11116 Warlock European 516 11127 Warlock European 516 11132 Warlock European 516 11142 Warlock European 516 11146 Warlock European 516 11154 Warlock European 516 11158 Warlock European 516 30184 Warlock European 516 30192 Warlock European 516 11551 Cleric European 518 11581 Cleric European 518 11597 Cleric European 518 11611 Cleric European 518 11618 Cleric European 518 11627 Cleric European 518 11632 Cleric European 518 11641 Cleric European 518 11647 Cleric European 518 11665 Cleric European 518 11682 Cleric European 518 11691 Cleric European 518 11702 Cleric European 518 11708 Cleric European 518 11719 Cleric European 518 11725 Cleric European 518 11740 Cleric European 518 11748 Cleric European 518 11764 Cleric European 518 11776 Cleric European 518 11780 Cleric European 518 11791 Cleric European 518 11793 Cleric European 518 11805 Cleric European 518 11807 Cleric European 518 11848 Cleric European 518 11865 Cleric European 518 11880 Cleric European 518 11893 Cleric European 518 11899 Cleric European 518 11912 Cleric European 518 11917 Cleric European 518 11928 Cleric European 518 11933 Cleric European 518 298 Bicheon Chinese 257 306 Bicheon Chinese 257 314 Bicheon Chinese 257 322 Bicheon Chinese 257 346 Bicheon Chinese 257 378 Bicheon Chinese 257 418 Bicheon Chinese 257 463 Bicheon Chinese 257 558 Bicheon Chinese 257 569 Bicheon Chinese 257 580 Bicheon Chinese 257 588 Bicheon Chinese 257 596 Bicheon Chinese 257 604 Bicheon Chinese 257 621 Bicheon Chinese 257 638 Bicheon Chinese 257 647 Bicheon Chinese 257 655 Bicheon Chinese 257 672 Bicheon Chinese 257 689 Bicheon Chinese 257 699 Bicheon Chinese 257 3140 Bicheon Chinese 257 3149 Bicheon Chinese 257 7139 Bicheon Chinese 257 7159 Bicheon Chinese 257 7203 Bicheon Chinese 257 7322 Bicheon Chinese 257 7385 Bicheon Chinese 257 7390 Bicheon Chinese 257 7392 Bicheon Chinese 257 7404 Bicheon Chinese 257 7418 Bicheon Chinese 257 7450 Bicheon Chinese 257 7474 Bicheon Chinese 257 7484 Bicheon Chinese 257 7513 Bicheon Chinese 257 7520 Bicheon Chinese 257 30578 Bicheon Chinese 257 30584 Bicheon Chinese 257 30590 Bicheon Chinese 257 30596 Bicheon Chinese 257 30600 Bicheon Chinese 257 708 Heuksal Chinese 258 716 Heuksal Chinese 258 724 Heuksal Chinese 258 735 Heuksal Chinese 258 746 Heuksal Chinese 258 757 Heuksal Chinese 258 765 Heuksal Chinese 258 773 Heuksal Chinese 258 781 Heuksal Chinese 258 789 Heuksal Chinese 258 797 Heuksal Chinese 258 805 Heuksal Chinese 258 813 Heuksal Chinese 258 821 Heuksal Chinese 258 829 Heuksal Chinese 258 853 Heuksal Chinese 258 885 Heuksal Chinese 258 925 Heuksal Chinese 258 933 Heuksal Chinese 258 943 Heuksal Chinese 258 3167 Heuksal Chinese 258 3176 Heuksal Chinese 258 3224 Heuksal Chinese 258 7536 Heuksal Chinese 258 7554 Heuksal Chinese 258 7577 Heuksal Chinese 258 7582 Heuksal Chinese 258 7584 Heuksal Chinese 258 7596 Heuksal Chinese 258 7612 Heuksal Chinese 258 7637 Heuksal Chinese 258 7651 Heuksal Chinese 258 7672 Heuksal Chinese 258 7675 Heuksal Chinese 258 7688 Heuksal Chinese 258 7798 Heuksal Chinese 258 7805 Heuksal Chinese 258 952 Pacheon Chinese 259 960 Pacheon Chinese 259 968 Pacheon Chinese 259 976 Pacheon Chinese 259 984 Pacheon Chinese 259 992 Pacheon Chinese 259 1003 Pacheon Chinese 259 1014 Pacheon Chinese 259 1025 Pacheon Chinese 259 1033 Pacheon Chinese 259 1041 Pacheon Chinese 259 1049 Pacheon Chinese 259 1053 Pacheon Chinese 259 1057 Pacheon Chinese 259 1065 Pacheon Chinese 259 1073 Pacheon Chinese 259 1081 Pacheon Chinese 259 1089 Pacheon Chinese 259 1099 Pacheon Chinese 259 3340 Pacheon Chinese 259 3349 Pacheon Chinese 259 7829 Pacheon Chinese 259 7838 Pacheon Chinese 259 7839 Pacheon Chinese 259 7853 Pacheon Chinese 259 7862 Pacheon Chinese 259 7877 Pacheon Chinese 259 7881 Pacheon Chinese 259 7894 Pacheon Chinese 259 7899 Pacheon Chinese 259 7907 Pacheon Chinese 259 7919 Pacheon Chinese 259 7931 Pacheon Chinese 259 7938 Pacheon Chinese 259 7947 Pacheon Chinese 259 7953 Pacheon Chinese 259 7959 Pacheon Chinese 259 7962 Pacheon Chinese 259 1108 Cold Chinese 273 1116 Cold Chinese 273 1124 Cold Chinese 273 1132 Cold Chinese 273 1140 Cold Chinese 273 1148 Cold Chinese 273 1153 Cold Chinese 273 1158 Cold Chinese 273 1163 Cold Chinese 273 1168 Cold Chinese 273 1173 Cold Chinese 273 1178 Cold Chinese 273 1189 Cold Chinese 273 1200 Cold Chinese 273 1217 Cold Chinese 273 1234 Cold Chinese 273 1244 Cold Chinese 273 3364 Cold Chinese 273 3379 Cold Chinese 273 3391 Cold Chinese 273 7972 Cold Chinese 273 7980 Cold Chinese 273 7995 Cold Chinese 273 7997 Cold Chinese 273 8010 Cold Chinese 273 8024 Cold Chinese 273 8050 Cold Chinese 273 8084 Cold Chinese 273 8097 Cold Chinese 273 8103 Cold Chinese 273 8109 Cold Chinese 273 8115 Cold Chinese 273 8119 Cold Chinese 273 1253 Lightning Chinese 274 1261 Lightning Chinese 274 1269 Lightning Chinese 274 1271 Lightning Chinese 274 1273 Lightning Chinese 274 1275 Lightning Chinese 274 1286 Lightning Chinese 274 1297 Lightning Chinese 274 1308 Lightning Chinese 274 1316 Lightning Chinese 274 1324 Lightning Chinese 274 1332 Lightning Chinese 274 1337 Lightning Chinese 274 1342 Lightning Chinese 274 1350 Lightning Chinese 274 1358 Lightning Chinese 274 1368 Lightning Chinese 274 3406 Lightning Chinese 274 3409 Lightning Chinese 274 3415 Lightning Chinese 274 8129 Lightning Chinese 274 8133 Lightning Chinese 274 8141 Lightning Chinese 274 8150 Lightning Chinese 274 8164 Lightning Chinese 274 8171 Lightning Chinese 274 8183 Lightning Chinese 274 8195 Lightning Chinese 274 8204 Lightning Chinese 274 1377 Fire Chinese 275 1385 Fire Chinese 275 1393 Fire Chinese 275 1398 Fire Chinese 275 1403 Fire Chinese 275 1408 Fire Chinese 275 1410 Fire Chinese 275 1412 Fire Chinese 275 1414 Fire Chinese 275 1422 Fire Chinese 275 1430 Fire Chinese 275 1438 Fire Chinese 275 1443 Fire Chinese 275 1448 Fire Chinese 275 1465 Fire Chinese 275 1482 Fire Chinese 275 1499 Fire Chinese 275 1509 Fire Chinese 275 3430 Fire Chinese 275 3435 Fire Chinese 275 3446 Fire Chinese 275 8214 Fire Chinese 275 8220 Fire Chinese 275 8221 Fire Chinese 275 8238 Fire Chinese 275 8239 Fire Chinese 275 8250 Fire Chinese 275 8253 Fire Chinese 275 8276 Fire Chinese 275 8291 Fire Chinese 275 8304 Fire Chinese 275 8316 Fire Chinese 275 8320 Fire Chinese 275 21215 Fire Chinese 275 21217 Fire Chinese 275 1518 Force Chinese 276 1526 Force Chinese 276 1534 Force Chinese 276 1539 Force Chinese 276 1544 Force Chinese 276 1549 Force Chinese 276 1557 Force Chinese 276 1565 Force Chinese 276 1573 Force Chinese 276 1578 Force Chinese 276 1583 Force Chinese 276 1588 Force Chinese 276 1593 Force Chinese 276 1598 Force Chinese 276 1609 Force Chinese 276 1617 Force Chinese 276 1628 Force Chinese 276 3461 Force Chinese 276 3467 Force Chinese 276 3473 Force Chinese 276 8338 Force Chinese 276 8347 Force Chinese 276 8348 Force Chinese 276 8361 Force Chinese 276 8370 Force Chinese 276 8379 Force Chinese 276 8383 Force Chinese 276 8390 Force Chinese 276 8399 Force Chinese 276 8405 Force Chinese 276 8410 Force Chinese 276 8414 Force Chinese 276 8416 Force Chinese 276 20494 Force Chinese 276 20497 Force Chinese 276 20500 Force Chinese 276 11978 Cleric European 518 11982 Cleric European 518 11993 Cleric European 518 11995 Cleric European 518 21213 Fire Chinese 275
شـريـط الاهـداءات
01-04-2017, 08:12 PM
.gif){kind=icon}
العرض العادي
