[Epic Release] Inventory Viewer

[ahmed4ever2u]

• this tool is only for server owners.
• made just for fun.
• First version V 1.00
  • • - support 3 pages.
    • - shows item Name and Plus only.
    • - shows gold.
• updates will follow
• Suggestions are welcomed.

• Download link
• • 

[Aaron*]

Awesome, all your releases are epic!

[XxGhostSpiriTxX]

very good *--*

Bro linck error

[@$$]

Link not working

[witchymoo]

ohhh hahaha niceee, you made the GUI version, awesome work

I always used SQL query to check such stuff since i have no knowledge in programming.Well, here it is: (Inventory and Storage)

USE [SRO_VT_SHARD]
GO
SET NOCOUNT ON;
/*
 * Check items in inventory and storage -- Witchy Moo 20150622
 */
DECLARE @CharName VARCHAR(64)
DECLARE @CharID INT
DECLARE @UserJID INT
DECLARE @ItemID BIGINT
DECLARE @CharSlot TINYINT
DECLARE @CodeName128 VARCHAR(64)

SET @CharName = 'Witchy'	-- set character name here

/* Check items in inventory */
PRINT CHAR(10)+'Inventory Items:'
SELECT @CharID = CharID FROM [_Char] WHERE CharName16 = LTRIM(RTRIM(@CharName))
DECLARE cur CURSOR FOR SELECT ItemID, Slot FROM [_Inventory] WITH (NOLOCK) WHERE CharID = @CharID AND ItemID > 0 ORDER BY Slot ASC
OPEN cur
FETCH NEXT FROM cur INTO @ItemID, @CharSlot
WHILE @@FETCH_STATUS = 0
BEGIN
	SELECT @CodeName128 = CodeName128 FROM [_RefObjCommon] WITH (NOLOCK) WHERE ID = (SELECT RefItemID FROM [_Items] WITH (NOLOCK) WHERE ID64 = @ItemID)
	PRINT '- Inventory slot ' + CAST(@CharSlot AS VARCHAR) + ': ItemID: ' + CAST(@ItemID AS VARCHAR) + ' Code: ' + @CodeName128
	FETCH NEXT FROM cur INTO @ItemID, @CharSlot
END;
CLOSE cur
DEALLOCATE cur
/* Check items in storage */
PRINT CHAR(10)+'Storage Items:'
SELECT @UserJID = UserJID FROM _User WHERE CharID = @CharID
DECLARE cur CURSOR FOR SELECT ItemID, Slot FROM [_Chest] WITH (NOLOCK) WHERE UserJID = @UserJID AND (ItemID <> 0 AND ItemID IS NOT NULL) ORDER BY Slot ASC
OPEN cur
FETCH NEXT FROM cur INTO @ItemID, @CharSlot
WHILE @@FETCH_STATUS = 0
BEGIN
	SELECT @CodeName128 = CodeName128 FROM [_RefObjCommon] WITH (NOLOCK) WHERE ID = (SELECT RefItemID FROM [_Items] WITH (NOLOCK) WHERE ID64 = @ItemID)
	PRINT '- Storage Slot ' + CAST(@CharSlot AS VARCHAR) + ': ' +@CodeName128
	FETCH NEXT FROM cur INTO @ItemID, @CharSlot
END;
CLOSE cur
DEALLOCATE cur

Result:

[ahmed4ever2u]

Originally Posted by witchymoo

ohhh hahaha niceee, you made the GUI version, awesome work

I always used SQL query to check such stuff since i have no knowledge in programming.Well, here it is: (Inventory and Storage)

USE [SRO_VT_SHARD]
GO
SET NOCOUNT ON;
/*
 * Check items in inventory and storage -- Witchy Moo 20150622
 */
DECLARE @CharName VARCHAR(64)
DECLARE @CharID INT
DECLARE @UserJID INT
DECLARE @ItemID BIGINT
DECLARE @CharSlot TINYINT
DECLARE @CodeName128 VARCHAR(64)

SET @CharName = 'Witchy'	-- set character name here

/* Check items in inventory */
PRINT CHAR(10)+'Inventory Items:'
SELECT @CharID = CharID FROM [_Char] WHERE CharName16 = LTRIM(RTRIM(@CharName))
DECLARE cur CURSOR FOR SELECT ItemID, Slot FROM [_Inventory] WITH (NOLOCK) WHERE CharID = @CharID AND ItemID > 0 ORDER BY Slot ASC
OPEN cur
FETCH NEXT FROM cur INTO @ItemID, @CharSlot
WHILE @@FETCH_STATUS = 0
BEGIN
	SELECT @CodeName128 = CodeName128 FROM [_RefObjCommon] WITH (NOLOCK) WHERE ID = (SELECT RefItemID FROM [_Items] WITH (NOLOCK) WHERE ID64 = @ItemID)
	PRINT '- Inventory slot ' + CAST(@CharSlot AS VARCHAR) + ': ItemID: ' + CAST(@ItemID AS VARCHAR) + ' Code: ' + @CodeName128
	FETCH NEXT FROM cur INTO @ItemID, @CharSlot
END;
CLOSE cur
DEALLOCATE cur
/* Check items in storage */
PRINT CHAR(10)+'Storage Items:'
SELECT @UserJID = UserJID FROM _User WHERE CharID = @CharID
DECLARE cur CURSOR FOR SELECT ItemID, Slot FROM [_Chest] WITH (NOLOCK) WHERE UserJID = @UserJID AND (ItemID <> 0 AND ItemID IS NOT NULL) ORDER BY Slot ASC
OPEN cur
FETCH NEXT FROM cur INTO @ItemID, @CharSlot
WHILE @@FETCH_STATUS = 0
BEGIN
	SELECT @CodeName128 = CodeName128 FROM [_RefObjCommon] WITH (NOLOCK) WHERE ID = (SELECT RefItemID FROM [_Items] WITH (NOLOCK) WHERE ID64 = @ItemID)
	PRINT '- Storage Slot ' + CAST(@CharSlot AS VARCHAR) + ': ' +@CodeName128
	FETCH NEXT FROM cur INTO @ItemID, @CharSlot
END;
CLOSE cur
DEALLOCATE cur

Result:

i always lose sql scripts
also my sql query's in the tool are much more simpler than yours

[Zargrin]

Awesome,you are released epic tools

[where_love2003]

have virus

[tschulian]

Originally Posted by where_love2003

have virus

Head_Banger du wirst doch wohl nicht Viren verteilen

#isso

danke für den Release! Ist nützlich und klappt super!
Suggestion wäre da noch delete Function mit einzubringen.

[Syloxx]

Originally Posted by witchymoo

ohhh hahaha niceee, you made the GUI version, awesome work

I always used SQL query to check such stuff since i have no knowledge in programming.Well, here it is: (Inventory and Storage)

USE [SRO_VT_SHARD]
GO
SET NOCOUNT ON;
/*
 * Check items in inventory and storage -- Witchy Moo 20150622
 */
DECLARE @CharName VARCHAR(64)
DECLARE @CharID INT
DECLARE @UserJID INT
DECLARE @ItemID BIGINT
DECLARE @CharSlot TINYINT
DECLARE @CodeName128 VARCHAR(64)

SET @CharName = 'Witchy'	-- set character name here

/* Check items in inventory */
PRINT CHAR(10)+'Inventory Items:'
SELECT @CharID = CharID FROM [_Char] WHERE CharName16 = LTRIM(RTRIM(@CharName))
DECLARE cur CURSOR FOR SELECT ItemID, Slot FROM [_Inventory] WITH (NOLOCK) WHERE CharID = @CharID AND ItemID > 0 ORDER BY Slot ASC
OPEN cur
FETCH NEXT FROM cur INTO @ItemID, @CharSlot
WHILE @@FETCH_STATUS = 0
BEGIN
	SELECT @CodeName128 = CodeName128 FROM [_RefObjCommon] WITH (NOLOCK) WHERE ID = (SELECT RefItemID FROM [_Items] WITH (NOLOCK) WHERE ID64 = @ItemID)
	PRINT '- Inventory slot ' + CAST(@CharSlot AS VARCHAR) + ': ItemID: ' + CAST(@ItemID AS VARCHAR) + ' Code: ' + @CodeName128
	FETCH NEXT FROM cur INTO @ItemID, @CharSlot
END;
CLOSE cur
DEALLOCATE cur
/* Check items in storage */
PRINT CHAR(10)+'Storage Items:'
SELECT @UserJID = UserJID FROM _User WHERE CharID = @CharID
DECLARE cur CURSOR FOR SELECT ItemID, Slot FROM [_Chest] WITH (NOLOCK) WHERE UserJID = @UserJID AND (ItemID <> 0 AND ItemID IS NOT NULL) ORDER BY Slot ASC
OPEN cur
FETCH NEXT FROM cur INTO @ItemID, @CharSlot
WHILE @@FETCH_STATUS = 0
BEGIN
	SELECT @CodeName128 = CodeName128 FROM [_RefObjCommon] WITH (NOLOCK) WHERE ID = (SELECT RefItemID FROM [_Items] WITH (NOLOCK) WHERE ID64 = @ItemID)
	PRINT '- Storage Slot ' + CAST(@CharSlot AS VARCHAR) + ': ' +@CodeName128
	FETCH NEXT FROM cur INTO @ItemID, @CharSlot
END;
CLOSE cur
DEALLOCATE cur

Result:

why you still using cursors? o.O

[​Exo]

Originally Posted by Syloxx

why you still using cursors? o.O

I had this exact thought.

[Jimmy*]

seems legit

[ledgervera]

Add a feature on the program that shows item units.

[Imodorox]

Good Job thanks alot

[Winor]

good job ..