مشاهدة النسخة كاملة : Mastery Scroll help ?
joesuef
01-04-2017, 08:12 PM
انا ضفتها و كل حاجه صح بس لما بستعمل السكرول مفيش حاجه بتحصل مفيش سكيل بيتفتح ؟؟
Dev.Klito
01-04-2017, 09:22 PM
أتأكد انك حاطط البروسيدر صح في مكنها الصح
joesuef
01-04-2017, 09:35 PM
[CENTER][FONT="Comic Sans MS"][COLOR="Purple"]أتأكد انك حاطط البروسيدر صح في مكنها الصح COLOR][/FONE
ما انا مش عارف اذا كان صح او غلط محطوط ممكن تيجي سكيب او فيس او تيم اي حاجه تشفهولي ؟
joesuef
01-04-2017, 09:40 PM
أتأكد انك حاطط البروسيدر صح في مكنها الصح
تيجي تيم تشوفهلي او فيس او اي حاجه ؟
pop2009
01-04-2017, 10:10 PM
اتاكد يا باشا انك كاتب البيانات الي جوه addlogitem صح زي ال
Scroll ObjID
Skill ID
joesuef
01-04-2017, 10:22 PM
اتاكد يا باشا انك كاتب البيانات الي جوه addlogitem صح زي ال
Scroll ObjID
Skill ID
متاكد يا باشا و كله صح ؟
pop2009
01-04-2017, 10:24 PM
استخدم ده
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
joesuef
01-04-2017, 10:38 PM
استخدم ده
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
طب ما تجيب لينك الموضوع ده لان ده الارقام ال فيها هتلخبطني مش هعرف اضفهم نفس الارقام ال عندى ؟
.Gamer.
01-04-2017, 10:44 PM
طب ما تجيب لينك الموضوع ده لان ده الارقام ال فيها هتلخبطني مش هعرف اضفهم نفس الارقام ال عندى ؟
http://www.silkroad4arab.com/vb/showthread.php?t=601089
---
شوف الموضوع ده .. كامل كل حاجه
joesuef
01-04-2017, 10:47 PM
استخدم ده
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
http://www.silkroad4arab.com/vb/showthread.php?t=601089
---
شوف الموضوع ده .. كامل كل حاجه
منا عامل الموضوع ده برضو لما استعمل سكرول ما بيحصلش حاجه ؟
joesuef
01-04-2017, 11:02 PM
http://i.epvpimg.com/Favnfab.png
مشكله دي بتجيلي ف جيم سرفر لما استعمل سكرول ؟
.Gamer.
01-04-2017, 11:26 PM
منا عامل الموضوع ده برضو لما استعمل سكرول ما بيحصلش حاجه ؟
انا شغال بيها والله مفيش فيها اي مشكلة:mfr_lol::mf_viking:
الايرور اللي موجود ده بيقولك ال Net Framework Disabled !!
joesuef
01-04-2017, 11:47 PM
انا شغال بيها والله مفيش فيها اي مشكلة:mfr_lol::mf_viking:
الايرور اللي موجود ده بيقولك ال Net Framework Disabled !!
طب دي احلها ازاى ؟
joesuef
02-04-2017, 12:16 AM
انا شغال بيها والله مفيش فيها اي مشكلة:mfr_lol::mf_viking:
الايرور اللي موجود ده بيقولك ال Net Framework Disabled !!
طيب ممكن تجبلي Procedure من عندك لان انا شكيل عملوه غلط ؟
.Gamer.
02-04-2017, 12:41 AM
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
pop2009
02-04-2017, 02:44 AM
سوري البروسديوس الي بعتو ده بتاع Mastery system مش Mastery بتاعت ال Up Skills
Mahmoud Rashwan
04-04-2017, 12:34 PM
ان شاء الله مشكلتك تكون اتحلت تنورنا في اى وقت
Mahmoud Rashwan
04-04-2017, 12:34 PM
@@
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc