Add Drop Max mini With codename (Fixed )

08/08/2012 03:37 AllStarsTeam#1

i Edit fthis query to be esay and simple have fun :

PHP Code:


			
USE SRO_VT_SHARD

GO



DECLARE @MonsterID int

DECLARE @ItemID int

DECLARE @DropRatio real

DECLARE @DropAmount real

DECLARE @DropAmount1 real





SET @MonsterID = (select ID from _RefObjCommon where CodeName128 like 'MOB_SD_SETH') -- You can find Monster ID's at RefObjCommon

SET @ItemID = (select ID from _RefObjCommon where CodeName128 like 'ITEM_ETC_AMMO_ARROW_01') -- You can find Item ID's at RefObjCommon

SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course

SET @DropAmount =  3-- Chose ur amount Mini

SET @DropAmount1 =  5-- Chose ur amount Max



INSERT _RefMonster_AssignedItemDrop 

(

RefMonsterID,

RefItemID,

DropGroupType,

OptLevel,

DropAmountMin,

DropAmountMax,

DropRatio,

RefMagicOptionID1,

CustomValue1,

RefMagicOptionID2,

CustomValue2,

RefMagicOptionID3,

CustomValue3,

RefMagicOptionID4,

CustomValue4,

RefMagicOptionID5,

CustomValue5,

RefMagicOptionID6,

CustomValue6,

RefMagicOptionID7,

CustomValue7,

RefMagicOptionID8,

CustomValue8,

RefMagicOptionID9,

CustomValue9,

RentCodeName

) 

VALUES(@MonsterID ,   @ItemID, 0,          0,        @DropAmount,             @DropAmount1,             @DropRatio,           0,                 0,           0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0 ,                0 ,           'xxx')

08/08/2012 09:33 ahmed4ever2u#2

a better version

Spoiler

PHP Code:


			
--##########################All credits goes to the orginal writer !####################################################################################################################################################

USE SRO_VT_SHARD                                                                                                                                                                                                     --#

GO                                                                                                                                                                                                                   --#

        DECLARE                                                                                                                                                                                                      --#

            @MonsterID int,@ItemID int,@DropRatio real,@DropAmount real,@DropAmount1 real,@CodeName_item VARCHAR (100)                                                                                               --#

            ,@CodeName_Monster VARCHAR (100)                                                                                                                                                                         --#

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@                                                                                                                                 --#

        SET @CodeName_item = 'ITEM_ETC_AMMO_ARROW_01'                            --@                                                                                                                                 --#

        SET @CodeName_Monster = 'MOB_SD_SETH'                                    --@                                                                                                                                 --#

        SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course          --@                                                                                                                                 --#

        SET @DropAmount =  3-- Chose ur amount Mini                              --@                                                                                                                                 --#

        SET @DropAmount1 =  5-- Chose ur amount Max                              --@                                                                                                                                 --#

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@                                                                                                                                 --#

                                                                                                                                                                                                                     --#

    SET @MonsterID = (select ID from _RefObjCommon where CodeName128 = @CodeName_Monster)                                                                                                                            --#

    SET @ItemID = (select ID from _RefObjCommon where CodeName128 = @CodeName_item)                                                                                                                                  --#

        INSERT _RefMonster_AssignedItemDrop                                                                                                                                                                          --#

            (RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3,                       --#

            RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName)  --#

        VALUES(@MonsterID ,@ItemID,0,0,@DropAmount,@DropAmount1,@DropRatio,0,0,0,0,0,0,0,0,0,0,0, 0, 0, 0, 0, 0, 0 ,0 ,'xxx')                                                                                        --#

--######################################orginzed By ahmed4ever2u########################################################################################################################################################

08/08/2012 11:01 IceAmStiel#3

in my opinion the first one is actually clearer structured ;o

08/08/2012 14:15 sarkoplata#4

Quote:

Originally Posted by ahmed4ever2u

a better version

Spoiler

PHP Code:

--##########################All credits goes to the orginal writer !#################################################################################################################################################### USE SRO_VT_SHARD --# GO --# DECLARE --# @MonsterID int,@ItemID int,@DropRatio real,@DropAmount real,@DropAmount1 real,@CodeName_item VARCHAR (100) --# ,@CodeName_Monster VARCHAR (100) --# --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --# SET @CodeName_item = 'ITEM_ETC_AMMO_ARROW_01' --@ --# SET @CodeName_Monster = 'MOB_SD_SETH' --@ --# SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course --@ --# SET @DropAmount = 3-- Chose ur amount Mini --@ --# SET @DropAmount1 = 5-- Chose ur amount Max --@ --# --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --# --# SET @MonsterID = (select ID from _RefObjCommon where CodeName128 = @CodeName_Monster) --# SET @ItemID = (select ID from _RefObjCommon where CodeName128 = @CodeName_item) --# INSERT _RefMonster_AssignedItemDrop --# (RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3, --# RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName) --# VALUES(@MonsterID ,@ItemID,0,0,@DropAmount,@DropAmount1,@DropRatio,0,0,0,0,0,0,0,0,0,0,0, 0, 0, 0, 0, 0, 0 ,0 ,'xxx') --# --######################################orginzed By ahmed4ever2u########################################################################################################################################################

That '@' '#' comment lines actually doesn't make the code better.

08/08/2012 14:44 intercsaki#5

Quote:

All credits goes to the orginal writer!

I lol'd...