New fields added to BF2142 stats feed (13 Sept)

For discussion of the BB stats code.
User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4231
Joined: Thu Dec 01, 2005 10:40 pm

New fields added to BF2142 stats feed (13 Sept)

Postby Mort » Sat Sep 13, 2008 10:08 pm

Stats for the new game modes are now coming back in the feed. Just need to work out which game mode refers to each value.

tgpm-3 4 5 6
kgpm-3 4 5 6
bksgpm-3 4 5 6
ctgpm-3 4 5 6
csgpm-3 4 5 6
trpm-3 4 5 6

Code: Select all

 ALTER TABLE [dbo].[player2142] ADD
   [tgpm-3] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [tgpm-4] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [tgpm-5] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [tgpm-6] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,

   [kgpm-3] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [kgpm-4] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [kgpm-5] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [kgpm-6] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,

   [bksgpm-3] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [bksgpm-4] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [bksgpm-5] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [bksgpm-6] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,

   [ctgpm-3] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [ctgpm-4] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [ctgpm-5] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [ctgpm-6] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,

   [csgpm-3] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [csgpm-4] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [csgpm-5] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [csgpm-6] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,

   [trpm-3] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [trpm-4] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [trpm-5] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL ,
   [trpm-6] [varchar] (16) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NULL
Image

User avatar
Piers
Comfortable with my sexuality
Comfortable with my sexuality
Posts: 1408
Joined: Fri Dec 02, 2005 7:57 am
Location: Horse country

Re: New fields added to BF2142 stats feed (13 Sept)

Postby Piers » Sun Sep 14, 2008 9:27 am

New game modes added - they've finally put in the stat for assault lines commander score etc., and I guess added in 4-6 for the new modes.

tgpm-3 4 5 6 - time in game mode
kgpm-3 4 5 6 - kills in game mode
bksgpm-3 4 5 6 - best kill streak in game mode
ctgpm-3 4 5 6 - um, can't remember... probably time as commander
csgpm-3 4 5 6 - commander score in game mode
trpm-3 4 5 6 - rounds played in game mode
Image

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4231
Joined: Thu Dec 01, 2005 10:40 pm

Re: New fields added to BF2142 stats feed (13 Sept)

Postby Mort » Sun Sep 14, 2008 8:58 pm

It's what the 3, 4, 5 and 6 game modes are referring to that we need to work out (and add the the stats pages as well)
Image

User avatar
Piers
Comfortable with my sexuality
Comfortable with my sexuality
Posts: 1408
Joined: Fri Dec 02, 2005 7:57 am
Location: Horse country

Re: New fields added to BF2142 stats feed (13 Sept)

Postby Piers » Sun Sep 14, 2008 10:56 pm

My guess is they're finally getting their shit together - currently there's
0 - conquest
1 - titan
2 - assault lines

maybe they're going to rework the code for no vehicles, conquest double, double assault lines, or whatever to report separately from conquest.
maybe they're going to have a last ditch milking of the franchise, a la Euro Force & Armored Fury.
Image

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4231
Joined: Thu Dec 01, 2005 10:40 pm

Re: New fields added to BF2142 stats feed (13 Sept)

Postby Mort » Wed Sep 17, 2008 9:47 am

Somethings broke again....
Image

User avatar
Piers
Comfortable with my sexuality
Comfortable with my sexuality
Posts: 1408
Joined: Fri Dec 02, 2005 7:57 am
Location: Horse country

Re: New fields added to BF2142 stats feed (13 Sept)

Postby Piers » Wed Sep 17, 2008 1:11 pm

I'll have to check tonight, I don't have the source code with me.
Image

User avatar
Mort
Alpha-Forum Whore
Alpha-Forum Whore
Posts: 4231
Joined: Thu Dec 01, 2005 10:40 pm

Re: New fields added to BF2142 stats feed (13 Sept)

Postby Mort » Wed Sep 17, 2008 1:19 pm

Don't worry, it's probably some more fields added... I'll fix it up if that's all it is.

Update: False alarm. Just looks like the stats feed crashed for no apparent reason and the import/processing scripts just failed. I just re-ran the import for the missing players and it's all fine.
Image


Return to “The Buddabudda Stats system”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests