[Guide] How to Edit Alchemy Success Rates in vSRO
Easy Method – Full Control Without Complex Queries
Introduction
Hello everyone,
Many people use complicated queries to change alchemy success rates, but there's an easier way that gives you full control over each enhancement level. You can make alchemy easier, harder, or even allow enhancements beyond +12!
In this guide, I'll show you how to modify the alchemy rates directly in the _RefObjItem table. No complex scripts – just simple edits.
Step 1: Locate the Correct Table and Rows
- Open SQL Server Management Studio.
- Connect to your database.
- Navigate to:
- You need to edit rows with IDs 2033 to 2044. These correspond to the alchemy stones.
Step 2: Understanding the Parameters
In _RefObjItem, there are three important columns that control alchemy success rates:
- Param2 – Controls enhancement levels +1 to +4
- Param3 – Controls enhancement levels +5 to +8
- Param4 – Controls enhancement levels +9 to +12 (and beyond if you increase the value)
Step 3: How to Modify the Rates
The logic is simple:
- Higher number = Higher success rate
- Lower number = Lower success rate
- To increase success rate: Multiply the current value by 2, 3, 4, etc. (e.g., if you want it twice as easy, double the number).
- To decrease success rate: Divide the current value by 2, 4, etc. (e.g., if you want it half as easy, divide by 2).
- Current value in Param2 = 841489940
- To double the success rate for +1 to +4: set it to 841489940 * 2 = 1682979880
Step 4: Expanding Beyond +12
Param4 covers +9 to +12. But what if you want alchemy to work up to +20 or even +250?
Simply increase the value in Param4 significantly. The game reads this value and applies it to all enhancements beyond +8. A larger number will allow higher enhancements to succeed more often.
For example, if you want alchemy to be possible up to +20, just raise Param4 to a very high number (experiment to find the right balance).
Step 5: Apply Your Changes
- Right-click on the row you want to edit and select "Edit Top 200 Rows" (or use an UPDATE query).
- Change the values in Param2, Param3, and/or Param4 as desired.
- Click Execute or Run to save the changes.
- Restart your GameServer for the changes to take effect.
Example: Making Alchemy 2x Easier
Let's say you want to double the success rate for all enhancements (+1 to +12) for the first alchemy stone (ID 2033).
Original Values:
- Param2 = 841489940
- Param3 = 336860180
- Param4 = 336202250
- Param2 = 1682979880
- Param3 = 673720360
- Param4 = 672404500
Quick Reference
- IDs to edit: 2033, 2034, 2035, 2036, 2037, 2038, 2039, 2040, 2041, 2042, 2043, 2044
- Param2 = +1 to +4
- Param3 = +5 to +8
- Param4 = +9 to +12 and beyond
Important Notes
EXPERIMENT ON A TEST SERVER FIRST – Alchemy rates can drastically affect game balance.- BACKUP YOUR DATABASE – Always backup _RefObjItem or the entire database before making changes.
- RESTART REQUIRED – Changes require a GameServer restart to take effect.
Troubleshooting
Q: I changed the values, but nothing happened.
A: Did you restart the GameServer? The server caches these values on startup.
Q: I set Param4 very high, but players still fail at +13.
A: Make sure your server files support enhancements beyond +12. Some files have a hard cap.
Q: Which IDs should I edit?
A: Only IDs 2033 through 2044. These are the standard alchemy stones. If you have custom stones, find their IDs in _RefObjCommon first.
Final Words
That's it! You now have full control over your alchemy rates. This method is much simpler than dealing with complex queries, and you can fine-tune each enhancement range separately.
If this guide helped you, please leave a comment or feedback below.
– Dev.S3oDy
