Inventory slot check?

10/03/2019 07:07 tvdynamo#1
I want to take out the empty slots of the inventory by a certain player, please help with the query. Thanks!

Image:
10/03/2019 17:35 ZαKuRα#2
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
10/03/2019 19:48 tvdynamo#3
Quote:
Originally Posted by ZαKuRα View Post
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.
10/04/2019 16:59 hoangphan7#4
Quote:
Originally Posted by tvdynamo View Post
This is total slots, I want to take all empty slots.

Declare @[Only registered and activated users can see links. Click Here To Register...]Slot int = (select InventorySize from _Char where CharID = @[Only registered and activated users can see links. Click Here To Register...]D)
Declare @[Only registered and activated users can see links. Click Here To Register...]lot int = (
Select Count(*) from _Inventory where CharID = @[Only registered and activated users can see links. Click Here To Register...]D and ItemID > 0 and Slot between 13 and @[Only registered and activated users can see links. Click Here To Register...]Slot)
10/04/2019 22:02 tvdynamo#5
Quote:
Originally Posted by hoangphan7 View Post
Declare @[Only registered and activated users can see links. Click Here To Register...]Slot int = (select InventorySize from _Char where CharID = @[Only registered and activated users can see links. Click Here To Register...]D)
Declare @[Only registered and activated users can see links. Click Here To Register...]lot int = (
Select Count(*) from _Inventory where CharID = @[Only registered and activated users can see links. Click Here To Register...]D and ItemID > 0 and Slot between 13 and @[Only registered and activated users can see links. Click Here To Register...]Slot)
Thanks very much!
10/05/2019 09:05 chipno0p#6
Quote:
Originally Posted by hoangphan7 View Post
Declare @[Only registered and activated users can see links. Click Here To Register...]Slot int = (select InventorySize from _Char where CharID = @[Only registered and activated users can see links. Click Here To Register...]D)
Declare @[Only registered and activated users can see links. Click Here To Register...]lot int = (
Select Count(*) from _Inventory where CharID = @[Only registered and activated users can see links. Click Here To Register...]D and ItemID > 0 and Slot between 13 and @[Only registered and activated users can see links. Click Here To Register...]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
10/05/2019 12:57 tvdynamo#7
Quote:
Originally Posted by chipno0p View Post
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.
10/05/2019 20:23 hoangphan7#8
Quote:
Originally Posted by chipno0p View Post
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!
10/06/2019 23:19 JellyBitz#9
Quote:
Originally Posted by tvdynamo View Post
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 = @[Only registered and activated users can see links. Click Here To Register...]D AND ItemID = 0 and Slot BETWEEN 13 AND 255

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