How to count differents IPs in sessions?

[luroca]

Hello, with this:

$maxtime = TIMENOW - $vbulletin->options['cookietimeout'];
$login = $vbulletin->db->query_first("
SELECT count(*) as number, host as host
FROM " . TABLE_PREFIX . "session
WHERE lastactivity >= $maxtime
AND userid = " . $vbulletin->userinfo[userid] . " GROUP BY number");

I get a number of IPs ($login['host']) for one userid but some of them are the same, repeated, I need to get the different IPs, not repeated.

Can anyone help me?

Thanks a lot

Myself

$maxtime = TIMENOW - $vbulletin->options['cookietimeout'];
$login = $vbulletin->db->query_first("
SELECT count(DISTINTC host) as host
FROM " . TABLE_PREFIX . "session
WHERE lastactivity >= $maxtime
AND userid = " . $vbulletin->userinfo[userid] . "");

I love Google.