[RELEASE] Inventory Viewer Query v1

/*
Query Created by: iSmokeDrow
Purpose: Viewing User Inventory
Version: 1

(Warning this query requires your SQL Server to be altered: to do so simply open a new query:
[PASTE-ME INTO NEW QUERY]
sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
[END-PASTE-ME] then execute)

Tables Used:
- dbo.Item //Telecaster
- dbo. Character // Telecaster
- dbo.ItemResource // Arcadia
- dbo.StringResource // Arcadia

To use, simply edit:
WHERE p.owner_id = 3 below!

WHERE extensions:p.owner_id, c.owner_name,c.account e.g. WHERE c.owner_name = '' 

Legend:
p. = dbo.Item
c. = dbo.Character
iR. = dbo.ItemResource
sR. = dbo.StringResource
*/
/*Select Info*/
SELECT P.owner_id, C.owner_name, C.account, sR.name, p.Code, p.amount, p.level, p.enhance, p.wear_info,
p.socket_0, p.socket_1, p.socket_2, p.socket_3, p.remain_time, p.update_time,
iR.icon_file_name 
FROM 
/*Select Info From dbo.Item*/
OPENROWSET('SQLNCLI11', 'Server=127.0.0.1;Database=Telecaster;Trusted_Connection=yes;',
                       'SELECT owner_id, code, cnt as amount, level, enhance, wear_info,
					    socket_0, socket_1, socket_2, socket_3,remain_time, update_time 
						FROM dbo.Item WHERE owner_id > 0') AS P
/* Select info from dbo.Character*/
INNER JOIN  OPENROWSET('SQLNCLI11', 'Server=127.0.0.1;Database=Telecaster;Trusted_Connection=yes;',
                       'SELECT sid, account, name as owner_name FROM dbo.Character') AS C
/*Base select off Character SID = Item Owner ID */
ON C.sid = P.owner_id
/*Select info from dbo.ItemResource*/
INNER JOIN  OPENROWSET('SQLNCLI11', 'Server=127.0.0.1;Database=Arcadia;Trusted_Connection=yes;',
                       'SELECT id, name_id, tooltip_id, icon_file_name FROM dbo.ItemResource') AS iR
/*Base select off ItemResource Id = Item ID */
ON iR.id = P.Code
/*Select info from dbo.StringResource */
INNER JOIN  OPENROWSET('SQLNCLI11', 'Server=127.0.0.1;Database=Arcadia;Trusted_Connection=yes;',
                       'SELECT code, value as name  FROM dbo.StringResource') AS sR
/*Base select off StringResource code = ItemResource name_id*/
ON sR.code = iR.name_id 
/*Base full SELECT clause WHERE credentials*/
WHERE p.owner_id = 3
/*Order by Owner ID Ascending*/
ORDER BY owner_id ASC

SELECT P.owner_id, C.owner_name, C.account, sR.name, P.Code, P.amount, P.level, P.enhance, P.wear_info,
       P.socket_0, P.socket_1, P.socket_2, P.socket_3, P.remain_time, P.update_time, iR.icon_file_name 
FROM       Telecaster.dbo.Item            P
/* Select info from dbo.Character, Base select off Character SID = Item Owner ID */
INNER JOIN Telecaster.dbo.Character       C ON C.sid   = P.owner_id  
/* Select info from dbo.ItemResource, Base select off ItemResource Id = Item ID */
INNER JOIN    Arcadia.dbo.ItemResource   iR ON iR.id   = P.Code
/* Select info from dbo.StringResource, Base select off StringResource code = ItemResource name_id */
INNER JOIN    Arcadia.dbo.StringResource sR ON sR.code = iR.name_id  
/* Base full SELECT clause WHERE credentials */
WHERE P.owner_id = 3
/* Order by Owner ID Ascending */
ORDER BY owner_id ASC