الموقع العربي الاول للعبة Silkroad Online
صفحة 1 من 2 1 2
عرض 40 مشاركات من هذا الموضوع لكل صفحة

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   Mastery Scroll help ? (https://silkroad4arab.com/vb/showthread.php?t=614250)

joesuef 01-04-2017 08:12 PM
Mastery Scroll help ?
 
انا ضفتها و كل حاجه صح بس لما بستعمل السكرول مفيش حاجه بتحصل مفيش سكيل بيتفتح ؟؟

Dev.Klito 01-04-2017 09:22 PM
رد: Mastery Scroll help ?
 
أتأكد انك حاطط البروسيدر صح في مكنها الصح

joesuef 01-04-2017 09:40 PM
رد: Mastery Scroll help ?
 
اقتباس:
المشاركة الأصلية كتبت بواسطة Dev.Klito (المشاركة 5310763)
أتأكد انك حاطط البروسيدر صح في مكنها الصح
تيجي تيم تشوفهلي او فيس او اي حاجه ؟

pop2009 01-04-2017 10:10 PM
رد: Mastery Scroll help ?
 
اتاكد يا باشا انك كاتب البيانات الي جوه addlogitem صح زي ال
Scroll ObjID
Skill ID

joesuef 01-04-2017 10:22 PM
رد: Mastery Scroll help ?
 
اقتباس:
المشاركة الأصلية كتبت بواسطة pop2009 (المشاركة 5310774)
اتاكد يا باشا انك كاتب البيانات الي جوه addlogitem صح زي ال
Scroll ObjID
Skill ID
متاكد يا باشا و كله صح ؟

pop2009 01-04-2017 10:24 PM
رد: Mastery Scroll help ?
 
استخدم ده
كود:
  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
رد: Mastery Scroll help ?
 
اقتباس:
المشاركة الأصلية كتبت بواسطة pop2009 (المشاركة 5310779)
استخدم ده
كود:
  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
رد: Mastery Scroll help ?
 
اقتباس:
المشاركة الأصلية كتبت بواسطة Yousif1337 (المشاركة 5310780)
طب ما تجيب لينك الموضوع ده لان ده الارقام ال فيها هتلخبطني مش هعرف اضفهم نفس الارقام ال عندى ؟
http://www.silkroad4arab.com/vb/showthread.php?t=601089
---
شوف الموضوع ده .. كامل كل حاجه

joesuef 01-04-2017 10:47 PM
رد: Mastery Scroll help ?
 
اقتباس:
المشاركة الأصلية كتبت بواسطة pop2009 (المشاركة 5310779)
استخدم ده
كود:
  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 (المشاركة 5310781)


http://www.silkroad4arab.com/vb/showthread.php?t=601089
---
شوف الموضوع ده .. كامل كل حاجه

منا عامل الموضوع ده برضو لما استعمل سكرول ما بيحصلش حاجه ؟

joesuef 01-04-2017 11:02 PM
رد: Mastery Scroll help ?
 
http://i.epvpimg.com/Favnfab.png

مشكله دي بتجيلي ف جيم سرفر لما استعمل سكرول ؟

.Gamer. 01-04-2017 11:26 PM
رد: Mastery Scroll help ?
 
اقتباس:
المشاركة الأصلية كتبت بواسطة Yousif1337 (المشاركة 5310783)
منا عامل الموضوع ده برضو لما استعمل سكرول ما بيحصلش حاجه ؟
انا شغال بيها والله مفيش فيها اي مشكلة:mfr_lol::mf_viking:

الايرور اللي موجود ده بيقولك ال Net Framework Disabled !!

joesuef 01-04-2017 11:47 PM
رد: Mastery Scroll help ?
 
اقتباس:
المشاركة الأصلية كتبت بواسطة #Gamer1337 (المشاركة 5310787)


انا شغال بيها والله مفيش فيها اي مشكلة:mfr_lol::mf_viking:

الايرور اللي موجود ده بيقولك ال Net Framework Disabled !!
طب دي احلها ازاى ؟

joesuef 02-04-2017 12:16 AM
رد: Mastery Scroll help ?
 
اقتباس:
المشاركة الأصلية كتبت بواسطة #Gamer1337 (المشاركة 5310787)


انا شغال بيها والله مفيش فيها اي مشكلة:mfr_lol::mf_viking:

الايرور اللي موجود ده بيقولك ال Net Framework Disabled !!
طيب ممكن تجبلي Procedure من عندك لان انا شكيل عملوه غلط ؟

.Gamer. 02-04-2017 12:41 AM
رد: Mastery Scroll help ?
 
كود PHP:
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 Scroll help ?
 
سوري البروسديوس الي بعتو ده بتاع Mastery system مش Mastery بتاعت ال Up Skills


الساعة الآن 12:50 AM.
صفحة 1 من 2 1 2
عرض 40 مشاركات من هذا الموضوع لكل صفحة

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.