![]() |
#1 | ||||||||||
![]() ![]()
|
انا ضفتها و كل حاجه صح بس لما بستعمل السكرول مفيش حاجه بتحصل مفيش سكيل بيتفتح ؟؟ |
||||||||||
|
![]() |
#2 | ||||||||||
![]() ![]()
|
أتأكد انك حاطط البروسيدر صح في مكنها الصح |
||||||||||
|
![]() |
#3 | |||||||||||
![]() ![]()
|
اقتباس:
|
|||||||||||
|
![]() |
#4 | ||||||||||
![]() ![]()
|
اتاكد يا باشا انك كاتب البيانات الي جوه addlogitem صح زي ال Scroll ObjID Skill ID |
||||||||||
|
![]() |
#5 | |||||||||||
![]() ![]()
|
اقتباس:
|
|||||||||||
|
![]() |
#6 | ||||||||||
![]() ![]()
|
استخدم ده كود:
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 |
||||||||||
|
![]() |
#7 | |||||||||||
![]() ![]()
|
اقتباس:
|
|||||||||||
|
![]() |
#8 | |||||||||||
![]() ![]()
|
اقتباس:
--- شوف الموضوع ده .. كامل كل حاجه |
|||||||||||
|
![]() |
#9 | ||||||||||||
![]() ![]()
|
اقتباس:
اقتباس:
منا عامل الموضوع ده برضو لما استعمل سكرول ما بيحصلش حاجه ؟ |
||||||||||||
|
![]() |
#10 | ||||||||||
![]() ![]()
|
![]() مشكله دي بتجيلي ف جيم سرفر لما استعمل سكرول ؟ |
||||||||||
|
![]() |
#11 | |||||||||||
![]() ![]()
|
اقتباس:
![]() ![]() الايرور اللي موجود ده بيقولك ال Net Framework Disabled !! |
|||||||||||
|
![]() |
#12 | |||||||||||
![]() ![]()
|
اقتباس:
|
|||||||||||
|
![]() |
#13 | |||||||||||
![]() ![]()
|
اقتباس:
|
|||||||||||
|
![]() |
#14 | ||||||||||
![]() ![]()
|
كود PHP:
|
||||||||||
|
![]() |
#15 | ||||||||||
![]() ![]()
|
سوري البروسديوس الي بعتو ده بتاع Mastery system مش Mastery بتاعت ال Up Skills |
||||||||||
|
![]() |
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
![]() |
||||
الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
Mastery lvup scroll | yaserelsheikh | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 1 | 31-03-2020 10:58 PM |
mastery scroll | MiShWo | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 7 | 23-01-2020 06:27 PM |
حل mastery scroll | H I T L E R | الأسئلة و الاستفسارات الخاصة بالـ PK2 edit | 4 | 20-04-2017 03:11 PM |