Hello Vsro Family
In this topic, I will explain to you in detail how to add items with Mob Drop Group . The steps we will follow in order are as follows;
Tables We Will Operate: _RefMonster_AssignedItemRndDrop and _RefDropItemGroup Tables.
Step 1: First, we set the groups to be added to the mob in the _RefMonster_AssignedItemRndDrop Table.
*** Hidden text: cannot be quoted. ***
Directly Copy the Above Code and Paste it into SQL.
RED COLOR: Group ID we will create
YELLOW COLOR: The Group Name You Set ( NOTE: It Must Be the Same as the Group Name We Will Enter in the _RefDropItemGroup Table.)
GREEN COLOR: Minimum Value of the Item to Drop from the Mob
PURPLE COLOR: Maximum Value of the Item to Drop from the Mob
BLACK COLOR: Drop Rate of Item in Mob (ex: We set 0.001 for 1 in 1000 mobs)
PINK COLOR: Which Mobs You Want to Add, You Will Write the Mob Code Added to RefObjCommon
NOTE: Rate Transactions have 2 Stages, Detailed Explanation is Available in the 2nd Step
NOTE: Bulk Mob Codes
*** Hidden text: cannot be quoted. ***
*** Hidden text: cannot be quoted. ***
*** Hidden text: cannot be quoted. ***
NOTE 2: If you only want to add it to Uniqs, just write and Rarity=3 at the end of the Mob Codes above.
Örneğin; select * from _RefObjCommon where CodeName128 like 'MOB_GOD%' and Rarity=3
*** Hidden text: cannot be quoted. ***
Picture Example: In this way, you will select the Uniqs
Result: After Execute, We Copy the Results and Paste them into the _RefMonster_AssignedItemRndDrop Table
STEP 2: In this step, we are operating in the _RefDropItemGroup Table. Here is the Item Section that will be added to the mob.
We are setting _RefMonster_AssignedItemRndDrop Linked to This Table
*** Hidden text: cannot be quoted. ***
Copy the Code Above and Paste it by Opening New Query in SQL
Meanings of the Colors in the Code Mentioned Above
RED COLOR: Group IDs we added
NOTE: _RefMonster_AssignedItemRndDrop MUST BE THE SAME ID WITH THE ID YOU ADDED HERE OTHERWISE GAMESERVER WILL NOT OPEN!!!!
YELLOW COLOR: The Group Name You Added
NOTE: _RefMonster_AssignedItemRndDrop MUST BE THE SAME AS THE GROUP NAME YOU ADDED HERE , OTHERWISE GAMESERVER WILL NOT OPEN!!!!
GREEN COLOR: Item's Drop Rate Let me explain it like this: For example, _RefMonster_AssignedItemRndDrop. The rate you set when you added it to this table was the rate for the item to leave the mob, but if the rate you set in this is, let's say, the rate you added to the mob table was 10%, it was 10%, the item will drop. The rate you set here is after the item rates in the mob match. The item will have a drop rate, so to give an example, I set the drop, gave 50% to the mob, and added a Set to that mob. How many items are there in the set? There are 36 items. These 36 items are entered individually or collectively, for example, I will set the rates of the headrests to 100%, that is, 1. When I do this, 36 items are added. Why do the headrests appear the most among the items, because we made it 1 and the others lower, so no matter what you do with the rate in this table, as long as it keeps the rate you set from the mob, the rate of the item in this table does not matter, it will decrease. Friends who know a lot understood what I said and will do it easily. Those who do not know have the opportunity to learn in detail.
PINK COLOR: This is where you write the item code you want to add. I put that code as an example. Thanks to that code, all the weapon sets are listed for you without separating acc china eu.
NOTE: Only For Chinese SWler
*** Hidden text: cannot be quoted. ***
Use this code. In this way, Eu extracts the items and sorts the item.
If you want to add the code yourself, paste " and CodeName128 not like 'ITEM_EU%' ' " Your Code at the End of the Code I gave in Step 2.
*** Hidden text: cannot be quoted. ***
PICTURE 2: Chinese and European Items Red Square
After scanning the codes, copying the results and pasting them into the _RefDropItemGroup table, the whole process is completed. Now you can set the drop group as you wish.
