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.

PHP Code:

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

PHP Code:

$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