Database vehalla help drop rate

[Duty*]

I need to change sox drop rate from Medusa Only
MOB_TQ_WHITESNAKE
Need to drop 1 sun every1 Medusa

[MrCatGardens]

Originally Posted by Duty*

I need to change sox drop rate from Medusa Only
MOB_TQ_WHITESNAKE
Need to drop 1 sun every1 Medusa

1. you need to create a dropgroup at (i think _refdropitemgroup)
2. Assign itemids to this created dropgroup (i think _refdropitemassign) with droprate and amount
3. add the group from step 1 to (dunno exactly the name) _refmonsteritem_randomdrop (something like this fancy name, you'll find it), again with droprate for the whole group

thats it

[Worshiper]

 Spoiler

USE SRO_VT_SHARD
GO

DECLARE @ID int
DECLARE @ID int
DECLARE @atio real



SET @ID = 3810 -------- Mob,Unique ID you want Add Drop in
SET @atio = 1 -------- Item drop rate 1=100% , 0.3 = 30%
SET @ID = 24165 -------- ITEM ID You want Add in Drops


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 @ID , @ID, 0, 0, 1, 1, @atio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , '***')

try this query

[#HB]

You can create a table with possibilities and pick a random item from it, that might require a filter or a system bot. I am not sure if you can do it with the normal dropping functions.

[MrCatGardens]

Originally Posted by [GM]Dejo

 Spoiler

USE SRO_VT_SHARD
GO

DECLARE @ID int
DECLARE @ID int
DECLARE @atio real



SET @ID = 3810 -------- Mob,Unique ID you want Add Drop in
SET @atio = 1 -------- Item drop rate 1=100% , 0.3 = 30%
SET @ID = 24165 -------- ITEM ID You want Add in Drops


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 @ID , @ID, 0, 0, 1, 1, @atio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')

try this query

I don't recommend to use this query. It's for single drops like an Immostone @ Medusa but not for specif itemGROUPS like 1 out of 30 SUN-Items.
Just create a dropgroup and assign the whole group to 1 mob.

dunno how i could explain it better. just take a look at the tables i mentioned above, you'll see the difference

Originally Posted by #HB

You can create a table with possibilities and pick a random item from it.

Theres already a table for that... _RefDropItemAssign With probability per item

[#HB]

Originally Posted by infinityProject

Theres already a table for that... _RefDropItemAssign With probability per item

He wants the guy who killed the unique to get one of sun items, you don't get it.

[B1Q]

Originally Posted by #HB

He wants the guy who killed the unique to get one of sun items, you don't get it.

Except that he never said it. you're drawing the wrong conclusion and that's not helping.
Even so, telling him "YOU NEED FILTER OR A BOT" is ridiculous. capturing unique kills is easier than you think.
giving the killer rewards is a 2 lines query

[#HB]

There's a bunch of ways. Like, creating an SQL trigger on the game server logging table then using your 2 lines query.

[B1Q]

Originally Posted by #HB

There's a bunch of ways. Like, creating an SQL trigger on the game server logging table then using your 2 lines query.

He didn't specifically say "i want to reward the killer"
you're making things up.
a trigger is not the way to go

[MrCatGardens]

****, small mistake by myself... if you want him to drop 1 out of x item, you could create a box. then by random youll reward him with an item from a "itempool".

if you need help, just ask i can give you an example

[#HB]

Originally Posted by B1Q

He didn't specifically say "i want to reward the killer"
you're making things up.
a trigger is not the way to go

I am not sure if you can't read or you're blind.

Originally Posted by Duty*

Need to drop 1 sun every1 Medusa

[MrCatGardens]

Originally Posted by #HB

I am not sure if you can't read or you're blind.

1 sun... thats right. but theres not only 1 sunitem. There are around 100 in 10th dg. the regular _refdropitemassign can't help you here.

easiest (and most flexible) way: create a box, some lines to addlogitem and let the sp find a 10dg sun item randomly

edit: absolutely no filter required. only 1 new item + some lines to an already existent procedure

[#HB]

Originally Posted by infinityProject

1 sun... thats right. but theres not only 1 sunitem. There are around 100 in 10th dg. the regular _refdropitemassign can't help you here.

easiest (and most flexible) way: create a box, some lines to addlogitem and let the sp find a 10dg sun item randomly

edit: absolutely no filter required. only 1 new item + some lines to an already existent procedure

lol??

I already know that! And I said that above, but B1Q doesn't get it, so I am trying to explain.

[B1Q]

Originally Posted by #HB

lol??

I already know that! And I said that above, but B1Q doesn't get it, so I am trying to explain.

Originally Posted by #HB

He wants the guy who killed the unique to get one of sun items, you don't get it.

You're contradicting your previous statements. that's gay

Originally Posted by infinityProject

damn, small mistake by myself... if you want him to drop 1 out of x item, you could create a box. then by random youll reward him with an item from a "itempool".

if you need help, just ask i can give you an example

he's trying to drop 1 sun item from every medusa, a random sun item
which has nothing to do with rewarding the killer or creating a "BOX"

this dude #HP is confusing you. wait until OP replies and states what he exactly wants to do (which is in the 1st post and it is as clear as the two middlefingers in my profile pic)

[MrCatGardens]

i know what he wants. he wants to let medusa drop one sun-item per kill. if you use the iteassign, its possible that she can drop 2 or 3 or x different suns since you specify the droprate per single item.
even if there are -lets say- 100 possible sun items, with a droprate of 1% each, its possible to get 20 suns at 1 kill.

imho its only possible with a box or scroll or w/e including a sp

correct if im wrong