Stuff

Changes needed to support rank, events_played, and events_started

--------------------------------------

Make these SQL adjustments:

-- player_stats adds 5 new columns
-- new "rank" table has 2 columns


for MySQL:

CREATE TABLE player_stats (
  stat_key varchar(255) NOT NULL default '',
  score varchar(20) default NULL,
  score_opposing varchar(20) default NULL,
  score_attempts smallint(6) default NULL,
  score_attempts_opposing smallint(6) default NULL,
  score_percentage decimal(4,3) default NULL,
  score_percentage_opposing decimal(4,3) default NULL,
  events_played smallint(6) default NULL,
  events_started smallint(6) default NULL,
  time_played_event varchar(20) default NULL,
  time_played_total varchar(20) default NULL,
  time_played_event_average varchar(20) default NULL,
  PRIMARY KEY  (stat_key)
) TYPE=MyISAM;


CREATE TABLE rank (
  stat_key varchar(255) NOT NULL default '',
  value smallint(6) default NULL,
  PRIMARY KEY  (stat_key)
) TYPE=MyISAM;

For SQL Server:

CREATE TABLE player_stats (
  stat_key varchar(255) NOT NULL default '',
  score varchar(20) default NULL,
  score_opposing varchar(20) default NULL,
  score_attempts smallint default NULL,
  score_attempts_opposing smallint default NULL,
  score_percentage decimal(4,3) default NULL,
  score_percentage_opposing decimal(4,3) default NULL,
  events_played smallint default NULL,
  events_started smallint default NULL,
  time_played_event varchar(15) default NULL,
  time_played_total varchar(15) default NULL,
  time_played_event_average varchar(15) default NULL

)

CREATE TABLE rank (
  stat_key varchar(255) NOT NULL default '',
  value smallint NOT NULL default '',
  );


--------------------------------------
Edit dbSportMaps/core.def, change [player_stats] section and add new [rank] section:


[player_stats]
score:VARCHAR
score_opposing:VARCHAR
score_attempts:SMALLINT
score_attempts_opposing:SMALLINT
score_percentage:SMALLINT
score_percentage_opposing:SMALLINT
events_played:SMALLINT
events_started:SMALLINT
time_played_event:VARCHAR
time_played_total:VARCHAR
time_played_event_average:VARCHAR


[rank]
value:SMALLINT

--------------------------------------

Edit bottom of active-fixtures-players.dat:

league/l.nascar.com.nextel:event-score,event-stats,lineup,driver-stats
league/l.nascar.com.winston:event-score,event-stats,lineup,driver-stats
league/l.nascar.com.busch:event-score,event-stats,lineup,driver-stats
league/l.nascar.com.craftsman:event-score,event-stats,lineup,driver-stats