[RELEASE - QUERY] - CLONE MOB DROPS

[yoneh1]

Hey Guys,
Another quick query to get the drops from _RefDropItemAssign into your Mob of choice

USAGE:
exec _CloneMobDrops ID,NEWID

PHP Code:

USE [Y0GI]
GO
/****** Object:  StoredProcedure [dbo].[_CloneMobDrops]    Script Date: 6/17/2024 11:50:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_CloneMobDrops]
    @OldRefMonsterID INT,
    @NewRefMonsterID INT
AS
BEGIN
    -- Insert the cloned item drops
    INSERT INTO [dbo].[_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
    )
    SELECT 
        @NewRefMonsterID AS 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
    FROM 
        [dbo].[_RefMonster_AssignedItemDrop]
    WHERE 
        RefMonsterID = @OldRefMonsterID;
END 


If you find this usefull, Please hit Thanks!.