Sound on PM

[NYI Fan]

Znaper -
Thanks for the help - this was great!
quick question though... you said we should replace the original line with this:

$newpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$bbuserinfo[userid] AND dateline>$bbuserinfo[lastvisit] AND messageread=0 AND folderid=0");

Shouldn't it be: (my change in red)

$newpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$bbuserinfo[userid] AND dateline>$bbuserinfo[lastvisit] AND messageread=0 AND folderid=0") $ignoreusers;

I couldn't get mine to work until I did it that way
Thanks again!

[butty]

great work!!! thanks

[NYI Fan]

OK
I had this working beautifully on 2.0.3

now in 2.2.0, when i try and edit the index.php for this:

PHP Code:

if ($newpm['messages']==0) {
    $pmsound = "";
    $lightbulb='off';
  } else {
    $pmsound = "<bgsound src= c:\windows\media\"gotmail.wav\" border=0>";    
    $lightbulb='on';
  } 


and ensure that $pmsound is present in forumhome

I still have no sound

and if i make the change

PHP Code:

$newpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$bbuserinfo[userid] AND dateline>$bbuserinfo[lastvisit] AND messageread=0 AND folderid=0"); 


as suggested, i get errors on line 24 of index.php

anyone have any ideas???