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

I may found a bug in characters_event > character join

Discussion in 'Census: Planetside 2' started by dawid, Feb 13, 2014.

  1. dawid

    dawid Guest

    The problem appears when
    <span style="text-decoration: underline">characters_event c:joins <span style="text-decoration: underline">character by index character_id

    it sometimes skips join operation aka. <span style="text-decoration: underline">attacker_character_id_join_character



    query examples showing error and correct output:

    <span style="color: #ff0000">query outputing error:


    Code:
    https://census.daybreakgames.com/get/ps2:v2/characters_event/?character_id=5428077662751450881&type=KILL,DEATH&c:join=character^on:attacker_character_id^to:character_id^show:name.first,character^on:character_id^to:character_id^show:name.first,item^on:attacker_weapon_id^to:item_id^show:name.en&c:limit=10
    Code:
    {"characters_event_list":[{"attacker_character_id":"5428139972583922673","attacker_character_id_join_character":{"name":{"first":"DrMcZonkers"}},"attacker_loadout_id":"19","attacker_vehicle_id":"7","attacker_weapon_id":"4302","attacker_weapon_id_join_item":{"name":{"en":"Saron Laser Cannon"}},"character_id":"5428077662751450881","character_id_join_character":{"name":{"first":"Dawid88"}},"character_loadout_id":"5","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392346004","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428077662751450881","attacker_character_id_join_character":{"name":{"first":"Dawid88"}},"attacker_loadout_id":"5","attacker_vehicle_id":"8","attacker_weapon_id":"4601","attacker_weapon_id_join_item":{"name":{"en":"Breaker Rocket Pods"}},"character_id":"5428173716370242161","character_loadout_id":"10","is_critical":"0","is_headshot":"0","table_type":"kills","timestamp":"1392345979","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428077662751450881","attacker_character_id_join_character":{"name":{"first":"Dawid88"}},"attacker_loadout_id":"5","attacker_vehicle_id":"8","attacker_weapon_id":"4601","attacker_weapon_id_join_item":{"name":{"en":"Breaker Rocket Pods"}},"character_id":"5428082728501179585","character_id_join_character":{"name":{"first":"RampantOne"}},"character_loadout_id":"12","is_critical":"0","is_headshot":"0","table_type":"kills","timestamp":"1392345857","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428077662751450881","attacker_character_id_join_character":{"name":{"first":"Dawid88"}},"attacker_loadout_id":"5","attacker_vehicle_id":"8","attacker_weapon_id":"4601","attacker_weapon_id_join_item":{"name":{"en":"Breaker Rocket Pods"}},"character_id":"5428082728501179585","character_id_join_character":{"name":{"first":"RampantOne"}},"character_loadout_id":"12","is_critical":"0","is_headshot":"0","table_type":"kills","timestamp":"1392345776","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428173716370240385","attacker_loadout_id":"12","attacker_vehicle_id":"0","attacker_weapon_id":"43","attacker_weapon_id_join_item":{"name":{"en":"TRAC-5"}},"character_id":"5428077662751450881","character_id_join_character":{"name":{"first":"Dawid88"}},"character_loadout_id":"5","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392345665","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428082728501179585","attacker_character_id_join_character":{"name":{"first":"RampantOne"}},"attacker_loadout_id":"13","attacker_vehicle_id":"0","attacker_weapon_id":"79","attacker_weapon_id_join_item":{"name":{"en":"T9 CARV"}},"character_id":"5428077662751450881","character_id_join_character":{"name":{"first":"Dawid88"}},"character_loadout_id":"6","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392345610","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428077662751450881","attacker_character_id_join_character":{"name":{"first":"Dawid88"}},"attacker_loadout_id":"6","attacker_vehicle_id":"0","attacker_weapon_id":"7528","attacker_weapon_id_join_item":{"name":{"en":"NC05 Jackhammer"}},"character_id":"5428082728501179585","character_id_join_character":{"name":{"first":"RampantOne"}},"character_loadout_id":"12","is_critical":"0","is_headshot":"0","table_type":"kills","timestamp":"1392345589","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428082728501179585","attacker_character_id_join_character":{"name":{"first":"RampantOne"}},"attacker_loadout_id":"12","attacker_vehicle_id":"0","attacker_weapon_id":"43","attacker_weapon_id_join_item":{"name":{"en":"TRAC-5"}},"character_id":"5428077662751450881","character_id_join_character":{"name":{"first":"Dawid88"}},"character_loadout_id":"6","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392345548","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428082728501179585","attacker_character_id_join_character":{"name":{"first":"RampantOne"}},"attacker_loadout_id":"13","attacker_vehicle_id":"0","attacker_weapon_id":"79","attacker_weapon_id_join_item":{"name":{"en":"T9 CARV"}},"character_id":"5428077662751450881","character_id_join_character":{"name":{"first":"Dawid88"}},"character_loadout_id":"3","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392345075","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428153774128157937","attacker_character_id_join_character":{"name":{"first":"Phil4nthr0p"}},"attacker_loadout_id":"19","attacker_vehicle_id":"0","attacker_weapon_id":"7441","attacker_weapon_id_join_item":{"name":{"en":"Thanatos VE70"}},"character_id":"5428077662751450881","character_id_join_character":{"name":{"first":"Dawid88"}},"character_loadout_id":"6","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392344969","world_id":"9","zone_id":"2"}],"returned":10,"timing":{"character-ms":3,"characters_event-ms":10,"item-ms":2,"total-ms":23}
    <span style="color: #00ff00">query outputing correct data:

    Code:
    https://census.daybreakgames.com/get/ps2:v2/characters_event/?character_id=5428077662751450881&type=KILL,DEATH&c:join=character_name^on:attacker_character_id^to:character_id^show:name.first,character_name^on:character_id^to:character_id^show:name.first,item^on:attacker_weapon_id^to:item_id^show:name.en&c:limit=10
    Code:
    {"characters_event_list":[{"attacker_character_id":"5428139972583922673","attacker_character_id_join_character_name":{"name":{"first":"DrMcZonkers"}},"attacker_loadout_id":"19","attacker_vehicle_id":"7","attacker_weapon_id":"4302","attacker_weapon_id_join_item":{"name":{"en":"Saron Laser Cannon"}},"character_id":"5428077662751450881","character_id_join_character_name":{"name":{"first":"Dawid88"}},"character_loadout_id":"5","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392346004","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428077662751450881","attacker_character_id_join_character_name":{"name":{"first":"Dawid88"}},"attacker_loadout_id":"5","attacker_vehicle_id":"8","attacker_weapon_id":"4601","attacker_weapon_id_join_item":{"name":{"en":"Breaker Rocket Pods"}},"character_id":"5428173716370242161","character_id_join_character_name":{"name":{"first":"Mohrati"}},"character_loadout_id":"10","is_critical":"0","is_headshot":"0","table_type":"kills","timestamp":"1392345979","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428077662751450881","attacker_character_id_join_character_name":{"name":{"first":"Dawid88"}},"attacker_loadout_id":"5","attacker_vehicle_id":"8","attacker_weapon_id":"4601","attacker_weapon_id_join_item":{"name":{"en":"Breaker Rocket Pods"}},"character_id":"5428082728501179585","character_id_join_character_name":{"name":{"first":"RampantOne"}},"character_loadout_id":"12","is_critical":"0","is_headshot":"0","table_type":"kills","timestamp":"1392345857","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428077662751450881","attacker_character_id_join_character_name":{"name":{"first":"Dawid88"}},"attacker_loadout_id":"5","attacker_vehicle_id":"8","attacker_weapon_id":"4601","attacker_weapon_id_join_item":{"name":{"en":"Breaker Rocket Pods"}},"character_id":"5428082728501179585","character_id_join_character_name":{"name":{"first":"RampantOne"}},"character_loadout_id":"12","is_critical":"0","is_headshot":"0","table_type":"kills","timestamp":"1392345776","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428173716370240385","attacker_character_id_join_character_name":{"name":{"first":"Dopexter"}},"attacker_loadout_id":"12","attacker_vehicle_id":"0","attacker_weapon_id":"43","attacker_weapon_id_join_item":{"name":{"en":"TRAC-5"}},"character_id":"5428077662751450881","character_id_join_character_name":{"name":{"first":"Dawid88"}},"character_loadout_id":"5","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392345665","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428082728501179585","attacker_character_id_join_character_name":{"name":{"first":"RampantOne"}},"attacker_loadout_id":"13","attacker_vehicle_id":"0","attacker_weapon_id":"79","attacker_weapon_id_join_item":{"name":{"en":"T9 CARV"}},"character_id":"5428077662751450881","character_id_join_character_name":{"name":{"first":"Dawid88"}},"character_loadout_id":"6","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392345610","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428077662751450881","attacker_character_id_join_character_name":{"name":{"first":"Dawid88"}},"attacker_loadout_id":"6","attacker_vehicle_id":"0","attacker_weapon_id":"7528","attacker_weapon_id_join_item":{"name":{"en":"NC05 Jackhammer"}},"character_id":"5428082728501179585","character_id_join_character_name":{"name":{"first":"RampantOne"}},"character_loadout_id":"12","is_critical":"0","is_headshot":"0","table_type":"kills","timestamp":"1392345589","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428082728501179585","attacker_character_id_join_character_name":{"name":{"first":"RampantOne"}},"attacker_loadout_id":"12","attacker_vehicle_id":"0","attacker_weapon_id":"43","attacker_weapon_id_join_item":{"name":{"en":"TRAC-5"}},"character_id":"5428077662751450881","character_id_join_character_name":{"name":{"first":"Dawid88"}},"character_loadout_id":"6","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392345548","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428082728501179585","attacker_character_id_join_character_name":{"name":{"first":"RampantOne"}},"attacker_loadout_id":"13","attacker_vehicle_id":"0","attacker_weapon_id":"79","attacker_weapon_id_join_item":{"name":{"en":"T9 CARV"}},"character_id":"5428077662751450881","character_id_join_character_name":{"name":{"first":"Dawid88"}},"character_loadout_id":"3","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392345075","world_id":"9","zone_id":"2"},{"attacker_character_id":"5428153774128157937","attacker_character_id_join_character_name":{"name":{"first":"Phil4nthr0p"}},"attacker_loadout_id":"19","attacker_vehicle_id":"0","attacker_weapon_id":"7441","attacker_weapon_id_join_item":{"name":{"en":"Thanatos VE70"}},"character_id":"5428077662751450881","character_id_join_character_name":{"name":{"first":"Dawid88"}},"character_loadout_id":"6","is_critical":"0","is_headshot":"0","table_type":"deaths","timestamp":"1392344969","world_id":"9","zone_id":"2"}],"returned":10,"timing":{"character_name-ms":2,"characters_event-ms":10,"item-ms":3,"total-ms":19}}
    btw. my game character is dawid88
     
    dawid, Feb 13, 2014
    #1

Share This Page