MSSQL TO MYSQL

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

Re: MSSQL TO MYSQL

Postby Mort » Wed Jan 09, 2008 1:58 pm

Same thing for the PID2142 table (which I think you've called members?), I use the PID as the index field, that way you can't accidentally get duplicate player entries in there.

BTW - the reason I use PID2142 rather than just PID (or "members") was because I learnt the hard way after our BF2 stats. If you use "common" names then if/when you do the same thing again for another product, it might get confusing. So try "members2142" instead, so if by some chance you start doing a COD4 stats or BF3 or something, you could then create a "membersCOD4" or "membersBF3" table and not worry about getting things confused. and don't go saying "Oh, but I'll never have COD4 stats", then I'll find you and hit you, because I spend my entire working life hearing things like that to find 6 months later that they decided to add them after all :)
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Wed Jan 09, 2008 2:23 pm

LoL I completely understand were ur coming from mort,
but i actually kept my pid2142 tbl with its original name
same as player2142.

the members tbl i posted was just an example MYSQL tbl to show the
difference's between the MSSQL tbl.

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

Re: MSSQL TO MYSQL

Postby Mort » Sat Feb 23, 2008 8:27 pm

Hey Nos,

I'm updating the current stats code and wanted to add the MySQL parts as well.

Are the following bits all that changed in 2142datafeed for MySQL?

Code: Select all

   $db = mysql_pconnect($dbhost,$dbuser,$dbpass);
   mysql_select_db("$dbname",$db);
   mysql_query($sqlString);

And are you able to do another table create SQL query dump for the player2142 and pid2142 tables like you did a couple of posts back?
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Thu Feb 28, 2008 12:54 pm

yep the php sql connection has been updated.

heres the sql dump.

PID

Code: Select all

CREATE TABLE `nuke_pid2142` (
  `pid` varchar(16) NOT NULL default '',
  `nick` varchar(24) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `getstats` char(1) NOT NULL default '',
  `leader` int(1) default NULL,
  PRIMARY KEY  (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




player2142

Code: Select all


CREATE TABLE `nuke_player2142` (
  `acdt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `adpr` varchar(16) character set latin1 collate latin1_bin default NULL,
  `akl` varchar(16) character set latin1 collate latin1_bin default NULL,
  `akpr` varchar(16) character set latin1 collate latin1_bin default NULL,
  `asof` varchar(16) character set latin1 collate latin1_bin default NULL,
  `atp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `attp-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `attp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `Avcred` varchar(1) character set latin1 collate latin1_bin default NULL,
  `award` varchar(1000) character set latin1 collate latin1_bin default NULL,
  `awin-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `awin-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `awybt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bksgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bksgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bnspt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `brs` varchar(4) character set latin1 collate latin1_bin default NULL,
  `capa` varchar(16) character set latin1 collate latin1_bin default NULL,
  `cb` varchar(16) character set latin1 collate latin1_bin default NULL,
  `cpt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `crpt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `cs` varchar(16) character set latin1 collate latin1_bin default NULL,
  `csgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `csgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `csgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ctgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ctgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `cts` varchar(16) character set latin1 collate latin1_bin default NULL,
  `dass` varchar(16) character set latin1 collate latin1_bin default NULL,
  `dcpt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `dpm` varchar(16) character set latin1 collate latin1_bin default NULL,
  `dstrk` varchar(3) character set latin1 collate latin1_bin default NULL,
  `dths` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ent` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ent-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ent-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ent-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `expts` varchar(16) character set latin1 collate latin1_bin default NULL,
  `fe` varchar(2) character set latin1 collate latin1_bin default NULL,
  `fgm` varchar(1) character set latin1 collate latin1_bin default NULL,
  `first` varchar(1000) character set latin1 collate latin1_bin default NULL,
  `fk` varchar(1) character set latin1 collate latin1_bin default NULL,
  `fm` varchar(2) character set latin1 collate latin1_bin default NULL,
  `fv` varchar(2) character set latin1 collate latin1_bin default NULL,
  `fw` varchar(2) character set latin1 collate latin1_bin default NULL,
  `gsco` varchar(16) character set latin1 collate latin1_bin default NULL,
  `hkl` varchar(16) character set latin1 collate latin1_bin default NULL,
  `hls` varchar(16) character set latin1 collate latin1_bin default NULL,
  `htp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kdr` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kkls-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kkls-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kkls-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kkls-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klla` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klls` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klse` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klsk` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klstrk` varchar(3) character set latin1 collate latin1_bin default NULL,
  `kluav` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kpm` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ktt-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ktt-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ktt-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ktt-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `level` varchar(1000) character set latin1 collate latin1_bin default NULL,
  `lgdt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `los` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `md` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `nick` varchar(24) character set latin1 collate latin1_bin default NULL,
  `ovaccu` varchar(16) character set latin1 collate latin1_bin default NULL,
  `pdt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `pdtc` varchar(16) character set latin1 collate latin1_bin default NULL,
  `pid` varchar(16) character set latin1 collate latin1_bin default NULL,
  `resp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `rnk` varchar(3) character set latin1 collate latin1_bin default NULL,
  `rps` varchar(16) character set latin1 collate latin1_bin default NULL,
  `rvs` varchar(16) character set latin1 collate latin1_bin default NULL,
  `sasl` varchar(16) character set latin1 collate latin1_bin default NULL,
  `slbcn` varchar(16) character set latin1 collate latin1_bin default NULL,
  `slbspn` varchar(16) character set latin1 collate latin1_bin default NULL,
  `slpts` varchar(16) character set latin1 collate latin1_bin default NULL,
  `sluav` varchar(16) character set latin1 collate latin1_bin default NULL,
  `spm` varchar(16) character set latin1 collate latin1_bin default NULL,
  `suic` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tac` varchar(16) character set latin1 collate latin1_bin default NULL,
  `talw` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tas` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tasl` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tasm` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tcd` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tcrd` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tdmg` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tdrps` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tds` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgd` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgr` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tid` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tkls` varchar(16) character set latin1 collate latin1_bin default NULL,
  `toth` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tots` varchar(16) character set latin1 collate latin1_bin default NULL,
  `trp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `trpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `trpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ttp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tvdmg` varchar(16) character set latin1 collate latin1_bin default NULL,
  `twsc` varchar(16) character set latin1 collate latin1_bin default NULL,
  `unlc` varchar(4) character set latin1 collate latin1_bin default NULL,
  `unlockid` varchar(1000) character set latin1 collate latin1_bin default NULL,
  `vdstry-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `when` varchar(1500) character set latin1 collate latin1_bin default NULL,
  `whts-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `win` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-28` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-29` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bksgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ctgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `trpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tags` varchar(512) character set latin1 collate latin1_bin default NULL,
  `vkdr-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkrls-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkrls-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-14` varchar(16) character set latin1 collate latin1_bin default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


sorry it took so long.

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

Re: MSSQL TO MYSQL

Postby Mort » Thu Feb 28, 2008 7:15 pm

Thanks Nos,

A few observations:

I notice on the PID table you are setting it to NOT NULL, but then setting a default value of "blank". That kind of defeats the purpose of the NOT NULL requirement. If you allow blanks for any of those fields (except maybe name) then the data becomes useless. The idea was that it would error out and not create a record at all unless it had all required data. Also, what does the 'leader' field do?

On the player2142 table, we have set ASOF and NICK to NOT NULL as without these two values being unique you risk having invalid record entries in the table. I also don't see any index or key fields to ensure unique data for player info. Creating an index on ASOF and NICK should also help searches as those are the two main fields used for sifting the data to be displayed.

I'll add them in as-is for the current release, and maybe we can refine them if required for the full php version release.
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Fri Feb 29, 2008 8:19 am

ok I have added the index on the player2142.

but I dont see the reason why it would affect the stats query when the default values are set to blank
on the pid2142 table, wouldn't it just return an error when searching for a pid that = ""?

the leader field in the pid2142 is going to be used to displayer a clan leader status through out the stats :P

player2142 dump

Code: Select all

CREATE TABLE `nuke_player2142` (
  `acdt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `adpr` varchar(16) character set latin1 collate latin1_bin default NULL,
  `akl` varchar(16) character set latin1 collate latin1_bin default NULL,
  `akpr` varchar(16) character set latin1 collate latin1_bin default NULL,
  `asof` varchar(16) character set latin1 collate latin1_bin NOT NULL,
  `atp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `attp-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `attp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `Avcred` varchar(1) character set latin1 collate latin1_bin default NULL,
  `award` varchar(1000) character set latin1 collate latin1_bin default NULL,
  `awin-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `awin-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `awybt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bksgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bksgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bnspt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `brs` varchar(4) character set latin1 collate latin1_bin default NULL,
  `capa` varchar(16) character set latin1 collate latin1_bin default NULL,
  `cb` varchar(16) character set latin1 collate latin1_bin default NULL,
  `cpt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `crpt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `cs` varchar(16) character set latin1 collate latin1_bin default NULL,
  `csgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `csgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `csgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ctgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ctgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `cts` varchar(16) character set latin1 collate latin1_bin default NULL,
  `dass` varchar(16) character set latin1 collate latin1_bin default NULL,
  `dcpt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `dpm` varchar(16) character set latin1 collate latin1_bin default NULL,
  `dstrk` varchar(3) character set latin1 collate latin1_bin default NULL,
  `dths` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ent` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ent-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ent-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ent-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `expts` varchar(16) character set latin1 collate latin1_bin default NULL,
  `fe` varchar(2) character set latin1 collate latin1_bin default NULL,
  `fgm` varchar(1) character set latin1 collate latin1_bin default NULL,
  `first` varchar(1000) character set latin1 collate latin1_bin default NULL,
  `fk` varchar(1) character set latin1 collate latin1_bin default NULL,
  `fm` varchar(2) character set latin1 collate latin1_bin default NULL,
  `fv` varchar(2) character set latin1 collate latin1_bin default NULL,
  `fw` varchar(2) character set latin1 collate latin1_bin default NULL,
  `gsco` varchar(16) character set latin1 collate latin1_bin default NULL,
  `hkl` varchar(16) character set latin1 collate latin1_bin default NULL,
  `hls` varchar(16) character set latin1 collate latin1_bin default NULL,
  `htp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kdr` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kkls-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kkls-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kkls-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kkls-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klla` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klls` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klse` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klsk` varchar(16) character set latin1 collate latin1_bin default NULL,
  `klstrk` varchar(3) character set latin1 collate latin1_bin default NULL,
  `kluav` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kpm` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ktt-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ktt-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ktt-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ktt-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `level` varchar(1000) character set latin1 collate latin1_bin default NULL,
  `lgdt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `los` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `md` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-0-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `nick` varchar(24) character set latin1 collate latin1_bin NOT NULL,
  `ovaccu` varchar(16) character set latin1 collate latin1_bin default NULL,
  `pdt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `pdtc` varchar(16) character set latin1 collate latin1_bin default NULL,
  `pid` varchar(16) character set latin1 collate latin1_bin default NULL,
  `resp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `rnk` varchar(3) character set latin1 collate latin1_bin default NULL,
  `rps` varchar(16) character set latin1 collate latin1_bin default NULL,
  `rvs` varchar(16) character set latin1 collate latin1_bin default NULL,
  `sasl` varchar(16) character set latin1 collate latin1_bin default NULL,
  `slbcn` varchar(16) character set latin1 collate latin1_bin default NULL,
  `slbspn` varchar(16) character set latin1 collate latin1_bin default NULL,
  `slpts` varchar(16) character set latin1 collate latin1_bin default NULL,
  `sluav` varchar(16) character set latin1 collate latin1_bin default NULL,
  `spm` varchar(16) character set latin1 collate latin1_bin default NULL,
  `suic` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tac` varchar(16) character set latin1 collate latin1_bin default NULL,
  `talw` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tas` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tasl` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tasm` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tcd` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tcrd` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tdmg` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tdrps` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tds` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgd` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgr` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tid` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tkls` varchar(16) character set latin1 collate latin1_bin default NULL,
  `toth` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tots` varchar(16) character set latin1 collate latin1_bin default NULL,
  `trp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `trpm-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `trpm-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tt` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ttp` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tvdmg` varchar(16) character set latin1 collate latin1_bin default NULL,
  `twsc` varchar(16) character set latin1 collate latin1_bin default NULL,
  `unlc` varchar(4) character set latin1 collate latin1_bin default NULL,
  `unlockid` varchar(1000) character set latin1 collate latin1_bin default NULL,
  `vdstry-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `when` varchar(1500) character set latin1 collate latin1_bin default NULL,
  `whts-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `win` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-28` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-29` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-0` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-17` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-18` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-19` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-20` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-21` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-22` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-23` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-24` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-25` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-26` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-27` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-3` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-30` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-4` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-5` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-6` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-7` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-8` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-9` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bksgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `bp-1` varchar(16) character set latin1 collate latin1_bin default NULL,
  `ctgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etp-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `etpk-16` varchar(16) character set latin1 collate latin1_bin default NULL,
  `kgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tgpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `trpm-2` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdstry-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vdths-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkls-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vtp-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkls-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wdths-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wshts-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `whts-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `waccu-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wkdr-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtp-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `wtpk-31` varchar(16) character set latin1 collate latin1_bin default NULL,
  `tags` varchar(512) character set latin1 collate latin1_bin default NULL,
  `vkdr-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkdr-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkrls-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vkrls-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `vrkls-15` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-10` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-11` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-12` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-1-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mtt-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mwin-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mlos-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mbr-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `msc-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-13` varchar(16) character set latin1 collate latin1_bin default NULL,
  `mkls-2-14` varchar(16) character set latin1 collate latin1_bin default NULL,
  KEY `asof` (`asof`),
  KEY `nick` (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


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

Re: MSSQL TO MYSQL

Postby Mort » Fri Feb 29, 2008 9:04 am

nos wrote:ok I have added the index on the player2142.

but I dont see the reason why it would affect the stats query when the default values are set to blank
on the pid2142 table, wouldn't it just return an error when searching for a pid that = ""?

Although it should never happen, the reason for setting those is just an extra check to make sure "invalid" entries don't end up in the PID table.

Remember, the query goes something like "For all PIDs in PID2142 that are enabled get...", so if you allowed entries in the PID2142 table that were anything other than an actual PID, it just means your query is going to be loking for blank PID as well. Not a big issue at all, but it seemed like a really simple check to add in that could reduce debugging issues later on.

Thanks for the code update, I'll add that in right now and release the pack. I'll just put in a comment about your site showing the upcoming release for php...
Image

nos

Re: MSSQL TO MYSQL

Postby nos » Fri Feb 29, 2008 12:43 pm

not a problem, i have not had a chance to do much coding over the last couple of weeks
but things are slowly moving closer to the finish, but i will send you the standard php version
for release ASAP, the only thing is I haven't had a chance to add in pid editor to it.

the nuke version well be made public soon as i finish the stuff I'll talked about the other day. :-D


Return to “The Buddabudda Stats system”

Who is online

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