0

I'm pull gaming stats from a database, but I'm having issues with one of the cases and I can't seem to figure out why.

The first two cases work fine, but the last one just returns null. What's strange is when I replace the third case with one of the others and return it as another name I still get null.

What am I missing??

$sql = "select bt.ID, bt.Username, bt.Group, bt.GUID, DATEDIFF(curdate(),STR_TO_DATE(bt.FirstSeen, '%m/%d/%Y')) as FirstSeenDays, bt.FirstSeen,  DATEDIFF(curdate(),STR_TO_DATE(bt.LastSeen, '%m/%d/%Y')) as LastSeenDays, bt.LastSeen, bt.Server, bt.IP, cp.id as personid, cp.callsign, 

	CASE
	WHEN ( bt.Kills = 0 ) THEN '0'
		ELSE bt.Kills
	END AS Kills,
	
	CASE
	WHEN ( bt.Deaths = 0 ) THEN '0'
		ELSE bt.Deaths
	END AS Deaths,
	
	CASE
	WHEN ( bt.Kills = 0 AND bt.Deaths <> 0 ) THEN bt.Deaths
	WHEN ( bt.Kills <> 0 AND bt.Deaths = 0 ) THEN bt.Kills
	WHEN ( bt.Kills <> 0 AND bt.Deaths <> 0 ) THEN bt.Kills/bt.Deaths
	END AS KDR

		from $blacktomato_db.playerdb bt
		LEFT JOIN $command_db.persons cp ON bt.Username = cp.callsign
		order by Username asc";
3
Contributors
15
Replies
16
Views
6 Years
Discussion Span
Last Post by k1robert
0

I don't know what you're missing, but I am missing the table structure and some test data.
Are there NULL values in the Kills and Deaths columns?

0

Sorry. No, there's no NULL values in those fields.

CREATE TABLE IF NOT EXISTS `playerdb` (
  `id` int(11) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  `guid` varchar(255) DEFAULT NULL,
  `firstseen` varchar(255) DEFAULT NULL,
  `lastseen` varchar(255) DEFAULT NULL,
  `server` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `kills` int(11) DEFAULT NULL,
  `deaths` int(11) DEFAULT NULL,
  `string1` varchar(255) DEFAULT NULL,
  `string2` varchar(255) DEFAULT NULL,
  `string3` varchar(255) DEFAULT NULL,
  `string4` varchar(255) DEFAULT NULL,
  `num1` int(11) DEFAULT NULL,
  `num2` int(11) DEFAULT NULL,
  `num3` int(11) DEFAULT NULL,
  `num4` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here's all the table data.

INSERT INTO `playerdb` (`id`, `username`, `group`, `guid`, `firstseen`, `lastseen`, `server`, `ip`, `kills`, `deaths`, `string1`, `string2`, `string3`, `string4`, `num1`, `num2`, `num3`, `num4`) VALUES
(2, 'Spector', 'Honor Squad Member', '34728278', '6/4/2011 9:17:05 PM', '6/26/2011 8:22:00 PM', 'TheHonorSquad.comMIX', 'NULL', 1191, 887, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(3, 'aemccolgan', 'D', '80330298', '6/4/2011 9:27:54 PM', '6/4/2011 9:32:14 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(4, 'Stangratch', 'Honor Squad Member', '29705014', '6/4/2011 9:32:52 PM', '6/26/2011 8:00:12 PM', 'TheHonorSquad.comMIX', 'NULL', 536, 422, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(5, 'john', 'D', '19126096', '6/4/2011 9:52:51 PM', '6/4/2011 9:55:46 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(6, 'Zzyzx', 'D', '58875156', '6/4/2011 9:53:15 PM', '6/4/2011 10:04:54 PM', 'TheHonorSquad.comNUKE', 'NULL', 20, 38, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(8, 'Torres25x*', 'D', '55899079', '6/4/2011 9:58:53 PM', '6/4/2011 10:04:52 PM', 'TheHonorSquad.comNUKE', 'NULL', 26, 14, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(9, 'MH| KEYLA', 'D', '54050580', '6/4/2011 10:01:11 PM', '6/4/2011 10:05:59 PM', 'TheHonorSquad.comNUKE', 'NULL', 6, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(10, 'Vice', 'D', '80434965', '6/4/2011 10:06:37 PM', '6/4/2011 10:31:00 PM', 'TheHonorSquad.comNUKE', 'NULL', 29, 43, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(11, 'CHOPPER GUNNER', 'D', '70064629', '6/4/2011 10:07:18 PM', '6/4/2011 10:19:32 PM', 'TheHonorSquad.comNUKE', 'NULL', 13, 27, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(12, 'rogerl', 'D', '79544755', '6/4/2011 10:14:20 PM', '6/4/2011 10:29:31 PM', 'TheHonorSquad.comNUKE', 'NULL', 22, 39, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(13, 'TheDeadBread', 'D', '55519050', '6/4/2011 10:22:46 PM', '6/4/2011 10:24:16 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(14, 'joshuabroussard', 'D', '65665584', '6/5/2011 1:39:43 AM', '6/5/2011 1:42:58 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(15, 'Col. Harris', 'D', '75230581', '6/5/2011 5:01:35 AM', '6/5/2011 12:53:09 PM', 'TheHonorSquad.comNUKE', 'NULL', 205, 169, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(16, 'F.s.B.]gryga.kl', 'D', '77799167', '6/5/2011 5:02:16 AM', '6/5/2011 6:45:22 AM', 'TheHonorSquad.comNUKE', 'NULL', 91, 173, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(17, 'Mn''S]maisonn', 'D', '80404961', '6/5/2011 5:04:17 AM', '6/5/2011 12:53:07 PM', 'TheHonorSquad.comNUKE', 'NULL', 204, 174, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(18, 'cinalbin', 'D', '65380456', '6/5/2011 5:04:50 AM', '6/7/2011 1:13:18 PM', 'TheHonorSquad.comNUKE', 'NULL', 76, 95, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(19, 'Trippin', 'D', '60352808', '6/5/2011 5:08:13 AM', '6/5/2011 5:14:54 AM', 'TheHonorSquad.comNUKE', 'NULL', 3, 9, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(20, 'LiNgLiNg', 'D', '70243148', '6/5/2011 5:14:34 AM', '6/5/2011 2:13:33 PM', 'TheHonorSquad.comNUKE', 'NULL', 93, 73, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(21, 'I ZueziidE', 'D', '53398559', '6/5/2011 5:17:32 AM', '6/5/2011 6:21:44 AM', 'TheHonorSquad.comNUKE', 'NULL', 125, 109, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(22, 'Sk0mMyLagg<8', 'D', '80241735', '6/5/2011 5:26:11 AM', '6/5/2011 5:31:44 AM', 'TheHonorSquad.comNUKE', 'NULL', 13, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(23, 'Fine Asian Guy', 'D', '71509559', '6/5/2011 5:27:08 AM', '6/5/2011 5:33:12 AM', 'TheHonorSquad.comNUKE', 'NULL', 14, 19, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(24, 'iTzZ_JoKer', 'D', '14030210', '6/5/2011 5:30:47 AM', '6/5/2011 5:50:21 AM', 'TheHonorSquad.comNUKE', 'NULL', 41, 51, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(25, 'ePh3x', 'D', '74620879', '6/5/2011 5:32:16 AM', '6/5/2011 5:37:42 AM', 'TheHonorSquad.comNUKE', 'NULL', 18, 9, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(26, 'TheWhiteWolf', 'D', '3931587', '6/5/2011 5:42:58 AM', '6/5/2011 6:21:44 AM', 'TheHonorSquad.comNUKE', 'NULL', 145, 50, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(27, 'BuNnY PL', 'D', '18237707', '6/5/2011 5:46:55 AM', '6/5/2011 5:46:55 AM', 'TheHonorSquad.comNUKE', 'NULL', 148, 132, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(28, 'TNT]Chudson', 'D', '74264052', '6/5/2011 5:47:28 AM', '6/5/2011 6:14:24 AM', 'TheHonorSquad.comNUKE', 'NULL', 164, 125, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(29, 'Witcher PL', 'D', '76872535', '6/5/2011 5:47:28 AM', '6/5/2011 6:49:31 AM', 'TheHonorSquad.comNUKE', 'NULL', 160, 127, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(30, 'danielias1', 'D', '60136776', '6/5/2011 5:51:03 AM', '6/5/2011 5:53:26 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(31, 'Lev1974', 'D', '56746466', '6/5/2011 5:54:18 AM', '6/5/2011 5:54:43 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(32, 'Harpor', 'D', '72565311', '6/5/2011 5:54:42 AM', '6/5/2011 6:16:12 AM', 'TheHonorSquad.comNUKE', 'NULL', 15, 58, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(33, 'popcricri', 'D', '82397649', '6/5/2011 6:00:23 AM', '6/5/2011 6:00:23 AM', 'TheHonorSquad.comNUKE', 'NULL', 42, 79, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(34, 'arapaleabogdan', 'D', '65475647', '6/5/2011 6:02:33 AM', '6/5/2011 1:49:52 PM', 'TheHonorSquad.comNUKE', 'NULL', 62, 94, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(35, 'Marvin', 'D', '54143811', '6/5/2011 6:06:18 AM', '6/5/2011 6:06:18 AM', 'TheHonorSquad.comNUKE', 'NULL', 80, 130, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(36, 'NovaStorm', 'D', '8256070', '6/5/2011 6:06:37 AM', '6/5/2011 6:21:44 AM', 'TheHonorSquad.comNUKE', 'NULL', 15, 27, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(37, 'MaDaStar', 'D', '10390249', '6/5/2011 6:10:50 AM', '6/5/2011 6:21:54 AM', 'TheHonorSquad.comNUKE', 'NULL', 20, 23, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(38, 'rrooon', 'D', '57014486', '6/5/2011 6:12:36 AM', '6/5/2011 6:13:29 AM', 'TheHonorSquad.comNUKE', 'NULL', 1, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(39, 'Aluterrian', 'D', '73241673', '6/5/2011 6:16:41 AM', '6/5/2011 6:16:41 AM', 'TheHonorSquad.comNUKE', 'NULL', 15, 114, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(40, 'granger23', 'D', '53575966', '6/5/2011 6:20:17 AM', '6/5/2011 6:22:36 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(41, 'Nigganaattor', 'D', '47200992', '6/5/2011 6:25:44 AM', '6/5/2011 12:50:14 PM', 'TheHonorSquad.comNUKE', 'NULL', 119, 63, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(42, 'nicolas393', 'D', '59197622', '6/5/2011 6:30:17 AM', '6/5/2011 6:30:17 AM', 'TheHonorSquad.comNUKE', 'NULL', 27, 40, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(43, 'naototto2010', 'D', '81893256', '6/5/2011 6:34:11 AM', '6/5/2011 6:42:11 AM', 'TheHonorSquad.comNUKE', 'NULL', 18, 9, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(44, 'redheadkickster', 'D', '82460042', '6/5/2011 6:36:16 AM', '6/5/2011 6:37:37 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(45, 'dave_yola', 'D', '82509921', '6/5/2011 6:37:39 AM', '6/5/2011 6:37:39 AM', 'TheHonorSquad.comNUKE', 'NULL', 12, 26, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(46, 'Psych0pa7h', 'D', '29319474', '6/5/2011 6:49:31 AM', '6/5/2011 6:49:31 AM', 'TheHonorSquad.comNUKE', 'NULL', 10, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(47, 'Don''t Taze Me Br', 'D', '37126956', '6/5/2011 6:51:59 AM', '6/5/2011 6:51:59 AM', 'TheHonorSquad.comNUKE', 'NULL', 13, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(48, 'vvitalik87', 'D', '39477950', '6/5/2011 6:54:49 AM', '6/5/2011 6:54:49 AM', 'TheHonorSquad.comNUKE', 'NULL', 1, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(49, 'Bboy6763', 'D', '64673329', '6/5/2011 7:01:56 AM', '6/5/2011 7:01:57 AM', 'TheHonorSquad.comNUKE', 'NULL', 1, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(50, 'Xt@sY!!!', 'D', '50113093', '6/5/2011 7:01:57 AM', '6/5/2011 7:01:57 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(51, 'superlisko', 'D', '38873930', '6/5/2011 7:01:57 AM', '6/5/2011 7:01:57 AM', 'TheHonorSquad.comNUKE', 'NULL', 2, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(52, 'Death Killer', 'D', '75748697', '6/5/2011 12:06:18 PM', '6/5/2011 12:07:31 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(53, 'W@nTeD^kIlLeR', 'D', '75580197', '6/5/2011 12:26:03 PM', '6/5/2011 12:44:15 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(54, 'coolyers', 'Honor Squad Member', '59958777', '6/5/2011 12:41:52 PM', '6/12/2011 9:31:12 PM', 'TheHonorSquad.comNUKE', 'NULL', 177, 200, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(55, 'TwoEmptyHands', 'D', '75292048', '6/5/2011 12:44:02 PM', '6/5/2011 1:05:34 PM', 'TheHonorSquad.comNUKE', 'NULL', 37, 48, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(56, 'Valkyr1e', 'D', '46175941', '6/5/2011 12:45:16 PM', '6/5/2011 12:53:17 PM', 'TheHonorSquad.comNUKE', 'NULL', 18, 19, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(57, 'MasterChe', 'D', '32981040', '6/5/2011 12:45:40 PM', '6/5/2011 12:47:51 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(58, 'Xfinity', 'D', '3927819', '6/5/2011 1:02:30 PM', '6/5/2011 1:04:55 PM', 'TheHonorSquad.comNUKE', 'NULL', 4, 3, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(59, 'chinedooo', 'D', '72842474', '6/5/2011 1:05:45 PM', '6/5/2011 1:38:38 PM', 'TheHonorSquad.comNUKE', 'NULL', 135, 68, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(60, 'Remark`', 'D', '70721041', '6/5/2011 1:06:18 PM', '6/5/2011 1:31:48 PM', 'TheHonorSquad.comNUKE', 'NULL', 48, 61, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(61, 'TECKNOXX', 'D', '11787748', '6/5/2011 1:13:30 PM', '6/5/2011 2:28:27 PM', 'TheHonorSquad.comNUKE', 'NULL', 130, 89, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(62, 'Cfrost', 'D', '76285683', '6/5/2011 1:14:51 PM', '6/5/2011 1:17:25 PM', 'TheHonorSquad.comNUKE', 'NULL', 4, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(63, 'M1nds!', 'D', '60515662', '6/5/2011 1:15:24 PM', '6/5/2011 1:44:51 PM', 'TheHonorSquad.comNUKE', 'NULL', 31, 76, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(64, 'JorgeLucas', 'D', '1352266', '6/5/2011 1:16:38 PM', '6/6/2011 10:25:10 PM', 'TheHonorSquad.comNUKE', 'NULL', 1, 3, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(65, 'UnasNalgas :Q', 'D', '67495365', '6/5/2011 1:23:26 PM', '6/5/2011 1:29:11 PM', 'TheHonorSquad.comNUKE', 'NULL', 4, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(66, 'A PIMP NAMED SLI', 'D', '65605163', '6/5/2011 1:34:01 PM', '6/5/2011 2:25:11 PM', 'TheHonorSquad.comNUKE', 'NULL', 142, 224, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(67, 'BeErNiNjA', 'D', '62500815', '6/5/2011 1:36:27 PM', '6/5/2011 2:29:34 PM', 'TheHonorSquad.comNUKE', 'NULL', 84, 93, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(68, 'Eldar', 'D', '72870155', '6/5/2011 1:37:59 PM', '6/5/2011 2:01:02 PM', 'TheHonorSquad.comNUKE', 'NULL', 46, 56, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(69, 'HITLER', 'D', '72902590', '6/5/2011 1:37:59 PM', '6/5/2011 2:01:02 PM', 'TheHonorSquad.comNUKE', 'NULL', 43, 57, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(70, 'K2]DanyPro86-_-', 'D', '55886955', '6/5/2011 1:39:21 PM', '6/5/2011 2:15:35 PM', 'TheHonorSquad.comNUKE', 'NULL', 110, 152, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(71, 'hitman', 'D', '53846126', '6/5/2011 1:39:45 PM', '6/5/2011 2:00:32 PM', 'TheHonorSquad.comNUKE', 'NULL', 20, 44, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(72, 'flash #opre', 'D', '3167014', '6/5/2011 1:40:03 PM', '6/5/2011 2:00:53 PM', 'TheHonorSquad.comNUKE', 'NULL', 54, 55, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(73, 'snowsurfer', 'D', '22346537', '6/5/2011 1:40:11 PM', '6/5/2011 2:24:14 PM', 'TheHonorSquad.comNUKE', 'NULL', 68, 126, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(74, 'K2]MaFuma', 'D', '53532754', '6/5/2011 1:43:32 PM', '6/5/2011 2:24:12 PM', 'TheHonorSquad.comNUKE', 'NULL', 134, 134, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(75, 'K2]MAK4BRON', 'D', '52403543', '6/5/2011 1:44:14 PM', '6/5/2011 2:26:47 PM', 'TheHonorSquad.comNUKE', 'NULL', 185, 109, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(76, 'Krome X ReMiiXx', 'D', '81992963', '6/5/2011 1:46:43 PM', '6/5/2011 4:19:56 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(77, '0x0]Jabbe', 'D', '58218627', '6/5/2011 1:47:33 PM', '6/5/2011 1:49:11 PM', 'TheHonorSquad.comNUKE', 'NULL', 7, 4, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(78, 'Johnny boy', 'D', '46035278', '6/5/2011 1:47:50 PM', '6/5/2011 1:48:37 PM', 'TheHonorSquad.comNUKE', 'NULL', 1, 3, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(80, 'UnholyCleric', 'D', '82535548', '6/5/2011 1:51:02 PM', '6/5/2011 1:57:12 PM', 'TheHonorSquad.comNUKE', 'NULL', 6, 16, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(81, 'kontogry77', 'D', '75115199', '6/5/2011 1:51:19 PM', '6/5/2011 2:29:00 PM', 'TheHonorSquad.comNUKE', 'NULL', 211, 68, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(82, 'ekspert', 'D', '37407818', '6/5/2011 1:51:19 PM', '6/5/2011 1:52:05 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(83, 'alessandroferruc', 'D', '72102181', '6/5/2011 1:52:18 PM', '6/5/2011 1:53:36 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(84, 'cacaarend', 'D', '82498981', '6/5/2011 1:52:18 PM', '6/5/2011 2:00:53 PM', 'TheHonorSquad.comNUKE', 'NULL', 1, 22, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(85, 'coolmanz', 'D', '80540110', '6/5/2011 1:57:29 PM', '6/5/2011 2:04:53 PM', 'TheHonorSquad.comNUKE', 'NULL', 3, 20, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(86, 'Clairvoyant', 'D', '27548716', '6/5/2011 2:01:00 PM', '6/26/2011 9:11:06 PM', 'TheHonorSquad.comMIX', 'NULL', 28, 56, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(87, 'BeX | DiFerence', 'D', '53443994', '6/5/2011 2:01:58 PM', '6/5/2011 2:03:51 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 4, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(88, 'DTK) AlfredO', 'D', '13934812', '6/5/2011 2:02:06 PM', '6/5/2011 2:13:29 PM', 'TheHonorSquad.comNUKE', 'NULL', 28, 32, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(89, 'bruninho0201', 'D', '81104954', '6/5/2011 2:05:43 PM', '6/5/2011 2:24:40 PM', 'TheHonorSquad.comNUKE', 'NULL', 6, 43, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(90, 'KGR}Phillips', 'D', '58759232', '6/5/2011 2:07:15 PM', '6/5/2011 2:11:57 PM', 'TheHonorSquad.comNUKE', 'NULL', 5, 14, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(91, 'GizdaMan', 'D', '37561443', '6/5/2011 2:07:23 PM', '6/5/2011 2:11:48 PM', 'TheHonorSquad.comNUKE', 'NULL', 10, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(92, 'AAC} Slutbumwal', 'D', '53919019', '6/5/2011 2:13:29 PM', '6/5/2011 2:28:51 PM', 'TheHonorSquad.comNUKE', 'NULL', 41, 33, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(93, '3-Dime', 'D', '74397376', '6/5/2011 2:14:02 PM', '6/5/2011 2:24:08 PM', 'TheHonorSquad.comNUKE', 'NULL', 14, 37, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(94, '3| Bewbs!', 'D', '33287140', '6/5/2011 2:14:27 PM', '6/5/2011 2:22:23 PM', 'TheHonorSquad.comNUKE', 'NULL', 8, 23, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(95, 'Morshu (DE)', 'D', '61168851', '6/5/2011 2:14:27 PM', '6/5/2011 2:51:24 PM', 'TheHonorSquad.comNUKE', 'NULL', 40, 41, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(96, 'MatheusGX', 'D', '82271988', '6/5/2011 2:15:01 PM', '6/5/2011 2:23:49 PM', 'TheHonorSquad.comNUKE', 'NULL', 7, 26, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(97, 'GTX 470 SLI', 'D', '28146240', '6/5/2011 2:23:49 PM', '6/5/2011 2:36:05 PM', 'TheHonorSquad.comNUKE', 'NULL', 13, 34, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(98, 'Bladder Warts', 'D', '55574445', '6/5/2011 2:30:47 PM', '6/5/2011 2:40:48 PM', 'TheHonorSquad.comNUKE', 'NULL', 13, 21, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(99, 'mass murder', 'D', '76607793', '6/5/2011 2:34:52 PM', '6/5/2011 2:35:57 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(100, 'nazebaze', 'D', '67773919', '6/5/2011 2:36:14 PM', '6/5/2011 2:43:00 PM', 'TheHonorSquad.comNUKE', 'NULL', 2, 22, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(101, 'Predator', 'D', '55397269', '6/5/2011 2:37:43 PM', '6/5/2011 2:44:36 PM', 'TheHonorSquad.comNUKE', 'NULL', 8, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(102, 'hector.nnf | #Pr', 'D', '33459224', '6/5/2011 2:40:42 PM', '6/5/2011 3:09:38 PM', 'TheHonorSquad.comNUKE', 'NULL', 29, 68, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(103, 'denilsonkw', 'D', '58245360', '6/5/2011 2:43:08 PM', '6/5/2011 3:12:02 PM', 'TheHonorSquad.comNUKE', 'NULL', 51, 96, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(104, 'pipeeee', 'D', '51621715', '6/5/2011 2:44:22 PM', '6/5/2011 2:46:33 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(105, 'nate1898', 'D', '72123463', '6/5/2011 2:48:35 PM', '6/5/2011 2:57:45 PM', 'TheHonorSquad.comNUKE', 'NULL', 6, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(106, 'Cats_tracker', 'D', '46364136', '6/5/2011 2:48:51 PM', '6/5/2011 2:54:29 PM', 'TheHonorSquad.comNUKE', 'NULL', 5, 4, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(107, 'Phantom 2020', 'D', '52911364', '6/5/2011 2:50:04 PM', '6/5/2011 2:55:30 PM', 'TheHonorSquad.comNUKE', 'NULL', 17, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(108, 'Solarhard', 'D', '77477529', '6/5/2011 2:56:43 PM', '6/5/2011 9:47:35 PM', 'TheHonorSquad.comNUKE', 'NULL', 13, 12, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(109, 'Jessica Alba', 'D', '9320420', '6/5/2011 3:02:33 PM', '6/26/2011 6:56:13 PM', 'TheHonorSquad.comMIX', 'NULL', 13, 26, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(110, 'roetter41', 'D', '78721805', '6/5/2011 3:12:29 PM', '6/5/2011 3:13:40 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(111, 'Secris', 'D', '65963431', '6/5/2011 6:47:49 PM', '6/5/2011 6:48:40 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(112, 'mkayseryan', 'D', '79907386', '6/5/2011 10:06:23 PM', '6/5/2011 10:12:00 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(113, 'Serj494', 'D', '59081973', '6/5/2011 10:09:38 PM', '6/5/2011 10:34:04 PM', 'TheHonorSquad.comNUKE', 'NULL', 5, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(114, 'Punk', 'D', '65223488', '6/5/2011 10:10:34 PM', '6/5/2011 10:12:39 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(115, 'iMuffinsx3', 'D', '82145368', '6/5/2011 10:11:48 PM', '6/5/2011 10:15:11 PM', 'TheHonorSquad.comNUKE', 'NULL', 1, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(116, 'sergeymaximum', 'D', '73629975', '6/5/2011 10:14:21 PM', '6/5/2011 10:30:25 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(117, 'X]:. Martin', 'D', '59042519', '6/5/2011 10:27:12 PM', '6/5/2011 10:27:41 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(118, 'Green_Kevy', 'D', '77033876', '6/6/2011 3:55:36 PM', '6/6/2011 3:57:30 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(119, 'johnsman', 'D', '39558326', '6/7/2011 1:13:09 PM', '6/7/2011 1:18:45 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(120, 'a//kawz', 'D', '38605359', '6/12/2011 8:16:01 PM', '6/12/2011 8:25:00 PM', 'TheHonorSquad.comNUKE', 'NULL', 6, 15, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(121, 'a//Ceejack', 'D', '60671101', '6/12/2011 8:16:34 PM', '6/12/2011 8:25:02 PM', 'TheHonorSquad.comNUKE', 'NULL', 16, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(122, 'SonicDeath', 'D', '77777027', '6/12/2011 8:16:58 PM', '6/27/2011 12:47:43 AM', 'TheHonorSquad.comMIX', 'NULL', 274, 355, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(123, 'dominic', 'D', '861833', '6/12/2011 8:18:35 PM', '6/12/2011 10:16:07 PM', 'TheHonorSquad.comNUKE', 'NULL', 160, 166, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(124, 'Whiskeyfox', 'D', '60786877', '6/12/2011 8:19:16 PM', '6/12/2011 8:25:04 PM', 'TheHonorSquad.comNUKE', 'NULL', 5, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(125, 'Zi''Tah]Soul', 'D', '32789652', '6/12/2011 8:26:20 PM', '6/12/2011 8:45:17 PM', 'TheHonorSquad.comNUKE', 'NULL', 20, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(126, 'Monntek', 'D', '56492409', '6/12/2011 8:35:40 PM', '6/12/2011 9:15:11 PM', 'TheHonorSquad.comNUKE', 'NULL', 32, 61, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(127, 'Hawkhunter13', 'D', '48057767', '6/12/2011 8:35:58 PM', '6/12/2011 8:51:11 PM', 'TheHonorSquad.comNUKE', 'NULL', 17, 29, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(128, 'Im Not Fantasy', 'D', '65013171', '6/12/2011 8:36:31 PM', '6/12/2011 9:03:19 PM', 'TheHonorSquad.comNUKE', 'NULL', 54, 56, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(129, 'SadisticPickle', 'D', '55895475', '6/12/2011 8:36:48 PM', '6/12/2011 9:03:37 PM', 'TheHonorSquad.comNUKE', 'NULL', 21, 51, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(130, 'Baldy McBald', 'D', '35765719', '6/12/2011 8:37:21 PM', '6/12/2011 8:49:58 PM', 'TheHonorSquad.comNUKE', 'NULL', 6, 13, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(131, 'Stealth', 'D', '76032593', '6/12/2011 8:45:58 PM', '6/12/2011 8:51:54 PM', 'TheHonorSquad.comNUKE', 'NULL', 9, 3, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(132, 'eHvUeRlTySn', 'D', '55305852', '6/12/2011 8:46:14 PM', '6/12/2011 9:31:10 PM', 'TheHonorSquad.comNUKE', 'NULL', 62, 37, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(133, 'DaCoStE..', 'D', '71229436', '6/12/2011 8:47:29 PM', '6/12/2011 9:31:14 PM', 'TheHonorSquad.comNUKE', 'NULL', 23, 75, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(134, 'TFR[]Seb', 'D', '53794072', '6/12/2011 8:54:53 PM', '6/12/2011 9:18:58 PM', 'TheHonorSquad.comNUKE', 'NULL', 28, 32, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(135, 'd3v0', 'D', '5495937', '6/12/2011 9:02:04 PM', '6/12/2011 9:03:02 PM', 'TheHonorSquad.comNUKE', 'NULL', 1, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(136, 'ButtTheHoopoe', 'D', '55695837', '6/12/2011 9:05:40 PM', '6/12/2011 9:40:26 PM', 'TheHonorSquad.comNUKE', 'NULL', 82, 55, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(137, 'gerald_wiles', 'D', '60822937', '6/12/2011 9:12:38 PM', '6/12/2011 9:50:07 PM', 'TheHonorSquad.comNUKE', 'NULL', 33, 53, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(138, 'LeXx', 'D', '3365045', '6/12/2011 9:17:59 PM', '6/12/2011 9:33:41 PM', 'TheHonorSquad.comNUKE', 'NULL', 27, 34, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(139, 'AbadSkidMark', 'D', '73268088', '6/12/2011 9:33:55 PM', '6/12/2011 9:47:39 PM', 'TheHonorSquad.comNUKE', 'NULL', 30, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(140, 'Ninja Dunk', 'D', '73760660', '6/12/2011 9:41:23 PM', '6/12/2011 9:45:33 PM', 'TheHonorSquad.comNUKE', 'NULL', 6, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(141, 'Modus_Ponens', 'D', '28478148', '6/12/2011 9:43:49 PM', '6/12/2011 10:15:22 PM', 'TheHonorSquad.comNUKE', 'NULL', 57, 65, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(142, 'Shay', 'D', '74252229', '6/12/2011 10:09:01 PM', '6/12/2011 10:15:18 PM', 'TheHonorSquad.comNUKE', 'NULL', 2, 13, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(143, 'Marauder', 'D', '58622936', '6/12/2011 10:14:18 PM', '6/12/2011 10:15:28 PM', 'TheHonorSquad.comNUKE', 'NULL', 1, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(144, 'Twi$ter', 'D', '74033669', '6/15/2011 11:13:18 AM', '6/15/2011 11:15:06 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(145, 'P1r4Nha :>', 'D', '68599468', '6/19/2011 4:20:30 AM', '6/19/2011 4:21:20 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(146, 'InTeLz ExtrEmE', 'D', '82038015', '6/19/2011 4:21:27 AM', '6/19/2011 4:22:06 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(147, 'bruce', 'D', '49153594', '6/19/2011 9:56:57 PM', '6/19/2011 9:58:33 PM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(148, 'KlonkeN', 'D', '56624566', '6/20/2011 8:18:26 AM', '6/20/2011 8:21:27 AM', 'TheHonorSquad.comNUKE', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(149, 'MenzkyQc', 'D', '73800700', '6/23/2011 7:45:14 PM', '6/23/2011 8:02:49 PM', 'TheHonorSquad.comMIX', 'NULL', 38, 21, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(150, 'Kurt_98', 'D', '78887519', '6/23/2011 7:50:15 PM', '6/23/2011 8:06:36 PM', 'TheHonorSquad.comMIX', 'NULL', 14, 19, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(151, 'milandijhon', 'D', '80157502', '6/23/2011 7:50:48 PM', '6/23/2011 8:00:10 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 8, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(152, 'rocketnubetube', 'D', '62488712', '6/23/2011 7:51:53 PM', '6/23/2011 7:55:31 PM', 'TheHonorSquad.comMIX', 'NULL', 4, 4, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(153, 'Sgt. G.', 'D', '7549954', '6/23/2011 7:52:50 PM', '6/23/2011 7:52:50 PM', 'TheHonorSquad.comMIX', 'NULL', 33, 52, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(154, 'nschaibly', 'D', '82586527', '6/23/2011 7:53:55 PM', '6/23/2011 8:18:44 PM', 'TheHonorSquad.comMIX', 'NULL', 24, 27, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(155, 'magofkemarcelo', 'D', '75453408', '6/23/2011 7:53:55 PM', '6/23/2011 7:53:55 PM', 'TheHonorSquad.comMIX', 'NULL', 13, 76, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(156, 'Ghengis~', 'D', '41072469', '6/23/2011 7:54:19 PM', '6/23/2011 8:23:43 PM', 'TheHonorSquad.comMIX', 'NULL', 94, 28, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(157, 'hamsteak', 'D', '81198624', '6/23/2011 7:54:36 PM', '6/23/2011 8:19:56 PM', 'TheHonorSquad.comMIX', 'NULL', 10, 43, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(158, 'WhiteTuna', 'D', '78377542', '6/23/2011 7:54:36 PM', '6/23/2011 8:08:06 PM', 'TheHonorSquad.comMIX', 'NULL', 17, 21, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(159, 'XxDaRk_VoIcExX', 'D', '78774606', '6/23/2011 7:54:36 PM', '6/23/2011 8:16:05 PM', 'TheHonorSquad.comMIX', 'NULL', 49, 21, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(160, 'Nyte', 'D', '14174611', '6/23/2011 7:54:52 PM', '6/23/2011 7:54:52 PM', 'TheHonorSquad.comMIX', 'NULL', 41, 35, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(161, 'Noon', 'D', '75316338', '6/23/2011 7:55:40 PM', '6/23/2011 8:06:16 PM', 'TheHonorSquad.comMIX', 'NULL', 17, 21, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(162, 'ARG] Mortadela', 'D', '43271396', '6/23/2011 7:55:40 PM', '6/23/2011 8:06:30 PM', 'TheHonorSquad.comMIX', 'NULL', 14, 15, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(163, 'Lick!em?', 'D', '12732299', '6/23/2011 7:55:40 PM', '6/23/2011 8:16:07 PM', 'TheHonorSquad.comMIX', 'NULL', 45, 39, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(164, 'MrSushi', 'D', '65068760', '6/23/2011 7:56:06 PM', '6/23/2011 8:00:21 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(165, 'Diss0lve', 'D', '68088451', '6/23/2011 7:56:31 PM', '6/23/2011 8:26:51 PM', 'TheHonorSquad.comMIX', 'NULL', 94, 44, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(166, 'Pure Evil', 'D', '844548', '6/23/2011 8:03:08 PM', '6/23/2011 8:19:52 PM', 'TheHonorSquad.comMIX', 'NULL', 50, 32, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(167, 'NGxscoot', 'D', '38008092', '6/23/2011 8:06:51 PM', '6/23/2011 8:14:49 PM', 'TheHonorSquad.comMIX', 'NULL', 21, 13, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(168, 'Loran', 'D', '20393407', '6/23/2011 8:07:24 PM', '6/23/2011 8:07:26 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(169, 'pauljohnbansil', 'D', '80944587', '6/23/2011 8:07:24 PM', '6/23/2011 8:17:36 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(170, 'jM2.me', 'D', '55428433', '6/23/2011 8:07:49 PM', '6/23/2011 8:23:30 PM', 'TheHonorSquad.comMIX', 'NULL', 15, 31, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(171, 'Awesome Bill fro', 'D', '10307757', '6/23/2011 8:08:05 PM', '6/23/2011 8:16:09 PM', 'TheHonorSquad.comMIX', 'NULL', 8, 20, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(172, 'M1ckZ', 'D', '52043887', '6/23/2011 8:08:30 PM', '6/23/2011 8:23:32 PM', 'TheHonorSquad.comMIX', 'NULL', 25, 31, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(173, 'xz3pt', 'D', '36966351', '6/23/2011 8:15:08 PM', '6/23/2011 8:22:08 PM', 'TheHonorSquad.comMIX', 'NULL', 4, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(174, 'KroNiic Death', 'D', '73050892', '6/23/2011 8:16:32 PM', '6/23/2011 8:22:24 PM', 'TheHonorSquad.comMIX', 'NULL', 9, 21, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(175, 'srtstig', 'D', '53581088', '6/23/2011 8:16:32 PM', '6/23/2011 8:23:36 PM', 'TheHonorSquad.comMIX', 'NULL', 8, 14, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(176, 'TheWhiteMongoose', 'D', '73109924', '6/23/2011 8:16:32 PM', '6/23/2011 8:16:32 PM', 'TheHonorSquad.comMIX', 'NULL', 18, 19, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(177, 'CRUSHER', 'D', '56472962', '6/23/2011 8:17:46 PM', '6/23/2011 8:17:46 PM', 'TheHonorSquad.comMIX', 'NULL', 19, 13, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(178, 'isidrosanches', 'D', '74718223', '6/23/2011 8:17:54 PM', '6/23/2011 8:17:54 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(179, 'uG.duckdown', 'D', '11248788', '6/23/2011 8:18:11 PM', '6/23/2011 8:18:11 PM', 'TheHonorSquad.comMIX', 'NULL', 28, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(180, 'ryustrife', 'D', '40052506', '6/23/2011 8:19:01 PM', '6/23/2011 8:19:01 PM', 'TheHonorSquad.comMIX', 'NULL', 10, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(181, 'Dienekes', 'D', '72890372', '6/23/2011 8:20:31 PM', '6/23/2011 8:20:31 PM', 'TheHonorSquad.comMIX', 'NULL', 6, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(182, 'k0mpletist', 'D', '77526', '6/23/2011 8:22:18 PM', '6/23/2011 8:22:18 PM', 'TheHonorSquad.comMIX', 'NULL', 5, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(183, 'bobafett1683', 'D', '73656416', '6/23/2011 8:22:51 PM', '6/23/2011 8:23:43 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(184, 'Horsti', 'D', '73910327', '6/23/2011 8:23:42 PM', '6/23/2011 8:23:42 PM', 'TheHonorSquad.comMIX', 'NULL', 9, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(185, 'Gottimus', 'D', '62641487', '6/23/2011 8:23:42 PM', '6/23/2011 8:23:42 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(186, 'yosonfio', 'D', '12249955', '6/23/2011 8:24:14 PM', '6/23/2011 8:24:35 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(187, 'HELL|Andres|CoL', 'D', '33977604', '6/23/2011 8:24:14 PM', '6/23/2011 8:24:14 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(188, 'JimHorton', 'D', '56419375', '6/23/2011 8:25:11 PM', '6/23/2011 8:25:11 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(189, 'Nibbler!', 'D', '51197996', '6/23/2011 8:25:11 PM', '6/23/2011 8:25:11 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(191, 'chsdawg07', 'D', '83803214', '6/26/2011 4:09:51 PM', '6/26/2011 4:13:00 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(192, 'Deezy', 'D', '56285352', '6/26/2011 5:28:40 PM', '6/26/2011 7:25:15 PM', 'TheHonorSquad.comMIX', 'NULL', 251, 225, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(193, 'Politician', 'D', '3439083', '6/26/2011 5:29:29 PM', '6/26/2011 5:42:25 PM', 'TheHonorSquad.comMIX', 'NULL', 14, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(194, 'pjwiseman', 'D', '73187292', '6/26/2011 5:29:45 PM', '6/26/2011 7:06:26 PM', 'TheHonorSquad.comMIX', 'NULL', 7, 30, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(195, 'abu3zh2005', 'D', '83301710', '6/26/2011 5:29:53 PM', '6/26/2011 5:32:28 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(196, 'doogman', 'D', '36201744', '6/26/2011 5:36:07 PM', '6/26/2011 5:57:58 PM', 'TheHonorSquad.comMIX', 'NULL', 26, 37, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(197, 'ZIPPtango', 'D', '27519411', '6/26/2011 5:36:48 PM', '6/26/2011 6:44:24 PM', 'TheHonorSquad.comMIX', 'NULL', 115, 92, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(198, 's3v3n', 'D', '74444919', '6/26/2011 5:42:21 PM', '6/26/2011 5:57:55 PM', 'TheHonorSquad.comMIX', 'NULL', 20, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(199, 'FutaFan', 'D', '37661715', '6/26/2011 5:43:26 PM', '6/26/2011 5:49:23 PM', 'TheHonorSquad.comMIX', 'NULL', 16, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(200, 'C Fodder', 'D', '55324963', '6/26/2011 5:43:26 PM', '6/26/2011 5:57:47 PM', 'TheHonorSquad.comMIX', 'NULL', 11, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(201, 'RichrdSimns', 'D', '33689807', '6/26/2011 5:44:47 PM', '6/26/2011 5:59:49 PM', 'TheHonorSquad.comMIX', 'NULL', 6, 19, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(202, 'Oscar5', 'D', '23914832', '6/26/2011 5:50:30 PM', '6/26/2011 5:53:09 PM', 'TheHonorSquad.comMIX', 'NULL', 4, 4, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(203, 'Ghost_', 'D', '81600785', '6/26/2011 5:52:00 PM', '6/26/2011 8:06:57 PM', 'TheHonorSquad.comMIX', 'NULL', 49, 231, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(204, 'martyD', 'D', '2764476', '6/26/2011 5:52:09 PM', '6/26/2011 5:59:12 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(205, 'Axxtasy', 'D', '37991452', '6/26/2011 5:53:15 PM', '6/26/2011 6:56:18 PM', 'TheHonorSquad.comMIX', 'NULL', 209, 122, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(206, 'jqu2', 'D', '6094232', '6/26/2011 5:53:31 PM', '6/26/2011 6:17:57 PM', 'TheHonorSquad.comMIX', 'NULL', 17, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(207, 'Dagger2b', 'D', '15473971', '6/26/2011 5:53:31 PM', '6/26/2011 9:29:31 PM', 'TheHonorSquad.comMIX', 'NULL', 443, 276, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(208, 'JGRakocy', 'D', '14258840', '6/26/2011 5:54:45 PM', '6/26/2011 6:14:10 PM', 'TheHonorSquad.comMIX', 'NULL', 10, 20, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(209, 'Dr. D-Dog', 'D', '15504393', '6/26/2011 5:54:53 PM', '6/26/2011 6:56:34 PM', 'TheHonorSquad.comMIX', 'NULL', 147, 101, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(210, 'Juba187', 'D', '58678398', '6/26/2011 5:56:07 PM', '6/26/2011 6:12:02 PM', 'TheHonorSquad.comMIX', 'NULL', 19, 30, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(211, 'pure_lunatic', 'D', '64359034', '6/26/2011 5:56:49 PM', '6/26/2011 6:17:57 PM', 'TheHonorSquad.comMIX', 'NULL', 28, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(212, 'Umd78', 'D', '51464615', '6/26/2011 5:59:36 PM', '6/26/2011 6:36:34 PM', 'TheHonorSquad.comMIX', 'NULL', 58, 72, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(213, 'Cepical', 'D', '15971094', '6/26/2011 5:59:44 PM', '6/26/2011 6:12:49 PM', 'TheHonorSquad.comMIX', 'NULL', 25, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(214, 'SAma''EL', 'D', '52088642', '6/26/2011 6:02:29 PM', '6/26/2011 6:08:24 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(215, 'Bugs*Weizer', 'D', '78794984', '6/26/2011 6:03:02 PM', '6/26/2011 6:10:15 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(216, 'notil2', 'D', '76144305', '6/26/2011 6:05:31 PM', '6/26/2011 6:06:41 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(217, 'painkiller', 'D', '3258442', '6/26/2011 6:10:45 PM', '6/26/2011 6:11:59 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(218, 'Jetslife', 'D', '40912057', '6/26/2011 6:18:16 PM', '6/26/2011 6:36:30 PM', 'TheHonorSquad.comMIX', 'NULL', 31, 19, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(219, 'cali', 'D', '83735261', '6/26/2011 6:18:16 PM', '6/26/2011 6:30:08 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(220, 'wilkiam', 'D', '73008565', '6/26/2011 6:19:54 PM', '6/26/2011 6:23:59 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(221, 'Mercenary410', 'D', '40528391', '6/26/2011 6:24:18 PM', '6/26/2011 6:25:34 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(222, 'DaiMon', 'D', '52433875', '6/26/2011 6:25:08 PM', '6/26/2011 6:33:53 PM', 'TheHonorSquad.comMIX', 'NULL', 5, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(223, 'Fraggle Rock', 'D', '83332246', '6/26/2011 6:25:57 PM', '6/27/2011 1:04:40 AM', 'TheHonorSquad.comMIX', 'NULL', 27, 86, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(224, 'Ghost', 'D', '71036148', '6/26/2011 6:29:56 PM', '6/26/2011 6:32:00 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 3, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(225, 'Griffon', 'D', '1277629', '6/26/2011 6:31:02 PM', '6/26/2011 6:46:48 PM', 'TheHonorSquad.comMIX', 'NULL', 16, 26, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(226, 'LIZARD1', 'D', '57064964', '6/26/2011 6:33:06 PM', '6/26/2011 6:35:30 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(227, 'TweaK', 'D', '19386369', '6/26/2011 6:35:42 PM', '6/26/2011 8:23:56 PM', 'TheHonorSquad.comMIX', 'NULL', 170, 200, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(228, 'Goldfish', 'D', '5057367', '6/26/2011 6:35:42 PM', '6/26/2011 8:23:23 PM', 'TheHonorSquad.comMIX', 'NULL', 200, 204, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(229, 'Anonymous Guy', 'D', '82973606', '6/26/2011 6:36:32 PM', '6/26/2011 6:46:50 PM', 'TheHonorSquad.comMIX', 'NULL', 36, 16, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(230, 'ZeDoPeixe', 'D', '63929935', '6/26/2011 6:37:22 PM', '6/26/2011 6:43:28 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 16, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(231, 'mathmaster987', 'D', '75508926', '6/26/2011 6:37:30 PM', '6/26/2011 6:39:09 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(232, 'isfsniper', 'D', '74554244', '6/26/2011 6:39:26 PM', '6/26/2011 6:56:24 PM', 'TheHonorSquad.comMIX', 'NULL', 11, 41, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(233, 'devo', 'D', '43596382', '6/26/2011 6:43:51 PM', '6/26/2011 6:53:25 PM', 'TheHonorSquad.comMIX', 'NULL', 5, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(234, 'BellCross', 'D', '55388264', '6/26/2011 6:45:46 PM', '6/26/2011 6:46:28 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(235, 'hisham', 'D', '55689007', '6/26/2011 6:47:18 PM', '6/26/2011 7:25:07 PM', 'TheHonorSquad.comMIX', 'NULL', 45, 65, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(236, 'Vojnik', 'D', '56936237', '6/26/2011 6:50:04 PM', '6/26/2011 6:53:54 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 4, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(237, 'BENJAMIN MARQUAR', 'D', '81914000', '6/26/2011 6:51:11 PM', '6/26/2011 7:06:26 PM', 'TheHonorSquad.comMIX', 'NULL', 14, 28, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(238, 'StonedQc', 'D', '55320285', '6/26/2011 6:54:46 PM', '6/26/2011 7:07:00 PM', 'TheHonorSquad.comMIX', 'NULL', 21, 15, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(239, 'MARQUITO', 'D', '74669681', '6/26/2011 6:56:44 PM', '6/26/2011 6:58:11 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 4, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(240, 'cV-RedOrchestra', 'D', '21509437', '6/26/2011 6:56:44 PM', '6/26/2011 7:06:26 PM', 'TheHonorSquad.comMIX', 'NULL', 22, 14, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(241, 'VG:.Z3RO', 'D', '44362538', '6/26/2011 6:58:23 PM', '6/26/2011 7:06:26 PM', 'TheHonorSquad.comMIX', 'NULL', 16, 9, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(242, 'Vampiiric', 'D', '56048700', '6/26/2011 6:58:40 PM', '6/26/2011 7:07:08 PM', 'TheHonorSquad.comMIX', 'NULL', 4, 8, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(243, 'ArtIcuLo MorTis', 'D', '29252944', '6/26/2011 6:58:40 PM', '6/26/2011 7:00:27 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 3, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(245, 'joanne_serge', 'D', '74018817', '6/26/2011 6:59:46 PM', '6/26/2011 7:08:36 PM', 'TheHonorSquad.comMIX', 'NULL', 9, 15, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(246, 'ShadowlessFigure', 'D', '59039447', '6/26/2011 7:06:35 PM', '6/26/2011 7:07:55 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(247, 'Naggafin', 'D', '38800467', '6/26/2011 7:07:26 PM', '6/26/2011 7:09:58 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(248, 'Aspara GUY', 'D', '11029887', '6/26/2011 7:07:43 PM', '6/26/2011 7:16:34 PM', 'TheHonorSquad.comMIX', 'NULL', 6, 15, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(249, '1jtensai', 'D', '83470562', '6/26/2011 7:07:43 PM', '6/26/2011 7:16:30 PM', 'TheHonorSquad.comMIX', 'NULL', 13, 19, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(250, 'Ptit crisss', 'D', '72868617', '6/26/2011 7:08:07 PM', '6/26/2011 7:16:33 PM', 'TheHonorSquad.comMIX', 'NULL', 10, 13, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(251, 'Unfillable', 'D', '80454224', '6/26/2011 7:09:24 PM', '6/26/2011 8:55:12 PM', 'TheHonorSquad.comMIX', 'NULL', 105, 155, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(252, 'Funk Galaxy', 'D', '71217616', '6/26/2011 7:09:24 PM', '6/26/2011 8:53:23 PM', 'TheHonorSquad.comMIX', 'NULL', 67, 147, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(253, 'Shalbane', 'D', '24185207', '6/26/2011 7:09:24 PM', '6/26/2011 7:10:09 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(254, 'Coully', 'D', '23958458', '6/26/2011 7:12:17 PM', '6/26/2011 7:32:04 PM', 'TheHonorSquad.comMIX', 'NULL', 23, 32, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(255, 'Death', 'D', '61262612', '6/26/2011 7:17:43 PM', '6/26/2011 7:21:41 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(256, 'NYChief', 'D', '55496600', '6/26/2011 7:22:23 PM', '6/26/2011 7:50:55 PM', 'TheHonorSquad.comMIX', 'NULL', 47, 48, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(258, 'Brudnicki', 'D', '47680333', '6/26/2011 7:25:15 PM', '6/26/2011 8:55:16 PM', 'TheHonorSquad.comMIX', 'NULL', 197, 154, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(259, 'Korea', 'D', '55777991', '6/26/2011 7:26:40 PM', '6/26/2011 7:33:28 PM', 'TheHonorSquad.comMIX', 'NULL', 12, 13, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(260, 'SplinterCat', 'D', '33005293', '6/26/2011 7:31:20 PM', '6/26/2011 7:51:10 PM', 'TheHonorSquad.comMIX', 'NULL', 13, 41, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(299, 'Ceelos09', 'D', '81878916', '6/26/2011 8:54:16 PM', '6/26/2011 9:22:51 PM', 'TheHonorSquad.comMIX', 'NULL', 19, 50, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(300, 'groupehumanitair', 'D', '81295370', '6/26/2011 8:56:27 PM', '6/26/2011 9:57:03 PM', 'TheHonorSquad.comMIX', 'NULL', 13, 55, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(301, 'omgukk', 'D', '3571366', '6/26/2011 8:57:07 PM', '6/26/2011 9:29:27 PM', 'TheHonorSquad.comMIX', 'NULL', 71, 39, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(302, 'Wiley C', 'D', '55916870', '6/26/2011 8:57:56 PM', '6/26/2011 9:18:12 PM', 'TheHonorSquad.comMIX', 'NULL', 11, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(303, 'Crazy', 'D', '55637646', '6/26/2011 8:58:21 PM', '6/26/2011 9:02:16 PM', 'TheHonorSquad.comMIX', 'NULL', 5, 8, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(304, 'StoryofMyLife', 'D', '66432475', '6/26/2011 8:58:21 PM', '6/26/2011 9:06:42 PM', 'TheHonorSquad.comMIX', 'NULL', 16, 12, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(305, 'WALKING DEAD', 'D', '74203435', '6/26/2011 8:58:45 PM', '6/26/2011 9:29:43 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 35, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(306, 'Gorilla', 'D', '56238679', '6/26/2011 8:58:53 PM', '6/26/2011 9:06:01 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 13, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(307, 'M&M''s|demox7', 'D', '47986781', '6/26/2011 8:59:10 PM', '6/26/2011 9:42:23 PM', 'TheHonorSquad.comMIX', 'NULL', 25, 71, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(308, 'That Guy', 'D', '34803126', '6/26/2011 8:59:18 PM', '6/26/2011 9:18:08 PM', 'TheHonorSquad.comMIX', 'NULL', 40, 25, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(309, 'A|X*ALIEN', 'D', '63156729', '6/26/2011 9:03:40 PM', '6/26/2011 9:29:49 PM', 'TheHonorSquad.comMIX', 'NULL', 30, 37, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(310, 'Flada', 'D', '78214385', '6/26/2011 9:07:13 PM', '6/26/2011 9:18:10 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 15, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(311, 'pinu83', 'D', '69147877', '6/26/2011 9:07:21 PM', '6/26/2011 9:39:48 PM', 'TheHonorSquad.comMIX', 'NULL', 24, 46, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(312, 'AVC022', 'D', '80618202', '6/26/2011 9:07:29 PM', '6/26/2011 9:26:49 PM', 'TheHonorSquad.comMIX', 'NULL', 33, 39, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(313, 'diegote', 'D', '58824083', '6/26/2011 9:12:15 PM', '6/26/2011 9:57:11 PM', 'TheHonorSquad.comMIX', 'NULL', 32, 40, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(314, 'crew_52', 'D', '72048281', '6/26/2011 9:18:16 PM', '6/26/2011 10:13:19 PM', 'TheHonorSquad.comMIX', 'NULL', 76, 60, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(315, 'petrino.ippolito', 'D', '80811759', '6/26/2011 9:18:41 PM', '6/27/2011 2:10:44 AM', 'TheHonorSquad.comMIX', 'NULL', 27, 55, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(316, 'Ularg', 'D', '34988394', '6/26/2011 9:19:13 PM', '6/26/2011 11:58:50 PM', 'TheHonorSquad.comMIX', 'NULL', 79, 50, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(317, '3ntry', 'D', '31299509', '6/26/2011 9:19:46 PM', '6/26/2011 9:30:55 PM', 'TheHonorSquad.comMIX', 'NULL', 25, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(318, 'wakeby', 'D', '72982840', '6/26/2011 9:19:46 PM', '6/26/2011 9:46:51 PM', 'TheHonorSquad.comMIX', 'NULL', 33, 31, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(319, 'Matt', 'D', '56263293', '6/26/2011 9:23:52 PM', '6/26/2011 9:31:09 PM', 'TheHonorSquad.comMIX', 'NULL', 11, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(320, 'Claytonator', 'D', '26897434', '6/26/2011 9:28:24 PM', '6/26/2011 9:57:11 PM', 'TheHonorSquad.comMIX', 'NULL', 50, 35, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(261, 'HuRRiCane.#', 'D', '83344388', '6/26/2011 7:32:26 PM', '6/26/2011 7:35:07 PM', 'TheHonorSquad.comMIX', 'NULL', 8, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(262, 'wfs228', 'D', '62102082', '6/26/2011 7:36:50 PM', '6/26/2011 7:47:16 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 13, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(263, 'Turn1p', 'D', '14073283', '6/26/2011 7:37:15 PM', '6/26/2011 7:39:59 PM', 'TheHonorSquad.comMIX', 'NULL', 4, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(264, 'conceptualrealit', 'D', '64911151', '6/26/2011 7:41:13 PM', '6/26/2011 7:41:36 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(265, 'Cakeflourz', 'D', '49871629', '6/26/2011 7:46:52 PM', '6/26/2011 10:01:18 PM', 'TheHonorSquad.comMIX', 'NULL', 143, 114, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(266, 'your mom', 'D', '44477114', '6/26/2011 7:48:55 PM', '6/27/2011 1:03:44 AM', 'TheHonorSquad.comMIX', 'NULL', 100, 154, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(267, 'white_arckon', 'D', '12503941', '6/26/2011 7:51:40 PM', '6/26/2011 8:06:57 PM', 'TheHonorSquad.comMIX', 'NULL', 16, 23, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(268, 'Bleach', 'D', '60312739', '6/26/2011 7:51:40 PM', '6/26/2011 8:32:53 PM', 'TheHonorSquad.comMIX', 'NULL', 61, 75, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(269, 'UaFO-JAG302', 'D', '20305054', '6/26/2011 7:58:50 PM', '6/26/2011 8:55:16 PM', 'TheHonorSquad.comMIX', 'NULL', 128, 104, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(270, 'UaFO - BACKDOOR', 'D', '72894892', '6/26/2011 8:05:02 PM', '6/26/2011 8:55:42 PM', 'TheHonorSquad.comMIX', 'NULL', 64, 81, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(271, 'HEAVY', 'D', '48113261', '6/26/2011 8:08:20 PM', '6/26/2011 8:55:20 PM', 'TheHonorSquad.comMIX', 'NULL', 24, 74, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(272, 'MiracleWhip**', 'D', '32462719', '6/26/2011 8:08:29 PM', '6/26/2011 8:09:39 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(273, 'Ninja', 'D', '40924990', '6/26/2011 8:08:29 PM', '6/26/2011 8:20:13 PM', 'TheHonorSquad.comMIX', 'NULL', 8, 22, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(274, 'Jodoxk', 'D', '72303974', '6/26/2011 8:08:47 PM', '6/26/2011 8:43:47 PM', 'TheHonorSquad.comMIX', 'NULL', 24, 72, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(275, 'DesertFox', 'D', '38266113', '6/26/2011 8:09:52 PM', '6/26/2011 9:18:08 PM', 'TheHonorSquad.comMIX', 'NULL', 120, 93, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(276, 'Hoover', 'D', '72793177', '6/26/2011 8:21:18 PM', '6/26/2011 8:32:49 PM', 'TheHonorSquad.comMIX', 'NULL', 25, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(277, 'kpwn99', 'D', '56201868', '6/26/2011 8:22:08 PM', '6/26/2011 8:34:19 PM', 'TheHonorSquad.comMIX', 'NULL', 6, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(278, 'Oz_HoCkEyMaN', 'D', '549097', '6/26/2011 8:22:16 PM', '6/26/2011 8:27:35 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(279, 'UAFO-Lunchmeat', 'D', '74612095', '6/26/2011 8:22:16 PM', '6/26/2011 8:55:40 PM', 'TheHonorSquad.comMIX', 'NULL', 80, 53, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(280, 'blsraposo', 'D', '42993690', '6/26/2011 8:23:05 PM', '6/26/2011 8:54:59 PM', 'TheHonorSquad.comMIX', 'NULL', 26, 51, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(281, 'kc2ttt', 'D', '82008448', '6/26/2011 8:23:05 PM', '6/26/2011 8:23:09 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(282, 'Holokaust', 'D', '50946011', '6/26/2011 8:23:29 PM', '6/26/2011 9:05:55 PM', 'TheHonorSquad.comMIX', 'NULL', 55, 71, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(283, 'papahorvath', 'D', '67258627', '6/26/2011 8:23:29 PM', '6/26/2011 8:32:53 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0);
INSERT INTO `playerdb` (`id`, `username`, `group`, `guid`, `firstseen`, `lastseen`, `server`, `ip`, `kills`, `deaths`, `string1`, `string2`, `string3`, `string4`, `num1`, `num2`, `num3`, `num4`) VALUES
(284, 'Nonstopx', 'D', '39556416', '6/26/2011 8:23:46 PM', '6/26/2011 8:55:20 PM', 'TheHonorSquad.comMIX', 'NULL', 118, 49, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(285, 'Vestfold)jaktti', 'D', '40110903', '6/26/2011 8:24:02 PM', '6/26/2011 8:32:57 PM', 'TheHonorSquad.comMIX', 'NULL', 4, 23, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(286, 'eldianel', 'D', '12776594', '6/26/2011 8:24:18 PM', '6/26/2011 8:24:45 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(287, 'Straydogg', 'D', '55402974', '6/26/2011 8:24:59 PM', '6/26/2011 8:29:37 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(288, 'preston158', 'D', '72046713', '6/26/2011 8:27:02 PM', '6/26/2011 8:44:05 PM', 'TheHonorSquad.comMIX', 'NULL', 13, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(289, 'rhrmd', 'D', '35176938', '6/26/2011 8:33:50 PM', '6/26/2011 8:44:09 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(290, 'bach72', 'D', '83602277', '6/26/2011 8:34:23 PM', '6/26/2011 8:34:47 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(291, 'shogo.ca', 'D', '944973', '6/26/2011 8:34:47 PM', '6/26/2011 9:16:01 PM', 'TheHonorSquad.comMIX', 'NULL', 122, 64, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(292, 'm.charlescandles', 'D', '34421588', '6/26/2011 8:34:55 PM', '6/26/2011 9:29:45 PM', 'TheHonorSquad.comMIX', 'NULL', 137, 92, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(293, 'king-bowser2000', 'D', '83859500', '6/26/2011 8:34:55 PM', '6/26/2011 8:36:30 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(294, 'RockstarS', 'D', '80875750', '6/26/2011 8:37:06 PM', '6/26/2011 8:48:39 PM', 'TheHonorSquad.comMIX', 'NULL', 42, 8, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(295, 'dickabodcrane', 'D', '3749791', '6/26/2011 8:44:09 PM', '6/26/2011 9:45:35 PM', 'TheHonorSquad.comMIX', 'NULL', 89, 103, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(296, 'Jihad Joe', 'D', '33247588', '6/26/2011 8:44:27 PM', '6/26/2011 8:56:52 PM', 'TheHonorSquad.comMIX', 'NULL', 13, 23, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(297, 'BW-UK]Tito[1BW]', 'D', '57556245', '6/26/2011 8:46:06 PM', '6/26/2011 8:46:10 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(298, 'ZzxXJJoSxXzZ', 'D', '64132145', '6/26/2011 8:46:22 PM', '6/26/2011 9:07:11 PM', 'TheHonorSquad.comMIX', 'NULL', 19, 27, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(321, 'coldarchery', 'D', '73391566', '6/26/2011 9:30:42 PM', '6/26/2011 10:13:11 PM', 'TheHonorSquad.comMIX', 'NULL', 37, 57, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(322, 'Reversion', 'D', '72434407', '6/26/2011 9:30:42 PM', '6/26/2011 10:25:33 PM', 'TheHonorSquad.comMIX', 'NULL', 44, 79, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(323, 'salut_bob69', 'D', '21972173', '6/26/2011 9:30:50 PM', '6/26/2011 10:03:48 PM', 'TheHonorSquad.comMIX', 'NULL', 34, 48, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(324, 'jparker11', 'D', '82358814', '6/26/2011 9:31:31 PM', '6/26/2011 9:57:24 PM', 'TheHonorSquad.comMIX', 'NULL', 19, 27, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(325, 'jermeyyz', 'D', '55986035', '6/26/2011 9:32:20 PM', '6/26/2011 9:45:39 PM', 'TheHonorSquad.comMIX', 'NULL', 18, 22, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(326, 'QCM*DESTROY', 'D', '49462863', '6/26/2011 9:32:28 PM', '6/26/2011 9:37:39 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 8, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(327, 'arccos-iZ3dMonit', 'D', '32176263', '6/26/2011 9:34:06 PM', '6/26/2011 10:11:26 PM', 'TheHonorSquad.comMIX', 'NULL', 25, 46, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(328, 'Dprobkw', 'D', '20839746', '6/26/2011 9:35:44 PM', '6/26/2011 9:57:24 PM', 'TheHonorSquad.comMIX', 'NULL', 35, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(329, 'TBS)-Vac Banne', 'D', '54529329', '6/26/2011 9:38:20 PM', '6/26/2011 9:57:11 PM', 'TheHonorSquad.comMIX', 'NULL', 48, 16, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(330, 'nhenry41', 'D', '81340309', '6/26/2011 9:40:39 PM', '6/26/2011 9:47:03 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(331, 'UnderFire Yeah', 'D', '19742958', '6/26/2011 9:44:44 PM', '6/26/2011 10:15:06 PM', 'TheHonorSquad.comMIX', 'NULL', 53, 45, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(332, 'baglin3', 'D', '74721682', '6/26/2011 9:45:58 PM', '6/26/2011 10:13:17 PM', 'TheHonorSquad.comMIX', 'NULL', 7, 35, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(333, 'Kroze', 'D', '8719746', '6/26/2011 9:46:46 PM', '6/27/2011 12:18:08 AM', 'TheHonorSquad.comMIX', 'NULL', 516, 225, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(334, 'CS} STONEY', 'D', '44616893', '6/26/2011 9:47:11 PM', '6/26/2011 10:04:13 PM', 'TheHonorSquad.comMIX', 'NULL', 26, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(335, 'StillBorn|Fx', 'D', '62239089', '6/26/2011 9:47:19 PM', '6/26/2011 9:56:32 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 16, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(336, 'FG_Gold', 'D', '79539954', '6/26/2011 9:47:27 PM', '6/26/2011 9:49:28 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(337, 'ZTS|Grelsto', 'D', '28663862', '6/26/2011 9:50:44 PM', '6/26/2011 10:54:24 PM', 'TheHonorSquad.comMIX', 'NULL', 114, 46, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(338, 'Shadow_FLUX', 'D', '23132733', '6/26/2011 9:57:17 PM', '6/26/2011 10:05:15 PM', 'TheHonorSquad.comMIX', 'NULL', 9, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(339, 'Loko', 'D', '69533039', '6/26/2011 9:59:36 PM', '6/26/2011 11:11:18 PM', 'TheHonorSquad.comMIX', 'NULL', 101, 118, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(340, 'BÅąĉk AngÂ', 'D', '52561924', '6/26/2011 9:59:44 PM', '6/26/2011 10:03:00 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 2, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(344, '10user10', 'D', '76287258', '6/26/2011 10:01:41 PM', '6/26/2011 10:03:02 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(345, 'DR-2012->', 'D', '3851325', '6/26/2011 10:02:48 PM', '6/26/2011 10:02:48 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(346, 'TheWoodsman', 'D', '55356315', '6/26/2011 10:03:04 PM', '6/26/2011 10:34:55 PM', 'TheHonorSquad.comMIX', 'NULL', 19, 27, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(347, 'null', 'D', '874986', '6/26/2011 10:03:46 PM', '6/26/2011 10:07:36 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(348, 'MD}SonofGod', 'D', '56628217', '6/26/2011 10:04:19 PM', '6/26/2011 10:45:15 PM', 'TheHonorSquad.comMIX', 'NULL', 46, 64, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(349, 'The Majestical N', 'D', '66334930', '6/26/2011 10:04:52 PM', '6/26/2011 10:13:17 PM', 'TheHonorSquad.comMIX', 'NULL', 5, 9, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(350, 'Gh0st.', 'D', '33053135', '6/26/2011 10:06:57 PM', '6/26/2011 10:24:07 PM', 'TheHonorSquad.comMIX', 'NULL', 21, 19, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(351, 'KillaKali', 'D', '31909208', '6/26/2011 10:08:03 PM', '6/26/2011 10:23:34 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 15, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(352, 'Dub-Ma$hine', 'D', '73093064', '6/26/2011 10:08:45 PM', '6/26/2011 11:10:31 PM', 'TheHonorSquad.comMIX', 'NULL', 94, 97, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(353, 'Double', 'D', '19802023', '6/26/2011 10:12:20 PM', '6/27/2011 12:12:23 AM', 'TheHonorSquad.comMIX', 'NULL', 390, 110, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(354, 'Mr_AUG5OME', 'D', '78212935', '6/26/2011 10:13:34 PM', '6/26/2011 10:24:05 PM', 'TheHonorSquad.comMIX', 'NULL', 19, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(355, 'bzerk', 'D', '12978195', '6/26/2011 10:14:23 PM', '6/26/2011 10:45:34 PM', 'TheHonorSquad.comMIX', 'NULL', 34, 65, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(356, 'Turtle', 'D', '6555158', '6/26/2011 10:14:31 PM', '6/26/2011 10:23:36 PM', 'TheHonorSquad.comMIX', 'NULL', 10, 9, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(357, 'jgamboa007', 'D', '57521633', '6/26/2011 10:24:09 PM', '6/26/2011 10:32:21 PM', 'TheHonorSquad.comMIX', 'NULL', 4, 15, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(358, 'dcdirtjumper', 'D', '72347626', '6/26/2011 10:24:33 PM', '6/26/2011 10:37:11 PM', 'TheHonorSquad.comMIX', 'NULL', 7, 21, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(359, 'Crevette', 'D', '57676930', '6/26/2011 10:24:50 PM', '6/26/2011 10:30:18 PM', 'TheHonorSquad.comMIX', 'NULL', 4, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(360, 'Megatron++', 'D', '696199', '6/26/2011 10:25:06 PM', '6/26/2011 10:26:21 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 3, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(361, 'ericmitchacho', 'D', '83098230', '6/26/2011 10:25:39 PM', '6/26/2011 10:27:59 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 4, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(362, 'Robert Burtch', 'D', '22685711', '6/26/2011 10:26:20 PM', '6/26/2011 10:44:13 PM', 'TheHonorSquad.comMIX', 'NULL', 14, 32, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(363, 'Surly', 'D', '16961184', '6/26/2011 10:27:59 PM', '6/26/2011 10:35:19 PM', 'TheHonorSquad.comMIX', 'NULL', 5, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(364, 'nextz_666', 'D', '36568494', '6/26/2011 10:28:32 PM', '6/26/2011 10:35:32 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(365, 'ICDa...Light...', 'D', '55737964', '6/26/2011 10:28:49 PM', '6/26/2011 10:46:51 PM', 'TheHonorSquad.comMIX', 'NULL', 31, 22, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(366, 'Country Boy', 'D', '49639952', '6/26/2011 10:31:01 PM', '6/26/2011 11:39:53 PM', 'TheHonorSquad.comMIX', 'NULL', 16, 84, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(367, 'Legion', 'D', '73622359', '6/26/2011 10:35:17 PM', '6/26/2011 10:45:07 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 23, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(368, 'AR52]shannon', 'D', '75761405', '6/26/2011 10:35:50 PM', '6/26/2011 10:38:29 PM', 'TheHonorSquad.comMIX', 'NULL', 2, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(369, 'jhuren11', 'D', '80003637', '6/26/2011 10:35:58 PM', '6/26/2011 10:38:44 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(370, 'lONeLySTraNgeR68', 'D', '72868901', '6/26/2011 10:36:07 PM', '6/26/2011 10:44:28 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 14, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(371, 'EMP=-Quantum', 'D', '73335096', '6/26/2011 10:36:07 PM', '6/26/2011 11:10:35 PM', 'TheHonorSquad.comMIX', 'NULL', 18, 70, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(372, 'dfjoyce', 'D', '83722489', '6/26/2011 10:39:09 PM', '6/26/2011 10:50:20 PM', 'TheHonorSquad.comMIX', 'NULL', 6, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(373, 'St!ng ///', 'D', '57284169', '6/26/2011 10:39:50 PM', '6/26/2011 10:41:34 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(374, 'Xenris|-', 'D', '17098112', '6/26/2011 10:40:15 PM', '6/26/2011 11:39:47 PM', 'TheHonorSquad.comMIX', 'NULL', 207, 60, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(375, 'RatBastard', 'D', '82062390', '6/26/2011 10:42:52 PM', '6/26/2011 11:30:26 PM', 'TheHonorSquad.comMIX', 'NULL', 13, 62, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(376, 'unimatrixzer0', 'D', '8667757', '6/26/2011 10:44:56 PM', '6/26/2011 11:18:26 PM', 'TheHonorSquad.comMIX', 'NULL', 13, 60, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(377, 'opusegg', 'D', '29313692', '6/26/2011 10:45:21 PM', '6/26/2011 11:00:34 PM', 'TheHonorSquad.comMIX', 'NULL', 7, 16, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(378, 'coryfriend_612', 'D', '81010587', '6/26/2011 10:46:03 PM', '6/26/2011 10:47:20 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(379, 'luke42878', 'D', '74402815', '6/26/2011 10:46:28 PM', '6/26/2011 11:01:35 PM', 'TheHonorSquad.comMIX', 'NULL', 10, 9, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(380, 'Ron_Burgandy', 'D', '15462260', '6/26/2011 10:46:45 PM', '6/26/2011 11:18:28 PM', 'TheHonorSquad.comMIX', 'NULL', 49, 44, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(381, 'vgbpc06', 'D', '72800735', '6/26/2011 10:47:51 PM', '6/26/2011 10:53:44 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(382, 'Pyro Mecha', 'D', '35856968', '6/26/2011 10:48:08 PM', '6/26/2011 11:05:24 PM', 'TheHonorSquad.comMIX', 'NULL', 17, 12, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(383, 'Surgeon General', 'D', '13873769', '6/26/2011 10:51:09 PM', '6/26/2011 10:51:40 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(384, 'UFO)Doberman', 'D', '55320145', '6/26/2011 10:54:20 PM', '6/26/2011 11:30:16 PM', 'TheHonorSquad.comMIX', 'NULL', 61, 64, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(385, 'Dreadzoor', 'D', '17339621', '6/26/2011 10:55:50 PM', '6/26/2011 11:10:37 PM', 'TheHonorSquad.comMIX', 'NULL', 17, 20, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(386, 'Renegate [AUT]', 'D', '52631468', '6/26/2011 11:01:40 PM', '6/26/2011 11:40:22 PM', 'TheHonorSquad.comMIX', 'NULL', 49, 41, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(387, 'KILLME', 'D', '82908356', '6/26/2011 11:02:54 PM', '6/26/2011 11:17:04 PM', 'TheHonorSquad.comMIX', 'NULL', 7, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(388, 'maxskate916', 'D', '58178286', '6/26/2011 11:06:20 PM', '6/26/2011 11:41:15 PM', 'TheHonorSquad.comMIX', 'NULL', 21, 39, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(389, 'BettyBlue', 'D', '73015073', '6/26/2011 11:10:37 PM', '6/26/2011 11:30:16 PM', 'TheHonorSquad.comMIX', 'NULL', 14, 26, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(390, 'madmax05', 'D', '7827538', '6/26/2011 11:11:53 PM', '6/26/2011 11:37:43 PM', 'TheHonorSquad.comMIX', 'NULL', 8, 35, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(391, 'Umad Bro', 'D', '75758788', '6/26/2011 11:12:10 PM', '6/26/2011 11:24:01 PM', 'TheHonorSquad.comMIX', 'NULL', 6, 21, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(392, 'myblindchance', 'D', '78495337', '6/26/2011 11:13:56 PM', '6/26/2011 11:15:11 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(393, 'handro', 'D', '73022285', '6/26/2011 11:16:08 PM', '6/26/2011 11:47:23 PM', 'TheHonorSquad.comMIX', 'NULL', 45, 67, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(394, 'Kowita~', 'D', '37915407', '6/26/2011 11:18:03 PM', '6/27/2011 1:14:31 AM', 'TheHonorSquad.comMIX', 'NULL', 139, 104, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(395, 'TPB]KuRONO ☯', 'D', '45749030', '6/26/2011 11:18:12 PM', '6/27/2011 12:00:22 AM', 'TheHonorSquad.comMIX', 'NULL', 32, 62, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(396, 'ASS]Aggressor*', 'D', '76384112', '6/26/2011 11:19:34 PM', '6/26/2011 11:39:49 PM', 'TheHonorSquad.comMIX', 'NULL', 7, 29, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(397, 'meinLeeepen', 'D', '27975830', '6/26/2011 11:19:50 PM', '6/26/2011 11:30:26 PM', 'TheHonorSquad.comMIX', 'NULL', 29, 14, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(398, 'Runn', 'D', '30721996', '6/26/2011 11:23:23 PM', '6/26/2011 11:29:57 PM', 'TheHonorSquad.comMIX', 'NULL', 14, 14, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(399, 'Ivannv86ruS', 'D', '73569533', '6/26/2011 11:25:03 PM', '6/26/2011 11:30:14 PM', 'TheHonorSquad.comMIX', 'NULL', 5, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(400, 'GuloGulo', 'D', '55592822', '6/26/2011 11:30:49 PM', '6/26/2011 11:39:45 PM', 'TheHonorSquad.comMIX', 'NULL', 9, 20, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(401, 'kerhy', 'D', '25097548', '6/26/2011 11:31:13 PM', '6/26/2011 11:39:53 PM', 'TheHonorSquad.comMIX', 'NULL', 5, 7, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(402, '666lbBongRip', 'D', '7128697', '6/26/2011 11:31:13 PM', '6/26/2011 11:32:34 PM', 'TheHonorSquad.comMIX', 'NULL', 1, 1, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(403, 'Barakus', 'D', '177833', '6/26/2011 11:31:55 PM', '6/27/2011 12:13:25 AM', 'TheHonorSquad.comMIX', 'NULL', 55, 66, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(404, 'kish180', 'D', '7464379', '6/26/2011 11:32:36 PM', '6/26/2011 11:39:43 PM', 'TheHonorSquad.comMIX', 'NULL', 10, 4, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(405, 'Tiger-bot Hesh', 'D', '166591', '6/26/2011 11:32:36 PM', '6/27/2011 12:13:23 AM', 'TheHonorSquad.comMIX', 'NULL', 41, 59, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(406, 'manitoass', 'D', '35296182', '6/26/2011 11:32:52 PM', '6/26/2011 11:34:14 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(407, 'Rapscallion', 'D', '55316249', '6/26/2011 11:33:00 PM', '6/27/2011 12:46:56 AM', 'TheHonorSquad.comMIX', 'NULL', 123, 122, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(408, 'askosta', 'D', '72977786', '6/26/2011 11:33:09 PM', '6/27/2011 12:33:16 AM', 'TheHonorSquad.comMIX', 'NULL', 54, 75, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(409, 'ultramegaman963', 'D', '74013434', '6/26/2011 11:38:39 PM', '6/26/2011 11:51:00 PM', 'TheHonorSquad.comMIX', 'NULL', 16, 24, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(410, 'Singularity', 'D', '47828727', '6/26/2011 11:42:41 PM', '6/26/2011 11:51:00 PM', 'TheHonorSquad.comMIX', 'NULL', 11, 14, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(411, 'cryptic.kitten', 'D', '75871237', '6/26/2011 11:44:28 PM', '6/27/2011 12:48:40 AM', 'TheHonorSquad.comMIX', 'NULL', 82, 82, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(412, 'KOR]HolyFxxk', 'D', '58609047', '6/26/2011 11:45:33 PM', '6/26/2011 11:50:56 PM', 'TheHonorSquad.comMIX', 'NULL', 4, 9, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(413, 'PUSSY SLAYER :)', 'D', '72860085', '6/26/2011 11:47:35 PM', '6/26/2011 11:56:54 PM', 'TheHonorSquad.comMIX', 'NULL', 6, 18, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(414, 'Sambo1986', 'D', '83838791', '6/26/2011 11:47:43 PM', '6/26/2011 11:54:23 PM', 'TheHonorSquad.comMIX', 'NULL', 3, 16, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(415, 'DirtDobber', 'D', '59789296', '6/26/2011 11:48:00 PM', '6/26/2011 11:51:08 PM', 'TheHonorSquad.comMIX', 'NULL', 5, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(416, 'jli10', 'D', '79603505', '6/26/2011 11:53:04 PM', '6/27/2011 1:05:15 AM', 'TheHonorSquad.comMIX', 'NULL', 65, 126, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(417, 'Necro', 'D', '47170902', '6/26/2011 11:53:27 PM', '6/27/2011 12:01:46 AM', 'TheHonorSquad.comMIX', 'NULL', 17, 8, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(418, 'FiliN', 'D', '56261461', '6/26/2011 11:54:17 PM', '6/27/2011 12:38:59 AM', 'TheHonorSquad.comMIX', 'NULL', 115, 77, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(419, 'awildbergerolmc', 'D', '83339178', '6/26/2011 11:56:03 PM', '6/27/2011 12:33:22 AM', 'TheHonorSquad.comMIX', 'NULL', 9, 54, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(420, 'CyPhaR', 'D', '50014244', '6/26/2011 11:56:28 PM', '6/27/2011 1:03:50 AM', 'TheHonorSquad.comMIX', 'NULL', 183, 87, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(421, 'alelallan38', 'D', '73721619', '6/26/2011 11:59:29 PM', '6/27/2011 12:06:15 AM', 'TheHonorSquad.comMIX', 'NULL', 4, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(422, 'finmaccul', 'D', '28479065', '6/27/2011 12:00:43 AM', '6/27/2011 12:44:10 AM', 'TheHonorSquad.comMIX', 'NULL', 37, 45, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(423, 'ElYoss', 'D', '24082818', '6/27/2011 12:01:32 AM', '6/27/2011 12:34:55 AM', 'TheHonorSquad.comMIX', 'NULL', 45, 45, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(424, 'Slurm Mckensie', 'D', '30623573', '6/27/2011 12:11:09 AM', '6/27/2011 12:33:20 AM', 'TheHonorSquad.comMIX', 'NULL', 33, 30, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(425, 'hEmO', 'D', '49847787', '6/27/2011 12:15:52 AM', '6/27/2011 1:04:40 AM', 'TheHonorSquad.comMIX', 'NULL', 85, 50, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(426, 'SgtSadanko', 'D', '58777099', '6/27/2011 12:16:00 AM', '6/27/2011 12:33:22 AM', 'TheHonorSquad.comMIX', 'NULL', 15, 31, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(427, 'chunxmkgee', 'D', '81040920', '6/27/2011 12:18:37 AM', '6/27/2011 12:23:52 AM', 'TheHonorSquad.comMIX', 'NULL', 7, 13, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(428, 'sukit}BigToe', 'D', '15719521', '6/27/2011 12:23:08 AM', '6/27/2011 1:04:14 AM', 'TheHonorSquad.comMIX', 'NULL', 57, 50, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(429, 'pHaidOwar', 'D', '10881048', '6/27/2011 12:24:55 AM', '6/27/2011 12:28:07 AM', 'TheHonorSquad.comMIX', 'NULL', 3, 5, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(430, 'ronnieblah', 'D', '82148035', '6/27/2011 12:29:02 AM', '6/27/2011 12:47:49 AM', 'TheHonorSquad.comMIX', 'NULL', 32, 31, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(431, 'rivet`', 'D', '14768373', '6/27/2011 12:35:05 AM', '6/27/2011 1:04:47 AM', 'TheHonorSquad.comMIX', 'NULL', 68, 30, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(341, 'You''re', 'D', '55380720', '6/26/2011 9:59:52 PM', '6/26/2011 10:06:17 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(342, 'Shunt', 'D', '75943904', '6/26/2011 10:00:17 PM', '6/26/2011 10:30:45 PM', 'TheHonorSquad.comMIX', 'NULL', 68, 67, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(343, 'm&m''s]FaceKOHTP', 'D', '81565546', '6/26/2011 10:00:17 PM', '6/26/2011 10:24:19 PM', 'TheHonorSquad.comMIX', 'NULL', 37, 46, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(432, 'Chaoticx', 'D', '79283294', '6/27/2011 12:36:19 AM', '6/27/2011 12:47:45 AM', 'TheHonorSquad.comMIX', 'NULL', 7, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(433, 'dapokerplaya', 'D', '55513272', '6/27/2011 12:41:06 AM', '6/27/2011 12:54:23 AM', 'TheHonorSquad.comMIX', 'NULL', 15, 11, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(434, 'Yetti', 'D', '11177662', '6/27/2011 12:49:33 AM', '6/27/2011 1:03:42 AM', 'TheHonorSquad.comMIX', 'NULL', 14, 12, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(435, 'mgj79', 'D', '80462792', '6/27/2011 2:11:22 AM', '6/27/2011 2:12:35 AM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(436, 'Lanse', 'D', '40824208', '6/28/2011 6:14:03 PM', '6/28/2011 6:15:20 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(437, 'NIPPON', 'D', '62160964', '6/28/2011 6:15:24 PM', '6/28/2011 6:16:17 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(1, 'Tunnleram', 'Server Admin', '9479627', '6/4/2011 9:16:00 PM', '7/2/2011 2:15:46 AM', 'TheHonorSquad.comMIX', 'NULL', 1530, 1396, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(7, 'IcyCup {TTFP}', 'Honor Squad Member', '64765663', '6/4/2011 9:58:12 PM', '7/2/2011 12:36:18 AM', 'TheHonorSquad.comMIX', 'NULL', 354, 409, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(79, 'eg0911', 'Honor Squad Member', '5861363', '6/5/2011 1:49:45 PM', '7/2/2011 2:16:04 AM', 'TheHonorSquad.comMIX', 'NULL', 1303, 533, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(190, 'Chaotic Si1ence', 'D', '33286182', '6/25/2011 6:49:57 PM', '7/2/2011 1:44:03 AM', 'TheHonorSquad.comMIX', 'NULL', 374, 435, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(244, 'Turd~Blossom', 'D', '80473317', '6/26/2011 6:59:13 PM', '7/2/2011 2:04:45 AM', 'TheHonorSquad.comMIX', 'NULL', 77, 123, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(257, 'Always Sunny ^^', 'D', '11321383', '6/26/2011 7:23:55 PM', '7/2/2011 1:33:31 AM', 'TheHonorSquad.comMIX', 'NULL', 138, 65, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(438, 'joda', 'D', '76555891', '7/1/2011 11:34:58 PM', '7/1/2011 11:38:37 PM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(439, 'Dirtbag III', 'D', '82865047', '7/1/2011 11:50:06 PM', '7/2/2011 12:01:32 AM', 'TheHonorSquad.comMIX', 'NULL', 23, 17, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(440, 'zeh goop stains', 'D', '81318657', '7/1/2011 11:50:39 PM', '7/2/2011 12:05:09 AM', 'TheHonorSquad.comMIX', 'NULL', 14, 23, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(441, 'Dreamwarrior', 'D', '83142681', '7/1/2011 11:58:05 PM', '7/2/2011 12:10:27 AM', 'TheHonorSquad.comMIX', 'NULL', 5, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(442, 'killrad', 'D', '19268365', '7/2/2011 12:22:59 AM', '7/2/2011 12:57:38 AM', 'TheHonorSquad.comMIX', 'NULL', 8, 29, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(443, 'Gihard', 'D', '75442444', '7/2/2011 12:29:17 AM', '7/2/2011 12:30:14 AM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(444, 'Bo-Abobo', 'D', '73716312', '7/2/2011 12:30:39 AM', '7/2/2011 12:42:46 AM', 'TheHonorSquad.comMIX', 'NULL', 4, 16, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(445, 'Skaly', 'D', '10302253', '7/2/2011 12:53:48 AM', '7/2/2011 12:57:17 AM', 'TheHonorSquad.comMIX', 'NULL', 0, 3, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(446, 'BeoWulf', 'D', '30620774', '7/2/2011 12:58:32 AM', '7/2/2011 12:59:14 AM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(447, 'Seven', 'D', '53446656', '7/2/2011 12:59:13 AM', '7/2/2011 1:06:46 AM', 'TheHonorSquad.comMIX', 'NULL', 6, 9, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(448, 'Bulletndahead', 'D', '19459396', '7/2/2011 1:09:06 AM', '7/2/2011 1:09:42 AM', 'TheHonorSquad.comMIX', 'NULL', 0, 0, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(449, 'Lotus', 'D', '75355943', '7/2/2011 1:17:06 AM', '7/2/2011 1:33:17 AM', 'TheHonorSquad.comMIX', 'NULL', 16, 39, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(450, 'OutLaw]DrXxL.', 'D', '53929646', '7/2/2011 1:26:03 AM', '7/2/2011 1:33:29 AM', 'TheHonorSquad.comMIX', 'NULL', 5, 14, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(451, 'pgott87', 'D', '83596219', '7/2/2011 1:26:35 AM', '7/2/2011 1:32:35 AM', 'TheHonorSquad.comMIX', 'NULL', 18, 8, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(452, 'ToNic#BlackLolli', 'D', '80778055', '7/2/2011 1:36:28 AM', '7/2/2011 1:44:11 AM', 'TheHonorSquad.comMIX', 'NULL', 5, 12, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(453, 'Robie', 'D', '42656619', '7/2/2011 1:36:28 AM', '7/2/2011 1:44:05 AM', 'TheHonorSquad.comMIX', 'NULL', 12, 10, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(454, 'Akkording', 'D', '58249558', '7/2/2011 1:38:06 AM', '7/2/2011 1:45:24 AM', 'TheHonorSquad.comMIX', 'NULL', 8, 6, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0),
(455, 'peekster.jpg', 'D', '55390716', '7/2/2011 1:48:49 AM', '7/2/2011 2:05:52 AM', 'TheHonorSquad.comMIX', 'NULL', 22, 16, 'NULL', 'NULL', 'NULL', 'NULL', 0, 0, 0, 0);
0

btw, I realize items like dates are not stored as strings which would be ideal.

Unfortunately I am getting this data from an application that creates an MS Access db. I've converted it to MySql and will have to do that repeatedly as stats are updated (unfortunately) so I've left the data the way it was.

0

btw, I realize items like dates are not stored as strings which would be ideal.

Err I mean the fact that dates are stored as strings, but that's not related to the issue.

0

Ok, I can't believe I didn't realize. I do actually have null values. Sorry for the waste of time.

0

Ok, I can't believe I didn't realize. I do actually have null values. Sorry for the waste of time.

I thought realizing the null values would solve the issue, but it would appear I'm still having issues.

I'm using same table structure and similar data to above with the following query adjusted to handle nulls, but KDR doesn't return a value.

$sql = "select bt.ID, bt.Username, bt.Group, bt.GUID, DATEDIFF(curdate(),STR_TO_DATE(bt.FirstSeen, '%m/%d/%Y')) as FirstSeenDays, bt.FirstSeen,  DATEDIFF(curdate(),STR_TO_DATE(bt.LastSeen, '%m/%d/%Y')) as LastSeenDays, bt.LastSeen, bt.Server, bt.IP, cp.id as personid, cp.callsign, 

	CASE
	WHEN ( bt.Kills IS NULL ) THEN '0'
		ELSE bt.Kills
	END AS Kills,
	
	CASE
	WHEN ( bt.Deaths IS NULL ) THEN '0'
		ELSE bt.Deaths
	END AS Deaths,
	
	CASE
	WHEN ( bt.Kills IS NULL AND bt.Deaths IS NOT NULL ) THEN bt.Deaths
	WHEN ( bt.Kills IS NOT NULL AND bt.Deaths IS NULL ) THEN bt.Kills
	WHEN ( bt.Kills IS NULL AND bt.Deaths IS NULL ) THEN '0.00'
	WHEN ( bt.Kills IS NOT NULL AND bt.Deaths IS NOT NULL ) THEN bt.Kills/bt.Deaths
	END AS KDR

		from $blacktomato_db.playerdb bt
		LEFT JOIN $command_db.persons cp ON bt.Username = cp.callsign
		order by bt.Username asc";

Any idea what I might be missing? Any help much appreciated.

0

In your table are no null values but strings with the content 'NULL', while your case statements test for NULL.
I changed that in the test data and purged all references to the persons table (which is missing from the test data) and I get a result table with 450 values.

0

In your table are no null values but strings with the content 'NULL', while your case statements test for NULL.
I changed that in the test data and purged all references to the persons table (which is missing from the test data) and I get a result table with 450 values.

Actually the Kills and Deaths fields are both integers (not strings) and there are several values in those fields that are NULL that I can see.

I don't have the luxury of changing the data. This data is being set by an application that I have no control over. I won't be able to change the data each time it updates.

I'll try and removing the references to the persons table and do more testing.

0

Actually the Kills and Deaths fields are both integers (not strings) and there are several values in those fields that are NULL that I can see.

What's weird is that in the data I posted above it shows zeros for the data, but in phpmyadmin it says NULL.

Is that normal?

0

Ok, so I took the reference to the persons table out. As it did before, the Kills and Deaths return fine, but the KDR returns without a value.

Did this work for you? To me it appears this should work ok, but something is obviously wrong.

$sql = "select bt.ID, bt.Username, bt.Group, bt.GUID, DATEDIFF(curdate(),STR_TO_DATE(bt.FirstSeen, '%m/%d/%Y')) as FirstSeenDays, bt.FirstSeen,  DATEDIFF(curdate(),STR_TO_DATE(bt.LastSeen, '%m/%d/%Y')) as LastSeenDays, bt.LastSeen, bt.Server, bt.IP,

	CASE
	WHEN ( bt.Kills IS NULL ) THEN '0'
		ELSE bt.Kills
	END AS Kills,
	
	CASE
	WHEN ( bt.Deaths IS NULL ) THEN '0'
		ELSE bt.Deaths
	END AS Deaths,
	
	CASE
	WHEN ( bt.Kills IS NULL AND bt.Deaths IS NOT NULL ) THEN bt.Deaths
	WHEN ( bt.Kills IS NOT NULL AND bt.Deaths IS NULL ) THEN bt.Kills
	WHEN ( bt.Kills IS NULL AND bt.Deaths IS NULL ) THEN '0.00'
	WHEN ( bt.Kills IS NOT NULL AND bt.Deaths IS NOT NULL ) THEN bt.Kills/bt.Deaths
	END AS KDR

		from $blacktomato_db.playerdb bt
		order by bt.Username asc";
0

phpMyAdmin shows an italic NULL for null values and a normal NULL for the character string "NULL".
And yes, with your query and my NULL values where you had "NULL" strings the query works. These are the results:

"ID";"Username";"Group";"GUID";"FirstSeenDays";"FirstSeen";"LastSeenDays";"LastSeen";"Server";"IP";"Kills";"Deaths";"KDR"
"347";NULL;"D";"874986";"8";"6/26/2011 10:03:46 PM";"8";"6/26/2011 10:07:36 PM";"TheHonorSquad.comMIX";NULL;"2";"7";"0.2857"
"77";"0x0]Jabbe";"D";"58218627";"29";"6/5/2011 1:47:33 PM";"29";"6/5/2011 1:49:11 PM";"TheHonorSquad.comNUKE";NULL;"7";"4";"1.7500"
"344";"10user10";"D";"76287258";"8";"6/26/2011 10:01:41 PM";"8";"6/26/2011 10:03:02 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"249";"1jtensai";"D";"83470562";"8";"6/26/2011 7:07:43 PM";"8";"6/26/2011 7:16:30 PM";"TheHonorSquad.comMIX";NULL;"13";"19";"0.6842"
"93";"3-Dime";"D";"74397376";"29";"6/5/2011 2:14:02 PM";"29";"6/5/2011 2:24:08 PM";"TheHonorSquad.comNUKE";NULL;"14";"37";"0.3784"
"317";"3ntry";"D";"31299509";"8";"6/26/2011 9:19:46 PM";"8";"6/26/2011 9:30:55 PM";"TheHonorSquad.comMIX";NULL;"25";"17";"1.4706"
"94";"3| Bewbs!";"D";"33287140";"29";"6/5/2011 2:14:27 PM";"29";"6/5/2011 2:22:23 PM";"TheHonorSquad.comNUKE";NULL;"8";"23";"0.3478"
"402";"666lbBongRip";"D";"7128697";"8";"6/26/2011 11:31:13 PM";"8";"6/26/2011 11:32:34 PM";"TheHonorSquad.comMIX";NULL;"1";"1";"1.0000"
"66";"A PIMP NAMED SLI";"D";"65605163";"29";"6/5/2011 1:34:01 PM";"29";"6/5/2011 2:25:11 PM";"TheHonorSquad.comNUKE";NULL;"142";"224";"0.6339"
"121";"a//Ceejack";"D";"60671101";"22";"6/12/2011 8:16:34 PM";"22";"6/12/2011 8:25:02 PM";"TheHonorSquad.comNUKE";NULL;"16";"6";"2.6667"
"120";"a//kawz";"D";"38605359";"22";"6/12/2011 8:16:01 PM";"22";"6/12/2011 8:25:00 PM";"TheHonorSquad.comNUKE";NULL;"6";"15";"0.4000"
"92";"AAC} Slutbumwal";"D";"53919019";"29";"6/5/2011 2:13:29 PM";"29";"6/5/2011 2:28:51 PM";"TheHonorSquad.comNUKE";NULL;"41";"33";"1.2424"
"139";"AbadSkidMark";"D";"73268088";"22";"6/12/2011 9:33:55 PM";"22";"6/12/2011 9:47:39 PM";"TheHonorSquad.comNUKE";NULL;"30";"18";"1.6667"
"195";"abu3zh2005";"D";"83301710";"8";"6/26/2011 5:29:53 PM";"8";"6/26/2011 5:32:28 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"3";"aemccolgan";"D";"80330298";"30";"6/4/2011 9:27:54 PM";"30";"6/4/2011 9:32:14 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"454";"Akkording";"D";"58249558";"2";"7/2/2011 1:38:06 AM";"2";"7/2/2011 1:45:24 AM";"TheHonorSquad.comMIX";NULL;"8";"6";"1.3333"
"421";"alelallan38";"D";"73721619";"8";"6/26/2011 11:59:29 PM";"7";"6/27/2011 12:06:15 AM";"TheHonorSquad.comMIX";NULL;"4";"10";"0.4000"
"83";"alessandroferruc";"D";"72102181";"29";"6/5/2011 1:52:18 PM";"29";"6/5/2011 1:53:36 PM";"TheHonorSquad.comNUKE";NULL;"0";"5";"0.0000"
"39";"Aluterrian";"D";"73241673";"29";"6/5/2011 6:16:41 AM";"29";"6/5/2011 6:16:41 AM";"TheHonorSquad.comNUKE";NULL;"15";"114";"0.1316"
"257";"Always Sunny ^^";"D";"11321383";"8";"6/26/2011 7:23:55 PM";"2";"7/2/2011 1:33:31 AM";"TheHonorSquad.comMIX";NULL;"138";"65";"2.1231"
"229";"Anonymous Guy";"D";"82973606";"8";"6/26/2011 6:36:32 PM";"8";"6/26/2011 6:46:50 PM";"TheHonorSquad.comMIX";NULL;"36";"16";"2.2500"
"368";"AR52]shannon";"D";"75761405";"8";"6/26/2011 10:35:50 PM";"8";"6/26/2011 10:38:29 PM";"TheHonorSquad.comMIX";NULL;"2";"1";"2.0000"
"34";"arapaleabogdan";"D";"65475647";"29";"6/5/2011 6:02:33 AM";"29";"6/5/2011 1:49:52 PM";"TheHonorSquad.comNUKE";NULL;"62";"94";"0.6596"
"327";"arccos-iZ3dMonit";"D";"32176263";"8";"6/26/2011 9:34:06 PM";"8";"6/26/2011 10:11:26 PM";"TheHonorSquad.comMIX";NULL;"25";"46";"0.5435"
"162";"ARG] Mortadela";"D";"43271396";"11";"6/23/2011 7:55:40 PM";"11";"6/23/2011 8:06:30 PM";"TheHonorSquad.comMIX";NULL;"14";"15";"0.9333"
"243";"ArtIcuLo MorTis";"D";"29252944";"8";"6/26/2011 6:58:40 PM";"8";"6/26/2011 7:00:27 PM";"TheHonorSquad.comMIX";NULL;"3";"3";"1.0000"
"408";"askosta";"D";"72977786";"8";"6/26/2011 11:33:09 PM";"7";"6/27/2011 12:33:16 AM";"TheHonorSquad.comMIX";NULL;"54";"75";"0.7200"
"248";"Aspara GUY";"D";"11029887";"8";"6/26/2011 7:07:43 PM";"8";"6/26/2011 7:16:34 PM";"TheHonorSquad.comMIX";NULL;"6";"15";"0.4000"
"396";"ASS]Aggressor*";"D";"76384112";"8";"6/26/2011 11:19:34 PM";"8";"6/26/2011 11:39:49 PM";"TheHonorSquad.comMIX";NULL;"7";"29";"0.2414"
"312";"AVC022";"D";"80618202";"8";"6/26/2011 9:07:29 PM";"8";"6/26/2011 9:26:49 PM";"TheHonorSquad.comMIX";NULL;"33";"39";"0.8462"
"171";"Awesome Bill fro";"D";"10307757";"11";"6/23/2011 8:08:05 PM";"11";"6/23/2011 8:16:09 PM";"TheHonorSquad.comMIX";NULL;"8";"20";"0.4000"
"419";"awildbergerolmc";"D";"83339178";"8";"6/26/2011 11:56:03 PM";"7";"6/27/2011 12:33:22 AM";"TheHonorSquad.comMIX";NULL;"9";"54";"0.1667"
"205";"Axxtasy";"D";"37991452";"8";"6/26/2011 5:53:15 PM";"8";"6/26/2011 6:56:18 PM";"TheHonorSquad.comMIX";NULL;"209";"122";"1.7131"
"309";"A|X*ALIEN";"D";"63156729";"8";"6/26/2011 9:03:40 PM";"8";"6/26/2011 9:29:49 PM";"TheHonorSquad.comMIX";NULL;"30";"37";"0.8108"
"290";"bach72";"D";"83602277";"8";"6/26/2011 8:34:23 PM";"8";"6/26/2011 8:34:47 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"332";"baglin3";"D";"74721682";"8";"6/26/2011 9:45:58 PM";"8";"6/26/2011 10:13:17 PM";"TheHonorSquad.comMIX";NULL;"7";"35";"0.2000"
"130";"Baldy McBald";"D";"35765719";"22";"6/12/2011 8:37:21 PM";"22";"6/12/2011 8:49:58 PM";"TheHonorSquad.comNUKE";NULL;"6";"13";"0.4615"
"403";"Barakus";"D";"177833";"8";"6/26/2011 11:31:55 PM";"7";"6/27/2011 12:13:25 AM";"TheHonorSquad.comMIX";NULL;"55";"66";"0.8333"
"49";"Bboy6763";"D";"64673329";"29";"6/5/2011 7:01:56 AM";"29";"6/5/2011 7:01:57 AM";"TheHonorSquad.comNUKE";NULL;"1";"0";NULL
"67";"BeErNiNjA";"D";"62500815";"29";"6/5/2011 1:36:27 PM";"29";"6/5/2011 2:29:34 PM";"TheHonorSquad.comNUKE";NULL;"84";"93";"0.9032"
"234";"BellCross";"D";"55388264";"8";"6/26/2011 6:45:46 PM";"8";"6/26/2011 6:46:28 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"237";"BENJAMIN MARQUAR";"D";"81914000";"8";"6/26/2011 6:51:11 PM";"8";"6/26/2011 7:06:26 PM";"TheHonorSquad.comMIX";NULL;"14";"28";"0.5000"
"446";"BeoWulf";"D";"30620774";"2";"7/2/2011 12:58:32 AM";"2";"7/2/2011 12:59:14 AM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"389";"BettyBlue";"D";"73015073";"8";"6/26/2011 11:10:37 PM";"8";"6/26/2011 11:30:16 PM";"TheHonorSquad.comMIX";NULL;"14";"26";"0.5385"
"87";"BeX | DiFerence";"D";"53443994";"29";"6/5/2011 2:01:58 PM";"29";"6/5/2011 2:03:51 PM";"TheHonorSquad.comNUKE";NULL;"0";"4";"0.0000"
"98";"Bladder Warts";"D";"55574445";"29";"6/5/2011 2:30:47 PM";"29";"6/5/2011 2:40:48 PM";"TheHonorSquad.comNUKE";NULL;"13";"21";"0.6190"
"268";"Bleach";"D";"60312739";"8";"6/26/2011 7:51:40 PM";"8";"6/26/2011 8:32:53 PM";"TheHonorSquad.comMIX";NULL;"61";"75";"0.8133"
"280";"blsraposo";"D";"42993690";"8";"6/26/2011 8:23:05 PM";"8";"6/26/2011 8:54:59 PM";"TheHonorSquad.comMIX";NULL;"26";"51";"0.5098"
"444";"Bo-Abobo";"D";"73716312";"2";"7/2/2011 12:30:39 AM";"2";"7/2/2011 12:42:46 AM";"TheHonorSquad.comMIX";NULL;"4";"16";"0.2500"
"183";"bobafett1683";"D";"73656416";"11";"6/23/2011 8:22:51 PM";"11";"6/23/2011 8:23:43 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"147";"bruce";"D";"49153594";"15";"6/19/2011 9:56:57 PM";"15";"6/19/2011 9:58:33 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"258";"Brudnicki";"D";"47680333";"8";"6/26/2011 7:25:15 PM";"8";"6/26/2011 8:55:16 PM";"TheHonorSquad.comMIX";NULL;"197";"154";"1.2792"
"89";"bruninho0201";"D";"81104954";"29";"6/5/2011 2:05:43 PM";"29";"6/5/2011 2:24:40 PM";"TheHonorSquad.comNUKE";NULL;"6";"43";"0.1395"
"215";"Bugs*Weizer";"D";"78794984";"8";"6/26/2011 6:03:02 PM";"8";"6/26/2011 6:10:15 PM";"TheHonorSquad.comMIX";NULL;"3";"6";"0.5000"
"448";"Bulletndahead";"D";"19459396";"2";"7/2/2011 1:09:06 AM";"2";"7/2/2011 1:09:42 AM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"27";"BuNnY PL";"D";"18237707";"29";"6/5/2011 5:46:55 AM";"29";"6/5/2011 5:46:55 AM";"TheHonorSquad.comNUKE";NULL;"148";"132";"1.1212"
"136";"ButtTheHoopoe";"D";"55695837";"22";"6/12/2011 9:05:40 PM";"22";"6/12/2011 9:40:26 PM";"TheHonorSquad.comNUKE";NULL;"82";"55";"1.4909"
"297";"BW-UK]Tito[1BW]";"D";"57556245";"8";"6/26/2011 8:46:06 PM";"8";"6/26/2011 8:46:10 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"355";"bzerk";"D";"12978195";"8";"6/26/2011 10:14:23 PM";"8";"6/26/2011 10:45:34 PM";"TheHonorSquad.comMIX";NULL;"34";"65";"0.5231"
"340";"BÅ?ąĉk AngÂ";"D";"52561924";"8";"6/26/2011 9:59:44 PM";"8";"6/26/2011 10:03:00 PM";"TheHonorSquad.comMIX";NULL;"0";"2";"0.0000"
"200";"C Fodder";"D";"55324963";"8";"6/26/2011 5:43:26 PM";"8";"6/26/2011 5:57:47 PM";"TheHonorSquad.comMIX";NULL;"11";"18";"0.6111"
"84";"cacaarend";"D";"82498981";"29";"6/5/2011 1:52:18 PM";"29";"6/5/2011 2:00:53 PM";"TheHonorSquad.comNUKE";NULL;"1";"22";"0.0455"
"265";"Cakeflourz";"D";"49871629";"8";"6/26/2011 7:46:52 PM";"8";"6/26/2011 10:01:18 PM";"TheHonorSquad.comMIX";NULL;"143";"114";"1.2544"
"219";"cali";"D";"83735261";"8";"6/26/2011 6:18:16 PM";"8";"6/26/2011 6:30:08 PM";"TheHonorSquad.comMIX";NULL;"0";"18";"0.0000"
"106";"Cats_tracker";"D";"46364136";"29";"6/5/2011 2:48:51 PM";"29";"6/5/2011 2:54:29 PM";"TheHonorSquad.comNUKE";NULL;"5";"4";"1.2500"
"299";"Ceelos09";"D";"81878916";"8";"6/26/2011 8:54:16 PM";"8";"6/26/2011 9:22:51 PM";"TheHonorSquad.comMIX";NULL;"19";"50";"0.3800"
"213";"Cepical";"D";"15971094";"8";"6/26/2011 5:59:44 PM";"8";"6/26/2011 6:12:49 PM";"TheHonorSquad.comMIX";NULL;"25";"18";"1.3889"
"62";"Cfrost";"D";"76285683";"29";"6/5/2011 1:14:51 PM";"29";"6/5/2011 1:17:25 PM";"TheHonorSquad.comNUKE";NULL;"4";"2";"2.0000"
"190";"Chaotic Si1ence";"D";"33286182";"9";"6/25/2011 6:49:57 PM";"2";"7/2/2011 1:44:03 AM";"TheHonorSquad.comMIX";NULL;"374";"435";"0.8598"
"432";"Chaoticx";"D";"79283294";"7";"6/27/2011 12:36:19 AM";"7";"6/27/2011 12:47:45 AM";"TheHonorSquad.comMIX";NULL;"7";"17";"0.4118"
"59";"chinedooo";"D";"72842474";"29";"6/5/2011 1:05:45 PM";"29";"6/5/2011 1:38:38 PM";"TheHonorSquad.comNUKE";NULL;"135";"68";"1.9853"
"11";"CHOPPER GUNNER";"D";"70064629";"30";"6/4/2011 10:07:18 PM";"30";"6/4/2011 10:19:32 PM";"TheHonorSquad.comNUKE";NULL;"13";"27";"0.4815"
"191";"chsdawg07";"D";"83803214";"8";"6/26/2011 4:09:51 PM";"8";"6/26/2011 4:13:00 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"427";"chunxmkgee";"D";"81040920";"7";"6/27/2011 12:18:37 AM";"7";"6/27/2011 12:23:52 AM";"TheHonorSquad.comMIX";NULL;"7";"13";"0.5385"
"18";"cinalbin";"D";"65380456";"29";"6/5/2011 5:04:50 AM";"27";"6/7/2011 1:13:18 PM";"TheHonorSquad.comNUKE";NULL;"76";"95";"0.8000"
"86";"Clairvoyant";"D";"27548716";"29";"6/5/2011 2:01:00 PM";"8";"6/26/2011 9:11:06 PM";"TheHonorSquad.comMIX";NULL;"28";"56";"0.5000"
"320";"Claytonator";"D";"26897434";"8";"6/26/2011 9:28:24 PM";"8";"6/26/2011 9:57:11 PM";"TheHonorSquad.comMIX";NULL;"50";"35";"1.4286"
"15";"Col. Harris";"D";"75230581";"29";"6/5/2011 5:01:35 AM";"29";"6/5/2011 12:53:09 PM";"TheHonorSquad.comNUKE";NULL;"205";"169";"1.2130"
"321";"coldarchery";"D";"73391566";"8";"6/26/2011 9:30:42 PM";"8";"6/26/2011 10:13:11 PM";"TheHonorSquad.comMIX";NULL;"37";"57";"0.6491"
"264";"conceptualrealit";"D";"64911151";"8";"6/26/2011 7:41:13 PM";"8";"6/26/2011 7:41:36 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"85";"coolmanz";"D";"80540110";"29";"6/5/2011 1:57:29 PM";"29";"6/5/2011 2:04:53 PM";"TheHonorSquad.comNUKE";NULL;"3";"20";"0.1500"
"54";"coolyers";"Honor Squad Member";"59958777";"29";"6/5/2011 12:41:52 PM";"22";"6/12/2011 9:31:12 PM";"TheHonorSquad.comNUKE";NULL;"177";"200";"0.8850"
"378";"coryfriend_612";"D";"81010587";"8";"6/26/2011 10:46:03 PM";"8";"6/26/2011 10:47:20 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"254";"Coully";"D";"23958458";"8";"6/26/2011 7:12:17 PM";"8";"6/26/2011 7:32:04 PM";"TheHonorSquad.comMIX";NULL;"23";"32";"0.7188"
"366";"Country Boy";"D";"49639952";"8";"6/26/2011 10:31:01 PM";"8";"6/26/2011 11:39:53 PM";"TheHonorSquad.comMIX";NULL;"16";"84";"0.1905"
"303";"Crazy";"D";"55637646";"8";"6/26/2011 8:58:21 PM";"8";"6/26/2011 9:02:16 PM";"TheHonorSquad.comMIX";NULL;"5";"8";"0.6250"
"359";"Crevette";"D";"57676930";"8";"6/26/2011 10:24:50 PM";"8";"6/26/2011 10:30:18 PM";"TheHonorSquad.comMIX";NULL;"4";"10";"0.4000"
"314";"crew_52";"D";"72048281";"8";"6/26/2011 9:18:16 PM";"8";"6/26/2011 10:13:19 PM";"TheHonorSquad.comMIX";NULL;"76";"60";"1.2667"
"177";"CRUSHER";"D";"56472962";"11";"6/23/2011 8:17:46 PM";"11";"6/23/2011 8:17:46 PM";"TheHonorSquad.comMIX";NULL;"19";"13";"1.4615"
"411";"cryptic.kitten";"D";"75871237";"8";"6/26/2011 11:44:28 PM";"7";"6/27/2011 12:48:40 AM";"TheHonorSquad.comMIX";NULL;"82";"82";"1.0000"
"334";"CS} STONEY";"D";"44616893";"8";"6/26/2011 9:47:11 PM";"8";"6/26/2011 10:04:13 PM";"TheHonorSquad.comMIX";NULL;"26";"24";"1.0833"
"240";"cV-RedOrchestra";"D";"21509437";"8";"6/26/2011 6:56:44 PM";"8";"6/26/2011 7:06:26 PM";"TheHonorSquad.comMIX";NULL;"22";"14";"1.5714"
"420";"CyPhaR";"D";"50014244";"8";"6/26/2011 11:56:28 PM";"7";"6/27/2011 1:03:50 AM";"TheHonorSquad.comMIX";NULL;"183";"87";"2.1034"
"135";"d3v0";"D";"5495937";"22";"6/12/2011 9:02:04 PM";"22";"6/12/2011 9:03:02 PM";"TheHonorSquad.comNUKE";NULL;"1";"2";"0.5000"
"133";"DaCoStE..";"D";"71229436";"22";"6/12/2011 8:47:29 PM";"22";"6/12/2011 9:31:14 PM";"TheHonorSquad.comNUKE";NULL;"23";"75";"0.3067"
"207";"Dagger2b";"D";"15473971";"8";"6/26/2011 5:53:31 PM";"8";"6/26/2011 9:29:31 PM";"TheHonorSquad.comMIX";NULL;"443";"276";"1.6051"
"222";"DaiMon";"D";"52433875";"8";"6/26/2011 6:25:08 PM";"8";"6/26/2011 6:33:53 PM";"TheHonorSquad.comMIX";NULL;"5";"18";"0.2778"
"30";"danielias1";"D";"60136776";"29";"6/5/2011 5:51:03 AM";"29";"6/5/2011 5:53:26 AM";"TheHonorSquad.comNUKE";NULL;"0";"2";"0.0000"
"433";"dapokerplaya";"D";"55513272";"7";"6/27/2011 12:41:06 AM";"7";"6/27/2011 12:54:23 AM";"TheHonorSquad.comMIX";NULL;"15";"11";"1.3636"
"45";"dave_yola";"D";"82509921";"29";"6/5/2011 6:37:39 AM";"29";"6/5/2011 6:37:39 AM";"TheHonorSquad.comNUKE";NULL;"12";"26";"0.4615"
"358";"dcdirtjumper";"D";"72347626";"8";"6/26/2011 10:24:33 PM";"8";"6/26/2011 10:37:11 PM";"TheHonorSquad.comMIX";NULL;"7";"21";"0.3333"
"255";"Death";"D";"61262612";"8";"6/26/2011 7:17:43 PM";"8";"6/26/2011 7:21:41 PM";"TheHonorSquad.comMIX";NULL;"0";"2";"0.0000"
"52";"Death Killer";"D";"75748697";"29";"6/5/2011 12:06:18 PM";"29";"6/5/2011 12:07:31 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"192";"Deezy";"D";"56285352";"8";"6/26/2011 5:28:40 PM";"8";"6/26/2011 7:25:15 PM";"TheHonorSquad.comMIX";NULL;"251";"225";"1.1156"
"103";"denilsonkw";"D";"58245360";"29";"6/5/2011 2:43:08 PM";"29";"6/5/2011 3:12:02 PM";"TheHonorSquad.comNUKE";NULL;"51";"96";"0.5313"
"275";"DesertFox";"D";"38266113";"8";"6/26/2011 8:09:52 PM";"8";"6/26/2011 9:18:08 PM";"TheHonorSquad.comMIX";NULL;"120";"93";"1.2903"
"233";"devo";"D";"43596382";"8";"6/26/2011 6:43:51 PM";"8";"6/26/2011 6:53:25 PM";"TheHonorSquad.comMIX";NULL;"5";"17";"0.2941"
"372";"dfjoyce";"D";"83722489";"8";"6/26/2011 10:39:09 PM";"8";"6/26/2011 10:50:20 PM";"TheHonorSquad.comMIX";NULL;"6";"24";"0.2500"
"295";"dickabodcrane";"D";"3749791";"8";"6/26/2011 8:44:09 PM";"8";"6/26/2011 9:45:35 PM";"TheHonorSquad.comMIX";NULL;"89";"103";"0.8641"
"313";"diegote";"D";"58824083";"8";"6/26/2011 9:12:15 PM";"8";"6/26/2011 9:57:11 PM";"TheHonorSquad.comMIX";NULL;"32";"40";"0.8000"
"181";"Dienekes";"D";"72890372";"11";"6/23/2011 8:20:31 PM";"11";"6/23/2011 8:20:31 PM";"TheHonorSquad.comMIX";NULL;"6";"18";"0.3333"
"439";"Dirtbag III";"D";"82865047";"3";"7/1/2011 11:50:06 PM";"2";"7/2/2011 12:01:32 AM";"TheHonorSquad.comMIX";NULL;"23";"17";"1.3529"
"415";"DirtDobber";"D";"59789296";"8";"6/26/2011 11:48:00 PM";"8";"6/26/2011 11:51:08 PM";"TheHonorSquad.comMIX";NULL;"5";"6";"0.8333"
"165";"Diss0lve";"D";"68088451";"11";"6/23/2011 7:56:31 PM";"11";"6/23/2011 8:26:51 PM";"TheHonorSquad.comMIX";NULL;"94";"44";"2.1364"
"123";"dominic";"D";"861833";"22";"6/12/2011 8:18:35 PM";"22";"6/12/2011 10:16:07 PM";"TheHonorSquad.comNUKE";NULL;"160";"166";"0.9639"
"47";"Don't Taze Me Br";"D";"37126956";"29";"6/5/2011 6:51:59 AM";"29";"6/5/2011 6:51:59 AM";"TheHonorSquad.comNUKE";NULL;"13";"6";"2.1667"
"196";"doogman";"D";"36201744";"8";"6/26/2011 5:36:07 PM";"8";"6/26/2011 5:57:58 PM";"TheHonorSquad.comMIX";NULL;"26";"37";"0.7027"
"353";"Double";"D";"19802023";"8";"6/26/2011 10:12:20 PM";"7";"6/27/2011 12:12:23 AM";"TheHonorSquad.comMIX";NULL;"390";"110";"3.5455"
"328";"Dprobkw";"D";"20839746";"8";"6/26/2011 9:35:44 PM";"8";"6/26/2011 9:57:24 PM";"TheHonorSquad.comMIX";NULL;"35";"24";"1.4583"
"345";"DR-2012->";"D";"3851325";"8";"6/26/2011 10:02:48 PM";"8";"6/26/2011 10:02:48 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"209";"Dr. D-Dog";"D";"15504393";"8";"6/26/2011 5:54:53 PM";"8";"6/26/2011 6:56:34 PM";"TheHonorSquad.comMIX";NULL;"147";"101";"1.4554"
"385";"Dreadzoor";"D";"17339621";"8";"6/26/2011 10:55:50 PM";"8";"6/26/2011 11:10:37 PM";"TheHonorSquad.comMIX";NULL;"17";"20";"0.8500"
"441";"Dreamwarrior";"D";"83142681";"3";"7/1/2011 11:58:05 PM";"2";"7/2/2011 12:10:27 AM";"TheHonorSquad.comMIX";NULL;"5";"6";"0.8333"
"88";"DTK) AlfredO";"D";"13934812";"29";"6/5/2011 2:02:06 PM";"29";"6/5/2011 2:13:29 PM";"TheHonorSquad.comNUKE";NULL;"28";"32";"0.8750"
"352";"Dub-Ma$hine";"D";"73093064";"8";"6/26/2011 10:08:45 PM";"8";"6/26/2011 11:10:31 PM";"TheHonorSquad.comMIX";NULL;"94";"97";"0.9691"
"79";"eg0911";"Honor Squad Member";"5861363";"29";"6/5/2011 1:49:45 PM";"2";"7/2/2011 2:16:04 AM";"TheHonorSquad.comMIX";NULL;"1303";"533";"2.4447"
"132";"eHvUeRlTySn";"D";"55305852";"22";"6/12/2011 8:46:14 PM";"22";"6/12/2011 9:31:10 PM";"TheHonorSquad.comNUKE";NULL;"62";"37";"1.6757"
"82";"ekspert";"D";"37407818";"29";"6/5/2011 1:51:19 PM";"29";"6/5/2011 1:52:05 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"68";"Eldar";"D";"72870155";"29";"6/5/2011 1:37:59 PM";"29";"6/5/2011 2:01:02 PM";"TheHonorSquad.comNUKE";NULL;"46";"56";"0.8214"
"286";"eldianel";"D";"12776594";"8";"6/26/2011 8:24:18 PM";"8";"6/26/2011 8:24:45 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"423";"ElYoss";"D";"24082818";"7";"6/27/2011 12:01:32 AM";"7";"6/27/2011 12:34:55 AM";"TheHonorSquad.comMIX";NULL;"45";"45";"1.0000"
"371";"EMP=-Quantum";"D";"73335096";"8";"6/26/2011 10:36:07 PM";"8";"6/26/2011 11:10:35 PM";"TheHonorSquad.comMIX";NULL;"18";"70";"0.2571"
"25";"ePh3x";"D";"74620879";"29";"6/5/2011 5:32:16 AM";"29";"6/5/2011 5:37:42 AM";"TheHonorSquad.comNUKE";NULL;"18";"9";"2.0000"
"361";"ericmitchacho";"D";"83098230";"8";"6/26/2011 10:25:39 PM";"8";"6/26/2011 10:27:59 PM";"TheHonorSquad.comMIX";NULL;"2";"4";"0.5000"
"16";"F.s.B.]gryga.kl";"D";"77799167";"29";"6/5/2011 5:02:16 AM";"29";"6/5/2011 6:45:22 AM";"TheHonorSquad.comNUKE";NULL;"91";"173";"0.5260"
"336";"FG_Gold";"D";"79539954";"8";"6/26/2011 9:47:27 PM";"8";"6/26/2011 9:49:28 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"418";"FiliN";"D";"56261461";"8";"6/26/2011 11:54:17 PM";"7";"6/27/2011 12:38:59 AM";"TheHonorSquad.comMIX";NULL;"115";"77";"1.4935"
"23";"Fine Asian Guy";"D";"71509559";"29";"6/5/2011 5:27:08 AM";"29";"6/5/2011 5:33:12 AM";"TheHonorSquad.comNUKE";NULL;"14";"19";"0.7368"
"422";"finmaccul";"D";"28479065";"7";"6/27/2011 12:00:43 AM";"7";"6/27/2011 12:44:10 AM";"TheHonorSquad.comMIX";NULL;"37";"45";"0.8222"
"310";"Flada";"D";"78214385";"8";"6/26/2011 9:07:13 PM";"8";"6/26/2011 9:18:10 PM";"TheHonorSquad.comMIX";NULL;"2";"15";"0.1333"
"72";"flash #opre";"D";"3167014";"29";"6/5/2011 1:40:03 PM";"29";"6/5/2011 2:00:53 PM";"TheHonorSquad.comNUKE";NULL;"54";"55";"0.9818"
"223";"Fraggle Rock";"D";"83332246";"8";"6/26/2011 6:25:57 PM";"7";"6/27/2011 1:04:40 AM";"TheHonorSquad.comMIX";NULL;"27";"86";"0.3140"
"252";"Funk Galaxy";"D";"71217616";"8";"6/26/2011 7:09:24 PM";"8";"6/26/2011 8:53:23 PM";"TheHonorSquad.comMIX";NULL;"67";"147";"0.4558"
"199";"FutaFan";"D";"37661715";"8";"6/26/2011 5:43:26 PM";"8";"6/26/2011 5:49:23 PM";"TheHonorSquad.comMIX";NULL;"16";"5";"3.2000"
"137";"gerald_wiles";"D";"60822937";"22";"6/12/2011 9:12:38 PM";"22";"6/12/2011 9:50:07 PM";"TheHonorSquad.comNUKE";NULL;"33";"53";"0.6226"
"350";"Gh0st.";"D";"33053135";"8";"6/26/2011 10:06:57 PM";"8";"6/26/2011 10:24:07 PM";"TheHonorSquad.comMIX";NULL;"21";"19";"1.1053"
"156";"Ghengis~";"D";"41072469";"11";"6/23/2011 7:54:19 PM";"11";"6/23/2011 8:23:43 PM";"TheHonorSquad.comMIX";NULL;"94";"28";"3.3571"
"224";"Ghost";"D";"71036148";"8";"6/26/2011 6:29:56 PM";"8";"6/26/2011 6:32:00 PM";"TheHonorSquad.comMIX";NULL;"0";"3";"0.0000"
"203";"Ghost_";"D";"81600785";"8";"6/26/2011 5:52:00 PM";"8";"6/26/2011 8:06:57 PM";"TheHonorSquad.comMIX";NULL;"49";"231";"0.2121"
"443";"Gihard";"D";"75442444";"2";"7/2/2011 12:29:17 AM";"2";"7/2/2011 12:30:14 AM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"91";"GizdaMan";"D";"37561443";"29";"6/5/2011 2:07:23 PM";"29";"6/5/2011 2:11:48 PM";"TheHonorSquad.comNUKE";NULL;"10";"17";"0.5882"
"228";"Goldfish";"D";"5057367";"8";"6/26/2011 6:35:42 PM";"8";"6/26/2011 8:23:23 PM";"TheHonorSquad.comMIX";NULL;"200";"204";"0.9804"
"306";"Gorilla";"D";"56238679";"8";"6/26/2011 8:58:53 PM";"8";"6/26/2011 9:06:01 PM";"TheHonorSquad.comMIX";NULL;"2";"13";"0.1538"
"185";"Gottimus";"D";"62641487";"11";"6/23/2011 8:23:42 PM";"11";"6/23/2011 8:23:42 PM";"TheHonorSquad.comMIX";NULL;"3";"7";"0.4286"
"40";"granger23";"D";"53575966";"29";"6/5/2011 6:20:17 AM";"29";"6/5/2011 6:22:36 AM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"118";"Green_Kevy";"D";"77033876";"28";"6/6/2011 3:55:36 PM";"28";"6/6/2011 3:57:30 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"225";"Griffon";"D";"1277629";"8";"6/26/2011 6:31:02 PM";"8";"6/26/2011 6:46:48 PM";"TheHonorSquad.comMIX";NULL;"16";"26";"0.6154"
"300";"groupehumanitair";"D";"81295370";"8";"6/26/2011 8:56:27 PM";"8";"6/26/2011 9:57:03 PM";"TheHonorSquad.comMIX";NULL;"13";"55";"0.2364"
"97";"GTX 470 SLI";"D";"28146240";"29";"6/5/2011 2:23:49 PM";"29";"6/5/2011 2:36:05 PM";"TheHonorSquad.comNUKE";NULL;"13";"34";"0.3824"
"400";"GuloGulo";"D";"55592822";"8";"6/26/2011 11:30:49 PM";"8";"6/26/2011 11:39:45 PM";"TheHonorSquad.comMIX";NULL;"9";"20";"0.4500"
"157";"hamsteak";"D";"81198624";"11";"6/23/2011 7:54:36 PM";"11";"6/23/2011 8:19:56 PM";"TheHonorSquad.comMIX";NULL;"10";"43";"0.2326"
"393";"handro";"D";"73022285";"8";"6/26/2011 11:16:08 PM";"8";"6/26/2011 11:47:23 PM";"TheHonorSquad.comMIX";NULL;"45";"67";"0.6716"
"32";"Harpor";"D";"72565311";"29";"6/5/2011 5:54:42 AM";"29";"6/5/2011 6:16:12 AM";"TheHonorSquad.comNUKE";NULL;"15";"58";"0.2586"
"127";"Hawkhunter13";"D";"48057767";"22";"6/12/2011 8:35:58 PM";"22";"6/12/2011 8:51:11 PM";"TheHonorSquad.comNUKE";NULL;"17";"29";"0.5862"
"271";"HEAVY";"D";"48113261";"8";"6/26/2011 8:08:20 PM";"8";"6/26/2011 8:55:20 PM";"TheHonorSquad.comMIX";NULL;"24";"74";"0.3243"
"102";"hector.nnf | #Pr";"D";"33459224";"29";"6/5/2011 2:40:42 PM";"29";"6/5/2011 3:09:38 PM";"TheHonorSquad.comNUKE";NULL;"29";"68";"0.4265"
"187";"HELL|Andres|CoL";"D";"33977604";"11";"6/23/2011 8:24:14 PM";"11";"6/23/2011 8:24:14 PM";"TheHonorSquad.comMIX";NULL;"1";"1";"1.0000"
"425";"hEmO";"D";"49847787";"7";"6/27/2011 12:15:52 AM";"7";"6/27/2011 1:04:40 AM";"TheHonorSquad.comMIX";NULL;"85";"50";"1.7000"
"235";"hisham";"D";"55689007";"8";"6/26/2011 6:47:18 PM";"8";"6/26/2011 7:25:07 PM";"TheHonorSquad.comMIX";NULL;"45";"65";"0.6923"
"69";"HITLER";"D";"72902590";"29";"6/5/2011 1:37:59 PM";"29";"6/5/2011 2:01:02 PM";"TheHonorSquad.comNUKE";NULL;"43";"57";"0.7544"
"71";"hitman";"D";"53846126";"29";"6/5/2011 1:39:45 PM";"29";"6/5/2011 2:00:32 PM";"TheHonorSquad.comNUKE";NULL;"20";"44";"0.4545"
"282";"Holokaust";"D";"50946011";"8";"6/26/2011 8:23:29 PM";"8";"6/26/2011 9:05:55 PM";"TheHonorSquad.comMIX";NULL;"55";"71";"0.7746"
"276";"Hoover";"D";"72793177";"8";"6/26/2011 8:21:18 PM";"8";"6/26/2011 8:32:49 PM";"TheHonorSquad.comMIX";NULL;"25";"24";"1.0417"
"184";"Horsti";"D";"73910327";"11";"6/23/2011 8:23:42 PM";"11";"6/23/2011 8:23:42 PM";"TheHonorSquad.comMIX";NULL;"9";"1";"9.0000"
"261";"HuRRiCane.#";"D";"83344388";"8";"6/26/2011 7:32:26 PM";"8";"6/26/2011 7:35:07 PM";"TheHonorSquad.comMIX";NULL;"8";"5";"1.6000"
"21";"I ZueziidE";"D";"53398559";"29";"6/5/2011 5:17:32 AM";"29";"6/5/2011 6:21:44 AM";"TheHonorSquad.comNUKE";NULL;"125";"109";"1.1468"
"365";"ICDa...Light...";"D";"55737964";"8";"6/26/2011 10:28:49 PM";"8";"6/26/2011 10:46:51 PM";"TheHonorSquad.comMIX";NULL;"31";"22";"1.4091"
"7";"IcyCup {TTFP}";"Honor Squad Member";"64765663";"30";"6/4/2011 9:58:12 PM";"2";"7/2/2011 12:36:18 AM";"TheHonorSquad.comMIX";NULL;"354";"409";"0.8655"
"128";"Im Not Fantasy";"D";"65013171";"22";"6/12/2011 8:36:31 PM";"22";"6/12/2011 9:03:19 PM";"TheHonorSquad.comNUKE";NULL;"54";"56";"0.9643"
"115";"iMuffinsx3";"D";"82145368";"29";"6/5/2011 10:11:48 PM";"29";"6/5/2011 10:15:11 PM";"TheHonorSquad.comNUKE";NULL;"1";"5";"0.2000"
"146";"InTeLz ExtrEmE";"D";"82038015";"15";"6/19/2011 4:21:27 AM";"15";"6/19/2011 4:22:06 AM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"232";"isfsniper";"D";"74554244";"8";"6/26/2011 6:39:26 PM";"8";"6/26/2011 6:56:24 PM";"TheHonorSquad.comMIX";NULL;"11";"41";"0.2683"
"178";"isidrosanches";"D";"74718223";"11";"6/23/2011 8:17:54 PM";"11";"6/23/2011 8:17:54 PM";"TheHonorSquad.comMIX";NULL;"0";"10";"0.0000"
"24";"iTzZ_JoKer";"D";"14030210";"29";"6/5/2011 5:30:47 AM";"29";"6/5/2011 5:50:21 AM";"TheHonorSquad.comNUKE";NULL;"41";"51";"0.8039"
"399";"Ivannv86ruS";"D";"73569533";"8";"6/26/2011 11:25:03 PM";"8";"6/26/2011 11:30:14 PM";"TheHonorSquad.comMIX";NULL;"5";"7";"0.7143"
"325";"jermeyyz";"D";"55986035";"8";"6/26/2011 9:32:20 PM";"8";"6/26/2011 9:45:39 PM";"TheHonorSquad.comMIX";NULL;"18";"22";"0.8182"
"109";"Jessica Alba";"D";"9320420";"29";"6/5/2011 3:02:33 PM";"8";"6/26/2011 6:56:13 PM";"TheHonorSquad.comMIX";NULL;"13";"26";"0.5000"
"218";"Jetslife";"D";"40912057";"8";"6/26/2011 6:18:16 PM";"8";"6/26/2011 6:36:30 PM";"TheHonorSquad.comMIX";NULL;"31";"19";"1.6316"
"357";"jgamboa007";"D";"57521633";"8";"6/26/2011 10:24:09 PM";"8";"6/26/2011 10:32:21 PM";"TheHonorSquad.comMIX";NULL;"4";"15";"0.2667"
"208";"JGRakocy";"D";"14258840";"8";"6/26/2011 5:54:45 PM";"8";"6/26/2011 6:14:10 PM";"TheHonorSquad.comMIX";NULL;"10";"20";"0.5000"
"369";"jhuren11";"D";"80003637";"8";"6/26/2011 10:35:58 PM";"8";"6/26/2011 10:38:44 PM";"TheHonorSquad.comMIX";NULL;"0";"6";"0.0000"
"296";"Jihad Joe";"D";"33247588";"8";"6/26/2011 8:44:27 PM";"8";"6/26/2011 8:56:52 PM";"TheHonorSquad.comMIX";NULL;"13";"23";"0.5652"
"188";"JimHorton";"D";"56419375";"11";"6/23/2011 8:25:11 PM";"11";"6/23/2011 8:25:11 PM";"TheHonorSquad.comMIX";NULL;"0";"2";"0.0000"
"416";"jli10";"D";"79603505";"8";"6/26/2011 11:53:04 PM";"7";"6/27/2011 1:05:15 AM";"TheHonorSquad.comMIX";NULL;"65";"126";"0.5159"
"170";"jM2.me";"D";"55428433";"11";"6/23/2011 8:07:49 PM";"11";"6/23/2011 8:23:30 PM";"TheHonorSquad.comMIX";NULL;"15";"31";"0.4839"
"245";"joanne_serge";"D";"74018817";"8";"6/26/2011 6:59:46 PM";"8";"6/26/2011 7:08:36 PM";"TheHonorSquad.comMIX";NULL;"9";"15";"0.6000"
"438";"joda";"D";"76555891";"3";"7/1/2011 11:34:58 PM";"3";"7/1/2011 11:38:37 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"274";"Jodoxk";"D";"72303974";"8";"6/26/2011 8:08:47 PM";"8";"6/26/2011 8:43:47 PM";"TheHonorSquad.comMIX";NULL;"24";"72";"0.3333"
"5";"john";"D";"19126096";"30";"6/4/2011 9:52:51 PM";"30";"6/4/2011 9:55:46 PM";"TheHonorSquad.comNUKE";NULL;"0";"6";"0.0000"
"78";"Johnny boy";"D";"46035278";"29";"6/5/2011 1:47:50 PM";"29";"6/5/2011 1:48:37 PM";"TheHonorSquad.comNUKE";NULL;"1";"3";"0.3333"
"119";"johnsman";"D";"39558326";"27";"6/7/2011 1:13:09 PM";"27";"6/7/2011 1:18:45 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"64";"JorgeLucas";"D";"1352266";"29";"6/5/2011 1:16:38 PM";"28";"6/6/2011 10:25:10 PM";"TheHonorSquad.comNUKE";NULL;"1";"3";"0.3333"
"14";"joshuabroussard";"D";"65665584";"29";"6/5/2011 1:39:43 AM";"29";"6/5/2011 1:42:58 AM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"324";"jparker11";"D";"82358814";"8";"6/26/2011 9:31:31 PM";"8";"6/26/2011 9:57:24 PM";"TheHonorSquad.comMIX";NULL;"19";"27";"0.7037"
"206";"jqu2";"D";"6094232";"8";"6/26/2011 5:53:31 PM";"8";"6/26/2011 6:17:57 PM";"TheHonorSquad.comMIX";NULL;"17";"18";"0.9444"
"210";"Juba187";"D";"58678398";"8";"6/26/2011 5:56:07 PM";"8";"6/26/2011 6:12:02 PM";"TheHonorSquad.comMIX";NULL;"19";"30";"0.6333"
"182";"k0mpletist";"D";"77526";"11";"6/23/2011 8:22:18 PM";"11";"6/23/2011 8:22:18 PM";"TheHonorSquad.comMIX";NULL;"5";"7";"0.7143"
"70";"K2]DanyPro86-_-";"D";"55886955";"29";"6/5/2011 1:39:21 PM";"29";"6/5/2011 2:15:35 PM";"TheHonorSquad.comNUKE";NULL;"110";"152";"0.7237"
"74";"K2]MaFuma";"D";"53532754";"29";"6/5/2011 1:43:32 PM";"29";"6/5/2011 2:24:12 PM";"TheHonorSquad.comNUKE";NULL;"134";"134";"1.0000"
"75";"K2]MAK4BRON";"D";"52403543";"29";"6/5/2011 1:44:14 PM";"29";"6/5/2011 2:26:47 PM";"TheHonorSquad.comNUKE";NULL;"185";"109";"1.6972"
"281";"kc2ttt";"D";"82008448";"8";"6/26/2011 8:23:05 PM";"8";"6/26/2011 8:23:09 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"401";"kerhy";"D";"25097548";"8";"6/26/2011 11:31:13 PM";"8";"6/26/2011 11:39:53 PM";"TheHonorSquad.comMIX";NULL;"5";"7";"0.7143"
"90";"KGR}Phillips";"D";"58759232";"29";"6/5/2011 2:07:15 PM";"29";"6/5/2011 2:11:57 PM";"TheHonorSquad.comNUKE";NULL;"5";"14";"0.3571"
"351";"KillaKali";"D";"31909208";"8";"6/26/2011 10:08:03 PM";"8";"6/26/2011 10:23:34 PM";"TheHonorSquad.comMIX";NULL;"3";"15";"0.2000"
"387";"KILLME";"D";"82908356";"8";"6/26/2011 11:02:54 PM";"8";"6/26/2011 11:17:04 PM";"TheHonorSquad.comMIX";NULL;"7";"7";"1.0000"
"442";"killrad";"D";"19268365";"2";"7/2/2011 12:22:59 AM";"2";"7/2/2011 12:57:38 AM";"TheHonorSquad.comMIX";NULL;"8";"29";"0.2759"
"293";"king-bowser2000";"D";"83859500";"8";"6/26/2011 8:34:55 PM";"8";"6/26/2011 8:36:30 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"404";"kish180";"D";"7464379";"8";"6/26/2011 11:32:36 PM";"8";"6/26/2011 11:39:43 PM";"TheHonorSquad.comMIX";NULL;"10";"4";"2.5000"
"148";"KlonkeN";"D";"56624566";"14";"6/20/2011 8:18:26 AM";"14";"6/20/2011 8:21:27 AM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"81";"kontogry77";"D";"75115199";"29";"6/5/2011 1:51:19 PM";"29";"6/5/2011 2:29:00 PM";"TheHonorSquad.comNUKE";NULL;"211";"68";"3.1029"
"259";"Korea";"D";"55777991";"8";"6/26/2011 7:26:40 PM";"8";"6/26/2011 7:33:28 PM";"TheHonorSquad.comMIX";NULL;"12";"13";"0.9231"
"412";"KOR]HolyFxxk";"D";"58609047";"8";"6/26/2011 11:45:33 PM";"8";"6/26/2011 11:50:56 PM";"TheHonorSquad.comMIX";NULL;"4";"9";"0.4444"
"394";"Kowita~";"D";"37915407";"8";"6/26/2011 11:18:03 PM";"7";"6/27/2011 1:14:31 AM";"TheHonorSquad.comMIX";NULL;"139";"104";"1.3365"
"277";"kpwn99";"D";"56201868";"8";"6/26/2011 8:22:08 PM";"8";"6/26/2011 8:34:19 PM";"TheHonorSquad.comMIX";NULL;"6";"6";"1.0000"
"76";"Krome X ReMiiXx";"D";"81992963";"29";"6/5/2011 1:46:43 PM";"29";"6/5/2011 4:19:56 PM";"TheHonorSquad.comNUKE";NULL;"0";"6";"0.0000"
"174";"KroNiic Death";"D";"73050892";"11";"6/23/2011 8:16:32 PM";"11";"6/23/2011 8:22:24 PM";"TheHonorSquad.comMIX";NULL;"9";"21";"0.4286"
"333";"Kroze";"D";"8719746";"8";"6/26/2011 9:46:46 PM";"7";"6/27/2011 12:18:08 AM";"TheHonorSquad.comMIX";NULL;"516";"225";"2.2933"
"150";"Kurt_98";"D";"78887519";"11";"6/23/2011 7:50:15 PM";"11";"6/23/2011 8:06:36 PM";"TheHonorSquad.comMIX";NULL;"14";"19";"0.7368"
"436";"Lanse";"D";"40824208";"6";"6/28/2011 6:14:03 PM";"6";"6/28/2011 6:15:20 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"367";"Legion";"D";"73622359";"8";"6/26/2011 10:35:17 PM";"8";"6/26/2011 10:45:07 PM";"TheHonorSquad.comMIX";NULL;"3";"23";"0.1304"
"31";"Lev1974";"D";"56746466";"29";"6/5/2011 5:54:18 AM";"29";"6/5/2011 5:54:43 AM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"138";"LeXx";"D";"3365045";"22";"6/12/2011 9:17:59 PM";"22";"6/12/2011 9:33:41 PM";"TheHonorSquad.comNUKE";NULL;"27";"34";"0.7941"
"163";"Lick!em?";"D";"12732299";"11";"6/23/2011 7:55:40 PM";"11";"6/23/2011 8:16:07 PM";"TheHonorSquad.comMIX";NULL;"45";"39";"1.1538"
"20";"LiNgLiNg";"D";"70243148";"29";"6/5/2011 5:14:34 AM";"29";"6/5/2011 2:13:33 PM";"TheHonorSquad.comNUKE";NULL;"93";"73";"1.2740"
"226";"LIZARD1";"D";"57064964";"8";"6/26/2011 6:33:06 PM";"8";"6/26/2011 6:35:30 PM";"TheHonorSquad.comMIX";NULL;"1";"6";"0.1667"
"339";"Loko";"D";"69533039";"8";"6/26/2011 9:59:36 PM";"8";"6/26/2011 11:11:18 PM";"TheHonorSquad.comMIX";NULL;"101";"118";"0.8559"
"370";"lONeLySTraNgeR68";"D";"72868901";"8";"6/26/2011 10:36:07 PM";"8";"6/26/2011 10:44:28 PM";"TheHonorSquad.comMIX";NULL;"3";"14";"0.2143"
"168";"Loran";"D";"20393407";"11";"6/23/2011 8:07:24 PM";"11";"6/23/2011 8:07:26 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"449";"Lotus";"D";"75355943";"2";"7/2/2011 1:17:06 AM";"2";"7/2/2011 1:33:17 AM";"TheHonorSquad.comMIX";NULL;"16";"39";"0.4103"
"379";"luke42878";"D";"74402815";"8";"6/26/2011 10:46:28 PM";"8";"6/26/2011 11:01:35 PM";"TheHonorSquad.comMIX";NULL;"10";"9";"1.1111"
"343";"m&m's]FaceKOHTP";"D";"81565546";"8";"6/26/2011 10:00:17 PM";"8";"6/26/2011 10:24:19 PM";"TheHonorSquad.comMIX";NULL;"37";"46";"0.8043"
"307";"M&M's|demox7";"D";"47986781";"8";"6/26/2011 8:59:10 PM";"8";"6/26/2011 9:42:23 PM";"TheHonorSquad.comMIX";NULL;"25";"71";"0.3521"
"292";"m.charlescandles";"D";"34421588";"8";"6/26/2011 8:34:55 PM";"8";"6/26/2011 9:29:45 PM";"TheHonorSquad.comMIX";NULL;"137";"92";"1.4891"
"172";"M1ckZ";"D";"52043887";"11";"6/23/2011 8:08:30 PM";"11";"6/23/2011 8:23:32 PM";"TheHonorSquad.comMIX";NULL;"25";"31";"0.8065"
"63";"M1nds!";"D";"60515662";"29";"6/5/2011 1:15:24 PM";"29";"6/5/2011 1:44:51 PM";"TheHonorSquad.comNUKE";NULL;"31";"76";"0.4079"
"37";"MaDaStar";"D";"10390249";"29";"6/5/2011 6:10:50 AM";"29";"6/5/2011 6:21:54 AM";"TheHonorSquad.comNUKE";NULL;"20";"23";"0.8696"
"390";"madmax05";"D";"7827538";"8";"6/26/2011 11:11:53 PM";"8";"6/26/2011 11:37:43 PM";"TheHonorSquad.comMIX";NULL;"8";"35";"0.2286"
"155";"magofkemarcelo";"D";"75453408";"11";"6/23/2011 7:53:55 PM";"11";"6/23/2011 7:53:55 PM";"TheHonorSquad.comMIX";NULL;"13";"76";"0.1711"
"406";"manitoass";"D";"35296182";"8";"6/26/2011 11:32:52 PM";"8";"6/26/2011 11:34:14 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"143";"Marauder";"D";"58622936";"22";"6/12/2011 10:14:18 PM";"22";"6/12/2011 10:15:28 PM";"TheHonorSquad.comNUKE";NULL;"1";"1";"1.0000"
"239";"MARQUITO";"D";"74669681";"8";"6/26/2011 6:56:44 PM";"8";"6/26/2011 6:58:11 PM";"TheHonorSquad.comMIX";NULL;"3";"4";"0.7500"
"204";"martyD";"D";"2764476";"8";"6/26/2011 5:52:09 PM";"8";"6/26/2011 5:59:12 PM";"TheHonorSquad.comMIX";NULL;"2";"7";"0.2857"
"35";"Marvin";"D";"54143811";"29";"6/5/2011 6:06:18 AM";"29";"6/5/2011 6:06:18 AM";"TheHonorSquad.comNUKE";NULL;"80";"130";"0.6154"
"99";"mass murder";"D";"76607793";"29";"6/5/2011 2:34:52 PM";"29";"6/5/2011 2:35:57 PM";"TheHonorSquad.comNUKE";NULL;"0";"2";"0.0000"
"57";"MasterChe";"D";"32981040";"29";"6/5/2011 12:45:40 PM";"29";"6/5/2011 12:47:51 PM";"TheHonorSquad.comNUKE";NULL;"0";"1";"0.0000"
"96";"MatheusGX";"D";"82271988";"29";"6/5/2011 2:15:01 PM";"29";"6/5/2011 2:23:49 PM";"TheHonorSquad.comNUKE";NULL;"7";"26";"0.2692"
"231";"mathmaster987";"D";"75508926";"8";"6/26/2011 6:37:30 PM";"8";"6/26/2011 6:39:09 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"319";"Matt";"D";"56263293";"8";"6/26/2011 9:23:52 PM";"8";"6/26/2011 9:31:09 PM";"TheHonorSquad.comMIX";NULL;"11";"2";"5.5000"
"388";"maxskate916";"D";"58178286";"8";"6/26/2011 11:06:20 PM";"8";"6/26/2011 11:41:15 PM";"TheHonorSquad.comMIX";NULL;"21";"39";"0.5385"
"348";"MD}SonofGod";"D";"56628217";"8";"6/26/2011 10:04:19 PM";"8";"6/26/2011 10:45:15 PM";"TheHonorSquad.comMIX";NULL;"46";"64";"0.7188"
"360";"Megatron++";"D";"696199";"8";"6/26/2011 10:25:06 PM";"8";"6/26/2011 10:26:21 PM";"TheHonorSquad.comMIX";NULL;"1";"3";"0.3333"
"397";"meinLeeepen";"D";"27975830";"8";"6/26/2011 11:19:50 PM";"8";"6/26/2011 11:30:26 PM";"TheHonorSquad.comMIX";NULL;"29";"14";"2.0714"
"149";"MenzkyQc";"D";"73800700";"11";"6/23/2011 7:45:14 PM";"11";"6/23/2011 8:02:49 PM";"TheHonorSquad.comMIX";NULL;"38";"21";"1.8095"
"221";"Mercenary410";"D";"40528391";"8";"6/26/2011 6:24:18 PM";"8";"6/26/2011 6:25:34 PM";"TheHonorSquad.comMIX";NULL;"0";"1";"0.0000"
"435";"mgj79";"D";"80462792";"7";"6/27/2011 2:11:22 AM";"7";"6/27/2011 2:12:35 AM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"9";"MH| KEYLA";"D";"54050580";"30";"6/4/2011 10:01:11 PM";"30";"6/4/2011 10:05:59 PM";"TheHonorSquad.comNUKE";NULL;"6";"5";"1.2000"
"151";"milandijhon";"D";"80157502";"11";"6/23/2011 7:50:48 PM";"11";"6/23/2011 8:00:10 PM";"TheHonorSquad.comMIX";NULL;"1";"8";"0.1250"
"272";"MiracleWhip**";"D";"32462719";"8";"6/26/2011 8:08:29 PM";"8";"6/26/2011 8:09:39 PM";"TheHonorSquad.comMIX";NULL;"1";"1";"1.0000"
"112";"mkayseryan";"D";"79907386";"29";"6/5/2011 10:06:23 PM";"29";"6/5/2011 10:12:00 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"17";"Mn'S]maisonn";"D";"80404961";"29";"6/5/2011 5:04:17 AM";"29";"6/5/2011 12:53:07 PM";"TheHonorSquad.comNUKE";NULL;"204";"174";"1.1724"
"141";"Modus_Ponens";"D";"28478148";"22";"6/12/2011 9:43:49 PM";"22";"6/12/2011 10:15:22 PM";"TheHonorSquad.comNUKE";NULL;"57";"65";"0.8769"
"126";"Monntek";"D";"56492409";"22";"6/12/2011 8:35:40 PM";"22";"6/12/2011 9:15:11 PM";"TheHonorSquad.comNUKE";NULL;"32";"61";"0.5246"
"95";"Morshu (DE)";"D";"61168851";"29";"6/5/2011 2:14:27 PM";"29";"6/5/2011 2:51:24 PM";"TheHonorSquad.comNUKE";NULL;"40";"41";"0.9756"
"164";"MrSushi";"D";"65068760";"11";"6/23/2011 7:56:06 PM";"11";"6/23/2011 8:00:21 PM";"TheHonorSquad.comMIX";NULL;"1";"7";"0.1429"
"354";"Mr_AUG5OME";"D";"78212935";"8";"6/26/2011 10:13:34 PM";"8";"6/26/2011 10:24:05 PM";"TheHonorSquad.comMIX";NULL;"19";"24";"0.7917"
"392";"myblindchance";"D";"78495337";"8";"6/26/2011 11:13:56 PM";"8";"6/26/2011 11:15:11 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"247";"Naggafin";"D";"38800467";"8";"6/26/2011 7:07:26 PM";"8";"6/26/2011 7:09:58 PM";"TheHonorSquad.comMIX";NULL;"1";"2";"0.5000"
"43";"naototto2010";"D";"81893256";"29";"6/5/2011 6:34:11 AM";"29";"6/5/2011 6:42:11 AM";"TheHonorSquad.comNUKE";NULL;"18";"9";"2.0000"
"105";"nate1898";"D";"72123463";"29";"6/5/2011 2:48:35 PM";"29";"6/5/2011 2:57:45 PM";"TheHonorSquad.comNUKE";NULL;"6";"10";"0.6000"
"100";"nazebaze";"D";"67773919";"29";"6/5/2011 2:36:14 PM";"29";"6/5/2011 2:43:00 PM";"TheHonorSquad.comNUKE";NULL;"2";"22";"0.0909"
"417";"Necro";"D";"47170902";"8";"6/26/2011 11:53:27 PM";"7";"6/27/2011 12:01:46 AM";"TheHonorSquad.comMIX";NULL;"17";"8";"2.1250"
"364";"nextz_666";"D";"36568494";"8";"6/26/2011 10:28:32 PM";"8";"6/26/2011 10:35:32 PM";"TheHonorSquad.comMIX";NULL;"1";"10";"0.1000"
"167";"NGxscoot";"D";"38008092";"11";"6/23/2011 8:06:51 PM";"11";"6/23/2011 8:14:49 PM";"TheHonorSquad.comMIX";NULL;"21";"13";"1.6154"
"330";"nhenry41";"D";"81340309";"8";"6/26/2011 9:40:39 PM";"8";"6/26/2011 9:47:03 PM";"TheHonorSquad.comMIX";NULL;"2";"10";"0.2000"
"189";"Nibbler!";"D";"51197996";"11";"6/23/2011 8:25:11 PM";"11";"6/23/2011 8:25:11 PM";"TheHonorSquad.comMIX";NULL;"2";"2";"1.0000"
"42";"nicolas393";"D";"59197622";"29";"6/5/2011 6:30:17 AM";"29";"6/5/2011 6:30:17 AM";"TheHonorSquad.comNUKE";NULL;"27";"40";"0.6750"
"41";"Nigganaattor";"D";"47200992";"29";"6/5/2011 6:25:44 AM";"29";"6/5/2011 12:50:14 PM";"TheHonorSquad.comNUKE";NULL;"119";"63";"1.8889"
"273";"Ninja";"D";"40924990";"8";"6/26/2011 8:08:29 PM";"8";"6/26/2011 8:20:13 PM";"TheHonorSquad.comMIX";NULL;"8";"22";"0.3636"
"140";"Ninja Dunk";"D";"73760660";"22";"6/12/2011 9:41:23 PM";"22";"6/12/2011 9:45:33 PM";"TheHonorSquad.comNUKE";NULL;"6";"5";"1.2000"
"437";"NIPPON";"D";"62160964";"6";"6/28/2011 6:15:24 PM";"6";"6/28/2011 6:16:17 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"284";"Nonstopx";"D";"39556416";"8";"6/26/2011 8:23:46 PM";"8";"6/26/2011 8:55:20 PM";"TheHonorSquad.comMIX";NULL;"118";"49";"2.4082"
"161";"Noon";"D";"75316338";"11";"6/23/2011 7:55:40 PM";"11";"6/23/2011 8:06:16 PM";"TheHonorSquad.comMIX";NULL;"17";"21";"0.8095"
"216";"notil2";"D";"76144305";"8";"6/26/2011 6:05:31 PM";"8";"6/26/2011 6:06:41 PM";"TheHonorSquad.comMIX";NULL;"0";"2";"0.0000"
"36";"NovaStorm";"D";"8256070";"29";"6/5/2011 6:06:37 AM";"29";"6/5/2011 6:21:44 AM";"TheHonorSquad.comNUKE";NULL;"15";"27";"0.5556"
"154";"nschaibly";"D";"82586527";"11";"6/23/2011 7:53:55 PM";"11";"6/23/2011 8:18:44 PM";"TheHonorSquad.comMIX";NULL;"24";"27";"0.8889"
"256";"NYChief";"D";"55496600";"8";"6/26/2011 7:22:23 PM";"8";"6/26/2011 7:50:55 PM";"TheHonorSquad.comMIX";NULL;"47";"48";"0.9792"
"160";"Nyte";"D";"14174611";"11";"6/23/2011 7:54:52 PM";"11";"6/23/2011 7:54:52 PM";"TheHonorSquad.comMIX";NULL;"41";"35";"1.1714"
"301";"omgukk";"D";"3571366";"8";"6/26/2011 8:57:07 PM";"8";"6/26/2011 9:29:27 PM";"TheHonorSquad.comMIX";NULL;"71";"39";"1.8205"
"377";"opusegg";"D";"29313692";"8";"6/26/2011 10:45:21 PM";"8";"6/26/2011 11:00:34 PM";"TheHonorSquad.comMIX";NULL;"7";"16";"0.4375"
"202";"Oscar5";"D";"23914832";"8";"6/26/2011 5:50:30 PM";"8";"6/26/2011 5:53:09 PM";"TheHonorSquad.comMIX";NULL;"4";"4";"1.0000"
"450";"OutLaw]DrXxL.";"D";"53929646";"2";"7/2/2011 1:26:03 AM";"2";"7/2/2011 1:33:29 AM";"TheHonorSquad.comMIX";NULL;"5";"14";"0.3571"
"278";"Oz_HoCkEyMaN";"D";"549097";"8";"6/26/2011 8:22:16 PM";"8";"6/26/2011 8:27:35 PM";"TheHonorSquad.comMIX";NULL;"2";"10";"0.2000"
"145";"P1r4Nha :>";"D";"68599468";"15";"6/19/2011 4:20:30 AM";"15";"6/19/2011 4:21:20 AM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"217";"painkiller";"D";"3258442";"8";"6/26/2011 6:10:45 PM";"8";"6/26/2011 6:11:59 PM";"TheHonorSquad.comMIX";NULL;"0";"1";"0.0000"
"283";"papahorvath";"D";"67258627";"8";"6/26/2011 8:23:29 PM";"8";"6/26/2011 8:32:53 PM";"TheHonorSquad.comMIX";NULL;"3";"6";"0.5000"
"169";"pauljohnbansil";"D";"80944587";"11";"6/23/2011 8:07:24 PM";"11";"6/23/2011 8:17:36 PM";"TheHonorSquad.comMIX";NULL;"0";"10";"0.0000"
"455";"peekster.jpg";"D";"55390716";"2";"7/2/2011 1:48:49 AM";"2";"7/2/2011 2:05:52 AM";"TheHonorSquad.comMIX";NULL;"22";"16";"1.3750"
"315";"petrino.ippolito";"D";"80811759";"8";"6/26/2011 9:18:41 PM";"7";"6/27/2011 2:10:44 AM";"TheHonorSquad.comMIX";NULL;"27";"55";"0.4909"
"451";"pgott87";"D";"83596219";"2";"7/2/2011 1:26:35 AM";"2";"7/2/2011 1:32:35 AM";"TheHonorSquad.comMIX";NULL;"18";"8";"2.2500"
"429";"pHaidOwar";"D";"10881048";"7";"6/27/2011 12:24:55 AM";"7";"6/27/2011 12:28:07 AM";"TheHonorSquad.comMIX";NULL;"3";"5";"0.6000"
"107";"Phantom 2020";"D";"52911364";"29";"6/5/2011 2:50:04 PM";"29";"6/5/2011 2:55:30 PM";"TheHonorSquad.comNUKE";NULL;"17";"18";"0.9444"
"311";"pinu83";"D";"69147877";"8";"6/26/2011 9:07:21 PM";"8";"6/26/2011 9:39:48 PM";"TheHonorSquad.comMIX";NULL;"24";"46";"0.5217"
"104";"pipeeee";"D";"51621715";"29";"6/5/2011 2:44:22 PM";"29";"6/5/2011 2:46:33 PM";"TheHonorSquad.comNUKE";NULL;"0";"5";"0.0000"
"194";"pjwiseman";"D";"73187292";"8";"6/26/2011 5:29:45 PM";"8";"6/26/2011 7:06:26 PM";"TheHonorSquad.comMIX";NULL;"7";"30";"0.2333"
"193";"Politician";"D";"3439083";"8";"6/26/2011 5:29:29 PM";"8";"6/26/2011 5:42:25 PM";"TheHonorSquad.comMIX";NULL;"14";"24";"0.5833"
"33";"popcricri";"D";"82397649";"29";"6/5/2011 6:00:23 AM";"29";"6/5/2011 6:00:23 AM";"TheHonorSquad.comNUKE";NULL;"42";"79";"0.5316"
"101";"Predator";"D";"55397269";"29";"6/5/2011 2:37:43 PM";"29";"6/5/2011 2:44:36 PM";"TheHonorSquad.comNUKE";NULL;"8";"10";"0.8000"
"288";"preston158";"D";"72046713";"8";"6/26/2011 8:27:02 PM";"8";"6/26/2011 8:44:05 PM";"TheHonorSquad.comMIX";NULL;"13";"24";"0.5417"
"46";"Psych0pa7h";"D";"29319474";"29";"6/5/2011 6:49:31 AM";"29";"6/5/2011 6:49:31 AM";"TheHonorSquad.comNUKE";NULL;"10";"5";"2.0000"
"250";"Ptit crisss";"D";"72868617";"8";"6/26/2011 7:08:07 PM";"8";"6/26/2011 7:16:33 PM";"TheHonorSquad.comMIX";NULL;"10";"13";"0.7692"
"114";"Punk";"D";"65223488";"29";"6/5/2011 10:10:34 PM";"29";"6/5/2011 10:12:39 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"166";"Pure Evil";"D";"844548";"11";"6/23/2011 8:03:08 PM";"11";"6/23/2011 8:19:52 PM";"TheHonorSquad.comMIX";NULL;"50";"32";"1.5625"
"211";"pure_lunatic";"D";"64359034";"8";"6/26/2011 5:56:49 PM";"8";"6/26/2011 6:17:57 PM";"TheHonorSquad.comMIX";NULL;"28";"24";"1.1667"
"413";"PUSSY SLAYER :)";"D";"72860085";"8";"6/26/2011 11:47:35 PM";"8";"6/26/2011 11:56:54 PM";"TheHonorSquad.comMIX";NULL;"6";"18";"0.3333"
"382";"Pyro Mecha";"D";"35856968";"8";"6/26/2011 10:48:08 PM";"8";"6/26/2011 11:05:24 PM";"TheHonorSquad.comMIX";NULL;"17";"12";"1.4167"
"326";"QCM*DESTROY";"D";"49462863";"8";"6/26/2011 9:32:28 PM";"8";"6/26/2011 9:37:39 PM";"TheHonorSquad.comMIX";NULL;"0";"8";"0.0000"
"407";"Rapscallion";"D";"55316249";"8";"6/26/2011 11:33:00 PM";"7";"6/27/2011 12:46:56 AM";"TheHonorSquad.comMIX";NULL;"123";"122";"1.0082"
"375";"RatBastard";"D";"82062390";"8";"6/26/2011 10:42:52 PM";"8";"6/26/2011 11:30:26 PM";"TheHonorSquad.comMIX";NULL;"13";"62";"0.2097"
"44";"redheadkickster";"D";"82460042";"29";"6/5/2011 6:36:16 AM";"29";"6/5/2011 6:37:37 AM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"60";"Remark`";"D";"70721041";"29";"6/5/2011 1:06:18 PM";"29";"6/5/2011 1:31:48 PM";"TheHonorSquad.comNUKE";NULL;"48";"61";"0.7869"
"386";"Renegate [AUT]";"D";"52631468";"8";"6/26/2011 11:01:40 PM";"8";"6/26/2011 11:40:22 PM";"TheHonorSquad.comMIX";NULL;"49";"41";"1.1951"
"322";"Reversion";"D";"72434407";"8";"6/26/2011 9:30:42 PM";"8";"6/26/2011 10:25:33 PM";"TheHonorSquad.comMIX";NULL;"44";"79";"0.5570"
"289";"rhrmd";"D";"35176938";"8";"6/26/2011 8:33:50 PM";"8";"6/26/2011 8:44:09 PM";"TheHonorSquad.comMIX";NULL;"0";"17";"0.0000"
"201";"RichrdSimns";"D";"33689807";"8";"6/26/2011 5:44:47 PM";"8";"6/26/2011 5:59:49 PM";"TheHonorSquad.comMIX";NULL;"6";"19";"0.3158"
"431";"rivet`";"D";"14768373";"7";"6/27/2011 12:35:05 AM";"7";"6/27/2011 1:04:47 AM";"TheHonorSquad.comMIX";NULL;"68";"30";"2.2667"
"362";"Robert Burtch";"D";"22685711";"8";"6/26/2011 10:26:20 PM";"8";"6/26/2011 10:44:13 PM";"TheHonorSquad.comMIX";NULL;"14";"32";"0.4375"
"453";"Robie";"D";"42656619";"2";"7/2/2011 1:36:28 AM";"2";"7/2/2011 1:44:05 AM";"TheHonorSquad.comMIX";NULL;"12";"10";"1.2000"
"152";"rocketnubetube";"D";"62488712";"11";"6/23/2011 7:51:53 PM";"11";"6/23/2011 7:55:31 PM";"TheHonorSquad.comMIX";NULL;"4";"4";"1.0000"
"294";"RockstarS";"D";"80875750";"8";"6/26/2011 8:37:06 PM";"8";"6/26/2011 8:48:39 PM";"TheHonorSquad.comMIX";NULL;"42";"8";"5.2500"
"110";"roetter41";"D";"78721805";"29";"6/5/2011 3:12:29 PM";"29";"6/5/2011 3:13:40 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"12";"rogerl";"D";"79544755";"30";"6/4/2011 10:14:20 PM";"30";"6/4/2011 10:29:31 PM";"TheHonorSquad.comNUKE";NULL;"22";"39";"0.5641"
"430";"ronnieblah";"D";"82148035";"7";"6/27/2011 12:29:02 AM";"7";"6/27/2011 12:47:49 AM";"TheHonorSquad.comMIX";NULL;"32";"31";"1.0323"
"380";"Ron_Burgandy";"D";"15462260";"8";"6/26/2011 10:46:45 PM";"8";"6/26/2011 11:18:28 PM";"TheHonorSquad.comMIX";NULL;"49";"44";"1.1136"
"38";"rrooon";"D";"57014486";"29";"6/5/2011 6:12:36 AM";"29";"6/5/2011 6:13:29 AM";"TheHonorSquad.comNUKE";NULL;"1";"1";"1.0000"
"398";"Runn";"D";"30721996";"8";"6/26/2011 11:23:23 PM";"8";"6/26/2011 11:29:57 PM";"TheHonorSquad.comMIX";NULL;"14";"14";"1.0000"
"180";"ryustrife";"D";"40052506";"11";"6/23/2011 8:19:01 PM";"11";"6/23/2011 8:19:01 PM";"TheHonorSquad.comMIX";NULL;"10";"6";"1.6667"
"198";"s3v3n";"D";"74444919";"8";"6/26/2011 5:42:21 PM";"8";"6/26/2011 5:57:55 PM";"TheHonorSquad.comMIX";NULL;"20";"17";"1.1765"
"129";"SadisticPickle";"D";"55895475";"22";"6/12/2011 8:36:48 PM";"22";"6/12/2011 9:03:37 PM";"TheHonorSquad.comNUKE";NULL;"21";"51";"0.4118"
"323";"salut_bob69";"D";"21972173";"8";"6/26/2011 9:30:50 PM";"8";"6/26/2011 10:03:48 PM";"TheHonorSquad.comMIX";NULL;"34";"48";"0.7083"
"214";"SAma'EL";"D";"52088642";"8";"6/26/2011 6:02:29 PM";"8";"6/26/2011 6:08:24 PM";"TheHonorSquad.comMIX";NULL;"3";"7";"0.4286"
"414";"Sambo1986";"D";"83838791";"8";"6/26/2011 11:47:43 PM";"8";"6/26/2011 11:54:23 PM";"TheHonorSquad.comMIX";NULL;"3";"16";"0.1875"
"111";"Secris";"D";"65963431";"29";"6/5/2011 6:47:49 PM";"29";"6/5/2011 6:48:40 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"116";"sergeymaximum";"D";"73629975";"29";"6/5/2011 10:14:21 PM";"29";"6/5/2011 10:30:25 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"113";"Serj494";"D";"59081973";"29";"6/5/2011 10:09:38 PM";"29";"6/5/2011 10:34:04 PM";"TheHonorSquad.comNUKE";NULL;"5";"1";"5.0000"
"447";"Seven";"D";"53446656";"2";"7/2/2011 12:59:13 AM";"2";"7/2/2011 1:06:46 AM";"TheHonorSquad.comMIX";NULL;"6";"9";"0.6667"
"153";"Sgt. G.";"D";"7549954";"11";"6/23/2011 7:52:50 PM";"11";"6/23/2011 7:52:50 PM";"TheHonorSquad.comMIX";NULL;"33";"52";"0.6346"
"426";"SgtSadanko";"D";"58777099";"7";"6/27/2011 12:16:00 AM";"7";"6/27/2011 12:33:22 AM";"TheHonorSquad.comMIX";NULL;"15";"31";"0.4839"
"246";"ShadowlessFigure";"D";"59039447";"8";"6/26/2011 7:06:35 PM";"8";"6/26/2011 7:07:55 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"338";"Shadow_FLUX";"D";"23132733";"8";"6/26/2011 9:57:17 PM";"8";"6/26/2011 10:05:15 PM";"TheHonorSquad.comMIX";NULL;"9";"10";"0.9000"
"253";"Shalbane";"D";"24185207";"8";"6/26/2011 7:09:24 PM";"8";"6/26/2011 7:10:09 PM";"TheHonorSquad.comMIX";NULL;"0";"1";"0.0000"
"142";"Shay";"D";"74252229";"22";"6/12/2011 10:09:01 PM";"22";"6/12/2011 10:15:18 PM";"TheHonorSquad.comNUKE";NULL;"2";"13";"0.1538"
"291";"shogo.ca";"D";"944973";"8";"6/26/2011 8:34:47 PM";"8";"6/26/2011 9:16:01 PM";"TheHonorSquad.comMIX";NULL;"122";"64";"1.9063"
"342";"Shunt";"D";"75943904";"8";"6/26/2011 10:00:17 PM";"8";"6/26/2011 10:30:45 PM";"TheHonorSquad.comMIX";NULL;"68";"67";"1.0149"
"410";"Singularity";"D";"47828727";"8";"6/26/2011 11:42:41 PM";"8";"6/26/2011 11:51:00 PM";"TheHonorSquad.comMIX";NULL;"11";"14";"0.7857"
"22";"Sk0mMyLagg<8";"D";"80241735";"29";"6/5/2011 5:26:11 AM";"29";"6/5/2011 5:31:44 AM";"TheHonorSquad.comNUKE";NULL;"13";"17";"0.7647"
"445";"Skaly";"D";"10302253";"2";"7/2/2011 12:53:48 AM";"2";"7/2/2011 12:57:17 AM";"TheHonorSquad.comMIX";NULL;"0";"3";"0.0000"
"424";"Slurm Mckensie";"D";"30623573";"7";"6/27/2011 12:11:09 AM";"7";"6/27/2011 12:33:20 AM";"TheHonorSquad.comMIX";NULL;"33";"30";"1.1000"
"73";"snowsurfer";"D";"22346537";"29";"6/5/2011 1:40:11 PM";"29";"6/5/2011 2:24:14 PM";"TheHonorSquad.comNUKE";NULL;"68";"126";"0.5397"
"108";"Solarhard";"D";"77477529";"29";"6/5/2011 2:56:43 PM";"29";"6/5/2011 9:47:35 PM";"TheHonorSquad.comNUKE";NULL;"13";"12";"1.0833"
"122";"SonicDeath";"D";"77777027";"22";"6/12/2011 8:16:58 PM";"7";"6/27/2011 12:47:43 AM";"TheHonorSquad.comMIX";NULL;"274";"355";"0.7718"
"2";"Spector";"Honor Squad Member";"34728278";"30";"6/4/2011 9:17:05 PM";"8";"6/26/2011 8:22:00 PM";"TheHonorSquad.comMIX";NULL;"1191";"887";"1.3427"
"260";"SplinterCat";"D";"33005293";"8";"6/26/2011 7:31:20 PM";"8";"6/26/2011 7:51:10 PM";"TheHonorSquad.comMIX";NULL;"13";"41";"0.3171"
"175";"srtstig";"D";"53581088";"11";"6/23/2011 8:16:32 PM";"11";"6/23/2011 8:23:36 PM";"TheHonorSquad.comMIX";NULL;"8";"14";"0.5714"
"373";"St!ng ///";"D";"57284169";"8";"6/26/2011 10:39:50 PM";"8";"6/26/2011 10:41:34 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"4";"Stangratch";"Honor Squad Member";"29705014";"30";"6/4/2011 9:32:52 PM";"8";"6/26/2011 8:00:12 PM";"TheHonorSquad.comMIX";NULL;"536";"422";"1.2701"
"131";"Stealth";"D";"76032593";"22";"6/12/2011 8:45:58 PM";"22";"6/12/2011 8:51:54 PM";"TheHonorSquad.comNUKE";NULL;"9";"3";"3.0000"
"335";"StillBorn|Fx";"D";"62239089";"8";"6/26/2011 9:47:19 PM";"8";"6/26/2011 9:56:32 PM";"TheHonorSquad.comMIX";NULL;"3";"16";"0.1875"
"238";"StonedQc";"D";"55320285";"8";"6/26/2011 6:54:46 PM";"8";"6/26/2011 7:07:00 PM";"TheHonorSquad.comMIX";NULL;"21";"15";"1.4000"
"304";"StoryofMyLife";"D";"66432475";"8";"6/26/2011 8:58:21 PM";"8";"6/26/2011 9:06:42 PM";"TheHonorSquad.comMIX";NULL;"16";"12";"1.3333"
"287";"Straydogg";"D";"55402974";"8";"6/26/2011 8:24:59 PM";"8";"6/26/2011 8:29:37 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"428";"sukit}BigToe";"D";"15719521";"7";"6/27/2011 12:23:08 AM";"7";"6/27/2011 1:04:14 AM";"TheHonorSquad.comMIX";NULL;"57";"50";"1.1400"
"51";"superlisko";"D";"38873930";"29";"6/5/2011 7:01:57 AM";"29";"6/5/2011 7:01:57 AM";"TheHonorSquad.comNUKE";NULL;"2";"0";NULL
"383";"Surgeon General";"D";"13873769";"8";"6/26/2011 10:51:09 PM";"8";"6/26/2011 10:51:40 PM";"TheHonorSquad.comMIX";NULL;"0";"1";"0.0000"
"363";"Surly";"D";"16961184";"8";"6/26/2011 10:27:59 PM";"8";"6/26/2011 10:35:19 PM";"TheHonorSquad.comMIX";NULL;"5";"17";"0.2941"
"329";"TBS)-Vac Banne";"D";"54529329";"8";"6/26/2011 9:38:20 PM";"8";"6/26/2011 9:57:11 PM";"TheHonorSquad.comMIX";NULL;"48";"16";"3.0000"
"61";"TECKNOXX";"D";"11787748";"29";"6/5/2011 1:13:30 PM";"29";"6/5/2011 2:28:27 PM";"TheHonorSquad.comNUKE";NULL;"130";"89";"1.4607"
"134";"TFR[]Seb";"D";"53794072";"22";"6/12/2011 8:54:53 PM";"22";"6/12/2011 9:18:58 PM";"TheHonorSquad.comNUKE";NULL;"28";"32";"0.8750"
"308";"That Guy";"D";"34803126";"8";"6/26/2011 8:59:18 PM";"8";"6/26/2011 9:18:08 PM";"TheHonorSquad.comMIX";NULL;"40";"25";"1.6000"
"349";"The Majestical N";"D";"66334930";"8";"6/26/2011 10:04:52 PM";"8";"6/26/2011 10:13:17 PM";"TheHonorSquad.comMIX";NULL;"5";"9";"0.5556"
"13";"TheDeadBread";"D";"55519050";"30";"6/4/2011 10:22:46 PM";"30";"6/4/2011 10:24:16 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"176";"TheWhiteMongoose";"D";"73109924";"11";"6/23/2011 8:16:32 PM";"11";"6/23/2011 8:16:32 PM";"TheHonorSquad.comMIX";NULL;"18";"19";"0.9474"
"26";"TheWhiteWolf";"D";"3931587";"29";"6/5/2011 5:42:58 AM";"29";"6/5/2011 6:21:44 AM";"TheHonorSquad.comNUKE";NULL;"145";"50";"2.9000"
"346";"TheWoodsman";"D";"55356315";"8";"6/26/2011 10:03:04 PM";"8";"6/26/2011 10:34:55 PM";"TheHonorSquad.comMIX";NULL;"19";"27";"0.7037"
"405";"Tiger-bot Hesh";"D";"166591";"8";"6/26/2011 11:32:36 PM";"7";"6/27/2011 12:13:23 AM";"TheHonorSquad.comMIX";NULL;"41";"59";"0.6949"
"28";"TNT]Chudson";"D";"74264052";"29";"6/5/2011 5:47:28 AM";"29";"6/5/2011 6:14:24 AM";"TheHonorSquad.comNUKE";NULL;"164";"125";"1.3120"
"452";"ToNic#BlackLolli";"D";"80778055";"2";"7/2/2011 1:36:28 AM";"2";"7/2/2011 1:44:11 AM";"TheHonorSquad.comMIX";NULL;"5";"12";"0.4167"
"8";"Torres25x*";"D";"55899079";"30";"6/4/2011 9:58:53 PM";"30";"6/4/2011 10:04:52 PM";"TheHonorSquad.comNUKE";NULL;"26";"14";"1.8571"
"395";"TPB]KuRONO ☯";"D";"45749030";"8";"6/26/2011 11:18:12 PM";"7";"6/27/2011 12:00:22 AM";"TheHonorSquad.comMIX";NULL;"32";"62";"0.5161"
"19";"Trippin";"D";"60352808";"29";"6/5/2011 5:08:13 AM";"29";"6/5/2011 5:14:54 AM";"TheHonorSquad.comNUKE";NULL;"3";"9";"0.3333"
"1";"Tunnleram";"Server Admin";"9479627";"30";"6/4/2011 9:16:00 PM";"2";"7/2/2011 2:15:46 AM";"TheHonorSquad.comMIX";NULL;"1530";"1396";"1.0960"
"244";"Turd~Blossom";"D";"80473317";"8";"6/26/2011 6:59:13 PM";"2";"7/2/2011 2:04:45 AM";"TheHonorSquad.comMIX";NULL;"77";"123";"0.6260"
"263";"Turn1p";"D";"14073283";"8";"6/26/2011 7:37:15 PM";"8";"6/26/2011 7:39:59 PM";"TheHonorSquad.comMIX";NULL;"4";"5";"0.8000"
"356";"Turtle";"D";"6555158";"8";"6/26/2011 10:14:31 PM";"8";"6/26/2011 10:23:36 PM";"TheHonorSquad.comMIX";NULL;"10";"9";"1.1111"
"227";"TweaK";"D";"19386369";"8";"6/26/2011 6:35:42 PM";"8";"6/26/2011 8:23:56 PM";"TheHonorSquad.comMIX";NULL;"170";"200";"0.8500"
"144";"Twi$ter";"D";"74033669";"19";"6/15/2011 11:13:18 AM";"19";"6/15/2011 11:15:06 AM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"55";"TwoEmptyHands";"D";"75292048";"29";"6/5/2011 12:44:02 PM";"29";"6/5/2011 1:05:34 PM";"TheHonorSquad.comNUKE";NULL;"37";"48";"0.7708"
"270";"UaFO - BACKDOOR";"D";"72894892";"8";"6/26/2011 8:05:02 PM";"8";"6/26/2011 8:55:42 PM";"TheHonorSquad.comMIX";NULL;"64";"81";"0.7901"
"269";"UaFO-JAG302";"D";"20305054";"8";"6/26/2011 7:58:50 PM";"8";"6/26/2011 8:55:16 PM";"TheHonorSquad.comMIX";NULL;"128";"104";"1.2308"
"279";"UAFO-Lunchmeat";"D";"74612095";"8";"6/26/2011 8:22:16 PM";"8";"6/26/2011 8:55:40 PM";"TheHonorSquad.comMIX";NULL;"80";"53";"1.5094"
"384";"UFO)Doberman";"D";"55320145";"8";"6/26/2011 10:54:20 PM";"8";"6/26/2011 11:30:16 PM";"TheHonorSquad.comMIX";NULL;"61";"64";"0.9531"
"179";"uG.duckdown";"D";"11248788";"11";"6/23/2011 8:18:11 PM";"11";"6/23/2011 8:18:11 PM";"TheHonorSquad.comMIX";NULL;"28";"6";"4.6667"
"316";"Ularg";"D";"34988394";"8";"6/26/2011 9:19:13 PM";"8";"6/26/2011 11:58:50 PM";"TheHonorSquad.comMIX";NULL;"79";"50";"1.5800"
"409";"ultramegaman963";"D";"74013434";"8";"6/26/2011 11:38:39 PM";"8";"6/26/2011 11:51:00 PM";"TheHonorSquad.comMIX";NULL;"16";"24";"0.6667"
"391";"Umad Bro";"D";"75758788";"8";"6/26/2011 11:12:10 PM";"8";"6/26/2011 11:24:01 PM";"TheHonorSquad.comMIX";NULL;"6";"21";"0.2857"
"212";"Umd78";"D";"51464615";"8";"6/26/2011 5:59:36 PM";"8";"6/26/2011 6:36:34 PM";"TheHonorSquad.comMIX";NULL;"58";"72";"0.8056"
"65";"UnasNalgas :Q";"D";"67495365";"29";"6/5/2011 1:23:26 PM";"29";"6/5/2011 1:29:11 PM";"TheHonorSquad.comNUKE";NULL;"4";"18";"0.2222"
"331";"UnderFire Yeah";"D";"19742958";"8";"6/26/2011 9:44:44 PM";"8";"6/26/2011 10:15:06 PM";"TheHonorSquad.comMIX";NULL;"53";"45";"1.1778"
"251";"Unfillable";"D";"80454224";"8";"6/26/2011 7:09:24 PM";"8";"6/26/2011 8:55:12 PM";"TheHonorSquad.comMIX";NULL;"105";"155";"0.6774"
"80";"UnholyCleric";"D";"82535548";"29";"6/5/2011 1:51:02 PM";"29";"6/5/2011 1:57:12 PM";"TheHonorSquad.comNUKE";NULL;"6";"16";"0.3750"
"376";"unimatrixzer0";"D";"8667757";"8";"6/26/2011 10:44:56 PM";"8";"6/26/2011 11:18:26 PM";"TheHonorSquad.comMIX";NULL;"13";"60";"0.2167"
"56";"Valkyr1e";"D";"46175941";"29";"6/5/2011 12:45:16 PM";"29";"6/5/2011 12:53:17 PM";"TheHonorSquad.comNUKE";NULL;"18";"19";"0.9474"
"242";"Vampiiric";"D";"56048700";"8";"6/26/2011 6:58:40 PM";"8";"6/26/2011 7:07:08 PM";"TheHonorSquad.comMIX";NULL;"4";"8";"0.5000"
"285";"Vestfold)jaktti";"D";"40110903";"8";"6/26/2011 8:24:02 PM";"8";"6/26/2011 8:32:57 PM";"TheHonorSquad.comMIX";NULL;"4";"23";"0.1739"
"241";"VG:.Z3RO";"D";"44362538";"8";"6/26/2011 6:58:23 PM";"8";"6/26/2011 7:06:26 PM";"TheHonorSquad.comMIX";NULL;"16";"9";"1.7778"
"381";"vgbpc06";"D";"72800735";"8";"6/26/2011 10:47:51 PM";"8";"6/26/2011 10:53:44 PM";"TheHonorSquad.comMIX";NULL;"1";"7";"0.1429"
"10";"Vice";"D";"80434965";"30";"6/4/2011 10:06:37 PM";"30";"6/4/2011 10:31:00 PM";"TheHonorSquad.comNUKE";NULL;"29";"43";"0.6744"
"236";"Vojnik";"D";"56936237";"8";"6/26/2011 6:50:04 PM";"8";"6/26/2011 6:53:54 PM";"TheHonorSquad.comMIX";NULL;"1";"4";"0.2500"
"48";"vvitalik87";"D";"39477950";"29";"6/5/2011 6:54:49 AM";"29";"6/5/2011 6:54:49 AM";"TheHonorSquad.comNUKE";NULL;"1";"7";"0.1429"
"53";"W@nTeD^kIlLeR";"D";"75580197";"29";"6/5/2011 12:26:03 PM";"29";"6/5/2011 12:44:15 PM";"TheHonorSquad.comNUKE";NULL;"0";"6";"0.0000"
"318";"wakeby";"D";"72982840";"8";"6/26/2011 9:19:46 PM";"8";"6/26/2011 9:46:51 PM";"TheHonorSquad.comMIX";NULL;"33";"31";"1.0645"
"305";"WALKING DEAD";"D";"74203435";"8";"6/26/2011 8:58:45 PM";"8";"6/26/2011 9:29:43 PM";"TheHonorSquad.comMIX";NULL;"3";"35";"0.0857"
"262";"wfs228";"D";"62102082";"8";"6/26/2011 7:36:50 PM";"8";"6/26/2011 7:47:16 PM";"TheHonorSquad.comMIX";NULL;"3";"13";"0.2308"
"124";"Whiskeyfox";"D";"60786877";"22";"6/12/2011 8:19:16 PM";"22";"6/12/2011 8:25:04 PM";"TheHonorSquad.comNUKE";NULL;"5";"1";"5.0000"
"158";"WhiteTuna";"D";"78377542";"11";"6/23/2011 7:54:36 PM";"11";"6/23/2011 8:08:06 PM";"TheHonorSquad.comMIX";NULL;"17";"21";"0.8095"
"267";"white_arckon";"D";"12503941";"8";"6/26/2011 7:51:40 PM";"8";"6/26/2011 8:06:57 PM";"TheHonorSquad.comMIX";NULL;"16";"23";"0.6957"
"302";"Wiley C";"D";"55916870";"8";"6/26/2011 8:57:56 PM";"8";"6/26/2011 9:18:12 PM";"TheHonorSquad.comMIX";NULL;"11";"24";"0.4583"
"220";"wilkiam";"D";"73008565";"8";"6/26/2011 6:19:54 PM";"8";"6/26/2011 6:23:59 PM";"TheHonorSquad.comMIX";NULL;"1";"5";"0.2000"
"29";"Witcher PL";"D";"76872535";"29";"6/5/2011 5:47:28 AM";"29";"6/5/2011 6:49:31 AM";"TheHonorSquad.comNUKE";NULL;"160";"127";"1.2598"
"374";"Xenris|-";"D";"17098112";"8";"6/26/2011 10:40:15 PM";"8";"6/26/2011 11:39:47 PM";"TheHonorSquad.comMIX";NULL;"207";"60";"3.4500"
"58";"Xfinity";"D";"3927819";"29";"6/5/2011 1:02:30 PM";"29";"6/5/2011 1:04:55 PM";"TheHonorSquad.comNUKE";NULL;"4";"3";"1.3333"
"50";"Xt@sY!!!";"D";"50113093";"29";"6/5/2011 7:01:57 AM";"29";"6/5/2011 7:01:57 AM";"TheHonorSquad.comNUKE";NULL;"0";"1";"0.0000"
"159";"XxDaRk_VoIcExX";"D";"78774606";"11";"6/23/2011 7:54:36 PM";"11";"6/23/2011 8:16:05 PM";"TheHonorSquad.comMIX";NULL;"49";"21";"2.3333"
"173";"xz3pt";"D";"36966351";"11";"6/23/2011 8:15:08 PM";"11";"6/23/2011 8:22:08 PM";"TheHonorSquad.comMIX";NULL;"4";"17";"0.2353"
"117";"X]:. Martin";"D";"59042519";"29";"6/5/2011 10:27:12 PM";"29";"6/5/2011 10:27:41 PM";"TheHonorSquad.comNUKE";NULL;"0";"0";NULL
"434";"Yetti";"D";"11177662";"7";"6/27/2011 12:49:33 AM";"7";"6/27/2011 1:03:42 AM";"TheHonorSquad.comMIX";NULL;"14";"12";"1.1667"
"186";"yosonfio";"D";"12249955";"11";"6/23/2011 8:24:14 PM";"11";"6/23/2011 8:24:35 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"341";"You're";"D";"55380720";"8";"6/26/2011 9:59:52 PM";"8";"6/26/2011 10:06:17 PM";"TheHonorSquad.comMIX";NULL;"0";"0";NULL
"266";"your mom";"D";"44477114";"8";"6/26/2011 7:48:55 PM";"7";"6/27/2011 1:03:44 AM";"TheHonorSquad.comMIX";NULL;"100";"154";"0.6494"
"230";"ZeDoPeixe";"D";"63929935";"8";"6/26/2011 6:37:22 PM";"8";"6/26/2011 6:43:28 PM";"TheHonorSquad.comMIX";NULL;"2";"16";"0.1250"
"440";"zeh goop stains";"D";"81318657";"3";"7/1/2011 11:50:39 PM";"2";"7/2/2011 12:05:09 AM";"TheHonorSquad.comMIX";NULL;"14";"23";"0.6087"
"125";"Zi'Tah]Soul";"D";"32789652";"22";"6/12/2011 8:26:20 PM";"22";"6/12/2011 8:45:17 PM";"TheHonorSquad.comNUKE";NULL;"20";"18";"1.1111"
"197";"ZIPPtango";"D";"27519411";"8";"6/26/2011 5:36:48 PM";"8";"6/26/2011 6:44:24 PM";"TheHonorSquad.comMIX";NULL;"115";"92";"1.2500"
"337";"ZTS|Grelsto";"D";"28663862";"8";"6/26/2011 9:50:44 PM";"8";"6/26/2011 10:54:24 PM";"TheHonorSquad.comMIX";NULL;"114";"46";"2.4783"
"298";"ZzxXJJoSxXzZ";"D";"64132145";"8";"6/26/2011 8:46:22 PM";"8";"6/26/2011 9:07:11 PM";"TheHonorSquad.comMIX";NULL;"19";"27";"0.7037"
"6";"Zzyzx";"D";"58875156";"30";"6/4/2011 9:53:15 PM";"30";"6/4/2011 10:04:54 PM";"TheHonorSquad.comNUKE";NULL;"20";"38";"0.5263"

Edited by smantscheff: n/a

0

Sorry if I seem dense, I really appreciate your help, but I seem to be missing something because I don't fully understand.

You said:

...where you had "NULL" strings the query works.

I have NULL strings for Kills and/or Deaths?
What fields are you talking about?
How can there be NULL strings for Kills and/or Deaths? They are int fields.

I see only Italic NULLS for Kills and/or Deaths. In fact those are the only NULLS I see for the entire table in any place where there is a NULL.

0

Maybe you should post a fresh set of test data.
You're right, there can be no "NULL" strings in Kills/Deaths.
As you see in my previous post, your query does retrieve results. Are they the expected ones?
In your CASE structure

CASE
	WHEN ( bt.Kills IS NULL AND bt.Deaths IS NOT NULL ) THEN bt.Deaths
	WHEN ( bt.Kills IS NOT NULL AND bt.Deaths IS NULL ) THEN bt.Kills
	WHEN ( bt.Kills IS NULL AND bt.Deaths IS NULL ) THEN '0.00'
	WHEN ( bt.Kills IS NOT NULL AND bt.Deaths IS NOT NULL ) THEN bt.Kills/bt.Deaths
	END AS KDR

the last case might lead to a division by zero.

Edited by smantscheff: n/a

0

Ugh, I did the dumbest thing. I had KDR defined in the case, but I forgot to define it was a variable so $KDR was never set to the result. I didn't post that part of the code which I should have. Note to self for next time to post everything.

I can't believe I overlooked that! /shakes head

Thanks for all your help.

0

Try this

isnull(
        case bt.Kills
            when 'value1' then '1'
            when 'value2' then '2'
        end, '0')
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.