Reply to thread

Message

<blockquote data-quote="invitro" data-source="post: 200911" data-attributes="member: 446">Gotcha, thanks.&nbsp; What I couldn't remember or didn't know is if TPA always rejected the 1T rollover for some or all platforms.Here are all of his current high scores (in the top 10,000 or so):[CODE]ID TABLE&nbsp; &nbsp; &nbsp; |&nbsp;&nbsp; RANK |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SCORE | DATE&nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; ORANK | USERNAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |19 STTNG&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; 1 |&nbsp; &nbsp; 1,890,199,057,550 | 2014-02-25 |&nbsp; &nbsp; &nbsp; 1 | www.vpforums.org&nbsp; &nbsp;&nbsp; |20 AFM&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; 7 |&nbsp; &nbsp; &nbsp; 644,245,109,590 | 2014-02-25 |&nbsp; &nbsp; &nbsp; 2 | www.vpforums.org&nbsp; &nbsp;&nbsp; |30 CP&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; &nbsp;&nbsp; 13 |&nbsp; &nbsp; &nbsp; &nbsp; 1,519,065,310 | 2014-02-25 |&nbsp; &nbsp; &nbsp; 5 | www.vpforums.org&nbsp; &nbsp;&nbsp; |29 Pin*Bot&nbsp; &nbsp; |&nbsp; &nbsp;&nbsp; 18 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 37,236,730 | 2014-02-25 |&nbsp; &nbsp;&nbsp; 10 | www.vpforums.org&nbsp; &nbsp;&nbsp; |27 SpSh&nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; &nbsp;&nbsp; 26 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 12,563,870 | 2014-02-25 |&nbsp; &nbsp;&nbsp; 11 | www.vpforums.org&nbsp; &nbsp;&nbsp; |42 BRose&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;&nbsp; 29 |&nbsp; &nbsp; &nbsp; &nbsp; 2,034,725,710 | 2014-02-25 |&nbsp; &nbsp;&nbsp; 12 | www.vpforums.org&nbsp; &nbsp;&nbsp; |41 FT&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; &nbsp;&nbsp; 34 |&nbsp; &nbsp; &nbsp; &nbsp; 1,823,610,490 | 2014-02-25 |&nbsp; &nbsp; &nbsp; 7 | www.vpforums.org&nbsp; &nbsp;&nbsp; |17 SS&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; &nbsp;&nbsp; 39 |&nbsp; &nbsp; &nbsp; &nbsp; 1,763,648,290 | 2014-02-25 |&nbsp; &nbsp;&nbsp; 23 | www.vpforums.org&nbsp; &nbsp;&nbsp; |&nbsp;1 RBioN&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;&nbsp; 87 |&nbsp; &nbsp; &nbsp; &nbsp; 1,973,748,810 | 2014-02-25 |&nbsp; &nbsp;&nbsp; 74 | www.vpforums.org&nbsp; &nbsp;&nbsp; |43 BK2K&nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; &nbsp; &nbsp; 1 |&nbsp; &nbsp; &nbsp;&nbsp; 71,200,687,840 | 2014-10-07 |&nbsp; &nbsp; &nbsp; 1 | www.vpforums.org&nbsp; &nbsp;&nbsp; |25 CentPark&nbsp;&nbsp; |&nbsp; &nbsp; &nbsp; 6 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 16,899 | 2014-10-07 |&nbsp; &nbsp; &nbsp; 5 | www.vpforums.org&nbsp; &nbsp;&nbsp; |&nbsp;3 BH&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; &nbsp; &nbsp; 6 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 136,951,830 | 2014-10-07 |&nbsp; &nbsp; &nbsp; 6 | www.vpforums.org&nbsp; &nbsp;&nbsp; |33 GoinNuts&nbsp;&nbsp; |&nbsp; &nbsp; &nbsp; 7 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 13,942,700 | 2014-10-07 |&nbsp; &nbsp; &nbsp; 5 | www.vpforums.org&nbsp; &nbsp;&nbsp; |21 Genie&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; 7 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 10,082,510 | 2014-10-07 |&nbsp; &nbsp; &nbsp; 5 | www.vpforums.org&nbsp; &nbsp;&nbsp; |23 FirePwr&nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; 7 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6,596,640 | 2014-10-07 |&nbsp; &nbsp; &nbsp; 5 | www.vpforums.org&nbsp; &nbsp;&nbsp; |16 BigShot&nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; 9 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,489,570 | 2014-10-07 |&nbsp; &nbsp; &nbsp; 7 | www.vpforums.org&nbsp; &nbsp;&nbsp; |&nbsp;9 Gorgar&nbsp; &nbsp;&nbsp; |&nbsp; &nbsp; &nbsp; 9 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 11,631,890 | 2014-10-07 |&nbsp; &nbsp; &nbsp; 8 | www.vpforums.org&nbsp; &nbsp;&nbsp; |ID TABLE&nbsp; &nbsp; &nbsp; |&nbsp;&nbsp; RANK |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SCORE | DATE&nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; ORANK | USERNAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |11 BK&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; &nbsp;&nbsp; 12 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 219,875,640 | 2014-10-07 |&nbsp; &nbsp;&nbsp; 11 | www.vpforums.org&nbsp; &nbsp;&nbsp; |35 HH&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |&nbsp; 24115 |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 20,430 | 2014-10-07 |&nbsp; 18193 | www.vpforums.org&nbsp; &nbsp;&nbsp; |[/CODE]And just to be sure, I know the 2014-10-07 scores were made since 2014-10-03, because I have a data set for 2014-10-03 that does not have those scores.&nbsp; I might as well and paste his scores on 2014-10-03:[CODE]mysql&gt; select * from tpa_leaderboard where username='www.vpforums.org' and date &gt;= '2014-10-03' and date &lt; '2014-10-07';+---------+----------------+------+------------------+---------------+------------+| tableid | tableabbr&nbsp; &nbsp; &nbsp; | rank | username&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; | score&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; | date&nbsp; &nbsp; &nbsp;&nbsp; |+---------+----------------+------+------------------+---------------+------------+|&nbsp; &nbsp; &nbsp;&nbsp; 1 | Ripleys&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp;&nbsp; 83 | www.vpforums.org |&nbsp; &nbsp; 1973748810 | 2014-10-03 ||&nbsp; &nbsp; &nbsp;&nbsp; 3 | BlkHole&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp;&nbsp; 12 | www.vpforums.org |&nbsp; &nbsp; &nbsp; 45708460 | 2014-10-03 ||&nbsp; &nbsp; &nbsp;&nbsp; 9 | Gorgar&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |&nbsp;&nbsp; 23 | www.vpforums.org |&nbsp; &nbsp; &nbsp;&nbsp; 3466590 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 11 | BlackKnight&nbsp; &nbsp; |&nbsp;&nbsp; 18 | www.vpforums.org |&nbsp; &nbsp;&nbsp; 123973970 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 16 | BigShot&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp;&nbsp; 31 | www.vpforums.org |&nbsp; &nbsp; &nbsp; &nbsp; 600080 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 17 | ElviraSS&nbsp; &nbsp; &nbsp;&nbsp; |&nbsp;&nbsp; 31 | www.vpforums.org |&nbsp; &nbsp; 1763648290 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 19 | StarTrekTNG&nbsp; &nbsp; |&nbsp; &nbsp; 1 | www.vpforums.org | 1890199057550 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 20 | AttackFromMars |&nbsp; &nbsp; 4 | www.vpforums.org |&nbsp; 644245109590 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 21 | Genie&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; 9 | www.vpforums.org |&nbsp; &nbsp; &nbsp;&nbsp; 5827550 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 23 | FirePwr&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp;&nbsp; 11 | www.vpforums.org |&nbsp; &nbsp; &nbsp;&nbsp; 4595110 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 25 | CentralPark&nbsp; &nbsp; |&nbsp;&nbsp; 15 | www.vpforums.org |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9017 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 27 | SpaceShuttle&nbsp;&nbsp; |&nbsp;&nbsp; 17 | www.vpforums.org |&nbsp; &nbsp; &nbsp; 12563870 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 29 | PinBot&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; |&nbsp;&nbsp; 17 | www.vpforums.org |&nbsp; &nbsp; &nbsp; 37236730 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 30 | ChampionPub&nbsp; &nbsp; |&nbsp;&nbsp; 10 | www.vpforums.org |&nbsp; &nbsp; 1519065310 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 41 | FishTales&nbsp; &nbsp; &nbsp; |&nbsp;&nbsp; 22 | www.vpforums.org |&nbsp; &nbsp; 1823610490 | 2014-10-03 ||&nbsp; &nbsp; &nbsp; 42 | BlackRose&nbsp; &nbsp; &nbsp; |&nbsp;&nbsp; 24 | www.vpforums.org |&nbsp; &nbsp; 2034725710 | 2014-10-03 |+---------+----------------+------+------------------+---------------+------------+16 rows in set (0.05 sec)[/CODE]</blockquote>

[QUOTE="invitro, post: 200911, member: 446"] Gotcha, thanks. What I couldn't remember or didn't know is if TPA always rejected the 1T rollover for some or all platforms. Here are all of his current high scores (in the top 10,000 or so): [CODE] ID TABLE | RANK | SCORE | DATE | ORANK | USERNAME | 19 STTNG | 1 | 1,890,199,057,550 | 2014-02-25 | 1 | www.vpforums.org | 20 AFM | 7 | 644,245,109,590 | 2014-02-25 | 2 | www.vpforums.org | 30 CP | 13 | 1,519,065,310 | 2014-02-25 | 5 | www.vpforums.org | 29 Pin*Bot | 18 | 37,236,730 | 2014-02-25 | 10 | www.vpforums.org | 27 SpSh | 26 | 12,563,870 | 2014-02-25 | 11 | www.vpforums.org | 42 BRose | 29 | 2,034,725,710 | 2014-02-25 | 12 | www.vpforums.org | 41 FT | 34 | 1,823,610,490 | 2014-02-25 | 7 | www.vpforums.org | 17 SS | 39 | 1,763,648,290 | 2014-02-25 | 23 | www.vpforums.org | 1 RBioN | 87 | 1,973,748,810 | 2014-02-25 | 74 | www.vpforums.org | 43 BK2K | 1 | 71,200,687,840 | 2014-10-07 | 1 | www.vpforums.org | 25 CentPark | 6 | 16,899 | 2014-10-07 | 5 | www.vpforums.org | 3 BH | 6 | 136,951,830 | 2014-10-07 | 6 | www.vpforums.org | 33 GoinNuts | 7 | 13,942,700 | 2014-10-07 | 5 | www.vpforums.org | 21 Genie | 7 | 10,082,510 | 2014-10-07 | 5 | www.vpforums.org | 23 FirePwr | 7 | 6,596,640 | 2014-10-07 | 5 | www.vpforums.org | 16 BigShot | 9 | 1,489,570 | 2014-10-07 | 7 | www.vpforums.org | 9 Gorgar | 9 | 11,631,890 | 2014-10-07 | 8 | www.vpforums.org | ID TABLE | RANK | SCORE | DATE | ORANK | USERNAME | 11 BK | 12 | 219,875,640 | 2014-10-07 | 11 | www.vpforums.org | 35 HH | 24115 | 20,430 | 2014-10-07 | 18193 | www.vpforums.org | [/CODE] And just to be sure, I know the 2014-10-07 scores were made since 2014-10-03, because I have a data set for 2014-10-03 that does not have those scores. I might as well and paste his scores on 2014-10-03: [CODE] mysql> select * from tpa_leaderboard where username='www.vpforums.org' and date >= '2014-10-03' and date < '2014-10-07'; +---------+----------------+------+------------------+---------------+------------+ | tableid | tableabbr | rank | username | score | date | +---------+----------------+------+------------------+---------------+------------+ | 1 | Ripleys | 83 | www.vpforums.org | 1973748810 | 2014-10-03 | | 3 | BlkHole | 12 | www.vpforums.org | 45708460 | 2014-10-03 | | 9 | Gorgar | 23 | www.vpforums.org | 3466590 | 2014-10-03 | | 11 | BlackKnight | 18 | www.vpforums.org | 123973970 | 2014-10-03 | | 16 | BigShot | 31 | www.vpforums.org | 600080 | 2014-10-03 | | 17 | ElviraSS | 31 | www.vpforums.org | 1763648290 | 2014-10-03 | | 19 | StarTrekTNG | 1 | www.vpforums.org | 1890199057550 | 2014-10-03 | | 20 | AttackFromMars | 4 | www.vpforums.org | 644245109590 | 2014-10-03 | | 21 | Genie | 9 | www.vpforums.org | 5827550 | 2014-10-03 | | 23 | FirePwr | 11 | www.vpforums.org | 4595110 | 2014-10-03 | | 25 | CentralPark | 15 | www.vpforums.org | 9017 | 2014-10-03 | | 27 | SpaceShuttle | 17 | www.vpforums.org | 12563870 | 2014-10-03 | | 29 | PinBot | 17 | www.vpforums.org | 37236730 | 2014-10-03 | | 30 | ChampionPub | 10 | www.vpforums.org | 1519065310 | 2014-10-03 | | 41 | FishTales | 22 | www.vpforums.org | 1823610490 | 2014-10-03 | | 42 | BlackRose | 24 | www.vpforums.org | 2034725710 | 2014-10-03 | +---------+----------------+------+------------------+---------------+------------+ 16 rows in set (0.05 sec) [/CODE] [/QUOTE]

Verification

Reply to thread

Members online

Newest members