Printable View
Hey all,
how you can read on top, i'm searching for an query how can add more then one item in one query to monster.
I got an query to add ONE item to monster but it would be great if someone can give me an query to add more items in same query.
Ow and maybe anyone know an query to add more spawnpoints for one unique without getting dobble spawn.
For example: I've add kidemonas on two positions, but when no one kill kidemonas, it spawnes one times on every position i've add.
Thx for help!
Use this Query
PHP Code:USE SRO_VT_SHARD_INIT
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
SET @MonsterID = 24160 -- You can find Monster ID's at RefObjCommon
SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course
SET @ItemID = 35773 -- You can find Item ID's at RefObjCommon
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, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
okay so far i was before too :D But how can i add more then only ID "35773" it's like "35773 35774" or "35773, 35774" or how i need to cut them?! If i want more then one item but only one queryQuote:
Originally Posted by adminsxza
Okay need help xD tried out something but wasn't the right way...
Quote:
USE/**/[SRO_VT_SHARD_INT]/**/
--Credits to Hean
/*Edited By nukertube*/
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = 'MOB_JUPITER_TEMPLE_PROTECTION'
SET @Item = 'ITEM_EU_SWORD_13_A_RARE'
SET @DropAmountMin = 0 /*Drop Min*/
SET @DropAmountMax = 1 /*Drop Max*/
SET @DropRatio = 1 /*0.5 = '50%' */
--------------------------------------------------------------------------
SET @MonsterID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/
SET @ItemID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
INSERT [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)/**/
VALUES(@MonsterID,@ItemID,0,0,@DropAmountMin,@DropAmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/
But want to add more then one item to monster
query drop.txt drop query
query search Item id.txt search item id query
query search mob id.txt search mob id query
have fun :)
I know that querys but i need a query to add two or more items in same queryQuote:
Originally Posted by bestprem
i need query add drop from all mobs too :D xDQuote:
Originally Posted by Jason1990