User:Co.cane
Webmaster of NanoSpy, VentriloSpy and some other game-related pages.
Experience in: web-scripting, web-design and graphical tools, also some java and c++.
BF2 Statistics Gathering Problems
I have problems getting the following values from the gamespy servers. If i know anything about the returned data, which should provide the values, it will be written in brackets [].
- the servers the player was playing on [srv-0, srv-1, srv-2, srv-3 ...]
- Numer of bullets fired per weapon
- Vehicle Accuracy [vacc]
- Best round for every map
I copied this table and marked all values i can get with the various queries as green, values i can't get with red, did not mark unknown values, and not needed values with grey.
| Code | Type | Meaning | Comment | |
| 1 | ban | N | # times banned | |
| 2 | bbrs | N | Best round score | |
| 3 | bksk | N | Best kill streak | |
| 4 | bmap | N | Best round map | |
| 5 | cacp | N | # assists capturing control point | |
| 6 | cdsc | N | Commander score | |
| 7 | cmsc | N | Combat score | |
| 8 | cpcp | N | # times captured control point | |
| 9 | deth | N | # deaths | |
| 10 | dfcp | N | # times defended control point | |
| 11 | dkas | N | # kill assists as driver | |
| 12 | dsab | N | Driver special ability | |
| 13 | dtpm | F | # deaths/minute | |
| 14 | dtpr | F | # deaths/round played | |
| 15 | fkit | N | Favorite kit | |
| 16 | fmap | N | Favorite map | |
| 17 | fveh | N | Favorite vehicle | |
| 18 | fwea | N | Favorite weapon | |
| 19 | heal | N | # heals | |
| 20 | jond | T | Date joined | |
| 21 | kick | N | # times kicked | |
| 22 | kila | N | # kill assists | |
| 23 | kill | N | # kills | |
| 24 | klpm | F | # kills/minute | |
| 25 | klpr | F | # kills/round played | |
| 26 | klsc | N | Kill score | |
| 27 | loss | N | # losses | |
| 28 | mode0 | N | Game mode 0 | |
| 29 | mode1 | N | Game mode 1 | |
| 30 | mode2 | N | Game mode 2 | |
| 31 | osaa | % | Overall small-arms accuracy | |
| 32 | ospm | F | Overall score/minute | |
| 33 | pkas | N | # kill assists as passenger | |
| 34 | rank | N | Rank | |
| 35 | rpar | N | # repairs | |
| 36 | rsup | N | # resupplies | |
| 37 | rviv | N | # revives | |
| 38 | scor | N | Global score | |
| 39 | smoc | B | Rank = SgtMaj of the Corps? | |
| 40 | suic | N | # suicides | |
| 41 | tcdr | E | Time as commander | |
| 42 | tsql | E | Time as squad leader | |
| 43 | tsqm | E | Time as squad member | |
| 44 | tlwf | E | Time as lone wolf | |
| 45 | tgte | N | # times targeted enemy | |
| 46 | time | E | Total time played | |
| 47 | topr | P | Top opponent in round | |
| 48 | tvcr | P | Top victim in round | |
| 49 | twsc | N | Teamwork score | |
| 50 | wdsk | N | Worst death streak | |
| 51 | wins | N | # wins | |
| 52 | lbtl | T | Last battle time | |
| 53 | vacc | % | Vehicle accuracy | |
| 54 | tkil | N | Team Kill | |
| 55 | tdmg | N | Team Damage | |
| 56 | tvdm | N | Team Vehicle Damage | |
| 57 | vrk | N | Road kill with vehicle | |
| 58 | mvns | S | Top victim name | |
| 59 | mvrs | S | Top victim rank | |
| 60 | mvks | N | Top victim kills | |
| 61 | vmns | S | Top opponent's name | |
| 62 | vmrs | S | Top opponent's rank | |
| 63 | vmks | N | Top opponent's kills | |
| 64 | abr- | N | Best round score in army | Lookup Values |
| 65 | awr- | N | Worst round score in army | |
| 66 | alo- | N | # losses in army | |
| 67 | atm- | E | Time in army | |
| 68 | awn- | N | # wins in army | |
| 69 | kdt- | N | # deaths using kit | Lookup Values |
| 70 | kkd- | R | Kill:death ratio using kit | |
| 71 | kkl- | N | # kills using kit | |
| 72 | ktm- | E | Time playing kit | |
| 73 | mbr- | N | Best round score on this map | |
| 74 | mcm- | N | # completed on this map | |
| 75 | mic- | N | # incomplete on this map | |
| 76 | mls- | N | # losses on this map | |
| 77 | mtm- | E | Time on this map | |
| 78 | mwn- | N | # wins on this map | |
| 79 | svr- | S | Server IP or name (svr-0 is the most recently used) | |
| 80 | vdt- | N | # deaths by vehicle | |
| 81 | vkl- | N | # kills with vehicle | |
| 82 | vkr- | N | # roadkills with vehicle | |
| 83 | vtm- | E | Time using vehicle | |
| 84 | vac- | % | Accuracy with vehicle | |
| 85 | vkd- | R | Kill:death ratio using vehicle | |
| 86 | wac- | % | Accuracy with weapon | |
| 87 | wdt- | N | # deaths while using weapon | |
| 88 | wkl- | N | # kills with weapon | |
| 89 | wtm- | E | Time using weapon | |
| 90 | wkd- | R | Kill:death ration using weapon | void |
| 116 | de-6 | N | Flashbang and teargas use (SF) | |
| 117 | de-7 | N | Grappling hook use (SF) | |
| 118 | de-8 | N | Zip line use (SF) |
BF2Stats.class.php
I have written a php-class for gathering battlefield2 statistics. This class is capable of querying for the most important bf2stats data.
- Supports DB-saving
- Fast
- enable/disable caching
- advanced search for players
- advanced search for player IDs
- xhtml1.0 compliant
- multilanguage support
- advanced verbose and debug options
Tested with PHP 4.3.0 and PHP 5.0.4, tested with Mysql version 4.1.12 and 4.1.10a-Max.
Projects
In case anyone is interested here's my current bf2 stats project: Battlefield2Browser.
Other projects are NanoSpy (a free gamequery system) and VentriloSpy (a free system for displaying info for Ventrilo Servers)
