View Single Post
  #110  
Old 10-14-2007, 05:27 PM
linuxrocks linuxrocks is offline
Senior Member
 
Join Date: Oct 2005
Posts: 1,014
Default Re: lolz super accountz

[ QUOTE ]
Holy [censored], I think I found him and I'm like 99% sure this is not a coincidence. Skip to the bolded text if you don't care about the details.

I put all of the IP/email address lines in the following type of SQL table:

CREATE TABLE `ipinfo` (
`table` int(3) NOT NULL,
`date` datetime NOT NULL,
`action` varchar(10) NOT NULL,
`email` varchar(80) NOT NULL,
`userid` int(15) NOT NULL,
`ip` varchar(25) NOT NULL,
`port` int(8) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Then I ran the following query:

SELECT *
FROM `ipinfo`
GROUP BY `email`
ORDER BY `ip` ASC

It returned 267 rows.

Then in the IP range starting with 200, there are two guys with identical IPs. snagglepuss alerted me to these two guys earlier. But here's the evidence on one of the guys:

1. This guy "enters" table 13 at 2007-09-12 21:02:14, which is 2 minutes and 14 seconds after the tourney started.
2. Table 13 is the table which POTRIPPER was playing on
3. He never leaves the table, which means he was observing the table until at least 11:20 PM EST (at least, that's how I understand this)
4. His IP address is based in Costa Rica.
5. This is the most damning. He is user id 363 at AP. That means he was created in the system very very early on. Most of these user ids are in the 6 or 7 figures.

I think this tells me that there was some sort of inside job going on.

I will withhold his IP and email for the time being.

[/ QUOTE ]

Great job, Nat! Did any body make progress on converting the raw HHs to PXF compatible form? I can help, if you like.