Community AlphaAlpha MUADMINS
RORomână
Autentificare
Pe MuADMINSContribuieAjută și câștigă Community PointsDeschidePe MuADMINSProgramul evenimentelorBlood Castle, Devil Square, invazii într-o grilă săptămânalăDeschide
← Toate soluțiile

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

Scris de MuADMINS pe baza surseiNot verified

Unealtă: 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.
Te-a ajutat?

Tot nu merge? Caută în MuGPS Întreabă Asistentul MU

MuADMINS Community Alpha: gratuit, făcut de comunitate, în dezvoltare activă.