sql call to retrieve PM's in IB

Nuke Cadet Joined: May 05, 2003 Posts: 5

I'm using the pd2003 pro theme which displays how many new Private Messages you have in the header after you login. However, I am using IB forums now, and would like to set it up to display how many IB new messages I have. I know there's a way but I don't know php&sql enough to do it.

Here's the code for a nuke-block that displays what I want:

Code:

global $cookie, $db;
$pmname = $cookie[1];

// Edit if required
$forumdir = "module/Forum"; // Path from phpNuke root directory to forums directory.
$ibf = "ibf_"; // Invision tables prefix
$text1 ="You have";
$text2 ="new";
$text3 ="private message(s)";

$sql_pm = $db->sql_query("SELECT * FROM ".$ibf."_members WHERE name='$pmname'") or print sql_error();
$pm = sql_fetch_array($sql_pm);
$content = "$pmname, <center>$text1 $pm[new_msg] $text2 <a href='$forumdir/index.php?s=&act=Msg&CODE=01'>$text3</a>.";

And here is the code for my current Private Messages in theme.php:

Code:

if (is_active("Private_Messages")) {
 $sql = "SELECT user_id FROM ".$user_prefix."_users WHERE username='$uname'";
 $result = $db->sql_query($sql);
 $row = $db->sql_fetchrow($result);
 $uid = $row[user_id];
 $numrow = $db->sql_numrows($db->sql_query("SELECT privmsgs_to_userid FROM ".$prefix."_bbprivmsgs WHERE privmsgs_to_userid='$uid' AND (privmsgs_type='1' OR privmsgs_type='5' OR privmsgs_type='0')"));
 $newpm = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_bbprivmsgs WHERE privmsgs_to_userid='$uid' AND (privmsgs_type='5' OR privmsgs_type='1')"));

 if ($newpm > 0) {
 echo "<img border=\"0\" src=\"themes/pd2003/images/pmail.gif\" align=\"absmiddle\" width=\"21\" height=\"17\">";
 }
 echo ""._YOUHAVE." <a href=\"modules/Forum/index.php?s=3fa89bfa4cd223f204c362d6eca08b5f&act=Msg&CODE=01\">$newpm "._PRIVATEMSG."</a>&&&&&&&&&&&&<a href=\"modules.php?name=Your_Account&op=logout\">[Logout]</a>";
 }

Nuke Cadet Joined: May 05, 2003 Posts: 5

I fixed this by myself awhile ago. If anybody wants the code send me an email.