EliteTop100xEliteTop100x

[Release] SQL Query to Add STR/INT +5 to Gold Dragon Flags (GDF)

1 views0 replies
#1 •
Draff
Draff
Everything is Free, Just DM ME
Joined
Received Thanks:0
Member
Hi elitepvpers community,

I'm sharing a quick and useful SQL query for vSRO server owners and developers. With this query, you can easily add +5 STR and +5 INT stats to the Gold Dragon Flags (GDF) in your database.

How to Apply:
  1. []Open SQL Management Studio. []Select your SRO_VT_SHARD database.
  2. Open a New Query window, paste the code below, and execute (F5).


Image

SQL Query:
Code:
USE SRO_VT_SHARD

UPDATE _RefScrapOfPackageItem SET 
MagParamNum=7, 
MagParam1=21474836713, 
MagParam2=21474836712, 
MagParam3=257698038180, 
MagParam4=34359738786, 
MagParam5=34359738785, 
MagParam6=171798691843, 
MagParam7=4294967735 
WHERE RefItemCodeName LIKE 'ITEM_ETC_E060529_GOLDDRAGONFLAG%'


Note: This query targets all items starting with the GDF codename. Make sure to restart your Gameserver after applying it to see the changes in-game.

I will continue to share more vSRO development content soon. If you found this helpful, please don't forget to hit the [Thanks] button!