[RELEASE] Inventory Viewer Query v1

[gr4ph0s]

But all the GM.tool posted here are in .net is not hard to modify them too


But i agree with you Raskim maybe if your tool is not look like the best tool you have practice and probably learn and that is the more important !

[5405045]

guys i didnt mean modifying another person work no
i meant the idea of his work like a new gm tool with a better features
and the gm tool ( official ) is a fortune if you get the log server working !

[gr4ph0s]

I agree with you oficial web panel is very good for ban moderator or any else

[ismokedrow]

Update:

Here is a MUCH more stream-lined version of my Inventory Viewer!

Inventory Viewing Query v2 [NIBBLER]

/*NIBBLER [Inventory Viewer v2]*/
/*Created by: iSmokeDrow*/
/*Revisements Contributed by: Glandu2, Haxti*/
/*Purpose: Viewing Player Inventories*/
/*Change Notes: Execution time reduced significantly (77 records @ 2 seconds)*/

/*To use, edit @owner_name = 'ENTER CHARACTER NAME HERE' to the desired Character Name and execute*/
DECLARE @owner_name NVARCHAR(55)
SET @owner_name = 'ENTER CHARACTER NAME HERE'

/*DO NOT EDIT ANYTHING BELOW*/
SELECT INVENTORY.owner_id, CHAR.name as owner_name, CHAR.account, STRINGRES.value as item_name,
INVENTORY.Code as item_id, INVENTORY.cnt as amount, INVENTORY.level, INVENTORY.enhance as enchant_lv,
INVENTORY.wear_info as equipment_slot, INVENTORY.socket_0, INVENTORY.socket_1, INVENTORY.socket_2, 
INVENTORY.socket_3, INVENTORY.remain_time, INVENTORY.update_time, ITEMRES.icon_file_name
FROM Telecaster.dbo.Item INVENTORY 
INNER JOIN Telecaster.dbo.Character CHAR
on CHAR.sid = INVENTORY.owner_id 
INNER JOIN Arcadia.dbo.ItemResource ITEMRES
on ITEMRES.id = INVENTORY.code
INNER JOIN Arcadia.dbo.StringResource STRINGRES
on STRINGRES.code = ITEMRES.name_id
WHERE CHAR.name = @owner_name
ORDER BY INVENTORY.owner_id ASC

Hope you enjoy!