تسجيل الدخول دائمآ
ط·آ§ط¸â€‍ط·آ¥ط·آ¹ط¸â€‍ط·آ§ط¸â€ ط·آ§ط·ع¾

الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group 



قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ]

موضوع مغلق
 
أدوات الموضوع انواع عرض الموضوع
قديم 01-04-2017, 10:38 PM   #1

joesuef
عضو فعال



الصورة الرمزية joesuef


• الانـتـسـاب » Sep 2015
• رقـم العـضـويـة » 127074
• المشـــاركـات » 482
• الـدولـة » Cairo/ Rehab
• الـهـوايـة » Private Server
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 10
joesuef صـاعـد

joesuef غير متواجد حالياً



افتراضي رد: Mastery Scroll help ?



اقتباس:
المشاركة الأصلية كتبت بواسطة pop2009 مشاهدة المشاركة
استخدم ده
كود:
  IF (@Operation=41 AND @ItemRefID between'45255'and'45265') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
DECLARE @gender int =(Select RefObjID from SRO_VT_SHARD.dbo._Char where CharID= @charID)
DECLARE @skillSORGU int
IF (@gender between '1907'and'1932') --Char CH ISE yapar. ELSE koyman laz?m EU için
BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33900'and'33903') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33900'and'33903'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33900,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33905'and'33908') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33905'and'33908'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33905,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33910'and'33913') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33910'and'33913'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33910,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33915'and'33918') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33915'and'33918'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33915,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33920'and'33923') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33920'and'33923'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33920,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33925'and'33928') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33925'and'33928'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33925,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33930'and'33932') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33930'and'33932'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33930,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33934'and'33936') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33934'and'33936'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33934,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33938'and'33939') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33938'and'33939'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33938,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33941'and'33941') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33941'and'33941'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33941,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33943'and'33943') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33943'and'33943'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33943,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END

IF (@Operation=41 AND @ItemRefID between'78057'and'78067') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
IF (@gender not between '1907'and'1932') --Char EU ISE yapar.   
 BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33945'and'33948') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33945'and'33948'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33945,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  

IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33950'and'33953') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33950'and'33953'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33950,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33955'and'33958') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33955'and'33958'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33955,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33960'and'33963') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33960'and'33963'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33960,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
 IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33965'and'33968') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33965'and'33968'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33965,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33970'and'33973') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33970'and'33973'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33970,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33975'and'33977') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33975'and'33977'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33975,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END 
IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33979'and'33981') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33979'and'33981'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33979,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END 
IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33983'and'33984') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33983'and'33984'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33983,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33986'and'33986') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33986'and'33986'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33986,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33989'and'33989') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33989'and'33989'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33989,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END
طب ما تجيب لينك الموضوع ده لان ده الارقام ال فيها هتلخبطني مش هعرف اضفهم نفس الارقام ال عندى ؟




إعلانات google

قديم 01-04-2017, 10:44 PM   #2

.Gamer.
عضو سوبر



الصورة الرمزية .Gamer.


• الانـتـسـاب » Jul 2015
• رقـم العـضـويـة » 123161
• المشـــاركـات » 2,962
• الـدولـة » https://t.me/pump_upp
• الـهـوايـة » Developer At Private Silkroad
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 33
.Gamer. صـاعـد

.Gamer. غير متواجد حالياً


إرسال رسالة عبر ICQ إلى .Gamer. إرسال رسالة عبر AIM إلى .Gamer. إرسال رسالة عبر Yahoo إلى .Gamer.

افتراضي رد: Mastery Scroll help ?



اقتباس:
المشاركة الأصلية كتبت بواسطة Yousif1337 مشاهدة المشاركة
طب ما تجيب لينك الموضوع ده لان ده الارقام ال فيها هتلخبطني مش هعرف اضفهم نفس الارقام ال عندى ؟
http://www.silkroad4arab.com/vb/showthread.php?t=601089
---
شوف الموضوع ده .. كامل كل حاجه


توقيع .Gamer. :
https://t.me/pump_upp


قديم 01-04-2017, 10:47 PM   #3

joesuef
عضو فعال



الصورة الرمزية joesuef


• الانـتـسـاب » Sep 2015
• رقـم العـضـويـة » 127074
• المشـــاركـات » 482
• الـدولـة » Cairo/ Rehab
• الـهـوايـة » Private Server
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 10
joesuef صـاعـد

joesuef غير متواجد حالياً



افتراضي رد: Mastery Scroll help ?



اقتباس:
المشاركة الأصلية كتبت بواسطة pop2009 مشاهدة المشاركة
استخدم ده
كود:
  IF (@Operation=41 AND @ItemRefID between'45255'and'45265') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
DECLARE @gender int =(Select RefObjID from SRO_VT_SHARD.dbo._Char where CharID= @charID)
DECLARE @skillSORGU int
IF (@gender between '1907'and'1932') --Char CH ISE yapar. ELSE koyman laz?m EU için
BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33900'and'33903') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33900'and'33903'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33900,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33905'and'33908') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33905'and'33908'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33905,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33910'and'33913') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33910'and'33913'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33910,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33915'and'33918') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33915'and'33918'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33915,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33920'and'33923') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33920'and'33923'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33920,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33925'and'33928') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33925'and'33928'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33925,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33930'and'33932') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33930'and'33932'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33930,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33934'and'33936') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33934'and'33936'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33934,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33938'and'33939') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33938'and'33939'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33938,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33941'and'33941') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33941'and'33941'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33941,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END

IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33943'and'33943') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33943'and'33943'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33943,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END

IF (@Operation=41 AND @ItemRefID between'78057'and'78067') -- ?mehProcedure --Scroll ObjID 'leri ama bir grubun mesela HP art?ran?nki BEGIN
IF (@gender not between '1907'and'1932') --Char EU ISE yapar.   
 BEGIN
IF(@ItemRefID=45255) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33945'and'33948') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33945'and'33948'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33945,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  

IF(@ItemRefID=45256) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33950'and'33953') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33950'and'33953'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33950,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45257) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33955'and'33958') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33955'and'33958'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33955,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45258) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33960'and'33963') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33960'and'33963'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33960,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
 IF(@ItemRefID=45259) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33965'and'33968') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33965'and'33968'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33965,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45260) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33970'and'33973') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33970'and'33973'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33970,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
IF(@ItemRefID=45261) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33975'and'33977') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33975'and'33977'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33975,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END 
IF(@ItemRefID=45262) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33979'and'33981') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33979'and'33981'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33979,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END 
IF(@ItemRefID=45263) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33983'and'33984') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33983'and'33984'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33983,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45264) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33986'and'33986') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33986'and'33986'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33986,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END  
IF(@ItemRefID=45265) --Scroll ObjID
BEGIN
IF EXISTS (SELECT*FROM SRO_VT_SHARD.DBO._CharSkill WHERE CharID =@charID and SkillID BETWEEN '33989'and'33989') --bu id aral??? varsa sadece skill ID +1 yapar bir sonraki skille geçer
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharSkill SET SkillID=SkillID+1 WHERE CharID= @charID and SkillID BETWEEN '33989'and'33989'
END
ELSE
BEGIN
INSERT INTO SRO_VT_SHARD.DBO._CharSkill(CharID,SkillID,Enable) VALUES(@charID,33989,1) -- Hiç yoksa e?er 1Lv olan skilli ekler temeldekini
END
END
END
اقتباس:
المشاركة الأصلية كتبت بواسطة #Gamer1337 مشاهدة المشاركة


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

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




قديم 01-04-2017, 11:02 PM   #4

joesuef
عضو فعال



الصورة الرمزية joesuef


• الانـتـسـاب » Sep 2015
• رقـم العـضـويـة » 127074
• المشـــاركـات » 482
• الـدولـة » Cairo/ Rehab
• الـهـوايـة » Private Server
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 10
joesuef صـاعـد

joesuef غير متواجد حالياً



افتراضي رد: Mastery Scroll help ?





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




قديم 01-04-2017, 11:26 PM   #5

.Gamer.
عضو سوبر



الصورة الرمزية .Gamer.


• الانـتـسـاب » Jul 2015
• رقـم العـضـويـة » 123161
• المشـــاركـات » 2,962
• الـدولـة » https://t.me/pump_upp
• الـهـوايـة » Developer At Private Silkroad
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 33
.Gamer. صـاعـد

.Gamer. غير متواجد حالياً


إرسال رسالة عبر ICQ إلى .Gamer. إرسال رسالة عبر AIM إلى .Gamer. إرسال رسالة عبر Yahoo إلى .Gamer.

افتراضي رد: Mastery Scroll help ?



اقتباس:
المشاركة الأصلية كتبت بواسطة Yousif1337 مشاهدة المشاركة
منا عامل الموضوع ده برضو لما استعمل سكرول ما بيحصلش حاجه ؟
انا شغال بيها والله مفيش فيها اي مشكلة

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


توقيع .Gamer. :
https://t.me/pump_upp


قديم 01-04-2017, 11:47 PM   #6

joesuef
عضو فعال



الصورة الرمزية joesuef


• الانـتـسـاب » Sep 2015
• رقـم العـضـويـة » 127074
• المشـــاركـات » 482
• الـدولـة » Cairo/ Rehab
• الـهـوايـة » Private Server
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 10
joesuef صـاعـد

joesuef غير متواجد حالياً



افتراضي رد: Mastery Scroll help ?



اقتباس:
المشاركة الأصلية كتبت بواسطة #Gamer1337 مشاهدة المشاركة


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

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




قديم 02-04-2017, 12:16 AM   #7

joesuef
عضو فعال



الصورة الرمزية joesuef


• الانـتـسـاب » Sep 2015
• رقـم العـضـويـة » 127074
• المشـــاركـات » 482
• الـدولـة » Cairo/ Rehab
• الـهـوايـة » Private Server
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 10
joesuef صـاعـد

joesuef غير متواجد حالياً



افتراضي رد: Mastery Scroll help ?



اقتباس:
المشاركة الأصلية كتبت بواسطة #Gamer1337 مشاهدة المشاركة


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

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




موضوع مغلق


يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
 
أدوات الموضوع
انواع عرض الموضوع

ضوابط المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code متاحة
كود [IMG] متاحة
كود HTML معطلة

الانتقال السريع

المواضيع المتشابهه
الموضوع كاتب الموضوع المنتدى الردود آخر مشاركة
Mastery lvup scroll yaserelsheikh قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 1 31-03-2020 10:58 PM
mastery scroll MiShWo قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 7 23-01-2020 06:27 PM
mastery scroll .Gamer. قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 0 14-06-2017 04:16 PM
حل mastery scroll H I T L E R الأسئلة و الاستفسارات الخاصة بالـ PK2 edit 4 20-04-2017 03:11 PM
Mastery Scroll ™Dev Microsoft™ قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة 0 03-09-2014 04:54 AM


الساعة الآن 09:59 AM.