Need pm by code for lavalair

[arman]

hi,anybody can help me by give pm by code for lavalair?thanks

[riderz]

give more info bout the script i think its already posted here

[arman]

i see many posts but can't find it.pm by code like we don't need to go inbox when anyone pm me,in index page it will see pm by :user name.if i click on it i will go the pm directly.

[riderz]

$umsg = getunreadpm(getuid_sid($sid));
$item = mysql_fetch_array(mysql_query("SELECT
            a.name, b.id FROM ibwf_users a
            INNER JOIN ibwf_private b ON a.id = b.byuid
            WHERE b.touid='".$uid."' AND b.unread='1'
            ORDER BY b.timesent DESC
            LIMIT 1"));

  if($umsg>0)
  {
  echo "You have got <a href=\"inbox.php?action=main&amp;sid=$sid\">$umsg</a> PM<br/>";
echo "Last PM by <a href=\"inbox.php?action=readpm&amp;pmid=$item[1]&amp;sid=$sid\">$item[0]</a><br/>";

  }

[arman]

thanks .can u plz give the unread pm by you code in lava?i find one code in posts but it n't working

[rukiya]

$umsg = getunreadpm(getuid_sid($sid));
$rukiya= mysql_query("SELECT
            a.name, b.id FROM ibwf_users a
            INNER JOIN ibwf_private b ON a.id = b.byuid
            WHERE b.touid=$uid AND b.unread=1
            ORDER BY b.timesent DESC");

  if($umsg>0)
  {
echo "You have got <a href=\"inbox.php?action=main&amp;sid=$sid\">$umsg</a> unread PMs<br/>";
while ($item = mysql_fetch_row($rukiya))
{ 
echo "<a href=\"inbox.php?action=readpm&amp;pmid=$item[1]&amp;sid=$sid\">$item[0]</a><br/>";
}
  }