PlanetSide Universe - View Single Post - The Oracle of Death
View Single Post
Old 2013-08-07, 05:04 PM   [Ignore Me] #15
maradine
Contributor
Lieutenant Colonel
 
maradine's Avatar
 
Re: The Oracle of Death


Proxy: 18239
Betty: 15296
Claymore: 6203

Though, for this one, I'm going to throw my hands up in confusion: there are 5 item entries for the three faction mines. I think the above is accurate. Gonna need to bug the API forums on what's up with that.

To the earlier AV arm question, I think the numbers are the numbers.


Code:
<item id="16028">
   <name en="NCM3 Raven"/>
   <weapon_details id="16028" type="av_max_(left)"/>
</item>

<item id="16029">
   <name en="NCM3 Raven"/>
   <weapon_details id="16028" type="av_max_(right)"/>
</item>

SELECT count(*)
FROM fkpk.kills
WHERE attacker_weapon_id = 16028
OR attacker_weapon_id = 16029;

'2736'


<item id="16030">
   <name en="MR1 Fracture"/>
   <weapon_details id="16029" type="av_max_(left)"/>
</item>

<item id="16031">
   <name en="MR1 Fracture"/>
   <weapon_details id="16029" type="av_max_(right)"/>
</item>

SELECT count(*)
FROM fkpk.kills
WHERE attacker_weapon_id = 16030
OR attacker_weapon_id = 16031;

'9898'


<item id="16032">
   <name en="Vortex VM21"/>
   <weapon_details id="16030" type="av_max_(left)"/>
</item>

<item id="16033">
   <name en="Vortex VM21"/>
   <weapon_details id="16030" type="av_max_(right)"/>
</item>

SELECT count(*)
FROM fkpk.kills
WHERE attacker_weapon_id = 16032
OR attacker_weapon_id = 16033;

'895'
maradine is offline