قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة[ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]
• الـهـوايـة » Private server developing and designing [ 2D -3D - Pk2 ]
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 55
رد: Lock / Unlock Scroll
فى فكرة احسن من موضوع الPw
وهى اننا ممكن نستخدم برنامج يتربط ب Table معينة ال Table دى بتخزن ال Ip بتاع صاحب ال Char ولما ييجى يعمل Unlock البرنامج يشوف ال Ip لو هو تشتغل لو لا خلاص .. انا ممكن ان شاء الله ابقى اعملها و اكمل معاك الموضوع ده بس حاليا مش فاضى بس
انا مش مع الفكره دي يااshefa علشان مثلا صاحب الاكونت فتح في مكان تاني
اكيد ال ip هيتغير وبكدا مش هيقدر يفكها ....
وكمان افرد انو عملو علي جهازو وعمل وندوس الip هيتغير
اقبل مروري ..
• الـهـوايـة » Private server developing and designing [ 2D -3D - Pk2 ]
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 55
رد: Lock / Unlock Scroll
تمام انا معاك بس احنا هنعرف الناس الكلام ده قبل ما يستخدموها يعنى استخدامها هيكون على مسئوليتهم
و انا جاالى فكرة ممكن نخليها بال HWID بدل ال Ip بس لسه مش متأكد تنفع ولا لا الصراحة لكن هشوف
اصل كده كده فكرة انو يكلمو على الفيس وكده دى مش داخله دماغى و يبقى احسنلى محطش السيستم ده لو كده اصلا
المشاركة الأصلية كتبت بواسطة shefa
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تمام انا معاك بس احنا هنعرف الناس الكلام ده قبل ما يستخدموها يعنى استخدامها هيكون على مسئوليتهم
و انا جاالى فكرة ممكن نخليها بال HWID بدل ال Ip بس لسه مش متأكد تنفع ولا لا الصراحة لكن هشوف
اصل كده كده فكرة انو يكلمو على الفيس وكده دى مش داخله دماغى و يبقى احسنلى محطش السيستم ده لو كده اصلا
هي فكره ال ip حلوه بس المشكله انو لو عمل مثلا windos لجهازو الip هيتغير
فا احنا ممكن نقولو ايه يستخدم الscroll ويطلب من الGMال ip بتاعو
بس في نفس الوقت الضرب فيه الscroll ليه بقي علشان ال GM يعرف انو هو صاحب ال account الضربها وفي الحاله دي صاحب الaccount هيضمن يفكها من غير مشاكل
كل الردود والأفكار جملية بس الفكرة الأفضل هي فكرة الـ Memo_Add وعلى فكرة يا حمزة معلومة ليك ال Memo_Add لما بتحط الكود قبل متبدأ الـ Transaction بيشتغل حتي لو ال Message inbox ال 20 رسالة كاملين دا في حالة انك هتخلي أكونت أسمه Lock System مثلاً يبقا مشترك لكل الناس أو ممكن تخليه يبعت المسيج لنفسه دي اسهل ،، وموضوع ان كل أيتم ليه باسورد دا موضوع فاكس ،، هو يدخل باسورد فى الأول وتبقا على كل السيستم للكركتر لأي أيتم يتبعت بإسم أو أي دي الكراكتر للـ Lock or Unlock وهو اللي يدخلها عشان يبقا فاكرها ،، بالنسبة للسيرفرات اللى الموقع بتاعها التسجيل بتدخل فيه سكريت كود للاكونت لما يتكريت دي أفضل لها تشتغل بالـ Secret code دا عشان هو عمره ما هينساه عشان بيغير بيه الباسورد ،، أو للي شغال بالإيميل ممكن يشتغل على الإيميل عادي ،، اهم حاجة تكون باسورد ثابتة لأكونت أو الكراكتر وهو اللي يدخلها عشان يحتفظ بيها ،،
موضوع الأي بي دا مش هينفع عشان ال Usb modem مع كل Connect بيغير الـ IP وموضوع الـ Hwan ID مينفعش خالص هتشتغل عليه إزاي ؟
موضوع البرايفت شات دا جميل لو اشتغل بنفس النظام اللي قولت عليه فوق بتاع المسيج بس لو الكراكتر اللي هيبعتلها خدت Dc لو البرنامج مفهوش Re-Log مش هيشتغل ،،
ودي صورة من عندي
التعديل الأخير تم بواسطة Dev. iLegend ; 18-11-2015 الساعة 11:47 PM
لاحظو الفرق بين الاتنين واعملوها علي اي ديجري انتو عايزينه
Add this at LOG db at AddLogItem
كود:
IF (@operation = 41 and @ItemRefID = '81023')
Begin
Declare @ID64 Int , @RefItemID Int , @NewRefID Int
Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64 Where Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
Select Top 1 @NewRefID = LockItemID From [dbo].[LockItemsID] Where ReqItemID = @RefItemID
IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
End
End
-- Unlock
IF (@operation = 41 and @ItemRefID = '81024')
Begin
Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64 Where Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
Select Top 1 @NewRefID = ReqItemID From [dbo].[LockItemsID] Where LockItemID = @RefItemID
IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
End
End
Then create this :
كود:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15] Script Date: 11/3/2015 8:01:33 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_HamzaLockSystemD15]
@CharID Int
As
-- Declare expression.
Declare @CreaterName Varchar(60) = 'Figozz' , -- Creater Name
@Slot Int = '13' , -- char inventory slot 1.
@ReqOptLevel Int = '0' , -- Requiared Opt Level to upgrade
@OptDifference Int = '2' , -- Set the difference optlevel between old plus and new plus.
@OldOptLevel Int ,
@NewOptLevel Int ,
@AdvValue Int ,
@ID64 Int ,
-------------------------
-- Set Old and New Item RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'
---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 39368 , @New_CH_SWORD_ID Int = 80370 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 39391 , @New_CH_BLADE_ID Int = 80391 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 39412 , @New_CH_SPEAR_ID Int = 80412 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 39433 , @New_CH_TBLADE_ID Int = 80433 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 39454 , @New_CH_BOW_ID Int = 80454 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 39475 , @New_CH_SHIELD_ID Int = 80475 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 40315 , @New_EU_DAGGER_ID Int = 80315 , --@European Dagger
@Old_EU_XBOW_ID Int = 40399 , @New_EU_XBOW_ID Int = 80399 , --@European CrossBow
@Old_EU_AXE_ID Int = 40378 , @New_EU_AXE_ID Int = 80378 , --@European Axe
@Old_EU_SWORD_ID Int = 40336 , @New_EU_SWORD_ID Int = 80336 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 40357 , @New_EU_TSWORD_ID Int = 80357 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 40441 , @New_EU_TSTAFF_ID Int = 80441 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 40483 , @New_EU_STAFF_ID Int = 80483 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 40420 , @New_EU_DSTAFF_ID Int = 80420 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 40462 , @New_EU_HARP_ID Int = 80462 , --@European Harp
@Old_EU_SHIELD_ID Int = 40504 , @New_EU_SHIELD_ID Int = 80504 --@European Shield
--------------------------------------------------------------------------------------------
Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)
-- Start Lock system :
-- First Case :
-- IF Item has not advanced elixir :
IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = @OldOptLevel - @OptDifference
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End
-- Second Case :
-- IF Item has advanced elixir :
ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End
كود:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15Unlock] Script Date: 11/3/2015 8:02:10 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_HamzaLockSystemD15Unlock]
@CharID Int
As
-- Declare expression.
Declare @CreaterName Varchar(60) = 'Figozz' , -- Creater Name
@Slot Int = '13' , -- char inventory slot 1.
@ReqOptLevel Int = '0' , -- Requiared Opt Level to upgrade
@OptDifference Int = '2' , -- Set the difference optlevel between old plus and new plus.
@OldOptLevel Int ,
@NewOptLevel Int ,
@AdvValue Int ,
@ID64 Int ,
-------------------------
-- Set Old and New Item RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'
---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 80370 , @New_CH_SWORD_ID Int = 39370 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 80391 , @New_CH_BLADE_ID Int = 39391 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 80412 , @New_CH_SPEAR_ID Int = 39412 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 80433 , @New_CH_TBLADE_ID Int = 39433 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 80454 , @New_CH_BOW_ID Int = 39454 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 80475 , @New_CH_SHIELD_ID Int = 39475 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 80315 , @New_EU_DAGGER_ID Int = 40315 , --@European Dagger
@Old_EU_XBOW_ID Int = 80399 , @New_EU_XBOW_ID Int = 40399 , --@European CrossBow
@Old_EU_AXE_ID Int = 80378 , @New_EU_AXE_ID Int = 40378 , --@European Axe
@Old_EU_SWORD_ID Int = 80336 , @New_EU_SWORD_ID Int = 40336 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 80357 , @New_EU_TSWORD_ID Int = 40357 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 80441 , @New_EU_TSTAFF_ID Int = 40441 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 80483 , @New_EU_STAFF_ID Int = 40483 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 80420 , @New_EU_DSTAFF_ID Int = 40420 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 80462 , @New_EU_HARP_ID Int = 40462 , --@European Harp
@Old_EU_SHIELD_ID Int = 80504 , @New_EU_SHIELD_ID Int = 40504 --@European Shield
--------------------------------------------------------------------------------------------
Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)
-- Start Lock system :
-- First Case :
-- IF Item has not advanced elixir :
IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = @OldOptLevel - @OptDifference
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End
-- Second Case :
-- IF Item has advanced elixir :
ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End
1 SN_ITEM_CHAOS_LOCK Lock Scroll
1 SN_ITEM_CHAOS_LOCK_TT_DESC <sml2>This scroll will LOCK your items to avoid to be scammed. <br><br><font color="255,255,255,0">How to use:</font><br>-Put ur item at the first slot in ur inventory (LEFT)<br>- Use the scroll. Regards from [GM] Figoz</sml2>
1 SN_ITEM_CHAOS_UNLOCK UNLock Scroll
1 SN_ITEM_CHAOS_UNLOCK_TT_DESC <sml2>This scroll will unlock your items, so u can trade/sell it.<br><br><font color="255,255,255,0">How to use:</font><br>-Put ur item at the first slot in ur inventory (LEFT)<br>- Use the scroll. Regards from [GM] Figoz</sml2>
وبخصوص البلاص تم عمل الصح ^^ من برنامج Zealous
كدة زي isro بالظبط. لو الاكونت بتاعك مع السيرفر كله متخافش علية
[YOUTUBE]4vhDJxMHplw[/YOUTUBE]
Regards
أستاذ حمزه أنا عملت الرساله دي بس ماإشتغلتش وبالرغم إنى مفيش حاجه ناقصه ... ممكن رد
المشاركة الأصلية كتبت بواسطة Hamza FiGo
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
25 ثانية كمقدمة كتير ^^ دا اولا
ثانيا السيستم جميل وسهل علي ان الناس تفهمه . تسلم ايدك
بس انت موضحتش في الفيديو ازاي كل شخصية تعمل كلمة السر
حبيبي يا حمزة
اولا - المقدمة انا لسه شغال عليه علشان كدة هي طويلة شويه
ثانيا - انا شغال ب Secret Word و ممكن يشتغل ب Email كمان
ثالثا - انا حنزل السيستم كامل في موضوع قريب علشان Dangers SrO كان طلبه مني
المشاركة الأصلية كتبت بواسطة HLP
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
حبيبي يا حمزة
اولا - المقدمة انا لسه شغال عليه علشان كدة هي طويلة شويه
ثانيا - انا شغال ب Secret Word و ممكن يشتغل ب Email كمان
ثالثا - انا حنزل السيستم كامل في موضوع قريب علشان Dangers SrO كان طلبه مني
شكرا يا رامي انا كنت شغال عليه
علشان انا قولت انك تنشتني بس شكرا اوي ومستنيك
16-11-2015, 07:02 AM
المواضيع المتشابهه
.gif){kind=icon}
العرض العادي
