مشكله فى الdata

الحالة
مغلق و غير مفتوح للمزيد من الردود.
E

eslambmz

عضو
21 فبراير 2017
15
0
1
المنيا

المستوي:

  • #1
    كل لمه ازى اعمل Restore يجبلى كدة
    423261115.png
     




    الحل
    UnCle ShaKro

    المستوي:

    رد: مشكله فى الdata

    USE SRO_VT_SHARD
    DECLARE @Place VARCHAR(MAX),@Drop VARCHAR(MAX),@Rate real,@rows int = 0,@MinAmount int,@MaxAmount int,@RowsCount int
    ,@MobCode varchar(max),@ID int,@ItemID int
    -------------------------------------------------------------------------------
    SET @Place = 'JG' -- your desired area Jangan = JG, Donwhang = DW, Hotan = HT, Alex = AX, JobTemple = TP
    SET @Drop = 'Code el item' --Item CodeName
    SET @Rate = '1' -- Drop Rate
    SET @MinAmount = '1' --Minimum amount of item
    SET @MaxAmount = '1' --Max amount of item
    -------------------------------------------------------------------------------
    IF @Place = 'JG'
    BEGIN
    SET @RowsCount = (SELECT COUNT(CodeName128) From...
    ترتيب حسب التاريخ ترتيب حسب الأصوات
    UnCle ShaKro

    UnCle ShaKro

    عضو
    20 أبريل 2017
    16
    1
    0
    1
    بنها

    المستوي:

  • #5
    رد: مشكله فى الdata

    USE SRO_VT_SHARD
    DECLARE @Place VARCHAR(MAX),@Drop VARCHAR(MAX),@Rate real,@rows int = 0,@MinAmount int,@MaxAmount int,@RowsCount int
    ,@MobCode varchar(max),@ID int,@ItemID int
    -------------------------------------------------------------------------------
    SET @Place = 'JG' -- your desired area Jangan = JG, Donwhang = DW, Hotan = HT, Alex = AX, JobTemple = TP
    SET @Drop = 'Code el item' --Item CodeName
    SET @Rate = '1' -- Drop Rate
    SET @MinAmount = '1' --Minimum amount of item
    SET @MaxAmount = '1' --Max amount of item
    -------------------------------------------------------------------------------
    IF @Place = 'JG'
    BEGIN
    SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
    (select dwobjid from Tab_RefTactics where dwTacticsID in
    (select dwTacticsID from Tab_RefNest where nRegionDBID in
    (select wregionid from _refregion where ContinentName like 'CHINA'))) and CodeName128 like '%MOB_%')
    while (@rows < @RowsCount) BEGIN
    set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
    set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
    set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
    INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
    END
    Print ''+@Drop+' has been added to Jangan Mobs Successfully!'
    END
    ELSE IF @Place = 'DW'
    BEGIN
    SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
    (select dwobjid from Tab_RefTactics where dwTacticsID in
    (select dwTacticsID from Tab_RefNest where nRegionDBID in
    (select wregionid from _refregion where ContinentName like 'West_China'))) and CodeName128 like '%MOB_%')
    while (@rows < @RowsCount) BEGIN
    set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
    set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
    set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
    INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
    END
    Print ''+@Drop+' has been added to Donwhang Mobs Successfully!'
    END
    ELSE IF @Place = 'HT'
    BEGIN
    SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
    (select dwobjid from Tab_RefTactics where dwTacticsID in
    (select dwTacticsID from Tab_RefNest where nRegionDBID in
    (select wregionid from _refregion where ContinentName like 'Oasis_Kingdom'))) and CodeName128 like '%MOB_%')
    while (@rows < @RowsCount) BEGIN
    set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
    set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
    set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
    INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
    END
    END
    ELSE IF @Place = 'AX'
    BEGIN
    SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
    (select dwobjid from Tab_RefTactics where dwTacticsID in
    (select dwTacticsID from Tab_RefNest where nRegionDBID in
    (select wregionid from _refregion where ContinentName like '%DELTA%' or ContinentName like '%SD%' or ContinentName like '%Pharaoh%' or ContinentName like '%KingsValley%'))) and CodeName128 like '%MOB_%')
    while (@rows < @RowsCount) BEGIN
    set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
    set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
    set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
    INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
    END
    Print ''+@Drop+' has been added to Alexandria Mobs Successfully!'
    END
    ELSE IF @Place = 'TP'
    BEGIN
    SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
    (select dwobjid from Tab_RefTactics where dwTacticsID in
    (select dwTacticsID from Tab_RefNest where nRegionDBID in
    (select wregionid from _refregion where ContinentName like '%TEMPLE%'))) and CodeName128 like '%MOB_%')
    while (@rows < @RowsCount) BEGIN
    set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
    set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
    set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
    INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
    END
    Print ''+@Drop+' has been added to Temple Mobs Successfully!'
    END
     




    تأييد 0 تصويت سلبي
    الحل
    الحالة
    مغلق و غير مفتوح للمزيد من الردود.

    كلمة مدير الموقع

    بسم الله الرحمن الرحيم تم اعادة فتح المنتدي بطريقة حديثة متزامنه مع تطورات المواقع وتطبيقات الويب الحديثة وهيتم تحديث المنتدي اول بأول واضافة نظم وطرق جديده اول ب اول ومتابعه الاعضاء النشطين مع نظام مكافئات هعلن عنه قريب ..
    أعلى أسفل
    قائمة