Global Droprates

09/10/2012 22:41 mabejenta#1
I've been searching to figure out how the actual global droprates works, because I have heard allot about some Global droprate. People keep telling me to "Change global droprate to 2-4%", and I got no clue what people refer to when they say "global" droprate.

I've been searching around on the global droprates, but all I really find is global private servers, so it's getting quite annoying to try to search for it in different ways.

Like for eksample, my light and fury map 3 drop's lapisias, however, in dbo.mobitems there are no grade for those to drop, so I guess that is a part of the "global" droprates? I bet it is like a stored posedure or in the server files, but I'm not sure at all when it comes to the "global" stuff.

Please don't laugh if this is a silly question! :p
09/10/2012 22:50 retrogod#2
Quote:
Originally Posted by mabejenta View Post
I've been searching to figure out how the actual global droprates works, because I have heard allot about some Global droprate. People keep telling me to "Change global droprate to 2-4%", and I got no clue what people refer to when they say "global" droprate.

I've been searching around on the global droprates, but all I really find is global private servers, so it's getting quite annoying to try to search for it in different ways.

Like for eksample, my light and fury map 3 drop's lapisias, however, in dbo.mobitems there are no grade for those to drop, so I guess that is a part of the "global" droprates? I bet it is like a stored posedure or in the server files, but I'm not sure at all when it comes to the "global" stuff.

Please don't laugh if this is a silly question! :p
global shaiya as orginal os right now nexon/aeriagames owns is rate of 30-45% and then also 50 & 65% i haven't seen any others as i seen so far :)
09/10/2012 22:55 mabejenta#3
Quote:
Originally Posted by retrogod View Post
global shaiya as orginal os right now nexon/aeriagames owns is rate of 30-45% and then also 50 & 65% i haven't seen any others as i seen so far :)
Hun, I don't think you get my question. My english might have glitched all up, but what I'm looking for is the "global droprate" settings in the database or whereever it is located.

Because some of my drops have a tiny chance of dropping stuff that is not in the [PS_GameDefs].[dbo].[MobItems]....

Some of my drops are like lapisia's, and their dropping from map 3 both factions, and that drop are not in the database table what so ever.
09/10/2012 23:08 retrogod#4
Quote:
Originally Posted by mabejenta View Post
Hun, I don't think you get my question. My english might have glitched all up, but what I'm looking for is the "global droprate" settings in the database or whereever it is located.

Because some of my drops have a tiny chance of dropping stuff that is not in the [PS_GameDefs].[dbo].[MobItems]....

Some of my drops are like lapisia's, and their dropping from map 3 both factions, and that drop are not in the database table what so ever.
ah ok simple too
database>gamedefs>mobitems>add the MobID>RowID>grade>Percent in order easy.
09/10/2012 23:13 mabejenta#5
Quote:
Originally Posted by retrogod View Post
ah ok simple too
database>gamedefs>mobitems>add the MobID>RowID>grade>Percent in order easy.
Hunny, please read my post. I just said that it is NOT in the mobitems...
09/10/2012 23:20 TeddyBear94#6
globla could work when u add to all mobs the right grade for the item u want to let drop with adding the right percentage (i bet u cna do a easy script for doing that)
09/11/2012 00:44 mabejenta#7
Quote:
Originally Posted by TeddyBear94 View Post
globla could work when u add to all mobs the right grade for the item u want to let drop with adding the right percentage (i bet u cna do a easy script for doing that)
Hmm... yeah, your in on something there I guess. But I thought all drops would be visible in the freaken dbo.mobitems, but some of my drops arent. Which is getting really frustrating. There is prolly a stored posedure or something hiding the info somewhere... What do you think?
09/11/2012 01:17 JohnHeatz#8
I know what you are asking for, if I am not mistaken there is a command that can be set on the servermgr (where you put the /vchkoff /nprotectoff things) for the droprates, I might have to look for all the commands that work from there...

In the meanwhile, you can easily change the droprate on a "global way" by using a simple script, which will simply take the current drop rate and get the % you want to increase/decrease (simple mathematical rule) and UPDATE the droprate using that percentage.

I might try making a script for your needs, but can't promise it being soon though.
09/11/2012 23:12 mabejenta#9
Quote:
Originally Posted by JohnHeatz View Post
I know what you are asking for, if I am not mistaken there is a command that can be set on the servermgr (where you put the /vchkoff /nprotectoff things) for the droprates, I might have to look for all the commands that work from there...

In the meanwhile, you can easily change the droprate on a "global way" by using a simple script, which will simply take the current drop rate and get the % you want to increase/decrease (simple mathematical rule) and UPDATE the droprate using that percentage.

I might try making a script for your needs, but can't promise it being soon though.
Yes! Now we're talking John. I know there is some sort of command, or some sort of script somewhere to hide some global chance, but I'm so lost and just can't find that one. I know a friend who knows how to do it, however he is greedy and wont help out.
09/12/2012 05:40 cypherxxl#10
With this Query u can change the Global Rate of all Drops, that are in the range u chose

UPDATE PS_GameDefs.dbo.MobItems
SET DropRate=10
WHERE Droprate=1
09/12/2012 07:02 JohnHeatz#11
Yet this query is really a quick update which is not doing any sort of % based increase/decrease on the droprates.

To point mabejenta in the right direction I would suggest start coding a script which will capture the DropRate (all of them) and replace it using the common mathematical formula for taking an specific percentage of a number and replace the DropRate with the same DropRate increased or decreased by the desired percentage.
09/12/2012 09:37 cypherxxl#12
hm, that sounds nice.
09/13/2012 18:12 [Admin]Snuggle#13
Grade is not contained by mob items.
Grade is in the items themselves.
Which you can find in the items table if you scroll all the way to the right on the table.
That's where you would find the grade of the item.

I'm confused on what you are asking though as of global drop rates.
I'm guessing you want to increase the overall drop rate on each mob by 2% or something?
If I understood what you are really asking I could compose something for you as of a script that could adjust all those rates.
Yet like I said need to understand what you're asking o.O
09/13/2012 18:51 mabejenta#14
Quote:
Originally Posted by [Admin]Snuggle View Post
Grade is not contained by mob items.
Grade is in the items themselves.
Which you can find in the items table if you scroll all the way to the right on the table.
That's where you would find the grade of the item.

I'm confused on what you are asking though as of global drop rates.
I'm guessing you want to increase the overall drop rate on each mob by 2% or something?
If I understood what you are really asking I could compose something for you as of a script that could adjust all those rates.
Yet like I said need to understand what you're asking o.O
Okey, to explain on a big basis, I need to make one heck of a post. But here it goes.

In the Database you have several tabels. The dbo.items is the one to tell you in detail what the item is and what it does, what drop grade it has etc. On the "grade" you decide where it belongs, not where it drops.

Where it drops is decided in the dbo.mobitems ! So here is an example very detailed.

I kill monsters on map 3, and let's use MobID 503 as this example... Here is the 9 slots on the dbo.mobitems


Allright, so here is the thing. From dropslot 4-9 there are no drops.
Grade 361 = Dread Gear level 40+
Grade 8 = Pots
Grade 175 = Dread Weap level 40+

This is where the issue is. You guys can clarely see that there are no muffins with these grades. Here is the proof:

Grade 8 contains:


Grade 361 contains:


Grade 175 contains:

In these grades, and dbo.Mobitems table, you see no such thing as Armor and Power lapisia! BUT however, they still drop.

They drop in a VERY low rate, but they still drop. I even bulletproofed my clientside, and nothing in clientside is triggering those drops to actually drop.

I have been looking tought my logs when a player finds the drop, but there are no error, or record of these items dropping on map 3. I have been digging tough all kinds of wierd looking files I got no understanding of. I do, howver, know that there is a way to add drops to a "global" rate, to where entire maps will drop something, but NOT in the dbo.mobitems place.

I've been digging trough the forums, and google for ages, but I cannot find out where it is all comming from. I counted how big rate these two items are dropping in, and they are dropping at a 0.7% chance. Which is NOT possible to make trough the dbo.items, not that I know of at least.

You see where my issue is at now?

So I have been digging trought here, and I found something that I think might trigger something, and that was in the actual svmap files. Did you know that you can add mobs and drops trough those? I just figured that out, somehow... Not entirely sure on how to quite yet, but I know it's possible. Because many of my mobs and bosses are not in my obelisk, nor server files, and it still spawns. Which is wierd.

Do you guys now, understand what it is that I am trying to figure out?

[On a side note] Does anyone have server files such as map.ini and obelisk.ini translated? Mine's full of jiberish. Getting those files would make me forever happy.
09/13/2012 21:53 [Admin]Snuggle#15
Hmmm
I know the drops aren't grades :P
Grades are groups of items and the grades are used for drops.
The database contains all the data for things like this.
So it won't be server or client side.
It's possible it's just a bug within the server itself.
What I would say is just change your grade out of the 8/175/361 area.
I've never used the lower grades personally.
I've always used 800+
That's indeed an odd issue though.
I really don't know what would cause that unless the lapisia are hidden somewhere in the item table. :/
Which you stated you looked over it in depth so really not sure.