fixing the nba table in my database to run live 2005

[Scorpio24]

Im trying to convert my nba table in my database to run live 2005 league but when i upload ratings.txt file into nba table it shows all 0s for ratings and has players on wrong team. Does anyone know php that can help me?
heres an example of what it is doing:

Code: Select all

Table structure for table `nba`
#

CREATE TABLE `nba` (
  `season_id` int(11) NOT NULL default '1',
  `league_id` int(11) NOT NULL default '1',
  `id` int(11) NOT NULL auto_increment,
  `Pos` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `Ovr` int(11) NOT NULL default '0',
  `FG` varchar(255) NOT NULL default '',
  `threept` varchar(255) NOT NULL default '',
  `Range` varchar(255) NOT NULL default '',
  `FT` varchar(255) NOT NULL default '',
  `Dunk` varchar(255) NOT NULL default '',
  `Jump` varchar(255) NOT NULL default '',
  `Block` varchar(255) NOT NULL default '',
  `Insscore` varchar(255) NOT NULL default '',
  `strength` varchar(255) NOT NULL default '',
  `offrebounds` varchar(255) NOT NULL default '',
  `defrebounds` varchar(255) NOT NULL default '',
  `Quick` varchar(255) NOT NULL default '',
  `Speed` varchar(255) NOT NULL default '',
  `Steal` varchar(255) NOT NULL default '',
  `Pass` varchar(255) NOT NULL default '',
  `Dribble` varchar(255) NOT NULL default '',
  `OffAware` varchar(255) NOT NULL default '',
  `DefAware` varchar(255) NOT NULL default '',
  `team` varchar(255) NOT NULL default '',
  `avail` varchar(255) NOT NULL default '',
  `salary` int(11) NOT NULL default '0',
  `years` int(11) NOT NULL default '0',
  `yeartwo` varchar(255) NOT NULL default '',
  `yearthree` varchar(255) NOT NULL default '',
  `yearfour` varchar(255) NOT NULL default '',
  `yearfive` varchar(255) NOT NULL default '',
  `picture` varchar(255) NOT NULL default '',
  `enl` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1335 ;

#
# Dumping data for table `nba`
#

INSERT INTO `nba` VALUES (1, 1, 1, 'PF', 'A. Henderson', 0, 'FALSE', '0', '0', '0', '0', '0', '0', '0', '', '8273', '0', '', '5', '0', '0', '', '7', '1', 'Atlanta', '', 0, 0, '', '', '', '', '', 0);
INSERT INTO `nba` VALUES (1, 1, 2, 'C', 'T. Ratliff', 0, 'FALSE', '0', '0', '0', '0', '0', '0', '0', '', '10938', '0', '', '23', '0', '1094', '', '4', '4', 'Atlanta', '', 0, 0, '', '', '', '', '', 0);
INSERT INTO `nba` VALUES (1, 1, 3, 'SF', 'C. Crawford', 0, 'FALSE', '0', '0', '0', '0', '0', '0', '0', '', '3250', '0', '', '0', '0', '0', '', '6', '1', '', '', 0, 0, '', '', '', '', '', 0);
INSERT INTO `nba` VALUES (1, 1, 4, 'C', 'N. Mohammed', 0, 'FALSE', '0', '0', '0', '0', '0', '0', '0', '', '5250', '0', '', '19', '0', '250', '', '5', '2', 'Atlanta', '', 0, 0, '', '', '', '', '', 0);
INSERT INTO `nba` VALUES (1, 1, 5, 'PG', 'J. Terry', 0, 'FALSE', '0', '0', '0', '0', '0', '0', '0', '', '7200', '0', '', '5', '0', '300', '', '7', '2', '', '', 0, 0, '', '', '', '', '', 0);


[greenmig]

mate the guys you need to talk to are guys in non-modem leagues like the ASA or NLL. guys like framebrain and tim in NLL. I dont know names but ASA has a few smart cookies over there too.

[Scorpio24]

what are emails for them ? or website addresses?

[greenmig]

not sure of ASA but someone here will know...9I have the URL in my favourites at home)

NLL - www.nbaliveleague.com