29-08-2012, 02:09 AM
My memory is failing me, but isn't there a list (complete or nearly complete) of items that were in MxO? Can anyone point me in the right direction?
Thanks in advance.
Thanks in advance.
(
ID NUMERIC,
PROP CHAR(60),
VAL CHAR(60))
)
select * from (
select
ID,
TRIM((select val from ABILITIES where PROP = 'AbilityID' and ID = ab.id)) AS AbilityID,
TRIM((select val from ABILITIES where PROP = 'objName' and ID = ab.id)) AS NAME,
TRIM((select val from ABILITIES where PROP = 'GOCategoryID' and ID = ab.id)) AS GO_Category,
TRIM((select val from ABILITIES where PROP = 'MemCost' and ID = ab.id)) AS MEM,
TRIM((select val from ABILITIES where PROP = 'InventoryMemCost' and ID = ab.id)) AS INVENTORY_MEM,
TRIM((select val from ABILITIES where PROP = 'BufferSize' and ID = ab.id)) AS BUFFER,
CONVERT(TRIM((select val from ABILITIES where PROP = 'VendorPrice' and ID = ab.id)), INT) AS COST,
TRIM((select val from ABILITIES where PROP = 'ReqCharLevel' and ID = ab.id)) AS LEV,
TRIM((select val from ABILITIES where PROP = 'ReqAbilityID' and ID = ab.id)) AS R1,
TRIM((select val from ABILITIES where PROP = 'objName' and ID =
(select val from ABILITIES where prop = 'ReqAbilityID' and ID = ab.id))) AS R1_NAME,
(select CONVERT(val, INT) from ABILITIES where PROP = 'ReqAbilityLevel' and ID = ab.id) AS RL1,
TRIM((select val from ABILITIES where PROP = 'ReqAbilityID 2' and ID = ab.id)) AS R2,
TRIM((select val from ABILITIES where PROP = 'objName' and ID =
(select val from ABILITIES where prop = 'ReqAbilityID 2' and ID = ab.id))) AS R2_NAME,
(select CONVERT(val, INT) from ABILITIES where PROP = 'ReqAbilityLevel 2' and ID = ab.id) AS RL2,
TRIM((select val from ABILITIES where PROP = 'ReqAbilityID 3' and ID = ab.id)) AS R3,
TRIM((select val from ABILITIES where PROP = 'objName' and ID =
(select val from ABILITIES where prop = 'ReqAbilityID 3' and ID = ab.id))) AS R3_NAME,
(select CONVERT(val, INT) from ABILITIES where PROP = 'ReqAbilityLevel 3' and ID = ab.id) AS RL3,
TRIM((select val from ABILITIES where PROP = 'ReqAbilityID 4' and ID = ab.id)) AS R4,
--TRIM((select str from STRING_TABLE ss where uint32 = (select val from ABILITIES where ID = ab.id and PROP = 'IconID'))) AS IconID,
TRIM((select str from STRING_TABLE ss where uint32 = (select val from ABILITIES where ID = ab.id and PROP = 'InfoID'))) AS InfoID,
TRIM((select str from STRING_TABLE ss where uint32 = (select val from ABILITIES where ID = ab.id and PROP = 'AbilityID'))) AS AbilityID,
TRIM((select str from STRING_TABLE ss where uint32 = (select val from ABILITIES where ID = ab.id and PROP = 'MoreInfoID'))) AS MoreInfoID,
1 AS END
from
ABILITIES ab
where prop = 'objName'
/*
and ID not in (2148521984)
and ID not in (select id from ABILITIES where PROP = 'objName' and VAL like 'NPC%')
and ID not in (select id from ABILITIES where PROP = 'OrganizationID')*/
)
order by COST ASC