[Aporte] Listar Cuentas cn Items Full OPT

Con este script, se listan todos los usuarios con items full, o que sea imposible que hayan caido.


Se pasa por el analizador de consultas con la db Muonline seleccionada.

Código:

Codigo:
use Muonline
select AccountID from warehouse
where (charindex (0xbf, items) %10=8)
or (charindex (0xff, items) %10=8)
or (charindex (0x7f, items) %10=8)
or (charindex (0x3f, items) %10=8)
or (charindex (0x9f, items) %10=8)
or (charindex (0x8f, items) %10=8)
or (charindex (0x9e, items) %10=8)
or (charindex (0x9d, items) %10=8)
or (charindex (0xbd, items) %10=8)
or (charindex (0xbc, items) %10=8)
or (charindex (0xba, items) %10=8)
or (charindex (0xbb, items) %10=8)
or (charindex (0xb7, items) %10=8)
or (charindex (0xaf, items) %10=8)
select Name, AccountID from character
where (charindex (0xbf, inventory) %10=8)
or (charindex (0xff, inventory) %10=8)
or (charindex (0x7f, inventory) %10=8)
or (charindex (0x3f, inventory) %10=8)
or (charindex (0x9f, inventory) %10=8)
or (charindex (0x8f, inventory) %10=8)
or (charindex (0x9e, inventory) %10=8)
or (charindex (0x9d, inventory) %10=8)
or (charindex (0xbd, inventory) %10=8)
or (charindex (0xbc, inventory) %10=8)
or (charindex (0xba, inventory) %10=8)
or (charindex (0xbb, inventory) %10=8)
or (charindex (0xb7, inventory) %10=8)
or (charindex (0xaf, inventory) %10=8)

Créditos: IaanE~


Probado en las siguientes versiones: 0.97, 99b, 99z, 1.2n S2. A medida que vaya probando actualizo.