Database vehalla help drop rate

Page 1 of 2 1 2
11/29/2018 13:23 Duty*#1
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 MrCatGardens#2
Quote:
Originally Posted by Duty* View Post
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 Worshiper#3

try this query
11/29/2018 20:11 #HB#4
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 MrCatGardens#5
Quote:
Originally Posted by [GM]Dejo View Post

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 View Post
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 #HB#6
Quote:
Originally Posted by infinityProject View Post
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 B1Q#7
Quote:
Originally Posted by #HB View Post
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 #HB#8
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 B1Q#9
Quote:
Originally Posted by #HB View Post
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 MrCatGardens#10
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
11/30/2018 13:30 #HB#11
Quote:
Originally Posted by B1Q View Post
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* View Post
Need to drop 1 sun every1 Medusa
11/30/2018 13:36 MrCatGardens#12
Quote:
Originally Posted by #HB View Post
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 #HB#13
Quote:
Originally Posted by infinityProject View Post
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 B1Q#14
Quote:
Originally Posted by #HB View Post
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 View Post
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 View Post
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 MrCatGardens#15
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
Page 1 of 2 1 2