[Guía] Listar cuentas con ITEMS FULL OPC

Tema: [Guía] Listar cuentas con ITEMS FULL OPC Sáb Ene 29, 2011 8:53 pm

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:: 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: jonh_d, editado por Volpe.

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

Atte:~Xtreme Exclamation

» [Guia]Crear Mu Season 4. 160 Items Agregados
» [Aporte] Files 1.06A+166 NEW ITEMS
» [Aporte] Borrar Items dup desde Sql
» [Aporte] Agregar items al inventario a la hora de crear personaje
» [Aporte] Sql Server 2000 Full