Inventory slot check?

[tvdynamo]

I want to take out the empty slots of the inventory by a certain player, please help with the query. Thanks!

Image:

 Spoiler

[ZαKuRα]

I don't know if I'm wrong but this will only work for you with a new char
while in those slots have items and closes you will have problems

SRO_VT_SHARD>dbo._Char>InventorySize

[tvdynamo]

Originally Posted by ZαKuRα

I don't know if I'm wrong but this will only work for you with a new char
while in those slots have items and closes you will have problems

SRO_VT_SHARD>dbo._Char>InventorySize

This is total slots, I want to take all empty slots.

[hoangphan7]

Originally Posted by tvdynamo

This is total slots, I want to take all empty slots.

Declare @Slot int = (select InventorySize from _Char where CharID = @D)
Declare @lot int = (
Select Count(*) from _Inventory where CharID = @D and ItemID > 0 and Slot between 13 and @Slot)

[tvdynamo]

Originally Posted by hoangphan7

Declare @Slot int = (select InventorySize from _Char where CharID = @D)
Declare @lot int = (
Select Count(*) from _Inventory where CharID = @D and ItemID > 0 and Slot between 13 and @Slot)

Thanks very much!

[chipno0p]

Originally Posted by hoangphan7

Declare @Slot int = (select InventorySize from _Char where CharID = @D)
Declare @lot int = (
Select Count(*) from _Inventory where CharID = @D and ItemID > 0 and Slot between 13 and @Slot)

This query is for checking how many slot which have item in. Change itemid = 0 to get total empty slot currently in character Inv

[tvdynamo]

Originally Posted by chipno0p

This query is for checking how many slot which have item in. Change itemid = 0 to get total empty slot currently in character Inv

Yes, I have made some changes to make it suitable for me, the purpose is that I want to know the location.

[hoangphan7]

Originally Posted by chipno0p

This query is for checking how many slot which have item in. Change itemid = 0 to get total empty slot currently in character Inv

Use your brain. OK!

[JellyBitz]

Originally Posted by tvdynamo

Yes, I have made some changes to make it suitable for me, the purpose is that I want to know the location.

SELECT *
FROM _Inventory
WHERE CharID = @D AND ItemID = 0 and Slot BETWEEN 13 AND 255

I don't know tables but it should be what you looking for.