Quote:

---

DECLARE @typeName nvarchar(25)
DECLARE @typeID int
DECLARE @blueprintID int

SET @typeName = 'Raven'

SELECT @typeID = typeID
FROM invTypes
WHERE typeName = @typeName

SELECT @blueprintID = blueprintTypeID
FROM invBlueprintTypes
WHERE productTypeID = @typeID

SELECT A.activityName, T1.typeName, requiredType = T2.typeName, AMV.quantity
FROM typeActivityMaterials AMV
INNER JOIN invTypes T1 on T1.typeID = AMV.typeID
INNER JOIN invTypes T2 on T2.typeID = AMV.requiredTypeID
INNER JOIN ramActivities A on A.activityID = AMV.activityID
WHERE AMV.typeID = @blueprintID AND AMV.activityID = 1

---

Quote:

---

activityNametypeNamerequiredTypequantity
ManufacturingRaven BlueprintTritanium7577632
ManufacturingRaven BlueprintPyerite1894802
ManufacturingRaven BlueprintMexallon474675
ManufacturingRaven BlueprintIsogen118519
ManufacturingRaven BlueprintNocxium29595
ManufacturingRaven BlueprintZydrine7060
ManufacturingRaven BlueprintMegacyte2254

---

Quote:

---

SELECT A.activityName, T1.typeName, requiredType = T2.typeName, AMV.quantity, recycle = ISNULL(recycle, 0)

---

Quote:

---

activityNametypeNamerequiredTypequantityrecycle

(1. Materials consumed/wasted in the process)
ManufacturingGuardian BlueprintTritanium-1874430
ManufacturingGuardian BlueprintPyerite-328220
ManufacturingGuardian BlueprintIsogen-18830
ManufacturingGuardian BlueprintZydrine-1910
ManufacturingGuardian BlueprintMegacyte-100

(2. Materials player has to provide)
ManufacturingGuardian BlueprintMexallon42190
ManufacturingGuardian BlueprintNocxium1670
ManufacturingGuardian BlueprintMorphite600

(3. Tech 1 ship that will be recycled into materials)
ManufacturingGuardian BlueprintAugoror11

(4. Skills at levels required)
ManufacturingGuardian BlueprintIndustry50
ManufacturingGuardian BlueprintCruiser Construction10
ManufacturingGuardian BlueprintAmarrian Starship Engineering10
ManufacturingGuardian BlueprintMechanical Engineering10

(5. Components required)
ManufacturingGuardian BlueprintR.A.M.- Starship Tech80
ManufacturingGuardian BlueprintConstruction Blocks500
ManufacturingGuardian BlueprintFusion Thruster1000
ManufacturingGuardian BlueprintRadar Sensor Cluster1500
ManufacturingGuardian BlueprintNanoelectrical Microprocessor2000
ManufacturingGuardian BlueprintTungsten Carbide Armor Plate1000
ManufacturingGuardian BlueprintAntimatter Reactor Unit1000
ManufacturingGuardian BlueprintTesseract Capacitor Unit2500
ManufacturingGuardian BlueprintLinear Shield Emitter1000

---

Quote:

---

(6. Materials provided by Tech 1 ship)
ManufacturingAugoror BlueprintTritanium204846
ManufacturingAugoror BlueprintPyerite51606
ManufacturingAugoror BlueprintMexallon14903
ManufacturingAugoror BlueprintIsogen3371
ManufacturingAugoror BlueprintNocxium846
ManufacturingAugoror BlueprintZydrine191
ManufacturingAugoror BlueprintMegacyte43

---

Quote:

---

Tritanium-187443+ 0+ 204846= 17403
Pyerite-32822+ 0+ 51606= 18784
Mexallon-0+ 4219+ 14903= 19122
Isogen-1883+ 0+ 3371= 1488
Nocxium-0+ 167+ 846= 1013
Zydrine-191+ 0+ 191= 0
Megacyte-10+ 0+ 43= 33
Morphite0+ 60+ 0= 60

---

Originally by: CCP Explorer

---

Edited by: CCP Explorer on 07/09/2008 12:46:29

.... For reprocessing, look for recycled items ...

(All queries courtesy of CCP Prism X.)

---

Quote:

---

CREATE PROCEDURE dbo.getReprocesResults
@itemIDint
AS
DECLARE @blueprintIDint
DECLARE @baseItemIDint
DECLARE @techLevelint

SET @baseItemID = 0
SELECT @baseItemID = parentTypeID
FROM invMetaTypes
WHERE typeID = @itemID AND metaGroupID != 2

IF(@baseItemID = 0)
BEGIN
SET @baseItemID = @itemID
END

SELECT @blueprintID = blueprintTypeID, @techLevel = techLevel
FROM invBlueprintTypes
WHERE productTypeID = @baseItemID

IF(@techLevel = 1)
BEGIN
SELECT typeActivityMaterials.requiredTypeID, typeActivityMaterials.quantity
FROM typeActivityMaterials
WHERE typeActivityMaterials.typeID = @blueprintID AND typeActivityMaterials.activityID = 1
END
ELSE
BEGIN
SELECT typeActivityMaterials.requiredTypeID, SUM(typeActivityMaterials.quantity) AS quantity
FROM typeActivityMaterials
JOIN
(
SELECT invBlueprintTypes.blueprintTypeID
FROM invBlueprintTypes
JOIN
(
SELECT typeActivityMaterials.requiredTypeID
FROM typeActivityMaterials
INNER JOIN invTypes AS typeReq ON typeActivityMaterials.requiredTypeID = typeReq.typeID
INNER JOIN invGroups AS typeGroup ON typeReq.groupID = typeGroup.groupID
WHERE typeActivityMaterials.typeID = @blueprintID AND typeActivityMaterials.activityID = 1 AND
typeActivityMaterials.recycle = 1
) AS tam ON invBlueprintTypes.productTypeID = tam.requiredTypeID
) AS bp ON typeActivityMaterials.typeID = bp.blueprintTypeID OR typeActivityMaterials.typeID = @blueprintID
INNER JOIN invTypes AS typeReq ON typeActivityMaterials.requiredTypeID = typeReq.typeID
INNER JOIN invGroups AS typeGroup ON typeReq.groupID = typeGroup.groupID
WHERE typeActivityMaterials.activityID = 1 AND typeActivityMaterials.recycle = 0 AND
typeGroup.categoryID != 16
GROUP BY requiredTypeID
END

RETURN

---

Quote:

---

SELECT
t2.typeID,
t2.typeName
FROM
typeActivityMaterials t
INNER JOIN invTypes t2 ON t.typeID = t2.typeID
INNER JOIN invTypes t3 ON t.requiredTypeID = t3.typeID
WHERE t.activityID = 6
AND t2.published = 1
GROUP BY t2.typeID
ORDER BY t2.typeName ASC

---

Quote:

---

DECLARE @typeName nvarchar(25)
DECLARE @typeID int
DECLARE @blueprintID int

SET @typeName = 'Raven'

SELECT @typeID = typeID
FROM invTypes
WHERE typeName = @typeName

SELECT @blueprintID = blueprintTypeID
FROM invBlueprintTypes
WHERE productTypeID = @typeID

SELECT A.activityName, T1.typeName, requiredType = T2.typeName, AMV.quantity
FROM typeActivityMaterials AMV
INNER JOIN invTypes T1 on T1.typeID = AMV.typeID
INNER JOIN invTypes T2 on T2.typeID = AMV.requiredTypeID
INNER JOIN ramActivities A on A.activityID = AMV.activityID
WHERE AMV.typeID = @blueprintID AND AMV.activityID = 1

---