View source for User:Co.cane

Webmaster of [http://www.nanospy.de NanoSpy], [http://www.ventrilospy.net 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 <span style="background:#aaffaa">green</span>, values i can't get with <span style="background:#ffaaaa">red</span>, did not mark unknown values, and not needed values with <span style="background:#ccc">grey</span>.

<!--{| style="border: 1px solid black"
|+'''Army Data'''
|- style="background:#aaffaa"
|abr- ||N ||Best round score in army  	 
|- style="background:#aaffaa" 
|awr- ||N ||Worst round score in army  	 
|- style="background:#aaffaa" 
|alo- ||N ||# losses in army  	 
|- style="background:#aaffaa" 
|atm- ||E ||Time in army  	 
|- style="background:#aaffaa" 
|awn- ||N ||# wins in army  	
|}-->


{| style="border: 1px solid black"
|+'''Data Gathering'''
| || '''Code'''||'''Type'''||'''Meaning'''||'''Comment'''
|- style="background:#aaffaa" 
|1||ban||N||# times banned   ||
|- style="background:#aaffaa" 
|2 ||bbrs ||N ||Best round score  	 
|- style="background:#aaffaa" 
|3 ||bksk ||N ||Best kill streak  	 
|- style="background:#aaffaa" 
|4 ||bmap ||N ||Best round map  	 
|- style="background:#aaffaa" 
|5 ||cacp ||N ||# assists capturing control point  	 
|- style="background:#aaffaa" 
|6 ||cdsc ||N ||Commander score  	 
|- style="background:#aaffaa" 
|7 ||cmsc ||N ||Combat score  	 ||
|- style="background:#aaffaa" 
|8 ||cpcp ||N ||# times captured control point  	 ||
|- style="background:#aaffaa" 
|9 ||deth ||N ||# deaths  	 ||
|- style="background:#aaffaa" 
|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  	 ||
|- style="background:#aaffaa" 
|15 ||fkit ||N ||Favorite kit  	 ||
|- style="background:#aaffaa" 
|16 ||fmap ||N ||Favorite map  	 ||
|- style="background:#aaffaa" 
|17 ||fveh ||N ||Favorite vehicle  	 
|- style="background:#aaffaa" 
|18 ||fwea ||N ||Favorite weapon  	 
|- style="background:#aaffaa" 
|19 ||heal ||N ||# heals  	
|- style="background:#aaffaa" 
|20 ||jond ||T ||Date joined  	 
|- style="background:#aaffaa" 
|21 ||kick ||N ||# times kicked  	 
|- style="background:#aaffaa" 
|22 ||kila ||N ||# kill assists  	 
|- style="background:#aaffaa" 
|23 ||kill ||N ||# kills  	
|-
|24 ||klpm ||F ||# kills/minute  	 
|-
|25 ||klpr ||F ||# kills/round played  	
|- style="background:#aaffaa" 
|26 ||klsc ||N ||Kill score  	 
|- style="background:#aaffaa" 
|27 ||loss ||N ||# losses  	 
|- style="background:#aaffaa" 
|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  	 
|- style="background:#aaffaa" 
|34 ||rank ||N ||Rank  	 ||
|- style="background:#aaffaa" 
|35 ||rpar ||N ||# repairs  	 
|- style="background:#aaffaa" 
|36 ||rsup ||N ||# resupplies  	 
|- style="background:#aaffaa" 
|37 ||rviv ||N ||# revives  	 
|- style="background:#aaffaa" 
|38 ||scor ||N ||Global score  	 
|-
|39 ||smoc ||B ||Rank = SgtMaj of the Corps?  	 
|- style="background:#aaffaa" 
|40 ||suic ||N ||# suicides  	 
|- style="background:#aaffaa" 
|41 ||tcdr ||E ||Time as commander  	 
|- style="background:#aaffaa" 
|42 ||tsql ||E ||Time as squad leader  	 ||
|- style="background:#aaffaa" 
|43 ||tsqm ||E ||Time as squad member  	 ||
|- style="background:#aaffaa" 
|44 ||tlwf ||E ||Time as lone wolf  	 ||
|-
|45 ||tgte ||N ||# times targeted enemy  	 ||
|- style="background:#aaffaa" 
|46 ||time ||E ||Total time played  	 ||
|-
|47 ||topr ||P ||Top opponent in round  	 ||
|-
|48 ||tvcr ||P ||Top victim in round  	 ||
|- style="background:#aaffaa"
|49 ||twsc ||N ||Teamwork score  	 ||
|- style="background:#aaffaa"
|50 ||wdsk ||N ||Worst death streak  	 ||
|- style="background:#aaffaa"
|51 ||wins ||N ||# wins  	 ||
|- style="background:#aaffaa"
|52 ||lbtl ||T ||Last battle time  	 ||
|-
|53 ||vacc ||% ||Vehicle accuracy  	 ||
|- style="background:#aaffaa" 
|54 ||tkil ||N ||Team Kill  	 ||
|- style="background:#aaffaa" 
|55 ||tdmg ||N ||Team Damage  	 ||
|- style="background:#aaffaa" 
|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  	 ||
|- style="background:#aaffaa" 
|64 ||abr- ||N ||Best round score in army  	 || [[BF2Stats_LookUp_Values#Army_Designators|Lookup Values]]
|- style="background:#aaffaa" 
|65 ||awr- ||N ||Worst round score in army  	 ||
|- style="background:#aaffaa" 
|66 ||alo- ||N ||# losses in army  	 ||
|- style="background:#aaffaa" 
|67 ||atm- ||E ||Time in army  	 ||
|- style="background:#aaffaa" 
|68 ||awn- ||N ||# wins in army  	 ||
|- style="background:#aaffaa" 
| style="border-top:2px solid black;" | 69 || style="border-top:2px solid black;" | kdt- || style="border-top:2px solid black;" | N || style="border-top:2px solid black;" | # deaths using kit  	 ||  style="border-top:2px solid black;" | [[BF2Stats_LookUp_Values#Kit_Numbers|Lookup Values]]
|- style="background:#aaffaa" 
|70 ||kkd- ||R ||Kill:death ratio using kit  	 ||
|- style="background:#aaffaa" 
|71 ||kkl- ||N ||# kills using kit  	 ||
|- style="background:#aaffaa" 
|72 ||ktm- ||E ||Time playing kit  	 ||
|- style="background:#ffaaaa;" 
| style="border-top:2px solid black;" | 73 || style="border-top:2px solid black;" | mbr- || style="border-top:2px solid black;" | N || style="border-top:2px solid black;" | Best round score on this map  	 ||
|- style="background:#ffaaaa;" 
|74 ||mcm- ||N ||# completed on this map  	 ||
|- style="background:#ffaaaa;" 
|75 ||mic- ||N ||# incomplete on this map  	 
|- style="background:#aaffaa;" 
|76 ||mls- ||N ||# losses on this map  	 
|- style="background:#aaffaa;" 
|77 ||mtm- ||E ||Time on this map  	 
|- style="background:#aaffaa;" 
|78 ||mwn- ||N ||# wins on this map  	 
|- style="background:#ffaaaa;" 
|79 ||svr- ||S ||Server IP or name (svr-0 is the most recently used)  	 
|- style="background:#aaffaa;" 
| style="border-top:2px solid black;" | 80 || style="border-top:2px solid black;" | vdt- || style="border-top:2px solid black;" | N || style="border-top:2px solid black;" | # deaths by vehicle  	 ||
|- style="background:#aaffaa" 
| 81 || vkl- || N || # kills with vehicle  	 
|- style="background:#aaffaa" 
| 82 ||vkr- ||N ||# roadkills with vehicle  	 
|- style="background:#aaffaa" 
| 83 ||vtm- ||E ||Time using vehicle  	 
|- style="background:#ffaaaa" 
|84 ||vac- ||% ||Accuracy with vehicle  	 ||
|- style="background:#aaffaa" 
|85 ||vkd- ||R ||Kill:death ratio using vehicle  	 ||
|- style="background:#aaffaa" 
|86 ||wac- ||% ||Accuracy with weapon  	 ||
|- style="background:#aaffaa" 
|87 ||wdt- ||N ||# deaths while using weapon  	 ||
|- style="background:#aaffaa" 
|88 ||wkl- ||N ||# kills with weapon  	 ||
|- style="background:#aaffaa" 
|89 ||wtm- ||E ||Time using weapon  	 ||
|-  style="background:#cccccc" 
|90 ||wkd- ||R ||Kill:death ration using weapon  	 || void
|- style="background:#aaffaa" 
|116 ||de-6 ||N ||Flashbang and teargas use (SF)
|- style="background:#aaffaa" 
|117 ||de-7 ||N ||Grappling hook use (SF)
|- style="background:#aaffaa" 
|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: [http://bfbrowser.nanospy.cc Battlefield2Browser].

Other projects are [http://www.nanospy.cc NanoSpy] (a free gamequery system) and [http://www.ventrilospy.net VentriloSpy] (a free system for displaying info for Ventrilo Servers)