These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

BPO list/BPC request module for joomla
Author
Previous Topic Next Topic
Rastuasi
Crunchy Crunchy
#1 - 2012-11-06 16:10:25 UTC
Hello,

So I do not know if this possible, let alone know enough about how joomla is coded to make one myself, but what I'm looking for is a way to have a page on a joomla page to access my corp's api and list the bpos that are available to be made into copies. I can easily enough create a form on joomla to then allow members in my alliance to request copies. The idea behind this is to lower the necessity to give out "viewing" roles and also allow an automatically updated list for alliance access. Ideally I could choose which division it shows so it doesn't show the entire corp hanger access.

Does anyone know where to look, if there is one developed already, or if it's even possible? Or if plausible, any better solutions than a webpage/form?

Thanks for the help,
Rastuasi
Kosmoto Gothwen
Frenemy Logicians
#2 - 2012-11-08 04:51:12 UTC
I do not have experience with jooma specifically but I've started playing with a tool that will do some of the same things. Here is what you need: the api, the eve datadump database (specifically the invTypes and invGroups tables), create a cache class for the api, parse the api, in the parse loop call a query to the datadump that inner joins on the invGroups and invTypes tables (hint you want categoryID = 9), this will return just the blueprints from the assets, then create your output.

Moon Gooru | Common Eve Terms
KnifeOrSpoon
Contraposition Industries Inc
#3 - 2012-11-08 10:25:02 UTC
Strangely enough I am working on something at the moment which does something similar to what you are looking for.
I however have chosen to integrate it into Joomla, Yapeal, and the Inferno Static Database dump.

Using the Inferno database and the Yapeal install the SQL would look like thus:

SELECT
`CAL`.*,
`IT`.`typeName`,
COUNT(`CAL`.`itemID`) as `qtyOnHand`
FROM
`XXX_inferno`.`invblueprinttypes` as `BPT`
INNER JOIN `XXX_inferno`.`invtypes` as `IT` ON `IT`.`typeID`=`BPT`.`blueprintTypeID`
INNER JOIN `XXX_yapeal`.`corpAssetList` as `CAL` ON `CAL`.`typeID`=`IT`.`typeID`
WHERE
`CAL`.`flag`=116 -- Blueprints in Corp Access Group 2
GROUP BY `CAL`.`typeID`
ORDER BY `IT`.`typeName` ASC

When I run this query I get the result of this:

{pilotID} 116 573908797 5 66002282 2 1 -1 6 1 12275 Ballistic Control System I Blueprint {qty}
{pilotID} 116 1007645276744 67 66002282 2 1 -1 68 1 977 Blackbird Blueprint {qty}
{pilotID} 116 1004805873936 51 66002282 2 1 -1 52 1 4314 Caldari Fuel Block Blueprint {qty}
{pilotID} 116 2026375287 23 66002282 2 1 -1 24 1 13321 Cruise Missile Launcher I Blueprint {qty}
{pilotID} 116 574630547 7 66002282 2 1 -1 8 1 3840 Large Shield Extender I Blueprint {qty}


The beauty of this query is you can also limit this query to certain stations by adding
' AND `CAL`.`locationID`='xxxxxxxxx' ' to the WHERE statement

As for the Joomla part of the problem, it's actually quite easy to build a component within Joomla to bring this data to the viewport. The hard part is wrapping your head around the Model View Controller to get things rolling.

Take a look at the developers section of the Joomla website, there is a brief walk-through detailing how components are built.


Hope that helps some :)