Ask a Question related to Macromedia ColdFusion, Design and Development.
-
DaveF67 #1
Battlefield 2 Stats / Ranking Parser Project...
This is the start of a data parser for Battlefield 2.
I cant finish it but maybe someone out there is bored and wants something to
do. Good Luck!
The code runs AS IS right now with a static data set. Use the CFHTTP to grab
realtime data based on a users ID in the URL.
**** other functions can be done as well --- general top 10 ppl etc
see [url]http://65.254.53.148/bf2/Bf2View.cgi[/url] for more info
SUPERD :+)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>BFTEST2</title>
</head>
<body>
<cfscript>
/**
* Converts Epoch time to a ColdFusion date object in local time.
*
* @param epoch Epoch time, in seconds. (Required)
* @return Returns a date object.
* @author Rob Brooks-Bilson (rbils@amkor.com)
* @version 1, June 21, 2002
*/
function EpochTimeToLocalDate(epoch) {
return DateAdd("s",epoch,DateConvert("utc2Local", "January 1 1970 00:00"));
}
// ****** TEST DATA ************
testData = "O
H asof
D 1119941921
H pid nick scor jond wins loss mode0 mode1 mode2 time smoc fkit fmap fveh fwea a
tm-0 atm-1 atm-2 awn-0 awn-1 awn-2 alo-0 alo-1 alo-2 abr-0 abr-1 abr-2 ktm-0 ktm
-1 ktm-2 ktm-3 ktm-4 ktm-5 ktm-6 kkl-0 kkl-1 kkl-2 kkl-3 kkl-4 kkl-5 kkl-6 kdt-0
kdt-1 kdt-2 kdt-3 kdt-4 kdt-5 kdt-6 kkd-0 kkd-1 kkd-2 kkd-3 kkd-4 kkd-5 kkd-6 v
tm-0 vtm-1 vtm-2 vtm-3 vtm-4 vtm-5 vtm-6 vkl-0 vkl-1 vkl-2 vkl-3 vkl-4 vkl-5 vkl
-6 vdt-0 vdt-1 vdt-2 vdt-3 vdt-4 vdt-5 vdt-6 vac-0 vac-1 vac-2 vac-3 vac-4 vac-5
vac-6 vkr-0 vkr-1 vkr-2 vkr-3 vkr-4 vkr-5 vkr-6 vrk wtm-0 wtm-1 wtm-2 wtm-3 wtm
-4 wtm-5 wtm-6 wtm-7 wtm-8 wtm-9 wtm-10 wtm-11 wtm-12 wkl-0 wkl-1 wkl-2 wkl-3 wk
l-4 wkl-5 wkl-6 wkl-7 wkl-8 wkl-9 wkl-10 wkl-11 wkl-12 wdt-0 wdt-1 wdt-2 wdt-3 w
dt-4 wdt-5 wdt-6 wdt-7 wdt-8 wdt-9 wdt-10 wdt-11 wdt-12 wac-0 wac-1 wac-2 wac-3
wac-4 wac-5 wac-6 wac-7 wac-8 wac-9 wac-10 wac-11 wac-12 twsc cpcp cacp dfcp hea
l rviv rsup rpar tgte dsab dkas pkas cmsc osaa kill kila deth suic bksk wdsk tvc
r topr klpm dtpm ospm klpr dtpr cdsc tcdr bmap bbrs mbr-0 mbr-1 mbr-2 mbr-3 mbr-
4 mbr-5 mbr-6 mbr-100 mbr-101 mbr-102 mbr-103 mbr-104 mbr-105 mwn-0 mwn-1 mwn-2
mwn-3 mwn-4 mwn-5 mwn-6 mwn-100 mwn-101 mwn-102 mwn-103 mwn-104 mwn-105 mls-0 ml
s-1 mls-2 mls-3 mls-4 mls-5 mls-6 mls-100 mls-101 mls-102 mls-103 mls-104 mls-10
5 mtm-0 mtm-1 mtm-2 mtm-3 mtm-4 mtm-5 mtm-6 mtm-100 mtm-101 mtm-102 mtm-103 mtm-
104 mtm-105 mcm-0 mcm-1 mcm-2 mcm-3 mcm-4 mcm-5 mcm-6 mcm-100 mcm-101 mcm-102 mc
m-103 mcm-104 mcm-105 mic-0 mic-1 mic-2 mic-3 mic-4 mic-5 mic-6 mic-100 mic-101
mic-102 mic-103 mic-104 mic-105 svr-0 svr-1 svr-2 svr-3 svr-4 svr-5 svr-6 svr-7
svr-8 svr-9 kick ban
D 44314195 KuranesGrey 429 1119318900 13 16 29 0 0 33974 0 1 5 0 0 21888 9200 28
86 12 0 1 6 7 3 58 35 28 5332 13932 1417 460 3126 2013 6060 24 63 4 2 5 4 27 43
111 8 2 20 14 21 24:43 21:37 1:2 1:1 1:4 2:7 9:7 3375 262 615 1376 2552 0 316 17
0 1 2 3 0 6 16 3 4 7 23 0 3 0 0 0 0 0 0 0 1 0 0 0 0 0 3 0 8905 972 1220 1639 39
51 1439 906 2962 1051 4 19 384 280 28 8 1 4 24 1 8 5 1 0 0 2 3 56 25 13 11 12 10
13 19 5 0 0 1 3 20 50 25 18 49 29 42 10 35 0 0 63 28 131 45 36 7 0 0 1 1 0 20 0
29 258 21 129 29 219 5 16 12 44451867 44116446 0.23 0.39 0.76 4.45 7.55 97 3427
2 58 23 0 58 0 0 30 18 0 0 0 7 0 28 2 0 1 0 0 3 3 0 0 0 2 0 2 1 0 5 0 0 7 0 0 0
0 0 0 3 4833 0 8401 0 0 12686 3294 0 0 0 1604 0 3156 1 0 4 0 0 8 3 0 0 0 1 0 2
2 0 2 0 0 2 0 0 0 0 1 0 3 0 0 0 0 0 0 0 0 0 0 0 0
$ 1878 $";
// ***************** DATA SET LABLES ****************
tags = "
asof,T,Rank date
ban,N,times banned
bbrs,N,Best round score
bksk,N,Best kill streak
bmap,N,Best round map
cacp,N,assists capturing control point
cdsc,N,Commander score
cmsc,N,Combat score
cpcp,N,times captured control point
deth,N,deaths
dfcp,N,times defended control point
dkas,N,kill assists as driver
dsab,N,Driver special ability
dtpm,F,deaths/minute
dtpr,F,deaths/round played
fkit,N,Favorite kit
fmap,N,Favorite map
fveh,N,Favorite vehicle
fwea,N,Favorite weapon
heal,N,heals
jond,T,Date joined
kick,N,times kicked
kila,N,kill assists
kill,N,kills
klpm,F,kills/minute
klpr,F,kills/round played
klsc,N,Kill score
loss,N,losses
mode0,N,Game mode 0
mode1,N,Game mode 1
mode2,N,Game mode 2
nick,S,Account name
osaa,%,Overall small-arms accuracy
ospm,F,Overall score/minute
pid,N,Account ID
pkas,N,kill assists as passenger
rank,N,Rank
rpar,N,repairs
rsup,N,resupplies
rviv,N,revives
scor,N,Glxxxxxxbal scoxxre
smoc,B,Rank = SgtMaj of the Corps?
suic,N,suicides
tcdr,E,Time as commander
tsql,E,Time as squad leader
tsqm,E,Time as squad member
tlwf,E,Time as lone wolf
tgte,N,times targeted enemy
time,E,Total time played
topr,P,Top opponent in round
tvcr,P,Top victim in round
twsc,N,Teamwork score
wdsk,N,Worst death streak
wins,N,wins
lbtl,T,Last battle time
vacc,%,Vehicle accuracy
tkil,N,Team Kill
tdmg,N,Team Damage
tvdm,N,Team Vehicle Damage
vrk,N,Road kill with vehicle
mvns,S,Top victim name
mvrs,S,Top victim rank
mvks,N,Top victim kills
vmns,S,Top opponent's name
vmrs,S,Top opponent's rank
vmks,N,Top opponent's kills
abr-0,N,Best round score (USA)
abr-1,N,Best round score (MEC)
abr-2,N,Best round score (China)
awr-0,N,Worst round score (USA)
awr-1,N,Worst round score (MEC)
awr-2,N,Worst round score (China)
alo-0,N,losses (USA)
alo-1,N,losses (MEC)
alo-2,N,losses (China)
atm-0,E,Time played (USA)
atm-1,E,Time played (MEC)
atm-2,E,Time played (China)
awn-0,N,wins (USA)
awn-1,N,wins (MEC)
awn-2,N,wins (China)
kdt-0,N,deaths while anti-tank
kdt-1,N,deaths while assault
kdt-2,N,deaths while engineer
kdt-3,N,deaths while medic
kdt-4,N,deaths while spec-ops
kdt-5,N,deaths while support
kdt-6,N,deaths while sniper
kkd-0,R,Kill:death ratio while anti-tank
kkd-1,R,Kill:death ratio while assault
kkd-2,R,Kill:death ratio while engineer
kkd-3,R,Kill:death ratio while medic
kkd-4,R,Kill:death ratio while spec-ops
kkd-5,R,Kill:death ratio while support
kkd-6,R,Kill:death ratio while sniper
kkl-0,N,kills while anti-tank
kkl-1,N,kills while assault
kkl-2,N,kills while engineer
kkl-3,N,kills while medic
kkl-4,N,kills while spec-ops
kkl-5,N,kills while support
kkl-6,N,kills while sniper
ktm-0,E,Time played while anti-tank
ktm-1,E,Time played while assault
ktm-2,E,Time played while engineer
ktm-3,E,Time played while medic
ktm-4,E,Time played while spec-ops
ktm-5,E,Time played while support
ktm-6,E,Time played while sniper
mbr-0,N,Best round score on Kubra Dam
mbr-1,N,Best round score on Mashtuur City
mbr-2,N,Best round score on Operation Clean Sweep
mbr-3,N,Best round score on Zatar Wetlands
mbr-4,N,Best round score on Strike at Karkand
mbr-5,N,Best round score on Sharqi Peninsula
mbr-6,N,Best round score on Gulf of Oman
mbr-100,N,Best round score on Daqing Oilfields
mbr-101,N,Best round score on Dalian Plant
mbr-102,N,Best round score on Dragon Valley
mbr-103,N,Best round score on FuShe Pass (The Glowing Pass?)
mbr-104,N,Best round score on Dalian Plant (Hingan Hills?)
mbr-105,N,Best round score on Songhua Stalemate
mcm-0,N,completed on Kubra Dam
mcm-1,N,completed on Mashtuur City
mcm-2,N,completed on Operation Clean Sweep
mcm-3,N,completed on Zatar Wetlands
mcm-4,N,completed on Strike at Karkand
mcm-5,N,completed on Sharqi Peninsula
mcm-6,N,completed on Gulf of Oman
mcm-100,N,completed on Daqing Oilfields
mcm-101,N,completed on Dalian Plant
mcm-102,N,completed on Dragon Valley
mcm-103,N,completed on FuShe Pass (The Glowing Pass?)
mcm-104,N,completed on Dalian Plant (Hingan Hills?)
mcm-105,N,completed on Songhua Stalemate
mic-0,N,incomplete on Kubra Dam
mic-1,N,incomplete on Mashtuur City
mic-2,N,incomplete on Operation Clean Sweep
mic-3,N,incomplete on Zatar Wetlands
mic-4,N,incomplete on Strike at Karkand
mic-5,N,incomplete on Sharqi Peninsula
mic-6,N,incomplete on Gulf of Oman
mic-100,N,incomplete on Daqing Oilfields
mic-101,N,incomplete on Dalian Plant
mic-102,N,incomplete on Dragon Valley
mic-103,N,incomplete on FuShe Pass (The Glowing Pass?)
mic-104,N,incomplete on Dalian Plant (Hingan Hills?)
mic-105,N,incomplete on Songhua Stalemate
mls-0,N,losses on Kubra Dam
mls-1,N,losses on Mashtuur City
mls-2,N,losses on Operation Clean Sweep
mls-3,N,losses on Zatar Wetlands
mls-4,N,losses on Strike at Karkand
mls-5,N,losses on Sharqi Peninsula
mls-6,N,losses on Gulf of Oman
mls-100,N,losses on Daqing Oilfields
mls-101,N,losses on Dalian Plant
mls-102,N,losses on Dragon Valley
mls-103,N,losses on FuShe Pass (The Glowing Pass?)
mls-104,N,losses on Dalian Plant (Hingan Hills?)
mls-105,N,losses on Songhua Stalemate
mtm-0,E,Time on Kubra Dam
mtm-1,E,Time on Mashtuur City
mtm-2,E,Time on Operation Clean Sweep
mtm-3,E,Time on Zatar Wetlands
mtm-4,E,Time on Strike at Karkand
mtm-5,E,Time on Sharqi Peninsula
mtm-6,E,Time on Gulf of Oman
mtm-100,E,Time on Daqing Oilfields
mtm-101,E,Time on Dalian Plant
mtm-102,E,Time on Dragon Valley
mtm-103,E,Time on FuShe Pass (The Glowing Pass?)
mtm-104,E,Time on Dalian Plant (Hingan Hills?)
mtm-105,E,Time on Songhua Stalemate
mwn-0,N,wins on Kubra Dam
mwn-1,N,wins on Mashtuur City
mwn-2,N,wins on Operation Clean Sweep
mwn-3,N,wins on Zatar Wetlands
mwn-4,N,wins on Strike at Karkand
mwn-5,N,wins on Sharqi Peninsula
mwn-6,N,wins on Gulf of Oman
mwn-100,N,wins on Daqing Oilfields
mwn-101,N,wins on Dalian Plant
mwn-102,N,wins on Dragon Valley
mwn-103,N,wins on FuShe Pass (The Glowing Pass?)
mwn-104,N,wins on Dalian Plant (Hingan Hills?)
mwn-105,N,wins on Songhua Stalemate
svr-0,S,0 Server IP or name
svr-1,S,1 Server IP or name
svr-2,S,2 Server IP or name
svr-3,S,3 Server IP or name
svr-4,S,4 Server IP or name
svr-5,S,5 Server IP or name
svr-6,S,6 Server IP or name
svr-7,S,7 Server IP or name
svr-8,S,8 Server IP or name
svr-9,S,9 Server IP or name
vdt-0,N,deaths by armor
vdt-1,N,deaths by aviator
vdt-2,N,deaths by air defense
vdt-3,N,deaths by helicopter
vdt-4,N,deaths by transpo
DaveF67 Guest
-
Ranking of results?
I've got various statistics, some are calculated from a query, which I'm putting into a custom query which I'm running a query of a query on. This... -
Parser Error on the base project created by Visual Studio
Hi, I think you should configure your web directory in IIS as application. Cheers, -- Maras -
ASP/SQL Ranking Query
Tim J wrote: With Access, I can't think of any way to do this that does not involve a custom function called from the query. Unfortunately, you... -
sorting and ranking
"shallabaz" <shallabaz@yahoo.com> wrote in message news:0c1f01c3454f$3abb6b40$a501280a@phx.gbl... Assuming you have properly normalized tables it... -
Combo box and ranking
X records on a continuous form which I want to number 1 to X. Any ideas about how I can use a combo to do this e.g. if there are five records to... -
DaveF67 #2
Re: Battlefield 2 Stats / Ranking Parser Project...
****** THE TEST DATA SHOULD LOOK LIKE THIS .... FIX IN THE SCRIPT!
// ****** TEST DATA ************
testData = "O
H asof
D 1119941921
H pid nick scor jond wins loss mode0 mode1 mode2 time smoc fkit fmap fveh fwea a
tm-0 atm-1 atm-2 awn-0 awn-1 awn-2 alo-0 alo-1 alo-2 abr-0 abr-1 abr-2 ktm-0 ktm
-1 ktm-2 ktm-3 ktm-4 ktm-5 ktm-6 kkl-0 kkl-1 kkl-2 kkl-3 kkl-4 kkl-5 kkl-6 kdt-0
kdt-1 kdt-2 kdt-3 kdt-4 kdt-5 kdt-6 kkd-0 kkd-1 kkd-2 kkd-3 kkd-4 kkd-5 kkd-6 v
tm-0 vtm-1 vtm-2 vtm-3 vtm-4 vtm-5 vtm-6 vkl-0 vkl-1 vkl-2 vkl-3 vkl-4 vkl-5 vkl
-6 vdt-0 vdt-1 vdt-2 vdt-3 vdt-4 vdt-5 vdt-6 vac-0 vac-1 vac-2 vac-3 vac-4 vac-5
vac-6 vkr-0 vkr-1 vkr-2 vkr-3 vkr-4 vkr-5 vkr-6 vrk wtm-0 wtm-1 wtm-2 wtm-3 wtm
-4 wtm-5 wtm-6 wtm-7 wtm-8 wtm-9 wtm-10 wtm-11 wtm-12 wkl-0 wkl-1 wkl-2 wkl-3 wk
l-4 wkl-5 wkl-6 wkl-7 wkl-8 wkl-9 wkl-10 wkl-11 wkl-12 wdt-0 wdt-1 wdt-2 wdt-3 w
dt-4 wdt-5 wdt-6 wdt-7 wdt-8 wdt-9 wdt-10 wdt-11 wdt-12 wac-0 wac-1 wac-2 wac-3
wac-4 wac-5 wac-6 wac-7 wac-8 wac-9 wac-10 wac-11 wac-12 twsc cpcp cacp dfcp hea
l rviv rsup rpar tgte dsab dkas pkas cmsc osaa kill kila deth suic bksk wdsk tvc
r topr klpm dtpm ospm klpr dtpr cdsc tcdr bmap bbrs mbr-0 mbr-1 mbr-2 mbr-3 mbr-
4 mbr-5 mbr-6 mbr-100 mbr-101 mbr-102 mbr-103 mbr-104 mbr-105 mwn-0 mwn-1 mwn-2
mwn-3 mwn-4 mwn-5 mwn-6 mwn-100 mwn-101 mwn-102 mwn-103 mwn-104 mwn-105 mls-0 ml
s-1 mls-2 mls-3 mls-4 mls-5 mls-6 mls-100 mls-101 mls-102 mls-103 mls-104 mls-10
5 mtm-0 mtm-1 mtm-2 mtm-3 mtm-4 mtm-5 mtm-6 mtm-100 mtm-101 mtm-102 mtm-103 mtm-
104 mtm-105 mcm-0 mcm-1 mcm-2 mcm-3 mcm-4 mcm-5 mcm-6 mcm-100 mcm-101 mcm-102 mc
m-103 mcm-104 mcm-105 mic-0 mic-1 mic-2 mic-3 mic-4 mic-5 mic-6 mic-100 mic-101
mic-102 mic-103 mic-104 mic-105 svr-0 svr-1 svr-2 svr-3 svr-4 svr-5 svr-6 svr-7
svr-8 svr-9 kick ban
D 44314195 KuranesGrey 429 1119318900 13 16 29 0 0 33974 0 1 5 0 0 21888 9200 28
86 12 0 1 6 7 3 58 35 28 5332 13932 1417 460 3126 2013 6060 24 63 4 2 5 4 27 43
111 8 2 20 14 21 24:43 21:37 1:2 1:1 1:4 2:7 9:7 3375 262 615 1376 2552 0 316 17
0 1 2 3 0 6 16 3 4 7 23 0 3 0 0 0 0 0 0 0 1 0 0 0 0 0 3 0 8905 972 1220 1639 39
51 1439 906 2962 1051 4 19 384 280 28 8 1 4 24 1 8 5 1 0 0 2 3 56 25 13 11 12 10
13 19 5 0 0 1 3 20 50 25 18 49 29 42 10 35 0 0 63 28 131 45 36 7 0 0 1 1 0 20 0
29 258 21 129 29 219 5 16 12 44451867 44116446 0.23 0.39 0.76 4.45 7.55 97 3427
2 58 23 0 58 0 0 30 18 0 0 0 7 0 28 2 0 1 0 0 3 3 0 0 0 2 0 2 1 0 5 0 0 7 0 0 0
0 0 0 3 4833 0 8401 0 0 12686 3294 0 0 0 1604 0 3156 1 0 4 0 0 8 3 0 0 0 1 0 2
2 0 2 0 0 2 0 0 0 0 1 0 3 0 0 0 0 0 0 0 0 0 0 0 0
$ 1878 $";
DaveF67 Guest



Reply With Quote

