Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSMitmachenHilf mit und sammle Community PointsÖffnenAuf MuADMINSEvent-ZeitpläneBlood Castle, Devil Square, Invasionen in einem WochenrasterÖffnen
← Alle Lösungen

SkynetMU Full Option Cleaner: how do I find and remove full excellent items from warehouses and inventories of a 97/97D SQL database?

Von MuADMINS anhand der Quelle geschriebenNot verified

Tool: SkynetMU Full Option Cleaner 1.1

  1. Install Python 3.11 or 3.12 on Windows, then run py -m pip install -r requirements.txt and py SkynetMU_FullOption_Cleaner.py.
  2. For ODBC install Microsoft ODBC Driver 17 or 18 for SQL Server and pick its exact name in the tool, or use the native pymssql option.
  3. The scan is read only. It reads dbo.warehouse.Items, dbo.ExtWarehouse.Items and dbo.Character.Inventory (classic 10 byte items) and marks full excellent items, where (byte[7] & 0x3F) == 0x3F.
  4. Cleaning replaces only the chosen item with FF FF FF FF FF FF FF FF FF FF, after it reads the blob again, checks that it did not change, writes a JSON backup of the original blob and updates exactly one row.
  5. Stop the GameServer or keep the option that blocks connected accounts (it uses MEMB_STAT), and test first on one known account.
  6. To undo, each JSON backup holds original_blob_base64, which you can decode and write back by hand.
Hat das geholfen?

Kommst du immer noch nicht weiter? MuGPS durchsuchen Frag den MU-Assistenten

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.