SELECT DISTINCT( ip ),port from mslog;

SELECT Count(DISTINCT( ip ),port) from mslog;

CREATE TABLE IF NOT EXISTS `mslog` (
`id` int(10) unsigned NOT NULL DEFAULT AUTO_INCREMENT,
`ip` int(10) unsigned NOT NULL DEFAULT '0',
`port` smallint(5) unsigned NOT NULL DEFAULT '27015',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0'
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

SELECT COUNT(DISTINCT ( ip ) ) AS `ip`,port
FROM `mslog`
WHERE timeyear = $m2 and timemonth = $m and timeday = $m3 and timehour = $i and type = 'cs'";