Achar Itens Full no Char ou Bau

[AnDeR]

Galera segue essa query para procurar itens full no bau ou no char, eu usei muito na 97d, não testei em outras versões

ACHAR ITENS FULL NO BAÚ

select * from warehouse where
((charindex (0xbf, items) %10=8)
or (charindex (0xff, items) %10=8)
or (charindex (0x7f, items) %10=8)
or (charindex (0x37, items) %10=8)
or (charindex (0x2f, items) %10=8)
or (charindex (0x2e, items) %10=8)
or (charindex (0x1f, items) %10=8)
or (charindex (0x3b, items) %10=8)
or (charindex (0x39, items) %10=8)
or (charindex (0x3d, items) %10=8)
or (charindex (0x3e, items) %10=8)
or (charindex (0x36, items) %10=8)
or (charindex (0x3a, items) %10=8)
or (charindex (0x0f, items) %10=8)
or (charindex (0x17, items) %10=8)
or (charindex (0x27, items) %10=8)
or (charindex (0x3f, items) %10=8))

**ACHAR ITENS FULL NO INVENTÓRIO**

select * from character where ((charindex (0xbf, inventory) %10=8)
or (charindex (0xff, inventory) %10=8)
or (charindex (0x7f, inventory) %10=8)
or (charindex (0x37, inventory) %10=8)
or (charindex (0x2f, inventory) %10=8)
or (charindex (0x2e, inventory) %10=8)
or (charindex (0x1f, inventory) %10=8)
or (charindex (0x3b, inventory) %10=8)
or (charindex (0x39, inventory) %10=8)
or (charindex (0x3d, inventory) %10=8)
or (charindex (0x3e, inventory) %10=8)
or (charindex (0x36, inventory) %10=8)
or (charindex (0x3a, inventory) %10=8)
or (charindex (0x0f, inventory) %10=8)
or (charindex (0x17, inventory) %10=8)
or (charindex (0x27, inventory) %10=8)
or (charindex (0x3f, inventory) %10=8))

By Kr0nuS

[DrAgOn-ADM]

Irei testar,

Valeu por compartilhar !

[louis]

Galera segue essa query para procurar itens full no bau ou no char, eu usei muito na 97d, não testei em outras versões

ACHAR ITENS FULL NO BAÚ



**ACHAR ITENS FULL NO INVENTÓRIO**




By Kr0nuS

Para funcionar em versões mais novas basta mudar o %10 para %16