A fully offline, zero-install Windows application — just a single HTML file you double-click. No Node.js. NoPython. 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
*** Hidden text: cannot be quoted. ***
