Jump to content

Setting Drop via Mysql Tables


Recommended Posts

  • Developer
14 hours ago, OtherChoice said:

Oh I see, thank you for your time and collaboration.

Regards

And about cache sharing, we could make that but then we need to use method of unconcurrency to make sure the cores access to memory one for time. To make this caching system is useless if done just for this system. it make sense only if you want a big shared cache to use for every game stuff.

When ymir coded this game, the cache sharing wasn't a standard method, so they decided to use the socket between cores to send "cache part" to other cores, and to make a different cache for every core. When i say cache i mean a method to store info, so about your last question, yeah the best way is to allocate the cache in the heap because there is enoght memory space.The stack relative to heap can allocate directly when the compiler compile the program but the stack size is very limited, the heap can allocate a lot of memory without problem but the allocation is a dynamic allocation so the performaces during the allocation will be smaller.

 

My youtube channel  on which you can see my works here

Link to comment
Share on other sites

Yeah after looking deeply into the code it was pretty clear.

I think the best way to achieve what I want, have every core read (only) a said memory region without refactoring everything is to use db to broadcasts pointer to vector of pointers to game binary instances.

1 hour ago, Ikarus_ said:

And about cache sharing, we could make that but then we need to use method of unconcurrency to make sure the cores access to memory one for time. To make this caching system is useless if done just for this system. it make sense only if you want a big shared cache to use for every game stuff.

When ymir coded this game, the cache sharing wasn't a standard method, so they decided to use the socket between cores to send "cache part" to other cores, and to make a different cache for every core. When i say cache i mean a method to store info, so about your last question, yeah the best way is to allocate the cache in the heap because there is enoght memory space.The stack relative to heap can allocate directly when the compiler compile the program but the stack size is very limited, the heap can allocate a lot of memory without problem but the allocation is a dynamic allocation so the performaces during the allocation will be smaller.

 

 

Link to comment
Share on other sites

  • Developer
22 minutes ago, Syriza said:

Hey @Ikarus_  thank you for the release Buddy im using it but

you cant place in probability Point numbers. e.g.: prob: 1.5 (This is very important :S)

 

the drop tables takes by default chance on 1/1000 (so to make chance 0.1% just add 1 as number)
you can change the scale to make chance on 1/10.000 or 1/100.000 by changing the number in length.h DROP_SCALE_TABLE

so you can for example make the drop scale on 10.000 and to make 0.01% chance you need to insert in table 1 as number
if you need 0.001% chance , you can change drop scale on 100.000 and then you need to insert in table 1 as number

warning
max drop scale is 1.000.000 (if you put number > the game automatically reduce it)  because ymir using milions as scale to make drop random numbers.

 

  • Love 1

My youtube channel  on which you can see my works here

Link to comment
Share on other sites

vor 48 Minuten schrieb Ikarus_:

the drop tables takes by default chance on 1/1000 (so to make chance 0.1% just add 1 as number)
you can change the scale to make chance on 1/10.000 or 1/100.000 by changing the number in length.h DROP_SCALE_TABLE

so you can for example make the drop scale on 10.000 and to make 0.01% chance you need to insert in table 1 as number
if you need 0.001% chance , you can change drop scale on 100.000 and then you need to insert in table 1 as number

warning
max drop scale is 1.000.000 (if you put number > the game automatically reduce it)  because ymir using milions as scale to make drop random numbers.

 

 

ahhh thank you! indeed it is thousand times better then working on those shitty text files. :)

 

 

Would be sick if we can get mob_drop_item & Special_drop_item converter 

 

edit: i have a improvement, how About a map_index column at the tables? example: Sword+9 is only dropable in map_index 41

Link to comment
Share on other sites

  • 2 weeks later...
  • Developer

Added a small fix about 0.X% in mob_drop_item.txt
now you can use 0.X% in the txt files before to convert it but there is a limit.

the limit depend on the DROP_SCALE_TABLE value (CONSTANT) 

for example :
DROP_SCALE_TABLE = 1000 -> min chance to set in txt 0.1% (100%/1000)
DROP_SCALE_TABLE = 10000 -> min chance to set in txt 0.01% (100%/10000)

 

obv DROP_SCALE_TABLE must be same value of DROP_SCALE_TABLE in common/length.h (SEE THE THREAD MESSAGE TO KNOW WHAT IS THIS CONSTANT)

  • Love 1

My youtube channel  on which you can see my works here

Link to comment
Share on other sites

vor 51 Minuten schrieb Ikarus_:

Added a small fix about 0.X% in mob_drop_item.txt
now you can use 0.X% in the txt files before to convert it but there is a limit.

the limit depend on the DROP_SCALE_TABLE value (CONSTANT) 

for example :
DROP_SCALE_TABLE = 1000 -> min chance to set in txt 0.1% (100%/1000)
DROP_SCALE_TABLE = 10000 -> min chance to set in txt 0.01% (100%/10000)

 

obv DROP_SCALE_TABLE must be same value of DROP_SCALE_TABLE in common/length.h (SEE THE THREAD MESSAGE TO KNOW WHAT IS THIS CONSTANT)

Target Info is showing the Drops but sometimes few Items arent listed for example: Player clicked one time on Monster ?-Info dont saw sword+9 clicked again and it was there.. could you please help Bro ? 

Link to comment
Share on other sites

  • Developer
18 hours ago, Sumnix said:

Is any plugin installed?

no, if you want help you should show the error

18 hours ago, Syriza said:

Target Info is showing the Drops but sometimes few Items arent listed for example: Player clicked one time on Monster ?-Info dont saw sword+9 clicked again and it was there.. could you please help Bro ? 

you should give some other info, for example which table are you mean (and so, what kind of drop method are you using)  ?

  • Love 1

My youtube channel  on which you can see my works here

Link to comment
Share on other sites

  • Developer
On 6/12/2019 at 9:45 PM, Sumnix said:

gwl_hinstance

Ekran-Al-nt-s.png

If the project using a SDK not installed you should change it in Project properties
Let me know if solved or not and i apologize for my late

Edited by Metin2 Dev
Core X - External 2 Internal

My youtube channel  on which you can see my works here

Link to comment
Share on other sites

  • 2 weeks later...

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.