1. I have corrected the e-mail settings so that outgoing e-mails from these forums should be sent now. If you tried to Register or Reset your Password, please try again!
    Dismiss Notice

Get all weapon stats

Discussion in 'Census: Planetside 2' started by cesarramsan, Jun 11, 2014.

  1. cesarramsan

    cesarramsan Guest

  2. Ryekir

    Ryekir Guest

    Well, since you're pulling directly from the characters_weapon_stat you can limit the results based on any value that's in that table (similar to how you're limiting to a specific character_id).

    So, if you wanted only vehicle related stats, you could add:

    Code:
    &vehicle_id=!0
    Or if you just want to exclude all vehicle stats:

    Code:
    &vehicle_id=0
    Or if you want all stats where the stat_name value starts with the string "weapon":

    Code:
    &stat_name=^weapon
    And you can, of course, combine as many arguments as you want. So if you want all "weapon*" stats, but also excluding vehicle:

    Code:
    &stat_name=^weapon&vehicle_id=0
     
  3. cesarramsan

    cesarramsan Guest

    Hi Ryekir,

    But even non-weapon items have stat names that start with weapon. For example med applicator and ammo packs also have stat names like "<span style="color: #008000">weapon_deaths". :(

    CRamsan
     
  4. Ryekir

    Ryekir Guest

    Yeah, you'll probably just have to ignore those, or explicitly exclude them from the results using the ID values. You may also be able to find other criteria for what you want, those were just quick examples.
     

Share This Page