A fully offline, zero-install Windows application — just a single HTML file you double-click. No Node.js. No Python. No setup wizard. It opens in your browser and works instantly.
It's a complete SQL command reference and generator for ALL four vSRO databases:
SRO_VT_ACCOUNT
SRO_VT_SHARD
SRO_VT_SHARD_INIT
SRO_VT_SHARDLOG
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE — 16 CATEGORIES, 80+ COMMANDS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Account & Auth — Create GM accounts, ban/unban, IP whitelist, ShardID fix
Silk & Currency — Add silk per account, per character, bulk gift, view logs
Characters — Level, gold, SP, HwanLevel, job levels, teleport, inventory size
Items & Gear — Search, alter price, rarity, trade flags, stack size, bulk fixes
Inventory & Storage — Give items, set plus, view storage chest, trace by Serial64
Skills & Masteries — View, max, reset, grant full CH/EU skill sets
Guilds & Alliances — View roster, set GP/level, disband, clear alliances
NPC & Shops — Add/remove shop items, add tabs, move NPC spawn
Mobs & Spawns — Full spawn chain (Tactics→Hive→Nest), level/HP/EXP edits
Drop Tables — Add/remove drops, per-mob and global rate multipliers
Fortress & Siege — Reset ownership, transfer guild, set tax, view war logs
Quests — View log, force complete, reset progress
Live GM Commands — _ExeGameServer: give items, teleport, spawn mobs, buffs IN REAL TIME
SHARDLOG Queries — Event logs, item operation traces, log size checker
Server Config — EXP multiplier, region bind table, teleport NPC creation
Schema Browser — Every table documented with columns, types, keys, and FK relationships
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Every command has editable parameter fields. Type your CharName, CodeName128, or value — the SQL updates LIVE as you type. One click copies the finished query straight to your clipboard, ready to paste into SSMS.
No more manually editing queries. No more typos in table names.
Fill in the fields → SQL builds itself
Copy → Paste into SQL Server Management Studio
Done
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
BUILT ON REAL SCHEMA RESEARCH
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
This isn't copy-pasted queries from 2012. Every command was built from deep research into the actual vSRO table structures:
— _Char column map (all 25+ fields including HwanLevel, DiedRegion, TelRegion)
— _Items schema (ID64 vs Serial64, MagParam1–12 for blue stats, Variance encoding)
— _Inventory slot layout (0–12 = equip, 13–109 = bag, correct storage vs avatar tables)
— _ExeGameServer Action_IDs 1–15 (documented and tested)
— _LogEventChar EventID map (4=login, 6=logout, 8=levelup, 9=mob kill, 11=PK, 19=job, 20=unique kill)
— SK_Silk three-column breakdown (silk_own vs silk_gift vs silk_point)
— _ShardService ShardID=64 requirement
— Tab_RefTactics → Tab_RefHive → Tab_RefNest full spawn chain
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
FEATURES OVERVIEW
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
✔ Zero install — single .html file, runs offline
✔ Live SQL builder — parameters update the query in real time
✔ Copy to clipboard with one click
✔ Export any query as a .sql file
✔ Global search across all 80+ commands
✔ Filter by database (ACCOUNT / SHARD / SHARD_INIT / SHARDLOG)
✔ Danger warnings on destructive queries
✔ Schema Browser — browse 20+ tables with full column docs
✔ Works with: vSRO v1.188, v1.193, Black Rogue, Phoenix Emulator
✔ T-SQL / SQL Server syntax (SSMS 2008+)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
DOWNLOAD
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
VirusTotal
Download
It's a complete SQL command reference and generator for ALL four vSRO databases:
SRO_VT_ACCOUNT SRO_VT_SHARD SRO_VT_SHARD_INIT SRO_VT_SHARDLOG━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE — 16 CATEGORIES, 80+ COMMANDS━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Account & Auth — Create GM accounts, ban/unban, IP whitelist, ShardID fix Silk & Currency — Add silk per account, per character, bulk gift, view logs Characters — Level, gold, SP, HwanLevel, job levels, teleport, inventory size Items & Gear — Search, alter price, rarity, trade flags, stack size, bulk fixes Inventory & Storage — Give items, set plus, view storage chest, trace by Serial64 Skills & Masteries — View, max, reset, grant full CH/EU skill sets Guilds & Alliances — View roster, set GP/level, disband, clear alliances NPC & Shops — Add/remove shop items, add tabs, move NPC spawn Mobs & Spawns — Full spawn chain (Tactics→Hive→Nest), level/HP/EXP edits Drop Tables — Add/remove drops, per-mob and global rate multipliers Fortress & Siege — Reset ownership, transfer guild, set tax, view war logs Quests — View log, force complete, reset progress Live GM Commands — _ExeGameServer: give items, teleport, spawn mobs, buffs IN REAL TIME SHARDLOG Queries — Event logs, item operation traces, log size checker Server Config — EXP multiplier, region bind table, teleport NPC creation Schema Browser — Every table documented with columns, types, keys, and FK relationships━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
HOW IT WORKS━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Every command has editable parameter fields. Type your CharName, CodeName128, or value — the SQL updates LIVE as you type. One click copies the finished query straight to your clipboard, ready to paste into SSMS.
No more manually editing queries. No more typos in table names.
Fill in the fields → SQL builds itself Copy → Paste into SQL Server Management Studio Done━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
BUILT ON REAL SCHEMA RESEARCH━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
This isn't copy-pasted queries from 2012. Every command was built from deep research into the actual vSRO table structures:
— _Char column map (all 25+ fields including HwanLevel, DiedRegion, TelRegion)
— _Items schema (ID64 vs Serial64, MagParam1–12 for blue stats, Variance encoding)
— _Inventory slot layout (0–12 = equip, 13–109 = bag, correct storage vs avatar tables)
— _ExeGameServer Action_IDs 1–15 (documented and tested)
— _LogEventChar EventID map (4=login, 6=logout, 8=levelup, 9=mob kill, 11=PK, 19=job, 20=unique kill)
— SK_Silk three-column breakdown (silk_own vs silk_gift vs silk_point)
— _ShardService ShardID=64 requirement
— Tab_RefTactics → Tab_RefHive → Tab_RefNest full spawn chain
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
FEATURES OVERVIEW━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
✔ Zero install — single .html file, runs offline
✔ Live SQL builder — parameters update the query in real time
✔ Copy to clipboard with one click
✔ Export any query as a .sql file
✔ Global search across all 80+ commands
✔ Filter by database (ACCOUNT / SHARD / SHARD_INIT / SHARDLOG)
✔ Danger warnings on destructive queries
✔ Schema Browser — browse 20+ tables with full column docs
✔ Works with: vSRO v1.188, v1.193, Black Rogue, Phoenix Emulator
✔ T-SQL / SQL Server syntax (SSMS 2008+)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
DOWNLOAD━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
VirusTotal
Download
