|
You last visited: Today at 18:33
Advertisement
Database vehalla help drop rate
Discussion on Database vehalla help drop rate within the SRO Private Server forum part of the Silkroad Online category.
11/29/2018, 13:23
|
#1
|
elite*gold: 0
Join Date: Mar 2015
Posts: 175
Received Thanks: 16
|
Database vehalla help drop rate
I need to change sox drop rate from Medusa Only
MOB_TQ_WHITESNAKE
Need to drop 1 sun every1 Medusa
|
|
|
11/29/2018, 16:56
|
#2
|
elite*gold: 235
Join Date: Apr 2016
Posts: 321
Received Thanks: 109
|
Quote:
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
|
|
|
11/29/2018, 19:50
|
#3
|
elite*gold: 208
Join Date: May 2017
Posts: 883
Received Thanks: 159
|
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
|
|
|
11/29/2018, 20:11
|
#4
|
elite*gold: 100
Join Date: Sep 2017
Posts: 1,097
Received Thanks: 889
|
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.
|
|
|
11/29/2018, 20:11
|
#5
|
elite*gold: 235
Join Date: Apr 2016
Posts: 321
Received Thanks: 109
|
Quote:
Originally Posted by [GM]Dejo
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
Quote:
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
|
|
|
11/29/2018, 23:23
|
#6
|
elite*gold: 100
Join Date: Sep 2017
Posts: 1,097
Received Thanks: 889
|
Quote:
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.
|
|
|
11/30/2018, 00:20
|
#7
|
elite*gold: 350
Join Date: Aug 2015
Posts: 1,999
Received Thanks: 1,184
|
Quote:
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
|
|
|
11/30/2018, 03:28
|
#8
|
elite*gold: 100
Join Date: Sep 2017
Posts: 1,097
Received Thanks: 889
|
There's a bunch of ways. Like, creating an SQL trigger on the game server logging table then using your 2 lines query.
|
|
|
11/30/2018, 05:41
|
#9
|
elite*gold: 350
Join Date: Aug 2015
Posts: 1,999
Received Thanks: 1,184
|
Quote:
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
|
|
|
11/30/2018, 09:31
|
#10
|
elite*gold: 235
Join Date: Apr 2016
Posts: 321
Received Thanks: 109
|
****, 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
|
|
|
11/30/2018, 13:30
|
#11
|
elite*gold: 100
Join Date: Sep 2017
Posts: 1,097
Received Thanks: 889
|
Quote:
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.
Quote:
Originally Posted by Duty*
Need to drop 1 sun every1 Medusa
|
|
|
|
11/30/2018, 13:36
|
#12
|
elite*gold: 235
Join Date: Apr 2016
Posts: 321
Received Thanks: 109
|
Quote:
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
|
|
|
11/30/2018, 14:13
|
#13
|
elite*gold: 100
Join Date: Sep 2017
Posts: 1,097
Received Thanks: 889
|
Quote:
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.
|
|
|
11/30/2018, 14:36
|
#14
|
elite*gold: 350
Join Date: Aug 2015
Posts: 1,999
Received Thanks: 1,184
|
Quote:
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.
|
Quote:
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
Quote:
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)
|
|
|
11/30/2018, 14:55
|
#15
|
elite*gold: 235
Join Date: Apr 2016
Posts: 321
Received Thanks: 109
|
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
|
|
|
All times are GMT +2. The time now is 18:33.
|
|