O que eu devo fazer para digitar esse codigo ?
Voce devera ir em Iniciar>>>>>Todos arquivos ou arquivos de programas>>>>>Microsoft sql server>>>>Query Analyzer>>>>Marque windows autentification>>>> LA na parte de cima aodne ta escrito master clicke lahe selecione MuOnline>>>Digite seu codigo no campo abaixo>>>>e depois de digitar seu codigo aperte f5!!!! e pronto
Codigos:
Achar itens full no Baú
Código:
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:
Código:
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))
Créditos : IGOR.A.B
