/*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