SQL query to count unread PMs?

[NetFXMedia]

I'm wondering if anyone has written a SQL query/PHP function to grab the number of unread PMs based on nickname/userid?

Looking to display this information outside of the vb template environment.

Any help?

[nico_swd]

Here a quick function I wrote.

function get_unread_pms($userid)
{
global $db;

$pms = $db->query_first("
SELECT COUNT(*) AS total
FROM ". TABLE_PREFIX ."pm
WHERE userid = ". intval($userid) ."
AND messageread = 0
");

return $pms['total'];
}


Usage example

$userid = 8;
echo get_unread_pms($userid);

[Paul M]

It's stored in the user table ;

SELECT pmunread FROM user WHERE userid = 123

[nico_swd]

Lol, dammit. :(

[vietkieu_cz]

do you know how to select thread titles with letter beginning exam: A ???

[Paul M]

Use LIKE 'A%'

[vietkieu_cz]

thank you administrator Paul :)