The following queries can be plugged into your SQL Management Package to test your database.

Try playing with and getting familiar with the SQL Server Management Package using these and othe queries available from the WIKI site at http://wiki.eve-id.net/Category:SQL_Queries

Please note that not all the queries listed on the WIKI site actually work properly but most do and those listed below work normally.

Find station with 'Cloning' service in Verge Vendor region starting with 'Ae'

SELECT nA.itemName AS Agent, nS.itemName AS Station FROM agtConfig c
INNER JOIN agtAgents a ON c.agentID=a.agentID
INNER JOIN eveNames nA ON c.agentID=nA.itemID
LEFT JOIN eveNames nS ON a.locationID=nS.itemID
WHERE c.k='agent.LocateCharacterService.enabled'
AND nA.itemName LIKE 'Ae%';

Produces this:

Researching and Copying for the Prototype Cloaking Device I Blueprint (typeID 13000):


SELECT a.activityName, t.typeName, r.quantity, r.damagePerJob
FROM ramTypeRequirements AS r
INNER JOIN invTypes AS t
ON r.requiredTypeID = t.typeID
INNER JOIN ramActivities AS a
ON r.activityID = a.activityID
WHERE r.activityID IN (3, 4, 5) -- time, material research, copying
AND r.typeID = 13000 -- Prototype Cloaking Device I Blueprint
ORDER BY a.activityName, t.typeName;

Produces this:

Returns list of POS modules with CPU and Powergrid requirements.

note: in example part of output table is filtered with ... and
t.typeName like '%Array' ...

SELECT t.typeName, -- name of item
a30.valueInt AS PG, -- power grid
a50.valueInt AS CPU -- CPU
FROM invTypes t
LEFT JOIN dgmTypeAttributes a30 ON t.typeID=a30.typeID
LEFT JOIN dgmTypeAttributes a50 ON t.typeID=a50.typeID
INNER JOIN invGroups g ON t.groupID=g.groupID
WHERE g.categoryID=23 -- POS group is 23, see invGroups table
AND a30.attributeID=30 -- power grid attribute is 30, see dgmAttributeTypes
AND a50.attributeID=50 -- cpu attribute is 50
AND t.published=1 -- filtering not in-game items
AND t.typeName LIKE "%Array";


Produces this:

• Add New
• Search
• RSS

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.

Joomla components by Compojoom