SQL Code: Search who has EXC Full Opts

[Elzard]

Thanks, very useful. :)

[xavi321]

hex codes out wherehause

declare @items varbinary(1920), 
@accountid varchar(10); 
 
set @accountid='xavi'; 
                             use MuOnline; 
set @items = (SELECT Items FROM warehouse WHERE AccountId = @accountid); 
print @items; 

hex codes out inventory

declare @items varbinary(1728), 
@character varchar(10); 
 
set @character='Xavi'; 
 
                             use MuOnline; 
set @items = (SELECT Inventory FROM Character WHERE Name = @character); 
print @items; 

[iGotYerGf]

asdasdasd

[xavi321]

any query to select the Serial of the items?
regards!

[Aquiles88]

I want to understand exactly what it means:
where (charindex (0xbf, inventory) %10=8) or (charindex (0xff, inventory) %10=8) or (charindex (0x7f, inventory) %10=8) or (charindex (0x3f, inventory) %10=8)...

I want to learn how it works and make my own query.
Thank's in advance.

[milaiko]

With this code, can we count how many items is exc full option per account?

select * 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)
select * 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)